Data source: Big Local News · About: Big Local

4,915 rows where grade = "grade_6" and state = "CO"

View and edit SQL

year

grade

  • grade_6 · 4,915
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
707846 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_6 5 1 50   0 1     0   0   35 22                       57 5 1 50   0 1     0   0   35 22                 57
707857 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_6 8 1 39   0 0     0   1   17 32                       49 8 1 39   0 0     0   1   17 32                 49
707871 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_6 8 1 40   1 5     0   2   29 28                       57 8 1 40   1 5     0   2   29 28                 57
707882 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2017   grade_6 6 0 17   1 1     0   0   10 15                       25 6 0 17   1 1     0   0   10 15                 25
707891 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   grade_6 5 0 46   0 5     0   1   31 26                       57 5 0 46   0 5     0   1   31 26                 57
707902 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_6 12 2 35   1 1     0   2   27 26                       53 12 2 35   1 1     0   2   27 26                 53
707911 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_6 5 1 46   2 0     0   2   34 22                       56 5 1 46   2 0     0   2   34 22                 56
707920 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2017   grade_6 11 0 39   0 2     0   1   27 26                       53 11 0 39   0 2     0   1   27 26                 53
707936 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_6 101 7 27   0 5     3   13   72 84                       156 101 7 27   0 5     3   13   72 84                 156
707944 CO     school 805550 10   MAPLETON 1 80555006672 3590 GLOBAL INTERMEDIATE ACADEMY   Regular School No Elementary 04 08 2017   grade_6 1 1 28   0 0     0   0   15 15                       30 1 1 28   0 0     0   0   15 15                 30
707961 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2017   grade_6 7 1 51   0 0     0   1   32 28                       60 7 1 51   0 0     0   1   32 28                 60
707974 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001726 57 ROCKY TOP MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 297 8 80   2 20     0   14   208 213                       421 297 8 80   2 20     0   14   208 213                 421
708014 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001620 1480 CENTURY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 212 4 87   5 11     3   12   172 162                       334 212 4 87   5 11     3   12   172 162                 334
708024 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690000728 1519 STARGATE CHARTER SCHOOL   Regular School Yes Other KG 10 2017   grade_6 102 0 10   1 27     0   10   81 69                       150 102 0 10   1 27     0   10   81 69                 150
708135 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001178 4172 HULSTROM OPTIONS K-8 SCHOOL   Regular School No Elementary KG 08 2017   grade_6 43 1 7   0 8     0   6   29 36                       65 43 1 7   0 8     0   6   29 36                 65
708140 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001179 4187 SILVER HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 155 8 189   2 16     0   14   187 197                       384 155 8 189   2 16     0   14   187 197                 384
708173 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001183 5814 THE INTERNATIONAL SCHOOL AT THORNTON MIDDLE   Regular School No Middle 06 08 2017   grade_6 34 9 242   2 5     0   6   147 151                       298 34 9 242   2 5     0   6   147 151                 298
708196 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001186 6342 SHADOW RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 143 5 125   1 23     0   10   163 144                       307 143 5 125   1 23     0   10   163 144                 307
708216 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001187 6398 NORTHGLENN MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 64 5 192   2 8     1   3   148 127                       275 64 5 192   2 8     1   3   148 127                 275
708232 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006507 6802 PROSPECT RIDGE ACADEMY   Regular School Yes Other KG 11 2017   grade_6 95 1 4   2 6     0   4   63 49                       112 95 1 4   2 6     0   4   63 49                 112
708244 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2017   grade_6 2 1 1   0 0     0   0   3 1                       4 2 1 1   0 0     0   0   3 1                 4
708285 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006468 8275 STEM LAB   Regular School No Elementary KG 08 2017   grade_6 37 0 9   1 4     0   2   31 22                       53 37 0 9   1 4     0   2   31 22                 53
708295 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006561 8310 STEM LAUNCH   Regular School No Elementary KG 08 2017   grade_6 40 2 125   2 7     0   2   99 79                       178 40 2 125   2 7     0   2   99 79                 178
708323 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006417 9431 WESTGATE CHARTER   Regular School Yes Other KG 12 2017   grade_6 33 1 7   0 1     0   1   20 23                       43 33 1 7   0 1     0   1   20 23                 43
708330 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001194 9444 WESTLAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 244 11 75   1 14     0   22   196 171                       367 244 11 75   1 14     0   22   196 171                 367
708351 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 33 8 235   2 0     0   6   154 130                       284 33 8 235   2 0     0   6   154 130                 284
708389 CO     school 801950 30   ADAMS COUNTY 14 80195000015 4516 KEARNEY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 27 6 209   0 2     0   3   122 125                       247 27 6 209   0 2     0   3   122 125                 247
708431 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001948 700 BELLE CREEK CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_6 30 1 36   0 1     0   5   31 42                       73 30 1 36   0 1     0   5   31 42                 73
708461 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001729 1052 BROMLEY EAST CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_6 95 1 62   0 0     1   3   74 88                       162 95 1 62   0 0     1   3   74 88                 162
708482 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006465 2945 FOUNDATIONS ACADEMY   Regular School Yes Elementary KG 08 2017   grade_6 58 1 33   0 0     0   0   42 50                       92 58 1 33   0 0     0   0   42 50                 92
708505 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006325 4950 LANDMARK ACADEMY AT REUNION   Regular School Yes Elementary KG 08 2017   grade_6 47 5 21   0 4     0   4   45 36                       81 47 5 21   0 4     0   4   45 36                 81
708535 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001377 6638 OVERLAND TRAIL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 62 2 116   1 4     0   8   98 95                       193 62 2 116   1 4     0   8   98 95                 193
708539 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006420 6702 OTHO E STUART MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 106 9 126   1 9     0   10   133 128                       261 106 9 126   1 9     0   10   133 128                 261
708548 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006362 7131 PRAIRIE VIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 140 6 132   0 9     0   9   157 139                       296 140 6 132   0 9     0   9   157 139                 296
708594 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000152 9230 VIKAN MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 59 3 129   0 1     0   3   96 99                       195 59 3 129   0 1     0   3   96 99                 195
708616 CO     school 802430 50   BENNETT 29J 80243000093 774 BENNETT MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 57 0 15   1 0     0   1   43 31                       74 57 0 15   1 0     0   1   43 31                 74
708637 CO     school 806750 60   STRASBURG 31J 80675001160 8332 HEMPHILL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 40 0 9   1 1     0   1   25 27                       52 40 0 9   1 1     0   1   25 27                 52
708690 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006567 4334 COLORADO STEM ACADEMY   Regular School No Elementary KG 08 2017   grade_6 26 0 41   0 3     0   1   38 33                       71 26 0 41   0 3     0   1   38 33                 71
708703 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001241 5388 M. SCOTT CARPENTER MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 14 0 124   1 2     0   0   73 68                       141 14 0 124   1 2     0   0   73 68                 141
708714 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006458 7305 IVER C. RANUM MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 22 3 184   1 8     1   3   103 119                       222 22 3 184   1 8     1   3   103 119                 222
708726 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001244 7812 SHAW HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 29 5 127   2 8     0   3   93 81                       174 29 5 127   2 8     0   3   93 81                 174
708767 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006675 9236 WESTMINSTER ACADEMY FOR INTERNATIONAL STUDIES   Regular School No Elementary PK 06 2017   grade_6 6 0 19   0 1     0   0   17 9                       26 6 0 19   0 1     0   0   17 9                 26
708776 CO     school 802070 100   ALAMOSA RE-11J 80207000026 114 ORTEGA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 61 1 115   1 3     0   2   88 95                       183 61 1 115   1 3     0   2   88 95                 183
708795 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No Other 06 12 2017   grade_6 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
708811 CO     school 806420 110   SANGRE DE CRISTO RE-22J 80642001116 7630 SANGRE DE CRISTO UNDIVIDED HIGH SCHOOL   Regular School No Other 06 12 2017   grade_6 16 0 5   1 0     0   0   12 10                       22 16 0 5   1 0     0   0   12 10                 22
708826 CO     school 803780 120   ENGLEWOOD 1 80378000486 1514 CHARLES HAY WORLD SCHOOL   Regular School No Elementary KG 06 2017   grade_6 23 1 18   0 0     0   3   23 22                       45 23 1 18   0 0     0   3   23 22                 45
708834 CO     school 803780 120   ENGLEWOOD 1 80378000488 1556 CHERRELYN ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2017   grade_6 19 1 5   0 0     0   0   16 9                       25 19 1 5   0 0     0   0   16 9                 25
708842 CO     school 803780 120   ENGLEWOOD 1 80378000489 1652 CLAYTON ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2017   grade_6 24 2 29   0 0     0   3   30 28                       58 24 2 29   0 0     0   3   30 28                 58
708850 CO     school 803780 120   ENGLEWOOD 1 80378001772 2750 ENGLEWOOD LEADERSHIP ACADEMY   Regular School No Other 06 09 2017   grade_6 16 0 7   0 1     0   0   15 9                       24 16 0 7   0 1     0   0   15 9                 24
708864 CO     school 803780 120   ENGLEWOOD 1 80378000497 9620 WM E BISHOP ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2017   grade_6 9 1 16   0 0     0   2   14 14                       28 9 1 16   0 0     0   2   14 14                 28
708874 CO     school 806540 123   SHERIDAN 2 80654001135 7837 FORT LOGAN NORTHGATE   Regular School No Elementary 03 08 2017   grade_6 13 2 77   0 1     0   5   46 52                       98 13 2 77   0 1     0   5   46 52                 98
708898 CO     school 802910 130   CHERRY CREEK 5 80291001711 18 LIBERTY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 222 32 62   5 41     0   25   209 178                       387 222 32 62   5 41     0   25   209 178                 387
708902 CO     school 802910 130   CHERRY CREEK 5 80291001878 141 SKY VISTA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 140 24 48   2 28     0   21   130 133                       263 140 24 48   2 28     0   21   130 133                 263
708962 CO     school 802910 130   CHERRY CREEK 5 80291000763 1510 CHALLENGE SCHOOL   Regular School No Elementary PK 08 2017   grade_6 36 9 6   0 19     0   3   40 33                       73 36 9 6   0 19     0   3   40 33                 73
708972 CO     school 802910 130   CHERRY CREEK 5 80291000185 1566 CAMPUS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 275 16 43   0 75     2   28   230 209                       439 275 16 43   0 75     2   28   230 209                 439
708976 CO     school 802910 130   CHERRY CREEK 5 80291000207 1568 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 314 5 78   3 25     1   17   209 234                       443 314 5 78   3 25     1   17   209 234                 443
708990 CO     school 802910 130   CHERRY CREEK 5 80291001152 1571 CHERRY CREEK CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_6 54 5 4   0 14     0   1   32 46                       78 54 5 4   0 14     0   1   32 46                 78
709062 CO     school 802910 130   CHERRY CREEK 5 80291001672 2897 FALCON CREEK MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 187 21 43   3 34     1   20   147 162                       309 187 21 43   3 34     1   20   147 162                 309
709066 CO     school 802910 130   CHERRY CREEK 5 80291006367 3030 FOX RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 344 36 50   3 36     0   20   245 244                       489 344 36 50   3 36     0   20   245 244                 489
709112 CO     school 802910 130   CHERRY CREEK 5 80291001328 4100 HORIZON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 129 58 88   5 13     1   19   171 142                       313 129 58 88   5 13     1   19   171 142                 313
709148 CO     school 802910 130   CHERRY CREEK 5 80291000197 4975 LAREDO MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 190 55 78   3 23     3   24   180 196                       376 190 55 78   3 23     3   24   180 196                 376
709184 CO     school 802910 130   CHERRY CREEK 5 80291006563 6367 OPTIONS SCHOOL   Alternative School No Other KG 12 2017   grade_6 40 2 2   0 0     1   3   22 26                       48 40 2 2   0 0     1   3   22 26                 48
709229 CO     school 802910 130   CHERRY CREEK 5 80291000201 7158 PRAIRIE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 121 150 228   4 27     3   35   302 266                       568 121 150 228   4 27     3   35   302 266                 568
709276 CO     school 802910 130   CHERRY CREEK 5 80291000034 8848 THUNDER RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 227 46 78   4 37     1   22   223 192                       415 227 46 78   4 37     1   22   223 192                 415
709344 CO     school 805310 140   LITTLETON 6 80531000876 2804 EUCLID MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 173 3 53   2 7     4   8   118 132                       250 173 3 53   2 7     4   8   118 132                 250
709355 CO     school 805310 140   LITTLETON 6 80531000879 3472 GODDARD MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 140 5 84   0 4     0   12   134 111                       245 140 5 84   0 4     0   12   134 111                 245
709372 CO     school 805310 140   LITTLETON 6 80531000885 4316 NEWTON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 162 5 16   1 3     0   16   106 97                       203 162 5 16   1 3     0   16   106 97                 203
709376 CO     school 805310 140   LITTLETON 6 80531001351 4447 JOHN WESLEY POWELL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 262 3 24   2 11     0   17   180 139                       319 262 3 24   2 11     0   17   180 139                 319
709390 CO     school 805310 140   LITTLETON 6 80531001515 5229 LITTLETON ACADEMY   Regular School Yes Elementary KG 08 2017   grade_6 36 2 4   0 8     0   2   31 21                       52 36 2 4   0 8     0   2   31 21                 52
709400 CO     school 805310 140   LITTLETON 6 80531001626 5233 LITTLETON PREP CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_6 40 1 19   0 3     0   2   29 36                       65 40 1 19   0 3     0   2   29 36                 65
709479 CO     school 803270 170   DEER TRAIL 26J 80327000288 2140 DEER TRAIL JUNIOR-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_6 8 0 2   0 0     0   0   6 4                       10 8 0 2   0 0     0   0   6 4                 10
709491 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_6 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
709501 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006399 213 AXL ACADEMY   Regular School Yes Elementary PK 08 2017   grade_6 16 13 27   0 0     0   3   30 29                       59 16 13 27   0 0     0   3   30 29                 59
709533 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001759 458 AURORA ACADEMY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_6 13 20 17   0 0     0   1   21 30                       51 13 20 17   0 0     0   1   21 30                 51
709538 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000054 464 AURORA HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 32 76 154   0 12     0   20   156 138                       294 32 76 154   0 12     0   20   156 138                 294
709547 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234002009 465 AURORA FRONTIER K-8   Regular School No Elementary PK 08 2017   grade_6 21 9 19   0 12     0   10   39 32                       71 21 9 19   0 12     0   10   39 32                 71
709558 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000055 914 BOSTON K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_6 1 6 25   0 3     0   1   15 21                       36 1 6 25   0 3     0   1   15 21                 36
709582 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000057 1720 CLYDE MILLER K-8   Regular School No Elementary PK 08 2017   grade_6 9 9 44   0 3     0   3   44 24                       68 9 9 44   0 3     0   3   44 24                 68
709588 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001322 1800 COLUMBIA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 82 49 91   0 13     0   27   135 127                       262 82 49 91   0 13     0   27   135 127                 262
709616 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000060 2384 EAST MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 27 37 243   3 14     3   9   184 152                       336 27 37 243   3 14     3   9   184 152                 336
709632 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006644 2673 EDNA AND JOHN W. MOSLEY P-8   Regular School No Elementary PK 08 2017   grade_6 9 14 59   2 2     1   6   52 41                       93 9 14 59   2 2     1   6   52 41                 93
709665 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes Elementary KG 08 2017   grade_6 13 15 69   1 6     0   3   68 39                       107 13 15 69   1 6     0   3   68 39                 107
709724 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2017   grade_6 17 36 43   0 3     1   0   45 55                       100 17 36 43   0 3     1   0   45 55                 100
709748 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000073 6160 MRACHEK MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 52 58 143   0 13     6   19   148 143                       291 52 58 143   0 13     6   19   148 143                 291
709757 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001881 6189 MURPHY CREEK K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_6 12 12 23   0 4     0   10   34 27                       61 12 12 23   0 4     0   10   34 27                 61
709763 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000074 6310 NORTH MIDDLE SCHOOL HEALTH SCIENCES AND TECHNOLOGY CAMPUS   Regular School No Middle 06 08 2017   grade_6 11 23 210   4 12     3   5   124 144                       268 11 23 210   4 12     3   5   124 144                 268
709775 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001789 6546 OPTIONS SCHOOL   Regular School No Other KG 12 2017   grade_6 69 1 14   0 2     0   4   38 52                       90 69 1 14   0 2     0   4   38 52                 90
709810 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001674 7232 AURORA QUEST K-8   Regular School No Elementary KG 08 2017   grade_6 38 8 23   0 11     0   5   41 44                       85 38 8 23   0 11     0   5   41 44                 85
709846 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000079 8078 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 14 51 177   4 12     3   10   141 130                       271 14 51 177   4 12     3   10   141 130                 271
709867 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006322 9056 VANGUARD CLASSICAL SCHOOL - WEST   Regular School Yes Elementary KG 08 2017   grade_6 7 5 32   0 1     0   2   18 29                       47 7 5 32   0 1     0   2   18 29                 47
709893 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006483 9083 VISTA PEAK P-8 EXPLORATORY   Regular School No Elementary PK 08 2017   grade_6 30 10 47   1 3     0   7   47 51                       98 30 10 47   1 3     0   7   47 51                 98
709920 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes Other KG 12 2017   grade_6 20 16 19   0 1     0   4   23 37                       60 20 16 19   0 1     0   4   23 37                 60
709929 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000082 9396 AURORA WEST COLLEGE PREPARATORY ACADEMY   Regular School No Other 06 12 2017   grade_6 16 30 191   1 40     0   6   142 142                       284 16 30 191   1 40     0   6   142 142                 284
709955 CO     school 802700 190   BYERS 32J 80270000163 1168 BYERS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_6 37 0 7   1 0     0   2   26 21                       47 37 0 7   1 0     0   2   26 21                 47
709979 CO     school 802700 190   BYERS 32J 80270006605 2356 ELEVATE ACADEMY   Regular School Yes Other KG 12 2017   grade_6 11 4 95   5 0     0   0   64 51                       115 11 4 95   5 0     0   0   64 51                 115
709993 CO     school 802700 190   BYERS 32J 80270006548 3362 VALIANT ACADEMY   Regular School No Other KG 12 2017   grade_6 13 1 4   0 0     0   0   13 5                       18 13 1 4   0 0     0   0   13 5                 18
710004 CO     school 802700 190   BYERS 32J 80270006630 6241 COLORADO DIGITAL ACADEMY - ELEMENTARY   Regular School Yes Elementary KG 06 2017   grade_6 65 4 6   0 1     0   0   42 34                       76 65 4 6   0 1     0   0   42 34                 76
710018 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000040 6657 PAGOSA SPRINGS MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_6 27 1 97   4 0     1   1   69 62                       131 27 1 97   4 0     1   1   69 62                 131
710032 CO     school 807110 230   WALSH RE-1 80711001215 9222 WALSH ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_6 4 0 1   0 0     0   0   1 4                       5 4 0 1   0 0     0   0   1 4                 5
710050 CO     school 806090 240   PRITCHETT RE-3 80609001952 7176 PRITCHETT MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 3 0 1   0 0     0   0   3 1                       4 3 0 1   0 0     0   0   3 1                 4

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