Data source: Big Local News · About: Big Local

4,098 rows where grade = "grade_12" and state = "TX" sorted by rowid descending

View and edit SQL

year

grade

  • grade_12 · 3,998
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
1661214 TX TYLER COUNTY   school 4844580 229904   WARREN ISD 484458005084 229904001 WARREN H S   Regular School No High 09 12 2020   grade_12                                                   72                                             72
1661194 TX BOSQUE COUNTY   school 4844520 18905   WALNUT SPRINGS ISD 484452012079 18905003 WALNUT SPRINGS SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   10                                             10
1661167 TX WALLER COUNTY   school 4844430 237904   WALLER ISD 484443005073 237904002 WALLER H S   Regular School No Other PK 12 2020   grade_12                                                   <460                                             460
1661116 TX TOM GREEN COUNTY   school 4844410 226906   WALL ISD 484441005069 226906001 WALL H S   Regular School No High 09 12 2020   grade_12                                                   82                                             82
1661102 TX TOM GREEN COUNTY   school 4844410 226906   WALL ISD 484441017083 226906002 FAIRVIEW ACCELERATED   Alternative School No High 10 12 2020   grade_12                                                   <10                                             10
1661091 TX GONZALES COUNTY   school 4844310 89905   WAELDER ISD 484431005063 89905102 WAELDER SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   15                                             15
1661070 TX MCLENNAN COUNTY   school 4844280 161914   WACO ISD 484428005054 161914002 WACO H S   Regular School No High 09 12 2020   grade_12                                                   390                                             390
1661066 TX MCLENNAN COUNTY   school 4844280 161914   WACO ISD 484428005059 161914003 UNIVERSITY H S   Regular School No High 09 12 2020   grade_12                                                   394                                             394
1660989 TX MCLENNAN COUNTY   school 4844280 161914   WACO ISD 484428007039 161914005 G L WILEY OPPORTUNITY CENTER   Alternative School No Other 04 12 2020   grade_12                                                   <10                                             10
1660965 TX MCLENNAN COUNTY   school 4844280 161914   WACO ISD 484428007397 161914004 CHALLENGE ACADEMY   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1660941 TX MCLENNAN COUNTY   school 4844280 161914   WACO ISD 484428009344 161914007 BRAZOS H S   Alternative School No High 09 12 2020   grade_12                                                   49                                             49
1660893 TX DALLAS COUNTY   school 4801436 57847   VILLAGE TECH SCHOOLS 480143613030 57847001 VILLAGE TECH SCHOOLS   Regular School Yes Other PK 12 2020   grade_12                                                   35                                             35
1660875 TX ORANGE COUNTY   school 4844160 181907   VIDOR ISD 484416005025 181907001 VIDOR H S   Regular School No High 09 12 2020   grade_12                                                   265                                             265
1660850 TX ORANGE COUNTY   school 4844160 181907   VIDOR ISD 484416007054 181907002 AIM CENTER H S   Alternative School No High 10 12 2020   grade_12                                                   25                                             25
1660847 TX VICTORIA COUNTY   school 4844150 235902   VICTORIA ISD 484415012281 235902014 VICTORIA WEST H S   Regular School No High 09 12 2020   grade_12                                                   359                                             359
1660839 TX VICTORIA COUNTY   school 4844150 235902   VICTORIA ISD 484415012267 235902013 VICTORIA EAST H S   Regular School No High 09 12 2020   grade_12                                                   406                                             406
1660767 TX VICTORIA COUNTY   school 4844150 235902   VICTORIA ISD 484415007745 235902004 LIBERTY DAEP   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1660760 TX VICTORIA COUNTY   school 4844150 235902   VICTORIA ISD 484415005579 235902006 LIBERTY CREDIT RECOVERY   Alternative School No High 09 12 2020   grade_12                                                   49                                             49
1660699 TX WILBARGER COUNTY   school 4844110 244903   VERNON ISD 484411004998 244903001 VERNON H S   Regular School No High 09 12 2020   grade_12                                                   131                                             131
1660687 TX WILBARGER COUNTY   school 4844110 244903   VERNON ISD 484411006493 244903002 NORTH TEXAS STATE HOSPITAL - AFP -   Alternative School No High 08 12 2020   grade_12                                                   <10                                             10
1660682 TX TOM GREEN COUNTY   school 4844040 226908   VERIBEST ISD 484404007463 226908001 VERIBEST H S   Regular School No High 07 12 2020   grade_12                                                   20                                             20
1660667 TX TOM GREEN COUNTY   school 4844040 226908   VERIBEST ISD 484404011051 226908005 VERIBEST DAEP   Alternative School No High 12 12 2020   grade_12                                                   <10                                             10
1660659 TX JOHNSON COUNTY   school 4844010 126908   VENUS ISD 484401004993 126908001 VENUS H S   Regular School No High 09 12 2020   grade_12                                                   111                                             111
1660646 TX OLDHAM COUNTY   school 4843980 180902   VEGA ISD 484398004991 180902001 VEGA H S   Regular School No High 09 12 2020   grade_12                                                   42                                             42
1660636 TX HIDALGO COUNTY   school 4800195 108808   VANGUARD ACADEMY 480019508649 108808101 VANGUARD REMBRANDT   Regular School Yes Other PK 12 2020   grade_12                                                   106                                             106
1660615 TX HIDALGO COUNTY   school 4800195 108808   VANGUARD ACADEMY 480019513037 108808104 VANGUARD MOZART   Regular School Yes Other PK 12 2020   grade_12                                                   15                                             15
1660590 TX MATAGORDA COUNTY   school 4843950 158906   VAN VLECK ISD 484395004988 158906002 VAN VLECK H S   Regular School No High 09 12 2020   grade_12                                                   76                                             76
1660568 TX VAN ZANDT COUNTY   school 4843920 234906   VAN ISD 484392004985 234906001 VAN H S   Regular School No High 09 12 2020   grade_12                                                   180                                             180
1660557 TX GRAYSON COUNTY   school 4843890 91908   VAN ALSTYNE ISD 484389004982 91908001 VAN ALSTYNE H S   Regular School No High 09 12 2020   grade_12                                                   123                                             123
1660504 TX HIDALGO COUNTY   school 4843800 108916   VALLEY VIEW ISD 484380021360 108916001 VALLEY VIEW H S   Regular School No High 09 12 2020   grade_12                                                   353                                             353
1660503 TX COOKE COUNTY   school 4843860 49903   VALLEY VIEW ISD 484386004980 49903001 VALLEY VIEW H S   Regular School No High 09 12 2020   grade_12                                                   54                                             54
1660477 TX BOSQUE COUNTY   school 4843760 18904   VALLEY MILLS ISD 484376004977 18904001 VALLEY MILLS H S   Regular School No High 09 12 2020   grade_12                                                   72                                             72
1660452 TX UVALDE COUNTY   school 4843720 232903   UVALDE CISD 484372004971 232903001 UVALDE H S   Regular School No High 09 12 2020   grade_12                                                   228                                             228
1660438 TX UVALDE COUNTY   school 4843720 232903   UVALDE CISD 484372014019 232903003 CROSSROADS ACADEMY   Alternative School No High 09 12 2020   grade_12                                                   23                                             23
1660411 TX UVALDE COUNTY   school 4843680 232904   UTOPIA ISD 484368004965 232904001 UTOPIA SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   23                                             23
1660397 TX SMITH COUNTY   school 4801427 212804   UT TYLER UNIVERSITY ACADEMY 480142712768 212804001 UT TYLER UNIVERSITY ACADEMY AT TYL   Regular School Yes Other KG 12 2020   grade_12                                                   19                                             19
1660384 TX SMITH COUNTY   school 4801427 212804   UT TYLER UNIVERSITY ACADEMY 480142712863 212804103 UT TYLER UNIVERSITY ACADEMY AT PAL   Regular School Yes Other KG 12 2020   grade_12                                                   11                                             11
1660371 TX SMITH COUNTY   school 4801427 212804   UT TYLER UNIVERSITY ACADEMY 480142712830 212804102 UT TYLER UNIVERSITY ACADEMY AT LON   Regular School Yes Other 01 12 2020   grade_12                                                   25                                             25
1660342 TX DALLAS COUNTY   school 4800030 57803   UPLIFT EDUCATION 480003012012 57803004 UPLIFT WILLIAMS PREPARATORY H S   Regular School Yes High 09 12 2020   grade_12                                                   110                                             110
1660316 TX DALLAS COUNTY   school 4800030 57803   UPLIFT EDUCATION 480003012175 57803009 UPLIFT SUMMIT INTERNATIONAL H S   Regular School Yes High 09 12 2020   grade_12                                                   67                                             67
1660296 TX DALLAS COUNTY   school 4800030 57803   UPLIFT EDUCATION 480003012139 57803010 UPLIFT PEAK PREPARATORY H S   Regular School Yes High 09 12 2020   grade_12                                                   84                                             84
1660282 TX DALLAS COUNTY   school 4800030 57803   UPLIFT EDUCATION 480003013482 57803014 UPLIFT MIGHTY H S   Regular School Yes High 09 12 2020   grade_12                                                   59                                             59
1660261 TX DALLAS COUNTY   school 4800030 57803   UPLIFT EDUCATION 480003013197 57803005 UPLIFT LUNA PREPARATORY H S   Regular School Yes High 09 12 2020   grade_12                                                   89                                             89
1660257 TX DALLAS COUNTY   school 4800030 57803   UPLIFT EDUCATION 480003013481 57803013 UPLIFT INFINITY H S   Regular School Yes High 09 12 2020   grade_12                                                   70                                             70
1660243 TX DALLAS COUNTY   school 4800030 57803   UPLIFT EDUCATION 480003013058 57803006 UPLIFT HEIGHTS PREPARATORY H S   Regular School Yes High 09 12 2020   grade_12                                                   131                                             131
1660230 TX DALLAS COUNTY   school 4800030 57803   UPLIFT EDUCATION 480003012200 57803007 UPLIFT HAMPTON PREPARATORY H S   Regular School Yes High 09 12 2020   grade_12                                                   66                                             66
1660223 TX DALLAS COUNTY   school 4800030 57803   UPLIFT EDUCATION 480003013588 57803016 UPLIFT GRAND H S   Regular School Yes High 09 12 2020   grade_12                                                   39                                             39
1660207 TX DALLAS COUNTY   school 4800030 57803   UPLIFT EDUCATION 480003012221 57803002 UPLIFT EDUCATION-NORTH HILLS PREP   Regular School Yes High 09 12 2020   grade_12                                                   128                                             128
1660170 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007112956 227806034 UT - UNIVERSITY CHARTER SCHOOL AT   Alternative School Yes Other 01 12 2020   grade_12                                                   <10                                             10
1660156 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113292 227806043 UNIVERSITY H S   Alternative School Yes High 09 12 2020   grade_12                                                   <10                                             10
1660143 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113838 227806051 THE REFUGE   Alternative School Yes High 09 12 2020   grade_12                                                   <10                                             10
1660140 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113821 227806052 SJRC TEXAS   Alternative School Yes High 07 12 2020   grade_12                                                   <10                                             10
1660131 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007108383 227806005 SETTLEMENT HOME   Alternative School Yes High 06 12 2020   grade_12                                                   <10                                             10
1660125 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113487 227806046 SETON HOME   Alternative School Yes High 07 12 2020   grade_12                                                   <10                                             10
1660094 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007109513 227806025 METHODIST CHILDREN'S HOME   Alternative School Yes High 06 12 2020   grade_12                                                   16                                             16
1660087 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007111352 227806030 LAUREL RIDGE   Alternative School Yes Other 03 12 2020   grade_12                                                   <10                                             10
1660059 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113999 227806054 CLEARFORK ACADEMY   Regular School Yes High 09 12 2020   grade_12                                                   <10                                             10
1660050 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113287 227806040 AUSTIN OAKS   Alternative School Yes Other 04 12 2020   grade_12                                                   <10                                             10
1660041 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007109074 227806017 ANNUNCIATION MATERNITY HOME   Alternative School Yes High 09 12 2020   grade_12                                                   <10                                             10
1660030 TX TRAVIS COUNTY   school 4801473 227506   UNIVERSITY OF TEXAS AT AUSTIN H S 480147313991 227506001 UNIVERSITY OF TEXAS AT AUSTIN H S   Regular School No High 09 12 2020   grade_12                                                   97                                             97
1660020 TX DALLAS COUNTY   school 4800070 57808   UNIVERSAL ACADEMY 480007008503 57808102 UNIVERSAL ACADEMY - COPPELL   Regular School Yes Other KG 12 2020   grade_12                                                   <10                                             10
1660007 TX DALLAS COUNTY   school 4800070 57808   UNIVERSAL ACADEMY 480007007850 57808101 UNIVERSAL ACADEMY   Regular School Yes Other PK 12 2020   grade_12                                                   20                                             20
1659978 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365008405 240903004 UNITED STEP ACADEMY   Alternative School No High 06 12 2020   grade_12                                                   16                                             16
1659968 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365006922 240903002 UNITED SOUTH H S   Regular School No High 09 12 2020   grade_12                                                   784                                             784
1659961 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365004962 240903001 UNITED H S   Regular School No High 09 12 2020   grade_12                                                   1148                                             1148
1659860 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365009091 240903009 LYNDON B JOHNSON   Regular School No High 09 12 2020   grade_12                                                   754                                             754
1659834 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365007476 240903006 JUVENILLE JUSTICE ALTERNATIVE PROG   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1659796 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365007094 240903003 JOHN B ALEXANDER H S   Regular School No High 09 12 2020   grade_12                                                   701                                             701
1659694 TX UPSHUR COUNTY   school 4843560 230904   UNION HILL ISD 484356004955 230904001 UNION HILL H S   Regular School No High 06 12 2020   grade_12                                                   17                                             17
1659678 TX UPSHUR COUNTY   school 4843530 230908   UNION GROVE ISD 484353004953 230908001 UNION GROVE H S   Regular School No High 09 12 2020   grade_12                                                   44                                             44
1659659 TX DALLAS COUNTY   school 4801425 57845   UME PREPARATORY ACADEMY 480142512685 57845001 UME PREPARATORY ACADEMY   Regular School Yes Other KG 12 2020   grade_12                                                   56                                             56
1659638 TX SMITH COUNTY   school 4843470 212905   TYLER ISD 484347013613 212905006 TYLER ISD EARLY COLLEGE H S   Regular School No High 09 12 2020   grade_12                                                   71                                             71
1659623 TX SMITH COUNTY   school 4843470 212905   TYLER ISD 484347004941 212905001 ROBERT E LEE H S   Regular School No High 09 12 2020   grade_12                                                   500                                             500
1659570 TX SMITH COUNTY   school 4843470 212905   TYLER ISD 484347004939 212905003 JOHN TYLER H S   Regular School No High 09 12 2020   grade_12                                                   440                                             440
1659491 TX SMITH COUNTY   school 4843470 212905   TYLER ISD 484347013616 212905010 ALVIN V ANDERSON RISE ACADEMY   Alternative School No High 09 12 2020   grade_12                                                   39                                             39
1659471 TX HALL COUNTY   school 4843400 96905   TURKEY-QUITAQUE ISD 484340004926 96905001 VALLEY SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   15                                             15
1659446 TX NUECES COUNTY   school 4843350 178912   TULOSO-MIDWAY ISD 484335004923 178912001 TULOSO-MIDWAY H S   Regular School No High 09 12 2020   grade_12                                                   272                                             272
1659442 TX NUECES COUNTY   school 4843350 178912   TULOSO-MIDWAY ISD 484335005136 178912002 TULOSO-MIDWAY ACADEMIC CAREER CENT   Alternative School No High 09 12 2020   grade_12                                                   13                                             13
1659434 TX SWISHER COUNTY   school 4843320 219903   TULIA ISD 484332004918 219903001 TULIA H S   Regular School No High 09 12 2020   grade_12                                                   66                                             66
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
1659404 TX SMITH COUNTY   school 4843230 212904   TROUP ISD 484323004910 212904002 TROUP H S   Regular School No High 09 12 2020   grade_12                                                   71                                             71
1659382 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013308280 108804001 TRIUMPH PUBLIC HISH SCHOOLS-MERCED   Alternative School Yes High 09 12 2020   grade_12                                                   39                                             39
1659378 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013311872 108804003 TRIUMPH PUBLIC HIGH SCHOOLS-SAN BE   Alternative School Yes High 09 12 2020   grade_12                                                   67                                             67
1659374 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013309294 108804002 TRIUMPH PUBLIC HIGH SCHOOLS-MCALLE   Alternative School Yes High 09 12 2020   grade_12                                                   54                                             54
1659370 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013313801 108804004 TRIUMPH PUBLIC HIGH SCHOOLS-BROWNS   Alternative School Yes High 09 12 2020   grade_12                                                   27                                             27
1659366 TX LUBBOCK COUNTY   school 4800142 152803   TRIUMPH PUBLIC HIGH SCHOOLS-LUBBOC 480014208326 152803001 TRIUMPH PUBLIC HIGH SCHOOLS-LUBBOC   Alternative School Yes High 09 12 2020   grade_12                                                   47                                             47
1659362 TX WEBB COUNTY   school 4800174 240801   TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO 480017412212 240801002 TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO   Alternative School Yes High 09 12 2020   grade_12                                                   55                                             55
1659361 TX WEBB COUNTY   school 4800174 240801   TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO 480017408403 240801001 TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO   Alternative School Yes High 09 12 2020   grade_12                                                   73                                             73
1659354 TX EL PASO COUNTY   school 4800106 71803   TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS 480010611212 71803002 TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS   Alternative School Yes High 09 12 2020   grade_12                                                   31                                             31
1659353 TX EL PASO COUNTY   school 4800106 71803   TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS 480010608207 71803001 TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS   Alternative School Yes High 09 12 2020   grade_12                                                   27                                             27
1659343 TX TRINITY COUNTY   school 4843200 228903   TRINITY ISD 484320004907 228903001 TRINITY H S   Regular School No High 09 12 2020   grade_12                                                   80                                             80
1659332 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913891 46802016 TRINITY CHARTER SCHOOLS - FORT WOR   Regular School Yes High 08 12 2020   grade_12                                                   <10                                             10
1659323 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913767 46802014 TRINITY CHARTER SCHOOL - BRENHAM C   Alternative School Yes High 08 12 2020   grade_12                                                   <10                                             10
1659318 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025910529 46802001 TRINITY CHARTER SCHOOL   Alternative School Yes High 05 12 2020   grade_12                                                   <10                                             10
1659303 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025912947 46802007 PEGASUS SCHOOL   Alternative School Yes Other 04 12 2020   grade_12                                                   13                                             13
1659294 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913143 46802008 CARSON PARKE   Alternative School Yes High 06 12 2020   grade_12                                                   <10                                             10
1659288 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913198 46802011 AZLEWAY - WILLOW BEND   Alternative School Yes Other 02 12 2020   grade_12                                                   <10                                             10
1659254 TX HENDERSON COUNTY   school 4843170 107907   TRINIDAD ISD 484317004904 107907001 TRINIDAD SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   12                                             12
1659236 TX FANNIN COUNTY   school 4843140 74912   TRENTON ISD 484314004902 74912001 TRENTON H S   Regular School No High 09 12 2020   grade_12                                                   35                                             35
1659225 TX TAYLOR COUNTY   school 4843110 221905   TRENT ISD 484311004900 221905001 TRENT INDEPENDENT SCHOOL DISTRICT   Regular School No Other PK 12 2020   grade_12                                                   <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]);