enrollments

Data source: Big Local News · About: Big Local

4,612 rows where grade = "grade_4", state = "TX" and year = 2020 sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 4,612 ✖

grade ✖

  • grade_4 · 4,612 ✖
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 ▼
1613395 1613395 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1613673 1613673 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000075 101902108 LANE SCHOOL   Special Education School No Other PK 12 2020   grade_4                                                   <10                                             10
1613921 1613921 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783011491 101903205 ALIEF LEARNING CTR (K-6)   Alternative School No Elementary 01 06 2020   grade_4                                                   <10                                             10
1614878 1614878 TX LAMB COUNTY   school 4808160 140901   AMHERST ISD 480816000188 140901001 AMHERST SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1616534 1616534 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005396 227901251 ROSEDALE   Alternative School No Other PK 12 2020   grade_4                                                   <10                                             10
1616692 1616692 TX REFUGIO COUNTY   school 4809000 196901   AUSTWELL-TIVOLI ISD 480900000372 196901102 AUSTWELL-TIVOLI EL   Regular School No Elementary PK 06 2020   grade_4                                                   10                                             10
1616735 1616735 TX CASS COUNTY   school 4809090 34902   AVINGER ISD 480909000378 34902001 AVINGER SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1616854 1616854 TX REEVES COUNTY   school 4809330 195902   BALMORHEA ISD 480933000392 195902001 BALMORHEA SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1617080 1617080 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967013717 123910134 BEAUMONT NEW EL DAEP   Alternative School No Elementary 02 05 2020   grade_4                                                   <10                                             10
1617426 1617426 TX KNOX COUNTY   school 4809980 138904   BENJAMIN ISD 480998000468 138904001 BENJAMIN SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1617514 1617514 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022709011 193801001 BIG SPRINGS CHARTER SCHOOL   Alternative School Yes Other KG 12 2020   grade_4                                                   <10                                             10
1617811 1617811 TX BROWN COUNTY   school 4810380 25904   BLANKET ISD 481038005661 25904001 BLANKET SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   10                                             10
1618436 1618436 TX DALLAS COUNTY   school 4801462 57851   BRIDGEWAY PREPARATORY ACADEMY 480146213560 57851101 BRIDGEWAY PREPARATORY ACADEMY   Regular School Yes Elementary PK 05 2020   grade_4                                                   <10                                             10
1618503 1618503 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155000627 25908001 BROOKESMITH SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   10                                             10
1618522 1618522 TX BEXAR COUNTY   school 4800268 15830   BROOKS ACADEMIES OF TEXAS 480026813121 15830102 BROOKS ACADEMY LONESTAR   Regular School Yes Elementary KG 05 2020   grade_4                                                   <10                                             10
1618662 1618662 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_4                                                   <10                                             10
1619016 1619016 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179008456 21902014 BRAZOS CO JUVENILE DETENTION CENTE   Alternative School No Other 04 12 2020   grade_4                                                   <10                                             10
1619587 1619587 TX ROBERTSON COUNTY   school 4812540 198902   CALVERT ISD 481254000756 198902101 CALVERT SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1619979 1619979 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305005854 57903117 HUIE SPECIAL EDUC CTR   Alternative School No Other PK 12 2020   grade_4                                                   <10                                             10
1620551 1620551 TX SAN SABA COUNTY   school 4813740 206903   CHEROKEE ISD 481374000866 206903001 CHEROKEE SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1622626 1622626 TX NUECES COUNTY   school 4815270 178904   CORPUS CHRISTI ISD 481527005681 178904054 STUDENT SUPPORT CENTER   Alternative School No Other 02 12 2020   grade_4                                                   <10                                             10
1622876 1622876 TX BOSQUE COUNTY   school 4815570 18908   CRANFILLS GAP ISD 481557001129 18908001 CRANFILLS GAP SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   10                                             10
1624193 1624193 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623009196 57905241 ELEMENTARY' DISCIPLINARY ALTERNATI   Alternative School No Elementary 04 05 2020   grade_4                                                   <10                                             10
1624396 1624396 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006391 57905099 HOSPITAL/HOMEBOUND   Alternative School No Other PK 12 2020   grade_4                                                   <10                                             10
1625582 1625582 TX HUDSPETH COUNTY   school 4816650 115903   DELL CITY ISD 481665001429 115903001 DELL CITY SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1625762 1625762 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674007265 61901005 LESTER DAVIS   Alternative School No Other 03 12 2020   grade_4                                                   <10                                             10
1625908 1625908 TX DALLAS COUNTY   school 4816860 57906   DESOTO ISD 481686013373 57906008 DESOTO ALTERNATIVE EDUCATION CENTE   Alternative School No Other 04 12 2020   grade_4                                                   <10                                             10
1626175 1626175 TX KERR COUNTY   school 4817190 133905   DIVIDE ISD 481719001490 133905101 DIVIDE EL   Regular School No Elementary PK 05 2020   grade_4                                                   <10                                             10
1626330 1626330 TX GILLESPIE COUNTY   school 4817400 86024   DOSS CONSOLIDATED CSD 481740001503 86024101 DOSS EL   Regular School No Elementary PK 07 2020   grade_4                                                   <10                                             10
1627359 1627359 TX BEXAR COUNTY   school 4818150 15905   EDGEWOOD ISD 481815013488 15905126 EL DAEP   Alternative School No Elementary 02 04 2020   grade_4                                                   <10                                             10
1627797 1627797 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830010643 71902171 ABOUT FACE PROGRAM EL   Alternative School No Elementary 01 05 2020   grade_4                                                   <10                                             10
1628606 1628606 TX SHELBY COUNTY   school 4818840 210906   EXCELSIOR ISD 481884001762 210906101 EXCELSIOR EL   Regular School No Elementary PK 08 2020   grade_4                                                   <10                                             10
1628671 1628671 TX DELTA COUNTY   school 4819050 60914   FANNINDEL ISD 481905001775 60914102 FANNINDEL EL   Regular School No Elementary PK 05 2020   grade_4                                                   <10                                             10
1628756 1628756 TX FAYETTE COUNTY   school 4819280 75901   FLATONIA ISD 481928012888 75901103 WHISPERING HILLS ACHIEVEMENT CENTE   Alternative School No Other 03 12 2020   grade_4                                                   <10                                             10
1628848 1628848 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944009238 77901003 P A C   Alternative School No Other 04 11 2020   grade_4                                                   <10                                             10
1628872 1628872 TX MONTAGUE COUNTY   school 4819530 169910   FORESTBURG ISD 481953001808 169910001 FORESTBURG SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1629427 1629427 TX WHEELER COUNTY   school 4811400 242906   FORT ELLIOTT CISD 481140000616 242906001 FORT ELLIOTT SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   10                                             10
1629540 1629540 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001832 220905104 BOULEVARD HEIGHTS   Alternative School No Other 01 12 2020   grade_4                                                   <10                                             10
1629607 1629607 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021056 220905210 CHILDREN'S MEDICAL CTR   Alternative School No Other KG 12 2020   grade_4                                                   <10                                             10
1629811 1629811 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970007725 220905252 INSIGHTS LEARNING CENTER   Alternative School No Elementary 03 05 2020   grade_4                                                   <10                                             10
1629838 1629838 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005717 220905026 JO KELLY SP ED   Alternative School No Other KG 12 2020   grade_4                                                   <10                                             10
1630294 1630294 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021057 220905211 WOMEN'S HAVEN   Alternative School No Other PK 09 2020   grade_4                                                   <10                                             10
1631315 1631315 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034000518 57909053 GARLAND AEC   Alternative School No Other 01 12 2020   grade_4                                                   <10                                             10
1631974 1631974 TX DALLAS COUNTY   school 4800237 57835   GOLDEN RULE CHARTER SCHOOL 480023711465 57835101 GOLDEN RULE   Regular School Yes Elementary PK 04 2020   grade_4                                                   <10                                             10
1632663 1632663 TX GRAY COUNTY   school 4821560 90905   GRANDVIEW-HOPKINS ISD 482156002172 90905101 GRANDVIEW-HOPKINS EL   Regular School No Elementary KG 06 2020   grade_4                                                   <10                                             10
1633017 1633017 TX CARSON COUNTY   school 4821840 33901   GROOM ISD 482184002205 33901001 GROOM SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1633090 1633090 TX KING COUNTY   school 4822020 135001   GUTHRIE CSD 482202002217 135001001 GUTHRIE SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1633285 1633285 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247008440 15904117 COLLIER DAEP   Alternative School No Elementary 01 04 2020   grade_4                                                   <10                                             10
1634044 1634044 TX WILBARGER COUNTY   school 4822620 244901   HARROLD ISD 482262002298 244901001 HARROLD SCHOOL   Regular School No Other KG 12 2020   grade_4                                                   <10                                             10
1634510 1634510 TX LIPSCOMB COUNTY   school 4823140 148903   HIGGINS ISD 482314002349 148903001 HIGGINS SCHOOL   Regular School No Other KG 12 2020   grade_4                                                   <10                                             10
1634733 1634733 TX HIDALGO COUNTY   school 4800065 108802   HORIZON MONTESSORI PUBLIC SCHOOLS 480006513976 108802104 HORIZON MONTESSORI - PEARLAND   Regular School Yes Elementary PK 04 2020   grade_4                                                   <10                                             10
1635069 1635069 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364006270 101912013 COMMUNITY SERVICES-SEC   Alternative School No Other PK 12 2020   grade_4                                                   <10                                             10
1635206 1635206 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364012656 101912466 EL DAEP   Alternative School No Elementary 04 04 2020   grade_4                                                   <10                                             10
1636038 1636038 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364008618 101912380 R D S P D   Special Education School No Elementary PK 04 2020   grade_4                                                   <10                                             10
1636572 1636572 TX BOWIE COUNTY   school 4823700 19913   HUBBARD ISD 482370002624 19913101 HUBBARD ISD   Regular School No Elementary PK 08 2020   grade_4                                                   10                                             10
1637845 1637845 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313328 15808012 JHW INSPIRE ACADEMY - LEGACY RANCH   Alternative School Yes Other KG 12 2020   grade_4                                                   <10                                             10
1638420 1638420 TX KENT COUNTY   school 4824660 132902   JAYTON-GIRARD ISD 482466002762 132902001 JAYTON SCHOOLS   Regular School No Other PK 12 2020   grade_4                                                   10                                             10
1639635 1639635 TX WHEELER COUNTY   school 4825290 242905   KELTON ISD 482529005755 242905001 KELTON SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1639668 1639668 TX KENEDY COUNTY   school 4825410 131001   KENEDY COUNTY WIDE CSD 482541002831 131001103 SARITA EL   Regular School No Elementary PK 06 2020   grade_4                                                   <10                                             10
1639814 1639814 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002861 14906022 ADVENTHEALTH SCHOOL   Alternative School No Other 01 12 2020   grade_4                                                   <10                                             10
1639899 1639899 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566009455 14906100 EL ALTER LEARNING CENTER   Alternative School No Elementary 01 05 2020   grade_4                                                   <10                                             10
1641751 1641751 TX RUSK COUNTY   school 4826700 201903   LANEVILLE ISD 482670006577 201903001 LANEVILLE SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1642313 1642313 TX GRAY COUNTY   school 4827090 90902   LEFORS ISD 482709003047 90902001 LEFORS SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   10                                             10
1642639 1642639 TX DENTON COUNTY   school 4827300 61902   LEWISVILLE ISD 482730006744 61902005 LEARNING CTR   Alternative School No Other 01 12 2020   grade_4                                                   <10                                             10
1643236 1643236 TX MCCULLOCH COUNTY   school 4827930 160905   LOHN ISD 482793003132 160905001 LOHN SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1643684 1643684 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850005539 152901009 HOMEBOUND   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1643960 1643960 TX JONES COUNTY   school 4828530 127905   LUEDERS-AVOCA ISD 482853003224 127905101 LUEDERS-AVOCA EL/J H   Regular School No Elementary PK 08 2020   grade_4                                                   <10                                             10
1644077 1644077 TX ATASCOSA COUNTY   school 4828650 7904   LYTLE ISD 482865008422 7904002 LYTLE DAEP   Alternative School No Other 04 09 2020   grade_4                                                   <10                                             10
1644573 1644573 TX BREWSTER COUNTY   school 4828980 22902   MARATHON ISD 482898003272 22902001 MARATHON INDEPENDENT SCHOOL DIST   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1645309 1645309 TX KENDALL COUNTY   school 4801404 130801   MEADOWLAND CHARTER DISTRICT 480140412137 130801001 OAKS ACADEMY   Alternative School Yes Other 02 12 2020   grade_4                                                   <10                                             10
1646232 1646232 TX CLAY COUNTY   school 4830660 39905   MIDWAY ISD 483066003461 39905001 MIDWAY SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1646515 1646515 TX HIDALGO COUNTY   school 4831040 108908   MISSION CISD 483104008657 108908039 ROOSEVELT ALTERNATIVE SCHOOL   Alternative School No Other 04 12 2020   grade_4                                                   <10                                             10
1646675 1646675 TX SHACKELFORD COUNTY   school 4831320 209902   MORAN ISD 483132003518 209902001 MORAN SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1646690 1646690 TX BOSQUE COUNTY   school 4831380 18903   MORGAN ISD 483138003520 18903001 MORGAN SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1646704 1646704 TX ERATH COUNTY   school 4831410 72910   MORGAN MILL ISD 483141003521 72910101 MORGAN MILL EL   Regular School No Elementary PK 08 2020   grade_4                                                   <10                                             10
1646874 1646874 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192005557 167902001 MULLIN MAIN   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1646889 1646889 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192013338 167902056 PARKVIEW SCHOOL - LEVELLAND   Alternative School No Other 04 10 2020   grade_4                                                   <10                                             10
1646897 1646897 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192013340 167902055 PARKVIEW SCHOOL - LUBBOCK   Alternative School No Other KG 11 2020   grade_4                                                   <10                                             10
1647606 1647606 TX BEXAR COUNTY   school 4832940 15910   NORTH EAST ISD 483294011135 15910160 ALTERNATIVE EL   Alternative School No Elementary 03 05 2020   grade_4                                                   <10                                             10
1648460 1648460 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312003715 15915004 HOLMGREEN CENTER   Alternative School No Other PK 12 2020   grade_4                                                   <10                                             10
1648787 1648787 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312002944 15915013 REDDIX CENTER   Alternative School No Other PK 12 2020   grade_4                                                   <10                                             10
1649109 1649109 TX DALLAS COUNTY   school 4800201 57827   NOVA ACADEMY SOUTHEAST 480020108755 57827101 NOVA ACADEMY CEDAR HILL   Regular School Yes Elementary PK 06 2020   grade_4                                                   <10                                             10
1649231 1649231 TX CORYELL COUNTY   school 4833420 50904   OGLESBY ISD 483342003751 50904001 OGLESBY SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1649374 1649374 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023511986 14804002 NEW HORIZONS   Alternative School Yes Other 02 12 2020   grade_4                                                   <10                                             10
1649424 1649424 TX HASKELL COUNTY   school 4833960 104907   PAINT CREEK ISD 483396003777 104907001 PAINT CREEK SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1649958 1649958 TX DICKENS COUNTY   school 4834380 63906   PATTON SPRINGS ISD 483438003858 63906001 PATTON SPRINGS SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1649972 1649972 TX BEE COUNTY   school 4834410 13902   PAWNEE ISD 483441003859 13902101 PAWNEE EL / J H   Regular School No Elementary PK 08 2020   grade_4                                                   <10                                             10
1651550 1651550 TX MONTAGUE COUNTY   school 4835730 169909   PRAIRIE VALLEY ISD 483573004043 169909101 PRAIRIE VALLEY EL   Regular School No Elementary PK 05 2020   grade_4                                                   <10                                             10
1651755 1651755 TX MILLS COUNTY   school 4835820 167904   PRIDDY ISD 483582004057 167904001 PRIDDY SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1651858 1651858 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007612905 14803002 GEORGETOWN CHARTER ACADEMY   Regular School Yes Elementary PK 08 2020   grade_4                                                   <10                                             10
1651923 1651923 TX TRAVIS COUNTY   school 4801414 227824   PROMESA PUBLIC SCHOOLS 480141412335 227824001 THE EAST AUSTIN COLLEGE PREP AT SO   Regular School Yes Elementary PK 05 2020   grade_4                                                   10                                             10
1652131 1652131 TX DUVAL COUNTY   school 4836420 66005   RAMIREZ CSD 483642004086 66005101 RAMIREZ EL   Regular School No Elementary PK 06 2020   grade_4                                                   <10                                             10
1652535 1652535 TX DALLAS COUNTY   school 4837020 57916   RICHARDSON ISD 483702005582 57916006 CHRISTA MCAULIFFE LEARNING CENTER   Alternative School No Other 01 12 2020   grade_4                                                   <10                                             10
1652841 1652841 TX SAN SABA COUNTY   school 4837080 206902   RICHLAND SPRINGS ISD 483708004169 206902001 RICHLAND SPRINGS SCHOOL   Regular School No Other KG 12 2020   grade_4                                                   <10                                             10
1653869 1653869 TX HASKELL COUNTY   school 4838280 104903   RULE ISD 483828004270 104903001 RULE SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1654312 1654312 TX BEXAR COUNTY   school 4838730 15907   SAN ANTONIO ISD 483873000289 15907201 CHILDREN'S SHELTER OF SA   Alternative School No Elementary PK 05 2020   grade_4                                                   <10                                             10
1654536 1654536 TX BEXAR COUNTY   school 4838730 15907   SAN ANTONIO ISD 483873006612 15907180 JT BRACKENRIDGE DAEP   Alternative School No Elementary 03 05 2020   grade_4                                                   <10                                             10
1655157 1655157 TX BREWSTER COUNTY   school 4839060 22903   SAN VICENTE ISD 483906005809 22903101 SAN VICENTE EL   Regular School No Elementary PK 08 2020   grade_4                                                   <10                                             10
1656063 1656063 TX HUDSPETH COUNTY   school 4840200 115902   SIERRA BLANCA ISD 484020004558 115902001 SIERRA BLANCA SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1656143 1656143 TX COOKE COUNTY   school 4840380 49909   SIVELLS BEND ISD 484038004574 49909101 SIVELLS BEND EL   Regular School No Elementary PK 08 2020   grade_4                                                   <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]);