enrollments

Data source: Big Local News · About: Big Local

89,718 rows where state = "NY" and year = 2017 sorted by ccd_school_lvl descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 89,718 ✖
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
943137 943137 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_1 21.0 2.0 0.0         1.0     0.0   7.0 17.0     *       17     *   24 21 2 0         1     0   7 17         17       24
943138 943138 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_10 17.0 0.0 0.0         0.0     2.0   6.0 13.0     *       11     *   19 17 0 0         0     2   6 13         11       19
943139 943139 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_11 9.0 0.0 1.0         0.0     3.0   4.0 9.0     *       8     *   13 9 0 1         0     3   4 9         8       13
943140 943140 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_12 14.0 1.0 0.0         0.0     3.0   11.0 7.0     *       8     *   18 14 1 0         0     3   11 7         8       18
943141 943141 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_2 16.0 0.0 0.0         0.0     0.0   6.0 10.0     *       8     *   16 16 0 0         0     0   6 10         8       16
943142 943142 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_3 26.0 1.0 1.0         0.0     0.0   15.0 13.0     *       23     5   28 26 1 1         0     0   15 13         23   5   28
943143 943143 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_4 23.0 1.0 3.0         1.0     1.0   11.0 18.0     *       22     *   29 23 1 3         1     1   11 18         22       29
943144 943144 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_5 17.0 1.0 3.0         1.0     4.0   13.0 13.0     *       19     9   26 17 1 3         1     4   13 13         19   9   26
943145 943145 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_6 21.0 0.0 1.0         0.0     2.0   10.0 14.0     *       20     5   24 21 0 1         0     2   10 14         20   5   24
943146 943146 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_7 22.0 1.0 0.0         1.0     2.0   13.0 13.0     *       16     5   26 22 1 0         1     2   13 13         16   5   26
943147 943147 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_8 21.0 3.0 1.0         0.0     1.0   10.0 16.0     *       22     6   26 21 3 1         0     1   10 16         22   6   26
943148 943148 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_9 27.0 3.0 2.0         0.0     0.0   15.0 17.0     *       22     9   32 27 3 2         0     0   15 17         22   9   32
943149 943149 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   kindergarten_full_day 26.0 1.0 1.0         0.0     1.0   17.0 12.0     *       20     *   29 26 1 1         0     1   17 12         20       29
943150 943150 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 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
943151 943151 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   pk_12_total 273.0 15.0 16.0         5.0     21.0   149.0 181.0     *       225     61   330 273 15 16         5     21   149 181         225   61   330
943152 943152 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   pre_kindergarten_full_day 13.0 1.0 3.0         1.0     2.0   11.0 9.0     *       9     *   20 13 1 3         1     2   11 9         9       20
943153 943153 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 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
943154 943154 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   ungraded_elementary 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
943155 943155 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   ungraded_secondary 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
943422 943422 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_1 20.0 0.0           0.0         6.0 14.0             13     *   20 20 0           0         6 14         13       20
943423 943423 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_10 19.0 0.0           0.0         8.0 11.0             8     0   19 19 0           0         8 11         8   0   19
943424 943424 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_11 21.0 1.0           0.0         10.0 12.0             14     *   22 21 1           0         10 12         14       22
943425 943425 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_12 27.0 0.0           0.0         16.0 11.0             9     *   27 27 0           0         16 11         9       27
943426 943426 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_2 29.0 0.0           0.0         12.0 17.0             17     *   29 29 0           0         12 17         17       29
943427 943427 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_3 23.0 0.0           0.0         9.0 14.0             15     *   23 23 0           0         9 14         15       23
943428 943428 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_4 16.0 1.0           0.0         9.0 8.0             11     *   17 16 1           0         9 8         11       17
943429 943429 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_5 24.0 1.0           1.0         11.0 15.0             17     *   26 24 1           1         11 15         17       26
943430 943430 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_6 24.0 0.0           0.0         12.0 12.0             12     *   24 24 0           0         12 12         12       24
943431 943431 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_7 21.0 0.0           0.0         13.0 8.0             11     5   21 21 0           0         13 8         11   5   21
943432 943432 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_8 19.0 0.0           0.0         7.0 12.0             9     0   19 19 0           0         7 12         9   0   19
943433 943433 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_9 25.0 0.0           0.0         8.0 17.0             12     *   25 25 0           0         8 17         12       25
943434 943434 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   kindergarten_full_day 21.0 0.0           0.0         12.0 9.0             13     *   21 21 0           0         12 9         13       21
943435 943435 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 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
943436 943436 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   pk_12_total 312.0 3.0           1.0         145.0 171.0             171     35   316 312 3           1         145 171         171   35   316
943437 943437 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   pre_kindergarten_full_day 0.0 0.0           0.0         0.0 0.0             0     0   0 0 0           0         0 0         0   0   0
943438 943438 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   pre_kindergarten_half_day 21.0 0.0           0.0         11.0 10.0             *     *   21 21 0           0         11 10                 21
943439 943439 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   ungraded_elementary 2.0 0.0           0.0         1.0 1.0             *     *   2 2 0           0         1 1                 2
943440 943440 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   ungraded_secondary 0.0 0.0           0.0         0.0 0.0             0     0   0 0 0           0         0 0         0   0   0
943441 943441 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_1 40.0 2.0 0.0   0.0     0.0     0.0   21.0 21.0             27     *   42 40 2 0   0     0     0   21 21         27       42
943442 943442 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_10 35.0 2.0 0.0   1.0     1.0     0.0   23.0 16.0             13     8   39 35 2 0   1     1     0   23 16         13   8   39
943443 943443 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_11 37.0 1.0 0.0   0.0     0.0     0.0   22.0 16.0             15     5   38 37 1 0   0     0     0   22 16         15   5   38
943444 943444 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_12 42.0 2.0 0.0   0.0     0.0     0.0   22.0 22.0             19     *   44 42 2 0   0     0     0   22 22         19       44
943445 943445 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 30.0 0.0 0.0   0.0     1.0     0.0   17.0 14.0             20     *   31 30 0 0   0     1     0   17 14         20       31
943446 943446 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_3 35.0 0.0 0.0   0.0     0.0     0.0   21.0 14.0             22     5   35 35 0 0   0     0     0   21 14         22   5   35
943447 943447 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_4 39.0 1.0 2.0   0.0     0.0     0.0   16.0 26.0             26     5   42 39 1 2   0     0     0   16 26         26   5   42
943448 943448 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_5 32.0 0.0 0.0   0.0     0.0     0.0   15.0 17.0             17     5   32 32 0 0   0     0     0   15 17         17   5   32
943449 943449 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_6 36.0 1.0 0.0   0.0     1.0     0.0   18.0 20.0             20     6   38 36 1 0   0     1     0   18 20         20   6   38
943450 943450 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 25.0 0.0 0.0   1.0     0.0     1.0   16.0 11.0             21     9   27 25 0 0   1     0     1   16 11         21   9   27
943451 943451 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_8 51.0 1.0 0.0   1.0     0.0     0.0   31.0 22.0             27     7   53 51 1 0   1     0     0   31 22         27   7   53
943452 943452 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_9 38.0 1.0 0.0   1.0     0.0     1.0   25.0 16.0             21     8   41 38 1 0   1     0     1   25 16         21   8   41
943453 943453 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   kindergarten_full_day 33.0 0.0 0.0   2.0     1.0     0.0   15.0 21.0             21     5   36 33 0 0   2     1     0   15 21         21   5   36
943454 943454 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 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         0   0   0
943455 943455 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   pk_12_total 517.0 11.0 2.0   7.0     4.0     2.0   289.0 254.0             302     91   543 517 11 2   7     4     2   289 254         302   91   543
943456 943456 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   pre_kindergarten_full_day 18.0 0.0 0.0   0.0     0.0     0.0   10.0 8.0             8     *   18 18 0 0   0     0     0   10 8         8       18
943457 943457 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   pre_kindergarten_half_day 13.0 0.0 0.0   0.0     0.0     0.0   5.0 8.0             12     *   13 13 0 0   0     0     0   5 8         12       13
943458 943458 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   ungraded_elementary 5.0 0.0 0.0   1.0     0.0     0.0   5.0 1.0             5     6   6 5 0 0   1     0     0   5 1         5   6   6
943459 943459 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   ungraded_secondary 8.0 0.0 0.0   0.0     0.0     0.0   7.0 1.0             8     8   8 8 0 0   0     0     0   7 1         8   8   8
943460 943460 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   grade_1 27.0   0.0               2.0   12.0 17.0             20     *   29 27   0               2   12 17         20       29
943461 943461 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   grade_10 20.0   0.0               0.0   15.0 5.0             *     *   20 20   0               0   15 5                 20
943462 943462 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   grade_11 22.0   1.0               0.0   14.0 9.0             16     *   23 22   1               0   14 9         16       23
943463 943463 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   grade_12 22.0   0.0               0.0   12.0 10.0             10     *   22 22   0               0   12 10         10       22
943464 943464 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   grade_2 30.0   0.0               0.0   17.0 13.0             19     *   30 30   0               0   17 13         19       30
943465 943465 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   grade_3 27.0   0.0               1.0   12.0 16.0             20     *   28 27   0               1   12 16         20       28
943466 943466 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   grade_4 31.0   0.0               0.0   15.0 16.0             19     *   31 31   0               0   15 16         19       31
943467 943467 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   grade_5 20.0   0.0               1.0   13.0 8.0             13     *   21 20   0               1   13 8         13       21
943468 943468 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   grade_6 26.0   0.0               0.0   19.0 7.0             18     *   26 26   0               0   19 7         18       26
943469 943469 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   grade_7 27.0   0.0               0.0   16.0 11.0             23     7   27 27   0               0   16 11         23   7   27
943470 943470 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   grade_8 33.0   1.0               0.0   19.0 15.0             23     7   34 33   1               0   19 15         23   7   34
943471 943471 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   grade_9 21.0   1.0               0.0   10.0 12.0             15     9   22 21   1               0   10 12         15   9   22
943472 943472 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   kindergarten_full_day 17.0   0.0               0.0   8.0 9.0             13     *   17 17   0               0   8 9         13       17
943473 943473 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 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
943474 943474 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   pk_12_total 345.0   3.0               4.0   193.0 159.0             231     55   352 345   3               4   193 159         231   55   352
943475 943475 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   pre_kindergarten_full_day 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
943476 943476 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   pre_kindergarten_half_day 21.0   0.0               0.0   11.0 10.0             12     *   21 21   0               0   11 10         12       21
943477 943477 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   ungraded_elementary 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
943478 943478 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   ungraded_secondary 1.0   0.0               0.0   0.0 1.0             *     *   1 1   0               0   0 1                 1
943479 943479 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_1 18.0 0.0 2.0         0.0         9.0 11.0             14     5   20 18 0 2         0         9 11         14   5   20
943480 943480 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_10 12.0 0.0 0.0         1.0         7.0 6.0             6     *   13 12 0 0         1         7 6         6       13
943481 943481 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_11 18.0 0.0 0.0         0.0         6.0 12.0             9     *   18 18 0 0         0         6 12         9       18
943482 943482 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_12 10.0 0.0 0.0         0.0         1.0 9.0             *     0   10 10 0 0         0         1 9             0   10
943483 943483 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_2 18.0 0.0 0.0         0.0         9.0 9.0             11     *   18 18 0 0         0         9 9         11       18
943484 943484 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_3 17.0 0.0 1.0         0.0         9.0 9.0             8     *   18 17 0 1         0         9 9         8       18
943485 943485 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_4 16.0 0.0 0.0         0.0         6.0 10.0             9     *   16 16 0 0         0         6 10         9       16
943486 943486 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_5 20.0 0.0 1.0         0.0         3.0 18.0             10     *   21 20 0 1         0         3 18         10       21
943487 943487 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_6 14.0 0.0 0.0         0.0         10.0 4.0             8     0   14 14 0 0         0         10 4         8   0   14
943488 943488 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_7 21.0 0.0 0.0         0.0         10.0 11.0             12     *   21 21 0 0         0         10 11         12       21
943489 943489 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_8 22.0 1.0 1.0         0.0         8.0 16.0             12     *   24 22 1 1         0         8 16         12       24
943490 943490 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_9 21.0 0.0 0.0         0.0         9.0 12.0             14     *   21 21 0 0         0         9 12         14       21
943491 943491 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   kindergarten_full_day 14.0 0.0 0.0         0.0         10.0 4.0             10     0   14 14 0 0         0         10 4         10   0   14
943492 943492 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 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
943493 943493 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   pk_12_total 242.0 1.0 7.0         1.0         108.0 143.0             143     34   251 242 1 7         1         108 143         143   34   251
943494 943494 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   pre_kindergarten_full_day 17.0 0.0 2.0         0.0         9.0 10.0             11     *   19 17 0 2         0         9 10         11       19
943495 943495 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 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
943496 943496 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   ungraded_elementary 4.0 0.0 0.0         0.0         2.0 2.0             *     *   4 4 0 0         0         2 2                 4
943497 943497 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   ungraded_secondary 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
943498 943498 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_1 25.0 0.0 0.0               1.0   12.0 14.0             25     5   26 25 0 0               1   12 14         25   5   26
943499 943499 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_10 26.0 0.0 2.0               1.0   16.0 13.0             17     9   29 26 0 2               1   16 13         17   9   29
943500 943500 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_11 22.0 0.0 0.0               0.0   10.0 12.0             17     *   22 22 0 0               0   10 12         17       22
943501 943501 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_12 19.0 0.0 0.0               0.0   6.0 13.0             11     *   19 19 0 0               0   6 13         11       19
943502 943502 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 23.0 0.0 2.0               0.0   12.0 13.0             21     *   25 23 0 2               0   12 13         21       25

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]);