Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 2,067

grade

  • grade_11 · 2,067
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
1622377 TX NUECES COUNTY   school 4815270 178904   CORPUS CHRISTI ISD 481527011318 178904008 COLLEGIATE H S   Alternative School No High 09 12 2020   grade_11                                                   108                                             108
1622633 TX NUECES COUNTY   school 4815270 178904   CORPUS CHRISTI ISD 481527005681 178904054 STUDENT SUPPORT CENTER   Alternative School No Other 02 12 2020   grade_11                                                   <10                                             10
1622812 TX KAUFMAN COUNTY   school 4815510 129901   CRANDALL ISD 481551007370 129901002 CRANDALL COMPASS ACADEMY   Alternative School No High 09 12 2020   grade_11                                                   15                                             15
1622935 TX HARRIS COUNTY   school 4815750 101906   CROSBY ISD 481575012769 101906004 CROSBY CROSSROADS ACADEMY   Alternative School No High 10 12 2020   grade_11                                                   17                                             17
1622961 TX HARRIS COUNTY   school 4815750 101906   CROSBY ISD 481575010727 101906105 HIGHPOINT SCHOOL EAST (CROSBY)   Alternative School No High 07 12 2020   grade_11                                                   <10                                             10
1623019 TX PARKER COUNTY   school 4800278 184801   CROSSTIMBERS ACADEMY 480027811303 184801001 CROSSTIMBERS ACADEMY   Alternative School Yes High 09 12 2020   grade_11                                                   50                                             50
1623392 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_11                                                   <10                                             10
1623967 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006930 57905029 BARBARA M MANNS H S DAEP   Alternative School No High 08 12 2020   grade_11                                                   16                                             16
1624402 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006391 57905099 HOSPITAL/HOMEBOUND   Alternative School No Other PK 12 2020   grade_11                                                   17                                             17
1624596 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623010565 57905096 JUVENILE JUSTICE AEP   Alternative School No High 07 12 2020   grade_11                                                   <10                                             10
1625453 TX HARRIS COUNTY   school 4816530 101908   DEER PARK ISD 481653011769 101908007 H S POINT   Alternative School No High 07 12 2020   grade_11                                                   <10                                             10
1625521 TX TRAVIS COUNTY   school 4816620 227910   DEL VALLE ISD 481662021529 227910002 DEL VALLE OPPORTUNITY CTR   Alternative School No High 09 12 2020   grade_11                                                   40                                             40
1625576 TX TRAVIS COUNTY   school 4816620 227910   DEL VALLE ISD 481662007743 227910005 TRAVIS CO J J A E P   Alternative School No Secondary 09 11 2020   grade_11                                                   <10                                             10
1625627 TX GRAYSON COUNTY   school 4816710 91903   DENISON ISD 481671007294 91903002 PATHWAYS H S   Alternative School No High 09 12 2020   grade_11                                                   <10                                             10
1625716 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674021219 61901039 FRED MOORE H S   Alternative School No High 09 12 2020   grade_11                                                   21                                             21
1625759 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674003735 61901040 JOE DALE SPARKS CAMPUS   Alternative School No High 07 12 2020   grade_11                                                   <10                                             10
1625769 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674007265 61901005 LESTER DAVIS   Alternative School No Other 03 12 2020   grade_11                                                   10                                             10
1625913 TX DALLAS COUNTY   school 4816860 57906   DESOTO ISD 481686013373 57906008 DESOTO ALTERNATIVE EDUCATION CENTE   Alternative School No Other 04 12 2020   grade_11                                                   10                                             10
1625986 TX MEDINA COUNTY   school 4816950 163901   DEVINE ISD 481695012708 163901004 DEVINE DAEP SCHOOL   Alternative School No High 07 12 2020   grade_11                                                   <10                                             10
1626043 TX ANGELINA COUNTY   school 4817040 3905   DIBOLL ISD 481704007503 3905004 STUBBLEFIELD LRN CTR   Alternative School No High 10 12 2020   grade_11                                                   <10                                             10
1626063 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707012520 84901009 DICKINSON CONTINUATION CENTER   Alternative School No High 08 12 2020   grade_11                                                   13                                             13
1626080 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707007290 84901012 GALVESTON CO DETENTION CTR   Alternative School No High 06 12 2020   grade_11                                                   <10                                             10
1626083 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707007889 84901010 GALVESTON CO J J A E P   Alternative School No Secondary 09 11 2020   grade_11                                                   <10                                             10
1626127 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707007289 84901011 TRANSFORMING LIVES COOPERATIVE (TL   Alternative School No Secondary 07 11 2020   grade_11                                                   <10                                             10
1626194 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739012205 108902006 3D ACADEMY   Alternative School No High 09 12 2020   grade_11                                                   45                                             45
1626470 TX MOORE COUNTY   school 4817610 171901   DUMAS ISD 481761017047 171901002 NORTH PLAINS OPPORTUNITY CENTER   Alternative School No High 09 12 2020   grade_11                                                   <10                                             10
1626532 TX DALLAS COUNTY   school 4817640 57907   DUNCANVILLE ISD 481764003679 57907004 MARY E SMITHEY PACE H S   Alternative School No High 10 12 2020   grade_11                                                   <30                                             30
1626550 TX DALLAS COUNTY   school 4817640 57907   DUNCANVILLE ISD 481764008519 57907005 SUMMIT LEARNING CENTER   Alternative School No High 07 12 2020   grade_11                                                   11                                             11
1626563 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770007447 220918003 ALTER DISCIPLINE CAMPUS   Alternative School No High 07 12 2020   grade_11                                                   <10                                             10
1626622 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770005450 220918002 ELMER C WATSON H S   Alternative School No High 09 12 2020   grade_11                                                   34                                             34
1626695 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_11                                                   <10                                             10
1626729 TX MAVERICK COUNTY   school 4817730 159901   EAGLE PASS ISD 481773007032 159901003 DAEP   Alternative School No High 07 12 2020   grade_11                                                   <10                                             10
1626915 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785007517 15911005 BEXAR COUNTY LRN CTR   Alternative School No Secondary 08 11 2020   grade_11                                                   <10                                             10
1626921 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785008449 15911003 EAST CENTRAL CHOICE PROGAM   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1627014 TX GREGG COUNTY   school 4800109 92801   EAST TEXAS CHARTER SCHOOLS 480010908220 92801001 DAN CHADWICK CAMPUS   Alternative School Yes High 09 12 2020   grade_11                                                   40                                             40
1627036 TX ECTOR COUNTY   school 4818000 68901   ECTOR COUNTY ISD 481800001596 68901004 ALTER ED CTR   Alternative School No High 06 12 2020   grade_11                                                   <10                                             10
1627100 TX ECTOR COUNTY   school 4818000 68901   ECTOR COUNTY ISD 481800016986 68901005 ECTOR CO YOUTH CTR   Alternative School No Secondary 06 11 2020   grade_11                                                   <10                                             10
1627279 TX HIDALGO COUNTY   school 4818060 108903   EDCOUCH-ELSA ISD 481806013006 108903004 EDCOUCH-ELSA H S ACADEMY   Alternative School No High 09 12 2020   grade_11                                                   <10                                             10
1627610 TX HIDALGO COUNTY   school 4818180 108904   EDINBURG CISD 481818006693 108904040 JUVENILE DETENTION CTR   Alternative School No High 07 12 2020   grade_11                                                   <10                                             10
1627716 TX JACKSON COUNTY   school 4818210 120901   EDNA ISD 481821013097 120901004 EDNA ALTERNATIVE   Alternative School No High 08 12 2020   grade_11                                                   11                                             11
1627789 TX EL PASO COUNTY   school 4800205 71804   EL PASO ACADEMY 480020508773 71804001 EL PASO ACADEMY   Alternative School Yes High 09 12 2020   grade_11                                                   70                                             70
1627793 TX EL PASO COUNTY   school 4800205 71804   EL PASO ACADEMY 480020510632 71804002 EL PASO ACADEMY WEST   Alternative School Yes High 09 12 2020   grade_11                                                   48                                             48
1627911 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830005464 71902020 COLLEGE CAREER TECHNOLOGY ACADEMY   Alternative School No High 09 12 2020   grade_11                                                   49                                             49
1627951 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830003812 71902025 DELTA ACADEMY   Alternative School No High 06 12 2020   grade_11                                                   <10                                             10
1628223 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830006945 71902027 TELLES ACADEMY   Alternative School No Secondary 06 11 2020   grade_11                                                   <10                                             10
1628354 TX BASTROP COUNTY   school 4818360 11902   ELGIN ISD 481836008426 11902004 PHOENIX H S   Alternative School No High 09 12 2020   grade_11                                                   16                                             16
1628433 TX ERATH COUNTY   school 4800159 72802   ERATH EXCELS ACADEMY INC 480015912097 72802002 COASTAL HORIZONS ACADEMY   Alternative School Yes High 07 12 2020   grade_11                                                   14                                             14
1628437 TX ERATH COUNTY   school 4800159 72802   ERATH EXCELS ACADEMY INC 480015908364 72802001 HUSTON ACADEMY   Alternative School Yes High 09 12 2020   grade_11                                                   24                                             24
1628529 TX TARRANT COUNTY   school 4818810 220904   EVERMAN ISD 481881012891 220904003 EVERMAN ACADEMY H S   Alternative School No High 10 12 2020   grade_11                                                   16                                             16
1628557 TX DALLAS COUNTY   school 4800236 57834   EVOLUTION ACADEMY CHARTER SCHOOL 480023613008 57834003 EVOLUTION ACADEMY BEAUMONT   Alternative School Yes High 09 12 2020   grade_11                                                   30                                             30
1628561 TX DALLAS COUNTY   school 4800236 57834   EVOLUTION ACADEMY CHARTER SCHOOL 480023609188 57834001 EVOLUTION ACADEMY CHARTER SCHOOL   Alternative School Yes High 09 12 2020   grade_11                                                   80                                             80
1628565 TX DALLAS COUNTY   school 4800236 57834   EVOLUTION ACADEMY CHARTER SCHOOL 480023612916 57834004 EVOLUTION ACADEMY HOUSTON   Alternative School Yes High 09 12 2020   grade_11                                                   81                                             81
1628571 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004913289 101811008 EXCEL ACADEMY EDUCATION TRANSITION   Alternative School Yes High 07 12 2020   grade_11                                                   <10                                             10
1628577 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004907909 101811001 HARRIS COUNTY JUVENILE DETENTION C   Alternative School Yes High 07 12 2020   grade_11                                                   <10                                             10
1628582 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908231 101811004 HARRIS COUNTY YOUTH VILLAGE   Alternative School Yes High 07 12 2020   grade_11                                                   <10                                             10
1628589 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908233 101811006 LEADERSHIP ACADEMY   Alternative School Yes High 06 12 2020   grade_11                                                   <10                                             10
1628776 TX WILLIAMSON COUNTY   school 4819320 246902   FLORENCE ISD 481932009566 246902004 WILLIAMSON CO JUVENILE DETENTION C   Alternative School No Secondary 10 11 2020   grade_11                                                   <10                                             10
1628782 TX WILSON COUNTY   school 4819350 247901   FLORESVILLE ISD 481935007499 247901002 FLORESVILLE ALTER CTR   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1628810 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_11                                                   <10                                             10
1628852 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944009238 77901003 P A C   Alternative School No Other 04 11 2020   grade_11                                                   <10                                             10
1629099 TX FORT BEND COUNTY   school 4819650 79907   FORT BEND ISD 481965012235 79907038 FERNDELL HENRY CENTER FOR LEARNING   Alternative School No High 06 12 2020   grade_11                                                   16                                             16
1629107 TX FORT BEND COUNTY   school 4819650 79907   FORT BEND ISD 481965007605 79907010 FORT BEND CO ALTER   Alternative School No High 08 12 2020   grade_11                                                   <10                                             10
1629497 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970007724 220905251 ASSESSMENT CTR   Alternative School No Other KG 11 2020   grade_11                                                   <10                                             10
1629547 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001832 220905104 BOULEVARD HEIGHTS   Alternative School No Other 01 12 2020   grade_11                                                   <10                                             10
1629552 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021058 220905212 BRIDGE ASSOC   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1629614 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021056 220905210 CHILDREN'S MEDICAL CTR   Alternative School No Other KG 12 2020   grade_11                                                   <10                                             10
1629689 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005469 220905024 DETENT CTR   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1629845 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005717 220905026 JO KELLY SP ED   Alternative School No Other KG 12 2020   grade_11                                                   <10                                             10
1629859 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970009035 220905040 JUVENILE JUSTICE ALTERNATIVE ED PR   Alternative School No High 07 12 2020   grade_11                                                   <10                                             10
1629957 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005472 220905019 METRO OPPORTUNITY   Alternative School No High 09 12 2020   grade_11                                                   <10                                             10
1630152 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970007112 220905021 SUCCESS H S   Alternative School No High 09 12 2020   grade_11                                                   37                                             37
1630363 TX GILLESPIE COUNTY   school 4819840 86901   FREDERICKSBURG ISD 481984021258 86901002 ALTER SCH   Alternative School No High 09 12 2020   grade_11                                                   <10                                             10
1630436 TX LUBBOCK COUNTY   school 4819830 152907   FRENSHIP ISD 481983009331 152907003 LUBBOCK CO J J A E P   Alternative School No Secondary 08 11 2020   grade_11                                                   <10                                             10
1630588 TX COLLIN COUNTY   school 4820010 43905   FRISCO ISD 482001010493 43905003 COLLIN CO J J A E P   Alternative School No High 09 12 2020   grade_11                                                   <10                                             10
1631021 TX HARRIS COUNTY   school 4820250 101910   GALENA PARK ISD 482025006973 101910006 HIGHPOINT SCHOOL EAST (DAEP)   Alternative School No High 07 12 2020   grade_11                                                   <10                                             10
1631040 TX HARRIS COUNTY   school 4820250 101910   GALENA PARK ISD 482025008813 101910008 JUVENILE JUSTICE AEP   Alternative School No Secondary 09 11 2020   grade_11                                                   <10                                             10
1631118 TX GALVESTON COUNTY   school 4820280 84902   GALVESTON ISD 482028012288 84902007 AIM COLLEGE & CAREER PREP   Alternative School No High 06 12 2020   grade_11                                                   19                                             19
1631154 TX GALVESTON COUNTY   school 4820280 84902   GALVESTON ISD 482028007890 84902003 GALVESTON CO J J A E P   Alternative School No Secondary 08 11 2020   grade_11                                                   <10                                             10
1631321 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034000518 57909053 GARLAND AEC   Alternative School No Other 01 12 2020   grade_11                                                   14                                             14
1631704 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001407174 15802001 GEORGE GERVIN ACADEMY   Alternative School Yes Other PK 12 2020   grade_11                                                   11                                             11
1631711 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001410415 15802004 RUTH JONES MCCLENDON MIDDLE   Alternative School Yes High 06 12 2020   grade_11                                                   <10                                             10
1631719 TX HARRIS COUNTY   school 4800020 101804   GEORGE I SANCHEZ CHARTER 480002007304 101804001 GEORGE I SANCHEZ CHARTER   Alternative School Yes Other PK 12 2020   grade_11                                                   101                                             101
1631762 TX WILLIAMSON COUNTY   school 4820600 246904   GEORGETOWN ISD 482060021554 246904002 CHIP RICHARTE H S   Alternative School No High 09 12 2020   grade_11                                                   38                                             38
1631794 TX WILLIAMSON COUNTY   school 4820600 246904   GEORGETOWN ISD 482060007097 246904003 GEORGETOWN ALTER PROG   Alternative School No High 07 12 2020   grade_11                                                   <10                                             10
1631844 TX WILLIAMSON COUNTY   school 4820600 246904   GEORGETOWN ISD 482060007491 246904197 WILLIAMSON CO J J A E P   Alternative School No High 07 12 2020   grade_11                                                   <10                                             10
1631951 TX JOHNSON COUNTY   school 4820960 126911   GODLEY ISD 482096013734 126911004 GODLEY LINKS ACADEMY   Alternative School No High 07 12 2020   grade_11                                                   <10                                             10
1632155 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115010738 101911012 HIGH POINT SCHOOL   Alternative School No High 08 12 2020   grade_11                                                   <10                                             10
1632196 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115006974 101911005 PETER E HYLAND CENTER   Alternative School No High 10 12 2020   grade_11                                                   <40                                             40
1632203 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115008605 101911006 POINT ALTERNATIVE CENTER   Alternative School No High 06 12 2020   grade_11                                                   18                                             18
1632316 TX YOUNG COUNTY   school 4821360 252901   GRAHAM ISD 482136021562 252901002 GRAHAM LEARNING CTR   Alternative School No High 11 12 2020   grade_11                                                   <10                                             10
1632370 TX HOOD COUNTY   school 4821390 111901   GRANBURY ISD 482139007006 111901002 STARS ACCELERATED H S   Alternative School No High 09 12 2020   grade_11                                                   <20                                             20
1632389 TX DALLAS COUNTY   school 4821420 57910   GRAND PRAIRIE ISD 482142012100 57910009 CROSSWINDS ACCELERATED H S   Alternative School No Other PK 12 2020   grade_11                                                   170                                             170
1632510 TX DALLAS COUNTY   school 4821420 57910   GRAND PRAIRIE ISD 482142006970 57910004 LYNDON B JOHNSON DAEP   Alternative School No High 06 12 2020   grade_11                                                   <10                                             10
1632628 TX VAN ZANDT COUNTY   school 4821450 234904   GRAND SALINE ISD 482145008069 234904002 VAN ZANDT CO YOUTH MULTI-SERVICE C   Alternative School No Secondary 06 11 2020   grade_11                                                   <10                                             10
1632683 TX TOM GREEN COUNTY   school 4821600 226907   GRAPE CREEK ISD 482160008930 226907005 FAIRVIEW DAEP   Alternative School No High 07 12 2020   grade_11                                                   <10                                             10
1632816 TX TARRANT COUNTY   school 4821660 220906   GRAPEVINE-COLLEYVILLE ISD 482166008034 220906038 TARRANT CO J J A E P   Alternative School No High 10 12 2020   grade_11                                                   <10                                             10
1632827 TX TARRANT COUNTY   school 4821660 220906   GRAPEVINE-COLLEYVILLE ISD 482166007116 220906006 THE BRIDGES ACAD ALTER   Alternative School No High 10 12 2020   grade_11                                                   <20                                             20
1632911 TX HUNT COUNTY   school 4821720 116905   GREENVILLE ISD 482172007361 116905004 GREENVILLE ALTERNATIVE EDUCATIONAL   Alternative School No High 06 12 2020   grade_11                                                   <10                                             10
1632935 TX HUNT COUNTY   school 4821720 116905   GREENVILLE ISD 482172006859 116905001 NEW HORIZONS LEARNING CENTER   Alternative School No High 09 12 2020   grade_11                                                   37                                             37
1633164 TX HARRISON COUNTY   school 4822170 102904   HALLSVILLE ISD 482217012918 102904010 TEXAS VIRTUAL ACADEMY AT HALLSVILL   Alternative School No Other 03 12 2020   grade_11                                                   956                                             956

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