Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2017 · 4,622

grade

  • grade_2 · 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
943939 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_2 1.0 26.0 75.0   0.0     0.0     2.0   54.0 50.0     10       101     22   104 1 26 75   0     0     2   54 50     10   101   22   104
943958 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_2 0.0 22.0 54.0   0.0     0.0     0.0   39.0 37.0     15       73     22   76 0 22 54   0     0     0   39 37     15   73   22   76
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
943996 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405118 320700010179 PS 179 public Regular School No Elementary PK 05 2017   grade_2 0.0 5.0 45.0   0.0     0.0     3.0   24.0 29.0     22       53     13   53 0 5 45   0     0     3   24 29     22   53   13   53
944015 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_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   0   0   0
944034 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405520 320700010224 PS/IS 224 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
944053 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008403738 320700010277 PS 277 public Regular School No Elementary PK 05 2017   grade_2 0.0 13.0 53.0   1.0     0.0     1.0   42.0 26.0     12       68     20   68 0 13 53   1     0     1   42 26     12   68   20   68
944072 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_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
944091 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_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
944110 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_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
944129 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_2 2.0 20.0 36.0   0.0     1.0     0.0   23.0 36.0     12       55     20   59 2 20 36   0     1     0   23 36     12   55   20   59
944148 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_2 1.0 5.0 33.0               0.0   17.0 22.0     23       39     12   39 1 5 33               0   17 22     23   39   12   39
944167 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405650 320700011221 SOUTH BRONX PREPARATORY 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   0 0     0   0   0   0
944186 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406383 320700011259 HERO HIGH SCHOOL public Regular School No High 09 12 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944205 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_2 0.0 0.0 0.0                   0.0 0.0     0       0     0   0 0 0 0                   0 0     0   0   0   0
944224 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_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   0   0   0
944243 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_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
944262 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_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
944281 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_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   0   0   0
944300 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_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   0   0   0
944319 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_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   0   0   0
944338 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_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   0   0   0
944357 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_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   0   0   0
944376 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_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   0   0   0
944395 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_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
944414 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_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
944433 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_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
944452 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_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
944471 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_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   0   0   0
944490 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_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   0   0   0
944509 NY Bronx   school 3601074 320700860703   HEKETI COMMUNITY CHARTER SCH 360107406336 320700860703 HEKETI COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 05 2017   grade_2 0.0 14.0 35.0   1.0     0.0     0.0   28.0 22.0     17       45     *   50 0 14 35   1     0     0   28 22     17   45       50
944528 NY Bronx   school 3600054 320700860820   KIPP ACADEMY CHARTER SCH 360005404452 320700860820 KIPP ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2017   grade_2 0.0 47.0 54.0   2.0     1.0     0.0   60.0 44.0     20       101     17   104 0 47 54   2     1     0   60 44     20   101   17   104
944547 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_2 0.0 16.0 55.0         1.0     0.0   37.0 35.0     15       66     11   72 0 16 55         1     0   37 35     15   66   11   72
944566 NY Bronx   school 3600144 320700860889   SOUTH BRONX CHARTER SCHOOL 360014405787 320700860889 SOUTH BRONX CHARTER SCHOOL charter Regular School Yes Elementary KG 05 2017   grade_2 0.0 6.0 48.0   0.0     1.0         26.0 29.0     24       35     5   55 0 6 48   0     1         26 29     24   35   5   55
944585 NY Bronx   school 3600967 320700860915   BGLIG CHARTER SCHOOL 360096706008 320700860915 BGLIG-SHIRLEY RODRIGUEZ-REMENESKI CS charter Regular School Yes Elementary KG 08 2017   grade_2 1.0 12.0 35.0   2.0     0.0     0.0     50.0     7       45     *   50 1 12 35   2     0     0     50     7   45       50
944604 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_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   0   0   0
944623 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_2 1.0 16.0 33.0   2.0     0.0     0.0   30.0 22.0     13       50     18   52 1 16 33   2     0     0   30 22     13   50   18   52
944642 NY Bronx   school 3600959 320700860926   NYC CHARTER HS - AECI 360095906073 320700860926 NYC CHARTER HS - AECI charter Regular School Yes High 09 12 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944661 NY Bronx   school 3601001 320700860957   ACADEMIC LEADERSHIP CHARTER 360100106154 320700860957 ACADEMIC LEADERSHIP CHARTER SCHOOL charter Regular School Yes Elementary PK 08 2017   grade_2 0.0 19.0 36.0   0.0     0.0     1.0   26.0 30.0     14       54     7   56 0 19 36   0     0     1   26 30     14   54   7   56
944680 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_2 0.0 56.0 36.0   0.0     1.0     1.0   51.0 43.0     17       86     15   94 0 56 36   0     1     1   51 43     17   86   15   94
944699 NY Bronx   school 3601044 320700861005   NYC MONTESSORI CHARTER SCHOO 360104406248 320700861005 NYC MONTESSORI CHARTER SCHOOL charter Regular School Yes Elementary PK 05 2017   grade_2 0.0 17.0 32.0   0.0     0.0     1.0   30.0 20.0     15       47     18   50 0 17 32   0     0     1   30 20     15   47   18   50
944718 NY Bronx   school 3601108 320700861014   BRILLA COLLEGE PREP CHARTER 360110806384 320700861014 BRILLA COLLEGE PREP CHARTER charter Regular School Yes Elementary KG 04 2017   grade_2 1.0 24.0 68.0         0.0     0.0   45.0 48.0     30       87     25   93 1 24 68         0     0   45 48     30   87   25   93
944737 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_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   0   0   0
944756 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_2 0.0 12.0 39.0         0.0     0.0   25.0 26.0     *       46     11   51 0 12 39         0     0   25 26         46   11   51
944775 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_2 0.0 28.0 37.0   0.0           0.0   35.0 30.0     5       58     10   65 0 28 37   0           0   35 30     5   58   10   65
944794 NY Bronx   school 3601119 320700861062   AMERICAN DREAM CHARTER SCHOO 360111906495 320700861062 AMERICAN DREAM CHARTER SCHOOL charter Regular School Yes 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
944813 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_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
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
944851 NY Bronx   school 3601137 320700861080   STOREFRONT ACADEMY CHARTER S 360113706552 320700861080 STOREFRONT ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary KG 02 2017   grade_2 0.0 18.0 24.0   1.0     1.0         27.0 17.0     6       34     11   44 0 18 24   1     1         27 17     6   34   11   44
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
944889 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_2 22.0 7.0 71.0   1.0     5.0     4.0   49.0 61.0     5       77     32   110 22 7 71   1     5     4   49 61     5   77   32   110
944908 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502168 320800010036 PS 36 UNIONPORT public Regular School No Elementary PK 05 2017   grade_2 3.0 13.0 72.0   4.0     24.0     0.0   58.0 58.0     19       70     24   116 3 13 72   4     24     0   58 58     19   70   24   116
944927 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_2 2.0 27.0 97.0   1.0     2.0     1.0   74.0 56.0     32       113     43   130 2 27 97   1     2     1   74 56     32   113   43   130
944946 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_2 6.0 20.0 97.0   0.0     1.0     0.0   75.0 49.0     19       123     48   124 6 20 97   0     1     0   75 49     19   123   48   124
944965 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_2 1.0 11.0 75.0   0.0     1.0     1.0   41.0 48.0     6       81     23   89 1 11 75   0     1     1   41 48     6   81   23   89
944984 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_2 35.0 9.0 144.0   2.0     10.0     2.0   109.0 93.0     29       161     41   202 35 9 144   2     10     2   109 93     29   161   41   202
945003 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_2 2.0 20.0 91.0   0.0     2.0         54.0 61.0     *       90     37   115 2 20 91   0     2         54 61         90   37   115
945022 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_2 3.0 25.0 68.0   0.0     1.0     0.0   47.0 50.0     21       75     28   97 3 25 68   0     1     0   47 50     21   75   28   97
945041 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_2 0.0 30.0 17.0   1.0           0.0   23.0 25.0     *       31     13   48 0 30 17   1           0   23 25         31   13   48
945060 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_2 1.0 25.0 51.0   2.0     0.0     1.0   40.0 40.0     *       58     22   80 1 25 51   2     0     1   40 40         58   22   80
945079 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_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   0   0   0
945098 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502401 320800010107 PS 107 public Regular School No Elementary PK 05 2017   grade_2 4.0 30.0 62.0   0.0     0.0     0.0   48.0 48.0     10       96     36   96 4 30 62   0     0     0   48 48     10   96   36   96
945117 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_2 15.0 19.0 72.0   4.0     47.0     0.0   79.0 78.0     45       109     27   157 15 19 72   4     47     0   79 78     45   109   27   157
945136 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_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
945155 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_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   0   0   0
945174 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_2 2.0 22.0 51.0   0.0     1.0         33.0 43.0     24       54     22   76 2 22 51   0     1         33 43     24   54   22   76
945193 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_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   0   0   0
945212 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_2 1.0 30.0 60.0   2.0     3.0     1.0   51.0 46.0     *       92     20   97 1 30 60   2     3     1   51 46         92   20   97
945231 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_2 0.0 53.0 74.0   0.0     0.0     0.0   71.0 56.0     20       119     29   127 0 53 74   0     0     0   71 56     20   119   29   127
945250 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_2 0.0 27.0 49.0   1.0     1.0     0.0   36.0 42.0     14       76     21   78 0 27 49   1     1     0   36 42     14   76   21   78
945269 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502547 320800010152 PS 152 EVERGREEN public Regular School No Elementary PK 05 2017   grade_2 2.0 30.0 115.0   1.0     1.0     0.0   64.0 85.0     51       127     31   149 2 30 115   1     1     0   64 85     51   127   31   149
945288 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502632 320800010182 PS 182 public Regular School No Elementary PK 05 2017   grade_2 7.0 37.0 83.0   0.0     15.0     1.0   72.0 71.0     14       115     26   143 7 37 83   0     15     1   72 71     14   115   26   143
945307 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_2 0.0 0.0 0.0                   0.0 0.0     0       0     0   0 0 0 0                   0 0     0   0   0   0
945326 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_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
945345 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_2 25.0 3.0 38.0   0.0     8.0     1.0   41.0 34.0     *       54     24   75 25 3 38   0     8     1   41 34         54   24   75
945364 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505654 320800010312 MILLENIUM ART ACADEMY public Regular School No High 09 12 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
945383 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_2 2.0 12.0 67.0   0.0     1.0     0.0   43.0 39.0     25       71     29   82 2 12 67   0     1     0   43 39     25   71   29   82
945402 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_2 1.0 16.0 33.0   0.0           0.0   24.0 26.0     7       48     16   50 1 16 33   0           0   24 26     7   48   16   50
945421 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_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
945440 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_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   0   0   0
945459 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_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
945478 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506506 320800010392 BRONX DELTA SCHOOL public Regular School No Elementary PK 05 2017   grade_2 8.0 3.0 25.0         2.0     1.0   21.0 18.0     *       30     11   39 8 3 25         2     1   21 18         30   11   39
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
945516 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506156 320800010448 SOUNDVIEW ACADEMY 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
945535 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_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
945554 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506302 320800010562 BLUEPRINT MIDDLE SCHOOL 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
945573 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_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   0   0   0
945592 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_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
945611 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_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   0   0   0
945630 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505661 320800011305 PABLO NERUDA ACADEMY public Regular School No High 09 12 2017   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
945649 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_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   0   0   0
945668 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_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
945687 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_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   0   0   0
945706 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_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   0   0   0
945725 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_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   0   0   0
945744 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_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
945763 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_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
945782 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_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   0   0   0
945801 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_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
945820 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_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   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]);