Data source: Big Local News · About: Big Local

4,385 rows where grade = "grade_9" and state = "TX" sorted by ccd_school_type

View and edit SQL

year

grade

  • grade_9 · 4,285
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
1387037 TX MEDINA COUNTY   school 4816950 163901   DEVINE ISD 481695012708 163901004 DEVINE DAEP SCHOOL   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1387112 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707012520 84901009 DICKINSON CONTINUATION CENTER   Alternative School No High 08 12 2021   grade_9                                                   <10                                             10
1387128 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707007290 84901012 GALVESTON CO DETENTION CTR   Alternative School No High 07 12 2021   grade_9                                                   <10                                             10
1387171 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707007289 84901011 TRANSFORMING LIVES COOPERATIVE (TL   Alternative School No Secondary 08 11 2021   grade_9                                                   <10                                             10
1387238 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739012205 108902006 3D ACADEMY   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1387303 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739007961 108902003 HIDALGO CO J J A E P   Alternative School No Secondary 08 11 2021   grade_9                                                   <10                                             10
1387606 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770007447 220918003 ALTER DISCIPLINE CAMPUS   Alternative School No High 07 12 2021   grade_9                                                   <10                                             10
1387674 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770005450 220918002 ELMER C WATSON H S   Alternative School No High 09 12 2021   grade_9                                                   <20                                             20
1387953 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785007183 15911004 BEXAR CO J J A E P   Alternative School No Secondary 09 10 2021   grade_9                                                   <10                                             10
1387957 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785007517 15911005 BEXAR COUNTY LRN CTR   Alternative School No Secondary 07 11 2021   grade_9                                                   11                                             11
1387961 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785008449 15911003 EAST CENTRAL CHOICE PROGAM   Alternative School No Secondary 07 11 2021   grade_9                                                   <10                                             10
1388050 TX GREGG COUNTY   school 4800109 92801   EAST TEXAS CHARTER SCHOOLS 480010908220 92801001 DAN CHADWICK CAMPUS   Alternative School Yes High 09 12 2021   grade_9                                                   28                                             28
1388072 TX ECTOR COUNTY   school 4818000 68901   ECTOR COUNTY ISD 481800001596 68901004 ALTER ED CTR   Alternative School No Secondary 06 11 2021   grade_9                                                   <10                                             10
1388135 TX ECTOR COUNTY   school 4818000 68901   ECTOR COUNTY ISD 481800016986 68901005 ECTOR CO YOUTH CTR   Alternative School No Secondary 08 11 2021   grade_9                                                   <10                                             10
1388642 TX HIDALGO COUNTY   school 4818180 108904   EDINBURG CISD 481818006693 108904040 JUVENILE DETENTION CTR   Alternative School No Secondary 07 11 2021   grade_9                                                   <10                                             10
1388812 TX EL PASO COUNTY   school 4800205 71804   EL PASO ACADEMY 480020508773 71804001 EL PASO ACADEMY   Alternative School Yes High 09 12 2021   grade_9                                                   36                                             36
1388816 TX EL PASO COUNTY   school 4800205 71804   EL PASO ACADEMY 480020510632 71804002 EL PASO ACADEMY WEST   Alternative School Yes High 09 12 2021   grade_9                                                   26                                             26
1388924 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830005464 71902020 COLLEGE CAREER TECHNOLOGY ACADEMY   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1388964 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830003812 71902025 DELTA ACADEMY   Alternative School No Middle 05 11 2021   grade_9                                                   28                                             28
1389237 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830006945 71902027 TELLES ACADEMY   Alternative School No High 07 12 2021   grade_9                                                   <10                                             10
1389366 TX BASTROP COUNTY   school 4818360 11902   ELGIN ISD 481836008426 11902004 PHOENIX H S   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1389446 TX ERATH COUNTY   school 4800159 72802   ERATH EXCELS ACADEMY INC 480015912097 72802002 COASTAL HORIZONS ACADEMY   Alternative School Yes High 07 12 2021   grade_9                                                   19                                             19
1389450 TX ERATH COUNTY   school 4800159 72802   ERATH EXCELS ACADEMY INC 480015908364 72802001 HUSTON ACADEMY   Alternative School Yes High 09 12 2021   grade_9                                                   15                                             15
1389540 TX TARRANT COUNTY   school 4818810 220904   EVERMAN ISD 481881012891 220904003 EVERMAN ACADEMY H S   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1389566 TX DALLAS COUNTY   school 4800236 57834   EVOLUTION ACADEMY CHARTER SCHOOL 480023613008 57834003 EVOLUTION ACADEMY BEAUMONT   Alternative School Yes High 09 12 2021   grade_9                                                   22                                             22
1389570 TX DALLAS COUNTY   school 4800236 57834   EVOLUTION ACADEMY CHARTER SCHOOL 480023609188 57834001 EVOLUTION ACADEMY CHARTER SCHOOL   Alternative School Yes High 09 12 2021   grade_9                                                   69                                             69
1389574 TX DALLAS COUNTY   school 4800236 57834   EVOLUTION ACADEMY CHARTER SCHOOL 480023612916 57834004 EVOLUTION ACADEMY HOUSTON   Alternative School Yes High 09 12 2021   grade_9                                                   28                                             28
1389578 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004913289 101811008 EXCEL ACADEMY EDUCATION TRANSITION   Alternative School Yes High 09 12 2021   grade_9                                                   25                                             25
1389583 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004907909 101811001 HARRIS COUNTY JUVENILE DETENTION C   Alternative School Yes High 07 12 2021   grade_9                                                   47                                             47
1389590 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908231 101811004 HARRIS COUNTY YOUTH VILLAGE   Alternative School Yes High 06 12 2021   grade_9                                                   13                                             13
1389596 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908233 101811006 LEADERSHIP ACADEMY   Alternative School Yes High 07 12 2021   grade_9                                                   24                                             24
1389773 TX FAYETTE COUNTY   school 4819280 75901   FLATONIA ISD 481928012888 75901103 WHISPERING HILLS ACHIEVEMENT CENTE   Alternative School No Other 04 12 2021   grade_9                                                   <10                                             10
1389791 TX WILSON COUNTY   school 4819350 247901   FLORESVILLE ISD 481935007499 247901002 FLORESVILLE ALTER CTR   Alternative School No High 06 12 2021   grade_9                                                   <10                                             10
1389837 TX NUECES COUNTY   school 4819380 178914   FLOUR BLUFF ISD 481938008010 178914004 NUECES CO J J A E P   Alternative School No Secondary 08 10 2021   grade_9                                                   <10                                             10
1390103 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_9                                                   <10                                             10
1390112 TX FORT BEND COUNTY   school 4819650 79907   FORT BEND ISD 481965007605 79907010 FORT BEND CO ALTER   Alternative School No High 07 12 2021   grade_9                                                   <10                                             10
1390551 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001832 220905104 BOULEVARD HEIGHTS   Alternative School No Other KG 12 2021   grade_9                                                   <10                                             10
1390557 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021058 220905212 BRIDGE ASSOC   Alternative School No Secondary 07 11 2021   grade_9                                                   <10                                             10
1390619 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021056 220905210 CHILDREN'S MEDICAL CTR   Alternative School No Other KG 12 2021   grade_9                                                   <10                                             10
1390692 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005469 220905024 DETENT CTR   Alternative School No High 06 12 2021   grade_9                                                   33                                             33
1390813 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005395 220905062 INT'L NEWCOMER ACAD   Alternative School No Middle 06 09 2021   grade_9                                                   121                                             121
1390841 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005717 220905026 JO KELLY SP ED   Alternative School No Other PK 12 2021   grade_9                                                   <10                                             10
1390855 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970009035 220905040 JUVENILE JUSTICE ALTERNATIVE ED PR   Alternative School No High 07 12 2021   grade_9                                                   <10                                             10
1391146 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970007112 220905021 SUCCESS H S   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1391178 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970008371 220905242 TARRANT YOUTH RECOVERY   Alternative School No Secondary 07 11 2021   grade_9                                                   <10                                             10
1391282 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970006257 220905066 WILLOUGHBY HOUSE   Alternative School No Secondary 08 11 2021   grade_9                                                   <10                                             10
1391288 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021057 220905211 WOMEN'S HAVEN   Alternative School No Other KG 09 2021   grade_9                                                   <10                                             10
1391891 TX NAVARRO COUNTY   school 4820040 175905   FROST ISD 482004010985 175905002 NAVARRO COUNTY AEP/ABC   Alternative School No Secondary 09 11 2021   grade_9                                                   <10                                             10
1392110 TX GALVESTON COUNTY   school 4820280 84902   GALVESTON ISD 482028012288 84902007 AIM COLLEGE & CAREER PREP   Alternative School No High 06 12 2021   grade_9                                                   18                                             18
1392307 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034000518 57909053 GARLAND AEC   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1392694 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001407174 15802001 GEORGE GERVIN ACADEMY   Alternative School Yes Other PK 12 2021   grade_9                                                   24                                             24
1392708 TX HARRIS COUNTY   school 4800020 101804   GEORGE I SANCHEZ CHARTER 480002007304 101804001 GEORGE I SANCHEZ CHARTER   Alternative School Yes Other PK 12 2021   grade_9                                                   99                                             99
1392715 TX HARRIS COUNTY   school 4800020 101804   GEORGE I SANCHEZ CHARTER 480002013387 101804004 GEORGE I SANCHEZ NORTH   Alternative School Yes Secondary 06 11 2021   grade_9                                                   58                                             58
1392741 TX WILLIAMSON COUNTY   school 4820600 246904   GEORGETOWN ISD 482060014151 246904204 C O R E   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1392777 TX WILLIAMSON COUNTY   school 4820600 246904   GEORGETOWN ISD 482060007097 246904003 GEORGETOWN ALTER PROG   Alternative School No Secondary 08 11 2021   grade_9                                                   <10                                             10
1392833 TX WILLIAMSON COUNTY   school 4820600 246904   GEORGETOWN ISD 482060007491 246904197 WILLIAMSON CO J J A E P   Alternative School No Secondary 09 10 2021   grade_9                                                   <10                                             10
1392836 TX WILLIAMSON COUNTY   school 4820600 246904   GEORGETOWN ISD 482060001018 246904199 WILLIAMSON CO JUVENILE DETENTION C   Alternative School No Secondary 06 11 2021   grade_9                                                   <10                                             10
1393026 TX GOLIAD COUNTY   school 4821030 88902   GOLIAD ISD 482103014103 88902005 GOLIAD DAEP   Alternative School No Secondary 09 11 2021   grade_9                                                   <10                                             10
1393158 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115010738 101911012 HIGH POINT SCHOOL   Alternative School No High 08 12 2021   grade_9                                                   <10                                             10
1393202 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115008605 101911006 POINT ALTERNATIVE CENTER   Alternative School No High 06 12 2021   grade_9                                                   <10                                             10
1393366 TX HOOD COUNTY   school 4821390 111901   GRANBURY ISD 482139007006 111901002 STARS ACCELERATED H S   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1393385 TX DALLAS COUNTY   school 4821420 57910   GRAND PRAIRIE ISD 482142012100 57910009 CROSSWINDS ACCELERATED H S   Alternative School No Other PK 12 2021   grade_9                                                   24                                             24
1393511 TX DALLAS COUNTY   school 4821420 57910   GRAND PRAIRIE ISD 482142006970 57910004 LYNDON B JOHNSON DAEP   Alternative School No High 06 12 2021   grade_9                                                   <10                                             10
1393522 TX DALLAS COUNTY   school 4821420 57910   GRAND PRAIRIE ISD 482142007575 57910007 P A S S LEARNING CTR   Alternative School No Secondary 09 11 2021   grade_9                                                   <10                                             10
1393623 TX VAN ZANDT COUNTY   school 4821450 234904   GRAND SALINE ISD 482145008069 234904002 VAN ZANDT CO YOUTH MULTI-SERVICE C   Alternative School No High 08 12 2021   grade_9                                                   <10                                             10
1393679 TX TOM GREEN COUNTY   school 4821600 226907   GRAPE CREEK ISD 482160008930 226907005 FAIRVIEW DAEP   Alternative School No High 08 12 2021   grade_9                                                   <10                                             10
1393944 TX HUNT COUNTY   school 4821720 116905   GREENVILLE ISD 482172006859 116905001 NEW HORIZONS LEARNING CENTER   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1394174 TX HARRISON COUNTY   school 4822170 102904   HALLSVILLE ISD 482217012918 102904010 TEXAS VIRTUAL ACADEMY AT HALLSVILL   Alternative School No Other 03 12 2021   grade_9                                                   1542                                             1542
1394259 TX HARDIN COUNTY   school 4822410 100905   HARDIN-JEFFERSON ISD 482241008581 100905004 HARDIN CO J J A E P   Alternative School No Secondary 09 09 2021   grade_9                                                   <10                                             10
1394286 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247007175 15904007 BEXAR CO J J A E P   Alternative School No Secondary 08 11 2021   grade_9                                                   <10                                             10
1394318 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247009122 15904010 FENLEY TRANSITIONAL H S   Alternative School No Secondary 09 11 2021   grade_9                                                   <10                                             10
1394323 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247005946 15904004 FRANK M TEJEDA ACADEMY   Alternative School No High 09 12 2021   grade_9                                                   44                                             44
1394341 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247006559 15904003 HAC DAEP H S   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1394463 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_9                                                   <10                                             10
1394498 TX CAMERON COUNTY   school 4822530 31903   HARLINGEN CISD 482253009155 31903204 EDNA TAMAYO HOUSE   Alternative School No Secondary 09 11 2021   grade_9                                                   <10                                             10
1394565 TX CAMERON COUNTY   school 4822530 31903   HARLINGEN CISD 482253006940 31903118 SECONDARY ALTER CTR   Alternative School No High 06 12 2021   grade_9                                                   <10                                             10
1395154 TX HAYS COUNTY   school 4800010 105906   HAYS CISD 480001006990 105906002 ALTER IMPACT CTR   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1395245 TX HAYS COUNTY   school 4800010 105906   HAYS CISD 480001008835 105906004 LIVE OAK ACADEMY   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1395343 TX WALLER COUNTY   school 4822920 237902   HEMPSTEAD ISD 482292013618 237902004 HEMPSTEAD ALTERNATIVE LEARNING CEN   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1395431 TX BEXAR COUNTY   school 4800080 15815   HERITAGE ACADEMY 480008011493 15815041 HERITAGE ACADEMY OF DEL RIO   Alternative School Yes High 09 12 2021   grade_9                                                   44                                             44
1395798 TX HARRIS COUNTY   school 4800115 101821   HOUSTON HEIGHTS HIGH SCHOOL 480011508239 101821001 HOUSTON HEIGHTS CHARTER SCHOOL   Alternative School Yes High 09 12 2021   grade_9                                                   20                                             20
1396072 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364006270 101912013 COMMUNITY SERVICES-SEC   Alternative School No Other 01 12 2021   grade_9                                                   21                                             21
1396401 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364011265 101912351 HARPER DAEP   Alternative School No High 06 12 2021   grade_9                                                   <10                                             10
1396796 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_9                                                   21                                             21
1396800 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_9                                                   23                                             23
1397130 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364012655 101912402 SECONDARY DAEP   Alternative School No Secondary 07 11 2021   grade_9                                                   <10                                             10
1397686 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391013167 101913197 HIGHPOINT EAST   Alternative School No Secondary 09 11 2021   grade_9                                                   <10                                             10
1397691 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391012774 101913015 HUMBLE COMMUNITY LEARNING CENTER   Alternative School No High 06 12 2021   grade_9                                                   <10                                             10
1398020 TX TARRANT COUNTY   school 4824060 220916   HURST-EULESS-BEDFORD ISD 482406006568 220916005 KEYS H S   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1398857 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313600 15808014 JHW INSPIRE ACADEMY - BELL COUNTY   Alternative School Yes High 08 12 2021   grade_9                                                   <10                                             10
1398862 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005309121 15808003 JHW INSPIRE ACADEMY - HAYS COUNTY   Alternative School Yes High 07 12 2021   grade_9                                                   15                                             15
1398875 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313328 15808012 JHW INSPIRE ACADEMY - LEGACY RANCH   Alternative School Yes Other KG 12 2021   grade_9                                                   <10                                             10
1398881 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005312039 15808007 JHW INSPIRE ACADEMY - ROCKDALE   Alternative School Yes High 06 12 2021   grade_9                                                   30                                             30
1399131 TX DALLAS COUNTY   school 4824420 57912   IRVING ISD 482442006275 57912005 BARBARA CARDWELL CAREER PREPARATOR   Alternative School No High 09 12 2021   grade_9                                                   38                                             38
1399365 TX CHEROKEE COUNTY   school 4824590 37904   JACKSONVILLE ISD 482459007213 37904004 COMPASS CENTER   Alternative School No Middle 05 11 2021   grade_9                                                   <10                                             10
1399465 TX DALLAS COUNTY   school 4800098 57819   JEAN MASSIEU ACADEMY 480009808169 57819001 JEAN MASSIEU ACADEMY   Alternative School Yes Other PK 12 2021   grade_9                                                   <10                                             10
1399616 TX ATASCOSA COUNTY   school 4824960 7902   JOURDANTON ISD 482496007778 7902005 ATASCOSA COUNTY JUVENILE JUSTICE C   Alternative School No Secondary 07 11 2021   grade_9                                                   <10                                             10
1399618 TX ATASCOSA COUNTY   school 4824960 7902   JOURDANTON ISD 482496012836 7902006 JOURDANTON DAEP   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1399844 TX BEXAR COUNTY   school 4824990 15916   JUDSON ISD 482499007187 15916005 JUDSON CARE ACADEMY   Alternative School No Secondary 09 10 2021   grade_9                                                   <10                                             10
1399997 TX HAYS COUNTY   school 4800132 105801   KATHERINE ANNE PORTER SCHOOL 480013208279 105801001 KATHERINE ANNE PORTER SCHOOL   Alternative School Yes High 09 12 2021   grade_9                                                   21                                             21

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