enrollments

Data source: Big Local News · About: Big Local

4,633 rows where grade = "grade_2", state = "TX" and year = 2020 sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 4,633 ✖

grade ✖

  • grade_2 · 4,633 ✖
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 ▼
1613393 1613393 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1613919 1613919 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783011491 101903205 ALIEF LEARNING CTR (K-6)   Alternative School No Elementary 01 06 2020   grade_2                                                   <10                                             10
1615922 1615922 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005646 227901250 AUSTIN ST HOSPITAL   Alternative School No Other 01 12 2020   grade_2                                                   <10                                             10
1616532 1616532 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005396 227901251 ROSEDALE   Alternative School No Other PK 12 2020   grade_2                                                   10                                             10
1616690 1616690 TX REFUGIO COUNTY   school 4809000 196901   AUSTWELL-TIVOLI ISD 480900000372 196901102 AUSTWELL-TIVOLI EL   Regular School No Elementary PK 06 2020   grade_2                                                   <10                                             10
1616733 1616733 TX CASS COUNTY   school 4809090 34902   AVINGER ISD 480909000378 34902001 AVINGER SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1616852 1616852 TX REEVES COUNTY   school 4809330 195902   BALMORHEA ISD 480933000392 195902001 BALMORHEA SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   10                                             10
1617079 1617079 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967013717 123910134 BEAUMONT NEW EL DAEP   Alternative School No Elementary 02 05 2020   grade_2                                                   <10                                             10
1617264 1617264 TX CLAY COUNTY   school 4809750 39904   BELLEVUE ISD 480975000446 39904001 BELLEVUE SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1617424 1617424 TX KNOX COUNTY   school 4809980 138904   BENJAMIN ISD 480998000468 138904001 BENJAMIN SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   10                                             10
1617512 1617512 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022709011 193801001 BIG SPRINGS CHARTER SCHOOL   Alternative School Yes Other KG 12 2020   grade_2                                                   <10                                             10
1617525 1617525 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022711321 193801101 HILL COUNTRY YOUTH RANCH   Alternative School Yes Other KG 12 2020   grade_2                                                   <10                                             10
1617764 1617764 TX NOLAN COUNTY   school 4800005 177903   BLACKWELL CISD 480000500513 177903001 BLACKWELL SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1617809 1617809 TX BROWN COUNTY   school 4810380 25904   BLANKET ISD 481038005661 25904001 BLANKET SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1618062 1618062 TX BORDEN COUNTY   school 4810860 17901   BORDEN COUNTY ISD 481086000552 17901001 BORDEN COUNTY SCHOOL   Regular School No Other KG 12 2020   grade_2                                                   <10                                             10
1618158 1618158 TX OLDHAM COUNTY   school 4811040 180901   BOYS RANCH ISD 481104000570 180901101 MIMI FARLEY EL   Regular School No Elementary PK 05 2020   grade_2                                                   <10                                             10
1618216 1618216 TX SOMERVELL COUNTY   school 4800214 213801   BRAZOS RIVER CHARTER SCHOOL 480021408907 213801001 BRAZOS RIVER CHARTER SCHOOL   Alternative School Yes Other KG 12 2020   grade_2                                                   <10                                             10
1619150 1619150 TX MILAM COUNTY   school 4811850 166907   BUCKHOLTS ISD 481185000697 166907001 BUCKHOLTS SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   10                                             10
1619548 1619548 TX CALHOUN COUNTY   school 4812480 29901   CALHOUN COUNTY ISD 481248000749 29901105 PORT O CONNOR EL   Regular School No Elementary PK 05 2020   grade_2                                                   <10                                             10
1619585 1619585 TX ROBERTSON COUNTY   school 4812540 198902   CALVERT ISD 481254000756 198902101 CALVERT SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1619977 1619977 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305005854 57903117 HUIE SPECIAL EDUC CTR   Alternative School No Other PK 12 2020   grade_2                                                   <10                                             10
1620549 1620549 TX SAN SABA COUNTY   school 4813740 206903   CHEROKEE ISD 481374000866 206903001 CHEROKEE SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1621799 1621799 TX HARRIS COUNTY   school 4800127 101842   COMQUEST ACADEMY 480012708255 101842001 COMQUEST ACADEMY   Alternative School Yes Other 01 12 2020   grade_2                                                   <10                                             10
1622624 1622624 TX NUECES COUNTY   school 4815270 178904   CORPUS CHRISTI ISD 481527005681 178904054 STUDENT SUPPORT CENTER   Alternative School No Other 02 12 2020   grade_2                                                   <10                                             10
1622744 1622744 TX HALE COUNTY   school 4815360 95902   COTTON CENTER ISD 481536001112 95902001 COTTON CENTER SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1622874 1622874 TX BOSQUE COUNTY   school 4815570 18908   CRANFILLS GAP ISD 481557001129 18908001 CRANFILLS GAP SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1624394 1624394 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006391 57905099 HOSPITAL/HOMEBOUND   Alternative School No Other PK 12 2020   grade_2                                                   <10                                             10
1625278 1625278 TX BRAZORIA COUNTY   school 4816260 20910   DAMON ISD 481626001391 20910101 DAMON EL   Regular School No Elementary PK 08 2020   grade_2                                                   <10                                             10
1625303 1625303 TX LIPSCOMB COUNTY   school 4816320 148905   DARROUZETT ISD 481632001699 148905101 DARROUZETT SCHOOLS   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1625330 1625330 TX DAWSON COUNTY   school 4816350 58902   DAWSON ISD 481635001399 58902001 DAWSON SCHOOL   Regular School No Other KG 12 2020   grade_2                                                   10                                             10
1625580 1625580 TX HUDSPETH COUNTY   school 4816650 115903   DELL CITY ISD 481665001429 115903001 DELL CITY SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1626146 1626146 TX LEE COUNTY   school 4817130 144903   DIME BOX ISD 481713001486 144903001 DIME BOX SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1626328 1626328 TX GILLESPIE COUNTY   school 4817400 86024   DOSS CONSOLIDATED CSD 481740001503 86024101 DOSS EL   Regular School No Elementary PK 07 2020   grade_2                                                   <10                                             10
1627358 1627358 TX BEXAR COUNTY   school 4818150 15905   EDGEWOOD ISD 481815013488 15905126 EL DAEP   Alternative School No Elementary 02 04 2020   grade_2                                                   <10                                             10
1628445 1628445 TX NACOGDOCHES COUNTY   school 4818660 174910   ETOILE ISD 481866001747 174910101 ETOILE EL   Regular School No Elementary PK 08 2020   grade_2                                                   <10                                             10
1628604 1628604 TX SHELBY COUNTY   school 4818840 210906   EXCELSIOR ISD 481884001762 210906101 EXCELSIOR EL   Regular School No Elementary PK 08 2020   grade_2                                                   <10                                             10
1628614 1628614 TX LAVACA COUNTY   school 4818890 143906   EZZELL ISD 481889001764 143906101 EZZELL EL   Regular School No Elementary PK 08 2020   grade_2                                                   <10                                             10
1628669 1628669 TX DELTA COUNTY   school 4819050 60914   FANNINDEL ISD 481905001775 60914102 FANNINDEL EL   Regular School No Elementary PK 05 2020   grade_2                                                   <10                                             10
1628856 1628856 TX LIPSCOMB COUNTY   school 4819500 148902   FOLLETT ISD 481950001806 148902001 FOLLETT SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1629538 1629538 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001832 220905104 BOULEVARD HEIGHTS   Alternative School No Other 01 12 2020   grade_2                                                   <10                                             10
1629605 1629605 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021056 220905210 CHILDREN'S MEDICAL CTR   Alternative School No Other KG 12 2020   grade_2                                                   <10                                             10
1629836 1629836 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005717 220905026 JO KELLY SP ED   Alternative School No Other KG 12 2020   grade_2                                                   <10                                             10
1631314 1631314 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034000518 57909053 GARLAND AEC   Alternative School No Other 01 12 2020   grade_2                                                   <10                                             10
1631958 1631958 TX MONTAGUE COUNTY   school 4820970 169906   GOLD BURG ISD 482097002091 169906001 GOLD BURG SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1632661 1632661 TX GRAY COUNTY   school 4821560 90905   GRANDVIEW-HOPKINS ISD 482156002172 90905101 GRANDVIEW-HOPKINS EL   Regular School No Elementary KG 06 2020   grade_2                                                   10                                             10
1633074 1633074 TX COMANCHE COUNTY   school 4821990 47903   GUSTINE ISD 482199002215 47903001 GUSTINE SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1633088 1633088 TX KING COUNTY   school 4822020 135001   GUTHRIE CSD 482202002217 135001001 GUTHRIE SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1634042 1634042 TX WILBARGER COUNTY   school 4822620 244901   HARROLD ISD 482262002298 244901001 HARROLD SCHOOL   Regular School No Other KG 12 2020   grade_2                                                   <10                                             10
1634304 1634304 TX DONLEY COUNTY   school 4822850 65902   HEDLEY ISD 482285002317 65902001 HEDLEY SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1634508 1634508 TX LIPSCOMB COUNTY   school 4823140 148903   HIGGINS ISD 482314002349 148903001 HIGGINS SCHOOL   Regular School No Other KG 12 2020   grade_2                                                   <10                                             10
1634522 1634522 TX GALVESTON COUNTY   school 4823160 84903   HIGH ISLAND ISD 482316002351 84903001 HIGH ISLAND SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   10                                             10
1634731 1634731 TX HIDALGO COUNTY   school 4800065 108802   HORIZON MONTESSORI PUBLIC SCHOOLS 480006513976 108802104 HORIZON MONTESSORI - PEARLAND   Regular School Yes Elementary PK 04 2020   grade_2                                                   <10                                             10
1635067 1635067 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364006270 101912013 COMMUNITY SERVICES-SEC   Alternative School No Other PK 12 2020   grade_2                                                   <10                                             10
1636365 1636365 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364011385 101912328 TSU CHARTER LAB SCH   Regular School Yes Elementary PK 02 2020   grade_2                                                   10                                             10
1636523 1636523 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364007949 101912371 YOUNG SCHOLARS ACADEMY FOR EXCELLE   Regular School Yes Elementary PK 08 2020   grade_2                                                   <10                                             10
1637843 1637843 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313328 15808012 JHW INSPIRE ACADEMY - LEGACY RANCH   Alternative School Yes Other KG 12 2020   grade_2                                                   <10                                             10
1638088 1638088 TX BOSQUE COUNTY   school 4824360 18906   IREDELL ISD 482436002714 18906001 IREDELL SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1638720 1638720 TX BEXAR COUNTY   school 4800179 15822   JUBILEE ACADEMIES 480017913941 15822014 JUBILEE SENDERO   Regular School Yes Elementary PK 03 2020   grade_2                                                   <10                                             10
1639633 1639633 TX WHEELER COUNTY   school 4825290 242905   KELTON ISD 482529005755 242905001 KELTON SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1639666 1639666 TX KENEDY COUNTY   school 4825410 131001   KENEDY COUNTY WIDE CSD 482541002831 131001103 SARITA EL   Regular School No Elementary PK 06 2020   grade_2                                                   <10                                             10
1639787 1639787 TX HAYS COUNTY   school 4801447 105803   KI CHARTER ACADEMY 480144713122 105803001 KI CHARTER ACADEMY   Alternative School Yes Other 02 12 2020   grade_2                                                   <10                                             10
1639897 1639897 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566009455 14906100 EL ALTER LEARNING CENTER   Alternative School No Elementary 01 05 2020   grade_2                                                   <10                                             10
1641749 1641749 TX RUSK COUNTY   school 4826700 201903   LANEVILLE ISD 482670006577 201903001 LANEVILLE SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1642000 1642000 TX PARMER COUNTY   school 4826970 185904   LAZBUDDIE ISD 482697003038 185904001 LAZBUDDIE SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1642300 1642300 TX BOWIE COUNTY   school 4827060 19914   LEARY ISD 482706003045 19914101 LEARY EL   Regular School No Elementary PK 08 2020   grade_2                                                   10                                             10
1642311 1642311 TX GRAY COUNTY   school 4827090 90902   LEFORS ISD 482709003047 90902001 LEFORS SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1642637 1642637 TX DENTON COUNTY   school 4827300 61902   LEWISVILLE ISD 482730006744 61902005 LEARNING CTR   Alternative School No Other 01 12 2020   grade_2                                                   <10                                             10
1643026 1643026 TX ORANGE COUNTY   school 4827690 181908   LITTLE CYPRESS-MAURICEVILLE CISD 482769003107 181908103 LITTLE CYPRESS INT   Regular School No Elementary 02 05 2020   grade_2                                                   <10                                             10
1643234 1643234 TX MCCULLOCH COUNTY   school 4827930 160905   LOHN ISD 482793003132 160905001 LOHN SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1643386 1643386 TX MITCHELL COUNTY   school 4828170 168902   LORAINE ISD 482817003156 168902001 LORAINE SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1643682 1643682 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850005539 152901009 HOMEBOUND   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1643958 1643958 TX JONES COUNTY   school 4828530 127905   LUEDERS-AVOCA ISD 482853003224 127905101 LUEDERS-AVOCA EL/J H   Regular School No Elementary PK 08 2020   grade_2                                                   <10                                             10
1644571 1644571 TX BREWSTER COUNTY   school 4828980 22902   MARATHON ISD 482898003272 22902001 MARATHON INDEPENDENT SCHOOL DIST   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1645307 1645307 TX KENDALL COUNTY   school 4801404 130801   MEADOWLAND CHARTER DISTRICT 480140412137 130801001 OAKS ACADEMY   Alternative School Yes Other 02 12 2020   grade_2                                                   <10                                             10
1645845 1645845 TX DEWITT COUNTY   school 4830450 62906   MEYERSVILLE ISD 483045003427 62906101 MEYERSVILLE EL   Regular School No Elementary PK 08 2020   grade_2                                                   <10                                             10
1646230 1646230 TX CLAY COUNTY   school 4830660 39905   MIDWAY ISD 483066003461 39905001 MIDWAY SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1646673 1646673 TX SHACKELFORD COUNTY   school 4831320 209902   MORAN ISD 483132003518 209902001 MORAN SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1646728 1646728 TX MOTLEY COUNTY   school 4831500 173901   MOTLEY COUNTY ISD 483150003526 173901001 MOTLEY COUNTY SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1646757 1646757 TX HILL COUNTY   school 4831620 109910   MOUNT CALM ISD 483162003529 109910101 MOUNT CALM ISD   Regular School No Other PK 12 2020   grade_2                                                   10                                             10
1646872 1646872 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192005557 167902001 MULLIN MAIN   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1646895 1646895 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192013340 167902055 PARKVIEW SCHOOL - LUBBOCK   Alternative School No Other KG 11 2020   grade_2                                                   <10                                             10
1648458 1648458 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312003715 15915004 HOLMGREEN CENTER   Alternative School No Other PK 12 2020   grade_2                                                   <10                                             10
1648767 1648767 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312003032 15915250 PUPIL PERSONNEL CAMPUS   Alternative School No Other KG 09 2020   grade_2                                                   <10                                             10
1648786 1648786 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312002944 15915013 REDDIX CENTER   Alternative School No Other PK 12 2020   grade_2                                                   <10                                             10
1649245 1649245 TX RUNNELS COUNTY   school 4833570 200906   OLFEN ISD 483357003754 200906101 OLFEN SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1649372 1649372 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023511986 14804002 NEW HORIZONS   Alternative School Yes Other 02 12 2020   grade_2                                                   <10                                             10
1649408 1649408 TX COTTLE COUNTY   school 4833900 51901   PADUCAH ISD 483390003775 51901001 PADUCAH SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1649422 1649422 TX HASKELL COUNTY   school 4833960 104907   PAINT CREEK ISD 483396003777 104907001 PAINT CREEK SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1649452 1649452 TX CONCHO COUNTY   school 4833980 48903   PAINT ROCK ISD 483398009184 48903190 WALL SPECIAL PROGRAMS   Alternative School No Elementary 01 06 2020   grade_2                                                   <10                                             10
1649956 1649956 TX DICKENS COUNTY   school 4834380 63906   PATTON SPRINGS ISD 483438003858 63906001 PATTON SPRINGS SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1651753 1651753 TX MILLS COUNTY   school 4835820 167904   PRIDDY ISD 483582004057 167904001 PRIDDY SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1652129 1652129 TX DUVAL COUNTY   school 4836420 66005   RAMIREZ CSD 483642004086 66005101 RAMIREZ EL   Regular School No Elementary PK 06 2020   grade_2                                                   <10                                             10
1652453 1652453 TX GRIMES COUNTY   school 4836990 93905   RICHARDS ISD 483699004120 93905101 RICHARDS EL   Regular School No Elementary PK 06 2020   grade_2                                                   10                                             10
1652533 1652533 TX DALLAS COUNTY   school 4837020 57916   RICHARDSON ISD 483702005582 57916006 CHRISTA MCAULIFFE LEARNING CENTER   Alternative School No Other 01 12 2020   grade_2                                                   <10                                             10
1652839 1652839 TX SAN SABA COUNTY   school 4837080 206902   RICHLAND SPRINGS ISD 483708004169 206902001 RICHLAND SPRINGS SCHOOL   Regular School No Other KG 12 2020   grade_2                                                   10                                             10
1653867 1653867 TX HASKELL COUNTY   school 4838280 104903   RULE ISD 483828004270 104903001 RULE SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   10                                             10
1654310 1654310 TX BEXAR COUNTY   school 4838730 15907   SAN ANTONIO ISD 483873000289 15907201 CHILDREN'S SHELTER OF SA   Alternative School No Elementary PK 05 2020   grade_2                                                   <10                                             10
1655155 1655155 TX BREWSTER COUNTY   school 4839060 22903   SAN VICENTE ISD 483906005809 22903101 SAN VICENTE EL   Regular School No Elementary PK 08 2020   grade_2                                                   <10                                             10
1656047 1656047 TX COMANCHE COUNTY   school 4840170 47905   SIDNEY ISD 484017004556 47905001 SIDNEY SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1656061 1656061 TX HUDSPETH COUNTY   school 4840200 115902   SIERRA BLANCA ISD 484020004558 115902001 SIERRA BLANCA SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <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]);