Data source: Big Local News · About: Big Local

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

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
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
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
1799639 CO     school 806900 20   Adams 12 Five Star Schools 80690001784 5043 Legacy High School   Regular School No High 09 12 2020   grade_9 412 9 137   3 37     0   36   335 299                       634 412 9 137   3 37     0   36   335 299                 634
1800915 CO     school 805310 140   Littleton 6 80531000884 5224 Littleton High School   Regular School No High 09 12 2020   grade_9 189 9 93   0 9     1   17   154 164                       318 189 9 93   0 9     1   17   154 164                 318
1802268 CO     school 802490 480   Boulder Valley Re 2 80249000114 2892 Fairview High School   Regular School No High 09 12 2020   grade_9 387 9 49   2 50     0   41   284 254                       538 387 9 49   2 50     0   41   284 254                 538
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
1803540 CO     school 803360 880   Denver County 1 80336006443 4494 Denver Justice High School   Alternative School Yes High 09 12 2020   grade_9 1 9 34   1 0     0   1   21 25                       46 1 9 34   1 0     0   1   21 25                 46
1804205 CO     school 803360 880   Denver County 1 80336006551 9693 West Early College   Regular School No High 06 12 2020   grade_9 4 9 91   3 0     0   3   55 55                       110 4 9 91   3 0     0   3   55 55                 110
1805283 CO     school 804530 980   Harrison 2 80453001781 4378 James Irwin Charter High School   Regular School Yes High 09 12 2020   grade_9 56 9 59   0 4     1   17   68 78                       146 56 9 59   0 4     1   17   68 78                 146
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
1811891 CO     school 804410 3120   Greeley 6 80441000640 3614 Greeley West High School   Regular School No High 09 12 2020   grade_9 90 9 338   0 15     0   8   244 216                       460 90 9 338   0 15     0   8   244 216                 460
1801366 CO     school 802340 180   Adams-Arapahoe 28J 80234001389 7250 Rangeview High School   Regular School No High 09 12 2020   grade_9 126 89 240   0 30     3   47   271 264                       535 126 89 240   0 30     3   47   271 264                 535
1799675 CO     school 806900 20   Adams 12 Five Star Schools 80690001996 6060 Mountain Range High School   Regular School No High 09 12 2020   grade_9 231 8 201   5 18     1   17   238 243                       481 231 8 201   5 18     1   17   238 243                 481
1799712 CO     school 806900 20   Adams 12 Five Star Schools 80690001188 6402 Northglenn High School   Regular School No High 09 12 2020   grade_9 134 8 439   4 14     0   10   310 299                       609 134 8 439   4 14     0   10   310 299                 609
1800043 CO     school 802580 40   School District 27J 80258006738 7340 Riverdale Ridge High School   Regular School No Secondary 09 11 2020   grade_9 160 8 129   2 17     0   15   161 170                       331 160 8 129   2 17     0   15   161 170                 331
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
1803240 CO     school 803360 880   Denver County 1 80336006640 2241 Denver School of Innovation and Sustainable Design   Regular School No High 09 12 2020   grade_9 8 8 13   0 2     0   1   23 9                       32 8 8 13   0 2     0   1   23 9                 32
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
1804868 CO     school 803450 900   Douglas County Re 1 80345001961 7435 Rock Canyon High School   Regular School No High 09 12 2020   grade_9 437 8 61   3 59     1   13   299 283                       582 437 8 61   3 59     1   13   299 283                 582
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
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
1804097 CO     school 803360 880   Denver County 1 80336000417 8822 Thomas Jefferson High School   Regular School No High 09 12 2020   grade_9 127 75 171   3 20     1   24   245 176                       421 127 75 171   3 20     1   24   245 176                 421
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
1801522 CO     school 802700 190   Byers 32J 80270001944 1752 Colorado Virtual Academy High School   Regular School Yes High 09 12 2020   grade_9 34 7 25   0 1     0   0   34 33                       67 34 7 25   0 1     0   0   34 33                 67
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
1803883 CO     school 803360 880   Denver County 1 80336001795 7163 Prep Academy   Alternative School No High 06 12 2020   grade_9 2 7 9   0 0     0   1   10 9                       19 2 7 9   0 0     0   1   10 9                 19
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
1806273 CO     school 801920 1040   Academy 20 80192001645 6937 Pine Creek High School   Regular School No High 09 12 2020   grade_9 247 7 51   1 22     0   27   183 172                       355 247 7 51   1 22     0   27   183 172                 355
1806569 CO     school 803870 1110   District 49 80387006393 3475 GOAL Academy   Alternative School Yes High 09 12 2020   grade_9 161 7 201   6 1     2   20   196 202                       398 161 7 201   6 1     2   20   196 202                 398
1807615 CO     school 804800 1420   Jefferson County R-1 80480000736 3628 Green Mountain High School   Regular School No High 09 12 2020   grade_9 196 7 58   3 10     0   19   152 141                       293 196 7 58   3 10     0   19   152 141                 293
1807683 CO     school 804800 1420   Jefferson County R-1 80480000739 4422 Jefferson Junior/Senior High School   Regular School No High 07 12 2020   grade_9 8 7 100   3 0     1   3   57 65                       122 8 7 100   3 0     1   3   57 65                 122
1807735 CO     school 804800 1420   Jefferson County R-1 80480000747 4942 Lakewood High School   Regular School No High 09 12 2020   grade_9 265 7 203   2 25     1   21   250 274                       524 265 7 203   2 25     1   21   250 274                 524
1809035 CO     school 803990 1550   Poudre R-1 80399000545 7470 Rocky Mountain High School   Regular School No High 09 12 2020   grade_9 391 7 105   3 11     0   28   283 262                       545 391 7 105   3 11     0   28   283 262                 545
1809259 CO     school 805400 1560   Thompson R2-J 80540001786 6163 Mountain View High School   Regular School No High 09 12 2020   grade_9 188 7 85   2 2     0   11   149 146                       295 188 7 85   2 2     0   11   149 146                 295
1800599 CO     school 802910 130   Cherry Creek 5 80291001625 3589 Grandview High School   Regular School No High 09 12 2020   grade_9 436 69 108   7 102     3   57   401 381                       782 436 69 108   7 102     3   57   401 381                 782
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
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
1803796 CO     school 803360 880   Denver County 1 80336006660 6368 Northfield High School   Regular School No High 09 12 2020   grade_9 132 68 126   1 8     1   24   171 189                       360 132 68 126   1 8     1   24   171 189                 360
1805552 CO     school 804080 1000   Fountain 8 80408000562 3110 Fountain-Fort Carson High School   Regular School No High 09 12 2020   grade_9 244 65 167   6 5     16   58   287 274                       561 244 65 167   6 5     16   58   287 274                 561
1804000 CO     school 803360 880   Denver County 1 80336000408 8086 South High School   Regular School No High 09 12 2020   grade_9 254 61 151   7 35     1   18   251 276                       527 254 61 151   7 35     1   18   251 276                 527
1805363 CO     school 804530 980   Harrison 2 80453001382 7882 Sierra High School   Regular School No High 09 12 2020   grade_9 50 60 125   1 6     0   17   135 124                       259 50 60 125   1 6     0   17   135 124                 259
1801399 CO     school 802340 180   Adams-Arapahoe 28J 80234000084 8356 William Smith High School   Regular School No High 09 12 2020   grade_9 16 6 62   0 5     1   1   47 44                       91 16 6 62   0 5     1   1   47 44                 91
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
1802864 CO     school 803360 880   Denver County 1 80336001724 40 Ridge View Academy Charter School   Alternative School Yes High 07 12 2020   grade_9 15 6 24   0 0     0   1   46 0                       46 15 6 24   0 0     0   1   46 0                 46
1803173 CO     school 803360 880   Denver County 1 80336001574 2184 Denver School of the Arts   Regular School No High 06 12 2020   grade_9 118 6 37   2 10     0   8   71 110                       181 118 6 37   2 10     0   8   71 110                 181
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
1810734 CO     school 806120 2690   Pueblo City 60 80612001040 2394 East High School   Regular School No High 09 12 2020   grade_9 51 6 229   1 0     1   1   158 131                       289 51 6 229   1 0     1   1   158 131                 289
1810843 CO     school 806120 2690   Pueblo City 60 80612001064 8082 South High School   Regular School No High 09 12 2020   grade_9 79 6 175   0 1     0   8   136 133                       269 79 6 175   0 1     0   8   136 133                 269
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
1803178 CO     school 803360 880   Denver County 1 80336001833 2185 DSST: Montview High School   Regular School Yes High 09 12 2020   grade_9 14 57 70   2 5     0   7   85 70                       155 14 57 70   2 5     0   7   85 70                 155
1801455 CO     school 802340 180   Adams-Arapahoe 28J 80234006451 9125 Vista Peak 9-12 Preparatory   Regular School No High 09 12 2020   grade_9 62 56 183   3 24     0   27   185 170                       355 62 56 183   3 24     0   27   185 170                 355
1805274 CO     school 804530 980   Harrison 2 80453000667 3806 Harrison High School   Regular School No High 09 12 2020   grade_9 63 55 159   2 6     2   16   165 138                       303 63 55 159   2 6     2   16   165 138                 303
1801476 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2020   grade_9 6 5 17   0 0     0   1   19 10                       29 6 5 17   0 0     0   1   19 10                 29
1802379 CO     school 802490 480   Boulder Valley Re 2 80249001632 5999 Monarch High School   Regular School No High 09 12 2020   grade_9 314 5 46   0 25     0   26   201 215                       416 314 5 46   0 25     0   26   201 215                 416
1803002 CO     school 803360 880   Denver County 1 80336006583 1489 Compassion Road Academy   Alternative School No High 09 12 2020   grade_9 1 5 23   2 0     0   1   16 16                       32 1 5 23   2 0     0   1   16 16                 32
1803369 CO     school 803360 880   Denver County 1 80336006626 3540 Girls Athletic Leadership School High School   Regular School Yes High 09 12 2020   grade_9 9 5 16   1 1     0   1   0 33                       33 9 5 16   1 1     0   1   0 33                 33
1803618 CO     school 803360 880   Denver County 1 80336006669 5044 Legacy Options High School   Alternative School No High 09 12 2020   grade_9 0 5 18   0 0     0   1   12 12                       24 0 5 18   0 0     0   1   12 12                 24
1806039 CO     school 802940 1020   Cheyenne Mountain 12 80294006370 9057 The Vanguard School (High)   Regular School Yes High 09 12 2020   grade_9 45 5 15   0 9     0   9   31 52                       83 45 5 15   0 9     0   9   31 52                 83
1806452 CO     school 805820 1080   Lewis-Palmer 38 80582001003 5100 Lewis-Palmer High School   Regular School No High 09 12 2020   grade_9 189 5 35   1 5     0   14   133 116                       249 189 5 35   1 5     0   14   133 116                 249
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
1806548 CO     school 803870 1110   District 49 80387006462 2877 Springs Studio for Academic Excellence   Regular School No Other KG 12 2020   grade_9 36 5 6   0 0     0   4   25 26                       51 36 5 6   0 0     0   4   25 26                 51
1808014 CO     school 804800 1420   Jefferson County R-1 80480000775 7114 Pomona High School   Regular School No High 09 12 2020   grade_9 179 5 127   2 7     1   11   187 145                       332 179 5 127   2 7     1   11   187 145                 332
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
1811956 CO     school 804410 3120   Greeley 6 80441001788 6364 Northridge High School   Regular School No High 09 12 2020   grade_9 70 5 250   0 1     1   9   175 161                       336 70 5 250   0 1     1   9   175 161                 336
1805863 CO     school 803060 1010   Colorado Springs 11 80306000257 6680 Palmer High School   Regular School No High 09 12 2020   grade_9 189 47 140   6 1     2   28   206 207                       413 189 47 140   6 1     2   28   206 207                 413
1803014 CO     school 803360 880   Denver County 1 80336006730 1529 DSST: Conservatory Green High School   Regular School Yes Secondary 09 11 2020   grade_9 18 46 89   1 7     0   4   85 80                       165 18 46 89   1 7     0   4   85 80                 165
1799313 CO     school 805550 10   Mapleton 1 80555001857 187 Mapleton Expeditionary School of the Arts   Regular School No High 07 12 2020   grade_9 24 4 108   3 2     0   5   74 72                       146 24 4 108   3 2     0   5   74 72                 146
1800894 CO     school 805310 140   Littleton 6 80531000881 3930 Heritage High School   Regular School No High 09 12 2020   grade_9 337 4 71   3 12     1   12   224 216                       440 337 4 71   3 12     1   12   224 216                 440
1801840 CO     school 805370 470   St Vrain Valley RE1J 80537001889 2761 Erie High School   Regular School No High 09 12 2020   grade_9 322 4 50   1 14     0   11   203 199                       402 322 4 50   1 14     0   11   203 199                 402
1802008 CO     school 805370 470   St Vrain Valley RE1J 80537000918 6276 Niwot High School   Regular School No High 09 12 2020   grade_9 175 4 85   1 19     0   9   133 160                       293 175 4 85   1 19     0   9   133 160                 293
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
1803830 CO     school 803360 880   Denver County 1 80336001955 6509 Denver Online High School   Regular School No High 09 12 2020   grade_9 17 4 30   1 2     0   5   21 38                       59 17 4 30   1 2     0   5   21 38                 59
1804213 CO     school 803360 880   Denver County 1 80336006547 9702 West Leadership Academy   Regular School No High 06 12 2020   grade_9 5 4 112   2 0     0   1   74 50                       124 5 4 112   2 0     0   1   74 50                 124
1804470 CO     school 803450 900   Douglas County Re 1 80345000440 2230 Douglas County High School   Regular School No High 09 12 2020   grade_9 338 4 80   1 14     2   25   223 241                       464 338 4 80   1 14     2   25   223 241                 464
1806153 CO     school 801920 1040   Academy 20 80192001943 1630 The Classical Academy High School   Regular School Yes High 09 12 2020   grade_9 142 4 9   1 6     0   6   87 81                       168 142 4 9   1 6     0   6   87 81                 168
1806355 CO     school 803750 1050   Ellicott 22 80375000485 2642 Ellicott Senior High School   Regular School No High 09 12 2020   grade_9 35 4 33   0 1     2   2   39 38                       77 35 4 33   0 1     2   2   39 38                 77
1806389 CO     school 804500 1070   Hanover 28 80450000661 3758 Hanover Junior-Senior High School   Regular School No High 06 12 2020   grade_9 11 4 3   0 0     0   0   10 8                       18 11 4 3   0 0     0   0   10 8                 18
1806457 CO     school 805820 1080   Lewis-Palmer 38 80582006369 6678 Palmer Ridge High School   Regular School No High 09 12 2020   grade_9 247 4 31   0 10     1   17   170 140                       310 247 4 31   0 10     1   17   170 140                 310
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
1807422 CO     school 804800 1420   Jefferson County R-1 80480001543 2093 Dakota Ridge Senior High School   Regular School No High 09 12 2020   grade_9 270 4 70   2 25     0   11   192 190                       382 270 4 70   2 25     0   11   192 190                 382
1810133 CO     school 805790 2180   Montrose County RE-1J 80579000992 6058 Montrose High School   Regular School No High 09 12 2020   grade_9 195 4 157   2 3     1   7   170 199                       369 195 4 157   2 3     1   7   170 199                 369
1810323 CO     school 805130 2520   East Otero R-1 80513006484 5015 La Junta Jr/Sr High School   Regular School No High 07 12 2020   grade_9 38 4 77   1 1     1   2   59 65                       124 38 4 77   1 1     1   2   59 65                 124
1810949 CO     school 806150 2700   Pueblo County 70 80615001079 7208 Pueblo County High School   Regular School No High 09 12 2020   grade_9 159 4 143   0 4     0   14   165 159                       324 159 4 143   0 4     0   14   165 159                 324
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
1812323 CO     school 800020 8001   Charter School Institute 80002006310 1795 Colorado Springs Early Colleges   Regular School Yes High 09 12 2020   grade_9 64 4 25   1 2     0   9   55 50                       105 64 4 25   1 2     0   9   55 50                 105
1812613 CO     school 800282 9170   Education reEnvisioned BOCES 80028206664 6971 Pikes Peak Online School   Alternative School No High 09 12 2020   grade_9 29 4 15   0 0     0   4   24 28                       52 29 4 15   0 0     0   4   24 28                 52
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
1806702 CO     school 803870 1110   District 49 80387006408 8791 Vista Ridge High School   Regular School No High 09 12 2020   grade_9 233 36 82   2 17     5   43   221 197                       418 233 36 82   2 17     5   43   221 197                 418
1803130 CO     school 803360 880   Denver County 1 80336006450 2145 DSST: Green Valley Ranch High School   Regular School Yes High 09 12 2020   grade_9 7 34 99   0 18     0   3   77 84                       161 7 34 99   0 18     0   3   77 84                 161
1805450 CO     school 806480 990   Widefield 3 80648001588 5841 Mesa Ridge High School   Regular School No High 09 12 2020   grade_9 184 32 102   2 6     4   36   187 179                       366 184 32 102   2 6     4   36   187 179                 366
1805684 CO     school 803060 1010   Colorado Springs 11 80306000268 2202 Doherty High School   Regular School No High 09 12 2020   grade_9 263 31 126   4 13     3   39   231 248                       479 263 31 126   4 13     3   39   231 248                 479
1806677 CO     school 803870 1110   District 49 80387001594 7613 Sand Creek High School   Regular School No High 09 12 2020   grade_9 118 31 92   1 8     0   36   148 138                       286 118 31 92   1 8     0   36   148 138                 286
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
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
1800356 CO     school 803780 120   Englewood 1 80378000491 2746 Englewood High School   Regular School No High 09 12 2020   grade_9 69 3 63   0 1     0   6   82 60                       142 69 3 63   0 1     0   6   82 60                 142
1801927 CO     school 805370 470   St Vrain Valley RE1J 80537000909 5282 Longmont High School   Regular School No High 09 12 2020   grade_9 178 3 111   1 3     0   5   152 149                       301 178 3 111   1 3     0   5   152 149                 301
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
1803165 CO     school 803360 880   Denver County 1 80336001917 2183 Denver Center for International Studies   Regular School No High 06 12 2020   grade_9 16 3 68   0 3     0   2   38 54                       92 16 3 68   0 3     0   2   38 54                 92
1803295 CO     school 803360 880   Denver County 1 80336000345 2726 Emily Griffith High School   Alternative School No High 09 12 2020   grade_9 1 3 8   0 3     0   0   6 9                       15 1 3 8   0 3     0   0   6 9                 15
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

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