Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_2 · 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
975061 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012105724 332300010522 MOTT HALL IV public Regular School No Middle 06 08 2017   grade_2   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
975289 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_2   0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0   0 0   0     0     0   0 0         0   0   0
981920 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003460 280208030002 CENTENNIAL AVENUE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2   55.0 29.0                   36.0 48.0     31       64     11   84   55 29                   36 48     31   64   11   84
981939 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003464 280208030003 ULYSSES BYAS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2   34.0 34.0                   38.0 30.0     25       48     *   68   34 34                   38 30     25   48       68
981958 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003465 280208030004 WASHINGTON ROSE SCHOOL public Regular School No Elementary PK 06 2017   grade_2   64.0 41.0                   52.0 53.0     37       73     9   105   64 41                   52 53     37   73   9   105
981977 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003463 280208030005 ROOSEVELT HIGH SCHOOL public Regular School No High 09 12 2017   grade_2   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
981996 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499005611 280208030009 ROOSEVELT MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_2   0.0 0.0               0.0   0.0 0.0     0       0     0   0   0 0               0   0 0     0   0   0   0
990337 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_2   0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0   0 0         0     0   0 0     0   0   0   0
991401 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_2   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
992180 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_2   0.0 0.0         0.0         0.0 0.0     0       0     0   0   0 0         0         0 0     0   0   0   0
992560 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_2   0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0   0 0   0     0     0   0 0         0   0   0
993985 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305871 310600010349 HARBOR HEIGHTS public Regular School No Middle 06 08 2017   grade_2     0.0               0.0   0.0 0.0     0       0     *   0     0               0   0 0     0   0       0
994270 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_2     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
994726 NY Niagara   school 3620850 400701060000   NIAGARA WHEATFIELD 362085002954 400701060003 TUSCARORA ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2     0.0   12.0           2.0   5.0 9.0             8     0   14     0   12           2   5 9         8   0   14
997538 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001449 420807040002 ONONDAGA NATION SCHOOL public Regular School No Elementary PK 08 2017   grade_2         22.0           1.0   11.0 12.0             20     0   23         22           1   11 12         20   0   23
1003694 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_2     0.0   0.0               0.0 0.0     0       0     0   0     0   0               0 0     0   0   0   0
1008064 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102563 342900010156 PS 156 LAURELTON public Regular School No Elementary PK 05 2017   grade_2   43.0 3.0   0.0     3.0     0.0   28.0 21.0     *       38     7   49   43 3   0     3     0   28 21         38   7   49
1008330 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010106550 342900010360 PS 360 public Regular School No Elementary PK 05 2017   grade_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
1027862 NY Westchester   school 3612400 660410020000   GREENBURGH-GRAHAM 361240006299 660410020003 ZICCOLELLA MIDDLE SCHOOL public Special Education School No Other 06 09 2017   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
1033733 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405118 320700010179 PS 179 public Regular School No 1.0 PK 05 2016   grade_2   8.0 40.0   0.0     1.0     0.0   24.0 25.0             47     13   49   8 40   0     1     0   24 25         47   13   49
1033904 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406020 320700010385 PERFORMANCE SCHOOL public Regular School No 2.0 05 05 2016   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
1034607 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_2   23.0 26.0         0.0     0.0   25.0 24.0             49     10   49   23 26         0     0   25 24         49   10   49
1035234 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_2   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1036089 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_2   0.0 0.0   0.0               0.0 0.0             0     0   0   0 0   0               0 0         0   0   0
1036146 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_2   16.0 36.0               1.0   19.0 34.0             45     7   53   16 36               1   19 34         45   7   53
1036469 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_2   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1036602 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_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
1036678 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_2   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1037058 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_2   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1037077 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_2     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
1037172 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_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
1037419 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_2   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1038445 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_2   14.0 35.0   0.0     0.0         26.0 23.0             49     5   49   14 35   0     0         26 23         49   5   49
1038692 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_2   0.0 0.0   0.0               0.0 0.0             0     0   0   0 0   0               0 0         0   0   0
1040668 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_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
1041371 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_2     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
1050244 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_2   52.0 8.0   0.0           0.0   31.0 29.0             60     8   60   52 8   0           0   31 29         60   8   60
1055716 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_2   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1055849 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_2   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1056932 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011905816 331400011322 FOUNDATIONS ACADEMY public Regular School No 3.0 09 12 2016   grade_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
1056951 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_2   0.0 0.0   0.0               0.0 0.0             0     0   0   0 0   0               0 0         0   0   0
1058528 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_2   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1058585 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_2   27.0 14.0   0.0     0.0     0.0   16.0 25.0             38     *   41   27 14   0     0     0   16 25         38       41
1058737 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_2   0.0 0.0   0.0               0.0 0.0             0     0   0   0 0   0               0 0         0   0   0
1058756 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_2   0.0 0.0         0.0     0.0   0.0 0.0             0     0   0   0 0         0     0   0 0         0   0   0
1058775 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009405707 331600010584 MS 584 public Regular School No 2.0 06 8 2016   grade_2   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1059345 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_2   18.0 5.0   0.0     0.0     0.0   12.0 11.0             22     *   23   18 5   0     0     0   12 11         22       23
1060029 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_2   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1060124 NY Kings   school 3600157 331700860841   EXPLORE CHARTER SCHOOL 360015705846 331700860841 EXPLORE CHARTER SCHOOL charter Regular School Yes 1.0 KG 8 2016   grade_2   49.0 9.0   2.0           2.0   25.0 37.0             53     10   62   49 9   2           2   25 37         53   10   62
1060732 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_2   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1061112 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_2   64.0 2.0               0.0   34.0 32.0             38     14   66   64 2               0   34 32         38   14   66
1061188 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_2   2.0 38.0   0.0     0.0     0.0   21.0 19.0             39     10   40   2 38   0     0     0   21 19         39   10   40
1061302 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_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
1061625 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_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
1062100 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes 4.0 02 12 2016   grade_2   1.0 0.0   0.0     0.0         0.0 1.0             *     0   1   1 0   0     0         0 1             0   1
1062195 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_2   74.0 17.0   2.0     1.0     1.0   42.0 53.0             78     14   95   74 17   2     1     1   42 53         78   14   95
1062214 NY Kings   school 3601050 331900860997   INVICTUS PREPARATORY CHARTER 360105006293 331900860997 INVICTUS PREPARATORY CHARTER SCHOOL charter Regular School Yes 2.0 05 8 2016   grade_2   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1064741 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_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
1065045 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_2   0.0 0.0         0.0     0.0   0.0 0.0             0     0   0   0 0         0     0   0 0         0   0   0
1065083 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_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
1065140 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_2   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1065178 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012105721 332300011493 BROOKLYN COLLEGIATE public Regular School No 3.0 08 12 2016   grade_2   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1065368 NY Kings   school 3601016 332300860942   LEADERSHIP PREP BROWNSVILLE 360101606201 332300860942 LEADERSHIP PREP BROWNSVILLE CHARTER charter Regular School Yes 1.0 KG 07 2016   grade_2   75.0 10.0   2.0           1.0   41.0 47.0             77     16   88   75 10   2           1   41 47         77   16   88
1065387 NY Kings   school 3601002 332300860954   BROWNSVILLE ASCEND CHARTER 360100206167 332300860954 BROWNSVILLE ASCEND CHARTER SCHOOL charter Regular School Yes 1.0 KG 07 2016   grade_2   103.0 12.0   0.0     0.0     0.0   60.0 55.0             68     15   115   103 12   0     0     0   60 55         68   15   115
1071923 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003460 280208030002 CENTENNIAL AVENUE ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2016   grade_2   50.0 26.0               0.0   37.0 39.0             24     7   76   50 26               0   37 39         24   7   76
1071942 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003464 280208030003 ULYSSES BYAS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2016   grade_2   72.0 32.0                   64.0 40.0             31     15   104   72 32                   64 40         31   15   104
1071961 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003465 280208030004 WASHINGTON ROSE SCHOOL public Regular School No 1.0 PK 07 2016   grade_2   69.0 41.0                   53.0 57.0             37     *   110   69 41                   53 57         37       110
1071980 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003463 280208030005 ROOSEVELT HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_2   0.0 0.0               0.0   0.0 0.0             0     0   0   0 0               0   0 0         0   0   0
1071999 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499005611 280208030009 ROOSEVELT MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_2   0.0 0.0               0.0   0.0 0.0             0     0   0   0 0               0   0 0         0   0   0
1082069 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_2   6.0 46.0   2.0     0.0         26.0 28.0             54     21   54   6 46   2     0         26 28         54   21   54
1083874 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_2   0.0 50.0         1.0     0.0   33.0 18.0             47     16   51   0 50         1     0   33 18         47   16   51
1084102 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_2     0.0                   0.0 0.0             0     *   0     0                   0 0         0       0
1084273 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_2   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1084387 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_2     0.0               0.0   0.0 0.0             0     0   0     0               0   0 0         0   0   0
1084805 NY Niagara   school 3620850 400701060000   NIAGARA WHEATFIELD 362085002954 400701060003 TUSCARORA ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_2     1.0   11.0           2.0   5.0 9.0             10     *   14     1   11           2   5 9         10       14
1087617 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001449 420807040002 ONONDAGA NATION SCHOOL public Regular School No 1.0 PK 08 2016   grade_2         11.0           0.0   9.0 2.0             10     *   11         11           0   9 2         10       11
1093754 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_2     0.0         0.0         0.0 0.0             0     0   0     0         0         0 0         0   0   0
1097288 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_2   0.0 0.0         0.0     0.0   0.0 0.0             0     0   0   0 0         0     0   0 0         0   0   0
1097687 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_2   70.0 5.0         1.0     0.0   39.0 37.0             56     16   76   70 5         1     0   39 37         56   16   76
1098238 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_2   65.0 0.0   0.0     1.0     0.0   35.0 31.0             39     9   66   65 0   0     1     0   35 31         39   9   66
1098333 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010106550 342900010360 PS 360 public Regular School No 1.0 PK KG 2016   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
1098542 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_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
1098561 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_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
1118055 NY Westchester   school 3612400 660410020000   GREENBURGH-GRAHAM 361240006299 660410020003 ZICCOLELLA MIDDLE SCHOOL public Special Education School No 2.0 06 09 2016   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
1434994 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_2   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
1435374 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_2   0.0 0.0                   0.0 0.0     *       0     0   0   0 0                   0 0         0   0   0
1435526 NY Bronx   school 3600959 320700860926   NYC CHARTER HS - AECI 360095906073 320700860926 NYC CHARTER HS - AECI charter Regular School Yes High 09 12 2021   grade_2   0.0 0.0   0.0               0.0 0.0     0       0     0   0   0 0   0               0 0     0   0   0   0
1435963 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_2   0.0 0.0         0.0     0.0     0.0             0     0   0   0 0         0     0     0         0   0   0
1436001 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_2   0.0 0.0               0.0   0.0 0.0     *       0     0   0   0 0               0   0 0         0   0   0
1437787 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_2   2.0 38.0   0.0     0.0     0.0   22.0 18.0     5       40     14   40   2 38   0     0     0   22 18     5   40   14   40
1438262 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605861 320900011263 VALIDUS PREP ACADEMY public Regular School No High 09 12 2021   grade_2   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
1438357 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_2     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1438585 NY Bronx   school 3600049 320900860835   ICAHN CHARTER SCHOOL 1 360004904470 320900860835 ICAHN CHARTER SCHOOL 1 charter Regular School Yes Elementary KG 08 2021   grade_2   20.0 17.0   0.0     1.0         17.0 21.0     6       32     *   38   20 17   0     1         17 21     6   32       38
1438604 NY Bronx   school 3600066 320900860839   FAMILY LIFE ACAD CHARTER 360006604877 320900860839 FAMILY LIFE ACADEMY CHARTER charter Regular School Yes Elementary KG 05 2021   grade_2   14.0 35.0   0.0     0.0     0.0   26.0 23.0     *       46     5   49   14 35   0     0     0   26 23         46   5   49
1438775 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_2   0.0 0.0                   0.0 0.0     *       0     *   0   0 0                   0 0         0       0
1438870 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_2   3.0 38.0   0.0     2.0     0.0   23.0 20.0     14       37     11   43   3 38   0     2     0   23 20     14   37   11   43
1439364 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008700739 321000010209 PS 209 public Regular School No Elementary PK 02 2021   grade_2   18.0 55.0         0.0         30.0 43.0     11       71     21   73   18 55         0         30 43     11   71   21   73
1439402 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704731 321000010226 PS 226 public Regular School No Elementary PK 05 2021   grade_2   10.0 48.0   0.0     0.0     0.0   26.0 32.0     19       57     11   58   10 48   0     0     0   26 32     19   57   11   58
1439763 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_2   6.0 36.0   1.0     1.0         27.0 17.0     9       43     12   44   6 36   1     1         27 17     9   43   12   44
1440029 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_2     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]);