Data source: Big Local News · About: Big Local

495 rows where grade = "grade_9", state = "CO" and year = 2021 sorted by black_int descending

View and edit SQL

year

  • 2021 · 495

grade

  • grade_9 · 495
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
1739677 CO     school 802910 130   Cherry Creek 5 80291001272 6625 Overland High School   Regular School No High 09 12 2021   grade_9 112 167 256   7 19     1   30   317 275                       592 112 167 256   7 19     1   30   317 275                 592
1742248 CO     school 803360 880   Denver County 1 80336000338 2398 East High School   Regular School No High 09 12 2021   grade_9 330 149 177   5 16     1   44   342 380                       722 330 149 177   5 16     1   44   342 380                 722
1739527 CO     school 802910 130   Cherry Creek 5 80291006156 2357 Eaglecrest High School   Regular School No High 09 12 2021   grade_9 406 114 186   0 41     1   56   438 366                       804 406 114 186   0 41     1   56   438 366                 804
1742327 CO     school 803360 880   Denver County 1 80336000352 3378 George Washington High School   Regular School No High 09 12 2021   grade_9 127 105 110   2 15     0   30   203 186                       389 127 105 110   2 15     0   30   203 186                 389
1740327 CO     school 802340 180   Adams-Arapahoe 28J 80234001389 7250 Rangeview High School   Regular School No High 09 12 2021   grade_9 94 93 218   2 15     3   60   249 236                       485 94 93 218   2 15     3   60   249 236                 485
1739743 CO     school 802910 130   Cherry Creek 5 80291000203 8020 Smoky Hill High School   Regular School No High 09 12 2021   grade_9 237 91 149   5 32     2   43   277 282                       559 237 91 149   5 32     2   43   277 282                 559
1743067 CO     school 803360 880   Denver County 1 80336000417 8822 Thomas Jefferson High School   Regular School No High 09 12 2021   grade_9 145 88 202   3 11     0   26   248 227                       475 145 88 202   3 11     0   26   248 227                 475
1742777 CO     school 803360 880   Denver County 1 80336006660 6368 Northfield High School   Regular School No High 09 12 2021   grade_9 212 74 131   3 8     2   31   244 217                       461 212 74 131   3 8     2   31   244 217                 461
1739448 CO     school 802910 130   Cherry Creek 5 80291001951 1551 Cherokee Trail High School   Regular School No High 09 12 2021   grade_9 453 66 138   5 70     0   42   405 369                       774 453 66 138   5 70     0   42   405 369                 774
1742641 CO     school 803360 880   Denver County 1 80336001406 5605 Dr. Martin Luther King Jr. Early College   Regular School No High 06 12 2021   grade_9 13 66 125   0 20     7   6   140 97                       237 13 66 125   0 20     7   6   140 97                 237
1739552 CO     school 802910 130   Cherry Creek 5 80291001625 3589 Grandview High School   Regular School No High 09 12 2021   grade_9 398 64 123   4 65     0   47   338 363                       701 398 64 123   4 65     0   47   338 363                 701
1740059 CO     school 802340 180   Adams-Arapahoe 28J 80234000056 1458 Aurora Central High School   Regular School No High 09 12 2021   grade_9 23 64 302   5 17     3   23   236 201                       437 23 64 302   5 17     3   23   236 201                 437
1740158 CO     school 802340 180   Adams-Arapahoe 28J 80234000063 3354 Gateway High School   Regular School No High 09 12 2021   grade_9 44 61 211   7 20     9   14   203 163                       366 44 61 211   7 20     9   14   203 163                 366
1740418 CO     school 802340 180   Adams-Arapahoe 28J 80234006451 9125 Vista Peak 9-12 Preparatory   Regular School No High 09 12 2021   grade_9 96 60 227   4 17     3   30   253 184                       437 96 60 227   4 17     3   30   253 184                 437
1744473 CO     school 804080 1000   Fountain 8 80408000562 3110 Fountain-Fort Carson High School   Regular School No High 09 12 2021   grade_9 243 60 140   4 7     8   55   264 253                       517 243 60 140   4 7     8   55   264 253                 517
1742981 CO     school 803360 880   Denver County 1 80336000408 8086 South High School   Regular School No High 09 12 2021   grade_9 211 59 199   4 23     0   25   268 253                       521 211 59 199   4 23     0   25   268 253                 521
1740173 CO     school 802340 180   Adams-Arapahoe 28J 80234000064 4024 Hinkley High School   Regular School No High 09 12 2021   grade_9 16 57 342   1 14     5   13   246 202                       448 16 57 342   1 14     5   13   246 202                 448
1742155 CO     school 803360 880   Denver County 1 80336001833 2185 DSST: Montview High School   Regular School Yes High 09 12 2021   grade_9 24 54 77   0 2     2   6   99 66                       165 24 54 77   0 2     2   6   99 66                 165
1741991 CO     school 803360 880   Denver County 1 80336006730 1529 DSST: Conservatory Green High School   Regular School Yes High 09 12 2021   grade_9 10 46 100   0 5     0   5   81 85                       166 10 46 100   0 5     0   5   81 85                 166
1744284 CO     school 804530 980   Harrison 2 80453001382 7882 Sierra High School   Regular School No High 09 12 2021   grade_9 34 44 120   2 4     1   17   127 95                       222 34 44 120   2 4     1   17   127 95                 222
1742106 CO     school 803360 880   Denver County 1 80336006450 2145 DSST: Green Valley Ranch High School   Regular School Yes High 09 12 2021   grade_9 4 40 93   0 14     2   7   77 83                       160 4 40 93   0 14     2   7   77 83                 160
1744190 CO     school 804530 980   Harrison 2 80453000667 3806 Harrison High School   Regular School No High 09 12 2021   grade_9 71 40 162   2 7     3   31   174 142                       316 71 40 162   2 7     3   31   174 142                 316
1744371 CO     school 806480 990   Widefield 3 80648001588 5841 Mesa Ridge High School   Regular School No High 09 12 2021   grade_9 159 37 106   4 7     8   43   199 165                       364 159 37 106   4 7     8   43   199 165                 364
1744423 CO     school 806480 990   Widefield 3 80648001129 9566 Widefield High School   Regular School No High 09 12 2021   grade_9 161 35 99   3 5     2   45   184 166                       350 161 35 99   3 5     2   45   184 166                 350
1739461 CO     school 802910 130   Cherry Creek 5 80291000186 1570 Cherry Creek High School   Regular School No High 09 12 2021   grade_9 645 34 133   3 126     1   61   534 469                       1003 645 34 133   3 126     1   61   534 469                 1003
1740228 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2021   grade_9 9 34 32   0 1     0   1   43 34                       77 9 34 32   0 1     0   1   43 34                 77
1742764 CO     school 803360 880   Denver County 1 80336000389 6314 North High School   Regular School No High 09 12 2021   grade_9 84 34 332   10 6     0   14   249 231                       480 84 34 332   10 6     0   14   249 231                 480
1742214 CO     school 803360 880   Denver County 1 80336006684 2228 DSST: Byers High School   Regular School Yes High 09 12 2021   grade_9 64 32 50   0 6     1   6   84 75                       159 64 32 50   0 6     1   6   84 75                 159
1744601 CO     school 803060 1010   Colorado Springs 11 80306000268 2202 Doherty High School   Regular School No High 09 12 2021   grade_9 293 32 130   3 9     4   32   247 256                       503 293 32 130   3 9     4   32   247 256                 503
1744757 CO     school 803060 1010   Colorado Springs 11 80306000254 5948 Mitchell High School   Regular School No High 09 12 2021   grade_9 104 31 154   3 4     1   18   161 154                       315 104 31 154   3 4     1   18   161 154                 315
1744774 CO     school 803060 1010   Colorado Springs 11 80306000257 6680 Palmer High School   Regular School No High 09 12 2021   grade_9 175 30 152   1 3     1   36   186 212                       398 175 30 152   1 3     1   36   186 212                 398
1742746 CO     school 803360 880   Denver County 1 80336006520 6239 Noel Community Arts School   Regular School No High 06 12 2021   grade_9 5 27 45   0 2     4   1   42 42                       84 5 27 45   0 2     4   1   42 42                 84
1745592 CO     school 803870 1110   District 49 80387001594 7613 Sand Creek High School   Regular School No High 09 12 2021   grade_9 137 27 92   0 8     2   34   154 146                       300 137 27 92   0 8     2   34   154 146                 300
1744591 CO     school 803060 1010   Colorado Springs 11 80306000228 1870 Coronado High School   Regular School No High 09 12 2021   grade_9 276 26 89   4 4     2   28   242 187                       429 276 26 89   4 4     2   28   242 187                 429
1742545 CO     school 803360 880   Denver County 1 80336006670 4509 KIPP Northeast Denver Leadership Academy   Regular School Yes High 09 12 2021   grade_9 8 25 102   1 10     0   2   83 65                       148 8 25 102   1 10     0   2   83 65                 148
1742625 CO     school 803360 880   Denver County 1 80336006328 5448 Manual High School   Regular School No High 09 12 2021   grade_9 5 23 46   1 0     0   1   43 33                       76 5 23 46   1 0     0   1   43 33                 76
1745617 CO     school 803870 1110   District 49 80387006408 8791 Vista Ridge High School   Regular School No High 09 12 2021   grade_9 234 23 95   0 17     1   45   223 192                       415 234 23 95   0 17     1   45   223 192                 415
1741944 CO     school 803360 880   Denver County 1 80336006515 1295 Collegiate Preparatory Academy   Regular School No High 09 12 2021   grade_9 4 22 66   1 3     1   2   47 52                       99 4 22 66   1 3     1   2   47 52                 99
1750771 CO     school 804410 3120   Greeley 6 80441000641 3610 Greeley Central High School   Regular School No High 09 12 2021   grade_9 69 22 305   0 5     1   4   206 200                       406 69 22 305   0 5     1   4   206 200                 406
1742279 CO     school 803360 880   Denver County 1 80336006527 2757 Northeast Early College   Regular School No High 09 12 2021   grade_9 9 21 129   0 1     3   1   95 69                       164 9 21 129   0 1     3   1   95 69                 164
1742957 CO     school 803360 880   Denver County 1 80336006689 7973 STRIVE Prep - Rise   Regular School Yes High 09 12 2021   grade_9 13 21 102   0 5     2   2   66 79                       145 13 21 102   0 5     2   2   66 79                 145
1740499 CO     school 802700 190   Byers 32J 80270006548 3362 Astravo Online Academy High School   Regular School Yes High 09 12 2021   grade_9 156 20 105   2 2     1   0   129 157                       286 156 20 105   2 2     1   0   129 157                 286
1738965 CO     school 802580 40   School District 27J 80258002003 7129 Prairie View High School   Regular School No High 09 12 2021   grade_9 158 19 239   1 18     1   22   253 205                       458 158 19 239   1 18     1   22   253 205                 458
1742127 CO     school 803360 880   Denver County 1 80336006636 2175 DSST: Cole High School   Regular School Yes High 09 12 2021   grade_9 1 18 74   1 2     0   0   39 57                       96 1 18 74   1 2     0   0   39 57                 96
1742197 CO     school 803360 880   Denver County 1 80336006528 2209 DCIS at Montbello   Regular School No High 06 12 2021   grade_9 2 18 189   0 4     8   3   136 88                       224 2 18 189   0 4     8   3   136 88                 224
1751216 CO     school 800020 8001   Charter School Institute 80002006710 1633 Colorado Early Colleges Aurora   Regular School Yes High 09 12 2021   grade_9 10 18 90   0 1     0   4   58 65                       123 10 18 90   0 1     0   4   58 65                 123
1742001 CO     school 803360 880   Denver County 1 80336001862 1748 Colorado High School Charter   Alternative School Yes High 09 12 2021   grade_9 4 17 30   2 0     0   1   26 28                       54 4 17 30   2 0     0   1   26 28                 54
1745199 CO     school 801920 1040   Academy 20 80192001321 7240 Rampart High School   Regular School No High 09 12 2021   grade_9 227 17 63   1 18     1   30   172 185                       357 227 17 63   1 18     1   30   172 185                 357
1740448 CO     school 802340 180   Adams-Arapahoe 28J 80234000082 9396 Aurora West College Preparatory Academy   Regular School No High 06 12 2021   grade_9 5 16 113   0 9     0   3   81 65                       146 5 16 113   0 9     0   3   81 65                 146
1745180 CO     school 801920 1040   Academy 20 80192001645 6937 Pine Creek High School   Regular School No High 09 12 2021   grade_9 279 15 62   2 33     2   39   237 195                       432 279 15 62   2 33     2   39   237 195                 432
1741831 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2021   grade_9 9 14 342   1 7     0   1   227 147                       374 9 14 342   1 7     0   1   227 147                 374
1742699 CO     school 803360 880   Denver County 1 80336000380 5844 Contemporary Learning Academy   Alternative School No High 09 12 2021   grade_9 3 14 14   1 0     0   3   17 18                       35 3 14 14   1 0     0   3   17 18                 35
1747905 CO     school 803990 1550   Poudre R-1 80399000545 7470 Rocky Mountain High School   Regular School No High 09 12 2021   grade_9 414 14 101   0 6     2   31   311 257                       568 414 14 101   0 6     2   31   311 257                 568
1742520 CO     school 803360 880   Denver County 1 80336006443 4494 Denver Justice High School   Alternative School Yes High 09 12 2021   grade_9 2 13 25   1 0     1   1   20 23                       43 2 13 25   1 0     1   1   20 23                 43
1743547 CO     school 803450 900   Douglas County Re 1 80345001437 3980 Highlands Ranch High School   Regular School No High 09 12 2021   grade_9 259 13 75   2 17     0   27   203 190                       393 259 13 75   2 17     0   27   203 190                 393
1744999 CO     school 801920 1040   Academy 20 80192000002 76 Air Academy High School   Regular School No High 09 12 2021   grade_9 238 13 54   4 6     0   21   160 176                       336 238 13 54   4 6     0   21   160 176                 336
1745144 CO     school 801920 1040   Academy 20 80192001429 5126 Liberty High School   Regular School No High 09 12 2021   grade_9 349 13 56   2 1     1   28   220 230                       450 349 13 56   2 1     1   28   220 230                 450
1751514 CO     school 800282 9170   Education reEnvisioned BOCES 80028206600 1550 Colorado Preparatory Academy High School   Regular School No High 09 12 2021   grade_9 161 13 76   1 3     1   19   108 166                       274 161 13 76   1 3     1   19   108 166                 274
1738611 CO     school 806900 20   Adams 12 Five Star Schools 80690001192 5816 Thornton High School   Regular School No High 09 12 2021   grade_9 83 12 291   3 11     1   11   214 198                       412 83 12 291   3 11     1   11   214 198                 412
1740132 CO     school 802340 180   Adams-Arapahoe 28J 80234006781 2654 Empower Community High School   Regular School Yes Secondary 09 10 2021   grade_9 6 12 21   0 0     0   0   16 23                       39 6 12 21   0 0     0   0   16 23                 39
1740490 CO     school 802700 190   Byers 32J 80270006605 2356 Astravo Academy High School   Regular School Yes High 09 12 2021   grade_9 91 12 29   2 4     0   0   60 78                       138 91 12 29   2 4     0   0   60 78                 138
1743333 CO     school 803450 900   Douglas County Re 1 80345001578 1503 Chaparral High School   Regular School No High 09 12 2021   grade_9 410 12 93   1 27     2   35   266 314                       580 410 12 93   1 27     2   35   266 314                 580
1745478 CO     school 803870 1110   District 49 80387000507 2908 Falcon High School   Regular School No High 09 12 2021   grade_9 220 12 50   0 5     0   19   159 147                       306 220 12 50   0 5     0   19   159 147                 306
1746645 CO     school 804800 1420   Jefferson County R-1 80480000747 4942 Lakewood High School   Regular School No High 09 12 2021   grade_9 243 12 190   5 30     2   25   240 267                       507 243 12 190   5 30     2   25   240 267                 507
1740439 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2021   grade_9 6 11 28   1 0     0   2   29 19                       48 6 11 28   1 0     0   2   29 19                 48
1742599 CO     school 803360 880   Denver County 1 80336006669 5044 Legacy Options High School   Alternative School No High 09 12 2021   grade_9 1 11 16   0 0     0   1   16 13                       29 1 11 16   0 0     0   1   16 13                 29
1743183 CO     school 803360 880   Denver County 1 80336006547 9702 West Leadership Academy   Regular School No High 06 12 2021   grade_9 3 11 107   1 0     0   4   72 54                       126 3 11 107   1 0     0   4   72 54                 126
1744199 CO     school 804530 980   Harrison 2 80453001781 4378 James Irwin Charter High School   Regular School Yes High 09 12 2021   grade_9 35 11 72   2 3     1   5   69 60                       129 35 11 72   2 3     1   5   69 60                 129
1749115 CO     school 804050 2405   Fort Morgan Re-3 80405000557 3078 Fort Morgan High School   Regular School No High 09 12 2021   grade_9 61 11 149   1 0     0   2   120 104                       224 61 11 149   1 0     0   2   120 104                 224
1738372 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_9 186 10 67   0 2     0   11   119 157                       276 186 10 67   0 2     0   11   119 157                 276
1738616 CO     school 806900 20   Adams 12 Five Star Schools 80690001996 6060 Mountain Range High School   Regular School No High 09 12 2021   grade_9 230 10 221   4 37     0   20   273 249                       522 230 10 221   4 37     0   20   273 249                 522
1742174 CO     school 803360 880   Denver County 1 80336006780 2199 The Cube   Regular School Yes Secondary 09 10 2021   grade_9 32 10 17   0 3     0   5   51 16                       67 32 10 17   0 3     0   5   51 16                 67
1743105 CO     school 803360 880   Denver County 1 80336006514 8995 Vista Academy   Alternative School No High 06 12 2021   grade_9 1 10 18   0 0     0   0   14 15                       29 1 10 18   0 0     0   0   14 15                 29
1743175 CO     school 803360 880   Denver County 1 80336006551 9693 West Early College   Regular School No High 06 12 2021   grade_9 7 10 101   2 0     0   3   67 56                       123 7 10 101   2 0     0   3   67 56                 123
1750776 CO     school 804410 3120   Greeley 6 80441000640 3614 Greeley West High School   Regular School No High 09 12 2021   grade_9 103 10 338   2 13     0   11   266 211                       477 103 10 338   2 13     0   11   266 211                 477
1738798 CO     school 801950 30   Adams County 14 80195000010 24 Adams City High School   Regular School No High 09 12 2021   grade_9 38 9 430   4 1     0   1   255 228                       483 38 9 430   4 1     0   1   255 228                 483
1742167 CO     school 803360 880   Denver County 1 80336006516 2188 Denver Center for 21st-Century Learning at Wyman   Alternative School No High 06 12 2021   grade_9 6 9 34   0 0     0   2   28 23                       51 6 9 34   0 0     0   2   28 23                 51
1742811 CO     school 803360 880   Denver County 1 80336001955 6509 Denver Online High School   Regular School No High 09 12 2021   grade_9 22 9 21   0 3     0   5   27 33                       60 22 9 21   0 3     0   5   27 33                 60
1742864 CO     school 803360 880   Denver County 1 80336001795 7163 Prep Academy   Alternative School No High 06 12 2021   grade_9 0 9 11   0 0     0   1   17 4                       21 0 9 11   0 0     0   1   17 4                 21
1744156 CO     school 804530 980   Harrison 2 80453006425 469 Atlas Preparatory High School   Regular School Yes High 09 12 2021   grade_9 10 9 108   1 1     1   6   67 69                       136 10 9 108   1 1     1   6   67 69                 136
1747689 CO     school 803990 1550   Poudre R-1 80399000528 3046 Fort Collins High School   Regular School No High 09 12 2021   grade_9 321 9 135   5 15     0   23   269 239                       508 321 9 135   5 15     0   23   269 239                 508
1739223 CO     school 807230 70   Westminster Public Schools 80723001254 9466 Westminster High School   Regular School No High 09 12 2021   grade_9 68 8 449   3 19     4   12   262 301                       563 68 8 449   3 19     4   12   262 301                 563
1742507 CO     school 803360 880   Denver County 1 80336000367 4444 John F Kennedy High School   Regular School No High 09 12 2021   grade_9 25 8 199   8 6     0   5   126 125                       251 25 8 199   8 6     0   5   126 125                 251
1746913 CO     school 804800 1420   Jefferson County R-1 80480000775 7114 Pomona High School   Regular School No High 09 12 2021   grade_9 163 8 120   6 7     0   7   154 157                       311 163 8 120   6 7     0   7   154 157                 311
1751544 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2021   grade_9 7 8 14   0 0     0   2   27 4                       31 7 8 14   0 0     0   2   27 4                 31
1738653 CO     school 806900 20   Adams 12 Five Star Schools 80690001188 6402 Northglenn High School   Regular School No High 09 12 2021   grade_9 112 7 396   3 11     1   10   297 243                       540 112 7 396   3 11     1   10   297 243                 540
1740360 CO     school 802340 180   Adams-Arapahoe 28J 80234000084 8356 William Smith High School   Regular School No High 09 12 2021   grade_9 7 7 68   1 7     0   3   41 52                       93 7 7 68   1 7     0   3   41 52                 93
1742772 CO     school 803360 880   Denver County 1 80336001869 6350 Bruce Randolph School   Regular School No High 06 12 2021   grade_9 3 7 119   0 0     0   1   74 56                       130 3 7 119   0 0     0   1   74 56                 130
1744606 CO     school 803060 1010   Colorado Springs 11 80306006580 2400 Odyssey Early College and Career Options   Alternative School No High 09 12 2021   grade_9 63 7 23   0 2     0   9   38 66                       104 63 7 23   0 2     0   9   38 66                 104
1745434 CO     school 803870 1110   District 49 80387002027 555 Banning Lewis Ranch Academy   Regular School Yes Other KG 12 2021   grade_9 62 7 19   1 7     0   16   64 48                       112 62 7 19   1 7     0   16   64 48                 112
1746162 CO     school 804800 1420   Jefferson County R-1 80480000695 378 Arvada West High School   Regular School No High 09 12 2021   grade_9 384 7 72   0 11     1   22   252 245                       497 384 7 72   0 11     1   22   252 245                 497
1749560 CO     school 806120 2690   Pueblo City 60 80612001037 1454 Central High School   Regular School No High 09 12 2021   grade_9 67 7 186   3 1     0   9   135 138                       273 67 7 186   3 1     0   9   135 138                 273
1750208 CO     school 804860 2862   Julesburg Re-1 80486006387 4369 Destinations Career Academy of Colorado   Alternative School No High 06 12 2021   grade_9 52 7 40   1 4     0   11   65 50                       115 52 7 40   1 4     0   11   65 50                 115
1738556 CO     school 806900 20   Adams 12 Five Star Schools 80690001491 4108 Horizon High School   Regular School No High 09 12 2021   grade_9 294 6 176   1 31     0   21   249 280                       529 294 6 176   1 31     0   21   249 280                 529
1738580 CO     school 806900 20   Adams 12 Five Star Schools 80690001784 5043 Legacy High School   Regular School No High 09 12 2021   grade_9 392 6 138   1 43     1   29   314 296                       610 392 6 138   1 43     1   29   314 296                 610
1738886 CO     school 802580 40   School District 27J 80258000144 1022 Brighton High School   Regular School No High 09 12 2021   grade_9 201 6 280   4 6     3   9   256 253                       509 201 6 280   4 6     3   9   256 253                 509
1738901 CO     school 802580 40   School District 27J 80258006474 2399 Eagle Ridge Academy   Regular School Yes High 09 12 2021   grade_9 82 6 63   0 5     0   5   78 83                       161 82 6 63   0 5     0   5   78 83                 161
1739306 CO     school 803780 120   Englewood 1 80378000491 2746 Englewood High School   Regular School No High 09 12 2021   grade_9 67 6 69   1 4     1   6   86 68                       154 67 6 69   1 4     1   6   86 68                 154
1739806 CO     school 805310 140   Littleton 6 80531000873 298 Arapahoe High School   Regular School No High 09 12 2021   grade_9 340 6 58   2 11     0   24   254 187                       441 340 6 58   2 11     0   24   254 187                 441
1739869 CO     school 805310 140   Littleton 6 80531000884 5224 Littleton High School   Regular School No High 09 12 2021   grade_9 200 6 109   4 7     1   14   170 171                       341 200 6 109   4 7     1   14   170 171                 341

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