enrollments
Data source: Big Local News · About: Big Local
487 rows where grade = "grade_9", state = "CO" and year = 2017 sorted by school
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
719355 | 719355 | CO | school | 806150 | 2700 | PUEBLO COUNTY 70 | 80615006496 | 5990 | 70 ONLINE | Regular School | No | Other | KG | 12 | 2017 | grade_9 | 5 | 0 | 3 | 0 | 0 | 0 | 1 | 5 | 4 | 9 | 5 | 0 | 3 | 0 | 0 | 0 | 1 | 5 | 4 | 9 | ||||||||||||||||||||||||||||||||||
711330 | 711330 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336000305 | 10 | ABRAHAM LINCOLN HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 11 | 10 | 276 | 3 | 6 | 0 | 2 | 182 | 126 | 308 | 11 | 10 | 276 | 3 | 6 | 0 | 2 | 182 | 126 | 308 | ||||||||||||||||||||||||||||||||||
707839 | 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 | ||||||||||||||||||||||||||||||||||
720631 | 720631 | CO | school | 800020 | 8001 | CHARTER SCHOOL INSTITUTE | 80002000727 | 15 | ACADEMY OF CHARTER SCHOOLS | Regular School | Yes | Other | PK | 12 | 2017 | grade_9 | 66 | 1 | 60 | 0 | 13 | 0 | 2 | 71 | 71 | 142 | 66 | 1 | 60 | 0 | 13 | 0 | 2 | 71 | 71 | 142 | ||||||||||||||||||||||||||||||||||
711340 | 711340 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001894 | 67 | ACADEMY OF URBAN LEARNING | Regular School | Yes | High | 09 | 12 | 2017 | grade_9 | 0 | 0 | 24 | 1 | 0 | 0 | 0 | 16 | 9 | 25 | 0 | 0 | 24 | 1 | 0 | 0 | 0 | 16 | 9 | 25 | ||||||||||||||||||||||||||||||||||
714500 | 714500 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192006434 | 110 | ACADEMY ONLINE | Regular School | No | Other | KG | 12 | 2017 | grade_9 | 23 | 2 | 3 | 0 | 0 | 0 | 1 | 19 | 10 | 29 | 23 | 2 | 3 | 0 | 0 | 0 | 1 | 19 | 10 | 29 | ||||||||||||||||||||||||||||||||||
711532 | 711532 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001764 | 1866 | ACE COMMUNITY CHALLENGE SCHOOL | Alternative School | Yes | Other | 08 | 10 | 2017 | grade_9 | 0 | 2 | 42 | 2 | 0 | 0 | 1 | 29 | 18 | 47 | 0 | 2 | 42 | 2 | 0 | 0 | 1 | 29 | 18 | 47 | ||||||||||||||||||||||||||||||||||
711208 | 711208 | CO | school | 803330 | 870 | DELTA COUNTY 50(J) | 80333006681 | 93 | ACHIEVE BLENDED LEARNING ACADEMY | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||
714007 | 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 | ||||||||||||||||||||||||||||||||||
708363 | 708363 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195000010 | 24 | ADAMS CITY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 60 | 11 | 456 | 2 | 3 | 0 | 6 | 262 | 276 | 538 | 60 | 11 | 456 | 2 | 3 | 0 | 6 | 262 | 276 | 538 | ||||||||||||||||||||||||||||||||||
715662 | 715662 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480006587 | 1451 | ADDENBROOKE CLASSICAL ACADEMY | Regular School | Yes | Other | 06 | 12 | 2017 | grade_9 | 18 | 0 | 10 | 0 | 0 | 0 | 0 | 10 | 18 | 28 | 18 | 0 | 10 | 0 | 0 | 0 | 0 | 10 | 18 | 28 | ||||||||||||||||||||||||||||||||||
717818 | 717818 | CO | school | 802010 | 1620 | AGUILAR REORGANIZED 6 | 80201000023 | 66 | AGUILAR JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2017 | grade_9 | 3 | 0 | 5 | 0 | 0 | 0 | 0 | 6 | 2 | 8 | 3 | 0 | 5 | 0 | 0 | 0 | 0 | 6 | 2 | 8 | ||||||||||||||||||||||||||||||||||
710111 | 710111 | CO | school | 805250 | 290 | LAS ANIMAS RE-1 | 80525006678 | 443 | AIM GLOBAL | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 6 | 1 | 27 | 1 | 0 | 0 | 0 | 18 | 17 | 35 | 6 | 1 | 27 | 1 | 0 | 0 | 0 | 18 | 17 | 35 | ||||||||||||||||||||||||||||||||||
714495 | 714495 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192000002 | 76 | AIR ACADEMY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 248 | 7 | 39 | 1 | 14 | 1 | 19 | 158 | 171 | 329 | 248 | 7 | 39 | 1 | 14 | 1 | 19 | 158 | 171 | 329 | ||||||||||||||||||||||||||||||||||
719922 | 719922 | CO | school | 802040 | 3030 | AKRON R-1 | 80204000025 | 90 | AKRON HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 12 | 0 | 2 | 0 | 0 | 0 | 1 | 7 | 8 | 15 | 12 | 0 | 2 | 0 | 0 | 0 | 1 | 7 | 8 | 15 | ||||||||||||||||||||||||||||||||||
715541 | 715541 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000691 | 108 | ALAMEDA INTERNATIONAL JUNIOR/SENIOR HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2017 | grade_9 | 26 | 4 | 160 | 3 | 3 | 0 | 3 | 114 | 85 | 199 | 26 | 4 | 160 | 3 | 3 | 0 | 3 | 114 | 85 | 199 | ||||||||||||||||||||||||||||||||||
708790 | 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 | 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 | ||||||||||||||||||||||||||||||||||
720648 | 720648 | CO | school | 800020 | 8001 | CHARTER SCHOOL INSTITUTE | 80002006418 | 75 | ANIMAS HIGH SCHOOL | Regular School | Yes | High | 09 | 12 | 2017 | grade_9 | 61 | 0 | 9 | 3 | 0 | 0 | 2 | 34 | 41 | 75 | 61 | 0 | 9 | 3 | 0 | 0 | 2 | 34 | 41 | 75 | ||||||||||||||||||||||||||||||||||
711139 | 711139 | CO | school | 802130 | 580 | SOUTH CONEJOS RE-10 | 80213000035 | 252 | ANTONITO HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 5 | 10 | 15 | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 5 | 10 | 15 | ||||||||||||||||||||||||||||||||||
710193 | 710193 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537006539 | 120 | APEX HOME SCHOOL ENRICHMENT PROGRAM | Regular School | No | Other | KG | 12 | 2017 | grade_9 | 32 | 0 | 3 | 0 | 0 | 0 | 3 | 16 | 22 | 38 | 32 | 0 | 3 | 0 | 0 | 0 | 3 | 16 | 22 | 38 | ||||||||||||||||||||||||||||||||||
709518 | 709518 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006476 | 219 | APS ONLINE SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 3 | 2 | 8 | 0 | 0 | 0 | 1 | 4 | 10 | 14 | 3 | 2 | 8 | 0 | 0 | 0 | 1 | 4 | 10 | 14 | ||||||||||||||||||||||||||||||||||
709321 | 709321 | CO | school | 805310 | 140 | LITTLETON 6 | 80531000873 | 298 | ARAPAHOE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 479 | 7 | 50 | 3 | 18 | 1 | 33 | 279 | 312 | 591 | 479 | 7 | 50 | 3 | 18 | 1 | 33 | 279 | 312 | 591 | ||||||||||||||||||||||||||||||||||
710555 | 710555 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001219 | 125 | ARAPAHOE RIDGE HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2017 | grade_9 | 1 | 0 | 6 | 0 | 1 | 0 | 0 | 4 | 4 | 8 | 1 | 0 | 6 | 0 | 1 | 0 | 0 | 4 | 4 | 8 | ||||||||||||||||||||||||||||||||||
719938 | 719938 | CO | school | 802220 | 3040 | ARICKAREE R-2 | 80222000042 | 308 | ARICKAREE UNDIVIDED HIGH SCHOOL | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 9 | 0 | 2 | 0 | 0 | 0 | 0 | 8 | 3 | 11 | 9 | 0 | 2 | 0 | 0 | 0 | 0 | 8 | 3 | 11 | ||||||||||||||||||||||||||||||||||
715565 | 715565 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000694 | 370 | ARVADA HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 73 | 3 | 79 | 0 | 5 | 0 | 7 | 93 | 74 | 167 | 73 | 3 | 79 | 0 | 5 | 0 | 7 | 93 | 74 | 167 | ||||||||||||||||||||||||||||||||||
715570 | 715570 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000695 | 378 | ARVADA WEST HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 343 | 5 | 74 | 2 | 13 | 1 | 15 | 239 | 214 | 453 | 343 | 5 | 74 | 2 | 13 | 1 | 15 | 239 | 214 | 453 | ||||||||||||||||||||||||||||||||||
718994 | 718994 | CO | school | 802280 | 2640 | ASPEN 1 | 80228000047 | 432 | ASPEN HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 131 | 1 | 19 | 0 | 3 | 0 | 0 | 82 | 72 | 154 | 131 | 1 | 19 | 0 | 3 | 0 | 0 | 82 | 72 | 154 | ||||||||||||||||||||||||||||||||||
714507 | 714507 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192000858 | 209 | ASPEN VALLEY CAMPUS | Alternative School | No | High | 07 | 12 | 2017 | grade_9 | 21 | 0 | 1 | 1 | 1 | 0 | 0 | 17 | 7 | 24 | 21 | 0 | 1 | 1 | 1 | 0 | 0 | 17 | 7 | 24 | ||||||||||||||||||||||||||||||||||
713669 | 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 | ||||||||||||||||||||||||||||||||||
709567 | 709567 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000056 | 1458 | AURORA CENTRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 19 | 100 | 347 | 4 | 55 | 4 | 21 | 279 | 271 | 550 | 19 | 100 | 347 | 4 | 55 | 4 | 21 | 279 | 271 | 550 | ||||||||||||||||||||||||||||||||||
709932 | 709932 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000082 | 9396 | AURORA WEST COLLEGE PREPARATORY ACADEMY | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 5 | 10 | 67 | 0 | 20 | 0 | 2 | 53 | 51 | 104 | 5 | 10 | 67 | 0 | 20 | 0 | 2 | 53 | 51 | 104 | ||||||||||||||||||||||||||||||||||
715205 | 715205 | CO | school | 804260 | 1180 | ROARING FORK RE-1 | 80426000584 | 570 | BASALT HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 54 | 0 | 70 | 1 | 0 | 0 | 1 | 65 | 61 | 126 | 54 | 0 | 70 | 1 | 0 | 0 | 1 | 65 | 61 | 126 | ||||||||||||||||||||||||||||||||||
713446 | 713446 | CO | school | 803540 | 910 | EAGLE COUNTY RE 50 | 80354000461 | 604 | BATTLE MOUNTAIN HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 106 | 1 | 130 | 2 | 3 | 0 | 6 | 117 | 131 | 248 | 106 | 1 | 130 | 2 | 3 | 0 | 6 | 117 | 131 | 248 | ||||||||||||||||||||||||||||||||||
717048 | 717048 | CO | school | 802400 | 1530 | BAYFIELD 10 JT-R | 80240000090 | 640 | BAYFIELD HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 68 | 0 | 15 | 1 | 2 | 0 | 2 | 47 | 41 | 88 | 68 | 0 | 15 | 1 | 2 | 0 | 2 | 47 | 41 | 88 | ||||||||||||||||||||||||||||||||||
715595 | 715595 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000697 | 664 | BEAR CREEK HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 201 | 5 | 159 | 1 | 20 | 2 | 11 | 200 | 199 | 399 | 201 | 5 | 159 | 1 | 20 | 2 | 11 | 200 | 199 | 399 | ||||||||||||||||||||||||||||||||||
708623 | 708623 | CO | school | 802430 | 50 | BENNETT 29J | 80243000092 | 775 | BENNETT HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 71 | 1 | 21 | 1 | 0 | 0 | 2 | 47 | 49 | 96 | 71 | 1 | 21 | 1 | 0 | 0 | 2 | 47 | 49 | 96 | ||||||||||||||||||||||||||||||||||
717494 | 717494 | CO | school | 805400 | 1560 | THOMPSON R2-J | 80540000927 | 812 | BERTHOUD HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 149 | 0 | 17 | 1 | 2 | 0 | 3 | 83 | 89 | 172 | 149 | 0 | 17 | 1 | 2 | 0 | 3 | 83 | 89 | 172 | ||||||||||||||||||||||||||||||||||
716894 | 716894 | CO | school | 802460 | 1490 | BETHUNE R-5 | 80246000095 | 842 | BETHUNE PUBLIC SCHOOLS | Regular School | No | Other | PK | 12 | 2017 | grade_9 | 7 | 0 | 2 | 0 | 0 | 0 | 0 | 5 | 4 | 9 | 7 | 0 | 2 | 0 | 0 | 0 | 0 | 5 | 4 | 9 | ||||||||||||||||||||||||||||||||||
707926 | 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 | ||||||||||||||||||||||||||||||||||
708470 | 708470 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258006575 | 1560 | BOLT ACADEMY | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 4 | 0 | 6 | 0 | 0 | 0 | 1 | 5 | 6 | 11 | 4 | 0 | 6 | 0 | 0 | 0 | 1 | 5 | 6 | 11 | ||||||||||||||||||||||||||||||||||
710601 | 710601 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000101 | 924 | BOULDER HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 348 | 4 | 121 | 7 | 30 | 0 | 21 | 271 | 260 | 531 | 348 | 4 | 121 | 7 | 30 | 0 | 21 | 271 | 260 | 531 | ||||||||||||||||||||||||||||||||||
710617 | 710617 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001631 | 934 | BOULDER PREP CHARTER HIGH SCHOOL | Alternative School | Yes | High | 09 | 12 | 2017 | grade_9 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 4 | 5 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 4 | 5 | ||||||||||||||||||||||||||||||||||
710612 | 710612 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249006463 | 930 | BOULDER UNIVERSAL | Regular School | No | Other | KG | 12 | 2017 | grade_9 | 6 | 0 | 3 | 0 | 0 | 0 | 1 | 5 | 5 | 10 | 6 | 0 | 3 | 0 | 0 | 0 | 1 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||
717845 | 717845 | CO | school | 802520 | 1750 | BRANSON REORGANIZED 82 | 80252000141 | 978 | BRANSON SCHOOL | Regular School | No | Other | PK | 12 | 2017 | grade_9 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2 | 4 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2 | 4 | ||||||||||||||||||||||||||||||||||
717831 | 717831 | CO | school | 802520 | 1750 | BRANSON REORGANIZED 82 | 80252001728 | 948 | BRANSON SCHOOL ONLINE | Regular School | No | Other | KG | 12 | 2017 | grade_9 | 35 | 4 | 15 | 1 | 0 | 0 | 2 | 25 | 32 | 57 | 35 | 4 | 15 | 1 | 0 | 0 | 2 | 25 | 32 | 57 | ||||||||||||||||||||||||||||||||||
720521 | 720521 | CO | school | 802550 | 3146 | BRIGGSDALE RE-10 | 80255000143 | 1012 | BRIGGSDALE UNDIVIDED HIGH SCHOOL | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 19 | 0 | 2 | 0 | 0 | 0 | 1 | 11 | 11 | 22 | 19 | 0 | 2 | 0 | 0 | 0 | 1 | 11 | 11 | 22 | ||||||||||||||||||||||||||||||||||
708449 | 708449 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000729 | 1021 | BRIGHTON HERITAGE ACADEMY | Alternative School | No | Other | 06 | 12 | 2017 | grade_9 | 3 | 0 | 6 | 0 | 0 | 0 | 1 | 7 | 3 | 10 | 3 | 0 | 6 | 0 | 0 | 0 | 1 | 7 | 3 | 10 | ||||||||||||||||||||||||||||||||||
708454 | 708454 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000144 | 1022 | BRIGHTON HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 214 | 6 | 256 | 5 | 3 | 0 | 18 | 268 | 234 | 502 | 214 | 6 | 256 | 5 | 3 | 0 | 18 | 268 | 234 | 502 | ||||||||||||||||||||||||||||||||||
710626 | 710626 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000103 | 1070 | BROOMFIELD HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 301 | 5 | 88 | 1 | 11 | 1 | 15 | 212 | 210 | 422 | 301 | 5 | 88 | 1 | 11 | 1 | 15 | 212 | 210 | 422 | ||||||||||||||||||||||||||||||||||
712219 | 712219 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001869 | 6350 | BRUCE RANDOLPH SCHOOL | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 2 | 11 | 106 | 1 | 0 | 0 | 0 | 62 | 58 | 120 | 2 | 11 | 106 | 1 | 0 | 0 | 0 | 62 | 58 | 120 | ||||||||||||||||||||||||||||||||||
718659 | 718659 | CO | school | 802610 | 2395 | BRUSH RE-2(J) | 80261000154 | 1096 | BRUSH HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 67 | 0 | 61 | 0 | 1 | 0 | 0 | 66 | 63 | 129 | 67 | 0 | 61 | 0 | 1 | 0 | 0 | 66 | 63 | 129 | ||||||||||||||||||||||||||||||||||
710960 | 710960 | CO | school | 802640 | 490 | BUENA VISTA R-31 | 80264000157 | 1130 | BUENA VISTA HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 59 | 0 | 5 | 0 | 1 | 0 | 0 | 25 | 40 | 65 | 59 | 0 | 5 | 0 | 1 | 0 | 0 | 25 | 40 | 65 | ||||||||||||||||||||||||||||||||||
716913 | 716913 | CO | school | 802670 | 1500 | BURLINGTON RE-6J | 80267000162 | 1152 | BURLINGTON HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 16 | 0 | 27 | 0 | 1 | 0 | 1 | 19 | 26 | 45 | 16 | 0 | 27 | 0 | 1 | 0 | 1 | 19 | 26 | 45 | ||||||||||||||||||||||||||||||||||
709964 | 709964 | CO | school | 802700 | 190 | BYERS 32J | 80270000164 | 1176 | BYERS JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2017 | grade_9 | 31 | 0 | 6 | 0 | 1 | 0 | 1 | 18 | 21 | 39 | 31 | 0 | 6 | 0 | 1 | 0 | 1 | 18 | 21 | 39 | ||||||||||||||||||||||||||||||||||
719520 | 719520 | CO | school | 805760 | 2740 | MONTE VISTA C-8 | 80576000984 | 6030 | BYRON SYRING DELTA CENTER | Alternative School | No | High | 07 | 12 | 2017 | grade_9 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
713659 | 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 | ||||||||||||||||||||||||||||||||||
717928 | 717928 | CO | school | 806690 | 1828 | VALLEY RE-1 | 80669001147 | 1224 | CALICHE JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2017 | grade_9 | 17 | 0 | 7 | 0 | 0 | 0 | 0 | 14 | 10 | 24 | 17 | 0 | 7 | 0 | 0 | 0 | 0 | 14 | 10 | 24 | ||||||||||||||||||||||||||||||||||
710103 | 710103 | CO | school | 802760 | 270 | CAMPO RE-6 | 80276000170 | 1252 | CAMPO UNDIVIDED HIGH SCHOOL | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
715086 | 715086 | CO | school | 802790 | 1140 | CANON CITY RE-1 | 80279000172 | 1266 | CANON CITY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 215 | 2 | 40 | 2 | 2 | 0 | 5 | 121 | 145 | 266 | 215 | 2 | 40 | 2 | 2 | 0 | 5 | 121 | 145 | 266 | ||||||||||||||||||||||||||||||||||
715077 | 715077 | CO | school | 802790 | 1140 | CANON CITY RE-1 | 80279006536 | 419 | CANON ONLINE ACADEMY | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
720697 | 720697 | CO | school | 800020 | 8001 | CHARTER SCHOOL INSTITUTE | 80002006305 | 1279 | CAPROCK ACADEMY | Regular School | Yes | Other | KG | 12 | 2017 | grade_9 | 39 | 0 | 7 | 0 | 1 | 1 | 1 | 21 | 28 | 49 | 39 | 0 | 7 | 0 | 1 | 1 | 1 | 21 | 28 | 49 | ||||||||||||||||||||||||||||||||||
714737 | 714737 | CO | school | 806060 | 1060 | PEYTON 23 JT | 80606006637 | 1346 | CAREER BUILDING ACADEMY | Regular School | Yes | High | 09 | 12 | 2017 | grade_9 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
711443 | 711443 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336000322 | 1319 | CAREER EDUCATION CENTER EARLY COLLEGE | Career and Technical School | No | High | 09 | 12 | 2017 | grade_9 | 3 | 1 | 109 | 0 | 0 | 0 | 1 | 49 | 65 | 114 | 3 | 1 | 109 | 0 | 0 | 0 | 1 | 49 | 65 | 114 | ||||||||||||||||||||||||||||||||||
712801 | 712801 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345001918 | 1367 | CASTLE VIEW HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 392 | 7 | 79 | 1 | 8 | 0 | 24 | 269 | 242 | 511 | 392 | 7 | 79 | 1 | 8 | 0 | 24 | 269 | 242 | 511 | ||||||||||||||||||||||||||||||||||
711215 | 711215 | CO | school | 803330 | 870 | DELTA COUNTY 50(J) | 80333001335 | 1372 | CEDAREDGE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 55 | 0 | 7 | 0 | 0 | 0 | 5 | 31 | 36 | 67 | 55 | 0 | 7 | 0 | 0 | 0 | 5 | 31 | 36 | 67 | ||||||||||||||||||||||||||||||||||
711082 | 711082 | CO | school | 805100 | 550 | NORTH CONEJOS RE-1J | 80510000843 | 1378 | CENTAURI HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 32 | 1 | 36 | 0 | 0 | 0 | 0 | 39 | 30 | 69 | 32 | 1 | 36 | 0 | 0 | 0 | 0 | 39 | 30 | 69 | ||||||||||||||||||||||||||||||||||
710639 | 710639 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000107 | 1380 | CENTAURUS HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 200 | 4 | 111 | 2 | 9 | 0 | 10 | 195 | 141 | 336 | 200 | 4 | 111 | 2 | 9 | 0 | 10 | 195 | 141 | 336 | ||||||||||||||||||||||||||||||||||
717188 | 717188 | CO | school | 803990 | 1550 | POUDRE R-1 | 80399000517 | 3760 | CENTENNIAL HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2017 | grade_9 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 7 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 7 | 8 | ||||||||||||||||||||||||||||||||||
719128 | 719128 | CO | school | 806120 | 2690 | PUEBLO CITY 60 | 80612001035 | 1402 | CENTENNIAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 90 | 7 | 191 | 4 | 4 | 0 | 7 | 144 | 159 | 303 | 90 | 7 | 191 | 4 | 4 | 0 | 7 | 144 | 159 | 303 | ||||||||||||||||||||||||||||||||||
711152 | 711152 | CO | school | 806360 | 640 | CENTENNIAL R-1 | 80636001416 | 1398 | CENTENNIAL SCHOOL | Regular School | No | Other | PK | 12 | 2017 | grade_9 | 3 | 0 | 16 | 0 | 0 | 0 | 0 | 9 | 10 | 19 | 3 | 0 | 16 | 0 | 0 | 0 | 0 | 9 | 10 | 19 | ||||||||||||||||||||||||||||||||||
719707 | 719707 | CO | school | 802850 | 2810 | CENTER 26 JT | 80285000179 | 1420 | CENTER HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 4 | 0 | 53 | 0 | 0 | 0 | 0 | 36 | 21 | 57 | 4 | 0 | 53 | 0 | 0 | 0 | 0 | 36 | 21 | 57 | ||||||||||||||||||||||||||||||||||
718075 | 718075 | CO | school | 804350 | 2000 | MESA COUNTY VALLEY 51 | 80435000600 | 1450 | CENTRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 346 | 4 | 136 | 3 | 1 | 0 | 20 | 268 | 242 | 510 | 346 | 4 | 136 | 3 | 1 | 0 | 20 | 268 | 242 | 510 | ||||||||||||||||||||||||||||||||||
719133 | 719133 | CO | school | 806120 | 2690 | PUEBLO CITY 60 | 80612001037 | 1454 | CENTRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 50 | 6 | 210 | 4 | 0 | 0 | 5 | 138 | 137 | 275 | 50 | 6 | 210 | 4 | 0 | 0 | 5 | 138 | 137 | 275 | ||||||||||||||||||||||||||||||||||
710969 | 710969 | CO | school | 802640 | 490 | BUENA VISTA R-31 | 80264006155 | 1508 | CHAFFEE COUNTY HIGH SCHOOL | Alternative School | No | High | 07 | 12 | 2017 | grade_9 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
712806 | 712806 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345001578 | 1503 | CHAPARRAL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 416 | 7 | 75 | 3 | 24 | 0 | 24 | 289 | 260 | 549 | 416 | 7 | 75 | 3 | 24 | 0 | 24 | 289 | 260 | 549 | ||||||||||||||||||||||||||||||||||
715667 | 715667 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480001383 | 1522 | CHATFIELD HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 367 | 1 | 60 | 0 | 4 | 1 | 18 | 239 | 212 | 451 | 367 | 1 | 60 | 0 | 4 | 1 | 18 | 239 | 212 | 451 | ||||||||||||||||||||||||||||||||||
719146 | 719146 | CO | school | 806120 | 2690 | PUEBLO CITY 60 | 80612001730 | 1488 | CHAVEZ/HUERTA K-12 PREPARATORY ACADEMY | Regular School | Yes | Other | KG | 12 | 2017 | grade_9 | 8 | 0 | 55 | 0 | 0 | 0 | 0 | 27 | 36 | 63 | 8 | 0 | 55 | 0 | 0 | 0 | 0 | 27 | 36 | 63 | ||||||||||||||||||||||||||||||||||
718821 | 718821 | CO | school | 802880 | 2560 | CHERAW 31 | 80288000182 | 1546 | CHERAW SCHOOL | Regular School | No | Other | PK | 12 | 2017 | grade_9 | 4 | 0 | 5 | 0 | 1 | 0 | 0 | 6 | 4 | 10 | 4 | 0 | 5 | 0 | 1 | 0 | 0 | 6 | 4 | 10 | ||||||||||||||||||||||||||||||||||
708970 | 708970 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001951 | 1551 | CHEROKEE TRAIL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 480 | 84 | 120 | 0 | 66 | 0 | 49 | 416 | 383 | 799 | 480 | 84 | 120 | 0 | 66 | 0 | 49 | 416 | 383 | 799 | ||||||||||||||||||||||||||||||||||
708983 | 708983 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000186 | 1570 | CHERRY CREEK HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 657 | 32 | 110 | 2 | 121 | 1 | 35 | 505 | 453 | 958 | 657 | 32 | 110 | 2 | 121 | 1 | 35 | 505 | 453 | 958 | ||||||||||||||||||||||||||||||||||
714402 | 714402 | CO | school | 802940 | 1020 | CHEYENNE MOUNTAIN 12 | 80294000211 | 1590 | CHEYENNE MOUNTAIN HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 226 | 9 | 36 | 2 | 7 | 0 | 20 | 151 | 149 | 300 | 226 | 9 | 36 | 2 | 7 | 0 | 20 | 151 | 149 | 300 | ||||||||||||||||||||||||||||||||||
711038 | 711038 | CO | school | 800001 | 520 | CHEYENNE COUNTY RE-5 | 80000100215 | 1612 | CHEYENNE WELLS JUNIOR/HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2017 | grade_9 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 7 | 14 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 7 | 14 | ||||||||||||||||||||||||||||||||||
714067 | 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 | ||||||||||||||||||||||||||||||||||
711064 | 711064 | CO | school | 803000 | 540 | CLEAR CREEK RE-1 | 80300000217 | 4216 | CLEAR CREEK HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 41 | 1 | 9 | 3 | 0 | 0 | 3 | 26 | 31 | 57 | 41 | 1 | 9 | 3 | 0 | 0 | 3 | 26 | 31 | 57 | ||||||||||||||||||||||||||||||||||
712831 | 712831 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006494 | 1555 | CLOVERLEAF HOME EDUCATION | Alternative School | No | Other | KG | 12 | 2017 | grade_9 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | ||||||||||||||||||||||||||||||||||
715259 | 715259 | CO | school | 806240 | 1195 | GARFIELD RE-2 | 80624001906 | 65 | COAL RIDGE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 77 | 0 | 64 | 0 | 1 | 0 | 1 | 80 | 63 | 143 | 77 | 0 | 64 | 0 | 1 | 0 | 1 | 80 | 63 | 143 | ||||||||||||||||||||||||||||||||||
716462 | 716462 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480001036 | 7701 | COLLEGIATE ACADEMY OF COLORADO | Regular School | Yes | Other | KG | 12 | 2017 | grade_9 | 15 | 0 | 4 | 0 | 0 | 0 | 2 | 13 | 8 | 21 | 15 | 0 | 4 | 0 | 0 | 0 | 2 | 13 | 8 | 21 | ||||||||||||||||||||||||||||||||||
711438 | 711438 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006515 | 1295 | COLLEGIATE PREPARATORY ACADEMY | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 1 | 32 | 54 | 1 | 2 | 4 | 6 | 52 | 48 | 100 | 1 | 32 | 54 | 1 | 2 | 4 | 6 | 52 | 48 | 100 | ||||||||||||||||||||||||||||||||||
707939 | 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 | ||||||||||||||||||||||||||||||||||
716954 | 716954 | CO | school | 803480 | 1520 | DURANGO 9-R | 80348006696 | 1526 | COLORADO CONNECTIONS ACADEMY @ DURANGO | Regular School | No | Other | KG | 10 | 2017 | grade_9 | 67 | 4 | 22 | 1 | 0 | 0 | 9 | 52 | 51 | 103 | 67 | 4 | 22 | 1 | 0 | 0 | 9 | 52 | 51 | 103 | ||||||||||||||||||||||||||||||||||
721022 | 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 | |||||||||||||||||||||||||||||||||||||||||
720741 | 720741 | CO | school | 800020 | 8001 | CHARTER SCHOOL INSTITUTE | 80002006542 | 2067 | COLORADO EARLY COLLEGE FORT COLLINS | Regular School | Yes | Other | 06 | 12 | 2017 | grade_9 | 102 | 3 | 18 | 0 | 5 | 0 | 4 | 68 | 64 | 132 | 102 | 3 | 18 | 0 | 5 | 0 | 4 | 68 | 64 | 132 | ||||||||||||||||||||||||||||||||||
720746 | 720746 | CO | school | 800020 | 8001 | CHARTER SCHOOL INSTITUTE | 80002006634 | 2196 | COLORADO EARLY COLLEGES - PARKER | Regular School | Yes | High | 09 | 12 | 2017 | grade_9 | 58 | 2 | 9 | 2 | 5 | 0 | 8 | 40 | 44 | 84 | 58 | 2 | 9 | 2 | 5 | 0 | 8 | 40 | 44 | 84 | ||||||||||||||||||||||||||||||||||
711488 | 711488 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001862 | 1748 | COLORADO HIGH SCHOOL CHARTER | Alternative School | Yes | High | 09 | 12 | 2017 | grade_9 | 7 | 6 | 30 | 2 | 0 | 0 | 2 | 31 | 16 | 47 | 7 | 6 | 30 | 2 | 0 | 0 | 2 | 31 | 16 | 47 | ||||||||||||||||||||||||||||||||||
720997 | 720997 | CO | school | 800282 | 9170 | COLORADO DIGITAL BOCES | 80028206600 | 1550 | COLORADO PREP ACADEMY | Regular School | No | Other | KG | 12 | 2017 | grade_9 | 76 | 9 | 8 | 1 | 0 | 0 | 4 | 47 | 51 | 98 | 76 | 9 | 8 | 1 | 0 | 0 | 4 | 47 | 51 | 98 | ||||||||||||||||||||||||||||||||||
720952 | 720952 | CO | school | 800023 | 9000 | COLORADO SCHOOL FOR THE DEAF AND BLIND | 80002306410 | 1924 | COLORADO SCHOOL FOR THE DEAF AND BLIND | Special Education School | No | Other | PK | 12 | 2017 | grade_9 | 8 | 1 | 8 | 0 | 1 | 0 | 1 | 15 | 4 | 19 | 8 | 1 | 8 | 0 | 1 | 0 | 1 | 15 | 4 | 19 | ||||||||||||||||||||||||||||||||||
720715 | 720715 | CO | school | 800020 | 8001 | CHARTER SCHOOL INSTITUTE | 80002006310 | 1795 | COLORADO SPRINGS EARLY COLLEGES | Regular School | Yes | High | 09 | 12 | 2017 | grade_9 | 74 | 3 | 23 | 0 | 5 | 0 | 8 | 56 | 57 | 113 | 74 | 3 | 23 | 0 | 5 | 0 | 8 | 56 | 57 | 113 | ||||||||||||||||||||||||||||||||||
709969 | 709969 | CO | school | 802700 | 190 | BYERS 32J | 80270001944 | 1752 | COLORADO VIRTUAL ACADEMY (COVA) | Regular School | Yes | High | 09 | 12 | 2017 | grade_9 | 87 | 1 | 17 | 2 | 0 | 0 | 0 | 48 | 59 | 107 | 87 | 1 | 17 | 2 | 0 | 0 | 0 | 48 | 59 | 107 | ||||||||||||||||||||||||||||||||||
708819 | 708819 | CO | school | 803780 | 120 | ENGLEWOOD 1 | 80378001310 | 206 | COLORADO'S FINEST HIGH SCHOOL OF CHOICE | Alternative School | No | High | 09 | 12 | 2017 | grade_9 | 44 | 1 | 28 | 0 | 1 | 0 | 0 | 45 | 29 | 74 | 44 | 1 | 28 | 0 | 1 | 0 | 0 | 45 | 29 | 74 |
Advanced export
JSON shape: default, array, newline-delimited
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]);