enrollments

Data source: Big Local News · About: Big Local

2,632 rows where grade = "grade_6", state = "TX" and year = 2020 sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,632 ✖

grade ✖

  • grade_6 · 2,632 ✖
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 ▼
1613225 1613225 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1613294 1613294 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009062 221901007 TAYLOR COUNTY LEARNING CENTER   Alternative School No Middle 05 11 2020   grade_6                                                   <10                                             10
1613323 1613323 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009308164 57814001 DALLAS COUNTY JUVENILE JUSTICE   Alternative School Yes High 06 12 2020   grade_6                                                   <10                                             10
1613341 1613341 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312112 57814003 MEDLOCK YOUTH VILLAGE   Alternative School Yes High 06 12 2020   grade_6                                                   <10                                             10
1613630 1613630 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771010723 101902098 HIGHPOINT   Alternative School No Middle 06 10 2020   grade_6                                                   <10                                             10
1613674 1613674 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000075 101902108 LANE SCHOOL   Special Education School No Other PK 12 2020   grade_6                                                   <10                                             10
1613906 1613906 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783008805 101903047 ALIEF ISD J J A E P   Alternative School No Secondary 06 11 2020   grade_6                                                   <10                                             10
1613923 1613923 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783011491 101903205 ALIEF LEARNING CTR (K-6)   Alternative School No Elementary 01 06 2020   grade_6                                                   <10                                             10
1614685 1614685 TX POTTER COUNTY   school 4808130 188901   AMARILLO ISD 480813000165 188901046 MANN MIDDLE   Regular School No Middle 06 08 2020   grade_6                                                   <10                                             10
1614818 1614818 TX POTTER COUNTY   school 4808130 188901   AMARILLO ISD 480813000182 188901047 TRAVIS MIDDLE   Regular School No Middle 06 08 2020   grade_6                                                   <10                                             10
1614880 1614880 TX LAMB COUNTY   school 4808160 140901   AMHERST ISD 480816000188 140901001 AMHERST SCHOOL   Regular School No Other PK 12 2020   grade_6                                                   <10                                             10
1614912 1614912 TX CHAMBERS COUNTY   school 4808190 36901   ANAHUAC ISD 480819013185 36901006 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No Secondary 06 11 2020   grade_6                                                   <10                                             10
1614957 1614957 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831016825 20902003 BRAZORIA CO ALTER ED CTR   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1614963 1614963 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831007814 20902004 BRAZORIA CO JUVENILE DETENTION   Alternative School No High 05 12 2020   grade_6                                                   <10                                             10
1615004 1615004 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831006642 20902002 STUDENT ALTERNATIVE CTR   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1615897 1615897 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894009076 227901012 ALTERNATIVE LEARNING CENTER   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1615924 1615924 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005646 227901250 AUSTIN ST HOSPITAL   Alternative School No Other 01 12 2020   grade_6                                                   <10                                             10
1616455 1616455 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894000344 227901128 PEASE EL   Regular School No Elementary KG 06 2020   grade_6                                                   <10                                             10
1616536 1616536 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005396 227901251 ROSEDALE   Alternative School No Other PK 12 2020   grade_6                                                   <10                                             10
1616592 1616592 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894009077 227901030 TRAVIS COUNTY JUVENILE DETENTION C   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1617160 1617160 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967007364 123910011 JEFFERSON CO YOUTH ACAD   Alternative School No Secondary 06 11 2020   grade_6                                                   <10                                             10
1617183 1617183 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967006510 123910006 PATHWAYS LEARNING CTR   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1617268 1617268 TX CLAY COUNTY   school 4809750 39904   BELLEVUE ISD 480975000446 39904001 BELLEVUE SCHOOL   Regular School No Other PK 12 2020   grade_6                                                   10                                             10
1617529 1617529 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022711321 193801101 HILL COUNTRY YOUTH RANCH   Alternative School Yes Other KG 12 2020   grade_6                                                   10                                             10
1617813 1617813 TX BROWN COUNTY   school 4810380 25904   BLANKET ISD 481038005661 25904001 BLANKET SCHOOL   Regular School No Other PK 12 2020   grade_6                                                   10                                             10
1618207 1618207 TX AUSTIN COUNTY   school 4844470 8903   BRAZOS ISD 484447013001 8903103 PRAIRIE HARBOR ALTERNATIVE SCHOOL   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1618305 1618305 TX BRAZORIA COUNTY   school 4811190 20905   BRAZOSPORT ISD 481119007528 20905004 LIGHTHOUSE LEARNING CENTER - DAEP   Alternative School No High 05 12 2020   grade_6                                                   <10                                             10
1618512 1618512 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155013724 25908003 GENESIS CAMPUS   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1618663 1618663 TX CAMERON COUNTY   school 4811680 31901   BROWNSVILLE ISD 481168007541 31901034 CAMERON CO J J A E P   Alternative School No Other 04 12 2020   grade_6                                                   <10                                             10
1619018 1619018 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179008456 21902014 BRAZOS CO JUVENILE DETENTION CENTE   Alternative School No Other 04 12 2020   grade_6                                                   <10                                             10
1619025 1619025 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179009145 21902015 BRAZOS COUNTY JJAEP   Alternative School No Secondary 06 11 2020   grade_6                                                   <10                                             10
1619795 1619795 TX RANDALL COUNTY   school 4812810 191901   CANYON ISD 481281005172 191901003 YOUTH CTR OF HIGH PLAINS   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1619981 1619981 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305005854 57903117 HUIE SPECIAL EDUC CTR   Alternative School No Other PK 12 2020   grade_6                                                   <10                                             10
1620072 1620072 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305007241 57903005 SALAZAR DISTRICT ALTERNATIVE EDUCA   Alternative School No Other 03 12 2020   grade_6                                                   <10                                             10
1620156 1620156 TX TARRANT COUNTY   school 4813170 220917   CASTLEBERRY ISD 481317007446 220917004 T R U C E LEARNING CTR   Alternative School No Secondary 06 11 2020   grade_6                                                   <10                                             10
1620351 1620351 TX TRINITY COUNTY   school 4813380 228904   CENTERVILLE ISD 481338000839 228904001 CENTERVILLE H S   Regular School No Other PK 12 2020   grade_6                                                   10                                             10
1620553 1620553 TX SAN SABA COUNTY   school 4813740 206903   CHEROKEE ISD 481374000866 206903001 CHEROKEE SCHOOL   Regular School No Other PK 12 2020   grade_6                                                   <10                                             10
1620883 1620883 TX GALVESTON COUNTY   school 4814280 84910   CLEAR CREEK ISD 481428009498 84910008 CLEAR PATH ALTERNATIVE SCHOOL   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1620939 1620939 TX GALVESTON COUNTY   school 4814280 84910   CLEAR CREEK ISD 481428008791 84910006 HARRIS CO JJAEP   Alternative School No Secondary 06 11 2020   grade_6                                                   <10                                             10
1621141 1621141 TX LIBERTY COUNTY   school 4814370 146901   CLEVELAND ISD 481437007381 146901003 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1621549 1621549 TX COMAL COUNTY   school 4814730 46902   COMAL ISD 481473012361 46902206 COMAL DISCIPLINE CENTER   Alternative School No High 05 12 2020   grade_6                                                   <10                                             10
1621802 1621802 TX HARRIS COUNTY   school 4800127 101842   COMQUEST ACADEMY 480012708255 101842001 COMQUEST ACADEMY   Alternative School Yes Other 01 12 2020   grade_6                                                   <10                                             10
1621822 1621822 TX MCLENNAN COUNTY   school 4814970 161921   CONNALLY ISD 481497007692 161921004 CHALLENGE ACADEMY   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1621993 1621993 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500017045 170902010 JJAEP   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1622747 1622747 TX HALE COUNTY   school 4815360 95902   COTTON CENTER ISD 481536001112 95902001 COTTON CENTER SCHOOL   Regular School No Other PK 12 2020   grade_6                                                   <10                                             10
1622986 1622986 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 09 2020   grade_6                                                   <10                                             10
1623093 1623093 TX TARRANT COUNTY   school 4815910 220912   CROWLEY ISD 481591006669 220912105 JACKIE CARDEN EL   Regular School No Elementary PK 06 2020   grade_6                                                   <10                                             10
1623102 1623102 TX TARRANT COUNTY   school 4815910 220912   CROWLEY ISD 481591013957 220912115 JUNE W DAVIS EL   Regular School No Elementary PK 06 2020   grade_6                                                   <10                                             10
1623160 1623160 TX TARRANT COUNTY   school 4815910 220912   CROWLEY ISD 481591012022 220912043 SUMMER CREEK MIDDLE   Regular School No Middle 06 09 2020   grade_6                                                   <10                                             10
1623235 1623235 TX SMITH COUNTY   school 4800034 212801   CUMBERLAND ACADEMY 480003413578 212801102 THE LEADERSHIP ACADEMY   Regular School Yes Elementary KG 08 2020   grade_6                                                   <10                                             10
1623949 1623949 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623001310 57905180 B H MACON EL   Regular School No Elementary PK 06 2020   grade_6                                                   <10                                             10
1624397 1624397 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006391 57905099 HOSPITAL/HOMEBOUND   Alternative School No Other PK 12 2020   grade_6                                                   <10                                             10
1624780 1624780 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006965 57905030 MAYA ANGELOU H S   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1625334 1625334 TX DAWSON COUNTY   school 4816350 58902   DAWSON ISD 481635001399 58902001 DAWSON SCHOOL   Regular School No Other KG 12 2020   grade_6                                                   <10                                             10
1625584 1625584 TX HUDSPETH COUNTY   school 4816650 115903   DELL CITY ISD 481665001429 115903001 DELL CITY SCHOOL   Regular School No Other PK 12 2020   grade_6                                                   <10                                             10
1625764 1625764 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674007265 61901005 LESTER DAVIS   Alternative School No Other 03 12 2020   grade_6                                                   <10                                             10
1625909 1625909 TX DALLAS COUNTY   school 4816860 57906   DESOTO ISD 481686013373 57906008 DESOTO ALTERNATIVE EDUCATION CENTE   Alternative School No Other 04 12 2020   grade_6                                                   <10                                             10
1626075 1626075 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707007290 84901012 GALVESTON CO DETENTION CTR   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1627031 1627031 TX ECTOR COUNTY   school 4818000 68901   ECTOR COUNTY ISD 481800001596 68901004 ALTER ED CTR   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1627095 1627095 TX ECTOR COUNTY   school 4818000 68901   ECTOR COUNTY ISD 481800016986 68901005 ECTOR CO YOUTH CTR   Alternative School No Secondary 06 11 2020   grade_6                                                   <10                                             10
1627328 1627328 TX BEXAR COUNTY   school 4818150 15905   EDGEWOOD ISD 481815008442 15905042 ALTERNATIVE CENTER   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1627946 1627946 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830003812 71902025 DELTA ACADEMY   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1628218 1628218 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830006945 71902027 TELLES ACADEMY   Alternative School No Secondary 06 11 2020   grade_6                                                   <10                                             10
1628449 1628449 TX NACOGDOCHES COUNTY   school 4818660 174910   ETOILE ISD 481866001747 174910101 ETOILE EL   Regular School No Elementary PK 08 2020   grade_6                                                   10                                             10
1628584 1628584 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908233 101811006 LEADERSHIP ACADEMY   Alternative School Yes High 06 12 2020   grade_6                                                   <10                                             10
1628608 1628608 TX SHELBY COUNTY   school 4818840 210906   EXCELSIOR ISD 481884001762 210906101 EXCELSIOR EL   Regular School No Elementary PK 08 2020   grade_6                                                   10                                             10
1628618 1628618 TX LAVACA COUNTY   school 4818890 143906   EZZELL ISD 481889001764 143906101 EZZELL EL   Regular School No Elementary PK 08 2020   grade_6                                                   10                                             10
1628874 1628874 TX MONTAGUE COUNTY   school 4819530 169910   FORESTBURG ISD 481953001808 169910001 FORESTBURG SCHOOL   Regular School No Other PK 12 2020   grade_6                                                   <10                                             10
1629094 1629094 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_6                                                   <10                                             10
1629542 1629542 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001832 220905104 BOULEVARD HEIGHTS   Alternative School No Other 01 12 2020   grade_6                                                   <10                                             10
1629684 1629684 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005469 220905024 DETENT CTR   Alternative School No High 05 12 2020   grade_6                                                   <10                                             10
1629840 1629840 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005717 220905026 JO KELLY SP ED   Alternative School No Other KG 12 2020   grade_6                                                   <10                                             10
1629931 1629931 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001879 220905050 MCLEAN MIDDLE   Regular School No Middle 06 08 2020   grade_6                                                   <10                                             10
1630069 1630069 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001904 220905057 ROSEMONT MIDDLE   Regular School No Middle 06 08 2020   grade_6                                                   <10                                             10
1630241 1630241 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001927 220905060 WEDGWOOD MIDDLE   Regular School No Middle 06 08 2020   grade_6                                                   <10                                             10
1631113 1631113 TX GALVESTON COUNTY   school 4820280 84902   GALVESTON ISD 482028012288 84902007 AIM COLLEGE & CAREER PREP   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1631316 1631316 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034000518 57909053 GARLAND AEC   Alternative School No Other 01 12 2020   grade_6                                                   <10                                             10
1631992 1631992 TX DALLAS COUNTY   school 4800237 57835   GOLDEN RULE CHARTER SCHOOL 480023712366 57835102 GOLDEN RULE DESOTO   Regular School Yes Other PK 10 2020   grade_6                                                   <10                                             10
1632198 1632198 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115008605 101911006 POINT ALTERNATIVE CENTER   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1632505 1632505 TX DALLAS COUNTY   school 4821420 57910   GRAND PRAIRIE ISD 482142006970 57910004 LYNDON B JOHNSON DAEP   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1632624 1632624 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_6                                                   <10                                             10
1632665 1632665 TX GRAY COUNTY   school 4821560 90905   GRANDVIEW-HOPKINS ISD 482156002172 90905101 GRANDVIEW-HOPKINS EL   Regular School No Elementary KG 06 2020   grade_6                                                   <10                                             10
1632906 1632906 TX HUNT COUNTY   school 4821720 116905   GREENVILLE ISD 482172007361 116905004 GREENVILLE ALTERNATIVE EDUCATIONAL   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1633019 1633019 TX CARSON COUNTY   school 4821840 33901   GROOM ISD 482184002205 33901001 GROOM SCHOOL   Regular School No Other PK 12 2020   grade_6                                                   10                                             10
1633078 1633078 TX COMANCHE COUNTY   school 4821990 47903   GUSTINE ISD 482199002215 47903001 GUSTINE SCHOOL   Regular School No Other PK 12 2020   grade_6                                                   <10                                             10
1633092 1633092 TX KING COUNTY   school 4822020 135001   GUTHRIE CSD 482202002217 135001001 GUTHRIE SCHOOL   Regular School No Other PK 12 2020   grade_6                                                   10                                             10
1633335 1633335 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247007799 15904045 HAC DAEP MIDDLE   Alternative School No Middle 06 08 2020   grade_6                                                   <10                                             10
1633557 1633557 TX CAMERON COUNTY   school 4822530 31903   HARLINGEN CISD 482253006940 31903118 SECONDARY ALTER CTR   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1634046 1634046 TX WILBARGER COUNTY   school 4822620 244901   HARROLD ISD 482262002298 244901001 HARROLD SCHOOL   Regular School No Other KG 12 2020   grade_6                                                   <10                                             10
1634308 1634308 TX DONLEY COUNTY   school 4822850 65902   HEDLEY ISD 482285002317 65902001 HEDLEY SCHOOL   Regular School No Other PK 12 2020   grade_6                                                   <10                                             10
1634512 1634512 TX LIPSCOMB COUNTY   school 4823140 148903   HIGGINS ISD 482314002349 148903001 HIGGINS SCHOOL   Regular School No Other KG 12 2020   grade_6                                                   <10                                             10
1634526 1634526 TX GALVESTON COUNTY   school 4823160 84903   HIGH ISLAND ISD 482316002351 84903001 HIGH ISLAND SCHOOL   Regular School No Other PK 12 2020   grade_6                                                   10                                             10
1635071 1635071 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364006270 101912013 COMMUNITY SERVICES-SEC   Alternative School No Other PK 12 2020   grade_6                                                   <10                                             10
1636180 1636180 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364012655 101912402 SECONDARY DAEP   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1636260 1636260 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364007018 101912069 SOAR CTR   Special Education School No Other PK 12 2020   grade_6                                                   <10                                             10
1636574 1636574 TX BOWIE COUNTY   school 4823700 19913   HUBBARD ISD 482370002624 19913101 HUBBARD ISD   Regular School No Elementary PK 08 2020   grade_6                                                   <10                                             10
1637006 1637006 TX TARRANT COUNTY   school 4824060 220916   HURST-EULESS-BEDFORD ISD 482406007730 220916004 ALTER ED PROG   Alternative School No High 05 12 2020   grade_6                                                   <10                                             10
1637825 1637825 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005307796 15808001 JHW INSPIRE ACADEMY - AFTON OAKS   Alternative School Yes High 06 12 2020   grade_6                                                   <10                                             10
1637847 1637847 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313328 15808012 JHW INSPIRE ACADEMY - LEGACY RANCH   Alternative School Yes Other KG 12 2020   grade_6                                                   <10                                             10
1637851 1637851 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313204 15808010 JHW INSPIRE ACADEMY - MERIDELL   Alternative School Yes High 06 12 2020   grade_6                                                   <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]);