enrollments

Data source: Big Local News · About: Big Local

4,236 rows where grade = "grade_7" and state = "CO" sorted by hispanic_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
1799664 1799664 CO     school 806900 20   Adams 12 Five Star Schools 80690001183 5814 The International School at Thornton Middle   Regular School No Middle 06 08 2020   grade_7 39 17 268   2 5     0   4   184 151                       335 39 17 268   2 5     0   4   184 151                 335
837262 837262 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000060 2384 EAST MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 25 57 257   4 14     2   11   192 178                       370 25 57 257   4 14     2   11   192 178                 370
835842 835842 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001183 5814 THE INTERNATIONAL SCHOOL AT THORNTON MIDDLE   Regular School No 2.0 06 08 2016   grade_7 34 16 254   2 4     0   5   176 139                       315 34 16 254   2 4     0   5   176 139                 315
1738605 1738605 CO     school 806900 20   Adams 12 Five Star Schools 80690001183 5814 Thornton Middle School   Regular School No Middle 06 08 2021   grade_7 31 13 254   3 8     1   5   164 151                       315 31 13 254   3 8     1   5   164 151                 315
1894044 1894044 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001183 5814 THE INTERNATIONAL SCHOOL AT THORNTON MIDDLE   Regular School No Middle 06 08 2018   grade_7 32 12 252   2 4     0   6   152 156                       308 32 12 252   2 4     0   6   152 156                 308
1895517 1895517 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000060 2384 EAST MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 22 32 252   5 13     2   5   186 145                       331 22 32 252   5 13     2   5   186 145                 331
1931323 1931323 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001183 5814 THE INTERNATIONAL SCHOOL AT THORNTON MIDDLE   Regular School No Middle 06 08 2019   grade_7 42 10 248   2 6     1   6   182 133                       315 42 10 248   2 6     1   6   182 133                 315
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
1801160 1801160 CO     school 802340 180   Adams-Arapahoe 28J 80234000060 2384 East Middle School   Regular School No Middle 06 08 2020   grade_7 11 39 246   5 8     2   7   164 154                       318 11 39 246   5 8     2   7   164 154                 318
1932423 1932423 CO     school 802910 130   CHERRY CREEK 5 80291000201 7158 PRAIRIE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 132 154 242   9 18     3   40   306 292                       598 132 154 242   9 18     3   40   306 292                 598
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
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
1799883 1799883 CO     school 801950 30   Adams County 14 80195000015 4516 Kearney Middle School   Regular School No Middle 06 08 2020   grade_7 32 5 236   1 0     1   1   151 125                       276 32 5 236   1 0     1   1   151 125                 276
1932821 1932821 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000060 2384 EAST MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 21 39 236   1 10     3   4   161 153                       314 21 39 236   1 10     3   4   161 153                 314
1931513 1931513 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 29 2 234   5 2     0   3   140 135                       275 29 2 234   5 2     0   3   140 135                 275
708174 708174 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001183 5814 THE INTERNATIONAL SCHOOL AT THORNTON MIDDLE   Regular School No Middle 06 08 2017   grade_7 39 16 233   4 9     0   4   170 135                       305 39 16 233   4 9     0   4   170 135                 305
709617 709617 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000060 2384 EAST MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 19 43 232   1 11     4   16   179 147                       326 19 43 232   1 11     4   16   179 147                 326
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
1894223 1894223 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 25 7 231   3 0     0   6   153 119                       272 25 7 231   3 0     0   6   153 119                 272
1738647 1738647 CO     school 806900 20   Adams 12 Five Star Schools 80690001187 6398 Northglenn Middle School   Regular School No Middle 06 08 2021   grade_7 50 4 230   2 8     0   3   181 116                       297 50 4 230   2 8     0   3   181 116                 297
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
708352 708352 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 36 6 224   1 3     1   5   150 126                       276 36 6 224   1 3     1   5   150 126                 276
708715 708715 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006458 7305 IVER C. RANUM MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 19 3 224   1 7     1   4   136 123                       259 19 3 224   1 7     1   4   136 123                 259
1133562 1133562 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001183 5814 THE INTERNATIONAL SCHOOL AT THORNTON MIDDLE   Regular School No 2.0 06 08 2015   grade_7 47.0 10.0 224.0   4.0 7.0     0.0   2.0   154.0 140.0                       294.0 47 10 224   4 7     0   2   154 140                 294
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
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
1799846 1799846 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2020   grade_7 23 3 221   2 0     1   6   121 135                       256 23 3 221   2 0     1   6   121 135                 256
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
708390 708390 CO     school 801950 30   ADAMS COUNTY 14 80195000015 4516 KEARNEY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 30 13 216   2 0     0   1   139 123                       262 30 13 216   2 0     0   1   139 123                 262
1738787 1738787 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2021   grade_7 22 3 216   1 0     0   3   134 111                       245 22 3 216   1 0     0   3   134 111                 245
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
1133726 1133726 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 29.0 7.0 215.0   2.0 2.0     0.0   5.0   135.0 125.0                       260.0 29 7 215   2 2     0   5   135 125                 260
1738569 1738569 CO     school 806900 20   Adams 12 Five Star Schools 80690001179 4187 Silver Hills Middle School   Regular School No Middle 06 08 2021   grade_7 113 5 213   3 8     0   12   190 164                       354 113 5 213   3 8     0   12   190 164                 354
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
836010 836010 CO     school   30   ADAMS COUNTY 14   20 ADAMS CITY MIDDLE SCHOOL             2016   grade_7 38 6 212   3 1     0   3   149 114                       263 38 6 212   3 1     0   3   149 114                 263
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
1738824 1738824 CO     school 801950 30   Adams County 14 80195000015 4516 Kearney Middle School   Regular School No Middle 06 08 2021   grade_7 26 2 212   1 0     0   1   128 114                       242 26 2 212   1 0     0   1   128 114                 242
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
1137677 1137677 CO     school 803360 880   DENVER COUNTY 1 80336000363 8054 HENRY WORLD SCHOOL GRADES 6-8   Regular School No 2.0 06 08 2015   grade_7 28.0 10.0 208.0   1.0 20.0     0.0   7.0   139.0 135.0                       274.0 28 10 208   1 20     0   7   139 135                 274
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
1895665 1895665 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000074 6310 NORTH MIDDLE SCHOOL HEALTH SCIENCES AND TECHNOLOGY CAMPUS   Regular School No Middle 06 08 2018   grade_7 11 32 205   3 8     3   3   124 141                       265 11 32 205   3 8     3   3   124 141                 265
847874 847874 CO     school 804410 3120   GREELEY 6 80441000639 3162 FRANKLIN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 25 2 204   3 4     0   2   121 119                       240 25 2 204   3 4     0   2   121 119                 240
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
1135115 1135115 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000074 6310 NORTH MIDDLE SCHOOL HEALTH SCIENCES AND TECHNOLOGY CAMPUS   Regular School No 2.0 06 08 2015   grade_7 19.0 45.0 204.0   4.0 8.0     0.0   6.0   132.0 154.0                       286.0 19 45 204   4 8     0   6   132 154                 286
1931286 1931286 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001179 4187 SILVER HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 136 6 203   2 21     0   5   166 207                       373 136 6 203   2 21     0   5   166 207                 373
1145442 1145442 CO     school 804410 3120   GREELEY 6 80441000639 3162 FRANKLIN MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 38.0 4.0 201.0   1.0 3.0     0.0   4.0   143.0 108.0                       251.0 38 4 201   1 3     0   4   143 108                 251
1799706 1799706 CO     school 806900 20   Adams 12 Five Star Schools 80690001187 6398 Northglenn Middle School   Regular School No Middle 06 08 2020   grade_7 60 7 199   0 4     0   5   147 128                       275 60 7 199   0 4     0   5   147 128                 275
843144 843144 CO     school   1420   JEFFERSON COUNTY R-1   108 ALAMEDA INTERNATIONAL JUNIOR/SENIOR HIGH SCHOOL             2016   grade_7 49 4 198   3 5     0   6   131 134                       265 49 4 198   3 5     0   6   131 134                 265
1740120 1740120 CO     school 802340 180   Adams-Arapahoe 28J 80234000060 2384 East Middle School   Regular School No Middle 06 08 2021   grade_7 6 28 198   3 8     3   6   135 117                       252 6 28 198   3 8     3   6   135 117                 252
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
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
1894087 1894087 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001187 6398 NORTHGLENN MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 54 4 197   2 7     2   3   137 132                       269 54 4 197   2 7     2   3   137 132                 269
709764 709764 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000074 6310 NORTH MIDDLE SCHOOL HEALTH SCIENCES AND TECHNOLOGY CAMPUS   Regular School No Middle 06 08 2017   grade_7 18 34 196   2 9     3   7   139 130                       269 18 34 196   2 9     3   7   139 130                 269
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
1894600 1894600 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006458 7305 IVER C. RANUM MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 16 2 195   1 10     1   1   105 121                       226 16 2 195   1 10     1   1   105 121                 226
1943639 1943639 CO     school 804410 3120   GREELEY 6 80441000642 3880 HEATH MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 52 14 191   0 9     0   4   150 120                       270 52 14 191   0 9     0   4   150 120                 270
836366 836366 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006458 7305 IVER C. RANUM MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 36 2 190   4 7     2   3   116 128                       244 36 2 190   4 7     2   3   116 128                 244
837185 837185 CO     school   180   ADAMS-ARAPAHOE 28J   464 AURORA HILLS MIDDLE SCHOOL             2016   grade_7 41 61 189   0 4     3   14   151 161                       312 41 61 189   0 4     3   14   151 161                 312
1144445 1144445 CO     school 806120 2690   PUEBLO CITY 60 80612001067 9188 W H HEATON MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 69.0 5.0 189.0   1.0 2.0     0.0   2.0   141.0 127.0                       268.0 69 5 189   1 2     0   2   141 127                 268
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
846873 846873 CO     school 806120 2690   PUEBLO CITY 60 80612001067 9188 W H HEATON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 47 6 188   3 2     0   1   119 128                       247 47 6 188   3 2     0   1   119 128                 247
1135196 1135196 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000079 8078 SOUTH MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 21.0 57.0 187.0   3.0 12.0     2.0   12.0   142.0 152.0                       294.0 21 57 187   3 12     2   12   142 152                 294
1739710 1739710 CO     school 802910 130   Cherry Creek 5 80291000201 7158 Prairie Middle School   Regular School No Middle 06 08 2021   grade_7 97 130 187   2 24     3   44   243 244                       487 97 130 187   2 24     3   44   243 244                 487
1137285 1137285 CO     school 803360 880   DENVER COUNTY 1 80336000370 4656 KEPNER MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 6.0 7.0 186.0   3.0 5.0     0.0   1.0   117.0 91.0                       208.0 6 7 186   3 5     0   1   117 91                 208
1932969 1932969 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000074 6310 NORTH MIDDLE SCHOOL HEALTH SCIENCES AND TECHNOLOGY CAMPUS   Regular School No Middle 06 08 2019   grade_7 8 34 186   5 7     1   7   124 124                       248 8 34 186   5 7     1   7   124 124                 248
1800218 1800218 CO     school 807230 70   Westminster Public Schools 80723006458 7305 Iver C. Ranum Middle School   Regular School No Middle 06 08 2020   grade_7 15 3 185   2 5     2   6   118 100                       218 15 3 185   2 5     2   6   118 100                 218
1931895 1931895 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006458 7305 IVER C. RANUM MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 17 3 184   3 4     0   5   101 115                       216 17 3 184   3 4     0   5   101 115                 216
847888 847888 CO     school 804410 3120   GREELEY 6 80441000642 3880 HEATH MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 54 7 183   0 2     1   1   120 128                       248 54 7 183   0 2     1   1   120 128                 248
1895751 1895751 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000079 8078 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 16 67 183   4 13     7   10   163 137                       300 16 67 183   4 13     7   10   163 137                 300
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
720338 720338 CO     school 804410 3120   GREELEY 6 80441000645 4438 PRAIRIE HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 89 10 182   3 16     2   1   163 140                       303 89 10 182   3 16     2   1   163 140                 303
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
1810862 1810862 CO     school 806120 2690   Pueblo City 60 80612001067 9188 W H Heaton Middle School   Regular School No Middle 06 08 2020   grade_7 47 4 182   4 4     0   4   115 130                       245 47 4 182   4 4     0   4   115 130                 245
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
1905179 1905179 CO     school 806120 2690   PUEBLO CITY 60 80612001055 5048 PUEBLO ACADEMY OF ARTS   Regular School No Middle 06 08 2018   grade_7 60 6 180   0 2     0   5   132 121                       253 60 6 180   0 2     0   5   132 121                 253
1931366 1931366 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001187 6398 NORTHGLENN MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 69 6 180   1 5     0   7   141 127                       268 69 6 180   1 5     0   7   141 127                 268
1933056 1933056 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000079 8078 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 15 44 179   3 9     6   12   149 119                       268 15 44 179   3 9     6   12   149 119                 268
1133602 1133602 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001187 6398 NORTHGLENN MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 93.0 11.0 178.0   4.0 8.0     1.0   6.0   161.0 140.0                       301.0 93 11 178   4 8     1   6   161 140                 301
1801289 1801289 CO     school 802340 180   Adams-Arapahoe 28J 80234000073 6160 Mrachek Middle School   Regular School No Middle 06 08 2020   grade_7 55 70 178   1 14     7   25   177 173                       350 55 70 178   1 14     7   25   177 173                 350
1807217 1807217 CO     school 804800 1420   Jefferson County R-1 80480000691 108 Alameda International Junior/Senior High School   Regular School No High 07 12 2020   grade_7 33 1 178   1 14     0   6   124 109                       233 33 1 178   1 14     0   6   124 109                 233
719304 719304 CO     school 806120 2690   PUEBLO CITY 60 80612001067 9188 W H HEATON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 40 5 177   2 2     1   5   128 104                       232 40 5 177   2 2     1   5   128 104                 232
1933144 1933144 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000082 9396 AURORA WEST COLLEGE PREPARATORY ACADEMY   Regular School No High 06 12 2019   grade_7 16 31 177   0 23     0   3   134 116                       250 16 31 177   0 23     0   3   134 116                 250
1811894 1811894 CO     school 804410 3120   Greeley 6 80441000642 3880 Heath Middle School   Regular School No Middle 06 08 2020   grade_7 43 10 174   1 8     0   7   130 113                       243 43 10 174   1 8     0   7   130 113                 243
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
847904 847904 CO     school 804410 3120   GREELEY 6 80441000645 4438 PRAIRIE HEIGHTS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 60 6 171   3 15     0   1   128 128                       256 60 6 171   3 15     0   1   128 128                 256
1746132 1746132 CO     school 804800 1420   Jefferson County R-1 80480000691 108 Alameda International Junior/Senior High School   Regular School No High 07 12 2021   grade_7 26 4 171   3 10     1   7   119 103                       222 26 4 171   3 10     1   7   119 103                 222
1810785 1810785 CO     school 806120 2690   Pueblo City 60 80612001055 5048 Pueblo Academy of Arts   Regular School No Middle 06 08 2020   grade_7 56 5 171   0 2     0   4   114 124                       238 56 5 171   0 2     0   4   114 124                 238
708141 708141 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001179 4187 SILVER HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 133 14 168   2 22     0   11   178 172                       350 133 14 168   2 22     0   11   178 172                 350
709539 709539 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000054 464 AURORA HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 31 66 168   2 13     2   12   147 147                       294 31 66 168   2 13     2   12   147 147                 294
715539 715539 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000691 108 ALAMEDA INTERNATIONAL JUNIOR/SENIOR HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 20 3 167   2 3     1   1   104 93                       197 20 3 167   2 3     1   1   104 93                 197
1750779 1750779 CO     school 804410 3120   Greeley 6 80441000642 3880 Heath Middle School   Regular School No Middle 06 08 2021   grade_7 41 14 167   2 11     1   3   124 115                       239 41 14 167   2 11     1   3   124 115                 239
1801483 1801483 CO     school 802340 180   Adams-Arapahoe 28J 80234000082 9396 Aurora West College Preparatory Academy   Regular School No High 06 12 2020   grade_7 9 27 167   1 23     1   5   122 111                       233 9 27 167   1 23     1   5   122 111                 233
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
1906266 1906266 CO     school 804410 3120   GREELEY 6 80441000642 3880 HEATH MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 38 11 167   1 3     1   3   123 101                       224 38 11 167   1 3     1   3   123 101                 224
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
840044 840044 CO     school 803360 880   DENVER COUNTY 1 80336000363 8054 HENRY WORLD SCHOOL GRADES 6-8   Regular School No 2.0 06 08 2016   grade_7 21 12 166   3 14     0   4   104 116                       220 21 12 166   3 14     0   4   104 116                 220
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
708217 708217 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001187 6398 NORTHGLENN MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 76 2 164   1 6     0   6   157 98                       255 76 2 164   1 6     0   6   157 98                 255
1138277 1138277 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006578 3847 HOPE ONLINE LEARNING ACADEMY MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2015   grade_7 35.0 14.0 164.0   3.0 3.0     1.0   7.0   115.0 112.0                       227.0 35 14 164   3 3     1   7   115 112                 227
1141483 1141483 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000762 6474 O'CONNELL MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   grade_7 23.0 5.0 164.0   1.0 5.0     0.0   4.0   118.0 84.0                       202.0 23 5 164   1 5     0   4   118 84                 202

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