enrollments

Data source: Big Local News · About: Big Local

16,123 rows where grade = "k_12_total" and state = "MO" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • k_12_total · 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
3069280 3069280 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069320 3069320 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No Other PK 12 2021   k_12_total                                                   0                                             0
3069338 3069338 MO     school 2906360 7129   BUTLER R-V 290636003308 7500 BUTLER EARLY CHILDHOOD   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069348 3069348 MO     school 2909900 8111   COLE CAMP R-I 290990003248 7500 COLE CAMP PRESCHOOL   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069410 3069410 MO     school 2901000 10093   COLUMBIA 93 290100003287 7500 CENTER FOR EARLY LRNING-NORTH   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069450 3069450 MO     school 2925450 12109   POPLAR BLUFF R-I 292545002769 7500 POPLAR BLUFF EARLY CHILDHOOD C   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069552 3069552 MO     school 2923730 19142   RAYMORE-PECULIAR R-II 292373003316 7500 SHULL EARLY LEARNING CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069562 3069562 MO     school 2913760 19149   HARRISONVILLE R-IX 291376002594 1015 EVERETT WADE JUVENILE CTR.   Alternative School No Other KG 12 2021   k_12_total                                                   0                                             0
3069579 3069579 MO     school 2904620 19152   BELTON 124 290462002725 7500 GRACE EARLY CHILD. & ED. CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069580 3069580 MO     school 2929520 20001   STOCKTON R-I 292952003351 1010 EXCEPTIONAL PUPIL COOP. - ECSE   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069584 3069584 MO     school 2929520 20001   STOCKTON R-I 292952003323 7500 LITTLE TIGER PRESCHOOL   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069600 3069600 MO     school 2922530 22089   Nixa Public Schools 292253003132 4030 EARLY LEARNING CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069608 3069608 MO     school 2922530 22089   Nixa Public Schools 292253003242 7500 EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069612 3069612 MO     school 2928740 22090   SPARTA R-III 292874003260 7500 SPARTA PK CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069632 3069632 MO     school 2916380 23101   CLARK CO. R-I 291638003254 7500 EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069641 3069641 MO     school 2916450 24086   KEARNEY R-I 291645003329 7500 KEARNEY EARLY EDUCATION CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069653 3069653 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165003352 7500 EXCELSIOR SPRINGS EAR CHLD CTR   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069671 3069671 MO     school 2918540 24090   LIBERTY 53 291854002615 7500 EARLY CHILD. EDUCATION CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069705 3069705 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280002662 7500 EARLY EDUCATION CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069739 3069739 MO     school 2916190 26006   JEFFERSON CITY 291619003121 7500 SOUTHWEST EARLY CHILDHOOD CTR   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069791 3069791 MO     school 2930600 32056   UNION STAR R-II 293060003376 7500 UNION STAR PRESCHOOL   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069824 3069824 MO     school 2916500 35102   KENNETT 39 291650002656 7500 EARLY CHILDHOOD CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069834 3069834 MO     school 2923460 36126   MERAMEC VALLEY R-III 292346002278 7540 DORIS HOFFMAN EARLY LEARNING C   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069843 3069843 MO     school 2929100 36136   ST. CLAIR R-XIII 292910002568 1010 FRANKLIN CO. SPECL. ED. COOP.   Special Education School No Other PK 12 2021   k_12_total                                                   0                                             0
3069864 3069864 MO     school 2931110 36139   WASHINGTON 293111002833 7500 EARLY LEARNING CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069895 3069895 MO     school 2926220 39134   REPUBLIC R-III 292622002733 7500 EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069904 3069904 MO     school 2929640 39137   STRAFFORD R-VI 292964003330 7500 COGDILL EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069928 3069928 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001785 4120 CAMPBELL ELEM.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069960 3069960 MO     school 2928860 39141   SPRINGFIELD R-XII 292886002905 7500 SHADY DELL EARLY CHILDHOOD CTR   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069961 3069961 MO     school 2928860 39141   SPRINGFIELD R-XII 292886003378 7520 ADAH FULBRIGHT EARLY CHILDHOOD   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069989 3069989 MO     school 2906480 42117   CALHOUN R-VIII 290648003284 7500 CALHOUN EARLY CHILDHOOD CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3069998 3069998 MO     school 2909860 42124   CLINTON 290986003291 7500 CLINTON EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070055 3070055 MO     school 2912290 48066   FORT OSAGE R-I 291229002310 7500 EARLY CHILDHOOD CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070082 3070082 MO     school 2913080 48069   GRAIN VALLEY R-V 291308003169 7500 GRAIN VALLEY EARLY CHILDHD CTR   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070112 3070112 MO     school 2918300 48071   LEE'S SUMMIT R-VII 291830002612 7500 GREAT BEGINNINGS EARLY ED CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070122 3070122 MO     school 2914340 48072   HICKMAN MILLS C-1 291434002979 7500 FREDA MARKLEY EARLY CHILDHOOD   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070138 3070138 MO     school 2926070 48073   RAYTOWN C-2 292607000945 7500 NEW TRAILS EARLY LEARNING CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070139 3070139 MO     school 2926070 48073   RAYTOWN C-2 292607003318 7510 THREE TRAILS PRESCHOOL   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070145 3070145 MO     school 2913140 48074   GRANDVIEW C-4 291314000552 5000 HIGH GROVE Early Childhood   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070177 3070177 MO     school 2915480 48077   INDEPENDENCE 30 291548001485 7500 HANTHORN EARLY EDUCATION   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070178 3070178 MO     school 2915480 48077   INDEPENDENCE 30 291548003157 7510 SUNSHINE CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070211 3070211 MO     school 2916400 48078   KANSAS CITY 33 291640000865 6030 CONTRACT   Regular School No Other PK 12 2021   k_12_total                                                   0                                             0
3070218 3070218 MO     school 2908250 48080   CENTER 58 290825002755 7500 YELLOW JACKET EARLY LEARNING   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070233 3070233 MO     school 2900025 48909   ALLEN VILLAGE 290002503379 7500 ALLEN VILLAGE PRESCHOOL   Regular School Yes Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070280 3070280 MO     school 2907460 49142   CARTHAGE R-IX 290746003243 7500 EARLY CHILDHOOD AND PAT CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070291 3070291 MO     school 2931500 49144   WEBB CITY R-VII 293150002377 7500 HERITAGE PRESCHOOL   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070307 3070307 MO     school 2916350 49148   JOPLIN SCHOOLS 291635002778 7500 JOPLIN EARLY CHILDHOOD CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070317 3070317 MO     school 2922890 50001   NORTHWEST R-I 292289003192 7500 HOUSE SPRINGS EARLY CHILD CTR   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070329 3070329 MO     school 2914250 50005   DUNKLIN R-V 291425003326 7500 TAYLOR EARLY CHILDHOOD   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070338 3070338 MO     school 2916230 50007   JEFFERSON CO. R-VII 291623003305 7500 JEFFERSON R-VII PRESCHOOL   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070362 3070362 MO     school 2912300 50012   FOX C-6 291230003028 7500 DON EARL EARLY CHILDHOOD CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070369 3070369 MO     school 2910500 50014   DESOTO 73 291050002993 7500 EARLY CHILDHOOD CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070456 3070456 MO     school 2930450 57003   TROY R-III 293045003347 7500 LINCOLN CO EARLY CHILDHOOD CTR   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070527 3070527 MO     school 2913650 64075   HANNIBAL 60 291365003307 7500 EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070544 3070544 MO     school 2927630 66105   SCHOOL OF THE OSAGE 292763003358 7500 EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070608 3070608 MO     school 2927900 73106   SENECA R-VII 292790003303 7500 SENECA EARLY CHILDHOOD SCHOOL   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070614 3070614 MO     school 2921810 73108   NEOSHO SCHOOL DISTRICT 292181001205 4060 FIELD EARLY CHILD./KDGN. CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070648 3070648 MO     school 2931830 76083   OSAGE CO. R-III 293183003348 7500 OSAGE CO. R-III PRESCHOOL   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070654 3070654 MO     school 2912600 77102   GAINESVILLE R-V 291260003373 7500 GAINESVILLE PRESCHOOL   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070674 3070674 MO     school 2923780 78013   PEMISCOT CO. SPEC. SCH. DIST. 292378002382 4020 OAK VIEW LEARNING CTR.   Regular School No Other PK 12 2021   k_12_total                                                   0                                             0
3070697 3070697 MO     school 2927830 80125   SEDALIA 200 292783002678 7500 EARLY CHILDHOOD CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070749 3070749 MO     school 2923550 83005   PARK HILL 292355003087 7500 GERNER FAMILY EARLY ED CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070756 3070756 MO     school 2911730 84002   FAIR PLAY R-II 291173003338 7500 LITTLE STINGERS PRESCHOOL   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070781 3070781 MO     school 2931440 85046   WAYNESVILLE R-VI 293144003332 7500 WILLIAMS EARLY CHILDHOOD CTR   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070807 3070807 MO     school 2921100 88081   MOBERLY 292110003386 7500 EARLY CHILDHOOD LEARNING CNTR   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070859 3070859 MO     school 2908370 92087   FT. ZUMWALT R-II 290837003315 7500 EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070878 3070878 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895000643 7500 EARLY CHILD FAMILY EDUC. CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070879 3070879 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002077 7520 EARLY CHILD. FAMILY EDUC CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070880 3070880 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002108 7530 EARLY CHILD. FAMILY EDUC. CTR   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070900 3070900 MO     school 2931650 92089   WENTZVILLE R-IV 293165003006 7500 EARLY CHILDHOOD CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070911 3070911 MO     school 2928920 92090   ST. CHARLES R-VI 292892003334 7500 ST.CHARLES EARLY CHILDHOOD CTR   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070916 3070916 MO     school 2923160 92091   ORCHARD FARM R-V 292316003290 7500 Early Learning Center   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070979 3070979 MO     school 2913830 96088   HAZELWOOD 291383003218 7500 CENTRAL EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070980 3070980 MO     school 2913830 96088   HAZELWOOD 291383003208 7510 EAST EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3070981 3070981 MO     school 2913830 96088   HAZELWOOD 291383003204 7520 WEST EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071004 3071004 MO     school 2912010 96089   FERGUSON-FLORISSANT R-II 291201002591 7500 EARLY EDUCATION CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071014 3071014 MO     school 2923700 96090   PATTONVILLE R-III 292370000656 7500 PATTONVILLE Early CHol   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071044 3071044 MO     school 2926850 96091   ROCKWOOD R-VI 292685002849 7500 ROCKWOOD CTR. EARLY CHILD. ED.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071053 3071053 MO     school 2916770 96092   KIRKWOOD R-VII 291677003031 7500 KIRKWOOD EARLY CHILD. CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071063 3071063 MO     school 2918690 96093   LINDBERGH SCHOOLS 291869003278 7500 EARLY CHILDHOOD ED CENTER WEST   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071081 3071081 MO     school 2920670 96094   MEHLVILLE R-IX 292067002996 7500 JOHN CARY EARLY CHILDHOOD CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071120 3071120 MO     school 2905880 96101   BRENTWOOD 290588003190 7500 BRENTWOOD EARLY CHILDHD CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071126 3071126 MO     school 2909720 96102   CLAYTON 290972002583 7500 FAMILY CTR.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071144 3071144 MO     school 2917820 96106   LADUE 291782003279 7500 LADUE EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071165 3071165 MO     school 2926640 96110   RITENOUR 292664003300 7500 RITENOUR EARLY CHILDHOOD CTR   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071178 3071178 MO     school 2926670 96111   RIVERVIEW GARDENS 292667002765 7530 EARLY CHILD. EDUCATION   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071185 3071185 MO     school 2930660 96112   UNIVERSITY CITY 293066001898 7500 JULIA GOLDSTEIN EARLY CHILD.   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071193 3071193 MO     school 2931530 96114   WEBSTER GROVES 293153002651 4050 WALTER AMBROSE FAMILY CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071264 3071264 MO     school 2902880 103129   ADVANCE R-IV 290288003340 7500 ADVANCE PRESCHOOL   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071269 3071269 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525002578 1015 JUVENILE CTR.   Alternative School No Other 02 12 2021   k_12_total                                                   0                                             0
3071277 3071277 MO     school 2910770 103132   DEXTER R-XI 291077003390 7500 SOUTHWEST ELEMENTARY PRESCHOOL   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071303 3071303 MO     school 2912240 106003   FORSYTH R-III 291224003391 1010 TRI LAKES SPECIAL SERV CO-OP   Regular School No Other PK 12 2021   k_12_total                                                   0                                             0
3071322 3071322 MO     school 2914840 107152   HOUSTON R-I 291484000686 1010 EXCEPTIONAL CHILD COOP.   Special Education School No Other PK 12 2021   k_12_total                                                   0                                             0
3071351 3071351 MO     school 2932310 109002   WRIGHT CITY R-II OF WARREN CO. 293231003273 7500 WRIGHT START PRESCHOOL   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071357 3071357 MO     school 2931050 109003   WARREN CO. R-III 293105003355 7500 EARLY LEARNING CENTER   Regular School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3071530 3071530 MO     school 2900022 201201   MO SCHLS FOR THE SEV DISABLED 290002203058 9024 CITADEL SCHOOL   Special Education School No Other KG 12 2021   k_12_total                                                   0                                             0
3296787 3296787 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No 1 PK PK 2015   k_12_total * * * *   *       * *           *         *   *   0                                             0
3296788 3296788 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3296789 3296789 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3296790 3296790 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No Prekindergarten PK PK 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);