Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • pre_kindergarten · 7,095
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 ▼
1614873 TX LAMB COUNTY   school 4808160 140901   AMHERST ISD 480816000188 140901001 AMHERST SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1616687 TX REFUGIO COUNTY   school 4809000 196901   AUSTWELL-TIVOLI ISD 480900000372 196901102 AUSTWELL-TIVOLI EL   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   <10                                             10
1616730 TX CASS COUNTY   school 4809090 34902   AVINGER ISD 480909000378 34902001 AVINGER SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1616849 TX REEVES COUNTY   school 4809330 195902   BALMORHEA ISD 480933000392 195902001 BALMORHEA SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1617261 TX CLAY COUNTY   school 4809750 39904   BELLEVUE ISD 480975000446 39904001 BELLEVUE SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   10                                             10
1617421 TX KNOX COUNTY   school 4809980 138904   BENJAMIN ISD 480998000468 138904001 BENJAMIN SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1617761 TX NOLAN COUNTY   school 4800005 177903   BLACKWELL CISD 480000500513 177903001 BLACKWELL SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1617806 TX BROWN COUNTY   school 4810380 25904   BLANKET ISD 481038005661 25904001 BLANKET SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1617968 TX KENDALL COUNTY   school 4810710 130901   BOERNE ISD 481071007055 130901103 FAIR OAKS RANCH EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   10                                             10
1617992 TX KENDALL COUNTY   school 4810710 130901   BOERNE ISD 481071011292 130901106 VAN RAUB EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <10                                             10
1618498 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155000627 25908001 BROOKESMITH SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1619545 TX CALHOUN COUNTY   school 4812480 29901   CALHOUN COUNTY ISD 481248000749 29901105 PORT O CONNOR EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <10                                             10
1619582 TX ROBERTSON COUNTY   school 4812540 198902   CALVERT ISD 481254000756 198902101 CALVERT SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1620451 TX HARTLEY COUNTY   school 4813620 103901   CHANNING ISD 481362000857 103901001 CHANNING SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   10                                             10
1620560 TX TYLER COUNTY   school 4813770 229906   CHESTER ISD 481377000867 229906101 CHESTER EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   10                                             10
1622741 TX HALE COUNTY   school 4815360 95902   COTTON CENTER ISD 481536001112 95902001 COTTON CENTER SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1622759 TX LA SALLE COUNTY   school 4815400 142901   COTULLA ISD 481540001115 142901104 ENCINAL EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   10                                             10
1622871 TX BOSQUE COUNTY   school 4815570 18908   CRANFILLS GAP ISD 481557001129 18908001 CRANFILLS GAP SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   10                                             10
1622984 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 09 2020   pre_kindergarten                                                   <10                                             10
1625577 TX HUDSPETH COUNTY   school 4816650 115903   DELL CITY ISD 481665001429 115903001 DELL CITY SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1625848 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674010611 61901119 SAVANNAH EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <10                                             10
1626171 TX KERR COUNTY   school 4817190 133905   DIVIDE ISD 481719001490 133905101 DIVIDE EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <10                                             10
1626325 TX GILLESPIE COUNTY   school 4817400 86024   DOSS CONSOLIDATED CSD 481740001503 86024101 DOSS EL   Regular School No Elementary PK 07 2020   pre_kindergarten                                                   10                                             10
1628601 TX SHELBY COUNTY   school 4818840 210906   EXCELSIOR ISD 481884001762 210906101 EXCELSIOR EL   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   <10                                             10
1628611 TX LAVACA COUNTY   school 4818890 143906   EZZELL ISD 481889001764 143906101 EZZELL EL   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   <10                                             10
1628853 TX LIPSCOMB COUNTY   school 4819500 148902   FOLLETT ISD 481950001806 148902001 FOLLETT SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1629422 TX WHEELER COUNTY   school 4811400 242906   FORT ELLIOTT CISD 481140000616 242906001 FORT ELLIOTT SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1630907 TX JEFF DAVIS COUNTY   school 4820100 122901   FT DAVIS ISD 482010001962 122901001 FT DAVIS SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1631291 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034002021 57909126 DAVIS EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <10                                             10
1631336 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034011198 57909157 GLEN COUCH EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <10                                             10
1631496 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034000519 57909145 ROBERT B SEWELL EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <10                                             10
1631544 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034002045 57909113 SOUTHGATE EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <10                                             10
1631552 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034005728 57909138 SPRING CREEK EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <10                                             10
1631560 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034008185 57909154 STEADHAM EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <10                                             10
1633012 TX CARSON COUNTY   school 4821840 33901   GROOM ISD 482184002205 33901001 GROOM SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1633085 TX KING COUNTY   school 4822020 135001   GUTHRIE CSD 482202002217 135001001 GUTHRIE SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1634301 TX DONLEY COUNTY   school 4822850 65902   HEDLEY ISD 482285002317 65902001 HEDLEY SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1634519 TX GALVESTON COUNTY   school 4823160 84903   HIGH ISLAND ISD 482316002351 84903001 HIGH ISLAND SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1634606 TX DALLAS COUNTY   school 4823250 57911   HIGHLAND PARK ISD 482325002360 57911104 UNIVERSITY PARK ELEMENTARY   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   <10                                             10
1635065 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364006270 101912013 COMMUNITY SERVICES-SEC   Alternative School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1636253 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364007018 101912069 SOAR CTR   Special Education School No Other PK 12 2020   pre_kindergarten                                                   10                                             10
1636802 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391011270 101913125 LAKESHORE EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   10                                             10
1638085 TX BOSQUE COUNTY   school 4824360 18906   IREDELL ISD 482436002714 18906001 IREDELL SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1638415 TX KENT COUNTY   school 4824660 132902   JAYTON-GIRARD ISD 482466002762 132902001 JAYTON SCHOOLS   Regular School No Other PK 12 2020   pre_kindergarten                                                   10                                             10
1639630 TX WHEELER COUNTY   school 4825290 242905   KELTON ISD 482529005755 242905001 KELTON SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1639687 TX HOUSTON COUNTY   school 4825470 113906   KENNARD ISD 482547002836 113906101 KENNARD ISD   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1640732 TX KNOX COUNTY   school 4825870 138902   KNOX CITY-O'BRIEN CISD 482587005526 138902001 KNOX CITY SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1640746 TX BOSQUE COUNTY   school 4825890 18907   KOPPERL ISD 482589002917 18907001 KOPPERL SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   10                                             10
1640860 TX JIM WELLS COUNTY   school 4826070 125906   LA GLORIA ISD 482607002931 125906101 LA GLORIA EL   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   <10                                             10
1642356 TX POLK COUNTY   school 4827120 187906   LEGGETT ISD 482712003048 187906101 LEGGETT EL   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   <10                                             10
1643231 TX MCCULLOCH COUNTY   school 4827930 160905   LOHN ISD 482793003132 160905001 LOHN SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1643325 TX GREGG COUNTY   school 4828110 92903   LONGVIEW ISD 482811012529 92903123 JOHNSTON-MCQUEEN EL   Regular School Yes Elementary PK 05 2020   pre_kindergarten                                                   <10                                             10
1643349 TX GREGG COUNTY   school 4828110 92903   LONGVIEW ISD 482811012484 92903126 NED E WILLIAMS EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <10                                             10
1643357 TX GREGG COUNTY   school 4828110 92903   LONGVIEW ISD 482811012508 92903124 SOUTH WARD EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <10                                             10
1643369 TX GAINES COUNTY   school 4828140 83902   LOOP ISD 482814003154 83902001 LOOP SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1644015 TX ANGELINA COUNTY   school 4828550 3903   LUFKIN ISD 482855007776 3903141 SPECIAL SERVICES   Alternative School No Elementary PK 06 2020   pre_kindergarten                                                   <10                                             10
1644568 TX BREWSTER COUNTY   school 4828980 22902   MARATHON ISD 482898003272 22902001 MARATHON INDEPENDENT SCHOOL DIST   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1646227 TX CLAY COUNTY   school 4830660 39905   MIDWAY ISD 483066003461 39905001 MIDWAY SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1646670 TX SHACKELFORD COUNTY   school 4831320 209902   MORAN ISD 483132003518 209902001 MORAN SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1646685 TX BOSQUE COUNTY   school 4831380 18903   MORGAN ISD 483138003520 18903001 MORGAN SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1646699 TX ERATH COUNTY   school 4831410 72910   MORGAN MILL ISD 483141003521 72910101 MORGAN MILL EL   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   <10                                             10
1646869 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192005557 167902001 MULLIN MAIN   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1647612 TX BEXAR COUNTY   school 4832940 15910   NORTH EAST ISD 483294010432 15910142 BULVERDE CREEK   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <10                                             10
1648455 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312003715 15915004 HOLMGREEN CENTER   Alternative School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1648539 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312021115 15915152 LEON SPRINGS EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   10                                             10
1649242 TX RUNNELS COUNTY   school 4833570 200906   OLFEN ISD 483357003754 200906101 OLFEN SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1649405 TX COTTLE COUNTY   school 4833900 51901   PADUCAH ISD 483390003775 51901001 PADUCAH SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1649419 TX HASKELL COUNTY   school 4833960 104907   PAINT CREEK ISD 483396003777 104907001 PAINT CREEK SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1649571 TX COLEMAN COUNTY   school 4800007 42905   PANTHER CREEK CISD 480000706343 42905001 PANTHER CREEK SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1649953 TX DICKENS COUNTY   school 4834380 63906   PATTON SPRINGS ISD 483438003858 63906001 PATTON SPRINGS SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   10                                             10
1651545 TX MONTAGUE COUNTY   school 4835730 169909   PRAIRIE VALLEY ISD 483573004043 169909101 PRAIRIE VALLEY EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   10                                             10
1651582 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020713927 72801151 FOUNDATION SCHOOL OF AUTISM - SAN   Special Education School Yes Elementary PK 01 2020   pre_kindergarten                                                   <10                                             10
1651816 TX HANSFORD COUNTY   school 4835890 98903   PRINGLE-MORSE CISD 483589004061 98903101 PRINGLE-MORSE EL-J H   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   <10                                             10
1652199 TX HARRIS COUNTY   school 4800022 101806   RAUL YZAGUIRRE SCHOOLS FOR SUCCESS 480002209256 101806101 BROWNSVILLE RAUL YZAGUIRRE STEM SC   Regular School Yes Elementary PK 08 2020   pre_kindergarten                                                   <10                                             10
1653796 TX FAYETTE COUNTY   school 4838100 75908   ROUND TOP-CARMINE ISD 483810004260 75908101 ROUND TOP-CARMINE EL   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   <10                                             10
1654307 TX BEXAR COUNTY   school 4838730 15907   SAN ANTONIO ISD 483873000289 15907201 CHILDREN'S SHELTER OF SA   Alternative School No Elementary PK 05 2020   pre_kindergarten                                                   <10                                             10
1655056 TX STARR COUNTY   school 4838910 214902   SAN ISIDRO ISD 483891008022 214902101 SAN ISIDRO EL   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   <10                                             10
1655153 TX BREWSTER COUNTY   school 4839060 22903   SAN VICENTE ISD 483906005809 22903101 SAN VICENTE EL   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   <10                                             10
1656044 TX COMANCHE COUNTY   school 4840170 47905   SIDNEY ISD 484017004556 47905001 SIDNEY SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   10                                             10
1656058 TX HUDSPETH COUNTY   school 4840200 115902   SIERRA BLANCA ISD 484020004558 115902001 SIERRA BLANCA SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1656138 TX COOKE COUNTY   school 4840380 49909   SIVELLS BEND ISD 484038004574 49909101 SIVELLS BEND EL   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   <10                                             10
1656928 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006313011 15807101 SOUTHWEST PREP NORTHWEST EL   Regular School Yes Elementary PK 02 2020   pre_kindergarten                                                   <10                                             10
1657614 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1657793 TX PALO PINTO COUNTY   school 4841700 182905   STRAWN ISD 484170004759 182905001 STRAWN SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1657825 TX HOPKINS COUNTY   school 4841790 112910   SULPHUR BLUFF ISD 484179004763 112910001 SULPHUR BLUFF ISD   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1657928 TX LAVACA COUNTY   school 4842000 143905   SWEET HOME ISD 484200004782 143905101 SWEET HOME EL   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   <10                                             10
1658180 TX BREWSTER COUNTY   school 4842390 22004   TERLINGUA CSD 484239007193 22004001 BIG BEND H S   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1658195 TX TERRELL COUNTY   school 4842420 222901   TERRELL COUNTY ISD 484242004837 222901001 SANDERSON SCHOOLS   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1659212 TX TAYLOR COUNTY   school 4843110 221905   TRENT ISD 484311004900 221905001 TRENT INDEPENDENT SCHOOL DISTRICT   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1659241 TX HENDERSON COUNTY   school 4843170 107907   TRINIDAD ISD 484317004904 107907001 TRINIDAD SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   10                                             10
1659733 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365004958 240903105 CLARK EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <10                                             10
1660398 TX UVALDE COUNTY   school 4843680 232904   UTOPIA ISD 484368004965 232904001 UTOPIA SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   10                                             10
1660427 TX UVALDE COUNTY   school 4843720 232903   UVALDE CISD 484372011429 232903108 BATESVILLE SCHOOL   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   <10                                             10
1660453 TX JEFF DAVIS COUNTY   school 4843740 122902   VALENTINE ISD 484374004975 122902001 VALENTINE SCHOOL   Regular School No Other PK 11 2020   pre_kindergarten                                                   <10                                             10
1661171 TX COOKE COUNTY   school 4844490 49908   WALNUT BEND ISD 484449005079 49908101 WALNUT BEND EL   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   <10                                             10
1661730 TX MITCHELL COUNTY   school 4845210 168903   WESTBROOK ISD 484521005156 168903001 WESTBROOK SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   10                                             10
1661744 TX DEWITT COUNTY   school 4845240 62905   WESTHOFF ISD 484524005157 62905101 WESTHOFF EL   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   <10                                             10
1661974 TX HOCKLEY COUNTY   school 4845690 110908   WHITHARRAL ISD 484569005193 110908001 WHITHARRAL SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1662157 TX OLDHAM COUNTY   school 4845840 180904   WILDORADO ISD 484584005225 180904101 WILDORADO SCHOOL   Regular School No Other PK 11 2020   pre_kindergarten                                                   <10                                             10
1662236 TX LYNN COUNTY   school 4845990 153907   WILSON ISD 484599005241 153907001 WILSON SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10

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