Data source: Big Local News · About: Big Local

620 rows where grade = "grade_8", state = "CO" and year = 2020 sorted by district_state_id

View and edit SQL

year

  • 2020 · 620

grade

  • grade_8 · 620
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
1799312 CO     school 805550 10   Mapleton 1 80555001857 187 Mapleton Expeditionary School of the Arts   Regular School No High 07 12 2020   grade_8 20 3 94   1 2     1   4   65 60                       125 20 3 94   1 2     1   4   65 60                 125
1799337 CO     school 805550 10   Mapleton 1 80555002021 501 Monterey Community School   Regular School No Elementary KG 08 2020   grade_8 3 0 49   0 2     0   0   24 30                       54 3 0 49   0 2     0   0   24 30                 54
1799347 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2020   grade_8 6 1 41   0 0     0   0   27 21                       48 6 1 41   0 0     0   0   27 21                 48
1799361 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_8 7 1 48   0 2     0   0   31 27                       58 7 1 48   0 2     0   0   31 27                 58
1799381 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2020   grade_8 4 4 44   0 2     0   1   24 31                       55 4 4 44   0 2     0   1   24 31                 55
1799410 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2020   grade_8 6 2 39   0 6     0   2   28 27                       55 6 2 39   0 6     0   2   28 27                 55
1799428 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2020   grade_8 170 12 73   1 2     0   12   108 162                       270 170 12 73   1 2     0   12   108 162                 270
1799436 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2020   grade_8 3 1 48   0 1     0   0   28 25                       53 3 1 48   0 1     0   0   28 25                 53
1799453 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   grade_8 10 1 44   0 0     0   1   29 27                       56 10 1 44   0 0     0   1   29 27                 56
1800286 CO     school 802070 100   Alamosa RE-11J 80207000026 114 Ortega Middle School   Regular School No Middle 06 08 2020   grade_8 52 2 116   0 3     2   4   87 92                       179 52 2 116   0 3     2   4   87 92                 179
1800305 CO     school 802070 100   Alamosa RE-11J 80207006508 368 Alamosa Ombudsman School of Excellence   Alternative School No High 06 12 2020   grade_8 0 0 5   0 0     0   0   3 2                       5 0 0 5   0 0     0   0   3 2                 5
1805514 CO     school 804080 1000   Fountain 8 80408000561 1332 Carson Middle School   Regular School No Middle 06 08 2020   grade_8 89 30 46   3 8     3   13   89 103                       192 89 30 46   3 8     3   13   89 103                 192
1805540 CO     school 804080 1000   Fountain 8 80408000563 3106 Fountain Middle School   Regular School No Middle 06 08 2020   grade_8 168 36 96   2 3     3   30   178 160                       338 168 36 96   2 3     3   30   178 160                 338
1805590 CO     school 803060 1010   Colorado Springs 11 80306006428 269 Achieve Online   Alternative School No High 06 12 2020   grade_8 21 3 8   1 0     0   3   20 16                       36 21 3 8   1 0     0   3   20 16                 36
1805609 CO     school 803060 1010   Colorado Springs 11 80306006456 517 Academy for Advanced and Creative Learning   Regular School Yes Elementary KG 08 2020   grade_8 19 0 3   0 0     0   4   12 14                       26 19 0 3   0 0     0   4   12 14                 26
1805704 CO     school 803060 1010   Colorado Springs 11 80306000232 2528 Nikola Tesla Education Opportunity Center   Alternative School No High 06 12 2020   grade_8 8 3 4   1 0     0   3   8 11                       19 8 3 4   1 0     0   3   8 11                 19
1805725 CO     school 803060 1010   Colorado Springs 11 80306006379 3360 Galileo School of Math and Science   Regular School No Middle 06 08 2020   grade_8 68 22 70   0 1     1   12   88 86                       174 68 22 70   0 1     1   12   88 86                 174
1805761 CO     school 803060 1010   Colorado Springs 11 80306000241 4070 Holmes Middle School   Regular School No Middle 06 08 2020   grade_8 154 8 37   3 4     1   13   125 95                       220 154 8 37   3 4     1   13   125 95                 220
1805765 CO     school 803060 1010   Colorado Springs 11 80306000242 4090 Mann Middle School   Regular School No Middle 06 08 2020   grade_8 73 9 61   1 0     1   16   73 88                       161 73 9 61   1 0     1   16   73 88                 161
1805786 CO     school 803060 1010   Colorado Springs 11 80306001683 4424 Jenkins Middle School   Regular School No Middle 06 08 2020   grade_8 216 19 61   0 8     3   12   167 152                       319 216 19 61   0 8     3   12   167 152                 319
1805858 CO     school 803060 1010   Colorado Springs 11 80306000256 6306 North Middle School   Regular School No Middle 06 08 2020   grade_8 92 17 85   1 3     1   13   93 119                       212 92 17 85   1 3     1   13   93 119                 212
1805897 CO     school 803060 1010   Colorado Springs 11 80306000263 7523 Russell Middle School   Regular School No Middle 06 08 2020   grade_8 96 22 72   0 0     0   17   101 106                       207 96 22 72   0 0     0   17   101 106                 207
1805901 CO     school 803060 1010   Colorado Springs 11 80306000234 7556 Sabin Middle School   Regular School No Middle 06 08 2020   grade_8 127 18 87   3 5     1   24   141 124                       265 127 18 87   3 5     1   24   141 124                 265
1805929 CO     school 803060 1010   Colorado Springs 11 80306006421 8457 Jack Swigert Aerospace Academy   Regular School No Middle 06 08 2020   grade_8 61 21 87   2 1     0   4   94 82                       176 61 21 87   2 1     0   4   94 82                 176
1805949 CO     school 803060 1010   Colorado Springs 11 80306000272 9404 West Middle School   Regular School No Middle 06 08 2020   grade_8 69 6 14   1 1     0   8   55 44                       99 69 6 14   1 1     0   8   55 44                 99
1805992 CO     school 802940 1020   Cheyenne Mountain 12 80294000209 1588 Cheyenne Mountain Junior High School   Regular School No Middle 07 08 2020   grade_8 229 2 43   1 6     1   22   162 142                       304 229 2 43   1 6     1   22   162 142                 304
1806034 CO     school 802940 1020   Cheyenne Mountain 12 80294006402 9051 The Vanguard School (Middle)   Regular School Yes Middle 07 08 2020   grade_8 62 4 17   0 13     2   9   50 57                       107 62 4 17   0 13     2   9   50 57                 107
1806051 CO     school 805490 1030   Manitou Springs 14 80549000945 5464 Manitou Springs Middle School   Regular School No Middle 06 08 2020   grade_8 117 0 17   1 4     0   6   65 80                       145 117 0 17   1 4     0   6   65 80                 145
1806084 CO     school 801920 1040   Academy 20 80192000001 74 Challenger Middle School   Regular School No Middle 06 08 2020   grade_8 186 9 25   1 22     0   16   139 120                       259 186 9 25   1 22     0   16   139 120                 259
1806100 CO     school 801920 1040   Academy 20 80192000858 209 Aspen Valley Campus   Alternative School No High 07 12 2020   grade_8 23 0 4   0 0     0   0   15 12                       27 23 0 4   0 0     0   0   15 12                 27
1806115 CO     school 801920 1040   Academy 20 80192006788 1421 Chinook Trail Middle School   Regular School No Middle 06 08 2020   grade_8 72 3 16   1 8     0   14   56 58                       114 72 3 16   1 8     0   14   56 58                 114
1806127 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_8 34 0 2   0 1     0   0   18 19                       37 34 0 2   0 1     0   0   18 19                 37
1806148 CO     school 801920 1040   Academy 20 80192001931 1629 The Classical Academy Middle School   Regular School Yes Middle 07 08 2020   grade_8 167 4 17   0 5     0   3   91 105                       196 167 4 17   0 5     0   3   91 105                 196
1806162 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2020   grade_8 28 1 6   0 2     0   0   18 19                       37 28 1 6   0 2     0   0   18 19                 37
1806167 CO     school 801920 1040   Academy 20 80192006616 1921 Discovery Canyon Campus Middle School   Regular School No Middle 06 08 2020   grade_8 205 5 46   1 20     0   27   156 148                       304 205 5 46   1 20     0   27   156 148                 304
1806192 CO     school 801920 1040   Academy 20 80192001402 2358 Eagleview Middle School   Regular School No Middle 06 08 2020   grade_8 240 7 63   2 7     0   23   170 172                       342 240 7 63   2 7     0   23   170 172                 342
1806242 CO     school 801920 1040   Academy 20 80192001593 6140 Mountain Ridge Middle School   Regular School No Middle 06 08 2020   grade_8 230 20 56   1 18     3   30   175 183                       358 230 20 56   1 18     3   30   175 183                 358
1806315 CO     school 801920 1040   Academy 20 80192006447 8779 TCA College Pathways   Regular School Yes High 07 12 2020   grade_8 49 3 7   0 1     1   7   18 50                       68 49 3 7   0 1     1   7   18 50                 68
1806329 CO     school 801920 1040   Academy 20 80192001462 8851 Timberview Middle School   Regular School No Middle 06 08 2020   grade_8 300 12 47   3 1     1   25   191 198                       389 300 12 47   3 1     1   25   191 198                 389
1806350 CO     school 803750 1050   Ellicott 22 80375001735 2640 Ellicott Middle School   Regular School No Middle 06 08 2020   grade_8 55 2 26   1 0     1   3   45 43                       88 55 2 26   1 0     1   3   45 43                 88
1806363 CO     school 806060 1060   Peyton 23 Jt 80606006692 6626 Peyton Online Academy   Regular School No High 05 12 2020   grade_8 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1806376 CO     school 806060 1060   Peyton 23 Jt 80606001399 6900 Peyton Junior High School   Regular School No Middle 07 08 2020   grade_8 35 2 3   0 1     0   4   26 19                       45 35 2 3   0 1     0   4   26 19                 45
1806388 CO     school 804500 1070   Hanover 28 80450000661 3758 Hanover Junior-Senior High School   Regular School No High 06 12 2020   grade_8 11 0 12   0 0     0   1   13 11                       24 11 0 12   0 0     0   1   13 11                 24
1806431 CO     school 805820 1080   Lewis-Palmer 38 80582001536 5093 Monument Charter Academy   Regular School Yes Elementary PK 08 2020   grade_8 98 1 13   1 3     0   2   58 60                       118 98 1 13   1 3     0   2   58 60                 118
1806447 CO     school 805820 1080   Lewis-Palmer 38 80582001002 5098 Lewis-Palmer Middle School   Regular School No Middle 07 08 2020   grade_8 399 5 49   2 5     0   20   253 227                       480 399 5 49   2 5     0   20   253 227                 480
1800321 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_8 7 0 10   3 1     0   2   6 17                       23 7 0 10   3 1     0   2   6 17                 23
1806492 CO     school 803870 1110   District 49 80387006778 431 Falcon Homeschool Program   Regular School No Other KG 12 2020   grade_8 35 0 6   0 0     0   2   28 15                       43 35 0 6   0 0     0   2   28 15                 43
1806505 CO     school 803870 1110   District 49 80387006785 448 Rocky Mountain Classical Academy Homeschool   Regular School No Other KG 12 2020   grade_8 29 3 4   0 2     0   3   17 24                       41 29 3 4   0 2     0   3   17 24                 41
1806518 CO     school 803870 1110   District 49 80387002027 555 Banning Lewis Ranch Academy   Regular School Yes Other KG 11 2020   grade_8 81 7 18   1 7     0   16   64 66                       130 81 7 18   1 7     0   16   64 66                 130
1806547 CO     school 803870 1110   District 49 80387006462 2877 Springs Studio for Academic Excellence   Regular School No Other KG 12 2020   grade_8 39 3 7   0 0     0   4   26 27                       53 39 3 7   0 0     0   4   26 27                 53
1806559 CO     school 803870 1110   District 49 80387000506 2906 Falcon Middle School   Regular School No Middle 06 08 2020   grade_8 239 13 60   0 3     0   14   182 147                       329 239 13 60   0 3     0   14   182 147                 329
1806573 CO     school 803870 1110   District 49 80387001393 4102 Horizon Middle School   Regular School No Middle 06 08 2020   grade_8 131 20 69   1 8     1   29   130 129                       259 131 20 69   1 8     1   29   130 129                 259
1806582 CO     school 803870 1110   District 49 80387006386 4251 Grand Peak Academy   Regular School Yes Elementary KG 08 2020   grade_8 26 4 12   0 0     0   2   15 29                       44 26 4 12   0 0     0   2   15 29                 44
1806600 CO     school 803870 1110   District 49 80387006744 5191 Liberty Tree Academy   Regular School Yes Other KG 09 2020   grade_8 38 0 2   2 0     0   0   16 26                       42 38 0 2   2 0     0   0   16 26                 42
1806625 CO     school 803870 1110   District 49 80387006693 6653 Power Technical Early College   Career and Technical School Yes High 06 12 2020   grade_8 49 0 22   0 0     0   8   68 11                       79 49 0 22   0 0     0   8   68 11                 79
1806645 CO     school 803870 1110   District 49 80387001844 6935 Pikes Peak School Expeditionary Learning   Regular School Yes Elementary KG 08 2020   grade_8 25 2 5   0 2     0   3   21 16                       37 25 2 5   0 2     0   3   21 16                 37
1806671 CO     school 803870 1110   District 49 80387002000 7463 Rocky Mountain Classical Academy   Regular School Yes Elementary KG 08 2020   grade_8 48 4 17   0 2     1   12   42 42                       84 48 4 17   0 2     1   12   42 42                 84
1806681 CO     school 803870 1110   District 49 80387001799 7960 Skyview Middle School   Regular School No Middle 06 08 2020   grade_8 201 27 97   1 15     1   38   216 164                       380 201 27 97   1 15     1   38   216 164                 380
1806730 CO     school 803630 1120   Edison 54 JT 80363001278 2526 Edison Junior-Senior High School   Regular School No High 06 12 2020   grade_8 3 0 1   0 0     0   0   4 0                       4 3 0 1   0 0     0   0   4 0                 4
1806746 CO     school 805670 1130   Miami/Yoder 60 JT 80567000972 5854 Miami-Yoder Middle/High School   Regular School No High 06 12 2020   grade_8 10 0 5   0 0     0   1   8 8                       16 10 0 5   0 0     0   1   8 8                 16
1806754 CO     school 802790 1140   Canon City RE-1 80279000171 1262 Canon City Middle School   Regular School No Middle 06 08 2020   grade_8 118 1 17   1 2     0   4   72 71                       143 118 1 17   1 2     0   4   72 71                 143
1806768 CO     school 802790 1140   Canon City RE-1 80279000173 3802 Harrison School   Regular School No Elementary KG 08 2020   grade_8 86 0 13   1 0     0   2   55 47                       102 86 0 13   1 0     0   2   55 47                 102
1806792 CO     school 802790 1140   Canon City RE-1 80279001538 6752 Mount View Core Knowledge Charter School   Regular School Yes Elementary PK 08 2020   grade_8 23 0 3   0 0     0   1   12 15                       27 23 0 3   0 0     0   1   12 15                 27
1806802 CO     school 802790 1140   Canon City RE-1 80279001433 7950 Canon Exploratory School   Regular School No Elementary KG 08 2020   grade_8 12 0 8   0 0     0   2   8 14                       22 12 0 8   0 0     0   2   8 14                 22
1806816 CO     school 803960 1150   Fremont RE-2 80396000514 3002 Florence Jr./Sr. High School   Regular School No High 07 12 2020   grade_8 86 1 21   1 1     0   9   62 57                       119 86 1 21   1 1     0   9   62 57                 119
1806850 CO     school 803120 1160   Cotopaxi RE-3 80312000277 3228 Cotopaxi Junior-Senior High School   Regular School No High 06 12 2020   grade_8 12 0 1   0 1     0   0   7 7                       14 12 0 1   0 1     0   0   7 7                 14
1806860 CO     school 804260 1180   Roaring Fork RE-1 80426001505 429 Carbondale Community Charter School   Regular School Yes Elementary KG 08 2020   grade_8 11 0 1   0 0     0   1   5 8                       13 11 0 1   0 0     0   1   5 8                 13
1806873 CO     school 804260 1180   Roaring Fork RE-1 80426000133 561 Basalt Middle School   Regular School No Middle 05 08 2020   grade_8 52 0 60   0 1     0   2   56 59                       115 52 0 60   0 1     0   2   56 59                 115
1806887 CO     school 804260 1180   Roaring Fork RE-1 80426000586 1296 Carbondale Middle School   Regular School No Middle 05 08 2020   grade_8 36 0 52   2 0     0   1   43 48                       91 36 0 52   2 0     0   1   43 48                 91
1806907 CO     school 804260 1180   Roaring Fork RE-1 80426000587 3464 Glenwood Springs Middle School   Regular School No Middle 06 08 2020   grade_8 53 0 106   3 1     0   3   85 81                       166 53 0 106   3 1     0   3   85 81                 166
1806921 CO     school 804260 1180   Roaring Fork RE-1 80426006715 7298 Riverview School   Regular School No Elementary PK 08 2020   grade_8 14 0 25   0 0     0   3   20 22                       42 14 0 25   0 0     0   3   20 22                 42
1806980 CO     school 806240 1195   Garfield Re-2 80624001096 7356 Rifle Middle School   Regular School No Middle 06 08 2020   grade_8 90 2 109   0 0     1   5   110 97                       207 90 2 109   0 0     1   5   110 97                 207
1806989 CO     school 806240 1195   Garfield Re-2 80624001098 7388 Riverside School   Regular School No Middle 06 08 2020   grade_8 79 1 71   0 0     0   2   82 71                       153 79 1 71   0 0     0   2   82 71                 153
1800360 CO     school 803780 120   Englewood 1 80378001772 2750 Englewood Leadership Academy   Regular School No Middle 06 09 2020   grade_8 11 0 7   0 0     1   0   7 12                       19 11 0 7   0 0     1   0   7 12                 19
1800363 CO     school 803780 120   Englewood 1 80378006331 2752 Englewood Middle School   Regular School No Middle 07 08 2020   grade_8 63 7 67   1 3     0   9   90 60                       150 63 7 67   1 3     0   9   90 60                 150
1807024 CO     school 804380 1220   Garfield 16 80438001368 8274 Grand Valley Middle School   Regular School No Middle 06 08 2020   grade_8 39 1 32   0 0     0   2   37 37                       74 39 1 32   0 0     0   2   37 37                 74
1800384 CO     school 806540 123   Sheridan 2 80654001135 7837 Fort Logan Northgate   Regular School No Middle 03 08 2020   grade_8 9 2 81   1 5     1   1   48 52                       100 9 2 81   1 5     1   1   48 52                 100
1800408 CO     school 802910 130   Cherry Creek 5 80291001711 18 Liberty Middle School   Regular School No Middle 06 08 2020   grade_8 194 40 71   0 36     1   28   177 193                       370 194 40 71   0 36     1   28   177 193                 370
1800420 CO     school 802910 130   Cherry Creek 5 80291001878 141 Sky Vista Middle School   Regular School No Middle 06 08 2020   grade_8 142 52 65   2 20     0   21   174 128                       302 142 52 65   2 20     0   21   174 128                 302
1800424 CO     school 802910 130   Cherry Creek 5 80291006770 188 Colorado Skies Academy   Regular School Yes Middle 06 08 2020   grade_8 21 4 4   0 0     0   2   19 12                       31 21 4 4   0 0     0   2   19 12                 31
1800489 CO     school 802910 130   Cherry Creek 5 80291000763 1510 Challenge School   Regular School No Elementary PK 08 2020   grade_8 35 15 7   0 10     0   6   36 37                       73 35 15 7   0 10     0   6   36 37                 73
1800499 CO     school 802910 130   Cherry Creek 5 80291000185 1566 Campus Middle School   Regular School No Middle 06 08 2020   grade_8 321 14 67   2 82     0   36   299 223                       522 321 14 67   2 82     0   36   299 223                 522
1800503 CO     school 802910 130   Cherry Creek 5 80291000207 1568 West Middle School   Regular School No Middle 06 08 2020   grade_8 329 8 55   3 23     0   24   237 205                       442 329 8 55   3 23     0   24   237 205                 442
1800517 CO     school 802910 130   Cherry Creek 5 80291001152 1571 Cherry Creek Charter Academy   Regular School Yes Elementary KG 08 2020   grade_8 29 5 1   0 14     0   1   29 21                       50 29 5 1   0 14     0   1   29 21                 50
1800590 CO     school 802910 130   Cherry Creek 5 80291001672 2897 Falcon Creek Middle School   Regular School No Middle 06 08 2020   grade_8 168 18 53   3 25     0   14   148 133                       281 168 18 53   3 25     0   14   148 133                 281
1800594 CO     school 802910 130   Cherry Creek 5 80291006367 3030 Fox Ridge Middle School   Regular School No Middle 06 08 2020   grade_8 251 20 61   3 35     0   28   223 175                       398 251 20 61   3 35     0   28   223 175                 398
1800638 CO     school 802910 130   Cherry Creek 5 80291001328 4100 Horizon Middle School   Regular School No Middle 06 08 2020   grade_8 135 45 98   2 10     2   19   162 149                       311 135 45 98   2 10     2   19   162 149                 311
1800647 CO     school 802910 130   Cherry Creek 5 80291006676 4189 Heritage Heights Academy   Regular School Yes Elementary KG 08 2020   grade_8 15 0 4   0 2     0   1   11 11                       22 15 0 4   0 2     0   1   11 11                 22
1800679 CO     school 802910 130   Cherry Creek 5 80291000197 4975 Laredo Middle School   Regular School No Middle 06 08 2020   grade_8 179 45 98   5 19     3   24   181 192                       373 179 45 98   5 19     3   24   181 192                 373
1800715 CO     school 802910 130   Cherry Creek 5 80291006563 6367 Options School   Alternative School No Other KG 12 2020   grade_8 43 0 12   1 2     0   5   40 23                       63 43 0 12   1 2     0   5   40 23                 63
1800758 CO     school 802910 130   Cherry Creek 5 80291000201 7158 Prairie Middle School   Regular School No Middle 06 08 2020   grade_8 116 164 240   7 15     1   33   299 277                       576 116 164 240   7 15     1   33   299 277                 576
1800777 CO     school 802910 130   Cherry Creek 5 80291006728 7514 Infinity Middle School   Regular School No Middle 06 08 2020   grade_8 127 21 45   1 18     0   12   107 117                       224 127 21 45   1 18     0   12   107 117                 224
1800810 CO     school 802910 130   Cherry Creek 5 80291000034 8848 Thunder Ridge Middle School   Regular School No Middle 06 08 2020   grade_8 249 52 85   1 25     0   33   227 218                       445 249 52 85   1 25     0   33   227 218                 445
1807039 CO     school 804230 1330   Gilpin County RE-1 80423001298 1634 Gilpin County Undivided High School   Regular School No High 06 12 2020   grade_8 35 0 5   0 0     1   6   21 26                       47 35 0 5   0 0     1   6   21 26                 47
1807054 CO     school 805070 1340   West Grand 1-JT 80507000829 9422 West Grand Elementary and Middle School   Regular School No Elementary KG 08 2020   grade_8 16 1 13   0 0     0   0   16 14                       30 16 1 13   0 0     0   0   16 14                 30
1807059 CO     school 804320 1350   East Grand 2 80432001343 2376 East Grand Middle School   Regular School No Middle 06 08 2020   grade_8 70 0 17   0 1     0   1   39 50                       89 70 0 17   0 1     0   1   39 50                 89
1807094 CO     school 804470 1360   Gunnison Watershed RE1J 80447000655 2006 Crested Butte Secondary School   Regular School No High 06 12 2020   grade_8 54 0 2   0 0     1   1   35 23                       58 54 0 2   0 0     1   1   35 23                 58
1807111 CO     school 804470 1360   Gunnison Watershed RE1J 80447001600 3697 Gunnison Middle School   Regular School No Middle 06 08 2020   grade_8 71 0 18   0 0     0   0   43 46                       89 71 0 18   0 0     0   0   43 46                 89
1807122 CO     school 804470 1360   Gunnison Watershed RE1J 80447001507 5577 Marble Charter School   Regular School Yes Other KG 10 2020   grade_8 3 0 1   0 0     0   0   1 3                       4 3 0 1   0 0     0   0   1 3                 4
1807135 CO     school 804620 1380   Hinsdale County RE 1 80462001969 4899 Lake City Community School   Regular School No Other PK 12 2020   grade_8 3 1 0   0 0     0   0   3 1                       4 3 1 0   0 0     0   0   3 1                 4

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