enrollments

Data source: Big Local News · About: Big Local

4,098 rows where grade = "grade_12" and state = "TX" sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_12 · 4,098 ✖
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 ▼
1374436 1374436 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1374535 1374535 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009308164 57814001 DALLAS COUNTY JUVENILE JUSTICE   Alternative School Yes High 05 12 2021   grade_12                                                   <10                                             10
1375152 1375152 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783011510 101903011 CROSSROADS   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1375721 1375721 TX POTTER COUNTY   school 4808130 188901   AMARILLO ISD 480813007086 188901003 AMARILLO AREA CTR FOR ADVANCED LRN   Regular School No High 09 12 2021   grade_12                                                   <10                                             10
1376062 1376062 TX LAMB COUNTY   school 4808160 140901   AMHERST ISD 480816000188 140901001 AMHERST SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1376130 1376130 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831016825 20902003 BRAZORIA CO ALTER ED CTR   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1376181 1376181 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831006642 20902002 STUDENT ALTERNATIVE CTR   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1376216 1376216 TX COLLIN COUNTY   school 4808340 43902   ANNA ISD 480834010492 43902197 SPECIAL PROG CTR/J J A E P   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1376867 1376867 TX TARRANT COUNTY   school 4808700 220901   ARLINGTON ISD 480870005792 220901007 TURNING POINT SECONDARY SCHOOL   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1377108 1377108 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005646 227901250 AUSTIN ST HOSPITAL   Alternative School No High 05 12 2021   grade_12                                                   <10                                             10
1377458 1377458 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894007137 227901035 LEADERSHIP ACADEMY   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1377836 1377836 TX REFUGIO COUNTY   school 4809000 196901   AUSTWELL-TIVOLI ISD 480900000371 196901001 AUSTWELL-TIVOLI H S   Regular School No High 07 12 2021   grade_12                                                   <10                                             10
1377878 1377878 TX CASS COUNTY   school 4809090 34902   AVINGER ISD 480909000378 34902001 AVINGER SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1377900 1377900 TX MCLENNAN COUNTY   school 4809150 161918   AXTELL ISD 480915006358 161918199 WACO CTR FOR YOUTH   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1377910 1377910 TX TARRANT COUNTY   school 4809200 220915   AZLE ISD 480920012892 220915003 AZLE HORNET ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1377976 1377976 TX RUNNELS COUNTY   school 4809300 200901   BALLINGER ISD 480930011322 200901003 FAIRVIEW ACCELERATED   Alternative School No High 12 12 2021   grade_12                                                   <10                                             10
1377979 1377979 TX RUNNELS COUNTY   school 4809300 200901   BALLINGER ISD 480930012897 200901005 FAIRVIEW ACCELERATED (DAEP)   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1378319 1378319 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967006510 123910006 PATHWAYS LEARNING CTR   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1378565 1378565 TX KNOX COUNTY   school 4809980 138904   BENJAMIN ISD 480998000468 138904001 BENJAMIN SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1378653 1378653 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022709011 193801001 BIG SPRINGS CHARTER SCHOOL   Alternative School Yes Other KG 12 2021   grade_12                                                   <10                                             10
1378666 1378666 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022711321 193801101 HILL COUNTRY YOUTH RANCH   Alternative School Yes Other KG 12 2021   grade_12                                                   <10                                             10
1379427 1379427 TX BRAZORIA COUNTY   school 4811190 20905   BRAZOSPORT ISD 481119007528 20905004 LIGHTHOUSE LEARNING CENTER - DAEP   Alternative School No Other 04 12 2021   grade_12                                                   <10                                             10
1379620 1379620 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155000627 25908001 BROOKESMITH SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   10                                             10
1379689 1379689 TX TERRY COUNTY   school 4811610 223901   BROWNFIELD ISD 481161012078 223901005 BROWNFIELD EDUCATION CENTER   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1379776 1379776 TX CAMERON COUNTY   school 4811680 31901   BROWNSVILLE ISD 481168007541 31901034 CAMERON CO J J A E P   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1380140 1380140 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179007816 21902012 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1380254 1380254 TX MILAM COUNTY   school 4811850 166907   BUCKHOLTS ISD 481185000697 166907001 BUCKHOLTS SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1380594 1380594 TX NUECES COUNTY   school 4812420 178903   CALALLEN ISD 481242009003 178903003 NUECES CO J J A E P   Alternative School No High 10 12 2021   grade_12                                                   <10                                             10
1380624 1380624 TX CALHOUN COUNTY   school 4812480 29901   CALHOUN COUNTY ISD 481248007199 29901003 HOPE H S   Alternative School No High 10 12 2021   grade_12                                                   <10                                             10
1381235 1381235 TX TARRANT COUNTY   school 4813170 220917   CASTLEBERRY ISD 481317007121 220917003 REACH H S   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1381241 1381241 TX TARRANT COUNTY   school 4813170 220917   CASTLEBERRY ISD 481317007446 220917004 T R U C E LEARNING CTR   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1381300 1381300 TX DALLAS COUNTY   school 4813230 57904   CEDAR HILL ISD 481323008182 57904007 JJAEP   Alternative School No High 10 12 2021   grade_12                                                   <10                                             10
1381395 1381395 TX SHELBY COUNTY   school 4813320 210901   CENTER ISD 481332013661 210901002 ROUGHRIDER ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1381414 1381414 TX KERR COUNTY   school 4813350 133901   CENTER POINT ISD 481335013963 133901004 NORTH STAR H S   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1381437 1381437 TX TRINITY COUNTY   school 4813380 228904   CENTERVILLE ISD 481338000839 228904001 CENTERVILLE H S   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1381475 1381475 TX ANGELINA COUNTY   school 4813500 3907   CENTRAL ISD 481350007164 3907004 STUBBLEFIELD LRN CTR   Alternative School No High 11 12 2021   grade_12                                                   <10                                             10
1381547 1381547 TX HARTLEY COUNTY   school 4813620 103901   CHANNING ISD 481362000857 103901001 CHANNING SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1381647 1381647 TX TYLER COUNTY   school 4813770 229906   CHESTER ISD 481377000868 229906001 CHESTER H S   Regular School No High 06 12 2021   grade_12                                                   10                                             10
1381785 1381785 TX EASTLAND COUNTY   school 4814070 67902   CISCO ISD 481407009215 67902004 CISCO LEARNING CENTER   Alternative School No High 10 12 2021   grade_12                                                   <10                                             10
1381961 1381961 TX GALVESTON COUNTY   school 4814280 84910   CLEAR CREEK ISD 481428009498 84910008 CLEAR PATH ALTERNATIVE SCHOOL   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1382220 1382220 TX LIBERTY COUNTY   school 4814370 146901   CLEVELAND ISD 481437007381 146901003 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1382538 1382538 TX MITCHELL COUNTY   school 4814640 168901   COLORADO ISD 481464010962 168901003 WALLACE ACCELERATED H S   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1382563 1382563 TX COLORADO COUNTY   school 4814700 45902   COLUMBUS ISD 481470012678 45902002 COLUMBUS ALTERNATIVE SCHOOL   Alternative School No High 10 12 2021   grade_12                                                   <10                                             10
1382623 1382623 TX COMAL COUNTY   school 4814730 46902   COMAL ISD 481473012361 46902206 COMAL DISCIPLINE CENTER   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1382891 1382891 TX HARRIS COUNTY   school 4800127 101842   COMQUEST ACADEMY 480012708255 101842001 COMQUEST ACADEMY   Alternative School Yes Other KG 12 2021   grade_12                                                   <10                                             10
1382904 1382904 TX VAL VERDE COUNTY   school 4814920 233903   COMSTOCK ISD 481492000991 233903001 COMSTOCK SCHOOL   Regular School No Other KG 12 2021   grade_12                                                   <10                                             10
1383081 1383081 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500017045 170902010 JJAEP   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1383704 1383704 TX NUECES COUNTY   school 4815270 178904   CORPUS CHRISTI ISD 481527005681 178904054 STUDENT SUPPORT CENTER   Alternative School No High 12 12 2021   grade_12                                                   <10                                             10
1383824 1383824 TX HALE COUNTY   school 4815360 95902   COTTON CENTER ISD 481536001112 95902001 COTTON CENTER SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1383952 1383952 TX BOSQUE COUNTY   school 4815570 18908   CRANFILLS GAP ISD 481557001129 18908001 CRANFILLS GAP SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1384005 1384005 TX HARRIS COUNTY   school 4815750 101906   CROSBY ISD 481575012769 101906004 CROSBY CROSSROADS ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1384051 1384051 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 12 2021   grade_12                                                   <10                                             10
1384454 1384454 TX HARRIS COUNTY   school 4816110 101907   CYPRESS-FAIRBANKS ISD 481611007624 101907037 CYPRESS-FAIRBANKS J J A E P   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1385030 1385030 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006930 57905029 BARBARA M MANNS H S DAEP   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1385483 1385483 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006391 57905099 HOSPITAL/HOMEBOUND   Alternative School No Other KG 12 2021   grade_12                                                   <10                                             10
1386375 1386375 TX LIPSCOMB COUNTY   school 4816320 148905   DARROUZETT ISD 481632001699 148905101 DARROUZETT SCHOOLS   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1386403 1386403 TX DAWSON COUNTY   school 4816350 58902   DAWSON ISD 481635001399 58902001 DAWSON SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1386418 1386418 TX LIBERTY COUNTY   school 4816410 146902   DAYTON ISD 481641011383 146902007 FREDDA NOTTINGHAM ALTERNATIVE EDUC   Alternative School No High 10 12 2021   grade_12                                                   <10                                             10
1386520 1386520 TX HARRIS COUNTY   school 4816530 101908   DEER PARK ISD 481653011769 101908007 H S POINT   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1386654 1386654 TX HUDSPETH COUNTY   school 4816650 115903   DELL CITY ISD 481665001429 115903001 DELL CITY SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1386691 1386691 TX GRAYSON COUNTY   school 4816710 91903   DENISON ISD 481671007294 91903002 PATHWAYS H S   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1386748 1386748 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674007581 61901006 DENTON CO J J A E P   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1386823 1386823 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674003735 61901040 JOE DALE SPARKS CAMPUS   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1386828 1386828 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674007265 61901005 LESTER DAVIS   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1387096 1387096 TX ANGELINA COUNTY   school 4817040 3905   DIBOLL ISD 481704007503 3905004 STUBBLEFIELD LRN CTR   Alternative School No High 10 12 2021   grade_12                                                   <10                                             10
1387609 1387609 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770007447 220918003 ALTER DISCIPLINE CAMPUS   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1388320 1388320 TX HIDALGO COUNTY   school 4818060 108903   EDCOUCH-ELSA ISD 481806013006 108903004 EDCOUCH-ELSA H S ACADEMY   Alternative School No High 10 12 2021   grade_12                                                   <10                                             10
1388372 1388372 TX BEXAR COUNTY   school 4818150 15905   EDGEWOOD ISD 481815012382 15905124 BURLESON CENTER   Regular School No High 12 12 2021   grade_12                                                   <10                                             10
1388626 1388626 TX HIDALGO COUNTY   school 4818180 108904   EDINBURG CISD 481818007651 108904039 J J A E P   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1389239 1389239 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830006945 71902027 TELLES ACADEMY   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1389449 1389449 TX ERATH COUNTY   school 4800159 72802   ERATH EXCELS ACADEMY INC 480015912097 72802002 COASTAL HORIZONS ACADEMY   Alternative School Yes High 07 12 2021   grade_12                                                   <10                                             10
1389586 1389586 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004907909 101811001 HARRIS COUNTY JUVENILE DETENTION C   Alternative School Yes High 07 12 2021   grade_12                                                   <10                                             10
1389593 1389593 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908231 101811004 HARRIS COUNTY YOUTH VILLAGE   Alternative School Yes High 06 12 2021   grade_12                                                   <10                                             10
1389599 1389599 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908233 101811006 LEADERSHIP ACADEMY   Alternative School Yes High 07 12 2021   grade_12                                                   <10                                             10
1389794 1389794 TX WILSON COUNTY   school 4819350 247901   FLORESVILLE ISD 481935007499 247901002 FLORESVILLE ALTER CTR   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1389872 1389872 TX LIPSCOMB COUNTY   school 4819500 148902   FOLLETT ISD 481950001806 148902001 FOLLETT SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1389887 1389887 TX MONTAGUE COUNTY   school 4819530 169910   FORESTBURG ISD 481953001808 169910001 FORESTBURG SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   10                                             10
1390106 1390106 TX FORT BEND COUNTY   school 4819650 79907   FORT BEND ISD 481965012235 79907038 FERNDELL HENRY CENTER FOR LEARNING   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1390115 1390115 TX FORT BEND COUNTY   school 4819650 79907   FORT BEND ISD 481965007605 79907010 FORT BEND CO ALTER   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1390622 1390622 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021056 220905210 CHILDREN'S MEDICAL CTR   Alternative School No Other KG 12 2021   grade_12                                                   <10                                             10
1390844 1390844 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005717 220905026 JO KELLY SP ED   Alternative School No Other PK 12 2021   grade_12                                                   <10                                             10
1391565 1391565 TX COLLIN COUNTY   school 4820010 43905   FRISCO ISD 482001011403 43905127 CARROLL EL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1392631 1392631 TX NACOGDOCHES COUNTY   school 4820400 174903   GARRISON ISD 482040011313 174903003 NACOGDOCHES COUNTY DAEP COOP   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1392697 1392697 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001407174 15802001 GEORGE GERVIN ACADEMY   Alternative School Yes Other PK 12 2021   grade_12                                                   <10                                             10
1392703 1392703 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001410415 15802004 RUTH JONES MCCLENDON MIDDLE   Alternative School Yes High 06 12 2021   grade_12                                                   <10                                             10
1392743 1392743 TX WILLIAMSON COUNTY   school 4820600 246904   GEORGETOWN ISD 482060014151 246904204 C O R E   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1392966 1392966 TX MONTAGUE COUNTY   school 4820970 169906   GOLD BURG ISD 482097002091 169906001 GOLD BURG SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1393205 1393205 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115008605 101911006 POINT ALTERNATIVE CENTER   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1393257 1393257 TX PALO PINTO COUNTY   school 4821180 182901   GORDON ISD 482118002125 182901001 GORDON SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1393316 1393316 TX YOUNG COUNTY   school 4821360 252901   GRAHAM ISD 482136021562 252901002 GRAHAM LEARNING CTR   Alternative School No High 11 12 2021   grade_12                                                   <10                                             10
1393639 1393639 TX WARD COUNTY   school 4821480 238904   GRANDFALLS-ROYALTY ISD 482148002168 238904001 GRANDFALLS-ROYALTY SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1393682 1393682 TX TOM GREEN COUNTY   school 4821600 226907   GRAPE CREEK ISD 482160008930 226907005 FAIRVIEW DAEP   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1393814 1393814 TX TARRANT COUNTY   school 4821660 220906   GRAPEVINE-COLLEYVILLE ISD 482166008034 220906038 TARRANT CO J J A E P   Alternative School No High 10 12 2021   grade_12                                                   <10                                             10
1393923 1393923 TX HUNT COUNTY   school 4821720 116905   GREENVILLE ISD 482172007361 116905004 GREENVILLE ALTERNATIVE EDUCATIONAL   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1394095 1394095 TX COMANCHE COUNTY   school 4821990 47903   GUSTINE ISD 482199002215 47903001 GUSTINE SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1394109 1394109 TX KING COUNTY   school 4822020 135001   GUTHRIE CSD 482202002217 135001001 GUTHRIE SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1394343 1394343 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247006559 15904003 HAC DAEP H S   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1394466 1394466 TX CAMERON COUNTY   school 4822530 31903   HARLINGEN CISD 482253008717 31903004 CAMERON CO J J A E P   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1394568 1394568 TX CAMERON COUNTY   school 4822530 31903   HARLINGEN CISD 482253006940 31903118 SECONDARY ALTER CTR   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1395071 1395071 TX WILBARGER COUNTY   school 4822620 244901   HARROLD ISD 482262002298 244901001 HARROLD SCHOOL   Regular School No Other KG 12 2021   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]);