enrollments

Data source: Big Local News · About: Big Local

626 rows where grade = "grade_7", state = "CO" and year = 2020 sorted by total_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 626 ✖

grade ✖

  • grade_7 · 626 ✖
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 ▲
1804728 1804728 CO     school 803450 900   Douglas County Re 1 80345001747 6164 Mountain Ridge Middle School   Regular School No Middle 07 08 2020   grade_7 393 9 69   3 29     3   30   260 276                       536 393 9 69   3 29     3   30   260 276                 536
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
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
1800498 1800498 CO     school 802910 130   Cherry Creek 5 80291000185 1566 Campus Middle School   Regular School No Middle 06 08 2020   grade_7 298 16 47   2 87     2   34   250 236                       486 298 16 47   2 87     2   34   250 236                 486
1804871 1804871 CO     school 803450 900   Douglas County Re 1 80345001962 7448 Rocky Heights Middle School   Regular School No Middle 06 08 2020   grade_7 343 3 44   4 29     1   21   218 227                       445 343 3 44   4 29     1   21   218 227                 445
1804327 1804327 CO     school 803450 900   Douglas County Re 1 80345006371 267 Mesa Middle School   Regular School No Middle 07 08 2020   grade_7 325 5 74   1 8     1   27   222 219                       441 325 5 74   1 8     1   27   222 219                 441
1804776 1804776 CO     school 803450 900   Douglas County Re 1 80345001582 6773 Sierra Middle School   Regular School No Middle 07 08 2020   grade_7 309 8 76   5 16     1   22   226 211                       437 309 8 76   5 16     1   22   226 211                 437
1806446 1806446 CO     school 805820 1080   Lewis-Palmer 38 80582001002 5098 Lewis-Palmer Middle School   Regular School No Middle 07 08 2020   grade_7 342 8 51   2 4     0   19   219 207                       426 342 8 51   2 4     0   19   219 207                 426
1804306 1804306 CO     school 803450 900   Douglas County Re 1 80345006404 264 Cimarron Middle   Regular School No Middle 06 08 2020   grade_7 324 3 53   0 11     2   25   217 201                       418 324 3 53   0 11     2   25   217 201                 418
1800502 1800502 CO     school 802910 130   Cherry Creek 5 80291000207 1568 West Middle School   Regular School No Middle 06 08 2020   grade_7 283 11 50   3 39     1   26   224 189                       413 283 11 50   3 39     1   26   224 189                 413
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
1804464 1804464 CO     school 803450 900   Douglas County Re 1 80345000438 2226 Castle Rock Middle School   Regular School No Middle 07 08 2020   grade_7 320 4 57   2 6     1   15   221 184                       405 320 4 57   2 6     1   15   221 184                 405
1804846 1804846 CO     school 803450 900   Douglas County Re 1 80345001528 7245 Ranch View Middle School   Regular School No Middle 07 08 2020   grade_7 326 2 44   5 8     0   10   207 188                       395 326 2 44   5 8     0   10   207 188                 395
1808990 1808990 CO     school 803990 1550   Poudre R-1 80399001091 7161 Preston Middle School   Regular School No Middle 06 08 2020   grade_7 329 5 38   0 15     3   4   205 189                       394 329 5 38   0 15     3   4   205 189                 394
1804461 1804461 CO     school 803450 900   Douglas County Re 1 80345006219 2012 Cresthill Middle School   Regular School No Middle 07 08 2020   grade_7 252 4 73   2 22     0   22   190 185                       375 252 4 73   2 22     0   22   190 185                 375
1806558 1806558 CO     school 803870 1110   District 49 80387000506 2906 Falcon Middle School   Regular School No Middle 06 08 2020   grade_7 248 12 78   3 5     0   27   179 194                       373 248 12 78   3 5     0   27   179 194                 373
1799628 1799628 CO     school 806900 20   Adams 12 Five Star Schools 80690001179 4187 Silver Hills Middle School   Regular School No Middle 06 08 2020   grade_7 126 8 198   3 17     1   12   182 183                       365 126 8 198   3 17     1   12   182 183                 365
1799469 1799469 CO     school 806900 20   Adams 12 Five Star Schools 80690001726 57 Rocky Top Middle School   Regular School No Middle 06 08 2020   grade_7 234 4 77   1 25     0   19   187 173                       360 234 4 77   1 25     0   19   187 173                 360
1799826 1799826 CO     school 806900 20   Adams 12 Five Star Schools 80690001194 9444 Westlake Middle School   Regular School No Middle 06 08 2020   grade_7 213 4 107   3 16     0   16   187 172                       359 213 4 107   3 16     0   16   187 172                 359
1805539 1805539 CO     school 804080 1000   Fountain 8 80408000563 3106 Fountain Middle School   Regular School No Middle 06 08 2020   grade_7 182 27 103   3 3     3   38   188 171                       359 182 27 103   3 3     3   38   188 171                 359
1800407 1800407 CO     school 802910 130   Cherry Creek 5 80291001711 18 Liberty Middle School   Regular School No Middle 06 08 2020   grade_7 194 24 61   3 45     1   24   182 170                       352 194 24 61   3 45     1   24   182 170                 352
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
1806328 1806328 CO     school 801920 1040   Academy 20 80192001462 8851 Timberview Middle School   Regular School No Middle 06 08 2020   grade_7 238 13 53   4 5     2   29   187 157                       344 238 13 53   4 5     2   29   187 157                 344
1799505 1799505 CO     school 806900 20   Adams 12 Five Star Schools 80690001620 1480 Century Middle School   Regular School No Middle 06 08 2020   grade_7 188 12 110   1 22     0   10   177 166                       343 188 12 110   1 22     0   10   177 166                 343
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
1806241 1806241 CO     school 801920 1040   Academy 20 80192001593 6140 Mountain Ridge Middle School   Regular School No Middle 06 08 2020   grade_7 203 13 75   0 19     2   30   163 179                       342 203 13 75   0 19     2   30   163 179                 342
1806191 1806191 CO     school 801920 1040   Academy 20 80192001402 2358 Eagleview Middle School   Regular School No Middle 06 08 2020   grade_7 258 7 46   0 10     2   17   155 185                       340 258 7 46   0 10     2   17   155 185                 340
1800593 1800593 CO     school 802910 130   Cherry Creek 5 80291006367 3030 Fox Ridge Middle School   Regular School No Middle 06 08 2020   grade_7 220 23 46   0 20     0   27   176 160                       336 220 23 46   0 20     0   27   176 160                 336
1804773 1804773 CO     school 803450 900   Douglas County Re 1 80345000443 6772 Sagewood Middle School   Regular School No Middle 06 08 2020   grade_7 277 2 36   0 3     1   17   184 152                       336 277 2 36   0 3     1   17   184 152                 336
1799664 1799664 CO     school 806900 20   Adams 12 Five Star Schools 80690001183 5814 The International School at Thornton Middle   Regular School No Middle 06 08 2020   grade_7 39 17 268   2 5     0   4   184 151                       335 39 17 268   2 5     0   4   184 151                 335
1806680 1806680 CO     school 803870 1110   District 49 80387001799 7960 Skyview Middle School   Regular School No Middle 06 08 2020   grade_7 175 27 79   3 10     1   36   169 162                       331 175 27 79   3 10     1   36   169 162                 331
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
1809739 1809739 CO     school 804350 2000   Mesa County Valley 51 80435000608 3244 Fruita Middle School   Regular School No Middle 06 07 2020   grade_7 250 0 56   3 6     0   11   156 170                       326 250 0 56   3 6     0   11   156 170                 326
1801160 1801160 CO     school 802340 180   Adams-Arapahoe 28J 80234000060 2384 East Middle School   Regular School No Middle 06 08 2020   grade_7 11 39 246   5 8     2   7   164 154                       318 11 39 246   5 8     2   7   164 154                 318
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
1807458 1807458 CO     school 804800 1420   Jefferson County R-1 80480000713 2300 Dunstan Middle School   Regular School No Middle 06 08 2020   grade_7 222 7 67   3 8     0   9   165 151                       316 222 7 67   3 8     0   9   165 151                 316
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
1807694 1807694 CO     school 804800 1420   Jefferson County R-1 80480000742 4548 Ken Caryl Middle School   Regular School No Middle 06 08 2020   grade_7 231 2 45   1 8     0   15   154 148                       302 231 2 45   1 8     0   15   154 148                 302
1805785 1805785 CO     school 803060 1010   Colorado Springs 11 80306001683 4424 Jenkins Middle School   Regular School No Middle 06 08 2020   grade_7 175 17 73   0 8     1   27   161 140                       301 175 17 73   0 8     1   27   161 140                 301
1801873 1801873 CO     school 805370 470   St Vrain Valley RE1J 80537001774 3194 Coal Ridge Middle School   Regular School No Middle 06 08 2020   grade_7 207 2 75   3 4     0   8   166 133                       299 207 2 75   3 4     0   8   166 133                 299
1807275 1807275 CO     school 804800 1420   Jefferson County R-1 80480000698 694 Bell Middle School   Regular School No Middle 06 08 2020   grade_7 222 6 54   2 4     1   9   156 142                       298 222 6 54   2 4     1   9   156 142                 298
1805991 1805991 CO     school 802940 1020   Cheyenne Mountain 12 80294000209 1588 Cheyenne Mountain Junior High School   Regular School No Middle 07 08 2020   grade_7 200 9 55   0 7     0   22   137 156                       293 200 9 55   0 7     0   22   137 156                 293
1807416 1807416 CO     school 804800 1420   Jefferson County R-1 80480000708 1976 Creighton Middle School   Regular School No Middle 06 08 2020   grade_7 113 11 142   4 6     0   17   147 146                       293 113 11 142   4 6     0   17   147 146                 293
1800589 1800589 CO     school 802910 130   Cherry Creek 5 80291001672 2897 Falcon Creek Middle School   Regular School No Middle 06 08 2020   grade_7 176 20 42   2 24     2   24   162 128                       290 176 20 42   2 24     2   24   162 128                 290
1808225 1808225 CO     school 804800 1420   Jefferson County R-1 80480001054 8381 Summit Ridge Middle School   Regular School No Middle 06 08 2020   grade_7 204 3 55   1 15     0   12   139 151                       290 204 3 55   1 15     0   12   139 151                 290
1800909 1800909 CO     school 805310 140   Littleton 6 80531001351 4447 John Wesley Powell Middle School   Regular School No Middle 06 08 2020   grade_7 226 6 31   0 8     0   12   136 147                       283 226 6 31   0 8     0   12   136 147                 283
1800877 1800877 CO     school 805310 140   Littleton 6 80531000876 2804 Euclid Middle School   Regular School No Middle 06 08 2020   grade_7 203 6 54   0 3     0   14   145 135                       280 203 6 54   0 3     0   14   145 135                 280
1808856 1808856 CO     school 803990 1550   Poudre R-1 80399001849 4698 Kinard Core Knowledge Middle School   Regular School No Middle 06 08 2020   grade_7 222 0 24   0 19     0   15   127 153                       280 222 0 24   0 19     0   15   127 153                 280
1801756 1801756 CO     school 805370 470   St Vrain Valley RE1J 80537001886 226 Altona Middle School   Regular School No Middle 06 08 2020   grade_7 201 5 47   0 17     0   9   135 144                       279 201 5 47   0 17     0   9   135 144                 279
1807454 1807454 CO     school 804800 1420   Jefferson County R-1 80480000712 2288 Drake Junior High School   Regular School No Middle 06 08 2020   grade_7 216 2 41   1 7     0   10   137 140                       277 216 2 41   1 7     0   10   137 140                 277
1799883 1799883 CO     school 801950 30   Adams County 14 80195000015 4516 Kearney Middle School   Regular School No Middle 06 08 2020   grade_7 32 5 236   1 0     1   1   151 125                       276 32 5 236   1 0     1   1   151 125                 276
1799706 1799706 CO     school 806900 20   Adams 12 Five Star Schools 80690001187 6398 Northglenn Middle School   Regular School No Middle 06 08 2020   grade_7 60 7 199   0 4     0   5   147 128                       275 60 7 199   0 4     0   5   147 128                 275
1800888 1800888 CO     school 805310 140   Littleton 6 80531000879 3472 Goddard Middle School   Regular School No Middle 06 08 2020   grade_7 151 5 93   1 6     0   18   136 138                       274 151 5 93   1 6     0   18   136 138                 274
1807329 1807329 CO     school 804800 1420   Jefferson County R-1 80480000703 1318 Carmody Middle School   Regular School No Middle 06 08 2020   grade_7 136 6 107   2 9     0   11   157 114                       271 136 6 107   2 9     0   11   157 114                 271
1799686 1799686 CO     school 806900 20   Adams 12 Five Star Schools 80690001186 6342 Shadow Ridge Middle School   Regular School No Middle 06 08 2020   grade_7 133 3 111   0 12     0   11   136 134                       270 133 3 111   0 12     0   11   136 134                 270
1807432 1807432 CO     school 804800 1420   Jefferson County R-1 80480001315 2130 Deer Creek Middle School   Regular School No Middle 06 08 2020   grade_7 199 5 40   3 9     0   14   137 133                       270 199 5 40   3 9     0   14   137 133                 270
1811407 1811407 CO     school 806810 3000   Summit RE-1 80681001400 8377 Summit Middle School   Regular School No Middle 06 08 2020   grade_7 153 0 108   0 3     0   6   136 134                       270 153 0 108   0 3     0   6   136 134                 270
1809244 1809244 CO     school 805400 1560   Thompson R2-J 80540001655 5335 Lucile Erwin Middle School   Regular School No Middle 06 08 2020   grade_7 187 4 71   3 0     0   2   158 109                       267 187 4 71   3 0     0   2   158 109                 267
1800021 1800021 CO     school 802580 40   School District 27J 80258006420 6702 Otho E Stuart Middle School   Regular School No Middle 06 08 2020   grade_7 105 20 115   0 9     0   17   141 125                       266 105 20 115   0 9     0   17   141 125                 266
1800776 1800776 CO     school 802910 130   Cherry Creek 5 80291006728 7514 Infinity Middle School   Regular School No Middle 06 08 2020   grade_7 158 21 37   2 25     0   22   142 123                       265 158 21 37   2 25     0   22   142 123                 265
1800046 1800046 CO     school 802580 40   School District 27J 80258006753 7351 Rodger Quist Middle School   Regular School No Middle 06 08 2020   grade_7 140 0 84   2 20     1   17   136 128                       264 140 0 84   2 20     1   17   136 128                 264
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
1801834 1801834 CO     school 805370 470   St Vrain Valley RE1J 80537000900 2760 Erie Middle School   Regular School No Middle 06 08 2020   grade_7 218 2 30   0 8     0   5   146 117                       263 218 2 30   0 8     0   5   146 117                 263
1808878 1808878 CO     school 803990 1550   Poudre R-1 80399001408 5068 Lesher Middle School   Regular School No Middle 06 08 2020   grade_7 165 1 71   1 10     0   15   141 122                       263 165 1 71   1 10     0   15   141 122                 263
1809074 1809074 CO     school 803990 1550   Poudre R-1 80399006162 9330 Webber Middle School   Regular School No Middle 06 08 2020   grade_7 190 6 53   2 3     0   9   138 125                       263 190 6 53   2 3     0   9   138 125                 263
1806166 1806166 CO     school 801920 1040   Academy 20 80192006616 1921 Discovery Canyon Campus Middle School   Regular School No Middle 06 08 2020   grade_7 186 8 30   0 12     0   26   134 128                       262 186 8 30   0 12     0   26   134 128                 262
1806083 1806083 CO     school 801920 1040   Academy 20 80192000001 74 Challenger Middle School   Regular School No Middle 06 08 2020   grade_7 176 6 35   0 19     1   23   131 129                       260 176 6 35   0 19     1   23   131 129                 260
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
1799846 1799846 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2020   grade_7 23 3 221   2 0     1   6   121 135                       256 23 3 221   2 0     1   6   121 135                 256
1804300 1804300 CO     school 803450 900   Douglas County Re 1 80345001896 215 American Academy   Regular School Yes Elementary PK 08 2020   grade_7 181 5 20   0 37     0   13   119 137                       256 181 5 20   0 37     0   13   119 137                 256
1807509 1807509 CO     school 804800 1420   Jefferson County R-1 80480000718 2832 Evergreen Middle School   Regular School No Middle 06 08 2020   grade_7 222 4 18   0 1     0   8   129 124                       253 222 4 18   0 1     0   8   129 124                 253
1802345 1802345 CO     school 802490 480   Boulder Valley Re 2 80249000122 4878 Angevine Middle School   Regular School No Middle 06 08 2020   grade_7 119 5 103   1 8     0   16   122 130                       252 119 5 103   1 8     0   16   122 130                 252
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
1802104 1802104 CO     school 805370 470   St Vrain Valley RE1J 80537006198 9430 Westview Middle School   Regular School No Middle 06 08 2020   grade_7 184 1 56   0 2     0   6   133 116                       249 184 1 56   0 2     0   6   133 116                 249
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
1809235 1809235 CO     school 805400 1560   Thompson R2-J 80540000929 5312 Bill Reed Middle School   Regular School No Middle 06 08 2020   grade_7 163 2 64   2 2     1   11   127 118                       245 163 2 64   2 2     1   11   127 118                 245
1810862 1810862 CO     school 806120 2690   Pueblo City 60 80612001067 9188 W H Heaton Middle School   Regular School No Middle 06 08 2020   grade_7 47 4 182   4 4     0   4   115 130                       245 47 4 182   4 4     0   4   115 130                 245
1806572 1806572 CO     school 803870 1110   District 49 80387001393 4102 Horizon Middle School   Regular School No Middle 06 08 2020   grade_7 115 22 73   0 7     0   27   139 105                       244 115 22 73   0 7     0   27   139 105                 244
1812602 1812602 CO     school 800282 9170   Education reEnvisioned BOCES 80028206764 1501 Colorado Preparatory Academy Middle School   Regular School No Middle 06 08 2020   grade_7 139 11 80   2 3     1   8   113 131                       244 139 11 80   2 3     1   8   113 131                 244
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
1811894 1811894 CO     school 804410 3120   Greeley 6 80441000642 3880 Heath Middle School   Regular School No Middle 06 08 2020   grade_7 43 10 174   1 8     0   7   130 113                       243 43 10 174   1 8     0   7   130 113                 243
1807941 1807941 CO     school 804800 1420   Jefferson County R-1 80480001283 6470 Oberon Junior High School   Regular School No Middle 06 08 2020   grade_7 185 0 40   0 3     1   13   146 96                       242 185 0 40   0 3     1   13   146 96                 242
1805857 1805857 CO     school 803060 1010   Colorado Springs 11 80306000256 6306 North Middle School   Regular School No Middle 06 08 2020   grade_7 102 23 94   1 0     1   19   120 120                       240 102 23 94   1 0     1   19   120 120                 240
1805513 1805513 CO     school 804080 1000   Fountain 8 80408000561 1332 Carson Middle School   Regular School No Middle 06 08 2020   grade_7 118 32 56   3 2     4   23   121 117                       238 118 32 56   3 2     4   23   121 117                 238
1810785 1810785 CO     school 806120 2690   Pueblo City 60 80612001055 5048 Pueblo Academy of Arts   Regular School No Middle 06 08 2020   grade_7 56 5 171   0 2     0   4   114 124                       238 56 5 171   0 2     0   4   114 124                 238
1806147 1806147 CO     school 801920 1040   Academy 20 80192001931 1629 The Classical Academy Middle School   Regular School Yes Middle 07 08 2020   grade_7 193 3 22   2 10     1   6   132 105                       237 193 3 22   2 10     1   6   132 105                 237
1811762 1811762 CO     school 804830 3110   Johnstown-Milliken RE-5J 80483000809 5902 Milliken Middle School   Regular School No Middle 06 08 2020   grade_7 142 1 86   0 2     1   4   106 130                       236 142 1 86   0 2     1   4   106 130                 236
1802356 1802356 CO     school 802490 480   Boulder Valley Re 2 80249000125 5306 Louisville Middle School   Regular School No Middle 06 08 2020   grade_7 189 3 21   1 3     1   16   127 107                       234 189 3 21   1 3     1   16   127 107                 234
1809843 1809843 CO     school 804350 2000   Mesa County Valley 51 80435001345 6166 Mount Garfield Middle School   Regular School No Middle 06 08 2020   grade_7 144 0 82   1 0     0   7   115 119                       234 144 0 82   1 0     0   7   115 119                 234
1801483 1801483 CO     school 802340 180   Adams-Arapahoe 28J 80234000082 9396 Aurora West College Preparatory Academy   Regular School No High 06 12 2020   grade_7 9 27 167   1 23     1   5   122 111                       233 9 27 167   1 23     1   5   122 111                 233
1807217 1807217 CO     school 804800 1420   Jefferson County R-1 80480000691 108 Alameda International Junior/Senior High School   Regular School No High 07 12 2020   grade_7 33 1 178   1 14     0   6   124 109                       233 33 1 178   1 14     0   6   124 109                 233
1808897 1808897 CO     school 803990 1550   Poudre R-1 80399000536 5168 Lincoln Middle School   Regular School No Middle 06 08 2020   grade_7 113 5 102   1 3     1   8   124 109                       233 113 5 102   1 3     1   8   124 109                 233
1805426 1805426 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2020   grade_7 86 25 83   0 1     3   34   124 108                       232 86 25 83   0 1     3   34   124 108                 232
1810248 1810248 CO     school 804050 2405   Fort Morgan Re-3 80405001281 3074 Fort Morgan Middle School   Regular School No Middle 06 08 2020   grade_7 70 5 145   2 1     0   9   128 104                       232 70 5 145   2 1     0   9   128 104                 232
1805900 1805900 CO     school 803060 1010   Colorado Springs 11 80306000234 7556 Sabin Middle School   Regular School No Middle 06 08 2020   grade_7 118 24 73   0 4     0   12   116 115                       231 118 24 73   0 4     0   12   116 115                 231
1807534 1807534 CO     school 804800 1420   Jefferson County R-1 80480001970 2963 Falcon Bluffs Middle School   Regular School No Middle 06 08 2020   grade_7 172 1 37   0 5     0   16   123 108                       231 172 1 37   0 5     0   16   123 108                 231
1811727 1811727 CO     school 807350 3100   Windsor RE-4 80735001265 9670 Windsor Middle School   Regular School No Middle 06 08 2020   grade_7 189 2 35   0 1     0   4   113 118                       231 189 2 35   0 1     0   4   113 118                 231
1809769 1809769 CO     school 804350 2000   Mesa County Valley 51 80435001656 3584 Grand Mesa Middle School   Regular School No Middle 06 08 2020   grade_7 131 2 72   2 2     3   14   115 111                       226 131 2 72   2 2     3   14   115 111                 226
1811912 1811912 CO     school 804410 3120   Greeley 6 80441000645 4438 Prairie Heights Middle School   Regular School No Middle 06 08 2020   grade_7 60 4 148   1 11     0   2   119 107                       226 60 4 148   1 11     0   2   119 107                 226
1807505 1807505 CO     school 804800 1420   Jefferson County R-1 80480000720 2820 Everitt Middle School   Regular School No Middle 06 08 2020   grade_7 111 6 85   6 3     1   12   99 125                       224 111 6 85   6 3     1   12   99 125                 224

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