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,145
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white ▼ black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
747141 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405533 320700010157 PS 157 GROVE HILL public Regular School No 1.0 PK 05 2015   grade_2   33.0 77.0         0.0     0.0   42.0 68.0             105     22   110   33 77         0     0   42 68         105   22   110
747217 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405119 320700010203 MS 203 public Regular School No 4.0 08 08 2015   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
747882 NY Bronx   school 3600963 320700860920   UNIVERSITY PREP CHARTER HIGH 360096306039 320700860920 UNIVERSITY PREP CHARTER HIGH SCHOOL charter Regular School Yes 3.0 09 12 2015   grade_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
748053 NY Bronx   school 3601070 320700861028   FAMILY LIFE ACADEMY CHARTER 360107006318 320700861028 FAMILY LIFE ACADEMY CHARTER SCH II charter Regular School Yes 1.0 KG 03 2015   grade_2   24.0 52.0                   36.0 40.0             76     8   76   24 52                   36 40         76   8   76
748110 NY Bronx   school 3601125 320700861070   FAMILY LIFE ACADEMY CHARTER 360112506479 320700861070 FAMILY LIFE ACADEMY CHARTER SCH III charter Regular School Yes 1.0 KG 01 2015   grade_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
749193 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506348 320800011559 SCHOOL FOR TOURISM AND HOSPITALITY public Regular School No 4.0 09 11 2015   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
749516 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602238 320900010055 PS 55 BENJAMIN FRANKLIN public Regular School No 1.0 PK 05 2015   grade_2   54.0 56.0   0.0     1.0         51.0 60.0             103     22   111   54 56   0     1         51 60         103   22   111
749630 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 2015   grade_2   12.0 38.0         1.0     1.0   22.0 30.0             42     12   52   12 38         1     1   22 30         42   12   52
750542 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No 2.0 06 08 2015   grade_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
750561 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 2015   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
750922 NY Bronx   school 3601071 320900861004   MOTT HALL CHARTER SCHOOL 360107106328 320900861004 MOTT HALL CHARTER SCHOOL charter Regular School Yes 2.0 06 08 2015   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
751929 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 2015   grade_2   10.0 32.0   0.0               25.0 17.0             41     7   42   10 32   0               25 17         41   7   42
752176 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705760 321000011319 PULSE HIGH SCHOOL public Alternative Education School No 3.0 09 12 2015   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
753905 NY Bronx   school 3600113 321100860859   BRONX CHARTER SCH-EXCELLENCE 360011305688 321100860859 BRONX CHARTER SCH-EXCELLENCE charter Regular School Yes 1.0 KG 08 2015   grade_2   43.0 22.0   0.0     20.0         42.0 43.0             62     11   85   43 22   0     20         42 43         62   11   85
754114 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002260 321200010061 PS 61 FRANCISCO OLLER public Regular School No 1.0 PK 05 2015   grade_2   15.0 34.0   0.0     0.0         34.0 15.0             48     16   49   15 34   0     0         34 15         48   16   49
754608 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006474 321200010458 SAMARA COMMUNITY SCHOOL public Regular School No 1.0 PK KG 2015   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
754779 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 2015   grade_2     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
754855 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009000744 321200011480 BRONX REGIONAL HIGH SCHOOL public Alternative Education School No 3.0 10 12 2015   grade_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
763633 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes 1 KG 4 2015   grade_2   62.0 7.0         0.0     2.0   31.0 40.0             69     13   71   62 7         0     2   31 40         69   13   71
769257 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009105696 331300010313 SATELLITE WEST MIDDLE SCHOOL public Regular School No 2 06 8 2015   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
769295 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009105968 331300010596 MS 596 PEACE ACADEMY public Regular School No 2 06 8 2015   grade_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
769713 NY Kings   school 3601033 331300860937   BROOKLYN EAST COLLEGIATE 360103306240 331300860937 BROOKLYN EAST COLLEGIATE CHARTER SCH charter Regular School Yes 2 05 9 2015   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
770359 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011905816 331400011322 FOUNDATIONS ACADEMY public Regular School No 3 09 12 2015   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
772012 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009402320 331600010081 PS 81 THADDEUS STEVENS public Regular School No 1 PK 6 2015   grade_2   24.0 18.0   2.0     0.0     0.0   22.0 22.0             44     15   44   24 18   2     0     0   22 22         44   15   44
772031 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009402758 331600010243 PS 243 WEEKSVILLE SCHOOL (THE) public Regular School No 1 PK 5 2015   grade_2   27.0 7.0   0.0     2.0         23.0 13.0             34     11   36   27 7   0     2         23 13         34   11   36
772183 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009405904 331600010534 UPPER SCHOOL AT PS 25 public Regular School No 2 06 8 2015   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
772202 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009405707 331600010584 MS 584 public Regular School No 2 06 8 2015   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
772449 NY Kings   school 3600965 331600860918   BEDFORD STUY COLLEGIATE CS 360096506044 331600860918 BEDFORD STUY COLLEGIATE CHARTER SCH charter Regular School Yes 4 05 11 2015   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
772506 NY Kings   school 3601029 331600860971   BEDFORD STUY NEW BEGINNINGS 360102906236 331600860971 BEDFORD STUY NEW BEGINNINGS CHARTER charter Regular School Yes 1 KG 7 2015   grade_2   53.0 20.0   0.0           0.0   30.0 43.0             65     13   73   53 20   0           0   30 43         65   13   73
772525 NY Kings   school 3601048 331600860975   EMBER CHARTER SCHOOL 360104806255 331600860975 TEACHING FIRMS OF AMERICA PRO PREP charter Regular School Yes 1 KG 4 2015   grade_2   55.0 11.0         0.0         30.0 36.0             62     11   66   55 11         0         30 36         62   11   66
772639 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502348 331700010091 PS 91 ALBANY AVE SCHOOL (THE) public Regular School No 1 PK 5 2015   grade_2   56.0 2.0               0.0   22.0 36.0             55     15   58   56 2               0   22 36         55   15   58
772772 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502656 331700010191 PS 191 PAUL ROBESON public Regular School No 1 PK 5 2015   grade_2   27.0 4.0         1.0     0.0   18.0 14.0             32     10   32   27 4         1     0   18 14         32   10   32
773399 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505515 331700011544 INTERNATIONAL ARTS BUSINESS SCHOOL public Regular School No 3 12 12 2015   grade_2   0.0 0.0         0.0         0.0 0.0             0     *   0   0 0         0         0 0         0       0
773475 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505762 331700011568 BROWNSVILLE ACADEMY HIGH SCHOOL public Alternative Education School No 3 10 12 2015   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
773570 NY Kings   school 3600157 331700860841   EXPLORE CHARTER SCHOOL 360015705846 331700860841 EXPLORE CHARTER SCHOOL charter Regular School Yes 1 KG 8 2015   grade_2   49.0 7.0   1.0           0.0   29.0 28.0             42     10   57   49 7   1           0   29 28         42   10   57
773741 NY Kings   school 3601095 331700861041   SUCCESS ACAD-CROWN HEIGHTS 360109506413 331700861041 SUCCESS ACAD CHARTER SCH-CROWN HGTS charter Regular School Yes 1 KG 2 2015   grade_2   55.0 3.0   1.0           1.0   29.0 31.0             50     5   60   55 3   1           1   29 31         50   5   60
774102 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009605958 331800010588 MIDDLE SCHOOL FOR ART AND PHILOSOPHY public Regular School No 2 06 8 2015   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
774140 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009606455 331800010763 BROOKLYN SCIENCE AND ENGINEERING ACA public Regular School No 2 06 6 2015   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
774558 NY Kings   school 3601092 331800861057   NEW AMERICAN ACAD CHARTER SC 360109206415 331800861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter Regular School Yes 1 KG 2 2015   grade_2   61.0 3.0                   38.0 26.0             57     14   64   61 3                   38 26         57   14   64
774634 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012003000 331900010089 PS 89 CYPRESS HILLS public Regular School No 1 PK 8 2015   grade_2   2.0 37.0   1.0     2.0     0.0   15.0 27.0             40     9   42   2 37   1     2     0   15 27         40   9   42
774729 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012002595 331900010166 JHS 166 GEORGE GERSHWIN public Regular School No 2 07 8 2015   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
775679 NY Kings   school 3601109 331900860993   ACHIEVEMENT FIRST ASPIRE CHA 360110906421 331900860993 ACHIEVEMENT FIRST ASPIRE CHARTER charter Regular School Yes 1 KG 2 2015   grade_2   59.0 28.0   3.0     0.0     0.0   38.0 52.0             81     11   90   59 28   3     0     0   38 52         81   11   90
775698 NY Kings   school 3601050 331900860997   INVICTUS PREPARATORY CHARTER 360105006293 331900860997 INVICTUS PREPARATORY CHARTER SCHOOL charter Regular School Yes 2 05 8 2015   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
778567 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012105724 332300010522 MOTT HALL IV public Regular School No 2 06 08 2015   grade_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
778605 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012106012 332300010631 GENERAL D CHAPPIE JAMES ELEM SCHOOL public Regular School No 2 05 05 2015   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
778624 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012106026 332300010634 GENERAL D CHAPPIE JAMES MIDDLE SCH public Regular School No 4 08 08 2015   grade_2   0.0 0.0   0.0               0.0 0.0             0     0   0   0 0   0               0 0         0   0   0
778662 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012106428 332300010668 RIVERDALE AVENUE MIDDLE SCHOOL public Regular School No 2 06 07 2015   grade_2   0.0 0.0   0.0               0.0 0.0             0     0   0   0 0   0               0 0         0   0   0
778890 NY Kings   school 3601016 332300860942   LEADERSHIP PREP BROWNSVILLE 360101606201 332300860942 LEADERSHIP PREP BROWNSVILLE CHARTER charter Regular School Yes 1 KG 06 2015   grade_2   77.0 12.0   0.0     0.0     0.0   41.0 48.0             84     12   89   77 12   0     0     0   41 48         84   12   89
779194 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009704888 333200010349 IS 349 MATH, SCIENCE & TECHNOLOGY public Regular School No 2 06 08 2015   grade_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
785483 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003460 280208030002 CENTENNIAL AVENUE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_2   24.0 13.0                   23.0 14.0             24     6   37   24 13                   23 14         24   6   37
785502 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003464 280208030003 ULYSSES BYAS ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_2   25.0 17.0                   27.0 15.0             18     *   42   25 17                   27 15         18       42
785521 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003465 280208030004 WASHINGTON ROSE SCHOOL public Regular School No 1 PK 06 2015   grade_2   35.0 27.0               0.0   29.0 33.0             36     *   62   35 27               0   29 33         36       62
785540 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003463 280208030005 ROOSEVELT HIGH SCHOOL public Regular School No 3 09 12 2015   grade_2   0.0 0.0               0.0   0.0 0.0             0     0   0   0 0               0   0 0         0   0   0
785559 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499005611 280208030009 ROOSEVELT MIDDLE SCHOOL public Regular School No 2 07 08 2015   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
793596 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007700583 310200011429 LEGACY SCHOOL FOR INTEGRATED STUDIES public Regular School No 3 09 12 2015   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
793957 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705500 310200011542 MANHATTAN BRIDGES HIGH SCHOOL public Regular School No 3 09 12 2015   grade_2     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
794812 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007803579 310300010247 MS 247 DUAL LANG MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
795287 NY New York   school 3600061 310300860804   SISULU-WALKER CHARTER SCHOOL 360006104438 310300860804 SISULU-WALKER CHARTER SCHOOL charter Regular School Yes 1 KG 05 2015   grade_2   46.0 8.0   3.0     0.0     1.0   33.0 25.0             51     14   58   46 8   3     0     1   33 25         51   14   58
795496 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007904448 310400010013 JHS 13 JACKIE ROBINSON public Regular School No 4 08 08 2015   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
795724 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007902560 310400010155 PS 155 WILLIAM PACA public Regular School No 1 PK 05 2015   grade_2   8.0 45.0   0.0     2.0         28.0 27.0             55     17   55   8 45   0     2         28 27         55   17   55
795857 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007906016 310400010377 RENAISSANCE SCHOOL OF THE ARTS public Regular School No 2 06 08 2015   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
796598 NY New York   school 3600081 310500010000   NYC GEOG DIST # 5 - MANHATTAN 360008106116 310500010410 URBAN ASSEMBLY INST-NEW TECHNOLOGIES public Regular School No 2 06 08 2015   grade_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
796845 NY New York   school 3600081 310500010000   NYC GEOG DIST # 5 - MANHATTAN 360008102938 310500011685 BREAD & ROSES INTEGRATED ARTS HS public Regular School No 3 09 12 2015   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
797111 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008301675 310600010004 PS 4 DUKE ELLINGTON public Regular School No 1 PK 05 2015   grade_2   13.0 113.0         0.0     0.0   61.0 65.0             97     24   126   13 113         0     0   61 65         97   24   126
797738 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305871 310600010349 HARBOR HEIGHTS public Regular School No 2 06 08 2015   grade_2     0.0                   0.0 0.0             0     *   0     0                   0 0         0       0
797909 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008306099 310600011423 HIGH SCH-EXCELLENCE AND INNOVATION public Regular School No 3 09 12 2015   grade_2   0.0 0.0               0.0   0.0 0.0             0     0   0   0 0               0   0 0         0   0   0
798023 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008301265 310600011552 GREGORIO LUPERON HS-SCI & MATH public Regular School No 3 09 12 2015   grade_2     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
798441 NY Niagara   school 3620850 400701060000   NIAGARA WHEATFIELD 362085002954 400701060003 TUSCARORA ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_2     0.0   12.0           1.0   7.0 6.0             9     *   13     0   12           1   7 6         9       13
801253 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001449 420807040002 ONONDAGA NATION SCHOOL public Regular School No 1 PK 08 2015   grade_2         11.0           0.0   3.0 8.0             9     0   11         11           0   3 8         9   0   11
807390 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806084 342400011296 PAN AMERICAN INTERNATIONAL HS public Regular School No 3 09 12 2015   grade_2     0.0         0.0         0.0 0.0             0     0   0     0         0         0 0         0   0   0
810943 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010006518 342800010312 JAMAICA CHILDREN'S SCHOOL public Regular School No 1 KG KG 2015   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
810962 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010006533 342800010332 REDWOOD MIDDLE SCHOOL public Regular School No 2 06 06 2015   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
811532 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102438 342900010118 PS 118 LORRAINE HANSBERRY public Regular School No 1 PK 05 2015   grade_2   82.0 5.0   0.0     3.0     0.0   48.0 42.0             59     21   90   82 5   0     3     0   48 42         59   21   90
811855 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010105546 342900010270 GORDON PARKS SCHOOL (THE) public Regular School No 1 KG 08 2015   grade_2   86.0 0.0   2.0     0.0     0.0   44.0 44.0             55     16   88   86 0   2     0     0   44 44         55   16   88
812235 NY Queens   school 3601118 342900861078   SUCCESS ACADEMY CS - SPRINGFI 360111806486 342900861078 SUCCESS ACADEMY CS - SPRINGFIELD charter Regular School Yes 1 KG 01 2015   grade_2   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
821089 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004235 580109020004 MILTON L OLIVE MIDDLE SCHOOL public Regular School No 2 06 08 2015   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
943977 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008404460 320700010162 JHS 162 LOLA RODRIGUEZ DE TIO 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
944832 NY Bronx   school 3601125 320700861070   FAMILY LIFE ACADEMY CHARTER 360112506479 320700861070 FAMILY LIFE ACADEMY CHARTER SCH III charter Regular School Yes Elementary KG 03 2017   grade_2   21.0 36.0         0.0     0.0   29.0 28.0     16       53     7   57   21 36         0     0   29 28     16   53   7   57
944870 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Other 09 09 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
945497 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506081 320800010424 HUNTS POINT SCHOOL (THE) 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   0   0   0
946352 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602338 320900010088 PS 88 S SILVERSTEIN LITTLE SPARROW public Regular School No Elementary PK 03 2017   grade_2   8.0 23.0         0.0     0.0   13.0 18.0     5       *     *   31   8 23         0     0   13 18     5           31
946466 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III 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   0   0   0
947245 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 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
947264 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY 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
950760 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   grade_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
951501 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE 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
960450 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 4 2017   grade_2   49.0 8.0   0.0           4.0   30.0 31.0     *       59     5   61   49 8   0           4   30 31         59   5   61
966226 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009105563 331300011553 BROOKLYN ACADEMY HIGH SCHOOL public Alternative 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
968620 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009402163 331600010035 MS 35 STEPHEN DECATUR public Regular School No Middle 06 8 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
968696 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009402758 331600010243 PS 243 WEEKSVILLE SCHOOL (THE) public Regular School No Elementary PK 5 2017   grade_2   24.0 11.0   0.0     2.0     0.0   19.0 18.0     *       36     11   37   24 11   0     2     0   19 18         36   11   37
968810 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009405518 331600010393 FREDERICK DOUGLASS ACADEMY IV 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
968962 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009406408 331600011669 RESEARCH AND SERVICE 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
969380 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502656 331700010191 PS 191 PAUL ROBESON public Regular School No Elementary PK 5 2017   grade_2   33.0 5.0   1.0     1.0     1.0   23.0 18.0     *       41     12   41   33 5   1     1     1   23 18         41   12   41
969551 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505819 331700010353 ELIJAH STROUD MIDDLE SCHOOL public Regular School No Middle 06 8 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   0   0
970045 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505762 331700011568 BROWNSVILLE ACADEMY HIGH SCHOOL public Alternative 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
970216 NY Kings   school 3601058 331700861027   EXPLORE EXCEED CHARTER SCHOO 360105806354 331700861027 EXPLORE EXCEED CHARTER SCHOOL charter Regular School Yes Elementary KG 7 2017   grade_2   52.0 10.0   0.0     2.0     1.0   32.0 33.0     *       54     16   65   52 10   0     2     1   32 33         54   16   65
970273 NY Kings   school 3601095 331700861041   SUCCESS ACAD-CROWN HEIGHTS 360109506413 331700861041 SUCCESS ACAD CHARTER SCH-CROWN HGTS charter Regular School Yes Elementary KG 4 2017   grade_2   85.0 1.0   0.0     0.0     1.0   39.0 48.0     *       76     16   87   85 1   0     0     1   39 48         76   16   87
971204 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012003000 331900010089 PS 89 CYPRESS HILLS public Regular School No Elementary PK 8 2017   grade_2   1.0 41.0   0.0     0.0     0.0   19.0 23.0     18       37     *   42   1 41   0     0     0   19 23     18   37       42
972173 NY Kings   school 3601031 331900860973   IMAGINE ME LEADERSHIP CHARTE 360103106238 331900860973 IMAGINE ME LEADERSHIP CHARTER SCHOOL charter Regular School Yes Elementary KG 5 2017   grade_2   24.0 11.0               0.0   35.0       *       33     7   35   24 11               0   35           33   7   35
972230 NY Kings   school 3601145 331900861065   COLLEGIATE ACADEMY-MATH-PERS 360114506574 331900861065 COLLEGIATE ACADEMY-MATH-PERSONAL AWA charter Regular School Yes Middle 06 6 2017   grade_2   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]);