enrollments

Data source: Big Local News · About: Big Local

89,718 rows where state = "NY" and year = 2018 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

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
2063554 2063554 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_3 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
2063555 2063555 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_4 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
2063556 2063556 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   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         0   0   0
2063557 2063557 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   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         0   0   0
2063558 2063558 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_7 34.0   4.0   0.0     1.0     0.0   23.0 16.0     *       14     7   39 34   4   0     1     0   23 16         14   7   39
2063559 2063559 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_8 30.0   6.0   1.0     0.0     0.0   13.0 24.0     *       17     *   37 30   6   1     0     0   13 24         17       37
2063560 2063560 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_9 45.0   4.0   0.0     0.0     2.0   27.0 24.0     *       21     7   51 45   4   0     0     2   27 24         21   7   51
2063561 2063561 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   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         0   0   0
2063562 2063562 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 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
2063563 2063563 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   pk_12_total 209.0   20.0   2.0     2.0     8.0   125.0 116.0     *       102     37   241 209   20   2     2     8   125 116         102   37   241
2063564 2063564 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   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         0   0   0
2063565 2063565 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 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
2063566 2063566 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   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
2063567 2063567 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   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
2049375 2049375 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2018   grade_1 26.0 8.0 5.0   0.0     2.0     7.0   31.0 17.0     *       14     *   48 26 8 5   0     2     7   31 17         14       48
2049376 2049376 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049377 2049377 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049378 2049378 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049379 2049379 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2018   grade_2 27.0 13.0 3.0   0.0     4.0     1.0   25.0 23.0     *       17     *   48 27 13 3   0     4     1   25 23         17       48
2049380 2049380 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2018   grade_3 26.0 8.0 6.0   0.0     6.0     2.0   34.0 14.0     *       16     *   48 26 8 6   0     6     2   34 14         16       48
2049381 2049381 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2018   grade_4 29.0 5.0 7.0   0.0     1.0     2.0   22.0 22.0     *       22     *   44 29 5 7   0     1     2   22 22         22       44
2049382 2049382 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2018   grade_5 28.0 7.0 5.0   1.0     3.0     2.0   25.0 21.0     *       15     *   46 28 7 5   1     3     2   25 21         15       46
2049383 2049383 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2018   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     0     0   0 0     0   0   0   0
2049384 2049384 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049385 2049385 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049386 2049386 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049387 2049387 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2018   kindergarten_full_day 25.0 8.0 7.0   0.0     4.0     6.0   27.0 23.0     6       17     *   50 25 8 7   0     4     6   27 23     6   17       50
2049388 2049388 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049389 2049389 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2018   pk_12_total 182.0 58.0 37.0   1.0     24.0     27.0   187.0 142.0     18       115     27   329 182 58 37   1     24     27   187 142     18   115   27   329
2049390 2049390 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2018   pre_kindergarten_full_day 19.0 6.0 2.0   0.0     3.0     6.0   15.0 21.0     0       7     6   36 19 6 2   0     3     6   15 21     0   7   6   36
2049391 2049391 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049392 2049392 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2018   ungraded_elementary 2.0 3.0 2.0   0.0     1.0     1.0   8.0 1.0     0       7     9   9 2 3 2   0     1     1   8 1     0   7   9   9
2049393 2049393 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2018   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 0     0   0   0   0
2049394 2049394 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_1 16.0 27.0 12.0   0.0     7.0     4.0   43.0 23.0     13       50     15   66 16 27 12   0     7     4   43 23     13   50   15   66
2049395 2049395 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049396 2049396 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049397 2049397 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049398 2049398 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 8.0 27.0 13.0   0.0     5.0     8.0   31.0 30.0     8       45     6   61 8 27 13   0     5     8   31 30     8   45   6   61
2049399 2049399 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_3 10.0 25.0 16.0   0.0     7.0     6.0   34.0 30.0     7       47     9   64 10 25 16   0     7     6   34 30     7   47   9   64
2049400 2049400 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_4 10.0 18.0 15.0   0.0     5.0     8.0   29.0 27.0     *       43     *   56 10 18 15   0     5     8   29 27         43       56
2049401 2049401 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_5 15.0 26.0 11.0   1.0     5.0     9.0   22.0 45.0     7       47     *   67 15 26 11   1     5     9   22 45     7   47       67
2049402 2049402 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   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     0     0   0 0     0   0   0   0
2049403 2049403 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049404 2049404 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049405 2049405 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049406 2049406 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   kindergarten_full_day 15.0 20.0 10.0   0.0     6.0     10.0   29.0 32.0     *       *     9   61 15 20 10   0     6     10   29 32             9   61
2049407 2049407 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049408 2049408 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   pk_12_total 74.0 143.0 77.0   1.0     35.0     46.0   188.0 188.0     43       271     46   376 74 143 77   1     35     46   188 188     43   271   46   376
2049409 2049409 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   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     0     0   0 0     0   0   0   0
2049410 2049410 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049411 2049411 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     1.0   0.0 1.0     0       *     *   1 0 0 0   0     0     1   0 1     0           1
2049412 2049412 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   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 0     0   0   0   0
2049413 2049413 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2018   grade_1 13.0 11.0 22.0   1.0     7.0     3.0   29.0 28.0     17       43     0   57 13 11 22   1     7     3   29 28     17   43   0   57
2049414 2049414 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049415 2049415 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049416 2049416 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049417 2049417 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 8.0 14.0 27.0   0.0     4.0     8.0   31.0 30.0     13       46     *   61 8 14 27   0     4     8   31 30     13   46       61
2049418 2049418 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2018   grade_3 9.0 15.0 32.0   0.0     8.0     4.0   39.0 29.0     22       56     5   68 9 15 32   0     8     4   39 29     22   56   5   68
2049419 2049419 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2018   grade_4 7.0 19.0 29.0   1.0     13.0     5.0   34.0 40.0     18       56     *   74 7 19 29   1     13     5   34 40     18   56       74
2049420 2049420 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2018   grade_5 8.0 22.0 28.0   0.0     8.0     1.0   35.0 32.0     19       54     10   67 8 22 28   0     8     1   35 32     19   54   10   67
2049421 2049421 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2018   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     0     0   0 0     0   0   0   0
2049422 2049422 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049423 2049423 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049424 2049424 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049425 2049425 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2018   kindergarten_full_day 6.0 20.0 36.0   0.0     11.0     3.0   40.0 36.0     20       54     8   76 6 20 36   0     11     3   40 36     20   54   8   76
2049426 2049426 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049427 2049427 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2018   pk_12_total 53.0 102.0 186.0   2.0     51.0     24.0   216.0 202.0     109       318     28   418 53 102 186   2     51     24   216 202     109   318   28   418
2049428 2049428 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2018   pre_kindergarten_full_day 2.0 1.0 12.0   0.0     0.0     0.0   8.0 7.0     0       9     *   15 2 1 12   0     0     0   8 7     0   9       15
2049429 2049429 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049430 2049430 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2018   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 0     0   0   0   0
2049431 2049431 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2018   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 0     0   0   0   0
2049432 2049432 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_1 36.0 9.0 10.0   1.0     7.0     3.0   29.0 37.0     5       *     7   66 36 9 10   1     7     3   29 37     5       7   66
2049433 2049433 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049434 2049434 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049435 2049435 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049436 2049436 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 34.0 19.0 15.0   0.0     4.0     9.0   47.0 34.0     *       38     13   81 34 19 15   0     4     9   47 34         38   13   81
2049437 2049437 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_3 41.0 20.0 7.0   0.0     3.0     7.0   46.0 32.0     *       40     13   78 41 20 7   0     3     7   46 32         40   13   78
2049438 2049438 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_4 46.0 18.0 11.0   0.0     9.0     8.0   50.0 42.0     5       37     15   92 46 18 11   0     9     8   50 42     5   37   15   92
2049439 2049439 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_5 33.0 16.0 18.0   1.0     13.0     8.0   50.0 39.0     8       40     13   89 33 16 18   1     13     8   50 39     8   40   13   89
2049440 2049440 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   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     0     0   0 0     0   0   0   0
2049441 2049441 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049442 2049442 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049443 2049443 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049444 2049444 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   kindergarten_full_day 43.0 13.0 14.0   0.0     11.0     9.0   42.0 48.0     6       36     7   90 43 13 14   0     11     9   42 48     6   36   7   90
2049445 2049445 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049446 2049446 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   pk_12_total 234.0 98.0 75.0   2.0     48.0     44.0   267.0 234.0     30       219     73   501 234 98 75   2     48     44   267 234     30   219   73   501
2049447 2049447 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   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     0     0   0 0     0   0   0   0
2049448 2049448 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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 0     0   0   0   0
2049449 2049449 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   ungraded_elementary 1.0 3.0 0.0   0.0     1.0     0.0   3.0 2.0     0       *     5   5 1 3 0   0     1     0   3 2     0       5   5
2049450 2049450 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   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 0     0   0   0   0
2049451 2049451 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2018   grade_1 6.0 23.0 7.0         1.0     3.0   25.0 15.0     6       36     0   40 6 23 7         1     3   25 15     6   36   0   40
2049452 2049452 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 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   0   0
2049453 2049453 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 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   0   0
2049454 2049454 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 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   0   0
2049455 2049455 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2018   grade_2 4.0 25.0 7.0         2.0     3.0   20.0 21.0     *       38     *   41 4 25 7         2     3   20 21         38       41
2049456 2049456 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2018   grade_3 5.0 46.0 9.0         1.0     4.0   43.0 22.0     9       58     *   65 5 46 9         1     4   43 22     9   58       65
2049457 2049457 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2018   grade_4 5.0 43.0 8.0         3.0     7.0   42.0 24.0     9       58     33   66 5 43 8         3     7   42 24     9   58   33   66
2049458 2049458 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2018   grade_5 8.0 23.0 5.0         2.0     2.0   17.0 23.0     9       35     *   40 8 23 5         2     2   17 23     9   35       40
2049459 2049459 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2018   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 0     0   0   0   0
2049460 2049460 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 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   0   0

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