Data source: Big Local News · About: Big Local

4,236 rows where grade = "grade_7" and state = "CO" sorted by native_american_alaskan_native_int descending

View and edit SQL

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
1941746 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309000833 1888 MONTEZUMA-CORTEZ MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 80 0 43   61 3     1   7   102 93                       195 80 0 43   61 3     1   7   102 93                 195
846004 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309000833 1888 CORTEZ MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 89 0 34   59 2     1   4   100 89                       189 89 0 34   59 2     1   4   100 89                 189
718435 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309000833 1888 CORTEZ MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 85 2 31   57 1     0   6   84 98                       182 85 2 31   57 1     0   6   84 98                 182
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
1748868 CO     school 803090 2035   Montezuma-Cortez RE-1 80309000833 1888 Montezuma-Cortez Middle School   Regular School No Middle 06 08 2021   grade_7 66 2 32   56 0     0   8   81 83                       164 66 2 32   56 0     0   8   81 83                 164
1904385 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309000833 1888 CORTEZ MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 78 1 35   55 0     1   2   89 83                       172 78 1 35   55 0     1   2   89 83                 172
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
1903003 CO     school 804770 1540   IGNACIO 11 JT 80477000688 4254 IGNACIO MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 12 0 22   25 1     0   3   38 25                       63 12 0 22   25 1     0   3   38 25                 63
844641 CO     school 804770 1540   IGNACIO 11 JT 80477000688 4254 IGNACIO MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 26 0 29   19 1     0   7   49 33                       82 26 0 29   19 1     0   7   49 33                 82
1940375 CO     school 804770 1540   IGNACIO 11 JT 80477000688 4254 IGNACIO MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 19 0 28   19 0     1   6   35 38                       73 19 0 28   19 0     1   6   35 38                 73
1741907 CO     school 803360 880   Denver County 1 80336006797 1010 American Indian Academy of Denver   Regular School Yes Middle 06 08 2021   grade_7 1 1 6   18 0     0   1   18 9                       27 1 1 6   18 0     0   1   18 9                 27
717058 CO     school 804770 1540   IGNACIO 11 JT 80477000688 4254 IGNACIO MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 17 0 23   17 2     0   4   34 29                       63 17 0 23   17 2     0   4   34 29                 63
710019 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000040 6657 PAGOSA SPRINGS MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_7 108 1 11   15 1     1   4   74 67                       141 108 1 11   15 1     1   4   74 67                 141
1142223 CO     school 804770 1540   IGNACIO 11 JT 80477000688 4254 IGNACIO MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 24.0 0.0 18.0   15.0 0.0     0.0   3.0   32.0 28.0                       60.0 24 0 18   15 0     0   3   32 28                 60
1747573 CO     school 804770 1540   Ignacio 11 JT 80477000688 4254 Ignacio Middle School   Regular School No Middle 06 08 2021   grade_7 11 0 29   15 1     0   1   33 24                       57 11 0 29   15 1     0   1   33 24                 57
1801569 CO     school 802190 220   Archuleta County 50 Jt 80219000040 6657 Pagosa Springs Middle School   Regular School No Middle 05 08 2020   grade_7 77 0 59   14 0     0   5   77 78                       155 77 0 59   14 0     0   5   77 78                 155
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
1747536 CO     school 803480 1520   Durango 9-R 80348000456 7994 Escalante Middle School   Regular School No Middle 06 08 2021   grade_7 93 3 50   12 2     0   7   90 77                       167 93 3 50   12 2     0   7   90 77                 167
1902967 CO     school 803480 1520   DURANGO 9-R 80348000456 7994 ESCALANTE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 111 2 43   12 2     0   5   93 82                       175 111 2 43   12 2     0   5   93 82                 175
1933237 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000040 6657 PAGOSA SPRINGS MIDDLE SCHOOL   Regular School No Middle 05 08 2019   grade_7 68 1 54   12 0     0   4   78 61                       139 68 1 54   12 0     0   4   78 61                 139
837662 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000040 6657 PAGOSA SPRINGS MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_7 92 1 7   11 2     0   4   51 66                       117 92 1 7   11 2     0   4   51 66                 117
1747508 CO     school 803480 1520   Durango 9-R 80348000452 5888 Miller Middle School   Regular School No Middle 06 08 2021   grade_7 110 1 32   11 0     0   10   92 72                       164 110 1 32   11 0     0   10   92 72                 164
1808687 CO     school 804770 1540   Ignacio 11 JT 80477000688 4254 Ignacio Middle School   Regular School No Middle 06 08 2020   grade_7 17 1 22   10 0     0   5   30 25                       55 17 1 22   10 0     0   5   30 25                 55
717022 CO     school 803480 1520   DURANGO 9-R 80348000456 7994 ESCALANTE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 92 0 34   9 1     0   6   65 77                       142 92 0 34   9 1     0   6   65 77                 142
843345 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000708 1976 CREIGHTON MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_7 178 8 162   9 8     1   15   200 181                       381 178 8 162   9 8     1   15   200 181                 381
1808651 CO     school 803480 1520   Durango 9-R 80348000456 7994 Escalante Middle School   Regular School No Middle 06 08 2020   grade_7 120 0 43   9 1     0   10   78 105                       183 120 0 43   9 1     0   10   78 105                 183
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 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
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
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
1740537 CO     school 802190 220   Archuleta County 50 Jt 80219000040 6657 Pagosa Springs Middle School   Regular School No Middle 05 08 2021   grade_7 53 1 48   8 3     0   7   63 57                       120 53 1 48   8 3     0   7   63 57                 120
1808667 CO     school 802400 1530   Bayfield 10 Jt-R 80240000089 636 Bayfield Middle School   Regular School No Middle 06 08 2020   grade_7 97 0 20   8 2     0   5   68 64                       132 97 0 20   8 2     0   5   68 64                 132
1937182 CO     school 806480 990   WIDEFIELD 3 80648001126 9294 WATSON JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2019   grade_7 104 31 72   8 3     2   28   128 120                       248 104 31 72   8 3     2   28   128 120                 248
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
1142187 CO     school 803480 1520   DURANGO 9-R 80348000456 7994 ESCALANTE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 116.0 1.0 26.0   7.0 2.0     0.0   7.0   85.0 74.0                       159.0 116 1 26   7 2     0   7   85 74                 159
1808623 CO     school 803480 1520   Durango 9-R 80348000452 5888 Miller Middle School   Regular School No Middle 06 08 2020   grade_7 133 0 33   7 0     0   6   92 87                       179 133 0 33   7 0     0   6   92 87                 179
1901457 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000691 108 ALAMEDA INTERNATIONAL JUNIOR/SENIOR HIGH SCHOOL   Regular School No High 07 12 2018   grade_7 27 2 162   7 9     0   4   116 95                       211 27 2 162   7 9     0   4   116 95                 211
716994 CO     school 803480 1520   DURANGO 9-R 80348000452 5888 MILLER MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 113 1 23   6 2     0   4   68 81                       149 113 1 23   6 2     0   4   68 81                 149
840795 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001747 6164 MOUNTAIN RIDGE MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_7 472 5 63   6 25     0   28   297 302                       599 472 5 63   6 25     0   28   297 302                 599
843619 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000739 4422 JEFFERSON JUNIOR/SENIOR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 25 5 101   6 1     0   1   77 62                       139 25 5 101   6 1     0   1   77 62                 139
844577 CO     school 803480 1520   DURANGO 9-R 80348000452 5888 MILLER MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 114 1 35   6 1     0   5   82 80                       162 114 1 35   6 1     0   5   82 80                 162
1133402 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001620 1480 CENTURY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 231.0 9.0 106.0   6.0 14.0     1.0   5.0   187.0 185.0                       372.0 231 9 106   6 14     1   5   187 185                 372
1747552 CO     school 802400 1530   Bayfield 10 Jt-R 80240000089 636 Bayfield Middle School   Regular School No Middle 06 08 2021   grade_7 70 0 23   6 0     1   4   59 45                       104 70 0 23   6 0     1   4   59 45                 104
1748957 CO     school 805460 2070   Mancos Re-6 80546001287 5450 Mancos Middle School   Regular School No Middle 06 08 2021   grade_7 29 0 8   6 0     0   4   19 28                       47 29 0 8   6 0     0   4   19 28                 47
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
1809311 CO     school 805400 1560   Thompson R2-J 80540001286 9228 Walt Clark Middle School   Regular School No Middle 06 08 2020   grade_7 149 1 17   6 0     0   3   93 83                       176 149 1 17   6 0     0   3   93 83                 176
1898666 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006371 267 MESA MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 290 3 65   6 8     3   15   194 196                       390 290 3 65   6 8     3   15   194 196                 390
1901948 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000739 4422 JEFFERSON JUNIOR/SENIOR HIGH SCHOOL   Regular School No High 07 12 2018   grade_7 13 7 98   6 0     0   3   54 73                       127 13 7 98   6 0     0   3   54 73                 127
1938873 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000691 108 ALAMEDA INTERNATIONAL JUNIOR/SENIOR HIGH SCHOOL   Regular School No High 07 12 2019   grade_7 33 2 151   6 7     0   7   106 100                       206 33 2 151   6 7     0   7   106 100                 206
1938883 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006489 109 ARVADA K-8   Regular School No Elementary KG 08 2019   grade_7 50 2 58   6 3     1   6   77 49                       126 50 2 58   6 3     1   6   77 49                 126
713166 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001747 6164 MOUNTAIN RIDGE MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 465 4 59   5 26     0   32   306 285                       591 465 4 59   5 26     0   32   306 285                 591
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
719233 CO     school 806120 2690   PUEBLO CITY 60 80612001055 5048 PUEBLO ACADEMY OF ARTS   Regular School No Middle 06 08 2017   grade_7 61 5 151   5 2     0   3   124 103                       227 61 5 151   5 2     0   3   124 103                 227
836424 CO     school   100   ALAMOSA RE-11J   114 ORTEGA MIDDLE SCHOOL             2016   grade_7 44 2 106   5 2     0   0   76 83                       159 44 2 106   5 2     0   0   76 83                 159
836764 CO     school 802910 130   CHERRY CREEK 5 80291001328 4100 HORIZON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 131 59 78   5 16     0   32   174 147                       321 131 59 78   5 16     0   32   174 147                 321
840831 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000443 6772 SAGEWOOD MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 215 2 55   5 7     1   22   164 143                       307 215 2 55   5 7     1   22   164 143                 307
841572 CO     school 804080 1000   FOUNTAIN 8 80408000563 3106 FOUNTAIN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 150 28 70   5 7     3   27   151 139                       290 150 28 70   5 7     3   27   151 139                 290
845510 CO     school 806690 1828   VALLEY RE-1 80669001154 8256 STERLING MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 101 0 48   5 0     0   4   93 65                       158 101 0 48   5 0     0   4   93 65                 158
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
1139566 CO     school 803060 1010   COLORADO SPRINGS 11 80306006421 8457 JACK SWIGERT AEROSPACE ACADEMY   Regular School No 2.0 06 08 2015   grade_7 32.0 28.0 78.0   5.0 3.0     2.0   11.0   89.0 70.0                       159.0 32 28 78   5 3     2   11   89 70                 159
1140203 CO     school 803870 1110   FALCON 49 80387001799 7960 SKYVIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 220.0 37.0 92.0   5.0 22.0     2.0   23.0   221.0 180.0                       401.0 220 37 92   5 22     2   23   221 180                 401
1140944 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000708 1976 CREIGHTON MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   grade_7 149.0 9.0 144.0   5.0 14.0     4.0   7.0   181.0 151.0                       332.0 149 9 144   5 14     4   7   181 151                 332
1142159 CO     school 803480 1520   DURANGO 9-R 80348000452 5888 MILLER MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 116.0 0.0 19.0   5.0 0.0     0.0   2.0   70.0 72.0                       142.0 116 0 19   5 0     0   2   70 72                 142
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
1739542 CO     school 802910 130   Cherry Creek 5 80291001672 2897 Falcon Creek Middle School   Regular School No Middle 06 08 2021   grade_7 160 27 58   5 25     1   27   153 150                       303 160 27 58   5 25     1   27   153 150                 303
1739546 CO     school 802910 130   Cherry Creek 5 80291006367 3030 Fox Ridge Middle School   Regular School No Middle 06 08 2021   grade_7 235 16 57   5 33     1   32   201 178                       379 235 16 57   5 33     1   32   201 178                 379
1739631 CO     school 802910 130   Cherry Creek 5 80291000197 4975 Laredo Middle School   Regular School No Middle 06 08 2021   grade_7 129 62 97   5 25     0   29   177 170                       347 129 62 97   5 25     0   29   177 170                 347
1744460 CO     school 804080 1000   Fountain 8 80408000563 3106 Fountain Middle School   Regular School No Middle 06 08 2021   grade_7 183 31 86   5 7     10   47   187 182                       369 183 31 86   5 7     10   47   187 182                 369
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
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
1803630 CO     school 803360 880   Denver County 1 80336006490 5255 Lake Middle School   Regular School No Middle 06 08 2020   grade_7 9 19 78   5 1     0   3   56 59                       115 9 19 78   5 1     0   3   56 59                 115
1804776 CO     school 803450 900   Douglas County Re 1 80345001582 6773 Sierra Middle School   Regular School No Middle 07 08 2020   grade_7 309 8 76   5 16     1   22   226 211                       437 309 8 76   5 16     1   22   226 211                 437
1804846 CO     school 803450 900   Douglas County Re 1 80345001528 7245 Ranch View Middle School   Regular School No Middle 07 08 2020   grade_7 326 2 44   5 8     0   10   207 188                       395 326 2 44   5 8     0   10   207 188                 395
1894787 CO     school 802910 130   CHERRY CREEK 5 80291001711 18 LIBERTY MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 227 37 56   5 43     1   28   219 178                       397 227 37 56   5 43     1   28   219 178                 397
1895001 CO     school 802910 130   CHERRY CREEK 5 80291001328 4100 HORIZON MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 135 56 87   5 12     2   22   181 138                       319 135 56 87   5 12     2   22   181 138                 319
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
1895926 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000040 6657 PAGOSA SPRINGS MIDDLE SCHOOL   Regular School No Middle 05 08 2018   grade_7 32 1 86   5 0     0   2   65 61                       126 32 1 86   5 0     0   2   65 61                 126
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
1932743 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000054 464 AURORA HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 26 59 161   5 9     2   14   135 141                       276 26 59 161   5 9     2   14   135 141                 276
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
1934850 CO     school 803360 880   DENVER COUNTY 1 80336001917 2183 DENVER CENTER FOR INTERNATIONAL STUDIES   Regular School No High 06 12 2019   grade_7 19 8 82   5 6     0   2   54 68                       122 19 8 82   5 6     0   2   54 68                 122
1935310 CO     school 803360 880   DENVER COUNTY 1 80336006490 5255 LAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 9 15 74   5 2     0   2   60 47                       107 9 15 74   5 2     0   2   60 47                 107
1935401 CO     school 803360 880   DENVER COUNTY 1 80336006562 5897 MCAULIFFE INTERNATIONAL SCHOOL   Regular School No Middle 06 08 2019   grade_7 327 51 58   5 10     1   43   268 227                       495 327 51 58   5 10     1   43   268 227                 495
1937246 CO     school 804080 1000   FOUNTAIN 8 80408000563 3106 FOUNTAIN MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 175 31 96   5 2     3   33   179 166                       345 175 31 96   5 2     3   33   179 166                 345
1940580 CO     school 803990 1550   POUDRE R-1 80399000536 5168 LINCOLN MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 91 3 102   5 2     0   6   108 101                       209 91 3 102   5 2     0   6   108 101                 209
1941755 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309006622 2036 CHILDREN'S KIVA MONTESSORI SCHOOL   Regular School Yes Elementary KG 08 2019   grade_7 2 0 0   5 0     0   0   5 2                       7 2 0 0   5 0     0   0   5 2                 7
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
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
708727 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001244 7812 SHAW HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 54 6 142   4 21     0   3   105 125                       230 54 6 142   4 21     0   3   105 125                 230
708854 CO     school 803780 120   ENGLEWOOD 1 80378006331 2752 ENGLEWOOD MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 70 3 75   4 2     0   3   87 70                       157 70 3 75   4 2     0   3   87 70                 157
709589 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001322 1800 COLUMBIA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 71 46 117   4 10     1   21   150 120                       270 71 46 117   4 10     1   21   150 120                 270
711624 CO     school 803360 880   DENVER COUNTY 1 80336001917 2183 DENVER CENTER FOR INTERNATIONAL STUDIES   Regular School No Other 06 12 2017   grade_7 38 5 64   4 2     0   6   47 72                       119 38 5 64   4 2     0   6   47 72                 119
712633 CO     school 803360 880   DENVER COUNTY 1 80336006551 9693 WEST EARLY COLLEGE   Regular School No Other 06 12 2017   grade_7 5 14 100   4 0     0   1   70 54                       124 5 14 100   4 0     0   1   70 54                 124
712754 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006371 267 MESA MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 346 5 62   4 4     0   19   228 212                       440 346 5 62   4 4     0   19   228 212                 440
712893 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006219 2012 CRESTHILL MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 310 5 71   4 24     0   19   228 205                       433 310 5 71   4 24     0   19   228 205                 433
713896 CO     school 806480 990   WIDEFIELD 3 80648001126 9294 WATSON JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2017   grade_7 126 15 56   4 5     2   23   119 112                       231 126 15 56   4 5     2   23   119 112                 231
713957 CO     school 804080 1000   FOUNTAIN 8 80408000563 3106 FOUNTAIN MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 142 28 91   4 2     4   27   157 141                       298 142 28 91   4 2     4   27   157 141                 298
714309 CO     school 803060 1010   COLORADO SPRINGS 11 80306000234 7556 SABIN MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 131 23 79   4 7     0   19   139 124                       263 131 23 79   4 7     0   19   139 124                 263
715000 CO     school 803870 1110   FALCON 49 80387001799 7960 SKYVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 238 21 88   4 17     2   37   211 196                       407 238 21 88   4 17     2   37   211 196                 407
720995 CO     school 800282 9170   COLORADO DIGITAL BOCES 80028206600 1550 COLORADO PREP ACADEMY   Regular School No Other KG 12 2017   grade_7 108 6 18   4 1     0   11   77 71                       148 108 6 18   4 1     0   11   77 71                 148

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