Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_8" and state = "NY" sorted by ccd_school_high_grade

View and edit SQL

year

grade

  • grade_8 · 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
759383 NY Columbia   school   100308020000   BERKSHIRE   100308020002 COLUMBIA-GREENE PARTNERSHIP ACADEMY public           2015   grade_8 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
987037 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           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   0   0
1043676 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   grade_8 69.0 5.0 2.0         0.0     2.0   43.0 35.0             25     12   78 69 5 2         0     2   43 35         25   12   78
1047590 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1456660 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1555992 NY Kings   school   332300010000   NYC GEOG DIST #23 - BROOKLYN   331700011646 ASPIRATIONS DIPLOMA PLUS HIGH SCHOOL public           2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2067910 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   grade_8 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2106347 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
747983 NY Bronx   school 3601115 320700860994   BOYS PREP CHARTER SCHOOL OF 360111506454 320700860994 BOYS PREP CHARTER SCHOOL OF NY charter Regular School Yes 1.0 KG 01 2015   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
748116 NY Bronx   school 3601125 320700861070   FAMILY LIFE ACADEMY CHARTER 360112506479 320700861070 FAMILY LIFE ACADEMY CHARTER SCH III charter Regular School Yes 1.0 KG 01 2015   grade_8   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
749370 NY Bronx   school 3601120 320800861074   SUCCESS ACADEMY CS - BRONX 4 360112006529 320800861074 SUCCESS ACADEMY CS - BRONX 4 charter Regular School Yes 1.0 KG 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
753360 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806400 321100010357 YOUNG VOICES ACADEMY-BRONX public Regular School No 1.0 PK 01 2015   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
758509 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000125 80201040003 GUILFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 01 2015   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
778193 NY Kings   school 3601123 332200861076   SUCCESS ACADEMY CS - BERGEN 360112306534 332200861076 SUCCESS ACADEMY CS - BERGEN BEACH charter Regular School Yes 1 KG 01 2015   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
779504 NY Kings   school 3601124 333200861045   ACHIEVEMENT FIRST NORTH BROOK 360112406457 333200861045 ACHIEVEMENT FIRST NORTH BROOKLYN PRE charter Regular School Yes 1 KG 01 2015   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
780378 NY Madison   school 3606390 250901060000   CANASTOTA 360639000420 250901060003 PETERBORO STREET ELEMENTARY SCHOOL public Regular School No 1 PK 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
781556 NY Monroe   school 3614700 260901060000   HONEOYE FALLS-LIMA 361470001224 260901060001 LIMA ELEMENTARY SCHOOL public Regular School No 1 KG 01 2015   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
783798 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000287 261801060002 GINTHER ELEMENTARY SCHOOL public Regular School No 1 PK 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
786230 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004226 280214030001 FRANKLIN EARLY CHILDHOOD CENTER public Regular School No 1 PK 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
786591 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176001637 280218030001 HEMLOCK SCHOOL public Regular School No 1 KG 01 2015   grade_8 0.0   0.0         0.0     0.0   0.0 0.0             *     0   0 0   0         0     0   0 0             0   0
786610 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000944 280218030002 HOMESTEAD SCHOOL public Regular School No 1 KG 01 2015   grade_8 0.0   0.0         0.0     0.0   0.0 0.0             *     0   0 0   0         0     0   0 0             0   0
786629 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000945 280218030003 LOCUST SCHOOL public Regular School No 1 KG 01 2015   grade_8 0.0 0.0           0.0     0.0   0.0 0.0             *     0   0 0 0           0     0   0 0             0   0
787332 NY Nassau   school 3615510 280226030000   ISLAND TREES 361551001321 280226030004 J FRED SPARKE SCHOOL public Regular School No 1 KG 01 2015   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
788035 NY Nassau   school 3630960 280401030000   WESTBURY 363096002842 280401030003 DRYDEN STREET SCHOOL public Regular School No 1 PK 01 2015   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
792728 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706371 310200010281 RIVER SCHOOL (THE) public Regular School No 1 PK 01 2015   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
794419 NY New York   school 3601110 310200861073   SUCCESS ACADEMY CS - WASHINGT 360111006501 310200861073 SUCCESS ACADEMY CS - WASHINGTON HGTS charter Regular School Yes 1 KG 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
796262 NY New York   school 3600142 310400861061   NY CTR FOR AUTISM CHARTER SC 360014205779 310400861061 NY CENTER FOR AUTISM CHARTER SCHOOL charter Special Education School Yes 1 01 01 2015   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
797269 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008306381 310600010103 DOS PUENTES ELEMENTARY SCHOOL public Regular School No 1 KG 01 2015   grade_8 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
801164 NY Onondaga   school 3607320 420701060000   WESTHILL 360732004582 420701060003 WALBERTA PARK PRIMARY SCHOOL public Regular School No 1 KG 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
802608 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859006510 421800010070 SYRACUSE LATIN SCHOOL public Regular School No 1 KG 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     *   0 0 0 0   0     0     0   0 0         0       0
803292 NY Ontario   school 3629640 431701060000   VICTOR 362964005334 431701060005 VICTOR EARLY CHILDHOOD SCHOOL public Regular School No 1 PK 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
804090 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965004198 441201060005 SMITH CLOVE ELEMENTARY SCHOOL public Regular School No 1 KG 01 2015   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
804147 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965004823 441201060011 SAPPHIRE ELEMENTARY SCHOOL public Regular School No 1 KG 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
807130 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806430 342400010211 ELM TREE ELEMENTARY SCHOOL public Regular School No 1 KG 01 2015   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
809201 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012301790 342700010051 PS 51 public Regular School No 1 PK 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
810360 NY Queens   school 3601116 342700861077   SUCCESS ACADEMY CS - ROSEDALE 360111606476 342700861077 SUCCESS ACADEMY CS - ROSEDALE charter Regular School Yes 1 KG 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
812241 NY Queens   school 3601118 342900861078   SUCCESS ACADEMY CS - SPRINGFI 360111806486 342900861078 SUCCESS ACADEMY CS - SPRINGFIELD charter Regular School Yes 1 KG 01 2015   grade_8   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
812925 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206442 343000010329 EAST ELMHURST COMMUNITY SCHOOL public Regular School No 1 KG 01 2015   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
813590 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No 1 KG 01 2015   grade_8 0.0                       0.0 0.0                   *   0 0                       0 0                 0
814160 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010306444 353100010009 NAPLES STREET ELEMENTARY SCHOOL public Regular School No 1 PK 01 2015   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
814939 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010306445 353100010059 HARBOR VIEW SCHOOL (THE) public Regular School No 1 PK 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
818777 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601005924 530600010006 FULTON EARLY CHILDHOOD CENTER public Regular School No 1 PK 01 2015   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
818834 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003580 530600010010 HOWE EARLY CHILDHOOD ED CTR public Regular School No 1 PK 01 2015   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
820050 NY Steuben   school 3614820 571800010000   HORNELL 361482004299 571800010007 NORTH HORNELL SCHOOL public Regular School No 1 KG 01 2015   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
822083 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920004843 580211060006 BICYCLE PATH KINDERGARTEN-PRE K public Regular School No 1 PK 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
823299 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801001044 580402060005 GOOSEHILL PRIMARY CENTER public Regular School No 1 KG 01 2015   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
824382 NY Suffolk   school 3615540 580502020000   ISLIP 361554000331 580502020006 WING ELEMENTARY SCHOOL public Regular School No 1 KG 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
825142 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528004432 580512030002 EAST ELEMENTARY SCHOOL public Regular School No 1 PK 01 2015   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
830842 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008004767 660301030004 WAVERLY EARLY CHLDHD CENTER public Regular School No 1 KG 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             *     0   0 0 0 0   0     0     0   0 0             0   0
831412 NY Westchester   school 3612720 660407060000   GREENBURGH 361272001046 660407060001 LEE F JACKSON SCHOOL public Regular School No 1 KG 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
831526 NY Westchester   school 3610650 660409020000   ELMSFORD 361065000839 660409020001 CARL L DIXSON ELEMENTARY SCHOOL public Regular School No 1 PK 01 2015   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
833312 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003184 661500010004 WOODSIDE SCHOOL public Regular School No 1 KG 01 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
950747 NY Bronx   school 3601127 321100861076   BRONX CHARTER SCHOOL-BETTER 360112706551 321100861076 BRONX CHARTER-BETTER LEARNING II charter Regular School Yes Elementary KG 01 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
950766 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 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
955269 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000125 80201040003 GUILFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 01 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
957644 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304004530 131301040003 COLD SPRING EARLY LEARNING CTR public Regular School No Elementary PK 01 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
976017 NY Kings   school 3601146 333200861096   SUCCESS ACADEMY CHARTER SCH- 360114606580 333200861096 SUCCESS ACADEMY CHARTER SCH-NYC 10 charter Regular School Yes Elementary KG 01 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
976872 NY Madison   school 3606390 250901060000   CANASTOTA 360639000420 250901060003 PETERBORO STREET ELEMENTARY SCHOOL public Regular School No Elementary PK 01 2017   grade_8 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
980235 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000287 261801060002 GINTHER ELEMENTARY SCHOOL public Regular School No Elementary PK 01 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 0     0   0   0   0
982667 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004226 280214030001 FRANKLIN EARLY CHILDHOOD CENTER public Regular School No Elementary PK 01 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 0     0   0   0   0
982781 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001501 280215030004 LAWRENCE EARLY CHILDHOOD-#4 SCHOOL public Regular School No Elementary PK 01 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 0     0   0   0   0
983028 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176001637 280218030001 HEMLOCK 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     *       *     0   0 0 0 0         0     0   0 0             0   0
983047 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000944 280218030002 HOMESTEAD 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   0 0   0         0     0   0 0         0   0   0
983066 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000945 280218030003 LOCUST 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   0 0 0 0         0         0 0         0   0   0
983769 NY Nassau   school 3615510 280226030000   ISLAND TREES 361551001321 280226030004 J FRED SPARKE 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     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
984624 NY Nassau   school 3625050 280403030000   ROSLYN 362505003471 280403030006 ROSLYN HTS ELEMENTARY SCHOOL public Regular School No Elementary PK 01 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 0     0   0   0   0
994390 NY New York   school 3601149 310600861074   AMBER CHARTER SCHOOL II 360114906588 310600861074 AMBER CHARTER SCHOOL II charter Regular School Yes Elementary KG 01 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
997449 NY Onondaga   school 3607320 420701060000   WESTHILL 360732004582 420701060003 WALBERTA PARK PRIMARY 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 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
999577 NY Ontario   school 3629640 431701060000   VICTOR 362964005334 431701060005 VICTOR EARLY CHILDHOOD SCHOOL public Regular School No Elementary PK 01 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 0     0   0   0   0
1000356 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965004198 441201060005 SMITH CLOVE ELEMENTARY 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 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1000413 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965004823 441201060011 SAPPHIRE ELEMENTARY 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     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1005505 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012301790 342700010051 PS 51 public Regular School No Elementary PK 01 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 0     0   0   0   0
1006664 NY Queens   school 3601151 342700861090   SUCCESS ACADEMY CHARTER SCHO 360115106581 342700861090 SUCCESS ACADEMY CHARTER SCHOOL-NYC 4 charter Regular School Yes Elementary KG 01 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
1006683 NY Queens   school 3601141 342700861099   SUCCESS ACADEMY CHARTER SCH- 360114106598 342700861099 SUCCESS ACADEMY CHARTER SCH-NYC 13 charter Regular School Yes Elementary KG 01 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         0   0   0
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
1016392 NY Steuben   school 3614820 571800010000   HORNELL 361482004299 571800010007 NORTH HORNELL 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     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1017209 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000064 580106030001 NORTHEAST SCHOOL public Regular School No Elementary PK 01 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   0   0
1017456 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180005838 580109020006 LA FRANCIS HARDIMAN ELEMENTARY SCH public Regular School No Elementary PK 01 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
1019565 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801001044 580402060005 GOOSEHILL PRIMARY CENTER public Regular School No Elementary KG 01 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
1020648 NY Suffolk   school 3615540 580502020000   ISLIP 361554000331 580502020006 WING ELEMENTARY 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     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1021408 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528004432 580512030002 EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 01 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 0     0   0   0   0
1021541 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000257 580512030010 PINE PARK ELEMENTARY 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 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1027089 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008004767 660301030004 WAVERLY EARLY CHLDHD CENTER public Regular School No Elementary KG 01 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
1027659 NY Westchester   school 3612720 660407060000   GREENBURGH 361272001046 660407060001 LEE F JACKSON 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     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1027773 NY Westchester   school 3610650 660409020000   ELMSFORD 361065000839 660409020001 CARL L DIXSON ELEMENTARY SCHOOL public Regular School No Elementary PK 01 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   0   0
1029388 NY Westchester   school 3622020 661401030000   OSSINING 362202003122 661401030003 PARK SCHOOL public Regular School No Elementary PK 01 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 0     0   0   0   0
1031174 NY Westchester   school 3631920 662300010000   YONKERS 363192006557 662300010058 YONKERS EARLY CHILDHOOD ACADEMY public Regular School No Elementary PK 01 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   0   0
1034632 NY Bronx   school 3601137 320700861080   STOREFRONT ACADEMY CHARTER S 360113706552 320700861080 STOREFRONT ACADEMY CHARTER SCHOOL charter Regular School Yes 1.0 KG 01 2016   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
1035259 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506506 320800010392 BRONX DELTA SCHOOL public Regular School No 1.0 PK 01 2016   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
1037463 NY Bronx   school 3601132 320900861084   SOUTH BRONX CLASSICAL CHARTE 360113206570 320900861084 SOUTH BRONX CLASSICAL CHARTER III charter Regular School Yes 1.0 KG 01 2016   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1037805 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706507 321000010077 BEDFORD PARK ELEMENTARY SCHOOL public Regular School No 1.0 PK 01 2016   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1041206 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006474 321200010458 SAMARA COMMUNITY SCHOOL public Regular School No 1.0 PK 01 2016   grade_8 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
1045139 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000125 80201040003 GUILFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 01 2016   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
1066875 NY Madison   school 3606390 250901060000   CANASTOTA 360639000420 250901060003 PETERBORO STREET ELEMENTARY SCHOOL public Regular School No 1.0 PK 01 2016   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1068034 NY Monroe   school 3614700 260901060000   HONEOYE FALLS-LIMA 361470001224 260901060001 LIMA ELEMENTARY SCHOOL public Regular School No 1.0 KG 01 2016   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
1070238 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000287 261801060002 GINTHER ELEMENTARY SCHOOL public Regular School No 1.0 PK 01 2016   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1072784 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001501 280215030004 LAWRENCE EARLY CHILDHOOD-#4 SCHOOL public Regular School No 1.0 PK 01 2016   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1073031 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176001637 280218030001 HEMLOCK SCHOOL public Regular School No 1.0 KG 01 2016   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
1073050 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000944 280218030002 HOMESTEAD SCHOOL public Regular School No 1.0 KG 01 2016   grade_8 0.0   0.0         0.0     0.0   0.0 0.0             *     0   0 0   0         0     0   0 0             0   0
1073069 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000945 280218030003 LOCUST SCHOOL public Regular School No 1.0 KG 01 2016   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

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