enrollments

Data source: Big Local News · About: Big Local

629,755 rows where state = "NY" sorted by school_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id ▲ school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
835468 835468 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_1 47.0 1.0 0.0   0.0     0.0     0.0   27.0 21.0             30     10   48 47 1 0   0     0     0   27 21         30   10   48
835469 835469 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_10 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
835470 835470 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_11 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
835471 835471 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_12 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
835472 835472 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_2 48.0 1.0 2.0   0.0     0.0     0.0   27.0 24.0             33     10   51 48 1 2   0     0     0   27 24         33   10   51
835473 835473 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_3 31.0 0.0 1.0   1.0     0.0     0.0   21.0 12.0             *     6   33 31 0 1   1     0     0   21 12             6   33
835474 835474 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_4 51.0 0.0 1.0   0.0     0.0     0.0   31.0 21.0             40     10   52 51 0 1   0     0     0   31 21         40   10   52
835475 835475 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_5 41.0 1.0 0.0   0.0     1.0     0.0   17.0 26.0             26     6   43 41 1 0   0     1     0   17 26         26   6   43
835476 835476 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_6 53.0 1.0 2.0   0.0     0.0     0.0   28.0 28.0             40     13   56 53 1 2   0     0     0   28 28         40   13   56
835477 835477 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
835478 835478 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
835479 835479 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
835480 835480 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   kindergarten_full_day 68.0 1.0 0.0   0.0     0.0     0.0   44.0 25.0             50     16   69 68 1 0   0     0     0   44 25         50   16   69
835481 835481 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
835482 835482 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   pk_12_total 374.0 5.0 7.0   1.0     1.0     2.0   216.0 174.0             261     83   390 374 5 7   1     1     2   216 174         261   83   390
835483 835483 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   pre_kindergarten_full_day 26.0 0.0 1.0   0.0     0.0     2.0   15.0 14.0             20     *   29 26 0 1   0     0     2   15 14         20       29
835484 835484 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   pre_kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
835485 835485 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   ungraded_elementary 4.0 0.0 0.0   0.0     0.0     0.0   3.0 1.0             0     *   4 4 0 0   0     0     0   3 1         0       4
835486 835486 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   ungraded_secondary 5.0 0.0 0.0   0.0     0.0     0.0   3.0 2.0             *     5   5 5 0 0   0     0     0   3 2             5   5
1121927 1121927 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_1 58.0 2.0 0.0   0.0     0.0     0.0   37.0 23.0             42     13   60 58 2 0   0     0     0   37 23         42   13   60
1121928 1121928 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_10 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121929 1121929 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_11 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121930 1121930 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_12 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121931 1121931 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_2 44.0 1.0 0.0   0.0     0.0     0.0   25.0 20.0             30     11   45 44 1 0   0     0     0   25 20         30   11   45
1121932 1121932 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_3 45.0 0.0 2.0   0.0     0.0     0.0   24.0 23.0             31     8   47 45 0 2   0     0     0   24 23         31   8   47
1121933 1121933 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_4 30.0 0.0 1.0   1.0     0.0     1.0   21.0 12.0             18     5   33 30 0 1   1     0     1   21 12         18   5   33
1121934 1121934 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_5 55.0 0.0 1.0   0.0     0.0     1.0   33.0 24.0             43     12   57 55 0 1   0     0     1   33 24         43   12   57
1121935 1121935 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_6 42.0 1.0 0.0   0.0     1.0     0.0   19.0 25.0             25     5   44 42 1 0   0     1     0   19 25         25   5   44
1121936 1121936 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121937 1121937 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121938 1121938 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121939 1121939 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   kindergarten_full_day 37.0 0.0 1.0   0.0     0.0     2.0   21.0 19.0             26     8   40 37 0 1   0     0     2   21 19         26   8   40
1121940 1121940 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121941 1121941 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   pk_12_total 344.0 4.0 5.0   1.0     1.0     5.0   194.0 166.0             230     74   360 344 4 5   1     1     5   194 166         230   74   360
1121942 1121942 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   pre_kindergarten_full_day 24.0 0.0 0.0   0.0     0.0     1.0   8.0 17.0             10     *   25 24 0 0   0     0     1   8 17         10       25
1121943 1121943 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   pre_kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121944 1121944 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   ungraded_elementary 4.0 0.0 0.0   0.0     0.0     0.0   3.0 1.0             *     *   4 4 0 0   0     0     0   3 1                 4
1121945 1121945 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   ungraded_secondary 5.0 0.0 0.0   0.0     0.0     0.0   3.0 2.0             *     5   5 5 0 0   0     0     0   3 2             5   5
1031734 1031734 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   grade_1 38.0 0.0 2.0   0.0           2.0   21.0 21.0             31     9   42 38 0 2   0           2   21 21         31   9   42
1031735 1031735 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   grade_10 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
1031736 1031736 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   grade_11 1.0 0.0 0.0   0.0           0.0   0.0 1.0             0     *   1 1 0 0   0           0   0 1         0       1
1031737 1031737 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   grade_12 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
1031738 1031738 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   grade_2 65.0 1.0 0.0   0.0           0.0   41.0 25.0             48     17   66 65 1 0   0           0   41 25         48   17   66
1031739 1031739 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   grade_3 45.0 1.0 2.0   0.0           0.0   26.0 22.0             33     9   48 45 1 2   0           0   26 22         33   9   48
1031740 1031740 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   grade_4 46.0 0.0 3.0   0.0           0.0   26.0 23.0             34     9   49 46 0 3   0           0   26 23         34   9   49
1031741 1031741 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   grade_5 30.0 0.0 1.0   1.0           2.0   21.0 13.0             18     6   34 30 0 1   1           2   21 13         18   6   34
1031742 1031742 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   grade_6 51.0 0.0 0.0   0.0           1.0   30.0 22.0             39     7   52 51 0 0   0           1   30 22         39   7   52
1031743 1031743 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   grade_7 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
1031744 1031744 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   grade_8 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
1031745 1031745 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   grade_9 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
1031746 1031746 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   kindergarten_full_day 47.0 0.0 0.0   0.0           5.0   25.0 27.0             38     8   52 47 0 0   0           5   25 27         38   8   52
1031747 1031747 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   kindergarten_half_day 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
1031748 1031748 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   pk_12_total 373.0 2.0 10.0   1.0           12.0   213.0 185.0             268     81   398 373 2 10   1           12   213 185         268   81   398
1031749 1031749 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   pre_kindergarten_full_day 44.0 0.0 2.0   0.0           2.0   19.0 29.0             22     9   48 44 0 2   0           2   19 29         22   9   48
1031750 1031750 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   pre_kindergarten_half_day 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
1031751 1031751 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   ungraded_elementary 2.0 0.0 0.0   0.0           0.0   1.0 1.0             *     *   2 2 0 0   0           0   1 1                 2
1031752 1031752 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   ungraded_secondary 4.0 0.0 0.0   0.0           0.0   3.0 1.0             *     *   4 4 0 0   0           0   3 1                 4
2139074 2139074 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_1 54.0 0.0 0.0   0.0           3.0   28.0 29.0             41     10   57 54 0 0   0           3   28 29         41   10   57
2139075 2139075 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_10 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
2139076 2139076 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_11 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
2139077 2139077 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_12 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
2139078 2139078 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_2 32.0 0.0 3.0   0.0           1.0   20.0 16.0             24     6   36 32 0 3   0           1   20 16         24   6   36
2139079 2139079 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_3 61.0 0.0 1.0   0.0           0.0   37.0 25.0             41     14   62 61 0 1   0           0   37 25         41   14   62
2139080 2139080 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_4 43.0 1.0 3.0   0.0           0.0   24.0 23.0             33     11   47 43 1 3   0           0   24 23         33   11   47
2139081 2139081 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_5 41.0 0.0 3.0   0.0           0.0   26.0 18.0             31     9   44 41 0 3   0           0   26 18         31   9   44
2139082 2139082 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_6 30.0 0.0 1.0   1.0           2.0   20.0 14.0             *     6   34 30 0 1   1           2   20 14             6   34
2139083 2139083 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_7 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
2139084 2139084 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_8 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
2139085 2139085 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_9 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
2139086 2139086 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   kindergarten_full_day 48.0 0.0 2.0   0.0           4.0   23.0 31.0             37     9   54 48 0 2   0           4   23 31         37   9   54
2139087 2139087 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   kindergarten_half_day 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
2139088 2139088 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   pk_12_total 347.0 1.0 14.0   1.0           10.0   200.0 173.0             252     78   373 347 1 14   1           10   200 173         252   78   373
2139089 2139089 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   pre_kindergarten_full_day 33.0 0.0 1.0   0.0           0.0   19.0 15.0             23     8   34 33 0 1   0           0   19 15         23   8   34
2139090 2139090 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   pre_kindergarten_half_day 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
2139091 2139091 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   ungraded_elementary 4.0 0.0 0.0   0.0           0.0   2.0 2.0             *     *   4 4 0 0   0           0   2 2                 4
2139092 2139092 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   ungraded_secondary 1.0 0.0 0.0   0.0           0.0   1.0 0.0             *     *   1 1 0 0   0           0   1 0                 1
2228735 2228735 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_1 45.0   2.0               2.0   20.0 29.0             32     6   49 45   2               2   20 29         32   6   49
2228736 2228736 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_10 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
2228737 2228737 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_11 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
2228738 2228738 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_12 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
2228739 2228739 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 53.0   0.0               3.0   27.0 29.0             37     9   56 53   0               3   27 29         37   9   56
2228740 2228740 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_3 31.0   4.0               1.0   21.0 15.0             21     *   36 31   4               1   21 15         21       36
2228741 2228741 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_4 60.0   5.0               2.0   38.0 29.0             42     14   67 60   5               2   38 29         42   14   67
2228742 2228742 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_5 42.0   3.0               0.0   23.0 22.0             32     10   45 42   3               0   23 22         32   10   45
2228743 2228743 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_6 37.0   2.0               2.0   22.0 19.0             27     9   41 37   2               2   22 19         27   9   41
2228744 2228744 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
2228745 2228745 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_8 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
2228746 2228746 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_9 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
2228747 2228747 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   kindergarten_full_day 47.0   0.0               4.0   33.0 18.0             36     15   51 47   0               4   33 18         36   15   51
2228748 2228748 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   kindergarten_half_day 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
2228749 2228749 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pk_12_total 344.0   17.0               14.0   198.0 177.0             244     75   375 344   17               14   198 177         244   75   375
2228750 2228750 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pre_kindergarten_full_day 21.0   1.0               0.0   9.0 13.0             11     *   22 21   1               0   9 13         11       22
2228751 2228751 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pre_kindergarten_half_day 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
2228752 2228752 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   ungraded_elementary 6.0   0.0               0.0   4.0 2.0             *     6   6 6   0               0   4 2             6   6
2228753 2228753 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   ungraded_secondary 2.0   0.0               0.0   1.0 1.0             *     *   2 2   0               0   1 1                 2
1613096 1613096 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 10 2020   grade_1 44.0 0.0 0.0               4.0   29.0 19.0             33     14   48 44 0 0               4   29 19         33   14   48
1613097 1613097 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 10 2020   grade_10 1.0 0.0 0.0               0.0   1.0 0.0             *     *   1 1 0 0               0   1 0                 1
1613098 1613098 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 10 2020   grade_11 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
1613099 1613099 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 10 2020   grade_12 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
1613100 1613100 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 10 2020   grade_2 47.0 0.0 3.0               3.0   20.0 33.0             29     7   53 47 0 3               3   20 33         29   7   53

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);