Data source: Big Local News · About: Big Local

33,145 rows where grade = "ungraded_elementary" and state = "NY" sorted by disability descending

View and edit SQL

year

grade

  • ungraded_elementary · 33,145
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
959722 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 2017   ungraded_elementary 32.0 45.0 12.0         7.0     2.0   65.0 33.0     *       91     97   98 32 45 12         7     2   65 33         91   97   98
1030858 NY Westchester   school 3631920 662300010000   YONKERS 363192004271 662300010029 SCHOOL 29 public Regular School No Elementary PK 08 2017   ungraded_elementary 17.0 25.0 46.0   0.0     4.0     4.0   65.0 31.0     *       74     96   96 17 25 46   0     4     4   65 31         74   96   96
2138198 NY Westchester   school 3631920 662300010000   YONKERS 363192004271 662300010029 SCHOOL 29 public Regular School No Elementary PK 08 2018   ungraded_elementary 18.0 21.0 49.0   0.0     5.0     3.0   64.0 32.0     *       79     96   96 18 21 49   0     5     3   64 32         79   96   96
1077560 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504354 307500014177 PS 177 public Special Education School No 1.0 KG 08 2016   ungraded_elementary 23.0 33.0 20.0   1.0     18.0     0.0   79.0 16.0             56     95   95 23 33 20   1     18     0   79 16         56   95   95
1049573 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No 4.0 KG 12 2016   ungraded_elementary 27.0 43.0 15.0         7.0     2.0   59.0 35.0             90     94   94 27 43 15         7     2   59 35         90   94   94
2227859 NY Westchester   school 3631920 662300010000   YONKERS 363192004271 662300010029 SCHOOL 29 public Regular School No Elementary PK 08 2019   ungraded_elementary 15.0 23.0 48.0   0.0     6.0     2.0   63.0 31.0     *       73     94   94 15 23 48   0     6     2   63 31         73   94   94
1077313 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502826 307500013370 PS 370 public Special Education School No 4.0 KG 12 2016   ungraded_elementary 30.0 20.0 28.0   0.0     15.0         63.0 30.0             57     93   93 30 20 28   0     15         63 30         57   93   93
791272 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502843 307500014811 PS 811 public Special Education School No 4 KG 12 2015   ungraded_elementary 12.0 32.0 29.0   5.0     12.0     1.0   66.0 25.0             52     91   91 12 32 29   5     12     1   66 25         52   91   91
1612220 NY Westchester   school 3631920 662300010000   YONKERS 363192004271 662300010029 SCHOOL 29 public Regular School No Elementary PK 08 2020   ungraded_elementary 14.0 19.0 50.0   0.0     5.0     3.0   63.0 28.0     *       75     91   91 14 19 50   0     5     3   63 28         75   91   91
790873 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502826 307500013370 PS 370 public Special Education School No 4 KG 12 2015   ungraded_elementary 28.0 19.0 30.0   0.0     13.0     0.0   64.0 26.0             53     90   90 28 19 30   0     13     0   64 26         53   90   90
2183855 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502733 307500011226 PS 226 public Special Education School No Other PK 12 2019   ungraded_elementary 7.0 37.0 43.0   1.0     1.0     1.0   64.0 26.0     17       82     90   90 7 37 43   1     1     1   64 26     17   82   90   90
745216 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   ungraded_elementary 3.0 4.0 1.0   0.0     1.0     0.0   8.0 1.0             5     9   9 3 4 1   0     1     0   8 1         5   9   9
749605 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602288 320900010070 PS 70 MAX SCHOENFELD public Regular School No 1.0 KG 05 2015   ungraded_elementary 0.0 2.0 7.0   0.0     0.0     0.0   8.0 1.0             8     9   9 0 2 7   0     0     0   8 1         8   9   9
753196 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008800158 321100010178 PS 178 DR SELMAN WAKSMAN public Regular School No 1.0 KG 05 2015   ungraded_elementary 0.0 3.0 5.0   1.0     0.0     0.0   5.0 4.0             9     9   9 0 3 5   1     0     0   5 4         9   9   9
755571 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001631 31101060004 MAINE MEMORIAL SCHOOL public Regular School No 1.0 PK 05 2015   ungraded_elementary 8.0 0.0 0.0   0.0     0.0     1.0   4.0 5.0             6     9   9 8 0 0   0     0     1   4 5         6   9   9
756597 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA ELEMENTARY SCHOOL public Regular School No 2.0 04 06 2015   ungraded_elementary 5.0 1.0 0.0   3.0     0.0     0.0   6.0 3.0             8     9   9 5 1 0   3     0     0   6 3         8   9   9
760625 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001272 130801060002 NETHERWOOD SCHOOL public Regular School No 1.0 KG 05 2015   ungraded_elementary 8.0 0.0 1.0         0.0     0.0   5.0 4.0             8     9   9 8 0 1         0     0   5 4         8   9   9
761936 NY Erie   school 3602920 140201060000   AMHERST 360292004378 140201060005 SMALLWOOD DRIVE SCHOOL public Regular School No 1 KG 5 2015   ungraded_elementary 7.0 2.0 0.0   0.0     0.0     0.0   5.0 4.0             5     9   9 7 2 0   0     0     0   5 4         5   9   9
762069 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004211 140203060007 FOREST ELEMENTARY SCHOOL public Regular School No 1 KG 4 2015   ungraded_elementary 7.0 1.0 0.0   0.0     1.0     0.0   7.0 2.0             6     9   9 7 1 0   0     1     0   7 2         6   9   9
764083 NY Erie   school 3607590 140801060000   CLARENCE 360759004680 140801060005 SHERIDAN HILL ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   ungraded_elementary 9.0 0.0 0.0         0.0     0.0   7.0 2.0             *     9   9 9 0 0         0     0   7 2             9   9
777364 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302003 332200010014 JHS 14 SHELL BANK public Regular School No 2 06 8 2015   ungraded_elementary 2.0 2.0 3.0   0.0     2.0     0.0   5.0 4.0             7     9   9 2 2 3   0     2     0   5 4         7   9   9
777820 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302769 332200010255 PS 255 BARBARA REING SCHOOL public Regular School No 1 PK 5 2015   ungraded_elementary 4.0 1.0 3.0   0.0     1.0     0.0   7.0 2.0             7     9   9 4 1 3   0     1     0   7 2         7   9   9
778295 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012102559 332300010155 PS/IS 155 NICHOLAS HERKIMER public Regular School No 1 PK 08 2015   ungraded_elementary 0.0 3.0 5.0   0.0     1.0         5.0 4.0             *     9   9 0 3 5   0     1         5 4             9   9
780708 NY Monroe   school 3605460 260101060000   BRIGHTON 360546000274 260101060001 COUNCIL ROCK PRIMARY SCHOOL public Regular School No 1 KG 02 2015   ungraded_elementary 6.0 0.0 3.0         0.0     0.0   8.0 1.0             *     9   9 6 0 3         0     0   8 1             9   9
782266 NY Monroe   school 3623160 261401060000   PITTSFORD 362316003243 261401060009 THORNELL ROAD SCHOOL public Regular School No 1 KG 05 2015   ungraded_elementary 6.0 0.0 0.0         2.0     1.0   8.0 1.0             *     9   9 6 0 0         2     1   8 1             9   9
784546 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   ungraded_elementary 1.0 4.0 4.0   0.0     0.0     0.0   6.0 3.0             8     9   9 1 4 4   0     0     0   6 3         8   9   9
795718 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007902529 310400010146 PS 146 ANN M SHORT public Regular School No 1 PK 05 2015   ungraded_elementary 0.0 2.0 7.0   0.0     0.0         5.0 4.0             9     9   9 0 2 7   0     0         5 4         9   9   9
801836 NY Onondaga   school 3617520 421501060000   LIVERPOOL 361752001569 421501060012 MORGAN ROAD ELEMENTARY SCHOOL public Regular School No 1 KG 06 2015   ungraded_elementary 8.0 1.0 0.0         0.0     0.0   7.0 2.0             9     9   9 8 1 0         0     0   7 2         9   9   9
804971 NY Orleans   school 3618960 450801060000   MEDINA 361896001715 450801060003 CLIFFORD WISE INTERMEDIATE/MIDDLE public Regular School No 1 03 07 2015   ungraded_elementary 3.0 3.0 2.0   0.0     0.0     1.0   6.0 3.0             *     9   9 3 3 2   0     0     1   6 3             9   9
806282 NY Putnam   school 3606570 480102060000   CARMEL 360657000441 480102060001 KENT PRIMARY SCHOOL public Regular School No 1 KG 04 2015   ungraded_elementary 6.0 0.0 3.0   0.0     0.0     0.0   7.0 2.0             *     9   9 6 0 3   0     0     0   7 2             9   9
806358 NY Putnam   school 3606570 480102060000   CARMEL 360657000439 480102060007 GEORGE FISCHER MIDDLE SCHOOL public Regular School No 2 05 08 2015   ungraded_elementary 4.0 1.0 3.0   0.0     0.0     1.0   4.0 5.0             7     9   9 4 1 3   0     0     1   4 5         7   9   9
806567 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009803117 342400010005 IS 5 WALTER CROWLEY INTERMEDIATE public Regular School No 2 06 09 2015   ungraded_elementary 0.0 0.0 7.0   0.0     2.0     0.0   6.0 3.0             7     9   9 0 0 7   0     2     0   6 3         7   9   9
813426 NY Rensselaer   school 3609630 490301060000   EAST GREENBUSH 360963000735 490301060006 RED MILL SCHOOL public Regular School No 1 KG 05 2015   ungraded_elementary 9.0 0.0 0.0   0.0     0.0     0.0   6.0 3.0             *     9   9 9 0 0   0     0     0   6 3             9   9
815459 NY Rockland   school 3620340 500101060000   CLARKSTOWN 362034001869 500101060006 LAUREL PLAINS ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   ungraded_elementary 4.0 0.0 4.0         1.0     0.0   7.0 2.0             *     9   9 4 0 4         1     0   7 2             9   9
817435 NY Saratoga   school 3626670 520302060000   SHENENDEHOWA 362667003636 520302060007 KARIGON ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   ungraded_elementary 6.0 3.0 0.0   0.0     0.0     0.0   7.0 2.0             5     9   9 6 3 0   0     0     0   7 2         5   9   9
817777 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393000153 521301060006 WOOD ROAD ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   ungraded_elementary 9.0 0.0 0.0         0.0     0.0   7.0 2.0             6     9   9 9 0 0         0     0   7 2         6   9   9
821064 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004234 580109020001 MARTIN LUTHER KING ELEMENTARY SCHOOL public Regular School No 1 03 05 2015   ungraded_elementary 0.0 5.0 4.0         0.0     0.0   6.0 3.0             9     9   9 0 5 4         0     0   6 3         9   9   9
822869 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800196 580235060002 KREAMER STREET ELEMENTARY SCHOOL public Regular School No 1 KG 03 2015   ungraded_elementary 7.0 1.0 1.0   0.0     0.0     0.0   7.0 2.0             5     9   9 7 1 1   0     0     0   7 2         5   9   9
824218 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000170 580501030003 MARY G CLARKSON SCHOOL public Regular School No 1 KG 02 2015   ungraded_elementary 2.0 2.0 5.0   0.0     0.0     0.0   5.0 4.0             *     9   9 2 2 5   0     0     0   5 4             9   9
826897 NY Sullivan   school 3628890 591201040000   TRI VALLEY 362889003909 591201040002 TRI-VALLEY ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   ungraded_elementary 4.0 0.0 2.0               3.0   7.0 2.0                   9   9 4 0 2               3   7 2             9   9
830830 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000786 660301030003 GREENVALE SCHOOL public Regular School No 1 02 05 2015   ungraded_elementary 5.0 0.0 1.0         2.0     1.0   5.0 4.0                   9   9 5 0 1         2     1   5 4             9   9
830849 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008004767 660301030004 WAVERLY EARLY CHLDHD CENTER public Regular School No 1 KG 01 2015   ungraded_elementary 5.0 0.0 2.0   0.0     2.0     0.0   7.0 2.0             *     9   9 5 0 2   0     2     0   7 2             9   9
831913 NY Westchester   school 3618240 660701030000   MAMARONECK 361824001647 660701030003 MAMARONECK AVENUE SCHOOL public Regular School No 1 KG 05 2015   ungraded_elementary 4.0 2.0 2.0   0.0     1.0     0.0   7.0 2.0             *     9   9 4 2 2   0     1     0   7 2             9   9
942185 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2017   ungraded_elementary 1.0 7.0 1.0   0.0     0.0     0.0   6.0 3.0     0       8     9   9 1 7 1   0     0     0   6 3     0   8   9   9
942945 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 08 2017   ungraded_elementary 5.0 2.0 1.0   0.0     1.0     0.0   6.0 3.0     0       5     9   9 5 2 1   0     1     0   6 3     0   5   9   9
955694 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000184 90301060001 BEEKMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   ungraded_elementary 9.0 0.0 0.0   0.0     0.0         5.0 4.0             9     9   9 9 0 0   0     0         5 4         9   9   9
957765 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003306 131500010009 MORSE YOUNG MAGNET SCHOOL public Regular School No Elementary KG 05 2017   ungraded_elementary 2.0 1.0 4.0   0.0     0.0     2.0   6.0 3.0     0       8     9   9 2 1 4   0     0     2   6 3     0   8   9   9
959019 NY Erie   school 3628500 140207060000   SWEET HOME 362850003829 140207060003 MAPLEMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 5 2017   ungraded_elementary 4.0 3.0 1.0         0.0     1.0   7.0 2.0             8     9   9 4 3 1         0     1   7 2         8   9   9
959608 NY Erie   school 3605850 140600010000   BUFFALO 360585000363 140600010072 LORRAINE ELEMENTARY SCHOOL public Regular School No Elementary PK 8 2017   ungraded_elementary 3.0 5.0 1.0   0.0     0.0     0.0   6.0 3.0     *       7     9   9 3 5 1   0     0     0   6 3         7   9   9
972623 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015101348 332000010187 IS 187 CHRISTA MCAULIFFE SCHOOL (THE public Regular School No Middle 06 8 2017   ungraded_elementary 5.0 1.0 3.0         0.0     0.0   3.0 6.0     *       9     9   9 5 1 3         0     0   3 6         9   9   9
981705 NY Nassau   school 3617160 280205030000   LEVITTOWN 361716001532 280205030010 WISDOM LANE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   ungraded_elementary 7.0 0.0 2.0   0.0     0.0     0.0   5.0 4.0     *       *     9   9 7 0 2   0     0     0   5 4             9   9
982408 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003057 280211030007 SCHOOL 9E-BOARDMAN ELEM SCHOOL public Regular School No Elementary 01 06 2017   ungraded_elementary 5.0 1.0 1.0         1.0     1.0   5.0 4.0     0       *     9   9 5 1 1         1     1   5 4     0       9   9
982807 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001502 280215030005 LAWRENCE ELEMENTARY SCHOOL-BROADWAY public Regular School No Elementary 03 05 2017   ungraded_elementary 2.0 2.0 5.0   0.0     0.0     0.0   6.0 3.0     *       6     9   9 2 2 5   0     0     0   6 3         6   9   9
985296 NY Nassau   school 3619500 280410030000   MINEOLA 361950001778 280410030003 JACKSON AVENUE SCHOOL public Regular School No Elementary 03 04 2017   ungraded_elementary 5.0 0.0 3.0         1.0     0.0   7.0 2.0     0       *     9   9 5 0 3         1     0   7 2     0       9   9
985714 NY Nassau   school 3617700 280503060000   LOCUST VALLEY 361770001590 280503060001 BAYVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   ungraded_elementary 7.0 0.0 2.0         1.0     0.0   9.0 1.0     *       6     9   10 7 0 2         1     0   9 1         6   9   10
998121 NY Onondaga   school 3617520 421501060000   LIVERPOOL 361752001569 421501060012 MORGAN ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   ungraded_elementary 7.0 0.0 0.0   0.0     1.0     1.0   6.0 3.0     0       9     9   9 7 0 0   0     1     1   6 3     0   9   9   9
998216 NY Onondaga   school 3617520 421501060000   LIVERPOOL 361752004720 421501060019 WILLOW FIELD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   ungraded_elementary 6.0 0.0 0.0   0.0     2.0     1.0   9.0 0.0             9     9   9 6 0 0   0     2     1   9 0         9   9   9
1000534 NY Orange   school 3619680 441301060000   VALLEY-MONTGMRY 361968001802 441301060006 VALLEY CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   ungraded_elementary 8.0 0.0 1.0   0.0     0.0     0.0   6.0 3.0     0       7     9   9 8 0 1   0     0     0   6 3     0   7   9   9
1003213 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802343 342400010089 PS 89 ELMHURST public Regular School No Elementary KG 05 2017   ungraded_elementary 0.0 0.0 5.0   0.0     4.0     0.0   5.0 4.0     7       6     9   9 0 0 5   0     4     0   5 4     7   6   9   9
1006994 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002510 342800010140 PS 140 EDWARD K ELLINGTON public Regular School No Elementary PK 06 2017   ungraded_elementary 0.0 9.0 0.0   0.0     0.0         4.0 5.0     0       9     9   9 0 9 0   0     0         4 5     0   9   9   9
1009806 NY Rensselaer   school 3609630 490301060000   EAST GREENBUSH 360963000735 490301060006 RED MILL SCHOOL public Regular School No Elementary KG 05 2017   ungraded_elementary 6.0 1.0 0.0   0.0     2.0     0.0   5.0 4.0             8     9   9 6 1 0   0     2     0   5 4         8   9   9
1010243 NY Rensselaer   school 3628950 491700010000   TROY 362895003913 491700010002 PS 2 public Regular School No Elementary KG 05 2017   ungraded_elementary 4.0 3.0 2.0         0.0     0.0   8.0 1.0     *       8     9   9 4 3 2         0     0   8 1         8   9   9
1014233 NY Saratoga   school 3627240 521401040000   SOUTH GLENS FALLS 362724003715 521401040003 HARRISON AVENUE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   ungraded_elementary 7.0 0.0 1.0         1.0     0.0   7.0 2.0     *       8     9   9 7 0 1         1     0   7 2         8   9   9
1015221 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003587 530600010013 PAIGE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   ungraded_elementary 3.0 2.0 4.0   0.0     0.0     0.0   8.0 1.0     0       7     9   9 3 2 4   0     0     0   8 1     0   7   9   9
1015563 NY Schoharie   school 3600010 541102060000   COBLSKL-RCHMDVL 360001001014 541102060005 JOSEPH B RADEZ ELEMENTARY SCHOOL public Regular School No Elementary 03 08 2017   ungraded_elementary 9.0 0.0 0.0         0.0     0.0   6.0 3.0     *       *     9   9 9 0 0         0     0   6 3             9   9
1017368 NY Suffolk   school 3608880 580107030000   DEER PARK 360888004715 580107030008 JOHN F KENNEDY INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2017   ungraded_elementary 3.0 2.0 2.0   0.0     1.0     1.0   6.0 3.0     0       *     9   9 3 2 2   0     1     1   6 3     0       9   9
1019097 NY Suffolk   school 3606840 580233020000   CENTER MORICHES 360684000469 580233020003 CLAYTON HUEY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   ungraded_elementary 8.0 0.0 0.0   1.0     0.0         5.0 4.0     0       *     9   9 8 0 0   1     0         5 4     0       9   9
1020560 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000165 580501030007 BAY SHORE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   ungraded_elementary 1.0 4.0 3.0         1.0     0.0   5.0 4.0     *       6     9   9 1 4 3         1     0   5 4         6   9   9
1020940 NY Suffolk   school 3604110 580505020000   BAYPORT BLUE POINT 360411000172 580505020005 ACADEMY STREET ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   ungraded_elementary 8.0 0.0 1.0   0.0     0.0     0.0   7.0 2.0     *       *     9   9 8 0 1   0     0     0   7 2             9   9
1021624 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000254 580512030016 NORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2017   ungraded_elementary 0.0 0.0 9.0   0.0     0.0     0.0   5.0 4.0     *       9     9   9 0 0 9   0     0     0   5 4         9   9   9
1027609 NY Westchester   school 3610200 660406030000   EDGEMONT 361020004551 660406030001 GREENVILLE SCHOOL public Regular School No Elementary KG 06 2017   ungraded_elementary 5.0 0.0 0.0         4.0     0.0   6.0 3.0     0             9   9 5 0 0         4     0   6 3     0       9   9
1032663 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   ungraded_elementary 4.0 2.0 1.0   0.0     1.0     1.0   6.0 3.0             *     9   9 4 2 1   0     1     1   6 3             9   9
1039465 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802389 321100010103 PS 103 HECTOR FONTANEZ public Regular School No 1.0 KG 05 2016   ungraded_elementary 0.0 6.0 3.0   0.0     0.0     0.0   6.0 3.0             6     9   9 0 6 3   0     0     0   6 3         6   9   9
1041992 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003821 30601060001 BROOKSIDE ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   ungraded_elementary 9.0 0.0 0.0         0.0     0.0   6.0 3.0             8     9   9 9 0 0         0     0   6 3         8   9   9
1049459 NY Erie   school 3605850 140600010000   BUFFALO 360585000363 140600010072 LORRAINE ELEMENTARY SCHOOL public Regular School No 1.0 PK 8 2016   ungraded_elementary 1.0 7.0 1.0   0.0     0.0     0.0   3.0 6.0             8     9   9 1 7 1   0     0     0   3 6         8   9   9
1056926 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011902291 331400011071 JUAN MOREL CAMPOS SECONDARY SCHOOL public Regular School No 4.0 06 12 2016   ungraded_elementary 8.0 0.0 1.0   0.0     0.0     0.0   2.0 7.0             8     9   9 8 0 1   0     0     0   2 7         8   9   9
1062341 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102385 332000010102 PS 102 BAYVIEW (THE) public Regular School No 1.0 KG 5 2016   ungraded_elementary 6.0 0.0 2.0   0.0     1.0     0.0   6.0 3.0             7     9   9 6 0 2   0     1     0   6 3         7   9   9
1063880 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302003 332200010014 JHS 14 SHELL BANK public Regular School No 2.0 06 8 2016   ungraded_elementary 5.0 2.0 0.0   0.0     1.0     1.0   6.0 3.0             9     9   9 5 2 0   0     1     1   6 3         9   9   9
1067186 NY Monroe   school 3605460 260101060000   BRIGHTON 360546000274 260101060001 COUNCIL ROCK PRIMARY SCHOOL public Regular School No 1.0 KG 02 2016   ungraded_elementary 7.0 0.0 1.0         1.0     0.0   9.0 0.0             *     9   9 7 0 1         1     0   9 0             9   9
1072088 NY Nassau   school 3611550 280209030000   FREEPORT 361155000911 280209030003 CAROLINE G ATKINSON SCHOOL public Regular School No 2.0 05 06 2016   ungraded_elementary 0.0 2.0 7.0   0.0     0.0     0.0   6.0 3.0             7     9   9 0 2 7   0     0     0   6 3         7   9   9
1073380 NY Nassau   school 3624780 280221030000   ROCKVILLE CENTRE 362478003430 280221030002 SOUTH SIDE MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   ungraded_elementary 6.0 2.0 1.0         0.0     0.0   7.0 2.0             *     9   9 6 2 1         0     0   7 2             9   9
1073988 NY Nassau   school 3629490 280230020000   VALLEY STR HEMP 30 362949003978 280230020002 FOREST ROAD SCHOOL public Regular School No 1.0 KG 06 2016   ungraded_elementary 0.0 5.0 1.0         3.0     0.0   7.0 2.0             *     9   9 0 5 1         3     0   7 2             9   9
1074881 NY Nassau   school 3620400 280405020000   NEW HYDE PARK 362040001883 280405020003 HILLSIDE GRADE SCHOOL public Regular School No 1.0 KG 06 2016   ungraded_elementary 2.0 0.0 5.0   0.0     2.0     0.0   9.0 0.0             5     9   9 2 0 5   0     2     0   9 0         5   9   9
1075717 NY Nassau   school 3617700 280503060000   LOCUST VALLEY 361770001590 280503060001 BAYVILLE ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   ungraded_elementary 7.0 0.0 1.0         1.0     0.0   8.0 1.0             5     9   9 7 0 1         1     0   8 1         5   9   9
1084837 NY Niagara   school 3620850 400701060000   NIAGARA WHEATFIELD 362085002948 400701060004 COLONIAL VILLAGE ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   ungraded_elementary 6.0 0.0 2.0   1.0           0.0   6.0 3.0             8     9   9 6 0 2   1           0   6 3         8   9   9
1088162 NY Onondaga   school 3617520 421501060000   LIVERPOOL 361752001564 421501060010 LIVERPOOL ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2016   ungraded_elementary 6.0 1.0 1.0   0.0     0.0     1.0   3.0 6.0             8     9   9 6 1 1   0     0     1   3 6         8   9   9
1088428 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003846 421800010004 BELLEVUE ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   ungraded_elementary 0.0 6.0 0.0   0.0     1.0     2.0   5.0 4.0             9     9   9 0 6 0   0     1     2   5 4         9   9   9
1089701 NY Orange   school 3630030 440102060000   WASHINGTONVILLE 363003004038 440102060002 TAFT ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   ungraded_elementary 3.0 1.0 4.0   0.0     1.0     0.0   6.0 3.0             *     9   9 3 1 4   0     1     0   6 3             9   9
1098061 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102532 342900010147 PS/MS 147 RONALD MCNAIR public Regular School No 1.0 PK 08 2016   ungraded_elementary 0.0 9.0 0.0   0.0     0.0     0.0   6.0 3.0             *     9   9 0 9 0   0     0     0   6 3             9   9
1100113 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600114 491302060001 SAND LAKE-MILLER HILL SCHOOL public Regular School No 1.0 KG 05 2016   ungraded_elementary 8.0 0.0 1.0         0.0     0.0   5.0 4.0             6     9   9 8 0 1         0     0   5 4         6   9   9
1100208 NY Rensselaer   school 3614730 491401040000   HOOSIC VALLEY 361473001226 491401040001 HOOSIC VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2016   ungraded_elementary 9.0 0.0 0.0   0.0     0.0     0.0   4.0 5.0             *     9   9 9 0 0   0     0     0   4 5             9   9
1100341 NY Rensselaer   school 3628950 491700010000   TROY 362895003916 491700010016 PS 16 public Regular School No 1.0 KG 05 2016   ungraded_elementary 3.0 1.0 4.0   0.0     0.0     1.0   5.0 4.0             8     9   9 3 1 4   0     0     1   5 4         8   9   9
1105281 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003580 530600010010 HOWE EARLY CHILDHOOD ED CTR public Regular School No 1.0 PK 01 2016   ungraded_elementary 3.0 2.0 3.0         1.0     0.0   9.0 0.0             6     9   9 3 2 3         1     0   9 0         6   9   9
1107029 NY Suffolk   school 3620910 580103030000   NORTH BABYLON 362091004742 580103030010 WILLIAM E DELUCA JR ELEMENTARY SCHOO public Regular School No 1.0 KG 05 2016   ungraded_elementary 5.0 1.0 3.0   0.0     0.0     0.0   8.0 1.0             6     9   9 5 1 3   0     0     0   8 1         6   9   9
1107352 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000066 580106030003 PARK AVENUE SCHOOL public Regular School No 1.0 01 06 2016   ungraded_elementary 0.0 3.0 6.0   0.0     0.0     0.0   7.0 2.0             7     9   9 0 3 6   0     0     0   7 2         7   9   9
1107998 NY Suffolk   school 3625350 580205060000   SACHEM 362535003513 580205060012 WENONAH SCHOOL public Regular School No 1.0 KG 05 2016   ungraded_elementary 5.0 1.0 1.0   0.0     2.0     0.0   4.0 5.0             *     9   9 5 1 1   0     2     0   4 5             9   9
1109784 NY Suffolk   school 3615090 580403030000   HUNTINGTON 361509001261 580403030004 FLOWER HILL SCHOOL public Regular School No 1.0 KG 04 2016   ungraded_elementary 3.0 3.0 2.0         0.0     1.0   6.0 3.0             *     9   9 3 3 2         0     1   6 3             9   9
1110468 NY Suffolk   school 3608130 580410030000   COMMACK 360813000591 580410030021 SAWMILL INTERMEDIATE SCHOOL public Regular School No 1.0 03 05 2016   ungraded_elementary 7.0 0.0 1.0   0.0     1.0     0.0   6.0 3.0             5     9   9 7 0 1   0     1     0   6 3         5   9   9
1112938 NY Suffolk   school 3600125 580912060000   ESTPRT-S MANOR CSD 360012500788 580912060002 EASTPORT ELEMENTARY SCHOOL public Regular School No 1.0 03 06 2016   ungraded_elementary 9.0 0.0 0.0         0.0     0.0   4.0 5.0             *     9   9 9 0 0         0     0   4 5             9   9
1443177 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000230 30200010011 MACARTHUR SCHOOL public Regular School No Elementary PK 05 2021   ungraded_elementary 5.0 2.0 0.0         0.0     2.0   6.0 3.0     *       9     9   9 5 2 0         0     2   6 3         9   9   9

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