Data source: Big Local News · About: Big Local

4,236 rows where grade = "grade_7" and state = "CO" sorted by year

View and edit SQL

year

grade

  • grade_7 · 4,236
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year ▼ term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1133215 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No 3.0 07 12 2015   grade_7 23.0 2.0 77.0   0.0 0.0     0.0   1.0   46.0 57.0                       103.0 23 2 77   0 0     0   1   46 57                 103
1133233 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No 4.0 PK 12 2015   grade_7 5.0 1.0 53.0   0.0 0.0     0.0   1.0   27.0 33.0                       60.0 5 1 53   0 0     0   1   27 33                 60
1133250 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No 1.0 PK 08 2015   grade_7 8.0 2.0 41.0   1.0 0.0     0.0   0.0   34.0 18.0                       52.0 8 2 41   1 0     0   0   34 18                 52
1133261 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No 1.0 PK 08 2015   grade_7 12.0 2.0 42.0   0.0 2.0     0.0   0.0   32.0 26.0                       58.0 12 2 42   0 2     0   0   32 26                 58
1133275 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No 4.0 KG 12 2015   grade_7 9.0 1.0 51.0   0.0 1.0     0.0   2.0   31.0 33.0                       64.0 9 1 51   0 1     0   2   31 33                 64
1133295 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No 1.0 PK 08 2015   grade_7 5.0 1.0 48.0   0.0 3.0     1.0   0.0   28.0 30.0                       58.0 5 1 48   0 3     1   0   28 30                 58
1133324 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No 1.0 KG 08 2015   grade_7 5.0 4.0 45.0   1.0 0.0     0.0   4.0   29.0 30.0                       59.0 5 4 45   1 0     0   4   29 30                 59
1133337 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No 4.0 KG 12 2015   grade_7 166.0 5.0 59.0   2.0 3.0     0.0   13.0   123.0 125.0                       248.0 166 5 59   2 3     0   13   123 125                 248
1133350 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No 1.0 KG 08 2015   grade_7 9.0 0.0 46.0   2.0 1.0     0.0   2.0   36.0 24.0                       60.0 9 0 46   2 1     0   2   36 24                 60
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
1133411 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690000728 1519 STARGATE CHARTER SCHOOL   Regular School Yes 1.0 KG 08 2015   grade_7 43.0 1.0 8.0   0.0 16.0     0.0   1.0   32.0 37.0                       69.0 43 1 8   0 16     0   1   32 37                 69
1133505 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006503 3439 GLOBAL VILLAGE ACADEMY   Regular School Yes 1.0 KG 07 2015   grade_7 17.0 0.0 25.0   0.0 1.0     0.0   1.0   27.0 17.0                       44.0 17 0 25   0 1     0   1   27 17                 44
1133527 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001178 4172 HULSTROM OPTIONS K-8 SCHOOL   Regular School No 1.0 KG 08 2015   grade_7 55.0 1.0 6.0   0.0 11.0     1.0   2.0   46.0 30.0                       76.0 55 1 6   0 11     1   2   46 30                 76
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
1133616 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006507 6802 PROSPECT RIDGE ACADEMY   Regular School Yes 4.0 KG 09 2015   grade_7 99.0 0.0 5.0   1.0 7.0     0.0   0.0   65.0 47.0                       112.0 99 0 5   1 7     0   0   65 47                 112
1133626 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative Education School No 4.0 KG 12 2015   grade_7 1.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 0.0                       2.0 1 0 1   0 0     0   0   2 0                 2
1133666 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006468 8275 STEM LAB   Regular School No 1.0 KG 08 2015   grade_7 41.0 0.0 8.0   0.0 3.0     0.0   1.0   32.0 21.0                       53.0 41 0 8   0 3     0   1   32 21                 53
1133676 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006561 8310 STEM LAUNCH   Regular School No 1.0 KG 08 2015   grade_7 33.0 3.0 109.0   2.0 3.0     0.0   2.0   85.0 67.0                       152.0 33 3 109   2 3     0   2   85 67                 152
1133702 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006417 9431 WESTGATE CHARTER   Regular School Yes 4.0 KG 11 2015   grade_7 22.0 0.0 6.0   0.0 3.0     0.0   0.0   21.0 10.0                       31.0 22 0 6   0 3     0   0   21 10                 31
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
1133805 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001948 700 BELLE CREEK CHARTER SCHOOL   Regular School Yes 1.0 KG 08 2015   grade_7 40.0 3.0 37.0   0.0 4.0     1.0   1.0   46.0 40.0                       86.0 40 3 37   0 4     1   1   46 40                 86
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
1133835 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001729 1052 BROMLEY EAST CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2015   grade_7 68.0 0.0 32.0   0.0 3.0     0.0   5.0   56.0 52.0                       108.0 68 0 32   0 3     0   5   56 52                 108
1133856 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006465 2945 FOUNDATIONS ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_7 56.0 0.0 25.0   0.0 1.0     0.0   1.0   40.0 43.0                       83.0 56 0 25   0 1     0   1   40 43                 83
1133876 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006325 4950 LANDMARK ACADEMY AT REUNION   Regular School Yes 1.0 KG 08 2015   grade_7 52.0 2.0 24.0   1.0 3.0     0.0   5.0   41.0 46.0                       87.0 52 2 24   1 3     0   5   41 46                 87
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
1134032 CO     school 807230 70   WESTMINSTER 50 80723001569 2035 CROWN POINTE CHARTER ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_7 18.0 0.0 30.0   0.0 2.0     0.0   2.0   26.0 26.0                       52.0 18 0 30   0 2     0   2   26 26                 52
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
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
1134225 CO     school 803780 120   ENGLEWOOD 1 80378006331 2752 ENGLEWOOD MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   grade_7 73.0 4.0 57.0   1.0 0.0     0.0   4.0   72.0 67.0                       139.0 73 4 57   1 0     0   4   72 67                 139
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
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
1134334 CO     school 802910 130   CHERRY CREEK 5 80291000763 1510 CHALLENGE SCHOOL   Regular School No 1.0 PK 08 2015   grade_7 41.0 2.0 8.0   0.0 18.0     0.0   3.0   37.0 35.0                       72.0 41 2 8   0 18     0   3   37 35                 72
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
1134362 CO     school 802910 130   CHERRY CREEK 5 80291001152 1571 CHERRY CREEK CHARTER ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_7 26.0 3.0 8.0   0.0 11.0     0.0   4.0   21.0 31.0                       52.0 26 3 8   0 11     0   4   21 31                 52
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
1134546 CO     school 802910 130   CHERRY CREEK 5 80291006563 6367 OPTIONS SCHOOL   Alternative Education School No 4.0 KG 12 2015   grade_7 39.0 2.0 6.0   0.0 0.0     0.0   3.0   32.0 18.0                       50.0 39 2 6   0 0     0   3   32 18                 50
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
1134752 CO     school 805310 140   LITTLETON 6 80531001515 5229 LITTLETON ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_7 41.0 0.0 3.0   0.0 7.0     0.0   1.0   26.0 26.0                       52.0 41 0 3   0 7     0   1   26 26                 52
1134762 CO     school 805310 140   LITTLETON 6 80531001626 5233 LITTLETON PREP CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2015   grade_7 41.0 0.0 16.0   0.0 1.0     0.0   5.0   30.0 33.0                       63.0 41 0 16   0 1     0   5   30 33                 63
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
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
1134864 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006399 213 AXL ACADEMY   Regular School Yes 1.0 PK 08 2015   grade_7 15.0 17.0 10.0   1.0 0.0     0.0   2.0   17.0 28.0                       45.0 15 17 10   1 0     0   2   17 28                 45
1134897 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001759 458 AURORA ACADEMY CHARTER SCHOOL   Regular School Yes 1.0 KG 08 2015   grade_7 15.0 8.0 15.0   0.0 1.0     0.0   2.0   27.0 14.0                       41.0 15 8 15   0 1     0   2   27 14                 41
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
1134911 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234002009 465 AURORA FRONTIER K-8   Regular School No 1.0 PK 08 2015   grade_7 26.0 12.0 15.0   0.0 9.0     0.0   6.0   38.0 30.0                       68.0 26 12 15   0 9     0   6   38 30                 68
1134922 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000055 914 BOSTON K-8 SCHOOL   Regular School No 1.0 PK 08 2015   grade_7 1.0 5.0 30.0   0.0 11.0     0.0   0.0   18.0 29.0                       47.0 1 5 30   0 11     0   0   18 29                 47
1134945 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000057 1720 CLYDE MILLER K-8   Regular School No 1.0 PK 08 2015   grade_7 12.0 6.0 41.0   0.0 1.0     0.0   1.0   31.0 30.0                       61.0 12 6 41   0 1     0   1   31 30                 61
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
1135017 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes 1.0 KG 08 2015   grade_7 7.0 9.0 35.0   0.0 3.0     0.0   1.0   23.0 32.0                       55.0 7 9 35   0 3     0   1   23 32                 55
1135076 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes 4.0 KG 12 2015   grade_7 14.0 37.0 19.0   0.0 0.0     0.0   0.0   36.0 34.0                       70.0 14 37 19   0 0     0   0   36 34                 70
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
1135109 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001881 6189 MURPHY CREEK K-8 SCHOOL   Regular School No 1.0 PK 08 2015   grade_7 24.0 11.0 30.0   0.0 0.0     0.0   6.0   37.0 34.0                       71.0 24 11 30   0 0     0   6   37 34                 71
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
1135127 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001789 6546 OPTIONS SCHOOL   Regular School No 4.0 KG 12 2015   grade_7 51.0 0.0 9.0   0.0 2.0     0.0   0.0   28.0 34.0                       62.0 51 0 9   0 2     0   0   28 34                 62
1135162 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001674 7232 AURORA QUEST K-8   Regular School No 1.0 KG 08 2015   grade_7 40.0 10.0 12.0   0.0 13.0     1.0   7.0   40.0 43.0                       83.0 40 10 12   0 13     1   7   40 43                 83
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
1135217 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006322 9056 VANGUARD CLASSICAL SCHOOL - WEST   Regular School Yes 1.0 KG 08 2015   grade_7 10.0 9.0 31.0   1.0 0.0     0.0   0.0   21.0 30.0                       51.0 10 9 31   1 0     0   0   21 30                 51
1135243 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006483 9083 VISTA PEAK P-8 EXPLORATORY   Regular School No 1.0 PK 08 2015   grade_7 34.0 7.0 65.0   1.0 1.0     1.0   5.0   59.0 55.0                       114.0 34 7 65   1 1     1   5   59 55                 114
1135268 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes 4.0 KG 10 2015   grade_7 17.0 15.0 18.0   0.0 2.0     0.0   6.0   34.0 24.0                       58.0 17 15 18   0 2     0   6   34 24                 58
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
1135309 CO     school 802700 190   BYERS 32J 80270000164 1176 BYERS JUNIOR-SENIOR HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_7 25.0 0.0 7.0   1.0 0.0     0.0   1.0   17.0 17.0                       34.0 25 0 7   1 0     0   1   17 17                 34
1135319 CO     school 802700 190   BYERS 32J 80270006605 2356 ELEVATE ACADEMY   Regular School Yes 3.0 07 12 2015   grade_7 8.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 6.0                       8.0 8 0 0   0 0     0   0   2 6                 8
1135332 CO     school 802700 190   BYERS 32J 80270006548 3362 GREAT PLAINS ACADEMY   Regular School No 4.0 KG 12 2015   grade_7 7.0 0.0 3.0   0.0 0.0     0.0   1.0   5.0 6.0                       11.0 7 0 3   0 0     0   1   5 6                 11
1135345 CO     school 802700 190   BYERS 32J 80270006620 6263 COLORADO DIGITAL ACADEMY - MIDDLE   Regular School Yes 2.0 07 08 2015   grade_7 100.0 2.0 15.0   0.0 0.0     0.0   7.0   65.0 59.0                       124.0 100 2 15   0 0     0   7   65 59                 124
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
1135377 CO     school 807110 230   WALSH RE-1 80711001216 9226 WALSH HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_7 6.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 3.0                       7.0 6 0 1   0 0     0   0   4 3                 7
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
1135409 CO     school 806630 250   SPRINGFIELD RE-4 80663001142 8168 SPRINGFIELD JUNIOR/SENIOR HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_7 11.0 0.0 3.0   0.0 0.0     0.0   0.0   6.0 8.0                       14.0 11 0 3   0 0     0   0   6 8                 14
1135419 CO     school 806990 260   VILAS RE-5 80699001805 9085 V.I.L.A.S. ONLINE SCHOOL   Regular School No 1.0 KG 08 2015   grade_7 5.0 3.0 0.0   0.0 0.0     0.0   0.0   4.0 4.0                       8.0 5 3 0   0 0     0   0   4 4                 8
1135435 CO     school 806990 260   VILAS RE-5 80699001207 9100 VILAS UNDIVIDED HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_7 3.0 0.0 2.0   0.0 0.0     0.0   0.0   4.0 1.0                       5.0 3 0 2   0 0     0   0   4 1                 5

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