Data source: Big Local News · About: Big Local

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

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
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
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
1799687 CO     school 806900 20   Adams 12 Five Star Schools 80690001186 6342 Shadow Ridge Middle School   Regular School No Middle 06 08 2020   grade_8 150 0 130   1 11     1   4   167 130                       297 150 0 130   1 11     1   4   167 130                 297
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
1799733 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2020   grade_8 0 0 2   1 0     0   0   2 1                       3 0 0 2   1 0     0   0   2 1                 3
1799771 CO     school 806900 20   Adams 12 Five Star Schools 80690006468 8275 STEM Lab   Regular School No Elementary PK 08 2020   grade_8 40 0 8   0 3     0   3   29 25                       54 40 0 8   0 3     0   3   29 25                 54
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
1799799 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2020   grade_8 56 0 7   0 1     0   5   37 32                       69 56 0 7   0 1     0   5   37 32                 69
1799941 CO     school 802580 40   School District 27J 80258000729 1021 Innovations & Options   Alternative School No High 06 12 2020   grade_8 0 0 2   0 0     0   0   1 1                       2 0 0 2   0 0     0   0   1 1                 2
1800273 CO     school 807230 70   Westminster Public Schools 80723006675 9236 Westminster Academy for International Studies   Regular School No Elementary PK 08 2020   grade_8 3 0 13   0 0     0   0   5 11                       16 3 0 13   0 0     0   0   5 11                 16
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
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
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
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
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
1800934 CO     school 805310 140   Littleton 6 80531001626 5233 Littleton Prep Charter School   Regular School Yes Elementary PK 08 2020   grade_8 42 0 14   1 2     1   1   25 36                       61 42 0 14   1 2     1   1   25 36                 61
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
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
1801516 CO     school 802700 190   Byers 32J 80270000164 1176 Byers Junior-Senior High School   Regular School No High 07 12 2020   grade_8 25 0 6   1 0     0   1   17 16                       33 25 0 6   1 0     0   1   17 16                 33
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
1801611 CO     school 806090 240   Pritchett RE-3 80609001952 7176 Pritchett Middle School   Regular School No Middle 06 08 2020   grade_8 3 0 1   0 0     0   0   3 1                       4 3 0 1   0 0     0   0   3 1                 4
1801631 CO     school 806630 250   Springfield RE-4 80663001142 8168 Springfield Junior/Senior High School   Regular School No High 06 12 2020   grade_8 11 0 8   0 0     0   0   7 12                       19 11 0 8   0 0     0   0   7 12                 19
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
1801662 CO     school 802760 270   Campo RE-6 80276000170 1252 Campo Undivided High School   Regular School No High 06 12 2020   grade_8 3 0 0   0 0     0   0   3 0                       3 3 0 0   0 0     0   0   3 0                 3
1801692 CO     school 805250 290   Las Animas RE-1 80525000867 4986 Las Animas Junior High School   Regular School No Middle 07 08 2020   grade_8 17 0 15   0 0     0   1   14 19                       33 17 0 15   0 0     0   1   14 19                 33
1801712 CO     school 805580 310   McClave Re-2 80558000963 5670 McClave Undivided High School   Regular School No High 07 12 2020   grade_8 20 0 0   0 0     0   1   13 8                       21 20 0 0   0 0     0   1   13 8                 21
1801737 CO     school 805370 470   St Vrain Valley RE1J 80537006530 71 Aspen Ridge Preparatory School   Regular School Yes Elementary KG 08 2020   grade_8 31 0 4   0 1     0   1   19 18                       37 31 0 4   0 1     0   1   19 18                 37
1801751 CO     school 805370 470   St Vrain Valley RE1J 80537006539 120 Apex Home School Enrichment Program   Regular School No Other KG 12 2020   grade_8 45 0 5   0 0     0   3   32 21                       53 45 0 5   0 0     0   3   32 21                 53
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
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
1802175 CO     school 802490 480   Boulder Valley Re 2 80249000104 1136 Manhattan Middle School of the Arts and Academics   Regular School No Middle 06 08 2020   grade_8 120 0 46   1 9     1   10   89 98                       187 120 0 46   1 9     1   10   89 98                 187
1802179 CO     school 802490 480   Boulder Valley Re 2 80249000106 1352 Casey Middle School   Regular School No Middle 06 08 2020   grade_8 132 0 96   1 9     0   10   122 126                       248 132 0 96   1 9     0   10   122 126                 248
1802188 CO     school 802490 480   Boulder Valley Re 2 80249000108 1390 Centennial Middle School   Regular School No Middle 06 08 2020   grade_8 151 0 47   1 9     0   13   116 105                       221 151 0 47   1 9     0   13   116 105                 221
1802325 CO     school 802490 480   Boulder Valley Re 2 80249002013 4496 Justice High Charter School   Alternative School Yes High 06 12 2020   grade_8 3 0 2   0 0     0   0   5 0                       5 3 0 2   0 0     0   0   5 0                 5
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
1802410 CO     school 802490 480   Boulder Valley Re 2 80249000131 6212 Nederland Middle-Senior High School   Regular School No High 06 12 2020   grade_8 34 0 3   0 0     0   1   21 17                       38 34 0 3   0 0     0   1   21 17                 38
1802424 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2020   grade_8 37 0 1   0 2     0   1   18 23                       41 37 0 1   0 2     0   1   18 23                 41
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
1802521 CO     school 806330 500   Salida R-32 80633006500 1554 Crest Academy   Regular School No Middle 05 08 2020   grade_8 7 0 1   0 0     0   0   2 6                       8 7 0 1   0 0     0   0   2 6                 8
1802531 CO     school 806330 500   Salida R-32 80633001107 4680 Salida Middle School   Regular School No Middle 05 08 2020   grade_8 73 0 12   0 1     0   1   48 39                       87 73 0 12   0 1     0   1   48 39                 87
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
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
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
1802657 CO     school 806390 560   Sanford 6J 80639001114 7616 Sanford Junior/Senior High School   Regular School No High 07 12 2020   grade_8 20 0 7   0 0     0   0   12 15                       27 20 0 7   0 0     0   0   12 15                 27
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
1802702 CO     school 804140 740   Sierra Grande R-30 80414000572 7880 Sierra Grande K-12 School   Regular School No Other PK 12 2020   grade_8 5 0 15   0 0     0   0   11 9                       20 5 0 15   0 0     0   0   11 9                 20
1802732 CO     school 807200 860   Custer County School District C-1 80720001732 2091 Custer Middle School   Regular School No Middle 06 08 2020   grade_8 24 0 3   0 0     0   1   12 16                       28 24 0 3   0 0     0   1   12 16                 28
1802748 CO     school 803330 870   Delta County 50(J) 80333001334 1375 Cedaredge Middle School   Regular School No Middle 06 08 2020   grade_8 60 0 5   1 0     0   3   35 34                       69 60 0 5   1 0     0   3   35 34                 69
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
1802807 CO     school 803330 870   Delta County 50(J) 80333000299 4124 Hotchkiss Elementary School   Regular School No Elementary PK 08 2020   grade_8 49 0 8   0 0     0   0   34 23                       57 49 0 8   0 0     0   0   34 23                 57
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
1802961 CO     school 803360 880   Denver County 1 80336000320 1106 Bryant Webster Dual Language ECE-8 School   Regular School No Elementary PK 08 2020   grade_8 0 0 52   1 0     0   0   28 25                       53 0 0 52   1 0     0   0   28 25                 53
1804025 CO     school 803360 880   Denver County 1 80336006491 8145 Summit Academy   Alternative School No High 06 12 2020   grade_8 0 0 19   0 0     0   0   11 8                       19 0 0 19   0 0     0   0   11 8                 19
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
1804275 CO     school 803450 900   Douglas County Re 1 80345006760 79 Ascent Classical Academy   Regular School Yes Other KG 11 2020   grade_8 37 0 4   0 3     0   2   21 25                       46 37 0 4   0 3     0   2   21 25                 46
1804387 CO     school 803450 900   Douglas County Re 1 80345001874 1512 Challenge to Excellence Charter School   Regular School Yes Elementary KG 08 2020   grade_8 44 0 6   0 13     0   6   31 38                       69 44 0 6   0 13     0   6   31 38                 69
1804401 CO     school 803450 900   Douglas County Re 1 80345006494 1555 Cloverleaf Home Education   Alternative School No Other KG 12 2020   grade_8 20 0 4   0 1     0   1   11 15                       26 20 0 4   0 1     0   1   11 15                 26
1804420 CO     school 803450 900   Douglas County Re 1 80345002011 1579 North Star Academy   Regular School Yes Elementary KG 08 2020   grade_8 40 0 10   0 6     0   2   26 32                       58 40 0 10   0 6     0   2   26 32                 58
1804650 CO     school 803450 900   Douglas County Re 1 80345006765 5225 Leman Classical Academy   Regular School Yes Elementary KG 08 2020   grade_8 17 0 5   0 3     0   0   12 13                       25 17 0 5   0 3     0   0   12 13                 25
1804708 CO     school 803450 900   Douglas County Re 1 80345001581 5997 DC Montessori Charter School   Regular School Yes Elementary PK 08 2020   grade_8 29 0 3   0 1     0   2   13 22                       35 29 0 3   0 1     0   2   13 22                 35
1804719 CO     school 803450 900   Douglas County Re 1 80345006588 6019 Aspen View Academy   Regular School Yes Elementary PK 08 2020   grade_8 69 0 17   1 2     0   3   37 55                       92 69 0 17   1 2     0   3   37 55                 92
1804729 CO     school 803450 900   Douglas County Re 1 80345001747 6164 Mountain Ridge Middle School   Regular School No Middle 07 08 2020   grade_8 435 0 66   0 23     0   28   238 314                       552 435 0 66   0 23     0   28   238 314                 552
1804843 CO     school 803450 900   Douglas County Re 1 80345006714 7244 Renaissance Secondary School   Regular School Yes High 06 12 2020   grade_8 56 0 7   1 3     0   4   44 27                       71 56 0 7   1 3     0   4   44 27                 71
1804961 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2020   grade_8 32 0 5   0 0     0   2   14 25                       39 32 0 5   0 0     0   2   14 25                 39
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
1805013 CO     school 803540 910   Eagle County RE 50 80354001531 793 Berry Creek Middle School   Regular School No Middle 06 08 2020   grade_8 19 0 72   0 2     0   1   57 37                       94 19 0 72   0 2     0   1   57 37                 94
1805024 CO     school 803540 910   Eagle County RE 50 80354000851 2340 Eagle County Charter Academy   Regular School Yes Elementary KG 08 2020   grade_8 36 0 1   0 0     0   1   19 19                       38 36 0 1   0 0     0   1   19 19                 38
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
1805096 CO     school 803540 910   Eagle County RE 50 80354006422 9061 Vail Ski and Snowboard Academy (VSSA)   Alternative School No High 05 12 2020   grade_8 39 0 1   0 0     0   0   23 17                       40 39 0 1   0 0     0   0   23 17                 40
1805106 CO     school 803540 910   Eagle County RE 50 80354006533 9701 World Academy   Regular School No Other KG 12 2020   grade_8 4 0 1   0 0     0   0   2 3                       5 4 0 1   0 0     0   0   2 3                 5
1805116 CO     school 803720 920   Elizabeth School District 80372001586 2572 Legacy Academy   Regular School Yes Elementary KG 08 2020   grade_8 45 0 2   1 1     0   1   30 20                       50 45 0 2   1 1     0   1   30 20                 50
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
1805161 CO     school 805010 930   Kiowa C-2 80501001587 4726 Kiowa Middle School   Regular School No Middle 06 08 2020   grade_8 17 0 0   3 0     0   0   6 14                       20 17 0 0   3 0     0   0   6 14                 20
1805178 CO     school 806600 940   Big Sandy 100J 80660001140 7918 Simla Junior High School   Regular School No Middle 06 08 2020   grade_8 24 0 2   0 0     0   2   13 15                       28 24 0 2   0 0     0   2   13 15                 28
1805198 CO     school 803690 950   Elbert 200 80369000481 2574 Elbert Junior-Senior High School   Regular School No High 06 12 2020   grade_8 23 0 2   0 0     0   2   14 13                       27 23 0 2   0 0     0   2   14 13                 27
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
1805306 CO     school 804530 980   Harrison 2 80453006663 5763 Mountain Vista Homeschool Academy   Regular School No Other KG 12 2020   grade_8 22 0 8   1 0     0   1   17 15                       32 22 0 8   1 0     0   1   17 15                 32
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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