Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_12 · 3,998
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
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
1388745 TX JACKSON COUNTY   school 4818210 120901   EDNA ISD 481821013097 120901004 EDNA ALTERNATIVE   Alternative School No High 09 12 2021   grade_12                                                   14                                             14
1388815 TX EL PASO COUNTY   school 4800205 71804   EL PASO ACADEMY 480020508773 71804001 EL PASO ACADEMY   Alternative School Yes High 09 12 2021   grade_12                                                   40                                             40
1388819 TX EL PASO COUNTY   school 4800205 71804   EL PASO ACADEMY 480020510632 71804002 EL PASO ACADEMY WEST   Alternative School Yes High 09 12 2021   grade_12                                                   14                                             14
1388927 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830005464 71902020 COLLEGE CAREER TECHNOLOGY ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   <60                                             60
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
1389369 TX BASTROP COUNTY   school 4818360 11902   ELGIN ISD 481836008426 11902004 PHOENIX H S   Alternative School No High 09 12 2021   grade_12                                                   19                                             19
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
1389453 TX ERATH COUNTY   school 4800159 72802   ERATH EXCELS ACADEMY INC 480015908364 72802001 HUSTON ACADEMY   Alternative School Yes High 09 12 2021   grade_12                                                   <20                                             20
1389543 TX TARRANT COUNTY   school 4818810 220904   EVERMAN ISD 481881012891 220904003 EVERMAN ACADEMY H S   Alternative School No High 09 12 2021   grade_12                                                   <20                                             20
1389569 TX DALLAS COUNTY   school 4800236 57834   EVOLUTION ACADEMY CHARTER SCHOOL 480023613008 57834003 EVOLUTION ACADEMY BEAUMONT   Alternative School Yes High 09 12 2021   grade_12                                                   42                                             42
1389573 TX DALLAS COUNTY   school 4800236 57834   EVOLUTION ACADEMY CHARTER SCHOOL 480023609188 57834001 EVOLUTION ACADEMY CHARTER SCHOOL   Alternative School Yes High 09 12 2021   grade_12                                                   89                                             89
1389577 TX DALLAS COUNTY   school 4800236 57834   EVOLUTION ACADEMY CHARTER SCHOOL 480023612916 57834004 EVOLUTION ACADEMY HOUSTON   Alternative School Yes High 09 12 2021   grade_12                                                   43                                             43
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 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 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908233 101811006 LEADERSHIP ACADEMY   Alternative School Yes High 07 12 2021   grade_12                                                   <10                                             10
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
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 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
1390554 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001832 220905104 BOULEVARD HEIGHTS   Alternative School No Other KG 12 2021   grade_12                                                   19                                             19
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 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
1391149 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970007112 220905021 SUCCESS H S   Alternative School No High 09 12 2021   grade_12                                                   68                                             68
1391185 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021053 220905035 TRANSITION CTR   Alternative School No High 12 12 2021   grade_12                                                   92                                             92
1391357 TX GILLESPIE COUNTY   school 4819840 86901   FREDERICKSBURG ISD 481984021258 86901002 ALTER SCH   Alternative School No High 10 12 2021   grade_12                                                   21                                             21
1392113 TX GALVESTON COUNTY   school 4820280 84902   GALVESTON ISD 482028012288 84902007 AIM COLLEGE & CAREER PREP   Alternative School No High 06 12 2021   grade_12                                                   15                                             15
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 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 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
1392711 TX HARRIS COUNTY   school 4800020 101804   GEORGE I SANCHEZ CHARTER 480002007304 101804001 GEORGE I SANCHEZ CHARTER   Alternative School Yes Other PK 12 2021   grade_12                                                   93                                             93
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
1392757 TX WILLIAMSON COUNTY   school 4820600 246904   GEORGETOWN ISD 482060021554 246904002 CHIP RICHARTE H S   Alternative School No High 10 12 2021   grade_12                                                   <50                                             50
1392950 TX JOHNSON COUNTY   school 4820960 126911   GODLEY ISD 482096013734 126911004 GODLEY LINKS ACADEMY   Alternative School No High 10 12 2021   grade_12                                                   11                                             11
1393199 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115006974 101911005 PETER E HYLAND CENTER   Alternative School No High 10 12 2021   grade_12                                                   96                                             96
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
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
1393369 TX HOOD COUNTY   school 4821390 111901   GRANBURY ISD 482139007006 111901002 STARS ACCELERATED H S   Alternative School No High 09 12 2021   grade_12                                                   27                                             27
1393388 TX DALLAS COUNTY   school 4821420 57910   GRAND PRAIRIE ISD 482142012100 57910009 CROSSWINDS ACCELERATED H S   Alternative School No Other PK 12 2021   grade_12                                                   128                                             128
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 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
1393825 TX TARRANT COUNTY   school 4821660 220906   GRAPEVINE-COLLEYVILLE ISD 482166007116 220906006 THE BRIDGES ACAD ALTER   Alternative School No High 10 12 2021   grade_12                                                   <50                                             50
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
1393947 TX HUNT COUNTY   school 4821720 116905   GREENVILLE ISD 482172006859 116905001 NEW HORIZONS LEARNING CENTER   Alternative School No High 09 12 2021   grade_12                                                   <30                                             30
1394177 TX HARRISON COUNTY   school 4822170 102904   HALLSVILLE ISD 482217012918 102904010 TEXAS VIRTUAL ACADEMY AT HALLSVILL   Alternative School No Other 03 12 2021   grade_12                                                   1030                                             1030
1394326 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247005946 15904004 FRANK M TEJEDA ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   37                                             37
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 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 TX CAMERON COUNTY   school 4822530 31903   HARLINGEN CISD 482253006940 31903118 SECONDARY ALTER CTR   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1395157 TX HAYS COUNTY   school 4800010 105906   HAYS CISD 480001006990 105906002 ALTER IMPACT CTR   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1395248 TX HAYS COUNTY   school 4800010 105906   HAYS CISD 480001008835 105906004 LIVE OAK ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   75                                             75
1395346 TX WALLER COUNTY   school 4822920 237902   HEMPSTEAD ISD 482292013618 237902004 HEMPSTEAD ALTERNATIVE LEARNING CEN   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1395434 TX BEXAR COUNTY   school 4800080 15815   HERITAGE ACADEMY 480008011493 15815041 HERITAGE ACADEMY OF DEL RIO   Alternative School Yes High 09 12 2021   grade_12                                                   40                                             40
1395801 TX HARRIS COUNTY   school 4800115 101821   HOUSTON HEIGHTS HIGH SCHOOL 480011508239 101821001 HOUSTON HEIGHTS CHARTER SCHOOL   Alternative School Yes High 09 12 2021   grade_12                                                   86                                             86
1396075 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364006270 101912013 COMMUNITY SERVICES-SEC   Alternative School No Other 01 12 2021   grade_12                                                   <10                                             10
1396404 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364011265 101912351 HARPER DAEP   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1396645 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364010741 101912324 LIBERTY H S   Alternative School No High 11 12 2021   grade_12                                                   132                                             132
1396799 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364013180 101912485 MIDDLE COLLEGE H S AT HCC FRAGA   Alternative School No High 09 12 2021   grade_12                                                   17                                             17
1396803 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364013076 101912484 MIDDLE COLLEGE H S AT HCC GULFTON   Alternative School No High 09 12 2021   grade_12                                                   25                                             25
1397535 TX ANGELINA COUNTY   school 4823790 3902   HUDSON ISD 482379007162 3902004 STUBBLEFIELD LRN CTR   Alternative School No High 11 12 2021   grade_12                                                   <10                                             10
1397694 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391012774 101913015 HUMBLE COMMUNITY LEARNING CENTER   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1397899 TX ANGELINA COUNTY   school 4824000 3904   HUNTINGTON ISD 482400001969 3904005 PRIDE ALTER SCH   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1398023 TX TARRANT COUNTY   school 4824060 220916   HURST-EULESS-BEDFORD ISD 482406006568 220916005 KEYS H S   Alternative School No High 09 12 2021   grade_12                                                   35                                             35
1398865 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005309121 15808003 JHW INSPIRE ACADEMY - HAYS COUNTY   Alternative School Yes High 07 12 2021   grade_12                                                   <10                                             10
1398877 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313328 15808012 JHW INSPIRE ACADEMY - LEGACY RANCH   Alternative School Yes Other KG 12 2021   grade_12                                                   <10                                             10
1398884 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005312039 15808007 JHW INSPIRE ACADEMY - ROCKDALE   Alternative School Yes High 06 12 2021   grade_12                                                   <10                                             10
1399134 TX DALLAS COUNTY   school 4824420 57912   IRVING ISD 482442006275 57912005 BARBARA CARDWELL CAREER PREPARATOR   Alternative School No High 09 12 2021   grade_12                                                   90                                             90
1399468 TX DALLAS COUNTY   school 4800098 57819   JEAN MASSIEU ACADEMY 480009808169 57819001 JEAN MASSIEU ACADEMY   Alternative School Yes Other PK 12 2021   grade_12                                                   <10                                             10
1399593 TX JOHNSON COUNTY   school 4824930 126905   JOSHUA ISD 482493007013 126905002 NEW HORIZON H S   Alternative School No High 10 12 2021   grade_12                                                   <30                                             30
1399856 TX BEXAR COUNTY   school 4824990 15916   JUDSON ISD 482499006128 15916003 JUDSON LEARNING ACAD   Alternative School No High 10 12 2021   grade_12                                                   <30                                             30
1400000 TX HAYS COUNTY   school 4800132 105801   KATHERINE ANNE PORTER SCHOOL 480013208279 105801001 KATHERINE ANNE PORTER SCHOOL   Alternative School Yes High 09 12 2021   grade_12                                                   29                                             29
1400299 TX HARRIS COUNTY   school 4825170 101914   KATY ISD 482517005516 101914003 OPPORT AWARENESS CTR   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1400437 TX KAUFMAN COUNTY   school 4825200 129903   KAUFMAN ISD 482520009321 129903003 GARY W CAMPBELL H S   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1400464 TX JOHNSON COUNTY   school 4825230 126906   KEENE ISD 482523007014 126906002 ALTER LEARNING CTR   Alternative School No High 11 12 2021   grade_12                                                   <10                                             10
1400580 TX TARRANT COUNTY   school 4825260 220907   KELLER ISD 482526007071 220907039 KELLER LEARNING CENTER   Alternative School No High 09 12 2021   grade_12                                                   34                                             34
1400692 TX KAUFMAN COUNTY   school 4825320 129904   KEMP ISD 482532010871 129904003 KEMP ALTERNATIVE   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1400814 TX KERR COUNTY   school 4825590 133903   KERRVILLE ISD 482559004892 133903105 HILL COUNTRY H S   Alternative School No High 09 12 2021   grade_12                                                   24                                             24
1400845 TX HAYS COUNTY   school 4801447 105803   KI CHARTER ACADEMY 480144713122 105803001 KI CHARTER ACADEMY   Alternative School Yes Other 01 12 2021   grade_12                                                   <10                                             10
1400953 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566006281 14906004 GATEWAY H S   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1401076 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566021001 14906006 PATHWAYS ACADEMIC CAMPUS   Alternative School No High 09 12 2021   grade_12                                                   <200                                             200
1401575 TX HARRIS COUNTY   school 4825740 101915   KLEIN ISD 482574007642 101915037 HARRIS CO JJAEP   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1401602 TX HARRIS COUNTY   school 4825740 101915   KLEIN ISD 482574008632 101915038 K E KAUFMAN ALTERNATIVE EDUCATION   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1401917 TX CAMERON COUNTY   school 4826040 31905   LA FERIA ISD 482604006941 31905002 LA FERIA ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   12                                             12
1402065 TX HIDALGO COUNTY   school 4826130 108912   LA JOYA ISD 482613009585 108912005 HOPE ACADEMY   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1402250 TX HARRIS COUNTY   school 4826190 101916   LA PORTE ISD 482619001443 101916002 THE ACADEMY OF VIOLA DEWALT HIGH S   Alternative School No High 09 12 2021   grade_12                                                   54                                             54
1402376 TX HOOD COUNTY   school 4801464 111801   LAKE GRANBURY ACADEMY CHARTER SCHO 480146413723 111801001 LAKE GRANBURY ACADEMY   Alternative School Yes High 07 12 2021   grade_12                                                   <10                                             10
1402473 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658006739 79901004 ALTERNATIVE LEARNING CENTER   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1402621 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658021244 79901133 JUVENILE DETENT CTR   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1402900 TX WEBB COUNTY   school 4826790 240901   LAREDO ISD 482679007475 240901007 F S LARA ACADEMY   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1403032 TX WEBB COUNTY   school 4826790 240901   LAREDO ISD 482679007748 240901010 WEBB COUNTY J J A E P   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1403225 TX WILLIAMSON COUNTY   school 4827030 246913   LEANDER ISD 482703013720 246913014 LEANDER EXTENDED OPPORTUNITY   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1403249 TX WILLIAMSON COUNTY   school 4827030 246913   LEANDER ISD 482703009437 246913011 NEW HOPE H S   Alternative School No High 11 12 2021   grade_12                                                   <70                                             70
1403710 TX DENTON COUNTY   school 4827300 61902   LEWISVILLE ISD 482730006744 61902005 LEARNING CTR   Alternative School No Other 01 12 2021   grade_12                                                   76                                             76
1403917 TX WILLIAMSON COUNTY   school 4827420 246908   LIBERTY HILL ISD 482742009428 246908005 WILLIAMSON JJAEP   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1404199 TX POLK COUNTY   school 4827780 187907   LIVINGSTON ISD 482778013296 187907004 LIVINGSTON H S ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   13                                             13
1404263 TX CALDWELL COUNTY   school 4827870 28902   LOCKHART ISD 482787021148 28902038 LOCKHART PRIDE H S   Alternative School No High 10 12 2021   grade_12                                                   <30                                             30
1404308 TX LAMPASAS COUNTY   school 4827960 141902   LOMETA ISD 482796013689 141902003 LEON VALLEY   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1404404 TX GREGG COUNTY   school 4828110 92903   LONGVIEW ISD 482811012512 92903004 LEAD ACADEMY H S   Alternative School Yes High 09 12 2021   grade_12                                                   31                                             31
1404494 TX CAMERON COUNTY   school 4828290 31906   LOS FRESNOS CISD 482829009454 31906005 CAMERON CO J J A E P   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1404779 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850008328 152901017 LUBBOCK CO JUVENILE JUSTICE CTR   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1404797 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850007030 152901011 MATTHEWS LEARNING CENTER   Alternative School No High 09 12 2021   grade_12                                                   56                                             56

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