enrollments

Data source: Big Local News · About: Big Local

9,153 rows where grade = "kindergarten" and state = "TX" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • kindergarten · 9,153 ✖
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
1377866 1377866 TX CASS COUNTY   school 4809090 34902   AVINGER ISD 480909000378 34902001 AVINGER SCHOOL   Regular School No Other PK 12 2021   kindergarten                                                   10                                             10
1383830 1383830 TX LA SALLE COUNTY   school 4815400 142901   COTULLA ISD 481540001115 142901104 ENCINAL EL   Regular School No Elementary PK 05 2021   kindergarten                                                   10                                             10
1389611 1389611 TX SHELBY COUNTY   school 4818840 210906   EXCELSIOR ISD 481884001762 210906101 EXCELSIOR EL   Regular School No Elementary PK 08 2021   kindergarten                                                   10                                             10
1399101 1399101 TX BOSQUE COUNTY   school 4824360 18906   IREDELL ISD 482436002714 18906001 IREDELL SCHOOL   Regular School No Other PK 12 2021   kindergarten                                                   10                                             10
1399442 1399442 TX KENT COUNTY   school 4824660 132902   JAYTON-GIRARD ISD 482466002762 132902001 JAYTON SCHOOLS   Regular School No Other PK 12 2021   kindergarten                                                   10                                             10
1404430 1404430 TX GAINES COUNTY   school 4828140 83902   LOOP ISD 482814003154 83902001 LOOP SCHOOL   Regular School No Other PK 12 2021   kindergarten                                                   10                                             10
1417012 1417012 TX COMANCHE COUNTY   school 4840170 47905   SIDNEY ISD 484017004556 47905001 SIDNEY SCHOOL   Regular School No Other PK 12 2021   kindergarten                                                   10                                             10
1419770 1419770 TX HAYS COUNTY   school 4800194 105802   TEXAS PREPARATORY SCHOOL 480019412933 105802101 TEXAS PREPARATORY SCHOOL - AUSTIN   Regular School Yes Elementary KG 06 2021   kindergarten                                                   10                                             10
1618499 1618499 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155000627 25908001 BROOKESMITH SCHOOL   Regular School No Other PK 12 2020   kindergarten                                                   10                                             10
1630908 1630908 TX JEFF DAVIS COUNTY   school 4820100 122901   FT DAVIS ISD 482010001962 122901001 FT DAVIS SCHOOL   Regular School No Other PK 12 2020   kindergarten                                                   10                                             10
1631144 1631144 TX GALVESTON COUNTY   school 4820280 84902   GALVESTON ISD 482028001997 84902102 CRENSHAW EL AND MIDDLE   Regular School No Elementary PK 08 2020   kindergarten                                                   10                                             10
1640747 1640747 TX BOSQUE COUNTY   school 4825890 18907   KOPPERL ISD 482589002917 18907001 KOPPERL SCHOOL   Regular School No Other PK 12 2020   kindergarten                                                   10                                             10
1641747 1641747 TX RUSK COUNTY   school 4826700 201903   LANEVILLE ISD 482670006577 201903001 LANEVILLE SCHOOL   Regular School No Other PK 12 2020   kindergarten                                                   10                                             10
1644770 1644770 TX MATAGORDA COUNTY   school 4829370 158904   MATAGORDA ISD 482937003310 158904101 MATAGORDA SCHOOL   Regular School No Elementary PK 08 2020   kindergarten                                                   10                                             10
1646686 1646686 TX BOSQUE COUNTY   school 4831380 18903   MORGAN ISD 483138003520 18903001 MORGAN SCHOOL   Regular School No Other PK 12 2020   kindergarten                                                   10                                             10
1651854 1651854 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007612905 14803002 GEORGETOWN CHARTER ACADEMY   Regular School Yes Elementary PK 08 2020   kindergarten                                                   10                                             10
1653865 1653865 TX HASKELL COUNTY   school 4838280 104903   RULE ISD 483828004270 104903001 RULE SCHOOL   Regular School No Other PK 12 2020   kindergarten                                                   10                                             10
1656139 1656139 TX COOKE COUNTY   school 4840380 49909   SIVELLS BEND ISD 484038004574 49909101 SIVELLS BEND EL   Regular School No Elementary PK 08 2020   kindergarten                                                   10                                             10
1659213 1659213 TX TAYLOR COUNTY   school 4843110 221905   TRENT ISD 484311004900 221905001 TRENT INDEPENDENT SCHOOL DISTRICT   Regular School No Other PK 12 2020   kindergarten                                                   10                                             10
1660903 1660903 TX LAVACA COUNTY   school 4844250 143904   VYSEHRAD ISD 484425005027 143904101 VYSEHRAD EL   Regular School No Elementary PK 08 2020   kindergarten                                                   10                                             10
1662237 1662237 TX LYNN COUNTY   school 4845990 153907   WILSON ISD 484599005241 153907001 WILSON SCHOOL   Regular School No Other PK 12 2020   kindergarten                                                   10                                             10
1662413 1662413 TX THROCKMORTON COUNTY   school 4846410 224902   WOODSON ISD 484641005285 224902001 WOODSON SCHOOL   Regular School No Other PK 12 2020   kindergarten                                                   10                                             10
1663068 1663068 TX ZAPATA COUNTY   school 4846710 253901   ZAPATA COUNTY ISD 484671005349 253901101 BENAVIDES EL   Regular School No Elementary PK 05 2020   kindergarten                                                   10                                             10
1374392 1374392 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000012 221901102 AUSTIN EL   Regular School No Elementary PK 05 2021   kindergarten                                                   100                                             100
1375218 1375218 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783006640 101903116 LANDIS EL   Regular School No Elementary PK 04 2021   kindergarten                                                   100                                             100
1377723 1377723 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894000358 227901138 SUMMITT EL   Regular School No Elementary PK 05 2021   kindergarten                                                   100                                             100
1378743 1378743 TX TARRANT COUNTY   school 4810230 220902   BIRDVILLE ISD 481023000487 220902104 JACK C BINION EL   Regular School No Elementary PK 05 2021   kindergarten                                                   100                                             100
1379705 1379705 TX HENDERSON COUNTY   school 4811640 107902   BROWNSBORO ISD 481164000638 107902101 BROWNSBORO EL   Regular School No Elementary PK 03 2021   kindergarten                                                   100                                             100
1379747 1379747 TX CAMERON COUNTY   school 4811680 31901   BROWNSVILLE ISD 481168012238 31901144 BREEDEN EL   Regular School No Elementary PK 05 2021   kindergarten                                                   100                                             100
1382484 1382484 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735013081 21901111 SPRING CREEK EL   Regular School No Elementary PK 04 2021   kindergarten                                                   100                                             100
1383044 1383044 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500005430 170902116 GLEN LOCH EL   Regular School No Elementary PK 04 2021   kindergarten                                                   100                                             100
1385241 1385241 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623001372 57905216 EDWARD TITCHE EL   Regular School No Elementary PK 05 2021   kindergarten                                                   100                                             100
1386081 1386081 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623012792 57905244 SEAGOVILLE NORTH EL   Regular School No Elementary PK 05 2021   kindergarten                                                   100                                             100
1387141 1387141 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707005455 84901105 JAKE SILBERNAGEL EL   Regular School No Elementary PK 04 2021   kindergarten                                                   100                                             100
1390365 1390365 TX FORT BEND COUNTY   school 4819650 79907   FORT BEND ISD 481965005988 79907120 SETTLERS WAY EL   Regular School No Elementary PK 05 2021   kindergarten                                                   100                                             100
1393110 1393110 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115002108 101911105 CARVER EL   Regular School No Elementary PK 05 2021   kindergarten                                                   100                                             100
1393483 1393483 TX DALLAS COUNTY   school 4821420 57910   GRAND PRAIRIE ISD 482142002146 57910102 JAMES BOWIE FINE ARTS ACADEMY   Regular School No Elementary PK 05 2021   kindergarten                                                   100                                             100
1396939 1396939 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364002555 101912218 PILGRIM ACADEMY   Regular School No Elementary PK 08 2021   kindergarten                                                   100                                             100
1397925 1397925 TX WALKER COUNTY   school 4824030 236902   HUNTSVILLE ISD 482403002660 236902101 STEWART EL   Regular School No Elementary KG 04 2021   kindergarten                                                   100                                             100
1402686 1402686 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658013858 79901144 TAMARRON EL   Regular School No Elementary PK 05 2021   kindergarten                                                   100                                             100
1403076 1403076 TX DENTON COUNTY   school 4801420 61804   LEADERSHIP PREP SCHOOL 480142012633 61804001 LEADERSHIP PREP SCHOOL   Regular School Yes Elementary KG 04 2021   kindergarten                                                   100                                             100
1403735 1403735 TX DENTON COUNTY   school 4827300 61902   LEWISVILLE ISD 482730009593 61902138 MARJORY VICKERY EL   Regular School No Elementary KG 05 2021   kindergarten                                                   100                                             100
1405502 1405502 TX TARRANT COUNTY   school 4828920 220908   MANSFIELD ISD 482892011478 220908125 JUDY MILLER EL   Regular School No Elementary PK 04 2021   kindergarten                                                   100                                             100
1406998 1406998 TX MIDLAND COUNTY   school 4830570 165901   MIDLAND ISD 483057013622 165901135 GENERAL TOMMY FRANKS EL   Regular School No Elementary PK 06 2021   kindergarten                                                   100                                             100
1407795 1407795 TX TITUS COUNTY   school 4831760 225902   MOUNT PLEASANT ISD 483176003536 225902102 ANNIE SIMS EL   Regular School No Elementary KG 04 2021   kindergarten                                                   100                                             100
1407860 1407860 TX BAILEY COUNTY   school 4831890 9901   MULESHOE ISD 483189003549 9901103 DILLMAN EL   Regular School No Elementary PK 02 2021   kindergarten                                                   100                                             100
1408015 1408015 TX GUADALUPE COUNTY   school 4832160 94903   NAVARRO ISD 483216003567 94903101 NAVARRO EL   Regular School No Elementary PK 03 2021   kindergarten                                                   100                                             100
1408328 1408328 TX MONTGOMERY COUNTY   school 4832400 170908   NEW CANEY ISD 483240012930 170908114 TAVOLA EL   Regular School No Elementary PK 05 2021   kindergarten                                                   100                                             100
1409548 1409548 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312012604 15915225 LIECK EL   Regular School No Elementary PK 05 2021   kindergarten                                                   100                                             100
1410618 1410618 TX HARRIS COUNTY   school 4834320 101917   PASADENA ISD 483432003818 101917101 BAILEY EL   Regular School No Elementary PK 04 2021   kindergarten                                                   100                                             100
1410928 1410928 TX HARRIS COUNTY   school 4834320 101917   PASADENA ISD 483432005569 101917130 YOUNG EL   Regular School No Elementary PK 04 2021   kindergarten                                                   100                                             100
1418292 1418292 TX HARRIS COUNTY   school 4841220 101919   SPRING ISD 484122004710 101919102 BAMMEL EL   Regular School No Elementary PK 05 2021   kindergarten                                                   100                                             100
1419497 1419497 TX TAYLOR COUNTY   school 4800163 221801   TEXAS COLLEGE PREPARATORY ACADEMIE 480016313318 221801063 FOUNDERS CLASSICAL ACADEMY OF FLOW   Regular School Yes Other KG 10 2021   kindergarten                                                   100                                             100
1421323 1421323 TX DALLAS COUNTY   school 4800030 57803   UPLIFT EDUCATION 480003013483 57803114 UPLIFT WHITE ROCK HILLS PREP   Regular School Yes Elementary PK 05 2021   kindergarten                                                   100                                             100
1423966 1423966 TX EL PASO COUNTY   school 4846680 71905   YSLETA ISD 484668005340 71905117 SCOTSDALE EL   Regular School No Elementary PK 06 2021   kindergarten                                                   100                                             100
1613208 1613208 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000014 221901104 BOWIE EL   Regular School No Elementary KG 05 2020   kindergarten                                                   100                                             100
1613241 1613241 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000022 221901112 JACKSON EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1613312 1613312 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744002238 221901150 WARD EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1617125 1617125 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967012433 123910129 DR MAE E JONES-CLARK EL   Regular School Yes Elementary PK 05 2020   kindergarten                                                   100                                             100
1617174 1617174 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967012429 123910128 MARTIN EL   Regular School No Elementary KG 05 2020   kindergarten                                                   100                                             100
1619074 1619074 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179021134 21902101 KEMP-CARVER EL   Regular School No Elementary PK 04 2020   kindergarten                                                   100                                             100
1620433 1620433 TX HARRIS COUNTY   school 4813590 101905   CHANNELVIEW ISD 481359005422 101905104 MCMULLAN EL   Regular School No Elementary KG 05 2020   kindergarten                                                   100                                             100
1620959 1620959 TX GALVESTON COUNTY   school 4814280 84910   CLEAR CREEK ISD 481428000910 84910104 JAMES H ROSS EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1622928 1622928 TX HOUSTON COUNTY   school 4815720 113901   CROCKETT ISD 481572007048 113901105 EARLY CHILDHOOD CTR   Regular School No Elementary PK KG 2020   kindergarten                                                   100                                             100
1626982 1626982 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785013627 15911108 TRADITION EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1630562 1630562 TX COLLIN COUNTY   school 4820010 43905   FRISCO ISD 482001011403 43905127 CARROLL EL   Regular School No Other PK 11 2020   kindergarten                                                   100                                             100
1630705 1630705 TX COLLIN COUNTY   school 4820010 43905   FRISCO ISD 482001011563 43905124 MOONEYHAM EL   Regular School No Elementary KG 05 2020   kindergarten                                                   100                                             100
1630741 1630741 TX COLLIN COUNTY   school 4820010 43905   FRISCO ISD 482001012899 43905133 PHILLIPS EL   Regular School No Elementary KG 05 2020   kindergarten                                                   100                                             100
1632087 1632087 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115002106 101911113 ASHBEL SMITH EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1635094 1635094 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364002428 101912132 COOP EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1636076 1636076 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364016978 101912080 RICE SCH /LA ESCUELA RICE   Regular School No Elementary KG 08 2020   kindergarten                                                   100                                             100
1637535 1637535 TX HIDALGO COUNTY   school 4800211 108807   IDEA PUBLIC SCHOOLS 480021114016 108807189 IDEA LOS ENCINOS ACADEMY   Regular School Yes Elementary PK 01 2020   kindergarten                                                   100                                             100
1637538 1637538 TX HIDALGO COUNTY   school 4800211 108807   IDEA PUBLIC SCHOOLS 480021113520 108807126 IDEA MAYS ACADEMY   Regular School Yes Elementary KG 05 2020   kindergarten                                                   100                                             100
1637682 1637682 TX HIDALGO COUNTY   school 4800211 108807   IDEA PUBLIC SCHOOLS 480021113220 108807136 IDEA RUNDBERG ACADEMY   Regular School Yes Elementary KG 05 2020   kindergarten                                                   100                                             100
1638605 1638605 TX ATASCOSA COUNTY   school 4824960 7902   JOURDANTON ISD 482496002784 7902101 JOURDANTON EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1639977 1639977 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566008428 14906129 MAXDALE EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1640458 1640458 TX HARRIS COUNTY   school 4825740 101915   KLEIN ISD 482574005521 101915110 EHRHARDT EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1641455 1641455 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658013552 79901142 DON CARTER EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1641612 1641612 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658007601 79901116 T L PINK EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1642011 1642011 TX DENTON COUNTY   school 4801420 61804   LEADERSHIP PREP SCHOOL 480142012633 61804001 LEADERSHIP PREP SCHOOL   Regular School Yes Elementary KG 04 2020   kindergarten                                                   100                                             100
1643941 1643941 TX LUBBOCK COUNTY   school 4815180 152906   LUBBOCK-COOPER ISD 481518001026 152906101 LUBBOCK-COOPER SOUTH EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1644169 1644169 TX MONTGOMERY COUNTY   school 4828740 170906   MAGNOLIA ISD 482874003253 170906102 MAGNOLIA EL   Regular School No Elementary PK 04 2020   kindergarten                                                   100                                             100
1646117 1646117 TX MIDLAND COUNTY   school 4830570 165901   MIDLAND ISD 483057003453 165901118 TRAVIS EL   Regular School No Elementary PK 06 2020   kindergarten                                                   100                                             100
1646648 1646648 TX MONTGOMERY COUNTY   school 4831260 170903   MONTGOMERY ISD 483126009353 170903104 STEWART CREEK EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1647047 1647047 TX GRIMES COUNTY   school 4832190 93904   NAVASOTA ISD 483219003569 93904104 JOHN C WEBB EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1648234 1648234 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312003690 15915128 CARLOS COON EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1648772 1648772 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312008708 15915167 RABA EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1648927 1648927 TX DENTON COUNTY   school 4833180 61911   NORTHWEST ISD 483318012293 61911117 CLARA LOVE EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1649587 1649587 TX WISE COUNTY   school 4834260 249906   PARADISE ISD 483426003807 249906101 PARADISE EL   Regular School No Elementary PK 03 2020   kindergarten                                                   100                                             100
1649709 1649709 TX HARRIS COUNTY   school 4834320 101917   PASADENA ISD 483432003827 101917106 GENOA EL   Regular School No Elementary PK 04 2020   kindergarten                                                   100                                             100
1654059 1654059 TX TOM GREEN COUNTY   school 4838700 226903   SAN ANGELO ISD 483870006317 226903122 BONHAM EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1657072 1657072 TX HARRIS COUNTY   school 4841100 101920   SPRING BRANCH ISD 484110004672 101920103 EDGEWOOD EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1657690 1657690 TX MARTIN COUNTY   school 4841430 156902   STANTON ISD 484143004739 156902101 STANTON EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1659799 1659799 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365008409 240903127 JOHN W ARNDT EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1661130 1661130 TX WALLER COUNTY   school 4844430 237904   WALLER ISD 484443009417 237904106 FIELDS STORE EL   Regular School No Elementary PK 05 2020   kindergarten                                                   100                                             100
1374502 1374502 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000035 221901121 TAYLOR EL   Regular School No Elementary KG 05 2021   kindergarten                                                   101                                             101
1375059 1375059 TX JIM WELLS COUNTY   school 4807800 125901   ALICE ISD 480780000098 125901104 NOONAN EL   Regular School No Elementary PK 04 2021   kindergarten                                                   101                                             101
1375547 1375547 TX BRAZORIA COUNTY   school 4808090 20901   ALVIN ISD 480809000135 20901104 BILL HASSE EL   Regular School No Elementary PK 05 2021   kindergarten                                                   101                                             101
1376568 1376568 TX TARRANT COUNTY   school 4808700 220901   ARLINGTON ISD 480870006821 220901142 ELLIS EL   Regular School No Elementary PK 06 2021   kindergarten                                                   101                                             101
1380853 1380853 TX RANDALL COUNTY   school 4812810 191901   CANYON ISD 481281006371 191901105 LAKEVIEW EL   Regular School No Elementary PK 04 2021   kindergarten                                                   101                                             101

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