enrollments

Data source: Big Local News · About: Big Local

4,236 rows where grade = "grade_7" and state = "CO" sorted by black_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 4,236 ✖
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
709230 709230 CO     school 802910 130   CHERRY CREEK 5 80291000201 7158 PRAIRIE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 145 161 231   3 26     2   42   328 282                       610 145 161 231   3 26     2   42   328 282                 610
1895119 1895119 CO     school 802910 130   CHERRY CREEK 5 80291000201 7158 PRAIRIE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 120 154 221   3 28     7   37   297 273                       570 120 154 221   3 28     7   37   297 273                 570
1932423 1932423 CO     school 802910 130   CHERRY CREEK 5 80291000201 7158 PRAIRIE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 132 154 242   9 18     3   40   306 292                       598 132 154 242   9 18     3   40   306 292                 598
1800757 1800757 CO     school 802910 130   Cherry Creek 5 80291000201 7158 Prairie Middle School   Regular School No Middle 06 08 2020   grade_7 101 145 213   5 29     4   34   286 245                       531 101 145 213   5 29     4   34   286 245                 531
836875 836875 CO     school 802910 130   CHERRY CREEK 5 80291000201 7158 PRAIRIE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 130 144 240   8 34     2   42   308 292                       600 130 144 240   8 34     2   42   308 292                 600
1134591 1134591 CO     school 802910 130   CHERRY CREEK 5 80291000201 7158 PRAIRIE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 153.0 136.0 196.0   5.0 32.0     1.0   34.0   303.0 254.0                       557.0 153 136 196   5 32     1   34   303 254                 557
1739710 1739710 CO     school 802910 130   Cherry Creek 5 80291000201 7158 Prairie Middle School   Regular School No Middle 06 08 2021   grade_7 97 130 187   2 24     3   44   243 244                       487 97 130 187   2 24     3   44   243 244                 487
1134902 1134902 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000054 464 AURORA HILLS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 26.0 83.0 182.0   1.0 12.0     1.0   10.0   193.0 122.0                       315.0 26 83 182   1 12     1   10   193 122                 315
837394 837394 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000073 6160 MRACHEK MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 66 75 127   3 12     7   12   170 132                       302 66 75 127   3 12     7   12   170 132                 302
1803459 1803459 CO     school 803360 880   Denver County 1 80336000364 3990 Hill Campus of Arts and Sciences   Regular School No Middle 06 08 2020   grade_7 131 75 87   2 7     0   16   152 166                       318 131 75 87   2 7     0   16   152 166                 318
1897789 1897789 CO     school 803360 880   DENVER COUNTY 1 80336000361 3746 HAMILTON MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 80 73 123   3 18     0   17   166 148                       314 80 73 123   3 18     0   17   166 148                 314
1932954 1932954 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000073 6160 MRACHEK MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 40 72 162   1 19     5   20   172 147                       319 40 72 162   1 19     5   20   172 147                 319
1134481 1134481 CO     school 802910 130   CHERRY CREEK 5 80291001328 4100 HORIZON MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 145.0 71.0 82.0   4.0 18.0     0.0   21.0   186.0 155.0                       341.0 145 71 82   4 18     0   21   186 155                 341
1801289 1801289 CO     school 802340 180   Adams-Arapahoe 28J 80234000073 6160 Mrachek Middle School   Regular School No Middle 06 08 2020   grade_7 55 70 178   1 14     7   25   177 173                       350 55 70 178   1 14     7   25   177 173                 350
1803721 1803721 CO     school 803360 880   Denver County 1 80336006562 5897 McAuliffe International School   Regular School No Middle 06 08 2020   grade_7 327 70 79   1 11     0   43   287 244                       531 327 70 79   1 11     0   43   287 244                 531
1895439 1895439 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000054 464 AURORA HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 27 70 147   0 10     1   23   151 127                       278 27 70 147   0 10     1   23   151 127                 278
1134510 1134510 CO     school 802910 130   CHERRY CREEK 5 80291000197 4975 LAREDO MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 183.0 69.0 85.0   1.0 28.0     0.0   16.0   197.0 185.0                       382.0 183 69 85   1 28     0   16   197 185                 382
836793 836793 CO     school 802910 130   CHERRY CREEK 5 80291000197 4975 LAREDO MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 190 68 87   2 27     4   23   206 195                       401 190 68 87   2 27     4   23   206 195                 401
1895751 1895751 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000079 8078 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 16 67 183   4 13     7   10   163 137                       300 16 67 183   4 13     7   10   163 137                 300
709539 709539 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000054 464 AURORA HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 31 66 168   2 13     2   12   147 147                       294 31 66 168   2 13     2   12   147 147                 294
1800637 1800637 CO     school 802910 130   Cherry Creek 5 80291001328 4100 Horizon Middle School   Regular School No Middle 06 08 2020   grade_7 112 65 111   1 22     1   30   184 158                       342 112 65 111   1 22     1   30   184 158                 342
1135100 1135100 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000073 6160 MRACHEK MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 58.0 64.0 150.0   2.0 9.0     0.0   13.0   173.0 123.0                       296.0 58 64 150   2 9     0   13   173 123                 296
1739631 1739631 CO     school 802910 130   Cherry Creek 5 80291000197 4975 Laredo Middle School   Regular School No Middle 06 08 2021   grade_7 129 62 97   5 25     0   29   177 170                       347 129 62 97   5 25     0   29   177 170                 347
709749 709749 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000073 6160 MRACHEK MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 56 61 130   1 10     1   16   150 125                       275 56 61 130   1 10     1   16   150 125                 275
837185 837185 CO     school   180   ADAMS-ARAPAHOE 28J   464 AURORA HILLS MIDDLE SCHOOL             2016   grade_7 41 61 189   0 4     3   14   151 161                       312 41 61 189   0 4     3   14   151 161                 312
1742068 1742068 CO     school 803360 880   Denver County 1 80336006566 2115 DSST: Montview Middle School   Regular School Yes Middle 06 08 2021   grade_7 30 61 49   0 11     0   6   92 65                       157 30 61 49   0 11     0   6   92 65                 157
1801082 1801082 CO     school 802340 180   Adams-Arapahoe 28J 80234000054 464 Aurora Hills Middle School   Regular School No Middle 06 08 2020   grade_7 16 61 154   4 7     4   18   147 117                       264 16 61 154   4 7     4   18   147 117                 264
836764 836764 CO     school 802910 130   CHERRY CREEK 5 80291001328 4100 HORIZON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 131 59 78   5 16     0   32   174 147                       321 131 59 78   5 16     0   32   174 147                 321
1134951 1134951 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001322 1800 COLUMBIA MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 86.0 59.0 99.0   2.0 14.0     0.0   16.0   143.0 133.0                       276.0 86 59 99   2 14     0   16   143 133                 276
1801393 1801393 CO     school 802340 180   Adams-Arapahoe 28J 80234000079 8078 South Middle School   Regular School No Middle 06 08 2020   grade_7 9 59 155   2 4     10   12   129 122                       251 9 59 155   2 4     10   12   129 122                 251
1932743 1932743 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000054 464 AURORA HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 26 59 161   5 9     2   14   135 141                       276 26 59 161   5 9     2   14   135 141                 276
709149 709149 CO     school 802910 130   CHERRY CREEK 5 80291000197 4975 LAREDO MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 171 58 79   1 31     0   18   182 176                       358 171 58 79   1 31     0   18   182 176                 358
709113 709113 CO     school 802910 130   CHERRY CREEK 5 80291001328 4100 HORIZON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 145 57 88   3 7     0   22   180 142                       322 145 57 88   3 7     0   22   180 142                 322
837262 837262 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000060 2384 EAST MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 25 57 257   4 14     2   11   192 178                       370 25 57 257   4 14     2   11   192 178                 370
1135196 1135196 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000079 8078 SOUTH MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 21.0 57.0 187.0   3.0 12.0     2.0   12.0   142.0 152.0                       294.0 21 57 187   3 12     2   12   142 152                 294
1742702 1742702 CO     school 803360 880   Denver County 1 80336006562 5897 McAuliffe International School   Regular School No Middle 06 08 2021   grade_7 349 56 78   2 17     0   41   278 265                       543 349 56 78   2 17     0   41   278 265                 543
1895001 1895001 CO     school 802910 130   CHERRY CREEK 5 80291001328 4100 HORIZON MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 135 56 87   5 12     2   22   181 138                       319 135 56 87   5 12     2   22   181 138                 319
1934780 1934780 CO     school 803360 880   DENVER COUNTY 1 80336006566 2115 DSST: STAPLETON MIDDLE SCHOOL   Regular School Yes Middle 06 08 2019   grade_7 18 56 73   0 3     2   8   91 69                       160 18 56 73   0 3     2   8   91 69                 160
1137208 1137208 CO     school 803360 880   DENVER COUNTY 1 80336000364 3990 HILL CAMPUS OF ARTS AND SCIENCES   Regular School No 2.0 06 08 2015   grade_7 60.0 55.0 88.0   0.0 5.0     0.0   9.0   117.0 100.0                       217.0 60 55 88   0 5     0   9   117 100                 217
1740250 1740250 CO     school 802340 180   Adams-Arapahoe 28J 80234000073 6160 Mrachek Middle School   Regular School No Middle 06 08 2021   grade_7 41 55 150   3 11     5   18   144 139                       283 41 55 150   3 11     5   18   144 139                 283
1895650 1895650 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000073 6160 MRACHEK MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 48 55 141   1 13     4   17   136 143                       279 48 55 141   1 13     4   17   136 143                 279
1897456 1897456 CO     school 803360 880   DENVER COUNTY 1 80336006566 2115 DSST: STAPLETON MIDDLE SCHOOL   Regular School Yes Middle 06 08 2018   grade_7 21 55 68   2 4     0   8   76 82                       158 21 55 68   2 4     0   8   76 82                 158
837490 837490 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000079 8078 SOUTH MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 20 54 162   2 4     0   5   127 120                       247 20 54 162   2 4     0   5   127 120                 247
1739590 1739590 CO     school 802910 130   Cherry Creek 5 80291001328 4100 Horizon Middle School   Regular School No Middle 06 08 2021   grade_7 103 54 116   2 13     1   20   173 136                       309 103 54 116   2 13     1   20   173 136                 309
1895038 1895038 CO     school 802910 130   CHERRY CREEK 5 80291000197 4975 LAREDO MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 178 53 81   3 25     2   29   182 189                       371 178 53 81   3 25     2   29   182 189                 371
1895168 1895168 CO     school 802910 130   CHERRY CREEK 5 80291000034 8848 THUNDER RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 231 53 77   3 40     2   21   227 200                       427 231 53 77   3 40     2   21   227 200                 427
1935120 1935120 CO     school 803360 880   DENVER COUNTY 1 80336000361 3746 HAMILTON MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 67 53 127   1 15     0   6   137 132                       269 67 53 127   1 15     0   6   137 132                 269
839520 839520 CO     school 803360 880   DENVER COUNTY 1 80336000361 3746 HAMILTON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 116 52 114   0 9     1   14   170 136                       306 116 52 114   0 9     1   14   170 136                 306
1137186 1137186 CO     school 803360 880   DENVER COUNTY 1 80336000361 3746 HAMILTON MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 102.0 52.0 99.0   2.0 10.0     0.0   12.0   119.0 158.0                       277.0 102 52 99   2 10     0   12   119 158                 277
711910 711910 CO     school 803360 880   DENVER COUNTY 1 80336000364 3990 HILL CAMPUS OF ARTS AND SCIENCES   Regular School No Middle 06 08 2017   grade_7 105 51 88   1 11     0   12   120 148                       268 105 51 88   1 11     0   12   120 148                 268
1134979 1134979 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000060 2384 EAST MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 22.0 51.0 229.0   1.0 16.0     1.0   9.0   164.0 165.0                       329.0 22 51 229   1 16     1   9   164 165                 329
1935401 1935401 CO     school 803360 880   DENVER COUNTY 1 80336006562 5897 MCAULIFFE INTERNATIONAL SCHOOL   Regular School No Middle 06 08 2019   grade_7 327 51 58   5 10     1   43   268 227                       495 327 51 58   5 10     1   43   268 227                 495
1740031 1740031 CO     school 802340 180   Adams-Arapahoe 28J 80234000054 464 Aurora Hills Middle School   Regular School No Middle 06 08 2021   grade_7 19 50 139   1 12     6   14   126 115                       241 19 50 139   1 12     6   14   126 115                 241
1800678 1800678 CO     school 802910 130   Cherry Creek 5 80291000197 4975 Laredo Middle School   Regular School No Middle 06 08 2020   grade_7 136 50 86   4 25     2   24   166 161                       327 136 50 86   4 25     2   24   166 161                 327
1897811 1897811 CO     school 803360 880   DENVER COUNTY 1 80336000364 3990 HILL CAMPUS OF ARTS AND SCIENCES   Regular School No Middle 06 08 2018   grade_7 89 50 82   1 2     0   19   134 109                       243 89 50 82   1 2     0   19   134 109                 243
1935142 1935142 CO     school 803360 880   DENVER COUNTY 1 80336000364 3990 HILL CAMPUS OF ARTS AND SCIENCES   Regular School No Middle 06 08 2019   grade_7 94 50 55   1 5     0   17   109 113                       222 94 50 55   1 5     0   17   109 113                 222
711888 711888 CO     school 803360 880   DENVER COUNTY 1 80336000361 3746 HAMILTON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 109 49 115   0 13     0   21   155 152                       307 109 49 115   0 13     0   21   155 152                 307
839300 839300 CO     school 803360 880   DENVER COUNTY 1 80336006618 2218 DSST: CONSERVATORY GREEN MIDDLE SCHOOL   Regular School Yes 2.0 06 07 2016   grade_7 30 49 54   0 6     0   9   85 63                       148 30 49 54   0 6     0   9   85 63                 148
1739369 1739369 CO     school 802910 130   Cherry Creek 5 80291001878 141 Sky Vista Middle School   Regular School No Middle 06 08 2021   grade_7 146 49 57   0 28     0   41   165 156                       321 146 49 57   0 28     0   41   165 156                 321
1742438 1742438 CO     school 803360 880   Denver County 1 80336000364 3990 Hill Campus of Arts and Sciences   Regular School No Middle 06 08 2021   grade_7 124 49 69   0 8     1   15   129 137                       266 124 49 69   0 8     1   15   129 137                 266
1801132 1801132 CO     school 802340 180   Adams-Arapahoe 28J 80234001322 1800 Columbia Middle School   Regular School No Middle 06 08 2020   grade_7 55 49 116   2 7     1   27   136 121                       257 55 49 116   2 7     1   27   136 121                 257
841388 841388 CO     school 804530 980   HARRISON 2 80453000669 6686 PANORAMA MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 40 48 71   2 5     2   4   90 82                       172 40 48 71   2 5     2   4   90 82                 172
1932095 1932095 CO     school 802910 130   CHERRY CREEK 5 80291001878 141 SKY VISTA MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 144 47 55   1 20     0   17   165 119                       284 144 47 55   1 20     0   17   165 119                 284
709589 709589 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001322 1800 COLUMBIA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 71 46 117   4 10     1   21   150 120                       270 71 46 117   4 10     1   21   150 120                 270
1899842 1899842 CO     school 804080 1000   FOUNTAIN 8 80408000561 1332 CARSON MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 98 46 63   1 3     2   21   133 101                       234 98 46 63   1 3     2   21   133 101                 234
1932342 1932342 CO     school 802910 130   CHERRY CREEK 5 80291000197 4975 LAREDO MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 186 46 85   4 21     4   24   183 187                       370 186 46 85   4 21     4   24   183 187                 370
1932474 1932474 CO     school 802910 130   CHERRY CREEK 5 80291000034 8848 THUNDER RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 250 46 77   1 22     2   32   226 204                       430 250 46 77   1 22     2   32   226 204                 430
1135115 1135115 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000074 6310 NORTH MIDDLE SCHOOL HEALTH SCIENCES AND TECHNOLOGY CAMPUS   Regular School No 2.0 06 08 2015   grade_7 19.0 45.0 204.0   4.0 8.0     0.0   6.0   132.0 154.0                       286.0 19 45 204   4 8     0   6   132 154                 286
1137369 1137369 CO     school 803360 880   DENVER COUNTY 1 80336001406 5605 MARTIN LUTHER KING JR. EARLY COLLEGE   Regular School No 4.0 06 12 2015   grade_7 5.0 45.0 78.0   0.0 3.0     2.0   4.0   76.0 61.0                       137.0 5 45 78   0 3     2   4   76 61                 137
1800809 1800809 CO     school 802910 130   Cherry Creek 5 80291000034 8848 Thunder Ridge Middle School   Regular School No Middle 06 08 2020   grade_7 219 45 100   3 14     2   30   217 196                       413 219 45 100   3 14     2   30   217 196                 413
1895489 1895489 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001322 1800 COLUMBIA MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 76 45 104   0 13     1   23   138 124                       262 76 45 104   0 13     1   23   138 124                 262
1934904 1934904 CO     school 803360 880   DENVER COUNTY 1 80336006618 2218 DSST: CONSERVATORY GREEN MIDDLE SCHOOL   Regular School Yes Middle 06 08 2019   grade_7 22 45 83   2 5     0   9   88 78                       166 22 45 83   2 5     0   9   88 78                 166
1136920 1136920 CO     school 803360 880   DENVER COUNTY 1 80336006546 2181 DSST: GREEN VALLEY RANCH MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2015   grade_7 11.0 44.0 69.0   1.0 15.0     0.0   8.0   82.0 66.0                       148.0 11 44 69   1 15     0   8   82 66                 148
1894955 1894955 CO     school 802910 130   CHERRY CREEK 5 80291006367 3030 FOX RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 355 44 62   3 35     0   22   264 257                       521 355 44 62   3 35     0   22   264 257                 521
1933056 1933056 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000079 8078 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 15 44 179   3 9     6   12   149 119                       268 15 44 179   3 9     6   12   149 119                 268
708899 708899 CO     school 802910 130   CHERRY CREEK 5 80291001711 18 LIBERTY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 225 43 47   3 41     1   25   207 178                       385 225 43 47   3 41     1   25   207 178                 385
709277 709277 CO     school 802910 130   CHERRY CREEK 5 80291000034 8848 THUNDER RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 251 43 74   2 38     2   26   227 209                       436 251 43 74   2 38     2   26   227 209                 436
709617 709617 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000060 2384 EAST MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 19 43 232   1 11     4   16   179 147                       326 19 43 232   1 11     4   16   179 147                 326
841545 841545 CO     school 804080 1000   FOUNTAIN 8 80408000561 1332 CARSON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 92 43 57   2 3     5   25   101 126                       227 92 43 57   2 3     5   25   101 126                 227
1803437 1803437 CO     school 803360 880   Denver County 1 80336000361 3746 Hamilton Middle School   Regular School No Middle 06 08 2020   grade_7 53 43 114   1 12     2   18   126 117                       243 53 43 114   1 12     2   18   126 117                 243
1805342 1805342 CO     school 804530 980   Harrison 2 80453000669 6686 Panorama Middle School   Regular School No Middle 06 08 2020   grade_7 39 43 125   1 7     3   27   131 114                       245 39 43 125   1 7     3   27   131 114                 245
1897577 1897577 CO     school 803360 880   DENVER COUNTY 1 80336006618 2218 DSST: CONSERVATORY GREEN MIDDLE SCHOOL   Regular School Yes Middle 06 08 2018   grade_7 22 43 69   1 9     0   3   75 72                       147 22 43 69   1 9     0   3   75 72                 147
839188 839188 CO     school 803360 880   DENVER COUNTY 1 80336006566 2115 DSST: STAPLETON MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2016   grade_7 36 42 55   1 7     0   9   73 77                       150 36 42 55   1 7     0   9   73 77                 150
839543 839543 CO     school 803360 880   DENVER COUNTY 1 80336000364 3990 HILL CAMPUS OF ARTS AND SCIENCES   Regular School No 2.0 06 08 2016   grade_7 80 42 80   0 8     0   17   113 114                       227 80 42 80   0 8     0   17   113 114                 227
1740226 1740226 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2021   grade_7 13 42 42   0 1     0   2   54 46                       100 13 42 42   0 1     0   2   54 46                 100
1742133 1742133 CO     school 803360 880   Denver County 1 80336006546 2181 DSST: Green Valley Ranch Middle School   Regular School Yes Middle 06 08 2021   grade_7 9 42 93   0 11     7   3   94 71                       165 9 42 93   0 11     7   3   94 71                 165
1803091 1803091 CO     school 803360 880   Denver County 1 80336006566 2115 DSST: Montview Middle School   Regular School Yes Middle 06 08 2020   grade_7 34 42 58   0 6     1   20   102 59                       161 34 42 58   0 6     1   20   102 59                 161
1937219 1937219 CO     school 804080 1000   FOUNTAIN 8 80408000561 1332 CARSON MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 105 42 50   3 3     5   19   105 122                       227 105 42 50   3 3     5   19   105 122                 227
839241 839241 CO     school 803360 880   DENVER COUNTY 1 80336006546 2181 DSST: GREEN VALLEY RANCH MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2016   grade_7 14 41 83   0 13     2   8   85 76                       161 14 41 83   0 13     2   8   85 76                 161
1800419 1800419 CO     school 802910 130   Cherry Creek 5 80291001878 141 Sky Vista Middle School   Regular School No Middle 06 08 2020   grade_7 144 41 68   0 27     0   23   160 143                       303 144 41 68   0 27     0   23   160 143                 303
1899684 1899684 CO     school 804530 980   HARRISON 2 80453000669 6686 PANORAMA MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 35 41 91   1 3     0   13   84 100                       184 35 41 91   1 3     0   13   84 100                 184
708903 708903 CO     school 802910 130   CHERRY CREEK 5 80291001878 141 SKY VISTA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 135 40 55   1 25     1   15   136 136                       272 135 40 55   1 25     1   15   136 136                 272
837234 837234 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001322 1800 COLUMBIA MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 85 40 126   2 15     0   6   145 129                       274 85 40 126   2 15     0   6   145 129                 274
1134638 1134638 CO     school 802910 130   CHERRY CREEK 5 80291000034 8848 THUNDER RIDGE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 276.0 40.0 75.0   1.0 30.0     0.0   32.0   225.0 229.0                       454.0 276 40 75   1 30     0   32   225 229                 454
1739762 1739762 CO     school 802910 130   Cherry Creek 5 80291000034 8848 Thunder Ridge Middle School   Regular School No Middle 06 08 2021   grade_7 195 40 96   2 25     2   29   194 195                       389 195 40 96   2 25     2   29   194 195                 389
1803156 1803156 CO     school 803360 880   Denver County 1 80336006546 2181 DSST: Green Valley Ranch Middle School   Regular School Yes Middle 06 08 2020   grade_7 9 40 91   0 11     1   7   80 79                       159 9 40 91   0 11     1   7   80 79                 159
1897585 1897585 CO     school 803360 880   DENVER COUNTY 1 80336006624 2227 DENVER DISCOVERY SCHOOL   Regular School No Middle 06 08 2018   grade_7 58 40 32   0 4     1   11   97 49                       146 58 40 32   0 4     1   11   97 49                 146
1932304 1932304 CO     school 802910 130   CHERRY CREEK 5 80291001328 4100 HORIZON MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 143 40 99   1 12     2   22   162 157                       319 143 40 99   1 12     2   22   162 157                 319
709847 709847 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000079 8078 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 14 39 157   0 9     6   7   129 103                       232 14 39 157   0 9     6   7   129 103                 232
711617 711617 CO     school 803360 880   DENVER COUNTY 1 80336006546 2181 DSST: GREEN VALLEY RANCH MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 6 39 87   1 8     0   5   73 73                       146 6 39 87   1 8     0   5   73 73                 146

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