enrollments

Data source: Big Local News · About: Big Local

2,075 rows where grade = "grade_12", state = "TX" and year = 2020 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,075 ✖

grade ✖

  • grade_12 · 2,075 ✖
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
1620174 1620174 TX ANDERSON COUNTY   school 4813200 1902   CAYUGA ISD 481320000821 1902001 CAYUGA H S   Regular School No High 09 12 2020   grade_12                                                   40                                             40
1628364 1628364 TX ANDERSON COUNTY   school 4818390 1903   ELKHART ISD 481839001732 1903001 ELKHART H S   Regular School No High 09 12 2020   grade_12                                                   87                                             87
1630358 1630358 TX ANDERSON COUNTY   school 4819770 1904   FRANKSTON ISD 481977001939 1904001 FRANKSTON H S   Regular School No High 09 12 2020   grade_12                                                   54                                             54
1647092 1647092 TX ANDERSON COUNTY   school 4832250 1906   NECHES ISD 483225003575 1906002 NECHES H S   Regular School No High 09 12 2020   grade_12                                                   33                                             33
1649474 1649474 TX ANDERSON COUNTY   school 4834050 1907   PALESTINE ISD 483405003788 1907001 PALESTINE H S   Regular School No High 09 12 2020   grade_12                                                   224                                             224
1656197 1656197 TX ANDERSON COUNTY   school 4840500 1909   SLOCUM ISD 484050004585 1909001 SLOCUM H S   Regular School No High 09 12 2020   grade_12                                                   24                                             24
1661784 1661784 TX ANDERSON COUNTY   school 4843290 1908   WESTWOOD ISD 484329004915 1908002 WESTWOOD H S   Regular School No High 09 12 2020   grade_12                                                   95                                             95
1614934 1614934 TX ANDREWS COUNTY   school 4808280 2901   ANDREWS ISD 480828007502 2901002 ANDREWS EDUCATION CENTER   Alternative School No High 09 12 2020   grade_12                                                   <20                                             20
1614938 1614938 TX ANDREWS COUNTY   school 4808280 2901   ANDREWS ISD 480828000194 2901001 ANDREWS H S   Regular School No High 09 12 2020   grade_12                                                   225                                             225
1620388 1620388 TX ANGELINA COUNTY   school 4813500 3907   CENTRAL ISD 481350000846 3907001 CENTRAL H S   Regular School No High 09 12 2020   grade_12                                                   106                                             106
1620393 1620393 TX ANGELINA COUNTY   school 4813500 3907   CENTRAL ISD 481350007164 3907004 STUBBLEFIELD LRN CTR   Alternative School No High 12 12 2020   grade_12                                                   <10                                             10
1626030 1626030 TX ANGELINA COUNTY   school 4817040 3905   DIBOLL ISD 481704001475 3905001 DIBOLL H S   Regular School No High 09 12 2020   grade_12                                                   130                                             130
1626044 1626044 TX ANGELINA COUNTY   school 4817040 3905   DIBOLL ISD 481704007503 3905004 STUBBLEFIELD LRN CTR   Alternative School No High 10 12 2020   grade_12                                                   <10                                             10
1636594 1636594 TX ANGELINA COUNTY   school 4823790 3902   HUDSON ISD 482379002631 3902001 HUDSON H S   Regular School No High 09 12 2020   grade_12                                                   200                                             200
1636599 1636599 TX ANGELINA COUNTY   school 4823790 3902   HUDSON ISD 482379007162 3902004 STUBBLEFIELD LRN CTR   Alternative School No High 11 12 2020   grade_12                                                   <10                                             10
1636956 1636956 TX ANGELINA COUNTY   school 4824000 3904   HUNTINGTON ISD 482400002654 3904001 HUNTINGTON H S   Regular School No High 09 12 2020   grade_12                                                   115                                             115
1636964 1636964 TX ANGELINA COUNTY   school 4824000 3904   HUNTINGTON ISD 482400001969 3904005 PRIDE ALTER SCH   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1643998 1643998 TX ANGELINA COUNTY   school 4828550 3903   LUFKIN ISD 482855000536 3903201 JUVENILE DETENT CTR   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1644006 1644006 TX ANGELINA COUNTY   school 4828550 3903   LUFKIN ISD 482855007762 3903001 LUFKIN H S   Regular School No High 09 12 2020   grade_12                                                   456                                             456
1644021 1644021 TX ANGELINA COUNTY   school 4828550 3903   LUFKIN ISD 482855007163 3903004 STUBBLEFIELD LRN CTR   Alternative School No High 09 12 2020   grade_12                                                   15                                             15
1650741 1650741 TX ANGELINA COUNTY   school 4800074 3801   PINEYWOODS COMMUNITY ACADEMY 480007408093 3801001 PINEYWOODS COMMUNITY ACADEMY H S   Regular School Yes High 09 12 2020   grade_12                                                   60                                             60
1663120 1663120 TX ANGELINA COUNTY   school 4846740 3906   ZAVALLA ISD 484674005354 3906001 ZAVALLA H S   Regular School No High 06 12 2020   grade_12                                                   19                                             19
1615136 1615136 TX ARANSAS COUNTY   school 4808550 4901   ARANSAS COUNTY ISD 480855000222 4901001 ROCKPORT-FULTON H S   Regular School No High 09 12 2020   grade_12                                                   188                                             188
1615170 1615170 TX ARCHER COUNTY   school 4808610 5901   ARCHER CITY ISD 480861000229 5901001 ARCHER CITY H S   Regular School No High 07 12 2020   grade_12                                                   33                                             33
1634669 1634669 TX ARCHER COUNTY   school 4823400 5902   HOLLIDAY ISD 482340002375 5902001 HOLLIDAY H S   Regular School No High 09 12 2020   grade_12                                                   79                                             79
1662275 1662275 TX ARCHER COUNTY   school 4846080 5904   WINDTHORST ISD 484608005265 5904001 WINDTHORST H S   Regular School No High 09 12 2020   grade_12                                                   32                                             32
1620786 1620786 TX ARMSTRONG COUNTY   school 4814250 6902   CLAUDE ISD 481425000900 6902001 CLAUDE SCHOOLS   Regular School No Other PK 12 2020   grade_12                                                   19                                             19
1620542 1620542 TX ATASCOSA COUNTY   school 4813710 7901   CHARLOTTE ISD 481371000863 7901001 CHARLOTTE H S   Regular School No High 09 12 2020   grade_12                                                   38                                             38
1638614 1638614 TX ATASCOSA COUNTY   school 4824960 7902   JOURDANTON ISD 482496002785 7902001 JOURDANTON H S   Regular School No High 09 12 2020   grade_12                                                   101                                             101
1644087 1644087 TX ATASCOSA COUNTY   school 4828650 7904   LYTLE ISD 482865003246 7904001 LYTLE H S   Regular School No High 09 12 2020   grade_12                                                   99                                             99
1651250 1651250 TX ATASCOSA COUNTY   school 4835190 7905   PLEASANTON ISD 483519003984 7905001 PLEASANTON H S   Regular School No High 09 12 2020   grade_12                                                   235                                             235
1651252 1651252 TX ATASCOSA COUNTY   school 4835190 7905   PLEASANTON ISD 483519011945 7905005 PLEASANTON ISD SCHOOL OF CHOICE   Alternative School No High 10 12 2020   grade_12                                                   <10                                             10
1651492 1651492 TX ATASCOSA COUNTY   school 4835520 7906   POTEET ISD 483552004029 7906001 POTEET H S   Regular School No High 09 12 2020   grade_12                                                   105                                             105
1617293 1617293 TX AUSTIN COUNTY   school 4809810 8901   BELLVILLE ISD 480981000449 8901001 BELLVILLE H S   Regular School No High 09 12 2020   grade_12                                                   165                                             165
1618203 1618203 TX AUSTIN COUNTY   school 4844470 8903   BRAZOS ISD 484447005075 8903001 BRAZOS H S   Regular School No High 09 12 2020   grade_12                                                   72                                             72
1618213 1618213 TX AUSTIN COUNTY   school 4844470 8903   BRAZOS ISD 484447013001 8903103 PRAIRIE HARBOR ALTERNATIVE SCHOOL   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1655617 1655617 TX AUSTIN COUNTY   school 4839630 8902   SEALY ISD 483963004502 8902001 SEALY H S   Regular School No High 09 12 2020   grade_12                                                   180                                             180
1646862 1646862 TX BAILEY COUNTY   school 4831890 9901   MULESHOE ISD 483189003547 9901001 MULESHOE H S   Regular School No High 09 12 2020   grade_12                                                   75                                             75
1646865 1646865 TX BAILEY COUNTY   school 4831890 9901   MULESHOE ISD 483189008094 9901002 P E P   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1616874 1616874 TX BANDERA COUNTY   school 4809360 10902   BANDERA ISD 480936000395 10902001 BANDERA H S   Regular School No High 09 12 2020   grade_12                                                   146                                             146
1645334 1645334 TX BANDERA COUNTY   school 4830030 10901   MEDINA ISD 483003003372 10901001 MEDINA SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   21                                             21
1616980 1616980 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957000409 11901001 BASTROP H S   Regular School No High 09 12 2020   grade_12                                                   303                                             303
1617002 1617002 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957012272 11901002 CEDAR CREEK H S   Regular School No High 09 12 2020   grade_12                                                   354                                             354
1617010 1617010 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957013111 11901005 COLORADO RIVER COLLEGIATE ACADEMY   Regular School No High 09 12 2020   grade_12                                                   43                                             43
1617021 1617021 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957021082 11901022 GENESIS H S   Alternative School No High 09 12 2020   grade_12                                                   42                                             42
1628342 1628342 TX BASTROP COUNTY   school 4818360 11902   ELGIN ISD 481836001728 11902001 ELGIN H S   Regular School No High 09 12 2020   grade_12                                                   309                                             309
1628355 1628355 TX BASTROP COUNTY   school 4818360 11902   ELGIN ISD 481836008426 11902004 PHOENIX H S   Alternative School No High 09 12 2020   grade_12                                                   11                                             11
1645066 1645066 TX BASTROP COUNTY   school 4829760 11905   MCDADE ISD 482976013256 11905001 MCDADE H S   Regular School No High 07 12 2020   grade_12                                                   16                                             16
1656220 1656220 TX BASTROP COUNTY   school 4840550 11904   SMITHVILLE ISD 484055004590 11904002 SMITHVILLE H S   Regular School No High 09 12 2020   grade_12                                                   121                                             121
1655756 1655756 TX BAYLOR COUNTY   school 4839780 12901   SEYMOUR ISD 483978004520 12901001 SEYMOUR H S   Regular School No High 09 12 2020   grade_12                                                   36                                             36
1617238 1617238 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972000442 13901001 A C JONES H S   Regular School No High 09 12 2020   grade_12                                                   204                                             204
1650241 1650241 TX BEE COUNTY   school 4834770 13903   PETTUS ISD 483477003899 13903001 PETTUS SECONDARY   Regular School No High 06 12 2020   grade_12                                                   32                                             32
1656158 1656158 TX BEE COUNTY   school 4840410 13905   SKIDMORE-TYNAN ISD 484041004576 13905001 SKIDMORE-TYNAN H S   Regular School No High 09 12 2020   grade_12                                                   63                                             63
1613356 1613356 TX BELL COUNTY   school 4807470 14901   ACADEMY ISD 480747000040 14901001 ACADEMY H S   Regular School No High 09 12 2020   grade_12                                                   111                                             111
1616957 1616957 TX BELL COUNTY   school 4809540 14902   BARTLETT ISD 480954000406 14902001 BARTLETT SCHOOLS   Regular School No Other PK 12 2020   grade_12                                                   21                                             21
1617319 1617319 TX BELL COUNTY   school 4809860 14903   BELTON ISD 480986000454 14903001 BELTON H S   Regular School No High 09 12 2020   grade_12                                                   679                                             679
1617323 1617323 TX BELL COUNTY   school 4809860 14903   BELTON ISD 480986008099 14903005 BELTON NEW TECH H S AT WASKOW   Regular School No High 09 12 2020   grade_12                                                   117                                             117
1634654 1634654 TX BELL COUNTY   school 4823370 14905   HOLLAND ISD 482337002373 14905001 HOLLAND H S   Regular School No High 09 12 2020   grade_12                                                   55                                             55
1639822 1639822 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002861 14906022 ADVENTHEALTH SCHOOL   Alternative School No Other 01 12 2020   grade_12                                                   <10                                             10
1639852 1639852 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002866 14906002 C E ELLISON H S   Regular School No High 09 12 2020   grade_12                                                   595                                             595
1639904 1639904 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566006281 14906004 GATEWAY H S   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1639918 1639918 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566008695 14906007 HARKER HEIGHTS H S   Regular School No High 09 12 2020   grade_12                                                   604                                             604
1639952 1639952 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002871 14906001 KILLEEN H S   Regular School No High 09 12 2020   grade_12                                                   441                                             441
1639956 1639956 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566013234 14906013 KILLEEN ISD EARLY COLLEGE H S   Regular School No High 09 12 2020   grade_12                                                   229                                             229
1640027 1640027 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566021001 14906006 PATHWAYS ACADEMIC CAMPUS   Alternative School No High 09 12 2020   grade_12                                                   132                                             132
1640063 1640063 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566008696 14906008 ROBERT M SHOEMAKER H S   Regular School No High 09 12 2020   grade_12                                                   455                                             455
1649357 1649357 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023512294 14804006 GATEWAY COLLEGE PREPARATORY SCHOOL   Regular School Yes Other KG 12 2020   grade_12                                                   55                                             55
1649361 1649361 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023512289 14804005 GATEWAY TECH H S   Alternative School Yes High 09 12 2020   grade_12                                                   14                                             14
1651852 1651852 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007613035 14803003 COVE CHARTER ACADEMY   Regular School Yes Other PK 12 2020   grade_12                                                   <10                                             10
1651876 1651876 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007608098 14803101 TEMPLE CHARTER ACADEMY   Alternative School Yes Other PK 12 2020   grade_12                                                   <10                                             10
1652417 1652417 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007509009 14801008 RICHARD MILBURN ACADEMY AMARILLO   Alternative School Yes High 09 12 2020   grade_12                                                   41                                             41
1652421 1652421 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007508344 14801007 RICHARD MILBURN ACADEMY CORPUS CHR   Alternative School Yes High 09 12 2020   grade_12                                                   67                                             67
1652425 1652425 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007509507 14801006 RICHARD MILBURN ACADEMY FORT WORTH   Alternative School Yes High 09 12 2020   grade_12                                                   43                                             43
1652429 1652429 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007513173 14801005 RICHARD MILBURN ACADEMY HOUSTON (S   Alternative School Yes High 09 12 2020   grade_12                                                   77                                             77
1652433 1652433 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007508324 14801004 RICHARD MILBURN ACADEMY LUBBOCK   Alternative School Yes High 09 12 2020   grade_12                                                   37                                             37
1652437 1652437 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007513433 14801010 RICHARD MILBURN ACADEMY MIDLAND SO   Alternative School Yes High 09 12 2020   grade_12                                                   29                                             29
1652441 1652441 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007509647 14801002 RICHARD MILBURN ACADEMY ODESSA   Alternative School Yes High 09 12 2020   grade_12                                                   116                                             116
1652445 1652445 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007513435 14801009 RICHARD MILBURN ACADEMY PASADENA   Alternative School Yes High 09 12 2020   grade_12                                                   42                                             42
1652449 1652449 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007508097 14801001 RICHARD MILBURN ALTER H S (KILLEEN   Alternative School Yes High 09 12 2020   grade_12                                                   50                                             50
1653320 1653320 TX BELL COUNTY   school 4837710 14907   ROGERS ISD 483771012091 14907043 BELL COUNTY DAEP   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1653331 1653331 TX BELL COUNTY   school 4837710 14907   ROGERS ISD 483771004225 14907001 ROGERS H S   Regular School No High 09 12 2020   grade_12                                                   60                                             60
1653987 1653987 TX BELL COUNTY   school 4838580 14908   SALADO ISD 483858004288 14908001 SALADO H S   Regular School No High 09 12 2020   grade_12                                                   144                                             144
1658083 1658083 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233008697 14909006 BELL CO J J A E P   Alternative School No High 08 12 2020   grade_12                                                   <10                                             10
1658097 1658097 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233012581 14909008 FRED W EDWARDS ACADEMY AEC   Alternative School No High 09 12 2020   grade_12                                                   25                                             25
1658141 1658141 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233004827 14909002 TEMPLE H S   Regular School No High 09 12 2020   grade_12                                                   472                                             472
1658165 1658165 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233008430 14909005 WHEATLEY ALTERNATIVE EDUCATION CEN   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1659422 1659422 TX BELL COUNTY   school 4843260 14910   TROY ISD 484326004913 14910001 TROY H S   Regular School No High 09 12 2020   grade_12                                                   107                                             107
1613435 1613435 TX BEXAR COUNTY   school 4807590 15901   ALAMO HEIGHTS ISD 480759000045 15901001 ALAMO HEIGHTS H S   Regular School No High 09 12 2020   grade_12                                                   389                                             389
1616976 1616976 TX BEXAR COUNTY   school 4801438 15834   BASIS TEXAS 480143813036 15834001 BASIS SAN ANTONIO- SHAVANO CAMPUS   Regular School Yes High 06 12 2020   grade_12                                                   76                                             76
1618543 1618543 TX BEXAR COUNTY   school 4800268 15830   BROOKS ACADEMIES OF TEXAS 480026811128 15830001 BROOKS ACADEMY OF SCIENCE AND ENGI   Regular School Yes Other PK 12 2020   grade_12                                                   108                                             108
1618557 1618557 TX BEXAR COUNTY   school 4800268 15830   BROOKS ACADEMIES OF TEXAS 480026813064 15830101 BROOKS COLLEGIATE ACADEMY   Regular School Yes Other PK 12 2020   grade_12                                                   52                                             52
1626922 1626922 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785008449 15911003 EAST CENTRAL CHOICE PROGAM   Alternative School No High 05 12 2020   grade_12                                                   <10                                             10
1626926 1626926 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785001554 15911001 EAST CENTRAL H S   Regular School No High 09 12 2020   grade_12                                                   698                                             698
1627333 1627333 TX BEXAR COUNTY   school 4818150 15905   EDGEWOOD ISD 481815008442 15905042 ALTERNATIVE CENTER   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1627380 1627380 TX BEXAR COUNTY   school 4818150 15905   EDGEWOOD ISD 481815001624 15905002 JOHN F KENNEDY H S   Regular School No High 09 12 2020   grade_12                                                   201                                             201
1627405 1627405 TX BEXAR COUNTY   school 4818150 15905   EDGEWOOD ISD 481815001628 15905003 MEMORIAL H S   Regular School No High 09 12 2020   grade_12                                                   250                                             250
1630949 1630949 TX BEXAR COUNTY   school 4820160 15914   FT SAM HOUSTON ISD 482016001965 15914001 ROBERT G COLE MIDDLE/HIGH SCHOOL   Regular School No High 06 12 2020   grade_12                                                   92                                             92
1631705 1631705 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001407174 15802001 GEORGE GERVIN ACADEMY   Alternative School Yes Other PK 12 2020   grade_12                                                   11                                             11
1631712 1631712 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001410415 15802004 RUTH JONES MCCLENDON MIDDLE   Alternative School Yes High 06 12 2020   grade_12                                                   <10                                             10
1632868 1632868 TX BEXAR COUNTY   school 4801441 15835   GREAT HEARTS TEXAS 480144113102 15835002 GREAT HEARTS MONTE VISTA NORTH   Regular School Yes High 06 12 2020   grade_12                                                   45                                             45

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