Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_9", state = "NY" and year = 2017

View and edit SQL

year

  • 2017 · 4,622

grade

  • grade_9 · 4,622
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
943946 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405533 320700010157 PS 157 GROVE HILL public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
943965 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402578 320700010161 PS 161 PONCE DE LEON SCHOOL public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
943984 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_9   0.0 0.0   0.0               0.0 0.0     0       0     0   0   0 0   0               0 0     0   0   0   0
944003 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405118 320700010179 PS 179 public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944022 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405521 320700010223 MS 223 LAB SCHOOL OF FIN & TECH public Regular School No Other 06 12 2017   grade_9 0.0 13.0 76.0   0.0     1.0     0.0   43.0 47.0     5       90     17   90 0 13 76   0     1     0   43 47     5   90   17   90
944041 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405520 320700010224 PS/IS 224 public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
944060 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008403738 320700010277 PS 277 public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944079 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405785 320700010296 SO BRONX ACADEMY-APPLIED MEDIA public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
944098 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405786 320700010298 ACADEMY OF PUBLIC RELATIONS public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
944117 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405920 320700010343 ACADEMY OF APPLIED MATH AND TECH public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
944136 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406382 320700010359 CONCOURSE VILLAGE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944155 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406041 320700010369 YOUNG LEADERS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
944174 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405650 320700011221 SOUTH BRONX PREPARATORY public Regular School No Other 06 12 2017   grade_9 0.0 23.0 80.0   0.0     3.0     0.0   41.0 65.0     8       105     26   106 0 23 80   0     3     0   41 65     8   105   26   106
944193 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406383 320700011259 HERO HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 1.0 45.0 65.0   3.0     1.0     0.0   28.0 87.0     18       88     24   115 1 45 65   3     1     0   28 87     18   88   24   115
944212 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405761 320700011321 CROTONA ACADEMY HIGH SCHOOL public Alternative School No High 09 12 2017   grade_9 0.0 2.0 4.0                   3.0 3.0     *       *     *   6 0 2 4                   3 3                 6
944231 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405873 320700011334 INTERNATIONAL COMMUNITY HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 5.0 5.0 68.0   0.0     7.0     1.0   46.0 40.0     83       84     *   86 5 5 68   0     7     1   46 40     83   84       86
944250 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405988 320700011379 JILL CHAIFETZ TRANSFER HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 0.0 5.0 13.0   0.0     0.0         4.0 14.0     5       16     *   18 0 5 13   0     0         4 14     5   16       18
944269 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406056 320700011381 BRONX HAVEN HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 0.0 5.0 17.0         0.0         12.0 10.0     *       20     6   22 0 5 17         0         12 10         20   6   22
944288 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405180 320700011427 COMMUNITY SCHOOL-SOCIAL JUSTICE public Regular School No High 09 12 2017   grade_9 0.0 17.0 54.0   0.0     0.0     0.0   39.0 32.0     19       70     20   71 0 17 54   0     0     0   39 32     19   70   20   71
944307 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405187 320700011473 MOTT HAVEN VILLAGE PREP HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 2.0 26.0 73.0   1.0     1.0     0.0   58.0 45.0     18       99     37   103 2 26 73   1     1     0   58 45     18   99   37   103
944326 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008400749 320700011495 UNIVERSITY HEIGHTS SECONDARY SCHOOL public Regular School No High 09 12 2017   grade_9 4.0 33.0 83.0   1.0     3.0     2.0   47.0 79.0     *       117     30   126 4 33 83   1     3     2   47 79         117   30   126
944345 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008400757 320700011500 HOSTOS-LINCOLN ACADEMY OF SCIENCE public Regular School No Other 06 12 2017   grade_9 1.0 25.0 60.0   2.0     3.0     0.0   40.0 51.0     8       77     21   91 1 25 60   2     3     0   40 51     8   77   21   91
944364 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406253 320700011522 BRONX DESIGN-CONSTRUCTION ACADEMY public Regular School No High 09 12 2017   grade_9 5.0 41.0 144.0   1.0     2.0     2.0   156.0 39.0     42       184     63   195 5 41 144   1     2     2   156 39     42   184   63   195
944383 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405189 320700011527 BRONX LEADERSHIP ACAD II HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 2.0 41.0 111.0   1.0     1.0     1.0   101.0 56.0     41       150     55   157 2 41 111   1     1     1   101 56     41   150   55   157
944402 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405517 320700011547 NEW EXPLORERS HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 1.0 48.0 97.0         1.0         62.0 85.0     24       130     49   147 1 48 97         1         62 85     24   130   49   147
944421 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405512 320700011548 CAREERS IN SPORTS HS public Regular School No High 09 12 2017   grade_9 2.0 60.0 104.0   1.0     1.0         139.0 29.0     17       156     55   168 2 60 104   1     1         139 29     17   156   55   168
944440 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405504 320700011551 URBAN ASSEMBLY BRONX OF LETTERS public Regular School No Other 06 12 2017   grade_9 2.0 24.0 71.0         2.0     0.0   50.0 49.0     18       95     25   99 2 24 71         2     0   50 49     18   95   25   99
944459 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406352 320700011557 MOTT HAVEN COMMUNITY HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 0.0 0.0 0.0   0.0               0.0 0.0     0       0     0   0 0 0 0   0               0 0     0   0   0   0
944478 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401909 320700011600 ALFRED E SMITH CAREER-TECH HIGH SCH public Career and Technical School No High 09 12 2017   grade_9 2.0 39.0 114.0   0.0     0.0     0.0   135.0 20.0     41       147     47   155 2 39 114   0     0     0   135 20     41   147   47   155
944497 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401338 320700011670 HEALTH OPPORTUNITIES HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 3.0 50.0 67.0   1.0     0.0     0.0   47.0 74.0     21       105     37   121 3 50 67   1     0     0   47 74     21   105   37   121
944516 NY Bronx   school 3601074 320700860703   HEKETI COMMUNITY CHARTER SCH 360107406336 320700860703 HEKETI COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944535 NY Bronx   school 3600054 320700860820   KIPP ACADEMY CHARTER SCH 360005404452 320700860820 KIPP ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2017   grade_9 0.0 29.0 38.0   1.0     0.0     0.0   31.0 37.0     *       51     16   68 0 29 38   1     0     0   31 37         51   16   68
944554 NY Bronx   school 3600110 320700860852   BRONX CHARTER SCH-CHILDREN 360011005651 320700860852 BRONX CHARTER SCHOOL FOR CHILDREN charter Regular School Yes Elementary KG 05 2017   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
944573 NY Bronx   school 3600144 320700860889   SOUTH BRONX CHARTER SCHOOL 360014405787 320700860889 SOUTH BRONX CHARTER SCHOOL charter Regular School Yes Elementary KG 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
944592 NY Bronx   school 3600967 320700860915   BGLIG CHARTER SCHOOL 360096706008 320700860915 BGLIG-SHIRLEY RODRIGUEZ-REMENESKI CS charter Regular School Yes Elementary KG 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0     0.0     0       0     0   0 0 0 0   0     0     0     0     0   0   0   0
944611 NY Bronx   school 3600963 320700860920   UNIVERSITY PREP CHARTER HIGH 360096306039 320700860920 UNIVERSITY PREP CHARTER HIGH SCHOOL charter Regular School Yes High 09 12 2017   grade_9 0.0 30.0 64.0   1.0     2.0     4.0   53.0 48.0     13       91     14   101 0 30 64   1     2     4   53 48     13   91   14   101
944630 NY Bronx   school 3600960 320700860925   MOTT HAVEN ACADEMY CHARTER S 360096006013 320700860925 MOTT HAVEN ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944649 NY Bronx   school 3600959 320700860926   NYC CHARTER HS - AECI 360095906073 320700860926 NYC CHARTER HS - AECI charter Regular School Yes High 09 12 2017   grade_9 0.0 55.0 78.0   1.0     1.0     1.0   99.0 37.0     12       128     39   136 0 55 78   1     1     1   99 37     12   128   39   136
944668 NY Bronx   school 3601001 320700860957   ACADEMIC LEADERSHIP CHARTER 360100106154 320700860957 ACADEMIC LEADERSHIP CHARTER SCHOOL charter Regular School Yes Elementary PK 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944687 NY Bronx   school 3601011 320700860981   SUCCESS ACADEMY-BRONX 1 360101106211 320700860981 SUCCESS ACADEMY CHARTER-BRONX 1 charter Regular School Yes Elementary KG 07 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944706 NY Bronx   school 3601044 320700861005   NYC MONTESSORI CHARTER SCHOO 360104406248 320700861005 NYC MONTESSORI CHARTER SCHOOL charter Regular School Yes Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944725 NY Bronx   school 3601108 320700861014   BRILLA COLLEGE PREP CHARTER 360110806384 320700861014 BRILLA COLLEGE PREP CHARTER charter Regular School Yes Elementary KG 04 2017   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
944744 NY Bronx   school 3601073 320700861018   NEW VISIONS CHARTER HS-HUMAN 360107306320 320700861018 NEW VISIONS CHARTER HS-HUMANITIES II charter Regular School Yes High 09 12 2017   grade_9 1.0 58.0 79.0   0.0     1.0     1.0   66.0 74.0     21       116     34   140 1 58 79   0     1     1   66 74     21   116   34   140
944763 NY Bronx   school 3601070 320700861028   FAMILY LIFE ACADEMY CHARTER 360107006318 320700861028 FAMILY LIFE ACADEMY CHARTER SCH II charter Regular School Yes Elementary KG 05 2017   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
944782 NY Bronx   school 3601105 320700861035   SOUTH BRONX CLASSICAL II 360110506385 320700861035 SOUTH BRONX CLASSICAL CHARTER II charter Regular School Yes Elementary KG 04 2017   grade_9 0.0 0.0 0.0   0.0           0.0   0.0 0.0     0       0     0   0 0 0 0   0           0   0 0     0   0   0   0
944801 NY Bronx   school 3601119 320700861062   AMERICAN DREAM CHARTER SCHOO 360111906495 320700861062 AMERICAN DREAM CHARTER SCHOOL charter Regular School Yes Middle 06 08 2017   grade_9 0.0 0.0 0.0   0.0           0.0   0.0 0.0     0       0     0   0 0 0 0   0           0   0 0     0   0   0   0
944820 NY Bronx   school 3601131 320700861068   SOUTH BRONX EARLY COLLEGE AC 360113106555 320700861068 SOUTH BRONX EARLY COLLEGE ACADEMY CS charter Regular School Yes Middle 06 07 2017   grade_9 0.0 0.0 0.0   0.0               0.0 0.0     0       0     0   0 0 0 0   0               0 0     0   0   0   0
944839 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_9   0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0   0 0         0     0   0 0     0   0   0   0
944858 NY Bronx   school 3601137 320700861080   STOREFRONT ACADEMY CHARTER S 360113706552 320700861080 STOREFRONT ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary KG 02 2017   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
944877 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_9   35.0 71.0               1.0   47.0 60.0     14       95     15   107   35 71               1   47 60     14   95   15   107
944896 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502085 320800010014 PS 14 SENATOR JOHN CALANDRA public Regular School No Elementary KG 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944915 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502168 320800010036 PS 36 UNIONPORT public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944934 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502211 320800010048 PS 48 JOSEPH R DRAKE public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944953 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502264 320800010062 PS 62 INOCENSIO CASANOVA public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944972 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502285 320800010069 PS 69 JOURNEY PREP SCHOOL public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944991 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502293 320800010071 PS 71 ROSE E SCALA public Regular School No Elementary PK 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
945010 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502295 320800010072 PS 72 DR WILLIAM DORNEY public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
945029 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502302 320800010075 PS 75 SCHOOL OF RESEARCH-DISCOVERY public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
945048 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502354 320800010093 PS 93 ALBERT G OLIVER public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0           0.0   0.0 0.0     0       0     0   0 0 0 0   0           0   0 0     0   0   0   0
945067 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502380 320800010100 PS 100 ISAAC CLASON public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
945086 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008503740 320800010101 MS 101 EDWARD R BYRNE public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
945105 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502401 320800010107 PS 107 public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
945124 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502441 320800010119 EMMETT W BASSETT SCHOOL public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
945143 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502456 320800010123 JHS 123 JAMES M KIERNAN public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
945162 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502463 320800010125 JHS 125 HENRY HUDSON public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
945181 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502479 320800010130 PS 130 ABRAM STEVENS HEWITT public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
945200 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008501979 320800010131 JHS 131 ALBERT EINSTEIN public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
945219 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502505 320800010138 PS 138 SAMUEL RANDALL public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
945238 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502509 320800010140 PS 140 EAGLE SCHOOL (THE) public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
945257 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502530 320800010146 PS 146 EDWARD COLLINS public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
945276 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502547 320800010152 PS 152 EVERGREEN public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
945295 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502632 320800010182 PS 182 public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
945314 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505121 320800010301 MS 301 PAUL L DUNBAR public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0                   0.0 0.0     0       0     0   0 0 0 0                   0 0     0   0   0   0
945333 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505122 320800010302 MS 302 LUISA DESSUS CRUZ public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
945352 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505123 320800010304 PS 304 EARLY CHILDHOOD SCHOOL public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
945371 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505654 320800010312 MILLENIUM ART ACADEMY public Regular School No High 09 12 2017   grade_9 2.0 26.0 92.0   0.0     2.0     0.0   59.0 63.0     14       74     41   122 2 26 92   0     2     0   59 63     14   74   41   122
945390 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505655 320800010333 PS 333 MUSEUM SCHOOL (THE) public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
945409 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505656 320800010335 ACADEMY OF THE ARTS (THE) public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0   0.0           0.0   0.0 0.0     0       0     0   0 0 0 0   0           0   0 0     0   0   0   0
945428 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505657 320800010337 SCHOOL FOR INQUIRY & SOCIAL JUSTICE public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
945447 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505982 320800010371 URBAN INSTITUTE OF MATHEMATICS public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
945466 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505986 320800010375 BRONX MATHEMATICS PREP SCH (THE) public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
945485 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506506 320800010392 BRONX DELTA SCHOOL public Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
945504 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_9   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
945523 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506156 320800010448 SOUNDVIEW ACADEMY public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
945542 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506162 320800010467 MOTT HALL COMMUNITY SCHOOL public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
945561 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506302 320800010562 BLUEPRINT MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
945580 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505652 320800011269 BRONX STUDIO SCHOOL-WRITERS-ARTISTS public Regular School No Other 06 12 2017   grade_9 3.0 27.0 100.0   0.0     1.0     1.0   59.0 73.0     27       110     49   132 3 27 100   0     1     1   59 73     27   110   49   132
945599 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505653 320800011282 WOMEN'S ACADEMY OF EXCELLENCE public Regular School No High 09 12 2017   grade_9 8.0 38.0 33.0   1.0     7.0     2.0     89.0     15       85     20   89 8 38 33   1     7     2     89     15   85   20   89
945618 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505659 320800011293 RENAISSANCE HIGH SCHOOL-MTT public Regular School No High 09 12 2017   grade_9 9.0 33.0 96.0   1.0     3.0     1.0   59.0 84.0     10       91     46   143 9 33 96   1     3     1   59 84     10   91   46   143
945637 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505661 320800011305 PABLO NERUDA ACADEMY public Regular School No High 09 12 2017   grade_9 0.0 15.0 36.0   0.0     3.0         32.0 22.0     7       *     *   54 0 15 36   0     3         32 22     7           54
945656 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506386 320800011320 PELHAM LAB HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 14.0 36.0 86.0   3.0     8.0     4.0   87.0 64.0     22       135     39   151 14 36 86   3     8     4   87 64     22   135   39   151
945675 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505876 320800011332 HOLCOMBE L RUCKER SCHOOL OF COMMUNIT public Regular School No High 09 12 2017   grade_9 0.0 17.0 10.0         2.0     0.0   22.0 7.0     *       *     9   29 0 17 10         2     0   22 7             9   29
945694 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506387 320800011348 SCHUYLERVILLE PREPARATORY HIGH SCHOO public Regular School No High 09 12 2017   grade_9 12.0 32.0 56.0   4.0     5.0     0.0   72.0 37.0     13       88     34   109 12 32 56   4     5     0   72 37     13   88   34   109
945713 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506388 320800011349 BRONX RIVER HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 6.0 27.0 74.0   2.0     4.0     0.0   69.0 44.0     27       91     33   113 6 27 74   2     4     0   69 44     27   91   33   113
945732 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505985 320800011367 ARCHIMEDES ACAD-MATH, SCI, TECH public Regular School No Other 06 12 2017   grade_9 5.0 29.0 64.0   1.0     8.0     1.0   78.0 30.0     20       89     37   108 5 29 64   1     8     1   78 30     20   89   37   108
945751 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505984 320800011376 ANTONIA PANTOJA PREP ACADEMY public Regular School No Other 06 12 2017   grade_9 1.0 9.0 51.0   0.0     6.0         42.0 25.0     20       49     21   67 1 9 51   0     6         42 25     20   49   21   67
945770 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505983 320800011377 BRONX COMMUNITY HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 0.0 2.0 1.0   0.0     0.0         0.0 3.0     0       *     *   3 0 2 1   0     0         0 3     0           3
945789 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008501964 320800011405 HERBERT H LEHMAN HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 31.0 71.0 145.0   2.0     28.0     3.0   172.0 108.0     37       209     85   280 31 71 145   2     28     3   172 108     37   209   85   280
945808 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506221 320800011432 BRONX BRIDGES HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 5.0 6.0 54.0   2.0     15.0         46.0 36.0     74       47     14   82 5 6 54   2     15         46 36     74   47   14   82
945827 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505186 320800011452 BRONX GUILD HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 0.0 14.0 40.0   1.0     3.0     0.0   31.0 27.0     *       *     *   58 0 14 40   1     3     0   31 27                 58

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