Data source: Big Local News · About: Big Local

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

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
707824 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2017   grade_9 34 1 94   0 1     0   3   69 64                       133 34 1 94   0 1     0   3   69 64                 133
707829 CO     school 805550 10   MAPLETON 1 80555001858 212 MAPLETON EARLY COLLEGE HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 14 2 39   1 3     1   0   31 29                       60 14 2 39   1 3     1   0   31 29                 60
707834 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No High 09 12 2017   grade_9 4 0 65   0 1     0   0   37 33                       70 4 0 65   0 1     0   0   37 33                 70
707839 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 10 6 106   2 1     0   4   80 49                       129 10 6 106   2 1     0   4   80 49                 129
707874 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_9 7 1 78   0 2     0   3   45 46                       91 7 1 78   0 2     0   3   45 46                 91
707926 CO     school 805550 10   MAPLETON 1 80555006671 695 BIG PICTURE COLLEGE AND CAREER ACADEMY   Regular School No Other 09 10 2017   grade_9 8 0 42   0 1     0   5   20 36                       56 8 0 42   0 1     0   5   20 36                 56
707939 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_9 223 11 77   4 4     3   22   167 177                       344 223 11 77   4 4     3   22   167 177                 344
835494 CO     school   10   MAPLETON 1   187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS             2016   grade_9 34 2 82   1 2     1   5   79 48                       127 34 2 82   1 2     1   5   79 48                 127
835499 CO     school   10   MAPLETON 1   212 MAPLETON EARLY COLLEGE HIGH SCHOOL             2016   grade_9 16 1 62   1 0     0   6   43 43                       86 16 1 62   1 0     0   6   43 43                 86
835512 CO     school   10   MAPLETON 1   263 GLOBAL LEADERSHIP ACADEMY             2016   grade_9 10 1 69   0 0     0   0   48 32                       80 10 1 69   0 0     0   0   48 32                 80
835519 CO     school   10   MAPLETON 1   309 ACADEMY HIGH SCHOOL             2016   grade_9 14 1 100   3 1     0   2   73 48                       121 14 1 100   3 1     0   2   73 48                 121
835554 CO     school   10   MAPLETON 1   503 YORK INTERNATIONAL             2016   grade_9 11 1 68   0 2     0   1   46 37                       83 11 1 68   0 2     0   1   46 37                 83
835616 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No 4.0 KG 12 2016   grade_9 220 11 95   3 5     0   23   161 196                       357 220 11 95   3 5     0   23   161 196                 357
1133217 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No 3.0 07 12 2015   grade_9 23.0 8.0 82.0   1.0 0.0     1.0   3.0   43.0 75.0                       118.0 23 8 82   1 0     1   3   43 75                 118
1133222 CO     school 805550 10   MAPLETON 1 80555001858 212 MAPLETON EARLY COLLEGE HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 15.0 1.0 48.0   0.0 0.0     0.0   2.0   38.0 28.0                       66.0 15 1 48   0 0     0   2   38 28                 66
1133235 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No 4.0 PK 12 2015   grade_9 4.0 2.0 57.0   1.0 2.0     0.0   0.0   38.0 28.0                       66.0 4 2 57   1 2     0   0   38 28                 66
1133242 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 25.0 3.0 87.0   0.0 1.0     0.0   1.0   63.0 54.0                       117.0 25 3 87   0 1     0   1   63 54                 117
1133277 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No 4.0 KG 12 2015   grade_9 12.0 2.0 55.0   0.0 0.0     0.0   1.0   26.0 44.0                       70.0 12 2 55   0 0     0   1   26 44                 70
1133339 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No 4.0 KG 12 2015   grade_9 232.0 6.0 88.0   3.0 4.0     1.0   20.0   164.0 190.0                       354.0 232 6 88   3 4     1   20   164 190                 354
1738267 CO     school 805550 10   Mapleton 1 80555001857 187 Mapleton Expeditionary School of the Arts   Regular School No High 07 12 2021   grade_9 15 3 93   2 2     1   3   68 51                       119 15 3 93   2 2     1   3   68 51                 119
1738272 CO     school 805550 10   Mapleton 1 80555001858 212 Mapleton Early College High School   Regular School No High 09 12 2021   grade_9 8 2 62   1 3     0   0   35 41                       76 8 2 62   1 3     0   0   35 41                 76
1738277 CO     school 805550 10   Mapleton 1 80555001860 263 Global Leadership Academy   Regular School No High 09 12 2021   grade_9 8 1 78   0 0     0   0   48 39                       87 8 1 78   0 0     0   0   48 39                 87
1738282 CO     school 805550 10   Mapleton 1 80555001872 309 Academy High School   Regular School No High 09 12 2021   grade_9 13 4 109   0 6     2   3   83 54                       137 13 4 109   0 6     2   3   83 54                 137
1738305 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2021   grade_9 14 1 78   0 1     0   3   48 49                       97 14 1 78   0 1     0   3   48 49                 97
1738359 CO     school 805550 10   Mapleton 1 80555006671 695 Big Picture College and Career Academy   Regular School No High 09 12 2021   grade_9 5 0 14   0 0     0   0   10 9                       19 5 0 14   0 0     0   0   10 9                 19
1738372 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_9 186 10 67   0 2     0   11   119 157                       276 186 10 67   0 2     0   11   119 157                 276
1799313 CO     school 805550 10   Mapleton 1 80555001857 187 Mapleton Expeditionary School of the Arts   Regular School No High 07 12 2020   grade_9 24 4 108   3 2     0   5   74 72                       146 24 4 108   3 2     0   5   74 72                 146
1799318 CO     school 805550 10   Mapleton 1 80555001858 212 Mapleton Early College High School   Regular School No High 09 12 2020   grade_9 7 0 64   1 2     0   1   26 49                       75 7 0 64   1 2     0   1   26 49                 75
1799323 CO     school 805550 10   Mapleton 1 80555001860 263 Global Leadership Academy   Regular School No High 09 12 2020   grade_9 3 1 84   0 2     0   1   46 45                       91 3 1 84   0 2     0   1   46 45                 91
1799328 CO     school 805550 10   Mapleton 1 80555001872 309 Academy High School   Regular School No High 09 12 2020   grade_9 11 2 118   0 2     0   4   88 49                       137 11 2 118   0 2     0   4   88 49                 137
1799362 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_9 5 2 69   1 5     0   0   42 40                       82 5 2 69   1 5     0   0   42 40                 82
1799416 CO     school 805550 10   Mapleton 1 80555006671 695 Big Picture College and Career Academy   Regular School No High 09 12 2020   grade_9 8 0 23   0 0     0   1   17 15                       32 8 0 23   0 0     0   1   17 15                 32
1799429 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2020   grade_9 202 10 78   4 2     2   14   156 156                       312 202 10 78   4 2     2   14   156 156                 312
1893687 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2018   grade_9 30 2 93   3 1     0   3   50 82                       132 30 2 93   3 1     0   3   50 82                 132
1893692 CO     school 805550 10   MAPLETON 1 80555001858 212 MAPLETON EARLY COLLEGE HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 8 0 50   1 3     0   0   28 34                       62 8 0 50   1 3     0   0   28 34                 62
1893697 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No High 09 12 2018   grade_9 6 2 66   0 1     0   0   36 39                       75 6 2 66   0 1     0   0   36 39                 75
1893702 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 8 4 106   0 3     0   3   61 63                       124 8 4 106   0 3     0   3   61 63                 124
1893737 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2018   grade_9 3 2 59   0 2     0   5   37 34                       71 3 2 59   0 2     0   5   37 34                 71
1893790 CO     school 805550 10   MAPLETON 1 80555006671 695 BIG PICTURE COLLEGE AND CAREER ACADEMY   Regular School No Secondary 09 11 2018   grade_9 5 0 49   1 0     0   3   30 28                       58 5 0 49   1 0     0   3   30 28                 58
1893803 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2018   grade_9 228 11 85   2 5     2   24   178 179                       357 228 11 85   2 5     2   24   178 179                 357
1930960 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2019   grade_9 24 2 88   4 1     0   3   65 57                       122 24 2 88   4 1     0   3   65 57                 122
1930965 CO     school 805550 10   MAPLETON 1 80555001858 212 MAPLETON EARLY COLLEGE HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 15 0 47   0 1     0   2   25 40                       65 15 0 47   0 1     0   2   25 40                 65
1930970 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No High 09 12 2019   grade_9 5 0 77   0 0     0   0   49 33                       82 5 0 77   0 0     0   0   49 33                 82
1930975 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 14 0 98   0 0     0   4   60 56                       116 14 0 98   0 0     0   4   60 56                 116
1931009 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_9 6 1 67   0 2     0   0   31 45                       76 6 1 67   0 2     0   0   31 45                 76
1931063 CO     school 805550 10   MAPLETON 1 80555006671 695 BIG PICTURE COLLEGE AND CAREER ACADEMY   Regular School No High 09 12 2019   grade_9 12 1 34   1 1     0   4   24 29                       53 12 1 34   1 1     0   4   24 29                 53
1931076 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2019   grade_9 239 12 93   4 5     1   17   172 199                       371 239 12 93   4 5     1   17   172 199                 371
708790 CO     school 802070 100   ALAMOSA RE-11J 80207000027 118 ALAMOSA HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 58 4 112   2 2     1   4   88 95                       183 58 4 112   2 2     1   4   88 95                 183
708798 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No Other 06 12 2017   grade_9 1 1 18   0 0     0   0   14 6                       20 1 1 18   0 0     0   0   14 6                 20
836437 CO     school   100   ALAMOSA RE-11J   118 ALAMOSA HIGH SCHOOL             2016   grade_9 66 1 116   1 2     2   3   96 95                       191 66 1 116   1 2     2   3   96 95                 191
836444 CO     school   100   ALAMOSA RE-11J   368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE             2016   grade_9 2 1 11   0 0     0   0   10 4                       14 2 1 11   0 0     0   0   10 4                 14
1134162 CO     school 802070 100   ALAMOSA RE-11J 80207000027 118 ALAMOSA HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 52.0 1.0 115.0   2.0 2.0     0.0   1.0   90.0 83.0                       173.0 52 1 115   2 2     0   1   90 83                 173
1134169 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative Education School No 4.0 06 12 2015   grade_9 0.0 0.0 12.0   0.0 0.0     0.0   0.0   5.0 7.0                       12.0 0 0 12   0 0     0   0   5 7                 12
1739238 CO     school 802070 100   Alamosa RE-11J 80207000027 118 Alamosa High School   Regular School No High 09 12 2021   grade_9 43 0 78   0 2     2   3   69 59                       128 43 0 78   0 2     2   3   69 59                 128
1739251 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_9 16 1 45   3 1     0   1   34 33                       67 16 1 45   3 1     0   1   34 33                 67
1800298 CO     school 802070 100   Alamosa RE-11J 80207000027 118 Alamosa High School   Regular School No High 09 12 2020   grade_9 64 0 122   3 3     0   1   97 96                       193 64 0 122   3 3     0   1   97 96                 193
1800306 CO     school 802070 100   Alamosa RE-11J 80207006508 368 Alamosa Ombudsman School of Excellence   Alternative School No High 06 12 2020   grade_9 4 0 10   0 0     0   0   10 4                       14 4 0 10   0 0     0   0   10 4                 14
1894678 CO     school 802070 100   ALAMOSA RE-11J 80207000027 118 ALAMOSA HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 44 2 117   6 2     0   5   100 76                       176 44 2 117   6 2     0   5   100 76                 176
1894686 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2018   grade_9 2 3 21   0 0     0   1   17 10                       27 2 3 21   0 0     0   1   17 10                 27
1931974 CO     school 802070 100   ALAMOSA RE-11J 80207000027 118 ALAMOSA HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 63 1 120   3 3     1   4   104 91                       195 63 1 120   3 3     1   4   104 91                 195
1931982 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2019   grade_9 2 0 10   1 0     0   0   7 6                       13 2 0 10   1 0     0   0   7 6                 13
713927 CO     school 804080 1000   FOUNTAIN 8 80408000096 203 WELTE EDUCATION CENTER   Alternative School No High 09 12 2017   grade_9 3 1 1   0 0     0   0   2 3                       5 3 1 1   0 0     0   0   2 3                 5
713970 CO     school 804080 1000   FOUNTAIN 8 80408000562 3110 FOUNTAIN-FORT CARSON HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 248 70 152   3 5     11   39   285 243                       528 248 70 152   3 5     11   39   285 243                 528
841542 CO     school   1000   FOUNTAIN 8   203 WELTE EDUCATION CENTER             2016   grade_9 5 1 2   0 0     0   2   7 3                       10 5 1 2   0 0     0   2   7 3                 10
841585 CO     school 804080 1000   FOUNTAIN 8 80408000562 3110 FOUNTAIN-FORT CARSON HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 228 77 135   6 9     13   39   282 225                       507 228 77 135   6 9     13   39   282 225                 507
1139148 CO     school 804080 1000   FOUNTAIN 8 80408000096 203 WELTE EDUCATION CENTER   Alternative Education School No 4.0 06 12 2015   grade_9 6.0 3.0 1.0   0.0 1.0     0.0   0.0   7.0 4.0                       11.0 6 3 1   0 1     0   0   7 4                 11
1139191 CO     school 804080 1000   FOUNTAIN 8 80408000562 3110 FOUNTAIN-FORT CARSON HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 255.0 59.0 139.0   4.0 6.0     10.0   41.0   251.0 263.0                       514.0 255 59 139   4 6     10   41   251 263                 514
1744430 CO     school 804080 1000   Fountain 8 80408000096 203 Welte Education Center   Alternative School No High 06 12 2021   grade_9 11 0 3   0 0     0   0   9 5                       14 11 0 3   0 0     0   0   9 5                 14
1744473 CO     school 804080 1000   Fountain 8 80408000562 3110 Fountain-Fort Carson High School   Regular School No High 09 12 2021   grade_9 243 60 140   4 7     8   55   264 253                       517 243 60 140   4 7     8   55   264 253                 517
1805510 CO     school 804080 1000   Fountain 8 80408000096 203 Welte Education Center   Alternative School No High 06 12 2020   grade_9 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
1805552 CO     school 804080 1000   Fountain 8 80408000562 3110 Fountain-Fort Carson High School   Regular School No High 09 12 2020   grade_9 244 65 167   6 5     16   58   287 274                       561 244 65 167   6 5     16   58   287 274                 561
1899839 CO     school 804080 1000   FOUNTAIN 8 80408000096 203 WELTE EDUCATION CENTER   Alternative School No High 06 12 2018   grade_9 6 1 1   0 0     0   1   7 2                       9 6 1 1   0 0     0   1   7 2                 9
1899882 CO     school 804080 1000   FOUNTAIN 8 80408000562 3110 FOUNTAIN-FORT CARSON HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 242 71 110   6 9     18   46   247 255                       502 242 71 110   6 9     18   46   247 255                 502
1937216 CO     school 804080 1000   FOUNTAIN 8 80408000096 203 WELTE EDUCATION CENTER   Alternative School No High 06 12 2019   grade_9 6 0 8   0 0     0   0   5 9                       14 6 0 8   0 0     0   0   5 9                 14
1937259 CO     school 804080 1000   FOUNTAIN 8 80408000562 3110 FOUNTAIN-FORT CARSON HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 211 50 131   8 4     8   37   232 217                       449 211 50 131   8 4     8   37   232 217                 449
714007 CO     school 803060 1010   COLORADO SPRINGS 11 80306006428 269 ACHIEVE ONLINE   Regular School No Other 06 12 2017   grade_9 17 3 9   0 0     0   1   11 19                       30 17 3 9   0 0     0   1   11 19                 30
714031 CO     school 803060 1010   COLORADO SPRINGS 11 80306001888 871 THE BIJOU SCHOOL   Alternative School No High 09 12 2017   grade_9 5 1 4   0 0     0   3   10 3                       13 5 1 4   0 0     0   3   10 3                 13
714067 CO     school 803060 1010   COLORADO SPRINGS 11 80306001589 1616 CIVA CHARTER ACADEMY   Regular School Yes High 09 12 2017   grade_9 26 1 7   0 1     0   2   15 22                       37 26 1 7   0 1     0   2   15 22                 37
714088 CO     school 803060 1010   COLORADO SPRINGS 11 80306000228 1870 CORONADO HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 248 18 113   3 4     2   30   224 194                       418 248 18 113   3 4     2   30   224 194                 418
714093 CO     school 803060 1010   COLORADO SPRINGS 11 80306001299 1885 COMMUNITY PREP CHARTER SCHOOL   Alternative School Yes High 09 12 2017   grade_9 3 0 0   0 0     0   0   3 0                       3 3 0 0   0 0     0   0   3 0                 3
714098 CO     school 803060 1010   COLORADO SPRINGS 11 80306000268 2202 DOHERTY HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 327 45 164   3 14     3   49   313 292                       605 327 45 164   3 14     3   49   313 292                 605
714103 CO     school 803060 1010   COLORADO SPRINGS 11 80306006580 2400 EARLY COLLEGE HIGH SCHOOL   Alternative School No High 09 12 2017   grade_9 19 3 18   0 0     0   8   20 28                       48 19 3 18   0 0     0   8   20 28                 48
714118 CO     school 803060 1010   COLORADO SPRINGS 11 80306000232 2528 NIKOLA TESLA EDUCATION OPPORTUNITY CENTER   Alternative School No Other 06 12 2017   grade_9 7 2 5   0 0     0   0   7 7                       14 7 2 5   0 0     0   0   7 7                 14
714209 CO     school 803060 1010   COLORADO SPRINGS 11 80306001841 5146 LIFE SKILLS CENTER OF COLORADO SPRINGS   Alternative School Yes High 09 12 2017   grade_9 0 1 0   0 0     0   0   1 0                       1 0 1 0   0 0     0   0   1 0                 1
714254 CO     school 803060 1010   COLORADO SPRINGS 11 80306000254 5948 MITCHELL HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 105 39 144   6 6     1   22   160 163                       323 105 39 144   6 6     1   22   160 163                 323
714271 CO     school 803060 1010   COLORADO SPRINGS 11 80306000257 6680 PALMER HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 214 37 182   1 7     4   36   239 242                       481 214 37 182   1 7     4   36   239 242                 481
841622 CO     school   1010   COLORADO SPRINGS 11   269 ACHIEVE ONLINE             2016   grade_9 15 3 9   0 0     0   1   18 10                       28 15 3 9   0 0     0   1   18 10                 28
841646 CO     school   1010   COLORADO SPRINGS 11   871 THE BIJOU SCHOOL             2016   grade_9 5 2 2   0 0     0   0   3 6                       9 5 2 2   0 0     0   0   3 6                 9
841682 CO     school 803060 1010   COLORADO SPRINGS 11 80306001589 1616 CIVA CHARTER ACADEMY   Regular School Yes 3.0 09 12 2016   grade_9 32 3 4   0 0     0   2   16 25                       41 32 3 4   0 0     0   2   16 25                 41
841703 CO     school 803060 1010   COLORADO SPRINGS 11 80306000228 1870 CORONADO HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 236 17 111   1 9     0   20   197 197                       394 236 17 111   1 9     0   20   197 197                 394
841708 CO     school 803060 1010   COLORADO SPRINGS 11 80306001299 1885 COMMUNITY PREP CHARTER SCHOOL   Alternative Education School Yes 3.0 09 12 2016   grade_9 4 0 6   0 0     0   0   4 6                       10 4 0 6   0 0     0   0   4 6                 10
841713 CO     school 803060 1010   COLORADO SPRINGS 11 80306000268 2202 DOHERTY HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 319 38 131   4 17     2   56   321 246                       567 319 38 131   4 17     2   56   321 246                 567
841718 CO     school 803060 1010   COLORADO SPRINGS 11 80306006580 2400 EARLY COLLEGE HIGH SCHOOL   Alternative Education School No 3.0 09 12 2016   grade_9 9 3 9   0 0     0   0   10 11                       21 9 3 9   0 0     0   0   10 11                 21
841733 CO     school 803060 1010   COLORADO SPRINGS 11 80306000232 2528 NIKOLA TESLA EDUCATION OPPORTUNITY CENTER   Alternative Education School No 4.0 06 12 2016   grade_9 4 0 5   0 0     0   0   5 4                       9 4 0 5   0 0     0   0   5 4                 9
841824 CO     school 803060 1010   COLORADO SPRINGS 11 80306001841 5146 LIFE SKILLS CENTER OF COLORADO SPRINGS   Alternative Education School Yes 3.0 09 12 2016   grade_9 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
841871 CO     school 803060 1010   COLORADO SPRINGS 11 80306000254 5948 MITCHELL HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 133 47 143   5 5     1   21   206 149                       355 133 47 143   5 5     1   21   206 149                 355
841888 CO     school 803060 1010   COLORADO SPRINGS 11 80306000257 6680 PALMER HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 216 31 158   6 7     1   43   200 262                       462 216 31 158   6 7     1   43   200 262                 462
1139229 CO     school 803060 1010   COLORADO SPRINGS 11 80306006428 269 ACHIEVE ONLINE   Regular School No 4.0 06 12 2015   grade_9 15.0 3.0 6.0   1.0 0.0     0.0   1.0   11.0 15.0                       26.0 15 3 6   1 0     0   1   11 15                 26
1139253 CO     school 803060 1010   COLORADO SPRINGS 11 80306001888 871 THE BIJOU SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_9 5.0 0.0 3.0   0.0 0.0     0.0   4.0   8.0 4.0                       12.0 5 0 3   0 0     0   4   8 4                 12
1139289 CO     school 803060 1010   COLORADO SPRINGS 11 80306001589 1616 CIVA CHARTER ACADEMY   Regular School Yes 3.0 09 12 2015   grade_9 33.0 3.0 10.0   0.0 0.0     0.0   3.0   16.0 33.0                       49.0 33 3 10   0 0     0   3   16 33                 49

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