Data source: Big Local News · About: Big Local

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

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
797648 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305782 310600010322 MIDDLE SCHOOL 322 public Regular School No 2 06 08 2015   grade_7 2.0 0.0 99.0   0.0     1.0     0.0   66.0 36.0             94     21   102 2 0 99   0     1     0   66 36         94   21   102
982286 NY Nassau   school 3603840 280210030000   BALDWIN 360384000126 280210030012 BALDWIN MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 60.0 155.0 99.0         17.0     6.0   170.0 167.0     *       113     65   337 60 155 99         17     6   170 167         113   65   337
993914 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305782 310600010322 MIDDLE SCHOOL 322 public Regular School No Middle 06 08 2017   grade_7 2.0 4.0 99.0   0.0     1.0         51.0 55.0     *       99     30   106 2 4 99   0     1         51 55         99   30   106
1047646 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003308 131500010011 POUGHKEEPSIE MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 36.0 181.0 99.0         1.0     8.0   155.0 170.0             240     53   325 36 181 99         1     8   155 170         240   53   325
1072289 NY Nassau   school 3603840 280210030000   BALDWIN 360384000126 280210030012 BALDWIN MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 78.0 199.0 99.0   0.0     22.0     18.0   215.0 201.0             97     57   416 78 199 99   0     22     18   215 201         97   57   416
1101169 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302216 353100010049 IS 49 BERTA A DREYFUS public Regular School No 2.0 05 08 2016   grade_7 28.0 92.0 99.0   0.0     24.0     1.0   118.0 126.0             205     88   244 28 92 99   0     24     1   118 126         205   88   244
1102119 NY Rockland   school 3620340 500101060000   CLARKSTOWN 362034005874 500101060023 FELIX FESTA CHARACTER MIDDLE SCHOOL public Regular School No 2.0 07 07 2016   grade_7 424.0 21.0 99.0         78.0     15.0   342.0 295.0             *     *   637 424 21 99         78     15   342 295                 637
1109149 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869005579 580232030010 WILLIAM FLOYD MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 189.0 47.0 99.0   2.0     11.0     10.0   180.0 178.0             202     44   358 189 47 99   2     11     10   180 178         202   44   358
1435664 NY Bronx   school 3601070 320700861028   FAMILY LIFE ACADEMY CHARTER 360107006318 320700861028 FAMILY LIFE ACADEMY CHARTER SCH II charter Regular School Yes Elementary KG 08 2021   grade_7 0.0 41.0 99.0   1.0     1.0     0.0   62.0 80.0     9       132     20   142 0 41 99   1     1     0   62 80     9   132   20   142
1462720 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006418 331900010661 VISTA ACADEMY public Regular School No Middle 06 08 2021   grade_7 2.0 39.0 99.0   3.0     12.0     0.0   84.0 71.0     14       151     36   155 2 39 99   3     12     0   84 71     14   151   36   155
1483867 NY New York   school 3600081 310500010000   NYC GEOG DIST # 5 - MANHATTAN 360008102577 310500010161 PS 161 PEDRO ALBIZU CAMPOS public Regular School No Elementary KG 08 2021   grade_7 0.0 23.0 99.0   1.0     1.0     1.0   63.0 62.0     39       123     28   125 0 23 99   1     1     1   63 62     39   123   28   125
1530740 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802323 321100010083 PS 83 DONALD HERTZ public Regular School No Elementary KG 08 2020   grade_7 76.0 17.0 99.0   3.0     17.0     3.0   118.0 97.0     31       149     51   215 76 17 99   3     17     3   118 97     31   149   51   215
1552856 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006418 331900010661 VISTA ACADEMY public Regular School No Middle 06 08 2020   grade_7 4.0 34.0 99.0   3.0     12.0     3.0   82.0 73.0     13       149     32   155 4 34 99   3     12     3   82 73     13   149   32   155
1556922 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009704887 333200010347 IS 347 SCHOOL OF HUMANITIES public Regular School No Middle 06 08 2020   grade_7 1.0 3.0 99.0                   50.0 53.0     33       93     13   103 1 3 99                   50 53     33   93   13   103
1593136 NY Richmond   school 3601019 353100860984   NEW WORLD PREP CHARTER SCHOO 360101906215 353100860984 NEW WORLD PREP CHARTER SCHOOL charter Regular School Yes Middle KG 08 2020   grade_7 2.0 26.0 99.0   0.0     0.0     1.0   65.0 63.0     16       120     39   128 2 26 99   0     0     1   65 63     16   120   39   128
2052481 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008503740 320800010101 MS 101 EDWARD R BYRNE public Regular School No Middle 06 08 2018   grade_7 31.0 20.0 99.0   5.0     21.0     1.0   76.0 101.0     5       133     39   177 31 20 99   5     21     1   76 101     5   133   39   177
2054172 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605664 320900010323 BRONX WRITING ACADEMY public Regular School No Middle 06 08 2018   grade_7 3.0 54.0 99.0   2.0     0.0     1.0   76.0 83.0     47       153     36   159 3 54 99   2     0     1   76 83     47   153   36   159
2065135 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003308 131500010011 POUGHKEEPSIE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 24.0 169.0 99.0   1.0     3.0     15.0   145.0 166.0     25       268     60   311 24 169 99   1     3     15   145 166     25   268   60   311
2126410 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869005744 580232030012 WILLIAM PACA MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 155.0 63.0 99.0   4.0     11.0     16.0   176.0 172.0     16       236     58   348 155 63 99   4     11     16   176 172     16   236   58   348
2148184 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009000227 321200010214 PS 214 public Regular School No Elementary PK 08 2019   grade_7 3.0 44.0 99.0   1.0     2.0     1.0   75.0 75.0     18       133     29   150 3 44 99   1     2     1   75 75     18   133   29   150
2172751 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009706331 333200010562 EVERGREEN MS-URBAN EXPLORATION public Regular School No Middle 06 08 2019   grade_7 3.0 26.0 99.0         0.0         61.0 67.0     14       122     27   128 3 26 99         0         61 67     14   122   27   128
2190915 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305647 310600010324 MS 324 PATRIA MIRABAL public Regular School No Middle 06 08 2019   grade_7 4.0 15.0 99.0   0.0     1.0         56.0 63.0     43       110     28   119 4 15 99   0     1         56 63     43   110   28   119
751991 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703812 321000010391 ANGELO PATRI MIDDLE SCHOOL (THE) public Regular School No 2.0 06 08 2015   grade_7 3.0 48.0 98.0   1.0     3.0         80.0 73.0             *     *   153 3 48 98   1     3         80 73                 153
779142 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009702799 333200010291 JHS 291 ROLAND HAYES public Regular School No 2 06 08 2015   grade_7 4.0 23.0 98.0   0.0     3.0         63.0 65.0             107     32   128 4 23 98   0     3         63 65         107   32   128
971703 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006419 331900010662 LIBERTY AVENUE MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_7 3.0 32.0 98.0   2.0     2.0         79.0 58.0     30       127     32   137 3 32 98   2     2         79 58     30   127   32   137
993610 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008302519 310600010143 JHS 143 ELEANOR ROOSEVELT public Regular School No Middle 06 08 2017   grade_7 7.0 0.0 98.0               0.0   65.0 40.0     64       71     31   105 7 0 98               0   65 40     64   71   31   105
1012059 NY Rockland   school 3620340 500101060000   CLARKSTOWN 362034005874 500101060023 FELIX FESTA CHARACTER MIDDLE SCHOOL public Regular School No Middle 07 07 2017   grade_7 426.0 23.0 98.0   1.0     105.0     8.0   371.0 290.0     10       *     *   661 426 23 98   1     105     8   371 290     10           661
1018994 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869005579 580232030010 WILLIAM FLOYD MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 193.0 50.0 98.0   0.0     16.0     7.0   187.0 177.0     20       208     36   364 193 50 98   0     16     7   187 177     20   208   36   364
1107173 NY Suffolk   school 3617380 580104030000   LINDENHURST 361738001547 580104030011 LINDENHURST MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 327.0 14.0 98.0   0.0     13.0     2.0   230.0 224.0             169     84   454 327 14 98   0     13     2   230 224         169   84   454
1439255 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702361 321000010095 PS 95 SHEILA MENCHER public Regular School No Elementary KG 08 2021   grade_7 5.0 18.0 98.0   0.0     10.0     3.0   68.0 66.0     23       116     35   134 5 18 98   0     10     3   68 66     23   116   35   134
1530778 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802342 321100010089 PS 89 public Regular School No Elementary PK 08 2020   grade_7 30.0 43.0 98.0   2.0     22.0     0.0   99.0 96.0     28       155     39   195 30 43 98   2     22     0   99 96     28   155   39   195
2054324 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606113 320900010454 SCIENCE AND TECHNOLOGY ACADEMY public Regular School No Middle 06 08 2018   grade_7 0.0 49.0 98.0         4.0     0.0   77.0 74.0     25       138     33   151 0 49 98         4     0   77 74     25   138   33   151
2183543 NY Nassau   school 3610980 280522030000   FARMINGDALE 361098000878 280522030008 HOWITT SCHOOL public Regular School No Middle 06 08 2019   grade_7 245.0 37.0 98.0   1.0     20.0     4.0   218.0 187.0     13       139     66   405 245 37 98   1     20     4   218 187     13   139   66   405
2228136 NY Westchester   school 3631920 662300010000   YONKERS 363192006001 662300010056 PALISADE PREPARATORY SCHOOL public Regular School No High 07 12 2019   grade_7 18.0 41.0 98.0   0.0     10.0     3.0   99.0 71.0     23       161     38   170 18 41 98   0     10     3   99 71     23   161   38   170
967029 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011905701 331400010577 CONSELYEA PREP SCHOOL public Regular School No Middle 06 8 2017   grade_7 68.0 3.0 97.0   0.0     4.0     0.0   70.0 102.0     *       73     34   172 68 3 97   0     4     0   70 102         73   34   172
1034897 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502456 320800010123 JHS 123 JAMES M KIERNAN public Regular School No 2.0 06 08 2016   grade_7 0.0 21.0 97.0         2.0         58.0 62.0             98     41   120 0 21 97         2         58 62         98   41   120
1437773 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604876 320900010232 IS 232 public Regular School No Middle 06 08 2021   grade_7 0.0 27.0 97.0                   71.0 53.0     37       123     20   124 0 27 97                   71 53     37   123   20   124
1502335 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302216 353100010049 IS 49 BERTA A DREYFUS public Regular School No Middle 06 08 2021   grade_7 13.0 75.0 97.0   1.0     25.0     4.0   98.0 117.0     36       187     67   215 13 75 97   1     25     4   98 117     36   187   67   215
1525743 NY Bronx   school 3601070 320700861028   FAMILY LIFE ACADEMY CHARTER 360107006318 320700861028 FAMILY LIFE ACADEMY CHARTER SCH II charter Regular School Yes Elementary KG 08 2020   grade_7 0.0 35.0 97.0   0.0     1.0         59.0 74.0     *       123     14   133 0 35 97   0     1         59 74         123   14   133
1526218 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008503740 320800010101 MS 101 EDWARD R BYRNE public Regular School No Middle 06 08 2020   grade_7 20.0 15.0 97.0   1.0     37.0     1.0   78.0 93.0     *       121     36   171 20 15 97   1     37     1   78 93         121   36   171
1527719 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603742 320900010218 PS/IS 218 R H DUAL LANG MAGNET public Regular School No Elementary KG 08 2020   grade_7 0.0 5.0 97.0   1.0     2.0     0.0   52.0 53.0     15       94     19   105 0 5 97   1     2     0   52 53     15   94   19   105
2078929 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006418 331900010661 VISTA ACADEMY public Regular School No Middle 06 08 2018   grade_7 3.0 39.0 97.0   4.0     9.0     1.0   69.0 84.0     17       148     31   153 3 39 97   4     9     1   69 84     17   148   31   153
2179458 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004528 280211030009 SCHOOL 9M-OCEANSIDE MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_7 308.0 4.0 97.0         15.0     14.0   228.0 210.0     19       101     45   438 308 4 97         15     14   228 210     19   101   45   438
2213848 NY Suffolk   school 3620910 580103030000   NORTH BABYLON 362091004737 580103030002 ROBERT MOSES MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 134.0 98.0 97.0   2.0     15.0     9.0   180.0 175.0     16       172     67   355 134 98 97   2     15     9   180 175     16   172   67   355
834166 NY Westchester   school 3631920 662300010000   YONKERS 363192000452 662300010001 ROBERT C DODSON SCHOOL public Regular School No 1 PK 08 2015   grade_7 1.0 3.0 96.0         2.0     0.0   53.0 49.0             94     14   102 1 3 96         2     0   53 49         94   14   102
949929 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008801989 321100010181 IS 181 PABLO CASALS public Regular School No Middle 06 08 2017   grade_7 8.0 174.0 96.0   3.0     12.0     1.0   147.0 147.0     *       228     71   294 8 174 96   3     12     1   147 147         228   71   294
1040958 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009000227 321200010214 PS 214 public Regular School No 1.0 PK 08 2016   grade_7 6.0 33.0 96.0   3.0     1.0     0.0   73.0 66.0             123     21   139 6 33 96   3     1     0   73 66         123   21   139
1436652 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506302 320800010562 BLUEPRINT MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 12.0 16.0 96.0   6.0     51.0     1.0   77.0 105.0     42       171     41   182 12 16 96   6     51     1   77 105     42   171   41   182
1495438 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202664 342500010194 JHS 194 WILLIAM CARR public Regular School No Middle 06 08 2021   grade_7 108.0 4.0 96.0   1.0     197.0     7.0   228.0 185.0     37       249     57   413 108 4 96   1     197     7   228 185     37   249   57   413
1575067 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008306530 310600010209 HAMILTON GRANGE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 8.0 8.0 96.0   0.0     4.0     1.0   61.0 56.0     18       101     28   117 8 8 96   0     4     1   61 56     18   101   28   117
2051379 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405520 320700010224 PS/IS 224 public Regular School No Middle 06 08 2018   grade_7 0.0 33.0 96.0   0.0     1.0     0.0   69.0 61.0     23       127     38   130 0 33 96   0     1     0   69 61     23   127   38   130
2101672 NY New York   school 3600167 310600860887   NEW HEIGHTS ACAD CHARTER SCH 360016705891 310600860887 NEW HEIGHTS ACADEMY CHARTER SCHOOL charter Regular School Yes High 05 12 2018   grade_7 0.0 3.0 96.0         0.0         50.0 49.0     18       92     13   99 0 3 96         0         50 49     18   92   13   99
2143206 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604461 320900010022 JHS 22 JORDAN L MOTT public Regular School No Middle 06 08 2019   grade_7 5.0 27.0 96.0   0.0     1.0     0.0   67.0 62.0     33       128     33   129 5 27 96   0     1     0   67 62     33   128   33   129
2189775 NY New York   school 3600081 310500010000   NYC GEOG DIST # 5 - MANHATTAN 360008102577 310500010161 PS 161 PEDRO ALBIZU CAMPOS public Regular School No Elementary KG 08 2019   grade_7 4.0 19.0 96.0   0.0     3.0     0.0   60.0 62.0     30       111     34   122 4 19 96   0     3     0   60 62     30   111   34   122
2215900 NY Suffolk   school 3622470 580224030000   PATCHOGUE-MEDFORD 362247003167 580224030011 SAXTON MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 117.0 11.0 96.0   1.0     3.0     4.0   116.0 116.0     30       134     68   232 117 11 96   1     3     4   116 116     30   134   68   232
797876 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305878 310600011346 COMMUNITY HEALTH ACAD OF THE HEIGHTS public Regular School No 4 06 12 2015   grade_7 1.0 5.0 95.0         0.0     0.0   42.0 59.0             93     22   101 1 5 95         0     0   42 59         93   22   101
947763 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702179 321000010020 PS/MS 20 PO GEORGE J WERDAN III public Regular School No Elementary PK 08 2017   grade_7 4.0 13.0 95.0   1.0     18.0     0.0   62.0 69.0     14       121     34   131 4 13 95   1     18     0   62 69     14   121   34   131
973470 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202736 332100010228 IS 228 DAVID A BOODY public Regular School No Middle 06 8 2017   grade_7 173.0 23.0 95.0   1.0     121.0     1.0   189.0 225.0     43       338     63   414 173 23 95   1     121     1   189 225     43   338   63   414
1065639 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009702799 333200010291 JHS 291 ROLAND HAYES public Regular School No 2.0 06 08 2016   grade_7 4.0 9.0 95.0         1.0         60.0 49.0             *     23   109 4 9 95         1         60 49             23   109
1084012 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305782 310600010322 MIDDLE SCHOOL 322 public Regular School No 2.0 06 08 2016   grade_7 0.0 5.0 95.0   1.0     0.0         54.0 47.0             90     21   101 0 5 95   1     0         54 47         90   21   101
1565472 NY Nassau   school 3626520 280252070000   SEWANHAKA 362652003630 280252070006 SEWANHAKA HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 35.0 67.0 95.0   0.0     68.0     6.0   130.0 141.0     10       156     20   271 35 67 95   0     68     6   130 141     10   156   20   271
2101767 NY New York   school 3601139 310600861101   SCHOOL IN THE SQUARE PUBLIC 360113906571 310600861101 SCHOOL IN THE SQUARE PUBLIC CS charter Regular School Yes Middle 06 07 2018   grade_7 1.0 5.0 95.0               0.0   47.0 54.0     9       88     18   101 1 5 95               0   47 54     9   88   18   101
2146835 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802469 321100010127 JHS 127 CASTLE HILL (THE) public Regular School No Middle 06 08 2019   grade_7 5.0 54.0 95.0   5.0     78.0     2.0   117.0 122.0     29       *     *   239 5 54 95   5     78     2   117 122     29           239
2168685 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006483 331900010760 HIGHLAND PARK COMMUNITY SCHOOL public Regular School No Middle 06 08 2019   grade_7 0.0 20.0 95.0   6.0     1.0         66.0 56.0     *       115     28   122 0 20 95   6     1         66 56         115   28   122
2223861 NY Westchester   school 3619950 660102060000   BEDFORD 361995001823 660102060005 FOX LANE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 155.0 7.0 95.0         8.0     10.0   140.0 135.0     21       94     32   275 155 7 95         8     10   140 135     21   94   32   275
747317 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405786 320700010298 ACADEMY OF PUBLIC RELATIONS public Regular School No 2.0 06 08 2015   grade_7 2.0 37.0 94.0   1.0     1.0         63.0 72.0             114     40   135 2 37 94   1     1         63 72         114   40   135
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
946908 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606394 320900010361 HIGHBRIDGE GREEN SCHOOL (THE) public Regular School No Middle 06 08 2017   grade_7 2.0 39.0 94.0   1.0     0.0         67.0 69.0     33       133     40   136 2 39 94   1     0         67 69     33   133   40   136
946965 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606113 320900010454 SCIENCE AND TECHNOLOGY ACADEMY public Regular School No Middle 06 08 2017   grade_7 1.0 35.0 94.0   0.0     2.0         74.0 58.0     26       *     40   132 1 35 94   0     2         74 58     26       40   132
957795 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003308 131500010011 POUGHKEEPSIE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 25.0 161.0 94.0   0.0     3.0     12.0   166.0 129.0     39       *     55   295 25 161 94   0     3     12   166 129     39       55   295
973546 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202792 332100010281 IS 281 JOSEPH B CAVALLARO public Regular School No Middle 06 8 2017   grade_7 116.0 25.0 94.0   0.0     167.0     3.0   238.0 167.0     60       338     74   405 116 25 94   0     167     3   238 167     60   338   74   405
994294 NY New York   school 3600167 310600860887   NEW HEIGHTS ACAD CHARTER SCH 360016705891 310600860887 NEW HEIGHTS ACADEMY CHARTER SCHOOL charter Regular School Yes Other 05 12 2017   grade_7 0.0 3.0 94.0                   46.0 51.0     12       93     13   97 0 3 94                   46 51     12   93   13   97
1017436 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004235 580109020004 MILTON L OLIVE MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_7 2.0 77.0 94.0         2.0     1.0   103.0 73.0     28       153     39   176 2 77 94         2     1   103 73     28   153   39   176
1441193 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805558 321100010194 PS/MS 194 public Regular School No Elementary KG 08 2021   grade_7 6.0 16.0 94.0   7.0     49.0     0.0   85.0 87.0     27       137     28   172 6 16 94   7     49     0   85 87     27   137   28   172
1466786 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009702799 333200010291 JHS 291 ROLAND HAYES public Regular School No Middle 06 08 2021   grade_7 0.0 10.0 94.0   0.0     3.0         56.0 51.0     36       100     24   107 0 10 94   0     3         56 51     36   100   24   107
1575561 NY New York   school 3600167 310600860887   NEW HEIGHTS ACAD CHARTER SCH 360016705891 310600860887 NEW HEIGHTS ACADEMY CHARTER SCHOOL charter Regular School Yes High 05 12 2020   grade_7 1.0 8.0 94.0         2.0     0.0   52.0 53.0     20       95     19   105 1 8 94         2     0   52 53     20   95   19   105
2052595 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008501979 320800010131 JHS 131 ALBERT EINSTEIN public Regular School No Middle 06 08 2018   grade_7 2.0 47.0 94.0   1.0     3.0     0.0   74.0 73.0     19       116     48   147 2 47 94   1     3     0   74 73     19   116   48   147
2054248 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603780 320900010339 IS 339 public Regular School No Middle 06 08 2018   grade_7 2.0 45.0 94.0   1.0     5.0     0.0   76.0 71.0     38       136     38   147 2 45 94   1     5     0   76 71     38   136   38   147
2055882 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705675 321000010331 BRONX SCHOOL OF YOUNG LEADERS (THE) public Regular School No Middle 06 08 2018   grade_7   39.0 94.0         1.0     0.0   77.0 57.0     30       115     32   134   39 94         1     0   77 57     30   115   32   134
2074369 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011905701 331400010577 CONSELYEA PREP SCHOOL public Regular School No Middle 06 08 2018   grade_7 64.0 12.0 94.0         3.0     1.0   76.0 98.0     6       99     36   174 64 12 94         3     1   76 98     6   99   36   174
2145562 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705675 321000010331 BRONX SCHOOL OF YOUNG LEADERS (THE) public Regular School No Middle 06 08 2019   grade_7 0.0 39.0 94.0         4.0     0.0   73.0 64.0     25       120     29   137 0 39 94         4     0   73 64     25   120   29   137
2191257 NY New York   school 3600167 310600860887   NEW HEIGHTS ACAD CHARTER SCH 360016705891 310600860887 NEW HEIGHTS ACADEMY CHARTER SCHOOL charter Regular School Yes High 05 12 2019   grade_7 0.0 9.0 94.0         0.0         53.0 50.0     15       96     17   103 0 9 94         0         53 50     15   96   17   103
2206134 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202688 343000010204 IS 204 OLIVER W HOLMES public Regular School No Middle 06 08 2019   grade_7 12.0 30.0 94.0   0.0     24.0     0.0   86.0 74.0     24       141     39   160 12 30 94   0     24     0   86 74     24   141   39   160
822899 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800192 580235060004 BELLPORT MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_7 120.0 82.0 93.0   1.0     10.0     5.0   159.0 152.0             187     41   311 120 82 93   1     10     5   159 152         187   41   311
948523 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705675 321000010331 BRONX SCHOOL OF YOUNG LEADERS (THE) public Regular School No Middle 06 08 2017   grade_7 1.0 17.0 93.0         1.0         52.0 60.0     *       86     24   112 1 17 93         1         52 60         86   24   112
1022623 NY Suffolk   school 3613530 580905020000   HAMPTON BAYS 361353006043 580905020004 HAMPTON BAYS MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_7 81.0 0.0 93.0   0.0     1.0     3.0   93.0 85.0     *       100     16   178 81 0 93   0     1     3   93 85         100   16   178
1033776 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405520 320700010224 PS/IS 224 public Regular School No 2.0 06 08 2016   grade_7 1.0 29.0 93.0   2.0     1.0         66.0 60.0             124     40   126 1 29 93   2     1         66 60         124   40   126
1034954 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008501979 320800010131 JHS 131 ALBERT EINSTEIN public Regular School No 2.0 06 08 2016   grade_7 0.0 56.0 93.0   0.0     2.0         81.0 70.0             *     52   151 0 56 93   0     2         81 70             52   151
1036626 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605664 320900010323 BRONX WRITING ACADEMY public Regular School No 2.0 05 08 2016   grade_7 2.0 44.0 93.0   0.0     3.0         58.0 84.0             *     *   142 2 44 93   0     3         58 84                 142
1063530 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202792 332100010281 IS 281 JOSEPH B CAVALLARO public Regular School No 2.0 05 8 2016   grade_7 120.0 26.0 93.0   1.0     129.0     3.0   196.0 176.0             299     57   372 120 26 93   1     129     3   196 176         299   57   372
1101492 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010301974 353100010072 IS 72 ROCCO LAURIE public Regular School No 2.0 05 08 2016   grade_7 211.0 20.0 93.0   1.0     94.0     3.0   227.0 195.0             264     98   422 211 20 93   1     94     3   227 195         264   98   422
1438039 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606113 320900010454 SCIENCE AND TECHNOLOGY ACADEMY public Regular School No Middle 06 08 2021   grade_7 3.0 35.0 93.0   1.0     5.0     0.0   69.0 68.0     22       134     29   137 3 35 93   1     5     0   69 68     22   134   29   137
1464259 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202367 332100010096 IS 96 SETH LOW public Regular School No Middle 06 08 2021   grade_7 90.0 20.0 93.0   1.0     77.0     2.0   159.0 124.0     75       226     68   283 90 20 93   1     77     2   159 124     75   226   68   283
1466938 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009706331 333200010562 EVERGREEN MS-URBAN EXPLORATION public Regular School No Middle 06 08 2021   grade_7 4.0 19.0 93.0         0.0         59.0 57.0     22       104     32   116 4 19 93         0         59 57     22   104   32   116
1501974 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302120 353100010024 IS 24 MYRA S BARNES public Regular School No Middle 06 08 2021   grade_7 315.0 10.0 93.0   1.0     48.0     8.0   241.0 234.0     8       232     127   475 315 10 93   1     48     8   241 234     8   232   127   475
1557036 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009706331 333200010562 EVERGREEN MS-URBAN EXPLORATION public Regular School No Middle 06 08 2020   grade_7 4.0 24.0 93.0         1.0         68.0 54.0     23       115     29   122 4 24 93         1         68 54     23   115   29   122
2058599 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005691 321200010316 KAPPA III public Regular School No Middle 06 08 2018   grade_7 0.0 35.0 93.0   1.0     2.0         65.0 66.0     13       116     38   131 0 35 93   1     2         65 66     13   116   38   131
2111837 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012201996 342500010237 IS 237 public Regular School No Middle 06 08 2018   grade_7 8.0 35.0 93.0   3.0     360.0     4.0   286.0 217.0     114       425     67   503 8 35 93   3     360     4   286 217     114   425   67   503
2120121 NY Rockland   school 3628320 500401060000   SUFFERN 362832003817 500401060011 SUFFERN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 215.0 11.0 93.0   0.0     19.0     15.0   164.0 189.0     7       102     64   353 215 11 93   0     19     15   164 189     7   102   64   353
2155423 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004026 132101060010 WAPPINGERS JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   grade_7 226.0 40.0 93.0         17.0     8.0   211.0 173.0     8       154     69   384 226 40 93         17     8   211 173     8   154   69   384

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