enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
1806083 1806083 CO     school 801920 1040   Academy 20 80192000001 74 Challenger Middle School   Regular School No Middle 06 08 2020   grade_7 176 6 35   0 19     1   23   131 129                       260 176 6 35   0 19     1   23   131 129                 260
1806099 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
1806114 1806114 CO     school 801920 1040   Academy 20 80192006788 1421 Chinook Trail Middle School   Regular School No Middle 06 08 2020   grade_7 80 4 16   0 4     0   13   56 61                       117 80 4 16   0 4     0   13   56 61                 117
1806126 1806126 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_7 27 0 3   0 2     0   2   16 18                       34 27 0 3   0 2     0   2   16 18                 34
1806147 1806147 CO     school 801920 1040   Academy 20 80192001931 1629 The Classical Academy Middle School   Regular School Yes Middle 07 08 2020   grade_7 193 3 22   2 10     1   6   132 105                       237 193 3 22   2 10     1   6   132 105                 237
1806161 1806161 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2020   grade_7 20 1 5   0 2     0   2   9 21                       30 20 1 5   0 2     0   2   9 21                 30
1806166 1806166 CO     school 801920 1040   Academy 20 80192006616 1921 Discovery Canyon Campus Middle School   Regular School No Middle 06 08 2020   grade_7 186 8 30   0 12     0   26   134 128                       262 186 8 30   0 12     0   26   134 128                 262
1806191 1806191 CO     school 801920 1040   Academy 20 80192001402 2358 Eagleview Middle School   Regular School No Middle 06 08 2020   grade_7 258 7 46   0 10     2   17   155 185                       340 258 7 46   0 10     2   17   155 185                 340
1806241 1806241 CO     school 801920 1040   Academy 20 80192001593 6140 Mountain Ridge Middle School   Regular School No Middle 06 08 2020   grade_7 203 13 75   0 19     2   30   163 179                       342 203 13 75   0 19     2   30   163 179                 342
1806258 1806258 CO     school 801920 1040   Academy 20 80192006745 6242 New Summit Charter Academy   Regular School Yes Elementary KG 08 2020   grade_7 31 3 6   0 0     1   0   19 22                       41 31 3 6   0 0     1   0   19 22                 41
1806314 1806314 CO     school 801920 1040   Academy 20 80192006447 8779 TCA College Pathways   Regular School Yes High 07 12 2020   grade_7 40 3 6   0 0     0   6   29 26                       55 40 3 6   0 0     0   6   29 26                 55
1806328 1806328 CO     school 801920 1040   Academy 20 80192001462 8851 Timberview Middle School   Regular School No Middle 06 08 2020   grade_7 238 13 53   4 5     2   29   187 157                       344 238 13 53   4 5     2   29   187 157                 344
1799469 1799469 CO     school 806900 20   Adams 12 Five Star Schools 80690001726 57 Rocky Top Middle School   Regular School No Middle 06 08 2020   grade_7 234 4 77   1 25     0   19   187 173                       360 234 4 77   1 25     0   19   187 173                 360
1799484 1799484 CO     school 806900 20   Adams 12 Five Star Schools 80690001172 210 Vantage Point   Alternative School No High 06 12 2020   grade_7 3 0 8   0 0     0   1   10 2                       12 3 0 8   0 0     0   1   10 2                 12
1799505 1799505 CO     school 806900 20   Adams 12 Five Star Schools 80690001620 1480 Century Middle School   Regular School No Middle 06 08 2020   grade_7 188 12 110   1 22     0   10   177 166                       343 188 12 110   1 22     0   10   177 166                 343
1799517 1799517 CO     school 806900 20   Adams 12 Five Star Schools 80690000728 1519 Stargate Charter School   Regular School Yes Other KG 12 2020   grade_7 75 1 11   1 37     0   10   65 70                       135 75 1 11   1 37     0   10   65 70                 135
1799623 1799623 CO     school 806900 20   Adams 12 Five Star Schools 80690001178 4172 Hulstrom Options K-8 School   Regular School No Elementary KG 08 2020   grade_7 42 0 10   0 9     0   9   29 41                       70 42 0 10   0 9     0   9   29 41                 70
1799628 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
1799664 1799664 CO     school 806900 20   Adams 12 Five Star Schools 80690001183 5814 The International School at Thornton Middle   Regular School No Middle 06 08 2020   grade_7 39 17 268   2 5     0   4   184 151                       335 39 17 268   2 5     0   4   184 151                 335
1799686 1799686 CO     school 806900 20   Adams 12 Five Star Schools 80690001186 6342 Shadow Ridge Middle School   Regular School No Middle 06 08 2020   grade_7 133 3 111   0 12     0   11   136 134                       270 133 3 111   0 12     0   11   136 134                 270
1799706 1799706 CO     school 806900 20   Adams 12 Five Star Schools 80690001187 6398 Northglenn Middle School   Regular School No Middle 06 08 2020   grade_7 60 7 199   0 4     0   5   147 128                       275 60 7 199   0 4     0   5   147 128                 275
1799723 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
1799732 1799732 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2020   grade_7 2 2 1   0 0     0   1   6 0                       6 2 2 1   0 0     0   1   6 0                 6
1799770 1799770 CO     school 806900 20   Adams 12 Five Star Schools 80690006468 8275 STEM Lab   Regular School No Elementary PK 08 2020   grade_7 46 0 24   0 2     0   1   43 30                       73 46 0 24   0 2     0   1   43 30                 73
1799781 1799781 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2020   grade_7 20 1 106   1 2     0   2   76 56                       132 20 1 106   1 2     0   2   76 56                 132
1799798 1799798 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2020   grade_7 68 1 9   0 6     1   3   50 38                       88 68 1 9   0 6     1   3   50 38                 88
1799820 1799820 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2020   grade_7 35 4 5   0 5     0   1   32 18                       50 35 4 5   0 5     0   1   32 18                 50
1799826 1799826 CO     school 806900 20   Adams 12 Five Star Schools 80690001194 9444 Westlake Middle School   Regular School No Middle 06 08 2020   grade_7 213 4 107   3 16     0   16   187 172                       359 213 4 107   3 16     0   16   187 172                 359
1799846 1799846 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2020   grade_7 23 3 221   2 0     1   6   121 135                       256 23 3 221   2 0     1   6   121 135                 256
1799883 1799883 CO     school 801950 30   Adams County 14 80195000015 4516 Kearney Middle School   Regular School No Middle 06 08 2020   grade_7 32 5 236   1 0     1   1   151 125                       276 32 5 236   1 0     1   1   151 125                 276
1801022 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
1801036 1801036 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2020   grade_7 6 12 59   1 0     1   6   36 49                       85 6 12 59   1 0     1   6   36 49                 85
1801050 1801050 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   grade_7 9 14 22   0 1     1   6   31 22                       53 9 14 22   0 1     1   6   31 22                 53
1801077 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
1801082 1801082 CO     school 802340 180   Adams-Arapahoe 28J 80234000054 464 Aurora Hills Middle School   Regular School No Middle 06 08 2020   grade_7 16 61 154   4 7     4   18   147 117                       264 16 61 154   4 7     4   18   147 117                 264
1801091 1801091 CO     school 802340 180   Adams-Arapahoe 28J 80234002009 465 Aurora Frontier K-8   Regular School No Elementary PK 08 2020   grade_7 17 10 24   0 6     0   3   38 22                       60 17 10 24   0 6     0   3   38 22                 60
1801102 1801102 CO     school 802340 180   Adams-Arapahoe 28J 80234000055 914 Boston K-8 School   Regular School No Elementary PK 08 2020   grade_7 3 3 36   0 2     0   1   23 22                       45 3 3 36   0 2     0   1   23 22                 45
1801126 1801126 CO     school 802340 180   Adams-Arapahoe 28J 80234000057 1720 Clyde Miller K-8   Regular School No Elementary PK 08 2020   grade_7 7 5 44   1 2     1   4   31 33                       64 7 5 44   1 2     1   4   31 33                 64
1801132 1801132 CO     school 802340 180   Adams-Arapahoe 28J 80234001322 1800 Columbia Middle School   Regular School No Middle 06 08 2020   grade_7 55 49 116   2 7     1   27   136 121                       257 55 49 116   2 7     1   27   136 121                 257
1801160 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
1801179 1801179 CO     school 802340 180   Adams-Arapahoe 28J 80234006644 2673 Edna and John W. Mosley P-8   Regular School No Elementary PK 08 2020   grade_7 14 18 69   3 4     2   4   58 56                       114 14 18 69   3 4     2   4   58 56                 114
1801205 1801205 CO     school 802340 180   Adams-Arapahoe 28J 80234006318 3471 Global Village Academy Aurora   Regular School Yes Elementary KG 08 2020   grade_7 14 18 63   0 1     0   5   55 46                       101 14 18 63   0 1     0   5   55 46                 101
1801265 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
1801289 1801289 CO     school 802340 180   Adams-Arapahoe 28J 80234000073 6160 Mrachek Middle School   Regular School No Middle 06 08 2020   grade_7 55 70 178   1 14     7   25   177 173                       350 55 70 178   1 14     7   25   177 173                 350
1801298 1801298 CO     school 802340 180   Adams-Arapahoe 28J 80234001881 6189 Murphy Creek K-8 School   Regular School No Elementary PK 08 2020   grade_7 35 13 35   0 5     0   9   42 55                       97 35 13 35   0 5     0   9   42 55                 97
1801304 1801304 CO     school 802340 180   Adams-Arapahoe 28J 80234000074 6310 North Middle School Health Sciences and Technology Campus   Regular School No Middle 06 08 2020   grade_7 9 30 157   0 5     4   5   113 97                       210 9 30 157   0 5     4   5   113 97                 210
1801316 1801316 CO     school 802340 180   Adams-Arapahoe 28J 80234001789 6546 Options School   Regular School No Other KG 12 2020   grade_7 62 3 17   0 1     0   2   44 41                       85 62 3 17   0 1     0   2   44 41                 85
1801351 1801351 CO     school 802340 180   Adams-Arapahoe 28J 80234001674 7232 Aurora Quest K-8   Regular School No Elementary KG 08 2020   grade_7 37 13 21   0 12     1   6   36 54                       90 37 13 21   0 12     1   6   36 54                 90
1801393 1801393 CO     school 802340 180   Adams-Arapahoe 28J 80234000079 8078 South Middle School   Regular School No Middle 06 08 2020   grade_7 9 59 155   2 4     10   12   129 122                       251 9 59 155   2 4     10   12   129 122                 251
1801412 1801412 CO     school 802340 180   Adams-Arapahoe 28J 80234006732 9053 Vega Collegiate Academy   Regular School Yes Elementary KG 07 2020   grade_7 4 6 44   0 7     0   1   27 35                       62 4 6 44   0 7     0   1   27 35                 62
1801421 1801421 CO     school 802340 180   Adams-Arapahoe 28J 80234006322 9056 Vanguard Classical School - West   Regular School Yes Elementary KG 08 2020   grade_7 5 4 35   0 0     0   3   25 22                       47 5 4 35   0 0     0   3   25 22                 47
1801447 1801447 CO     school 802340 180   Adams-Arapahoe 28J 80234006483 9083 Vista Peak P-8 Exploratory   Regular School No Elementary PK 08 2020   grade_7 31 13 68   0 6     0   9   71 56                       127 31 13 68   0 6     0   9   71 56                 127
1801474 1801474 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2020   grade_7 6 19 25   1 1     0   3   26 29                       55 6 19 25   1 1     0   3   26 29                 55
1801483 1801483 CO     school 802340 180   Adams-Arapahoe 28J 80234000082 9396 Aurora West College Preparatory Academy   Regular School No High 06 12 2020   grade_7 9 27 167   1 23     1   5   122 111                       233 9 27 167   1 23     1   5   122 111                 233
1805211 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
1809413 1809413 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   grade_7 5 0 2   0 0     0   1   3 5                       8 5 0 2   0 0     0   1   3 5                 8
1811486 1811486 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2020   grade_7 25 0 8   0 0     0   1   21 13                       34 25 0 8   0 0     0   1   21 13                 34
1800285 1800285 CO     school 802070 100   Alamosa RE-11J 80207000026 114 Ortega Middle School   Regular School No Middle 06 08 2020   grade_7 41 0 113   2 2     0   2   83 77                       160 41 0 113   2 2     0   2   83 77                 160
1800304 1800304 CO     school 802070 100   Alamosa RE-11J 80207006508 368 Alamosa Ombudsman School of Excellence   Alternative School No High 06 12 2020   grade_7 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
1801569 1801569 CO     school 802190 220   Archuleta County 50 Jt 80219000040 6657 Pagosa Springs Middle School   Regular School No Middle 05 08 2020   grade_7 77 0 59   14 0     0   5   77 78                       155 77 0 59   14 0     0   5   77 78                 155
1811508 1811508 CO     school 802220 3040   Arickaree R-2 80222000042 308 Arickaree Undivided High School   Regular School No High 06 12 2020   grade_7 7 1 2   0 0     0   0   2 8                       10 7 1 2   0 0     0   0   2 8                 10
1808465 1808465 CO     school 802260 1450   Arriba-Flagler C-20 80226000509 2960 Flagler Public School   Regular School No Other PK 12 2020   grade_7 9 0 2   0 0     0   0   6 5                       11 9 0 2   0 0     0   0   6 5                 11
1810535 1810535 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2020   grade_7 15 0 0   1 0     0   0   7 9                       16 15 0 0   1 0     0   0   7 9                 16
1810547 1810547 CO     school 802280 2640   Aspen 1 80228000046 430 Aspen Middle School   Regular School No Middle 05 08 2020   grade_7 93 3 22   0 3     0   1   62 60                       122 93 3 22   0 3     0   1   62 60                 122
1812074 1812074 CO     school 802310 3145   Ault-Highland RE-9 80231001466 3961 Highland Middle School   Regular School No Middle 06 08 2020   grade_7 45 0 40   0 0     2   0   47 40                       87 45 0 40   0 0     2   0   47 40                 87
1808667 1808667 CO     school 802400 1530   Bayfield 10 Jt-R 80240000089 636 Bayfield Middle School   Regular School No Middle 06 08 2020   grade_7 97 0 20   8 2     0   5   68 64                       132 97 0 20   8 2     0   5   68 64                 132
1800114 1800114 CO     school 802430 50   Bennett 29J 80243000093 774 Bennett Middle School   Regular School No Middle 07 08 2020   grade_7 57 3 27   1 0     0   7   53 42                       95 57 3 27   1 0     0   7   53 42                 95
1808512 1808512 CO     school 802460 1490   Bethune R-5 80246000095 842 Bethune Public Schools   Regular School No Other PK 12 2020   grade_7 8 0 5   0 0     0   0   6 7                       13 8 0 5   0 0     0   0   6 7                 13
1805177 1805177 CO     school 806600 940   Big Sandy 100J 80660001140 7918 Simla Junior High School   Regular School No Middle 06 08 2020   grade_7 23 0 3   1 0     0   1   14 14                       28 23 0 3   1 0     0   1   14 14                 28
1802118 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
1802155 1802155 CO     school 802490 480   Boulder Valley Re 2 80249006463 930 Boulder Universal   Regular School No Other KG 12 2020   grade_7 6 0 0   0 0     0   0   4 2                       6 6 0 0   0 0     0   0   4 2                 6
1802165 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
1802174 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
1802178 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
1802187 1802187 CO     school 802490 480   Boulder Valley Re 2 80249000108 1390 Centennial Middle School   Regular School No Middle 06 08 2020   grade_7 135 1 44   1 9     0   10   107 93                       200 135 1 44   1 9     0   10   107 93                 200
1802241 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
1802252 1802252 CO     school 802490 480   Boulder Valley Re 2 80249006716 2639 Meadowlark School   Regular School No Elementary PK 08 2020   grade_7 35 1 11   0 4     1   3   30 25                       55 35 1 11   0 4     1   3   30 25                 55
1802324 1802324 CO     school 802490 480   Boulder Valley Re 2 80249002013 4496 Justice High Charter School   Alternative School Yes High 06 12 2020   grade_7 2 0 2   0 0     0   0   3 1                       4 2 0 2   0 0     0   0   3 1                 4
1802345 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
1802356 1802356 CO     school 802490 480   Boulder Valley Re 2 80249000125 5306 Louisville Middle School   Regular School No Middle 06 08 2020   grade_7 189 3 21   1 3     1   16   127 107                       234 189 3 21   1 3     1   16   127 107                 234
1802387 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
1802409 1802409 CO     school 802490 480   Boulder Valley Re 2 80249000131 6212 Nederland Middle-Senior High School   Regular School No High 06 12 2020   grade_7 34 0 3   0 0     1   3   25 16                       41 34 0 3   0 0     1   3   25 16                 41
1802414 1802414 CO     school 802490 480   Boulder Valley Re 2 80249000132 6224 Nevin Platt Middle School   Regular School No Middle 06 08 2020   grade_7 142 2 17   1 3     0   17   86 96                       182 142 2 17   1 3     0   17   86 96                 182
1802423 1802423 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2020   grade_7 34 0 4   0 1     0   2   21 20                       41 34 0 4   0 1     0   2   21 20                 41
1802436 1802436 CO     school 802490 480   Boulder Valley Re 2 80249001792 6816 Peak to Peak Charter School   Regular School Yes Other KG 12 2020   grade_7 92 1 16   1 20     2   4   77 59                       136 92 1 16   1 20     2   4   77 59                 136
1802466 1802466 CO     school 802490 480   Boulder Valley Re 2 80249000134 8135 Southern Hills Middle School   Regular School No Middle 06 08 2020   grade_7 138 3 12   0 6     1   15   88 87                       175 138 3 12   0 6     1   15   88 87                 175
1802470 1802470 CO     school 802490 480   Boulder Valley Re 2 80249001517 8387 Summit Middle Charter School   Regular School Yes Middle 06 08 2020   grade_7 82 1 3   0 21     0   14   54 67                       121 82 1 3   0 21     0   14   54 67                 121
1809426 1809426 CO     school 802520 1750   Branson Reorganized 82 80252001728 948 Branson School Online   Regular School No Other KG 12 2020   grade_7 28 2 3   0 0     0   0   13 20                       33 28 2 3   0 0     0   0   13 20                 33
1809440 1809440 CO     school 802520 1750   Branson Reorganized 82 80252000141 978 Branson School   Regular School No Other PK 12 2020   grade_7 7 0 1   0 0     0   0   2 6                       8 7 0 1   0 0     0   0   2 6                 8
1812094 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
1810218 1810218 CO     school 802610 2395   Brush RE-2(J) 80261000153 1094 Brush Middle School   Regular School No Middle 06 08 2020   grade_7 43 0 67   0 2     1   1   59 55                       114 43 0 67   0 2     1   1   59 55                 114
1802503 1802503 CO     school 802640 490   Buena Vista R-31 80264000158 1132 Harry L McGinnis Middle School   Regular School No Middle 06 08 2020   grade_7 51 0 6   0 0     1   0   28 30                       58 51 0 6   0 0     1   0   28 30                 58
1809568 1809568 CO     school 805640 1860   Buffalo RE-4J 80564000970 5806 Merino Junior Senior High School   Regular School No High 07 12 2020   grade_7 17 0 4   0 0     0   2   13 10                       23 17 0 4   0 0     0   2   13 10                 23
1808527 1808527 CO     school 802670 1500   Burlington RE-6J 80267000161 1150 Burlington Middle School   Regular School No Middle 05 08 2020   grade_7 24 2 24   1 0     0   1   27 25                       52 24 2 24   1 0     0   1   27 25                 52
1801515 1801515 CO     school 802700 190   Byers 32J 80270000164 1176 Byers Junior-Senior High School   Regular School No High 07 12 2020   grade_7 43 0 6   0 0     0   1   26 24                       50 43 0 6   0 0     0   1   26 24                 50
1801530 1801530 CO     school 802700 190   Byers 32J 80270006759 2793 Astravo Academy Middle School   Regular School Yes Middle 06 08 2020   grade_7 30 5 30   1 1     0   0   28 39                       67 30 5 30   1 1     0   0   28 39                 67
1801546 1801546 CO     school 802700 190   Byers 32J 80270006620 6263 Colorado Virtual Academy Middle School   Regular School Yes Middle 07 08 2020   grade_7 45 6 6   1 3     0   0   28 33                       61 45 6 6   1 3     0   0   28 33                 61
1801557 1801557 CO     school 802700 190   Byers 32J 80270006755 9033 Astravo Online Academy Middle School   Regular School Yes Middle 06 08 2020   grade_7 16 0 5   0 1     0   0   11 11                       22 16 0 5   0 1     0   0   11 11                 22
1812623 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
1805224 1805224 CO     school 802730 970   Calhan RJ-1 80273000510 1215 Calhan Middle School   Regular School No Middle 06 08 2020   grade_7 28 6 4   0 0     0   0   21 17                       38 28 6 4   0 0     0   0   21 17                 38

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