enrollments
Data source: Big Local News · About: Big Local
257,968 rows where state = "MO" sorted by black descending
This data as json, CSV (advanced)
grade ✖
- grade_1 16,123
- grade_10 16,123
- grade_11 16,123
- grade_12 16,123
- grade_2 16,123
- grade_3 16,123
- grade_4 16,123
- grade_5 16,123
- grade_6 16,123
- grade_7 16,123
- grade_8 16,123
- grade_9 16,123
- k_12_total 16,123
- kindergarten 16,123
- pk_12_total 16,123
- pre_kindergarten 16,123
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3301349 | 3301349 | MO | school | 2912290 | 48066 | FORT OSAGE R-I | 291229000496 | 1050 | FORT OSAGE HIGH | Regular School | No | 3 | 09 | 12 | 2015 | k_12_total | 1221 | 99 | 116 | 15 | 11 | 38 | 12 | 16 | 720.2 | 125 | 1512 | 1221 | 99 | 116 | 15 | 11 | 38 | 12 | 16 | 125 | 1512 | |||||||||||||||||||||||||||||||||
3302264 | 3302264 | MO | school | 2916400 | 48078 | KANSAS CITY 33 | 291640000848 | 4880 | LONGFELLOW ELEM. | Regular School | No | 1 | PK | 06 | 2015 | k_12_total | 29 | 99 | 25 | * | * | * | * | 17 | * | 43 | 160 | 29 | 99 | 25 | 17 | 43 | 160 | |||||||||||||||||||||||||||||||||||||
3306173 | 3306173 | MO | school | 2928950 | 92088 | FRANCIS HOWELL R-III | 292895002307 | 3000 | BARNWELL MIDDLE | Regular School | No | 2 | 06 | 08 | 2015 | k_12_total | 624 | 99 | 50 | * | 57 | * | 37 | 23 | 249 | 98 | 867 | 624 | 99 | 50 | 57 | 37 | 23 | 249 | 98 | 867 | ||||||||||||||||||||||||||||||||||
3297625 | 3297625 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001660 | 1080 | LAFAYETTE HIGH | Regular School | No | 3 | 09 | 12 | 2016 | k_12_total | 604 | 99 | 46 | * | * | * | 27 | 14 | 478 | 102 | 784 | 604 | 99 | 46 | 27 | 14 | 478 | 102 | 784 | |||||||||||||||||||||||||||||||||||
3299159 | 3299159 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001268 | 3100 | EASTGATE MIDDLE | Regular School | No | 2 | 06 | 08 | 2016 | k_12_total | 320 | 99 | 117 | 6 | 36 | 5 | 65 | 32 | 478 | 119 | 648 | 320 | 99 | 117 | 6 | 36 | 5 | 65 | 32 | 478 | 119 | 648 | ||||||||||||||||||||||||||||||||
3307845 | 3307845 | MO | school | 2920010 | 96107 | MAPLEWOOD-RICHMOND HEIGHTS | 292001001067 | 1050 | MAPLEWOOD-RICHMOND HGTS. HIGH | Regular School | No | 3 | 09 | 12 | 2016 | k_12_total | 165 | 99 | 12 | * | * | * | 20 | * | 138 | 39 | 302 | 165 | 99 | 12 | 20 | 138 | 39 | 302 | ||||||||||||||||||||||||||||||||||||
3308105 | 3308105 | MO | school | 2930690 | 96113 | VALLEY PARK | 293069002115 | 4020 | VALLEY PARK ELEM. | Regular School | No | 1 | PK | 05 | 2016 | k_12_total | 282 | 99 | 31 | * | 16 | * | 27 | 36 | 213 | 51 | 456 | 282 | 99 | 31 | 16 | 27 | 36 | 213 | 51 | 456 | ||||||||||||||||||||||||||||||||||
3309673 | 3309673 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928003276 | 4970 | NAHED CHAPMAN NEW AMERICAN ACA | Regular School | No | 1 | KG | 08 | 2016 | k_12_total | 27 | 99 | 42 | * | 28 | * | * | * | * | * | 196 | 27 | 99 | 42 | 28 | 196 | ||||||||||||||||||||||||||||||||||||||
3297626 | 3297626 | MO | school | 2927060 | 11082 | ST. JOSEPH | 292706001660 | 1080 | LAFAYETTE HIGH | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 612 | 99 | 51 | * | * | 5 | 37 | 12 | 465 | 124 | 809 | 612 | 99 | 51 | 5 | 37 | 12 | 465 | 124 | 809 | ||||||||||||||||||||||||||||||||||
3307530 | 3307530 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001376 | 4030 | BELLERIVE ELEM. | Regular School | No | Elementary | PK | 05 | 2017 | k_12_total | 196 | 99 | 14 | * | 52 | * | 24 | 25 | 94 | 95 | 386 | 196 | 99 | 14 | 52 | 24 | 25 | 94 | 95 | 386 | ||||||||||||||||||||||||||||||||||
3302002 | 3302002 | MO | school | 2915480 | 48077 | INDEPENDENCE 30 | 291548002339 | 3000 | BINGHAM MIDDLE | Regular School | No | Middle | 07 | 08 | 2018 | k_12_total | 481 | 99 | 126 | 7 | 8 | 12 | 63 | 24 | 601 | 105 | 796 | 481 | 99 | 126 | 7 | 8 | 12 | 63 | 24 | 601 | 105 | 796 | ||||||||||||||||||||||||||||||||
3304588 | 3304588 | MO | school | 2900004 | 72074 | NEW MADRID CO. R-I | 290000401488 | 1060 | CENTRAL HIGH | Regular School | No | High | 09 | 12 | 2018 | k_12_total | 244 | 99 | 10 | * | * | * | 10 | * | 212 | 60 | 363 | 244 | 99 | 10 | 10 | 212 | 60 | 363 | ||||||||||||||||||||||||||||||||||||
3310020 | 3310020 | MO | school | 2900605 | 115923 | EAGLE COLLEGE PREP ENDEAVOR | 290060503304 | 6998 | EAGLE GRAVOIS PARK | Regular School | Yes | Elementary | KG | 04 | 2018 | k_12_total | * | 99 | * | * | * | * | 7 | * | * | 10 | 112 | 99 | 7 | 10 | 112 | |||||||||||||||||||||||||||||||||||||||
3308437 | 3308437 | MO | school | 2928260 | 100063 | SIKESTON R-6 | 292826001738 | 4020 | SIKESTON KINDERGARTEN CTR. | Regular School | No | Elementary | PK | KG | 2019 | k_12_total | 148 | 99 | 12 | * | * | * | 33 | * | * | 30 | 294 | 148 | 99 | 12 | 33 | 30 | 294 | |||||||||||||||||||||||||||||||||||||
3309760 | 3309760 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928001986 | 5600 | OAK HILL ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | 50 | 99 | 42 | * | 29 | * | * | 110 | * | 29 | 220 | 50 | 99 | 42 | 29 | 110 | 29 | 220 | ||||||||||||||||||||||||||||||||||||
3304590 | 3304590 | MO | school | 2900004 | 72074 | NEW MADRID CO. R-I | 290000401488 | 1060 | CENTRAL HIGH | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 245 | 99 | 15 | * | * | * | 12 | * | * | 62 | 371 | 245 | 99 | 15 | 12 | 62 | 371 | |||||||||||||||||||||||||||||||||||||
3307265 | 3307265 | MO | school | 2916770 | 96092 | KIRKWOOD R-VII | 291677000923 | 3000 | NIPHER MIDDLE | Regular School | No | Middle | 06 | 08 | 2020 | k_12_total | 542 | 99 | 31 | * | 13 | * | 41 | * | 106 | 98 | 728 | 542 | 99 | 31 | 13 | 41 | 106 | 98 | 728 | |||||||||||||||||||||||||||||||||||
3309425 | 3309425 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928001926 | 1222 | COMMUNITY ACCESS JOB TRAINING | Regular School | No | High | 08 | 12 | 2020 | k_12_total | 14 | 99 | 8 | * | * | * | * | 14 | * | * | 124 | 14 | 99 | 8 | 14 | 124 | ||||||||||||||||||||||||||||||||||||||
3309761 | 3309761 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928001986 | 5600 | OAK HILL ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | k_12_total | 46 | 99 | 35 | * | 18 | * | * | 102 | * | 23 | 198 | 46 | 99 | 35 | 18 | 102 | 23 | 198 | ||||||||||||||||||||||||||||||||||||
3305440 | 3305440 | MO | school | 2923550 | 83005 | PARK HILL | 292355001373 | 4020 | THOMAS B. CHINN ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 282 | 98 | 56 | * | 19 | 8 | 22 | 67 | 204 | 52 | 488 | 282 | 98 | 56 | 19 | 8 | 22 | 67 | 204 | 52 | 488 | |||||||||||||||||||||||||||||||||
3307308 | 3307308 | MO | school | 2918690 | 96093 | LINDBERGH SCHOOLS | 291869001026 | 1050 | LINDBERGH SR. HIGH | Regular School | No | 3 | 09 | 12 | 2015 | k_12_total | 1763 | 98 | 43 | 6 | 75 | 5 | 31 | 24 | 286.2 | 233 | 2021 | 1763 | 98 | 43 | 6 | 75 | 5 | 31 | 24 | 233 | 2021 | |||||||||||||||||||||||||||||||||
3306041 | 3306041 | MO | school | 2908370 | 92087 | FT. ZUMWALT R-II | 290837001539 | 3050 | DR. BERNARD J. DUBRAY MIDDLE | Regular School | No | 2 | 06 | 08 | 2016 | k_12_total | 643 | 98 | 49 | * | 20 | * | 39 | 14 | 242 | 165 | 850 | 643 | 98 | 49 | 20 | 39 | 14 | 242 | 165 | 850 | ||||||||||||||||||||||||||||||||||
3299296 | 3299296 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001291 | 4560 | TOPPING ELEM. | Regular School | No | Elementary | PK | 05 | 2017 | k_12_total | 140 | 98 | 51 | * | 10 | * | 27 | 62 | 221 | 29 | 329 | 140 | 98 | 51 | 10 | 27 | 62 | 221 | 29 | 329 | ||||||||||||||||||||||||||||||||||
3304593 | 3304593 | MO | school | 2900004 | 72074 | NEW MADRID CO. R-I | 290000401991 | 3000 | CENTRAL MIDDLE | Regular School | No | Middle | 06 | 08 | 2017 | k_12_total | 205 | 98 | 8 | * | * | * | 8 | * | 228 | 80 | 319 | 205 | 98 | 8 | 8 | 228 | 80 | 319 | ||||||||||||||||||||||||||||||||||||
3307671 | 3307671 | MO | school | 2904500 | 96099 | BAYLESS | 290450000043 | 4020 | BAYLESS ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 545 | 98 | 38 | * | 97 | * | 34 | 255 | 534 | 133 | 812 | 545 | 98 | 38 | 97 | 34 | 255 | 534 | 133 | 812 | ||||||||||||||||||||||||||||||||||
3298987 | 3298987 | MO | school | 2911650 | 24089 | EXCELSIOR SPRINGS 40 | 291165000071 | 1080 | EXCELSIOR SPRINGS TECH. HIGH | Career and Technical School | No | High | 10 | 12 | 2019 | k_12_total | 57 | 98 | 10 | * | * | * | 12 | * | 156 | * | 178 | 57 | 98 | 10 | 12 | 156 | 178 | |||||||||||||||||||||||||||||||||||||
3299262 | 3299262 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001277 | 4380 | LINDEN WEST ELEM. | Regular School | No | Elementary | PK | 05 | 2019 | k_12_total | 229 | 98 | 94 | * | 9 | 14 | 58 | 62 | 321 | 50 | 503 | 229 | 98 | 94 | 9 | 14 | 58 | 62 | 321 | 50 | 503 | |||||||||||||||||||||||||||||||||
3306033 | 3306033 | MO | school | 2908370 | 92087 | FT. ZUMWALT R-II | 290837002624 | 1090 | FT. ZUMWALT WEST HIGH | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 1524 | 98 | 119 | * | 71 | * | 99 | 40 | 282.3 | 233 | 1914 | 1524 | 98 | 119 | 71 | 99 | 40 | 233 | 1914 | |||||||||||||||||||||||||||||||||||
3307742 | 3307742 | MO | school | 2913620 | 96103 | HANCOCK PLACE | 291362000583 | 1050 | HANCOCK SR. HIGH | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 249 | 98 | 38 | * | 5 | * | 42 | 13 | * | 61 | 433 | 249 | 98 | 38 | 5 | 42 | 13 | 61 | 433 | |||||||||||||||||||||||||||||||||||
3308438 | 3308438 | MO | school | 2928260 | 100063 | SIKESTON R-6 | 292826001738 | 4020 | SIKESTON KINDERGARTEN CTR. | Regular School | No | Elementary | PK | KG | 2020 | k_12_total | 148 | 98 | 8 | * | * | * | 18 | * | * | 30 | 272 | 148 | 98 | 8 | 18 | 30 | 272 | |||||||||||||||||||||||||||||||||||||
3309585 | 3309585 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928001903 | 4360 | CLAY ELEM. | Regular School | No | Elementary | PK | 05 | 2020 | k_12_total | * | 98 | * | * | * | * | * | * | * | 16 | 101 | 98 | 16 | 101 | ||||||||||||||||||||||||||||||||||||||||
3306873 | 3306873 | MO | school | 2912010 | 96089 | FERGUSON-FLORISSANT R-II | 291201000472 | 1050 | MCCLUER HIGH | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 77 | 970 | 25 | * | 8 | * | 32 | 19 | * | 216 | 1112 | 77 | 970 | 25 | 8 | 32 | 19 | 216 | 1112 | |||||||||||||||||||||||||||||||||||
3306874 | 3306874 | MO | school | 2912010 | 96089 | FERGUSON-FLORISSANT R-II | 291201000472 | 1050 | MCCLUER HIGH | Regular School | No | High | 09 | 12 | 2018 | k_12_total | 57 | 970 | 25 | * | 6 | * | 27 | 17 | * | 193 | 1086 | 57 | 970 | 25 | 6 | 27 | 17 | 193 | 1086 | |||||||||||||||||||||||||||||||||||
3305371 | 3305371 | MO | school | 2925230 | 83003 | PLATTE CO. R-III | 292523001456 | 1050 | PLATTE COUNTY HIGH | Regular School | No | 3 | 09 | 12 | 2015 | k_12_total | 900 | 97 | 62 | * | 17 | * | 23 | 8 | 164.1 | 88 | 1104 | 900 | 97 | 62 | 17 | 23 | 8 | 88 | 1104 | |||||||||||||||||||||||||||||||||||
3306022 | 3306022 | MO | school | 2908370 | 92087 | FT. ZUMWALT R-II | 290837002978 | 1080 | FT. ZUMWALT EAST HIGH | Regular School | No | 3 | 09 | 12 | 2015 | k_12_total | 1058 | 97 | 45 | 5 | 17 | * | 50 | 5 | 300 | 179 | 1273 | 1058 | 97 | 45 | 5 | 17 | 50 | 5 | 300 | 179 | 1273 | |||||||||||||||||||||||||||||||||
3306811 | 3306811 | MO | school | 2913830 | 96088 | HAZELWOOD | 291383000634 | 4240 | RUSSELL ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 255 | 97 | 17 | * | 7 | * | 18 | 31 | 156 | 53 | 395 | 255 | 97 | 17 | 7 | 18 | 31 | 156 | 53 | 395 | ||||||||||||||||||||||||||||||||||
3297402 | 3297402 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000304 | 2050 | JEFFERSON MIDDLE SCHOOL | Regular School | No | 2 | 06 | 08 | 2016 | k_12_total | 311 | 97 | 52 | * | 45 | * | 33 | 45 | 211 | 40 | 543 | 311 | 97 | 52 | 45 | 33 | 45 | 211 | 40 | 543 | ||||||||||||||||||||||||||||||||||
3299259 | 3299259 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001277 | 4380 | LINDEN WEST ELEM. | Regular School | No | 1 | PK | 05 | 2016 | k_12_total | 257 | 97 | 80 | 5 | 11 | 21 | 35 | 73 | 345 | 39 | 506 | 257 | 97 | 80 | 5 | 11 | 21 | 35 | 73 | 345 | 39 | 506 | ||||||||||||||||||||||||||||||||
3307267 | 3307267 | MO | school | 2916770 | 96092 | KIRKWOOD R-VII | 291677000925 | 3025 | NORTH KIRKWOOD MIDDLE | Regular School | No | 2 | 06 | 08 | 2016 | k_12_total | 500 | 97 | 18 | * | 9 | * | 29 | * | 76 | 94 | 656 | 500 | 97 | 18 | 9 | 29 | 76 | 94 | 656 | |||||||||||||||||||||||||||||||||||
3308207 | 3308207 | MO | school | 2926760 | 96119 | SPECL. SCH. DST. ST. LOUIS CO. | 292676001588 | 4029 | ACKERMAN SCH. | Regular School | No | 1 | KG | 08 | 2016 | k_12_total | 35 | 97 | * | * | * | * | * | * | 123 | * | 138 | 35 | 97 | 123 | 138 | |||||||||||||||||||||||||||||||||||||||
3309817 | 3309817 | MO | school | 2929280 | 115115 | ST. LOUIS CITY | 292928002646 | 6030 | WILKINSON EARLY CHILDHOOD CTR. | Regular School | No | 1 | PK | 02 | 2016 | k_12_total | 57 | 97 | * | * | * | * | * | * | * | 38 | 161 | 57 | 97 | 38 | 161 | |||||||||||||||||||||||||||||||||||||||
3301628 | 3301628 | MO | school | 2918300 | 48071 | LEE'S SUMMIT R-VII | 291830000982 | 3080 | PLEASANT LEA MIDDLE | Regular School | No | Middle | 07 | 08 | 2017 | k_12_total | 647 | 97 | 49 | * | 27 | * | 51 | 27 | 233 | 105 | 878 | 647 | 97 | 49 | 27 | 51 | 27 | 233 | 105 | 878 | ||||||||||||||||||||||||||||||||||
3306042 | 3306042 | MO | school | 2908370 | 92087 | FT. ZUMWALT R-II | 290837001539 | 3050 | DR. BERNARD J. DUBRAY MIDDLE | Regular School | No | Middle | 06 | 08 | 2017 | k_12_total | 662 | 97 | 51 | * | 27 | * | 34 | 19 | 268 | 165 | 872 | 662 | 97 | 51 | 27 | 34 | 19 | 268 | 165 | 872 | ||||||||||||||||||||||||||||||||||
3307846 | 3307846 | MO | school | 2920010 | 96107 | MAPLEWOOD-RICHMOND HEIGHTS | 292001001067 | 1050 | MAPLEWOOD-RICHMOND HGTS. HIGH | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 178 | 97 | 16 | * | 6 | * | 15 | * | 119 | 48 | 314 | 178 | 97 | 16 | 6 | 15 | 119 | 48 | 314 | |||||||||||||||||||||||||||||||||||
3309896 | 3309896 | MO | school | 2900585 | 115911 | CITY GARDEN MONTESSORI | 290058503101 | 6955 | CITY GARDEN MONTESSORI SCHOOL | Regular School | Yes | Elementary | PK | 08 | 2017 | k_12_total | 114 | 97 | 11 | * | * | * | 7 | * | 97 | 32 | 231 | 114 | 97 | 11 | 7 | 97 | 32 | 231 | ||||||||||||||||||||||||||||||||||||
3309902 | 3309902 | MO | school | 2900586 | 115912 | ST. LOUIS LANG IMMERSION SCH | 290058603126 | 6960 | THE FRENCH SCHOOL | Regular School | Yes | Elementary | KG | 05 | 2017 | k_12_total | 63 | 97 | 6 | * | * | * | 7 | 6 | 110 | 26 | 174 | 63 | 97 | 6 | 7 | 6 | 110 | 26 | 174 | |||||||||||||||||||||||||||||||||||
3309976 | 3309976 | MO | school | 2900592 | 115916 | GATEWAY SCIENCE ACAD/ST LOUIS | 290059203241 | 6997 | GATEWAY SCIENCE ACAD-SOUTH ELE | Regular School | Yes | Elementary | KG | 05 | 2017 | k_12_total | 231 | 97 | 23 | * | 8 | * | 40 | 63 | 266 | 43 | 400 | 231 | 97 | 23 | 8 | 40 | 63 | 266 | 43 | 400 | ||||||||||||||||||||||||||||||||||
3299175 | 3299175 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001282 | 3180 | NEW MARK MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 885 | 97 | 122 | * | 26 | * | 103 | 14 | 276 | 93 | 1237 | 885 | 97 | 122 | 26 | 103 | 14 | 276 | 93 | 1237 | ||||||||||||||||||||||||||||||||||
3302020 | 3302020 | MO | school | 2915480 | 48077 | INDEPENDENCE 30 | 291548002807 | 3070 | PIONEER RIDGE MIDDLE | Regular School | No | Middle | 07 | 08 | 2018 | k_12_total | 458 | 97 | 144 | * | 11 | 8 | 51 | 39 | 424 | 83 | 770 | 458 | 97 | 144 | 11 | 8 | 51 | 39 | 424 | 83 | 770 | |||||||||||||||||||||||||||||||||
3302207 | 3302207 | MO | school | 2916400 | 48078 | KANSAS CITY 33 | 291640003257 | 4270 | HALE COOK ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 141 | 97 | 20 | * | * | * | 18 | 11 | * | 30 | 280 | 141 | 97 | 20 | 18 | 11 | 30 | 280 | ||||||||||||||||||||||||||||||||||||
3305374 | 3305374 | MO | school | 2925230 | 83003 | PLATTE CO. R-III | 292523001456 | 1050 | PLATTE COUNTY HIGH | Regular School | No | High | 09 | 12 | 2018 | k_12_total | 970 | 97 | 76 | * | 22 | 8 | 32 | 21 | 221 | 89 | 1206 | 970 | 97 | 76 | 22 | 8 | 32 | 21 | 221 | 89 | 1206 | |||||||||||||||||||||||||||||||||
3309977 | 3309977 | MO | school | 2900592 | 115916 | GATEWAY SCIENCE ACAD/ST LOUIS | 290059203241 | 6997 | GATEWAY SCIENCE ACAD-SOUTH ELE | Regular School | Yes | Elementary | KG | 05 | 2018 | k_12_total | 248 | 97 | 29 | * | 11 | * | 37 | 79 | 283 | 47 | 423 | 248 | 97 | 29 | 11 | 37 | 79 | 283 | 47 | 423 | ||||||||||||||||||||||||||||||||||
3302003 | 3302003 | MO | school | 2915480 | 48077 | INDEPENDENCE 30 | 291548002339 | 3000 | BINGHAM MIDDLE | Regular School | No | Middle | 07 | 08 | 2019 | k_12_total | 482 | 97 | 134 | 9 | 7 | 9 | 86 | 39 | 611 | 122 | 824 | 482 | 97 | 134 | 9 | 7 | 9 | 86 | 39 | 611 | 122 | 824 | ||||||||||||||||||||||||||||||||
3302566 | 3302566 | MO | school | 2900593 | 48923 | DELASALLE CHARTER SCHOOL | 290059303176 | 1970 | DeLaSalle Charter High School | Regular School | Yes | High | 09 | 12 | 2019 | k_12_total | 6 | 97 | 9 | * | * | * | * | * | * | 11 | 113 | 6 | 97 | 9 | 11 | 113 | ||||||||||||||||||||||||||||||||||||||
3306405 | 3306405 | MO | school | 2928920 | 92090 | ST. CHARLES R-VI | 292892001850 | 3000 | HARDIN MIDDLE | Regular School | No | Middle | 07 | 08 | 2019 | k_12_total | 465 | 97 | 70 | * | 13 | * | 29 | 38 | 292 | 123 | 678 | 465 | 97 | 70 | 13 | 29 | 38 | 292 | 123 | 678 | ||||||||||||||||||||||||||||||||||
3310000 | 3310000 | MO | school | 2900600 | 115920 | ST. LOUIS COLLEGE PREP | 290060003178 | 3925 | St. Louis College Prep Middle | Regular School | Yes | Middle | 06 | 08 | 2019 | k_12_total | 5 | 97 | * | * | * | * | * | * | * | 13 | 104 | 5 | 97 | 13 | 104 | |||||||||||||||||||||||||||||||||||||||
3307079 | 3307079 | MO | school | 2926850 | 96091 | ROCKWOOD R-VI | 292685001621 | 1050 | EUREKA SR. HIGH | Regular School | No | High | 09 | 12 | 2020 | k_12_total | 1516 | 97 | 55 | * | 42 | * | 35 | 5 | 171 | 283 | 1752 | 1516 | 97 | 55 | 42 | 35 | 5 | 171 | 283 | 1752 | ||||||||||||||||||||||||||||||||||
3298377 | 3298377 | MO | school | 2923730 | 19142 | RAYMORE-PECULIAR R-II | 292373000088 | 3000 | RAYMORE-PECULIAR EAST MIDDLE | Regular School | No | 2 | 07 | 08 | 2015 | k_12_total | 793 | 96 | 36 | * | 14 | * | 27 | * | 267 | 87 | 971 | 793 | 96 | 36 | 14 | 27 | 267 | 87 | 971 | |||||||||||||||||||||||||||||||||||
3301470 | 3301470 | MO | school | 2905310 | 48068 | BLUE SPRINGS R-IV | 290531000078 | 4080 | CORDILL-MASON ELEM. | Regular School | No | 1 | PK | 05 | 2015 | k_12_total | 568 | 96 | 28 | * | 13 | * | 11 | * | 204.1 | 43 | 720 | 568 | 96 | 28 | 13 | 11 | 43 | 720 | ||||||||||||||||||||||||||||||||||||
3307708 | 3307708 | MO | school | 2909720 | 96102 | CLAYTON | 290972002584 | 3000 | WYDOWN MIDDLE | Regular School | No | 2 | 06 | 08 | 2016 | k_12_total | 435 | 96 | 31 | * | 66 | * | 19 | 12 | 92 | 64 | 648 | 435 | 96 | 31 | 66 | 19 | 12 | 92 | 64 | 648 | ||||||||||||||||||||||||||||||||||
3308452 | 3308452 | MO | school | 2928260 | 100063 | SIKESTON R-6 | 292826001742 | 4070 | SOUTHEAST ELEM. | Regular School | No | 1 | 01 | 04 | 2016 | k_12_total | 190 | 96 | 13 | * | 6 | * | 16 | * | 247 | 42 | 322 | 190 | 96 | 13 | 6 | 16 | 247 | 42 | 322 | |||||||||||||||||||||||||||||||||||
3299260 | 3299260 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001277 | 4380 | LINDEN WEST ELEM. | Regular School | No | Elementary | PK | 05 | 2017 | k_12_total | 241 | 96 | 72 | 6 | 12 | 15 | 34 | 71 | 332 | 34 | 476 | 241 | 96 | 72 | 6 | 12 | 15 | 34 | 71 | 332 | 34 | 476 | ||||||||||||||||||||||||||||||||
3302013 | 3302013 | MO | school | 2915480 | 48077 | INDEPENDENCE 30 | 291548003090 | 3060 | CLIFFORD H. NOWLIN MIDDLE | Regular School | No | Middle | 06 | 08 | 2017 | k_12_total | 423 | 96 | 259 | * | * | 6 | 64 | 86 | 715 | 112 | 851 | 423 | 96 | 259 | 6 | 64 | 86 | 715 | 112 | 851 | ||||||||||||||||||||||||||||||||||
3306012 | 3306012 | MO | school | 2908370 | 92087 | FT. ZUMWALT R-II | 290837000239 | 1050 | FT. ZUMWALT NORTH HIGH | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 1286 | 96 | 52 | * | 18 | * | 48 | 15 | 251 | 224 | 1504 | 1286 | 96 | 52 | 18 | 48 | 15 | 251 | 224 | 1504 | ||||||||||||||||||||||||||||||||||
3306397 | 3306397 | MO | school | 2928920 | 92090 | ST. CHARLES R-VI | 292892001851 | 1075 | ST. CHARLES WEST HIGH | Regular School | No | High | 09 | 12 | 2017 | k_12_total | 528 | 96 | 27 | * | 13 | * | 9 | 11 | 180 | 99 | 674 | 528 | 96 | 27 | 13 | 9 | 11 | 180 | 99 | 674 | ||||||||||||||||||||||||||||||||||
3307709 | 3307709 | MO | school | 2909720 | 96102 | CLAYTON | 290972002584 | 3000 | WYDOWN MIDDLE | Regular School | No | Middle | 06 | 08 | 2017 | k_12_total | 435 | 96 | 27 | * | 71 | * | 23 | 8 | 77 | 73 | 653 | 435 | 96 | 27 | 71 | 23 | 8 | 77 | 73 | 653 | ||||||||||||||||||||||||||||||||||
3297404 | 3297404 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000304 | 2050 | JEFFERSON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 403 | 96 | 47 | * | 31 | * | 37 | 33 | 252 | 53 | 617 | 403 | 96 | 47 | 31 | 37 | 33 | 252 | 53 | 617 | ||||||||||||||||||||||||||||||||||
3299156 | 3299156 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001258 | 3000 | ANTIOCH MIDDLE | Regular School | No | Middle | 07 | 08 | 2019 | k_12_total | 530 | 96 | 133 | * | 17 | 14 | 85 | 16 | 417 | 94 | 876 | 530 | 96 | 133 | 17 | 14 | 85 | 16 | 417 | 94 | 876 | |||||||||||||||||||||||||||||||||
3302542 | 3302542 | MO | school | 2900590 | 48922 | FRONTIER SCHOOLS | 290059003232 | 1985 | FRONTIER STEM HIGH SCHOOL | Regular School | Yes | High | 09 | 12 | 2019 | k_12_total | 23 | 96 | 221 | * | 5 | * | * | 98 | * | 16 | 345 | 23 | 96 | 221 | 5 | 98 | 16 | 345 | ||||||||||||||||||||||||||||||||||||
3302537 | 3302537 | MO | school | 2900590 | 48922 | FRONTIER SCHOOLS | 290059003181 | 1920 | FRONTIER SCHL OF EXCELLENCE-U | Regular School | Yes | High | 09 | 12 | 2020 | k_12_total | 5 | 96 | 73 | * | * | * | * | 52 | * | 23 | 175 | 5 | 96 | 73 | 52 | 23 | 175 | |||||||||||||||||||||||||||||||||||||
3297514 | 3297514 | MO | school | 2901000 | 10093 | COLUMBIA 93 | 290100000307 | 5040 | PARKADE ELEM. | Regular School | No | 1 | PK | 05 | 2015 | k_12_total | 228 | 95 | 26 | * | 8 | * | 45 | 8 | 253 | 58 | 407 | 228 | 95 | 26 | 8 | 45 | 8 | 253 | 58 | 407 | ||||||||||||||||||||||||||||||||||
3307528 | 3307528 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001376 | 4030 | BELLERIVE ELEM. | Regular School | No | 1 | KG | 05 | 2015 | k_12_total | 181 | 95 | 21 | * | 59 | * | 16 | 32 | 94 | 91 | 373 | 181 | 95 | 21 | 59 | 16 | 32 | 94 | 91 | 373 | ||||||||||||||||||||||||||||||||||
3302599 | 3302599 | MO | school | 2900604 | 48927 | ACADEMY FOR INTEGRATED ARTS | 290060403209 | 6995 | ACADEMY FOR INTEGRATED ARTS | Regular School | Yes | 1 | KG | 05 | 2016 | k_12_total | 10 | 95 | * | * | * | * | 11 | * | 111 | 10 | 120 | 10 | 95 | 11 | 111 | 10 | 120 | |||||||||||||||||||||||||||||||||||||
3307670 | 3307670 | MO | school | 2904500 | 96099 | BAYLESS | 290450000043 | 4020 | BAYLESS ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2017 | k_12_total | 561 | 95 | 32 | * | 96 | * | 30 | 243 | 510 | 132 | 814 | 561 | 95 | 32 | 96 | 30 | 243 | 510 | 132 | 814 | ||||||||||||||||||||||||||||||||||
3301423 | 3301423 | MO | school | 2905310 | 48068 | BLUE SPRINGS R-IV | 290531001706 | 3060 | MORELAND RIDGE MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 742 | 95 | 57 | 5 | 16 | * | 74 | * | 309 | 122 | 993 | 742 | 95 | 57 | 5 | 16 | 74 | 309 | 122 | 993 | ||||||||||||||||||||||||||||||||||
3302559 | 3302559 | MO | school | 2900590 | 48922 | FRONTIER SCHOOLS | 290059003127 | 6975 | FRONTIER SCHOOL OF INNOVATION | Regular School | Yes | Elementary | KG | 05 | 2018 | k_12_total | 53 | 95 | 528 | * | 11 | * | * | 473 | * | 38 | 687 | 53 | 95 | 528 | 11 | 473 | 38 | 687 | ||||||||||||||||||||||||||||||||||||
3307710 | 3307710 | MO | school | 2909720 | 96102 | CLAYTON | 290972002584 | 3000 | WYDOWN MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 428 | 95 | 26 | * | 81 | * | 26 | 10 | 63 | 85 | 657 | 428 | 95 | 26 | 81 | 26 | 10 | 63 | 85 | 657 | ||||||||||||||||||||||||||||||||||
3304589 | 3304589 | MO | school | 2900004 | 72074 | NEW MADRID CO. R-I | 290000401488 | 1060 | CENTRAL HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 243 | 95 | 18 | * | * | * | 14 | 5 | * | 56 | 370 | 243 | 95 | 18 | 14 | 5 | 56 | 370 | ||||||||||||||||||||||||||||||||||||
3307264 | 3307264 | MO | school | 2916770 | 96092 | KIRKWOOD R-VII | 291677000923 | 3000 | NIPHER MIDDLE | Regular School | No | Middle | 06 | 08 | 2019 | k_12_total | 503 | 95 | 27 | * | 12 | * | 42 | 5 | 103 | 98 | 681 | 503 | 95 | 27 | 12 | 42 | 5 | 103 | 98 | 681 | ||||||||||||||||||||||||||||||||||
3308120 | 3308120 | MO | school | 2931530 | 96114 | WEBSTER GROVES | 293153002194 | 3000 | HIXSON MIDDLE | Regular School | No | Middle | 07 | 08 | 2019 | k_12_total | 533 | 95 | 24 | 5 | 12 | * | 35 | * | 103 | 85 | 704 | 533 | 95 | 24 | 5 | 12 | 35 | 103 | 85 | 704 | ||||||||||||||||||||||||||||||||||
3309898 | 3309898 | MO | school | 2900585 | 115911 | CITY GARDEN MONTESSORI | 290058503101 | 6955 | CITY GARDEN MONTESSORI SCHOOL | Regular School | Yes | Elementary | PK | 08 | 2019 | k_12_total | 109 | 95 | 12 | * | * | * | 7 | * | 85 | 30 | 227 | 109 | 95 | 12 | 7 | 85 | 30 | 227 | ||||||||||||||||||||||||||||||||||||
3306875 | 3306875 | MO | school | 2912010 | 96089 | FERGUSON-FLORISSANT R-II | 291201000472 | 1050 | MCCLUER HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 46 | 940 | 35 | * | * | * | 24 | 19 | * | 191 | 1049 | 46 | 940 | 35 | 24 | 19 | 191 | 1049 | ||||||||||||||||||||||||||||||||||||
3298553 | 3298553 | MO | school | 2904620 | 19152 | BELTON 124 | 290462003025 | 1055 | BELTON MIDDLE SCHOOL/FC | Regular School | No | 2 | 07 | 09 | 2015 | k_12_total | 802 | 94 | 134 | * | 5 | 5 | 45 | 30 | 555 | 145 | 1088 | 802 | 94 | 134 | 5 | 5 | 45 | 30 | 555 | 145 | 1088 | |||||||||||||||||||||||||||||||||
3302017 | 3302017 | MO | school | 2915480 | 48077 | INDEPENDENCE 30 | 291548002807 | 3070 | PIONEER RIDGE MIDDLE | Regular School | No | 2 | 07 | 08 | 2015 | k_12_total | 486 | 94 | 126 | * | 18 | 7 | 48 | 39 | 443 | 69 | 782 | 486 | 94 | 126 | 18 | 7 | 48 | 39 | 443 | 69 | 782 | |||||||||||||||||||||||||||||||||
3304561 | 3304561 | MO | school | 2900003 | 72068 | PORTAGEVILLE | 290000302458 | 1050 | PORTAGEVILLE HIGH | Regular School | No | 4 | 06 | 12 | 2015 | k_12_total | 292 | 94 | * | * | * | * | 5 | * | 235 | 49 | 397 | 292 | 94 | 5 | 235 | 49 | 397 | |||||||||||||||||||||||||||||||||||||
3307122 | 3307122 | MO | school | 2926850 | 96091 | ROCKWOOD R-VI | 292685000706 | 3060 | ROCKWOOD SOUTH MIDDLE | Regular School | No | 2 | 06 | 08 | 2015 | k_12_total | 745 | 94 | 29 | * | 44 | * | 15 | 7 | 168 | 146 | 929 | 745 | 94 | 29 | 44 | 15 | 7 | 168 | 146 | 929 | ||||||||||||||||||||||||||||||||||
3301433 | 3301433 | MO | school | 2905310 | 48068 | BLUE SPRINGS R-IV | 290531002835 | 3090 | PAUL KINDER MIDDLE SCHOOL | Regular School | No | 2 | 06 | 08 | 2016 | k_12_total | 563 | 94 | 42 | * | 12 | * | 42 | * | 276 | 81 | 760 | 563 | 94 | 42 | 12 | 42 | 276 | 81 | 760 | |||||||||||||||||||||||||||||||||||
3305047 | 3305047 | MO | school | 2907470 | 78012 | CARUTHERSVILLE 18 | 290747001023 | 3000 | CARUTHERSVILLE MIDDLE | Regular School | No | 2 | 06 | 08 | 2016 | k_12_total | 115 | 94 | 5 | * | * | * | 5 | * | * | 32 | 219 | 115 | 94 | 5 | 5 | 32 | 219 | |||||||||||||||||||||||||||||||||||||
3306402 | 3306402 | MO | school | 2928920 | 92090 | ST. CHARLES R-VI | 292892001850 | 3000 | HARDIN MIDDLE | Regular School | No | 2 | 07 | 08 | 2016 | k_12_total | 556 | 94 | 30 | * | 14 | * | 5 | 29 | 309 | 122 | 702 | 556 | 94 | 30 | 14 | 5 | 29 | 309 | 122 | 702 | ||||||||||||||||||||||||||||||||||
3307261 | 3307261 | MO | school | 2916770 | 96092 | KIRKWOOD R-VII | 291677000923 | 3000 | NIPHER MIDDLE | Regular School | No | 2 | 06 | 08 | 2016 | k_12_total | 504 | 94 | 20 | * | 18 | * | 23 | 5 | 103 | 72 | 659 | 504 | 94 | 20 | 18 | 23 | 5 | 103 | 72 | 659 | ||||||||||||||||||||||||||||||||||
3307285 | 3307285 | MO | school | 2916770 | 96092 | KIRKWOOD R-VII | 291677000921 | 5060 | GEORGE R. ROBINSON ELEM. | Regular School | No | 1 | KG | 05 | 2016 | k_12_total | 344 | 94 | 13 | * | 8 | * | 32 | * | 126 | 64 | 491 | 344 | 94 | 13 | 8 | 32 | 126 | 64 | 491 | |||||||||||||||||||||||||||||||||||
3300589 | 3300589 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001813 | 3100 | PIPKIN MIDDLE | Regular School | No | Middle | 06 | 08 | 2017 | k_12_total | 392 | 94 | 43 | * | 6 | * | 23 | 9 | 426 | 56 | 563 | 392 | 94 | 43 | 6 | 23 | 9 | 426 | 56 | 563 | ||||||||||||||||||||||||||||||||||
3302482 | 3302482 | MO | school | 2900013 | 48912 | DELLA LAMB ELEM. | 290001303275 | 6931 | DELLA LAMB @ WOODLAND | Regular School | Yes | Elementary | KG | 01 | 2017 | k_12_total | 11 | 94 | 17 | * | 8 | * | * | 87 | * | * | 132 | 11 | 94 | 17 | 8 | 87 | 132 | |||||||||||||||||||||||||||||||||||||
3305391 | 3305391 | MO | school | 2925230 | 83003 | PLATTE CO. R-III | 292523003086 | 4020 | PATHFINDER ELEM. | Regular School | No | Elementary | PK | 04 | 2017 | k_12_total | 357 | 94 | 68 | * | 23 | 7 | 39 | 40 | 173 | 41 | 591 | 357 | 94 | 68 | 23 | 7 | 39 | 40 | 173 | 41 | 591 | |||||||||||||||||||||||||||||||||
3299155 | 3299155 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001258 | 3000 | ANTIOCH MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | k_12_total | 600 | 94 | 139 | * | 25 | 13 | 87 | 14 | 458 | 99 | 959 | 600 | 94 | 139 | 25 | 13 | 87 | 14 | 458 | 99 | 959 | |||||||||||||||||||||||||||||||||
3299261 | 3299261 | MO | school | 2922800 | 24093 | NORTH KANSAS CITY 74 | 292280001277 | 4380 | LINDEN WEST ELEM. | Regular School | No | Elementary | PK | 05 | 2018 | k_12_total | 234 | 94 | 79 | * | 7 | 22 | 58 | 65 | 320 | 36 | 495 | 234 | 94 | 79 | 7 | 22 | 58 | 65 | 320 | 36 | 495 | |||||||||||||||||||||||||||||||||
3301352 | 3301352 | MO | school | 2912290 | 48066 | FORT OSAGE R-I | 291229000496 | 1050 | FORT OSAGE HIGH | Regular School | No | High | 09 | 12 | 2018 | k_12_total | 1154 | 94 | 136 | 11 | 22 | 24 | 40 | 13 | 695 | 159 | 1481 | 1154 | 94 | 136 | 11 | 22 | 24 | 40 | 13 | 695 | 159 | 1481 | ||||||||||||||||||||||||||||||||
3307531 | 3307531 | MO | school | 2923580 | 96095 | PARKWAY C-2 | 292358001376 | 4030 | BELLERIVE ELEM. | Regular School | No | Elementary | KG | 05 | 2018 | k_12_total | 197 | 94 | 13 | * | 49 | * | 24 | 21 | 91 | 92 | 379 | 197 | 94 | 13 | 49 | 24 | 21 | 91 | 92 | 379 | ||||||||||||||||||||||||||||||||||
3300549 | 3300549 | MO | school | 2928860 | 39141 | SPRINGFIELD R-XII | 292886001804 | 1085 | KICKAPOO HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 1563 | 94 | 110 | 11 | 72 | 7 | 38 | 35 | 444 | 141 | 1895 | 1563 | 94 | 110 | 11 | 72 | 7 | 38 | 35 | 444 | 141 | 1895 | ||||||||||||||||||||||||||||||||
3302796 | 3302796 | MO | school | 2916350 | 49148 | JOPLIN SCHOOLS | 291635000787 | 1050 | JOPLIN HIGH | Regular School | No | High | 09 | 12 | 2019 | k_12_total | 1679 | 94 | 178 | 25 | 36 | 30 | 103 | 30 | 1055 | 349 | 2145 | 1679 | 94 | 178 | 25 | 36 | 30 | 103 | 30 | 1055 | 349 | 2145 |
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]);