enrollments

Data source: Big Local News · About: Big Local

586 rows where grade = "grade_7", state = "CO" and year = 2016

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 586 ✖

grade ✖

  • grade_7 · 586 ✖
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
835492 835492 CO     school   10   MAPLETON 1   187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS             2016   grade_7 32 2 85   1 2     0   3   50 75                       125 32 2 85   1 2     0   3   50 75                 125
835510 835510 CO     school   10   MAPLETON 1   263 GLOBAL LEADERSHIP ACADEMY             2016   grade_7 7 1 46   0 0     0   0   30 24                       54 7 1 46   0 0     0   0   30 24                 54
835527 835527 CO     school   10   MAPLETON 1   501 MONTEREY COMMUNITY SCHOOL             2016   grade_7 6 1 44   0 0     0   1   24 28                       52 6 1 44   0 0     0   1   24 28                 52
835538 835538 CO     school   10   MAPLETON 1   502 MEADOW COMMUNITY SCHOOL             2016   grade_7 9 2 40   2 0     0   0   23 30                       53 9 2 40   2 0     0   0   23 30                 53
835552 835552 CO     school   10   MAPLETON 1   503 YORK INTERNATIONAL             2016   grade_7 7 0 42   0 2     0   3   29 25                       54 7 0 42   0 2     0   3   29 25                 54
835572 835572 CO     school   10   MAPLETON 1   505 ACHIEVE ACADEMY             2016   grade_7 8 0 46   0 1     0   1   28 28                       56 8 0 46   0 1     0   1   28 28                 56
835601 835601 CO     school   10   MAPLETON 1   509 CLAYTON PARTNERSHIP SCHOOL             2016   grade_7 12 1 38   0 5     0   4   32 28                       60 12 1 38   0 5     0   4   32 28                 60
835614 835614 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No 4.0 KG 12 2016   grade_7 171 9 48   2 5     0   14   124 125                       249 171 9 48   2 5     0   14   124 125                 249
835627 835627 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No 1.0 KG 08 2016   grade_7 4 0 54   1 0     0   1   21 39                       60 4 0 54   1 0     0   1   21 39                 60
835640 835640 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   57 ROCKY TOP MIDDLE SCHOOL             2016   grade_7 310 3 75   2 30     0   11   226 205                       431 310 3 75   2 30     0   11   226 205                 431
835657 835657 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   210 VANTAGE POINT             2016   grade_7 4 1 3   0 0     0   1   8 1                       9 4 1 3   0 0     0   1   8 1                 9
835679 835679 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001620 1480 CENTURY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 225 14 93   2 13     0   4   173 178                       351 225 14 93   2 13     0   4   173 178                 351
835688 835688 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690000728 1519 STARGATE CHARTER SCHOOL   Regular School Yes 4.0 KG 09 2016   grade_7 57 0 7   0 17     0   2   40 43                       83 57 0 7   0 17     0   2   40 43                 83
835784 835784 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006503 3439 GLOBAL VILLAGE ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_7 14 1 23   1 4     0   0   20 23                       43 14 1 23   1 4     0   0   20 23                 43
835807 835807 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001178 4172 HULSTROM OPTIONS K-8 SCHOOL   Regular School No 1.0 KG 08 2016   grade_7 63 1 13   0 7     1   3   43 45                       88 63 1 13   0 7     1   3   43 45                 88
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
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
835864 835864 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001186 6342 SHADOW RIDGE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 169 10 123   0 16     0   5   161 162                       323 169 10 123   0 16     0   5   161 162                 323
835882 835882 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001187 6398 NORTHGLENN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 86 14 162   4 13     0   3   151 131                       282 86 14 162   4 13     0   3   151 131                 282
835897 835897 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006507 6802 PROSPECT RIDGE ACADEMY   Regular School Yes 4.0 KG 10 2016   grade_7 87 2 4   1 13     0   5   55 57                       112 87 2 4   1 13     0   5   55 57                 112
835947 835947 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006468 8275 STEM LAB   Regular School No 1.0 KG 08 2016   grade_7 45 1 9   0 1     0   1   32 25                       57 45 1 9   0 1     0   1   32 25                 57
835957 835957 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006561 8310 STEM LAUNCH   Regular School No 1.0 KG 08 2016   grade_7 32 1 118   0 5     0   0   81 75                       156 32 1 118   0 5     0   0   81 75                 156
835985 835985 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006417 9431 WESTGATE CHARTER   Regular School Yes 4.0 KG 12 2016   grade_7 41 0 7   0 4     0   1   26 27                       53 41 0 7   0 4     0   1   26 27                 53
835992 835992 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001194 9444 WESTLAKE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 260 1 82   1 21     0   8   190 183                       373 260 1 82   1 21     0   8   190 183                 373
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
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
836090 836090 CO     school   40   SCHOOL DISTRICT 27J   700 BELLE CREEK CHARTER SCHOOL             2016   grade_7 30 2 42   1 4     0   0   37 42                       79 30 2 42   1 4     0   0   37 42                 79
836119 836119 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001729 1052 BROMLEY EAST CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2016   grade_7 75 0 30   0 1     1   1   58 50                       108 75 0 30   0 1     1   1   58 50                 108
836140 836140 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006465 2945 FOUNDATIONS ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_7 45 2 21   1 1     1   0   37 34                       71 45 2 21   1 1     1   0   37 34                 71
836160 836160 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006325 4950 LANDMARK ACADEMY AT REUNION   Regular School Yes 1.0 KG 08 2016   grade_7 42 4 25   0 1     0   5   42 35                       77 42 4 25   0 1     0   5   42 35                 77
836191 836191 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001377 6638 OVERLAND TRAIL MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 85 4 114   2 2     0   8   115 100                       215 85 4 114   2 2     0   8   115 100                 215
836195 836195 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006420 6702 OTHO E STUART MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 99 7 116   1 17     0   14   131 123                       254 99 7 116   1 17     0   14   131 123                 254
836204 836204 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006362 7131 PRAIRIE VIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 128 5 97   3 19     1   7   129 131                       260 128 5 97   3 19     1   7   129 131                 260
836251 836251 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000152 9230 VIKAN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 65 1 123   4 0     0   4   109 88                       197 65 1 123   4 0     0   4   109 88                 197
836273 836273 CO     school   50   BENNETT 29J   774 BENNETT MIDDLE SCHOOL             2016   grade_7 69 0 17   0 0     0   2   48 40                       88 69 0 17   0 0     0   2   48 40                 88
836293 836293 CO     school 806750 60   STRASBURG 31J 80675001160 8332 HEMPHILL MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 60 1 16   0 0     0   0   49 28                       77 60 1 16   0 0     0   0   49 28                 77
836343 836343 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006567 4334 COLORADO STEM ACADEMY   Regular School No 1.0 03 08 2016   grade_7 20 1 21   0 0     0   0   26 16                       42 20 1 21   0 0     0   0   26 16                 42
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
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
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
836424 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
836442 836442 CO     school   100   ALAMOSA RE-11J   368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE             2016   grade_7 2 0 2   0 0     0   0   2 2                       4 2 0 2   0 0     0   0   2 2                 4
836458 836458 CO     school 806420 110   SANGRE DE CRISTO RE-22J 80642001116 7630 SANGRE DE CRISTO UNDIVIDED HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_7 9 1 9   1 0     0   1   11 10                       21 9 1 9   1 0     0   1   11 10                 21
836497 836497 CO     school 803780 120   ENGLEWOOD 1 80378001772 2750 ENGLEWOOD LEADERSHIP ACADEMY   Regular School No 2.0 06 09 2016   grade_7 27 0 5   0 2     0   1   15 20                       35 27 0 5   0 2     0   1   15 20                 35
836500 836500 CO     school 803780 120   ENGLEWOOD 1 80378006331 2752 ENGLEWOOD MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_7 74 2 76   0 0     0   5   76 81                       157 74 2 76   0 0     0   5   76 81                 157
836521 836521 CO     school 806540 123   SHERIDAN 2 80654001135 7837 FORT LOGAN NORTHGATE   Regular School No 1.0 03 08 2016   grade_7 14 5 76   2 2     0   2   56 45                       101 14 5 76   2 2     0   2   56 45                 101
836545 836545 CO     school   130   CHERRY CREEK 5   18 LIBERTY MIDDLE SCHOOL             2016   grade_7 208 27 58   1 52     1   24   173 198                       371 208 27 58   1 52     1   24   173 198                 371
836549 836549 CO     school   130   CHERRY CREEK 5   141 SKY VISTA MIDDLE SCHOOL             2016   grade_7 163 31 59   0 22     1   14   143 147                       290 163 31 59   0 22     1   14   143 147                 290
836610 836610 CO     school 802910 130   CHERRY CREEK 5 80291000763 1510 CHALLENGE SCHOOL   Regular School No 1.0 PK 08 2016   grade_7 34 6 7   0 20     1   7   41 34                       75 34 6 7   0 20     1   7   41 34                 75
836620 836620 CO     school 802910 130   CHERRY CREEK 5 80291000185 1566 CAMPUS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 305 14 65   1 62     0   22   233 236                       469 305 14 65   1 62     0   22   233 236                 469
836624 836624 CO     school 802910 130   CHERRY CREEK 5 80291000207 1568 WEST MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 281 7 55   3 29     0   18   183 210                       393 281 7 55   3 29     0   18   183 210                 393
836638 836638 CO     school 802910 130   CHERRY CREEK 5 80291001152 1571 CHERRY CREEK CHARTER ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_7 46 6 2   1 19     0   4   40 38                       78 46 6 2   1 19     0   4   40 38                 78
836713 836713 CO     school 802910 130   CHERRY CREEK 5 80291001672 2897 FALCON CREEK MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 190 26 56   0 26     0   17   161 154                       315 190 26 56   0 26     0   17   161 154                 315
836717 836717 CO     school 802910 130   CHERRY CREEK 5 80291006367 3030 FOX RIDGE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 299 28 54   0 32     0   25   222 216                       438 299 28 54   0 32     0   25   222 216                 438
836764 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
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
836829 836829 CO     school 802910 130   CHERRY CREEK 5 80291006563 6367 OPTIONS SCHOOL   Alternative Education School No 4.0 KG 12 2016   grade_7 46 0 8   0 1     0   3   28 30                       58 46 0 8   0 1     0   3   28 30                 58
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
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
836991 836991 CO     school 805310 140   LITTLETON 6 80531000876 2804 EUCLID MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 160 1 54   1 4     0   8   115 113                       228 160 1 54   1 4     0   8   115 113                 228
837002 837002 CO     school 805310 140   LITTLETON 6 80531000879 3472 GODDARD MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 156 3 95   2 7     0   10   138 135                       273 156 3 95   2 7     0   10   138 135                 273
837019 837019 CO     school 805310 140   LITTLETON 6 80531000885 4316 NEWTON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 152 3 21   1 14     0   3   102 92                       194 152 3 21   1 14     0   3   102 92                 194
837023 837023 CO     school 805310 140   LITTLETON 6 80531001351 4447 JOHN WESLEY POWELL MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 273 5 33   1 7     0   13   169 163                       332 273 5 33   1 7     0   13   169 163                 332
837037 837037 CO     school 805310 140   LITTLETON 6 80531001515 5229 LITTLETON ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_7 44 1 1   0 5     0   2   20 33                       53 44 1 1   0 5     0   2   20 33                 53
837047 837047 CO     school 805310 140   LITTLETON 6 80531001626 5233 LITTLETON PREP CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2016   grade_7 41 1 16   0 2     0   0   25 35                       60 41 1 16   0 2     0   0   25 35                 60
837126 837126 CO     school 803270 170   DEER TRAIL 26J 80327000288 2140 DEER TRAIL JUNIOR-SENIOR HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_7 10 0 3   0 0     0   0   7 6                       13 10 0 3   0 0     0   0   7 6                 13
837136 837136 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2016   grade_7 0 1 0   0 0     0   0   0 1                       1 0 1 0   0 0     0   0   0 1                 1
837148 837148 CO     school   180   ADAMS-ARAPAHOE 28J   213 AXL ACADEMY             2016   grade_7 5 16 17   1 1     0   1   19 22                       41 5 16 17   1 1     0   1   19 22                 41
837180 837180 CO     school   180   ADAMS-ARAPAHOE 28J   458 AURORA ACADEMY CHARTER SCHOOL             2016   grade_7 13 13 24   0 1     0   3   28 26                       54 13 13 24   0 1     0   3   28 26                 54
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
837194 837194 CO     school   180   ADAMS-ARAPAHOE 28J   465 AURORA FRONTIER K-8             2016   grade_7 32 12 21   0 10     0   8   47 36                       83 32 12 21   0 10     0   8   47 36                 83
837205 837205 CO     school   180   ADAMS-ARAPAHOE 28J   914 BOSTON K-8 SCHOOL             2016   grade_7 0 5 18   0 9     1   0   17 16                       33 0 5 18   0 9     1   0   17 16                 33
837228 837228 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000057 1720 CLYDE MILLER K-8   Regular School No 1.0 PK 08 2016   grade_7 11 13 39   1 0     0   6   36 34                       70 11 13 39   1 0     0   6   36 34                 70
837234 837234 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001322 1800 COLUMBIA MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 85 40 126   2 15     0   6   145 129                       274 85 40 126   2 15     0   6   145 129                 274
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
837278 837278 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006644 2673 EDNA AND JOHN W. MOSLEY P-8   Regular School No 1.0 PK 08 2016   grade_7 12 7 39   0 2     1   3   38 26                       64 12 7 39   0 2     1   3   38 26                 64
837311 837311 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes 1.0 KG 08 2016   grade_7 14 21 53   1 2     0   5   47 49                       96 14 21 53   1 2     0   5   47 49                 96
837370 837370 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes 4.0 KG 12 2016   grade_7 12 29 32   1 3     0   0   39 38                       77 12 29 32   1 3     0   0   39 38                 77
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
837403 837403 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001881 6189 MURPHY CREEK K-8 SCHOOL   Regular School No 1.0 PK 08 2016   grade_7 26 9 28   0 4     0   12   38 41                       79 26 9 28   0 4     0   12   38 41                 79
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
837421 837421 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001789 6546 OPTIONS SCHOOL   Regular School No 4.0 KG 12 2016   grade_7 53 2 12   0 0     0   3   40 30                       70 53 2 12   0 0     0   3   40 30                 70
837456 837456 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001674 7232 AURORA QUEST K-8   Regular School No 1.0 KG 08 2016   grade_7 36 9 20   0 13     1   8   46 41                       87 36 9 20   0 13     1   8   46 41                 87
837490 837490 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000079 8078 SOUTH MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 20 54 162   2 4     0   5   127 120                       247 20 54 162   2 4     0   5   127 120                 247
837511 837511 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006322 9056 VANGUARD CLASSICAL SCHOOL - WEST   Regular School Yes 1.0 KG 08 2016   grade_7 6 6 40   0 0     0   3   25 30                       55 6 6 40   0 0     0   3   25 30                 55
837537 837537 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006483 9083 VISTA PEAK P-8 EXPLORATORY   Regular School No 1.0 PK 08 2016   grade_7 38 5 46   1 2     1   7   50 50                       100 38 5 46   1 2     1   7   50 50                 100
837563 837563 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes 4.0 KG 11 2016   grade_7 23 23 24   1 0     0   2   32 41                       73 23 23 24   1 0     0   2   32 41                 73
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
837604 837604 CO     school 802700 190   BYERS 32J 80270000164 1176 BYERS JUNIOR-SENIOR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 32 0 5   0 0     0   1   18 20                       38 32 0 5   0 0     0   1   18 20                 38
837622 837622 CO     school 802700 190   BYERS 32J 80270006605 2356 ELEVATE ACADEMY   Regular School Yes 4.0 KG 12 2016   grade_7 34 6 73   2 0     1   0   64 52                       116 34 6 73   2 0     1   0   64 52                 116
837636 837636 CO     school 802700 190   BYERS 32J 80270006548 3362 GREAT PLAINS ACADEMY   Regular School No 4.0 KG 12 2016   grade_7 10 0 3   0 0     0   0   4 9                       13 10 0 3   0 0     0   0   4 9                 13
837650 837650 CO     school 802700 190   BYERS 32J 80270006620 6263 COLORADO DIGITAL ACADEMY - MIDDLE   Regular School Yes 2.0 07 08 2016   grade_7 95 7 14   4 5     0   0   62 63                       125 95 7 14   4 5     0   0   62 63                 125
837662 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
837682 837682 CO     school 807110 230   WALSH RE-1 80711001216 9226 WALSH HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 5 0 4   0 0     0   0   4 5                       9 5 0 4   0 0     0   0   4 5                 9
837695 837695 CO     school 806090 240   PRITCHETT RE-3 80609001952 7176 PRITCHETT MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
837715 837715 CO     school 806630 250   SPRINGFIELD RE-4 80663001142 8168 SPRINGFIELD JUNIOR/SENIOR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 14 0 5   0 0     0   0   12 7                       19 14 0 5   0 0     0   0   12 7                 19
837725 837725 CO     school 806990 260   VILAS RE-5 80699001805 9085 V.I.L.A.S. ONLINE SCHOOL   Regular School No 1.0 KG 08 2016   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
837740 837740 CO     school 806990 260   VILAS RE-5 80699001207 9100 VILAS UNDIVIDED HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 2 0 2   0 0     0   0   1 3                       4 2 0 2   0 0     0   0   1 3                 4
837755 837755 CO     school 802760 270   CAMPO RE-6 80276000170 1252 CAMPO UNDIVIDED HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_7 3 0 0   0 0     0   0   0 3                       3 3 0 0   0 0     0   0   0 3                 3
837769 837769 CO     school 805250 290   LAS ANIMAS RE-1 80525000867 4986 LAS ANIMAS JUNIOR HIGH SCHOOL   Regular School No 2.0 07 08 2016   grade_7 40 0 8   0 0     0   0   20 28                       48 40 0 8   0 0     0   0   20 28                 48

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