Data source: Big Local News · About: Big Local

627 rows where grade = "grade_8", state = "CO" and year = 2021 sorted by district_nces_id

View and edit SQL

year

  • 2021 · 627

grade

  • grade_8 · 627
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
1741547 CO     school 800001 520   Cheyenne County Re-5 80000100215 1612 Cheyenne Wells Junior/High School   Regular School No High 07 12 2021   grade_8 11 0 2   0 0     0   0   8 5                       13 11 0 2   0 0     0   0   8 5                 13
1751496 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   grade_8 36 0 7   0 2     0   7   32 20                       52 36 0 7   0 2     0   7   32 20                 52
1751020 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2021   grade_8 34 0 31   0 0     0   0   34 31                       65 34 0 31   0 0     0   0   34 31                 65
1751046 CO     school 800017 3210   Wray RD-2 80001701818 9733 Wray Junior Senior High School   Regular School No High 07 12 2021   grade_8 32 0 20   1 0     0   0   27 26                       53 32 0 20   1 0     0   0   27 26                 53
1751062 CO     school 800018 3220   Idalia RJ-3 80001801742 4231 Idalia Junior-Senior High School   Regular School No High 07 12 2021   grade_8 9 0 4   0 0     0   0   6 7                       13 9 0 4   0 0     0   0   6 7                 13
1751075 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   grade_8 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1751090 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_8 90 1 42   1 12     0   5   68 83                       151 90 1 42   1 12     0   5   68 83                 151
1751110 CO     school 800020 8001   Charter School Institute 80002006760 79 Ascent Classical Academy   Regular School Yes Other KG 12 2021   grade_8 45 0 9   0 0     0   3   36 21                       57 45 0 9   0 0     0   3   36 21                 57
1751116 CO     school 800020 8001   Charter School Institute 80002006777 149 Colorado Early Colleges Fort Collins West   Regular School Yes Middle 06 08 2021   grade_8 89 0 17   0 2     0   1   62 47                       109 89 0 17   0 2     0   1   62 47                 109
1751133 CO     school 800020 8001   Charter School Institute 80002002018 653 Stone Creek School   Regular School Yes Elementary KG 08 2021   grade_8 23 0 8   0 0     0   2   18 15                       33 23 0 8   0 0     0   2   18 15                 33
1751143 CO     school 800020 8001   Charter School Institute 80002002033 655 High Point Academy   Regular School Yes Elementary PK 08 2021   grade_8 9 18 35   1 5     0   0   37 31                       68 9 18 35   1 5     0   0   37 31                 68
1751172 CO     school 800020 8001   Charter School Institute 80002006305 1279 Caprock Academy   Regular School Yes Other KG 12 2021   grade_8 66 0 13   0 0     0   1   42 38                       80 66 0 13   0 0     0   1   42 38                 80
1751196 CO     school 800020 8001   Charter School Institute 80002006779 1387 Colorado Early Colleges Windsor   Regular School Yes Other KG 12 2021   grade_8 31 0 2   0 0     0   2   16 19                       35 31 0 2   0 0     0   2   16 19                 35
1751209 CO     school 800020 8001   Charter School Institute 80002006708 1505 Colorado Military Academy   Regular School Yes Other KG 11 2021   grade_8 46 3 17   2 0     2   0   46 24                       70 46 3 17   2 0     2   0   46 24                 70
1751225 CO     school 800020 8001   Charter School Institute 80002001912 1791 Colorado Springs Charter Academy   Regular School Yes Elementary KG 08 2021   grade_8 23 0 14   0 0     0   1   16 22                       38 23 0 14   0 0     0   1   16 22                 38
1751247 CO     school 800020 8001   Charter School Institute 80002001569 2035 Crown Pointe Charter Academy   Regular School Yes Elementary KG 08 2021   grade_8 15 0 33   0 1     0   0   24 25                       49 15 0 33   0 1     0   0   24 25                 49
1751255 CO     school 800020 8001   Charter School Institute 80002006542 2067 Colorado Early College Fort Collins   Regular School Yes High 06 12 2021   grade_8 80 2 26   0 1     0   5   59 55                       114 80 2 26   0 1     0   5   59 55                 114
1751268 CO     school 800020 8001   Charter School Institute 80002006390 2837 Early College of Arvada   Regular School Yes High 06 12 2021   grade_8 9 2 28   0 3     0   0   17 25                       42 9 2 28   0 3     0   0   17 25                 42
1751289 CO     school 800020 8001   Charter School Institute 80002006639 3393 Golden View Classical Academy   Regular School Yes Other KG 12 2021   grade_8 48 1 7   0 2     0   2   34 26                       60 48 1 7   0 2     0   2   34 26                 60
1751301 CO     school 800020 8001   Charter School Institute 80002006503 3439 Global Village Academy - Northglenn   Regular School Yes Elementary KG 08 2021   grade_8 21 1 35   0 1     0   0   24 34                       58 21 1 35   0 1     0   0   24 34                 58
1751333 CO     school 800020 8001   Charter School Institute 80002006761 5431 Coperni 2   Regular School Yes Elementary KG 08 2021   grade_8 2 1 9   0 1     0   0   4 9                       13 2 1 9   0 1     0   0   4 9                 13
1751340 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2021   grade_8 54 0 5   0 0     1   0   32 28                       60 54 0 5   0 0     1   0   32 28                 60
1751356 CO     school 800020 8001   Charter School Institute 80002006589 5851 Mountain Song Community School   Regular School Yes Elementary KG 08 2021   grade_8 16 1 12   0 0     0   2   10 21                       31 16 1 12   0 0     0   2   10 21                 31
1751389 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   grade_8 20 0 160   0 6     0   4   85 105                       190 20 0 160   0 6     0   4   85 105                 190
1751400 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2021   grade_8 0 0 40   0 0     0   0   19 21                       40 0 0 40   0 0     0   0   19 21                 40
1751410 CO     school 800020 8001   Charter School Institute 80002001913 7512 Ross Montessori School   Regular School Yes Elementary KG 08 2021   grade_8 19 0 3   0 0     0   0   14 8                       22 19 0 3   0 0     0   0   14 8                 22
1751420 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2021   grade_8 10 0 0   0 0     0   0   5 5                       10 10 0 0   0 0     0   0   5 5                 10
1751430 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2021   grade_8 25 0 14   0 1     0   1   22 19                       41 25 0 14   0 1     0   1   22 19                 41
1751444 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   grade_8 60 2 22   0 4     0   7   48 47                       95 60 2 22   0 4     0   7   48 47                 95
1751456 CO     school 800020 8001   Charter School Institute 80002006579 9040 Victory Preparatory Academy Middle State Charter School   Regular School Yes Middle 06 08 2021   grade_8 5 1 63   0 0     0   0   33 36                       69 5 1 63   0 0     0   0   33 36                 69
1751468 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2021   grade_8 4 1 7   0 0     0   0   8 4                       12 4 1 7   0 0     0   0   8 4                 12
1751509 CO     school 800282 9170   Education reEnvisioned BOCES 80028206764 1501 Colorado Preparatory Academy Middle School   Regular School No Middle 06 08 2021   grade_8 230 16 133   2 5     2   26   193 221                       414 230 16 133   2 5     2   26   193 221                 414
1751524 CO     school 800282 9170   Education reEnvisioned BOCES 80028206804 1892 Orton Academy   Regular School No Other KG 12 2021   grade_8 6 0 0   0 0     0   0   2 4                       6 6 0 0   0 0     0   0   2 4                 6
1744994 CO     school 801920 1040   Academy 20 80192000001 74 Challenger Middle School   Regular School No Middle 06 08 2021   grade_8 180 6 38   0 19     1   24   133 135                       268 180 6 38   0 19     1   24   133 135                 268
1745010 CO     school 801920 1040   Academy 20 80192000858 209 Aspen Valley Campus   Alternative School No High 07 12 2021   grade_8 17 1 2   0 0     0   2   15 7                       22 17 1 2   0 0     0   2   15 7                 22
1745025 CO     school 801920 1040   Academy 20 80192006788 1421 Chinook Trail Middle School   Regular School No Middle 06 08 2021   grade_8 91 5 19   1 5     0   12   61 72                       133 91 5 19   1 5     0   12   61 72                 133
1745037 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2021   grade_8 15 0 3   0 1     0   1   5 15                       20 15 0 3   0 1     0   1   5 15                 20
1745057 CO     school 801920 1040   Academy 20 80192001931 1629 The Classical Academy Middle School   Regular School Yes Middle 07 08 2021   grade_8 164 3 22   2 10     1   7   116 93                       209 164 3 22   2 10     1   7   116 93                 209
1745071 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2021   grade_8 25 1 6   0 2     0   1   13 22                       35 25 1 6   0 2     0   1   13 22                 35
1745076 CO     school 801920 1040   Academy 20 80192006616 1921 Discovery Canyon Campus Middle School   Regular School No Middle 06 08 2021   grade_8 192 6 39   0 8     0   27   140 132                       272 192 6 39   0 8     0   27   140 132                 272
1745100 CO     school 801920 1040   Academy 20 80192001402 2358 Eagleview Middle School   Regular School No Middle 06 08 2021   grade_8 240 5 46   0 9     2   18   141 179                       320 240 5 46   0 9     2   18   141 179                 320
1745148 CO     school 801920 1040   Academy 20 80192001593 6140 Mountain Ridge Middle School   Regular School No Middle 06 08 2021   grade_8 192 14 66   0 14     2   31   140 179                       319 192 14 66   0 14     2   31   140 179                 319
1745165 CO     school 801920 1040   Academy 20 80192006745 6242 New Summit Charter Academy   Regular School Yes Elementary KG 08 2021   grade_8 23 2 4   0 0     1   0   17 13                       30 23 2 4   0 0     1   0   17 13                 30
1745220 CO     school 801920 1040   Academy 20 80192006447 8779 TCA College Pathways   Regular School Yes High 07 12 2021   grade_8 55 4 3   0 0     0   6   39 29                       68 55 4 3   0 0     0   6   39 29                 68
1745233 CO     school 801920 1040   Academy 20 80192001462 8851 Timberview Middle School   Regular School No Middle 06 08 2021   grade_8 237 15 62   4 6     2   32   190 168                       358 237 15 62   4 6     2   32   190 168                 358
1738788 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2021   grade_8 24 0 219   3 0     1   4   122 129                       251 24 0 219   3 0     1   4   122 129                 251
1738825 CO     school 801950 30   Adams County 14 80195000015 4516 Kearney Middle School   Regular School No Middle 06 08 2021   grade_8 30 4 223   1 1     1   1   143 118                       261 30 4 223   1 1     1   1   143 118                 261
1744129 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2021   grade_8 0 0 2   0 0     0   0   1 1                       2 0 0 2   0 0     0   0   1 1                 2
1748273 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2021   grade_8 4 0 2   0 0     0   1   3 4                       7 4 0 2   0 0     0   1   3 4                 7
1750360 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2021   grade_8 26 0 7   0 0     0   1   22 12                       34 26 0 7   0 0     0   1   22 12                 34
1739229 CO     school 802070 100   Alamosa RE-11J 80207000026 114 Ortega Middle School   Regular School No Middle 06 08 2021   grade_8 41 0 85   2 3     0   0   65 66                       131 41 0 85   2 3     0   0   65 66                 131
1739250 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_8 11 0 27   2 0     0   2   27 15                       42 11 0 27   2 0     0   2   27 15                 42
1741644 CO     school 802130 580   South Conejos RE-10 80213001464 250 Antonito Middle School   Regular School No Middle 07 08 2021   grade_8 0 0 8   0 0     0   0   5 3                       8 0 0 8   0 0     0   0   5 3                 8
1740538 CO     school 802190 220   Archuleta County 50 Jt 80219000040 6657 Pagosa Springs Middle School   Regular School No Middle 05 08 2021   grade_8 71 0 48   13 0     0   5   70 67                       137 71 0 48   13 0     0   5   70 67                 137
1750382 CO     school 802220 3040   Arickaree R-2 80222000042 308 Arickaree Undivided High School   Regular School No High 06 12 2021   grade_8 7 1 1   0 0     0   0   2 7                       9 7 1 1   0 0     0   0   2 7                 9
1747350 CO     school 802260 1450   Arriba-Flagler C-20 80226000509 2960 Flagler Public School   Regular School No Other PK 12 2021   grade_8 10 0 2   0 0     0   0   7 5                       12 10 0 2   0 0     0   0   7 5                 12
1749404 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2021   grade_8 14 0 0   1 0     0   0   7 8                       15 14 0 0   1 0     0   0   7 8                 15
1749416 CO     school 802280 2640   Aspen 1 80228000046 430 Aspen Middle School   Regular School No Middle 05 08 2021   grade_8 92 3 23   0 3     0   1   57 65                       122 92 3 23   0 3     0   1   57 65                 122
1750961 CO     school 802310 3145   Ault-Highland RE-9 80231001466 3961 Highland Middle School   Regular School No Middle 06 08 2021   grade_8 42 0 37   0 0     2   1   44 38                       82 42 0 37   0 0     2   1   44 38                 82
1739985 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2021   grade_8 5 15 56   1 0     1   5   35 48                       83 5 15 56   1 0     1   5   35 48                 83
1740000 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2021   grade_8 7 12 20   0 1     1   3   28 16                       44 7 12 20   0 1     1   3   28 16                 44
1740027 CO     school 802340 180   Adams-Arapahoe 28J 80234001759 458 Aurora Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_8 12 21 21   0 3     0   0   30 27                       57 12 21 21   0 3     0   0   30 27                 57
1740032 CO     school 802340 180   Adams-Arapahoe 28J 80234000054 464 Aurora Hills Middle School   Regular School No Middle 06 08 2021   grade_8 15 50 138   5 6     4   7   130 95                       225 15 50 138   5 6     4   7   130 95                 225
1740041 CO     school 802340 180   Adams-Arapahoe 28J 80234002009 465 Aurora Frontier K-8   Regular School No Elementary PK 08 2021   grade_8 17 12 26   0 6     1   4   38 28                       66 17 12 26   0 6     1   4   38 28                 66
1740052 CO     school 802340 180   Adams-Arapahoe 28J 80234000055 914 Boston K-8 School   Regular School No Elementary PK 08 2021   grade_8 3 7 31   0 2     0   0   25 18                       43 3 7 31   0 2     0   0   25 18                 43
1740076 CO     school 802340 180   Adams-Arapahoe 28J 80234000057 1720 Clyde Miller K-8   Regular School No Elementary PK 08 2021   grade_8 8 4 45   1 2     1   4   35 30                       65 8 4 45   1 2     1   4   35 30                 65
1740082 CO     school 802340 180   Adams-Arapahoe 28J 80234001322 1800 Columbia Middle School   Regular School No Middle 06 08 2021   grade_8 52 50 116   2 8     3   25   139 117                       256 52 50 116   2 8     3   25   139 117                 256
1740091 CO     school 802340 180   Adams-Arapahoe 28J 80234006803 1851 Harmony Ridge P-8   Regular School No Elementary PK 08 2021   grade_8 4 2 38   0 0     0   1   23 22                       45 4 2 38   0 0     0   1   23 22                 45
1740121 CO     school 802340 180   Adams-Arapahoe 28J 80234000060 2384 East Middle School   Regular School No Middle 06 08 2021   grade_8 10 42 228   6 7     2   8   162 141                       303 10 42 228   6 7     2   8   162 141                 303
1740141 CO     school 802340 180   Adams-Arapahoe 28J 80234006644 2673 Edna and John W. Mosley P-8   Regular School No Elementary PK 08 2021   grade_8 10 17 60   3 1     3   4   54 44                       98 10 17 60   3 1     3   4   54 44                 98
1740167 CO     school 802340 180   Adams-Arapahoe 28J 80234006318 3471 Global Village Academy Aurora   Regular School Yes Elementary KG 08 2021   grade_8 12 14 68   0 2     1   2   54 45                       99 12 14 68   0 2     1   2   54 45                 99
1740227 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2021   grade_8 12 34 48   2 3     0   1   41 59                       100 12 34 48   2 3     0   1   41 59                 100
1740251 CO     school 802340 180   Adams-Arapahoe 28J 80234000073 6160 Mrachek Middle School   Regular School No Middle 06 08 2021   grade_8 50 68 170   1 16     6   25   168 168                       336 50 68 170   1 16     6   25   168 168                 336
1740260 CO     school 802340 180   Adams-Arapahoe 28J 80234001881 6189 Murphy Creek K-8 School   Regular School No Elementary PK 08 2021   grade_8 30 11 30   0 6     0   8   36 49                       85 30 11 30   0 6     0   8   36 49                 85
1740266 CO     school 802340 180   Adams-Arapahoe 28J 80234000074 6310 North Middle School Health Sciences and Technology Campus   Regular School No Middle 06 08 2021   grade_8 8 32 149   0 5     5   6   108 97                       205 8 32 149   0 5     5   6   108 97                 205
1740278 CO     school 802340 180   Adams-Arapahoe 28J 80234001789 6546 Options School   Regular School No Other KG 12 2021   grade_8 51 2 9   0 1     0   2   29 36                       65 51 2 9   0 1     0   2   29 36                 65
1740313 CO     school 802340 180   Adams-Arapahoe 28J 80234001674 7232 Aurora Quest K-8   Regular School No Elementary KG 08 2021   grade_8 36 13 21   0 13     1   5   38 51                       89 36 13 21   0 13     1   5   38 51                 89
1740355 CO     school 802340 180   Adams-Arapahoe 28J 80234000079 8078 South Middle School   Regular School No Middle 06 08 2021   grade_8 8 57 149   1 3     5   11   129 105                       234 8 57 149   1 3     5   11   129 105                 234
1740375 CO     school 802340 180   Adams-Arapahoe 28J 80234006732 9053 Vega Collegiate Academy   Regular School Yes Elementary KG 08 2021   grade_8 4 6 40   0 7     0   1   25 33                       58 4 6 40   0 7     0   1   25 33                 58
1740385 CO     school 802340 180   Adams-Arapahoe 28J 80234006322 9056 Vanguard Classical School - West   Regular School Yes Elementary KG 08 2021   grade_8 5 3 34   0 0     0   3   24 21                       45 5 3 34   0 0     0   3   24 21                 45
1740411 CO     school 802340 180   Adams-Arapahoe 28J 80234006483 9083 Vista Peak P-8 Exploratory   Regular School No Elementary PK 08 2021   grade_8 26 12 32   1 6     0   8   53 32                       85 26 12 32   1 6     0   8   53 32                 85
1740438 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2021   grade_8 6 17 27   1 1     0   1   22 31                       53 6 17 27   1 1     0   1   22 31                 53
1740447 CO     school 802340 180   Adams-Arapahoe 28J 80234000082 9396 Aurora West College Preparatory Academy   Regular School No High 06 12 2021   grade_8 12 31 165   1 22     1   5   121 116                       237 12 31 165   1 22     1   5   121 116                 237
1749321 CO     school 802370 2600   Platte Canyon 1 80237001325 7048 Fitzsimmons Middle School   Regular School No Middle 06 08 2021   grade_8 45 1 9   0 0     0   2   37 20                       57 45 1 9   0 0     0   2   37 20                 57
1747553 CO     school 802400 1530   Bayfield 10 Jt-R 80240000089 636 Bayfield Middle School   Regular School No Middle 06 08 2021   grade_8 90 0 17   9 2     0   5   65 58                       123 90 0 17   9 2     0   5   65 58                 123
1739054 CO     school 802430 50   Bennett 29J 80243000093 774 Bennett Middle School   Regular School No Middle 07 08 2021   grade_8 53 2 35   1 0     0   7   52 46                       98 53 2 35   1 0     0   7   52 46                 98
1747397 CO     school 802460 1490   Bethune R-5 80246000095 842 Bethune Public Schools   Regular School No Other PK 12 2021   grade_8 9 0 6   0 0     0   0   7 8                       15 9 0 6   0 0     0   0   7 8                 15
1741085 CO     school 802490 480   Boulder Valley Re 2 80249001758 441 Aspen Creek K-8 School   Regular School No Elementary PK 08 2021   grade_8 101 3 16   1 8     0   3   77 55                       132 101 3 16   1 8     0   3   77 55                 132
1741126 CO     school 802490 480   Boulder Valley Re 2 80249006463 930 Boulder Universal   Regular School No Other KG 12 2021   grade_8 106 2 19   0 5     0   13   86 59                       145 106 2 19   0 5     0   13   86 59                 145
1741137 CO     school 802490 480   Boulder Valley Re 2 80249000102 1066 Broomfield Heights Middle School   Regular School No Middle 06 08 2021   grade_8 111 2 32   1 7     0   12   76 89                       165 111 2 32   1 7     0   12   76 89                 165
1741146 CO     school 802490 480   Boulder Valley Re 2 80249000104 1136 Manhattan Middle School of the Arts and Academics   Regular School No Middle 06 08 2021   grade_8 93 1 27   1 4     1   6   53 80                       133 93 1 27   1 4     1   6   53 80                 133
1741150 CO     school 802490 480   Boulder Valley Re 2 80249000106 1352 Casey Middle School   Regular School No Middle 06 08 2021   grade_8 89 4 79   0 4     1   5   102 80                       182 89 4 79   0 4     1   5   102 80                 182
1741159 CO     school 802490 480   Boulder Valley Re 2 80249000108 1390 Centennial Middle School   Regular School No Middle 06 08 2021   grade_8 125 2 43   1 9     0   10   104 86                       190 125 2 43   1 9     0   10   104 86                 190
1741213 CO     school 802490 480   Boulder Valley Re 2 80249001771 2589 Eldorado K-8 School   Regular School No Elementary PK 08 2021   grade_8 92 0 9   0 12     1   9   64 59                       123 92 0 9   0 12     1   9   64 59                 123
1741224 CO     school 802490 480   Boulder Valley Re 2 80249006716 2639 Meadowlark School   Regular School No Elementary PK 08 2021   grade_8 35 0 11   0 4     1   3   33 21                       54 35 0 11   0 4     1   3   33 21                 54
1741297 CO     school 802490 480   Boulder Valley Re 2 80249002013 4496 Justice High Charter School   Alternative School Yes High 06 12 2021   grade_8 1 0 2   0 0     0   0   1 2                       3 1 0 2   0 0     0   0   1 2                 3
1741318 CO     school 802490 480   Boulder Valley Re 2 80249000122 4878 Angevine Middle School   Regular School No Middle 06 08 2021   grade_8 107 4 98   1 7     0   12   112 117                       229 107 4 98   1 7     0   12   112 117                 229
1741329 CO     school 802490 480   Boulder Valley Re 2 80249000125 5306 Louisville Middle School   Regular School No Middle 06 08 2021   grade_8 179 3 18   1 2     1   14   114 104                       218 179 3 18   1 2     1   14   114 104                 218
1741360 CO     school 802490 480   Boulder Valley Re 2 80249001573 6000 Monarch K-8 School   Regular School No Elementary PK 08 2021   grade_8 103 2 10   0 10     0   3   70 58                       128 103 2 10   0 10     0   3   70 58                 128
1741382 CO     school 802490 480   Boulder Valley Re 2 80249000131 6212 Nederland Middle-Senior High School   Regular School No High 06 12 2021   grade_8 30 0 3   1 0     0   2   21 15                       36 30 0 3   1 0     0   2   21 15                 36

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