Data source: Big Local News · About: Big Local

8,794 rows where grade = "grade_5" and state = "TX" sorted by total_int

View and edit SQL

year

grade

  • grade_5 · 8,694
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 ▼
1419560 TX TAYLOR COUNTY   school 4800163 221801   TEXAS COLLEGE PREPARATORY ACADEMIE 480016312093 221801027 ISCHOOL HIGH - LEWISVILLE   Regular School Yes Elementary KG 05 2021   grade_5                                                   <10                                             10
1419775 TX HAYS COUNTY   school 4800194 105802   TEXAS PREPARATORY SCHOOL 480019412933 105802101 TEXAS PREPARATORY SCHOOL - AUSTIN   Regular School Yes Elementary KG 06 2021   grade_5                                                   <10                                             10
1419978 TX THROCKMORTON COUNTY   school 4842780 224901   THROCKMORTON COLLEGIATE ISD 484278004880 224901001 THROCKMORTON COLLEGIATE ISD   Regular School Yes Other PK 12 2021   grade_5                                                   <10                                             10
1420203 TX TAYLOR COUNTY   school 4843110 221905   TRENT ISD 484311004900 221905001 TRENT INDEPENDENT SCHOOL DISTRICT   Regular School No Other PK 12 2021   grade_5                                                   <10                                             10
1420272 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913198 46802011 AZLEWAY - WILLOW BEND   Alternative School Yes High 05 12 2021   grade_5                                                   <10                                             10
1420283 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025912947 46802007 PEGASUS SCHOOL   Alternative School Yes High 05 12 2021   grade_5                                                   <10                                             10
1421042 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007111351 227806029 DEPELCHIN-RICHMOND   Alternative School Yes Elementary 02 07 2021   grade_5                                                   <10                                             10
1421053 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007112104 227806032 HELPING HAND   Alternative School Yes Elementary 02 07 2021   grade_5                                                   10                                             10
1421057 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007111352 227806030 LAUREL RIDGE   Alternative School Yes Other 04 12 2021   grade_5                                                   <10                                             10
1421079 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007111445 227806031 OLYMPIA HILLS   Regular School Yes Middle 03 08 2021   grade_5                                                   <10                                             10
1421083 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007108932 227806009 PATHFINDER CAMP   Alternative School Yes Middle 05 10 2021   grade_5                                                   <10                                             10
1421089 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007109407 227806023 PATHWAYS 3H CAMPUS   Alternative School Yes Middle 05 11 2021   grade_5                                                   <10                                             10
1421125 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007109408 227806024 TNC CAMPUS (TEXAS NEUROREHABILITAT   Alternative School Yes Other 04 11 2021   grade_5                                                   <10                                             10
1421143 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007112956 227806034 UT - UNIVERSITY CHARTER SCHOOL AT   Alternative School Yes Other KG 12 2021   grade_5                                                   <10                                             10
1421452 TX JEFF DAVIS COUNTY   school 4843740 122902   VALENTINE ISD 484374004975 122902001 VALENTINE SCHOOL   Regular School No Other PK 12 2021   grade_5                                                   <10                                             10
1421769 TX VICTORIA COUNTY   school 4844150 235902   VICTORIA ISD 484415014058 235902128 LIBERTY DAEP EL   Alternative School No Elementary 03 05 2021   grade_5                                                   <10                                             10
1421910 TX LAVACA COUNTY   school 4844250 143904   VYSEHRAD ISD 484425005027 143904101 VYSEHRAD EL   Regular School No Elementary PK 08 2021   grade_5                                                   <10                                             10
1422175 TX COOKE COUNTY   school 4844490 49908   WALNUT BEND ISD 484449005079 49908101 WALNUT BEND EL   Regular School No Elementary PK 08 2021   grade_5                                                   <10                                             10
1422186 TX BOSQUE COUNTY   school 4844520 18905   WALNUT SPRINGS ISD 484452012079 18905003 WALNUT SPRINGS SCHOOL   Regular School No Other PK 12 2021   grade_5                                                   <10                                             10
1422739 TX DEWITT COUNTY   school 4845240 62905   WESTHOFF ISD 484524005157 62905101 WESTHOFF EL   Regular School No Elementary PK 08 2021   grade_5                                                   <10                                             10
1423119 TX WICHITA COUNTY   school 4845780 243905   WICHITA FALLS ISD 484578009422 243905009 WICHITA COUNTY JUVENILE JUSTICE AE   Alternative School No High 05 12 2021   grade_5                                                   <10                                             10
1423218 TX LYNN COUNTY   school 4845990 153907   WILSON ISD 484599005241 153907001 WILSON SCHOOL   Regular School No Other PK 12 2021   grade_5                                                   <10                                             10
1613293 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009062 221901007 TAYLOR COUNTY LEARNING CENTER   Alternative School No Middle 05 11 2020   grade_5                                                   <10                                             10
1613396 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1613922 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783011491 101903205 ALIEF LEARNING CTR (K-6)   Alternative School No Elementary 01 06 2020   grade_5                                                   <10                                             10
1614879 TX LAMB COUNTY   school 4808160 140901   AMHERST ISD 480816000188 140901001 AMHERST SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1614962 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831007814 20902004 BRAZORIA CO JUVENILE DETENTION   Alternative School No High 05 12 2020   grade_5                                                   <10                                             10
1615787 TX STONEWALL COUNTY   school 4800006 217901   ASPERMONT ISD 480000600274 217901101 ASPERMONT EL   Regular School No Elementary PK 05 2020   grade_5                                                   10                                             10
1616099 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894006356 227901115 DAEP- EL   Alternative School No Middle 05 05 2020   grade_5                                                   <10                                             10
1616535 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005396 227901251 ROSEDALE   Alternative School No Other PK 12 2020   grade_5                                                   <10                                             10
1617081 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967013717 123910134 BEAUMONT NEW EL DAEP   Alternative School No Elementary 02 05 2020   grade_5                                                   <10                                             10
1617427 TX KNOX COUNTY   school 4809980 138904   BENJAMIN ISD 480998000468 138904001 BENJAMIN SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1617528 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022711321 193801101 HILL COUNTRY YOUTH RANCH   Alternative School Yes Other KG 12 2020   grade_5                                                   <10                                             10
1618239 TX BRAZOS COUNTY   school 4800086 21803   BRAZOS SCHOOL FOR INQUIRY & CREATI 480008608128 21803001 BRAZOS SCHOOL FOR INQUIRY AND CREA   Regular School Yes Elementary PK 08 2020   grade_5                                                   10                                             10
1618304 TX BRAZORIA COUNTY   school 4811190 20905   BRAZOSPORT ISD 481119007528 20905004 LIGHTHOUSE LEARNING CENTER - DAEP   Alternative School No High 05 12 2020   grade_5                                                   <10                                             10
1618437 TX DALLAS COUNTY   school 4801462 57851   BRIDGEWAY PREPARATORY ACADEMY 480146213560 57851101 BRIDGEWAY PREPARATORY ACADEMY   Regular School Yes Elementary PK 05 2020   grade_5                                                   <10                                             10
1618504 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155000627 25908001 BROOKESMITH SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1618523 TX BEXAR COUNTY   school 4800268 15830   BROOKS ACADEMIES OF TEXAS 480026813121 15830102 BROOKS ACADEMY LONESTAR   Regular School Yes Elementary KG 05 2020   grade_5                                                   <10                                             10
1619017 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179008456 21902014 BRAZOS CO JUVENILE DETENTION CENTE   Alternative School No Other 04 12 2020   grade_5                                                   <10                                             10
1619153 TX MILAM COUNTY   school 4811850 166907   BUCKHOLTS ISD 481185000697 166907001 BUCKHOLTS SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1619301 TX JOHNSON COUNTY   school 4812180 126902   BURLESON ISD 481218000720 126902041 HUGHES MIDDLE   Regular School No Middle 05 09 2020   grade_5                                                   <10                                             10
1619347 TX JOHNSON COUNTY   school 4812180 126902   BURLESON ISD 481218013766 126902008 REALM   Regular School No Middle 05 11 2020   grade_5                                                   <10                                             10
1619418 TX EL PASO COUNTY   school 4800037 71801   BURNHAM WOOD CHARTER SCHOOL DISTRI 480003713938 71801004 THE LINGUISTIC ACAD OF EL PASO-CUL   Regular School Yes Elementary PK 05 2020   grade_5                                                   10                                             10
1619455 TX HILL COUNTY   school 4812360 109902   BYNUM ISD 481236000730 109902001 BYNUM SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1619588 TX ROBERTSON COUNTY   school 4812540 198902   CALVERT ISD 481254000756 198902101 CALVERT SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1619980 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305005854 57903117 HUIE SPECIAL EDUC CTR   Alternative School No Other PK 12 2020   grade_5                                                   <10                                             10
1620350 TX TRINITY COUNTY   school 4813380 228904   CENTERVILLE ISD 481338000839 228904001 CENTERVILLE H S   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1620552 TX SAN SABA COUNTY   school 4813740 206903   CHEROKEE ISD 481374000866 206903001 CHEROKEE SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1621548 TX COMAL COUNTY   school 4814730 46902   COMAL ISD 481473012361 46902206 COMAL DISCIPLINE CENTER   Alternative School No High 05 12 2020   grade_5                                                   <10                                             10
1621801 TX HARRIS COUNTY   school 4800127 101842   COMQUEST ACADEMY 480012708255 101842001 COMQUEST ACADEMY   Alternative School Yes Other 01 12 2020   grade_5                                                   <10                                             10
1622627 TX NUECES COUNTY   school 4815270 178904   CORPUS CHRISTI ISD 481527005681 178904054 STUDENT SUPPORT CENTER   Alternative School No Other 02 12 2020   grade_5                                                   <10                                             10
1622746 TX HALE COUNTY   school 4815360 95902   COTTON CENTER ISD 481536001112 95902001 COTTON CENTER SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1622985 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 09 2020   grade_5                                                   <10                                             10
1623234 TX SMITH COUNTY   school 4800034 212801   CUMBERLAND ACADEMY 480003413578 212801102 THE LEADERSHIP ACADEMY   Regular School Yes Elementary KG 08 2020   grade_5                                                   <10                                             10
1624194 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623009196 57905241 ELEMENTARY' DISCIPLINARY ALTERNATI   Alternative School No Elementary 04 05 2020   grade_5                                                   <10                                             10
1625306 TX LIPSCOMB COUNTY   school 4816320 148905   DARROUZETT ISD 481632001699 148905101 DARROUZETT SCHOOLS   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1625583 TX HUDSPETH COUNTY   school 4816650 115903   DELL CITY ISD 481665001429 115903001 DELL CITY SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1625763 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674007265 61901005 LESTER DAVIS   Alternative School No Other 03 12 2020   grade_5                                                   <10                                             10
1626176 TX KERR COUNTY   school 4817190 133905   DIVIDE ISD 481719001490 133905101 DIVIDE EL   Regular School No Elementary PK 05 2020   grade_5                                                   <10                                             10
1626331 TX GILLESPIE COUNTY   school 4817400 86024   DOSS CONSOLIDATED CSD 481740001503 86024101 DOSS EL   Regular School No Elementary PK 07 2020   grade_5                                                   <10                                             10
1626916 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785008449 15911003 EAST CENTRAL CHOICE PROGAM   Alternative School No High 05 12 2020   grade_5                                                   <10                                             10
1627798 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830010643 71902171 ABOUT FACE PROGRAM EL   Alternative School No Elementary 01 05 2020   grade_5                                                   <10                                             10
1628448 TX NACOGDOCHES COUNTY   school 4818660 174910   ETOILE ISD 481866001747 174910101 ETOILE EL   Regular School No Elementary PK 08 2020   grade_5                                                   <10                                             10
1628607 TX SHELBY COUNTY   school 4818840 210906   EXCELSIOR ISD 481884001762 210906101 EXCELSIOR EL   Regular School No Elementary PK 08 2020   grade_5                                                   <10                                             10
1628617 TX LAVACA COUNTY   school 4818890 143906   EZZELL ISD 481889001764 143906101 EZZELL EL   Regular School No Elementary PK 08 2020   grade_5                                                   10                                             10
1628672 TX DELTA COUNTY   school 4819050 60914   FANNINDEL ISD 481905001775 60914102 FANNINDEL EL   Regular School No Elementary PK 05 2020   grade_5                                                   <10                                             10
1628757 TX FAYETTE COUNTY   school 4819280 75901   FLATONIA ISD 481928012888 75901103 WHISPERING HILLS ACHIEVEMENT CENTE   Alternative School No Other 03 12 2020   grade_5                                                   <10                                             10
1628777 TX WILSON COUNTY   school 4819350 247901   FLORESVILLE ISD 481935007499 247901002 FLORESVILLE ALTER CTR   Alternative School No High 05 12 2020   grade_5                                                   <10                                             10
1629541 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001832 220905104 BOULEVARD HEIGHTS   Alternative School No Other 01 12 2020   grade_5                                                   <10                                             10
1629549 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021058 220905212 BRIDGE ASSOC   Alternative School No High 05 12 2020   grade_5                                                   <10                                             10
1629608 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021056 220905210 CHILDREN'S MEDICAL CTR   Alternative School No Other KG 12 2020   grade_5                                                   <10                                             10
1629683 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005469 220905024 DETENT CTR   Alternative School No High 05 12 2020   grade_5                                                   <10                                             10
1629812 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970007725 220905252 INSIGHTS LEARNING CENTER   Alternative School No Elementary 03 05 2020   grade_5                                                   <10                                             10
1629839 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005717 220905026 JO KELLY SP ED   Alternative School No Other KG 12 2020   grade_5                                                   <10                                             10
1631961 TX MONTAGUE COUNTY   school 4820970 169906   GOLD BURG ISD 482097002091 169906001 GOLD BURG SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1632664 TX GRAY COUNTY   school 4821560 90905   GRANDVIEW-HOPKINS ISD 482156002172 90905101 GRANDVIEW-HOPKINS EL   Regular School No Elementary KG 06 2020   grade_5                                                   <10                                             10
1633077 TX COMANCHE COUNTY   school 4821990 47903   GUSTINE ISD 482199002215 47903001 GUSTINE SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1633091 TX KING COUNTY   school 4822020 135001   GUTHRIE CSD 482202002217 135001001 GUTHRIE SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1634045 TX WILBARGER COUNTY   school 4822620 244901   HARROLD ISD 482262002298 244901001 HARROLD SCHOOL   Regular School No Other KG 12 2020   grade_5                                                   10                                             10
1634136 TX HAYS COUNTY   school 4800010 105906   HAYS CISD 480001006990 105906002 ALTER IMPACT CTR   Alternative School No High 05 12 2020   grade_5                                                   <10                                             10
1634307 TX DONLEY COUNTY   school 4822850 65902   HEDLEY ISD 482285002317 65902001 HEDLEY SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1634511 TX LIPSCOMB COUNTY   school 4823140 148903   HIGGINS ISD 482314002349 148903001 HIGGINS SCHOOL   Regular School No Other KG 12 2020   grade_5                                                   <10                                             10
1634525 TX GALVESTON COUNTY   school 4823160 84903   HIGH ISLAND ISD 482316002351 84903001 HIGH ISLAND SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   10                                             10
1635070 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364006270 101912013 COMMUNITY SERVICES-SEC   Alternative School No Other PK 12 2020   grade_5                                                   <10                                             10
1635559 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364012042 101912300 INSPIRED FOR EXCELLENCE ACADEMY IN   Alternative School Yes Middle 05 08 2020   grade_5                                                   <10                                             10
1636608 TX HARRIS COUNTY   school 4823820 101925   HUFFMAN ISD 482382010800 101925004 EXCEL ACADEMY   Alternative School No Middle 05 09 2020   grade_5                                                   <10                                             10
1637005 TX TARRANT COUNTY   school 4824060 220916   HURST-EULESS-BEDFORD ISD 482406007730 220916004 ALTER ED PROG   Alternative School No High 05 12 2020   grade_5                                                   <10                                             10
1637846 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313328 15808012 JHW INSPIRE ACADEMY - LEGACY RANCH   Alternative School Yes Other KG 12 2020   grade_5                                                   <10                                             10
1637858 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005312039 15808007 JHW INSPIRE ACADEMY - ROCKDALE   Alternative School Yes High 05 12 2020   grade_5                                                   <10                                             10
1637866 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313326 15808011 JHW INSPIRE ACADEMY - WILLIAMS HOU   Alternative School Yes High 05 12 2020   grade_5                                                   <10                                             10
1638421 TX KENT COUNTY   school 4824660 132902   JAYTON-GIRARD ISD 482466002762 132902001 JAYTON SCHOOLS   Regular School No Other PK 12 2020   grade_5                                                   10                                             10
1639407 TX JOHNSON COUNTY   school 4801455 126801   KAUFFMAN LEADERSHIP ACADEMY 480145513372 126801001 KAUFFMAN LEADERSHIP ACADEMY   Alternative School Yes High 05 12 2020   grade_5                                                   <10                                             10
1639636 TX WHEELER COUNTY   school 4825290 242905   KELTON ISD 482529005755 242905001 KELTON SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1639669 TX KENEDY COUNTY   school 4825410 131001   KENEDY COUNTY WIDE CSD 482541002831 131001103 SARITA EL   Regular School No Elementary PK 06 2020   grade_5                                                   <10                                             10
1639815 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002861 14906022 ADVENTHEALTH SCHOOL   Alternative School No Other 01 12 2020   grade_5                                                   <10                                             10
1639900 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566009455 14906100 EL ALTER LEARNING CENTER   Alternative School No Elementary 01 05 2020   grade_5                                                   <10                                             10
1641400 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658006739 79901004 ALTERNATIVE LEARNING CENTER   Alternative School No High 05 12 2020   grade_5                                                   <10                                             10
1642003 TX PARMER COUNTY   school 4826970 185904   LAZBUDDIE ISD 482697003038 185904001 LAZBUDDIE SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1642314 TX GRAY COUNTY   school 4827090 90902   LEFORS ISD 482709003047 90902001 LEFORS SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   10                                             10
1642420 TX HOCKLEY COUNTY   school 4827240 110902   LEVELLAND ISD 482724003060 110902105 SOUTH EL   Regular School No Elementary 01 05 2020   grade_5                                                   <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]);