enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 89,718 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income ▼ free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1000783 1000783 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_1 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000784 1000784 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_10 2.0 6.0 14.0                   14.0 8.0     *                 22 2 6 14                   14 8                 22
1000785 1000785 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_11 3.0 3.0 5.0                   3.0 8.0     *                 11 3 3 5                   3 8                 11
1000786 1000786 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_12 5.0 10.0 8.0                   14.0 9.0     *                 23 5 10 8                   14 9                 23
1000787 1000787 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_2 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000788 1000788 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_3 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000789 1000789 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_4 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000790 1000790 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_5 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000791 1000791 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_6 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000792 1000792 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_7 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000793 1000793 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_8 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000794 1000794 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_9 0.0 4.0 5.0                   5.0 4.0     *                 9 0 4 5                   5 4                 9
1000795 1000795 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   kindergarten_full_day 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000796 1000796 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   kindergarten_half_day 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000797 1000797 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   pk_12_total 10.0 23.0 32.0                   36.0 29.0     *                 65 10 23 32                   36 29                 65
1000798 1000798 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   pre_kindergarten_full_day 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000799 1000799 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   pre_kindergarten_half_day 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000800 1000800 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   ungraded_elementary 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000801 1000801 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   ungraded_secondary 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1009960 1009960 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   grade_1 7.0                   0.0   6.0 1.0     *             *   7 7                   0   6 1                 7
1009961 1009961 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   grade_10 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1009962 1009962 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   grade_11 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1009963 1009963 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   grade_12 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1009964 1009964 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   grade_2 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1009965 1009965 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   grade_3 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1009966 1009966 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   grade_4 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1009967 1009967 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   grade_5 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1009968 1009968 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   grade_6 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1009969 1009969 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   grade_7 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1009970 1009970 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   grade_8 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1009971 1009971 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   grade_9 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1009972 1009972 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   kindergarten_full_day 8.0                   1.0   4.0 5.0     *             *   9 8                   1   4 5                 9
1009973 1009973 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   kindergarten_half_day 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1009974 1009974 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   pk_12_total 15.0                   1.0   10.0 6.0     *             *   16 15                   1   10 6                 16
1009975 1009975 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   pre_kindergarten_full_day 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1009976 1009976 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   pre_kindergarten_half_day 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1009977 1009977 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   ungraded_elementary 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1009978 1009978 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   ungraded_secondary 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1019327 1019327 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   grade_1 6.0 0.0 1.0         0.0     0.0   2.0 5.0     0             0   7 6 0 1         0     0   2 5     0       0   7
1019328 1019328 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   grade_10 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1019329 1019329 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   grade_11 2.0 0.0 0.0         0.0     0.0   0.0 2.0     0             0   2 2 0 0         0     0   0 2     0       0   2
1019330 1019330 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   grade_12 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1019331 1019331 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   grade_2 5.0 0.0 1.0         0.0     0.0   3.0 3.0     0             0   6 5 0 1         0     0   3 3     0       0   6
1019332 1019332 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   grade_3 9.0 0.0 3.0         0.0     1.0   7.0 6.0     *             0   13 9 0 3         0     1   7 6             0   13
1019333 1019333 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   grade_4 9.0 0.0 4.0         0.0     0.0   4.0 9.0     *             *   13 9 0 4         0     0   4 9                 13
1019334 1019334 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   grade_5 8.0 0.0 1.0         0.0     2.0   7.0 4.0     *             *   11 8 0 1         0     2   7 4                 11
1019335 1019335 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   grade_6 14.0 0.0 1.0         2.0     2.0   8.0 11.0     0             *   19 14 0 1         2     2   8 11     0           19
1019336 1019336 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   grade_7 11.0 0.0 1.0         0.0     2.0   10.0 4.0     0             *   14 11 0 1         0     2   10 4     0           14
1019337 1019337 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1019338 1019338 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1019339 1019339 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   kindergarten_full_day 12.0 1.0 2.0         0.0     0.0   8.0 7.0     *             *   15 12 1 2         0     0   8 7                 15
1019340 1019340 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1019341 1019341 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   pk_12_total 87.0 1.0 17.0         2.0     8.0   57.0 58.0     6             11   115 87 1 17         2     8   57 58     6       11   115
1019342 1019342 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   pre_kindergarten_full_day 11.0 0.0 2.0         0.0     0.0   7.0 6.0     0             0   13 11 0 2         0     0   7 6     0       0   13
1019343 1019343 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   pre_kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1019344 1019344 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   ungraded_elementary 0.0 0.0 1.0         0.0     1.0   1.0 1.0     *             *   2 0 0 1         0     1   1 1                 2
1019345 1019345 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 11 2017   ungraded_secondary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1019403 1019403 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   grade_1 13.0 2.0 7.0         0.0     1.0   13.0 10.0     *             *   23 13 2 7         0     1   13 10                 23
1019404 1019404 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   grade_10 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1019405 1019405 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   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
1019406 1019406 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   grade_12 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1019407 1019407 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   grade_2 25.0 3.0 6.0         1.0     0.0   20.0 15.0     *             8   35 25 3 6         1     0   20 15             8   35
1019408 1019408 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   grade_3 27.0 0.0 11.0         1.0     1.0   19.0 21.0     7             9   40 27 0 11         1     1   19 21     7       9   40
1019409 1019409 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   grade_4 25.0 2.0 16.0         1.0     0.0   20.0 24.0     *             7   44 25 2 16         1     0   20 24             7   44
1019410 1019410 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   grade_5 28.0 1.0 12.0         0.0     0.0   16.0 25.0     *             6   41 28 1 12         0     0   16 25             6   41
1019411 1019411 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   grade_6 26.0 1.0 5.0         0.0     0.0   17.0 15.0     *             5   32 26 1 5         0     0   17 15             5   32
1019412 1019412 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   grade_7 12.0 2.0 9.0         4.0     0.0   14.0 13.0     *             *   27 12 2 9         4     0   14 13                 27
1019413 1019413 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   grade_8 28.0 2.0 10.0         0.0     0.0   20.0 20.0     *             5   40 28 2 10         0     0   20 20             5   40
1019414 1019414 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1019415 1019415 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   kindergarten_full_day 15.0 2.0 5.0         0.0     0.0   14.0 8.0     *             *   22 15 2 5         0     0   14 8                 22
1019416 1019416 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1019417 1019417 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   pk_12_total 216.0 15.0 89.0         7.0     2.0   165.0 164.0     32             49   329 216 15 89         7     2   165 164     32       49   329
1019418 1019418 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 17.0 0.0 6.0         0.0     0.0   10.0 13.0     0             0   23 17 0 6         0     0   10 13     0       0   23
1019419 1019419 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   pre_kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1019420 1019420 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   ungraded_elementary 0.0 0.0 2.0         0.0     0.0   2.0 0.0     *             *   2 0 0 2         0     0   2 0                 2
1019421 1019421 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2017   ungraded_secondary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
1021854 1021854 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   grade_1 0.0   1.0               0.0   1.0 0.0     *             *   1 0   1               0   1 0                 1
1021855 1021855 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   grade_10 0.0   0.0               0.0   0.0 0.0     *             *   0 0   0               0   0 0                 0
1021856 1021856 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   grade_11 0.0   0.0               0.0   0.0 0.0     *             *   0 0   0               0   0 0                 0
1021857 1021857 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   grade_12 0.0   0.0               0.0   0.0 0.0     *             *   0 0   0               0   0 0                 0
1021858 1021858 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   grade_2 5.0   1.0               0.0   3.0 3.0     *             *   6 5   1               0   3 3                 6
1021859 1021859 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   grade_3 1.0   1.0               0.0   2.0 0.0     *             *   2 1   1               0   2 0                 2
1021860 1021860 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   grade_4 2.0   0.0               0.0   2.0 0.0     *             *   2 2   0               0   2 0                 2
1021861 1021861 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   grade_5 1.0   1.0               2.0   4.0 0.0     *             *   4 1   1               2   4 0                 4
1021862 1021862 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   grade_6 3.0   1.0               0.0   4.0 0.0     *             *   4 3   1               0   4 0                 4
1021863 1021863 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   grade_7 0.0   0.0               0.0   0.0 0.0     *             *   0 0   0               0   0 0                 0
1021864 1021864 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   grade_8 0.0   0.0               0.0   0.0 0.0     *             *   0 0   0               0   0 0                 0
1021865 1021865 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   grade_9 0.0   0.0               0.0   0.0 0.0     *             *   0 0   0               0   0 0                 0
1021866 1021866 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   kindergarten_full_day 1.0   1.0               0.0   1.0 1.0     *             *   2 1   1               0   1 1                 2
1021867 1021867 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   kindergarten_half_day 0.0   0.0               0.0   0.0 0.0     *             *   0 0   0               0   0 0                 0
1021868 1021868 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   pk_12_total 17.0   6.0               2.0   18.0 7.0     *             *   25 17   6               2   18 7                 25
1021869 1021869 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   pre_kindergarten_full_day 0.0   0.0               0.0   0.0 0.0     *             *   0 0   0               0   0 0                 0
1021870 1021870 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   pre_kindergarten_half_day 4.0   0.0               0.0   1.0 3.0     *             *   4 4   0               0   1 3                 4
1021871 1021871 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   ungraded_elementary 0.0   0.0               0.0   0.0 0.0     *             *   0 0   0               0   0 0                 0
1021872 1021872 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2017   ungraded_secondary 0.0   0.0               0.0   0.0 0.0     *             *   0 0   0               0   0 0                 0
1022557 1022557 NY Suffolk   school 3624060 580903020000   QUOGUE 362406003319 580903020001 QUOGUE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_1 13.0 0.0 1.0         0.0     1.0   7.0 8.0                   0   15 13 0 1         0     1   7 8             0   15
1022558 1022558 NY Suffolk   school 3624060 580903020000   QUOGUE 362406003319 580903020001 QUOGUE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_10 0.0 0.0 0.0         0.0     0.0   0.0 0.0                   0   0 0 0 0         0     0   0 0             0   0
1022559 1022559 NY Suffolk   school 3624060 580903020000   QUOGUE 362406003319 580903020001 QUOGUE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   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
1022560 1022560 NY Suffolk   school 3624060 580903020000   QUOGUE 362406003319 580903020001 QUOGUE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_12 0.0 0.0 0.0         0.0     0.0   0.0 0.0                   0   0 0 0 0         0     0   0 0             0   0
1022561 1022561 NY Suffolk   school 3624060 580903020000   QUOGUE 362406003319 580903020001 QUOGUE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 10.0 0.0 0.0         0.0     0.0   7.0 3.0                   *   10 10 0 0         0     0   7 3                 10

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