Data source: Big Local News · About: Big Local

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

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
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
1799318 CO     school 805550 10   Mapleton 1 80555001858 212 Mapleton Early College High School   Regular School No High 09 12 2020   grade_9 7 0 64   1 2     0   1   26 49                       75 7 0 64   1 2     0   1   26 49                 75
1799323 CO     school 805550 10   Mapleton 1 80555001860 263 Global Leadership Academy   Regular School No High 09 12 2020   grade_9 3 1 84   0 2     0   1   46 45                       91 3 1 84   0 2     0   1   46 45                 91
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
1799362 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_9 5 2 69   1 5     0   0   42 40                       82 5 2 69   1 5     0   0   42 40                 82
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
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
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
1805510 CO     school 804080 1000   Fountain 8 80408000096 203 Welte Education Center   Alternative School No High 06 12 2020   grade_9 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
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
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
1805616 CO     school 803060 1010   Colorado Springs 11 80306001888 871 The Bijou School   Alternative School No High 09 12 2020   grade_9 6 1 4   0 0     0   3   7 7                       14 6 1 4   0 0     0   3   7 7                 14
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
1805674 CO     school 803060 1010   Colorado Springs 11 80306000228 1870 Coronado High School   Regular School No High 09 12 2020   grade_9 244 25 98   5 1     0   20   207 186                       393 244 25 98   5 1     0   20   207 186                 393
1805679 CO     school 803060 1010   Colorado Springs 11 80306001299 1885 Community Prep Charter School   Alternative School Yes High 09 12 2020   grade_9 7 3 3   0 0     0   0   8 5                       13 7 3 3   0 0     0   0   8 5                 13
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
1805689 CO     school 803060 1010   Colorado Springs 11 80306006580 2400 Odyssey Early College and Career Options   Alternative School No High 09 12 2020   grade_9 58 2 25   0 1     0   9   37 58                       95 58 2 25   0 1     0   9   37 58                 95
1805705 CO     school 803060 1010   Colorado Springs 11 80306000232 2528 Nikola Tesla Education Opportunity Center   Alternative School No High 06 12 2020   grade_9 12 3 9   0 1     0   0   10 15                       25 12 3 9   0 1     0   0   10 15                 25
1805799 CO     school 803060 1010   Colorado Springs 11 80306001841 5146 Eastlake High School of Colorado Springs   Alternative School Yes High 09 12 2020   grade_9 0 0 0   1 0     0   0   1 0                       1 0 0 0   1 0     0   0   1 0                 1
1805846 CO     school 803060 1010   Colorado Springs 11 80306000254 5948 Mitchell High School   Regular School No High 09 12 2020   grade_9 76 29 166   3 3     0   15   154 138                       292 76 29 166   3 3     0   15   154 138                 292
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
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
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
1806056 CO     school 805490 1030   Manitou Springs 14 80549000946 5468 Manitou Springs High School   Regular School No High 09 12 2020   grade_9 88 1 14   2 2     0   14   51 70                       121 88 1 14   2 2     0   14   51 70                 121
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
1806094 CO     school 801920 1040   Academy 20 80192006434 110 Village High School   Regular School No High 09 12 2020   grade_9 42 0 8   0 1     0   0   31 20                       51 42 0 8   0 1     0   0   31 20                 51
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
1806128 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_9 10 0 2   0 0     0   1   5 8                       13 10 0 2   0 0     0   1   5 8                 13
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
1806180 CO     school 801920 1040   Academy 20 80192001905 2195 Discovery Canyon Campus High School   Regular School No High 09 12 2020   grade_9 200 3 36   1 16     1   18   148 127                       275 200 3 36   1 16     1   18   148 127                 275
1806238 CO     school 801920 1040   Academy 20 80192001429 5126 Liberty High School   Regular School No High 09 12 2020   grade_9 279 14 77   3 13     2   32   192 228                       420 279 14 77   3 13     2   32   192 228                 420
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
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
1806316 CO     school 801920 1040   Academy 20 80192006447 8779 TCA College Pathways   Regular School Yes High 07 12 2020   grade_9 69 1 7   0 8     0   4   38 51                       89 69 1 7   0 8     0   4   38 51                 89
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
1806364 CO     school 806060 1060   Peyton 23 Jt 80606006692 6626 Peyton Online Academy   Regular School No High 05 12 2020   grade_9 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1806381 CO     school 806060 1060   Peyton 23 Jt 80606001025 6902 Peyton Senior High School   Regular School No High 09 12 2020   grade_9 45 0 4   0 1     0   3   31 22                       53 45 0 4   0 1     0   3   31 22                 53
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
1806394 CO     school 804500 1070   Hanover 28 80450006720 3941 Hanover Online Academy   Regular School No High 06 12 2020   grade_9 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
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
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
1800322 CO     school 806420 110   Sangre De Cristo Re-22J 80642001116 7630 Sangre de Cristo Undivided High School   Regular School No High 06 12 2020   grade_9 13 0 7   0 0     0   2   12 10                       22 13 0 7   0 0     0   2   12 10                 22
1806493 CO     school 803870 1110   District 49 80387006778 431 Falcon Homeschool Program   Regular School No Other KG 12 2020   grade_9 32 0 6   0 1     0   5   27 17                       44 32 0 6   0 1     0   5   27 17                 44
1806506 CO     school 803870 1110   District 49 80387006785 448 Rocky Mountain Classical Academy Homeschool   Regular School No Other KG 12 2020   grade_9 20 1 2   0 0     0   2   14 11                       25 20 1 2   0 0     0   2   14 11                 25
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
1806564 CO     school 803870 1110   District 49 80387000507 2908 Falcon High School   Regular School No High 09 12 2020   grade_9 214 13 65   2 4     1   16   156 159                       315 214 13 65   2 4     1   16   156 159                 315
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
1806601 CO     school 803870 1110   District 49 80387006744 5191 Liberty Tree Academy   Regular School Yes Other KG 09 2020   grade_9 27 0 3   0 0     1   5   18 18                       36 27 0 3   0 0     1   5   18 18                 36
1806626 CO     school 803870 1110   District 49 80387006693 6653 Power Technical Early College   Career and Technical School Yes High 06 12 2020   grade_9 36 2 13   0 0     0   5   51 5                       56 36 2 13   0 0     0   5   51 5                 56
1806631 CO     school 803870 1110   District 49 80387006403 6810 Patriot High School   Alternative School No High 09 12 2020   grade_9 5 0 2   0 0     0   0   5 2                       7 5 0 2   0 0     0   0   5 2                 7
1806636 CO     school 803870 1110   District 49 80387006694 6821 Pikes Peak Early College   Regular School No High 09 12 2020   grade_9 15 2 4   0 0     0   5   8 18                       26 15 2 4   0 0     0   5   8 18                 26
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
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
1806723 CO     school 803630 1120   Edison 54 JT 80363006648 2523 Edison Prep   Regular School No High 09 12 2020   grade_9 2 0 1   0 1     0   1   2 3                       5 2 0 1   0 1     0   1   2 3                 5
1806731 CO     school 803630 1120   Edison 54 JT 80363001278 2526 Edison Junior-Senior High School   Regular School No High 06 12 2020   grade_9 11 0 0   0 0     0   0   7 4                       11 11 0 0   0 0     0   0   7 4                 11
1806747 CO     school 805670 1130   Miami/Yoder 60 JT 80567000972 5854 Miami-Yoder Middle/High School   Regular School No High 06 12 2020   grade_9 19 0 6   0 0     0   0   14 11                       25 19 0 6   0 0     0   0   14 11                 25
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
1806817 CO     school 803960 1150   Fremont RE-2 80396000514 3002 Florence Jr./Sr. High School   Regular School No High 07 12 2020   grade_9 78 1 16   1 0     0   3   56 43                       99 78 1 16   1 0     0   3   56 43                 99
1806851 CO     school 803120 1160   Cotopaxi RE-3 80312000277 3228 Cotopaxi Junior-Senior High School   Regular School No High 06 12 2020   grade_9 20 0 1   0 0     0   0   13 8                       21 20 0 1   0 0     0   0   13 8                 21
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
1806912 CO     school 804260 1180   Roaring Fork RE-1 80426000588 3468 Glenwood Springs High School   Regular School No High 09 12 2020   grade_9 118 1 117   1 1     0   8   134 112                       246 118 1 117   1 1     0   8   134 112                 246
1806929 CO     school 804260 1180   Roaring Fork RE-1 80426000590 7422 Roaring Fork High School   Regular School No High 09 12 2020   grade_9 49 0 50   0 0     0   0   59 40                       99 49 0 50   0 0     0   0   59 40                 99
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
1806985 CO     school 806240 1195   Garfield Re-2 80624001097 7360 Rifle High School   Regular School No High 09 12 2020   grade_9 94 0 129   0 1     0   4   109 119                       228 94 0 129   0 1     0   4   109 119                 228
1800327 CO     school 803780 120   Englewood 1 80378001310 206 Colorado's Finest High School of Choice   Alternative School No High 09 12 2020   grade_9 35 0 20   0 0     0   2   32 25                       57 35 0 20   0 0     0   2   32 25                 57
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
1807020 CO     school 804380 1220   Garfield 16 80438000631 3586 Grand Valley High School   Regular School No High 09 12 2020   grade_9 61 0 33   0 0     0   2   48 48                       96 61 0 33   0 0     0   2   48 48                 96
1800389 CO     school 806540 123   Sheridan 2 80654001134 7842 Sheridan High School   Regular School No High 09 12 2020   grade_9 12 1 73   2 2     0   5   46 49                       95 12 1 73   2 2     0   5   46 49                 95
1800396 CO     school 806540 123   Sheridan 2 80654006565 8123 SOAR Academy   Alternative School No High 06 12 2020   grade_9 2 0 3   0 0     0   0   3 2                       5 2 0 3   0 0     0   0   3 2                 5
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
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
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
1800574 CO     school 802910 130   Cherry Creek 5 80291006156 2357 Eaglecrest High School   Regular School No High 09 12 2020   grade_9 378 112 178   7 65     2   54   413 383                       796 378 112 178   7 65     2   54   413 383                 796
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
1800716 CO     school 802910 130   Cherry Creek 5 80291006563 6367 Options School   Alternative School No Other KG 12 2020   grade_9 27 1 5   0 0     0   0   15 18                       33 27 1 5   0 0     0   0   15 18                 33
1800724 CO     school 802910 130   Cherry Creek 5 80291001272 6625 Overland High School   Regular School No High 09 12 2020   grade_9 119 144 219   2 27     3   35   292 257                       549 119 144 219   2 27     3   35   292 257                 549
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
1807040 CO     school 804230 1330   Gilpin County RE-1 80423001298 1634 Gilpin County Undivided High School   Regular School No High 06 12 2020   grade_9 35 1 2   0 0     0   0   18 20                       38 35 1 2   0 0     0   0   18 20                 38
1807045 CO     school 805070 1340   West Grand 1-JT 80507000830 9420 West Grand High School   Regular School No High 09 12 2020   grade_9 23 0 5   0 0     0   2   16 14                       30 23 0 5   0 0     0   2   16 14                 30
1807080 CO     school 804320 1350   East Grand 2 80432000596 5864 Middle Park High School   Regular School No High 09 12 2020   grade_9 98 0 22   1 0     0   1   55 67                       122 98 0 22   1 0     0   1   55 67                 122
1807095 CO     school 804470 1360   Gunnison Watershed RE1J 80447000655 2006 Crested Butte Secondary School   Regular School No High 06 12 2020   grade_9 63 0 2   1 0     0   1   32 35                       67 63 0 2   1 0     0   1   32 35                 67
1807107 CO     school 804470 1360   Gunnison Watershed RE1J 80447000656 3694 Gunnison High School   Regular School No High 09 12 2020   grade_9 67 0 28   0 1     0   1   49 48                       97 67 0 28   0 1     0   1   49 48                 97
1807136 CO     school 804620 1380   Hinsdale County RE 1 80462001969 4899 Lake City Community School   Regular School No Other PK 12 2020   grade_9 7 1 0   0 0     0   0   6 2                       8 7 1 0   0 0     0   0   6 2                 8
1807165 CO     school 807080 1390   Huerfano Re-1 80708001212 9212 John Mall High School   Regular School No High 09 12 2020   grade_9 14 0 27   2 0     0   0   23 20                       43 14 0 27   2 0     0   0   23 20                 43
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
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
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
1807181 CO     school 805160 1400   La Veta Re-2 80516000854 4864 La Veta Junior-Senior High School   Regular School No High 06 12 2020   grade_9 14 0 5   0 0     0   0   9 10                       19 14 0 5   0 0     0   0   9 10                 19
1807194 CO     school 807050 1410   North Park R-1 80705001209 6358 North Park School   Regular School No Other PK 12 2020   grade_9 12 0 2   0 0     0   0   8 6                       14 12 0 2   0 0     0   0   8 6                 14
1807212 CO     school 804800 1420   Jefferson County R-1 80480006163 33 McLain Community High School   Alternative School No High 07 12 2020   grade_9 2 0 7   0 0     0   0   7 2                       9 2 0 7   0 0     0   0   7 2                 9
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
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
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
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
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
1807375 CO     school 804800 1420   Jefferson County R-1 80480000707 1864 Columbine High School   Regular School No High 09 12 2020   grade_9 304 11 88   5 11     2   16   233 204                       437 304 11 88   5 11     2   16   233 204                 437
1807406 CO     school 804800 1420   Jefferson County R-1 80480001766 1880 Compass Montessori - Golden Charter School   Regular School Yes Other PK 12 2020   grade_9 30 0 7   0 0     0   3   19 21                       40 30 0 7   0 0     0   3   19 21                 40

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