enrollments

Data source: Big Local News · About: Big Local

89,661 rows where state = "NY" and year = 2019 sorted by low_income

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 89,661 ✖
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
2191609 2191609 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   grade_1 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2191610 2191610 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   grade_10 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2191611 2191611 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   grade_11 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2191612 2191612 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   grade_12 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2191613 2191613 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   grade_2 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2191614 2191614 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   grade_3 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2191615 2191615 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   grade_4 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2191616 2191616 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   grade_5 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2191617 2191617 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   grade_6 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2191618 2191618 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   grade_7 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2191619 2191619 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   grade_8 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2191620 2191620 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   grade_9 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2191621 2191621 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   kindergarten_full_day 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2191622 2191622 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   kindergarten_half_day 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2191623 2191623 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   pk_12_total 53.0                   1.0   23.0 31.0                   *   54 53                   1   23 31                 54
2191624 2191624 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   pre_kindergarten_full_day 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2191625 2191625 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   pre_kindergarten_half_day 53.0                   1.0   23.0 31.0                   *   54 53                   1   23 31                 54
2191626 2191626 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   ungraded_elementary 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2191627 2191627 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   ungraded_secondary 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2206999 2206999 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   grade_1 10.0 1.0 0.0         0.0         5.0 6.0     *             *   11 10 1 0         0         5 6                 11
2207000 2207000 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   grade_10 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2207001 2207001 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   grade_11 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2207002 2207002 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   grade_12 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2207003 2207003 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   grade_2 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2207004 2207004 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   grade_3 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2207005 2207005 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   grade_4 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2207006 2207006 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   grade_5 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2207007 2207007 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   grade_6 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2207008 2207008 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   grade_7 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2207009 2207009 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   grade_8 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2207010 2207010 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   grade_9 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2207011 2207011 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   kindergarten_full_day 7.0 0.0 1.0         1.0         3.0 6.0     *             *   9 7 0 1         1         3 6                 9
2207012 2207012 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   kindergarten_half_day 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2207013 2207013 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   pk_12_total 17.0 1.0 1.0         1.0         8.0 12.0     *             *   20 17 1 1         1         8 12                 20
2207014 2207014 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   pre_kindergarten_full_day 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2207015 2207015 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   pre_kindergarten_half_day 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2207016 2207016 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   ungraded_elementary 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2207017 2207017 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   ungraded_secondary 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2216366 2216366 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   grade_1 3.0 0.0 1.0               0.0   1.0 3.0     0                 4 3 0 1               0   1 3     0           4
2216367 2216367 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   grade_10 0.0 0.0 0.0               0.0   0.0 0.0     0                 0 0 0 0               0   0 0     0           0
2216368 2216368 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   grade_11 0.0 0.0 0.0               0.0   0.0 0.0     0                 0 0 0 0               0   0 0     0           0
2216369 2216369 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   grade_12 0.0 0.0 0.0               0.0   0.0 0.0     0                 0 0 0 0               0   0 0     0           0
2216370 2216370 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   grade_2 10.0 1.0 3.0               0.0   7.0 7.0     *                 14 10 1 3               0   7 7                 14
2216371 2216371 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   grade_3 7.0 0.0 2.0               0.0   2.0 7.0     *                 9 7 0 2               0   2 7                 9
2216372 2216372 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   grade_4 4.0 0.0 0.0               0.0   3.0 1.0     0                 4 4 0 0               0   3 1     0           4
2216373 2216373 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   grade_5 9.0 0.0 3.0               1.0   8.0 5.0     *                 13 9 0 3               1   8 5                 13
2216374 2216374 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   grade_6 8.0 0.0 4.0               0.0   3.0 9.0     *                 12 8 0 4               0   3 9                 12
2216375 2216375 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0               0.0   0.0 0.0     0                 0 0 0 0               0   0 0     0           0
2216376 2216376 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   grade_8 0.0 0.0 0.0               0.0   0.0 0.0     0                 0 0 0 0               0   0 0     0           0
2216377 2216377 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   grade_9 0.0 0.0 0.0               0.0   0.0 0.0     0                 0 0 0 0               0   0 0     0           0
2216378 2216378 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   kindergarten_full_day 7.0 0.0 2.0               0.0   7.0 2.0     *                 9 7 0 2               0   7 2                 9
2216379 2216379 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   kindergarten_half_day 0.0 0.0 0.0               0.0   0.0 0.0     0                 0 0 0 0               0   0 0     0           0
2216380 2216380 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   pk_12_total 60.0 1.0 23.0               2.0   40.0 46.0     6                 86 60 1 23               2   40 46     6           86
2216381 2216381 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   pre_kindergarten_full_day 12.0 0.0 7.0               0.0   8.0 11.0     0                 19 12 0 7               0   8 11     0           19
2216382 2216382 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   pre_kindergarten_half_day 0.0 0.0 0.0               0.0   0.0 0.0     0                 0 0 0 0               0   0 0     0           0
2216383 2216383 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   ungraded_elementary 0.0 0.0 1.0               1.0   1.0 1.0     *                 2 0 0 1               1   1 1                 2
2216384 2216384 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   ungraded_secondary 0.0 0.0 0.0               0.0   0.0 0.0     0                 0 0 0 0               0   0 0     0           0
2216442 2216442 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   grade_1 17.0 0.0 5.0         0.0     0.0   11.0 11.0     *             *   22 17 0 5         0     0   11 11                 22
2216443 2216443 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   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
2216444 2216444 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   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
2216445 2216445 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   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
2216446 2216446 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   grade_2 15.0 1.0 6.0         0.0     0.0   13.0 9.0     *             *   22 15 1 6         0     0   13 9                 22
2216447 2216447 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   grade_3 13.0 2.0 7.0         0.0     1.0   14.0 9.0     *             8   23 13 2 7         0     1   14 9             8   23
2216448 2216448 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   grade_4 24.0 3.0 5.0         1.0     0.0   18.0 15.0     *             10   33 24 3 5         1     0   18 15             10   33
2216449 2216449 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   grade_5 27.0 0.0 12.0         1.0     1.0   20.0 21.0     6             9   41 27 0 12         1     1   20 21     6       9   41
2216450 2216450 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   grade_6 20.0 2.0 15.0         1.0     0.0   17.0 21.0     *             5   38 20 2 15         1     0   17 21             5   38
2216451 2216451 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   grade_7 26.0 1.0 15.0         0.0     0.0   18.0 24.0     6             5   42 26 1 15         0     0   18 24     6       5   42
2216452 2216452 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   grade_8 26.0 1.0 5.0         0.0     0.0   19.0 13.0     *             5   32 26 1 5         0     0   19 13             5   32
2216453 2216453 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   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
2216454 2216454 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   kindergarten_full_day 20.0 1.0 14.0         0.0     0.0   18.0 17.0     6             5   35 20 1 14         0     0   18 17     6       5   35
2216455 2216455 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
2216456 2216456 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   pk_12_total 201.0 13.0 95.0         3.0     2.0   165.0 149.0     29             55   314 201 13 95         3     2   165 149     29       55   314
2216457 2216457 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   pre_kindergarten_full_day 13.0 2.0 10.0         0.0     0.0   16.0 9.0     0             *   25 13 2 10         0     0   16 9     0           25
2216458 2216458 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   pre_kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
2216459 2216459 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   ungraded_elementary 0.0 0.0 1.0         0.0     0.0   1.0 0.0     *             *   1 0 0 1         0     0   1 0                 1
2216460 2216460 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   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
2218893 2218893 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   grade_1 5.0 0.0 1.0         0.0         5.0 1.0     *             *   6 5 0 1         0         5 1                 6
2218894 2218894 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   grade_10 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2218895 2218895 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   grade_11 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2218896 2218896 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   grade_12 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2218897 2218897 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   grade_2 2.0 0.0 0.0         0.0         1.0 1.0     *             *   2 2 0 0         0         1 1                 2
2218898 2218898 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   grade_3 3.0 0.0 1.0         1.0         3.0 2.0     *             *   5 3 0 1         1         3 2                 5
2218899 2218899 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   grade_4 2.0 0.0 2.0         0.0         3.0 1.0     *             *   4 2 0 2         0         3 1                 4
2218900 2218900 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   grade_5 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2218901 2218901 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   grade_6 3.0 0.0 0.0         0.0         1.0 2.0     *             *   3 3 0 0         0         1 2                 3
2218902 2218902 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2218903 2218903 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   grade_8 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2218904 2218904 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   grade_9 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2218905 2218905 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   kindergarten_full_day 8.0 0.0 1.0         1.0         4.0 6.0     *             *   10 8 0 1         1         4 6                 10
2218906 2218906 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   kindergarten_half_day 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2218907 2218907 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   pk_12_total 24.0 1.0 5.0         2.0         17.0 15.0     *             *   32 24 1 5         2         17 15                 32
2218908 2218908 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   pre_kindergarten_full_day 1.0 1.0 0.0         0.0         0.0 2.0     *             *   2 1 1 0         0         0 2                 2
2218909 2218909 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   pre_kindergarten_half_day 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2218910 2218910 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   ungraded_elementary 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2218911 2218911 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   ungraded_secondary 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2219729 2219729 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No Elementary KG 03 2019   grade_1 1.0   0.0                   1.0 0.0                       1 1   0                   1 0                 1
2219730 2219730 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No Elementary KG 03 2019   grade_10 0.0   0.0                   0.0 0.0                       0 0   0                   0 0                 0
2219731 2219731 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No Elementary KG 03 2019   grade_11 0.0   0.0                   0.0 0.0                       0 0   0                   0 0                 0
2219732 2219732 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No Elementary KG 03 2019   grade_12 0.0   0.0                   0.0 0.0                       0 0   0                   0 0                 0
2219733 2219733 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No Elementary KG 03 2019   grade_2 6.0   0.0                   2.0 4.0                       6 6   0                   2 4                 6

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