enrollments

Data source: Big Local News · About: Big Local

4,236 rows where grade = "grade_7" and state = "CO" sorted by native_hawaiian_pacific_islander_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
1744460 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
1801393 1801393 CO     school 802340 180   Adams-Arapahoe 28J 80234000079 8078 South Middle School   Regular School No Middle 06 08 2020   grade_7 9 59 155   2 4     10   12   129 122                       251 9 59 155   2 4     10   12   129 122                 251
841312 841312 CO     school 804530 980   HARRISON 2 80453000666 3522 FOX MEADOW MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 56 33 60   3 2     8   21   109 74                       183 56 33 60   3 2     8   21   109 74                 183
1139151 1139151 CO     school 804080 1000   FOUNTAIN 8 80408000561 1332 CARSON MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 104.0 36.0 62.0   3.0 9.0     8.0   13.0   132.0 103.0                       235.0 104 36 62   3 9     8   13   132 103                 235
837394 837394 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000073 6160 MRACHEK MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 66 75 127   3 12     7   12   170 132                       302 66 75 127   3 12     7   12   170 132                 302
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
1742671 1742671 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2021   grade_7 2 10 55   0 0     7   1   36 39                       75 2 10 55   0 0     7   1   36 39                 75
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
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
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
1899869 1899869 CO     school 804080 1000   FOUNTAIN 8 80408000563 3106 FOUNTAIN MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 163 22 103   3 3     7   40   161 180                       341 163 22 103   3 3     7   40   161 180                 341
1937131 1937131 CO     school 806480 990   WIDEFIELD 3 80648001120 4394 JANITELL JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2019   grade_7 135 29 87   2 5     7   36   163 138                       301 135 29 87   2 5     7   36   163 138                 301
709847 709847 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000079 8078 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 14 39 157   0 9     6   7   129 103                       232 14 39 157   0 9     6   7   129 103                 232
713930 713930 CO     school 804080 1000   FOUNTAIN 8 80408000561 1332 CARSON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 97 38 50   2 4     6   15   115 97                       212 97 38 50   2 4     6   15   115 97                 212
1740031 1740031 CO     school 802340 180   Adams-Arapahoe 28J 80234000054 464 Aurora Hills Middle School   Regular School No Middle 06 08 2021   grade_7 19 50 139   1 12     6   14   126 115                       241 19 50 139   1 12     6   14   126 115                 241
1742195 1742195 CO     school 803360 880   Denver County 1 80336006528 2209 DCIS at Montbello   Regular School No High 06 12 2021   grade_7 2 13 77   0 0     6   2   57 43                       100 2 13 77   0 0     6   2   57 43                 100
1899756 1899756 CO     school 806480 990   WIDEFIELD 3 80648001120 4394 JANITELL JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2018   grade_7 117 23 81   2 4     6   26   139 120                       259 117 23 81   2 4     6   26   139 120                 259
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
1935370 1935370 CO     school 803360 880   DENVER COUNTY 1 80336001276 5685 MCGLONE ACADEMY   Regular School No Elementary PK 08 2019   grade_7 0 11 48   1 0     6   1   40 27                       67 0 11 48   1 0     6   1   40 27                 67
709633 709633 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006644 2673 EDNA AND JOHN W. MOSLEY P-8   Regular School No Elementary PK 08 2017   grade_7 17 15 49   2 1     5   3   49 43                       92 17 15 49   2 1     5   3   49 43                 92
712288 712288 CO     school 803360 880   DENVER COUNTY 1 80336001933 6970 FLORIDA PITT-WALLER ECE-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 9 23 34   0 5     5   2   37 41                       78 9 23 34   0 5     5   2   37 41                 78
841511 841511 CO     school 806480 990   WIDEFIELD 3 80648001126 9294 WATSON JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2016   grade_7 119 19 76   0 4     5   25   106 142                       248 119 19 76   0 4     5   25   106 142                 248
841545 841545 CO     school 804080 1000   FOUNTAIN 8 80408000561 1332 CARSON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 92 43 57   2 3     5   25   101 126                       227 92 43 57   2 3     5   25   101 126                 227
1139177 1139177 CO     school 804080 1000   FOUNTAIN 8 80408000563 3106 FOUNTAIN MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 143.0 35.0 98.0   0.0 2.0     5.0   32.0   171.0 144.0                       315.0 143 35 98   0 2     5   32   171 144                 315
1740140 1740140 CO     school 802340 180   Adams-Arapahoe 28J 80234006644 2673 Edna and John W. Mosley P-8   Regular School No Elementary PK 08 2021   grade_7 12 17 54   1 0     5   3   54 38                       92 12 17 54   1 0     5   3   54 38                 92
1740250 1740250 CO     school 802340 180   Adams-Arapahoe 28J 80234000073 6160 Mrachek Middle School   Regular School No Middle 06 08 2021   grade_7 41 55 150   3 11     5   18   144 139                       283 41 55 150   3 11     5   18   144 139                 283
1740265 1740265 CO     school 802340 180   Adams-Arapahoe 28J 80234000074 6310 North Middle School Health Sciences and Technology Campus   Regular School No Middle 06 08 2021   grade_7 10 27 130   1 8     5   7   112 76                       188 10 27 130   1 8     5   7   112 76                 188
1744433 1744433 CO     school 804080 1000   Fountain 8 80408000561 1332 Carson Middle School   Regular School No Middle 06 08 2021   grade_7 110 32 50   1 2     5   24   116 108                       224 110 32 50   1 2     5   24   116 108                 224
1899806 1899806 CO     school 806480 990   WIDEFIELD 3 80648001126 9294 WATSON JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2018   grade_7 137 16 63   2 1     5   18   123 119                       242 137 16 63   2 1     5   18   123 119                 242
1932838 1932838 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006644 2673 EDNA AND JOHN W. MOSLEY P-8   Regular School No Elementary PK 08 2019   grade_7 10 15 57   2 2     5   1   42 50                       92 10 15 57   2 2     5   1   42 50                 92
1932954 1932954 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000073 6160 MRACHEK MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 40 72 162   1 19     5   20   172 147                       319 40 72 162   1 19     5   20   172 147                 319
1937219 1937219 CO     school 804080 1000   FOUNTAIN 8 80408000561 1332 CARSON MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 105 42 50   3 3     5   19   105 122                       227 105 42 50   3 3     5   19   105 122                 227
709063 709063 CO     school 802910 130   CHERRY CREEK 5 80291001672 2897 FALCON CREEK MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 184 23 56   1 28     4   12   159 149                       308 184 23 56   1 28     4   12   159 149                 308
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
713957 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
836793 836793 CO     school 802910 130   CHERRY CREEK 5 80291000197 4975 LAREDO MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 190 68 87   2 27     4   23   206 195                       401 190 68 87   2 27     4   23   206 195                 401
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
1139063 1139063 CO     school 806480 990   WIDEFIELD 3 80648001120 4394 JANITELL JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2015   grade_7 119.0 32.0 74.0   3.0 6.0     4.0   18.0   134.0 122.0                       256.0 119 32 74   3 6     4   18   134 122                 256
1140944 1140944 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000708 1976 CREIGHTON MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   grade_7 149.0 9.0 144.0   5.0 14.0     4.0   7.0   181.0 151.0                       332.0 149 9 144   5 14     4   7   181 151                 332
1740354 1740354 CO     school 802340 180   Adams-Arapahoe 28J 80234000079 8078 South Middle School   Regular School No Middle 06 08 2021   grade_7 17 29 155   3 6     4   7   108 113                       221 17 29 155   3 6     4   7   108 113                 221
1742639 1742639 CO     school 803360 880   Denver County 1 80336001406 5605 Dr. Martin Luther King Jr. Early College   Regular School No High 06 12 2021   grade_7 3 32 63   0 16     4   5   59 64                       123 3 32 63   0 16     4   5   59 64                 123
1744347 1744347 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2021   grade_7 106 15 63   1 3     4   24   112 104                       216 106 15 63   1 3     4   24   112 104                 216
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
1801082 1801082 CO     school 802340 180   Adams-Arapahoe 28J 80234000054 464 Aurora Hills Middle School   Regular School No Middle 06 08 2020   grade_7 16 61 154   4 7     4   18   147 117                       264 16 61 154   4 7     4   18   147 117                 264
1801304 1801304 CO     school 802340 180   Adams-Arapahoe 28J 80234000074 6310 North Middle School Health Sciences and Technology Campus   Regular School No Middle 06 08 2020   grade_7 9 30 157   0 5     4   5   113 97                       210 9 30 157   0 5     4   5   113 97                 210
1803861 1803861 CO     school 803360 880   Denver County 1 80336001933 6970 Florida Pitt-Waller ECE-8 School   Regular School No Elementary PK 08 2020   grade_7 3 32 50   0 5     4   5   44 55                       99 3 32 50   0 5     4   5   44 55                 99
1805413 1805413 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   grade_7 42 10 27   2 3     4   8   52 44                       96 42 10 27   2 3     4   8   52 44                 96
1805467 1805467 CO     school 806480 990   Widefield 3 80648001125 8178 Sproul Junior High School   Regular School No Middle 06 08 2020   grade_7 89 16 53   0 4     4   28   100 94                       194 89 16 53   0 4     4   28   100 94                 194
1805513 1805513 CO     school 804080 1000   Fountain 8 80408000561 1332 Carson Middle School   Regular School No Middle 06 08 2020   grade_7 118 32 56   3 2     4   23   121 117                       238 118 32 56   3 2     4   23   121 117                 238
1895650 1895650 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000073 6160 MRACHEK MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 48 55 141   1 13     4   17   136 143                       279 48 55 141   1 13     4   17   136 143                 279
1899665 1899665 CO     school 804530 980   HARRISON 2 80453001903 6162 MOUNTAIN VISTA COMMUNITY SCHOOL   Regular School No Elementary PK 08 2018   grade_7 21 15 55   1 2     4   6   61 43                       104 21 15 55   1 2     4   6   61 43                 104
1900547 1900547 CO     school 801920 1040   ACADEMY 20 80192001593 6140 MOUNTAIN RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 215 9 60   1 18     4   29   175 161                       336 215 9 60   1 18     4   29   175 161                 336
1932342 1932342 CO     school 802910 130   CHERRY CREEK 5 80291000197 4975 LAREDO MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 186 46 85   4 21     4   24   183 187                       370 186 46 85   4 21     4   24   183 187                 370
1935541 1935541 CO     school 803360 880   DENVER COUNTY 1 80336001933 6970 FLORIDA PITT-WALLER ECE-8 SCHOOL   Regular School No Elementary PK 08 2019   grade_7 11 19 37   2 6     4   3   39 43                       82 11 19 37   2 6     4   3   39 43                 82
1937487 1937487 CO     school 803060 1010   COLORADO SPRINGS 11 80306001683 4424 JENKINS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 229 17 60   2 6     4   14   170 162                       332 229 17 60   2 6     4   14   170 162                 332
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
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
713774 713774 CO     school 804530 980   HARRISON 2 80453000669 6686 PANORAMA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 25 34 61   1 12     3   6   71 71                       142 25 34 61   1 12     3   6   71 71                 142
713847 713847 CO     school 806480 990   WIDEFIELD 3 80648001120 4394 JANITELL JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2017   grade_7 111 31 66   2 0     3   24   138 99                       237 111 31 66   2 0     3   24   138 99                 237
714705 714705 CO     school 801920 1040   ACADEMY 20 80192001462 8851 TIMBERVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 258 13 58   2 8     3   23   189 176                       365 258 13 58   2 8     3   23   189 176                 365
836923 836923 CO     school 802910 130   CHERRY CREEK 5 80291000034 8848 THUNDER RIDGE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 268 35 77   2 16     3   36   209 228                       437 268 35 77   2 16     3   36   209 228                 437
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
839721 839721 CO     school 803360 880   DENVER COUNTY 1 80336001406 5605 MARTIN LUTHER KING JR. EARLY COLLEGE   Regular School No 4.0 06 12 2016   grade_7 9 32 87   0 3     3   4   74 64                       138 9 32 87   0 3     3   4   74 64                 138
841332 841332 CO     school 804530 980   HARRISON 2 80453001964 4379 JAMES IRWIN CHARTER MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2016   grade_7 51 18 63   1 8     3   5   76 73                       149 51 18 63   1 8     3   5   76 73                 149
841572 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
842598 842598 CO     school 803870 1110   FALCON 49 80387001799 7960 SKYVIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 229 32 79   1 10     3   19   195 178                       373 229 32 79   1 10     3   19   195 178                 373
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
1138971 1138971 CO     school 804530 980   HARRISON 2 80453001903 6162 MOUNTAIN VISTA COMMUNITY SCHOOL   Regular School No 1.0 PK 08 2015   grade_7 36.0 14.0 47.0   1.0 2.0     3.0   4.0   51.0 56.0                       107.0 36 14 47   1 2     3   4   51 56                 107
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
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
1740520 1740520 CO     school 802700 190   Byers 32J 80270006755 9033 Astravo Online Academy Middle School   Regular School Yes Middle 06 08 2021   grade_7 157 20 71   0 5     3   0   119 137                       256 157 20 71   0 5     3   0   119 137                 256
1744202 1744202 CO     school 804530 980   Harrison 2 80453001964 4379 James Irwin Charter Middle School   Regular School Yes Middle 06 08 2021   grade_7 37 8 84   0 2     3   17   74 77                       151 37 8 84   0 2     3   17   74 77                 151
1744334 1744334 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2021   grade_7 48 18 25   0 3     3   12   47 62                       109 48 18 25   0 3     3   12   47 62                 109
1744388 1744388 CO     school 806480 990   Widefield 3 80648001125 8178 Sproul Junior High School   Regular School No Middle 06 08 2021   grade_7 94 14 70   1 4     3   19   105 100                       205 94 14 70   1 4     3   19   105 100                 205
1745147 1745147 CO     school 801920 1040   Academy 20 80192001593 6140 Mountain Ridge Middle School   Regular School No Middle 06 08 2021   grade_7 185 9 60   0 13     3   20   141 149                       290 185 9 60   0 13     3   20   141 149                 290
1751508 1751508 CO     school 800282 9170   Education reEnvisioned BOCES 80028206764 1501 Colorado Preparatory Academy Middle School   Regular School No Middle 06 08 2021   grade_7 214 15 123   2 2     3   34   212 181                       393 214 15 123   2 2     3   34   212 181                 393
1803216 1803216 CO     school 803360 880   Denver County 1 80336006528 2209 DCIS at Montbello   Regular School No High 06 12 2020   grade_7 2 12 83   0 0     3   2   58 44                       102 2 12 83   0 0     3   2   58 44                 102
1803690 1803690 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2020   grade_7 0 6 51   0 0     3   2   30 32                       62 0 6 51   0 0     3   2   30 32                 62
1804728 1804728 CO     school 803450 900   Douglas County Re 1 80345001747 6164 Mountain Ridge Middle School   Regular School No Middle 07 08 2020   grade_7 393 9 69   3 29     3   30   260 276                       536 393 9 69   3 29     3   30   260 276                 536
1805342 1805342 CO     school 804530 980   Harrison 2 80453000669 6686 Panorama Middle School   Regular School No Middle 06 08 2020   grade_7 39 43 125   1 7     3   27   131 114                       245 39 43 125   1 7     3   27   131 114                 245
1805426 1805426 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2020   grade_7 86 25 83   0 1     3   34   124 108                       232 86 25 83   0 1     3   34   124 108                 232
1805539 1805539 CO     school 804080 1000   Fountain 8 80408000563 3106 Fountain Middle School   Regular School No Middle 06 08 2020   grade_7 182 27 103   3 3     3   38   188 171                       359 182 27 103   3 3     3   38   188 171                 359
1805896 1805896 CO     school 803060 1010   Colorado Springs 11 80306000263 7523 Russell Middle School   Regular School No Middle 06 08 2020   grade_7 90 16 72   1 4     3   20   113 93                       206 90 16 72   1 4     3   20   113 93                 206
1808990 1808990 CO     school 803990 1550   Poudre R-1 80399001091 7161 Preston Middle School   Regular School No Middle 06 08 2020   grade_7 329 5 38   0 15     3   4   205 189                       394 329 5 38   0 15     3   4   205 189                 394
1809769 1809769 CO     school 804350 2000   Mesa County Valley 51 80435001656 3584 Grand Mesa Middle School   Regular School No Middle 06 08 2020   grade_7 131 2 72   2 2     3   14   115 111                       226 131 2 72   2 2     3   14   115 111                 226
1895236 1895236 CO     school 805310 140   LITTLETON 6 80531000876 2804 EUCLID MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 176 4 50   1 8     3   7   116 133                       249 176 4 50   1 8     3   7   116 133                 249
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
1898666 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
1899795 1899795 CO     school 806480 990   WIDEFIELD 3 80648001125 8178 SPROUL JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2018   grade_7 89 21 55   1 3     3   23   103 92                       195 89 21 55   1 3     3   23   103 92                 195
1901516 1901516 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000698 694 BELL MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 258 0 53   0 9     3   7   175 155                       330 258 0 53   0 9     3   7   175 155                 330
1931883 1931883 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001241 5388 M. SCOTT CARPENTER MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 14 2 138   0 6     3   3   77 89                       166 14 2 138   0 6     3   3   77 89                 166
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
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
1936985 1936985 CO     school 804530 980   HARRISON 2 80453000666 3522 FOX MEADOW MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 59 29 103   1 5     3   25   111 114                       225 59 29 103   1 5     3   25   111 114                 225
1937003 1937003 CO     school 804530 980   HARRISON 2 80453001964 4379 JAMES IRWIN CHARTER MIDDLE SCHOOL   Regular School Yes Middle 06 08 2019   grade_7 46 10 78   1 4     3   11   76 77                       153 46 10 78   1 4     3   11   76 77                 153
1937246 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
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
1939076 1939076 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000708 1976 CREIGHTON MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 125 10 143   4 13     3   18   163 153                       316 125 10 143   4 13     3   18   163 153                 316
708331 708331 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001194 9444 WESTLAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 256 4 98   0 20     2   10   196 194                       390 256 4 98   0 20     2   10   196 194                 390
708549 708549 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006362 7131 PRAIRIE VIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 118 2 120   0 13     2   7   123 139                       262 118 2 120   0 13     2   7   123 139                 262

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