enrollments

Data source: Big Local News · About: Big Local

4,236 rows where grade = "grade_7" and state = "CO" sorted by male 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
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
708536 708536 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001377 6638 OVERLAND TRAIL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 73 3 118   0 2     1   7   99 105                       204 73 3 118   0 2     1   7   99 105                 204
712143 712143 CO     school 803360 880   DENVER COUNTY 1 80336000379 5826 MERRILL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 80 14 56   2 6     0   6   99 65                       164 80 14 56   2 6     0   6   99 65                 164
717620 717620 CO     school 805400 1560   THOMPSON R2-J 80540000929 5312 BILL REED MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 166 3 39   0 1     0   5   99 115                       214 166 3 39   0 1     0   5   99 115                 214
838565 838565 CO     school 802490 480   BOULDER VALLEY RE 2 80249000134 8135 SOUTHERN HILLS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 157 0 17   0 9     0   13   99 97                       196 157 0 17   0 9     0   13   99 97                 196
846102 846102 CO     school 805790 2180   MONTROSE COUNTY RE-1J 80579000987 1392 CENTENNIAL MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 100 0 69   1 0     1   6   99 78                       177 100 0 69   1 0     1   6   99 78                 177
1741317 1741317 CO     school 802490 480   Boulder Valley Re 2 80249000122 4878 Angevine Middle School   Regular School No Middle 06 08 2021   grade_7 96 0 74   1 10     0   13   99 95                       194 96 0 74   1 10     0   13   99 95                 194
1744807 1744807 CO     school 803060 1010   Colorado Springs 11 80306000263 7523 Russell Middle School   Regular School No Middle 06 08 2021   grade_7 95 17 61   0 4     1   13   99 92                       191 95 17 61   0 4     1   13   99 92                 191
1746420 1746420 CO     school 804800 1420   Jefferson County R-1 80480000718 2832 Evergreen Middle School   Regular School No Middle 06 08 2021   grade_7 180 1 14   2 3     0   5   99 106                       205 180 1 14   2 3     0   5   99 106                 205
1746840 1746840 CO     school 804800 1420   Jefferson County R-1 80480000760 6330 North Arvada Middle School   Regular School No Middle 06 08 2021   grade_7 97 2 86   1 10     0   8   99 105                       204 97 2 86   1 10     0   8   99 105                 204
1800231 1800231 CO     school 807230 70   Westminster Public Schools 80723001244 7812 Shaw Heights Middle School   Regular School No Middle 06 08 2020   grade_7 32 10 128   2 12     0   7   99 92                       191 32 10 128   2 12     0   7   99 92                 191
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
1807892 1807892 CO     school 804800 1420   Jefferson County R-1 80480001317 6090 Moore Middle School   Regular School No Middle 06 08 2020   grade_7 119 4 70   3 1     0   6   99 104                       203 119 4 70   3 1     0   6   99 104                 203
1811662 1811662 CO     school 804920 3090   Weld County School District RE-3J 80492002026 9347 Weld Central Middle School   Regular School No Middle 06 08 2020   grade_7 82 2 96   0 2     0   2   99 85                       184 82 2 96   0 2     0   2   99 85                 184
1812031 1812031 CO     school 804020 3140   Weld Re-8 Schools 80402000553 3066 Fort Lupton Middle School   Regular School No Middle 06 08 2020   grade_7 25 1 142   0 0     0   1   99 70                       169 25 1 142   0 0     0   1   99 70                 169
1898931 1898931 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006578 3847 HOPE ONLINE LEARNING ACADEMY MIDDLE SCHOOL   Regular School Yes Middle 06 08 2018   grade_7 21 10 180   0 1     0   4   99 117                       216 21 10 180   0 1     0   4   99 117                 216
1902096 1902096 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001746 5472 MANNING OPTIONS SCHOOL   Regular School No Middle 07 08 2018   grade_7 177 3 22   0 9     0   10   99 122                       221 177 3 22   0 9     0   10   99 122                 221
1932442 1932442 CO     school 802910 130   CHERRY CREEK 5 80291006728 7514 INFINITY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 116 18 46   1 17     0   12   99 111                       210 116 18 46   1 17     0   12   99 111                 210
1935646 1935646 CO     school 803360 880   DENVER COUNTY 1 80336000403 7942 SKINNER MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 72 8 115   2 5     0   8   99 111                       210 72 8 115   2 5     0   8   99 111                 210
1939488 1939488 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001746 5472 MANNING OPTIONS SCHOOL   Regular School No Middle 06 08 2019   grade_7 179 2 25   0 4     0   14   99 125                       224 179 2 25   0 4     0   14   99 125                 224
1940049 1940049 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000795 9428 WEST JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 158 1 11   0 3     0   3   99 77                       176 158 1 11   0 3     0   3   99 77                 176
1940339 1940339 CO     school 803480 1520   DURANGO 9-R 80348000456 7994 ESCALANTE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 110 0 40   14 1     0   3   99 69                       168 110 0 40   14 1     0   3   99 69                 168
1135974 1135974 CO     school 802490 480   BOULDER VALLEY RE 2 80249000108 1390 CENTENNIAL MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 130.0 0.0 36.0   3.0 11.0     0.0   12.0   98.0 94.0                       192.0 130 0 36   3 11     0   12   98 94                 192
717468 717468 CO     school 803990 1550   POUDRE R-1 80399000551 9374 WELLINGTON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 139 3 33   1 1     0   2   98 81                       179 139 3 33   1 1     0   2   98 81                 179
836378 836378 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001244 7812 SHAW HEIGHTS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 37 1 145   2 15     0   3   98 105                       203 37 1 145   2 15     0   3   98 105                 203
1742351 1742351 CO     school 803360 880   Denver County 1 80336000357 3600 Grant Beacon Middle School   Regular School No Middle 06 08 2021   grade_7 44 15 96   0 8     0   5   98 70                       168 44 15 96   0 8     0   5   98 70                 168
1746726 1746726 CO     school 804800 1420   Jefferson County R-1 80480001746 5472 Manning Options School   Regular School No Middle 06 08 2021   grade_7 177 2 29   1 5     0   8   98 124                       222 177 2 29   1 5     0   8   98 124                 222
1802951 1802951 CO     school 803360 880   Denver County 1 80336006682 1077 Bear Valley International School   Regular School No Middle 06 08 2020   grade_7 20 5 123   2 7     0   2   98 61                       159 20 5 123   2 7     0   2   98 61                 159
1811870 1811870 CO     school 804410 3120   Greeley 6 80441000639 3162 Franklin Middle School   Regular School No Middle 06 08 2020   grade_7 22 0 167   2 4     0   2   98 99                       197 22 0 167   2 4     0   2   98 99                 197
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
1906178 1906178 CO     school 804410 3120   GREELEY 6 80441000634 988 BRENTWOOD MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 49 6 127   0 6     0   1   98 91                       189 49 6 127   0 6     0   1   98 91                 189
1906405 1906405 CO     school 804020 3140   WELD COUNTY S/D RE-8 80402000553 3066 FORT LUPTON MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 27 1 140   0 1     0   2   98 73                       171 27 1 140   0 1     0   2   98 73                 171
1933855 1933855 CO     school 802490 480   BOULDER VALLEY RE 2 80249000102 1066 BROOMFIELD HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 127 1 48   0 5     1   11   98 95                       193 127 1 48   0 5     1   11   98 95                 193
1939564 1939564 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001317 6090 MOORE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 113 6 58   3 4     0   5   98 91                       189 113 6 58   3 4     0   5   98 91                 189
1941616 1941616 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000205 7281 REDLANDS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 157 1 22   1 3     0   3   98 89                       187 157 1 22   1 3     0   3   98 89                 187
1140434 1140434 CO     school 804260 1180   ROARING FORK RE-1 80426000587 3464 GLENWOOD SPRINGS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 72.0 0.0 104.0   0.0 0.0     0.0   4.0   97.0 83.0                       180.0 72 0 104   0 0     0   4   97 83                 180
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
710388 710388 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000908 5286 SUNSET MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 104 0 81   0 1     0   5   97 94                       191 104 0 81   0 1     0   5   97 94                 191
713885 713885 CO     school 806480 990   WIDEFIELD 3 80648001125 8178 SPROUL JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2017   grade_7 71 14 56   2 0     2   24   97 72                       169 71 14 56   2 0     2   24   97 72                 169
836355 836355 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001241 5388 M. SCOTT CARPENTER MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 9 3 156   0 9     0   1   97 81                       178 9 3 156   0 9     0   1   97 81                 178
841882 841882 CO     school 803060 1010   COLORADO SPRINGS 11 80306000256 6306 NORTH MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 99 16 80   1 2     1   20   97 122                       219 99 16 80   1 2     1   20   97 122                 219
843765 843765 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001746 5472 MANNING OPTIONS SCHOOL   Regular School No 2.0 07 08 2016   grade_7 182 1 25   2 8     1   6   97 128                       225 182 1 25   2 8     1   6   97 128                 225
1739989 1739989 CO     school 802340 180   Adams-Arapahoe 28J 80234006787 127 Aurora Science & Tech Middle School   Regular School Yes Middle 06 07 2021   grade_7 16 23 115   0 4     2   11   97 74                       171 16 23 115   0 4     2   11   97 74                 171
1744838 1744838 CO     school 803060 1010   Colorado Springs 11 80306006421 8457 Jack Swigert Aerospace Academy   Regular School No Middle 06 08 2021   grade_7 49 18 88   1 8     1   15   97 83                       180 49 18 88   1 8     1   15   97 83                 180
1748702 1748702 CO     school 804350 2000   Mesa County Valley 51 80435001345 6166 Mount Garfield Middle School   Regular School No Middle 06 08 2021   grade_7 118 1 52   1 0     0   8   97 83                       180 118 1 52   1 0     0   8   97 83                 180
1805760 1805760 CO     school 803060 1010   Colorado Springs 11 80306000241 4070 Holmes Middle School   Regular School No Middle 06 08 2020   grade_7 122 10 37   2 5     1   15   97 95                       192 122 10 37   2 5     1   15   97 95                 192
1810009 1810009 CO     school 803090 2035   Montezuma-Cortez RE-1 80309000833 1888 Montezuma-Cortez Middle School   Regular School No Middle 06 08 2020   grade_7 106 1 42   53 0     0   8   97 113                       210 106 1 42   53 0     0   8   97 113                 210
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
1897585 1897585 CO     school 803360 880   DENVER COUNTY 1 80336006624 2227 DENVER DISCOVERY SCHOOL   Regular School No Middle 06 08 2018   grade_7 58 40 32   0 4     1   11   97 49                       146 58 40 32   0 4     1   11   97 49                 146
1903083 1903083 CO     school 803990 1550   POUDRE R-1 80399000522 892 BLEVINS MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 137 3 46   2 4     0   5   97 100                       197 137 3 46   2 4     0   5   97 100                 197
1933793 1933793 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006198 9430 WESTVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 171 2 48   0 7     0   7   97 138                       235 171 2 48   0 7     0   7   97 138                 235
1141955 1141955 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006512 9515 WHEAT RIDGE 5-8   Regular School No 2.0 05 08 2015   grade_7 30.0 4.0 143.0   3.0 2.0     1.0   1.0   96.0 88.0                       184.0 30 4 143   3 2     1   1   96 88                 184
709373 709373 CO     school 805310 140   LITTLETON 6 80531000885 4316 NEWTON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 149 6 20   2 8     0   7   96 96                       192 149 6 20   2 8     0   7   96 96                 192
713697 713697 CO     school 804530 980   HARRISON 2 80453000666 3522 FOX MEADOW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 58 30 96   5 6     3   11   96 113                       209 58 30 96   5 6     3   11   96 113                 209
715305 715305 CO     school 806240 1195   GARFIELD RE-2 80624001098 7388 RIVERSIDE SCHOOL   Regular School No Middle 05 08 2017   grade_7 88 1 80   0 1     0   4   96 78                       174 88 1 80   0 1     0   4   96 78                 174
844605 844605 CO     school 803480 1520   DURANGO 9-R 80348000456 7994 ESCALANTE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 122 0 48   8 4     0   4   96 90                       186 122 0 48   8 4     0   4   96 90                 186
1749651 1749651 CO     school 806120 2690   Pueblo City 60 80612001051 4376 Risley International Academy of Innovation   Regular School No Middle 06 08 2021   grade_7 28 4 124   1 0     0   3   96 64                       160 28 4 124   1 0     0   3   96 64                 160
1902624 1902624 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480002036 9299 WAYNE CARLE MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 155 0 35   1 7     1   4   96 107                       203 155 0 35   1 7     1   4   96 107                 203
1904008 1904008 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000598 900 BOOKCLIFF MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 94 0 95   3 1     0   3   96 100                       196 94 0 95   3 1     0   3   96 100                 196
1935392 1935392 CO     school 803360 880   DENVER COUNTY 1 80336000379 5826 MERRILL MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 98 14 57   3 12     0   11   96 99                       195 98 14 57   3 12     0   11   96 99                 195
1940311 1940311 CO     school 803480 1520   DURANGO 9-R 80348000452 5888 MILLER MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 107 2 26   8 1     0   10   96 58                       154 107 2 26   8 1     0   10   96 58                 154
1940794 1940794 CO     school 803990 1550   POUDRE R-1 80399000551 9374 WELLINGTON MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 149 2 32   0 1     0   3   96 91                       187 149 2 32   0 1     0   3   96 91                 187
1136945 1136945 CO     school 803360 880   DENVER COUNTY 1 80336006572 2186 DSST: BYERS MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2015   grade_7 89.0 14.0 35.0   2.0 6.0     0.0   5.0   95.0 56.0                       151.0 89 14 35   2 6     0   5   95 56                 151
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
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
712386 712386 CO     school 803360 880   DENVER COUNTY 1 80336000403 7942 SKINNER MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 73 15 110   2 3     0   6   95 114                       209 73 15 110   2 3     0   6   95 114                 209
718384 718384 CO     school 805730 2020   MOFFAT COUNTY RE:NO 1 80573000977 1938 CRAIG MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 121 0 51   2 1     0   3   95 83                       178 121 0 51   2 1     0   3   95 83                 178
840652 840652 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006578 3847 HOPE ONLINE LEARNING ACADEMY MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2016   grade_7 43 16 114   1 1     1   1   95 82                       177 43 16 114   1 1     1   1   95 82                 177
841500 841500 CO     school 806480 990   WIDEFIELD 3 80648001125 8178 SPROUL JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2016   grade_7 84 22 77   2 2     4   13   95 109                       204 84 22 77   2 2     4   13   95 109                 204
845863 845863 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000205 7281 REDLANDS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 143 0 23   1 5     3   8   95 88                       183 143 0 23   1 5     3   8   95 88                 183
1739170 1739170 CO     school 807230 70   Westminster Public Schools 80723001244 7812 Shaw Heights Middle School   Regular School No Middle 06 08 2021   grade_7 26 7 132   2 8     0   4   95 84                       179 26 7 132   2 8     0   4   95 84                 179
1746416 1746416 CO     school 804800 1420   Jefferson County R-1 80480000720 2820 Everitt Middle School   Regular School No Middle 06 08 2021   grade_7 74 4 91   1 3     0   8   95 86                       181 74 4 91   1 3     0   8   95 86                 181
1746796 1746796 CO     school 804800 1420   Jefferson County R-1 80480001317 6090 Moore Middle School   Regular School No Middle 06 08 2021   grade_7 91 6 70   3 7     0   14   95 96                       191 91 6 70   3 7     0   14   95 96                 191
1803513 1803513 CO     school 803360 880   Denver County 1 80336006554 4381 DSST: College View Middle School   Regular School Yes Middle 06 08 2020   grade_7 6 4 149   0 7     0   2   95 73                       168 6 4 149   0 7     0   2   95 73                 168
1810837 1810837 CO     school 806120 2690   Pueblo City 60 80612001061 7481 Roncalli Stem Academy   Regular School No Middle 06 08 2020   grade_7 33 4 123   1 0     1   1   95 68                       163 33 4 123   1 0     1   1   95 68                 163
1894612 1894612 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001244 7812 SHAW HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 28 6 124   1 8     0   4   95 76                       171 28 6 124   1 8     0   4   95 76                 171
1934154 1934154 CO     school 802490 480   BOULDER VALLEY RE 2 80249000134 8135 SOUTHERN HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 152 1 11   0 10     0   11   95 90                       185 152 1 11   0 10     0   11   95 90                 185
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
1937595 1937595 CO     school 803060 1010   COLORADO SPRINGS 11 80306000263 7523 RUSSELL MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 102 18 64   1 1     0   14   95 105                       200 102 18 64   1 1     0   14   95 105                 200
708777 708777 CO     school 802070 100   ALAMOSA RE-11J 80207000026 114 ORTEGA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 61 1 112   3 1     0   5   94 89                       183 61 1 112   3 1     0   5   94 89                 183
715754 715754 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000964 2120 D'EVELYN JUNIOR/SENIOR HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 163 1 17   1 14     0   7   94 109                       203 163 1 17   1 14     0   7   94 109                 203
838272 838272 CO     school 802490 480   BOULDER VALLEY RE 2 80249000106 1352 CASEY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 122 3 78   0 3     0   6   94 118                       212 122 3 78   0 3     0   6   94 118                 212
841952 841952 CO     school 803060 1010   COLORADO SPRINGS 11 80306006421 8457 JACK SWIGERT AEROSPACE ACADEMY   Regular School No 2.0 06 08 2016   grade_7 44 18 91   4 2     0   13   94 78                       172 44 18 91   4 2     0   13   94 78                 172
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
845284 845284 CO     school 805400 1560   THOMPSON R2-J 80540001286 9228 WALT CLARK MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 133 1 32   1 2     0   1   94 76                       170 133 1 32   1 2     0   1   94 76                 170
845842 845842 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000619 6562 ORCHARD MESA MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 115 1 41   2 1     0   4   94 70                       164 115 1 41   2 1     0   4   94 70                 164
1742133 1742133 CO     school 803360 880   Denver County 1 80336006546 2181 DSST: Green Valley Ranch Middle School   Regular School Yes Middle 06 08 2021   grade_7 9 42 93   0 11     7   3   94 71                       165 9 42 93   0 11     7   3   94 71                 165
1742200 1742200 CO     school 803360 880   Denver County 1 80336006618 2218 DSST: Conservatory Green Middle School   Regular School Yes Middle 06 08 2021   grade_7 21 30 94   0 3     1   8   94 63                       157 21 30 94   0 3     1   8   94 63                 157
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
1744399 1744399 CO     school 806480 990   Widefield 3 80648001126 9294 Watson Junior High School   Regular School No Middle 06 08 2021   grade_7 82 18 61   1 3     0   22   94 93                       187 82 18 61   1 3     0   22   94 93                 187
1749832 1749832 CO     school 806150 2700   Pueblo County 70 80615001357 7212 Liberty Point International School   Regular School No Middle 06 08 2021   grade_7 87 2 78   2 0     1   10   94 86                       180 87 2 78   2 0     1   10   94 86                 180
1808316 1808316 CO     school 804800 1420   Jefferson County R-1 80480002036 9299 Wayne Carle Middle School   Regular School No Middle 06 08 2020   grade_7 148 2 36   1 4     2   11   94 110                       204 148 2 36   1 4     2   11   94 110                 204
1808776 1808776 CO     school 803990 1550   Poudre R-1 80399000523 898 Boltz Middle School   Regular School No Middle 06 08 2020   grade_7 122 3 55   1 2     0   8   94 97                       191 122 3 55   1 2     0   8   94 97                 191
1906054 1906054 CO     school 807350 3100   WINDSOR RE-4 80735006427 7755 SEVERANCE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 144 0 41   0 1     0   2   94 94                       188 144 0 41   0 1     0   2   94 94                 188
1931695 1931695 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001377 6638 OVERLAND TRAIL MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 74 2 115   1 6     2   8   94 114                       208 74 2 115   1 6     2   8   94 114                 208
1934868 1934868 CO     school 803360 880   DENVER COUNTY 1 80336006572 2186 DSST: BYERS MIDDLE SCHOOL   Regular School Yes Middle 06 08 2019   grade_7 81 25 45   0 4     0   11   94 72                       166 81 25 45   0 4     0   11   94 72                 166
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
1944221 1944221 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001915 6914 THE PINNACLE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_7 21 3 147   0 5     0   2   94 84                       178 21 3 147   0 5     0   2   94 84                 178
1141867 1141867 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480002036 9299 WAYNE CARLE MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   grade_7 149.0 1.0 27.0   2.0 6.0     0.0   3.0   93.0 95.0                       188.0 149 1 27   2 6     0   3   93 95                 188
1144412 1144412 CO     school 806120 2690   PUEBLO CITY 60 80612001061 7481 RONCALLI STEM ACADEMY   Regular School No 2.0 06 08 2015   grade_7 28.0 5.0 122.0   5.0 1.0     0.0   2.0   93.0 70.0                       163.0 28 5 122   5 1     0   2   93 70                 163

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