Data source: Big Local News · About: Big Local

686 rows where grade = "grade_6", state = "CO" and year = 2019

View and edit SQL

year

  • 2019 · 686

grade

  • grade_6 · 686
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
1930982 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary KG 08 2019   grade_6 2 0 37   0 1     0   1   19 22                       41 2 0 37   0 1     0   1   19 22                 41
1930992 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   grade_6 6 0 45   0 3     0   0   32 22                       54 6 0 45   0 3     0   0   32 22                 54
1931006 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_6 4 0 51   0 1     0   1   30 27                       57 4 0 51   0 1     0   1   30 27                 57
1931017 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2019   grade_6 2 2 21   0 0     0   1   7 19                       26 2 2 21   0 0     0   1   7 19                 26
1931026 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   grade_6 7 0 49   1 1     0   3   28 33                       61 7 0 49   1 1     0   3   28 33                 61
1931037 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_6 13 1 35   1 1     0   3   36 18                       54 13 1 35   1 1     0   3   36 18                 54
1931046 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_6 7 0 30   1 0     0   0   18 20                       38 7 0 30   1 0     0   0   18 20                 38
1931055 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2019   grade_6 8 0 40   0 2     0   0   26 24                       50 8 0 40   0 2     0   0   26 24                 50
1931073 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2019   grade_6 89 5 40   0 3     1   6   70 74                       144 89 5 40   0 3     1   6   70 74                 144
1931081 CO     school 805550 10   MAPLETON 1 80555006672 3590 GLOBAL INTERMEDIATE ACADEMY   Regular School No Middle 04 08 2019   grade_6 3 1 51   0 1     0   1   30 27                       57 3 1 51   0 1     0   1   30 27                 57
1931098 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2019   grade_6 5 0 40   0 0     0   1   22 24                       46 5 0 40   0 0     0   1   22 24                 46
1931114 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001726 57 ROCKY TOP MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 238 4 72   1 22     0   16   180 173                       353 238 4 72   1 22     0   16   180 173                 353
1931153 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001620 1480 CENTURY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 199 13 116   2 26     0   10   190 176                       366 199 13 116   2 26     0   10   190 176                 366
1931165 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690000728 1519 STARGATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_6 74 1 11   1 31     0   11   59 70                       129 74 1 11   1 31     0   11   59 70                 129
1931280 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001178 4172 HULSTROM OPTIONS K-8 SCHOOL   Regular School No Elementary KG 08 2019   grade_6 45 0 9   0 13     0   9   34 42                       76 45 0 9   0 13     0   9   34 42                 76
1931285 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001179 4187 SILVER HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 133 7 205   2 20     1   18   203 183                       386 133 7 205   2 20     1   18   203 183                 386
1931322 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001183 5814 THE INTERNATIONAL SCHOOL AT THORNTON MIDDLE   Regular School No Middle 06 08 2019   grade_6 34 16 262   2 6     0   5   183 142                       325 34 16 262   2 6     0   5   183 142                 325
1931345 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001186 6342 SHADOW RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 148 2 113   1 14     1   12   158 133                       291 148 2 113   1 14     1   12   158 133                 291
1931365 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001187 6398 NORTHGLENN MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 61 9 206   0 5     0   4   151 134                       285 61 9 206   0 5     0   4   151 134                 285
1931382 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006507 6802 PROSPECT RIDGE ACADEMY   Regular School Yes Other KG 12 2019   grade_6 111 1 7   0 10     0   1   50 80                       130 111 1 7   0 10     0   1   50 80                 130
1931392 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2019   grade_6 1 1 1   0 0     0   0   3 0                       3 1 1 1   0 0     0   0   3 0                 3
1931433 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006468 8275 STEM LAB   Regular School No Elementary KG 08 2019   grade_6 40 0 14   0 1     0   1   35 21                       56 40 0 14   0 1     0   1   35 21                 56
1931443 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006561 8310 STEM LAUNCH   Regular School No Elementary KG 08 2019   grade_6 26 2 117   1 4     0   1   86 65                       151 26 2 117   1 4     0   1   86 65                 151
1931460 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006740 8814 THUNDER VISTA P-8   Regular School No Elementary PK 08 2019   grade_6 62 1 8   0 6     1   3   45 36                       81 62 1 8   0 6     1   3   45 36                 81
1931483 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006417 9431 WESTGATE CHARTER   Regular School Yes Other KG 12 2019   grade_6 32 2 6   0 4     1   1   26 20                       46 32 2 6   0 4     1   1   26 20                 46
1931490 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001194 9444 WESTLAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 212 3 106   4 17     0   15   185 172                       357 212 3 106   4 17     0   15   185 172                 357
1931512 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 27 3 227   2 0     1   8   135 133                       268 27 3 227   2 0     1   8   135 133                 268
1931550 CO     school 801950 30   ADAMS COUNTY 14 80195000015 4516 KEARNEY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 27 6 245   1 1     1   2   154 129                       283 27 6 245   1 1     1   2   154 129                 283
1931594 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001948 700 BELLE CREEK CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_6 27 4 45   0 0     0   1   41 36                       77 27 4 45   0 0     0   1   41 36                 77
1931624 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001729 1052 BROMLEY EAST CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_6 106 0 49   0 1     0   4   82 78                       160 106 0 49   0 1     0   4   82 78                 160
1931645 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006465 2945 FOUNDATIONS ACADEMY   Regular School Yes Elementary KG 08 2019   grade_6 54 0 31   0 0     0   4   45 44                       89 54 0 31   0 0     0   4   45 44                 89
1931664 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006325 4950 LANDMARK ACADEMY AT REUNION   Regular School Yes Elementary KG 08 2019   grade_6 52 2 24   0 2     0   2   40 42                       82 52 2 24   0 2     0   2   40 42                 82
1931694 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001377 6638 OVERLAND TRAIL MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 62 0 136   1 4     0   4   112 95                       207 62 0 136   1 4     0   4   112 95                 207
1931698 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006420 6702 OTHO E STUART MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 109 11 112   0 8     0   17   135 122                       257 109 11 112   0 8     0   17   135 122                 257
1931707 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006362 7131 PRAIRIE VIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 100 1 97   2 8     0   4   110 102                       212 100 1 97   2 8     0   4   110 102                 212
1931723 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006753 7351 RODGER QUIST MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 135 0 74   2 15     1   16   129 114                       243 135 0 74   2 15     1   16   129 114                 243
1931771 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000152 9230 VIKAN MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 75 1 124   1 1     0   5   109 98                       207 75 1 124   1 1     0   5   109 98                 207
1931793 CO     school 802430 50   BENNETT 29J 80243000093 774 BENNETT MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 55 2 27   2 0     0   7   48 45                       93 55 2 27   2 0     0   7   48 45                 93
1931814 CO     school 806750 60   STRASBURG 31J 80675001160 8332 HEMPHILL MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 55 1 18   3 1     1   1   44 36                       80 55 1 18   3 1     1   1   44 36                 80
1931869 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006567 4334 COLORADO STEM ACADEMY   Regular School No Elementary KG 08 2019   grade_6 19 1 29   1 1     0   2   32 21                       53 19 1 29   1 1     0   2   32 21                 53
1931882 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001241 5388 M. SCOTT CARPENTER MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 9 2 134   1 1     2   2   79 72                       151 9 2 134   1 1     2   2   79 72                 151
1931894 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006458 7305 IVER C. RANUM MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 19 5 192   3 5     2   5   124 107                       231 19 5 192   3 5     2   5   124 107                 231
1931906 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001244 7812 SHAW HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 31 6 133   1 10     0   6   96 91                       187 31 6 133   1 10     0   6   96 91                 187
1931947 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006675 9236 WESTMINSTER ACADEMY FOR INTERNATIONAL STUDIES   Regular School No Elementary PK 08 2019   grade_6 2 0 17   0 2     0   0   12 9                       21 2 0 17   0 2     0   0   12 9                 21
1931960 CO     school 802070 100   ALAMOSA RE-11J 80207000026 114 ORTEGA MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 53 0 111   2 2     0   0   84 84                       168 53 0 111   2 2     0   0   84 84                 168
1931979 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2019   grade_6 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1931995 CO     school 806420 110   SANGRE DE CRISTO RE-22J 80642001116 7630 SANGRE DE CRISTO UNDIVIDED HIGH SCHOOL   Regular School No High 06 12 2019   grade_6 23 0 5   4 0     0   0   19 13                       32 23 0 5   4 0     0   0   19 13                 32
1932010 CO     school 803780 120   ENGLEWOOD 1 80378000486 1514 CHARLES HAY WORLD SCHOOL   Regular School No Elementary KG 06 2019   grade_6 23 0 16   0 0     0   4   25 18                       43 23 0 16   0 0     0   4   25 18                 43
1932018 CO     school 803780 120   ENGLEWOOD 1 80378000488 1556 CHERRELYN ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_6 17 2 11   1 0     0   2   18 15                       33 17 2 11   1 0     0   2   18 15                 33
1932026 CO     school 803780 120   ENGLEWOOD 1 80378000489 1652 CLAYTON ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_6 23 1 20   1 0     0   1   31 15                       46 23 1 20   1 0     0   1   31 15                 46
1932034 CO     school 803780 120   ENGLEWOOD 1 80378001772 2750 ENGLEWOOD LEADERSHIP ACADEMY   Regular School No Middle 06 09 2019   grade_6 24 0 10   0 0     0   0   23 11                       34 24 0 10   0 0     0   0   23 11                 34
1932048 CO     school 803780 120   ENGLEWOOD 1 80378000497 9620 WM E BISHOP ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_6 3 0 20   0 0     0   3   11 15                       26 3 0 20   0 0     0   3   11 15                 26
1932058 CO     school 806540 123   SHERIDAN 2 80654001135 7837 FORT LOGAN NORTHGATE   Regular School No Middle 03 08 2019   grade_6 12 6 79   1 0     0   4   54 48                       102 12 6 79   1 0     0   4   54 48                 102
1932082 CO     school 802910 130   CHERRY CREEK 5 80291001711 18 LIBERTY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 208 28 65   4 42     1   26   200 174                       374 208 28 65   4 42     1   26   200 174                 374
1932094 CO     school 802910 130   CHERRY CREEK 5 80291001878 141 SKY VISTA MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 146 35 56   1 26     0   21   154 131                       285 146 35 56   1 26     0   21   154 131                 285
1932154 CO     school 802910 130   CHERRY CREEK 5 80291000763 1510 CHALLENGE SCHOOL   Regular School No Elementary PK 08 2019   grade_6 23 10 10   0 17     0   8   28 40                       68 23 10 10   0 17     0   8   28 40                 68
1932164 CO     school 802910 130   CHERRY CREEK 5 80291000185 1566 CAMPUS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 304 11 45   1 82     2   34   251 228                       479 304 11 45   1 82     2   34   251 228                 479
1932168 CO     school 802910 130   CHERRY CREEK 5 80291000207 1568 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 281 12 52   3 40     1   23   227 185                       412 281 12 52   3 40     1   23   227 185                 412
1932182 CO     school 802910 130   CHERRY CREEK 5 80291001152 1571 CHERRY CREEK CHARTER ACADEMY   Regular School Yes Elementary KG 08 2019   grade_6 39 9 4   0 22     0   3   37 40                       77 39 9 4   0 22     0   3   37 40                 77
1932254 CO     school 802910 130   CHERRY CREEK 5 80291001672 2897 FALCON CREEK MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 174 21 49   3 24     2   24   163 134                       297 174 21 49   3 24     2   24   163 134                 297
1932258 CO     school 802910 130   CHERRY CREEK 5 80291006367 3030 FOX RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 203 20 46   0 16     0   24   160 149                       309 203 20 46   0 16     0   24   160 149                 309
1932303 CO     school 802910 130   CHERRY CREEK 5 80291001328 4100 HORIZON MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 116 66 103   1 20     1   28   187 148                       335 116 66 103   1 20     1   28   187 148                 335
1932312 CO     school 802910 130   CHERRY CREEK 5 80291006676 4189 HERITAGE HEIGHTS ACADEMY   Regular School Yes Elementary KG 07 2019   grade_6 18 1 3   0 0     1   1   11 13                       24 18 1 3   0 0     1   1   11 13                 24
1932341 CO     school 802910 130   CHERRY CREEK 5 80291000197 4975 LAREDO MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 145 48 85   5 24     3   26   172 164                       336 145 48 85   5 24     3   26   172 164                 336
1932377 CO     school 802910 130   CHERRY CREEK 5 80291006563 6367 OPTIONS SCHOOL   Alternative School No Other KG 12 2019   grade_6 44 1 7   0 3     0   6   29 32                       61 44 1 7   0 3     0   6   29 32                 61
1932422 CO     school 802910 130   CHERRY CREEK 5 80291000201 7158 PRAIRIE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 105 141 206   5 30     6   36   291 238                       529 105 141 206   5 30     6   36   291 238                 529
1932441 CO     school 802910 130   CHERRY CREEK 5 80291006728 7514 INFINITY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 157 20 39   2 25     0   21   141 123                       264 157 20 39   2 25     0   21   141 123                 264
1932473 CO     school 802910 130   CHERRY CREEK 5 80291000034 8848 THUNDER RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 220 43 98   3 15     2   29   221 189                       410 220 43 98   3 15     2   29   221 189                 410
1932541 CO     school 805310 140   LITTLETON 6 80531000876 2804 EUCLID MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 203 3 54   0 2     0   13   143 132                       275 203 3 54   0 2     0   13   143 132                 275
1932552 CO     school 805310 140   LITTLETON 6 80531000879 3472 GODDARD MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 151 5 82   1 5     0   19   122 141                       263 151 5 82   1 5     0   19   122 141                 263
1932569 CO     school 805310 140   LITTLETON 6 80531000885 4316 NEWTON MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 161 4 25   0 3     0   12   109 96                       205 161 4 25   0 3     0   12   109 96                 205
1932573 CO     school 805310 140   LITTLETON 6 80531001351 4447 JOHN WESLEY POWELL MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 226 5 27   0 6     1   11   131 145                       276 226 5 27   0 6     1   11   131 145                 276
1932587 CO     school 805310 140   LITTLETON 6 80531001515 5229 LITTLETON ACADEMY   Regular School Yes Elementary KG 08 2019   grade_6 37 2 4   0 5     0   3   24 27                       51 37 2 4   0 5     0   3   24 27                 51
1932597 CO     school 805310 140   LITTLETON 6 80531001626 5233 LITTLETON PREP CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_6 43 3 15   0 3     0   1   29 36                       65 43 3 15   0 3     0   1   29 36                 65
1932676 CO     school 803270 170   DEER TRAIL 26J 80327000288 2140 DEER TRAIL JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 06 12 2019   grade_6 8 0 7   1 0     0   1   8 9                       17 8 0 7   1 0     0   1   8 9                 17
1932688 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_6 0 0 0   0 1     0   0   0 1                       1 0 0 0   0 1     0   0   0 1                 1
1932698 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   grade_6 10 16 59   1 1     0   6   36 57                       93 10 16 59   1 1     0   6   36 57                 93
1932710 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006399 213 AXL ACADEMY   Regular School Yes Elementary PK 08 2019   grade_6 9 16 19   0 1     1   3   30 19                       49 9 16 19   0 1     1   3   30 19                 49
1932737 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001759 458 AURORA ACADEMY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_6 14 26 24   0 4     0   0   35 33                       68 14 26 24   0 4     0   0   35 33                 68
1932742 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000054 464 AURORA HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 24 63 152   5 5     1   15   154 111                       265 24 63 152   5 5     1   15   154 111                 265
1932751 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234002009 465 AURORA FRONTIER K-8   Regular School No Elementary PK 08 2019   grade_6 22 7 25   0 8     0   5   39 28                       67 22 7 25   0 8     0   5   39 28                 67
1932762 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000055 914 BOSTON K-8 SCHOOL   Regular School No Elementary PK 08 2019   grade_6 3 5 34   0 3     0   2   23 24                       47 3 5 34   0 3     0   2   23 24                 47
1932786 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000057 1720 CLYDE MILLER K-8   Regular School No Elementary PK 08 2019   grade_6 7 6 47   0 2     0   6   35 33                       68 7 6 47   0 2     0   6   35 33                 68
1932792 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001322 1800 COLUMBIA MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 53 47 106   2 6     3   24   132 109                       241 53 47 106   2 6     3   24   132 109                 241
1932820 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000060 2384 EAST MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 8 35 229   5 7     1   5   148 142                       290 8 35 229   5 7     1   5   148 142                 290
1932837 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006644 2673 EDNA AND JOHN W. MOSLEY P-8   Regular School No Elementary PK 08 2019   grade_6 10 16 63   3 3     4   6   53 52                       105 10 16 63   3 3     4   6   53 52                 105
1932870 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes Elementary KG 08 2019   grade_6 17 20 72   0 2     1   6   65 53                       118 17 20 72   0 2     1   6   65 53                 118
1932929 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2019   grade_6 10 35 54   2 3     0   1   48 57                       105 10 35 54   2 3     0   1   48 57                 105
1932953 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000073 6160 MRACHEK MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 57 74 167   1 14     6   25   183 161                       344 57 74 167   1 14     6   25   183 161                 344
1932962 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001881 6189 MURPHY CREEK K-8 SCHOOL   Regular School No Elementary PK 08 2019   grade_6 33 14 33   0 5     0   8   41 52                       93 33 14 33   0 5     0   8   41 52                 93
1932968 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000074 6310 NORTH MIDDLE SCHOOL HEALTH SCIENCES AND TECHNOLOGY CAMPUS   Regular School No Middle 06 08 2019   grade_6 11 32 173   0 7     5   8   117 119                       236 11 32 173   0 7     5   8   117 119                 236
1932980 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001789 6546 OPTIONS SCHOOL   Regular School No Other KG 12 2019   grade_6 89 5 17   2 1     0   4   57 61                       118 89 5 17   2 1     0   4   57 61                 118
1933015 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001674 7232 AURORA QUEST K-8   Regular School No Elementary KG 08 2019   grade_6 39 13 17   0 12     1   8   34 56                       90 39 13 17   0 12     1   8   34 56                 90
1933055 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000079 8078 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 14 55 148   2 4     7   10   134 106                       240 14 55 148   2 4     7   10   134 106                 240
1933073 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006732 9053 VEGA COLLEGIATE ACADEMY   Regular School Yes Elementary KG 06 2019   grade_6 3 9 44   0 5     0   3   32 32                       64 3 9 44   0 5     0   3   32 32                 64
1933081 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006322 9056 VANGUARD CLASSICAL SCHOOL - WEST   Regular School Yes Elementary KG 08 2019   grade_6 6 3 32   0 0     0   2   25 18                       43 6 3 32   0 0     0   2   25 18                 43
1933107 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006483 9083 VISTA PEAK P-8 EXPLORATORY   Regular School No Elementary PK 08 2019   grade_6 32 12 59   0 6     0   13   66 56                       122 32 12 59   0 6     0   13   66 56                 122
1933134 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes Other KG 12 2019   grade_6 10 28 20   1 2     0   3   31 33                       64 10 28 20   1 2     0   3   31 33                 64
1933143 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000082 9396 AURORA WEST COLLEGE PREPARATORY ACADEMY   Regular School No High 06 12 2019   grade_6 14 22 152   1 23     0   7   112 107                       219 14 22 152   1 23     0   7   112 107                 219
1933169 CO     school 802700 190   BYERS 32J 80270000163 1168 BYERS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_6 39 0 4   0 0     0   1   19 25                       44 39 0 4   0 0     0   1   19 25                 44

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