enrollments

Data source: Big Local News · About: Big Local

2,167 rows where grade = "grade_11", state = "TX" and year = 2020 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,167 ✖

grade ✖

  • grade_11 · 2,167 ✖
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
1620173 1620173 TX ANDERSON COUNTY   school 4813200 1902   CAYUGA ISD 481320000821 1902001 CAYUGA H S   Regular School No High 09 12 2020   grade_11                                                   40                                             40
1628363 1628363 TX ANDERSON COUNTY   school 4818390 1903   ELKHART ISD 481839001732 1903001 ELKHART H S   Regular School No High 09 12 2020   grade_11                                                   101                                             101
1630357 1630357 TX ANDERSON COUNTY   school 4819770 1904   FRANKSTON ISD 481977001939 1904001 FRANKSTON H S   Regular School No High 09 12 2020   grade_11                                                   47                                             47
1647091 1647091 TX ANDERSON COUNTY   school 4832250 1906   NECHES ISD 483225003575 1906002 NECHES H S   Regular School No High 09 12 2020   grade_11                                                   23                                             23
1649473 1649473 TX ANDERSON COUNTY   school 4834050 1907   PALESTINE ISD 483405003788 1907001 PALESTINE H S   Regular School No High 09 12 2020   grade_11                                                   211                                             211
1656196 1656196 TX ANDERSON COUNTY   school 4840500 1909   SLOCUM ISD 484050004585 1909001 SLOCUM H S   Regular School No High 09 12 2020   grade_11                                                   31                                             31
1661783 1661783 TX ANDERSON COUNTY   school 4843290 1908   WESTWOOD ISD 484329004915 1908002 WESTWOOD H S   Regular School No High 09 12 2020   grade_11                                                   98                                             98
1614933 1614933 TX ANDREWS COUNTY   school 4808280 2901   ANDREWS ISD 480828007502 2901002 ANDREWS EDUCATION CENTER   Alternative School No High 09 12 2020   grade_11                                                   14                                             14
1614937 1614937 TX ANDREWS COUNTY   school 4808280 2901   ANDREWS ISD 480828000194 2901001 ANDREWS H S   Regular School No High 09 12 2020   grade_11                                                   288                                             288
1620387 1620387 TX ANGELINA COUNTY   school 4813500 3907   CENTRAL ISD 481350000846 3907001 CENTRAL H S   Regular School No High 09 12 2020   grade_11                                                   94                                             94
1626029 1626029 TX ANGELINA COUNTY   school 4817040 3905   DIBOLL ISD 481704001475 3905001 DIBOLL H S   Regular School No High 09 12 2020   grade_11                                                   109                                             109
1626043 1626043 TX ANGELINA COUNTY   school 4817040 3905   DIBOLL ISD 481704007503 3905004 STUBBLEFIELD LRN CTR   Alternative School No High 10 12 2020   grade_11                                                   <10                                             10
1636593 1636593 TX ANGELINA COUNTY   school 4823790 3902   HUDSON ISD 482379002631 3902001 HUDSON H S   Regular School No High 09 12 2020   grade_11                                                   181                                             181
1636598 1636598 TX ANGELINA COUNTY   school 4823790 3902   HUDSON ISD 482379007162 3902004 STUBBLEFIELD LRN CTR   Alternative School No High 11 12 2020   grade_11                                                   <10                                             10
1636955 1636955 TX ANGELINA COUNTY   school 4824000 3904   HUNTINGTON ISD 482400002654 3904001 HUNTINGTON H S   Regular School No High 09 12 2020   grade_11                                                   106                                             106
1636963 1636963 TX ANGELINA COUNTY   school 4824000 3904   HUNTINGTON ISD 482400001969 3904005 PRIDE ALTER SCH   Alternative School No High 09 12 2020   grade_11                                                   <10                                             10
1643997 1643997 TX ANGELINA COUNTY   school 4828550 3903   LUFKIN ISD 482855000536 3903201 JUVENILE DETENT CTR   Alternative School No High 06 12 2020   grade_11                                                   <10                                             10
1644005 1644005 TX ANGELINA COUNTY   school 4828550 3903   LUFKIN ISD 482855007762 3903001 LUFKIN H S   Regular School No High 09 12 2020   grade_11                                                   509                                             509
1644020 1644020 TX ANGELINA COUNTY   school 4828550 3903   LUFKIN ISD 482855007163 3903004 STUBBLEFIELD LRN CTR   Alternative School No High 09 12 2020   grade_11                                                   14                                             14
1650740 1650740 TX ANGELINA COUNTY   school 4800074 3801   PINEYWOODS COMMUNITY ACADEMY 480007408093 3801001 PINEYWOODS COMMUNITY ACADEMY H S   Regular School Yes High 09 12 2020   grade_11                                                   57                                             57
1663105 1663105 TX ANGELINA COUNTY   school 4846740 3906   ZAVALLA ISD 484674009579 3906004 STUBBLEFIELD LRN CTR   Alternative School No Secondary 11 11 2020   grade_11                                                   <10                                             10
1663119 1663119 TX ANGELINA COUNTY   school 4846740 3906   ZAVALLA ISD 484674005354 3906001 ZAVALLA H S   Regular School No High 06 12 2020   grade_11                                                   26                                             26
1615135 1615135 TX ARANSAS COUNTY   school 4808550 4901   ARANSAS COUNTY ISD 480855000222 4901001 ROCKPORT-FULTON H S   Regular School No High 09 12 2020   grade_11                                                   183                                             183
1615169 1615169 TX ARCHER COUNTY   school 4808610 5901   ARCHER CITY ISD 480861000229 5901001 ARCHER CITY H S   Regular School No High 07 12 2020   grade_11                                                   36                                             36
1634668 1634668 TX ARCHER COUNTY   school 4823400 5902   HOLLIDAY ISD 482340002375 5902001 HOLLIDAY H S   Regular School No High 09 12 2020   grade_11                                                   76                                             76
1662274 1662274 TX ARCHER COUNTY   school 4846080 5904   WINDTHORST ISD 484608005265 5904001 WINDTHORST H S   Regular School No High 09 12 2020   grade_11                                                   30                                             30
1620785 1620785 TX ARMSTRONG COUNTY   school 4814250 6902   CLAUDE ISD 481425000900 6902001 CLAUDE SCHOOLS   Regular School No Other PK 12 2020   grade_11                                                   25                                             25
1620541 1620541 TX ATASCOSA COUNTY   school 4813710 7901   CHARLOTTE ISD 481371000863 7901001 CHARLOTTE H S   Regular School No High 09 12 2020   grade_11                                                   31                                             31
1638599 1638599 TX ATASCOSA COUNTY   school 4824960 7902   JOURDANTON ISD 482496007778 7902005 ATASCOSA COUNTY JUVENILE JUSTICE C   Alternative School No Secondary 07 11 2020   grade_11                                                   <10                                             10
1638613 1638613 TX ATASCOSA COUNTY   school 4824960 7902   JOURDANTON ISD 482496002785 7902001 JOURDANTON H S   Regular School No High 09 12 2020   grade_11                                                   105                                             105
1644086 1644086 TX ATASCOSA COUNTY   school 4828650 7904   LYTLE ISD 482865003246 7904001 LYTLE H S   Regular School No High 09 12 2020   grade_11                                                   101                                             101
1651249 1651249 TX ATASCOSA COUNTY   school 4835190 7905   PLEASANTON ISD 483519003984 7905001 PLEASANTON H S   Regular School No High 09 12 2020   grade_11                                                   241                                             241
1651491 1651491 TX ATASCOSA COUNTY   school 4835520 7906   POTEET ISD 483552004029 7906001 POTEET H S   Regular School No High 09 12 2020   grade_11                                                   106                                             106
1617292 1617292 TX AUSTIN COUNTY   school 4809810 8901   BELLVILLE ISD 480981000449 8901001 BELLVILLE H S   Regular School No High 09 12 2020   grade_11                                                   180                                             180
1618202 1618202 TX AUSTIN COUNTY   school 4844470 8903   BRAZOS ISD 484447005075 8903001 BRAZOS H S   Regular School No High 09 12 2020   grade_11                                                   47                                             47
1618212 1618212 TX AUSTIN COUNTY   school 4844470 8903   BRAZOS ISD 484447013001 8903103 PRAIRIE HARBOR ALTERNATIVE SCHOOL   Alternative School No High 06 12 2020   grade_11                                                   <10                                             10
1655616 1655616 TX AUSTIN COUNTY   school 4839630 8902   SEALY ISD 483963004502 8902001 SEALY H S   Regular School No High 09 12 2020   grade_11                                                   211                                             211
1646861 1646861 TX BAILEY COUNTY   school 4831890 9901   MULESHOE ISD 483189003547 9901001 MULESHOE H S   Regular School No High 09 12 2020   grade_11                                                   78                                             78
1616873 1616873 TX BANDERA COUNTY   school 4809360 10902   BANDERA ISD 480936000395 10902001 BANDERA H S   Regular School No High 09 12 2020   grade_11                                                   132                                             132
1645333 1645333 TX BANDERA COUNTY   school 4830030 10901   MEDINA ISD 483003003372 10901001 MEDINA SCHOOL   Regular School No Other PK 12 2020   grade_11                                                   23                                             23
1616979 1616979 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957000409 11901001 BASTROP H S   Regular School No High 09 12 2020   grade_11                                                   355                                             355
1617001 1617001 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957012272 11901002 CEDAR CREEK H S   Regular School No High 09 12 2020   grade_11                                                   403                                             403
1617009 1617009 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957013111 11901005 COLORADO RIVER COLLEGIATE ACADEMY   Regular School No High 09 12 2020   grade_11                                                   48                                             48
1617020 1617020 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957021082 11901022 GENESIS H S   Alternative School No High 09 12 2020   grade_11                                                   46                                             46
1628341 1628341 TX BASTROP COUNTY   school 4818360 11902   ELGIN ISD 481836001728 11902001 ELGIN H S   Regular School No High 09 12 2020   grade_11                                                   292                                             292
1628354 1628354 TX BASTROP COUNTY   school 4818360 11902   ELGIN ISD 481836008426 11902004 PHOENIX H S   Alternative School No High 09 12 2020   grade_11                                                   16                                             16
1645065 1645065 TX BASTROP COUNTY   school 4829760 11905   MCDADE ISD 482976013256 11905001 MCDADE H S   Regular School No High 07 12 2020   grade_11                                                   13                                             13
1656219 1656219 TX BASTROP COUNTY   school 4840550 11904   SMITHVILLE ISD 484055004590 11904002 SMITHVILLE H S   Regular School No High 09 12 2020   grade_11                                                   138                                             138
1655755 1655755 TX BAYLOR COUNTY   school 4839780 12901   SEYMOUR ISD 483978004520 12901001 SEYMOUR H S   Regular School No High 09 12 2020   grade_11                                                   40                                             40
1617237 1617237 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972000442 13901001 A C JONES H S   Regular School No High 09 12 2020   grade_11                                                   233                                             233
1617241 1617241 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972013804 13901004 A C JONES HEALTH PROFESSIONS MAGNE   Regular School No Secondary 09 11 2020   grade_11                                                   14                                             14
1650240 1650240 TX BEE COUNTY   school 4834770 13903   PETTUS ISD 483477003899 13903001 PETTUS SECONDARY   Regular School No High 06 12 2020   grade_11                                                   26                                             26
1656157 1656157 TX BEE COUNTY   school 4840410 13905   SKIDMORE-TYNAN ISD 484041004576 13905001 SKIDMORE-TYNAN H S   Regular School No High 09 12 2020   grade_11                                                   65                                             65
1613355 1613355 TX BELL COUNTY   school 4807470 14901   ACADEMY ISD 480747000040 14901001 ACADEMY H S   Regular School No High 09 12 2020   grade_11                                                   114                                             114
1616956 1616956 TX BELL COUNTY   school 4809540 14902   BARTLETT ISD 480954000406 14902001 BARTLETT SCHOOLS   Regular School No Other PK 12 2020   grade_11                                                   22                                             22
1617313 1617313 TX BELL COUNTY   school 4809860 14903   BELTON ISD 480986008100 14903006 BELL CO J J A E P   Alternative School No Secondary 09 11 2020   grade_11                                                   <10                                             10
1617318 1617318 TX BELL COUNTY   school 4809860 14903   BELTON ISD 480986000454 14903001 BELTON H S   Regular School No High 09 12 2020   grade_11                                                   731                                             731
1617322 1617322 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_11                                                   125                                             125
1634653 1634653 TX BELL COUNTY   school 4823370 14905   HOLLAND ISD 482337002373 14905001 HOLLAND H S   Regular School No High 09 12 2020   grade_11                                                   52                                             52
1639821 1639821 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002861 14906022 ADVENTHEALTH SCHOOL   Alternative School No Other 01 12 2020   grade_11                                                   <10                                             10
1639851 1639851 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002866 14906002 C E ELLISON H S   Regular School No High 09 12 2020   grade_11                                                   584                                             584
1639903 1639903 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566006281 14906004 GATEWAY H S   Alternative School No High 09 12 2020   grade_11                                                   <20                                             20
1639917 1639917 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566008695 14906007 HARKER HEIGHTS H S   Regular School No High 09 12 2020   grade_11                                                   588                                             588
1639951 1639951 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002871 14906001 KILLEEN H S   Regular School No High 09 12 2020   grade_11                                                   491                                             491
1639955 1639955 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566013234 14906013 KILLEEN ISD EARLY COLLEGE H S   Regular School No High 09 12 2020   grade_11                                                   297                                             297
1640026 1640026 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566021001 14906006 PATHWAYS ACADEMIC CAMPUS   Alternative School No High 09 12 2020   grade_11                                                   96                                             96
1640062 1640062 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566008696 14906008 ROBERT M SHOEMAKER H S   Regular School No High 09 12 2020   grade_11                                                   459                                             459
1649356 1649356 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023512294 14804006 GATEWAY COLLEGE PREPARATORY SCHOOL   Regular School Yes Other KG 12 2020   grade_11                                                   77                                             77
1649360 1649360 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023512289 14804005 GATEWAY TECH H S   Alternative School Yes High 09 12 2020   grade_11                                                   21                                             21
1649381 1649381 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023511986 14804002 NEW HORIZONS   Alternative School Yes Other 02 12 2020   grade_11                                                   <10                                             10
1651838 1651838 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007612994 14803004 CEDAR PARK CHARTER ACADEMY   Regular School Yes Other PK 12 2020   grade_11                                                   <10                                             10
1651851 1651851 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007613035 14803003 COVE CHARTER ACADEMY   Regular School Yes Other PK 12 2020   grade_11                                                   <20                                             20
1651875 1651875 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007608098 14803101 TEMPLE CHARTER ACADEMY   Alternative School Yes Other PK 12 2020   grade_11                                                   <10                                             10
1652416 1652416 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_11                                                   47                                             47
1652420 1652420 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_11                                                   58                                             58
1652424 1652424 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_11                                                   62                                             62
1652428 1652428 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_11                                                   49                                             49
1652432 1652432 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_11                                                   42                                             42
1652436 1652436 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_11                                                   40                                             40
1652440 1652440 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_11                                                   92                                             92
1652444 1652444 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_11                                                   49                                             49
1652448 1652448 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_11                                                   47                                             47
1653330 1653330 TX BELL COUNTY   school 4837710 14907   ROGERS ISD 483771004225 14907001 ROGERS H S   Regular School No High 09 12 2020   grade_11                                                   67                                             67
1653986 1653986 TX BELL COUNTY   school 4838580 14908   SALADO ISD 483858004288 14908001 SALADO H S   Regular School No High 09 12 2020   grade_11                                                   170                                             170
1658096 1658096 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233012581 14909008 FRED W EDWARDS ACADEMY AEC   Alternative School No High 09 12 2020   grade_11                                                   36                                             36
1658140 1658140 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233004827 14909002 TEMPLE H S   Regular School No High 09 12 2020   grade_11                                                   500                                             500
1658164 1658164 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233008430 14909005 WHEATLEY ALTERNATIVE EDUCATION CEN   Alternative School No High 06 12 2020   grade_11                                                   12                                             12
1659421 1659421 TX BELL COUNTY   school 4843260 14910   TROY ISD 484326004913 14910001 TROY H S   Regular School No High 09 12 2020   grade_11                                                   109                                             109
1613434 1613434 TX BEXAR COUNTY   school 4807590 15901   ALAMO HEIGHTS ISD 480759000045 15901001 ALAMO HEIGHTS H S   Regular School No High 09 12 2020   grade_11                                                   421                                             421
1616975 1616975 TX BEXAR COUNTY   school 4801438 15834   BASIS TEXAS 480143813036 15834001 BASIS SAN ANTONIO- SHAVANO CAMPUS   Regular School Yes High 06 12 2020   grade_11                                                   85                                             85
1618542 1618542 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_11                                                   100                                             100
1618556 1618556 TX BEXAR COUNTY   school 4800268 15830   BROOKS ACADEMIES OF TEXAS 480026813064 15830101 BROOKS COLLEGIATE ACADEMY   Regular School Yes Other PK 12 2020   grade_11                                                   49                                             49
1626915 1626915 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785007517 15911005 BEXAR COUNTY LRN CTR   Alternative School No Secondary 08 11 2020   grade_11                                                   <10                                             10
1626921 1626921 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785008449 15911003 EAST CENTRAL CHOICE PROGAM   Alternative School No High 05 12 2020   grade_11                                                   <10                                             10
1626925 1626925 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785001554 15911001 EAST CENTRAL H S   Regular School No High 09 12 2020   grade_11                                                   719                                             719
1627379 1627379 TX BEXAR COUNTY   school 4818150 15905   EDGEWOOD ISD 481815001624 15905002 JOHN F KENNEDY H S   Regular School No High 09 12 2020   grade_11                                                   207                                             207
1627404 1627404 TX BEXAR COUNTY   school 4818150 15905   EDGEWOOD ISD 481815001628 15905003 MEMORIAL H S   Regular School No High 09 12 2020   grade_11                                                   281                                             281
1630948 1630948 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_11                                                   94                                             94
1631704 1631704 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001407174 15802001 GEORGE GERVIN ACADEMY   Alternative School Yes Other PK 12 2020   grade_11                                                   11                                             11
1631711 1631711 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001410415 15802004 RUTH JONES MCCLENDON MIDDLE   Alternative School Yes High 06 12 2020   grade_11                                                   <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]);