Data source: Big Local News · About: Big Local

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

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
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
1812589 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   grade_8 32 0 8   0 0     0   8   25 23                       48 32 0 8   0 0     0   8   25 23                 48
1812134 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2020   grade_8 33 0 38   0 0     0   0   32 39                       71 33 0 38   0 0     0   0   32 39                 71
1812157 CO     school 800017 3210   Wray RD-2 80001701817 9729 Buchanan Middle School   Regular School No Middle 05 08 2020   grade_8 52 0 10   0 0     0   0   23 39                       62 52 0 10   0 0     0   0   23 39                 62
1812177 CO     school 800018 3220   Idalia RJ-3 80001801742 4231 Idalia Junior-Senior High School   Regular School No High 07 12 2020   grade_8 15 0 8   0 0     0   0   11 12                       23 15 0 8   0 0     0   0   11 12                 23
1812190 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2020   grade_8 5 0 0   0 0     0   0   3 2                       5 5 0 0   0 0     0   0   3 2                 5
1812205 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_8 86 1 45   0 9     0   5   64 82                       146 86 1 45   0 9     0   5   64 82                 146
1812217 CO     school 800020 8001   Charter School Institute 80002006777 149 Colorado Early Colleges Fort Collins West   Regular School Yes Middle 06 08 2020   grade_8 9 0 3   0 0     0   1   8 5                       13 9 0 3   0 0     0   1   8 5                 13
1812234 CO     school 800020 8001   Charter School Institute 80002002018 653 Stone Creek School   Regular School Yes Elementary KG 08 2020   grade_8 19 0 9   0 0     0   2   18 12                       30 19 0 9   0 0     0   2   18 12                 30
1812244 CO     school 800020 8001   Charter School Institute 80002002033 655 High Point Academy   Regular School Yes Elementary PK 08 2020   grade_8 13 17 34   0 3     2   0   40 29                       69 13 17 34   0 3     2   0   40 29                 69
1812266 CO     school 800020 8001   Charter School Institute 80002006305 1279 Caprock Academy   Regular School Yes Other KG 12 2020   grade_8 61 0 15   0 3     0   2   34 47                       81 61 0 15   0 3     0   2   34 47                 81
1812289 CO     school 800020 8001   Charter School Institute 80002006779 1387 Colorado Early Colleges Windsor   Regular School Yes Other KG 12 2020   grade_8 16 0 4   0 2     0   0   9 13                       22 16 0 4   0 2     0   0   9 13                 22
1812301 CO     school 800020 8001   Charter School Institute 80002006708 1505 Colorado Military Academy   Regular School Yes Other KG 12 2020   grade_8 30 4 17   0 1     0   2   30 24                       54 30 4 17   0 1     0   2   30 24                 54
1812317 CO     school 800020 8001   Charter School Institute 80002001912 1791 Colorado Springs Charter Academy   Regular School Yes Elementary KG 08 2020   grade_8 29 0 18   0 0     0   1   22 26                       48 29 0 18   0 0     0   1   22 26                 48
1812340 CO     school 800020 8001   Charter School Institute 80002001569 2035 Crown Pointe Charter Academy   Regular School Yes Elementary KG 08 2020   grade_8 11 0 28   0 2     0   1   17 25                       42 11 0 28   0 2     0   1   17 25                 42
1812348 CO     school 800020 8001   Charter School Institute 80002006542 2067 Colorado Early College Fort Collins   Regular School Yes High 06 12 2020   grade_8 85 1 21   0 3     1   4   56 59                       115 85 1 21   0 3     1   4   56 59                 115
1812361 CO     school 800020 8001   Charter School Institute 80002006390 2837 Early College of Arvada   Regular School Yes High 06 12 2020   grade_8 13 1 42   0 6     0   0   31 31                       62 13 1 42   0 6     0   0   31 31                 62
1812371 CO     school 800020 8001   Charter School Institute 80002006586 3326 Colorado International Language Academy   Regular School Yes Elementary KG 08 2020   grade_8 2 1 15   0 0     0   0   9 9                       18 2 1 15   0 0     0   0   9 9                 18
1812385 CO     school 800020 8001   Charter School Institute 80002006639 3393 Golden View Classical Academy   Regular School Yes Other KG 12 2020   grade_8 52 2 0   0 3     0   2   35 24                       59 52 2 0   0 3     0   2   35 24                 59
1812396 CO     school 800020 8001   Charter School Institute 80002006503 3439 Global Village Academy - Northglenn   Regular School Yes Elementary KG 08 2020   grade_8 24 0 24   0 1     0   0   30 19                       49 24 0 24   0 1     0   0   30 19                 49
1812434 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2020   grade_8 50 0 6   2 0     0   2   30 30                       60 50 0 6   2 0     0   2   30 30                 60
1812449 CO     school 800020 8001   Charter School Institute 80002006589 5851 Mountain Song Community School   Regular School Yes Elementary KG 08 2020   grade_8 13 1 6   0 0     0   1   11 10                       21 13 1 6   0 0     0   1   11 10                 21
1812482 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2020   grade_8 18 4 146   0 6     0   2   88 88                       176 18 4 146   0 6     0   2   88 88                 176
1812493 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2020   grade_8 1 0 42   0 0     0   0   17 26                       43 1 0 42   0 0     0   0   17 26                 43
1812503 CO     school 800020 8001   Charter School Institute 80002001913 7512 Ross Montessori School   Regular School Yes Elementary KG 08 2020   grade_8 7 0 8   0 0     0   1   5 11                       16 7 0 8   0 0     0   1   5 11                 16
1812513 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2020   grade_8 7 0 0   0 0     0   0   4 3                       7 7 0 0   0 0     0   0   4 3                 7
1812523 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2020   grade_8 22 1 17   0 1     0   1   25 17                       42 22 1 17   0 1     0   1   25 17                 42
1812537 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   grade_8 58 3 18   0 2     0   3   41 43                       84 58 3 18   0 2     0   3   41 43                 84
1812549 CO     school 800020 8001   Charter School Institute 80002006579 9040 Victory Preparatory Academy Middle State Charter School   Regular School Yes Middle 06 08 2020   grade_8 2 1 57   0 0     0   0   27 33                       60 2 1 57   0 0     0   0   27 33                 60
1812561 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 2020   grade_8 3 0 5   0 0     0   0   3 5                       8 3 0 5   0 0     0   0   3 5                 8
1812603 CO     school 800282 9170   Education reEnvisioned BOCES 80028206764 1501 Colorado Preparatory Academy Middle School   Regular School No Middle 06 08 2020   grade_8 159 17 77   2 2     1   9   102 165                       267 159 17 77   2 2     1   9   102 165                 267
1806084 CO     school 801920 1040   Academy 20 80192000001 74 Challenger Middle School   Regular School No Middle 06 08 2020   grade_8 186 9 25   1 22     0   16   139 120                       259 186 9 25   1 22     0   16   139 120                 259
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
1806115 CO     school 801920 1040   Academy 20 80192006788 1421 Chinook Trail Middle School   Regular School No Middle 06 08 2020   grade_8 72 3 16   1 8     0   14   56 58                       114 72 3 16   1 8     0   14   56 58                 114
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
1806148 CO     school 801920 1040   Academy 20 80192001931 1629 The Classical Academy Middle School   Regular School Yes Middle 07 08 2020   grade_8 167 4 17   0 5     0   3   91 105                       196 167 4 17   0 5     0   3   91 105                 196
1806162 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2020   grade_8 28 1 6   0 2     0   0   18 19                       37 28 1 6   0 2     0   0   18 19                 37
1806167 CO     school 801920 1040   Academy 20 80192006616 1921 Discovery Canyon Campus Middle School   Regular School No Middle 06 08 2020   grade_8 205 5 46   1 20     0   27   156 148                       304 205 5 46   1 20     0   27   156 148                 304
1806192 CO     school 801920 1040   Academy 20 80192001402 2358 Eagleview Middle School   Regular School No Middle 06 08 2020   grade_8 240 7 63   2 7     0   23   170 172                       342 240 7 63   2 7     0   23   170 172                 342
1806242 CO     school 801920 1040   Academy 20 80192001593 6140 Mountain Ridge Middle School   Regular School No Middle 06 08 2020   grade_8 230 20 56   1 18     3   30   175 183                       358 230 20 56   1 18     3   30   175 183                 358
1806315 CO     school 801920 1040   Academy 20 80192006447 8779 TCA College Pathways   Regular School Yes High 07 12 2020   grade_8 49 3 7   0 1     1   7   18 50                       68 49 3 7   0 1     1   7   18 50                 68
1806329 CO     school 801920 1040   Academy 20 80192001462 8851 Timberview Middle School   Regular School No Middle 06 08 2020   grade_8 300 12 47   3 1     1   25   191 198                       389 300 12 47   3 1     1   25   191 198                 389
1799847 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2020   grade_8 25 2 230   4 1     0   3   139 126                       265 25 2 230   4 1     0   3   139 126                 265
1799884 CO     school 801950 30   Adams County 14 80195000015 4516 Kearney Middle School   Regular School No Middle 06 08 2020   grade_8 22 5 237   0 1     0   0   138 127                       265 22 5 237   0 1     0   0   138 127                 265
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
1809414 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   grade_8 6 0 5   0 0     0   0   6 5                       11 6 0 5   0 0     0   0   6 5                 11
1811487 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2020   grade_8 21 0 2   0 0     0   2   12 13                       25 21 0 2   0 0     0   2   12 13                 25
1800286 CO     school 802070 100   Alamosa RE-11J 80207000026 114 Ortega Middle School   Regular School No Middle 06 08 2020   grade_8 52 2 116   0 3     2   4   87 92                       179 52 2 116   0 3     2   4   87 92                 179
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
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
1801570 CO     school 802190 220   Archuleta County 50 Jt 80219000040 6657 Pagosa Springs Middle School   Regular School No Middle 05 08 2020   grade_8 67 2 51   12 0     0   5   75 62                       137 67 2 51   12 0     0   5   75 62                 137
1811509 CO     school 802220 3040   Arickaree R-2 80222000042 308 Arickaree Undivided High School   Regular School No High 06 12 2020   grade_8 6 0 1   0 0     0   0   3 4                       7 6 0 1   0 0     0   0   3 4                 7
1808466 CO     school 802260 1450   Arriba-Flagler C-20 80226000509 2960 Flagler Public School   Regular School No Other PK 12 2020   grade_8 11 0 0   0 0     0   0   4 7                       11 11 0 0   0 0     0   0   4 7                 11
1810536 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2020   grade_8 10 0 0   0 0     0   0   4 6                       10 10 0 0   0 0     0   0   4 6                 10
1810548 CO     school 802280 2640   Aspen 1 80228000046 430 Aspen Middle School   Regular School No Middle 05 08 2020   grade_8 104 2 10   0 3     0   1   58 62                       120 104 2 10   0 3     0   1   58 62                 120
1812075 CO     school 802310 3145   Ault-Highland RE-9 80231001466 3961 Highland Middle School   Regular School No Middle 06 08 2020   grade_8 48 0 21   1 0     0   2   35 37                       72 48 0 21   1 0     0   2   35 37                 72
1801037 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2020   grade_8 6 8 45   0 0     0   5   38 26                       64 6 8 45   0 0     0   5   38 26                 64
1801051 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   grade_8 11 13 21   1 2     0   3   23 28                       51 11 13 21   1 2     0   3   23 28                 51
1801078 CO     school 802340 180   Adams-Arapahoe 28J 80234001759 458 Aurora Academy Charter School   Regular School Yes Elementary KG 08 2020   grade_8 9 13 15   0 1     0   1   18 21                       39 9 13 15   0 1     0   1   18 21                 39
1801083 CO     school 802340 180   Adams-Arapahoe 28J 80234000054 464 Aurora Hills Middle School   Regular School No Middle 06 08 2020   grade_8 26 54 161   3 11     4   8   133 134                       267 26 54 161   3 11     4   8   133 134                 267
1801092 CO     school 802340 180   Adams-Arapahoe 28J 80234002009 465 Aurora Frontier K-8   Regular School No Elementary PK 08 2020   grade_8 19 13 21   1 14     0   6   44 30                       74 19 13 21   1 14     0   6   44 30                 74
1801103 CO     school 802340 180   Adams-Arapahoe 28J 80234000055 914 Boston K-8 School   Regular School No Elementary PK 08 2020   grade_8 2 3 36   0 2     0   0   26 17                       43 2 3 36   0 2     0   0   26 17                 43
1801127 CO     school 802340 180   Adams-Arapahoe 28J 80234000057 1720 Clyde Miller K-8   Regular School No Elementary PK 08 2020   grade_8 2 4 38   0 1     0   5   26 24                       50 2 4 38   0 1     0   5   26 24                 50
1801133 CO     school 802340 180   Adams-Arapahoe 28J 80234001322 1800 Columbia Middle School   Regular School No Middle 06 08 2020   grade_8 66 38 102   2 6     0   31   136 109                       245 66 38 102   2 6     0   31   136 109                 245
1801161 CO     school 802340 180   Adams-Arapahoe 28J 80234000060 2384 East Middle School   Regular School No Middle 06 08 2020   grade_8 17 32 249   1 8     2   8   167 150                       317 17 32 249   1 8     2   8   167 150                 317
1801180 CO     school 802340 180   Adams-Arapahoe 28J 80234006644 2673 Edna and John W. Mosley P-8   Regular School No Elementary PK 08 2020   grade_8 13 10 50   1 1     3   6   40 44                       84 13 10 50   1 1     3   6   40 44                 84
1801206 CO     school 802340 180   Adams-Arapahoe 28J 80234006318 3471 Global Village Academy Aurora   Regular School Yes Elementary KG 08 2020   grade_8 3 13 59   0 0     0   3   42 36                       78 3 13 59   0 0     0   3   42 36                 78
1801266 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2020   grade_8 10 31 34   0 0     0   2   46 31                       77 10 31 34   0 0     0   2   46 31                 77
1801290 CO     school 802340 180   Adams-Arapahoe 28J 80234000073 6160 Mrachek Middle School   Regular School No Middle 06 08 2020   grade_8 39 65 164   2 17     6   25   171 147                       318 39 65 164   2 17     6   25   171 147                 318
1801299 CO     school 802340 180   Adams-Arapahoe 28J 80234001881 6189 Murphy Creek K-8 School   Regular School No Elementary PK 08 2020   grade_8 21 13 33   1 1     0   4   43 30                       73 21 13 33   1 1     0   4   43 30                 73
1801305 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_8 10 33 181   5 8     2   7   130 116                       246 10 33 181   5 8     2   7   130 116                 246
1801317 CO     school 802340 180   Adams-Arapahoe 28J 80234001789 6546 Options School   Regular School No Other KG 12 2020   grade_8 51 2 14   0 2     0   4   35 38                       73 51 2 14   0 2     0   4   35 38                 73
1801352 CO     school 802340 180   Adams-Arapahoe 28J 80234001674 7232 Aurora Quest K-8   Regular School No Elementary KG 08 2020   grade_8 33 11 26   0 12     1   2   36 49                       85 33 11 26   0 12     1   2   36 49                 85
1801394 CO     school 802340 180   Adams-Arapahoe 28J 80234000079 8078 South Middle School   Regular School No Middle 06 08 2020   grade_8 16 49 186   4 9     4   16   156 128                       284 16 49 186   4 9     4   16   156 128                 284
1801422 CO     school 802340 180   Adams-Arapahoe 28J 80234006322 9056 Vanguard Classical School - West   Regular School Yes Elementary KG 08 2020   grade_8 2 6 24   0 0     0   4   23 13                       36 2 6 24   0 0     0   4   23 13                 36
1801448 CO     school 802340 180   Adams-Arapahoe 28J 80234006483 9083 Vista Peak P-8 Exploratory   Regular School No Elementary PK 08 2020   grade_8 32 21 81   2 3     0   11   86 64                       150 32 21 81   2 3     0   11   86 64                 150
1801475 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2020   grade_8 9 20 27   0 0     1   1   30 28                       58 9 20 27   0 0     1   1   30 28                 58
1801484 CO     school 802340 180   Adams-Arapahoe 28J 80234000082 9396 Aurora West College Preparatory Academy   Regular School No High 06 12 2020   grade_8 13 28 189   0 23     1   9   141 122                       263 13 28 189   0 23     1   9   141 122                 263
1810452 CO     school 802370 2600   Platte Canyon 1 80237001325 7048 Fitzsimmons Middle School   Regular School No Middle 06 08 2020   grade_8 59 0 7   1 0     0   4   34 37                       71 59 0 7   1 0     0   4   34 37                 71
1808668 CO     school 802400 1530   Bayfield 10 Jt-R 80240000089 636 Bayfield Middle School   Regular School No Middle 06 08 2020   grade_8 77 1 20   4 1     0   2   53 52                       105 77 1 20   4 1     0   2   53 52                 105
1800115 CO     school 802430 50   Bennett 29J 80243000093 774 Bennett Middle School   Regular School No Middle 07 08 2020   grade_8 45 3 35   1 0     0   5   43 46                       89 45 3 35   1 0     0   5   43 46                 89
1808513 CO     school 802460 1490   Bethune R-5 80246000095 842 Bethune Public Schools   Regular School No Other PK 12 2020   grade_8 4 0 3   0 0     0   0   6 1                       7 4 0 3   0 0     0   0   6 1                 7
1802119 CO     school 802490 480   Boulder Valley Re 2 80249001758 441 Aspen Creek K-8 School   Regular School No Elementary PK 08 2020   grade_8 104 1 21   0 12     0   4   76 66                       142 104 1 21   0 12     0   4   76 66                 142
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
1802166 CO     school 802490 480   Boulder Valley Re 2 80249000102 1066 Broomfield Heights Middle School   Regular School No Middle 06 08 2020   grade_8 125 1 46   0 3     1   10   99 87                       186 125 1 46   0 3     1   10   99 87                 186
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
1802242 CO     school 802490 480   Boulder Valley Re 2 80249001771 2589 Eldorado K-8 School   Regular School No Elementary PK 08 2020   grade_8 124 2 9   0 13     0   10   83 75                       158 124 2 9   0 13     0   10   83 75                 158
1802253 CO     school 802490 480   Boulder Valley Re 2 80249006716 2639 Meadowlark School   Regular School No Elementary PK 08 2020   grade_8 47 1 12   0 3     0   5   40 28                       68 47 1 12   0 3     0   5   40 28                 68
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
1802346 CO     school 802490 480   Boulder Valley Re 2 80249000122 4878 Angevine Middle School   Regular School No Middle 06 08 2020   grade_8 117 2 84   3 7     0   11   116 108                       224 117 2 84   3 7     0   11   116 108                 224
1802357 CO     school 802490 480   Boulder Valley Re 2 80249000125 5306 Louisville Middle School   Regular School No Middle 06 08 2020   grade_8 163 2 30   3 7     0   14   110 109                       219 163 2 30   3 7     0   14   110 109                 219
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
1802415 CO     school 802490 480   Boulder Valley Re 2 80249000132 6224 Nevin Platt Middle School   Regular School No Middle 06 08 2020   grade_8 141 3 17   1 3     0   13   101 77                       178 141 3 17   1 3     0   13   101 77                 178
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
1802467 CO     school 802490 480   Boulder Valley Re 2 80249000134 8135 Southern Hills Middle School   Regular School No Middle 06 08 2020   grade_8 160 1 10   0 9     0   12   97 95                       192 160 1 10   0 9     0   12   97 95                 192
1802471 CO     school 802490 480   Boulder Valley Re 2 80249001517 8387 Summit Middle Charter School   Regular School Yes Middle 06 08 2020   grade_8 75 1 8   0 18     1   15   60 58                       118 75 1 8   0 18     1   15   60 58                 118

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