Data source: Big Local News · About: Big Local

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

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
1801023 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2020   grade_8 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1802641 CO     school 805100 550   North Conejos RE-1J 80510006601 6339 North Conejos Alternative Program   Alternative School No Other KG 12 2020   grade_8 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1802863 CO     school 803360 880   Denver County 1 80336001724 40 Ridge View Academy Charter School   Alternative School Yes High 07 12 2020   grade_8 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1805212 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2020   grade_8 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1805436 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2020   grade_8 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
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
1808699 CO     school   1550   Poudre R-1   0 Not a school             2020   grade_8 0 0 0   0 0     0   1   0 1                       1 0 0 0   0 0     0   1   0 1                 1
1809333 CO     school 803810 1570   Estes Park R-3 80381006426 2788 Estes Park Options School   Alternative School No Other KG 12 2020   grade_8 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1809457 CO     school 804980 1760   Kim Reorganized 88 80498000823 4694 Kim Undivided High School   Regular School No High 06 12 2020   grade_8 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1810495 CO     school 804710 2620   Holyoke Re-1J 80471006610 2686 Holyoke Alternative School   Alternative School No High 07 12 2020   grade_8 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1810289 CO     school 807140 2505   Weldon Valley RE-20(J) 80714001218 9360 Weldon Valley Jr/Sr High School   Regular School No High 07 12 2020   grade_8 9 0 1   0 0     0   0   6 4                       10 9 0 1   0 0     0   0   6 4                 10
1810536 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2020   grade_8 10 0 0   0 0     0   0   4 6                       10 10 0 0   0 0     0   0   4 6                 10
1810931 CO     school 806150 2700   Pueblo County 70 80615006763 6817 PSAS Homeschool Program   Regular School No Elementary KG 08 2020   grade_8 8 0 2   0 0     0   0   8 2                       10 8 0 2   0 0     0   0   8 2                 10
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
1809347 CO     school 803810 1570   Estes Park R-3 80381000499 2792 Estes Park Middle School   Regular School No Middle 06 08 2020   grade_8 63 3 29   1 4     0   0   48 52                       100 63 3 29   1 4     0   0   48 52                 100
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
1803873 CO     school 803360 880   Denver County 1 80336006398 7045 Place Bridge Academy   Regular School No Elementary PK 08 2020   grade_8 9 34 42   0 16     0   2   55 48                       103 9 34 42   0 16     0   2   55 48                 103
1805078 CO     school 803540 910   Eagle County RE 50 80354001478 5742 Homestake Peak School   Regular School No Elementary PK 08 2020   grade_8 36 1 63   1 1     0   3   54 51                       105 36 1 63   1 1     0   3   54 51                 105
1808668 CO     school 802400 1530   Bayfield 10 Jt-R 80240000089 636 Bayfield Middle School   Regular School No Middle 06 08 2020   grade_8 77 1 20   4 1     0   2   53 52                       105 77 1 20   4 1     0   2   53 52                 105
1803082 CO     school 803360 880   Denver County 1 80336006645 1939 Compass Academy   Regular School Yes Middle 06 08 2020   grade_8 1 1 102   1 1     0   0   50 56                       106 1 1 102   1 1     0   0   50 56                 106
1804151 CO     school 803360 880   Denver County 1 80336006444 9389 STRIVE Prep - Westwood   Regular School Yes Middle 06 08 2020   grade_8 1 2 97   1 5     0   0   63 43                       106 1 2 97   1 5     0   0   63 43                 106
1804155 CO     school 803360 880   Denver County 1 80336006479 9390 STRIVE Prep - Lake   Regular School Yes Middle 06 08 2020   grade_8 2 7 97   0 0     0   0   60 46                       106 2 7 97   0 0     0   0   60 46                 106
1810702 CO     school 806120 2690   Pueblo City 60 80612001730 1488 Chavez/Huerta K-12 Preparatory Academy   Regular School Yes Other KG 12 2020   grade_8 15 1 89   0 0     1   0   54 52                       106 15 1 89   0 0     1   0   54 52                 106
1801857 CO     school 805370 470   St Vrain Valley RE1J 80537001890 2964 Flagstaff Charter Academy   Regular School Yes Elementary PK 08 2020   grade_8 85 1 12   0 5     0   4   58 49                       107 85 1 12   0 5     0   4   58 49                 107
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
1801869 CO     school 805370 470   St Vrain Valley RE1J 80537000901 3192 Thunder Valley PK-8   Regular School No Elementary PK 08 2020   grade_8 42 1 63   0 0     0   2   47 61                       108 42 1 63   0 0     0   2   47 61                 108
1803607 CO     school 803360 880   Denver County 1 80336006442 4795 Kunsmiller Creative Arts Academy   Regular School No Other KG 12 2020   grade_8 9 1 87   4 5     0   2   55 53                       108 9 1 87   4 5     0   2   55 53                 108
1810782 CO     school 806120 2690   Pueblo City 60 80612001051 4376 Risley International Academy of Innovation   Regular School No Middle 06 08 2020   grade_8 23 2 79   1 0     0   3   56 52                       108 23 2 79   1 0     0   3   56 52                 108
1808790 CO     school 803990 1550   Poudre R-1 80399000524 1190 Cache La Poudre Middle School   Regular School No Middle 06 08 2020   grade_8 90 0 10   0 0     0   9   60 49                       109 90 0 10   0 0     0   9   60 49                 109
1811716 CO     school 807350 3100   Windsor RE-4 80735006782 9563 Windsor Charter Academy Middle School   Regular School Yes Middle 06 08 2020   grade_8 87 0 14   0 4     0   4   49 60                       109 87 0 14   0 4     0   4   49 60                 109
1801647 CO     school 806990 260   Vilas RE-5 80699001207 9100 Vilas Undivided High School   Regular School No High 07 12 2020   grade_8 6 0 5   0 0     0   0   6 5                       11 6 0 5   0 0     0   0   6 5                 11
1802156 CO     school 802490 480   Boulder Valley Re 2 80249006463 930 Boulder Universal   Regular School No Other KG 12 2020   grade_8 8 0 1   0 0     0   2   5 6                       11 8 0 1   0 0     0   2   5 6                 11
1802670 CO     school 802130 580   South Conejos RE-10 80213001464 250 Antonito Middle School   Regular School No Middle 07 08 2020   grade_8 1 0 10   0 0     0   0   3 8                       11 1 0 10   0 0     0   0   3 8                 11
1802761 CO     school 803330 870   Delta County 50(J) 80333002001 2152 Delta Academy of Applied Learning   Alternative School No Middle 05 08 2020   grade_8 10 0 1   0 0     0   0   8 3                       11 10 0 1   0 0     0   0   8 3                 11
1808161 CO     school 804800 1420   Jefferson County R-1 80480006307 8036 Sobesky Academy   Special Education School No Other KG 12 2020   grade_8 7 0 3   1 0     0   0   8 3                       11 7 0 3   1 0     0   0   8 3                 11
1808466 CO     school 802260 1450   Arriba-Flagler C-20 80226000509 2960 Flagler Public School   Regular School No Other PK 12 2020   grade_8 11 0 0   0 0     0   0   4 7                       11 11 0 0   0 0     0   0   4 7                 11
1809414 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   grade_8 6 0 5   0 0     0   0   6 5                       11 6 0 5   0 0     0   0   6 5                 11
1811160 CO     school 806660 2770   Steamboat Springs RE-2 80666001749 6363 North Routt Charter School   Regular School Yes Elementary KG 08 2020   grade_8 10 0 0   0 1     0   0   2 9                       11 10 0 0   0 1     0   0   2 9                 11
1812624 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2020   grade_8 3 1 7   0 0     0   0   9 2                       11 3 1 7   0 0     0   0   9 2                 11
1802081 CO     school 805370 470   St Vrain Valley RE1J 80537006739 8055 Soaring Heights PK-8   Regular School No Elementary PK 08 2020   grade_8 85 2 19   0 2     1   1   60 50                       110 85 2 19   0 2     1   1   60 50                 110
1803226 CO     school 803360 880   Denver County 1 80336006523 2223 DSST: Cole Middle School   Regular School Yes Middle 06 08 2020   grade_8 1 28 81   0 2     0   1   49 64                       113 1 28 81   0 2     0   1   49 64                 113
1803631 CO     school 803360 880   Denver County 1 80336006490 5255 Lake Middle School   Regular School No Middle 06 08 2020   grade_8 9 15 79   6 2     0   3   60 54                       114 9 15 79   6 2     0   3   60 54                 114
1803749 CO     school 803360 880   Denver County 1 80336000386 6098 Morey Middle School   Regular School No Middle 06 08 2020   grade_8 52 22 24   0 0     0   16   72 42                       114 52 22 24   0 0     0   16   72 42                 114
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
1803579 CO     school 803360 880   Denver County 1 80336001865 4732 KIPP Sunshine Peak Academy   Regular School Yes Middle 05 08 2020   grade_8 0 2 113   0 0     0   0   48 67                       115 0 2 113   0 0     0   0   48 67                 115
1804286 CO     school 803450 900   Douglas County Re 1 80345006492 135 Ben Franklin Academy   Regular School Yes Elementary PK 08 2020   grade_8 93 2 9   0 8     1   2   55 60                       115 93 2 9   0 8     1   2   55 60                 115
1805251 CO     school 804530 980   Harrison 2 80453000662 1306 Carmel Middle School   Regular School No Middle 06 08 2020   grade_8 22 17 61   1 2     0   12   57 58                       115 22 17 61   1 2     0   12   57 58                 115
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
1812348 CO     school 800020 8001   Charter School Institute 80002006542 2067 Colorado Early College Fort Collins   Regular School Yes High 06 12 2020   grade_8 85 1 21   0 3     1   4   56 59                       115 85 1 21   0 3     1   4   56 59                 115
1802471 CO     school 802490 480   Boulder Valley Re 2 80249001517 8387 Summit Middle Charter School   Regular School Yes Middle 06 08 2020   grade_8 75 1 8   0 18     1   15   60 58                       118 75 1 8   0 18     1   15   60 58                 118
1803164 CO     school 803360 880   Denver County 1 80336001917 2183 Denver Center for International Studies   Regular School No High 06 12 2020   grade_8 16 5 84   6 6     0   1   54 64                       118 16 5 84   6 6     0   1   54 64                 118
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
1810322 CO     school 805130 2520   East Otero R-1 80513006484 5015 La Junta Jr/Sr High School   Regular School No High 07 12 2020   grade_8 33 2 77   2 1     1   2   65 53                       118 33 2 77   2 1     1   2   65 53                 118
1803995 CO     school 803360 880   Denver County 1 80336002012 8085 STRIVE Prep - Federal   Regular School Yes Middle 06 08 2020   grade_8 3 1 112   1 1     0   1   67 52                       119 3 1 112   1 1     0   1   67 52                 119
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
1807682 CO     school 804800 1420   Jefferson County R-1 80480000739 4422 Jefferson Junior/Senior High School   Regular School No High 07 12 2020   grade_8 15 6 93   3 1     0   1   52 67                       119 15 6 93   3 1     0   1   52 67                 119
1801012 CO     school 803270 170   Deer Trail 26J 80327000288 2140 Deer Trail Junior-Senior High School   Regular School No High 06 12 2020   grade_8 9 0 3   0 0     0   0   8 4                       12 9 0 3   0 0     0   0   8 4                 12
1801598 CO     school 807110 230   Walsh RE-1 80711001216 9226 Walsh High School   Regular School No High 07 12 2020   grade_8 8 0 3   1 0     0   0   8 4                       12 8 0 3   1 0     0   0   8 4                 12
1802575 CO     school 800001 520   Cheyenne County Re-5 80000100215 1612 Cheyenne Wells Junior/High School   Regular School No High 07 12 2020   grade_8 9 0 3   0 0     0   0   6 6                       12 9 0 3   0 0     0   0   6 6                 12
1808481 CO     school 806510 1460   Hi-Plains R-23 80651001130 7746 Hi-Plains School District R-23   Regular School No Other PK 12 2020   grade_8 9 0 3   0 0     0   0   6 6                       12 9 0 3   0 0     0   0   6 6                 12
1809208 CO     school 805400 1560   Thompson R2-J 80540006558 5121 LEAP School   Regular School No Other KG 12 2020   grade_8 10 0 1   0 0     0   1   5 7                       12 10 0 1   0 0     0   1   5 7                 12
1809384 CO     school 807260 1590   Primero Reorganized 2 80726001255 7164 Primero Junior-Senior High School   Regular School No High 06 12 2020   grade_8 6 0 6   0 0     0   0   4 8                       12 6 0 6   0 0     0   0   4 8                 12
1812576 CO     school 899300 9050   San Juan BOCES 89930006497 8121 Southwest Colorado eSchool   Regular School No High 06 12 2020   grade_8 9 0 3   0 0     0   0   7 5                       12 9 0 3   0 0     0   0   7 5                 12
1804746 CO     school 803450 900   Douglas County Re 1 80345006455 6365 Skyview Academy   Regular School Yes Other PK 12 2020   grade_8 86 1 14   0 13     0   6   58 62                       120 86 1 14   0 13     0   6   58 62                 120
1810548 CO     school 802280 2640   Aspen 1 80228000046 430 Aspen Middle School   Regular School No Middle 05 08 2020   grade_8 104 2 10   0 3     0   1   58 62                       120 104 2 10   0 3     0   1   58 62                 120
1811035 CO     school 806150 2700   Pueblo County 70 80615001085 9134 Vineland Middle School   Regular School No Middle 06 08 2020   grade_8 52 0 63   1 0     0   4   56 64                       120 52 0 63   1 0     0   4   56 64                 120
1802388 CO     school 802490 480   Boulder Valley Re 2 80249001573 6000 Monarch K-8 School   Regular School No Elementary PK 08 2020   grade_8 84 0 11   1 15     0   10   58 63                       121 84 0 11   1 15     0   10   58 63                 121
1804217 CO     school 803360 880   Denver County 1 80336006556 9730 STRIVE Prep - Green Valley Ranch   Regular School Yes Middle 06 08 2020   grade_8 12 23 80   0 3     0   3   49 72                       121 12 23 80   0 3     0   3   49 72                 121
1807265 CO     school 804800 1420   Jefferson County R-1 80480000696 660 Bear Creek K-8 School   Regular School No Elementary KG 08 2020   grade_8 55 1 43   2 9     2   9   65 56                       121 55 1 43   2 9     2   9   65 56                 121
1810583 CO     school 805220 2660   Lamar Re-2 80522000861 4956 Lamar Middle School   Regular School No Middle 06 08 2020   grade_8 52 0 68   1 0     0   0   64 57                       121 52 0 68   1 0     0   0   64 57                 121
1805042 CO     school 803540 910   Eagle County RE 50 80354001309 2355 Eagle Valley Middle School   Regular School No Middle 06 08 2020   grade_8 83 0 36   2 1     0   2   62 62                       124 83 0 36   2 1     0   2   62 62                 124
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
1803569 CO     school 803360 880   Denver County 1 80336006686 4513 Kepner Beacon Middle School   Regular School No Middle 06 08 2020   grade_8 8 4 110   0 3     0   1   66 60                       126 8 4 110   0 3     0   1   66 60                 126
1799782 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2020   grade_8 27 0 97   1 2     0   0   75 52                       127 27 0 97   1 2     0   0   75 52                 127
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
1808433 CO     school 803510 1430   Eads RE-1 80351001277 2332 Eads Middle School   Regular School No Middle 06 08 2020   grade_8 12 0 1   0 0     0   0   6 7                       13 12 0 1   0 0     0   0   6 7                 13
1811249 CO     school 805700 2800   Moffat 2 80570000974 5958 Moffat Prek-12 School   Regular School No Other PK 12 2020   grade_8 10 1 1   0 0     0   1   6 7                       13 10 1 1   0 0     0   1   6 7                 13
1811395 CO     school 806810 3000   Summit RE-1 80681006464 8375 Snowy Peaks Junior/Senior High School   Alternative School No High 07 12 2020   grade_8 11 0 2   0 0     0   0   8 5                       13 11 0 2   0 0     0   0   8 5                 13
1812217 CO     school 800020 8001   Charter School Institute 80002006777 149 Colorado Early Colleges Fort Collins West   Regular School Yes Middle 06 08 2020   grade_8 9 0 3   0 0     0   1   8 5                       13 9 0 3   0 0     0   1   8 5                 13
1799724 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2020   grade_8 90 0 21   1 9     0   9   57 73                       130 90 0 21   1 9     0   9   57 73                 130
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
1807228 CO     school 804800 1420   Jefferson County R-1 80480006489 109 Arvada K-8   Regular School No Elementary KG 08 2020   grade_8 46 6 67   3 2     1   6   75 56                       131 46 6 67   3 2     1   6   75 56                 131
1803560 CO     school 803360 880   Denver County 1 80336006519 4507 KIPP Northeast Denver Middle School   Regular School Yes Middle 05 08 2020   grade_8 5 27 93   0 4     0   3   68 64                       132 5 27 93   0 4     0   3   68 64                 132
1803790 CO     school 803360 880   Denver County 1 80336001869 6350 Bruce Randolph School   Regular School No High 06 12 2020   grade_8 5 5 121   0 0     0   2   77 56                       133 5 5 121   0 0     0   2   77 56                 133
1804991 CO     school 803540 910   Eagle County RE 50 80354001723 39 Gypsum Creek Middle School   Regular School No Middle 06 08 2020   grade_8 29 0 100   1 2     0   1   78 55                       133 29 0 100   1 2     0   1   78 55                 133
1811835 CO     school 804410 3120   Greeley 6 80441001614 1875 Frontier Charter Academy   Regular School Yes Other KG 12 2020   grade_8 96 0 33   0 1     1   2   60 73                       133 96 0 33   0 1     1   2   60 73                 133
1799518 CO     school 806900 20   Adams 12 Five Star Schools 80690000728 1519 Stargate Charter School   Regular School Yes Other KG 12 2020   grade_8 88 0 16   1 23     0   6   54 80                       134 88 0 16   1 23     0   6   54 80                 134
1810729 CO     school 806120 2690   Pueblo City 60 80612006361 2096 Corwin International Magnet School   Regular School No Middle 04 08 2020   grade_8 41 1 88   0 0     0   4   70 64                       134 41 1 88   0 0     0   4   70 64                 134
1802437 CO     school 802490 480   Boulder Valley Re 2 80249001792 6816 Peak to Peak Charter School   Regular School Yes Other KG 12 2020   grade_8 95 0 7   0 28     0   5   69 66                       135 95 0 7   0 28     0   5   69 66                 135
1805121 CO     school 803720 920   Elizabeth School District 80372000482 2604 Elizabeth Middle School   Regular School No Middle 06 08 2020   grade_8 118 0 14   0 0     0   3   74 61                       135 118 0 14   0 0     0   3   74 61                 135
1809729 CO     school 804350 2000   Mesa County Valley 51 80435000605 2392 East Middle School   Regular School No Middle 06 08 2020   grade_8 102 0 24   0 4     0   5   75 60                       135 102 0 24   0 4     0   5   75 60                 135
1810936 CO     school 806150 2700   Pueblo County 70 80615001078 7086 Pleasant View Middle School   Regular School No Middle 06 08 2020   grade_8 73 1 58   0 0     0   4   65 71                       136 73 1 58   0 0     0   4   65 71                 136
1801570 CO     school 802190 220   Archuleta County 50 Jt 80219000040 6657 Pagosa Springs Middle School   Regular School No Middle 05 08 2020   grade_8 67 2 51   12 0     0   5   75 62                       137 67 2 51   12 0     0   5   75 62                 137
1801986 CO     school 805370 470   St Vrain Valley RE1J 80537006594 6010 Timberline PK-8   Regular School No Elementary PK 08 2020   grade_8 14 2 114   1 3     1   2   77 60                       137 14 2 114   1 3     1   2   77 60                 137
1811607 CO     school 803600 3085   Eaton RE-2 80360000475 2452 Eaton Middle School   Regular School No Middle 06 08 2020   grade_8 94 0 43   0 0     0   1   71 67                       138 94 0 43   0 0     0   1   71 67                 138
1802952 CO     school 803360 880   Denver County 1 80336006682 1077 Bear Valley International School   Regular School No Middle 06 08 2020   grade_8 19 2 107   1 7     0   3   75 64                       139 19 2 107   1 7     0   3   75 64                 139
1802046 CO     school 805370 470   St Vrain Valley RE1J 80537006430 7565 St. Vrain Community Montessori School   Regular School Yes Elementary PK 08 2020   grade_8 14 0 0   0 0     0   0   6 8                       14 14 0 0   0 0     0   0   6 8                 14
1802559 CO     school 805040 510   Kit Carson R-1 80504000826 4742 Kit Carson Junior-Senior High School   Regular School No High 06 12 2020   grade_8 10 0 3   0 1     0   0   4 10                       14 10 0 3   0 1     0   0   4 10                 14
1804235 CO     school 803420 890   Dolores County RE No.2 80342000429 2216 Dove Creek High School   Regular School No High 06 12 2020   grade_8 14 0 0   0 0     0   0   8 6                       14 14 0 0   0 0     0   0   8 6                 14
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

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