Data source: Big Local News · About: Big Local

489 rows where grade = "grade_9", state = "CO" and year = 2020 sorted by school

View and edit SQL

year

  • 2020 · 489

grade

  • grade_9 · 489
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
1803315 CO     school 803360 880   Denver County 1 80336006756 2994 5280 High School   Regular School Yes High 09 12 2020   grade_9 10 3 35   0 0     0   2   31 19                       50 10 3 35   0 0     0   2   31 19                 50
1810914 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   grade_9 11 0 7   0 0     0   3   13 8                       21 11 0 7   0 0     0   3   13 8                 21
1801671 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2020   grade_9 62 6 117   1 0     0   3   95 94                       189 62 6 117   1 0     0   3   95 94                 189
1802858 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2020   grade_9 9 20 302   4 7     0   2   202 142                       344 9 20 302   4 7     0   2   202 142                 344
1799328 CO     school 805550 10   Mapleton 1 80555001872 309 Academy High School   Regular School No High 09 12 2020   grade_9 11 2 118   0 2     0   4   88 49                       137 11 2 118   0 2     0   4   88 49                 137
1812206 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_9 76 2 48   0 15     0   3   73 71                       144 76 2 48   0 15     0   3   73 71                 144
1802869 CO     school 803360 880   Denver County 1 80336001894 67 Academy of Urban Learning   Alternative School Yes High 09 12 2020   grade_9 5 3 32   0 0     0   0   25 15                       40 5 3 32   0 0     0   0   25 15                 40
1805591 CO     school 803060 1010   Colorado Springs 11 80306006428 269 Achieve Online   Alternative School No High 06 12 2020   grade_9 20 1 13   0 0     0   0   15 19                       34 20 1 13   0 0     0   0   15 19                 34
1799857 CO     school 801950 30   Adams County 14 80195000010 24 Adams City High School   Regular School No High 09 12 2020   grade_9 47 11 437   2 2     1   7   263 244                       507 47 11 437   2 2     1   7   263 244                 507
1807338 CO     school 804800 1420   Jefferson County R-1 80480006587 1451 Addenbrooke Classical Academy   Regular School Yes High 06 12 2020   grade_9 47 0 16   0 0     0   4   36 31                       67 47 0 16   0 0     0   4   36 31                 67
1805213 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2020   grade_9 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
1809415 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   grade_9 2 0 7   0 0     0   0   5 4                       9 2 0 7   0 0     0   0   5 4                 9
1806089 CO     school 801920 1040   Academy 20 80192000002 76 Air Academy High School   Regular School No High 09 12 2020   grade_9 263 15 49   1 18     0   20   189 177                       366 263 15 49   1 18     0   20   189 177                 366
1811494 CO     school 802040 3030   Akron R-1 80204000025 90 Akron High School   Regular School No High 09 12 2020   grade_9 14 1 3   0 0     0   1   12 7                       19 14 1 3   0 0     0   1   12 7                 19
1807219 CO     school 804800 1420   Jefferson County R-1 80480000691 108 Alameda International Junior/Senior High School   Regular School No High 07 12 2020   grade_9 25 1 140   2 10     0   2   99 81                       180 25 1 140   2 10     0   2   99 81                 180
1800298 CO     school 802070 100   Alamosa RE-11J 80207000027 118 Alamosa High School   Regular School No High 09 12 2020   grade_9 64 0 122   3 3     0   1   97 96                       193 64 0 122   3 3     0   1   97 96                 193
1800306 CO     school 802070 100   Alamosa RE-11J 80207006508 368 Alamosa Ombudsman School of Excellence   Alternative School No High 06 12 2020   grade_9 4 0 10   0 0     0   0   10 4                       14 4 0 10   0 0     0   0   10 4                 14
1812213 CO     school 800020 8001   Charter School Institute 80002006418 75 Animas High School   Regular School Yes High 09 12 2020   grade_9 29 0 4   1 0     0   1   18 17                       35 29 0 4   1 0     0   1   18 17                 35
1802675 CO     school 802130 580   South Conejos RE-10 80213000035 252 Antonito High School   Regular School No High 09 12 2020   grade_9 2 0 9   0 0     0   0   5 6                       11 2 0 9   0 0     0   0   5 6                 11
1801752 CO     school 805370 470   St Vrain Valley RE1J 80537006539 120 Apex Home School Enrichment Program   Regular School No Other KG 12 2020   grade_9 44 0 10   0 0     0   0   28 26                       54 44 0 10   0 0     0   0   28 26                 54
1800853 CO     school 805310 140   Littleton 6 80531000873 298 Arapahoe High School   Regular School No High 09 12 2020   grade_9 400 8 45   5 15     0   31   242 262                       504 400 8 45   5 15     0   31   242 262                 504
1802110 CO     school 802490 480   Boulder Valley Re 2 80249001219 125 Arapahoe Ridge High School   Alternative School No High 09 12 2020   grade_9 0 0 3   0 0     0   0   2 1                       3 0 0 3   0 0     0   0   2 1                 3
1811510 CO     school 802220 3040   Arickaree R-2 80222000042 308 Arickaree Undivided High School   Regular School No High 06 12 2020   grade_9 7 0 1   0 0     0   0   5 3                       8 7 0 1   0 0     0   0   5 3                 8
1807242 CO     school 804800 1420   Jefferson County R-1 80480000694 370 Arvada High School   Regular School No High 09 12 2020   grade_9 76 2 124   1 6     0   3   127 85                       212 76 2 124   1 6     0   3   127 85                 212
1807247 CO     school 804800 1420   Jefferson County R-1 80480000695 378 Arvada West High School   Regular School No High 09 12 2020   grade_9 351 2 102   4 12     1   24   266 230                       496 351 2 102   4 12     1   24   266 230                 496
1804276 CO     school 803450 900   Douglas County Re 1 80345006760 79 Ascent Classical Academy   Regular School Yes Other KG 11 2020   grade_9 34 0 4   0 0     0   0   21 17                       38 34 0 4   0 0     0   0   21 17                 38
1810553 CO     school 802280 2640   Aspen 1 80228000047 432 Aspen High School   Regular School No High 09 12 2020   grade_9 113 1 19   0 1     0   2   70 66                       136 113 1 19   0 1     0   2   70 66                 136
1806101 CO     school 801920 1040   Academy 20 80192000858 209 Aspen Valley Campus   Alternative School No High 07 12 2020   grade_9 18 1 8   0 0     0   2   23 6                       29 18 1 8   0 0     0   2   23 6                 29
1801527 CO     school 802700 190   Byers 32J 80270006605 2356 Astravo Academy High School   Regular School Yes High 09 12 2020   grade_9 35 2 4   0 0     0   0   19 22                       41 35 2 4   0 0     0   0   19 22                 41
1801536 CO     school 802700 190   Byers 32J 80270006548 3362 Astravo Online Academy High School   Regular School Yes High 09 12 2020   grade_9 68 7 37   0 1     0   0   46 67                       113 68 7 37   0 1     0   0   46 67                 113
1805240 CO     school 804530 980   Harrison 2 80453006425 469 Atlas Preparatory High School   Regular School Yes High 09 12 2020   grade_9 12 7 116   0 1     1   5   66 76                       142 12 7 116   0 1     1   5   66 76                 142
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
1801485 CO     school 802340 180   Adams-Arapahoe 28J 80234000082 9396 Aurora West College Preparatory Academy   Regular School No High 06 12 2020   grade_9 5 11 102   0 9     0   3   58 72                       130 5 11 102   0 9     0   3   58 72                 130
1806519 CO     school 803870 1110   District 49 80387002027 555 Banning Lewis Ranch Academy   Regular School Yes Other KG 11 2020   grade_9 55 5 25   1 3     0   11   48 52                       100 55 5 25   1 3     0   11   48 52                 100
1806878 CO     school 804260 1180   Roaring Fork RE-1 80426000584 570 Basalt High School   Regular School No High 09 12 2020   grade_9 60 0 81   1 2     0   5   72 77                       149 60 0 81   1 2     0   5   72 77                 149
1805009 CO     school 803540 910   Eagle County RE 50 80354000461 604 Battle Mountain High School   Regular School No High 09 12 2020   grade_9 104 3 117   1 2     0   4   118 113                       231 104 3 117   1 2     0   4   118 113                 231
1808673 CO     school 802400 1530   Bayfield 10 Jt-R 80240000090 640 Bayfield High School   Regular School No High 09 12 2020   grade_9 78 0 19   2 2     0   7   54 54                       108 78 0 19   2 2     0   7   54 54                 108
1807272 CO     school 804800 1420   Jefferson County R-1 80480000697 664 Bear Creek High School   Regular School No High 09 12 2020   grade_9 184 4 175   6 28     1   14   222 190                       412 184 4 175   6 28     1   14   222 190                 412
1800120 CO     school 802430 50   Bennett 29J 80243000092 775 Bennett High School   Regular School No High 09 12 2020   grade_9 58 1 29   0 0     1   0   47 42                       89 58 1 29   0 0     1   0   47 42                 89
1809113 CO     school 805400 1560   Thompson R2-J 80540000927 812 Berthoud High School   Regular School No High 09 12 2020   grade_9 159 0 27   0 1     0   2   101 88                       189 159 0 27   0 1     0   2   101 88                 189
1808514 CO     school 802460 1490   Bethune R-5 80246000095 842 Bethune Public Schools   Regular School No Other PK 12 2020   grade_9 6 0 3   0 0     0   0   4 5                       9 6 0 3   0 0     0   0   4 5                 9
1799416 CO     school 805550 10   Mapleton 1 80555006671 695 Big Picture College and Career Academy   Regular School No High 09 12 2020   grade_9 8 0 23   0 0     0   1   17 15                       32 8 0 23   0 0     0   1   17 15                 32
1802148 CO     school 802490 480   Boulder Valley Re 2 80249000101 924 Boulder High School   Regular School No High 09 12 2020   grade_9 350 4 140   1 12     0   33   254 286                       540 350 4 140   1 12     0   33   254 286                 540
1802162 CO     school 802490 480   Boulder Valley Re 2 80249001631 934 Boulder Prep Charter High School   Alternative School Yes High 09 12 2020   grade_9 4 0 1   0 0     0   1   4 2                       6 4 0 1   0 0     0   1   4 2                 6
1802157 CO     school 802490 480   Boulder Valley Re 2 80249006463 930 Boulder Universal   Regular School No Other KG 12 2020   grade_9 3 0 1   0 0     0   0   1 3                       4 3 0 1   0 0     0   0   1 3                 4
1809442 CO     school 802520 1750   Branson Reorganized 82 80252000141 978 Branson School   Regular School No Other PK 12 2020   grade_9 8 0 1   0 0     0   0   2 7                       9 8 0 1   0 0     0   0   2 7                 9
1809428 CO     school 802520 1750   Branson Reorganized 82 80252001728 948 Branson School Online   Regular School No Other KG 12 2020   grade_9 29 0 13   0 0     1   1   16 28                       44 29 0 13   0 0     1   1   16 28                 44
1812096 CO     school 802550 3146   Briggsdale RE-10 80255000143 1012 Briggsdale Undivided High School   Regular School No High 06 12 2020   grade_9 14 0 3   0 0     0   0   9 8                       17 14 0 3   0 0     0   0   9 8                 17
1799947 CO     school 802580 40   School District 27J 80258000144 1022 Brighton High School   Regular School No High 09 12 2020   grade_9 213 3 294   1 2     1   17   271 260                       531 213 3 294   1 2     1   17   271 260                 531
1802171 CO     school 802490 480   Boulder Valley Re 2 80249000103 1070 Broomfield High School   Regular School No High 09 12 2020   grade_9 286 11 76   1 17     0   15   181 225                       406 286 11 76   1 17     0   15   181 225                 406
1803791 CO     school 803360 880   Denver County 1 80336001869 6350 Bruce Randolph School   Regular School No High 06 12 2020   grade_9 1 8 103   0 1     0   0   51 62                       113 1 8 103   0 1     0   0   51 62                 113
1810224 CO     school 802610 2395   Brush RE-2(J) 80261000154 1096 Brush High School   Regular School No High 09 12 2020   grade_9 63 0 51   0 0     1   2   62 55                       117 63 0 51   0 0     1   2   62 55                 117
1802500 CO     school 802640 490   Buena Vista R-31 80264000157 1130 Buena Vista High School   Regular School No High 09 12 2020   grade_9 76 1 15   0 1     0   6   46 53                       99 76 1 15   0 1     0   6   46 53                 99
1808533 CO     school 802670 1500   Burlington RE-6J 80267000162 1152 Burlington High School   Regular School No High 09 12 2020   grade_9 27 1 27   2 0     0   0   25 32                       57 27 1 27   2 0     0   0   25 32                 57
1801517 CO     school 802700 190   Byers 32J 80270000164 1176 Byers Junior-Senior High School   Regular School No High 07 12 2020   grade_9 31 1 10   0 0     0   0   23 19                       42 31 1 10   0 0     0   0   23 19                 42
1805653 CO     school 803060 1010   Colorado Springs 11 80306001589 1616 CIVA Charter Academy   Regular School Yes High 09 12 2020   grade_9 21 0 8   1 1     0   8   13 26                       39 21 0 8   1 1     0   8   13 26                 39
1812625 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2020   grade_9 15 6 17   0 2     0   7   41 6                       47 15 6 17   0 2     0   7   41 6                 47
1812354 CO     school 800020 8001   Charter School Institute 80002006634 2196 COLORADO EARLY COLLEGES - Douglas County   Regular School Yes High 09 12 2020   grade_9 95 2 14   1 4     0   5   52 69                       121 95 2 14   1 4     0   5   52 69                 121
1805230 CO     school 802730 970   Calhan RJ-1 80273000168 1218 Calhan Secondary School   Regular School No High 06 12 2020   grade_9 24 8 4   0 1     0   1   23 15                       38 24 8 4   0 1     0   1   23 15                 38
1809524 CO     school 806690 1828   Valley RE-1 80669001147 1224 Caliche Junior-Senior High School   Regular School No High 07 12 2020   grade_9 22 0 3   0 0     0   3   10 18                       28 22 0 3   0 0     0   3   10 18                 28
1801663 CO     school 802760 270   Campo RE-6 80276000170 1252 Campo Undivided High School   Regular School No High 06 12 2020   grade_9 2 0 2   1 0     0   0   1 4                       5 2 0 2   1 0     0   0   1 4                 5
1806759 CO     school 802790 1140   Canon City RE-1 80279000172 1266 Canon City High School   Regular School No High 09 12 2020   grade_9 229 0 47   4 4     0   12   140 156                       296 229 0 47   4 4     0   12   140 156                 296
1812267 CO     school 800020 8001   Charter School Institute 80002006305 1279 Caprock Academy   Regular School Yes Other KG 12 2020   grade_9 46 0 7   0 2     0   5   26 34                       60 46 0 7   0 2     0   5   26 34                 60
1802973 CO     school 803360 880   Denver County 1 80336000322 1319 Career Education Center Early College   Career and Technical School No High 09 12 2020   grade_9 2 1 119   0 2     0   0   58 66                       124 2 1 119   0 2     0   0   58 66                 124
1804371 CO     school 803450 900   Douglas County Re 1 80345001918 1367 Castle View High School   Regular School No High 09 12 2020   grade_9 419 3 97   3 18     1   20   285 276                       561 419 3 97   3 18     1   20   285 276                 561
1802744 CO     school 803330 870   Delta County 50(J) 80333001335 1372 Cedaredge High School   Regular School No High 09 12 2020   grade_9 68 0 8   0 0     0   2   36 42                       78 68 0 8   0 0     0   2   36 42                 78
1802620 CO     school 805100 550   North Conejos RE-1J 80510000843 1378 Centauri High School   Regular School No High 09 12 2020   grade_9 38 0 49   1 0     0   1   47 42                       89 38 0 49   1 0     0   1   47 42                 89
1802184 CO     school 802490 480   Boulder Valley Re 2 80249000107 1380 Centaurus High School   Regular School No High 09 12 2020   grade_9 222 2 140   0 8     0   19   222 169                       391 222 2 140   0 8     0   19   222 169                 391
1808828 CO     school 803990 1550   Poudre R-1 80399000517 3760 Centennial High School   Alternative School No High 09 12 2020   grade_9 0 0 2   0 0     0   0   0 2                       2 0 0 2   0 0     0   0   0 2                 2
1810685 CO     school 806120 2690   Pueblo City 60 80612001035 1402 Centennial High School   Regular School No High 09 12 2020   grade_9 64 9 158   1 7     1   2   113 129                       242 64 9 158   1 7     1   2   113 129                 242
1802688 CO     school 806360 640   Centennial R-1 80636001416 1398 Centennial School   Regular School No Other PK 12 2020   grade_9 1 0 12   0 0     0   0   8 5                       13 1 0 12   0 0     0   0   8 5                 13
1811278 CO     school 802850 2810   Center 26 JT 80285000179 1420 Center High School   Regular School No High 09 12 2020   grade_9 3 0 39   0 0     0   0   20 22                       42 3 0 39   0 0     0   0   20 22                 42
1811261 CO     school 802850 2810   Center 26 JT 80285006513 1368 Center Virtual Academy   Regular School No High 09 12 2020   grade_9 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
1809673 CO     school 804350 2000   Mesa County Valley 51 80435000600 1450 Central High School   Regular School No High 09 12 2020   grade_9 276 1 178   4 2     2   27   238 252                       490 276 1 178   4 2     2   27   238 252                 490
1810690 CO     school 806120 2690   Pueblo City 60 80612001037 1454 Central High School   Regular School No High 09 12 2020   grade_9 51 5 163   2 1     0   7   137 92                       229 51 5 163   2 1     0   7   137 92                 229
1802509 CO     school 802640 490   Buena Vista R-31 80264006155 1508 Chaffee County High School   Alternative School No High 07 12 2020   grade_9 4 0 1   0 0     0   0   4 1                       5 4 0 1   0 0     0   0   4 1                 5
1804376 CO     school 803450 900   Douglas County Re 1 80345001578 1503 Chaparral High School   Regular School No High 09 12 2020   grade_9 392 14 90   2 20     2   27   278 269                       547 392 14 90   2 20     2   27   278 269                 547
1807343 CO     school 804800 1420   Jefferson County R-1 80480001383 1522 Chatfield High School   Regular School No High 09 12 2020   grade_9 388 1 56   1 10     1   19   241 235                       476 388 1 56   1 10     1   19   241 235                 476
1810703 CO     school 806120 2690   Pueblo City 60 80612001730 1488 Chavez/Huerta K-12 Preparatory Academy   Regular School Yes Other KG 12 2020   grade_9 8 1 61   0 1     0   0   37 34                       71 8 1 61   0 1     0   0   37 34                 71
1810384 CO     school 802880 2560   Cheraw 31 80288000182 1546 Cheraw School   Regular School No Other PK 12 2020   grade_9 15 0 3   0 0     0   0   13 5                       18 15 0 3   0 0     0   0   13 5                 18
1800495 CO     school 802910 130   Cherry Creek 5 80291001951 1551 Cherokee Trail High School   Regular School No High 09 12 2020   grade_9 416 75 100   4 59     1   38   355 338                       693 416 75 100   4 59     1   38   355 338                 693
1800480 CO     school 802910 130   Cherry Creek 5 80291006791 1429 Cherry Creek Elevation   Regular School No High 09 12 2020   grade_9 17 2 1   0 0     0   2   9 13                       22 17 2 1   0 0     0   2   9 13                 22
1800508 CO     school 802910 130   Cherry Creek 5 80291000186 1570 Cherry Creek High School   Regular School No High 09 12 2020   grade_9 628 38 143   2 128     3   46   495 493                       988 628 38 143   2 128     3   46   495 493                 988
1805997 CO     school 802940 1020   Cheyenne Mountain 12 80294000211 1590 Cheyenne Mountain High School   Regular School No High 09 12 2020   grade_9 235 6 50   1 10     0   24   164 162                       326 235 6 50   1 10     0   24   164 162                 326
1802576 CO     school 800001 520   Cheyenne County Re-5 80000100215 1612 Cheyenne Wells Junior/High School   Regular School No High 07 12 2020   grade_9 15 0 1   0 0     0   0   10 6                       16 15 0 1   0 0     0   0   10 6                 16
1802602 CO     school 803000 540   Clear Creek RE-1 80300000217 4216 Clear Creek High School   Regular School No High 09 12 2020   grade_9 51 1 4   0 1     0   0   35 22                       57 51 1 4   0 1     0   0   35 22                 57
1804402 CO     school 803450 900   Douglas County Re 1 80345006494 1555 Cloverleaf Home Education   Alternative School No Other KG 12 2020   grade_9 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
1806943 CO     school 806240 1195   Garfield Re-2 80624001906 65 Coal Ridge High School   Regular School No High 09 12 2020   grade_9 66 0 70   0 0     0   5   63 78                       141 66 0 70   0 0     0   5   63 78                 141
1808097 CO     school 804800 1420   Jefferson County R-1 80480001036 7701 Collegiate Academy of Colorado   Regular School Yes Other KG 12 2020   grade_9 30 0 4   0 2     0   4   17 23                       40 30 0 4   0 2     0   4   17 23                 40
1802968 CO     school 803360 880   Denver County 1 80336006515 1295 Collegiate Preparatory Academy   Regular School No High 09 12 2020   grade_9 2 22 50   0 1     1   3   38 41                       79 2 22 50   0 1     1   3   38 41                 79
1799429 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2020   grade_9 202 10 78   4 2     2   14   156 156                       312 202 10 78   4 2     2   14   156 156                 312
1808576 CO     school 803480 1520   Durango 9-R 80348006696 1526 Colorado Connections Academy @ Durango   Regular School No Other KG 12 2020   grade_9 73 0 27   3 0     0   4   61 46                       107 73 0 27   3 0     0   4   61 46                 107
1812349 CO     school 800020 8001   Charter School Institute 80002006542 2067 Colorado Early College Fort Collins   Regular School Yes High 06 12 2020   grade_9 155 2 34   0 10     0   6   105 102                       207 155 2 34   0 10     0   6   105 102                 207
1812308 CO     school 800020 8001   Charter School Institute 80002006710 1633 Colorado Early Colleges Aurora   Regular School Yes High 09 12 2020   grade_9 11 10 52   0 4     0   2   35 44                       79 11 10 52   0 4     0   2   35 44                 79
1812290 CO     school 800020 8001   Charter School Institute 80002006779 1387 Colorado Early Colleges Windsor   Regular School Yes Other KG 12 2020   grade_9 8 0 0   0 0     0   0   2 6                       8 8 0 0   0 0     0   0   2 6                 8
1803024 CO     school 803360 880   Denver County 1 80336001862 1748 Colorado High School Charter   Alternative School Yes High 09 12 2020   grade_9 1 26 66   1 1     0   3   55 43                       98 1 26 66   1 1     0   3   55 43                 98
1803019 CO     school 803360 880   Denver County 1 80336006735 1561 Colorado High School Charter - GES   Alternative School Yes High 09 12 2020   grade_9 1 9 27   1 0     0   1   28 11                       39 1 9 27   1 0     0   1   28 11                 39
1812302 CO     school 800020 8001   Charter School Institute 80002006708 1505 Colorado Military Academy   Regular School Yes Other KG 12 2020   grade_9 20 4 12   0 2     0   1   29 10                       39 20 4 12   0 2     0   1   29 10                 39
1812608 CO     school 800282 9170   Education reEnvisioned BOCES 80028206600 1550 Colorado Preparatory Academy High School   Regular School No High 09 12 2020   grade_9 100 10 64   2 4     1   4   92 93                       185 100 10 64   2 4     1   4   92 93                 185
1812562 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   grade_9 3 1 5   0 0     0   1   2 8                       10 3 1 5   0 0     0   1   2 8                 10

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