Data source: Big Local News · About: Big Local

603 rows where grade = "grade_7", state = "CO" and year = 2018 sorted by total_int descending

View and edit SQL

year

  • 2018 · 603

grade

  • grade_7 · 603
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 ▲
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
1899071 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001747 6164 MOUNTAIN RIDGE MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 437 3 69   1 25     2   25   296 266                       562 437 3 69   1 25     2   25   296 266                 562
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
1899217 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001962 7448 ROCKY HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 384 4 53   1 31     1   10   263 221                       484 384 4 53   1 31     1   10   263 221                 484
1894861 CO     school 802910 130   CHERRY CREEK 5 80291000185 1566 CAMPUS MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 288 20 50   1 84     2   29   251 223                       474 288 20 50   1 84     2   29   251 223                 474
1898644 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006404 264 CIMARRON MIDDLE   Regular School No Middle 06 08 2018   grade_7 360 2 67   3 8     1   28   242 227                       469 360 2 67   3 8     1   28   242 227                 469
1894865 CO     school 802910 130   CHERRY CREEK 5 80291000207 1568 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 331 5 75   3 28     1   18   220 241                       461 331 5 75   3 28     1   18   220 241                 461
1899191 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001528 7245 RANCH VIEW MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 353 2 58   1 9     0   23   247 199                       446 353 2 58   1 9     0   23   247 199                 446
1893843 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001726 57 ROCKY TOP MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 314 8 84   1 21     0   15   215 228                       443 314 8 84   1 21     0   15   215 228                 443
1898807 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000438 2226 CASTLE ROCK MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 324 5 76   1 13     2   16   229 208                       437 324 5 76   1 13     2   16   229 208                 437
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
1898804 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006219 2012 CRESTHILL MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 310 11 58   1 19     0   26   224 201                       425 310 11 58   1 19     0   26   224 201                 425
1900731 CO     school 805820 1080   LEWIS-PALMER 38 80582001002 5098 LEWIS-PALMER MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 337 4 52   2 8     1   21   234 191                       425 337 4 52   2 8     1   21   234 191                 425
1899121 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001582 6773 SIERRA MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 316 5 64   3 8     2   17   216 199                       415 316 5 64   3 8     2   17   216 199                 415
1894787 CO     school 802910 130   CHERRY CREEK 5 80291001711 18 LIBERTY MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 227 37 56   5 43     1   28   219 178                       397 227 37 56   5 43     1   28   219 178                 397
1898666 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006371 267 MESA MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 290 3 65   6 8     3   15   194 196                       390 290 3 65   6 8     3   15   194 196                 390
1894012 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001179 4187 SILVER HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 153 8 189   2 19     0   14   195 190                       385 153 8 189   2 19     0   14   195 190                 385
1898063 CO     school 803360 880   DENVER COUNTY 1 80336006562 5897 MCAULIFFE INTERNATIONAL SCHOOL   Regular School No Middle 06 08 2018   grade_7 249 37 60   2 10     0   27   191 194                       385 249 37 60   2 10     0   27   191 194                 385
1894201 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001194 9444 WESTLAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 253 7 85   1 12     0   24   203 179                       382 253 7 85   1 12     0   24   203 179                 382
1903301 CO     school 803990 1550   POUDRE R-1 80399001091 7161 PRESTON MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 322 2 32   0 12     1   8   207 170                       377 322 2 32   0 12     1   8   207 170                 377
1900618 CO     school 801920 1040   ACADEMY 20 80192001462 8851 TIMBERVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 244 16 68   3 11     1   30   181 192                       373 244 16 68   3 11     1   30   181 192                 373
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
1900919 CO     school 803870 1110   FALCON 49 80387001799 7960 SKYVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 198 33 77   4 10     2   37   198 163                       361 198 33 77   4 10     2   37   198 163                 361
1902528 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001054 8381 SUMMIT RIDGE MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 246 7 65   1 19     2   14   180 174                       354 246 7 65   1 19     2   14   180 174                 354
1901699 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000712 2288 DRAKE JUNIOR HIGH SCHOOL   Regular School No Middle 07 08 2018   grade_7 255 2 59   1 11     0   16   176 168                       344 255 2 59   1 11     0   16   176 168                 344
1899869 CO     school 804080 1000   FOUNTAIN 8 80408000563 3106 FOUNTAIN MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 163 22 103   3 3     7   40   161 180                       341 163 22 103   3 3     7   40   161 180                 341
1900547 CO     school 801920 1040   ACADEMY 20 80192001593 6140 MOUNTAIN RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 215 9 60   1 18     4   29   175 161                       336 215 9 60   1 18     4   29   175 161                 336
1900810 CO     school 803870 1110   FALCON 49 80387000506 2906 FALCON MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 224 19 62   3 3     1   22   173 161                       334 224 19 62   3 3     1   22   173 161                 334
1901963 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000742 4548 KEN CARYL MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 254 7 45   2 11     0   14   181 152                       333 254 7 45   2 11     0   14   181 152                 333
1896193 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000900 2760 ERIE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 273 2 37   3 7     0   10   172 160                       332 273 2 37   3 7     0   10   172 160                 332
1900494 CO     school 801920 1040   ACADEMY 20 80192001402 2358 EAGLEVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 231 15 51   1 14     0   20   162 170                       332 231 15 51   1 14     0   20   162 170                 332
1895517 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000060 2384 EAST MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 22 32 252   5 13     2   5   186 145                       331 22 32 252   5 13     2   5   186 145                 331
1900109 CO     school 803060 1010   COLORADO SPRINGS 11 80306001683 4424 JENKINS MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 216 19 68   2 7     2   16   158 172                       330 216 19 68   2 7     2   16   158 172                 330
1901516 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000698 694 BELL MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 258 0 53   0 9     3   7   175 155                       330 258 0 53   0 9     3   7   175 155                 330
1895268 CO     school 805310 140   LITTLETON 6 80531001351 4447 JOHN WESLEY POWELL MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 258 3 30   2 12     0   20   185 140                       325 258 3 30   2 12     0   20   185 140                 325
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
1900468 CO     school 801920 1040   ACADEMY 20 80192006616 1921 DISCOVERY CANYON CAMPUS MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 232 7 40   1 16     0   22   168 150                       318 232 7 40   1 16     0   22   168 150                 318
1901661 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000708 1976 CREIGHTON MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 138 8 140   4 8     1   16   159 156                       315 138 8 140   4 8     1   16   159 156                 315
1893882 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001620 1480 CENTURY MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 197 6 81   4 13     2   11   151 163                       314 197 6 81   4 13     2   11   151 163                 314
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
1899118 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000443 6772 SAGEWOOD MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 247 2 44   1 3     1   16   167 147                       314 247 2 44   1 3     1   16   167 147                 314
1904091 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000608 3244 FRUITA MIDDLE SCHOOL   Regular School No Middle 06 07 2018   grade_7 256 0 38   2 2     1   15   160 154                       314 256 0 38   2 2     1   15   160 154                 314
1894044 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001183 5814 THE INTERNATIONAL SCHOOL AT THORNTON MIDDLE   Regular School No Middle 06 08 2018   grade_7 32 12 252   2 4     0   6   152 156                       308 32 12 252   2 4     0   6   152 156                 308
1894951 CO     school 802910 130   CHERRY CREEK 5 80291001672 2897 FALCON CREEK MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 182 23 40   3 36     1   22   143 164                       307 182 23 40   3 36     1   22   143 164                 307
1901702 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000713 2300 DUNSTAN MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 209 6 55   3 13     1   19   150 156                       306 209 6 55   3 13     1   19   150 156                 306
1894420 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006362 7131 PRAIRIE VIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 129 6 147   1 11     0   11   160 145                       305 129 6 147   1 11     0   11   160 145                 305
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
1894067 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001186 6342 SHADOW RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 135 3 118   2 24     1   11   154 140                       294 135 3 118   2 24     1   11   154 140                 294
1900309 CO     school 802940 1020   CHEYENNE MOUNTAIN 12 80294000209 1588 CHEYENNE MOUNTAIN JUNIOR HIGH SCHOOL   Regular School No Middle 07 08 2018   grade_7 204 8 46   1 9     0   26   145 149                       294 204 8 46   1 9     0   26   145 149                 294
1901677 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001315 2130 DEER CREEK MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 219 1 41   1 10     1   11   159 125                       284 219 1 41   1 10     1   11   159 125                 284
1900402 CO     school 801920 1040   ACADEMY 20 80192000001 74 CHALLENGER MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 213 7 26   1 19     0   17   146 137                       283 213 7 26   1 19     0   17   146 137                 283
1903575 CO     school 805400 1560   THOMPSON R2-J 80540001655 5335 LUCILE ERWIN MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 196 1 71   2 6     0   5   147 134                       281 196 1 71   2 6     0   5   147 134                 281
1894411 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006420 6702 OTHO E STUART MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 112 14 135   1 8     0   10   151 129                       280 112 14 135   1 8     0   10   151 129                 280
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
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
1896109 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001886 226 ALTONA MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 203 2 31   1 30     1   8   150 126                       276 203 2 31   1 30     1   8   150 126                 276
1901754 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000718 2832 EVERGREEN MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 252 2 9   0 4     0   8   149 126                       275 252 2 9   0 4     0   8   149 126                 275
1902224 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001283 6470 OBERON JUNIOR HIGH SCHOOL   Regular School No Middle 07 08 2018   grade_7 201 0 51   2 2     1   16   148 125                       273 201 0 51   2 2     1   16   148 125                 273
1894223 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 25 7 231   3 0     0   6   153 119                       272 25 7 231   3 0     0   6   153 119                 272
1903399 CO     school 803990 1550   POUDRE R-1 80399006162 9330 WEBBER MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 218 1 35   0 6     0   12   128 144                       272 218 1 35   0 6     0   12   128 144                 272
1901571 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000703 1318 CARMODY MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 143 2 100   4 11     0   10   130 140                       270 143 2 100   4 11     0   10   130 140                 270
1894087 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001187 6398 NORTHGLENN MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 54 4 197   2 7     2   3   137 132                       269 54 4 197   2 7     2   3   137 132                 269
1894791 CO     school 802910 130   CHERRY CREEK 5 80291001878 141 SKY VISTA MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 136 25 54   2 30     0   22   134 135                       269 136 25 54   2 30     0   22   134 135                 269
1903162 CO     school 803990 1550   POUDRE R-1 80399001849 4698 KINARD CORE KNOWLEDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 212 2 20   1 26     0   6   141 126                       267 212 2 20   1 26     0   6   141 126                 267
1895247 CO     school 805310 140   LITTLETON 6 80531000879 3472 GODDARD MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 146 4 97   1 4     0   13   143 122                       265 146 4 97   1 4     0   13   143 122                 265
1895665 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000074 6310 NORTH MIDDLE SCHOOL HEALTH SCIENCES AND TECHNOLOGY CAMPUS   Regular School No Middle 06 08 2018   grade_7 11 32 205   3 8     3   3   124 141                       265 11 32 205   3 8     3   3   124 141                 265
1905780 CO     school 806810 3000   SUMMIT RE-1 80681001400 8377 SUMMIT MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 161 4 93   0 1     0   5   159 105                       264 161 4 93   0 1     0   5   159 105                 264
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
1894261 CO     school 801950 30   ADAMS COUNTY 14 80195000015 4516 KEARNEY MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 29 8 216   1 2     0   3   122 137                       259 29 8 216   1 2     0   3   122 137                 259
1899756 CO     school 806480 990   WIDEFIELD 3 80648001120 4394 JANITELL JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2018   grade_7 117 23 81   2 4     6   26   139 120                       259 117 23 81   2 4     6   26   139 120                 259
1896455 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006198 9430 WESTVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 192 3 49   1 6     0   6   139 118                       257 192 3 49   1 6     0   6   139 118                 257
1895837 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000082 9396 AURORA WEST COLLEGE PREPARATORY ACADEMY   Regular School No High 06 12 2018   grade_7 11 30 173   1 35     1   5   131 125                       256 11 30 173   1 35     1   5   131 125                 256
1896234 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001774 3194 COAL RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 172 1 69   1 4     1   7   145 110                       255 172 1 69   1 4     1   7   145 110                 255
1905179 CO     school 806120 2690   PUEBLO CITY 60 80612001055 5048 PUEBLO ACADEMY OF ARTS   Regular School No Middle 06 08 2018   grade_7 60 6 180   0 2     0   5   132 121                       253 60 6 180   0 2     0   5   132 121                 253
1900221 CO     school 803060 1010   COLORADO SPRINGS 11 80306000234 7556 SABIN MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 123 18 73   3 5     2   28   132 120                       252 123 18 73   3 5     2   28   132 120                 252
1900824 CO     school 803870 1110   FALCON 49 80387001393 4102 HORIZON MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 113 25 70   1 8     2   31   130 120                       250 113 25 70   1 8     2   31   130 120                 250
1895236 CO     school 805310 140   LITTLETON 6 80531000876 2804 EUCLID MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 176 4 50   1 8     3   7   116 133                       249 176 4 50   1 8     3   7   116 133                 249
1906284 CO     school 804410 3120   GREELEY 6 80441000645 4438 PRAIRIE HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 64 6 160   1 11     2   2   139 107                       246 64 6 160   1 11     2   2   139 107                 246
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
1899806 CO     school 806480 990   WIDEFIELD 3 80648001126 9294 WATSON JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2018   grade_7 137 16 63   2 1     5   18   123 119                       242 137 16 63   2 1     5   18   123 119                 242
1903183 CO     school 803990 1550   POUDRE R-1 80399001408 5068 LESHER MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 149 2 66   2 11     0   11   121 120                       241 149 2 66   2 11     0   11   121 120                 241
1906134 CO     school 804830 3110   JOHNSTOWN-MILLIKEN RE-5J 80483000809 5902 MILLIKEN MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 170 1 64   0 2     0   3   141 99                       240 170 1 64   0 2     0   3   141 99                 240
1896770 CO     school 802490 480   BOULDER VALLEY RE 2 80249000132 6224 NEVIN PLATT MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 193 4 22   0 8     0   12   131 108                       239 193 4 22   0 8     0   12   131 108                 239
1899004 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006493 5259 STEM SCHOOL HIGHLANDS RANCH   Regular School Yes Other KG 12 2018   grade_7 142 1 28   1 44     0   20   155 81                       236 142 1 28   1 44     0   20   155 81                 236
1896436 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001891 8903 TRAIL RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 109 2 113   2 4     0   4   122 112                       234 109 2 113   2 4     0   4   122 112                 234
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
1906965 CO     school 800282 9170   COLORADO DIGITAL BOCES 80028206600 1550 COLORADO PREP ACADEMY   Regular School No Other KG 12 2018   grade_7 140 9 61   3 4     0   13   113 117                       230 140 9 61   3 4     0   13   113 117                 230
1896712 CO     school 802490 480   BOULDER VALLEY RE 2 80249000125 5306 LOUISVILLE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 192 0 24   0 2     0   10   113 115                       228 192 0 24   0 2     0   10   113 115                 228
1894600 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006458 7305 IVER C. RANUM MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 16 2 195   1 10     1   1   105 121                       226 16 2 195   1 10     1   1   105 121                 226
1901215 CO     school 806240 1195   GARFIELD RE-2 80624001096 7356 RIFLE MIDDLE SCHOOL   Regular School No Middle 05 08 2018   grade_7 96 0 124   0 1     0   5   106 120                       226 96 0 124   0 1     0   5   106 120                 226
1904200 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435001345 6166 MOUNT GARFIELD MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 128 0 86   1 1     0   10   118 108                       226 128 0 86   1 1     0   10   118 108                 226
1906266 CO     school 804410 3120   GREELEY 6 80441000642 3880 HEATH MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 38 11 167   1 3     1   3   123 101                       224 38 11 167   1 3     1   3   123 101                 224
1902096 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001746 5472 MANNING OPTIONS SCHOOL   Regular School No Middle 07 08 2018   grade_7 177 3 22   0 9     0   10   99 122                       221 177 3 22   0 9     0   10   99 122                 221
1901750 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000720 2820 EVERITT MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 80 2 119   2 1     0   15   124 95                       219 80 2 119   2 1     0   15   124 95                 219
1898931 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006578 3847 HOPE ONLINE LEARNING ACADEMY MIDDLE SCHOOL   Regular School Yes Middle 06 08 2018   grade_7 21 10 180   0 1     0   4   99 117                       216 21 10 180   0 1     0   4   99 117                 216
1904633 CO     school 804050 2405   FORT MORGAN RE-3 80405001281 3074 FORT MORGAN MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 67 7 137   1 1     0   3   122 94                       216 67 7 137   1 1     0   3   122 94                 216
1896529 CO     school 802490 480   BOULDER VALLEY RE 2 80249000106 1352 CASEY MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 99 2 100   0 5     0   8   104 110                       214 99 2 100   0 5     0   8   104 110                 214
1900178 CO     school 803060 1010   COLORADO SPRINGS 11 80306000256 6306 NORTH MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 95 24 80   2 0     0   13   105 109                       214 95 24 80   2 0     0   13   105 109                 214
1902221 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000760 6330 NORTH ARVADA MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 111 2 88   2 5     0   5   115 98                       213 111 2 88   2 5     0   5   115 98                 213
1901457 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000691 108 ALAMEDA INTERNATIONAL JUNIOR/SENIOR HIGH SCHOOL   Regular School No High 07 12 2018   grade_7 27 2 162   7 9     0   4   116 95                       211 27 2 162   7 9     0   4   116 95                 211

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