Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_9" and state = "NY" sorted by white

View and edit SQL

year

grade

  • grade_9 · 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
975068 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012105724 332300010522 MOTT HALL IV public Regular School No Middle 06 08 2017   grade_9   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
975296 NY Kings   school 3601032 332300860936   OCEAN HILL COLLEGIATE CHA 360103206229 332300860936 OCEAN HILL COLLEGIATE CHARTER SCH charter Regular School Yes Middle 05 08 2017   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0   0 0   0     0     0   0 0         0   0   0
981927 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003460 280208030002 CENTENNIAL AVENUE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_9   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
981946 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003464 280208030003 ULYSSES BYAS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_9   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
981965 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003465 280208030004 WASHINGTON ROSE SCHOOL public Regular School No Elementary PK 06 2017   grade_9   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
981984 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003463 280208030005 ROOSEVELT HIGH SCHOOL public Regular School No High 09 12 2017   grade_9   123.0 125.0                   130.0 118.0     59       135     29   248   123 125                   130 118     59   135   29   248
982003 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499005611 280208030009 ROOSEVELT MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_9   0.0 0.0               0.0   0.0 0.0     0       0     0   0   0 0               0   0 0     0   0   0   0
990344 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705500 310200011542 MANHATTAN BRIDGES HIGH SCHOOL public Regular School No High 09 12 2017   grade_9   0.0 154.0         1.0     1.0   71.0 85.0     94       100     20   156   0 154         1     1   71 85     94   100   20   156
991408 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007806145 310300011404 INNOVATION DIPLOMA PLUS public Regular School No High 09 12 2017   grade_9   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
992187 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007906096 310400010406 GLOBAL TECHNOLOGY PREPARATORY public Regular School No Middle 06 08 2017   grade_9   0.0 0.0         0.0         0.0 0.0     0       0     0   0   0 0         0         0 0     0   0   0   0
992567 NY New York   school 3601144 310400861081   CAPITAL PREP (CP) HARLEM CHA 360114406597 310400861081 CAPITAL PREP (CP) HARLEM CHARTER charter Regular School Yes Middle 06 07 2017   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0   0 0   0     0     0   0 0         0   0   0
993992 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305871 310600010349 HARBOR HEIGHTS public Regular School No Middle 06 08 2017   grade_9     0.0               0.0   0.0 0.0     0       0     *   0     0               0   0 0     0   0       0
994277 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008301265 310600011552 GREGORIO LUPERON HS-SCI & MATH public Regular School No High 09 12 2017   grade_9     101.0                   37.0 64.0     *       100     *   101     101                   37 64         100       101
994733 NY Niagara   school 3620850 400701060000   NIAGARA WHEATFIELD 362085002954 400701060003 TUSCARORA ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_9     0.0   0.0           0.0   0.0 0.0             0     0   0     0   0           0   0 0         0   0   0
997545 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001449 420807040002 ONONDAGA NATION SCHOOL public Regular School No Elementary PK 08 2017   grade_9         0.0           0.0   0.0 0.0             0     0   0         0           0   0 0         0   0   0
1003701 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806084 342400011296 PAN AMERICAN INTERNATIONAL HS public Regular School No High 09 12 2017   grade_9     119.0   1.0               69.0 51.0     119       111     *   120     119   1               69 51     119   111       120
1008071 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102563 342900010156 PS 156 LAURELTON public Regular School No Elementary PK 05 2017   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
1008337 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010106550 342900010360 PS 360 public Regular School No Elementary PK 05 2017   grade_9   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
1027869 NY Westchester   school 3612400 660410020000   GREENBURGH-GRAHAM 361240006299 660410020003 ZICCOLELLA MIDDLE SCHOOL public Special Education School No Other 06 09 2017   grade_9   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
1033740 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405118 320700010179 PS 179 public Regular School No 1.0 PK 05 2016   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1033911 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406020 320700010385 PERFORMANCE SCHOOL public Regular School No 2.0 05 05 2016   grade_9   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
1034614 NY Bronx   school 3601125 320700861070   FAMILY LIFE ACADEMY CHARTER 360112506479 320700861070 FAMILY LIFE ACADEMY CHARTER SCH III charter Regular School Yes 1.0 KG 02 2016   grade_9   0.0 0.0         0.0     0.0   0.0 0.0             0     0   0   0 0         0     0   0 0         0   0   0
1035241 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505986 320800010375 BRONX MATHEMATICS PREP SCH (THE) public Regular School No 2.0 06 08 2016   grade_9   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1036096 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605542 320900010064 PS 64 PURA BELPRE public Regular School No 2.0 05 05 2016   grade_9   0.0 0.0   0.0               0.0 0.0             0     0   0   0 0   0               0 0         0   0   0
1036153 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602338 320900010088 PS 88 S SILVERSTEIN LITTLE SPARROW public Regular School No 1.0 KG 03 2016   grade_9   0.0 0.0               0.0   0.0 0.0             0     0   0   0 0               0   0 0         0   0   0
1036476 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604355 320900010230 PS 230 DR ROLAND N PATTERSON public Regular School No 1.0 KG 06 2016   grade_9   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1036609 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603767 320900010313 IS 313 SCHOOL OF LEADERSHIP DEV public Regular School No 2.0 05 08 2016   grade_9   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
1036685 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605667 320900010328 NEW MILLENNIUM BUSINESS ACAD MS public Regular School No 2.0 06 08 2016   grade_9   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1037065 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No 4.0 06 10 2016   grade_9   17.0 30.0   0.0     1.0         25.0 23.0             42     14   48   17 30   0     1         25 23         42   14   48
1037084 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No 3.0 09 12 2016   grade_9     86.0                   42.0 44.0             85     *   86     86                   42 44         85       86
1037179 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605178 320900011414 J LEVIN HIGH SCHOOL-MEDIA & COMMUN public Regular School No 3.0 12 12 2016   grade_9   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
1037426 NY Bronx   school 3601071 320900861004   MOTT HALL CHARTER SCHOOL 360107106328 320900861004 MOTT HALL CHARTER SCHOOL charter Regular School Yes 2.0 06 08 2016   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1038452 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706057 321000010382 ELEM SCHOOL FOR MATH, SCIENCE, TECH public Regular School No 1.0 KG 05 2016   grade_9   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1038699 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705760 321000011319 PULSE HIGH SCHOOL public Alternative Education School No 3.0 09 12 2016   grade_9   5.0 15.0   0.0               13.0 7.0             17     *   20   5 15   0               13 7         17       20
1040675 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002219 321200010050 PS 50 CLARA BARTON public Regular School No 2.0 05 05 2016   grade_9   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
1041378 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No 3.0 09 12 2016   grade_9     156.0                   76.0 80.0             154     5   156     156                   76 80         154   5   156
1050251 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 4 2016   grade_9   0.0 0.0   0.0           0.0   0.0 0.0             0     0   0   0 0   0           0   0 0         0   0   0
1055723 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009104483 331300010266 MS 266 PARK PLACE COMMUNITY MS public Regular School No 2.0 06 8 2016   grade_9   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1055856 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009105696 331300010313 SATELLITE WEST MIDDLE SCHOOL public Regular School No 2.0 06 8 2016   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1056939 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011905816 331400011322 FOUNDATIONS ACADEMY public Regular School No 3.0 09 12 2016   grade_9   16.0 3.0         0.0         10.0 9.0             16     *   19   16 3         0         10 9         16       19
1056958 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011905813 331400011330 URBAN ASSEMBLY SCHOOL-URBAN ENVR public Regular School No 2.0 06 8 2016   grade_9   0.0 0.0   0.0               0.0 0.0             0     0   0   0 0   0               0 0         0   0   0
1058535 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009402163 331600010035 MS 35 STEPHEN DECATUR public Regular School No 2.0 06 8 2016   grade_9   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1058592 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009402320 331600010081 PS 81 THADDEUS STEVENS public Regular School No 1.0 PK 5 2016   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1058744 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009405518 331600010393 FREDERICK DOUGLASS ACADEMY IV public Regular School No 3.0 09 12 2016   grade_9   14.0 1.0   0.0               5.0 10.0             14     6   15   14 1   0               5 10         14   6   15
1058763 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009405904 331600010534 UPPER SCHOOL AT PS 25 public Regular School No 2.0 06 8 2016   grade_9   0.0 0.0         0.0     0.0   0.0 0.0             0     0   0   0 0         0     0   0 0         0   0   0
1058782 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009405707 331600010584 MS 584 public Regular School No 2.0 06 8 2016   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1059352 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502656 331700010191 PS 191 PAUL ROBESON public Regular School No 1.0 PK 5 2016   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1060036 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505762 331700011568 BROWNSVILLE ACADEMY HIGH SCHOOL public Alternative Education School No 3.0 10 12 2016   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1060131 NY Kings   school 3600157 331700860841   EXPLORE CHARTER SCHOOL 360015705846 331700860841 EXPLORE CHARTER SCHOOL charter Regular School Yes 1.0 KG 8 2016   grade_9   0.0 0.0   0.0           0.0   0.0 0.0             0     0   0   0 0   0           0   0 0         0   0   0
1060739 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009605956 331800011566 BROOKLYN GENERATION SCHOOL public Regular School No 3.0 08 12 2016   grade_9   62.0 8.0   0.0     0.0     2.0   47.0 25.0             59     25   72   62 8   0     0     2   47 25         59   25   72
1061119 NY Kings   school 3601092 331800861057   NEW AMERICAN ACAD CHARTER SC 360109206415 331800861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter Regular School Yes 1.0 KG 3 2016   grade_9   0.0 0.0               0.0   0.0 0.0             0     0   0   0 0               0   0 0         0   0   0
1061195 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012003000 331900010089 PS 89 CYPRESS HILLS public Regular School No 1.0 PK 8 2016   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1061309 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012002611 331900010174 PS 174 DUMONT public Regular School No 2.0 05 5 2016   grade_9   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
1061632 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012005895 331900010452 FDA VIII MIDDLE SCHOOL public Regular School No 2.0 06 8 2016   grade_9   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
1062107 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes 4.0 02 12 2016   grade_9   60.0 20.0   1.0     3.0         44.0 40.0             75     12   84   60 20   1     3         44 40         75   12   84
1062202 NY Kings   school 3601109 331900860993   ACHIEVEMENT FIRST ASPIRE CHA 360110906421 331900860993 ACHIEVEMENT FIRST ASPIRE CHARTER charter Regular School Yes 1.0 KG 3 2016   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1062221 NY Kings   school 3601050 331900860997   INVICTUS PREPARATORY CHARTER 360105006293 331900860997 INVICTUS PREPARATORY CHARTER SCHOOL charter Regular School Yes 2.0 05 8 2016   grade_9   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1064748 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012102299 332300010073 PS 73 THOMAS S BOYLAND public Regular School No 2.0 05 08 2016   grade_9   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
1065052 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012105722 332300010514 FREDERICK DOUGLASS ACADEMY VII public Regular School No 3.0 09 12 2016   grade_9   47.0 6.0         2.0     1.0   31.0 25.0             53     22   56   47 6         2     1   31 25         53   22   56
1065090 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012105724 332300010522 MOTT HALL IV public Regular School No 2.0 06 08 2016   grade_9   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
1065147 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012106428 332300010668 RIVERDALE AVENUE MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_9   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1065185 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012105721 332300011493 BROOKLYN COLLEGIATE public Regular School No 3.0 08 12 2016   grade_9   81.0 10.0   1.0     1.0         65.0 28.0             82     24   93   81 10   1     1         65 28         82   24   93
1065375 NY Kings   school 3601016 332300860942   LEADERSHIP PREP BROWNSVILLE 360101606201 332300860942 LEADERSHIP PREP BROWNSVILLE CHARTER charter Regular School Yes 1.0 KG 07 2016   grade_9   0.0 0.0   0.0           0.0   0.0 0.0             0     0   0   0 0   0           0   0 0         0   0   0
1065394 NY Kings   school 3601002 332300860954   BROWNSVILLE ASCEND CHARTER 360100206167 332300860954 BROWNSVILLE ASCEND CHARTER SCHOOL charter Regular School Yes 1.0 KG 07 2016   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1071930 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003460 280208030002 CENTENNIAL AVENUE ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2016   grade_9   0.0 0.0               0.0   0.0 0.0             0     0   0   0 0               0   0 0         0   0   0
1071949 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003464 280208030003 ULYSSES BYAS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2016   grade_9   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
1071968 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003465 280208030004 WASHINGTON ROSE SCHOOL public Regular School No 1.0 PK 07 2016   grade_9   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
1071987 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003463 280208030005 ROOSEVELT HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_9   112.0 129.0               0.0   127.0 114.0             157     26   241   112 129               0   127 114         157   26   241
1072006 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499005611 280208030009 ROOSEVELT MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_9   0.0 0.0               0.0   0.0 0.0             0     0   0   0 0               0   0 0         0   0   0
1082076 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007902560 310400010155 PS 155 WILLIAM PACA public Regular School No 1.0 PK 05 2016   grade_9   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1083881 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008302872 310600010210 PS/IS 210 21ST CENTURY ACADEMY public Regular School No 1.0 PK 08 2016   grade_9   0.0 0.0         0.0     0.0   0.0 0.0             0     0   0   0 0         0     0   0 0         0   0   0
1084109 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305871 310600010349 HARBOR HEIGHTS public Regular School No 2.0 06 08 2016   grade_9     0.0                   0.0 0.0             0     *   0     0                   0 0         0       0
1084280 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008306099 310600011423 HIGH SCH-EXCELLENCE AND INNOVATION public Regular School No 3.0 09 12 2016   grade_9   7.0 45.0   1.0     0.0         26.0 27.0             46     21   53   7 45   1     0         26 27         46   21   53
1084394 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008301265 310600011552 GREGORIO LUPERON HS-SCI & MATH public Regular School No 3.0 09 12 2016   grade_9     114.0               1.0   64.0 51.0             115     *   115     114               1   64 51         115       115
1084812 NY Niagara   school 3620850 400701060000   NIAGARA WHEATFIELD 362085002954 400701060003 TUSCARORA ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_9     0.0   0.0           0.0   0.0 0.0             0     0   0     0   0           0   0 0         0   0   0
1087624 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001449 420807040002 ONONDAGA NATION SCHOOL public Regular School No 1.0 PK 08 2016   grade_9         0.0           0.0   0.0 0.0             0     0   0         0           0   0 0         0   0   0
1093761 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806084 342400011296 PAN AMERICAN INTERNATIONAL HS public Regular School No 3.0 08 12 2016   grade_9     91.0         0.0         50.0 41.0             91     *   91     91         0         50 41         91       91
1097295 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010006518 342800010312 JAMAICA CHILDREN'S SCHOOL public Regular School No 1.0 KG 01 2016   grade_9   0.0 0.0         0.0     0.0   0.0 0.0             0     0   0   0 0         0     0   0 0         0   0   0
1097694 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102089 342900010015 PS 15 JACKIE ROBINSON public Regular School No 1.0 PK 05 2016   grade_9   0.0 0.0         0.0     0.0   0.0 0.0             0     0   0   0 0         0     0   0 0         0   0   0
1098245 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010105546 342900010270 GORDON PARKS SCHOOL (THE) public Regular School No 1.0 PK 08 2016   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1098340 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010106550 342900010360 PS 360 public Regular School No 1.0 PK KG 2016   grade_9   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
1098549 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010101409 342900011494 LAW/GOVERNMENT, COMMUNITY SERVICE public Regular School No 3.0 10 12 2016   grade_9   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
1098568 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010101411 342900011496 BUSINESS/COMPTR APP & ENTREPRE public Regular School No 3.0 11 12 2016   grade_9   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
1118062 NY Westchester   school 3612400 660410020000   GREENBURGH-GRAHAM 361240006299 660410020003 ZICCOLELLA MIDDLE SCHOOL public Special Education School No 2.0 06 09 2016   grade_9   0.0 1.0                   0.0 1.0             *     *   1   0 1                   0 1                 1
1435001 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405786 320700010298 ACADEMY OF PUBLIC RELATIONS public Regular School No Middle 06 08 2021   grade_9   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
1435381 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406714 320700011625 WALKABOUT BRONX HIGH SCHOOL public Regular School No Secondary 09 09 2021   grade_9   21.0 30.0                   19.0 32.0     *       42     8   51   21 30                   19 32         42   8   51
1435533 NY Bronx   school 3600959 320700860926   NYC CHARTER HS - AECI 360095906073 320700860926 NYC CHARTER HS - AECI charter Regular School Yes High 09 12 2021   grade_9   62.0 87.0   0.0               103.0 46.0     18       145     41   149   62 87   0               103 46     18   145   41   149
1435970 NY Bronx   school 3601217 320700861179   GIRLS PREP CHARTER SCHOOL - 360121706715 320700861179 GIRLS PREP CHARTER SCHOOL - BRONX II charter Regular School Yes Elementary PK KG 2021   grade_9   0.0 0.0         0.0     0.0     0.0             0     0   0   0 0         0     0     0         0   0   0
1436008 NY Bronx   school 3601219 320700861182   ZETA CHARTER SCHOOL - NYC 4 360121906717 320700861182 ZETA CHARTER SCHOOL - BRONX 2 charter Regular School Yes Elementary KG KG 2021   grade_9   0.0 0.0               0.0   0.0 0.0     *       0     0   0   0 0               0   0 0         0   0   0
1437794 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602751 320900010236 PS 236 LANGSTON HUGHES public Regular School No Elementary PK 05 2021   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
1438269 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605861 320900011263 VALIDUS PREP ACADEMY public Regular School No High 09 12 2021   grade_9   37.0 65.0   1.0     0.0     0.0   68.0 35.0     17       100     30   103   37 65   1     0     0   68 35     17   100   30   103
1438364 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2021   grade_9     97.0                   57.0 40.0     97       95     *   97     97                   57 40     97   95       97
1438592 NY Bronx   school 3600049 320900860835   ICAHN CHARTER SCHOOL 1 360004904470 320900860835 ICAHN CHARTER SCHOOL 1 charter Regular School Yes Elementary KG 08 2021   grade_9   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
1438611 NY Bronx   school 3600066 320900860839   FAMILY LIFE ACAD CHARTER 360006604877 320900860839 FAMILY LIFE ACADEMY CHARTER charter Regular School Yes Elementary KG 05 2021   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
1438782 NY Bronx   school 3601220 320900861174   WILDFLOWER NEW YORK CHARTER 360122006718 320900861174 WILDFLOWER NEW YORK CHARTER SCHOOL charter Regular School Yes Elementary PK 01 2021   grade_9   0.0 0.0                   0.0 0.0     *       0     *   0   0 0                   0 0         0       0
1438877 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701748 321000010015 PS 15 INST FOR ENVIRON LRNG public Regular School No Elementary KG 08 2021   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
1439371 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008700739 321000010209 PS 209 public Regular School No Elementary PK 02 2021   grade_9   0.0 0.0         0.0         0.0 0.0     0       0     0   0   0 0         0         0 0     0   0   0   0
1439409 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704731 321000010226 PS 226 public Regular School No Elementary PK 05 2021   grade_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
1439770 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706057 321000010382 ELEM SCHOOL FOR MATH, SCIENCE, TECH public Regular School No Elementary KG 05 2021   grade_9   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
1440036 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705938 321000011342 INTERNATIONAL SCHOOL FOR LIBERAL ART public Regular School No High 06 12 2021   grade_9     99.0                   63.0 36.0     82       98     18   99     99                   63 36     82   98   18   99

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