enrollments

Data source: Big Local News · About: Big Local

90,098 rows where state = "NY" and year = 2020 sorted by asian_pacific_islander

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 90,098 ✖
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
1523378 1523378 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_1 3.0 67.0 14.0               4.0   39.0 49.0     *       80     *   88 3 67 14               4   39 49         80       88
1523379 1523379 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   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
1523380 1523380 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 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
1523381 1523381 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 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
1523382 1523382 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_2 1.0 57.0 16.0               6.0   39.0 41.0     *       72     *   80 1 57 16               6   39 41         72       80
1523383 1523383 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_3 0.0 48.0 13.0               4.0   32.0 33.0     *       59     *   65 0 48 13               4   32 33         59       65
1523384 1523384 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_4 2.0 47.0 11.0               2.0   31.0 31.0     *       51     *   62 2 47 11               2   31 31         51       62
1523385 1523385 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_5 0.0 0.0 0.0               0.0   0.0 0.0     0       0     *   0 0 0 0               0   0 0     0   0       0
1523386 1523386 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_6 0.0 0.0 0.0               0.0   0.0 0.0     0       0     *   0 0 0 0               0   0 0     0   0       0
1523387 1523387 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   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
1523388 1523388 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   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
1523389 1523389 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   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
1523390 1523390 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   kindergarten_full_day 2.0 50.0 9.0               7.0   32.0 36.0     0       59     *   68 2 50 9               7   32 36     0   59       68
1523391 1523391 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   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
1523392 1523392 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   pk_12_total 8.0 269.0 63.0               23.0   173.0 190.0     11       321     *   363 8 269 63               23   173 190     11   321       363
1523393 1523393 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   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     0   0       0
1523394 1523394 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   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
1523395 1523395 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   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
1523396 1523396 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   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
1524119 1524119 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   grade_1 17.0 2.0 0.0               1.0   8.0 12.0             8     *   20 17 2 0               1   8 12         8       20
1524120 1524120 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   grade_10 18.0 2.0 0.0               0.0   10.0 10.0             7     *   20 18 2 0               0   10 10         7       20
1524121 1524121 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   grade_11 13.0 3.0 1.0               0.0   8.0 9.0             15     6   17 13 3 1               0   8 9         15   6   17
1524122 1524122 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   grade_12 18.0 3.0 1.0               0.0   8.0 14.0             13     *   22 18 3 1               0   8 14         13       22
1524123 1524123 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   grade_2 15.0 2.0 1.0               4.0   12.0 10.0             14     5   22 15 2 1               4   12 10         14   5   22
1524124 1524124 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   grade_3 12.0 1.0 0.0               2.0   6.0 9.0             10     *   15 12 1 0               2   6 9         10       15
1524125 1524125 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   grade_4 13.0 1.0 1.0               0.0   7.0 8.0             10     *   15 13 1 1               0   7 8         10       15
1524126 1524126 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   grade_5 14.0 1.0 0.0               1.0   5.0 11.0             9     *   16 14 1 0               1   5 11         9       16
1524127 1524127 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   grade_6 25.0 2.0 0.0               0.0   16.0 11.0             17     7   27 25 2 0               0   16 11         17   7   27
1524128 1524128 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   grade_7 18.0 1.0 1.0               1.0   8.0 13.0             11     *   21 18 1 1               1   8 13         11       21
1524129 1524129 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   grade_8 15.0 2.0 1.0               4.0   8.0 14.0             16     9   22 15 2 1               4   8 14         16   9   22
1524130 1524130 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   grade_9 21.0 1.0 1.0               0.0   9.0 14.0             18     *   23 21 1 1               0   9 14         18       23
1524131 1524131 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   kindergarten_full_day 13.0 7.0 1.0               0.0   10.0 11.0             *     *   21 13 7 1               0   10 11                 21
1524132 1524132 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   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
1524133 1524133 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   pk_12_total 213.0 29.0 8.0               13.0   117.0 146.0             154     57   263 213 29 8               13   117 146         154   57   263
1524134 1524134 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   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         0   0   0
1524135 1524135 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   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
1524136 1524136 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   ungraded_elementary 1.0 1.0 0.0               0.0   2.0 0.0             *     *   2 1 1 0               0   2 0                 2
1524137 1524137 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   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
1524442 1524442 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   grade_1 22.0 0.0 0.0               0.0   12.0 10.0     *       14     *   22 22 0 0               0   12 10         14       22
1524443 1524443 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   grade_10 22.0 0.0 0.0               0.0   14.0 8.0     *       15     5   22 22 0 0               0   14 8         15   5   22
1524444 1524444 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   grade_11 31.0 0.0 1.0               0.0   19.0 13.0     *       21     5   32 31 0 1               0   19 13         21   5   32
1524445 1524445 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   grade_12 15.0 0.0 1.0               0.0   7.0 9.0     *       10     *   16 15 0 1               0   7 9         10       16
1524446 1524446 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   grade_2 26.0 0.0 2.0               0.0   16.0 12.0     *       22     *   28 26 0 2               0   16 12         22       28
1524447 1524447 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   grade_3 17.0 0.0 0.0               0.0   9.0 8.0     *       15     *   17 17 0 0               0   9 8         15       17
1524448 1524448 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   grade_4 23.0 1.0 0.0               2.0   11.0 15.0     *       17     5   26 23 1 0               2   11 15         17   5   26
1524449 1524449 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   grade_5 28.0 0.0 0.0               0.0   16.0 12.0     *       17     *   28 28 0 0               0   16 12         17       28
1524450 1524450 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   grade_6 29.0 0.0 0.0               2.0   12.0 19.0     *       23     6   31 29 0 0               2   12 19         23   6   31
1524451 1524451 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   grade_7 32.0 1.0 0.0               0.0   13.0 20.0     *       21     7   33 32 1 0               0   13 20         21   7   33
1524452 1524452 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   grade_8 20.0 0.0 0.0               1.0   11.0 10.0     *       12     *   21 20 0 0               1   11 10         12       21
1524453 1524453 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   grade_9 26.0 0.0 2.0               0.0   18.0 10.0     *       24     10   28 26 0 2               0   18 10         24   10   28
1524454 1524454 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   kindergarten_full_day 18.0 0.0 0.0               0.0   9.0 9.0     *       13     *   18 18 0 0               0   9 9         13       18
1524455 1524455 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   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
1524456 1524456 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   pk_12_total 330.0 2.0 6.0               5.0   174.0 169.0     *       235     68   343 330 2 6               5   174 169         235   68   343
1524457 1524457 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   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         0   0   0
1524458 1524458 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   pre_kindergarten_half_day 21.0 0.0 0.0               0.0   7.0 14.0     *       11     5   21 21 0 0               0   7 14         11   5   21
1524459 1524459 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   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
1524460 1524460 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   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
1524461 1524461 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_1 13.0   1.0                   6.0 8.0             *     *   14 13   1                   6 8                 14
1524462 1524462 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_10 15.0   3.0                   9.0 9.0             12     *   18 15   3                   9 9         12       18
1524463 1524463 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_11 17.0   0.0                   7.0 10.0             8     *   17 17   0                   7 10         8       17
1524464 1524464 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_12 14.0   1.0                   5.0 10.0             7     *   15 14   1                   5 10         7       15
1524465 1524465 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_2 14.0   1.0                   8.0 7.0             7     *   15 14   1                   8 7         7       15
1524466 1524466 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_3 11.0   0.0                   7.0 4.0             6     *   11 11   0                   7 4         6       11
1524467 1524467 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_4 15.0   1.0                   7.0 9.0             9     *   16 15   1                   7 9         9       16
1524468 1524468 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_5 14.0   0.0                   10.0 4.0             6     *   14 14   0                   10 4         6       14
1524469 1524469 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_6 12.0   1.0                   6.0 7.0             *     *   13 12   1                   6 7                 13
1524470 1524470 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_7 12.0   1.0                   4.0 9.0             6     *   13 12   1                   4 9         6       13
1524471 1524471 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_8 23.0   1.0                   5.0 19.0             9     *   24 23   1                   5 19         9       24
1524472 1524472 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_9 10.0   0.0                   8.0 2.0             *     *   10 10   0                   8 2                 10
1524473 1524473 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   kindergarten_full_day 14.0   1.0                   10.0 5.0             6     *   15 14   1                   10 5         6       15
1524474 1524474 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   kindergarten_half_day 0.0   0.0                   0.0 0.0             0     0   0 0   0                   0 0         0   0   0
1524475 1524475 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   pk_12_total 202.0   13.0                   101.0 114.0             93     32   215 202   13                   101 114         93   32   215
1524476 1524476 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   pre_kindergarten_full_day 14.0   2.0                   7.0 9.0             *     7   16 14   2                   7 9             7   16
1524477 1524477 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   pre_kindergarten_half_day 0.0   0.0                   0.0 0.0             0     0   0 0   0                   0 0         0   0   0
1524478 1524478 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   ungraded_elementary 0.0   0.0                   0.0 0.0             0     0   0 0   0                   0 0         0   0   0
1524479 1524479 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   ungraded_secondary 4.0   0.0                   2.0 2.0             *     *   4 4   0                   2 2                 4
1524480 1524480 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_1 21.0 1.0 0.0               1.0   15.0 8.0             19     *   23 21 1 0               1   15 8         19       23
1524481 1524481 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_10 15.0 1.0 0.0               0.0   7.0 9.0             10     *   16 15 1 0               0   7 9         10       16
1524482 1524482 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_11 17.0 0.0 0.0               3.0   9.0 11.0             13     *   20 17 0 0               3   9 11         13       20
1524483 1524483 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_12 21.0 0.0 1.0               1.0   12.0 11.0             12     *   23 21 0 1               1   12 11         12       23
1524484 1524484 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_2 20.0 0.0 1.0               1.0   15.0 7.0             19     *   22 20 0 1               1   15 7         19       22
1524485 1524485 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_3 21.0 0.0 0.0               1.0   8.0 14.0             17     6   22 21 0 0               1   8 14         17   6   22
1524486 1524486 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_4 26.0 0.0 1.0               0.0   12.0 15.0             17     *   27 26 0 1               0   12 15         17       27
1524487 1524487 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_5 19.0 0.0 2.0               0.0   9.0 12.0             18     *   21 19 0 2               0   9 12         18       21
1524488 1524488 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_6 24.0 0.0 3.0               1.0   10.0 18.0             19     5   28 24 0 3               1   10 18         19   5   28
1524489 1524489 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 16.0 0.0 1.0               3.0   12.0 8.0             17     *   20 16 0 1               3   12 8         17       20
1524490 1524490 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_8 27.0 0.0 0.0               0.0   12.0 15.0             15     *   27 27 0 0               0   12 15         15       27
1524491 1524491 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_9 26.0 0.0 2.0               0.0   12.0 16.0             21     10   28 26 0 2               0   12 16         21   10   28
1524492 1524492 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   kindergarten_full_day 23.0 0.0 0.0               4.0   20.0 7.0             16     8   27 23 0 0               4   20 7         16   8   27
1524493 1524493 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   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
1524494 1524494 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   pk_12_total 288.0 2.0 11.0               18.0   160.0 159.0             223     63   319 288 2 11               18   160 159         223   63   319
1524495 1524495 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   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         0   0   0
1524496 1524496 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   pre_kindergarten_half_day 12.0 0.0 0.0               3.0   7.0 8.0             10     5   15 12 0 0               3   7 8         10   5   15
1524497 1524497 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   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
1524498 1524498 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   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
1524518 1524518 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_1 13.0 1.0 1.0                   8.0 7.0     *       7     0   15 13 1 1                   8 7         7   0   15
1524519 1524519 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_10 15.0 0.0 0.0                   8.0 7.0     *       6     *   15 15 0 0                   8 7         6       15
1524520 1524520 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_11 21.0 0.0 0.0                   14.0 7.0     *       11     *   21 21 0 0                   14 7         11       21
1524521 1524521 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_12 15.0 0.0 0.0                   5.0 10.0     *       10     *   15 15 0 0                   5 10         10       15
1524522 1524522 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_2 11.0 0.0 0.0                   7.0 4.0     *       8     *   11 11 0 0                   7 4         8       11

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