Data source: Big Local News · About: Big Local

2,436 rows where grade = "grade_8", state = "TX" and year = 2020 sorted by total_int

View and edit SQL

year

  • 2020 · 2,436

grade

  • grade_8 · 2,436
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 ▼
1613227 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1613254 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009497 221901008 JUVENILE DETENTION CENTER   Alternative School No Secondary 08 11 2020   grade_8                                                   <10                                             10
1613296 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009062 221901007 TAYLOR COUNTY LEARNING CENTER   Alternative School No Middle 05 11 2020   grade_8                                                   <10                                             10
1613318 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007123 221901003 WOODSON CENTER FOR EXCELLENCE   Alternative School No High 08 12 2020   grade_8                                                   <10                                             10
1613331 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312248 57814002 DRC CAMPUS   Alternative School Yes Secondary 07 11 2020   grade_8                                                   <10                                             10
1613336 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312005 57814005 LETOT CAMPUS   Alternative School Yes High 07 12 2020   grade_8                                                   <10                                             10
1613491 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771007620 101902099 ALDINE J J A E P   Alternative School No Middle 08 08 2020   grade_8                                                   <10                                             10
1613675 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000075 101902108 LANE SCHOOL   Special Education School No Other PK 12 2020   grade_8                                                   <10                                             10
1613908 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_8                                                   <10                                             10
1614126 TX HARRIS COUNTY   school 4800035 101815   ALIEF MONTESSORI COMMUNITY SCHOOL 480003507914 101815101 ALIEF MONTESSORI COMMUNITY SCHOOL   Regular School Yes Elementary PK 08 2020   grade_8                                                   <10                                             10
1614913 TX CHAMBERS COUNTY   school 4808190 36901   ANAHUAC ISD 480819013185 36901006 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No Secondary 06 11 2020   grade_8                                                   <10                                             10
1614958 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831016825 20902003 BRAZORIA CO ALTER ED CTR   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1614965 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831007814 20902004 BRAZORIA CO JUVENILE DETENTION   Alternative School No High 05 12 2020   grade_8                                                   <10                                             10
1615006 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831006642 20902002 STUDENT ALTERNATIVE CTR   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1615024 TX COLLIN COUNTY   school 4808340 43902   ANNA ISD 480834013928 43902005 ANNA ISD DAEP   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1615926 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005646 227901250 AUSTIN ST HOSPITAL   Alternative School No Other 01 12 2020   grade_8                                                   <10                                             10
1616282 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894007137 227901035 LEADERSHIP ACADEMY   Alternative School No High 08 12 2020   grade_8                                                   <10                                             10
1616472 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894008389 227901032 PHOENIX ACADEMY   Alternative School No High 08 12 2020   grade_8                                                   <10                                             10
1616538 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005396 227901251 ROSEDALE   Alternative School No Other PK 12 2020   grade_8                                                   <10                                             10
1616587 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894012204 227901027 TRAVIS COUNTY DAY SCHOOL   Alternative School No Secondary 08 11 2020   grade_8                                                   <10                                             10
1616594 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894009077 227901030 TRAVIS COUNTY JUVENILE DETENTION C   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1616916 TX CHAMBERS COUNTY   school 4809450 36902   BARBERS HILL ISD 480945011547 36902005 ALTERNATIVE SCHOOL   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1616942 TX CHAMBERS COUNTY   school 4809450 36902   BARBERS HILL ISD 480945013300 36902006 HIGHPOINT   Alternative School No Middle 08 08 2020   grade_8                                                   <10                                             10
1617162 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967007364 123910011 JEFFERSON CO YOUTH ACAD   Alternative School No Secondary 06 11 2020   grade_8                                                   <10                                             10
1617185 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967006510 123910006 PATHWAYS LEARNING CTR   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1617270 TX CLAY COUNTY   school 4809750 39904   BELLEVUE ISD 480975000446 39904001 BELLEVUE SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   <10                                             10
1617430 TX KNOX COUNTY   school 4809980 138904   BENJAMIN ISD 480998000468 138904001 BENJAMIN SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   <10                                             10
1617518 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022709011 193801001 BIG SPRINGS CHARTER SCHOOL   Alternative School Yes Other KG 12 2020   grade_8                                                   <10                                             10
1617531 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022711321 193801101 HILL COUNTRY YOUTH RANCH   Alternative School Yes Other KG 12 2020   grade_8                                                   10                                             10
1617770 TX NOLAN COUNTY   school 4800005 177903   BLACKWELL CISD 480000500513 177903001 BLACKWELL SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   <10                                             10
1617815 TX BROWN COUNTY   school 4810380 25904   BLANKET ISD 481038005661 25904001 BLANKET SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   10                                             10
1618209 TX AUSTIN COUNTY   school 4844470 8903   BRAZOS ISD 484447013001 8903103 PRAIRIE HARBOR ALTERNATIVE SCHOOL   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1618244 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_8                                                   <10                                             10
1618307 TX BRAZORIA COUNTY   school 4811190 20905   BRAZOSPORT ISD 481119007528 20905004 LIGHTHOUSE LEARNING CENTER - DAEP   Alternative School No High 05 12 2020   grade_8                                                   <10                                             10
1618478 TX COKE COUNTY   school 4811490 41901   BRONTE ISD 481149000623 41901001 BRONTE ISD   Regular School No Other PK 12 2020   grade_8                                                   <10                                             10
1618514 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155013724 25908003 GENESIS CAMPUS   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1618665 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_8                                                   <10                                             10
1619020 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179008456 21902014 BRAZOS CO JUVENILE DETENTION CENTE   Alternative School No Other 04 12 2020   grade_8                                                   <10                                             10
1619026 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179009145 21902015 BRAZOS COUNTY JJAEP   Alternative School No Secondary 06 11 2020   grade_8                                                   <10                                             10
1619156 TX MILAM COUNTY   school 4811850 166907   BUCKHOLTS ISD 481185000697 166907001 BUCKHOLTS SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   <10                                             10
1619797 TX RANDALL COUNTY   school 4812810 191901   CANYON ISD 481281005172 191901003 YOUTH CTR OF HIGH PLAINS   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1620158 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_8                                                   <10                                             10
1620460 TX HARTLEY COUNTY   school 4813620 103901   CHANNING ISD 481362000857 103901001 CHANNING SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   <10                                             10
1620728 TX WICHITA COUNTY   school 4814130 243906   CITY VIEW ISD 481413011091 243906002 WICHITA COUNTY J J A E P   Alternative School No Middle 08 08 2020   grade_8                                                   <10                                             10
1620885 TX GALVESTON COUNTY   school 4814280 84910   CLEAR CREEK ISD 481428009498 84910008 CLEAR PATH ALTERNATIVE SCHOOL   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1621143 TX LIBERTY COUNTY   school 4814370 146901   CLEVELAND ISD 481437007381 146901003 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1621341 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735010464 21901015 COLLEGE STATION JJAEP   Alternative School No Secondary 08 11 2020   grade_8                                                   <10                                             10
1621465 TX MITCHELL COUNTY   school 4814640 168901   COLORADO ISD 481464010962 168901003 WALLACE ACCELERATED H S   Alternative School No High 08 12 2020   grade_8                                                   <10                                             10
1621491 TX COLORADO COUNTY   school 4814700 45902   COLUMBUS ISD 481470012678 45902002 COLUMBUS ALTERNATIVE SCHOOL   Alternative School No High 08 12 2020   grade_8                                                   <10                                             10
1621551 TX COMAL COUNTY   school 4814730 46902   COMAL ISD 481473012361 46902206 COMAL DISCIPLINE CENTER   Alternative School No High 05 12 2020   grade_8                                                   <10                                             10
1621742 TX COLLIN COUNTY   school 4814850 43918   COMMUNITY ISD 481485010523 43918003 BRAVES ACADEMY   Alternative School No High 08 12 2020   grade_8                                                   <10                                             10
1621804 TX HARRIS COUNTY   school 4800127 101842   COMQUEST ACADEMY 480012708255 101842001 COMQUEST ACADEMY   Alternative School Yes Other 01 12 2020   grade_8                                                   <10                                             10
1621823 TX MCLENNAN COUNTY   school 4814970 161921   CONNALLY ISD 481497007692 161921004 CHALLENGE ACADEMY   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1621995 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500017045 170902010 JJAEP   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1622001 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500007998 170902201 JUVENILE DETENTION CTR   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1622370 TX NUECES COUNTY   school 4815270 178904   CORPUS CHRISTI ISD 481527006082 178904009 COLES H S AND EDUCATIONAL CENTER   Alternative School No High 08 12 2020   grade_8                                                   <10                                             10
1622749 TX HALE COUNTY   school 4815360 95902   COTTON CENTER ISD 481536001112 95902001 COTTON CENTER SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   <10                                             10
1622880 TX BOSQUE COUNTY   school 4815570 18908   CRANFILLS GAP ISD 481557001129 18908001 CRANFILLS GAP SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   <10                                             10
1622958 TX HARRIS COUNTY   school 4815750 101906   CROSBY ISD 481575010727 101906105 HIGHPOINT SCHOOL EAST (CROSBY)   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1622968 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000112448 54901003 CROSBYTON DAEP   Alternative School No Middle 08 08 2020   grade_8                                                   <10                                             10
1623237 TX SMITH COUNTY   school 4800034 212801   CUMBERLAND ACADEMY 480003413578 212801102 THE LEADERSHIP ACADEMY   Regular School Yes Elementary KG 08 2020   grade_8                                                   10                                             10
1623389 TX HARRIS COUNTY   school 4816110 101907   CYPRESS-FAIRBANKS ISD 481611007624 101907037 CYPRESS-FAIRBANKS J J A E P   Alternative School No Secondary 08 11 2020   grade_8                                                   <10                                             10
1623964 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006930 57905029 BARBARA M MANNS H S DAEP   Alternative School No High 08 12 2020   grade_8                                                   <10                                             10
1624399 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006391 57905099 HOSPITAL/HOMEBOUND   Alternative School No Other PK 12 2020   grade_8                                                   <10                                             10
1624587 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623001295 57905008 JUSTIN F KIMBALL H S   Regular School No High 08 12 2020   grade_8                                                   <10                                             10
1624593 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623010565 57905096 JUVENILE JUSTICE AEP   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1624781 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006965 57905030 MAYA ANGELOU H S   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1624795 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623007565 57905005 MOISES E MOLINA H S   Regular School No High 08 12 2020   grade_8                                                   <10                                             10
1625284 TX BRAZORIA COUNTY   school 4816260 20910   DAMON ISD 481626001391 20910101 DAMON EL   Regular School No Elementary PK 08 2020   grade_8                                                   <10                                             10
1625336 TX DAWSON COUNTY   school 4816350 58902   DAWSON ISD 481635001399 58902001 DAWSON SCHOOL   Regular School No Other KG 12 2020   grade_8                                                   10                                             10
1625451 TX HARRIS COUNTY   school 4816530 101908   DEER PARK ISD 481653011769 101908007 H S POINT   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1625586 TX HUDSPETH COUNTY   school 4816650 115903   DELL CITY ISD 481665001429 115903001 DELL CITY SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   <10                                             10
1625683 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674007581 61901006 DENTON CO J J A E P   Alternative School No Secondary 08 10 2020   grade_8                                                   <10                                             10
1625756 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674003735 61901040 JOE DALE SPARKS CAMPUS   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1625766 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674007265 61901005 LESTER DAVIS   Alternative School No Other 03 12 2020   grade_8                                                   <10                                             10
1625910 TX DALLAS COUNTY   school 4816860 57906   DESOTO ISD 481686013373 57906008 DESOTO ALTERNATIVE EDUCATION CENTE   Alternative School No Other 04 12 2020   grade_8                                                   <10                                             10
1625984 TX MEDINA COUNTY   school 4816950 163901   DEVINE ISD 481695012708 163901004 DEVINE DAEP SCHOOL   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1626077 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707007290 84901012 GALVESTON CO DETENTION CTR   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1626124 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707007289 84901011 TRANSFORMING LIVES COOPERATIVE (TL   Alternative School No Secondary 07 11 2020   grade_8                                                   <10                                             10
1626152 TX LEE COUNTY   school 4817130 144903   DIME BOX ISD 481713001486 144903001 DIME BOX SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   <10                                             10
1626547 TX DALLAS COUNTY   school 4817640 57907   DUNCANVILLE ISD 481764008519 57907005 SUMMIT LEARNING CENTER   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1626693 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_8                                                   <10                                             10
1626726 TX MAVERICK COUNTY   school 4817730 159901   EAGLE PASS ISD 481773007032 159901003 DAEP   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1626912 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785007517 15911005 BEXAR COUNTY LRN CTR   Alternative School No Secondary 08 11 2020   grade_8                                                   <10                                             10
1626918 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785008449 15911003 EAST CENTRAL CHOICE PROGAM   Alternative School No High 05 12 2020   grade_8                                                   <10                                             10
1627097 TX ECTOR COUNTY   school 4818000 68901   ECTOR COUNTY ISD 481800016986 68901005 ECTOR CO YOUTH CTR   Alternative School No Secondary 06 11 2020   grade_8                                                   <10                                             10
1627330 TX BEXAR COUNTY   school 4818150 15905   EDGEWOOD ISD 481815008442 15905042 ALTERNATIVE CENTER   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1627334 TX BEXAR COUNTY   school 4818150 15905   EDGEWOOD ISD 481815009124 15905010 BEXAR CO J J A E P   Alternative School No Secondary 08 09 2020   grade_8                                                   <10                                             10
1627607 TX HIDALGO COUNTY   school 4818180 108904   EDINBURG CISD 481818006693 108904040 JUVENILE DETENTION CTR   Alternative School No High 07 12 2020   grade_8                                                   10                                             10
1627761 TX DALLAS COUNTY   school 4800186 57833   EDUCATION CENTER INTERNATIONAL ACA 480018613557 57833003 EDUCATION CENTER INTERNATIONAL ACA   Regular School Yes Elementary KG 08 2020   grade_8                                                   <10                                             10
1627948 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830003812 71902025 DELTA ACADEMY   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1628220 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830006945 71902027 TELLES ACADEMY   Alternative School No Secondary 06 11 2020   grade_8                                                   <10                                             10
1628430 TX ERATH COUNTY   school 4800159 72802   ERATH EXCELS ACADEMY INC 480015912097 72802002 COASTAL HORIZONS ACADEMY   Alternative School Yes High 07 12 2020   grade_8                                                   <10                                             10
1628451 TX NACOGDOCHES COUNTY   school 4818660 174910   ETOILE ISD 481866001747 174910101 ETOILE EL   Regular School No Elementary PK 08 2020   grade_8                                                   <10                                             10
1628568 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004913289 101811008 EXCEL ACADEMY EDUCATION TRANSITION   Alternative School Yes High 07 12 2020   grade_8                                                   <10                                             10
1628586 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908233 101811006 LEADERSHIP ACADEMY   Alternative School Yes High 06 12 2020   grade_8                                                   <10                                             10
1628610 TX SHELBY COUNTY   school 4818840 210906   EXCELSIOR ISD 481884001762 210906101 EXCELSIOR EL   Regular School No Elementary PK 08 2020   grade_8                                                   <10                                             10
1628620 TX LAVACA COUNTY   school 4818890 143906   EZZELL ISD 481889001764 143906101 EZZELL EL   Regular School No Elementary PK 08 2020   grade_8                                                   <10                                             10
1628675 TX DELTA COUNTY   school 4819050 60914   FANNINDEL ISD 481905001776 60914001 FANNINDEL H S   Regular School No High 06 12 2020   grade_8                                                   <10                                             10
1628758 TX FAYETTE COUNTY   school 4819280 75901   FLATONIA ISD 481928012888 75901103 WHISPERING HILLS ACHIEVEMENT CENTE   Alternative School No Other 03 12 2020   grade_8                                                   <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]);