enrollments

Data source: Big Local News · About: Big Local

4,236 rows where grade = "grade_7" and state = "CO" sorted by multiracial 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
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
1134091 1134091 CO     school 807230 70   WESTMINSTER 50 80723006458 7305 IVER C. RANUM MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 27.0 0.0 204.0   0.0 10.0     0.0   9.0   133.0 117.0                       250.0 27 0 204   0 10     0   9   133 117                 250
1134979 1134979 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000060 2384 EAST MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 22.0 51.0 229.0   1.0 16.0     1.0   9.0   164.0 165.0                       329.0 22 51 229   1 16     1   9   164 165                 329
1135952 1135952 CO     school 802490 480   BOULDER VALLEY RE 2 80249000102 1066 BROOMFIELD HEIGHTS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 138.0 1.0 43.0   1.0 5.0     0.0   9.0   92.0 105.0                       197.0 138 1 43   1 5     0   9   92 105                 197
1136029 1136029 CO     school 802490 480   BOULDER VALLEY RE 2 80249001771 2589 ELDORADO K-8 SCHOOL   Regular School No 1.0 KG 08 2015   grade_7 110.0 0.0 12.0   0.0 13.0     0.0   9.0   86.0 58.0                       144.0 110 0 12   0 13     0   9   86 58                 144
1136132 1136132 CO     school 802490 480   BOULDER VALLEY RE 2 80249000122 4878 ANGEVINE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 111.0 2.0 96.0   1.0 6.0     0.0   9.0   123.0 102.0                       225.0 111 2 96   1 6     0   9   123 102                 225
1136202 1136202 CO     school 802490 480   BOULDER VALLEY RE 2 80249000132 6224 NEVIN PLATT MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 147.0 4.0 19.0   1.0 3.0     0.0   9.0   90.0 93.0                       183.0 147 4 19   1 3     0   9   90 93                 183
1136225 1136225 CO     school 802490 480   BOULDER VALLEY RE 2 80249001792 6816 PEAK TO PEAK CHARTER SCHOOL   Regular School Yes 4.0 KG 12 2015   grade_7 88.0 2.0 11.0   0.0 24.0     1.0   9.0   69.0 66.0                       135.0 88 2 11   0 24     1   9   69 66                 135
1136927 1136927 CO     school 803360 880   DENVER COUNTY 1 80336001917 2183 DENVER CENTER FOR INTERNATIONAL STUDIES   Regular School No 4.0 06 12 2015   grade_7 45.0 3.0 49.0   2.0 9.0     2.0   9.0   56.0 63.0                       119.0 45 3 49   2 9     2   9   56 63                 119
1137208 1137208 CO     school 803360 880   DENVER COUNTY 1 80336000364 3990 HILL CAMPUS OF ARTS AND SCIENCES   Regular School No 2.0 06 08 2015   grade_7 60.0 55.0 88.0   0.0 5.0     0.0   9.0   117.0 100.0                       217.0 60 55 88   0 5     0   9   117 100                 217
1140975 1140975 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000713 2300 DUNSTAN MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   grade_7 215.0 6.0 58.0   2.0 17.0     1.0   9.0   158.0 150.0                       308.0 215 6 58   2 17     1   9   158 150                 308
1141428 1141428 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001317 6090 MOORE MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   grade_7 139.0 4.0 85.0   2.0 2.0     0.0   9.0   122.0 119.0                       241.0 139 4 85   2 2     0   9   122 119                 241
708197 708197 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001186 6342 SHADOW RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 164 6 135   2 19     1   9   161 175                       336 164 6 135   2 19     1   9   161 175                 336
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
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
710563 710563 CO     school 802490 480   BOULDER VALLEY RE 2 80249001758 441 ASPEN CREEK K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 124 2 16   1 6     0   9   76 82                       158 124 2 16   1 6     0   9   76 82                 158
710633 710633 CO     school 802490 480   BOULDER VALLEY RE 2 80249000106 1352 CASEY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 121 3 85   2 6     0   9   120 106                       226 121 3 85   2 6     0   9   120 106                 226
715653 715653 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000703 1318 CARMODY MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 156 2 100   2 7     0   9   146 130                       276 156 2 100   2 7     0   9   146 130                 276
715784 715784 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000713 2300 DUNSTAN MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 233 6 65   3 14     1   9   149 182                       331 233 6 65   3 14     1   9   149 182                 331
715999 715999 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001921 4404 JEFFERSON ACADEMY   Regular School Yes Other KG 12 2017   grade_7 122 1 20   0 8     0   9   75 85                       160 122 1 20   0 8     0   9   75 85                 160
716289 716289 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000760 6330 NORTH ARVADA MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 123 1 108   1 8     0   9   135 115                       250 123 1 108   1 8     0   9   135 115                 250
719391 719391 CO     school 806150 2700   PUEBLO COUNTY 70 80615001357 7212 LIBERTY POINT INTERNATIONAL SCHOOL   Regular School No Middle 06 08 2017   grade_7 63 0 63   2 2     0   9   79 60                       139 63 0 63   2 2     0   9   79 60                 139
720154 720154 CO     school 807350 3100   WINDSOR RE-4 80735001265 9670 WINDSOR MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 182 1 38   0 3     0   9   132 101                       233 182 1 38   0 3     0   9   132 101                 233
837409 837409 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000074 6310 NORTH MIDDLE SCHOOL HEALTH SCIENCES AND TECHNOLOGY CAMPUS   Regular School No 2.0 06 08 2016   grade_7 19 37 212   4 6     2   9   130 159                       289 19 37 212   4 6     2   9   130 159                 289
838482 838482 CO     school 802490 480   BOULDER VALLEY RE 2 80249001573 6000 MONARCH K-8 SCHOOL   Regular School No 1.0 PK 08 2016   grade_7 119 3 11   0 12     1   9   84 71                       155 119 3 11   0 12     1   9   84 71                 155
838534 838534 CO     school 802490 480   BOULDER VALLEY RE 2 80249001792 6816 PEAK TO PEAK CHARTER SCHOOL   Regular School Yes 4.0 KG 12 2016   grade_7 85 1 17   0 22     1   9   79 56                       135 85 1 17   0 22     1   9   79 56                 135
839188 839188 CO     school 803360 880   DENVER COUNTY 1 80336006566 2115 DSST: STAPLETON MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2016   grade_7 36 42 55   1 7     0   9   73 77                       150 36 42 55   1 7     0   9   73 77                 150
839300 839300 CO     school 803360 880   DENVER COUNTY 1 80336006618 2218 DSST: CONSERVATORY GREEN MIDDLE SCHOOL   Regular School Yes 2.0 06 07 2016   grade_7 30 49 54   0 6     0   9   85 63                       148 30 49 54   0 6     0   9   85 63                 148
843154 843154 CO     school   1420   JEFFERSON COUNTY R-1   109 ARVADA K-8             2016   grade_7 67 3 68   0 5     0   9   82 70                       152 67 3 68   0 5     0   9   82 70                 152
843454 843454 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001970 2963 FALCON BLUFFS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 181 0 25   1 3     0   9   113 106                       219 181 0 25   1 3     0   9   113 106                 219
844337 844337 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000795 9428 WEST JEFFERSON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 169 0 10   4 7     0   9   94 105                       199 169 0 10   4 7     0   9   94 105                 199
845200 845200 CO     school 805400 1560   THOMPSON R2-J 80540001655 5335 LUCILE ERWIN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 234 6 54   1 5     0   9   146 163                       309 234 6 54   1 5     0   9   146 163                 309
1738664 1738664 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2021   grade_7 88 1 18   0 12     0   9   62 66                       128 88 1 18   0 12     0   9   62 66                 128
1739832 1739832 CO     school 805310 140   Littleton 6 80531000876 2804 Euclid Middle School   Regular School No Middle 06 08 2021   grade_7 189 2 46   2 1     2   9   139 112                       251 189 2 46   2 1     2   9   139 112                 251
1741136 1741136 CO     school 802490 480   Boulder Valley Re 2 80249000102 1066 Broomfield Heights Middle School   Regular School No Middle 06 08 2021   grade_7 112 5 58   0 2     0   9   91 95                       186 112 5 58   0 2     0   9   91 95                 186
1741386 1741386 CO     school 802490 480   Boulder Valley Re 2 80249000132 6224 Nevin Platt Middle School   Regular School No Middle 06 08 2021   grade_7 122 3 14   0 3     0   9   90 61                       151 122 3 14   0 3     0   9   90 61                 151
1742158 1742158 CO     school 803360 880   Denver County 1 80336006572 2186 DSST: Byers Middle School   Regular School Yes Middle 06 08 2021   grade_7 57 37 53   1 5     0   9   85 77                       162 57 37 53   1 5     0   9   85 77                 162
1742706 1742706 CO     school 803360 880   Denver County 1 80336006687 5973 McAuliffe Manual Middle School   Regular School No Middle 06 08 2021   grade_7 17 28 49   1 3     0   9   65 42                       107 17 28 49   1 3     0   9   65 42                 107
1744166 1744166 CO     school 804530 980   Harrison 2 80453000662 1306 Carmel Middle School   Regular School No Middle 06 08 2021   grade_7 14 21 54   0 3     0   9   53 48                       101 14 21 54   0 3     0   9   53 48                 101
1744262 1744262 CO     school 804530 980   Harrison 2 80453000669 6686 Panorama Middle School   Regular School No Middle 06 08 2021   grade_7 37 35 81   0 7     2   9   94 77                       171 37 35 81   0 7     2   9   94 77                 171
1746364 1746364 CO     school 804800 1420   Jefferson County R-1 80480000712 2288 Drake Junior High School   Regular School No Middle 06 08 2021   grade_7 252 3 60   2 7     0   9   160 173                       333 252 3 60   2 7     0   9   160 173                 333
1748597 1748597 CO     school 804350 2000   Mesa County Valley 51 80435000608 3244 Fruita Middle School   Regular School No Middle 06 07 2021   grade_7 220 2 40   0 2     0   9   141 132                       273 220 2 40   0 2     0   9   141 132                 273
1799623 1799623 CO     school 806900 20   Adams 12 Five Star Schools 80690001178 4172 Hulstrom Options K-8 School   Regular School No Elementary KG 08 2020   grade_7 42 0 10   0 9     0   9   29 41                       70 42 0 10   0 9     0   9   29 41                 70
1801298 1801298 CO     school 802340 180   Adams-Arapahoe 28J 80234001881 6189 Murphy Creek K-8 School   Regular School No Elementary PK 08 2020   grade_7 35 13 35   0 5     0   9   42 55                       97 35 13 35   0 5     0   9   42 55                 97
1801447 1801447 CO     school 802340 180   Adams-Arapahoe 28J 80234006483 9083 Vista Peak P-8 Exploratory   Regular School No Elementary PK 08 2020   grade_7 31 13 68   0 6     0   9   71 56                       127 31 13 68   0 6     0   9   71 56                 127
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
1803115 1803115 CO     school 803360 880   Denver County 1 80336006482 2127 Denver Language School   Regular School Yes Elementary KG 08 2020   grade_7 41 5 18   0 3     1   9   43 34                       77 41 5 18   0 3     1   9   43 34                 77
1803221 1803221 CO     school 803360 880   Denver County 1 80336006618 2218 DSST: Conservatory Green Middle School   Regular School Yes Middle 06 08 2020   grade_7 23 29 91   1 6     0   9   88 71                       159 23 29 91   1 6     0   9   88 71                 159
1803725 1803725 CO     school 803360 880   Denver County 1 80336006687 5973 McAuliffe Manual Middle School   Regular School No Middle 06 08 2020   grade_7 31 25 47   0 2     0   9   56 58                       114 31 25 47   0 2     0   9   56 58                 114
1803748 1803748 CO     school 803360 880   Denver County 1 80336000386 6098 Morey Middle School   Regular School No Middle 06 08 2020   grade_7 60 20 26   2 3     0   9   71 49                       120 60 20 26   2 3     0   9   71 49                 120
1806581 1806581 CO     school 803870 1110   District 49 80387006386 4251 Grand Peak Academy   Regular School Yes Elementary KG 08 2020   grade_7 39 1 11   0 1     1   9   25 37                       62 39 1 11   0 1     1   9   25 37                 62
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
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
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
1809659 1809659 CO     school 804350 2000   Mesa County Valley 51 80435000598 900 Bookcliff Middle School   Regular School No Middle 06 08 2020   grade_7 100 1 92   1 0     1   9   122 82                       204 100 1 92   1 0     1   9   122 82                 204
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
1811333 1811333 CO     school 804860 2862   Julesburg Re-1 80486006387 4369 Destinations Career Academy of Colorado   Alternative School No High 06 12 2020   grade_7 29 3 20   1 1     0   9   32 31                       63 29 3 20   1 1     0   9   32 31                 63
1895659 1895659 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001881 6189 MURPHY CREEK K-8 SCHOOL   Regular School No Elementary PK 08 2018   grade_7 11 13 23   0 4     0   9   35 25                       60 11 13 23   0 4     0   9   35 25                 60
1895801 1895801 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006483 9083 VISTA PEAK P-8 EXPLORATORY   Regular School No Elementary PK 08 2018   grade_7 32 14 48   2 4     0   9   53 56                       109 32 14 48   2 4     0   9   53 56                 109
1896516 1896516 CO     school 802490 480   BOULDER VALLEY RE 2 80249000102 1066 BROOMFIELD HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 119 5 41   1 5     0   9   85 95                       180 119 5 41   1 5     0   9   85 95                 180
1896792 1896792 CO     school 802490 480   BOULDER VALLEY RE 2 80249001792 6816 PEAK TO PEAK CHARTER SCHOOL   Regular School Yes Other KG 12 2018   grade_7 100 0 14   0 13     0   9   71 65                       136 100 0 14   0 13     0   9   71 65                 136
1898089 1898089 CO     school 803360 880   DENVER COUNTY 1 80336000386 6098 MOREY MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 38 13 24   1 3     0   9   55 33                       88 38 13 24   1 3     0   9   55 33                 88
1900085 1900085 CO     school 803060 1010   COLORADO SPRINGS 11 80306000241 4070 HOLMES MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 160 8 31   1 1     0   9   117 93                       210 160 8 31   1 1     0   9   117 93                 210
1903566 1903566 CO     school 805400 1560   THOMPSON R2-J 80540000929 5312 BILL REED MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 133 4 57   0 3     0   9   98 108                       206 133 4 57   0 3     0   9   98 108                 206
1931074 1931074 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2019   grade_7 145 12 44   2 1     0   9   83 130                       213 145 12 44   2 1     0   9   83 130                 213
1931154 1931154 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001620 1480 CENTURY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 144 4 98   4 18     0   9   139 138                       277 144 4 98   4 18     0   9   139 138                 277
1931491 1931491 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001194 9444 WESTLAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 271 7 75   2 15     1   9   203 177                       380 271 7 75   2 15     1   9   203 177                 380
1931907 1931907 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001244 7812 SHAW HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 31 3 136   0 10     0   9   102 87                       189 31 3 136   0 10     0   9   102 87                 189
1933108 1933108 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006483 9083 VISTA PEAK P-8 EXPLORATORY   Regular School No Elementary PK 08 2019   grade_7 33 16 59   2 3     0   9   70 52                       122 33 16 59   2 3     0   9   70 52                 122
1933868 1933868 CO     school 802490 480   BOULDER VALLEY RE 2 80249000106 1352 CASEY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 138 0 85   0 9     0   9   115 126                       241 138 0 85   0 9     0   9   115 126                 241
1934843 1934843 CO     school 803360 880   DENVER COUNTY 1 80336006546 2181 DSST: GREEN VALLEY RANCH MIDDLE SCHOOL   Regular School Yes Middle 06 08 2019   grade_7 11 33 92   1 13     2   9   75 86                       161 11 33 92   1 13     2   9   75 86                 161
1934904 1934904 CO     school 803360 880   DENVER COUNTY 1 80336006618 2218 DSST: CONSERVATORY GREEN MIDDLE SCHOOL   Regular School Yes Middle 06 08 2019   grade_7 22 45 83   2 5     0   9   88 78                       166 22 45 83   2 5     0   9   88 78                 166
1935055 1935055 CO     school 803360 880   DENVER COUNTY 1 80336000357 3600 GRANT BEACON MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 17 7 112   1 3     0   9   92 57                       149 17 7 112   1 3     0   9   92 57                 149
1938920 1938920 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000696 660 BEAR CREEK K-8 SCHOOL   Regular School No Elementary KG 08 2019   grade_7 61 1 40   2 9     3   9   68 57                       125 61 1 40   2 9     3   9   68 57                 125
1939196 1939196 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001970 2963 FALCON BLUFFS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 174 1 32   2 5     0   9   106 117                       223 174 1 32   2 5     0   9   106 117                 223
1940455 1940455 CO     school 803990 1550   POUDRE R-1 80399000522 892 BLEVINS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 161 4 45   0 3     0   9   125 97                       222 161 4 45   0 3     0   9   125 97                 222
1940459 1940459 CO     school 803990 1550   POUDRE R-1 80399000523 898 BOLTZ MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 136 6 56   1 2     0   9   114 96                       210 136 6 56   1 2     0   9   114 96                 210
1940472 1940472 CO     school 803990 1550   POUDRE R-1 80399000524 1190 CACHE LA POUDRE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 97 0 10   0 0     0   9   63 53                       116 97 0 10   0 0     0   9   63 53                 116
1942715 1942715 CO     school 806150 2700   PUEBLO COUNTY 70 80615001357 7212 LIBERTY POINT INTERNATIONAL SCHOOL   Regular School No Middle 06 08 2019   grade_7 73 1 64   4 0     0   9   77 74                       151 73 1 64   4 0     0   9   77 74                 151
1943471 1943471 CO     school 807350 3100   WINDSOR RE-4 80735001265 9670 WINDSOR MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 191 0 29   0 3     0   9   135 97                       232 191 0 29   0 3     0   9   135 97                 232
1135880 1135880 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006198 9430 WESTVIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 201.0 1.0 50.0   2.0 9.0     0.0   8.0   134.0 137.0                       271.0 201 1 50   2 9     0   8   134 137                 271
1135961 1135961 CO     school 802490 480   BOULDER VALLEY RE 2 80249000104 1136 MANHATTAN MIDDLE SCHOOL OF THE ARTS AND ACADEMICS   Regular School No 2.0 06 08 2015   grade_7 117.0 1.0 45.0   1.0 15.0     0.0   8.0   90.0 97.0                       187.0 117 1 45   1 15     0   8   90 97                 187
1136255 1136255 CO     school 802490 480   BOULDER VALLEY RE 2 80249000134 8135 SOUTHERN HILLS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 152.0 1.0 8.0   1.0 10.0     0.0   8.0   99.0 81.0                       180.0 152 1 8   1 10     0   8   99 81                 180
1136867 1136867 CO     school 803360 880   DENVER COUNTY 1 80336006566 2115 DSST: STAPLETON MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2015   grade_7 42.0 37.0 59.0   0.0 11.0     0.0   8.0   74.0 83.0                       157.0 42 37 59   0 11     0   8   74 83                 157
1136920 1136920 CO     school 803360 880   DENVER COUNTY 1 80336006546 2181 DSST: GREEN VALLEY RANCH MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2015   grade_7 11.0 44.0 69.0   1.0 15.0     0.0   8.0   82.0 66.0                       148.0 11 44 69   1 15     0   8   82 66                 148
1138990 1138990 CO     school 804530 980   HARRISON 2 80453000669 6686 PANORAMA MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 30.0 26.0 93.0   8.0 7.0     1.0   8.0   91.0 82.0                       173.0 30 26 93   8 7     1   8   91 82                 173
1140070 1140070 CO     school 803870 1110   FALCON 49 80387002027 555 BANNING LEWIS RANCH ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_7 52.0 5.0 14.0   0.0 2.0     1.0   8.0   40.0 42.0                       82.0 52 5 14   0 2     1   8   40 42                 82
1142639 1142639 CO     school 805400 1560   THOMPSON R2-J 80540000925 510 CONRAD BALL MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 127.0 5.0 70.0   0.0 2.0     0.0   8.0   124.0 88.0                       212.0 127 5 70   0 2     0   8   124 88                 212
1142862 1142862 CO     school 805400 1560   THOMPSON R2-J 80540001286 9228 WALT CLARK MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 133.0 1.0 29.0   1.0 0.0     1.0   8.0   89.0 84.0                       173.0 133 1 29   1 0     1   8   89 84                 173
1143212 1143212 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000598 900 BOOKCLIFF MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 97.0 0.0 86.0   0.0 0.0     0.0   8.0   92.0 99.0                       191.0 97 0 86   0 0     0   8   92 99                 191
1143292 1143292 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000608 3244 FRUITA MIDDLE SCHOOL   Regular School No 2.0 06 07 2015   grade_7 224.0 3.0 44.0   1.0 3.0     1.0   8.0   156.0 128.0                       284.0 224 3 44   1 3     1   8   156 128                 284
1143441 1143441 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000205 7281 REDLANDS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 170.0 0.0 22.0   0.0 1.0     0.0   8.0   116.0 85.0                       201.0 170 0 22   0 1     0   8   116 85                 201
1143571 1143571 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309000833 1888 CORTEZ MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 92.0 0.0 46.0   57.0 1.0     1.0   8.0   97.0 108.0                       205.0 92 0 46   57 1     1   8   97 108                 205
1143690 1143690 CO     school 805790 2180   MONTROSE COUNTY RE-1J 80579000989 6054 COLUMBINE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 119.0 2.0 43.0   0.0 2.0     0.0   8.0   95.0 79.0                       174.0 119 2 43   0 2     0   8   95 79                 174
708015 708015 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001620 1480 CENTURY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 208 6 92   4 15     0   8   156 177                       333 208 6 92   4 15     0   8   156 177                 333
710629 710629 CO     school 802490 480   BOULDER VALLEY RE 2 80249000104 1136 MANHATTAN MIDDLE SCHOOL OF THE ARTS AND ACADEMICS   Regular School No Middle 06 08 2017   grade_7 96 2 31   1 6     0   8   71 73                       144 96 2 31   1 6     0   8   71 73                 144
710816 710816 CO     school 802490 480   BOULDER VALLEY RE 2 80249000125 5306 LOUISVILLE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 170 2 28   1 6     0   8   107 108                       215 170 2 28   1 6     0   8   107 108                 215
711642 711642 CO     school 803360 880   DENVER COUNTY 1 80336006572 2186 DSST: BYERS MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 71 14 56   1 7     0   8   89 68                       157 71 14 56   1 7     0   8   89 68                 157
712726 712726 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001896 215 AMERICAN ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 125 2 16   0 17     0   8   83 85                       168 125 2 16   0 17     0   8   83 85                 168
713663 713663 CO     school 804530 980   HARRISON 2 80453006691 369 ATLAS PREPARATORY MIDDLE SCHOOL   Regular School Yes Middle 05 08 2017   grade_7 18 14 123   0 0     2   8   89 76                       165 18 14 123   0 0     2   8   89 76                 165

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