enrollments
Data source: Big Local News · About: Big Local
13,286 rows where state = "CO" and year = 2021 sorted by native_hawaiian_pacific_islander_int descending
This data as json, CSV (advanced)
grade ✖
- pk_12_total 1,920
- grade_5 1,114
- grade_2 1,109
- grade_4 1,109
- grade_3 1,108
- grade_1 1,106
- kindergarten_full_day 1,094
- grade_6 694
- pre_kindergarten 685
- grade_7 634
- grade_8 627
- grade_11 509
- grade_12 508
- grade_10 505
- grade_9 495
- kindergarten_half_day 69
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1742674 | 1742674 | CO | school | 803360 | 880 | Denver County 1 | 80336001276 | 5685 | McGlone Academy | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 23 | 104 | 650 | 3 | 6 | 57 | 14 | 412 | 445 | 857 | 23 | 104 | 650 | 3 | 6 | 57 | 14 | 412 | 445 | 857 | ||||||||||||||||||||||||||||||||||
1744474 | 1744474 | CO | school | 804080 | 1000 | Fountain 8 | 80408000562 | 3110 | Fountain-Fort Carson High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 846 | 224 | 505 | 16 | 26 | 41 | 176 | 931 | 903 | 1834 | 846 | 224 | 505 | 16 | 26 | 41 | 176 | 931 | 903 | 1834 | ||||||||||||||||||||||||||||||||||
1740159 | 1740159 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000063 | 3354 | Gateway High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 170 | 252 | 856 | 13 | 59 | 32 | 56 | 781 | 657 | 1438 | 170 | 252 | 856 | 13 | 59 | 32 | 56 | 781 | 657 | 1438 | ||||||||||||||||||||||||||||||||||
1740174 | 1740174 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000064 | 4024 | Hinkley High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 96 | 230 | 1457 | 16 | 78 | 29 | 55 | 1012 | 949 | 1961 | 96 | 230 | 1457 | 16 | 78 | 29 | 55 | 1012 | 949 | 1961 | ||||||||||||||||||||||||||||||||||
1744424 | 1744424 | CO | school | 806480 | 990 | Widefield 3 | 80648001129 | 9566 | Widefield High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 577 | 122 | 348 | 11 | 17 | 27 | 149 | 644 | 607 | 1251 | 577 | 122 | 348 | 11 | 17 | 27 | 149 | 644 | 607 | 1251 | ||||||||||||||||||||||||||||||||||
1745484 | 1745484 | CO | school | 803870 | 1110 | District 49 | 80387006393 | 3475 | GOAL Academy | Alternative School | Yes | High | 09 | 12 | 2021 | pk_12_total | 2224 | 185 | 2584 | 76 | 26 | 26 | 187 | 2567 | 2741 | 5308 | 2224 | 185 | 2584 | 76 | 26 | 26 | 187 | 2567 | 2741 | 5308 | ||||||||||||||||||||||||||||||||||
1740143 | 1740143 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234006644 | 2673 | Edna and John W. Mosley P-8 | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 158 | 147 | 495 | 10 | 18 | 24 | 53 | 485 | 420 | 905 | 158 | 147 | 495 | 10 | 18 | 24 | 53 | 485 | 420 | 905 | ||||||||||||||||||||||||||||||||||
1742198 | 1742198 | CO | school | 803360 | 880 | Denver County 1 | 80336006528 | 2209 | DCIS at Montbello | Regular School | No | High | 06 | 12 | 2021 | pk_12_total | 9 | 71 | 809 | 0 | 14 | 22 | 10 | 500 | 435 | 935 | 9 | 71 | 809 | 0 | 14 | 22 | 10 | 500 | 435 | 935 | ||||||||||||||||||||||||||||||||||
1742642 | 1742642 | CO | school | 803360 | 880 | Denver County 1 | 80336001406 | 5605 | Dr. Martin Luther King Jr. Early College | Regular School | No | High | 06 | 12 | 2021 | pk_12_total | 57 | 300 | 693 | 2 | 91 | 22 | 34 | 623 | 576 | 1199 | 57 | 300 | 693 | 2 | 91 | 22 | 34 | 623 | 576 | 1199 | ||||||||||||||||||||||||||||||||||
1744372 | 1744372 | CO | school | 806480 | 990 | Widefield 3 | 80648001588 | 5841 | Mesa Ridge High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 603 | 127 | 392 | 12 | 25 | 22 | 131 | 716 | 596 | 1312 | 603 | 127 | 392 | 12 | 25 | 22 | 131 | 716 | 596 | 1312 | ||||||||||||||||||||||||||||||||||
1744338 | 1744338 | CO | school | 806480 | 990 | Widefield 3 | 80648006772 | 3692 | Grand Mountain School | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 422 | 113 | 289 | 7 | 18 | 21 | 104 | 498 | 476 | 974 | 422 | 113 | 289 | 7 | 18 | 21 | 104 | 498 | 476 | 974 | ||||||||||||||||||||||||||||||||||
1742633 | 1742633 | CO | school | 803360 | 880 | Denver County 1 | 80336001380 | 5578 | Marrama Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 37 | 95 | 258 | 1 | 66 | 19 | 17 | 251 | 242 | 493 | 37 | 95 | 258 | 1 | 66 | 19 | 17 | 251 | 242 | 493 | ||||||||||||||||||||||||||||||||||
1744462 | 1744462 | CO | school | 804080 | 1000 | Fountain 8 | 80408000563 | 3106 | Fountain Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 531 | 93 | 294 | 12 | 14 | 19 | 121 | 562 | 522 | 1084 | 531 | 93 | 294 | 12 | 14 | 19 | 121 | 562 | 522 | 1084 | ||||||||||||||||||||||||||||||||||
1740252 | 1740252 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000073 | 6160 | Mrachek Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 137 | 184 | 482 | 4 | 43 | 17 | 61 | 489 | 439 | 928 | 137 | 184 | 482 | 4 | 43 | 17 | 61 | 489 | 439 | 928 | ||||||||||||||||||||||||||||||||||
1740060 | 1740060 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000056 | 1458 | Aurora Central High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 76 | 294 | 1262 | 16 | 86 | 16 | 57 | 953 | 854 | 1807 | 76 | 294 | 1262 | 16 | 86 | 16 | 57 | 953 | 854 | 1807 | ||||||||||||||||||||||||||||||||||
1744451 | 1744451 | CO | school | 804080 | 1000 | Fountain 8 | 80408006330 | 3027 | Eagleside Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 291 | 47 | 108 | 5 | 6 | 16 | 85 | 281 | 277 | 558 | 291 | 47 | 108 | 5 | 6 | 16 | 85 | 281 | 277 | 558 | ||||||||||||||||||||||||||||||||||
1744602 | 1744602 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000268 | 2202 | Doherty High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1072 | 134 | 536 | 14 | 37 | 16 | 132 | 982 | 959 | 1941 | 1072 | 134 | 536 | 14 | 37 | 16 | 132 | 982 | 959 | 1941 | ||||||||||||||||||||||||||||||||||
1740296 | 1740296 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000076 | 6758 | Park Lane Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 10 | 23 | 175 | 3 | 15 | 15 | 16 | 139 | 118 | 257 | 10 | 23 | 175 | 3 | 15 | 15 | 16 | 139 | 118 | 257 | ||||||||||||||||||||||||||||||||||
1742747 | 1742747 | CO | school | 803360 | 880 | Denver County 1 | 80336006520 | 6239 | Noel Community Arts School | Regular School | No | High | 06 | 12 | 2021 | pk_12_total | 27 | 98 | 237 | 1 | 7 | 15 | 11 | 188 | 208 | 396 | 27 | 98 | 237 | 1 | 7 | 15 | 11 | 188 | 208 | 396 | ||||||||||||||||||||||||||||||||||
1744435 | 1744435 | CO | school | 804080 | 1000 | Fountain 8 | 80408000561 | 1332 | Carson Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 323 | 91 | 165 | 6 | 13 | 15 | 75 | 355 | 333 | 688 | 323 | 91 | 165 | 6 | 13 | 15 | 75 | 355 | 333 | 688 | ||||||||||||||||||||||||||||||||||
1744470 | 1744470 | CO | school | 804080 | 1000 | Fountain 8 | 80408000562 | 3110 | Fountain-Fort Carson High School | Regular School | No | High | 09 | 12 | 2021 | grade_10 | 223 | 60 | 161 | 4 | 7 | 15 | 54 | 263 | 261 | 524 | 223 | 60 | 161 | 4 | 7 | 15 | 54 | 263 | 261 | 524 | ||||||||||||||||||||||||||||||||||
1744495 | 1744495 | CO | school | 804080 | 1000 | Fountain 8 | 80408000565 | 6338 | Patriot Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 330 | 74 | 125 | 3 | 15 | 15 | 69 | 335 | 296 | 631 | 330 | 74 | 125 | 3 | 15 | 15 | 69 | 335 | 296 | 631 | ||||||||||||||||||||||||||||||||||
1745482 | 1745482 | CO | school | 803870 | 1110 | District 49 | 80387006393 | 3475 | GOAL Academy | Alternative School | Yes | High | 09 | 12 | 2021 | grade_12 | 1098 | 120 | 1461 | 32 | 16 | 15 | 108 | 1350 | 1500 | 2850 | 1098 | 120 | 1461 | 32 | 16 | 15 | 108 | 1350 | 1500 | 2850 | ||||||||||||||||||||||||||||||||||
1740033 | 1740033 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000054 | 464 | Aurora Hills Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 52 | 146 | 421 | 6 | 27 | 14 | 28 | 382 | 312 | 694 | 52 | 146 | 421 | 6 | 27 | 14 | 28 | 382 | 312 | 694 | ||||||||||||||||||||||||||||||||||
1744191 | 1744191 | CO | school | 804530 | 980 | Harrison 2 | 80453000667 | 3806 | Harrison High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 224 | 171 | 570 | 9 | 24 | 14 | 96 | 608 | 500 | 1108 | 224 | 171 | 570 | 9 | 24 | 14 | 96 | 608 | 500 | 1108 | ||||||||||||||||||||||||||||||||||
1739744 | 1739744 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000203 | 8020 | Smoky Hill High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 927 | 383 | 567 | 18 | 143 | 13 | 157 | 1151 | 1057 | 2208 | 927 | 383 | 567 | 18 | 143 | 13 | 157 | 1151 | 1057 | 2208 | ||||||||||||||||||||||||||||||||||
1740328 | 1740328 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234001389 | 7250 | Rangeview High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 475 | 410 | 950 | 15 | 113 | 13 | 156 | 1087 | 1045 | 2132 | 475 | 410 | 950 | 15 | 113 | 13 | 156 | 1087 | 1045 | 2132 | ||||||||||||||||||||||||||||||||||
1740368 | 1740368 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234001324 | 8858 | Tollgate Elementary School of Expeditionary Learning | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 63 | 94 | 263 | 1 | 13 | 13 | 32 | 235 | 244 | 479 | 63 | 94 | 263 | 1 | 13 | 13 | 32 | 235 | 244 | 479 | ||||||||||||||||||||||||||||||||||
1742135 | 1742135 | CO | school | 803360 | 880 | Denver County 1 | 80336006546 | 2181 | DSST: Green Valley Ranch Middle School | Regular School | Yes | Middle | 06 | 08 | 2021 | pk_12_total | 24 | 119 | 277 | 0 | 35 | 13 | 17 | 252 | 233 | 485 | 24 | 119 | 277 | 0 | 35 | 13 | 17 | 252 | 233 | 485 | ||||||||||||||||||||||||||||||||||
1744502 | 1744502 | CO | school | 804080 | 1000 | Fountain 8 | 80408006481 | 9610 | Weikel Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 461 | 73 | 177 | 7 | 20 | 13 | 59 | 424 | 386 | 810 | 461 | 73 | 177 | 7 | 20 | 13 | 59 | 424 | 386 | 810 | ||||||||||||||||||||||||||||||||||
1740267 | 1740267 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000074 | 6310 | North Middle School Health Sciences and Technology Campus | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 26 | 90 | 407 | 1 | 22 | 12 | 17 | 309 | 266 | 575 | 26 | 90 | 407 | 1 | 22 | 12 | 17 | 309 | 266 | 575 | ||||||||||||||||||||||||||||||||||
1742845 | 1742845 | CO | school | 803360 | 880 | Denver County 1 | 80336001933 | 6970 | Florida Pitt-Waller ECE-8 School | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 42 | 249 | 407 | 7 | 50 | 12 | 21 | 364 | 424 | 788 | 42 | 249 | 407 | 7 | 50 | 12 | 21 | 364 | 424 | 788 | ||||||||||||||||||||||||||||||||||
1744397 | 1744397 | CO | school | 806480 | 990 | Widefield 3 | 80648001418 | 8392 | Sunrise Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 242 | 38 | 168 | 1 | 10 | 12 | 48 | 270 | 249 | 519 | 242 | 38 | 168 | 1 | 10 | 12 | 48 | 270 | 249 | 519 | ||||||||||||||||||||||||||||||||||
1739712 | 1739712 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000201 | 7158 | Prairie Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 300 | 416 | 629 | 11 | 74 | 11 | 118 | 805 | 754 | 1559 | 300 | 416 | 629 | 11 | 74 | 11 | 118 | 805 | 754 | 1559 | ||||||||||||||||||||||||||||||||||
1740156 | 1740156 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000063 | 3354 | Gateway High School | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 41 | 53 | 180 | 2 | 12 | 11 | 13 | 163 | 149 | 312 | 41 | 53 | 180 | 2 | 12 | 11 | 13 | 163 | 149 | 312 | ||||||||||||||||||||||||||||||||||
1740171 | 1740171 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000064 | 4024 | Hinkley High School | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 25 | 47 | 335 | 5 | 17 | 11 | 12 | 235 | 217 | 452 | 25 | 47 | 335 | 5 | 17 | 11 | 12 | 235 | 217 | 452 | ||||||||||||||||||||||||||||||||||
1740356 | 1740356 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000079 | 8078 | South Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 43 | 129 | 479 | 4 | 12 | 11 | 28 | 364 | 342 | 706 | 43 | 129 | 479 | 4 | 12 | 11 | 28 | 364 | 342 | 706 | ||||||||||||||||||||||||||||||||||
1744349 | 1744349 | CO | school | 806480 | 990 | Widefield 3 | 80648001120 | 4394 | Janitell Junior High School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 284 | 59 | 217 | 3 | 11 | 11 | 79 | 359 | 305 | 664 | 284 | 59 | 217 | 3 | 11 | 11 | 79 | 359 | 305 | 664 | ||||||||||||||||||||||||||||||||||
1750889 | 1750889 | CO | school | 804410 | 3120 | Greeley 6 | 80441006552 | 8975 | Union Colony Elementary School | Regular School | Yes | Elementary | KG | 05 | 2021 | pk_12_total | 118 | 23 | 203 | 0 | 20 | 11 | 8 | 188 | 195 | 383 | 118 | 23 | 203 | 0 | 20 | 11 | 8 | 188 | 195 | 383 | ||||||||||||||||||||||||||||||||||
1739224 | 1739224 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001254 | 9466 | Westminster High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 286 | 33 | 1708 | 14 | 108 | 10 | 39 | 1100 | 1098 | 2198 | 286 | 33 | 1708 | 14 | 108 | 10 | 39 | 1100 | 1098 | 2198 | ||||||||||||||||||||||||||||||||||
1742666 | 1742666 | CO | school | 803360 | 880 | Denver County 1 | 80336001276 | 5685 | McGlone Academy | Regular School | No | Elementary | PK | 08 | 2021 | grade_2 | 2 | 10 | 81 | 0 | 0 | 10 | 2 | 46 | 59 | 105 | 2 | 10 | 81 | 0 | 0 | 10 | 2 | 46 | 59 | 105 | ||||||||||||||||||||||||||||||||||
1744292 | 1744292 | CO | school | 804530 | 980 | Harrison 2 | 80453001965 | 8034 | Soaring Eagles Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 159 | 54 | 250 | 2 | 19 | 10 | 52 | 261 | 285 | 546 | 159 | 54 | 250 | 2 | 19 | 10 | 52 | 261 | 285 | 546 | ||||||||||||||||||||||||||||||||||
1744460 | 1744460 | CO | school | 804080 | 1000 | Fountain 8 | 80408000563 | 3106 | Fountain Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 183 | 31 | 86 | 5 | 7 | 10 | 47 | 187 | 182 | 369 | 183 | 31 | 86 | 5 | 7 | 10 | 47 | 187 | 182 | 369 | ||||||||||||||||||||||||||||||||||
1744471 | 1744471 | CO | school | 804080 | 1000 | Fountain 8 | 80408000562 | 3110 | Fountain-Fort Carson High School | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 189 | 43 | 114 | 4 | 4 | 10 | 35 | 200 | 199 | 399 | 189 | 43 | 114 | 4 | 4 | 10 | 35 | 200 | 199 | 399 | ||||||||||||||||||||||||||||||||||
1744481 | 1744481 | CO | school | 804080 | 1000 | Fountain 8 | 80408001481 | 4474 | Jordahl Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 297 | 32 | 150 | 4 | 6 | 10 | 67 | 291 | 275 | 566 | 297 | 32 | 150 | 4 | 6 | 10 | 67 | 291 | 275 | 566 | ||||||||||||||||||||||||||||||||||
1745200 | 1745200 | CO | school | 801920 | 1040 | Academy 20 | 80192001321 | 7240 | Rampart High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 946 | 58 | 289 | 7 | 85 | 10 | 124 | 757 | 762 | 1519 | 946 | 58 | 289 | 7 | 85 | 10 | 124 | 757 | 762 | 1519 | ||||||||||||||||||||||||||||||||||
1739553 | 1739553 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001625 | 3589 | Grandview High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1617 | 263 | 453 | 23 | 362 | 9 | 181 | 1496 | 1412 | 2908 | 1617 | 263 | 453 | 23 | 362 | 9 | 181 | 1496 | 1412 | 2908 | ||||||||||||||||||||||||||||||||||
1739574 | 1739574 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006182 | 3988 | Highline Community Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 51 | 90 | 219 | 3 | 22 | 9 | 13 | 213 | 194 | 407 | 51 | 90 | 219 | 3 | 22 | 9 | 13 | 213 | 194 | 407 | ||||||||||||||||||||||||||||||||||
1740158 | 1740158 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000063 | 3354 | Gateway High School | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 44 | 61 | 211 | 7 | 20 | 9 | 14 | 203 | 163 | 366 | 44 | 61 | 211 | 7 | 20 | 9 | 14 | 203 | 163 | 366 | ||||||||||||||||||||||||||||||||||
1740170 | 1740170 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000064 | 4024 | Hinkley High School | Regular School | No | High | 09 | 12 | 2021 | grade_10 | 17 | 62 | 369 | 3 | 23 | 9 | 15 | 259 | 239 | 498 | 17 | 62 | 369 | 3 | 23 | 9 | 15 | 259 | 239 | 498 | ||||||||||||||||||||||||||||||||||
1740207 | 1740207 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000068 | 4970 | Lansing Elementary Community School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 35 | 90 | 167 | 3 | 18 | 9 | 33 | 178 | 177 | 355 | 35 | 90 | 167 | 3 | 18 | 9 | 33 | 178 | 177 | 355 | ||||||||||||||||||||||||||||||||||
1742280 | 1742280 | CO | school | 803360 | 880 | Denver County 1 | 80336006527 | 2757 | Northeast Early College | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 29 | 78 | 427 | 0 | 5 | 9 | 8 | 306 | 250 | 556 | 29 | 78 | 427 | 0 | 5 | 9 | 8 | 306 | 250 | 556 | ||||||||||||||||||||||||||||||||||
1742375 | 1742375 | CO | school | 803360 | 880 | Denver County 1 | 80336001776 | 3641 | Green Valley Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 59 | 135 | 372 | 8 | 61 | 9 | 19 | 347 | 316 | 663 | 59 | 135 | 372 | 8 | 61 | 9 | 19 | 347 | 316 | 663 | ||||||||||||||||||||||||||||||||||
1744390 | 1744390 | CO | school | 806480 | 990 | Widefield 3 | 80648001125 | 8178 | Sproul Junior High School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 274 | 46 | 177 | 3 | 11 | 9 | 60 | 286 | 294 | 580 | 274 | 46 | 177 | 3 | 11 | 9 | 60 | 286 | 294 | 580 | ||||||||||||||||||||||||||||||||||
1744421 | 1744421 | CO | school | 806480 | 990 | Widefield 3 | 80648001129 | 9566 | Widefield High School | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 125 | 22 | 78 | 2 | 2 | 9 | 34 | 152 | 120 | 272 | 125 | 22 | 78 | 2 | 2 | 9 | 34 | 152 | 120 | 272 | ||||||||||||||||||||||||||||||||||
1744422 | 1744422 | CO | school | 806480 | 990 | Widefield 3 | 80648001129 | 9566 | Widefield High School | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 144 | 41 | 91 | 4 | 4 | 9 | 39 | 165 | 167 | 332 | 144 | 41 | 91 | 4 | 4 | 9 | 39 | 165 | 167 | 332 | ||||||||||||||||||||||||||||||||||
1744893 | 1744893 | CO | school | 802940 | 1020 | Cheyenne Mountain 12 | 80294001326 | 1582 | The Vanguard School (Elementary) | Regular School | Yes | Elementary | KG | 06 | 2021 | pk_12_total | 557 | 43 | 280 | 0 | 54 | 9 | 117 | 514 | 546 | 1060 | 557 | 43 | 280 | 0 | 54 | 9 | 117 | 514 | 546 | 1060 | ||||||||||||||||||||||||||||||||||
1745618 | 1745618 | CO | school | 803870 | 1110 | District 49 | 80387006408 | 8791 | Vista Ridge High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 873 | 121 | 397 | 6 | 68 | 9 | 153 | 845 | 782 | 1627 | 873 | 121 | 397 | 6 | 68 | 9 | 153 | 845 | 782 | 1627 | ||||||||||||||||||||||||||||||||||
1746995 | 1746995 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001036 | 7701 | Collegiate Academy of Colorado | Regular School | Yes | Other | KG | 12 | 2021 | pk_12_total | 316 | 6 | 70 | 0 | 7 | 9 | 25 | 204 | 229 | 433 | 316 | 6 | 70 | 0 | 7 | 9 | 25 | 204 | 229 | 433 | ||||||||||||||||||||||||||||||||||
1751506 | 1751506 | CO | school | 800282 | 9170 | Education reEnvisioned BOCES | 80028206752 | 1448 | Colorado Preparatory Academy Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 1189 | 144 | 702 | 7 | 24 | 9 | 205 | 1094 | 1186 | 2280 | 1189 | 144 | 702 | 7 | 24 | 9 | 205 | 1094 | 1186 | 2280 | ||||||||||||||||||||||||||||||||||
1738887 | 1738887 | CO | school | 802580 | 40 | School District 27J | 80258000144 | 1022 | Brighton High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 735 | 18 | 1005 | 7 | 15 | 8 | 46 | 910 | 924 | 1834 | 735 | 18 | 1005 | 7 | 15 | 8 | 46 | 910 | 924 | 1834 | ||||||||||||||||||||||||||||||||||
1740153 | 1740153 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000062 | 3272 | Fulton Academy of Excellence | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 25 | 50 | 261 | 4 | 16 | 8 | 13 | 195 | 182 | 377 | 25 | 50 | 261 | 4 | 16 | 8 | 13 | 195 | 182 | 377 | ||||||||||||||||||||||||||||||||||
1740181 | 1740181 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234001323 | 4270 | Iowa Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 74 | 68 | 206 | 2 | 25 | 8 | 32 | 219 | 196 | 415 | 74 | 68 | 206 | 2 | 25 | 8 | 32 | 219 | 196 | 415 | ||||||||||||||||||||||||||||||||||
1740247 | 1740247 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000072 | 6068 | Montview Math & Health Sciences Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 25 | 41 | 224 | 3 | 6 | 8 | 14 | 174 | 147 | 321 | 25 | 41 | 224 | 3 | 6 | 8 | 14 | 174 | 147 | 321 | ||||||||||||||||||||||||||||||||||
1742197 | 1742197 | CO | school | 803360 | 880 | Denver County 1 | 80336006528 | 2209 | DCIS at Montbello | Regular School | No | High | 06 | 12 | 2021 | grade_9 | 2 | 18 | 189 | 0 | 4 | 8 | 3 | 136 | 88 | 224 | 2 | 18 | 189 | 0 | 4 | 8 | 3 | 136 | 88 | 224 | ||||||||||||||||||||||||||||||||||
1742323 | 1742323 | CO | school | 803360 | 880 | Denver County 1 | 80336001864 | 3340 | Lena Archuleta Elementary School | Regular School | No | Elementary | 01 | 05 | 2021 | pk_12_total | 15 | 57 | 355 | 0 | 15 | 8 | 13 | 243 | 220 | 463 | 15 | 57 | 355 | 0 | 15 | 8 | 13 | 243 | 220 | 463 | ||||||||||||||||||||||||||||||||||
1742474 | 1742474 | CO | school | 803360 | 880 | Denver County 1 | 80336001928 | 4140 | Farrell B. Howell ECE-8 School | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 5 | 95 | 489 | 2 | 3 | 8 | 3 | 295 | 310 | 605 | 5 | 95 | 489 | 2 | 3 | 8 | 3 | 295 | 310 | 605 | ||||||||||||||||||||||||||||||||||
1742668 | 1742668 | CO | school | 803360 | 880 | Denver County 1 | 80336001276 | 5685 | McGlone Academy | Regular School | No | Elementary | PK | 08 | 2021 | grade_4 | 3 | 13 | 78 | 0 | 0 | 8 | 1 | 56 | 47 | 103 | 3 | 13 | 78 | 0 | 0 | 8 | 1 | 56 | 47 | 103 | ||||||||||||||||||||||||||||||||||
1742807 | 1742807 | CO | school | 803360 | 880 | Denver County 1 | 80336001838 | 6508 | Omar D Blair Charter School | Regular School | Yes | Elementary | KG | 08 | 2021 | pk_12_total | 48 | 268 | 249 | 6 | 61 | 8 | 35 | 361 | 314 | 675 | 48 | 268 | 249 | 6 | 61 | 8 | 35 | 361 | 314 | 675 | ||||||||||||||||||||||||||||||||||
1743334 | 1743334 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001578 | 1503 | Chaparral High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1592 | 40 | 352 | 7 | 92 | 8 | 122 | 1096 | 1117 | 2213 | 1592 | 40 | 352 | 7 | 92 | 8 | 122 | 1096 | 1117 | 2213 | ||||||||||||||||||||||||||||||||||
1744371 | 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 | ||||||||||||||||||||||||||||||||||
1744469 | 1744469 | CO | school | 804080 | 1000 | Fountain 8 | 80408000564 | 3108 | Mesa Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 258 | 37 | 120 | 8 | 5 | 8 | 57 | 264 | 229 | 493 | 258 | 37 | 120 | 8 | 5 | 8 | 57 | 264 | 229 | 493 | ||||||||||||||||||||||||||||||||||
1744472 | 1744472 | CO | school | 804080 | 1000 | Fountain 8 | 80408000562 | 3110 | Fountain-Fort Carson High School | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 191 | 61 | 90 | 4 | 8 | 8 | 32 | 204 | 190 | 394 | 191 | 61 | 90 | 4 | 8 | 8 | 32 | 204 | 190 | 394 | ||||||||||||||||||||||||||||||||||
1744473 | 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 | ||||||||||||||||||||||||||||||||||
1744578 | 1744578 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306006319 | 1625 | McAuliffe Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 212 | 51 | 131 | 8 | 12 | 8 | 59 | 270 | 211 | 481 | 212 | 51 | 131 | 8 | 12 | 8 | 59 | 270 | 211 | 481 | ||||||||||||||||||||||||||||||||||
1745181 | 1745181 | CO | school | 801920 | 1040 | Academy 20 | 80192001645 | 6937 | Pine Creek High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1113 | 42 | 244 | 9 | 91 | 8 | 137 | 867 | 777 | 1644 | 1113 | 42 | 244 | 9 | 91 | 8 | 137 | 867 | 777 | 1644 | ||||||||||||||||||||||||||||||||||
1739678 | 1739678 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001272 | 6625 | Overland High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 431 | 652 | 941 | 21 | 108 | 7 | 126 | 1213 | 1073 | 2286 | 431 | 652 | 941 | 21 | 108 | 7 | 126 | 1213 | 1073 | 2286 | ||||||||||||||||||||||||||||||||||
1740018 | 1740018 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234001296 | 310 | Arkansas Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 62 | 100 | 153 | 2 | 21 | 7 | 49 | 195 | 199 | 394 | 62 | 100 | 153 | 2 | 21 | 7 | 49 | 195 | 199 | 394 | ||||||||||||||||||||||||||||||||||
1740169 | 1740169 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234006318 | 3471 | Global Village Academy Aurora | Regular School | Yes | Elementary | KG | 08 | 2021 | pk_12_total | 69 | 170 | 522 | 1 | 33 | 7 | 59 | 421 | 440 | 861 | 69 | 170 | 522 | 1 | 33 | 7 | 59 | 421 | 440 | 861 | ||||||||||||||||||||||||||||||||||
1740335 | 1740335 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000077 | 7558 | Sable Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 23 | 85 | 257 | 4 | 17 | 7 | 13 | 204 | 202 | 406 | 23 | 85 | 257 | 4 | 17 | 7 | 13 | 204 | 202 | 406 | ||||||||||||||||||||||||||||||||||
1740402 | 1740402 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000080 | 9060 | Vaughn Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 22 | 35 | 224 | 7 | 15 | 7 | 11 | 158 | 163 | 321 | 22 | 35 | 224 | 7 | 15 | 7 | 11 | 158 | 163 | 321 | ||||||||||||||||||||||||||||||||||
1740426 | 1740426 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000081 | 9140 | Virginia Court Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 35 | 60 | 237 | 3 | 16 | 7 | 17 | 203 | 172 | 375 | 35 | 60 | 237 | 3 | 16 | 7 | 17 | 203 | 172 | 375 | ||||||||||||||||||||||||||||||||||
1740518 | 1740518 | CO | school | 802700 | 190 | Byers 32J | 80270006749 | 8994 | Astravo Online Academy Elementary School | Regular School | Yes | Elementary | PK | 05 | 2021 | pk_12_total | 438 | 78 | 260 | 12 | 10 | 7 | 0 | 409 | 396 | 805 | 438 | 78 | 260 | 12 | 10 | 7 | 0 | 409 | 396 | 805 | ||||||||||||||||||||||||||||||||||
1741945 | 1741945 | CO | school | 803360 | 880 | Denver County 1 | 80336006515 | 1295 | Collegiate Preparatory Academy | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 8 | 88 | 214 | 3 | 10 | 7 | 10 | 153 | 187 | 340 | 8 | 88 | 214 | 3 | 10 | 7 | 10 | 153 | 187 | 340 | ||||||||||||||||||||||||||||||||||
1742133 | 1742133 | CO | school | 803360 | 880 | Denver County 1 | 80336006546 | 2181 | DSST: Green Valley Ranch Middle School | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_7 | 9 | 42 | 93 | 0 | 11 | 7 | 3 | 94 | 71 | 165 | 9 | 42 | 93 | 0 | 11 | 7 | 3 | 94 | 71 | 165 | ||||||||||||||||||||||||||||||||||
1742182 | 1742182 | CO | school | 803360 | 880 | Denver County 1 | 80336006521 | 2205 | DCIS at Ford | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 12 | 87 | 378 | 0 | 4 | 7 | 7 | 241 | 254 | 495 | 12 | 87 | 378 | 0 | 4 | 7 | 7 | 241 | 254 | 495 | ||||||||||||||||||||||||||||||||||
1742641 | 1742641 | CO | school | 803360 | 880 | Denver County 1 | 80336001406 | 5605 | Dr. Martin Luther King Jr. Early College | Regular School | No | High | 06 | 12 | 2021 | grade_9 | 13 | 66 | 125 | 0 | 20 | 7 | 6 | 140 | 97 | 237 | 13 | 66 | 125 | 0 | 20 | 7 | 6 | 140 | 97 | 237 | ||||||||||||||||||||||||||||||||||
1742663 | 1742663 | CO | school | 803360 | 880 | Denver County 1 | 80336001635 | 5644 | Maxwell Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 24 | 81 | 480 | 4 | 3 | 7 | 4 | 299 | 304 | 603 | 24 | 81 | 480 | 4 | 3 | 7 | 4 | 299 | 304 | 603 | ||||||||||||||||||||||||||||||||||
1742665 | 1742665 | CO | school | 803360 | 880 | Denver County 1 | 80336001276 | 5685 | McGlone Academy | Regular School | No | Elementary | PK | 08 | 2021 | grade_1 | 2 | 11 | 67 | 1 | 1 | 7 | 0 | 40 | 49 | 89 | 2 | 11 | 67 | 1 | 1 | 7 | 0 | 40 | 49 | 89 | ||||||||||||||||||||||||||||||||||
1742667 | 1742667 | CO | school | 803360 | 880 | Denver County 1 | 80336001276 | 5685 | McGlone Academy | Regular School | No | Elementary | PK | 08 | 2021 | grade_3 | 3 | 12 | 67 | 1 | 2 | 7 | 1 | 44 | 49 | 93 | 3 | 12 | 67 | 1 | 2 | 7 | 1 | 44 | 49 | 93 | ||||||||||||||||||||||||||||||||||
1742669 | 1742669 | CO | school | 803360 | 880 | Denver County 1 | 80336001276 | 5685 | McGlone Academy | Regular School | No | Elementary | PK | 08 | 2021 | grade_5 | 3 | 12 | 92 | 0 | 1 | 7 | 5 | 57 | 63 | 120 | 3 | 12 | 92 | 0 | 1 | 7 | 5 | 57 | 63 | 120 | ||||||||||||||||||||||||||||||||||
1742671 | 1742671 | CO | school | 803360 | 880 | Denver County 1 | 80336001276 | 5685 | McGlone Academy | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 2 | 10 | 55 | 0 | 0 | 7 | 1 | 36 | 39 | 75 | 2 | 10 | 55 | 0 | 0 | 7 | 1 | 36 | 39 | 75 | ||||||||||||||||||||||||||||||||||
1744285 | 1744285 | CO | school | 804530 | 980 | Harrison 2 | 80453001382 | 7882 | Sierra High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 132 | 169 | 406 | 7 | 27 | 7 | 60 | 410 | 398 | 808 | 132 | 169 | 406 | 7 | 27 | 7 | 60 | 410 | 398 | 808 | ||||||||||||||||||||||||||||||||||
1744320 | 1744320 | CO | school | 804530 | 980 | Harrison 2 | 80453001370 | 9602 | Wildflower Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 106 | 66 | 182 | 2 | 5 | 7 | 32 | 209 | 191 | 400 | 106 | 66 | 182 | 2 | 5 | 7 | 32 | 209 | 191 | 400 | ||||||||||||||||||||||||||||||||||
1744420 | 1744420 | CO | school | 806480 | 990 | Widefield 3 | 80648001129 | 9566 | Widefield High School | Regular School | No | High | 09 | 12 | 2021 | grade_10 | 147 | 24 | 80 | 2 | 6 | 7 | 31 | 143 | 154 | 297 | 147 | 24 | 80 | 2 | 6 | 7 | 31 | 143 | 154 | 297 | ||||||||||||||||||||||||||||||||||
1744558 | 1744558 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000226 | 1340 | Carver Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 92 | 35 | 83 | 0 | 3 | 7 | 17 | 128 | 109 | 237 | 92 | 35 | 83 | 0 | 3 | 7 | 17 | 128 | 109 | 237 | ||||||||||||||||||||||||||||||||||
1745196 | 1745196 | CO | school | 801920 | 1040 | Academy 20 | 80192001321 | 7240 | Rampart High School | Regular School | No | High | 09 | 12 | 2021 | grade_10 | 205 | 5 | 88 | 2 | 20 | 7 | 34 | 200 | 161 | 361 | 205 | 5 | 88 | 2 | 20 | 7 | 34 | 200 | 161 | 361 | ||||||||||||||||||||||||||||||||||
1745481 | 1745481 | CO | school | 803870 | 1110 | District 49 | 80387006393 | 3475 | GOAL Academy | Alternative School | Yes | High | 09 | 12 | 2021 | grade_11 | 570 | 40 | 540 | 26 | 6 | 7 | 37 | 609 | 617 | 1226 | 570 | 40 | 540 | 26 | 6 | 7 | 37 | 609 | 617 | 1226 | ||||||||||||||||||||||||||||||||||
1745498 | 1745498 | CO | school | 803870 | 1110 | District 49 | 80387006386 | 4251 | Grand Peak Academy | Regular School | Yes | Elementary | KG | 08 | 2021 | pk_12_total | 434 | 25 | 180 | 2 | 23 | 7 | 56 | 371 | 356 | 727 | 434 | 25 | 180 | 2 | 23 | 7 | 56 | 371 | 356 | 727 | ||||||||||||||||||||||||||||||||||
1746395 | 1746395 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000717 | 2550 | Eiber Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 67 | 19 | 216 | 4 | 3 | 7 | 5 | 154 | 167 | 321 | 67 | 19 | 216 | 4 | 3 | 7 | 5 | 154 | 167 | 321 |
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]);