enrollments

Data source: Big Local News · About: Big Local

2,075 rows where grade = "grade_12", state = "TX" and year = 2020 sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,075 ✖

grade ✖

  • grade_12 · 2,075 ✖
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 ▼
1613163 1613163 TX HALE COUNTY   school 4807410 95901   ABERNATHY ISD 480741009626 95901003 ABERNATHY DAEP   Alternative School No High 08 12 2020   grade_12                                                   <10                                             10
1613231 1613231 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1613329 1613329 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009308164 57814001 DALLAS COUNTY JUVENILE JUSTICE   Alternative School Yes High 06 12 2020   grade_12                                                   <10                                             10
1613340 1613340 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312005 57814005 LETOT CAMPUS   Alternative School Yes High 07 12 2020   grade_12                                                   <10                                             10
1613347 1613347 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312112 57814003 MEDLOCK YOUTH VILLAGE   Alternative School Yes High 06 12 2020   grade_12                                                   <10                                             10
1613917 1613917 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783008599 101903005 ALIEF LEARNING CTR (6-12)   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1613973 1613973 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783011510 101903011 CROSSROADS   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1614391 1614391 TX BRAZORIA COUNTY   school 4808090 20901   ALVIN ISD 480809008709 20901004 BRAZORIA CO J J A E P   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1614886 1614886 TX LAMB COUNTY   school 4808160 140901   AMHERST ISD 480816000188 140901001 AMHERST SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   <10                                             10
1614961 1614961 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831016825 20902003 BRAZORIA CO ALTER ED CTR   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1614969 1614969 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831007814 20902004 BRAZORIA CO JUVENILE DETENTION   Alternative School No High 05 12 2020   grade_12                                                   <10                                             10
1615010 1615010 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831006642 20902002 STUDENT ALTERNATIVE CTR   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1615028 1615028 TX COLLIN COUNTY   school 4808340 43902   ANNA ISD 480834013928 43902005 ANNA ISD DAEP   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1615094 1615094 TX HOCKLEY COUNTY   school 4808460 110901   ANTON ISD 480846000214 110901001 ANTON SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   <10                                             10
1615687 1615687 TX TARRANT COUNTY   school 4808700 220901   ARLINGTON ISD 480870005792 220901007 TURNING POINT SECONDARY SCHOOL   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1615847 1615847 TX DENTON COUNTY   school 4808910 61907   AUBREY ISD 480891010621 61907002 DENTON CO J J A E P   Alternative School No High 12 12 2020   grade_12                                                   <10                                             10
1615903 1615903 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894009076 227901012 ALTERNATIVE LEARNING CENTER   Alternative School No High 06 12 2020   grade_12                                                   10                                             10
1615930 1615930 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005646 227901250 AUSTIN ST HOSPITAL   Alternative School No Other 01 12 2020   grade_12                                                   <10                                             10
1616286 1616286 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894007137 227901035 LEADERSHIP ACADEMY   Alternative School No High 08 12 2020   grade_12                                                   <10                                             10
1616476 1616476 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894008389 227901032 PHOENIX ACADEMY   Alternative School No High 08 12 2020   grade_12                                                   <10                                             10
1616598 1616598 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894009077 227901030 TRAVIS COUNTY JUVENILE DETENTION C   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1616764 1616764 TX MCLENNAN COUNTY   school 4809150 161918   AXTELL ISD 480915006358 161918199 WACO CTR FOR YOUTH   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1616774 1616774 TX TARRANT COUNTY   school 4809200 220915   AZLE ISD 480920012892 220915003 AZLE HORNET ACADEMY   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1616847 1616847 TX RUNNELS COUNTY   school 4809300 200901   BALLINGER ISD 480930012897 200901005 FAIRVIEW ACCELERATED (DAEP)   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1616862 1616862 TX REEVES COUNTY   school 4809330 195902   BALMORHEA ISD 480933000392 195902001 BALMORHEA SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   10                                             10
1616919 1616919 TX CHAMBERS COUNTY   school 4809450 36902   BARBERS HILL ISD 480945011547 36902005 ALTERNATIVE SCHOOL   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1617189 1617189 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967006510 123910006 PATHWAYS LEARNING CTR   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1617434 1617434 TX KNOX COUNTY   school 4809980 138904   BENJAMIN ISD 480998000468 138904001 BENJAMIN SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   <10                                             10
1617491 1617491 TX HOWARD COUNTY   school 4810200 114901   BIG SPRING ISD 481020013473 114901003 ANDERSON ACCELERATED H S   Alternative School No High 11 12 2020   grade_12                                                   <10                                             10
1617535 1617535 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022711321 193801101 HILL COUNTRY YOUTH RANCH   Alternative School Yes Other KG 12 2020   grade_12                                                   <10                                             10
1618213 1618213 TX AUSTIN COUNTY   school 4844470 8903   BRAZOS ISD 484447013001 8903103 PRAIRIE HARBOR ALTERNATIVE SCHOOL   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1618311 1618311 TX BRAZORIA COUNTY   school 4811190 20905   BRAZOSPORT ISD 481119007528 20905004 LIGHTHOUSE LEARNING CENTER - DAEP   Alternative School No High 05 12 2020   grade_12                                                   <10                                             10
1618517 1618517 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155013724 25908003 GENESIS CAMPUS   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1618578 1618578 TX TERRY COUNTY   school 4811610 223901   BROWNFIELD ISD 481161012078 223901005 BROWNFIELD EDUCATION CENTER   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1618669 1618669 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_12                                                   <10                                             10
1618948 1618948 TX BROWN COUNTY   school 4811700 25902   BROWNWOOD ISD 481170011156 25902003 BROWNWOOD ACCELERATED H S   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1618977 1618977 TX MCLENNAN COUNTY   school 4811730 161919   BRUCEVILLE-EDDY ISD 481173011401 161919005 AXTELL/BE DAEP   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1619024 1619024 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179008456 21902014 BRAZOS CO JUVENILE DETENTION CENTE   Alternative School No Other 04 12 2020   grade_12                                                   <10                                             10
1619046 1619046 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179007816 21902012 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1619160 1619160 TX MILAM COUNTY   school 4811850 166907   BUCKHOLTS ISD 481185000697 166907001 BUCKHOLTS SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   10                                             10
1619174 1619174 TX PECOS COUNTY   school 4811910 186901   BUENA VISTA ISD 481191000699 186901001 BUENA VISTA SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   10                                             10
1619389 1619389 TX BURNET COUNTY   school 4812220 27903   BURNET CISD 481222003287 27903003 QUEST H S   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1619506 1619506 TX NUECES COUNTY   school 4812420 178903   CALALLEN ISD 481242009003 178903003 NUECES CO J J A E P   Alternative School No High 12 12 2020   grade_12                                                   <10                                             10
1619801 1619801 TX RANDALL COUNTY   school 4812810 191901   CANYON ISD 481281005172 191901003 YOUTH CTR OF HIGH PLAINS   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1619931 1619931 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305008510 57903008 DENTON COUNTY JJAEP CFB CAMPUS   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1620078 1620078 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305007241 57903005 SALAZAR DISTRICT ALTERNATIVE EDUCA   Alternative School No Other 03 12 2020   grade_12                                                   <10                                             10
1620155 1620155 TX TARRANT COUNTY   school 4813170 220917   CASTLEBERRY ISD 481317007121 220917003 REACH H S   Alternative School No High 09 12 2020   grade_12                                                   10                                             10
1620292 1620292 TX COLLIN COUNTY   school 4813290 43903   CELINA ISD 481329009159 43903002 COLLIN CO J J A E P   Alternative School No High 12 12 2020   grade_12                                                   <10                                             10
1620334 1620334 TX KERR COUNTY   school 4813350 133901   CENTER POINT ISD 481335013963 133901004 NORTH STAR H S   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1620357 1620357 TX TRINITY COUNTY   school 4813380 228904   CENTERVILLE ISD 481338000839 228904001 CENTERVILLE H S   Regular School No Other PK 12 2020   grade_12                                                   <10                                             10
1620393 1620393 TX ANGELINA COUNTY   school 4813500 3907   CENTRAL ISD 481350007164 3907004 STUBBLEFIELD LRN CTR   Alternative School No High 12 12 2020   grade_12                                                   <10                                             10
1620464 1620464 TX HARTLEY COUNTY   school 4813620 103901   CHANNING ISD 481362000857 103901001 CHANNING SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   <10                                             10
1620559 1620559 TX SAN SABA COUNTY   school 4813740 206903   CHEROKEE ISD 481374000866 206903001 CHEROKEE SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   <10                                             10
1620649 1620649 TX MCLENNAN COUNTY   school 4813960 161920   CHINA SPRING ISD 481396007995 161920002 TAG   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1620712 1620712 TX EASTLAND COUNTY   school 4814070 67902   CISCO ISD 481407009215 67902004 CISCO LEARNING CENTER   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1620889 1620889 TX GALVESTON COUNTY   school 4814280 84910   CLEAR CREEK ISD 481428009498 84910008 CLEAR PATH ALTERNATIVE SCHOOL   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1621147 1621147 TX LIBERTY COUNTY   school 4814370 146901   CLEVELAND ISD 481437007381 146901003 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1621493 1621493 TX COLORADO COUNTY   school 4814700 45902   COLUMBUS ISD 481470012678 45902002 COLUMBUS ALTERNATIVE SCHOOL   Alternative School No High 08 12 2020   grade_12                                                   <10                                             10
1621555 1621555 TX COMAL COUNTY   school 4814730 46902   COMAL ISD 481473012361 46902206 COMAL DISCIPLINE CENTER   Alternative School No High 05 12 2020   grade_12                                                   <10                                             10
1621598 1621598 TX COMAL COUNTY   school 4814730 46902   COMAL ISD 481473013793 46902210 JJAEP   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1621744 1621744 TX COLLIN COUNTY   school 4814850 43918   COMMUNITY ISD 481485010523 43918003 BRAVES ACADEMY   Alternative School No High 08 12 2020   grade_12                                                   <10                                             10
1621808 1621808 TX HARRIS COUNTY   school 4800127 101842   COMQUEST ACADEMY 480012708255 101842001 COMQUEST ACADEMY   Alternative School Yes Other 01 12 2020   grade_12                                                   <10                                             10
1621821 1621821 TX VAL VERDE COUNTY   school 4814920 233903   COMSTOCK ISD 481492000991 233903001 COMSTOCK SCHOOL   Regular School No Other KG 12 2020   grade_12                                                   <10                                             10
1621999 1621999 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500017045 170902010 JJAEP   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1622634 1622634 TX NUECES COUNTY   school 4815270 178904   CORPUS CHRISTI ISD 481527005681 178904054 STUDENT SUPPORT CENTER   Alternative School No Other 02 12 2020   grade_12                                                   <10                                             10
1622753 1622753 TX HALE COUNTY   school 4815360 95902   COTTON CENTER ISD 481536001112 95902001 COTTON CENTER SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   <10                                             10
1622884 1622884 TX BOSQUE COUNTY   school 4815570 18908   CRANFILLS GAP ISD 481557001129 18908001 CRANFILLS GAP SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   <10                                             10
1622962 1622962 TX HARRIS COUNTY   school 4815750 101906   CROSBY ISD 481575010727 101906105 HIGHPOINT SCHOOL EAST (CROSBY)   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1623968 1623968 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006930 57905029 BARBARA M MANNS H S DAEP   Alternative School No High 08 12 2020   grade_12                                                   <10                                             10
1624403 1624403 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006391 57905099 HOSPITAL/HOMEBOUND   Alternative School No Other PK 12 2020   grade_12                                                   <10                                             10
1624597 1624597 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623010565 57905096 JUVENILE JUSTICE AEP   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1624784 1624784 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006965 57905030 MAYA ANGELOU H S   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1625313 1625313 TX LIPSCOMB COUNTY   school 4816320 148905   DARROUZETT ISD 481632001699 148905101 DARROUZETT SCHOOLS   Regular School No Other PK 12 2020   grade_12                                                   <10                                             10
1625340 1625340 TX DAWSON COUNTY   school 4816350 58902   DAWSON ISD 481635001399 58902001 DAWSON SCHOOL   Regular School No Other KG 12 2020   grade_12                                                   <10                                             10
1625353 1625353 TX LIBERTY COUNTY   school 4816410 146902   DAYTON ISD 481641011383 146902007 FREDDA NOTTINGHAM ALTERNATIVE EDUC   Alternative School No High 12 12 2020   grade_12                                                   <10                                             10
1625454 1625454 TX HARRIS COUNTY   school 4816530 101908   DEER PARK ISD 481653011769 101908007 H S POINT   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1625590 1625590 TX HUDSPETH COUNTY   school 4816650 115903   DELL CITY ISD 481665001429 115903001 DELL CITY SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   <10                                             10
1625628 1625628 TX GRAYSON COUNTY   school 4816710 91903   DENISON ISD 481671007294 91903002 PATHWAYS H S   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1625760 1625760 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674003735 61901040 JOE DALE SPARKS CAMPUS   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1625770 1625770 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674007265 61901005 LESTER DAVIS   Alternative School No Other 03 12 2020   grade_12                                                   <10                                             10
1625914 1625914 TX DALLAS COUNTY   school 4816860 57906   DESOTO ISD 481686013373 57906008 DESOTO ALTERNATIVE EDUCATION CENTE   Alternative School No Other 04 12 2020   grade_12                                                   <10                                             10
1625987 1625987 TX MEDINA COUNTY   school 4816950 163901   DEVINE ISD 481695012708 163901004 DEVINE DAEP SCHOOL   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1626044 1626044 TX ANGELINA COUNTY   school 4817040 3905   DIBOLL ISD 481704007503 3905004 STUBBLEFIELD LRN CTR   Alternative School No High 10 12 2020   grade_12                                                   <10                                             10
1626551 1626551 TX DALLAS COUNTY   school 4817640 57907   DUNCANVILLE ISD 481764008519 57907005 SUMMIT LEARNING CENTER   Alternative School No High 07 12 2020   grade_12                                                   10                                             10
1626564 1626564 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770007447 220918003 ALTER DISCIPLINE CAMPUS   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1626696 1626696 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770007731 220918007 TARRANT CO J J A E P   Alternative School No High 08 12 2020   grade_12                                                   <10                                             10
1626730 1626730 TX MAVERICK COUNTY   school 4817730 159901   EAGLE PASS ISD 481773007032 159901003 DAEP   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1626922 1626922 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785008449 15911003 EAST CENTRAL CHOICE PROGAM   Alternative School No High 05 12 2020   grade_12                                                   <10                                             10
1627037 1627037 TX ECTOR COUNTY   school 4818000 68901   ECTOR COUNTY ISD 481800001596 68901004 ALTER ED CTR   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1627280 1627280 TX HIDALGO COUNTY   school 4818060 108903   EDCOUCH-ELSA ISD 481806013006 108903004 EDCOUCH-ELSA H S ACADEMY   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1627320 1627320 TX CONCHO COUNTY   school 4818070 48901   EDEN CISD 481807001605 48901001 EDEN CISD   Regular School No Other PK 12 2020   grade_12                                                   10                                             10
1627333 1627333 TX BEXAR COUNTY   school 4818150 15905   EDGEWOOD ISD 481815008442 15905042 ALTERNATIVE CENTER   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1628434 1628434 TX ERATH COUNTY   school 4800159 72802   ERATH EXCELS ACADEMY INC 480015912097 72802002 COASTAL HORIZONS ACADEMY   Alternative School Yes High 07 12 2020   grade_12                                                   <10                                             10
1628572 1628572 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004913289 101811008 EXCEL ACADEMY EDUCATION TRANSITION   Alternative School Yes High 07 12 2020   grade_12                                                   <10                                             10
1628583 1628583 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908231 101811004 HARRIS COUNTY YOUTH VILLAGE   Alternative School Yes High 07 12 2020   grade_12                                                   <10                                             10
1628590 1628590 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908233 101811006 LEADERSHIP ACADEMY   Alternative School Yes High 06 12 2020   grade_12                                                   <10                                             10
1628679 1628679 TX DELTA COUNTY   school 4819050 60914   FANNINDEL ISD 481905001776 60914001 FANNINDEL H S   Regular School No High 06 12 2020   grade_12                                                   <10                                             10
1628760 1628760 TX FAYETTE COUNTY   school 4819280 75901   FLATONIA ISD 481928012888 75901103 WHISPERING HILLS ACHIEVEMENT CENTE   Alternative School No Other 03 12 2020   grade_12                                                   <10                                             10
1628783 1628783 TX WILSON COUNTY   school 4819350 247901   FLORESVILLE ISD 481935007499 247901002 FLORESVILLE ALTER CTR   Alternative School No High 05 12 2020   grade_12                                                   <10                                             10
1628811 1628811 TX WILSON COUNTY   school 4819350 247901   FLORESVILLE ISD 481935008091 247901003 WILSON CO J J A E P   Alternative School No High 08 12 2020   grade_12                                                   <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]);