Data source: Big Local News · About: Big Local

13,072 rows where state = "CO" and year = 2016 sorted by black descending

View and edit SQL

year

  • 2016 · 13,072
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
836693 CO     school 802910 130   CHERRY CREEK 5 80291006156 2357 EAGLECREST HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_10 355 99 138   5 39     3   46   357 328                       685 355 99 138   5 39     3   46   357 328                 685
837271 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000061 2618 ELKHART ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   pk_12_total 28 99 471   3 15     2   18   327 309                       636 28 99 471   3 15     2   18   327 309                 636
837303 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000063 3354 GATEWAY HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 54 99 205   6 10     3   18   207 188                       395 54 99 205   6 10     3   18   207 188                 395
837360 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000069 4973 LAREDO ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   pk_12_total 49 99 316   3 21     5   20   279 234                       513 49 99 316   3 21     5   20   279 234                 513
836616 CO     school 802910 130   CHERRY CREEK 5 80291001951 1551 CHEROKEE TRAIL HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_12 385 98 93   4 58     6   26   336 334                       670 385 98 93   4 58     6   26   336 334                 670
836694 CO     school 802910 130   CHERRY CREEK 5 80291006156 2357 EAGLECREST HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_11 317 98 132   1 31     3   42   323 301                       624 317 98 132   1 31     3   42   323 301                 624
837514 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006322 9056 VANGUARD CLASSICAL SCHOOL - WEST   Regular School Yes 1.0 KG 08 2016   pk_12_total 86 98 287   1 5     0   17   242 252                       494 86 98 287   1 5     0   17   242 252                 494
839565 CO     school 803360 880   DENVER COUNTY 1 80336000365 4074 HOLM ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   pk_12_total 85 98 272   6 23     0   28   251 261                       512 85 98 272   6 23     0   28   251 261                 512
841390 CO     school 804530 980   HARRISON 2 80453000669 6686 PANORAMA MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   pk_12_total 105 98 228   10 22     5   17   254 231                       485 105 98 228   10 22     5   17   254 231                 485
841614 CO     school 804080 1000   FOUNTAIN 8 80408006481 9610 WEIKEL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   pk_12_total 415 98 163   2 12     5   72   410 357                       767 415 98 163   2 12     5   72   410 357                 767
836572 CO     school   130   CHERRY CREEK 5   348 ARROWHEAD ELEMENTARY SCHOOL             2016   pk_12_total 313 97 152   4 35     2   53   343 313                       656 313 97 152   4 35     2   53   343 313                 656
836865 CO     school 802910 130   CHERRY CREEK 5 80291000199 7102 POLTON COMMUNITY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   pk_12_total 229 97 110   1 42     2   56   288 249                       537 229 97 110   1 42     2   56   288 249                 537
837317 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000064 4024 HINKLEY HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_12 62 97 394   4 23     6   16   302 300                       602 62 97 394   4 23     6   16   302 300                 602
837243 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000058 1948 CRAWFORD ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   pk_12_total 26 96 374   5 162     0   5   359 309                       668 26 96 374   5 162     0   5   359 309                 668
837301 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000063 3354 GATEWAY HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_11 53 96 222   5 11     5   13   205 200                       405 53 96 222   5 11     5   13   205 200                 405
836695 CO     school 802910 130   CHERRY CREEK 5 80291006156 2357 EAGLECREST HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_12 321 95 131   4 41     1   26   338 281                       619 321 95 131   4 41     1   26   338 281                 619
836902 CO     school 802910 130   CHERRY CREEK 5 80291000203 8020 SMOKY HILL HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_11 240 95 116   5 42     3   25   241 285                       526 240 95 116   5 42     3   25   241 285                 526
840291 CO     school 803360 880   DENVER COUNTY 1 80336001637 9739 WYATT ACADEMY   Regular School Yes 1.0 KG 08 2016   pk_12_total 8 95 395   2 0     0   13   263 250                       513 8 95 395   2 0     0   13   263 250                 513
841463 CO     school 806480 990   WIDEFIELD 3 80648001120 4394 JANITELL JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2016   pk_12_total 336 95 207   5 10     8   66   402 325                       727 336 95 207   5 10     8   66   402 325                 727
841775 CO     school 803060 1010   COLORADO SPRINGS 11 80306000239 3890 HUNT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   pk_12_total 115 95 135   9 3     1   36   215 179                       394 115 95 135   9 3     1   36   215 179                 394
842600 CO     school 803870 1110   FALCON 49 80387001799 7960 SKYVIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   pk_12_total 686 95 271   10 44     8   73   633 554                       1187 686 95 271   10 44     8   73   633 554                 1187
836631 CO     school 802910 130   CHERRY CREEK 5 80291000186 1570 CHERRY CREEK HIGH SCHOOL   Regular School No 3.0 09 12 2016   pk_12_total 2395 94 390   16 437     7   160   1770 1729                       3499 2395 94 390   16 437     7   160   1770 1729                 3499
839787 CO     school 803360 880   DENVER COUNTY 1 80336006562 5897 MCAULIFFE INTERNATIONAL SCHOOL   Regular School No 2.0 06 08 2016   pk_12_total 516 94 126   4 21     3   61   430 395                       825 516 94 126   4 21     3   61   430 395                 825
836696 CO     school 802910 130   CHERRY CREEK 5 80291006156 2357 EAGLECREST HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 357 93 127   4 37     2   50   365 305                       670 357 93 127   4 37     2   50   365 305                 670
839501 CO     school 803360 880   DENVER COUNTY 1 80336006477 3655 GREENLEE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   pk_12_total 29 93 214   8 5     0   9   197 161                       358 29 93 214   8 5     0   9   197 161                 358
840052 CO     school 803360 880   DENVER COUNTY 1 80336000408 8086 SOUTH HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_11 86 93 97   6 27     0   8   156 161                       317 86 93 97   6 27     0   8   156 161                 317
836547 CO     school   130   CHERRY CREEK 5   18 LIBERTY MIDDLE SCHOOL             2016   pk_12_total 651 91 175   5 128     2   69   550 571                       1121 651 91 175   5 128     2   69   550 571                 1121
836901 CO     school 802910 130   CHERRY CREEK 5 80291000203 8020 SMOKY HILL HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_10 229 91 124   1 47     2   27   272 249                       521 229 91 124   1 47     2   27   272 249                 521
839283 CO     school 803360 880   DENVER COUNTY 1 80336006521 2205 DCIS AT FORD   Regular School No 1.0 PK 05 2016   pk_12_total 21 91 382   0 0     2   4   279 221                       500 21 91 382   0 0     2   4   279 221                 500
839853 CO     school 803360 880   DENVER COUNTY 1 80336001869 6350 BRUCE RANDOLPH SCHOOL   Regular School No 4.0 06 12 2016   pk_12_total 10 91 699   8 3     0   13   411 413                       824 10 91 699   8 3     0   13   411 413                 824
841296 CO     school 804530 980   HARRISON 2 80453000662 1306 CARMEL MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   pk_12_total 83 91 229   5 8     2   25   235 208                       443 83 91 229   5 8     2   25   235 208                 443
837553 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000081 9140 VIRGINIA COURT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   pk_12_total 51 90 375   5 11     2   16   299 251                       550 51 90 375   5 11     2   16   299 251                 550
839374 CO     school 803360 880   DENVER COUNTY 1 80336006527 2757 HIGH TECH EARLY COLLEGE   Regular School No 3.0 09 12 2016   pk_12_total 25 90 381   1 12     7   13   288 241                       529 25 90 381   1 12     7   13   288 241                 529
835556 CO     school   10   MAPLETON 1   503 YORK INTERNATIONAL             2016   pk_12_total 116 9 565   2 25     0   17   364 370                       734 116 9 565   2 25     0   17   364 370                 734
835614 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No 4.0 KG 12 2016   grade_7 171 9 48   2 5     0   14   124 125                       249 171 9 48   2 5     0   14   124 125                 249
835668 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   301 ARAPAHOE RIDGE ELEMENTARY SCHOOL             2016   pk_12_total 376 9 192   2 23     2   30   341 293                       634 376 9 192   2 23     2   30   341 293                 634
835748 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001401 2578 SKYVIEW ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   pk_12_total 253 9 205   6 13     1   15   268 234                       502 253 9 205   6 13     1   15   268 234                 502
835798 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001491 4108 HORIZON HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_12 312 9 128   3 40     1   5   260 238                       498 312 9 128   3 40     1   5   260 238                 498
835810 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001178 4172 HULSTROM OPTIONS K-8 SCHOOL   Regular School No 1.0 KG 08 2016   pk_12_total 441 9 85   1 110     5   37   334 354                       688 441 9 85   1 110     5   37   334 354                 688
835812 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001179 4187 SILVER HILLS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 166 9 166   4 24     0   5   199 175                       374 166 9 166   4 24     0   5   199 175                 374
835813 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001179 4187 SILVER HILLS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 174 9 155   3 24     0   6   197 174                       371 174 9 155   3 24     0   6   197 174                 371
835817 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001784 5043 LEGACY HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_12 339 9 91   4 49     3   6   263 238                       501 339 9 91   4 49     3   6   263 238                 501
835833 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001181 5418 MALLEY DRIVE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   pk_12_total 174 9 254   7 8     1   15   242 226                       468 174 9 254   7 8     1   15   242 226                 468
835887 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001188 6402 NORTHGLENN HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_12 104 9 170   1 18     1   2   154 151                       305 104 9 170   1 18     1   2   154 151                 305
835961 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006561 8310 STEM LAUNCH   Regular School No 1.0 KG 08 2016   pk_12_total 204 9 593   5 31     0   10   462 390                       852 204 9 593   5 31     0   10   462 390                 852
836020 CO     school   30   ADAMS COUNTY 14   24 ADAMS CITY HIGH SCHOOL             2016   grade_12 44 9 332   1 1     0   4   199 192                       391 44 9 332   1 1     0   4   199 192                 391
836046 CO     school 801950 30   ADAMS COUNTY 14 80195000013 2308 DUPONT ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   pk_12_total 83 9 527   7 3     0   13   346 296                       642 83 9 527   7 3     0   13   346 296                 642
836048 CO     school 801950 30   ADAMS COUNTY 14 80195000015 4516 KEARNEY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 29 9 239   1 0     0   1   151 128                       279 29 9 239   1 0     0   1   151 128                 279
836144 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006465 2945 FOUNDATIONS ACADEMY   Regular School Yes 1.0 KG 08 2016   pk_12_total 532 9 185   1 7     2   15   375 376                       751 532 9 185   1 7     2   15   375 376                 751
836421 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001254 9466 WESTMINSTER HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 97 9 502   4 42     2   9   341 324                       665 97 9 502   4 42     2   9   341 324                 665
836491 CO     school 803780 120   ENGLEWOOD 1 80378000491 2746 ENGLEWOOD HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_10 63 9 64   0 1     0   6   86 57                       143 63 9 64   0 1     0   6   86 57                 143
836559 CO     school   130   CHERRY CREEK 5   243 COYOTE HILLS ELEMENTARY SCHOOL             2016   grade_1 66 9 15   0 11     0   7   57 51                       108 66 9 15   0 11     0   7   57 51                 108
836561 CO     school   130   CHERRY CREEK 5   243 COYOTE HILLS ELEMENTARY SCHOOL             2016   grade_3 82 9 15   0 9     1   11   65 62                       127 82 9 15   0 9     1   11   65 62                 127
836594 CO     school 802910 130   CHERRY CREEK 5 80291006301 1155 BUFFALO TRAIL ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_5 76 9 6   0 9     0   7   53 54                       107 76 9 6   0 9     0   7   53 54                 107
836605 CO     school 802910 130   CHERRY CREEK 5 80291000763 1510 CHALLENGE SCHOOL   Regular School No 1.0 PK 08 2016   grade_2 21 9 4   1 12     0   4   26 25                       51 21 9 4   1 12     0   4   26 25                 51
836625 CO     school 802910 130   CHERRY CREEK 5 80291000207 1568 WEST MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 325 9 50   1 26     0   14   221 204                       425 325 9 50   1 26     0   14   221 204                 425
836731 CO     school 802910 130   CHERRY CREEK 5 80291000192 3648 GREENWOOD ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   pk_12_total 364 9 35   0 15     1   18   232 210                       442 364 9 35   0 15     1   18   232 210                 442
836796 CO     school 802910 130   CHERRY CREEK 5 80291001329 5744 MEADOW POINT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 30 9 32   1 3     1   3   36 43                       79 30 9 32   1 3     1   3   36 43                 79
836800 CO     school 802910 130   CHERRY CREEK 5 80291001329 5744 MEADOW POINT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_5 36 9 22   0 7     1   8   48 35                       83 36 9 22   0 7     1   8   48 35                 83
836809 CO     school 802910 130   CHERRY CREEK 5 80291000198 5934 MISSION VIEJO ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 40 9 21   1 3     2   8   39 45                       84 40 9 21   1 3     2   8   39 45                 84
836879 CO     school 802910 130   CHERRY CREEK 5 80291001880 7277 RED HAWK RIDGE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 40 9 21   0 17     0   15   53 49                       102 40 9 21   0 17     0   15   53 49                 102
836938 CO     school 802910 130   CHERRY CREEK 5 80291001330 8887 TRAILS WEST ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_5 63 9 8   1 3     0   5   44 45                       89 63 9 8   1 3     0   5   44 45                 89
837000 CO     school 805310 140   LITTLETON 6 80531000877 2926 FIELD ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   pk_12_total 95 9 206   5 8     0   16   181 158                       339 95 9 206   5 8     0   16   181 158                 339
837021 CO     school 805310 140   LITTLETON 6 80531000885 4316 NEWTON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   pk_12_total 482 9 59   3 30     0   24   299 308                       607 482 9 59   3 30     0   24   299 308                 607
837027 CO     school 805310 140   LITTLETON 6 80531000884 5224 LITTLETON HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_11 183 9 98   4 11     1   21   152 175                       327 183 9 98   4 11     1   21   152 175                 327
837156 CO     school   180   ADAMS-ARAPAHOE 28J   214 ALTURA ELEMENTARY SCHOOL             2016   grade_4 14 9 82   1 4     1   3   61 53                       114 14 9 82   1 4     1   3   61 53                 114
837158 CO     school   180   ADAMS-ARAPAHOE 28J   214 ALTURA ELEMENTARY SCHOOL             2016   kindergarten_full_day 5 9 52   0 4     0   1   34 37                       71 5 9 52   0 4     0   1   34 37                 71
837188 CO     school   180   ADAMS-ARAPAHOE 28J   465 AURORA FRONTIER K-8             2016   grade_1 34 9 12   0 11     0   5   37 34                       71 34 9 12   0 11     0   5   37 34                 71
837190 CO     school   180   ADAMS-ARAPAHOE 28J   465 AURORA FRONTIER K-8             2016   grade_3 23 9 19   0 11     0   6   47 21                       68 23 9 19   0 11     0   6   47 21                 68
837201 CO     school   180   ADAMS-ARAPAHOE 28J   914 BOSTON K-8 SCHOOL             2016   grade_3 0 9 28   0 5     0   1   18 25                       43 0 9 28   0 5     0   1   18 25                 43
837224 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000057 1720 CLYDE MILLER K-8   Regular School No 1.0 PK 08 2016   grade_3 10 9 50   0 2     0   6   41 36                       77 10 9 50   0 2     0   6   41 36                 77
837225 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000057 1720 CLYDE MILLER K-8   Regular School No 1.0 PK 08 2016   grade_4 7 9 33   0 0     0   5   21 33                       54 7 9 33   0 0     0   5   21 33                 54
837253 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000059 2114 DARTMOUTH ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 25 9 28   0 4     0   2   33 35                       68 25 9 28   0 4     0   2   33 35                 68
837338 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000067 4646 KENTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 4 9 71   0 8     0   7   48 51                       99 4 9 71   0 8     0   7   48 51                 99
837353 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000068 4970 LANSING ELEMENTARY COMMUNITY SCHOOL   Regular School No 1.0 PK 05 2016   pre_kindergarten 8 9 22   0 1     0   0   22 18                       40 8 9 22   0 1     0   0   22 18                 40
837389 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000072 6068 MONTVIEW MATH & HEALTH SCIENCES ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_5 4 9 67   0 0     1   1   37 45                       82 4 9 67   0 0     1   1   37 45                 82
837397 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001881 6189 MURPHY CREEK K-8 SCHOOL   Regular School No 1.0 PK 08 2016   grade_1 39 9 29   0 3     1   5   48 38                       86 39 9 29   0 3     1   5   48 38                 86
837400 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001881 6189 MURPHY CREEK K-8 SCHOOL   Regular School No 1.0 PK 08 2016   grade_4 21 9 18   1 1     1   3   35 19                       54 21 9 18   1 1     1   3   35 19                 54
837403 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001881 6189 MURPHY CREEK K-8 SCHOOL   Regular School No 1.0 PK 08 2016   grade_7 26 9 28   0 4     0   12   38 41                       79 26 9 28   0 4     0   12   38 41                 79
837431 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000075 6728 PARIS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_full_day 1 9 46   0 3     0   1   33 27                       60 1 9 46   0 3     0   1   33 27                 60
837442 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001927 6869 PEORIA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 2 9 75   1 4     1   0   50 42                       92 2 9 75   1 4     1   0   50 42                 92
837456 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001674 7232 AURORA QUEST K-8   Regular School No 1.0 KG 08 2016   grade_7 36 9 20   0 13     1   8   46 41                       87 36 9 20   0 13     1   8   46 41                 87
837472 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000077 7558 SABLE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   pre_kindergarten 1 9 15   0 1     0   1   12 15                       27 1 9 15   0 1     0   1   12 15                 27
837517 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001294 9059 VASSAR ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_3 17 9 37   2 2     1   7   36 39                       75 17 9 37   2 2     1   7   36 39                 75
837547 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000081 9140 VIRGINIA COURT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 4 9 62   0 1     0   3   42 37                       79 4 9 62   0 1     0   3   42 37                 79
837625 CO     school 802700 190   BYERS 32J 80270006605 2356 ELEVATE ACADEMY   Regular School Yes 4.0 KG 12 2016   kindergarten_full_day 4 9 92   1 0     1   0   63 44                       107 4 9 92   1 0     1   0   63 44                 107
837833 CO     school   470   ST VRAIN VALLEY RE 1J   226 ALTONA MIDDLE SCHOOL             2016   grade_6 209 9 26   0 27     0   9   133 147                       280 209 9 26   0 27     0   9   133 147                 280
837908 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001675 2343 EAGLE CREST ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   pk_12_total 382 9 131   3 67     1   20   315 298                       613 382 9 131   3 67     1   20   315 298                 613
838096 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000918 6276 NIWOT HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 176 9 77   2 31     2   9   139 167                       306 176 9 77   2 31     2   9   139 167                 306
838475 CO     school 802490 480   BOULDER VALLEY RE 2 80249001632 5999 MONARCH HIGH SCHOOL   Regular School No 3.0 09 12 2016   pk_12_total 1394 9 167   2 91     4   90   942 815                       1757 1394 9 167   2 91     4   90   942 815                 1757
838554 CO     school 802490 480   BOULDER VALLEY RE 2 80249001365 7528 RYAN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   pk_12_total 290 9 87   1 20     0   20   235 192                       427 290 9 87   1 20     0   20   235 192                 427
838951 CO     school   880   DENVER COUNTY 1   10 ABRAHAM LINCOLN HIGH SCHOOL             2016   grade_10 8 9 331   3 17     0   1   210 159                       369 8 9 331   3 17     0   1   210 159                 369
838969 CO     school   880   DENVER COUNTY 1   99 ACADEMY 360             2016   grade_4 4 9 3   1 0     0   1   12 6                       18 4 9 3   1 0     0   1   12 6                 18
838980 CO     school   880   DENVER COUNTY 1   220 AMESSE ELEMENTARY SCHOOL             2016   pre_kindergarten 1 9 59   0 1     0   0   38 32                       70 1 9 59   0 1     0   0   38 32                 70
839074 CO     school 803360 880   DENVER COUNTY 1 80336000322 1319 CEC MIDDLE COLLEGE OF DENVER   Vocational Education School No 3.0 09 12 2016   pk_12_total 22 9 383   5 13     0   1   216 217                       433 22 9 383   5 13     0   1   216 217                 433
839104 CO     school 803360 880   DENVER COUNTY 1 80336006583 1489 COMPASSION ROAD ACADEMY   Regular School No 3.0 09 12 2016   grade_12 5 9 14   0 1     0   0   16 13                       29 5 9 14   0 1     0   0   16 13                 29
839108 CO     school 803360 880   DENVER COUNTY 1 80336000325 1528 CHELTENHAM ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 2 9 59   0 0     0   5   36 39                       75 2 9 59   0 0     0   5   36 39                 75
839192 CO     school 803360 880   DENVER COUNTY 1 80336006453 2125 DENVER GREEN SCHOOL   Regular School No 1.0 PK 08 2016   grade_2 22 9 11   0 6     3   8   33 26                       59 22 9 11   0 6     3   8   33 26                 59
839197 CO     school 803360 880   DENVER COUNTY 1 80336006453 2125 DENVER GREEN SCHOOL   Regular School No 1.0 PK 08 2016   grade_7 25 9 17   1 1     0   3   26 30                       56 25 9 17   1 1     0   3   26 30                 56
839202 CO     school 803360 880   DENVER COUNTY 1 80336006482 2127 DENVER LANGUAGE SCHOOL   Regular School Yes 1.0 KG 07 2016   grade_1 57 9 19   0 2     0   11   48 50                       98 57 9 19   0 2     0   11   48 50                 98

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