Data source: Big Local News · About: Big Local

3,382 rows where grade = "grade_9" and state = "CO" sorted by district_state_id descending

View and edit SQL

year

grade

  • grade_9 · 3,382
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
721022 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_9 10 6 19   1 0     0   0   29 7                       36 10 6 19   1 0     0   0   29 7                 36
848557 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2016   grade_9 10 3 15   0 0     0   0   20 8                       28 10 3 15   0 0     0   0   20 8                 28
1146096 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2015   grade_9 16.0 2.0 11.0   0.0 0.0     0.0   0.0   22.0 7.0                       29.0 16 2 11   0 0     0   0   22 7                 29
1751544 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2021   grade_9 7 8 14   0 0     0   2   27 4                       31 7 8 14   0 0     0   2   27 4                 31
1812625 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2020   grade_9 15 6 17   0 2     0   7   41 6                       47 15 6 17   0 2     0   7   41 6                 47
1906986 CO     school   9999   COLORADO DETENTION CENTERS   No school COLORADO DETENTION CENTERS             2018   grade_9 14 6 24   0 0     0   1   36 9                       45 14 6 24   0 0     0   1   36 9                 45
1944366 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_9 6 13 19   1 0     0   0   25 14                       39 6 13 19   1 0     0   0   25 14                 39
713868 CO     school 806480 990   WIDEFIELD 3 80648001588 5841 MESA RIDGE HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 154 49 103   3 3     3   30   182 163                       345 154 49 103   3 3     3   30   182 163                 345
713920 CO     school 806480 990   WIDEFIELD 3 80648001129 9566 WIDEFIELD HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 153 40 110   2 3     8   39   177 178                       355 153 40 110   2 3     8   39   177 178                 355
841482 CO     school 806480 990   WIDEFIELD 3 80648001588 5841 MESA RIDGE HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 191 31 96   5 5     2   25   182 173                       355 191 31 96   5 5     2   25   182 173                 355
841535 CO     school 806480 990   WIDEFIELD 3 80648001129 9566 WIDEFIELD HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 185 32 106   3 6     5   45   183 199                       382 185 32 106   3 6     5   45   183 199                 382
1139084 CO     school 806480 990   WIDEFIELD 3 80648001588 5841 MESA RIDGE HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 180.0 43.0 93.0   0.0 5.0     6.0   34.0   184.0 177.0                       361.0 180 43 93   0 5     6   34   184 177                 361
1139126 CO     school 806480 990   WIDEFIELD 3 80648000051 9560 DISCOVERY HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_9 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0                       1.0 0 0 0   0 0     0   1   1 0                 1
1139139 CO     school 806480 990   WIDEFIELD 3 80648001129 9566 WIDEFIELD HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 162.0 38.0 91.0   3.0 2.0     5.0   32.0   180.0 153.0                       333.0 162 38 91   3 2     5   32   180 153                 333
1744371 CO     school 806480 990   Widefield 3 80648001588 5841 Mesa Ridge High School   Regular School No High 09 12 2021   grade_9 159 37 106   4 7     8   43   199 165                       364 159 37 106   4 7     8   43   199 165                 364
1744423 CO     school 806480 990   Widefield 3 80648001129 9566 Widefield High School   Regular School No High 09 12 2021   grade_9 161 35 99   3 5     2   45   184 166                       350 161 35 99   3 5     2   45   184 166                 350
1805450 CO     school 806480 990   Widefield 3 80648001588 5841 Mesa Ridge High School   Regular School No High 09 12 2020   grade_9 184 32 102   2 6     4   36   187 179                       366 184 32 102   2 6     4   36   187 179                 366
1805503 CO     school 806480 990   Widefield 3 80648001129 9566 Widefield High School   Regular School No High 09 12 2020   grade_9 159 30 85   2 6     6   32   161 159                       320 159 30 85   2 6     6   32   161 159                 320
1899778 CO     school 806480 990   WIDEFIELD 3 80648001588 5841 MESA RIDGE HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 164 34 97   2 6     4   24   183 148                       331 164 34 97   2 6     4   24   183 148                 331
1899830 CO     school 806480 990   WIDEFIELD 3 80648001129 9566 WIDEFIELD HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 150 34 126   3 3     9   39   177 187                       364 150 34 126   3 3     9   39   177 187                 364
1937154 CO     school 806480 990   WIDEFIELD 3 80648001588 5841 MESA RIDGE HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 143 36 106   2 4     5   32   193 135                       328 143 36 106   2 4     5   32   193 135                 328
1937206 CO     school 806480 990   WIDEFIELD 3 80648001129 9566 WIDEFIELD HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 159 31 89   4 4     5   43   182 153                       335 159 31 89   4 4     5   43   182 153                 335
713669 CO     school 804530 980   HARRISON 2 80453006425 469 ATLAS PREPARATORY HIGH SCHOOL   Regular School Yes High 09 12 2017   grade_9 23 14 97   1 0     0   3   67 71                       138 23 14 97   1 0     0   3   67 71                 138
713703 CO     school 804530 980   HARRISON 2 80453000667 3806 HARRISON HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 67 59 158   7 7     1   20   164 155                       319 67 59 158   7 7     1   20   164 155                 319
713709 CO     school 804530 980   HARRISON 2 80453006535 3870 HIGH SCHOOL PREPARATORY ACADEMY   Regular School No High 08 12 2017   grade_9 0 0 2   0 0     0   0   1 1                       2 0 0 2   0 0     0   0   1 1                 2
713714 CO     school 804530 980   HARRISON 2 80453001781 4378 JAMES IRWIN CHARTER HIGH SCHOOL   Regular School Yes High 09 12 2017   grade_9 45 13 51   2 9     1   4   56 69                       125 45 13 51   2 9     1   4   56 69                 125
713739 CO     school 804530 980   HARRISON 2 80453006663 5763 MOUNTAIN VISTA HOMESCHOOL ACADEMY   Regular School No Other KG 12 2017   grade_9 7 0 6   0 1     0   0   6 8                       14 7 0 6   0 1     0   0   6 8                 14
713794 CO     school 804530 980   HARRISON 2 80453001382 7882 SIERRA HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 35 50 109   6 4     1   17   119 103                       222 35 50 109   6 4     1   17   119 103                 222
841284 CO     school   980   HARRISON 2   469 ATLAS PREPARATORY SCHOOL             2016   grade_9 14 25 80   0 0     0   2   65 56                       121 14 25 80   0 0     0   2   65 56                 121
841318 CO     school 804530 980   HARRISON 2 80453000667 3806 HARRISON HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 56 59 137   3 6     1   16   135 143                       278 56 59 137   3 6     1   16   135 143                 278
841324 CO     school 804530 980   HARRISON 2 80453006535 3870 HIGH SCHOOL PREPARATORY ACADEMY   Regular School No 3.0 08 12 2016   grade_9 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
841329 CO     school 804530 980   HARRISON 2 80453001781 4378 JAMES IRWIN CHARTER HIGH SCHOOL   Regular School Yes 3.0 09 12 2016   grade_9 44 8 53   0 8     1   6   57 63                       120 44 8 53   0 8     1   6   57 63                 120
841353 CO     school 804530 980   HARRISON 2 80453006663 5763 MOUNTAIN VISTA HOMESCHOOL ACADEMY   Regular School No 4.0 KG 12 2016   grade_9 7 0 6   0 0     0   1   7 7                       14 7 0 6   0 0     0   1   7 7                 14
841408 CO     school 804530 980   HARRISON 2 80453001382 7882 SIERRA HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 42 60 89   2 8     4   8   113 100                       213 42 60 89   2 8     4   8   113 100                 213
1138900 CO     school 804530 980   HARRISON 2 80453006425 469 ATLAS PREPARATORY SCHOOL   Regular School Yes 4.0 05 10 2015   grade_9 16.0 17.0 70.0   2.0 1.0     0.0   3.0   67.0 42.0                       109.0 16 17 70   2 1     0   3   67 42                 109
1138934 CO     school 804530 980   HARRISON 2 80453000667 3806 HARRISON HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 92.0 44.0 145.0   2.0 8.0     3.0   19.0   164.0 149.0                       313.0 92 44 145   2 8     3   19   164 149                 313
1138944 CO     school 804530 980   HARRISON 2 80453001781 4378 JAMES IRWIN CHARTER HIGH SCHOOL   Regular School Yes 3.0 09 12 2015   grade_9 54.0 12.0 51.0   1.0 6.0     1.0   9.0   55.0 79.0                       134.0 54 12 51   1 6     1   9   55 79                 134
1139010 CO     school 804530 980   HARRISON 2 80453001382 7882 SIERRA HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 33.0 65.0 110.0   6.0 4.0     2.0   12.0   114.0 118.0                       232.0 33 65 110   6 4     2   12   114 118                 232
1744156 CO     school 804530 980   Harrison 2 80453006425 469 Atlas Preparatory High School   Regular School Yes High 09 12 2021   grade_9 10 9 108   1 1     1   6   67 69                       136 10 9 108   1 1     1   6   67 69                 136
1744190 CO     school 804530 980   Harrison 2 80453000667 3806 Harrison High School   Regular School No High 09 12 2021   grade_9 71 40 162   2 7     3   31   174 142                       316 71 40 162   2 7     3   31   174 142                 316
1744199 CO     school 804530 980   Harrison 2 80453001781 4378 James Irwin Charter High School   Regular School Yes High 09 12 2021   grade_9 35 11 72   2 3     1   5   69 60                       129 35 11 72   2 3     1   5   69 60                 129
1744223 CO     school 804530 980   Harrison 2 80453006663 5763 Mountain Vista Homeschool Academy   Regular School No Other KG 12 2021   grade_9 19 0 6   0 0     0   0   12 13                       25 19 0 6   0 0     0   0   12 13                 25
1744284 CO     school 804530 980   Harrison 2 80453001382 7882 Sierra High School   Regular School No High 09 12 2021   grade_9 34 44 120   2 4     1   17   127 95                       222 34 44 120   2 4     1   17   127 95                 222
1805240 CO     school 804530 980   Harrison 2 80453006425 469 Atlas Preparatory High School   Regular School Yes High 09 12 2020   grade_9 12 7 116   0 1     1   5   66 76                       142 12 7 116   0 1     1   5   66 76                 142
1805274 CO     school 804530 980   Harrison 2 80453000667 3806 Harrison High School   Regular School No High 09 12 2020   grade_9 63 55 159   2 6     2   16   165 138                       303 63 55 159   2 6     2   16   165 138                 303
1805283 CO     school 804530 980   Harrison 2 80453001781 4378 James Irwin Charter High School   Regular School Yes High 09 12 2020   grade_9 56 9 59   0 4     1   17   68 78                       146 56 9 59   0 4     1   17   68 78                 146
1805307 CO     school 804530 980   Harrison 2 80453006663 5763 Mountain Vista Homeschool Academy   Regular School No Other KG 12 2020   grade_9 15 0 2   1 0     0   0   9 9                       18 15 0 2   1 0     0   0   9 9                 18
1805363 CO     school 804530 980   Harrison 2 80453001382 7882 Sierra High School   Regular School No High 09 12 2020   grade_9 50 60 125   1 6     0   17   135 124                       259 50 60 125   1 6     0   17   135 124                 259
1899582 CO     school 804530 980   HARRISON 2 80453006425 469 ATLAS PREPARATORY HIGH SCHOOL   Regular School Yes High 09 12 2018   grade_9 11 11 92   2 0     0   4   61 59                       120 11 11 92   2 0     0   4   61 59                 120
1899616 CO     school 804530 980   HARRISON 2 80453000667 3806 HARRISON HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 63 54 123   3 6     7   25   146 135                       281 63 54 123   3 6     7   25   146 135                 281
1899625 CO     school 804530 980   HARRISON 2 80453001781 4378 JAMES IRWIN CHARTER HIGH SCHOOL   Regular School Yes High 09 12 2018   grade_9 37 14 53   2 6     4   6   56 66                       122 37 14 53   2 6     4   6   56 66                 122
1899649 CO     school 804530 980   HARRISON 2 80453006663 5763 MOUNTAIN VISTA HOMESCHOOL ACADEMY   Regular School No Other KG 12 2018   grade_9 17 0 1   0 0     0   1   8 11                       19 17 0 1   0 0     0   1   8 11                 19
1899704 CO     school 804530 980   HARRISON 2 80453001382 7882 SIERRA HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 38 49 107   1 8     2   14   122 97                       219 38 49 107   1 8     2   14   122 97                 219
1936957 CO     school 804530 980   HARRISON 2 80453006425 469 ATLAS PREPARATORY HIGH SCHOOL   Regular School Yes High 09 12 2019   grade_9 11 12 116   0 1     1   4   86 59                       145 11 12 116   0 1     1   4   86 59                 145
1936991 CO     school 804530 980   HARRISON 2 80453000667 3806 HARRISON HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 70 44 157   5 11     4   14   166 139                       305 70 44 157   5 11     4   14   166 139                 305
1937000 CO     school 804530 980   HARRISON 2 80453001781 4378 JAMES IRWIN CHARTER HIGH SCHOOL   Regular School Yes High 09 12 2019   grade_9 41 13 59   3 10     1   3   66 64                       130 41 13 59   3 10     1   3   66 64                 130
1937024 CO     school 804530 980   HARRISON 2 80453006663 5763 MOUNTAIN VISTA HOMESCHOOL ACADEMY   Regular School No Other KG 12 2019   grade_9 13 0 4   0 0     0   0   7 10                       17 13 0 4   0 0     0   0   7 10                 17
1937079 CO     school 804530 980   HARRISON 2 80453001382 7882 SIERRA HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 41 48 103   3 6     3   11   120 95                       215 41 48 103   3 6     3   11   120 95                 215
713659 CO     school 802730 970   CALHAN RJ-1 80273000168 1218 CALHAN HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 35 3 5   0 0     0   0   20 23                       43 35 3 5   0 0     0   0   20 23                 43
841276 CO     school 802730 970   CALHAN RJ-1 80273000168 1218 CALHAN HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 28 5 1   0 0     0   0   19 15                       34 28 5 1   0 0     0   0   19 15                 34
1138893 CO     school 802730 970   CALHAN RJ-1 80273000168 1218 CALHAN HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 50.0 1.0 5.0   0.0 0.0     0.0   1.0   23.0 34.0                       57.0 50 1 5   0 0     0   1   23 34                 57
1744146 CO     school 802730 970   Calhan RJ-1 80273000168 1218 Calhan Secondary School   Regular School No High 06 12 2021   grade_9 30 3 6   1 1     0   0   19 22                       41 30 3 6   1 1     0   0   19 22                 41
1805230 CO     school 802730 970   Calhan RJ-1 80273000168 1218 Calhan Secondary School   Regular School No High 06 12 2020   grade_9 24 8 4   0 1     0   1   23 15                       38 24 8 4   0 1     0   1   23 15                 38
1899572 CO     school 802730 970   CALHAN RJ-1 80273000168 1218 CALHAN HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 37 2 3   2 0     0   1   21 24                       45 37 2 3   2 0     0   1   21 24                 45
1936947 CO     school 802730 970   CALHAN RJ-1 80273000168 1218 CALHAN HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 27 2 4   0 0     0   1   17 17                       34 27 2 4   0 0     0   1   17 17                 34
1744130 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2021   grade_9 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1805213 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2020   grade_9 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
1936930 CO     school 801980 960   AGATE 300 80198000021 48 AGATE JUNIOR SENIOR HIGH SCHOOL   Regular School No High 06 12 2019   grade_9 5 0 0   0 0     0   0   0 5                       5 5 0 0   0 0     0   0   0 5                 5
713637 CO     school 803690 950   ELBERT 200 80369000481 2574 ELBERT JUNIOR-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_9 12 0 0   0 1     0   0   8 5                       13 12 0 0   0 1     0   0   8 5                 13
841256 CO     school 803690 950   ELBERT 200 80369000481 2574 ELBERT JUNIOR-SENIOR HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_9 17 0 2   1 0     0   1   7 14                       21 17 0 2   1 0     0   1   7 14                 21
1138870 CO     school 803690 950   ELBERT 200 80369000481 2574 ELBERT JUNIOR-SENIOR HIGH SCHOOL   Regular School No 4.0 06 12 2015   grade_9 10.0 0.0 1.0   0.0 0.0     0.0   1.0   8.0 4.0                       12.0 10 0 1   0 0     0   1   8 4                 12
1744115 CO     school 803690 950   Elbert 200 80369000481 2574 Elbert Junior-Senior High School   Regular School No High 06 12 2021   grade_9 21 0 2   0 0     0   2   13 12                       25 21 0 2   0 0     0   2   13 12                 25
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
1899550 CO     school 803690 950   ELBERT 200 80369000481 2574 ELBERT JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 06 12 2018   grade_9 28 0 1   1 0     1   0   20 11                       31 28 0 1   1 0     1   0   20 11                 31
1936916 CO     school 803690 950   ELBERT 200 80369000481 2574 ELBERT JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 06 12 2019   grade_9 22 0 0   0 0     0   0   11 11                       22 22 0 0   0 0     0   0   11 11                 22
713621 CO     school 806600 940   BIG SANDY 100J 80660001139 7922 SIMLA HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 22 0 1   0 0     0   1   19 5                       24 22 0 1   0 0     0   1   19 5                 24
841240 CO     school 806600 940   BIG SANDY 100J 80660001139 7922 SIMLA HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 16 0 1   1 0     0   2   8 12                       20 16 0 1   1 0     0   2   8 12                 20
1138854 CO     school 806600 940   BIG SANDY 100J 80660001139 7922 SIMLA HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 16.0 1.0 2.0   0.0 0.0     0.0   0.0   8.0 11.0                       19.0 16 1 2   0 0     0   0   8 11                 19
1744099 CO     school 806600 940   Big Sandy 100J 80660001139 7922 Simla High School   Regular School No High 09 12 2021   grade_9 17 0 4   0 0     0   2   14 9                       23 17 0 4   0 0     0   2   14 9                 23
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
1899534 CO     school 806600 940   BIG SANDY 100J 80660001139 7922 SIMLA HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 19 0 2   1 0     0   0   12 10                       22 19 0 2   1 0     0   0   12 10                 22
1936900 CO     school 806600 940   BIG SANDY 100J 80660001139 7922 SIMLA HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 24 0 3   0 0     0   0   14 13                       27 24 0 3   0 0     0   0   14 13                 27
713604 CO     school 805010 930   KIOWA C-2 80501000825 4728 KIOWA HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 13 0 6   0 0     0   0   8 11                       19 13 0 6   0 0     0   0   8 11                 19
841223 CO     school 805010 930   KIOWA C-2 80501000825 4728 KIOWA HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 23 0 4   0 0     0   0   16 11                       27 23 0 4   0 0     0   0   16 11                 27
1138837 CO     school 805010 930   KIOWA C-2 80501000825 4728 KIOWA HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 15.0 0.0 0.0   0.0 0.0     0.0   0.0   9.0 6.0                       15.0 15 0 0   0 0     0   0   9 6                 15
1744082 CO     school 805010 930   Kiowa C-2 80501000825 4728 Kiowa High School   Regular School No High 09 12 2021   grade_9 18 0 2   2 0     0   0   8 14                       22 18 0 2   2 0     0   0   8 14                 22
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
1899517 CO     school 805010 930   KIOWA C-2 80501000825 4728 KIOWA HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 14 0 6   0 0     0   1   13 8                       21 14 0 6   0 0     0   1   13 8                 21
1936883 CO     school 805010 930   KIOWA C-2 80501000825 4728 KIOWA HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 15 0 0   0 0     0   0   6 9                       15 15 0 0   0 0     0   0   6 9                 15
713564 CO     school 803720 920   ELIZABETH C-1 80372000483 2608 ELIZABETH HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 159 0 15   0 2     0   4   83 97                       180 159 0 15   0 2     0   4   83 97                 180
713569 CO     school 803720 920   ELIZABETH C-1 80372001775 3236 FRONTIER HIGH SCHOOL   Alternative School No High 09 12 2017   grade_9 5 0 1   0 0     0   2   5 3                       8 5 0 1   0 0     0   2   5 3                 8
841183 CO     school 803720 920   ELIZABETH C-1 80372000483 2608 ELIZABETH HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 171 1 20   1 0     1   4   80 118                       198 171 1 20   1 0     1   4   80 118                 198
841188 CO     school 803720 920   ELIZABETH C-1 80372001775 3236 FRONTIER HIGH SCHOOL   Alternative Education School No 3.0 09 12 2016   grade_9 19 0 0   0 0     0   0   17 2                       19 19 0 0   0 0     0   0   17 2                 19
1138797 CO     school 803720 920   ELIZABETH C-1 80372000483 2608 ELIZABETH HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 148.0 1.0 14.0   2.0 0.0     0.0   2.0   80.0 87.0                       167.0 148 1 14   2 0     0   2   80 87                 167
1138802 CO     school 803720 920   ELIZABETH C-1 80372001775 3236 FRONTIER HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_9 10.0 0.0 1.0   0.0 0.0     0.0   0.0   5.0 6.0                       11.0 10 0 1   0 0     0   0   5 6                 11
1744047 CO     school 803720 920   Elizabeth School District 80372000483 2608 Elizabeth High School   Regular School No High 09 12 2021   grade_9 147 0 18   1 1     0   1   98 70                       168 147 0 18   1 1     0   1   98 70                 168
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
1899477 CO     school 803720 920   ELIZABETH C-1 80372000483 2608 ELIZABETH HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 140 0 12   0 2     0   2   79 77                       156 140 0 12   0 2     0   2   79 77                 156
1899482 CO     school 803720 920   ELIZABETH C-1 80372001775 3236 FRONTIER HIGH SCHOOL   Alternative School No High 09 12 2018   grade_9 5 1 1   0 0     0   0   5 2                       7 5 1 1   0 0     0   0   5 2                 7

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