Data source: Big Local News · About: Big Local

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

View and edit SQL

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
842104 CO     school   1040   ACADEMY 20   74 CHALLENGER MIDDLE SCHOOL             2016   grade_7 212 7 29   4 14     1   19   144 142                       286 212 7 29   4 14     1   19   144 142                 286
842120 CO     school   1040   ACADEMY 20   209 ASPEN VALLEY CAMPUS             2016   grade_7 12 1 5   0 0     0   0   12 6                       18 12 1 5   0 0     0   0   12 6                 18
842151 CO     school 801920 1040   ACADEMY 20 80192001931 1629 THE CLASSICAL ACADEMY MIDDLE SCHOOL   Regular School Yes 2.0 07 08 2016   grade_7 189 4 22   0 8     1   13   117 120                       237 189 4 22   0 8     1   13   117 120                 237
842165 CO     school 801920 1040   ACADEMY 20 80192006478 1901 ACADEMY CALVERT K-8 ONLINE SCHOOL   Regular School No 1.0 KG 08 2016   grade_7 10 0 4   0 0     0   1   9 6                       15 10 0 4   0 0     0   1   9 6                 15
842170 CO     school 801920 1040   ACADEMY 20 80192006616 1921 DISCOVERY CANYON CAMPUS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 234 13 35   2 15     1   21   179 142                       321 234 13 35   2 15     1   21   179 142                 321
842196 CO     school 801920 1040   ACADEMY 20 80192001402 2358 EAGLEVIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 239 8 44   3 7     0   25   157 169                       326 239 8 44   3 7     0   25   157 169                 326
842249 CO     school 801920 1040   ACADEMY 20 80192001593 6140 MOUNTAIN RIDGE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 252 21 66   1 24     0   32   201 195                       396 252 21 66   1 24     0   32   201 195                 396
842306 CO     school 801920 1040   ACADEMY 20 80192006447 8779 TCA COLLEGE PATHWAYS   Regular School Yes 3.0 07 12 2016   grade_7 46 1 3   1 3     0   1   29 26                       55 46 1 3   1 3     0   1   29 26                 55
842320 CO     school 801920 1040   ACADEMY 20 80192001462 8851 TIMBERVIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 277 14 69   2 8     0   18   208 180                       388 277 14 69   2 8     0   18   208 180                 388
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
845388 CO     school   1620   AGUILAR REORGANIZED 6   66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL             2016   grade_7 1 0 9   0 0     0   0   5 5                       10 1 0 9   0 0     0   0   5 5                 10
847484 CO     school   3030   AKRON R-1   86 AKRON ELEMENTARY SCHOOL             2016   grade_7 20 0 5   0 0     0   1   15 11                       26 20 0 5   0 0     0   1   15 11                 26
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 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
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
847506 CO     school   3040   ARICKAREE R-2   308 ARICKAREE UNDIVIDED HIGH SCHOOL             2016   grade_7 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
844441 CO     school 802260 1450   ARRIBA-FLAGLER C-20 80226000509 2960 FLAGLER PUBLIC SCHOOL   Regular School No 4.0 PK 12 2016   grade_7 20 0 1   0 0     0   0   7 14                       21 20 0 1   0 0     0   0   7 14                 21
846538 CO     school   2640   ASPEN 1   42 ASPEN COMMUNITY CHARTER SCHOOL             2016   grade_7 15 0 0   0 0     0   0   8 7                       15 15 0 0   0 0     0   0   8 7                 15
846550 CO     school   2640   ASPEN 1   430 ASPEN MIDDLE SCHOOL             2016   grade_7 100 0 8   0 1     0   0   57 52                       109 100 0 8   0 1     0   0   57 52                 109
848066 CO     school 802310 3145   AULT-HIGHLAND RE-9 80231001466 3961 HIGHLAND MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 48 0 25   0 0     0   1   41 33                       74 48 0 25   0 0     0   1   41 33                 74
844625 CO     school   1530   BAYFIELD 10 JT-R   636 BAYFIELD MIDDLE SCHOOL             2016   grade_7 109 0 14   3 1     0   2   61 68                       129 109 0 14   3 1     0   2   61 68                 129
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
844488 CO     school   1490   BETHUNE R-5   842 BETHUNE PUBLIC SCHOOLS             2016   grade_7 6 0 2   0 0     0   0   3 5                       8 6 0 2   0 0     0   0   3 5                 8
841234 CO     school 806600 940   BIG SANDY 100J 80660001140 7918 SIMLA JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2016   grade_7 16 0 2   1 0     0   1   12 8                       20 16 0 2   1 0     0   1   12 8                 20
838200 CO     school   480   BOULDER VALLEY RE 2   441 ASPEN CREEK K-8 SCHOOL             2016   grade_7 107 2 16   0 5     0   11   72 69                       141 107 2 16   0 5     0   11   72 69                 141
838218 CO     school   480   BOULDER VALLEY RE 2   866 BOULDER EXPLORE             2016   grade_7 1 0 2   0 0     0   1   2 2                       4 1 0 2   0 0     0   1   2 2                 4
838249 CO     school   480   BOULDER VALLEY RE 2   930 BOULDER UNIVERSAL             2016   grade_7 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
838259 CO     school 802490 480   BOULDER VALLEY RE 2 80249000102 1066 BROOMFIELD HEIGHTS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 119 1 36   2 9     0   8   89 86                       175 119 1 36   2 9     0   8   89 86                 175
838268 CO     school 802490 480   BOULDER VALLEY RE 2 80249000104 1136 MANHATTAN MIDDLE SCHOOL OF THE ARTS AND ACADEMICS   Regular School No 2.0 06 08 2016   grade_7 104 4 33   2 5     0   10   81 77                       158 104 4 33   2 5     0   10   81 77                 158
838272 CO     school 802490 480   BOULDER VALLEY RE 2 80249000106 1352 CASEY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 122 3 78   0 3     0   6   94 118                       212 122 3 78   0 3     0   6   94 118                 212
838281 CO     school 802490 480   BOULDER VALLEY RE 2 80249000108 1390 CENTENNIAL MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 134 2 46   0 17     1   18   110 108                       218 134 2 46   0 17     1   18   110 108                 218
838337 CO     school 802490 480   BOULDER VALLEY RE 2 80249001771 2589 ELDORADO K-8 SCHOOL   Regular School No 1.0 KG 08 2016   grade_7 120 2 14   0 13     0   12   85 76                       161 120 2 14   0 13     0   12   85 76                 161
838389 CO     school 802490 480   BOULDER VALLEY RE 2 80249001467 3499 HALCYON SCHOOL (SPECIAL EDUCATION)   Special Education School No 4.0 06 12 2016   grade_7 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
838440 CO     school 802490 480   BOULDER VALLEY RE 2 80249000122 4878 ANGEVINE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 145 2 92   0 11     0   3   144 109                       253 145 2 92   0 11     0   3   144 109                 253
838451 CO     school 802490 480   BOULDER VALLEY RE 2 80249000125 5306 LOUISVILLE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 153 1 28   0 4     0   15   108 93                       201 153 1 28   0 4     0   15   108 93                 201
838482 CO     school 802490 480   BOULDER VALLEY RE 2 80249001573 6000 MONARCH K-8 SCHOOL   Regular School No 1.0 PK 08 2016   grade_7 119 3 11   0 12     1   9   84 71                       155 119 3 11   0 12     1   9   84 71                 155
838506 CO     school 802490 480   BOULDER VALLEY RE 2 80249000131 6212 NEDERLAND MIDDLE-SENIOR HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_7 44 0 2   0 0     0   3   22 27                       49 44 0 2   0 0     0   3   22 27                 49
838511 CO     school 802490 480   BOULDER VALLEY RE 2 80249000132 6224 NEVIN PLATT MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 159 0 19   0 8     1   8   113 82                       195 159 0 19   0 8     1   8   113 82                 195
838520 CO     school 802490 480   BOULDER VALLEY RE 2 80249006199 6642 HORIZONS K-8 SCHOOL   Alternative Education School Yes 1.0 KG 08 2016   grade_7 35 1 2   1 3     0   0   20 22                       42 35 1 2   1 3     0   0   20 22                 42
838534 CO     school 802490 480   BOULDER VALLEY RE 2 80249001792 6816 PEAK TO PEAK CHARTER SCHOOL   Regular School Yes 4.0 KG 12 2016   grade_7 85 1 17   0 22     1   9   79 56                       135 85 1 17   0 22     1   9   79 56                 135
838565 CO     school 802490 480   BOULDER VALLEY RE 2 80249000134 8135 SOUTHERN HILLS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 157 0 17   0 9     0   13   99 97                       196 157 0 17   0 9     0   13   99 97                 196
838569 CO     school 802490 480   BOULDER VALLEY RE 2 80249001517 8387 SUMMIT MIDDLE CHARTER SCHOOL   Regular School Yes 2.0 06 08 2016   grade_7 77 0 8   0 21     0   13   66 53                       119 77 0 8   0 21     0   13   66 53                 119
845401 CO     school   1750   BRANSON REORGANIZED 82   948 BRANSON SCHOOL ONLINE             2016   grade_7 32 0 4   0 0     0   0   22 14                       36 32 0 4   0 0     0   0   22 14                 36
845415 CO     school   1750   BRANSON REORGANIZED 82   978 BRANSON SCHOOL             2016   grade_7 4 1 3   0 0     0   0   3 5                       8 4 1 3   0 0     0   0   3 5                 8
848086 CO     school 802550 3146   BRIGGSDALE RE-10 80255000143 1012 BRIGGSDALE UNDIVIDED HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_7 7 0 2   0 1     0   0   5 5                       10 7 0 2   0 1     0   0   5 5                 10
846225 CO     school 802610 2395   BRUSH RE-2(J) 80261000153 1094 BRUSH MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_7 45 0 48   0 0     0   1   38 56                       94 45 0 48   0 0     0   1   38 56                 94
838600 CO     school 802640 490   BUENA VISTA R-31 80264000158 1132 HARRY L MC GINNIS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 73 2 11   0 1     0   1   51 37                       88 73 2 11   0 1     0   1   51 37                 88
845545 CO     school 805640 1860   BUFFALO RE-4J 80564000970 5806 MERINO JUNIOR SENIOR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 25 0 0   1 0     0   0   14 12                       26 25 0 0   1 0     0   0   14 12                 26
844503 CO     school 802670 1500   BURLINGTON RE-6J 80267000161 1150 BURLINGTON MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_7 24 1 17   0 0     0   0   24 18                       42 24 1 17   0 0     0   0   24 18                 42
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 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 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 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
841270 CO     school 802730 970   CALHAN RJ-1 80273000510 1215 CALHAN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 38 5 2   0 0     0   1   22 24                       46 38 5 2   0 0     0   1   22 24                 46
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
842676 CO     school 802790 1140   CANON CITY RE-1 80279000171 1262 CANON CITY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 100 1 22   3 0     0   4   63 67                       130 100 1 22   3 0     0   4   63 67                 130
842690 CO     school 802790 1140   CANON CITY RE-1 80279000173 3802 HARRISON SCHOOL   Regular School No 1.0 KG 08 2016   grade_7 99 0 23   1 2     1   2   76 52                       128 99 0 23   1 2     1   2   76 52                 128
842714 CO     school 802790 1140   CANON CITY RE-1 80279001538 6752 MOUNT VIEW CORE KNOWLEDGE CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2016   grade_7 24 1 4   0 0     0   0   13 16                       29 24 1 4   0 0     0   0   13 16                 29
842724 CO     school 802790 1140   CANON CITY RE-1 80279001433 7950 CANON EXPLORATORY SCHOOL   Regular School No 1.0 KG 08 2016   grade_7 20 0 0   0 0     0   2   11 11                       22 20 0 0   0 0     0   2   11 11                 22
838785 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No 4.0 PK 12 2016   grade_7 5 0 17   0 0     0   0   10 12                       22 5 0 17   0 0     0   0   10 12                 22
847272 CO     school 802850 2810   CENTER 26 JT 80285000178 1416 SKOGLUND MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 3 0 41   1 0     0   0   24 21                       45 3 0 41   1 0     0   0   24 21                 45
848197 CO     school   8001   CHARTER SCHOOL INSTITUTE   15 ACADEMY OF CHARTER SCHOOLS             2016   grade_7 77 2 48   0 14     0   3   69 75                       144 77 2 48   0 14     0   3   69 75                 144

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