Data source: Big Local News · About: Big Local

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

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
1802560 CO     school 805040 510   Kit Carson R-1 80504000826 4742 Kit Carson Junior-Senior High School   Regular School No High 06 12 2020   grade_9 4 0 5   0 0     0   0   5 4                       9 4 0 5   0 0     0   0   5 4                 9
1802576 CO     school 800001 520   Cheyenne County Re-5 80000100215 1612 Cheyenne Wells Junior/High School   Regular School No High 07 12 2020   grade_9 15 0 1   0 0     0   0   10 6                       16 15 0 1   0 0     0   0   10 6                 16
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
1802620 CO     school 805100 550   North Conejos RE-1J 80510000843 1378 Centauri High School   Regular School No High 09 12 2020   grade_9 38 0 49   1 0     0   1   47 42                       89 38 0 49   1 0     0   1   47 42                 89
1802642 CO     school 805100 550   North Conejos RE-1J 80510006601 6339 North Conejos Alternative Program   Alternative School No Other KG 12 2020   grade_9 0 0 2   0 0     0   0   1 1                       2 0 0 2   0 0     0   0   1 1                 2
1802658 CO     school 806390 560   Sanford 6J 80639001114 7616 Sanford Junior/Senior High School   Regular School No High 07 12 2020   grade_9 20 0 5   0 0     0   0   13 12                       25 20 0 5   0 0     0   0   13 12                 25
1802675 CO     school 802130 580   South Conejos RE-10 80213000035 252 Antonito High School   Regular School No High 09 12 2020   grade_9 2 0 9   0 0     0   0   5 6                       11 2 0 9   0 0     0   0   5 6                 11
1802688 CO     school 806360 640   Centennial R-1 80636001416 1398 Centennial School   Regular School No Other PK 12 2020   grade_9 1 0 12   0 0     0   0   8 5                       13 1 0 12   0 0     0   0   8 5                 13
1802703 CO     school 804140 740   Sierra Grande R-30 80414000572 7880 Sierra Grande K-12 School   Regular School No Other PK 12 2020   grade_9 6 1 15   0 0     0   1   11 12                       23 6 1 15   0 0     0   1   11 12                 23
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
1802737 CO     school 807200 860   Custer County School District C-1 80720001225 2092 Custer County High School   Regular School No High 09 12 2020   grade_9 23 0 1   0 0     0   0   12 12                       24 23 0 1   0 0     0   0   12 12                 24
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1804276 CO     school 803450 900   Douglas County Re 1 80345006760 79 Ascent Classical Academy   Regular School Yes Other KG 11 2020   grade_9 34 0 4   0 0     0   0   21 17                       38 34 0 4   0 0     0   0   21 17                 38
1804371 CO     school 803450 900   Douglas County Re 1 80345001918 1367 Castle View High School   Regular School No High 09 12 2020   grade_9 419 3 97   3 18     1   20   285 276                       561 419 3 97   3 18     1   20   285 276                 561
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
1804402 CO     school 803450 900   Douglas County Re 1 80345006494 1555 Cloverleaf Home Education   Alternative School No Other KG 12 2020   grade_9 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
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
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
1804610 CO     school 803450 900   Douglas County Re 1 80345006391 3995 HOPE Online Learning Academy High School   Regular School Yes High 09 12 2020   grade_9 20 2 109   1 1     1   1   69 66                       135 20 2 109   1 1     1   1   69 66                 135
1804615 CO     school 803450 900   Douglas County Re 1 80345006400 4271 Legend High School   Regular School No High 09 12 2020   grade_9 429 3 76   2 18     1   27   269 287                       556 429 3 76   2 18     1   27   269 287                 556
1804665 CO     school 803450 900   Douglas County Re 1 80345006493 5259 STEM School Highlands Ranch   Regular School Yes Other KG 12 2020   grade_9 92 2 25   0 18     0   13   110 40                       150 92 2 25   0 18     0   13   110 40                 150
1804671 CO     school 803450 900   Douglas County Re 1 80345006372 5405 eDCSD   Regular School No Other KG 12 2020   grade_9 4 0 0   0 0     0   0   2 2                       4 4 0 0   0 0     0   0   2 2                 4
1804734 CO     school 803450 900   Douglas County Re 1 80345001748 6165 Mountain Vista High School   Regular School No High 09 12 2020   grade_9 464 3 80   1 44     3   29   319 305                       624 464 3 80   1 44     3   29   319 305                 624
1804747 CO     school 803450 900   Douglas County Re 1 80345006455 6365 Skyview Academy   Regular School Yes Other PK 12 2020   grade_9 68 2 16   0 11     0   6   49 54                       103 68 2 16   0 11     0   6   49 54                 103
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
1804844 CO     school 803450 900   Douglas County Re 1 80345006714 7244 Renaissance Secondary School   Regular School Yes High 06 12 2020   grade_9 43 1 10   0 1     0   1   35 21                       56 43 1 10   0 1     0   1   35 21                 56
1804868 CO     school 803450 900   Douglas County Re 1 80345001961 7435 Rock Canyon High School   Regular School No High 09 12 2020   grade_9 437 8 61   3 59     1   13   299 283                       582 437 8 61   3 59     1   13   299 283                 582
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
1804996 CO     school 803540 910   Eagle County RE 50 80354001756 205 Red Canyon High School   Alternative School No High 09 12 2020   grade_9 3 0 2   0 0     0   0   2 3                       5 3 0 2   0 0     0   0   2 3                 5
1805009 CO     school 803540 910   Eagle County RE 50 80354000461 604 Battle Mountain High School   Regular School No High 09 12 2020   grade_9 104 3 117   1 2     0   4   118 113                       231 104 3 117   1 2     0   4   118 113                 231
1805038 CO     school 803540 910   Eagle County RE 50 80354000463 2350 Eagle Valley High School   Regular School No High 09 12 2020   grade_9 107 0 132   0 1     0   2   127 115                       242 107 0 132   0 1     0   2   127 115                 242
1805097 CO     school 803540 910   Eagle County RE 50 80354006422 9061 Vail Ski and Snowboard Academy (VSSA)   Alternative School No High 05 12 2020   grade_9 22 0 2   0 1     0   1   17 9                       26 22 0 2   0 1     0   1   17 9                 26
1805107 CO     school 803540 910   Eagle County RE 50 80354006533 9701 World Academy   Regular School No Other KG 12 2020   grade_9 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1805126 CO     school 803720 920   Elizabeth School District 80372000483 2608 Elizabeth High School   Regular School No High 09 12 2020   grade_9 143 0 25   0 3     0   4   83 92                       175 143 0 25   0 3     0   4   83 92                 175
1805131 CO     school 803720 920   Elizabeth School District 80372001775 3236 Frontier High School   Alternative School No High 09 12 2020   grade_9 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1805166 CO     school 805010 930   Kiowa C-2 80501000825 4728 Kiowa High School   Regular School No High 09 12 2020   grade_9 17 1 0   0 0     0   0   9 9                       18 17 1 0   0 0     0   0   9 9                 18
1805183 CO     school 806600 940   Big Sandy 100J 80660001139 7922 Simla High School   Regular School No High 09 12 2020   grade_9 18 0 2   0 0     0   0   11 9                       20 18 0 2   0 0     0   0   11 9                 20
1805199 CO     school 803690 950   Elbert 200 80369000481 2574 Elbert Junior-Senior High School   Regular School No High 06 12 2020   grade_9 16 0 2   0 0     0   0   10 8                       18 16 0 2   0 0     0   0   10 8                 18

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