Data source: Big Local News · About: Big Local

13,207 rows where state = "CO" and year = 2017 sorted by black descending

View and edit SQL

year

  • 2017 · 13,207
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
709047 CO     school 802910 130   CHERRY CREEK 5 80291006156 2357 EAGLECREST HIGH SCHOOL   Regular School No High 09 12 2017   grade_12 305 99 132   0 33     2   44   327 288                       615 305 99 132   0 33     2   44   327 288                 615
709626 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000061 2618 ELKHART ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   pk_12_total 23 99 475   3 18     3   24   324 321                       645 23 99 475   3 18     3   24   324 321                 645
711797 CO     school 803360 880   DENVER COUNTY 1 80336000352 3378 GEORGE WASHINGTON HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 92 99 134   1 18     0   24   195 173                       368 92 99 134   1 18     0   24   195 173                 368
714160 CO     school 803060 1010   COLORADO SPRINGS 11 80306000239 3890 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 136 99 156   2 1     1   46   234 207                       441 136 99 156   2 1     1   46   234 207                 441
709715 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000069 4973 LAREDO ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   pk_12_total 53 98 311   4 16     5   16   275 228                       503 53 98 311   4 16     5   16   275 228                 503
709910 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000081 9140 VIRGINIA COURT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 60 98 362   4 11     0   17   312 240                       552 60 98 362   4 11     0   17   312 240                 552
707941 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   pk_12_total 1589 97 496   18 35     19   172   1146 1280                       2426 1589 97 496   18 35     19   172   1146 1280                 2426
709046 CO     school 802910 130   CHERRY CREEK 5 80291006156 2357 EAGLECREST HIGH SCHOOL   Regular School No High 09 12 2017   grade_11 328 97 138   5 39     3   46   334 322                       656 328 97 138   5 39     3   46   334 322                 656
712416 CO     school 803360 880   DENVER COUNTY 1 80336006486 8053 SOAR AT GREEN VALLEY RANCH   Regular School Yes Elementary KG 05 2017   pk_12_total 53 97 256   1 32     3   25   233 234                       467 53 97 256   1 32     3   25   233 234                 467
709220 CO     school 802910 130   CHERRY CREEK 5 80291000199 7102 POLTON COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 223 96 113   1 33     4   61   279 252                       531 223 96 113   1 33     4   61   279 252                 531
709565 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000056 1458 AURORA CENTRAL HIGH SCHOOL   Regular School No High 09 12 2017   grade_11 17 95 353   3 45     2   13   291 237                       528 17 95 353   3 45     2   13   291 237                 528
713688 CO     school 804530 980   HARRISON 2 80453000663 1383 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 88 95 269   7 4     15   49   276 251                       527 88 95 269   7 4     15   49   276 251                 527
708926 CO     school 802910 130   CHERRY CREEK 5 80291000183 348 ARROWHEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 302 94 133   4 39     2   51   332 293                       625 302 94 133   4 39     2   51   332 293                 625
709984 CO     school 802700 190   BYERS 32J 80270006605 2356 ELEVATE ACADEMY   Regular School Yes Other KG 12 2017   pk_12_total 187 94 749   53 4     3   3   584 509                       1093 187 94 749   53 4     3   3   584 509                 1093
711745 CO     school 803360 880   DENVER COUNTY 1 80336000345 2726 EMILY GRIFFITH HIGH SCHOOL   Alternative School No High 09 12 2017   pk_12_total 56 94 202   4 3     0   11   207 163                       370 56 94 202   4 3     0   11   207 163                 370
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
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
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
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
707850 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   pk_12_total 53 9 412   0 6     0   4   242 242                       484 53 9 412   0 6     0   4   242 242                 484
707935 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_5 85 9 21   1 0     0   7   52 71                       123 85 9 21   1 0     0   7   52 71                 123
707973 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   pk_12_total 256 9 189   2 12     1   20   271 218                       489 256 9 189   2 12     1   20   271 218                 489
708002 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   pk_12_total 366 9 198   1 22     1   27   330 294                       624 366 9 198   1 22     1   27   330 294                 624
708128 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001491 4108 HORIZON HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 331 9 164   3 33     1   8   276 273                       549 331 9 164   3 33     1   8   276 273                 549
708163 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001181 5418 MALLEY DRIVE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 177 9 307   3 9     0   14   287 232                       519 177 9 307   3 9     0   14   287 232                 519
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
708279 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006303 8225 STELLAR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   pk_12_total 293 9 232   6 29     0   24   313 280                       593 293 9 232   6 29     0   24   313 280                 593
708341 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001195 9494 WESTVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 185 9 243   5 29     0   23   280 214                       494 185 9 243   5 29     0   23   280 214                 494
708365 CO     school 801950 30   ADAMS COUNTY 14 80195001947 124 STARS EARLY LEARNING CENTER   Regular School No Elementary PK PK 2017   pk_12_total 13 9 96   0 0     0   2   65 55                       120 13 9 96   0 0     0   2   65 55                 120
708366 CO     school 801950 30   ADAMS COUNTY 14 80195001947 124 STARS EARLY LEARNING CENTER   Regular School No Elementary PK PK 2017   pre_kindergarten 13 9 96   0 0     0   2   65 55                       120 13 9 96   0 0     0   2   65 55                 120
708391 CO     school 801950 30   ADAMS COUNTY 14 80195000015 4516 KEARNEY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 31 9 244   1 0     0   1   158 128                       286 31 9 244   1 0     0   1   158 128                 286
708538 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001377 6638 OVERLAND TRAIL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 217 9 350   2 8     1   21   314 294                       608 217 9 350   2 8     1   21   314 294                 608
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
708635 CO     school 806750 60   STRASBURG 31J 80675001159 8328 STRASBURG ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 348 9 76   7 4     5   1   248 202                       450 348 9 76   7 4     5   1   248 202                 450
708694 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006567 4334 COLORADO STEM ACADEMY   Regular School No Elementary KG 08 2017   pk_12_total 177 9 180   4 13     2   11   234 162                       396 177 9 180   4 13     2   11   234 162                 396
708771 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001254 9466 WESTMINSTER HIGH SCHOOL   Regular School No High 09 12 2017   grade_10 91 9 514   2 41     2   8   341 326                       667 91 9 514   2 41     2   8   341 326                 667
708828 CO     school 803780 120   ENGLEWOOD 1 80378000486 1514 CHARLES HAY WORLD SCHOOL   Regular School No Elementary KG 06 2017   pk_12_total 230 9 113   1 3     1   22   208 171                       379 230 9 113   1 3     1   22   208 171                 379
708920 CO     school 802910 130   CHERRY CREEK 5 80291000183 348 ARROWHEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 45 9 13   0 5     1   7   46 34                       80 45 9 13   0 5     1   7   46 34                 80
708931 CO     school 802910 130   CHERRY CREEK 5 80291001879 442 ASPEN CROSSING ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 64 9 13   0 8     0   6   55 45                       100 64 9 13   0 8     0   6   55 45                 100
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
709026 CO     school 802910 130   CHERRY CREEK 5 80291001404 1970 CREEKSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 91 9 20   2 13     0   9   75 69                       144 91 9 20   2 13     0   9   75 69                 144
709059 CO     school 802910 130   CHERRY CREEK 5 80291006649 2653 ENDEAVOR ACADEMY   Regular School No High 09 12 2017   grade_11 37 9 24   2 3     0   4   47 32                       79 37 9 24   2 3     0   4   47 32                 79
709100 CO     school 802910 130   CHERRY CREEK 5 80291000194 4062 HOLLY HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 30 9 48   1 6     0   4   59 39                       98 30 9 48   1 6     0   4   59 39                 98
709104 CO     school 802910 130   CHERRY CREEK 5 80291000194 4062 HOLLY HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 26 9 17   0 10     0   6   41 27                       68 26 9 17   0 10     0   6   41 27                 68
709168 CO     school 802910 130   CHERRY CREEK 5 80291006607 6225 MOUNTAIN VISTA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 42 9 6   0 3     0   8   34 34                       68 42 9 6   0 3     0   8   34 34                 68
709233 CO     school 802910 130   CHERRY CREEK 5 80291001880 7277 RED HAWK RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 51 9 18   0 9     0   9   54 42                       96 51 9 18   0 9     0   9   54 42                 96
709273 CO     school 802910 130   CHERRY CREEK 5 80291001378 8394 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_half_day 35 9 30   0 2     0   14   45 45                       90 35 9 30   0 2     0   14   45 45                 90
709275 CO     school 802910 130   CHERRY CREEK 5 80291001378 8394 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 18 9 13   1 6     1   7   27 28                       55 18 9 13   1 6     1   7   27 28                 55
709382 CO     school 805310 140   LITTLETON 6 80531000884 5224 LITTLETON HIGH SCHOOL   Regular School No High 09 12 2017   grade_12 185 9 91   4 15     1   20   152 173                       325 185 9 91   4 15     1   20   152 173                 325
709506 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006399 213 AXL ACADEMY   Regular School Yes Elementary PK 08 2017   pre_kindergarten 5 9 9   0 0     0   2   10 15                       25 5 9 9   0 0     0   2   10 15                 25
709527 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001296 310 ARKANSAS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 9 9 9   1 1     0   2   22 9                       31 9 9 9   1 1     0   2   22 9                 31
709546 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234002009 465 AURORA FRONTIER K-8   Regular School No Elementary PK 08 2017   grade_5 27 9 18   1 12     0   5   38 34                       72 27 9 18   1 12     0   5   38 34                 72
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
709581 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000057 1720 CLYDE MILLER K-8   Regular School No Elementary PK 08 2017   grade_5 7 9 33   0 0     0   4   24 29                       53 7 9 33   0 0     0   4   24 29                 53
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
709608 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000059 2114 DARTMOUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 20 9 24   0 1     0   4   40 18                       58 20 9 24   0 1     0   4   40 18                 58
709613 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000059 2114 DARTMOUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_full_day 25 9 13   1 1     0   3   31 21                       52 25 9 13   1 1     0   3   31 21                 52
709645 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006424 2998 FLETCHER COMMUNITY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_full_day 3 9 47   1 3     0   4   43 24                       67 3 9 47   1 3     0   4   43 24                 67
709694 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000067 4646 KENTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 2 9 65   0 5     0   3   45 39                       84 2 9 65   0 5     0   3   45 39                 84
709734 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000070 5361 LYN KNOLL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 3 9 23   0 1     0   3   24 15                       39 3 9 23   0 1     0   3   24 15                 39
709743 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000072 6068 MONTVIEW MATH & HEALTH SCIENCES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 8 9 55   0 2     1   3   41 37                       78 8 9 55   0 2     1   3   41 37                 78
709781 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000075 6728 PARIS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 2 9 44   0 3     0   2   32 28                       60 2 9 44   0 3     0   2   32 28                 60
709812 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001674 7232 AURORA QUEST K-8   Regular School No Elementary KG 08 2017   grade_8 34 9 19   0 13     1   7   42 41                       83 34 9 19   0 13     1   7   42 41                 83
709875 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001294 9059 VASSAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 18 9 35   2 4     2   8   41 37                       78 18 9 35   2 4     2   8   41 37                 78
709892 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006483 9083 VISTA PEAK P-8 EXPLORATORY   Regular School No Elementary PK 08 2017   grade_5 36 9 43   5 3     0   12   59 49                       108 36 9 43   5 3     0   12   59 49                 108
710199 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001886 226 ALTONA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 607 9 91   1 78     3   23   410 402                       812 607 9 91   1 78     3   23   410 402                 812
710395 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000910 5288 LONGS PEAK MIDDLE SCHOOL   Regular School No Middle 05 08 2017   pk_12_total 139 9 259   3 3     0   6   205 214                       419 139 9 259   3 3     0   6   205 214                 419
710458 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000918 6276 NIWOT HIGH SCHOOL   Regular School No High 09 12 2017   grade_10 171 9 78   2 30     2   11   141 162                       303 171 9 78   2 30     2   11   141 162                 303
710551 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006198 9430 WESTVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 545 9 157   3 21     0   21   406 350                       756 545 9 157   3 21     0   21   406 350                 756
710709 CO     school 802490 480   BOULDER VALLEY RE 2 80249000113 2702 EMERALD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 175 9 177   4 20     1   14   211 189                       400 175 9 177   4 20     1   14   211 189                 400
711334 CO     school 803360 880   DENVER COUNTY 1 80336001724 40 RIDGE VIEW ACADEMY CHARTER SCHOOL   Alternative School Yes High 09 12 2017   grade_12 15 9 26   0 0     0   0   50 0                       50 15 9 26   0 0     0   0   50 0                 50
711342 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes Elementary PK 05 2017   grade_1 4 9 14   0 0     0   0   15 12                       27 4 9 14   0 0     0   0   15 12                 27
711380 CO     school 803360 880   DENVER COUNTY 1 80336000309 418 ASHLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 9 9 26   0 0     0   3   25 22                       47 9 9 26   0 0     0   3   25 22                 47
711399 CO     school 803360 880   DENVER COUNTY 1 80336000317 964 BRADLEY INTERNATIONAL SCHOOL   Regular School No Elementary PK 05 2017   grade_3 37 9 17   0 2     0   8   37 36                       73 37 9 17   0 2     0   8   37 36                 73
711482 CO     school 803360 880   DENVER COUNTY 1 80336000325 1528 CHELTENHAM ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_full_day 2 9 40   1 0     1   1   29 25                       54 2 9 40   1 0     1   1   29 25                 54
711533 CO     school 803360 880   DENVER COUNTY 1 80336001764 1866 ACE COMMUNITY CHALLENGE SCHOOL   Alternative School Yes Other 08 10 2017   pk_12_total 4 9 135   3 0     0   3   86 68                       154 4 9 135   3 0     0   3   86 68                 154
711550 CO     school 803360 880   DENVER COUNTY 1 80336006645 1939 COMPASS ACADEMY   Regular School Yes Middle 06 07 2017   pk_12_total 5 9 191   2 7     1   1   115 101                       216 5 9 191   2 7     1   1   115 101                 216
711629 CO     school 803360 880   DENVER COUNTY 1 80336001574 2184 DENVER SCHOOL OF THE ARTS   Regular School No Other 06 12 2017   grade_11 127 9 20   0 2     1   9   64 104                       168 127 9 20   0 2     1   9   64 104                 168
711657 CO     school 803360 880   DENVER COUNTY 1 80336006521 2205 DCIS AT FORD   Regular School No Elementary PK 05 2017   grade_5 1 9 45   0 0     2   0   29 28                       57 1 9 45   0 0     2   0   29 28                 57
711658 CO     school 803360 880   DENVER COUNTY 1 80336006521 2205 DCIS AT FORD   Regular School No Elementary PK 05 2017   kindergarten_full_day 1 9 58   0 0     1   1   36 34                       70 1 9 58   0 0     1   1   36 34                 70
711664 CO     school 803360 880   DENVER COUNTY 1 80336006584 2207 DOWNTOWN DENVER EXPEDITIONARY SCHOOL   Regular School Yes Elementary KG 05 2017   grade_4 51 9 13   1 4     0   6   45 39                       84 51 9 13   1 4     0   6   45 39                 84
711737 CO     school 803360 880   DENVER COUNTY 1 80336000341 2652 ELLIS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 13 9 35   0 4     0   3   29 35                       64 13 9 35   0 4     0   3   29 35                 64
711800 CO     school 803360 880   DENVER COUNTY 1 80336000353 3426 GILPIN MONTESSORI PUBLIC SCHOOL   Regular School No Elementary PK 06 2017   grade_2 0 9 8   1 0     0   2   12 8                       20 0 9 8   1 0     0   2   12 8                 20
711855 CO     school 803360 880   DENVER COUNTY 1 80336001739 3647 MARIE L. GREENWOOD ACADEMY   Regular School No Elementary 01 08 2017   grade_1 1 9 41   0 0     0   0   25 26                       51 1 9 41   0 0     0   0   25 26                 51
711891 CO     school 803360 880   DENVER COUNTY 1 80336000362 3778 INTERNATIONAL ACADEMY OF DENVER AT HARRINGTON   Regular School No Elementary PK 05 2017   grade_1 0 9 23   0 0     0   2   15 19                       34 0 9 23   0 0     0   2   15 19                 34
711906 CO     school 803360 880   DENVER COUNTY 1 80336001835 3987 HIGHLINE ACADEMY SOUTHEAST   Regular School Yes Elementary KG 08 2017   grade_8 33 9 10   0 1     0   4   21 36                       57 33 9 10   0 1     0   4   21 36                 57
711907 CO     school 803360 880   DENVER COUNTY 1 80336001835 3987 HIGHLINE ACADEMY SOUTHEAST   Regular School Yes Elementary KG 08 2017   kindergarten_full_day 29 9 5   0 2     0   3   23 25                       48 29 9 5   0 2     0   3   23 25                 48
711948 CO     school 803360 880   DENVER COUNTY 1 80336006570 4213 ISABELLA BIRD COMMUNITY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 52 9 12   0 5     0   8   36 50                       86 52 9 12   0 5     0   8   36 50                 86
711951 CO     school 803360 880   DENVER COUNTY 1 80336006570 4213 ISABELLA BIRD COMMUNITY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_full_day 51 9 11   0 17     1   15   50 54                       104 51 9 11   0 17     1   15   50 54                 104
711967 CO     school 803360 880   DENVER COUNTY 1 80336000367 4444 JOHN F KENNEDY HIGH SCHOOL   Regular School No High 09 12 2017   grade_11 28 9 211   2 24     1   1   151 125                       276 28 9 211   2 24     1   1   151 125                 276
712102 CO     school 803360 880   DENVER COUNTY 1 80336006555 5621 MONARCH MONTESSORI   Regular School Yes Elementary KG 05 2017   grade_2 5 9 22   0 0     0   3   21 18                       39 5 9 22   0 0     0   3   21 18                 39
712109 CO     school 803360 880   DENVER COUNTY 1 80336001635 5644 MAXWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 2 9 67   0 0     1   0   48 31                       79 2 9 67   0 0     1   0   48 31                 79
712115 CO     school 803360 880   DENVER COUNTY 1 80336001635 5644 MAXWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 4 9 41   0 0     0   1   36 19                       55 4 9 41   0 0     0   1   36 19                 55
712147 CO     school 803360 880   DENVER COUNTY 1 80336000380 5844 CONTEMPORARY LEARNING ACADEMY   Alternative School No High 09 12 2017   grade_11 4 9 14   0 0     0   2   13 16                       29 4 9 14   0 0     0   2   13 16                 29

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