Data source: Big Local News · About: Big Local

13,321 rows where state = "CO" and year = 2020 sorted by native_hawaiian_pacific_islander descending

View and edit SQL

year

  • 2020 · 13,321
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
1801107 CO     school 802340 180   Adams-Arapahoe 28J 80234000056 1458 Aurora Central High School   Regular School No High 09 12 2020   grade_10 26 70 334   2 23     9   17   279 202                       481 26 70 334   2 23     9   17   279 202                 481
1803270 CO     school 803360 880   Denver County 1 80336000338 2398 East High School   Regular School No High 09 12 2020   pk_12_total 1345 388 557   13 68     9   176   1188 1368                       2556 1345 388 557   13 68     9   176   1188 1368                 2556
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
1803685 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2020   grade_2 3 16 70   0 2     9   1   49 52                       101 3 16 70   0 2     9   1   49 52                 101
1805344 CO     school 804530 980   Harrison 2 80453000669 6686 Panorama Middle School   Regular School No Middle 06 08 2020   pk_12_total 113 120 302   4 18     9   53   339 280                       619 113 120 302   4 18     9   53   339 280                 619
1805406 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 264 69 182   5 13     9   63   302 303                       605 264 69 182   5 13     9   63   302 303                 605
1805469 CO     school 806480 990   Widefield 3 80648001125 8178 Sproul Junior High School   Regular School No Middle 06 08 2020   pk_12_total 289 46 196   2 9     9   76   315 312                       627 289 46 196   2 9     9   76   315 312                 627
1805512 CO     school 804080 1000   Fountain 8 80408000561 1332 Carson Middle School   Regular School No Middle 06 08 2020   grade_6 131 39 58   4 6     9   28   139 136                       275 131 39 58   4 6     9   28   139 136                 275
1805522 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 201 80 119   9 5     9   44   243 224                       467 201 80 119   9 5     9   44   243 224                 467
1805548 CO     school 804080 1000   Fountain 8 80408000564 3108 Mesa Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 301 31 109   7 6     9   61   269 255                       524 301 31 109   7 6     9   61   269 255                 524
1805864 CO     school 803060 1010   Colorado Springs 11 80306000257 6680 Palmer High School   Regular School No High 09 12 2020   pk_12_total 753 165 561   13 14     9   107   816 806                       1622 753 165 561   13 14     9   107   816 806                 1622
1806567 CO     school 803870 1110   District 49 80387006393 3475 GOAL Academy   Alternative School Yes High 09 12 2020   grade_11 494 53 570   21 8     9   58   574 639                       1213 494 53 570   21 8     9   58   574 639                 1213
1799431 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2020   pk_12_total 1432 102 528   17 27     8   160   1049 1225                       2274 1432 102 528   17 27     8   160   1049 1225                 2274
1800759 CO     school 802910 130   Cherry Creek 5 80291000201 7158 Prairie Middle School   Regular School No Middle 06 08 2020   pk_12_total 325 438 664   15 71     8   109   854 776                       1630 325 438 664   15 71     8   109   854 776                 1630
1801110 CO     school 802340 180   Adams-Arapahoe 28J 80234000056 1458 Aurora Central High School   Regular School No High 09 12 2020   grade_9 18 69 310   8 19     8   15   235 212                       447 18 69 310   8 19     8   15   235 212                 447
1801194 CO     school 802340 180   Adams-Arapahoe 28J 80234000063 3354 Gateway High School   Regular School No High 09 12 2020   grade_10 40 63 197   4 15     8   14   178 163                       341 40 63 197   4 15     8   14   178 163                 341
1803158 CO     school 803360 880   Denver County 1 80336006546 2181 DSST: Green Valley Ranch Middle School   Regular School Yes Middle 06 08 2020   pk_12_total 27 116 278   0 35     8   18   245 237                       482 27 116 278   0 35     8   18   245 237                 482
1803555 CO     school 803360 880   Denver County 1 80336006652 4500 KIPP Northeast Elementary   Regular School Yes Elementary PK 04 2020   pk_12_total 27 130 272   0 20     8   27   242 242                       484 27 130 272   0 20     8   27   242 242                 484
1803687 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2020   grade_4 2 14 94   1 1     8   3   58 65                       123 2 14 94   1 1     8   3   58 65                 123
1804377 CO     school 803450 900   Douglas County Re 1 80345001578 1503 Chaparral High School   Regular School No High 09 12 2020   pk_12_total 1600 42 337   9 84     8   113   1107 1086                       2193 1600 42 337   9 84     8   113   1107 1086                 2193
1805368 CO     school 804530 980   Harrison 2 80453001965 8034 Soaring Eagles Elementary School   Regular School No Elementary PK 05 2020   grade_4 26 7 37   0 3     8   10   40 51                       91 26 7 37   0 3     8   10   40 51                 91
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
1806243 CO     school 801920 1040   Academy 20 80192001593 6140 Mountain Ridge Middle School   Regular School No Middle 06 08 2020   pk_12_total 625 42 187   1 49     8   77   484 505                       989 625 42 187   1 49     8   77   484 505                 989
1806274 CO     school 801920 1040   Academy 20 80192001645 6937 Pine Creek High School   Regular School No High 09 12 2020   pk_12_total 1143 43 218   8 85     8   126   860 771                       1631 1143 43 218   8 85     8   126   860 771                 1631
1809036 CO     school 803990 1550   Poudre R-1 80399000545 7470 Rocky Mountain High School   Regular School No High 09 12 2020   pk_12_total 1504 32 327   6 51     8   96   1054 970                       2024 1504 32 327   6 51     8   96   1054 970                 2024
1799676 CO     school 806900 20   Adams 12 Five Star Schools 80690001996 6060 Mountain Range High School   Regular School No High 09 12 2020   pk_12_total 982 37 720   14 84     7   48   929 963                       1892 982 37 720   14 84     7   48   929 963                 1892
1800575 CO     school 802910 130   Cherry Creek 5 80291006156 2357 Eaglecrest High School   Regular School No High 09 12 2020   pk_12_total 1489 429 694   18 216     7   210   1593 1470                       3063 1489 429 694   18 216     7   210   1593 1470                 3063
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
1801192 CO     school 802340 180   Adams-Arapahoe 28J 80234000062 3272 Fulton Academy of Excellence   Regular School No Elementary PK 05 2020   pk_12_total 28 55 304   4 19     7   15   218 214                       432 28 55 304   4 19     7   15   218 214                 432
1801289 CO     school 802340 180   Adams-Arapahoe 28J 80234000073 6160 Mrachek Middle School   Regular School No Middle 06 08 2020   grade_7 55 70 178   1 14     7   25   177 173                       350 55 70 178   1 14     7   25   177 173                 350
1802073 CO     school 805370 470   St Vrain Valley RE1J 80537001284 7954 Skyline High School   Regular School No High 09 12 2020   pk_12_total 537 17 869   9 27     7   16   782 700                       1482 537 17 869   9 27     7   16   782 700                 1482
1803215 CO     school 803360 880   Denver County 1 80336006528 2209 DCIS at Montbello   Regular School No High 06 12 2020   grade_6 3 10 76   0 0     7   1   55 42                       97 3 10 76   0 0     7   1   55 42                 97
1803686 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2020   grade_3 2 15 80   0 0     7   0   57 47                       104 2 15 80   0 0     7   0   57 47                 104
1805284 CO     school 804530 980   Harrison 2 80453001781 4378 James Irwin Charter High School   Regular School Yes High 09 12 2020   pk_12_total 144 37 194   2 12     7   45   199 242                       441 144 37 194   2 12     7   45   199 242                 441
1805364 CO     school 804530 980   Harrison 2 80453001382 7882 Sierra High School   Regular School No High 09 12 2020   pk_12_total 149 192 400   6 28     7   66   437 411                       848 149 192 400   6 28     7   66   437 411                 848
1805536 CO     school 804080 1000   Fountain 8 80408000566 3102 Aragon Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 327 55 180   9 4     7   90   328 344                       672 327 55 180   9 4     7   90   328 344                 672
1805661 CO     school 803060 1010   Colorado Springs 11 80306006319 1625 McAuliffe Elementary   Regular School No Elementary PK 05 2020   pk_12_total 277 58 149   5 14     7   45   305 250                       555 277 58 149   5 14     7   45   305 250                 555
1806584 CO     school 803870 1110   District 49 80387006386 4251 Grand Peak Academy   Regular School Yes Elementary KG 08 2020   pk_12_total 456 31 168   2 22     7   74   380 380                       760 456 31 168   2 22     7   74   380 380                 760
1800695 CO     school 802910 130   Cherry Creek 5 80291000198 5934 Mission Viejo Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 249 65 178   3 20     6   55   296 280                       576 249 65 178   3 20     6   55   296 280                 576
1801109 CO     school 802340 180   Adams-Arapahoe 28J 80234000056 1458 Aurora Central High School   Regular School No High 09 12 2020   grade_12 21 130 410   4 49     6   20   338 302                       640 21 130 410   4 49     6   20   338 302                 640
1801162 CO     school 802340 180   Adams-Arapahoe 28J 80234000060 2384 East Middle School   Regular School No Middle 06 08 2020   pk_12_total 36 111 706   9 24     6   21   474 439                       913 36 111 706   9 24     6   21   474 439                 913
1801197 CO     school 802340 180   Adams-Arapahoe 28J 80234000063 3354 Gateway High School   Regular School No High 09 12 2020   grade_9 37 72 227   3 15     6   21   212 169                       381 37 72 227   3 15     6   21   212 169                 381
1801212 CO     school 802340 180   Adams-Arapahoe 28J 80234000064 4024 Hinkley High School   Regular School No High 09 12 2020   grade_9 23 68 376   2 23     6   13   270 241                       511 23 68 376   2 23     6   13   270 241                 511
1801243 CO     school 802340 180   Adams-Arapahoe 28J 80234000068 4970 Lansing Elementary Community School   Regular School No Elementary PK 05 2020   grade_4 6 16 30   0 4     6   6   42 26                       68 6 16 30   0 4     6   6   42 26                 68
1801286 CO     school 802340 180   Adams-Arapahoe 28J 80234000072 6068 Montview Math & Health Sciences Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 35 31 265   1 4     6   10   183 169                       352 35 31 265   1 4     6   10   183 169                 352
1801290 CO     school 802340 180   Adams-Arapahoe 28J 80234000073 6160 Mrachek Middle School   Regular School No Middle 06 08 2020   grade_8 39 65 164   2 17     6   25   171 147                       318 39 65 164   2 17     6   25   171 147                 318
1801303 CO     school 802340 180   Adams-Arapahoe 28J 80234000074 6310 North Middle School Health Sciences and Technology Campus   Regular School No Middle 06 08 2020   grade_6 9 32 131   1 8     6   8   115 80                       195 9 32 131   1 8     6   8   115 80                 195
1801335 CO     school 802340 180   Adams-Arapahoe 28J 80234000076 6758 Park Lane Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 21 31 190   5 23     6   17   152 141                       293 21 31 190   5 23     6   17   152 141                 293
1801343 CO     school 802340 180   Adams-Arapahoe 28J 80234001927 6869 Peoria Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 13 39 349   5 32     6   12   233 223                       456 13 39 349   5 32     6   12   233 223                 456
1801439 CO     school 802340 180   Adams-Arapahoe 28J 80234000080 9060 Vaughn Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 22 33 266   5 14     6   14   169 191                       360 22 33 266   5 14     6   14   169 191                 360
1803203 CO     school 803360 880   Denver County 1 80336006521 2205 DCIS at Ford   Regular School No Elementary PK 05 2020   pk_12_total 17 83 393   1 3     6   4   258 249                       507 17 83 393   1 3     6   4   258 249                 507
1803682 CO     school 803360 880   Denver County 1 80336001635 5644 Maxwell Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 20 95 518   3 2     6   5   305 344                       649 20 95 518   3 2     6   5   305 344                 649
1803688 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2020   grade_5 2 9 97   0 0     6   2   66 50                       116 2 9 97   0 0     6   2   66 50                 116
1803689 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2020   grade_6 2 10 52   0 0     6   1   34 37                       71 2 10 52   0 0     6   1   34 37                 71
1803757 CO     school 803360 880   Denver County 1 80336000387 6188 Munroe Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 11 16 383   1 2     6   2   196 225                       421 11 16 383   1 2     6   2   196 225                 421
1804001 CO     school 803360 880   Denver County 1 80336000408 8086 South High School   Regular School No High 09 12 2020   pk_12_total 733 211 493   16 113     6   64   812 824                       1636 733 211 493   16 113     6   64   812 824                 1636
1805271 CO     school 804530 980   Harrison 2 80453000667 3806 Harrison High School   Regular School No High 09 12 2020   grade_10 59 37 149   4 9     6   19   151 132                       283 59 37 149   4 9     6   19   151 132                 283
1805288 CO     school 804530 980   Harrison 2 80453001964 4379 James Irwin Charter Middle School   Regular School Yes Middle 06 08 2020   pk_12_total 136 38 244   1 8     6   38   214 257                       471 136 38 244   1 8     6   38   214 257                 471
1805427 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2020   grade_8 130 28 84   1 4     6   36   154 135                       289 130 28 84   1 4     6   36   154 135                 289
1805499 CO     school 806480 990   Widefield 3 80648001128 9562 Widefield Elementary School of the Arts   Regular School No Elementary KG 05 2020   pk_12_total 244 23 110   0 5     6   35   218 205                       423 244 23 110   0 5     6   35   218 205                 423
1805500 CO     school 806480 990   Widefield 3 80648001129 9566 Widefield High School   Regular School No High 09 12 2020   grade_10 143 21 80   3 2     6   39   168 126                       294 143 21 80   3 2     6   39   168 126                 294
1805501 CO     school 806480 990   Widefield 3 80648001129 9566 Widefield High School   Regular School No High 09 12 2020   grade_11 156 33 102   3 4     6   35   167 172                       339 156 33 102   3 4     6   35   167 172                 339
1805503 CO     school 806480 990   Widefield 3 80648001129 9566 Widefield High School   Regular School No High 09 12 2020   grade_9 159 30 85   2 6     6   32   161 159                       320 159 30 85   2 6     6   32   161 159                 320
1805525 CO     school 804080 1000   Fountain 8 80408006330 3027 Eagleside Elementary School   Regular School No Elementary PK 05 2020   grade_3 52 10 24   0 0     6   14   61 45                       106 52 10 24   0 0     6   14   61 45                 106
1805537 CO     school 804080 1000   Fountain 8 80408000566 3102 Aragon Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 146 15 55   4 2     6   41   148 121                       269 146 15 55   4 2     6   41   148 121                 269
1805713 CO     school 803060 1010   Colorado Springs 11 80306006317 3175 Freedom Elementary School   Special Education School No Elementary PK 05 2020   pk_12_total 292 28 70   1 22     6   29   236 212                       448 292 28 70   1 22     6   29   236 212                 448
1805910 CO     school 803060 1010   Colorado Springs 11 80306001641 7705 Scott Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 395 36 122   3 6     6   49   329 288                       617 395 36 122   3 6     6   49   329 288                 617
1806293 CO     school 801920 1040   Academy 20 80192001321 7240 Rampart High School   Regular School No High 09 12 2020   grade_9 219 10 80   1 21     6   37   191 183                       374 219 10 80   1 21     6   37   191 183                 374
1806566 CO     school 803870 1110   District 49 80387006393 3475 GOAL Academy   Alternative School Yes High 09 12 2020   grade_10 351 29 392   12 3     6   24   421 396                       817 351 29 392   12 3     6   24   421 396                 817
1806568 CO     school 803870 1110   District 49 80387006393 3475 GOAL Academy   Alternative School Yes High 09 12 2020   grade_12 983 114 1292   47 10     6   85   1220 1317                       2537 983 114 1292   47 10     6   85   1220 1317                 2537
1807376 CO     school 804800 1420   Jefferson County R-1 80480000707 1864 Columbine High School   Regular School No High 09 12 2020   pk_12_total 1234 33 344   7 68     6   53   884 861                       1745 1234 33 344   7 68     6   53   884 861                 1745
1807589 CO     school 804800 1420   Jefferson County R-1 80480000733 3502 Golden High School   Regular School No High 09 12 2020   pk_12_total 1093 7 172   3 48     6   43   710 662                       1372 1093 7 172   3 48     6   43   710 662                 1372
1808992 CO     school 803990 1550   Poudre R-1 80399001091 7161 Preston Middle School   Regular School No Middle 06 08 2020   pk_12_total 936 12 100   1 44     6   33   600 532                       1132 936 12 100   1 44     6   33   600 532                 1132
1809489 CO     school 805280 1790   Limon RE-4J 80528000871 5136 Limon Junior-Senior High School   Regular School No High 06 12 2020   pk_12_total 211 6 36   2 4     6   3   136 132                       268 211 6 36   2 4     6   3   136 132                 268
1812350 CO     school 800020 8001   Charter School Institute 80002006542 2067 Colorado Early College Fort Collins   Regular School Yes High 06 12 2020   pk_12_total 1023 18 187   1 44     6   40   641 678                       1319 1023 18 187   1 44     6   40   641 678                 1319
1803693 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2020   pk_12_total 23 117 695   3 5     59   11   461 452                       913 23 117 695   3 5     59   11   461 452                 913
1799948 CO     school 802580 40   School District 27J 80258000144 1022 Brighton High School   Regular School No High 09 12 2020   pk_12_total 754 16 962   9 16     5   54   921 895                       1816 754 16 962   9 16     5   54   921 895                 1816
1800203 CO     school 807230 70   Westminster Public Schools 80723006373 4465 Josephine Hodgkins Leadership Academy   Regular School No Elementary PK 06 2020   pk_12_total 111 4 502   5 12     5   12   340 311                       651 111 4 502   5 12     5   12   340 311                 651
1800215 CO     school 807230 70   Westminster Public Schools 80723001242 5834 Mesa Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 66 9 199   7 12     5   7   160 145                       305 66 9 199   7 12     5   7   160 145                 305
1800256 CO     school 807230 70   Westminster Public Schools 80723001248 8406 Sunset Ridge Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 50 2 242   2 6     5   7   167 147                       314 50 2 242   2 6     5   7   167 147                 314
1800277 CO     school 807230 70   Westminster Public Schools 80723001254 9466 Westminster High School   Regular School No High 09 12 2020   grade_10 88 13 484   6 36     5   16   345 303                       648 88 13 484   6 36     5   16   345 303                 648
1800294 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 328 14 750   14 2     5   29   603 539                       1142 328 14 750   14 2     5   29   603 539                 1142
1800615 CO     school 802910 130   Cherry Creek 5 80291006182 3988 Highline Community Elementary School   Regular School No Elementary PK 05 2020   grade_1 15 25 44   1 6     5   0   53 43                       96 15 25 44   1 6     5   0   53 43                 96
1800680 CO     school 802910 130   Cherry Creek 5 80291000197 4975 Laredo Middle School   Regular School No Middle 06 08 2020   pk_12_total 457 156 275   13 67     5   79   523 529                       1052 457 156 275   13 67     5   79   523 529                 1052
1800732 CO     school 802910 130   Cherry Creek 5 80291006183 6820 Peakview Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 348 37 97   0 31     5   54   292 280                       572 348 37 97   0 31     5   54   292 280                 572
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
1800790 CO     school 802910 130   Cherry Creek 5 80291000203 8020 Smoky Hill High School   Regular School No High 09 12 2020   grade_9 259 99 132   6 33     5   51   317 268                       585 259 99 132   6 33     5   51   317 268                 585
1801053 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   pk_12_total 100 132 168   4 5     5   31   231 214                       445 100 132 168   4 5     5   31   231 214                 445
1801108 CO     school 802340 180   Adams-Arapahoe 28J 80234000056 1458 Aurora Central High School   Regular School No High 09 12 2020   grade_11 16 66 339   2 27     5   4   228 231                       459 16 66 339   2 27     5   4   228 231                 459
1801196 CO     school 802340 180   Adams-Arapahoe 28J 80234000063 3354 Gateway High School   Regular School No High 09 12 2020   grade_12 53 105 248   5 19     5   19   267 187                       454 53 105 248   5 19     5   19   267 187                 454
1801254 CO     school 802340 180   Adams-Arapahoe 28J 80234000069 4973 Laredo Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 50 73 275   5 13     5   20   239 202                       441 50 73 275   5 13     5   20   239 202                 441
1801385 CO     school 802340 180   Adams-Arapahoe 28J 80234000078 7932 Sixth Avenue Elementary School   Regular School No Elementary PK 05 2020   grade_2 5 15 44   1 1     5   3   32 42                       74 5 15 44   1 1     5   3   32 42                 74
1801387 CO     school 802340 180   Adams-Arapahoe 28J 80234000078 7932 Sixth Avenue Elementary School   Regular School No Elementary PK 05 2020   grade_4 1 12 53   0 0     5   2   39 34                       73 1 12 53   0 0     5   2   39 34                 73
1801392 CO     school 802340 180   Adams-Arapahoe 28J 80234000079 8078 South Middle School   Regular School No Middle 06 08 2020   grade_6 17 32 158   3 5     5   5   112 113                       225 17 32 158   3 5     5   5   112 113                 225
1801431 CO     school 802340 180   Adams-Arapahoe 28J 80234001294 9059 Vassar Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 106 103 198   6 36     5   66   276 244                       520 106 103 198   6 36     5   66   276 244                 520
1801672 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2020   pk_12_total 518 70 1173   6 3     5   21   897 899                       1796 518 70 1173   6 3     5   21   897 899                 1796
1802966 CO     school 803360 880   Denver County 1 80336006515 1295 Collegiate Preparatory Academy   Regular School No High 09 12 2020   grade_11 4 29 55   0 2     5   5   48 52                       100 4 29 55   0 2     5   5   48 52                 100
1803155 CO     school 803360 880   Denver County 1 80336006546 2181 DSST: Green Valley Ranch Middle School   Regular School Yes Middle 06 08 2020   grade_6 9 40 94   0 11     5   2   89 72                       161 9 40 94   0 11     5   2   89 72                 161
1803217 CO     school 803360 880   Denver County 1 80336006528 2209 DCIS at Montbello   Regular School No High 06 12 2020   grade_8 1 13 122   0 2     5   2   84 61                       145 1 13 122   0 2     5   2   84 61                 145
1803657 CO     school 803360 880   Denver County 1 80336001406 5605 Dr. Martin Luther King Jr. Early College   Regular School No High 06 12 2020   grade_6 3 35 55   0 14     5   2   55 59                       114 3 35 55   0 14     5   2   55 59                 114

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