enrollments

Data source: Big Local News · About: Big Local

7,227 rows where grade = "pre_kindergarten" and state = "TX" sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pre_kindergarten · 7,227 ✖
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
1375121 1375121 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783007622 101903121 BUSH EL   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   <90                                             90
1376115 1376115 TX ANDREWS COUNTY   school 4808280 2901   ANDREWS ISD 480828005844 2901105 CLEARFORK EL   Regular School No Elementary PK 01 2021   pre_kindergarten                                                   <90                                             90
1378134 1378134 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957002476 11901103 CEDAR CREEK EL   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   <90                                             90
1382209 1382209 TX LIBERTY COUNTY   school 4814370 146901   CLEVELAND ISD 481437013664 146901105 COTTONWOOD EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1382906 1382906 TX MCLENNAN COUNTY   school 4814970 161921   CONNALLY ISD 481497013354 161921106 CONNALLY EARLY CHILDHOOD CENTER   Regular School No Elementary PK KG 2021   pre_kindergarten                                                   <90                                             90
1384806 1384806 TX HARRIS COUNTY   school 4816110 101907   CYPRESS-FAIRBANKS ISD 481611009630 101907141 TIPPS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1389492 1389492 TX HENDERSON COUNTY   school 4818720 107905   EUSTACE ISD 481872001750 107905101 EUSTACE PRI   Regular School No Elementary PK 02 2021   pre_kindergarten                                                   <90                                             90
1389811 1389811 TX WILSON COUNTY   school 4819350 247901   FLORESVILLE ISD 481935012576 247901106 FLORESVILLE SOUTH EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1391976 1391976 TX HARRIS COUNTY   school 4820250 101910   GALENA PARK ISD 482025001981 101910102 CLOVERLEAF EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1393168 1393168 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115005479 101911117 HOPPER PRI   Regular School No Elementary PK 01 2021   pre_kindergarten                                                   <90                                             90
1394586 1394586 TX CAMERON COUNTY   school 4822530 31903   HARLINGEN CISD 482253005487 31903117 TREASURE HILLS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1395810 1395810 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364002387 101912104 ALMEDA EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1395897 1395897 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364001389 101912295 BENAVIDEZ EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1397115 1397115 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364010744 101912353 SCHOOL AT ST GEORGE PLACE   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1397731 1397731 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391002649 101913102 LAKELAND EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1397777 1397777 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391010757 101913122 PARK LAKES EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1397803 1397803 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391010758 101913123 RIVER PINES EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1399903 1399903 TX BEXAR COUNTY   school 4824990 15916   JUDSON ISD 482499010447 15916116 RICARDO SALINAS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1399911 1399911 TX BEXAR COUNTY   school 4824990 15916   JUDSON ISD 482499012467 15916118 ROLLING MEADOWS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1400704 1400704 TX KAUFMAN COUNTY   school 4825320 129904   KEMP ISD 482532002825 129904101 KEMP PRI   Regular School No Elementary PK 02 2021   pre_kindergarten                                                   <90                                             90
1400875 1400875 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566013235 14906140 ALICE W DOUSE EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1400977 1400977 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566012378 14906138 HAYNES EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1403930 1403930 TX LIBERTY COUNTY   school 4827450 146906   LIBERTY ISD 482745003089 146906102 SAN JACINTO EL   Regular School No Elementary PK 01 2021   pre_kindergarten                                                   <90                                             90
1405135 1405135 TX ATASCOSA COUNTY   school 4828650 7904   LYTLE ISD 482865008424 7904103 LYTLE PRIMARY SCHOOL   Regular School No Elementary PK 01 2021   pre_kindergarten                                                   <90                                             90
1406848 1406848 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042003424 147903103 A B MCBAY EL   Regular School No Elementary PK 02 2021   pre_kindergarten                                                   <90                                             90
1407478 1407478 TX HIDALGO COUNTY   school 4831040 108908   MISSION CISD 483104009483 108908115 HURLA M MIDKIFF EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1407500 1407500 TX HIDALGO COUNTY   school 4831040 108908   MISSION CISD 483104006146 108908110 MIMS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1411561 1411561 TX HIDALGO COUNTY   school 4834860 108909   PHARR-SAN JUAN-ALAMO ISD 483486003915 108909108 HENRY FORD EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1414885 1414885 TX CHEROKEE COUNTY   school 4838360 37907   RUSK ISD 483836005807 37907103 GW BRADFORD PRI   Regular School No Elementary PK 01 2021   pre_kindergarten                                                   <90                                             90
1417347 1417347 TX EL PASO COUNTY   school 4840710 71909   SOCORRO ISD 484071005922 71909105 HORIZON HEIGHTS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1417366 1417366 TX EL PASO COUNTY   school 4840710 71909   SOCORRO ISD 484071012820 71909129 JAMES P BUTLER EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1417484 1417484 TX EL PASO COUNTY   school 4840710 71909   SOCORRO ISD 484071013501 71909132 SGT JOSE F CARRASCO EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1418466 1418466 TX HARRIS COUNTY   school 4841220 101919   SPRING ISD 484122004718 101919103 PONDEROSA EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1418899 1418899 TX NOLAN COUNTY   school 4842030 177902   SWEETWATER ISD 484203004783 177902101 SOUTHEAST EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   <90                                             90
1421669 1421669 TX JOHNSON COUNTY   school 4844010 126908   VENUS ISD 484401008313 126908102 VENUS PRI   Regular School No Elementary PK 01 2021   pre_kindergarten                                                   <90                                             90
1421930 1421930 TX MCLENNAN COUNTY   school 4844280 161914   WACO ISD 484428005030 161914103 BELL'S HILL EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1422675 1422675 TX NUECES COUNTY   school 4845120 178915   WEST OSO ISD 484512005145 178915102 KENNEDY EL   Regular School No Elementary PK 02 2021   pre_kindergarten                                                   <90                                             90
1615152 1615152 TX SAN PATRICIO COUNTY   school 4808580 205901   ARANSAS PASS ISD 480858000226 205901101 H T FAULK EL   Regular School No Elementary PK 02 2020   pre_kindergarten                                                   <90                                             90
1617037 1617037 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957008693 11901107 RED ROCK EL   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   <90                                             90
1619191 1619191 TX SMITH COUNTY   school 4812060 212902   BULLARD ISD 481206012154 212902103 BULLARD EARLY CHILDHOOD   Regular School No Elementary PK KG 2020   pre_kindergarten                                                   <90                                             90
1619508 1619508 TX BURLESON COUNTY   school 4812460 26901   CALDWELL ISD 481246000738 26901101 CALDWELL EL   Regular School No Elementary PK 03 2020   pre_kindergarten                                                   <90                                             90
1619818 1619818 TX DIMMIT COUNTY   school 4812990 64903   CARRIZO SPRINGS CISD 481299009648 64903102 CARRIZO SPRINGS EL   Regular School No Elementary PK 03 2020   pre_kindergarten                                                   <90                                             90
1621191 1621191 TX EL PASO COUNTY   school 4814430 71901   CLINT ISD 481443011214 71901106 CARROLL T WELCH EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1621913 1621913 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500008992 170902106 CREIGHTON EL   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   <90                                             90
1621936 1621936 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500000997 170902112 FORD EL   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   <90                                             90
1623405 1623405 TX HARRIS COUNTY   school 4816110 101907   CYPRESS-FAIRBANKS ISD 481611010730 101907142 DURYEA EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1624487 1624487 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623010568 57905172 JIMMIE TYLER BRASHEAR EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1629328 1629328 TX FORT BEND COUNTY   school 4819650 79907   FORT BEND ISD 481965008566 79907140 RITA DRABEK EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1629624 1629624 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970009377 220905222 CLIFFORD DAVIS EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1630124 1630124 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001912 220905167 SOUTH HILLS EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1631328 1631328 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034011475 57909159 GEORGE WASHINGTON CARVER EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1634682 1634682 TX MEDINA COUNTY   school 4823430 163904   HONDO ISD 482343002378 163904102 MEYER EL   Regular School No Elementary PK 02 2020   pre_kindergarten                                                   <90                                             90
1634801 1634801 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364002387 101912104 ALMEDA EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1634862 1634862 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364002395 101912108 BASTIAN EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1634876 1634876 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364002396 101912151 BELL EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1635223 1635223 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364002450 101912148 ELROD EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1635530 1635530 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364002490 101912175 HOBBY EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1635700 1635700 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364002523 101912196 LONGFELLOW EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1635982 1635982 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364002555 101912218 PILGRIM ACADEMY   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   <90                                             90
1636166 1636166 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364010744 101912353 SCHOOL AT ST GEORGE PLACE   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1636390 1636390 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364002603 101912253 WALNUT BEND EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1636601 1636601 TX ANGELINA COUNTY   school 4823790 3902   HUDSON ISD 482379008687 3902101 W F PEAVY PRI   Regular School No Elementary PK 02 2020   pre_kindergarten                                                   <90                                             90
1636818 1636818 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391002650 101913103 NORTH BELT EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1636841 1636841 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391010757 101913122 PARK LAKES EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1636867 1636867 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391010758 101913123 RIVER PINES EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1638049 1638049 TX WICHITA COUNTY   school 4824260 243903   IOWA PARK CISD 482426002705 243903103 KIDWELL EL   Regular School No Elementary PK 02 2020   pre_kindergarten                                                   <90                                             90
1638349 1638349 TX CHEROKEE COUNTY   school 4824590 37904   JACKSONVILLE ISD 482459006000 37904103 FRED DOUGLASS   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   <90                                             90
1638809 1638809 TX BEXAR COUNTY   school 4824990 15916   JUDSON ISD 482499002790 15916102 HOPKINS EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1638856 1638856 TX BEXAR COUNTY   school 4824990 15916   JUDSON ISD 482499009452 15916115 MARY LOU HARTMAN   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1639737 1639737 TX WINKLER COUNTY   school 4825560 248901   KERMIT ISD 482556012414 248901101 KERMIT EL   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   <90                                             90
1640053 1640053 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566012047 14906137 RICHARD E CAVAZOS EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1644038 1644038 TX CALDWELL COUNTY   school 4828590 28903   LULING ISD 482859013051 28903104 LULING PRI   Regular School No Elementary PK 01 2020   pre_kindergarten                                                   <90                                             90
1644918 1644918 TX HIDALGO COUNTY   school 4829670 108906   MCALLEN ISD 482967021348 108906124 GONZALEZ EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1649701 1649701 TX HARRIS COUNTY   school 4834320 101917   PASADENA ISD 483432003826 101917105 GARFIELD EL   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   <90                                             90
1649758 1649758 TX HARRIS COUNTY   school 4834320 101917   PASADENA ISD 483432003833 101917117 MAE SMYTHE EL   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   <90                                             90
1649825 1649825 TX HARRIS COUNTY   school 4834320 101917   PASADENA ISD 483432003840 101917108 PEARL HALL EL   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   <90                                             90
1650796 1650796 TX CAMP COUNTY   school 4835010 32902   PITTSBURG ISD 483501003940 32902104 PITTSBURG PRI   Regular School No Elementary PK 01 2020   pre_kindergarten                                                   <90                                             90
1656508 1656508 TX EL PASO COUNTY   school 4840710 71909   SOCORRO ISD 484071013106 71909131 PURPLE HEART EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1656820 1656820 TX BEXAR COUNTY   school 4840950 15912   SOUTHWEST ISD 484095007520 15912108 ELM CREEK EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1657341 1657341 TX HARRIS COUNTY   school 4841220 101919   SPRING ISD 484122006329 101919112 BENEKE EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1657506 1657506 TX HARRIS COUNTY   school 4841220 101919   SPRING ISD 484122004718 101919103 PONDEROSA EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1659798 1659798 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365008409 240903127 JOHN W ARNDT EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1659980 1659980 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365013304 240903133 VETERANS MEMORIAL EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1660928 1660928 TX MCLENNAN COUNTY   school 4844280 161914   WACO ISD 484428005030 161914103 BELL'S HILL EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1660975 1660975 TX MCLENNAN COUNTY   school 4844280 161914   WACO ISD 484428005034 161914107 DEAN HIGHLAND EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1661788 1661788 TX ANDERSON COUNTY   school 4843290 1908   WESTWOOD ISD 484329005606 1908102 WESTWOOD PRI   Regular School No Elementary PK 02 2020   pre_kindergarten                                                   <90                                             90
1375134 1375134 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783000107 101903108 CHANCELLOR EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <80                                             80
1375176 1375176 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783005637 101903111 HEFLIN EL   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   <80                                             80
1377611 1377611 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894006070 227901143 PATTON EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <80                                             80
1379260 1379260 TX MONTAGUE COUNTY   school 4810990 169901   BOWIE ISD 481099009664 169901042 BOWIE INT   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <80                                             80
1379528 1379528 TX WISE COUNTY   school 4811340 249903   BRIDGEPORT ISD 481134000611 249903101 BRIDGEPORT EL   Regular School No Elementary PK 02 2021   pre_kindergarten                                                   <80                                             80
1379815 1379815 TX CAMERON COUNTY   school 4811680 31901   BROWNSVILLE ISD 481168000650 31901123 EGLY EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <80                                             80
1380330 1380330 TX WICHITA COUNTY   school 4812120 243901   BURKBURNETT ISD 481212000711 243901103 JOHN G TOWER EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <80                                             80
1380482 1380482 TX BURNET COUNTY   school 4812220 27903   BURNET CISD 481222000722 27903101 SHADY GROVE EL   Regular School No Elementary PK 02 2021   pre_kindergarten                                                   <80                                             80
1382222 1382222 TX LIBERTY COUNTY   school 4814370 146901   CLEVELAND ISD 481437007675 146901104 EASTSIDE EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <80                                             80
1382330 1382330 TX EL PASO COUNTY   school 4814430 71901   CLINT ISD 481443000933 71901101 WM DAVID SURRATT EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <80                                             80
1382998 1382998 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500008992 170902106 CREIGHTON EL   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   <80                                             80
1383115 1383115 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500001010 170902109 OAK RIDGE EL   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   <80                                             80
1383126 1383126 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500012002 170902128 PATTERSON EL   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   <80                                             80
1384101 1384101 TX TARRANT COUNTY   school 4815910 220912   CROWLEY ISD 481591001154 220912101 BESS RACE EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <80                                             80

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