enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
838671 838671 CO     school 800001 520   CHEYENNE COUNTY RE-5 80000100215 1612 CHEYENNE WELLS JUNIOR/HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 2 0 2   0 0     0   0   3 1                       4 2 0 2   0 0     0   0   3 1                 4
848517 848517 CO     school 800004 9130   EXPEDITIONARY BOCES 80000400709 2840 ROCKY MOUNTAIN SCHOOL OF EXPEDITIONARY LEARNING   Regular School No 4.0 KG 12 2016   grade_7 34 1 9   0 2     0   4   34 16                       50 34 1 9   0 2     0   4   34 16                 50
848125 848125 CO     school 800016 3200   YUMA 1 80001601819 9791 YUMA MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_7 40 0 33   0 0     0   0   45 28                       73 40 0 33   0 0     0   0   45 28                 73
848148 848148 CO     school 800017 3210   WRAY RD-2 80001701817 9729 BUCHANAN MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_7 34 2 17   0 0     0   2   29 26                       55 34 2 17   0 0     0   2   29 26                 55
848168 848168 CO     school 800018 3220   IDALIA RJ-3 80001801742 4231 IDALIA JUNIOR-SENIOR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 9 0 3   1 0     0   0   5 8                       13 9 0 3   1 0     0   0   5 8                 13
848184 848184 CO     school 800019 3230   LIBERTY J-4 80001901744 5123 LIBERTY JUNIOR-SENIOR HIGH SCHOOL   Vocational Education School No 4.0 06 12 2016   grade_7 11 0 0   0 0     0   0   7 4                       11 11 0 0   0 0     0   0   7 4                 11
848299 848299 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001569 2035 CROWN POINTE CHARTER ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_7 21 1 25   0 3     1   1   29 23                       52 21 1 25   0 3     1   1   29 23                 52
848472 848472 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001612 9785 YOUTH & FAMILY ACADEMY CHARTER   Alternative Education School Yes 3.0 07 12 2016   grade_7 2 0 7   0 0     0   0   2 7                       9 2 0 7   0 0     0   0   2 7                 9
848275 848275 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001912 1791 COLORADO SPRINGS CHARTER ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_7 34 1 7   0 0     0   3   18 27                       45 34 1 7   0 0     0   3   18 27                 45
848412 848412 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001913 7512 ROSS MONTESSORI SCHOOL   Regular School Yes 1.0 KG 08 2016   grade_7 16 0 2   0 0     0   0   3 15                       18 16 0 2   0 0     0   0   3 15                 18
848388 848388 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002002010 6913 THE PINNACLE CHARTER SCHOOL MIDDLE   Regular School Yes 2.0 06 08 2016   grade_7 33 0 137   1 6     0   0   73 104                       177 33 0 137   1 6     0   0   73 104                 177
848263 848263 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006305 1279 CAPROCK ACADEMY   Regular School Yes 4.0 KG 12 2016   grade_7 57 1 10   0 1     0   3   39 33                       72 57 1 10   0 1     0   3   39 33                 72
848402 848402 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006320 7278 RICARDO FLORES MAGON ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_7 0 0 34   0 0     0   0   19 15                       34 0 0 34   0 0     0   0   19 15                 34
848456 848456 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006338 8929 PIKES PEAK PREP   Regular School Yes 4.0 KG 12 2016   grade_7 21 5 6   0 0     1   0   15 18                       33 21 5 6   0 0     1   0   15 18                 33
848320 848320 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006390 2837 EARLY COLLEGE OF ARVADA   Regular School Yes 4.0 06 12 2016   grade_7 19 0 34   0 8     0   1   26 36                       62 19 0 34   0 8     0   1   26 36                 62
848443 848443 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes 4.0 06 12 2016   grade_7 63 1 25   0 0     0   4   47 46                       93 63 1 25   0 0     0   4   47 46                 93
848358 848358 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2016   grade_7 57 0 3   0 0     0   0   33 27                       60 57 0 3   0 0     0   0   33 27                 60
848307 848307 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006542 2067 COLORADO EARLY COLLEGE FORT COLLINS   Regular School Yes 4.0 06 12 2016   grade_7 48 2 4   0 0     0   0   28 26                       54 48 2 4   0 0     0   0   28 26                 54
848466 848466 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006579 9040 VICTORY PREPARATORY ACADEMY MIDDLE STATE CHARTER SCHOOL   Regular School Yes 2.0 06 08 2016   grade_7 9 1 76   0 0     0   0   39 47                       86 9 1 76   0 0     0   0   39 47                 86
848330 848330 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006586 3326 GLOBAL VILLAGE ACADEMY - COLORADO SPRINGS   Regular School Yes 1.0 KG 07 2016   grade_7 3 3 6   0 2     0   5   8 11                       19 3 3 6   0 2     0   5   8 11                 19
848367 848367 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006589 5851 MOUNTAIN SONG COMMUNITY SCHOOL   Regular School Yes 1.0 KG 07 2016   grade_7 20 0 4   0 0     0   1   12 13                       25 20 0 4   0 0     0   1   12 13                 25
848339 848339 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006596 3399 GLOBAL VILLAGE ACADEMY - FORT COLLINS   Regular School Yes 1.0 KG 07 2016   grade_7 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
848434 848434 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006635 8821 TWO RIVERS COMMUNITY SCHOOL   Regular School Yes 1.0 KG 08 2016   grade_7 17 1 6   0 0     0   0   10 14                       24 17 1 6   0 0     0   0   10 14                 24
848423 848423 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006651 8061 SALIDA MONTESSORI CHARTER SCHOOL   Regular School Yes 1.0 KG 08 2016   grade_7 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
848485 848485 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 COLORADO SCHOOL FOR THE DEAF AND BLIND   Special Education School No 4.0 PK 12 2016   grade_7 4 0 4   0 0     0   0   5 3                       8 4 0 4   0 0     0   0   5 3                 8
848536 848536 CO     school 800282 9170   COLORADO DIGITAL BOCES 80028206600 1550 COLORADO PREP ACADEMY   Regular School No 4.0 KG 12 2016   grade_7 106 14 32   2 1     1   5   67 94                       161 106 14 32   2 1     1   5   67 94                 161
842196 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
842320 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
842249 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
842151 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
842306 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
842165 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 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
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
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
844441 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
848066 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
846455 846455 CO     school 802370 2600   PLATTE CANYON 1 80237001325 7048 FITZSIMMONS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 67 0 12   0 4     0   1   40 44                       84 67 0 12   0 4     0   1   40 44                 84
838259 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 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 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 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
838440 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 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
838506 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 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
838565 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
838389 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
838569 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
838482 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
838337 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
838534 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
838520 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
848086 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
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
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
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
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
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
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
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
846225 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 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
844503 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 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
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
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
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
841270 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 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 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 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
842724 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
842714 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
847272 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
846385 846385 CO     school 802880 2560   CHERAW 31 80288000182 1546 CHERAW SCHOOL   Regular School No 4.0 PK 12 2016   grade_7 8 0 4   0 0     0   0   6 6                       12 8 0 4   0 0     0   0   6 6                 12
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
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
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
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
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
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
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
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

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