enrollments

Data source: Big Local News · About: Big Local

4,236 rows where grade = "grade_7" and state = "CO" sorted by asian_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
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
1894861 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
1932165 1932165 CO     school 802910 130   CHERRY CREEK 5 80291000185 1566 CAMPUS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 324 15 63   2 80     0   34   297 221                       518 324 15 63   2 80     0   34   297 221                 518
1134344 1134344 CO     school 802910 130   CHERRY CREEK 5 80291000185 1566 CAMPUS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 327.0 11.0 55.0   2.0 75.0     0.0   19.0   260.0 229.0                       489.0 327 11 55   2 75     0   19   260 229                 489
1739451 1739451 CO     school 802910 130   Cherry Creek 5 80291000185 1566 Campus Middle School   Regular School No Middle 06 08 2021   grade_7 292 18 61   2 74     1   37   231 254                       485 292 18 61   2 74     1   37   231 254                 485
708973 708973 CO     school 802910 130   CHERRY CREEK 5 80291000185 1566 CAMPUS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 314 16 57   2 71     1   21   246 236                       482 314 16 57   2 71     1   21   246 236                 482
836620 836620 CO     school 802910 130   CHERRY CREEK 5 80291000185 1566 CAMPUS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 305 14 65   1 62     0   22   233 236                       469 305 14 65   1 62     0   22   233 236                 469
836545 836545 CO     school   130   CHERRY CREEK 5   18 LIBERTY MIDDLE SCHOOL             2016   grade_7 208 27 58   1 52     1   24   173 198                       371 208 27 58   1 52     1   24   173 198                 371
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
1899004 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
1135277 1135277 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000082 9396 AURORA WEST COLLEGE PREPARATORY ACADEMY   Regular School No 4.0 06 12 2015   grade_7 17.0 33.0 221.0   2.0 43.0     0.0   7.0   172.0 151.0                       323.0 17 33 221   2 43     0   7   172 151                 323
1894787 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
1936367 1936367 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006493 5259 STEM SCHOOL HIGHLANDS RANCH   Regular School Yes Other KG 12 2019   grade_7 143 1 32   0 43     0   18   147 90                       237 143 1 32   0 43     0   18   147 90                 237
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
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
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
1804663 1804663 CO     school 803450 900   Douglas County Re 1 80345006493 5259 STEM School Highlands Ranch   Regular School Yes Other KG 12 2020   grade_7 109 4 18   1 39     0   17   122 66                       188 109 4 18   1 39     0   17   122 66                 188
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
713091 713091 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006493 5259 STEM SCHOOL   Regular School Yes Other KG 12 2017   grade_7 167 0 18   3 38     0   13   166 73                       239 167 0 18   3 38     0   13   166 73                 239
837572 837572 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000082 9396 AURORA WEST COLLEGE PREPARATORY ACADEMY   Regular School No 4.0 06 12 2016   grade_7 17 26 211   1 38     0   4   140 157                       297 17 26 211   1 38     0   4   140 157                 297
1743603 1743603 CO     school 803450 900   Douglas County Re 1 80345006493 5259 STEM School Highlands Ranch   Regular School Yes Other KG 12 2021   grade_7 113 0 31   0 37     0   12   126 67                       193 113 0 31   0 37     0   12   126 67                 193
1799517 1799517 CO     school 806900 20   Adams 12 Five Star Schools 80690000728 1519 Stargate Charter School   Regular School Yes Other KG 12 2020   grade_7 75 1 11   1 37     0   10   65 70                       135 75 1 11   1 37     0   10   65 70                 135
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
1932083 1932083 CO     school 802910 130   CHERRY CREEK 5 80291001711 18 LIBERTY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 194 34 75   1 37     0   25   177 189                       366 194 34 75   1 37     0   25   177 189                 366
709930 709930 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000082 9396 AURORA WEST COLLEGE PREPARATORY ACADEMY   Regular School No Other 06 12 2017   grade_7 14 37 205   3 36     0   1   165 131                       296 14 37 205   3 36     0   1   165 131                 296
1134435 1134435 CO     school 802910 130   CHERRY CREEK 5 80291006367 3030 FOX RIDGE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 277.0 29.0 47.0   0.0 36.0     0.0   16.0   210.0 195.0                       405.0 277 29 47   0 36     0   16   210 195                 405
1894951 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
840926 840926 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001962 7448 ROCKY HEIGHTS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 409 3 31   2 35     0   19   242 257                       499 409 3 31   2 35     0   19   242 257                 499
1138551 1138551 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001962 7448 ROCKY HEIGHTS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 396.0 3.0 42.0   3.0 35.0     1.0   20.0   255.0 245.0                       500.0 396 3 42   3 35     1   20   255 245                 500
1739357 1739357 CO     school 802910 130   Cherry Creek 5 80291001711 18 Liberty Middle School   Regular School No Middle 06 08 2021   grade_7 178 34 61   1 35     1   33   189 154                       343 178 34 61   1 35     1   33   189 154                 343
1743258 1743258 CO     school 803450 900   Douglas County Re 1 80345001896 215 American Academy   Regular School Yes Elementary PK 08 2021   grade_7 167 1 22   1 35     0   18   129 115                       244 167 1 22   1 35     0   18   129 115                 244
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
1895837 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
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
1133708 1133708 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001194 9444 WESTLAKE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 258.0 3.0 82.0   1.0 34.0     0.0   5.0   197.0 186.0                       383.0 258 3 82   1 34     0   5   197 186                 383
1142384 1142384 CO     school 803990 1550   POUDRE R-1 80399001849 4698 KINARD CORE KNOWLEDGE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 207.0 3.0 14.0   0.0 33.0     0.0   10.0   127.0 140.0                       267.0 207 3 14   0 33     0   10   127 140                 267
1739546 1739546 CO     school 802910 130   Cherry Creek 5 80291006367 3030 Fox Ridge Middle School   Regular School No Middle 06 08 2021   grade_7 235 16 57   5 33     1   32   201 178                       379 235 16 57   5 33     1   32   201 178                 379
1743803 1743803 CO     school 803450 900   Douglas County Re 1 80345001962 7448 Rocky Heights Middle School   Regular School No Middle 06 08 2021   grade_7 321 2 49   0 33     0   22   223 204                       427 321 2 49   0 33     0   22   223 204                 427
836717 836717 CO     school 802910 130   CHERRY CREEK 5 80291006367 3030 FOX RIDGE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 299 28 54   0 32     0   25   222 216                       438 299 28 54   0 32     0   25   222 216                 438
1134270 1134270 CO     school 802910 130   CHERRY CREEK 5 80291001711 18 LIBERTY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 220.0 25.0 68.0   0.0 32.0     0.0   25.0   184.0 186.0                       370.0 220 25 68   0 32     0   25   184 186                 370
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
1136259 1136259 CO     school 802490 480   BOULDER VALLEY RE 2 80249001517 8387 SUMMIT MIDDLE CHARTER SCHOOL   Regular School Yes 2.0 06 08 2015   grade_7 66.0 0.0 8.0   1.0 32.0     0.0   10.0   64.0 53.0                       117.0 66 0 8   1 32     0   10   64 53                 117
1932259 1932259 CO     school 802910 130   CHERRY CREEK 5 80291006367 3030 FOX RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 236 15 55   3 32     0   27   212 156                       368 236 15 55   3 32     0   27   212 156                 368
708977 708977 CO     school 802910 130   CHERRY CREEK 5 80291000207 1568 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 296 7 57   2 31     1   12   209 197                       406 296 7 57   2 31     1   12   209 197                 406
709067 709067 CO     school 802910 130   CHERRY CREEK 5 80291006367 3030 FOX RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 317 33 67   2 31     0   36   251 235                       486 317 33 67   2 31     0   36   251 235                 486
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
1899217 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
1936582 1936582 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001962 7448 ROCKY HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 405 3 38   0 31     0   15   259 233                       492 405 3 38   0 31     0   15   259 233                 492
835640 835640 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   57 ROCKY TOP MIDDLE SCHOOL             2016   grade_7 310 3 75   2 30     0   11   226 205                       431 310 3 75   2 30     0   11   226 205                 431
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
1894791 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
1896109 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
836624 836624 CO     school 802910 130   CHERRY CREEK 5 80291000207 1568 WEST MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 281 7 55   3 29     0   18   183 210                       393 281 7 55   3 29     0   18   183 210                 393
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
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
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
1933422 1933422 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001886 226 ALTONA MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 179 7 41   1 29     0   14   140 131                       271 179 7 41   1 29     0   14   140 131                 271
709063 709063 CO     school 802910 130   CHERRY CREEK 5 80291001672 2897 FALCON CREEK MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 184 23 56   1 28     4   12   159 149                       308 184 23 56   1 28     4   12   159 149                 308
713308 713308 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001962 7448 ROCKY HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 399 5 39   1 28     1   21   240 254                       494 399 5 39   1 28     1   21   240 254                 494
839934 839934 CO     school 803360 880   DENVER COUNTY 1 80336006398 7045 PLACE BRIDGE ACADEMY   Regular School No 1.0 PK 08 2016   grade_7 2 36 41   1 28     2   2   60 52                       112 2 36 41   1 28     2   2   60 52                 112
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
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
1741408 1741408 CO     school 802490 480   Boulder Valley Re 2 80249001792 6816 Peak to Peak Charter School   Regular School Yes Other KG 12 2021   grade_7 85 0 14   0 28     0   8   72 63                       135 85 0 14   0 28     0   8   72 63                 135
1894865 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
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
1898212 1898212 CO     school 803360 880   DENVER COUNTY 1 80336006398 7045 PLACE BRIDGE ACADEMY   Regular School No Elementary PK 08 2018   grade_7 20 21 38   1 28     1   3   54 58                       112 20 21 38   1 28     1   3   54 58                 112
1931115 1931115 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001726 57 ROCKY TOP MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 282 9 76   2 28     0   17   209 205                       414 282 9 76   2 28     0   17   209 205                 414
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
840526 840526 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006219 2012 CRESTHILL MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_7 330 9 66   1 27     0   19   240 212                       452 330 9 66   1 27     0   19   240 212                 452
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
1893893 1893893 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690000728 1519 STARGATE CHARTER SCHOOL   Regular School Yes Other KG 11 2018   grade_7 100 0 8   1 27     0   10   79 67                       146 100 0 8   1 27     0   10   79 67                 146
1934124 1934124 CO     school 802490 480   BOULDER VALLEY RE 2 80249001792 6816 PEAK TO PEAK CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_7 96 0 7   0 27     0   4   69 65                       134 96 0 7   0 27     0   4   69 65                 134
708025 708025 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690000728 1519 STARGATE CHARTER SCHOOL   Regular School Yes Other KG 10 2017   grade_7 79 2 8   0 26     0   7   67 55                       122 79 2 8   0 26     0   7   67 55                 122
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
713166 713166 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001747 6164 MOUNTAIN RIDGE MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 465 4 59   5 26     0   32   306 285                       591 465 4 59   5 26     0   32   306 285                 591
836713 836713 CO     school 802910 130   CHERRY CREEK 5 80291001672 2897 FALCON CREEK MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 190 26 56   0 26     0   17   161 154                       315 190 26 56   0 26     0   17   161 154                 315
1134348 1134348 CO     school 802910 130   CHERRY CREEK 5 80291000207 1568 WEST MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 320.0 8.0 57.0   1.0 26.0     0.0   18.0   219.0 211.0                       430.0 320 8 57   1 26     0   18   219 211                 430
1137578 1137578 CO     school 803360 880   DENVER COUNTY 1 80336006398 7045 PLACE BRIDGE ACADEMY   Regular School No 1.0 PK 08 2015   grade_7 5.0 24.0 40.0   0.0 26.0     0.0   4.0   51.0 48.0                       99.0 5 24 40   0 26     0   4   51 48                 99
1745024 1745024 CO     school 801920 1040   Academy 20 80192006788 1421 Chinook Trail Middle School   Regular School No Middle 06 08 2021   grade_7 199 5 38   1 26     0   26   152 143                       295 199 5 38   1 26     0   26   152 143                 295
1896826 1896826 CO     school 802490 480   BOULDER VALLEY RE 2 80249001517 8387 SUMMIT MIDDLE CHARTER SCHOOL   Regular School Yes Middle 06 08 2018   grade_7 72 0 8   0 26     0   14   50 70                       120 72 0 8   0 26     0   14   50 70                 120
1903162 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
1935988 1935988 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001896 215 AMERICAN ACADEMY   Regular School Yes Elementary PK 08 2019   grade_7 180 3 16   1 26     0   15   112 129                       241 180 3 16   1 26     0   15   112 129                 241
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
710197 710197 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001886 226 ALTONA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 213 8 26   0 25     1   9   133 149                       282 213 8 26   0 25     1   9   133 149                 282
840795 840795 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001747 6164 MOUNTAIN RIDGE MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_7 472 5 63   6 25     0   28   297 302                       599 472 5 63   6 25     0   28   297 302                 599
1133363 1133363 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001726 57 ROCKY TOP MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 329.0 7.0 80.0   1.0 25.0     1.0   6.0   223.0 226.0                       449.0 329 7 80   1 25     1   6   223 226                 449
1133532 1133532 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001179 4187 SILVER HILLS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 162.0 8.0 154.0   2.0 25.0     0.0   6.0   176.0 181.0                       357.0 162 8 154   2 25     0   6   176 181                 357
1138158 1138158 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006219 2012 CRESTHILL MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   grade_7 320.0 8.0 63.0   1.0 25.0     1.0   24.0   214.0 228.0                       442.0 320 8 63   1 25     1   24   214 228                 442
1738458 1738458 CO     school 806900 20   Adams 12 Five Star Schools 80690000728 1519 Stargate Charter School   Regular School Yes Other KG 12 2021   grade_7 80 2 16   0 25     0   11   57 77                       134 80 2 16   0 25     0   11   57 77                 134
1739542 1739542 CO     school 802910 130   Cherry Creek 5 80291001672 2897 Falcon Creek Middle School   Regular School No Middle 06 08 2021   grade_7 160 27 58   5 25     1   27   153 150                       303 160 27 58   5 25     1   27   153 150                 303
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
1739729 1739729 CO     school 802910 130   Cherry Creek 5 80291006728 7514 Infinity Middle School   Regular School No Middle 06 08 2021   grade_7 169 19 36   0 25     0   25   137 137                       274 169 19 36   0 25     0   25   137 137                 274
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
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
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
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
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
1899071 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
1937781 1937781 CO     school 801920 1040   ACADEMY 20 80192000001 74 CHALLENGER MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 219 12 35   2 25     0   22   169 146                       315 219 12 35   2 25     0   22   169 146                 315
1939087 1939087 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000964 2120 D'EVELYN JUNIOR/SENIOR HIGH SCHOOL   Regular School No High 07 12 2019   grade_7 145 5 25   1 25     0   8   94 115                       209 145 5 25   1 25     0   8   94 115                 209

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