Data source: Big Local News · About: Big Local

626 rows where grade = "grade_7", state = "CO" and year = 2020 sorted by white

View and edit SQL

year

  • 2020 · 626

grade

  • grade_7 · 626
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
1799940 CO     school 802580 40   School District 27J 80258000729 1021 Innovations & Options   Alternative School No High 06 12 2020   grade_7 0 0 2   0 0     0   0   1 1                       2 0 0 2   0 0     0   0   1 1                 2
1801022 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2020   grade_7 0 0 2   0 1     0   0   2 1                       3 0 0 2   0 1     0   0   2 1                 3
1802669 CO     school 802130 580   South Conejos RE-10 80213001464 250 Antonito Middle School   Regular School No Middle 07 08 2020   grade_7 0 0 9   0 0     0   0   4 5                       9 0 0 9   0 0     0   0   4 5                 9
1803188 CO     school 803360 880   Denver County 1 80336006516 2188 Denver Center for 21st-Century Learning at Wyman   Alternative School No High 06 12 2020   grade_7 0 1 1   0 0     0   0   2 0                       2 0 1 1   0 0     0   0   2 0                 2
1803690 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2020   grade_7 0 6 51   0 0     3   2   30 32                       62 0 6 51   0 0     3   2   30 32                 62
1803881 CO     school 803360 880   Denver County 1 80336001795 7163 Prep Academy   Alternative School No High 06 12 2020   grade_7 0 2 4   0 0     0   0   2 4                       6 0 2 4   0 0     0   0   2 4                 6
1804178 CO     school 803360 880   Denver County 1 80336000426 9548 Whittier ECE-8 School   Regular School No Elementary PK 08 2020   grade_7 0 8 18   0 0     0   3   12 17                       29 0 8 18   0 0     0   3   12 17                 29
1807885 CO     school 804800 1420   Jefferson County R-1 80480001607 5994 Montessori Peaks Charter Academy   Regular School Yes Elementary PK 08 2020   grade_7 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
1812492 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2020   grade_7 0 0 37   0 0     0   0   19 18                       37 0 0 37   0 0     0   0   19 18                 37
1802766 CO     school 803330 870   Delta County 50(J) 80333001953 2155 Grand Mesa Choice Academy   Alternative School No High 07 12 2020   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1803578 CO     school 803360 880   Denver County 1 80336001865 4732 KIPP Sunshine Peak Academy   Regular School Yes Middle 05 08 2020   grade_7 1 2 110   0 1     1   0   61 54                       115 1 2 110   0 1     1   0   61 54                 115
1803994 CO     school 803360 880   Denver County 1 80336002012 8085 STRIVE Prep - Federal   Regular School Yes Middle 06 08 2020   grade_7 1 2 107   1 2     0   0   57 56                       113 1 2 107   1 2     0   0   57 56                 113
1804146 CO     school 803360 880   Denver County 1 80336006457 9336 STRIVE Prep - Sunnyside   Regular School Yes Middle 06 08 2020   grade_7 1 7 72   1 0     0   2   44 39                       83 1 7 72   1 0     0   2   44 39                 83
1805211 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2020   grade_7 1 0 1   0 0     0   0   1 1                       2 1 0 1   0 0     0   0   1 1                 2
1806362 CO     school 806060 1060   Peyton 23 Jt 80606006692 6626 Peyton Online Academy   Regular School No High 05 12 2020   grade_7 1 1 0   0 0     0   0   1 1                       2 1 1 0   0 0     0   0   1 1                 2
1806393 CO     school 804500 1070   Hanover 28 80450006720 3941 Hanover Online Academy   Regular School No High 06 12 2020   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1810412 CO     school 805970 2580   Ouray R-1 80597001662 6598 Ouray Middle School   Regular School No Middle 07 08 2020   grade_7 1 0 4   0 0     0   0   4 1                       5 1 0 4   0 0     0   0   4 1                 5
1812189 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2020   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1812623 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2020   grade_7 1 1 2   0 0     0   0   4 0                       4 1 1 2   0 0     0   0   4 0                 4
1802574 CO     school 800001 520   Cheyenne County Re-5 80000100215 1612 Cheyenne Wells Junior/High School   Regular School No High 07 12 2020   grade_7 10 0 3   0 0     0   0   8 5                       13 10 0 3   0 0     0   0   8 5                 13
1802760 CO     school 803330 870   Delta County 50(J) 80333002001 2152 Delta Academy of Applied Learning   Alternative School No Middle 05 08 2020   grade_7 10 0 1   0 0     0   0   9 2                       11 10 0 1   0 0     0   0   9 2                 11
1803568 CO     school 803360 880   Denver County 1 80336006686 4513 Kepner Beacon Middle School   Regular School No Middle 06 08 2020   grade_7 10 11 104   2 4     0   0   73 58                       131 10 11 104   2 4     0   0   73 58                 131
1804583 CO     school 803450 900   Douglas County Re 1 80345006578 3847 HOPE Online Learning Academy Middle School   Regular School Yes Middle 06 08 2020   grade_7 10 7 131   0 0     0   2   70 80                       150 10 7 131   0 0     0   2   70 80                 150
1805197 CO     school 803690 950   Elbert 200 80369000481 2574 Elbert Junior-Senior High School   Regular School No High 06 12 2020   grade_7 10 0 1   0 0     0   0   9 2                       11 10 0 1   0 0     0   0   9 2                 11
1805234 CO     school 804530 980   Harrison 2 80453006691 369 Atlas Preparatory Middle School   Regular School Yes Middle 05 08 2020   grade_7 10 11 135   1 1     2   5   85 80                       165 10 11 135   1 1     2   5   85 80                 165
1805589 CO     school 803060 1010   Colorado Springs 11 80306006428 269 Achieve Online   Alternative School No High 06 12 2020   grade_7 10 1 3   0 0     0   0   10 4                       14 10 1 3   0 0     0   0   10 4                 14
1806859 CO     school 804260 1180   Roaring Fork RE-1 80426001505 429 Carbondale Community Charter School   Regular School Yes Elementary KG 08 2020   grade_7 10 0 4   0 0     0   0   6 8                       14 10 0 4   0 0     0   0   6 8                 14
1807192 CO     school 807050 1410   North Park R-1 80705001209 6358 North Park School   Regular School No Other PK 12 2020   grade_7 10 0 6   0 0     0   0   8 8                       16 10 0 6   0 0     0   0   8 8                 16
1807441 CO     school 804800 1420   Jefferson County R-1 80480006695 2189 Doral Academy of Colorado   Regular School Yes Other KG 09 2020   grade_7 10 1 7   0 0     0   1   8 11                       19 10 1 7   0 0     0   1   8 11                 19
1809597 CO     school 803240 1980   De Beque 49JT 80324000286 2126 De Beque PK-12 School District 49JT   Regular School No Other PK 12 2020   grade_7 10 1 3   0 0     1   0   7 8                       15 10 1 3   0 0     1   0   7 8                 15
1810199 CO     school 805850 2190   West End RE-2 80585006727 6307 Nucla Middle School   Regular School No Middle 07 08 2020   grade_7 10 1 1   0 0     0   1   7 6                       13 10 1 1   0 0     0   1   7 6                 13
1811800 CO     school 804410 3120   Greeley 6 80441001990 54 Bella Romero Academy of Applied Technology   Regular School No Elementary KG 08 2020   grade_7 10 9 106   0 1     1   1   79 49                       128 10 9 106   0 1     1   1   79 49                 128
1808789 CO     school 803990 1550   Poudre R-1 80399000524 1190 Cache La Poudre Middle School   Regular School No Middle 06 08 2020   grade_7 100 2 8   0 1     0   2   59 54                       113 100 2 8   0 1     0   2   59 54                 113
1809659 CO     school 804350 2000   Mesa County Valley 51 80435000598 900 Bookcliff Middle School   Regular School No Middle 06 08 2020   grade_7 100 1 92   1 0     1   9   122 82                       204 100 1 92   1 0     1   9   122 82                 204
1800757 CO     school 802910 130   Cherry Creek 5 80291000201 7158 Prairie Middle School   Regular School No Middle 06 08 2020   grade_7 101 145 213   5 29     4   34   286 245                       531 101 145 213   5 29     4   34   286 245                 531
1802241 CO     school 802490 480   Boulder Valley Re 2 80249001771 2589 Eldorado K-8 School   Regular School No Elementary PK 08 2020   grade_7 102 0 8   0 12     1   10   71 62                       133 102 0 8   0 12     1   10   71 62                 133
1805857 CO     school 803060 1010   Colorado Springs 11 80306000256 6306 North Middle School   Regular School No Middle 06 08 2020   grade_7 102 23 94   1 0     1   19   120 120                       240 102 23 94   1 0     1   19   120 120                 240
1811715 CO     school 807350 3100   Windsor RE-4 80735006782 9563 Windsor Charter Academy Middle School   Regular School Yes Middle 06 08 2020   grade_7 102 1 22   0 3     0   6   70 64                       134 102 1 22   0 3     0   6   70 64                 134
1802118 CO     school 802490 480   Boulder Valley Re 2 80249001758 441 Aspen Creek K-8 School   Regular School No Elementary PK 08 2020   grade_7 103 3 18   1 9     0   4   85 53                       138 103 3 18   1 9     0   4   85 53                 138
1810127 CO     school 805790 2180   Montrose County RE-1J 80579000989 6054 Columbine Middle School   Regular School No Middle 06 08 2020   grade_7 103 0 53   0 0     1   6   82 81                       163 103 0 53   0 0     1   6   82 81                 163
1802174 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_7 104 2 33   1 4     0   7   60 91                       151 104 2 33   1 4     0   7   60 91                 151
1800021 CO     school 802580 40   School District 27J 80258006420 6702 Otho E Stuart Middle School   Regular School No Middle 06 08 2020   grade_7 105 20 115   0 9     0   17   141 125                       266 105 20 115   0 9     0   17   141 125                 266
1809533 CO     school 806690 1828   Valley RE-1 80669001154 8256 Sterling Middle School   Regular School No Middle 06 08 2020   grade_7 106 5 33   0 1     0   1   68 78                       146 106 5 33   0 1     0   1   68 78                 146
1810009 CO     school 803090 2035   Montezuma-Cortez RE-1 80309000833 1888 Montezuma-Cortez Middle School   Regular School No Middle 06 08 2020   grade_7 106 1 42   53 0     0   8   97 113                       210 106 1 42   53 0     0   8   97 113                 210
1802178 CO     school 802490 480   Boulder Valley Re 2 80249000106 1352 Casey Middle School   Regular School No Middle 06 08 2020   grade_7 108 3 79   0 3     1   6   114 86                       200 108 3 79   0 3     1   6   114 86                 200
1802387 CO     school 802490 480   Boulder Valley Re 2 80249001573 6000 Monarch K-8 School   Regular School No Elementary PK 08 2020   grade_7 108 2 7   0 11     0   3   69 62                       131 108 2 7   0 11     0   3   69 62                 131
1799723 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2020   grade_7 109 0 7   0 13     0   1   53 77                       130 109 0 7   0 13     0   1   53 77                 130
1804663 CO     school 803450 900   Douglas County Re 1 80345006493 5259 STEM School Highlands Ranch   Regular School Yes Other KG 12 2020   grade_7 109 4 18   1 39     0   17   122 66                       188 109 4 18   1 39     0   17   122 66                 188
1805120 CO     school 803720 920   Elizabeth School District 80372000482 2604 Elizabeth Middle School   Regular School No Middle 06 08 2020   grade_7 109 0 17   0 0     0   5   68 63                       131 109 0 17   0 0     0   5   68 63                 131
1809728 CO     school 804350 2000   Mesa County Valley 51 80435000605 2392 East Middle School   Regular School No Middle 06 08 2020   grade_7 109 1 33   1 2     0   10   78 78                       156 109 1 33   1 2     0   10   78 78                 156
1801160 CO     school 802340 180   Adams-Arapahoe 28J 80234000060 2384 East Middle School   Regular School No Middle 06 08 2020   grade_7 11 39 246   5 8     2   7   164 154                       318 11 39 246   5 8     2   7   164 154                 318
1801265 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2020   grade_7 11 30 46   2 3     0   1   39 54                       93 11 30 46   2 3     0   1   39 54                 93
1806387 CO     school 804500 1070   Hanover 28 80450000661 3758 Hanover Junior-Senior High School   Regular School No High 06 12 2020   grade_7 11 1 11   0 0     0   0   12 11                       23 11 1 11   0 0     0   0   12 11                 23
1810823 CO     school 806120 2690   Pueblo City 60 80612006711 6775 Pueblo School for Arts & Sciences at Fulton Heights   Regular School Yes Elementary KG 07 2020   grade_7 11 0 15   0 0     0   0   15 11                       26 11 0 15   0 0     0   0   15 11                 26
1812176 CO     school 800018 3220   Idalia RJ-3 80001801742 4231 Idalia Junior-Senior High School   Regular School No High 07 12 2020   grade_7 11 0 3   0 0     0   0   7 7                       14 11 0 3   0 0     0   0   7 7                 14
1812360 CO     school 800020 8001   Charter School Institute 80002006390 2837 Early College of Arvada   Regular School Yes High 06 12 2020   grade_7 11 3 28   0 3     0   0   21 24                       45 11 3 28   0 3     0   0   21 24                 45
1807505 CO     school 804800 1420   Jefferson County R-1 80480000720 2820 Everitt Middle School   Regular School No Middle 06 08 2020   grade_7 111 6 85   6 3     1   12   99 125                       224 111 6 85   6 3     1   12   99 125                 224
1800637 CO     school 802910 130   Cherry Creek 5 80291001328 4100 Horizon Middle School   Regular School No Middle 06 08 2020   grade_7 112 65 111   1 22     1   30   184 158                       342 112 65 111   1 22     1   30   184 158                 342
1807416 CO     school 804800 1420   Jefferson County R-1 80480000708 1976 Creighton Middle School   Regular School No Middle 06 08 2020   grade_7 113 11 142   4 6     0   17   147 146                       293 113 11 142   4 6     0   17   147 146                 293
1808897 CO     school 803990 1550   Poudre R-1 80399000536 5168 Lincoln Middle School   Regular School No Middle 06 08 2020   grade_7 113 5 102   1 3     1   8   124 109                       233 113 5 102   1 3     1   8   124 109                 233
1811606 CO     school 803600 3085   Eaton RE-2 80360000475 2452 Eaton Middle School   Regular School No Middle 06 08 2020   grade_7 113 0 45   0 0     0   2   83 77                       160 113 0 45   0 0     0   2   83 77                 160
1799427 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2020   grade_7 114 9 43   1 4     2   18   83 108                       191 114 9 43   1 4     2   18   83 108                 191
1806572 CO     school 803870 1110   District 49 80387001393 4102 Horizon Middle School   Regular School No Middle 06 08 2020   grade_7 115 22 73   0 7     0   27   139 105                       244 115 22 73   0 7     0   27   139 105                 244
1807813 CO     school 804800 1420   Jefferson County R-1 80480001384 5454 Mandalay Middle School   Regular School No Middle 06 08 2020   grade_7 117 5 42   0 20     1   18   100 103                       203 117 5 42   0 20     1   18   100 103                 203
1805513 CO     school 804080 1000   Fountain 8 80408000561 1332 Carson Middle School   Regular School No Middle 06 08 2020   grade_7 118 32 56   3 2     4   23   121 117                       238 118 32 56   3 2     4   23   121 117                 238
1805900 CO     school 803060 1010   Colorado Springs 11 80306000234 7556 Sabin Middle School   Regular School No Middle 06 08 2020   grade_7 118 24 73   0 4     0   12   116 115                       231 118 24 73   0 4     0   12   116 115                 231
1809969 CO     school 805730 2020   Moffat County RE: No 1 80573000977 1938 Craig Middle School   Regular School No Middle 06 08 2020   grade_7 118 0 39   0 1     0   5   84 79                       163 118 0 39   0 1     0   5   84 79                 163
1802345 CO     school 802490 480   Boulder Valley Re 2 80249000122 4878 Angevine Middle School   Regular School No Middle 06 08 2020   grade_7 119 5 103   1 8     0   16   122 130                       252 119 5 103   1 8     0   16   122 130                 252
1807892 CO     school 804800 1420   Jefferson County R-1 80480001317 6090 Moore Middle School   Regular School No Middle 06 08 2020   grade_7 119 4 70   3 1     0   6   99 104                       203 119 4 70   3 1     0   6   99 104                 203
1800646 CO     school 802910 130   Cherry Creek 5 80291006676 4189 Heritage Heights Academy   Regular School Yes Elementary KG 08 2020   grade_7 12 2 6   0 1     1   0   8 14                       22 12 2 6   0 1     1   0   8 14                 22
1801711 CO     school 805580 310   McClave Re-2 80558000963 5670 McClave Undivided High School   Regular School No High 07 12 2020   grade_7 12 0 0   0 0     0   0   4 8                       12 12 0 0   0 0     0   0   4 8                 12
1802045 CO     school 805370 470   St Vrain Valley RE1J 80537006430 7565 St. Vrain Community Montessori School   Regular School Yes Elementary PK 08 2020   grade_7 12 0 2   0 0     0   0   6 8                       14 12 0 2   0 0     0   0   6 8                 14
1802520 CO     school 806330 500   Salida R-32 80633006500 1554 Crest Academy   Regular School No Middle 05 08 2020   grade_7 12 0 1   0 0     0   0   7 6                       13 12 0 1   0 0     0   0   7 6                 13
1807179 CO     school 805160 1400   La Veta Re-2 80516000854 4864 La Veta Junior-Senior High School   Regular School No High 06 12 2020   grade_7 12 0 7   0 0     0   0   11 8                       19 12 0 7   0 0     0   0   11 8                 19
1811081 CO     school 803300 2730   Upper Rio Grande School District C-7 80330000290 2150 Del Norte High Jr./Sr. High School   Regular School No High 07 12 2020   grade_7 12 0 25   0 0     0   0   23 14                       37 12 0 25   0 0     0   0   23 14                 37
1811159 CO     school 806660 2770   Steamboat Springs RE-2 80666001749 6363 North Routt Charter School   Regular School Yes Elementary KG 08 2020   grade_7 12 0 0   1 0     0   0   9 4                       13 12 0 0   1 0     0   0   9 4                 13
1812052 CO     school 804020 3140   Weld Re-8 Schools 80402006606 7219 Kenneth Homyak PK-8   Regular School No Elementary PK 08 2020   grade_7 12 0 7   0 0     0   0   10 9                       19 12 0 7   0 0     0   0   10 9                 19
1808651 CO     school 803480 1520   Durango 9-R 80348000456 7994 Escalante Middle School   Regular School No Middle 06 08 2020   grade_7 120 0 43   9 1     0   10   78 105                       183 120 0 43   9 1     0   10   78 105                 183
1802165 CO     school 802490 480   Boulder Valley Re 2 80249000102 1066 Broomfield Heights Middle School   Regular School No Middle 06 08 2020   grade_7 121 2 37   1 7     0   14   83 99                       182 121 2 37   1 7     0   14   83 99                 182
1805760 CO     school 803060 1010   Colorado Springs 11 80306000241 4070 Holmes Middle School   Regular School No Middle 06 08 2020   grade_7 122 10 37   2 5     1   15   97 95                       192 122 10 37   2 5     1   15   97 95                 192
1808776 CO     school 803990 1550   Poudre R-1 80399000523 898 Boltz Middle School   Regular School No Middle 06 08 2020   grade_7 122 3 55   1 2     0   8   94 97                       191 122 3 55   1 2     0   8   94 97                 191
1802080 CO     school 805370 470   St Vrain Valley RE1J 80537006739 8055 Soaring Heights PK-8   Regular School No Elementary PK 08 2020   grade_7 124 4 25   0 7     0   2   86 76                       162 124 4 25   0 7     0   2   86 76                 162
1799628 CO     school 806900 20   Adams 12 Five Star Schools 80690001179 4187 Silver Hills Middle School   Regular School No Middle 06 08 2020   grade_7 126 8 198   3 17     1   12   182 183                       365 126 8 198   3 17     1   12   182 183                 365
1808772 CO     school 803990 1550   Poudre R-1 80399000522 892 Blevins Middle School   Regular School No Middle 06 08 2020   grade_7 127 4 51   1 4     0   7   107 87                       194 127 4 51   1 4     0   7   107 87                 194
1809864 CO     school 804350 2000   Mesa County Valley 51 80435000619 6562 Orchard Mesa Middle School   Regular School No Middle 06 08 2020   grade_7 127 0 38   0 2     0   11   87 91                       178 127 0 38   0 2     0   11   87 91                 178
1801077 CO     school 802340 180   Adams-Arapahoe 28J 80234001759 458 Aurora Academy Charter School   Regular School Yes Elementary KG 08 2020   grade_7 13 22 20   0 3     0   0   30 28                       58 13 22 20   0 3     0   0   30 28                 58
1805160 CO     school 805010 930   Kiowa C-2 80501001587 4726 Kiowa Middle School   Regular School No Middle 06 08 2020   grade_7 13 1 0   2 0     0   0   9 7                       16 13 1 0   2 0     0   0   9 7                 16
1806099 CO     school 801920 1040   Academy 20 80192000858 209 Aspen Valley Campus   Alternative School No High 07 12 2020   grade_7 13 0 1   0 0     0   1   10 5                       15 13 0 1   0 0     0   1   10 5                 15
1807351 CO     school 804800 1420   Jefferson County R-1 80480000704 1730 Coal Creek Canyon K-8 Elementary School   Regular School No Elementary KG 08 2020   grade_7 13 0 0   0 0     0   0   10 3                       13 13 0 0   0 0     0   0   10 3                 13
1808495 CO     school 806780 1480   Stratton R-4 80678000138 8351 Stratton Middle School   Regular School No Middle 06 08 2020   grade_7 13 0 3   1 0     0   0   7 10                       17 13 0 3   1 0     0   0   7 10                 17
1809469 CO     school 804740 1780   Genoa-Hugo C113 80474000686 4162 Genoa-Hugo School   Regular School No Other PK 12 2020   grade_7 13 1 1   0 0     0   0   9 6                       15 13 1 1   0 0     0   0   9 6                 15
1809553 CO     school 803930 1850   Frenchman RE-3 80393000512 2988 Fleming High School   Regular School No High 07 12 2020   grade_7 13 0 0   0 0     0   0   9 4                       13 13 0 0   0 0     0   0   9 4                 13
1810144 CO     school 805790 2180   Montrose County RE-1J 80579006499 6262 Peak Virtual Academy   Regular School No Other KG 12 2020   grade_7 13 0 1   0 0     0   0   8 6                       14 13 0 1   0 0     0   0   8 6                 14
1810365 CO     school 804110 2540   Fowler R-4J 80411000567 3130 Fowler Junior High School   Regular School No Middle 07 08 2020   grade_7 13 0 13   0 0     0   0   11 15                       26 13 0 13   0 0     0   0   11 15                 26
1810382 CO     school 802880 2560   Cheraw 31 80288000182 1546 Cheraw School   Regular School No Other PK 12 2020   grade_7 13 0 6   0 0     0   0   7 12                       19 13 0 6   0 0     0   0   7 12                 19
1810609 CO     school 804680 2670   Holly RE-3 80468000681 4058 Holly School   Regular School No Other PK 12 2020   grade_7 13 0 9   0 1     0   0   14 9                       23 13 0 9   0 1     0   0   14 9                 23
1812094 CO     school 802550 3146   Briggsdale RE-10 80255000143 1012 Briggsdale Undivided High School   Regular School No High 06 12 2020   grade_7 13 0 1   0 1     0   0   9 6                       15 13 0 1   0 1     0   0   9 6                 15
1812243 CO     school 800020 8001   Charter School Institute 80002002033 655 High Point Academy   Regular School Yes Elementary PK 08 2020   grade_7 13 18 36   1 4     0   0   39 33                       72 13 18 36   1 4     0   0   39 33                 72
1801976 CO     school 805370 470   St Vrain Valley RE1J 80537000915 5730 Mead Middle School   Regular School No Middle 06 08 2020   grade_7 130 1 34   0 1     1   4   90 81                       171 130 1 34   0 1     1   4   90 81                 171
1803459 CO     school 803360 880   Denver County 1 80336000364 3990 Hill Campus of Arts and Sciences   Regular School No Middle 06 08 2020   grade_7 131 75 87   2 7     0   16   152 166                       318 131 75 87   2 7     0   16   152 166                 318

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