enrollments

Data source: Big Local News · About: Big Local

4,236 rows where grade = "grade_7" and state = "CO" sorted by black 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
1133402 1133402 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001620 1480 CENTURY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 231.0 9.0 106.0   6.0 14.0     1.0   5.0   187.0 185.0                       372.0 231 9 106   6 14     1   5   187 185                 372
1133763 1133763 CO     school 801950 30   ADAMS COUNTY 14 80195000015 4516 KEARNEY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 29.0 9.0 223.0   1.0 0.0     0.0   1.0   128.0 135.0                       263.0 29 9 223   1 0     0   1   128 135                 263
1135017 1135017 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes 1.0 KG 08 2015   grade_7 7.0 9.0 35.0   0.0 3.0     0.0   1.0   23.0 32.0                       55.0 7 9 35   0 3     0   1   23 32                 55
1135217 1135217 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006322 9056 VANGUARD CLASSICAL SCHOOL - WEST   Regular School Yes 1.0 KG 08 2015   grade_7 10.0 9.0 31.0   1.0 0.0     0.0   0.0   21.0 30.0                       51.0 10 9 31   1 0     0   0   21 30                 51
1136951 1136951 CO     school 803360 880   DENVER COUNTY 1 80336006516 2188 DENVER CENTER FOR 21ST LEARNING AT WYMAN   Alternative Education School No 4.0 06 12 2015   grade_7 0.0 9.0 4.0   0.0 0.0     0.0   0.0   6.0 7.0                       13.0 0 9 4   0 0     0   0   6 7                 13
1137874 1137874 CO     school 803360 880   DENVER COUNTY 1 80336000426 9548 WHITTIER K-8 SCHOOL   Regular School No 1.0 PK 08 2015   grade_7 0.0 9.0 6.0   0.0 0.0     0.0   2.0   8.0 9.0                       17.0 0 9 6   0 0     0   2   8 9                 17
1140105 1140105 CO     school 803870 1110   FALCON 49 80387000506 2906 FALCON MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 211.0 9.0 39.0   1.0 5.0     0.0   19.0   148.0 136.0                       284.0 211 9 39   1 5     0   19   148 136                 284
1140944 1140944 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000708 1976 CREIGHTON MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   grade_7 149.0 9.0 144.0   5.0 14.0     4.0   7.0   181.0 151.0                       332.0 149 9 144   5 14     4   7   181 151                 332
714581 714581 CO     school 801920 1040   ACADEMY 20 80192001402 2358 EAGLEVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 230 9 41   0 9     0   25   148 166                       314 230 9 41   0 9     0   25   148 166                 314
720229 720229 CO     school 804410 3120   GREELEY 6 80441001990 54 BELLA ROMERO ACADEMY OF APPLIED TECHNOLOGY   Regular School No Elementary KG 08 2017   grade_7 12 9 108   0 0     0   0   60 69                       129 12 9 108   0 0     0   0   60 69                 129
835614 835614 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No 4.0 KG 12 2016   grade_7 171 9 48   2 5     0   14   124 125                       249 171 9 48   2 5     0   14   124 125                 249
835812 835812 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001179 4187 SILVER HILLS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 166 9 166   4 24     0   5   199 175                       374 166 9 166   4 24     0   5   199 175                 374
836048 836048 CO     school 801950 30   ADAMS COUNTY 14 80195000015 4516 KEARNEY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 29 9 239   1 0     0   1   151 128                       279 29 9 239   1 0     0   1   151 128                 279
837403 837403 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001881 6189 MURPHY CREEK K-8 SCHOOL   Regular School No 1.0 PK 08 2016   grade_7 26 9 28   0 4     0   12   38 41                       79 26 9 28   0 4     0   12   38 41                 79
837456 837456 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001674 7232 AURORA QUEST K-8   Regular School No 1.0 KG 08 2016   grade_7 36 9 20   0 13     1   8   46 41                       87 36 9 20   0 13     1   8   46 41                 87
839197 839197 CO     school 803360 880   DENVER COUNTY 1 80336006453 2125 DENVER GREEN SCHOOL   Regular School No 1.0 PK 08 2016   grade_7 25 9 17   1 1     0   3   26 30                       56 25 9 17   1 1     0   3   26 30                 56
839492 839492 CO     school 803360 880   DENVER COUNTY 1 80336001739 3647 MARIE L. GREENWOOD ACADEMY   Regular School No 1.0 01 08 2016   grade_7 1 9 50   0 5     0   1   34 32                       66 1 9 50   0 5     0   1   34 32                 66
840186 840186 CO     school 803360 880   DENVER COUNTY 1 80336006514 8995 VISTA ACADEMY   Alternative Education School No 4.0 06 12 2016   grade_7 1 9 14   0 0     0   0   10 14                       24 1 9 14   0 0     0   0   10 14                 24
840262 840262 CO     school 803360 880   DENVER COUNTY 1 80336006551 9693 WEST GENERATIONS ACADEMY   Regular School No 4.0 06 12 2016   grade_7 3 9 121   1 2     0   1   73 64                       137 3 9 121   1 2     0   1   73 64                 137
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
1740040 1740040 CO     school 802340 180   Adams-Arapahoe 28J 80234002009 465 Aurora Frontier K-8   Regular School No Elementary PK 08 2021   grade_7 35 9 43   0 13     0   2   55 47                       102 35 9 43   0 13     0   2   55 47                 102
1740051 1740051 CO     school 802340 180   Adams-Arapahoe 28J 80234000055 914 Boston K-8 School   Regular School No Elementary PK 08 2021   grade_7 1 9 30   0 2     0   0   21 21                       42 1 9 30   0 2     0   0   21 21                 42
1740090 1740090 CO     school 802340 180   Adams-Arapahoe 28J 80234006803 1851 Harmony Ridge P-8   Regular School No Elementary PK 08 2021   grade_7 7 9 44   3 0     0   3   31 35                       66 7 9 44   3 0     0   3   31 35                 66
1740259 1740259 CO     school 802340 180   Adams-Arapahoe 28J 80234001881 6189 Murphy Creek K-8 School   Regular School No Elementary PK 08 2021   grade_7 26 9 10   1 6     0   8   30 30                       60 26 9 10   1 6     0   8   30 30                 60
1743416 1743416 CO     school 803450 900   Douglas County Re 1 80345006219 2012 Cresthill Middle School   Regular School No Middle 07 08 2021   grade_7 279 9 60   0 23     0   16   194 193                       387 279 9 60   0 23     0   16   194 193                 387
1744150 1744150 CO     school 804530 980   Harrison 2 80453006691 369 Atlas Preparatory Middle School   Regular School Yes Middle 05 08 2021   grade_7 5 9 119   0 0     2   8   71 72                       143 5 9 119   0 0     2   8   71 72                 143
1744675 1744675 CO     school 803060 1010   Colorado Springs 11 80306000241 4070 Holmes Middle School   Regular School No Middle 06 08 2021   grade_7 124 9 43   0 4     0   19   122 77                       199 124 9 43   0 4     0   19   122 77                 199
1745147 1745147 CO     school 801920 1040   Academy 20 80192001593 6140 Mountain Ridge Middle School   Regular School No Middle 06 08 2021   grade_7 185 9 60   0 13     3   20   141 149                       290 185 9 60   0 13     3   20   141 149                 290
1745232 1745232 CO     school 801920 1040   Academy 20 80192001462 8851 Timberview Middle School   Regular School No Middle 06 08 2021   grade_7 228 9 56   1 6     0   25   164 161                       325 228 9 56   1 6     0   25   164 161                 325
1745432 1745432 CO     school 803870 1110   District 49 80387002027 555 Banning Lewis Ranch Academy   Regular School Yes Other KG 12 2021   grade_7 77 9 39   1 5     0   11   69 73                       142 77 9 39   1 5     0   11   69 73                 142
1749733 1749733 CO     school 806120 2690   Pueblo City 60 80612001067 9188 W H Heaton Middle School   Regular School No Middle 06 08 2021   grade_7 58 9 198   1 1     1   7   147 128                       275 58 9 198   1 1     1   7   147 128                 275
1799427 1799427 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2020   grade_7 114 9 43   1 4     2   18   83 108                       191 114 9 43   1 4     2   18   83 108                 191
1804203 1804203 CO     school 803360 880   Denver County 1 80336006551 9693 West Early College   Regular School No High 06 12 2020   grade_7 5 9 65   2 2     0   2   46 39                       85 5 9 65   2 2     0   2   46 39                 85
1804211 1804211 CO     school 803360 880   Denver County 1 80336006547 9702 West Leadership Academy   Regular School No High 06 12 2020   grade_7 6 9 67   0 0     0   2   40 44                       84 6 9 67   0 0     0   2   40 44                 84
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
1805764 1805764 CO     school 803060 1010   Colorado Springs 11 80306000242 4090 Mann Middle School   Regular School No Middle 06 08 2020   grade_7 53 9 51   2 2     1   12   62 68                       130 53 9 51   2 2     1   12   62 68                 130
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
1811800 1811800 CO     school 804410 3120   Greeley 6 80441001990 54 Bella Romero Academy of Applied Technology   Regular School No Elementary KG 08 2020   grade_7 10 9 106   0 1     1   1   79 49                       128 10 9 106   0 1     1   1   79 49                 128
1893801 1893801 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2018   grade_7 130 9 45   1 5     2   14   97 109                       206 130 9 45   1 5     2   14   97 109                 206
1895448 1895448 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234002009 465 AURORA FRONTIER K-8   Regular School No Elementary PK 08 2018   grade_7 20 9 21   0 13     0   7   37 33                       70 20 9 21   0 13     0   7   37 33                 70
1900547 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
1906965 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
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
1931551 1931551 CO     school 801950 30   ADAMS COUNTY 14 80195000015 4516 KEARNEY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 25 9 247   0 1     0   0   148 134                       282 25 9 247   0 1     0   0   148 134                 282
1932752 1932752 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234002009 465 AURORA FRONTIER K-8   Regular School No Elementary PK 08 2019   grade_7 20 9 23   1 14     0   6   43 30                       73 20 9 23   1 14     0   6   43 30                 73
1935779 1935779 CO     school 803360 880   DENVER COUNTY 1 80336006734 8787 THE BOYS SCHOOL OF DENVER   Regular School Yes Middle 06 07 2019   grade_7 45 9 21   1 1     0   4   81 0                       81 45 9 21   1 1     0   4   81 0                 81
1935890 1935890 CO     school 803360 880   DENVER COUNTY 1 80336006551 9693 WEST EARLY COLLEGE   Regular School No High 06 12 2019   grade_7 5 9 59   1 0     0   0   31 43                       74 5 9 59   1 0     0   0   31 43                 74
1936283 1936283 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006578 3847 HOPE ONLINE LEARNING ACADEMY MIDDLE SCHOOL   Regular School Yes Middle 06 08 2019   grade_7 12 9 166   0 1     0   2   95 95                       190 12 9 166   0 1     0   2   95 95                 190
1937040 1937040 CO     school 804530 980   HARRISON 2 80453001903 6162 MOUNTAIN VISTA COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   grade_7 22 9 59   0 4     0   8   54 48                       102 22 9 59   0 4     0   8   54 48                 102
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
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
1133911 1133911 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006420 6702 OTHO E STUART MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 104.0 8.0 85.0   2.0 10.0     0.0   9.0   127.0 91.0                       218.0 104 8 85   2 10     0   9   127 91                 218
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
1134897 1134897 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001759 458 AURORA ACADEMY CHARTER SCHOOL   Regular School Yes 1.0 KG 08 2015   grade_7 15.0 8.0 15.0   0.0 1.0     0.0   2.0   27.0 14.0                       41.0 15 8 15   0 1     0   2   27 14                 41
1137821 1137821 CO     school 803360 880   DENVER COUNTY 1 80336006514 8995 VISTA ACADEMY   Alternative Education School No 4.0 06 12 2015   grade_7 0.0 8.0 13.0   0.0 0.0     1.0   0.0   12.0 10.0                       22.0 0 8 13   0 0     1   0   12 10                 22
1137904 1137904 CO     school 803360 880   DENVER COUNTY 1 80336006547 9702 WEST LEADERSHIP ACADEMY   Regular School No 4.0 06 11 2015   grade_7 4.0 8.0 111.0   0.0 1.0     1.0   1.0   62.0 64.0                       126.0 4 8 111   0 1     1   1   62 64                 126
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
1139397 1139397 CO     school 803060 1010   COLORADO SPRINGS 11 80306000242 4090 MANN MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 78.0 8.0 53.0   0.0 6.0     1.0   16.0   89.0 73.0                       162.0 78 8 53   0 6     1   16   89 73                 162
1139718 1139718 CO     school 801920 1040   ACADEMY 20 80192000001 74 CHALLENGER MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 204.0 8.0 22.0   1.0 15.0     2.0   22.0   149.0 125.0                       274.0 204 8 22   1 15     2   22   149 125                 274
1142306 1142306 CO     school 803990 1550   POUDRE R-1 80399000523 898 BOLTZ MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 138.0 8.0 45.0   3.0 5.0     0.0   7.0   114.0 92.0                       206.0 138 8 45   3 5     0   7   114 92                 206
1144371 1144371 CO     school 806120 2690   PUEBLO CITY 60 80612001055 5048 PUEBLO ACADEMY OF ARTS   Regular School No 2.0 04 08 2015   grade_7 44.0 8.0 123.0   2.0 1.0     0.0   7.0   95.0 90.0                       185.0 44 8 123   2 1     0   7   95 90                 185
707975 707975 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001726 57 ROCKY TOP MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 353 8 94   2 24     0   10   265 226                       491 353 8 94   2 24     0   10   265 226                 491
708963 708963 CO     school 802910 130   CHERRY CREEK 5 80291000763 1510 CHALLENGE SCHOOL   Regular School No Elementary PK 08 2017   grade_7 30 8 10   0 17     0   9   34 40                       74 30 8 10   0 17     0   9   34 40                 74
709583 709583 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000057 1720 CLYDE MILLER K-8   Regular School No Elementary PK 08 2017   grade_7 7 8 42   0 0     0   5   35 27                       62 7 8 42   0 0     0   5   35 27                 62
709811 709811 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001674 7232 AURORA QUEST K-8   Regular School No Elementary KG 08 2017   grade_7 47 8 21   3 11     1   4   43 52                       95 47 8 21   3 11     1   4   43 52                 95
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
712608 712608 CO     school 803360 880   DENVER COUNTY 1 80336000426 9548 WHITTIER K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 0 8 10   1 1     0   2   13 9                       22 0 8 10   1 1     0   2   13 9                 22
714195 714195 CO     school 803060 1010   COLORADO SPRINGS 11 80306001683 4424 JENKINS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 190 8 66   1 10     2   28   158 147                       305 190 8 66   1 10     2   28   158 147                 305
720320 720320 CO     school 804410 3120   GREELEY 6 80441000642 3880 HEATH MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 63 8 182   1 8     1   3   152 114                       266 63 8 182   1 8     1   3   152 114                 266
840386 840386 CO     school   900   DOUGLAS COUNTY RE 1   267 MESA MIDDLE SCHOOL             2016   grade_7 377 8 57   1 9     1   15   252 216                       468 377 8 57   1 9     1   15   252 216                 468
842196 842196 CO     school 801920 1040   ACADEMY 20 80192001402 2358 EAGLEVIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 239 8 44   3 7     0   25   157 169                       326 239 8 44   3 7     0   25   157 169                 326
843345 843345 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000708 1976 CREIGHTON MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_7 178 8 162   9 8     1   15   200 181                       381 178 8 162   9 8     1   15   200 181                 381
846251 846251 CO     school 804050 2405   FORT MORGAN RE-3 80405001281 3074 FORT MORGAN MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_7 73 8 127   0 2     0   2   102 110                       212 73 8 127   0 2     0   2   102 110                 212
1740312 1740312 CO     school 802340 180   Adams-Arapahoe 28J 80234001674 7232 Aurora Quest K-8   Regular School No Elementary KG 08 2021   grade_7 31 8 24   0 13     0   11   48 39                       87 31 8 24   0 13     0   11   48 39                 87
1740493 1740493 CO     school 802700 190   Byers 32J 80270006759 2793 Astravo Academy Middle School   Regular School Yes Middle 06 08 2021   grade_7 161 8 33   3 11     1   0   114 103                       217 161 8 33   3 11     1   0   114 103                 217
1742366 1742366 CO     school 803360 880   Denver County 1 80336006473 3639 Girls Athletic Leadership School Middle School   Regular School Yes Middle 06 08 2021   grade_7 50 8 36   0 2     0   6   1 101                       102 50 8 36   0 2     0   6   1 101                 102
1742383 1742383 CO     school 803360 880   Denver County 1 80336001739 3647 Marie L. Greenwood Academy   Regular School No Elementary KG 08 2021   grade_7 1 8 57   0 0     0   1   34 33                       67 1 8 57   0 0     0   1   34 33                 67
1743664 1743664 CO     school 803450 900   Douglas County Re 1 80345001747 6164 Mountain Ridge Middle School   Regular School No Middle 07 08 2021   grade_7 361 8 57   1 24     0   30   245 236                       481 361 8 57   1 24     0   30   245 236                 481
1743778 1743778 CO     school 803450 900   Douglas County Re 1 80345001528 7245 Ranch View Middle School   Regular School No Middle 07 08 2021   grade_7 301 8 54   1 9     0   18   193 198                       391 301 8 54   1 9     0   18   193 198                 391
1744202 1744202 CO     school 804530 980   Harrison 2 80453001964 4379 James Irwin Charter Middle School   Regular School Yes Middle 06 08 2021   grade_7 37 8 84   0 2     3   17   74 77                       151 37 8 84   0 2     3   17   74 77                 151
1744278 1744278 CO     school 804530 980   Harrison 2 80453001533 7611 Sand Creek International Elementary School   Regular School No Elementary KG 07 2021   grade_7 9 8 36   1 0     0   5   25 34                       59 9 8 36   1 0     0   5   25 34                 59
1744679 1744679 CO     school 803060 1010   Colorado Springs 11 80306000242 4090 Mann Middle School   Regular School No Middle 06 08 2021   grade_7 70 8 34   1 1     0   14   65 63                       128 70 8 34   1 1     0   14   65 63                 128
1745353 1745353 CO     school 805820 1080   Lewis-Palmer 38 80582001002 5098 Lewis-Palmer Middle School   Regular School No Middle 07 08 2021   grade_7 302 8 39   1 7     0   22   208 171                       379 302 8 39   1 7     0   22   208 171                 379
1751208 1751208 CO     school 800020 8001   Charter School Institute 80002006708 1505 Colorado Military Academy   Regular School Yes Other KG 11 2021   grade_7 33 8 26   0 1     0   3   44 27                       71 33 8 26   0 1     0   3   44 27                 71
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
1803171 1803171 CO     school 803360 880   Denver County 1 80336001574 2184 Denver School of the Arts   Regular School No High 06 12 2020   grade_7 91 8 26   0 6     0   8   55 84                       139 91 8 26   0 6     0   8   55 84                 139
1804178 1804178 CO     school 803360 880   Denver County 1 80336000426 9548 Whittier ECE-8 School   Regular School No Elementary PK 08 2020   grade_7 0 8 18   0 0     0   3   12 17                       29 0 8 18   0 0     0   3   12 17                 29
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
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
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
1806517 1806517 CO     school 803870 1110   District 49 80387002027 555 Banning Lewis Ranch Academy   Regular School Yes Other KG 11 2020   grade_7 78 8 46   1 7     1   16   68 89                       157 78 8 46   1 7     1   16   68 89                 157
1811805 1811805 CO     school 804410 3120   Greeley 6 80441000634 988 Brentwood Middle School   Regular School No Middle 06 08 2020   grade_7 52 8 153   2 3     0   4   118 104                       222 52 8 153   2 3     0   4   118 104                 222
1893843 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
1894012 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
1894261 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
1895459 1895459 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000055 914 BOSTON K-8 SCHOOL   Regular School No Elementary PK 08 2018   grade_7 1 8 28   0 4     0   1   19 23                       42 1 8 28   0 4     0   1   19 23                 42
1895712 1895712 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001674 7232 AURORA QUEST K-8   Regular School No Elementary KG 08 2018   grade_7 38 8 24   0 11     0   5   43 43                       86 38 8 24   0 11     0   5   43 43                 86
1895914 1895914 CO     school 802700 190   BYERS 32J 80270006620 6263 COLORADO DIGITAL ACADEMY - MIDDLE   Regular School Yes Middle 07 08 2018   grade_7 84 8 17   0 0     0   5   61 53                       114 84 8 17   0 0     0   5   61 53                 114
1897446 1897446 CO     school 803360 880   DENVER COUNTY 1 80336006645 1939 COMPASS ACADEMY   Regular School Yes Middle 06 08 2018   grade_7 4 8 87   1 4     1   0   57 48                       105 4 8 87   1 4     1   0   57 48                 105
1898573 1898573 CO     school 803360 880   DENVER COUNTY 1 80336006737 9753 WYATT ACADEMY MIDDLE SCHOOL   Regular School Yes Middle 06 08 2018   grade_7 2 8 32   0 0     0   1   21 22                       43 2 8 32   0 0     0   1   21 22                 43

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