Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_8 · 33,045
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
1018387 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001749 580211060007 EUGENE AUER MEMORIAL SCHOOL public Regular School No Elementary 01 05 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
1018463 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001747 580211060014 STAGECOACH SCHOOL public Regular School No Elementary 01 05 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
1018482 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001740 580211060015 JERICHO ELEMENTARY SCHOOL public Regular School No Elementary 01 05 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
1018520 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001741 580211060017 NEW LANE MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary 01 05 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
1021446 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000251 580512030004 LAUREL PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 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
1021465 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000252 580512030005 LORETTA PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 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
1021484 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No Elementary 01 05 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
1021503 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 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
1021560 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000259 580512030012 SOUTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 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
1021579 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No Elementary 01 05 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
1021712 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687004253 580513030001 CORDELLO AVENUE ELEMENTARY SCHOOL public Regular School No Elementary 01 05 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
1021731 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000476 580513030002 FRANCIS J O'NEILL SCHOOL public Regular School No Elementary 01 05 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
1021750 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000477 580513030003 MARGUERITE L MULVEY SCHOOL public Regular School No Elementary 01 05 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
1021807 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000471 580513030007 ANDREW T MORROW SCHOOL public Regular School No Elementary 01 05 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
1027279 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003891 660401030002 W L MORSE SCHOOL public Regular School No Elementary 01 02 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
1029350 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No Elementary 01 03 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
1047552 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No 1.0 01 05 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
1052093 NY Erie   school 3616230 142601030000   KENMORE 361623004395 142601030019 THEODORE ROOSEVELT ELEMENTARY SCHOOL public Regular School No 1.0 01 5 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
1053917 NY Greene   school 3606720 190401060000   CATSKILL 360672000459 190401060003 CATSKILL SENIOR HIGH SCHOOL public Regular School No 4.0 01 12 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
1072328 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No 1.0 01 06 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
1072347 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No 1.0 01 06 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
1072366 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No 1.0 01 06 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
1072385 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003062 280211030005 SCHOOL 5 public Regular School No 1.0 01 06 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
1072404 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003057 280211030007 SCHOOL 9E-BOARDMAN ELEM SCHOOL public Regular School No 1.0 01 06 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
1072423 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003064 280211030008 SCHOOL 8 public Regular School No 1.0 01 06 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
1072632 NY Nassau   school 3629430 280213020000   VALLEY STR HEMP 13 362943003971 280213020003 WHEELER AVENUE SCHOOL public Regular School No 1.0 01 06 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
1072765 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001500 280215030002 LAWRENCE PRIMARY SCHOOL-#2 SCHOOL public Regular School No 1.0 01 02 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
1073240 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001608 280220030002 MARION STREET SCHOOL public Regular School No 1.0 01 05 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
1073259 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001609 280220030003 WAVERLY PARK SCHOOL public Regular School No 1.0 01 05 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
1073278 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001610 280220030004 WEST END SCHOOL public Regular School No 1.0 01 05 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
1073810 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004121 280227030002 CORNWELL AVENUE SCHOOL public Regular School No 1.0 01 05 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
1073886 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004122 280227030006 GEORGE WASHINGTON SCHOOL public Regular School No 1.0 01 05 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
1074437 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No 1.0 01 05 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
1074456 NY Nassau   school 3630960 280401030000   WESTBURY 363096004157 280401030002 DREXEL AVENUE SCHOOL public Regular School No 1.0 01 05 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
1074494 NY Nassau   school 3630960 280401030000   WESTBURY 363096004160 280401030005 POWELLS LANE SCHOOL public Regular School No 1.0 01 05 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
1074646 NY Nassau   school 3625050 280403030000   ROSLYN 362505003469 280403030007 HARBOR HILL SCHOOL public Regular School No 1.0 01 05 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
1075786 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322004381 280504060001 PASADENA ELEMENTARY SCHOOL public Regular School No 1.0 01 04 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
1075805 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322003254 280504060004 PARKWAY SCHOOL public Regular School No 1.0 01 04 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
1075862 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322003253 280504060012 OLD BETHPAGE SCHOOL public Regular School No 1.0 01 04 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
1077743 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502124 307500015025 SOUTH RICHMOND HIGH SCH IS/PS 25 public Special Education School No 4.0 01 12 2016   grade_8 11.0 23.0 18.0   0.0     2.0     0.0   40.0 14.0             46     53   54 11 23 18   0     2     0   40 14         46   53   54
1088649 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003872 421800010025 HUGHES ELEMENTARY SCHOOL public Regular School No 1.0 01 05 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
1088801 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003852 421800010041 DELAWARE ACADEMY public Regular School No 1.0 01 05 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
1089675 NY Orange   school 3630030 440102060000   WASHINGTONVILLE 363003004036 440102060001 LITTLE BRITAIN ELEMENTARY SCHOOL public Regular School No 1.0 01 05 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
1102823 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003771 500402060002 GRANDVIEW ELEMENTARY SCHOOL public Regular School No 1.0 01 03 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
1102880 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003776 500402060005 MARGETTS ELEMENTARY SCHOOL public Regular School No 1.0 01 03 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
1105198 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003575 530600010003 ELMER AVENUE SCHOOL public Regular School No 1.0 01 06 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
1105369 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003581 530600010018 JESSIE T ZOLLER SCHOOL public Regular School No 1.0 01 08 2016   grade_8 23.0 15.0 10.0         5.0     0.0   29.0 24.0             46     *   53 23 15 10         5     0   29 24         46       53
1105483 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601005996 530600010031 FRANKLIN D ROOSEVELT ELEMENTARY SCH public Regular School No 1.0 01 06 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
1107326 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No 1.0 01 03 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
1107345 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000066 580106030003 PARK AVENUE SCHOOL public Regular School No 1.0 01 06 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
1108447 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001738 580211060002 HAWKINS PATH SCHOOL public Regular School No 1.0 01 05 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
1108466 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001739 580211060003 HOLBROOK ROAD SCHOOL public Regular School No 1.0 01 05 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
1108485 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001743 580211060004 NORTH COLEMAN ROAD SCHOOL public Regular School No 1.0 01 05 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
1108504 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001744 580211060005 OXHEAD ROAD SCHOOL public Regular School No 1.0 01 05 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
1108542 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001749 580211060007 EUGENE AUER MEMORIAL SCHOOL public Regular School No 1.0 01 05 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
1108637 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001740 580211060015 JERICHO ELEMENTARY SCHOOL public Regular School No 1.0 01 05 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
1108675 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001741 580211060017 NEW LANE MEMORIAL ELEMENTARY SCHOOL public Regular School No 1.0 01 06 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
1111620 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000251 580512030004 LAUREL PARK ELEMENTARY SCHOOL public Regular School No 1.0 01 05 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
1111639 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000252 580512030005 LORETTA PARK ELEMENTARY SCHOOL public Regular School No 1.0 01 05 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
1111658 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No 1.0 01 05 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
1111677 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No 1.0 01 05 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
1111734 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000259 580512030012 SOUTHEAST ELEMENTARY SCHOOL public Regular School No 1.0 01 05 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
1111753 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No 1.0 01 05 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
1111886 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687004253 580513030001 CORDELLO AVENUE ELEMENTARY SCHOOL public Regular School No 1.0 01 05 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
1111905 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000476 580513030002 FRANCIS J O'NEILL SCHOOL public Regular School No 1.0 01 05 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
1111924 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000477 580513030003 MARGUERITE L MULVEY SCHOOL public Regular School No 1.0 01 05 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
1111981 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000471 580513030007 ANDREW T MORROW SCHOOL public Regular School No 1.0 01 05 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
1117472 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003891 660401030002 W L MORSE SCHOOL public Regular School No 1.0 01 02 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
1118118 NY Westchester   school 3610140 660411020000   GREENBURGH 11 361014000387 660411020004 GREENBURGH ELEVEN HIGH SCHOOL public Special Education School No 4.0 01 12 2016   grade_8 0.0 1.0 1.0   0.0     0.0     0.0   2.0 0.0             0     *   2 0 1 1   0     0     0   2 0         0       2
1119543 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No 1.0 01 03 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
1445773 NY Chautauqua   school 3611520 62201060000   FREDONIA 361152000906 62201060001 FREDONIA ELEMENTARY SCHOOL public Regular School No Elementary 01 04 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
1448832 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003302 131500010001 WARRING MAGNET ACAD OF SCI & TECH public Regular School No Elementary 01 07 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
1448851 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 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
1448870 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003304 131500010006 G W KRIEGER SCHOOL public Regular School No Elementary 01 05 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
1454779 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 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
1461353 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   grade_8 0.0 49.0 4.0   3.0     0.0     1.0   29.0 28.0     *       40     10   57 0 49 4   3     0     1   29 28         40   10   57
1472069 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 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
1472088 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 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
1472107 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 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
1472126 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 06 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
1472164 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No Elementary 01 05 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
1472202 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004772 280201030011 FRONT STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 05 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
1473437 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 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
1473475 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No Elementary 01 06 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
1473494 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003062 280211030005 SCHOOL 5 public Regular School No Elementary 01 06 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
1473513 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003057 280211030007 SCHOOL 9E-BOARDMAN ELEM SCHOOL public Regular School No Elementary 01 06 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
1473532 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003064 280211030008 SCHOOL 8 public Regular School No Elementary 01 06 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
1473741 NY Nassau   school 3629430 280213020000   VALLEY STR HEMP 13 362943003971 280213020003 WHEELER AVENUE SCHOOL public Regular School No Elementary 01 06 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
1474349 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001608 280220030002 MARION STREET SCHOOL public Regular School No Elementary 01 05 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
1474387 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001610 280220030004 WEST END SCHOOL public Regular School No Elementary 01 05 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
1474919 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004121 280227030002 CORNWELL AVENUE SCHOOL public Regular School No Elementary 01 05 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
1475546 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No Elementary 01 05 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
1475565 NY Nassau   school 3630960 280401030000   WESTBURY 363096004157 280401030002 DREXEL AVENUE SCHOOL public Regular School No Elementary 01 05 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
1475603 NY Nassau   school 3630960 280401030000   WESTBURY 363096004160 280401030005 POWELLS LANE SCHOOL public Regular School No Elementary 01 05 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
1476135 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001021 280407030008 LAKEVILLE ELEMENTARY SCHOOL public Regular School No Elementary 01 05 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
1478681 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504480 307500014023 PS 23 AT QUEENS CHILDREN CENTER public Special Education School No Other 01 12 2021   grade_8 6.0 8.0 7.0   2.0     1.0     0.0   15.0 9.0     0       22     20   24 6 8 7   2     1     0   15 9     0   22   20   24
1478909 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502124 307500015025 SOUTH RICHMOND HIGH SCH IS/PS 25 public Special Education School No Other 01 12 2021   grade_8 13.0 30.0 14.0   0.0     1.0     1.0   49.0 10.0     *       54     59   59 13 30 14   0     1     1   49 10         54   59   59
1483659 NY New York   school 3600142 310400861061   NYC AUTISM CHARTER-EAST HARLE 360014205779 310400861061 NYC AUTISM CHARTER SCHOOL EAST HARLE charter Special Education School Yes Other 01 12 2021   grade_8 0.0 1.0 0.0   0.0     0.0     0.0   1.0 0.0     *       *     *   1 0 1 0   0     0     0   1 0                 1
1490670 NY Orange   school 3630030 440102060000   WASHINGTONVILLE 363003004036 440102060001 LITTLE BRITAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 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
1492019 NY Orange   school 3629970 442101060000   WARWICK VALLEY 362997004032 442101060004 PARK AVENUE ELEMENTARY SCHOOL public Regular School No Elementary 01 04 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

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