Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_7 · 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
747146 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_7   0.0 0.0         0.0     0.0   0.0 0.0             0     0   0   0 0         0     0   0 0         0   0   0
747222 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405119 320700010203 MS 203 public Regular School No 4.0 08 08 2015   grade_7   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
747887 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_7   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
748058 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_7   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
748115 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_7   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
749198 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_7   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
749521 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_7   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
749635 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_7   0.0 0.0         0.0     0.0   0.0 0.0             0     0   0   0 0         0     0   0 0         0   0   0
750547 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_7   21.0 37.0         0.0         29.0 29.0             55     21   58   21 37         0         29 29         55   21   58
750566 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_7   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
750927 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_7   20.0 25.0         0.0     0.0   25.0 20.0             43     13   45   20 25         0     0   25 20         43   13   45
751934 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_7   0.0 0.0   0.0               0.0 0.0             0     0   0   0 0   0               0 0         0   0   0
752181 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_7   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
753910 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_7   30.0 19.0   0.0     6.0         18.0 37.0             42     9   55   30 19   0     6         18 37         42   9   55
754119 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_7   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
754613 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_7   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
754784 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_7     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
754860 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_7   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
763638 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_7   0.0 0.0         0.0     0.0   0.0 0.0             0     0   0   0 0         0     0   0 0         0   0   0
769262 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_7   16.0 14.0   1.0     2.0     1.0   22.0 12.0             27     *   34   16 14   1     2     1   22 12         27       34
769300 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_7   12.0 2.0         2.0         7.0 9.0             16     *   16   12 2         2         7 9         16       16
769718 NY Kings   school 3601033 331300860937   BROOKLYN EAST COLLEGIATE 360103306240 331300860937 BROOKLYN EAST COLLEGIATE CHARTER SCH charter Regular School Yes 2 05 9 2015   grade_7   63.0 9.0   0.0     0.0     0.0   37.0 35.0             61     12   72   63 9   0     0     0   37 35         61   12   72
770364 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011905816 331400011322 FOUNDATIONS ACADEMY public Regular School No 3 09 12 2015   grade_7   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
772017 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_7   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
772036 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_7   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
772188 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_7   39.0 7.0                   23.0 23.0             39     15   46   39 7                   23 23         39   15   46
772207 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009405707 331600010584 MS 584 public Regular School No 2 06 8 2015   grade_7   31.0 8.0   1.0     0.0     1.0   18.0 23.0             38     12   41   31 8   1     0     1   18 23         38   12   41
772454 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_7   65.0 7.0   1.0     3.0         42.0 34.0             60     8   76   65 7   1     3         42 34         60   8   76
772511 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_7   37.0 16.0   0.0           0.0   21.0 32.0             47     5   53   37 16   0           0   21 32         47   5   53
772530 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_7   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
772644 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_7   0.0 0.0               0.0   0.0 0.0             0     0   0   0 0               0   0 0         0   0   0
772777 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_7   0.0 0.0         0.0     0.0   0.0 0.0             0     0   0   0 0         0     0   0 0         0   0   0
773404 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_7   0.0 0.0         0.0         0.0 0.0             0     *   0   0 0         0         0 0         0       0
773480 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_7   0.0 0.0         0.0     0.0   0.0 0.0             0     0   0   0 0         0     0   0 0         0   0   0
773575 NY Kings   school 3600157 331700860841   EXPLORE CHARTER SCHOOL 360015705846 331700860841 EXPLORE CHARTER SCHOOL charter Regular School Yes 1 KG 8 2015   grade_7   54.0 1.0   0.0           1.0   25.0 31.0             32     8   56   54 1   0           1   25 31         32   8   56
773746 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_7   0.0 0.0   0.0           0.0   0.0 0.0             0     0   0   0 0   0           0   0 0         0   0   0
774107 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_7   82.0 6.0   0.0     0.0         45.0 43.0             81     19   88   82 6   0     0         45 43         81   19   88
774145 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_7   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
774563 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_7   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
774639 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_7   0.0 66.0   0.0     0.0     0.0   31.0 35.0             61     20   66   0 66   0     0     0   31 35         61   20   66
774734 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_7   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
775684 NY Kings   school 3601109 331900860993   ACHIEVEMENT FIRST ASPIRE CHA 360110906421 331900860993 ACHIEVEMENT FIRST ASPIRE CHARTER charter Regular School Yes 1 KG 2 2015   grade_7   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
775703 NY Kings   school 3601050 331900860997   INVICTUS PREPARATORY CHARTER 360105006293 331900860997 INVICTUS PREPARATORY CHARTER SCHOOL charter Regular School Yes 2 05 8 2015   grade_7   83.0 17.0   1.0     1.0         56.0 46.0             77     7   102   83 17   1     1         56 46         77   7   102
778572 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012105724 332300010522 MOTT HALL IV public Regular School No 2 06 08 2015   grade_7   73.0 7.0         0.0         47.0 33.0             72     15   80   73 7         0         47 33         72   15   80
778610 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_7   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
778629 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_7   0.0 0.0   0.0               0.0 0.0             0     0   0   0 0   0               0 0         0   0   0
778667 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_7   46.0 5.0   0.0               27.0 24.0             46     13   51   46 5   0               27 24         46   13   51
778895 NY Kings   school 3601016 332300860942   LEADERSHIP PREP BROWNSVILLE 360101606201 332300860942 LEADERSHIP PREP BROWNSVILLE CHARTER charter Regular School Yes 1 KG 06 2015   grade_7   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
779199 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_7   7.0 115.0         0.0         63.0 59.0             121     20   122   7 115         0         63 59         121   20   122
785488 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003460 280208030002 CENTENNIAL AVENUE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_7   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
785507 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003464 280208030003 ULYSSES BYAS ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_7   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
785526 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003465 280208030004 WASHINGTON ROSE SCHOOL public Regular School No 1 PK 06 2015   grade_7   0.0 0.0               0.0   0.0 0.0             0     0   0   0 0               0   0 0         0   0   0
785545 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003463 280208030005 ROOSEVELT HIGH SCHOOL public Regular School No 3 09 12 2015   grade_7   0.0 0.0               0.0   0.0 0.0             0     0   0   0 0               0   0 0         0   0   0
785564 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499005611 280208030009 ROOSEVELT MIDDLE SCHOOL public Regular School No 2 07 08 2015   grade_7   123.0 84.0                   108.0 99.0             140     19   207   123 84                   108 99         140   19   207
793601 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_7   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
793962 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_7     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
794817 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_7   1.0 61.0                   21.0 41.0             62     15   62   1 61                   21 41         62   15   62
795292 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_7   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
795501 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_7   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
795729 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_7   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
795862 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_7   26.0 31.0                   26.0 31.0             48     20   57   26 31                   26 31         48   20   57
796603 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_7   24.0 13.0         0.0         19.0 18.0             27     17   37   24 13         0         19 18         27   17   37
796850 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_7   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
797116 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_7   0.0 0.0         0.0     0.0   0.0 0.0             0     0   0   0 0         0     0   0 0         0   0   0
797743 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305871 310600010349 HARBOR HEIGHTS public Regular School No 2 06 08 2015   grade_7     47.0                   31.0 16.0             47     *   47     47                   31 16         47       47
797914 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_7   0.0 0.0               0.0   0.0 0.0             0     0   0   0 0               0   0 0         0   0   0
798028 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_7     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
798446 NY Niagara   school 3620850 400701060000   NIAGARA WHEATFIELD 362085002954 400701060003 TUSCARORA ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_7     0.0   0.0           0.0   0.0 0.0             0     0   0     0   0           0   0 0         0   0   0
801258 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001449 420807040002 ONONDAGA NATION SCHOOL public Regular School No 1 PK 08 2015   grade_7         11.0           0.0   5.0 6.0             8     *   11         11           0   5 6         8       11
807395 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_7     0.0         0.0         0.0 0.0             0     0   0     0         0         0 0         0   0   0
810948 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_7   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
810967 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010006533 342800010332 REDWOOD MIDDLE SCHOOL public Regular School No 2 06 06 2015   grade_7   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
811537 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_7   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
811860 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_7   71.0 0.0   0.0     1.0     0.0   35.0 37.0             36     20   72   71 0   0     1     0   35 37         36   20   72
812240 NY Queens   school 3601118 342900861078   SUCCESS ACADEMY CS - SPRINGFI 360111806486 342900861078 SUCCESS ACADEMY CS - SPRINGFIELD charter Regular School Yes 1 KG 01 2015   grade_7   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
821094 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004235 580109020004 MILTON L OLIVE MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_7   105.0 54.0         0.0     0.0   81.0 78.0             146     38   159   105 54         0     0   81 78         146   38   159
943982 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_7   29.0 94.0   1.0               66.0 58.0     25       113     38   124   29 94   1               66 58     25   113   38   124
944837 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_7   0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0   0 0         0     0   0 0     0   0   0   0
944875 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_7   0.0 0.0               0.0   0.0 0.0     0       0     0   0   0 0               0   0 0     0   0   0   0
945502 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_7   16.0 82.0   2.0     0.0     1.0   50.0 51.0     25       88     *   101   16 82   2     0     1   50 51     25   88       101
946357 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_7   0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0   0 0         0     0   0 0     0   0   0   0
946471 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   grade_7   59.0 61.0   1.0     1.0     0.0   52.0 70.0     *       112     21   122   59 61   1     1     0   52 70         112   21   122
947250 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_7   21.0 22.0   6.0     0.0         25.0 24.0     16       44     23   49   21 22   6     0         25 24     16   44   23   49
947269 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_7   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
950765 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_7   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
951506 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_7     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
960455 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_7   0.0 0.0   0.0           0.0   0.0 0.0     *       0     0   0   0 0   0           0   0 0         0   0   0
966231 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_7   0.0 0.0   0.0               0.0 0.0             0     0   0   0 0   0               0 0         0   0   0
968625 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_7   35.0 7.0   0.0     1.0     0.0   21.0 22.0     *       *     *   43   35 7   0     1     0   21 22                 43
968701 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_7   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
968815 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_7   0.0 0.0               0.0   0.0 0.0             0     0   0   0 0               0   0 0         0   0   0
968967 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_7   0.0 0.0         0.0         0.0 0.0     *       0     0   0   0 0         0         0 0         0   0   0
969385 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_7   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
969556 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_7   38.0 4.0   0.0     1.0     0.0   28.0 15.0     *       41     14   43   38 4   0     1     0   28 15         41   14   43
970050 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_7   0.0 0.0   0.0     0.0         0.0 0.0     *       0     0   0   0 0   0     0         0 0         0   0   0
970221 NY Kings   school 3601058 331700861027   EXPLORE EXCEED CHARTER SCHOO 360105806354 331700861027 EXPLORE EXCEED CHARTER SCHOOL charter Regular School Yes Elementary KG 7 2017   grade_7   50.0 15.0   0.0     1.0     0.0   31.0 35.0     5       57     10   66   50 15   0     1     0   31 35     5   57   10   66
970278 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_7   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
971209 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_7   1.0 52.0   1.0     0.0     0.0   28.0 26.0     26       52     13   54   1 52   1     0     0   28 26     26   52   13   54
972178 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_7   0.0 0.0               0.0   0.0       *       0     0   0   0 0               0   0           0   0   0
972235 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_7   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]);