enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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 ▼
1389237 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 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
1389540 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
1389685 1389685 TX DELTA COUNTY   school 4819050 60914   FANNINDEL ISD 481905001776 60914001 FANNINDEL H S   Regular School No High 06 12 2021   grade_9                                                   <10                                             10
1389773 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 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 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 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 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
1390438 1390438 TX WHEELER COUNTY   school 4811400 242906   FORT ELLIOTT CISD 481140000616 242906001 FORT ELLIOTT SCHOOL   Regular School No Other PK 12 2021   grade_9                                                   <10                                             10
1390551 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 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 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
1390841 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 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 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 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 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 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
1391564 1391564 TX COLLIN COUNTY   school 4820010 43905   FRISCO ISD 482001011403 43905127 CARROLL EL   Regular School No Other PK 12 2021   grade_9                                                   <10                                             10
1391891 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
1392307 1392307 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034000518 57909053 GARLAND AEC   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1392741 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 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 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 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 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 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 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 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
1393511 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 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 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
1393636 1393636 TX WARD COUNTY   school 4821480 238904   GRANDFALLS-ROYALTY ISD 482148002168 238904001 GRANDFALLS-ROYALTY SCHOOL   Regular School No Other PK 12 2021   grade_9                                                   <10                                             10
1393679 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 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
1394092 1394092 TX COMANCHE COUNTY   school 4821990 47903   GUSTINE ISD 482199002215 47903001 GUSTINE SCHOOL   Regular School No Other PK 12 2021   grade_9                                                   <10                                             10
1394106 1394106 TX KING COUNTY   school 4822020 135001   GUTHRIE CSD 482202002217 135001001 GUTHRIE SCHOOL   Regular School No Other PK 12 2021   grade_9                                                   <10                                             10
1394259 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 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 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
1394341 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 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 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 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
1395068 1395068 TX WILBARGER COUNTY   school 4822620 244901   HARROLD ISD 482262002298 244901001 HARROLD SCHOOL   Regular School No Other KG 12 2021   grade_9                                                   10                                             10
1395154 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 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 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
1396401 1396401 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364011265 101912351 HARPER DAEP   Alternative School No High 06 12 2021   grade_9                                                   <10                                             10
1397130 1397130 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364012655 101912402 SECONDARY DAEP   Alternative School No Secondary 07 11 2021   grade_9                                                   <10                                             10
1397205 1397205 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364007018 101912069 SOAR CTR   Special Education School No Other PK 12 2021   grade_9                                                   10                                             10
1397255 1397255 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364006272 101912039 T H ROGERS SCHOOL   Regular School No Other PK 12 2021   grade_9                                                   <10                                             10
1397686 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 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 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 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
1398875 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
1399365 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 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
1399586 1399586 TX JOHNSON COUNTY   school 4824930 126905   JOSHUA ISD 482493002781 126905001 JOSHUA H S   Regular School No High 09 12 2021   grade_9                                                   <10                                             10
1399616 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 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 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
1400081 1400081 TX HARRIS COUNTY   school 4825170 101914   KATY ISD 482517010762 101914034 FORT BEND CO ALTER   Alternative School No Secondary 09 09 2021   grade_9                                                   <10                                             10
1400434 1400434 TX KAUFMAN COUNTY   school 4825200 129903   KAUFMAN ISD 482520009321 129903003 GARY W CAMPBELL H S   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1400577 1400577 TX TARRANT COUNTY   school 4825260 220907   KELLER ISD 482526007071 220907039 KELLER LEARNING CENTER   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1400686 1400686 TX WHEELER COUNTY   school 4825290 242905   KELTON ISD 482529005755 242905001 KELTON SCHOOL   Regular School No Other PK 12 2021   grade_9                                                   <10                                             10
1400716 1400716 TX KARNES COUNTY   school 4825440 128902   KENEDY ISD 482544012592 128902004 FISD DAEP   Alternative School No Secondary 09 09 2021   grade_9                                                   <10                                             10
1400811 1400811 TX KERR COUNTY   school 4825590 133903   KERRVILLE ISD 482559004892 133903105 HILL COUNTRY H S   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1400873 1400873 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002861 14906022 ADVENTHEALTH SCHOOL   Alternative School No Other 02 12 2021   grade_9                                                   <10                                             10
1401572 1401572 TX HARRIS COUNTY   school 4825740 101915   KLEIN ISD 482574007642 101915037 HARRIS CO JJAEP   Alternative School No High 07 12 2021   grade_9                                                   <10                                             10
1401599 1401599 TX HARRIS COUNTY   school 4825740 101915   KLEIN ISD 482574008632 101915038 K E KAUFMAN ALTERNATIVE EDUCATION   Alternative School No High 06 12 2021   grade_9                                                   <10                                             10
1401832 1401832 TX HARDIN COUNTY   school 4825920 100903   KOUNTZE ISD 482592008226 100903003 HARDIN CO ALTER ED   Alternative School No Secondary 09 10 2021   grade_9                                                   <10                                             10
1401867 1401867 TX DENTON COUNTY   school 4825980 61905   KRUM ISD 482598009212 61905002 DENTON CO J J A E P   Alternative School No Secondary 09 10 2021   grade_9                                                   <10                                             10
1401914 1401914 TX CAMERON COUNTY   school 4826040 31905   LA FERIA ISD 482604006941 31905002 LA FERIA ACADEMY   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1402062 1402062 TX HIDALGO COUNTY   school 4826130 108912   LA JOYA ISD 482613009585 108912005 HOPE ACADEMY   Alternative School No High 07 12 2021   grade_9                                                   <10                                             10
1402207 1402207 TX HARRIS COUNTY   school 4826190 101916   LA PORTE ISD 482619017032 101916009 HIGHPOINT - DAEP   Alternative School No Secondary 09 10 2021   grade_9                                                   <10                                             10
1402281 1402281 TX WILSON COUNTY   school 4826310 247903   LA VERNIA ISD 482631007500 247903002 FLORESVILLE ALTERNATIVE EDUCATION   Alternative School No Secondary 07 11 2021   grade_9                                                   <10                                             10
1402470 1402470 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658006739 79901004 ALTERNATIVE LEARNING CENTER   Alternative School No High 06 12 2021   grade_9                                                   <10                                             10
1402529 1402529 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658006999 79901008 FORT BEND CO ALTER   Alternative School No Secondary 09 11 2021   grade_9                                                   <10                                             10
1402618 1402618 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658021244 79901133 JUVENILE DETENT CTR   Alternative School No High 08 12 2021   grade_9                                                   <10                                             10
1402897 1402897 TX WEBB COUNTY   school 4826790 240901   LAREDO ISD 482679007475 240901007 F S LARA ACADEMY   Alternative School No High 06 12 2021   grade_9                                                   <10                                             10
1403030 1403030 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_9                                                   <10                                             10
1403222 1403222 TX WILLIAMSON COUNTY   school 4827030 246913   LEANDER ISD 482703013720 246913014 LEANDER EXTENDED OPPORTUNITY   Alternative School No High 06 12 2021   grade_9                                                   <10                                             10
1403363 1403363 TX WILLIAMSON COUNTY   school 4827030 246913   LEANDER ISD 482703009438 246913012 WILLIAMSON COUNTY DETENTION CENTER   Alternative School No Secondary 09 11 2021   grade_9                                                   <10                                             10
1403433 1403433 TX POLK COUNTY   school 4827120 187906   LEGGETT ISD 482712003049 187906001 LEGGETT H S   Regular School No High 07 12 2021   grade_9                                                   <10                                             10
1403583 1403583 TX DENTON COUNTY   school 4827300 61902   LEWISVILLE ISD 482730007865 61902007 DENTON CO J J A E P   Alternative School No Secondary 09 11 2021   grade_9                                                   <10                                             10
1403916 1403916 TX WILLIAMSON COUNTY   school 4827420 246908   LIBERTY HILL ISD 482742009428 246908005 WILLIAMSON JJAEP   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1404196 1404196 TX POLK COUNTY   school 4827780 187907   LIVINGSTON ISD 482778013296 187907004 LIVINGSTON H S ACADEMY   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1404301 1404301 TX MCCULLOCH COUNTY   school 4827930 160905   LOHN ISD 482793003132 160905001 LOHN SCHOOL   Regular School No Other PK 12 2021   grade_9                                                   <10                                             10
1404305 1404305 TX LAMPASAS COUNTY   school 4827960 141902   LOMETA ISD 482796013689 141902003 LEON VALLEY   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1404398 1404398 TX GREGG COUNTY   school 4828110 92903   LONGVIEW ISD 482811001116 92903200 JUVENILE DETENT CTR   Alternative School No Secondary 08 11 2021   grade_9                                                   <10                                             10
1404401 1404401 TX GREGG COUNTY   school 4828110 92903   LONGVIEW ISD 482811012512 92903004 LEAD ACADEMY H S   Alternative School Yes High 09 12 2021   grade_9                                                   <10                                             10
1404439 1404439 TX GAINES COUNTY   school 4828140 83902   LOOP ISD 482814003154 83902001 LOOP SCHOOL   Regular School No Other PK 12 2021   grade_9                                                   <10                                             10
1404453 1404453 TX MITCHELL COUNTY   school 4828170 168902   LORAINE ISD 482817003156 168902001 LORAINE SCHOOL   Regular School No Other PK 12 2021   grade_9                                                   10                                             10
1404487 1404487 TX CAMERON COUNTY   school 4828290 31906   LOS FRESNOS CISD 482829011868 31906003 AMI KIDS RIO GRANDE VALLEY (FKA RG   Alternative School No Secondary 09 11 2021   grade_9                                                   <10                                             10
1404491 1404491 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_9                                                   <10                                             10
1404771 1404771 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850007677 152901015 LUBBOCK CO J J A E P   Alternative School No Secondary 08 11 2021   grade_9                                                   <10                                             10
1404794 1404794 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850007030 152901011 MATTHEWS LEARNING CENTER   Alternative School No High 09 12 2021   grade_9                                                   <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]);