Data source: Big Local News · About: Big Local

581 rows where grade = "grade_7", state = "CO" and year = 2015 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2015 · 581

grade

  • grade_7 · 581
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
1134852 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2015   grade_7 0.0 1.0 0.0   1.0 0.0     0.0   0.0   2.0 0.0                       2.0 0 1 0   1 0     0   0   2 0                 2
1146094 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2015   grade_7 0.0 1.0 3.0   0.0 0.0     0.0   0.0   3.0 1.0                       4.0 0 1 3   0 0     0   0   3 1                 4
1137160 CO     school 803360 880   DENVER COUNTY 1 80336001739 3647 MARIE L. GREENWOOD ACADEMY   Regular School No 1.0 01 08 2015   grade_7 0.0 5.0 64.0   0.0 1.0     0.0   0.0   36.0 34.0                       70.0 0 5 64   0 1     0   0   36 34                 70
1134069 CO     school 807230 70   WESTMINSTER 50 80723006567 4334 COLORADO STEM ACADEMY   Regular School No 1.0 03 08 2015   grade_7 22.0 0.0 31.0   0.0 3.0     0.0   0.0   33.0 23.0                       56.0 22 0 31   0 3     0   0   33 23                 56
1134246 CO     school 806540 123   SHERIDAN 2 80654001135 7837 FORT LOGAN NORTHGATE   Regular School No 1.0 03 08 2015   grade_7 13.0 4.0 90.0   4.0 6.0     0.0   1.0   59.0 59.0                       118.0 13 4 90   4 6     0   1   59 59                 118
1144305 CO     school 806120 2690   PUEBLO CITY 60 80612006361 2096 CORWIN INTERNATIONAL MAGNET SCHOOL   Regular School No 2.0 04 08 2015   grade_7 47.0 3.0 84.0   0.0 1.0     0.0   5.0   82.0 58.0                       140.0 47 3 84   0 1     0   5   82 58                 140
1144371 CO     school 806120 2690   PUEBLO CITY 60 80612001055 5048 PUEBLO ACADEMY OF ARTS   Regular School No 2.0 04 08 2015   grade_7 44.0 8.0 123.0   2.0 1.0     0.0   7.0   95.0 90.0                       185.0 44 8 123   2 1     0   7   95 90                 185
1144682 CO     school 805760 2740   MONTE VISTA C-8 80576001560 6520 MONTE VISTA ON-LINE ACADEMY   Alternative Education School No 4.0 04 12 2015   grade_7 11.0 0.0 3.0   0.0 0.0     0.0   0.0   7.0 7.0                       14.0 11 0 3   0 0     0   0   7 7                 14
1135357 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000040 6657 PAGOSA SPRINGS MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 55.0 0.0 47.0   3.0 2.0     1.0   1.0   49.0 60.0                       109.0 55 0 47   3 2     1   1   49 60                 109
1135722 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000910 5288 LONGS PEAK MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 47.0 1.0 88.0   2.0 2.0     0.0   1.0   74.0 67.0                       141.0 47 1 88   2 2     0   1   74 67                 141
1136308 CO     school 806330 500   SALIDA R-32 80633006500 1554 CREST ACADEMY   Regular School No 2.0 05 08 2015   grade_7 6.0 0.0 1.0   0.0 0.0     0.0   0.0   3.0 4.0                       7.0 6 0 1   0 0     0   0   3 4                 7
1136318 CO     school 806330 500   SALIDA R-32 80633001107 4680 SALIDA MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 61.0 1.0 11.0   0.0 1.0     0.0   1.0   46.0 29.0                       75.0 61 1 11   0 1     0   1   46 29                 75
1136550 CO     school 803330 870   DELTA COUNTY 50(J) 80333002001 2152 DELTA ACADEMY OF APPLIED LEARNING   Alternative Education School No 2.0 05 08 2015   grade_7 8.0 0.0 2.0   0.0 0.0     0.0   0.0   6.0 4.0                       10.0 8 0 2   0 0     0   0   6 4                 10
1137281 CO     school 803360 880   DENVER COUNTY 1 80336006519 4507 KIPP MONTBELLO COLLEGE PREP   Regular School Yes 2.0 05 08 2015   grade_7 8.0 31.0 73.0   0.0 0.0     0.0   2.0   62.0 52.0                       114.0 8 31 73   0 0     0   2   62 52                 114
1137295 CO     school 803360 880   DENVER COUNTY 1 80336001865 4732 KIPP SUNSHINE PEAK ACADEMY   Regular School Yes 2.0 05 08 2015   grade_7 1.0 0.0 96.0   0.0 1.0     0.0   0.0   58.0 40.0                       98.0 1 0 96   0 1     0   0   58 40                 98
1138764 CO     school 803540 910   EAGLE COUNTY RE 50 80354006422 9061 VAIL SKI AND SNOWBOARD ACADEMY (VSSA)   Alternative Education School No 4.0 05 12 2015   grade_7 22.0 0.0 0.0   0.0 0.0     0.0   1.0   13.0 10.0                       23.0 22 0 0   0 0     0   1   13 10                 23
1138898 CO     school 804530 980   HARRISON 2 80453006425 469 ATLAS PREPARATORY SCHOOL   Regular School Yes 4.0 05 10 2015   grade_7 21.0 22.0 100.0   0.0 1.0     1.0   6.0   73.0 78.0                       151.0 21 22 100   0 1     1   6   73 78                 151
1140398 CO     school 804260 1180   ROARING FORK RE-1 80426000133 561 BASALT MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 49.0 0.0 63.0   0.0 0.0     0.0   1.0   60.0 53.0                       113.0 49 0 63   0 0     0   1   60 53                 113
1140413 CO     school 804260 1180   ROARING FORK RE-1 80426000586 1296 CARBONDALE MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 36.0 0.0 48.0   1.0 2.0     0.0   1.0   47.0 41.0                       88.0 36 0 48   1 2     0   1   47 41                 88
1140495 CO     school 806240 1195   GARFIELD RE-2 80624001096 7356 RIFLE MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 99.0 0.0 94.0   0.0 1.0     0.0   3.0   109.0 88.0                       197.0 99 0 94   0 1     0   3   109 88                 197
1140505 CO     school 806240 1195   GARFIELD RE-2 80624001098 7388 RIVERSIDE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 93.0 0.0 61.0   0.0 1.0     0.0   0.0   82.0 73.0                       155.0 93 0 61   0 1     0   0   82 73                 155
1141955 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006512 9515 WHEAT RIDGE 5-8   Regular School No 2.0 05 08 2015   grade_7 30.0 4.0 143.0   3.0 2.0     1.0   1.0   96.0 88.0                       184.0 30 4 143   3 2     1   1   96 88                 184
1142088 CO     school 802670 1500   BURLINGTON RE-6J 80267000161 1150 BURLINGTON MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 13.0 0.0 26.0   1.0 1.0     0.0   0.0   17.0 24.0                       41.0 13 0 26   1 1     0   0   17 24                 41
1144120 CO     school 802280 2640   ASPEN 1 80228000046 430 ASPEN MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 113.0 2.0 17.0   1.0 4.0     0.0   0.0   72.0 65.0                       137.0 113 2 17   1 4     0   0   72 65                 137
1144639 CO     school 803300 2730   DEL NORTE C-7 80330000289 2148 DEL NORTE MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 16.0 0.0 20.0   0.0 0.0     0.0   0.0   22.0 14.0                       36.0 16 0 20   0 0     0   0   22 14                 36
1145693 CO     school 800016 3200   YUMA 1 80001601819 9791 YUMA MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 15.0 0.0 30.0   0.0 0.0     0.0   0.0   23.0 22.0                       45.0 15 0 30   0 0     0   0   23 22                 45
1145716 CO     school 800017 3210   WRAY RD-2 80001701817 9729 BUCHANAN MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 26.0 0.0 12.0   0.0 0.0     0.0   1.0   25.0 14.0                       39.0 26 0 12   0 0     0   1   25 14                 39
1133363 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001726 57 ROCKY TOP MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 329.0 7.0 80.0   1.0 25.0     1.0   6.0   223.0 226.0                       449.0 329 7 80   1 25     1   6   223 226                 449
1133380 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative Education School No 4.0 06 12 2015   grade_7 2.0 0.0 5.0   0.0 0.0     0.0   0.0   5.0 2.0                       7.0 2 0 5   0 0     0   0   5 2                 7
1133402 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001620 1480 CENTURY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 231.0 9.0 106.0   6.0 14.0     1.0   5.0   187.0 185.0                       372.0 231 9 106   6 14     1   5   187 185                 372
1133532 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001179 4187 SILVER HILLS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 162.0 8.0 154.0   2.0 25.0     0.0   6.0   176.0 181.0                       357.0 162 8 154   2 25     0   6   176 181                 357
1133562 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001183 5814 THE INTERNATIONAL SCHOOL AT THORNTON MIDDLE   Regular School No 2.0 06 08 2015   grade_7 47.0 10.0 224.0   4.0 7.0     0.0   2.0   154.0 140.0                       294.0 47 10 224   4 7     0   2   154 140                 294
1133584 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001186 6342 SHADOW RIDGE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 180.0 4.0 126.0   1.0 20.0     0.0   3.0   182.0 152.0                       334.0 180 4 126   1 20     0   3   182 152                 334
1133602 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001187 6398 NORTHGLENN MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 93.0 11.0 178.0   4.0 8.0     1.0   6.0   161.0 140.0                       301.0 93 11 178   4 8     1   6   161 140                 301
1133708 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001194 9444 WESTLAKE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 258.0 3.0 82.0   1.0 34.0     0.0   5.0   197.0 186.0                       383.0 258 3 82   1 34     0   5   197 186                 383
1133726 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 29.0 7.0 215.0   2.0 2.0     0.0   5.0   135.0 125.0                       260.0 29 7 215   2 2     0   5   135 125                 260
1133763 CO     school 801950 30   ADAMS COUNTY 14 80195000015 4516 KEARNEY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 29.0 9.0 223.0   1.0 0.0     0.0   1.0   128.0 135.0                       263.0 29 9 223   1 0     0   1   128 135                 263
1133820 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000729 1021 BRIGHTON HERITAGE ACADEMY   Alternative Education School No 4.0 06 12 2015   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0                       2.0 2 0 0   0 0     0   0   2 0                 2
1133907 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001377 6638 OVERLAND TRAIL MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 66.0 1.0 129.0   2.0 3.0     0.0   4.0   119.0 86.0                       205.0 66 1 129   2 3     0   4   119 86                 205
1133911 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006420 6702 OTHO E STUART MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 104.0 8.0 85.0   2.0 10.0     0.0   9.0   127.0 91.0                       218.0 104 8 85   2 10     0   9   127 91                 218
1133920 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006362 7131 PRAIRIE VIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 139.0 5.0 129.0   2.0 15.0     0.0   5.0   162.0 133.0                       295.0 139 5 129   2 15     0   5   162 133                 295
1133968 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000152 9230 VIKAN MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 67.0 3.0 133.0   4.0 1.0     0.0   4.0   114.0 98.0                       212.0 67 3 133   4 1     0   4   114 98                 212
1133990 CO     school 802430 50   BENNETT 29J 80243000093 774 BENNETT MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 74.0 0.0 21.0   1.0 0.0     0.0   2.0   50.0 48.0                       98.0 74 0 21   1 0     0   2   50 48                 98
1134011 CO     school 806750 60   STRASBURG 31J 80675001160 8332 HEMPHILL MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 80.0 2.0 8.0   1.0 0.0     0.0   1.0   54.0 38.0                       92.0 80 2 8   1 0     0   1   54 38                 92
1134080 CO     school 807230 70   WESTMINSTER 50 80723001241 5388 M. SCOTT CARPENTER MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 19.0 1.0 153.0   0.0 6.0     0.0   3.0   103.0 79.0                       182.0 19 1 153   0 6     0   3   103 79                 182
1134091 CO     school 807230 70   WESTMINSTER 50 80723006458 7305 IVER C. RANUM MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 27.0 0.0 204.0   0.0 10.0     0.0   9.0   133.0 117.0                       250.0 27 0 204   0 10     0   9   133 117                 250
1134103 CO     school 807230 70   WESTMINSTER 50 80723001244 7812 SHAW HEIGHTS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 48.0 0.0 122.0   1.0 9.0     0.0   3.0   92.0 91.0                       183.0 48 0 122   1 9     0   3   92 91                 183
1134149 CO     school 802070 100   ALAMOSA RE-11J 80207000026 114 ORTEGA MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 51.0 4.0 112.0   1.0 2.0     1.0   2.0   82.0 91.0                       173.0 51 4 112   1 2     1   2   82 91                 173
1134167 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative Education School No 4.0 06 12 2015   grade_7 0.0 0.0 4.0   0.0 0.0     0.0   0.0   0.0 4.0                       4.0 0 0 4   0 0     0   0   0 4                 4
1134183 CO     school 806420 110   SANGRE DE CRISTO RE-22J 80642001116 7630 SANGRE DE CRISTO UNDIVIDED HIGH SCHOOL   Regular School No 4.0 06 12 2015   grade_7 13.0 0.0 10.0   1.0 0.0     1.0   0.0   9.0 16.0                       25.0 13 0 10   1 0     1   0   9 16                 25
1134222 CO     school 803780 120   ENGLEWOOD 1 80378001772 2750 ENGLEWOOD LEADERSHIP ACADEMY   Regular School No 2.0 06 09 2015   grade_7 10.0 0.0 7.0   0.0 0.0     0.0   0.0   9.0 8.0                       17.0 10 0 7   0 0     0   0   9 8                 17
1134270 CO     school 802910 130   CHERRY CREEK 5 80291001711 18 LIBERTY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 220.0 25.0 68.0   0.0 32.0     0.0   25.0   184.0 186.0                       370.0 220 25 68   0 32     0   25   184 186                 370
1134274 CO     school 802910 130   CHERRY CREEK 5 80291001878 141 SKY VISTA MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 167.0 36.0 46.0   0.0 19.0     0.0   21.0   164.0 125.0                       289.0 167 36 46   0 19     0   21   164 125                 289
1134344 CO     school 802910 130   CHERRY CREEK 5 80291000185 1566 CAMPUS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 327.0 11.0 55.0   2.0 75.0     0.0   19.0   260.0 229.0                       489.0 327 11 55   2 75     0   19   260 229                 489
1134348 CO     school 802910 130   CHERRY CREEK 5 80291000207 1568 WEST MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 320.0 8.0 57.0   1.0 26.0     0.0   18.0   219.0 211.0                       430.0 320 8 57   1 26     0   18   219 211                 430
1134431 CO     school 802910 130   CHERRY CREEK 5 80291001672 2897 FALCON CREEK MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 204.0 25.0 71.0   0.0 20.0     1.0   13.0   171.0 163.0                       334.0 204 25 71   0 20     1   13   171 163                 334
1134435 CO     school 802910 130   CHERRY CREEK 5 80291006367 3030 FOX RIDGE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 277.0 29.0 47.0   0.0 36.0     0.0   16.0   210.0 195.0                       405.0 277 29 47   0 36     0   16   210 195                 405
1134481 CO     school 802910 130   CHERRY CREEK 5 80291001328 4100 HORIZON MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 145.0 71.0 82.0   4.0 18.0     0.0   21.0   186.0 155.0                       341.0 145 71 82   4 18     0   21   186 155                 341
1134510 CO     school 802910 130   CHERRY CREEK 5 80291000197 4975 LAREDO MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 183.0 69.0 85.0   1.0 28.0     0.0   16.0   197.0 185.0                       382.0 183 69 85   1 28     0   16   197 185                 382
1134591 CO     school 802910 130   CHERRY CREEK 5 80291000201 7158 PRAIRIE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 153.0 136.0 196.0   5.0 32.0     1.0   34.0   303.0 254.0                       557.0 153 136 196   5 32     1   34   303 254                 557
1134638 CO     school 802910 130   CHERRY CREEK 5 80291000034 8848 THUNDER RIDGE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 276.0 40.0 75.0   1.0 30.0     0.0   32.0   225.0 229.0                       454.0 276 40 75   1 30     0   32   225 229                 454
1134706 CO     school 805310 140   LITTLETON 6 80531000876 2804 EUCLID MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 165.0 3.0 43.0   2.0 5.0     1.0   6.0   103.0 122.0                       225.0 165 3 43   2 5     1   6   103 122                 225
1134717 CO     school 805310 140   LITTLETON 6 80531000879 3472 GODDARD MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 131.0 4.0 72.0   2.0 3.0     1.0   12.0   109.0 116.0                       225.0 131 4 72   2 3     1   12   109 116                 225
1134734 CO     school 805310 140   LITTLETON 6 80531000885 4316 NEWTON MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 176.0 4.0 21.0   1.0 8.0     0.0   12.0   105.0 117.0                       222.0 176 4 21   1 8     0   12   105 117                 222
1134738 CO     school 805310 140   LITTLETON 6 80531001351 4447 JOHN WESLEY POWELL MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 253.0 3.0 32.0   3.0 15.0     0.0   14.0   160.0 160.0                       320.0 253 3 32   3 15     0   14   160 160                 320
1134841 CO     school 803270 170   DEER TRAIL 26J 80327000288 2140 DEER TRAIL JUNIOR-SENIOR HIGH SCHOOL   Regular School No 4.0 06 12 2015   grade_7 11.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 7.0                       11.0 11 0 0   0 0     0   0   4 7                 11
1134902 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000054 464 AURORA HILLS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 26.0 83.0 182.0   1.0 12.0     1.0   10.0   193.0 122.0                       315.0 26 83 182   1 12     1   10   193 122                 315
1134951 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001322 1800 COLUMBIA MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 86.0 59.0 99.0   2.0 14.0     0.0   16.0   143.0 133.0                       276.0 86 59 99   2 14     0   16   143 133                 276
1134979 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000060 2384 EAST MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 22.0 51.0 229.0   1.0 16.0     1.0   9.0   164.0 165.0                       329.0 22 51 229   1 16     1   9   164 165                 329
1135100 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000073 6160 MRACHEK MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 58.0 64.0 150.0   2.0 9.0     0.0   13.0   173.0 123.0                       296.0 58 64 150   2 9     0   13   173 123                 296
1135115 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000074 6310 NORTH MIDDLE SCHOOL HEALTH SCIENCES AND TECHNOLOGY CAMPUS   Regular School No 2.0 06 08 2015   grade_7 19.0 45.0 204.0   4.0 8.0     0.0   6.0   132.0 154.0                       286.0 19 45 204   4 8     0   6   132 154                 286
1135196 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000079 8078 SOUTH MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 21.0 57.0 187.0   3.0 12.0     2.0   12.0   142.0 152.0                       294.0 21 57 187   3 12     2   12   142 152                 294
1135277 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000082 9396 AURORA WEST COLLEGE PREPARATORY ACADEMY   Regular School No 4.0 06 12 2015   grade_7 17.0 33.0 221.0   2.0 43.0     0.0   7.0   172.0 151.0                       323.0 17 33 221   2 43     0   7   172 151                 323
1135390 CO     school 806090 240   PRITCHETT RE-3 80609001952 7176 PRITCHETT MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 7.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 3.0                       7.0 7 0 0   0 0     0   0   4 3                 7
1135451 CO     school 802760 270   CAMPO RE-6 80276000170 1252 CAMPO UNDIVIDED HIGH SCHOOL   Regular School No 4.0 06 12 2015   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0                       1.0 1 0 0   0 0     0   0   0 1                 1
1135529 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001886 226 ALTONA MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 188.0 2.0 36.0   1.0 24.0     0.0   5.0   129.0 127.0                       256.0 188 2 36   1 24     0   5   129 127                 256
1135615 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000900 2760 ERIE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 216.0 2.0 26.0   1.0 5.0     0.0   6.0   112.0 144.0                       256.0 216 2 26   1 5     0   6   112 144                 256
1135656 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001774 3194 COAL RIDGE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 184.0 1.0 55.0   2.0 3.0     0.0   2.0   124.0 123.0                       247.0 184 1 55   2 3     0   2   124 123                 247
1135717 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000908 5286 SUNSET MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 112.0 1.0 89.0   0.0 4.0     2.0   4.0   101.0 111.0                       212.0 112 1 89   0 4     2   4   101 111                 212
1135738 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No 4.0 06 12 2015   grade_7 43.0 1.0 3.0   0.0 5.0     0.0   0.0   29.0 23.0                       52.0 43 1 3   0 5     0   0   29 23                 52
1135757 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000915 5730 MEAD MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 112.0 0.0 27.0   0.0 2.0     0.0   2.0   74.0 69.0                       143.0 112 0 27   0 2     0   2   74 69                 143
1135861 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001891 8903 TRAIL RIDGE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 101.0 4.0 96.0   1.0 9.0     1.0   1.0   110.0 103.0                       213.0 101 4 96   1 9     1   1   110 103                 213
1135880 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006198 9430 WESTVIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 201.0 1.0 50.0   2.0 9.0     0.0   8.0   134.0 137.0                       271.0 201 1 50   2 9     0   8   134 137                 271
1135952 CO     school 802490 480   BOULDER VALLEY RE 2 80249000102 1066 BROOMFIELD HEIGHTS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 138.0 1.0 43.0   1.0 5.0     0.0   9.0   92.0 105.0                       197.0 138 1 43   1 5     0   9   92 105                 197
1135961 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 2015   grade_7 117.0 1.0 45.0   1.0 15.0     0.0   8.0   90.0 97.0                       187.0 117 1 45   1 15     0   8   90 97                 187
1135965 CO     school 802490 480   BOULDER VALLEY RE 2 80249000106 1352 CASEY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 94.0 2.0 92.0   1.0 11.0     0.0   6.0   111.0 95.0                       206.0 94 2 92   1 11     0   6   111 95                 206
1135974 CO     school 802490 480   BOULDER VALLEY RE 2 80249000108 1390 CENTENNIAL MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 130.0 0.0 36.0   3.0 11.0     0.0   12.0   98.0 94.0                       192.0 130 0 36   3 11     0   12   98 94                 192
1136080 CO     school 802490 480   BOULDER VALLEY RE 2 80249001467 3499 HALCYON SCHOOL (SPECIAL EDUCATION)   Special Education School No 4.0 06 12 2015   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0                       3.0 3 0 0   0 0     0   0   3 0                 3
1136132 CO     school 802490 480   BOULDER VALLEY RE 2 80249000122 4878 ANGEVINE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 111.0 2.0 96.0   1.0 6.0     0.0   9.0   123.0 102.0                       225.0 111 2 96   1 6     0   9   123 102                 225
1136144 CO     school 802490 480   BOULDER VALLEY RE 2 80249000125 5306 LOUISVILLE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 165.0 1.0 29.0   1.0 6.0     0.0   13.0   104.0 111.0                       215.0 165 1 29   1 6     0   13   104 111                 215
1136197 CO     school 802490 480   BOULDER VALLEY RE 2 80249000131 6212 NEDERLAND MIDDLE-SENIOR HIGH SCHOOL   Regular School No 4.0 06 12 2015   grade_7 33.0 0.0 2.0   1.0 1.0     0.0   4.0   19.0 22.0                       41.0 33 0 2   1 1     0   4   19 22                 41
1136202 CO     school 802490 480   BOULDER VALLEY RE 2 80249000132 6224 NEVIN PLATT MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 147.0 4.0 19.0   1.0 3.0     0.0   9.0   90.0 93.0                       183.0 147 4 19   1 3     0   9   90 93                 183
1136255 CO     school 802490 480   BOULDER VALLEY RE 2 80249000134 8135 SOUTHERN HILLS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 152.0 1.0 8.0   1.0 10.0     0.0   8.0   99.0 81.0                       180.0 152 1 8   1 10     0   8   99 81                 180
1136259 CO     school 802490 480   BOULDER VALLEY RE 2 80249001517 8387 SUMMIT MIDDLE CHARTER SCHOOL   Regular School Yes 2.0 06 08 2015   grade_7 66.0 0.0 8.0   1.0 32.0     0.0   10.0   64.0 53.0                       117.0 66 0 8   1 32     0   10   64 53                 117
1136290 CO     school 802640 490   BUENA VISTA R-31 80264000158 1132 HARRY L MC GINNIS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 58.0 0.0 5.0   0.0 1.0     0.0   0.0   27.0 37.0                       64.0 58 0 5   0 1     0   0   27 37                 64
1136346 CO     school 805040 510   KIT CARSON R-1 80504000826 4742 KIT CARSON JUNIOR-SENIOR HIGH SCHOOL   Regular School No 4.0 06 12 2015   grade_7 7.0 0.0 1.0   0.0 0.0     0.0   0.0   6.0 2.0                       8.0 7 0 1   0 0     0   0   6 2                 8
1136402 CO     school 805100 550   NORTH CONEJOS RE-1J 80510000842 1276 CENTAURI MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 32.0 1.0 33.0   0.0 0.0     0.0   0.0   38.0 28.0                       66.0 32 1 33   0 0     0   0   38 28                 66
1136459 CO     school 802130 580   SOUTH CONEJOS RE-10 80213001464 250 ANTONITO MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 1.0 0.0 17.0   0.0 0.0     0.0   0.0   5.0 13.0                       18.0 1 0 17   0 0     0   0   5 13                 18
1136504 CO     school 803210 770   CROWLEY COUNTY RE-1-J 80321001519 2054 CROWLEY COUNTY WARD MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 16.0 0.0 12.0   1.0 0.0     0.0   0.0   19.0 10.0                       29.0 16 0 12   1 0     0   0   19 10                 29
1136521 CO     school 807200 860   CUSTER COUNTY SCHOOL DISTRICT C-1 80720001732 2091 CUSTER MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 28.0 0.0 0.0   0.0 0.0     0.0   0.0   9.0 19.0                       28.0 28 0 0   0 0     0   0   9 19                 28

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