Data source: Big Local News · About: Big Local

2,167 rows where grade = "grade_11", state = "TX" and year = 2020 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2020 · 2,167

grade

  • grade_11 · 2,167
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
1615929 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005646 227901250 AUSTIN ST HOSPITAL   Alternative School No Other 01 12 2020   grade_11                                                   <10                                             10
1621807 TX HARRIS COUNTY   school 4800127 101842   COMQUEST ACADEMY 480012708255 101842001 COMQUEST ACADEMY   Alternative School Yes Other 01 12 2020   grade_11                                                   <10                                             10
1629547 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001832 220905104 BOULEVARD HEIGHTS   Alternative School No Other 01 12 2020   grade_11                                                   <10                                             10
1631321 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034000518 57909053 GARLAND AEC   Alternative School No Other 01 12 2020   grade_11                                                   14                                             14
1639821 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002861 14906022 ADVENTHEALTH SCHOOL   Alternative School No Other 01 12 2020   grade_11                                                   <10                                             10
1642646 TX DENTON COUNTY   school 4827300 61902   LEWISVILLE ISD 482730006744 61902005 LEARNING CTR   Alternative School No Other 01 12 2020   grade_11                                                   55                                             55
1647541 TX GONZALES COUNTY   school 4832740 89903   NIXON-SMILEY CISD 483274007008 89903002 NIXON-SMILEY CISD DAEP   Alternative School No Other 01 11 2020   grade_11                                                   <10                                             10
1652542 TX DALLAS COUNTY   school 4837020 57916   RICHARDSON ISD 483702005582 57916006 CHRISTA MCAULIFFE LEARNING CENTER   Alternative School No Other 01 12 2020   grade_11                                                   <10                                             10
1660370 TX SMITH COUNTY   school 4801427 212804   UT TYLER UNIVERSITY ACADEMY 480142712830 212804102 UT TYLER UNIVERSITY ACADEMY AT LON   Regular School Yes Other 01 12 2020   grade_11                                                   21                                             21
1622633 TX NUECES COUNTY   school 4815270 178904   CORPUS CHRISTI ISD 481527005681 178904054 STUDENT SUPPORT CENTER   Alternative School No Other 02 12 2020   grade_11                                                   <10                                             10
1639796 TX HAYS COUNTY   school 4801447 105803   KI CHARTER ACADEMY 480144713122 105803001 KI CHARTER ACADEMY   Alternative School Yes Other 02 12 2020   grade_11                                                   19                                             19
1645316 TX KENDALL COUNTY   school 4801404 130801   MEADOWLAND CHARTER DISTRICT 480140412137 130801001 OAKS ACADEMY   Alternative School Yes Other 02 12 2020   grade_11                                                   <10                                             10
1649381 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023511986 14804002 NEW HORIZONS   Alternative School Yes Other 02 12 2020   grade_11                                                   <10                                             10
1658244 TX KAUFMAN COUNTY   school 4842450 129906   TERRELL ISD 484245005604 129906104 TISD CHILD & ADOLESCENT SCHOOL   Regular School No Other 02 12 2020   grade_11                                                   <10                                             10
1659287 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913198 46802011 AZLEWAY - WILLOW BEND   Alternative School Yes Other 02 12 2020   grade_11                                                   <10                                             10
1620077 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305007241 57903005 SALAZAR DISTRICT ALTERNATIVE EDUCA   Alternative School No Other 03 12 2020   grade_11                                                   <10                                             10
1625769 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674007265 61901005 LESTER DAVIS   Alternative School No Other 03 12 2020   grade_11                                                   10                                             10
1633164 TX HARRISON COUNTY   school 4822170 102904   HALLSVILLE ISD 482217012918 102904010 TEXAS VIRTUAL ACADEMY AT HALLSVILL   Alternative School No Other 03 12 2020   grade_11                                                   956                                             956
1636329 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364012363 101912100 TEXAS CONNECTIONS ACADEMY AT HOUST   Regular School Yes Other 03 12 2020   grade_11                                                   948                                             948
1655649 TX GUADALUPE COUNTY   school 4839690 94901   SEGUIN ISD 483969004070 94901111 DISCIPLINE ALTERNATIVE SCHOOL AT S   Alternative School No Other 03 12 2020   grade_11                                                   <10                                             10
1656947 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006309118 15807004 SOUTHWEST PREPARATORY SCHOOL-NORTH   Alternative School Yes Other 03 12 2020   grade_11                                                   60                                             60
1658601 TX TAYLOR COUNTY   school 4800163 221801   TEXAS COLLEGE PREPARATORY ACADEMIE 480016309583 221801022 ISCHOOL VIRTUAL ACADEMY OF TEXAS   Alternative School Yes Other 03 12 2020   grade_11                                                   80                                             80
1658725 TX TRAVIS COUNTY   school 4800066 227805   TEXAS EMPOWERMENT ACADEMY 480006608057 227805041 TEXAS EMPOWERMENT ACADEMY   Regular School Yes Other 03 11 2020   grade_11                                                   18                                             18
1660086 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007111352 227806030 LAUREL RIDGE   Alternative School Yes Other 03 12 2020   grade_11                                                   <10                                             10
1660152 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007109408 227806024 TNC CAMPUS (TEXAS NEUROREHABILITAT   Alternative School Yes Other 03 12 2020   grade_11                                                   <10                                             10
1618668 TX CAMERON COUNTY   school 4811680 31901   BROWNSVILLE ISD 481168007541 31901034 CAMERON CO J J A E P   Alternative School No Other 04 12 2020   grade_11                                                   12                                             12
1619023 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179008456 21902014 BRAZOS CO JUVENILE DETENTION CENTE   Alternative School No Other 04 12 2020   grade_11                                                   <10                                             10
1625913 TX DALLAS COUNTY   school 4816860 57906   DESOTO ISD 481686013373 57906008 DESOTO ALTERNATIVE EDUCATION CENTE   Alternative School No Other 04 12 2020   grade_11                                                   10                                             10
1628852 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944009238 77901003 P A C   Alternative School No Other 04 11 2020   grade_11                                                   <10                                             10
1646520 TX HIDALGO COUNTY   school 4831040 108908   MISSION CISD 483104008657 108908039 ROOSEVELT ALTERNATIVE SCHOOL   Alternative School No Other 04 12 2020   grade_11                                                   <10                                             10
1649156 TX TRAVIS COUNTY   school 4800058 227804   NYOS CHARTER SCHOOL 480005808056 227804101 NYOS CHARTER SCHOOL   Regular School Yes Other 04 12 2020   grade_11                                                   67                                             67
1659302 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025912947 46802007 PEGASUS SCHOOL   Alternative School Yes Other 04 12 2020   grade_11                                                   14                                             14
1660049 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113287 227806040 AUSTIN OAKS   Alternative School Yes Other 04 12 2020   grade_11                                                   <10                                             10
1660988 TX MCLENNAN COUNTY   school 4844280 161914   WACO ISD 484428007039 161914005 G L WILEY OPPORTUNITY CENTER   Alternative School No Other 04 12 2020   grade_11                                                   <10                                             10
1662145 TX WICHITA COUNTY   school 4845780 243905   WICHITA FALLS ISD 484578009422 243905009 WICHITA COUNTY JUVENILE JUSTICE AE   Alternative School No Other 04 11 2020   grade_11                                                   <10                                             10
1662463 TX COLLIN COUNTY   school 4846530 43914   WYLIE ISD 484653011178 43914004 ACHIEVE ACADEMY   Alternative School No Other 04 12 2020   grade_11                                                   34                                             34
1613298 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009062 221901007 TAYLOR COUNTY LEARNING CENTER   Alternative School No Middle 05 11 2020   grade_11                                                   <10                                             10
1614968 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831007814 20902004 BRAZORIA CO JUVENILE DETENTION   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1615205 TX HARRIS COUNTY   school 4800019 101803   ARISTOI CLASSICAL ACADEMY 480001913071 101803001 ARISTOI CLASSICAL UPPER SCHOOL   Regular School Yes High 05 12 2020   grade_11                                                   28                                             28
1618310 TX BRAZORIA COUNTY   school 4811190 20905   BRAZOSPORT ISD 481119007528 20905004 LIGHTHOUSE LEARNING CENTER - DAEP   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1619353 TX JOHNSON COUNTY   school 4812180 126902   BURLESON ISD 481218013766 126902008 REALM   Regular School No Middle 05 11 2020   grade_11                                                   <10                                             10
1621554 TX COMAL COUNTY   school 4814730 46902   COMAL ISD 481473012361 46902206 COMAL DISCIPLINE CENTER   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1626921 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785008449 15911003 EAST CENTRAL CHOICE PROGAM   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1628782 TX WILSON COUNTY   school 4819350 247901   FLORESVILLE ISD 481935007499 247901002 FLORESVILLE ALTER CTR   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1629552 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021058 220905212 BRIDGE ASSOC   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1629689 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005469 220905024 DETENT CTR   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1632806 TX TARRANT COUNTY   school 4821660 220906   GRAPEVINE-COLLEYVILLE ISD 482166013033 220906007 IUNIVERSITY PREP   Regular School No High 05 12 2020   grade_11                                                   158                                             158
1634141 TX HAYS COUNTY   school 4800010 105906   HAYS CISD 480001006990 105906002 ALTER IMPACT CTR   Alternative School No High 05 12 2020   grade_11                                                   11                                             11
1637011 TX TARRANT COUNTY   school 4824060 220916   HURST-EULESS-BEDFORD ISD 482406007730 220916004 ALTER ED PROG   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1637864 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005312039 15808007 JHW INSPIRE ACADEMY - ROCKDALE   Alternative School Yes High 05 12 2020   grade_11                                                   <10                                             10
1637872 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313326 15808011 JHW INSPIRE ACADEMY - WILLIAMS HOU   Alternative School Yes High 05 12 2020   grade_11                                                   <10                                             10
1639413 TX JOHNSON COUNTY   school 4801455 126801   KAUFFMAN LEADERSHIP ACADEMY 480145513372 126801001 KAUFFMAN LEADERSHIP ACADEMY   Alternative School Yes High 05 12 2020   grade_11                                                   11                                             11
1641405 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658006739 79901004 ALTERNATIVE LEARNING CENTER   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1642022 TX DENTON COUNTY   school 4801420 61804   LEADERSHIP PREP SCHOOL 480142013518 61804002 LEADERSHIP PREP SCHOOL SECONDARY   Regular School Yes High 05 12 2020   grade_11                                                   73                                             73
1645120 TX COLLIN COUNTY   school 4829850 43907   MCKINNEY ISD 482985008486 43907006 COUNTY RESIDENTIAL CENTER   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1646806 TX TITUS COUNTY   school 4831760 225902   MOUNT PLEASANT ISD 483176009399 225902003 MOUNT PLEASANT DAEP   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1647319 TX MONTGOMERY COUNTY   school 4832400 170908   NEW CANEY ISD 483240009358 170908003 PROJECT RESTORE   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1647351 TX MONTGOMERY COUNTY   school 4832400 170908   NEW CANEY ISD 483240007079 170908002 THE LEARNING CTR   Alternative School No High 05 12 2020   grade_11                                                   12                                             12
1651466 TX GARZA COUNTY   school 4835490 85902   POST ISD 483549012914 85902040 GARZA COUNTY REGIONAL JUVENILE CEN   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1654877 TX CAMERON COUNTY   school 4838790 31912   SAN BENITO CISD 483879006942 31912201 HESTER JUVENILE DETENT   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1658307 TX BOWIE COUNTY   school 4842480 19907   TEXARKANA ISD 484248013901 19907006 ESCHOOL PREP   Regular School No Middle 05 11 2020   grade_11                                                   208                                             208
1658423 TX GALVESTON COUNTY   school 4842510 84906   TEXAS CITY ISD 484251009544 84906006 WOODROW WILSON DAEP   Alternative School No High 05 12 2020   grade_11                                                   16                                             16
1659316 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025910529 46802001 TRINITY CHARTER SCHOOL   Alternative School Yes High 05 12 2020   grade_11                                                   <10                                             10
1660112 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007108932 227806009 PATHFINDER CAMP   Alternative School Yes Middle 05 11 2020   grade_11                                                   <10                                             10
1660119 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007109407 227806023 PATHWAYS 3H CAMPUS   Alternative School Yes Middle 05 11 2020   grade_11                                                   <10                                             10
1613230 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2020   grade_11                                                   <10                                             10
1613328 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009308164 57814001 DALLAS COUNTY JUVENILE JUSTICE   Alternative School Yes High 06 12 2020   grade_11                                                   14                                             14
1613346 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312112 57814003 MEDLOCK YOUTH VILLAGE   Alternative School Yes High 06 12 2020   grade_11                                                   <10                                             10
1613430 TX NUECES COUNTY   school 4807530 178901   AGUA DULCE ISD 480753000044 178901001 AGUA DULCE H S   Regular School No High 06 12 2020   grade_11                                                   37                                             37
1613467 TX WOOD COUNTY   school 4807650 250906   ALBA-GOLDEN ISD 480765000053 250906001 ALBA-GOLDEN H S   Regular School No High 06 12 2020   grade_11                                                   66                                             66
1613911 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783008805 101903047 ALIEF ISD J J A E P   Alternative School No Secondary 06 11 2020   grade_11                                                   <10                                             10
1614915 TX CHAMBERS COUNTY   school 4808190 36901   ANAHUAC ISD 480819013185 36901006 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No Secondary 06 11 2020   grade_11                                                   <10                                             10
1614929 TX GRIMES COUNTY   school 4808230 93901   ANDERSON-SHIRO CISD 480823000193 93901001 ANDERSON-SHIRO JR/SR H S   Regular School No High 06 12 2020   grade_11                                                   76                                             76
1615009 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831006642 20902002 STUDENT ALTERNATIVE CTR   Alternative School No High 06 12 2020   grade_11                                                   <10                                             10
1615793 TX STONEWALL COUNTY   school 4800006 217901   ASPERMONT ISD 480000600275 217901001 ASPERMONT H S   Regular School No High 06 12 2020   grade_11                                                   23                                             23
1615902 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894009076 227901012 ALTERNATIVE LEARNING CENTER   Alternative School No High 06 12 2020   grade_11                                                   <10                                             10
1616513 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894011354 227901028 RICHARDS SCH FOR YOUNG WOMEN LEADE   Alternative School No High 06 12 2020   grade_11                                                   101                                             101
1616597 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894009077 227901030 TRAVIS COUNTY JUVENILE DETENTION C   Alternative School No High 06 12 2020   grade_11                                                   <10                                             10
1616728 TX RED RIVER COUNTY   school 4809060 194902   AVERY ISD 480906000376 194902001 AVERY SECONDARY   Regular School No High 06 12 2020   grade_11                                                   25                                             25
1616975 TX BEXAR COUNTY   school 4801438 15834   BASIS TEXAS 480143813036 15834001 BASIS SAN ANTONIO- SHAVANO CAMPUS   Regular School Yes High 06 12 2020   grade_11                                                   85                                             85
1617165 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967007364 123910011 JEFFERSON CO YOUTH ACAD   Alternative School No Secondary 06 11 2020   grade_11                                                   <10                                             10
1617188 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967006510 123910006 PATHWAYS LEARNING CTR   Alternative School No High 06 12 2020   grade_11                                                   13                                             13
1617225 TX PANOLA COUNTY   school 4809690 183901   BECKVILLE ISD 480969000437 183901001 BECKVILLE JR-SR HIGH SCHOOL   Regular School No High 06 12 2020   grade_11                                                   63                                             63
1617915 TX JEFFERSON COUNTY   school 4801410 123807   BOB HOPE SCHOOL 480141012450 123807001 BOB HOPE SCHOOL   Regular School Yes High 06 12 2020   grade_11                                                   108                                             108
1618051 TX LIPSCOMB COUNTY   school 4810830 148901   BOOKER ISD 481083000550 148901001 BOOKER JH/H S   Regular School No High 06 12 2020   grade_11                                                   16                                             16
1618212 TX AUSTIN COUNTY   school 4844470 8903   BRAZOS ISD 484447013001 8903103 PRAIRIE HARBOR ALTERNATIVE SCHOOL   Alternative School No High 06 12 2020   grade_11                                                   <10                                             10
1618451 TX SAN AUGUSTINE COUNTY   school 4811430 203902   BROADDUS ISD 481143000618 203902001 BROADDUS H S   Regular School No High 06 12 2020   grade_11                                                   22                                             22
1618496 TX JASPER COUNTY   school 4811520 121902   BROOKELAND ISD 481152000625 121902001 BROOKELAND H S   Regular School No High 06 12 2020   grade_11                                                   24                                             24
1619029 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179009145 21902015 BRAZOS COUNTY JJAEP   Alternative School No Secondary 06 11 2020   grade_11                                                   <10                                             10
1619403 TX EL PASO COUNTY   school 4800037 71801   BURNHAM WOOD CHARTER SCHOOL DISTRI 480003711452 71801003 DAVINCI SCHOOL FOR SCIENCE AND THE   Regular School Yes High 06 12 2020   grade_11                                                   43                                             43
1619631 TX HUNT COUNTY   school 4812660 116910   CAMPBELL ISD 481266000764 116910001 CAMPBELL H S   Regular School No High 06 12 2020   grade_11                                                   27                                             27
1619800 TX RANDALL COUNTY   school 4812810 191901   CANYON ISD 481281005172 191901003 YOUTH CTR OF HIGH PLAINS   Alternative School No High 06 12 2020   grade_11                                                   <10                                             10
1620161 TX TARRANT COUNTY   school 4813170 220917   CASTLEBERRY ISD 481317007446 220917004 T R U C E LEARNING CTR   Alternative School No Secondary 06 11 2020   grade_11                                                   <10                                             10
1620572 TX TYLER COUNTY   school 4813770 229906   CHESTER ISD 481377000868 229906001 CHESTER H S   Regular School No High 06 12 2020   grade_11                                                   11                                             11
1620691 TX TOM GREEN COUNTY   school 4814010 226901   CHRISTOVAL ISD 481401000886 226901001 CHRISTOVAL H S   Regular School No High 06 12 2020   grade_11                                                   36                                             36
1620771 TX RED RIVER COUNTY   school 4814190 194904   CLARKSVILLE ISD 481419000896 194904002 CLARKSVILLE MIDDLE AND H S   Regular School No High 06 12 2020   grade_11                                                   38                                             38
1620888 TX GALVESTON COUNTY   school 4814280 84910   CLEAR CREEK ISD 481428009498 84910008 CLEAR PATH ALTERNATIVE SCHOOL   Alternative School No High 06 12 2020   grade_11                                                   15                                             15
1620940 TX GALVESTON COUNTY   school 4814280 84910   CLEAR CREEK ISD 481428008791 84910006 HARRIS CO JJAEP   Alternative School No Secondary 06 11 2020   grade_11                                                   <10                                             10
1621146 TX LIBERTY COUNTY   school 4814370 146901   CLEVELAND ISD 481437007381 146901003 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No High 06 12 2020   grade_11                                                   10                                             10
1621998 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500017045 170902010 JJAEP   Alternative School No High 06 12 2020   grade_11                                                   13                                             13

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