Data source: Big Local News · About: Big Local

489 rows where grade = "grade_9", state = "CO" and year = 2020 sorted by school_nces_id

View and edit SQL

year

  • 2020 · 389

grade

  • grade_9 · 389
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
1800790 CO     school 802910 130   Cherry Creek 5 80291000203 8020 Smoky Hill High School   Regular School No High 09 12 2020   grade_9 259 99 132   6 33     5   51   317 268                       585 259 99 132   6 33     5   51   317 268                 585
1800724 CO     school 802910 130   Cherry Creek 5 80291001272 6625 Overland High School   Regular School No High 09 12 2020   grade_9 119 144 219   2 27     3   35   292 257                       549 119 144 219   2 27     3   35   292 257                 549
1800599 CO     school 802910 130   Cherry Creek 5 80291001625 3589 Grandview High School   Regular School No High 09 12 2020   grade_9 436 69 108   7 102     3   57   401 381                       782 436 69 108   7 102     3   57   401 381                 782
1800495 CO     school 802910 130   Cherry Creek 5 80291001951 1551 Cherokee Trail High School   Regular School No High 09 12 2020   grade_9 416 75 100   4 59     1   38   355 338                       693 416 75 100   4 59     1   38   355 338                 693
1800574 CO     school 802910 130   Cherry Creek 5 80291006156 2357 Eaglecrest High School   Regular School No High 09 12 2020   grade_9 378 112 178   7 65     2   54   413 383                       796 378 112 178   7 65     2   54   413 383                 796
1800716 CO     school 802910 130   Cherry Creek 5 80291006563 6367 Options School   Alternative School No Other KG 12 2020   grade_9 27 1 5   0 0     0   0   15 18                       33 27 1 5   0 0     0   0   15 18                 33
1800480 CO     school 802910 130   Cherry Creek 5 80291006791 1429 Cherry Creek Elevation   Regular School No High 09 12 2020   grade_9 17 2 1   0 0     0   2   9 13                       22 17 2 1   0 0     0   2   9 13                 22
1805997 CO     school 802940 1020   Cheyenne Mountain 12 80294000211 1590 Cheyenne Mountain High School   Regular School No High 09 12 2020   grade_9 235 6 50   1 10     0   24   164 162                       326 235 6 50   1 10     0   24   164 162                 326
1806039 CO     school 802940 1020   Cheyenne Mountain 12 80294006370 9057 The Vanguard School (High)   Regular School Yes High 09 12 2020   grade_9 45 5 15   0 9     0   9   31 52                       83 45 5 15   0 9     0   9   31 52                 83
1802602 CO     school 803000 540   Clear Creek RE-1 80300000217 4216 Clear Creek High School   Regular School No High 09 12 2020   grade_9 51 1 4   0 1     0   0   35 22                       57 51 1 4   0 1     0   0   35 22                 57
1809622 CO     school 803030 1990   Plateau Valley 50 80303000220 7032 Plateau Valley High School   Regular School No High 09 12 2020   grade_9 20 0 3   0 2     0   0   10 15                       25 20 0 3   0 2     0   0   10 15                 25
1805674 CO     school 803060 1010   Colorado Springs 11 80306000228 1870 Coronado High School   Regular School No High 09 12 2020   grade_9 244 25 98   5 1     0   20   207 186                       393 244 25 98   5 1     0   20   207 186                 393
1805705 CO     school 803060 1010   Colorado Springs 11 80306000232 2528 Nikola Tesla Education Opportunity Center   Alternative School No High 06 12 2020   grade_9 12 3 9   0 1     0   0   10 15                       25 12 3 9   0 1     0   0   10 15                 25
1805846 CO     school 803060 1010   Colorado Springs 11 80306000254 5948 Mitchell High School   Regular School No High 09 12 2020   grade_9 76 29 166   3 3     0   15   154 138                       292 76 29 166   3 3     0   15   154 138                 292
1805863 CO     school 803060 1010   Colorado Springs 11 80306000257 6680 Palmer High School   Regular School No High 09 12 2020   grade_9 189 47 140   6 1     2   28   206 207                       413 189 47 140   6 1     2   28   206 207                 413
1805684 CO     school 803060 1010   Colorado Springs 11 80306000268 2202 Doherty High School   Regular School No High 09 12 2020   grade_9 263 31 126   4 13     3   39   231 248                       479 263 31 126   4 13     3   39   231 248                 479
1805679 CO     school 803060 1010   Colorado Springs 11 80306001299 1885 Community Prep Charter School   Alternative School Yes High 09 12 2020   grade_9 7 3 3   0 0     0   0   8 5                       13 7 3 3   0 0     0   0   8 5                 13
1805653 CO     school 803060 1010   Colorado Springs 11 80306001589 1616 CIVA Charter Academy   Regular School Yes High 09 12 2020   grade_9 21 0 8   1 1     0   8   13 26                       39 21 0 8   1 1     0   8   13 26                 39
1805799 CO     school 803060 1010   Colorado Springs 11 80306001841 5146 Eastlake High School of Colorado Springs   Alternative School Yes High 09 12 2020   grade_9 0 0 0   1 0     0   0   1 0                       1 0 0 0   1 0     0   0   1 0                 1
1805616 CO     school 803060 1010   Colorado Springs 11 80306001888 871 The Bijou School   Alternative School No High 09 12 2020   grade_9 6 1 4   0 0     0   3   7 7                       14 6 1 4   0 0     0   3   7 7                 14
1805591 CO     school 803060 1010   Colorado Springs 11 80306006428 269 Achieve Online   Alternative School No High 06 12 2020   grade_9 20 1 13   0 0     0   0   15 19                       34 20 1 13   0 0     0   0   15 19                 34
1805689 CO     school 803060 1010   Colorado Springs 11 80306006580 2400 Odyssey Early College and Career Options   Alternative School No High 09 12 2020   grade_9 58 2 25   0 1     0   9   37 58                       95 58 2 25   0 1     0   9   37 58                 95
1810054 CO     school 803090 2035   Montezuma-Cortez RE-1 80309000840 6026 Montezuma-Cortez High School   Regular School No High 09 12 2020   grade_9 78 1 32   43 0     1   4   82 77                       159 78 1 32   43 0     1   4   82 77                 159
1810069 CO     school 803090 2035   Montezuma-Cortez RE-1 80309001692 8133 Southwest Open Charter School   Alternative School Yes High 09 12 2020   grade_9 11 0 5   9 0     0   0   15 10                       25 11 0 5   9 0     0   0   15 10                 25
1806851 CO     school 803120 1160   Cotopaxi RE-3 80312000277 3228 Cotopaxi Junior-Senior High School   Regular School No High 06 12 2020   grade_9 20 0 1   0 0     0   0   13 8                       21 20 0 1   0 0     0   0   13 8                 21
1809958 CO     school 803150 2010   Creede School District 80315000279 1966 Creede School   Regular School No Other PK 12 2020   grade_9 5 0 1   0 0     0   0   4 2                       6 5 0 1   0 0     0   0   4 2                 6
1811437 CO     school 803180 3010   Cripple Creek-Victor RE-1 80318000281 2024 Cripple Creek-Victor Junior-Senior High School   Regular School No High 06 12 2020   grade_9 19 0 6   0 0     0   0   16 9                       25 19 0 6   0 0     0   0   16 9                 25
1802720 CO     school 803210 770   Crowley County RE-1-J 80321000282 2058 Crowley County Junior and Senior High School   Regular School No High 07 12 2020   grade_9 23 1 11   0 0     0   0   14 21                       35 23 1 11   0 0     0   0   14 21                 35
1809599 CO     school 803240 1980   De Beque 49JT 80324000286 2126 De Beque PK-12 School District 49JT   Regular School No Other PK 12 2020   grade_9 14 0 0   0 0     0   0   7 7                       14 14 0 0   0 0     0   0   7 7                 14
1801013 CO     school 803270 170   Deer Trail 26J 80327000288 2140 Deer Trail Junior-Senior High School   Regular School No High 06 12 2020   grade_9 12 0 4   0 0     0   0   9 7                       16 12 0 4   0 0     0   0   9 7                 16
1811083 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_9 19 0 22   1 0     0   0   22 20                       42 19 0 22   1 0     0   0   22 20                 42
1802776 CO     school 803330 870   Delta County 50(J) 80333000297 2164 Delta High School   Regular School No High 09 12 2020   grade_9 92 0 69   0 3     0   6   80 90                       170 92 0 69   0 3     0   6   80 90                 170
1802814 CO     school 803330 870   Delta County 50(J) 80333000300 4128 Hotchkiss High School   Regular School No High 09 12 2020   grade_9 28 0 10   0 0     0   0   16 22                       38 28 0 10   0 0     0   0   16 22                 38
1802853 CO     school 803330 870   Delta County 50(J) 80333000304 6708 Paonia High School   Regular School No High 07 12 2020   grade_9 30 0 7   1 0     0   1   23 16                       39 30 0 7   1 0     0   1   23 16                 39
1802744 CO     school 803330 870   Delta County 50(J) 80333001335 1372 Cedaredge High School   Regular School No High 09 12 2020   grade_9 68 0 8   0 0     0   2   36 42                       78 68 0 8   0 0     0   2   36 42                 78
1802767 CO     school 803330 870   Delta County 50(J) 80333001953 2155 Grand Mesa Choice Academy   Alternative School No High 07 12 2020   grade_9 2 0 2   0 0     0   0   4 0                       4 2 0 2   0 0     0   0   4 0                 4
1802789 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2020   grade_9 23 0 5   0 0     0   3   14 17                       31 23 0 5   0 0     0   3   14 17                 31
1802858 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2020   grade_9 9 20 302   4 7     0   2   202 142                       344 9 20 302   4 7     0   2   202 142                 344
1802973 CO     school 803360 880   Denver County 1 80336000322 1319 Career Education Center Early College   Career and Technical School No High 09 12 2020   grade_9 2 1 119   0 2     0   0   58 66                       124 2 1 119   0 2     0   0   58 66                 124
1803269 CO     school 803360 880   Denver County 1 80336000338 2398 East High School   Regular School No High 09 12 2020   grade_9 361 122 155   5 25     2   40   346 364                       710 361 122 155   5 25     2   40   346 364                 710
1803295 CO     school 803360 880   Denver County 1 80336000345 2726 Emily Griffith High School   Alternative School No High 09 12 2020   grade_9 1 3 8   0 3     0   0   6 9                       15 1 3 8   0 3     0   0   6 9                 15
1803348 CO     school 803360 880   Denver County 1 80336000352 3378 George Washington High School   Regular School No High 09 12 2020   grade_9 143 116 126   2 17     2   26   225 207                       432 143 116 126   2 17     2   26   225 207                 432
1803527 CO     school 803360 880   Denver County 1 80336000367 4444 John F Kennedy High School   Regular School No High 09 12 2020   grade_9 37 11 248   5 14     0   3   166 152                       318 37 11 248   5 14     0   3   166 152                 318
1803718 CO     school 803360 880   Denver County 1 80336000380 5844 Contemporary Learning Academy   Alternative School No High 09 12 2020   grade_9 5 11 16   0 0     0   2   16 18                       34 5 11 16   0 0     0   2   16 18                 34
1803783 CO     school 803360 880   Denver County 1 80336000389 6314 North High School   Regular School No High 09 12 2020   grade_9 89 14 280   5 10     1   7   203 203                       406 89 14 280   5 10     1   7   203 203                 406
1804000 CO     school 803360 880   Denver County 1 80336000408 8086 South High School   Regular School No High 09 12 2020   grade_9 254 61 151   7 35     1   18   251 276                       527 254 61 151   7 35     1   18   251 276                 527
1804097 CO     school 803360 880   Denver County 1 80336000417 8822 Thomas Jefferson High School   Regular School No High 09 12 2020   grade_9 127 75 171   3 20     1   24   245 176                       421 127 75 171   3 20     1   24   245 176                 421
1803660 CO     school 803360 880   Denver County 1 80336001406 5605 Dr. Martin Luther King Jr. Early College   Regular School No High 06 12 2020   grade_9 10 90 162   1 12     9   9   161 132                       293 10 90 162   1 12     9   9   161 132                 293
1803173 CO     school 803360 880   Denver County 1 80336001574 2184 Denver School of the Arts   Regular School No High 06 12 2020   grade_9 118 6 37   2 10     0   8   71 110                       181 118 6 37   2 10     0   8   71 110                 181
1803320 CO     school 803360 880   Denver County 1 80336001575 3000 Florence Crittenton High School   Alternative School No High 09 12 2020   grade_9 0 1 16   0 0     0   1   0 18                       18 0 1 16   0 0     0   1   0 18                 18
1802864 CO     school 803360 880   Denver County 1 80336001724 40 Ridge View Academy Charter School   Alternative School Yes High 07 12 2020   grade_9 15 6 24   0 0     0   1   46 0                       46 15 6 24   0 0     0   1   46 0                 46
1803883 CO     school 803360 880   Denver County 1 80336001795 7163 Prep Academy   Alternative School No High 06 12 2020   grade_9 2 7 9   0 0     0   1   10 9                       19 2 7 9   0 0     0   1   10 9                 19
1803178 CO     school 803360 880   Denver County 1 80336001833 2185 DSST: Montview High School   Regular School Yes High 09 12 2020   grade_9 14 57 70   2 5     0   7   85 70                       155 14 57 70   2 5     0   7   85 70                 155
1803024 CO     school 803360 880   Denver County 1 80336001862 1748 Colorado High School Charter   Alternative School Yes High 09 12 2020   grade_9 1 26 66   1 1     0   3   55 43                       98 1 26 66   1 1     0   3   55 43                 98
1803791 CO     school 803360 880   Denver County 1 80336001869 6350 Bruce Randolph School   Regular School No High 06 12 2020   grade_9 1 8 103   0 1     0   0   51 62                       113 1 8 103   0 1     0   0   51 62                 113
1802869 CO     school 803360 880   Denver County 1 80336001894 67 Academy of Urban Learning   Alternative School Yes High 09 12 2020   grade_9 5 3 32   0 0     0   0   25 15                       40 5 3 32   0 0     0   0   25 15                 40
1803165 CO     school 803360 880   Denver County 1 80336001917 2183 Denver Center for International Studies   Regular School No High 06 12 2020   grade_9 16 3 68   0 3     0   2   38 54                       92 16 3 68   0 3     0   2   38 54                 92
1803830 CO     school 803360 880   Denver County 1 80336001955 6509 Denver Online High School   Regular School No High 09 12 2020   grade_9 17 4 30   1 2     0   5   21 38                       59 17 4 30   1 2     0   5   21 38                 59
1803644 CO     school 803360 880   Denver County 1 80336006328 5448 Manual High School   Regular School No High 09 12 2020   grade_9 3 28 48   0 0     0   3   47 35                       82 3 28 48   0 0     0   3   47 35                 82
1803608 CO     school 803360 880   Denver County 1 80336006442 4795 Kunsmiller Creative Arts Academy   Regular School No Other KG 12 2020   grade_9 4 2 66   1 8     0   1   31 51                       82 4 2 66   1 8     0   1   31 51                 82
1803540 CO     school 803360 880   Denver County 1 80336006443 4494 Denver Justice High School   Alternative School Yes High 09 12 2020   grade_9 1 9 34   1 0     0   1   21 25                       46 1 9 34   1 0     0   1   21 25                 46
1803574 CO     school 803360 880   Denver County 1 80336006448 4730 KIPP Denver Collegiate High School   Regular School Yes High 09 12 2020   grade_9 0 3 130   0 3     0   1   76 61                       137 0 3 130   0 3     0   1   76 61                 137
1803130 CO     school 803360 880   Denver County 1 80336006450 2145 DSST: Green Valley Ranch High School   Regular School Yes High 09 12 2020   grade_9 7 34 99   0 18     0   3   77 84                       161 7 34 99   0 18     0   3   77 84                 161
1804026 CO     school 803360 880   Denver County 1 80336006491 8145 Summit Academy   Alternative School No High 06 12 2020   grade_9 2 0 45   0 0     0   1   24 24                       48 2 0 45   0 0     0   1   24 24                 48
1804135 CO     school 803360 880   Denver County 1 80336006514 8995 Vista Academy   Alternative School No High 06 12 2020   grade_9 0 11 28   0 1     1   0   24 17                       41 0 11 28   0 1     1   0   24 17                 41
1802968 CO     school 803360 880   Denver County 1 80336006515 1295 Collegiate Preparatory Academy   Regular School No High 09 12 2020   grade_9 2 22 50   0 1     1   3   38 41                       79 2 22 50   0 1     1   3   38 41                 79
1803190 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_9 7 16 35   0 0     0   3   34 27                       61 7 16 35   0 0     0   3   34 27                 61
1803765 CO     school 803360 880   Denver County 1 80336006520 6239 Noel Community Arts School   Regular School No High 06 12 2020   grade_9 3 22 44   0 1     1   0   29 42                       71 3 22 44   0 1     1   0   29 42                 71
1803300 CO     school 803360 880   Denver County 1 80336006527 2757 Northeast Early College   Regular School No High 09 12 2020   grade_9 8 21 83   0 0     1   2   59 56                       115 8 21 83   0 0     1   2   59 56                 115
1803218 CO     school 803360 880   Denver County 1 80336006528 2209 DCIS at Montbello   Regular School No High 06 12 2020   grade_9 2 24 157   1 3     4   1   114 78                       192 2 24 157   1 3     4   1   114 78                 192
1804197 CO     school 803360 880   Denver County 1 80336006543 9639 STRIVE Prep - Smart Academy   Regular School Yes High 09 12 2020   grade_9 1 0 171   0 0     1   0   99 74                       173 1 0 171   0 0     1   0   99 74                 173
1804213 CO     school 803360 880   Denver County 1 80336006547 9702 West Leadership Academy   Regular School No High 06 12 2020   grade_9 5 4 112   2 0     0   1   74 50                       124 5 4 112   2 0     0   1   74 50                 124
1804205 CO     school 803360 880   Denver County 1 80336006551 9693 West Early College   Regular School No High 06 12 2020   grade_9 4 9 91   3 0     0   3   55 55                       110 4 9 91   3 0     0   3   55 55                 110
1803137 CO     school 803360 880   Denver County 1 80336006568 2167 Denver Montessori Junior/Senior High School   Regular School No High 07 12 2020   grade_9 9 2 22   0 0     0   3   18 18                       36 9 2 22   0 0     0   3   18 18                 36
1803778 CO     school 803360 880   Denver County 1 80336006569 6308 North High School Engagement Center   Alternative School No High 09 12 2020   grade_9 1 1 6   0 0     0   0   6 2                       8 1 1 6   0 0     0   0   6 2                 8
1804057 CO     school 803360 880   Denver County 1 80336006576 8347 STRIVE Prep - Excel   Regular School Yes High 09 12 2020   grade_9 0 2 96   2 0     0   0   59 41                       100 0 2 96   2 0     0   0   59 41                 100
1803002 CO     school 803360 880   Denver County 1 80336006583 1489 Compassion Road Academy   Alternative School No High 09 12 2020   grade_9 1 5 23   2 0     0   1   16 16                       32 1 5 23   2 0     0   1   16 16                 32
1803282 CO     school 803360 880   Denver County 1 80336006599 2641 Excel Academy   Alternative School No High 09 12 2020   grade_9 4 1 73   0 0     0   1   52 27                       79 4 1 73   0 0     0   1   52 27                 79
1803369 CO     school 803360 880   Denver County 1 80336006626 3540 Girls Athletic Leadership School High School   Regular School Yes High 09 12 2020   grade_9 9 5 16   1 1     0   1   0 33                       33 9 5 16   1 1     0   1   0 33                 33
1803151 CO     school 803360 880   Denver County 1 80336006636 2175 DSST: Cole High School   Regular School Yes High 09 12 2020   grade_9 4 21 99   0 0     0   1   67 58                       125 4 21 99   0 0     0   1   67 58                 125
1803240 CO     school 803360 880   Denver County 1 80336006640 2241 Denver School of Innovation and Sustainable Design   Regular School No High 09 12 2020   grade_9 8 8 13   0 2     0   1   23 9                       32 8 8 13   0 2     0   1   23 9                 32
1803914 CO     school 803360 880   Denver County 1 80336006647 7361 RiseUp Community School   Alternative School Yes High 09 12 2020   grade_9 1 2 12   0 0     0   2   7 10                       17 1 2 12   0 0     0   2   7 10                 17
1803245 CO     school 803360 880   Denver County 1 80336006658 2244 DSST: College View High School   Regular School Yes High 09 12 2020   grade_9 9 0 153   1 5     0   2   102 68                       170 9 0 153   1 5     0   2   102 68                 170
1803796 CO     school 803360 880   Denver County 1 80336006660 6368 Northfield High School   Regular School No High 09 12 2020   grade_9 132 68 126   1 8     1   24   171 189                       360 132 68 126   1 8     1   24   171 189                 360
1803618 CO     school 803360 880   Denver County 1 80336006669 5044 Legacy Options High School   Alternative School No High 09 12 2020   grade_9 0 5 18   0 0     0   1   12 12                       24 0 5 18   0 0     0   1   12 12                 24
1803565 CO     school 803360 880   Denver County 1 80336006670 4509 KIPP Northeast Denver Leadership Academy   Regular School Yes High 09 12 2020   grade_9 9 23 131   0 12     3   2   96 84                       180 9 23 131   0 12     3   2   96 84                 180
1803235 CO     school 803360 880   Denver County 1 80336006684 2228 DSST: Byers High School   Regular School Yes High 09 12 2020   grade_9 69 23 57   2 2     0   12   96 69                       165 69 23 57   2 2     0   12   96 69                 165
1803976 CO     school 803360 880   Denver County 1 80336006689 7973 STRIVE Prep - Rise   Regular School Yes High 09 12 2020   grade_9 7 20 127   0 3     1   2   83 77                       160 7 20 127   0 3     1   2   83 77                 160
1803014 CO     school 803360 880   Denver County 1 80336006730 1529 DSST: Conservatory Green High School   Regular School Yes Secondary 09 11 2020   grade_9 18 46 89   1 7     0   4   85 80                       165 18 46 89   1 7     0   4   85 80                 165
1803426 CO     school 803360 880   Denver County 1 80336006731 3699 Delta High School   Alternative School No High 09 12 2020   grade_9 1 0 1   0 0     0   0   1 1                       2 1 0 1   0 0     0   0   1 1                 2
1803019 CO     school 803360 880   Denver County 1 80336006735 1561 Colorado High School Charter - GES   Alternative School Yes High 09 12 2020   grade_9 1 9 27   1 0     0   1   28 11                       39 1 9 27   1 0     0   1   28 11                 39
1803315 CO     school 803360 880   Denver County 1 80336006756 2994 5280 High School   Regular School Yes High 09 12 2020   grade_9 10 3 35   0 0     0   2   31 19                       50 10 3 35   0 0     0   2   31 19                 50
1803195 CO     school 803360 880   Denver County 1 80336006780 2199 The Cube   Regular School Yes Secondary 09 09 2020   grade_9 34 11 27   1 0     0   8   50 31                       81 34 11 27   1 0     0   8   50 31                 81
1810084 CO     school 803390 2055   Dolores RE-4A 80339000432 2208 Dolores Secondary School   Regular School No High 07 12 2020   grade_9 37 0 12   2 0     0   0   24 27                       51 37 0 12   2 0     0   0   24 27                 51
1804236 CO     school 803420 890   Dolores County RE No.2 80342000429 2216 Dove Creek High School   Regular School No High 06 12 2020   grade_9 24 0 1   3 0     0   0   18 10                       28 24 0 1   3 0     0   0   18 10                 28
1804470 CO     school 803450 900   Douglas County Re 1 80345000440 2230 Douglas County High School   Regular School No High 09 12 2020   grade_9 338 4 80   1 14     2   25   223 241                       464 338 4 80   1 14     2   25   223 241                 464
1804827 CO     school 803450 900   Douglas County Re 1 80345001341 7118 Ponderosa High School   Regular School No High 09 12 2020   grade_9 288 0 43   2 6     0   12   189 162                       351 288 0 43   2 6     0   12   189 162                 351
1804605 CO     school 803450 900   Douglas County Re 1 80345001437 3980 Highlands Ranch High School   Regular School No High 09 12 2020   grade_9 289 11 55   3 24     0   23   210 195                       405 289 11 55   3 24     0   23   210 195                 405
1804935 CO     school 803450 900   Douglas County Re 1 80345001529 8847 Thunderridge High School   Regular School No High 09 12 2020   grade_9 408 2 74   4 23     1   25   288 249                       537 408 2 74   4 23     1   25   288 249                 537
1804376 CO     school 803450 900   Douglas County Re 1 80345001578 1503 Chaparral High School   Regular School No High 09 12 2020   grade_9 392 14 90   2 20     2   27   278 269                       547 392 14 90   2 20     2   27   278 269                 547

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