Data source: Big Local News · About: Big Local

92,494 rows where state = "CO" sorted by black descending

View and edit SQL

grade

year

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
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
1739741 CO     school 802910 130   Cherry Creek 5 80291000203 8020 Smoky Hill High School   Regular School No High 09 12 2021   grade_11 197 94 136   3 36     1   31   264 234                       498 197 94 136   3 36     1   31   264 234                 498
1740368 CO     school 802340 180   Adams-Arapahoe 28J 80234001324 8858 Tollgate Elementary School of Expeditionary Learning   Regular School No Elementary KG 05 2021   pk_12_total 63 94 263   1 13     13   32   235 244                       479 63 94 263   1 13     13   32   235 244                 479
1800491 CO     school 802910 130   Cherry Creek 5 80291000763 1510 Challenge School   Regular School No Elementary PK 08 2020   pk_12_total 210 94 58   1 109     1   55   256 272                       528 210 94 58   1 109     1   55   256 272                 528
1895018 CO     school 802910 130   CHERRY CREEK 5 80291000196 4276 INDEPENDENCE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   pk_12_total 211 94 124   4 16     0   55   264 240                       504 211 94 124   4 16     0   55   264 240                 504
1895149 CO     school 802910 130   CHERRY CREEK 5 80291000203 8020 SMOKY HILL HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 262 94 121   6 37     6   38   286 278                       564 262 94 121   6 37     6   38   286 278                 564
1897401 CO     school 803360 880   DENVER COUNTY 1 80336006364 1785 COLE ARTS AND SCIENCE ACADEMY   Regular School No Elementary PK 05 2018   pk_12_total 43 94 319   1 2     0   18   238 239                       477 43 94 319   1 2     0   18   238 239                 477
1932971 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000074 6310 NORTH MIDDLE SCHOOL HEALTH SCIENCES AND TECHNOLOGY CAMPUS   Regular School No Middle 06 08 2019   pk_12_total 28 94 543   9 24     9   20   360 367                       727 28 94 543   9 24     9   20   360 367                 727
1934914 CO     school 803360 880   DENVER COUNTY 1 80336006624 2227 DENVER DISCOVERY SCHOOL   Regular School No Middle 06 08 2019   pk_12_total 66 94 78   2 4     2   18   129 135                       264 66 94 78   2 4     2   18   129 135                 264
1134355 CO     school 802910 130   CHERRY CREEK 5 80291000186 1570 CHERRY CREEK HIGH SCHOOL   Regular School No 3.0 09 12 2015   pk_12_total 2459.0 93.0 400.0   12.0 410.0     8.0   124.0   1782.0 1724.0                       3506.0 2459 93 400   12 410     8   124   1782 1724                 3506
1134619 CO     school 802910 130   CHERRY CREEK 5 80291000203 8020 SMOKY HILL HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 251.0 93.0 118.0   1.0 44.0     2.0   33.0   274.0 268.0                       542.0 251 93 118   1 44     2   33   274 268                 542
1135066 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000069 4973 LAREDO ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   pk_12_total 50.0 93.0 348.0   3.0 22.0     14.0   20.0   295.0 255.0                       550.0 50 93 348   3 22     14   20   295 255                 550
709672 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000064 4024 HINKLEY HIGH SCHOOL   Regular School No High 09 12 2017   grade_12 54 93 425   2 15     6   18   321 292                       613 54 93 425   2 15     6   18   321 292                 613
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
1739444 CO     school 802910 130   Cherry Creek 5 80291000763 1510 Challenge School   Regular School No Elementary PK 08 2021   pk_12_total 209 93 55   1 126     2   56   274 268                       542 209 93 55   1 126     2   56   274 268                 542
1740327 CO     school 802340 180   Adams-Arapahoe 28J 80234001389 7250 Rangeview High School   Regular School No High 09 12 2021   grade_9 94 93 218   2 15     3   60   249 236                       485 94 93 218   2 15     3   60   249 236                 485
1742835 CO     school 803360 880   Denver County 1 80336001576 6957 University Prep - Steele St.   Regular School Yes Elementary PK 05 2021   pk_12_total 22 93 224   4 3     0   17   185 178                       363 22 93 224   4 3     0   17   185 178                 363
1744462 CO     school 804080 1000   Fountain 8 80408000563 3106 Fountain Middle School   Regular School No Middle 06 08 2021   pk_12_total 531 93 294   12 14     19   121   562 522                       1084 531 93 294   12 14     19   121   562 522                 1084
1800656 CO     school 802910 130   Cherry Creek 5 80291000196 4276 Independence Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 186 93 134   4 14     2   68   243 258                       501 186 93 134   4 14     2   68   243 258                 501
1801069 CO     school 802340 180   Adams-Arapahoe 28J 80234001296 310 Arkansas Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 79 93 172   3 19     7   45   213 205                       418 79 93 172   3 19     7   45   213 205                 418
1801230 CO     school 802340 180   Adams-Arapahoe 28J 80234000066 4426 Jewell Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 70 93 205   1 14     4   25   223 189                       412 70 93 205   1 14     4   25   223 189                 412
1803266 CO     school 803360 880   Denver County 1 80336000338 2398 East High School   Regular School No High 09 12 2020   grade_10 312 93 145   3 12     4   38   283 324                       607 312 93 145   3 12     4   38   283 324                 607
1895148 CO     school 802910 130   CHERRY CREEK 5 80291000203 8020 SMOKY HILL HIGH SCHOOL   Regular School No High 09 12 2018   grade_12 209 93 116   2 45     2   26   254 239                       493 209 93 116   2 45     2   26   254 239                 493
1933045 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001432 7865 SIDE CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   pk_12_total 116 93 174   0 43     0   50   240 236                       476 116 93 174   0 43     0   50   240 236                 476
1933085 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006322 9056 VANGUARD CLASSICAL SCHOOL - WEST   Regular School Yes Elementary KG 08 2019   pk_12_total 65 93 245   0 4     0   16   201 222                       423 65 93 245   0 4     0   16   201 222                 423
1134928 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000056 1458 AURORA CENTRAL HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_12 36.0 92.0 382.0   3.0 69.0     2.0   14.0   333.0 265.0                       598.0 36 92 382   3 69     2   14   333 265                 598
1138912 CO     school 804530 980   HARRISON 2 80453000662 1306 CARMEL MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   pk_12_total 81.0 92.0 186.0   6.0 8.0     2.0   19.0   197.0 197.0                       394.0 81 92 186   6 8     2   19   197 197                 394
709096 CO     school 802910 130   CHERRY CREEK 5 80291006182 3988 HIGHLINE COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 84 92 303   8 21     1   24   284 249                       533 84 92 303   8 21     1   24   284 249                 533
709257 CO     school 802910 130   CHERRY CREEK 5 80291000203 8020 SMOKY HILL HIGH SCHOOL   Regular School No High 09 12 2017   grade_12 240 92 118   5 45     3   29   239 293                       532 240 92 118   5 45     3   29   239 293                 532
711762 CO     school 803360 880   DENVER COUNTY 1 80336000347 2880 FAIRVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 12 92 124   2 15     0   4   122 127                       249 12 92 124   2 15     0   4   122 127                 249
712349 CO     school 803360 880   DENVER COUNTY 1 80336006642 7496 ROOTS ELEMENTARY   Regular School Yes Elementary KG 02 2017   pk_12_total 22 92 31   1 0     0   10   80 76                       156 22 92 31   1 0     0   10   80 76                 156
1742202 CO     school 803360 880   Denver County 1 80336006618 2218 DSST: Conservatory Green Middle School   Regular School Yes Middle 06 08 2021   pk_12_total 62 92 279   2 12     1   22   251 219                       470 62 92 279   2 12     1   22   251 219                 470
1744186 CO     school 804530 980   Harrison 2 80453000666 3522 Fox Meadow Middle School   Regular School No Middle 06 08 2021   pk_12_total 150 92 260   5 10     2   54   312 261                       573 150 92 260   5 10     2   54   312 261                 573
1800788 CO     school 802910 130   Cherry Creek 5 80291000203 8020 Smoky Hill High School   Regular School No High 09 12 2020   grade_11 236 92 136   7 38     5   38   292 260                       552 236 92 136   7 38     5   38   292 260                 552
1801374 CO     school 802340 180   Adams-Arapahoe 28J 80234000077 7558 Sable Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 25 92 254   5 21     4   16   207 210                       417 25 92 254   5 21     4   16   207 210                 417
1894957 CO     school 802910 130   CHERRY CREEK 5 80291006367 3030 FOX RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   pk_12_total 920 92 196   7 96     0   87   725 673                       1398 920 92 196   7 96     0   87   725 673                 1398
1895498 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000058 1948 CRAWFORD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   pk_12_total 20 92 282   8 159     0   4   289 276                       565 20 92 282   8 159     0   4   289 276                 565
1932886 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001323 4270 IOWA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   pk_12_total 91 92 241   2 22     7   28   244 239                       483 91 92 241   2 22     7   28   244 239                 483
1935362 CO     school 803360 880   DENVER COUNTY 1 80336001635 5644 MAXWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   pk_12_total 21 92 493   2 4     3   12   315 312                       627 21 92 493   2 4     3   12   315 312                 627
1935464 CO     school 803360 880   DENVER COUNTY 1 80336000389 6314 NORTH HIGH SCHOOL   Regular School No High 09 12 2019   pk_12_total 202 92 868   28 13     1   31   651 584                       1235 202 92 868   28 13     1   31   651 584                 1235
1936292 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006577 3863 HOPE ONLINE LEARNING ACADEMY ELEMENTARY   Regular School Yes Elementary KG 05 2019   pk_12_total 93 92 717   3 2     0   14   465 456                       921 93 92 717   3 2     0   14   465 456                 921
1936987 CO     school 804530 980   HARRISON 2 80453000666 3522 FOX MEADOW MIDDLE SCHOOL   Regular School No Middle 06 08 2019   pk_12_total 178 92 287   7 11     5   58   347 291                       638 178 92 287   7 11     5   58   347 291                 638
1134433 CO     school 802910 130   CHERRY CREEK 5 80291001672 2897 FALCON CREEK MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   pk_12_total 620.0 91.0 183.0   2.0 72.0     2.0   52.0   513.0 509.0                       1022.0 620 91 183   2 72     2   52   513 509                 1022
711504 CO     school 803360 880   DENVER COUNTY 1 80336006364 1785 COLE ARTS AND SCIENCE ACADEMY   Regular School No Elementary PK 05 2017   pk_12_total 34 91 371   1 3     3   24   256 271                       527 34 91 371   1 3     3   24   256 271                 527
712000 CO     school 803360 880   DENVER COUNTY 1 80336006519 4507 KIPP MONTBELLO COLLEGE PREP   Regular School Yes Middle 05 08 2017   pk_12_total 14 91 334   0 5     2   9   232 223                       455 14 91 334   0 5     2   9   232 223                 455
715002 CO     school 803870 1110   FALCON 49 80387001799 7960 SKYVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 653 91 237   9 40     4   90   596 528                       1124 653 91 237   9 40     4   90   596 528                 1124
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
1739743 CO     school 802910 130   Cherry Creek 5 80291000203 8020 Smoky Hill High School   Regular School No High 09 12 2021   grade_9 237 91 149   5 32     2   43   277 282                       559 237 91 149   5 32     2   43   277 282                 559
1740058 CO     school 802340 180   Adams-Arapahoe 28J 80234000056 1458 Aurora Central High School   Regular School No High 09 12 2021   grade_12 21 91 364   2 25     5   9   259 258                       517 21 91 364   2 25     5   9   259 258                 517
1742215 CO     school 803360 880   Denver County 1 80336006684 2228 DSST: Byers High School   Regular School Yes High 09 12 2021   pk_12_total 235 91 186   2 20     1   34   313 256                       569 235 91 186   2 20     1   34   313 256                 569
1744435 CO     school 804080 1000   Fountain 8 80408000561 1332 Carson Middle School   Regular School No Middle 06 08 2021   pk_12_total 323 91 165   6 13     15   75   355 333                       688 323 91 165   6 13     15   75   355 333                 688
1801390 CO     school 802340 180   Adams-Arapahoe 28J 80234000078 7932 Sixth Avenue Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 30 91 276   2 6     18   24   227 220                       447 30 91 276   2 6     18   24   227 220                 447
1803183 CO     school 803360 880   Denver County 1 80336006572 2186 DSST: Byers Middle School   Regular School Yes Middle 06 08 2020   pk_12_total 197 91 144   4 16     0   30   258 224                       482 197 91 144   4 16     0   30   258 224                 482
1805749 CO     school 803060 1010   Colorado Springs 11 80306000239 3890 Adams Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 136 91 193   2 1     2   27   252 200                       452 136 91 193   2 1     2   27   252 200                 452
1895556 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000063 3354 GATEWAY HIGH SCHOOL   Regular School No High 09 12 2018   grade_10 31 91 224   1 16     2   15   225 155                       380 31 91 224   1 16     2   15   225 155                 380
1932452 CO     school 802910 130   CHERRY CREEK 5 80291000203 8020 SMOKY HILL HIGH SCHOOL   Regular School No High 09 12 2019   grade_10 246 91 126   6 38     6   40   281 272                       553 246 91 126   6 38     6   40   281 272                 553
1935247 CO     school 803360 880   DENVER COUNTY 1 80336006670 4509 KIPP NORTHEAST DENVER LEADERSHIP ACADEMY   Regular School Yes High 09 12 2019   pk_12_total 22 91 367   2 28     1   5   251 265                       516 22 91 367   2 28     1   5   251 265                 516
1134418 CO     school 802910 130   CHERRY CREEK 5 80291006156 2357 EAGLECREST HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_12 326.0 90.0 115.0   1.0 41.0     0.0   21.0   303.0 291.0                       594.0 326 90 115   1 41     0   21   303 291                 594
1137039 CO     school 803360 880   DENVER COUNTY 1 80336006441 2755 VENTURE PREP HIGH SCHOOL   Regular School Yes 3.0 09 12 2015   pk_12_total 23.0 90.0 162.0   1.0 2.0     1.0   5.0   143.0 141.0                       284.0 23 90 162   1 2     1   5   143 141                 284
709045 CO     school 802910 130   CHERRY CREEK 5 80291006156 2357 EAGLECREST HIGH SCHOOL   Regular School No High 09 12 2017   grade_10 358 90 134   4 42     3   50   365 316                       681 358 90 134   4 42     3   50   365 316                 681
709575 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001388 1470 CENTURY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 72 90 123   1 7     6   23   174 148                       322 72 90 123   1 7     6   23   174 148                 322
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
1739574 CO     school 802910 130   Cherry Creek 5 80291006182 3988 Highline Community Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 51 90 219   3 22     9   13   213 194                       407 51 90 219   3 22     9   13   213 194                 407
1740207 CO     school 802340 180   Adams-Arapahoe 28J 80234000068 4970 Lansing Elementary Community School   Regular School No Elementary PK 05 2021   pk_12_total 35 90 167   3 18     9   33   178 177                       355 35 90 167   3 18     9   33   178 177                 355
1740267 CO     school 802340 180   Adams-Arapahoe 28J 80234000074 6310 North Middle School Health Sciences and Technology Campus   Regular School No Middle 06 08 2021   pk_12_total 26 90 407   1 22     12   17   309 266                       575 26 90 407   1 22     12   17   309 266                 575
1740324 CO     school 802340 180   Adams-Arapahoe 28J 80234001389 7250 Rangeview High School   Regular School No High 09 12 2021   grade_10 116 90 235   0 30     3   43   257 260                       517 116 90 235   0 30     3   43   257 260                 517
1740387 CO     school 802340 180   Adams-Arapahoe 28J 80234006322 9056 Vanguard Classical School - West   Regular School Yes Elementary KG 08 2021   pk_12_total 48 90 219   0 5     0   21   207 176                       383 48 90 219   0 5     0   21   207 176                 383
1800628 CO     school 802910 130   Cherry Creek 5 80291000194 4062 Holly Hills Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 168 90 204   5 26     0   49   275 267                       542 168 90 204   5 26     0   49   275 267                 542
1802908 CO     school 803360 880   Denver County 1 80336000309 418 Ashley Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 38 90 208   1 2     0   12   173 178                       351 38 90 208   1 2     0   12   173 178                 351
1803660 CO     school 803360 880   Denver County 1 80336001406 5605 Dr. Martin Luther King Jr. Early College   Regular School No High 06 12 2020   grade_9 10 90 162   1 12     9   9   161 132                       293 10 90 162   1 12     9   9   161 132                 293
1805581 CO     school 804080 1000   Fountain 8 80408006481 9610 Weikel Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 531 90 131   11 16     8   68   446 409                       855 531 90 131   11 16     8   68   446 409                 855
1895748 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000078 7932 SIXTH AVENUE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   pk_12_total 45 90 290   5 6     30   12   252 226                       478 45 90 290   5 6     30   12   252 226                 478
1895817 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000081 9140 VIRGINIA COURT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   pk_12_total 59 90 341   5 13     2   17   291 236                       527 59 90 341   5 13     2   17   291 236                 527
1899904 CO     school 804080 1000   FOUNTAIN 8 80408000565 6338 PATRIOT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   pk_12_total 324 90 143   5 12     18   60   323 329                       652 324 90 143   5 12     18   60   323 329                 652
1932239 CO     school 802910 130   CHERRY CREEK 5 80291006156 2357 EAGLECREST HIGH SCHOOL   Regular School No High 09 12 2019   grade_12 327 90 139   7 49     1   54   345 322                       667 327 90 139   7 49     1   54   345 322                 667
1932455 CO     school 802910 130   CHERRY CREEK 5 80291000203 8020 SMOKY HILL HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 198 90 124   2 37     0   30   241 240                       481 198 90 124   2 37     0   30   241 240                 481
1932769 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000056 1458 AURORA CENTRAL HIGH SCHOOL   Regular School No High 09 12 2019   grade_11 16 90 290   3 40     7   13   247 212                       459 16 90 290   3 40     7   13   247 212                 459
1935031 CO     school 803360 880   DENVER COUNTY 1 80336000352 3378 GEORGE WASHINGTON HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 141 90 109   4 12     3   26   189 196                       385 141 90 109   4 12     3   26   189 196                 385
1133237 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No 4.0 PK 12 2015   pk_12_total 42.0 9.0 527.0   3.0 4.0     0.0   7.0   313.0 279.0                       592.0 42 9 527   3 4     0   7   313 279                 592
1133338 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No 4.0 KG 12 2015   grade_8 188.0 9.0 60.0   2.0 1.0     1.0   22.0   131.0 152.0                       283.0 188 9 60   2 1     1   22   131 152                 283
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
1133515 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001177 4000 HILLCREST ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   pk_12_total 100.0 9.0 301.0   3.0 29.0     0.0   12.0   237.0 217.0                       454.0 100 9 301   3 29     0   12   237 217                 454
1133517 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001491 4108 HORIZON HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_11 318.0 9.0 113.0   4.0 36.0     2.0   4.0   247.0 239.0                       486.0 318 9 113   4 36     2   4   247 239                 486
1133518 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001491 4108 HORIZON HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_12 337.0 9.0 118.0   4.0 24.0     1.0   1.0   241.0 253.0                       494.0 337 9 118   4 24     1   1   241 253                 494
1133533 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001179 4187 SILVER HILLS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 169.0 9.0 156.0   7.0 16.0     0.0   4.0   195.0 166.0                       361.0 169 9 156   7 16     0   4   195 166                 361
1133603 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001187 6398 NORTHGLENN MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 99.0 9.0 167.0   2.0 7.0     0.0   3.0   161.0 126.0                       287.0 99 9 167   2 7     0   3   161 126                 287
1133735 CO     school 801950 30   ADAMS COUNTY 14 80195000010 24 ADAMS CITY HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_12 44.0 9.0 298.0   1.0 3.0     0.0   2.0   180.0 177.0                       357.0 44 9 298   1 3     0   2   180 177                 357
1133762 CO     school 801950 30   ADAMS COUNTY 14 80195000015 4516 KEARNEY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 30.0 9.0 248.0   0.0 0.0     0.0   1.0   149.0 139.0                       288.0 30 9 248   0 0     0   1   149 139                 288
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
1133782 CO     school 801950 30   ADAMS COUNTY 14 80195000017 5982 MONACO ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   pk_12_total 71.0 9.0 395.0   7.0 0.0     0.0   8.0   231.0 259.0                       490.0 71 9 395   7 0     0   8   231 259                 490
1134227 CO     school 803780 120   ENGLEWOOD 1 80378006331 2752 ENGLEWOOD MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   pk_12_total 140.0 9.0 110.0   4.0 0.0     0.0   8.0   142.0 129.0                       271.0 140 9 110   4 0     0   8   142 129                 271
1134288 CO     school 802910 130   CHERRY CREEK 5 80291002032 243 COYOTE HILLS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_5 81.0 9.0 13.0   1.0 7.0     0.0   10.0   64.0 57.0                       121.0 81 9 13   1 7     0   10   64 57                 121

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