Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_12 · 3,898
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
1404839 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850003208 152901007 PRIORITY INTERVENTION ACADEMY   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1404979 TX LUBBOCK COUNTY   school 4815180 152906   LUBBOCK-COOPER ISD 481518013526 152906003 LUBBOCK-COOPER NEW HOPE ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   54                                             54
1405065 TX ANGELINA COUNTY   school 4828550 3903   LUFKIN ISD 482855007163 3903004 STUBBLEFIELD LRN CTR   Alternative School No High 09 12 2021   grade_12                                                   17                                             17
1405122 TX ATASCOSA COUNTY   school 4828650 7904   LYTLE ISD 482865008422 7904002 LYTLE DAEP   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1405184 TX MONTGOMERY COUNTY   school 4828740 170906   MAGNOLIA ISD 482874008996 170906012 ALPHA   Alternative School No High 09 12 2021   grade_12                                                   31                                             31
1405358 TX TRAVIS COUNTY   school 4828890 227907   MANOR ISD 482889007141 227907002 MANOR EXCEL ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   60                                             60
1405588 TX TARRANT COUNTY   school 4828920 220908   MANSFIELD ISD 482892005407 220908006 THE PHOENIX ACADEMY   Alternative School No High 10 12 2021   grade_12                                                   55                                             55
1405626 TX BURNET COUNTY   school 4829010 27904   MARBLE FALLS ISD 482901010469 27904002 FALLS CAREER H S   Alternative School No High 09 12 2021   grade_12                                                   22                                             22
1405982 TX HIDALGO COUNTY   school 4829670 108906   MCALLEN ISD 482967021346 108906007 LAMAR ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   21                                             21
1406251 TX COLLIN COUNTY   school 4829850 43907   MCKINNEY ISD 482985008149 43907005 SERENITY HIGH   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1406345 TX KENDALL COUNTY   school 4801404 130801   MEADOWLAND CHARTER DISTRICT 480140413750 130801003 STEPPING STONES ACADEMY   Alternative School Yes Other 04 12 2021   grade_12                                                   <10                                             10
1406465 TX HIDALGO COUNTY   school 4830250 108907   MERCEDES ISD 483025006996 108907002 MERCEDES ACADEMIC ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   23                                             23
1406469 TX HIDALGO COUNTY   school 4830250 108907   MERCEDES ISD 483025012441 108907006 MERCEDES EARLY COLLEGE ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   95                                             95
1406730 TX DALLAS COUNTY   school 4830390 57914   MESQUITE ISD 483039007578 57914007 PASS LEARNING CTR   Alternative School No High 10 12 2021   grade_12                                                   <10                                             10
1406856 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042007028 147903101 DEVELOPMENTAL CTR   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1407160 TX MIDLAND COUNTY   school 4830570 165901   MIDLAND ISD 483057006756 165901004 VIOLA M COLEMAN H S   Alternative School No High 09 12 2021   grade_12                                                   29                                             29
1407414 TX PALO PINTO COUNTY   school 4830950 182903   MINERAL WELLS ISD 483095008348 182903002 MINERAL WELLS ACADEMY   Alternative School No High 10 12 2021   grade_12                                                   12                                             12
1407563 TX WARD COUNTY   school 4831170 238902   MONAHANS-WICKETT-PYOTE ISD 483117007746 238902002 MONAHANS ED CTR   Alternative School No High 10 12 2021   grade_12                                                   <10                                             10
1407893 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192013019 167902002 MULLIN OAKS   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1407901 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192013340 167902055 PARKVIEW SCHOOL - LUBBOCK   Alternative School No High 12 12 2021   grade_12                                                   <10                                             10
1407905 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192013057 167902003 PECAN RIDGE H S   Alternative School No High 09 12 2021   grade_12                                                   13                                             13
1407970 TX NACOGDOCHES COUNTY   school 4832090 174904   NACOGDOCHES ISD 483209011314 174904005 MALCOLM RECTOR TECHNICAL H S   Alternative School No High 09 12 2021   grade_12                                                   33                                             33
1408060 TX GRIMES COUNTY   school 4832190 93904   NAVASOTA ISD 483219012965 93904005 W B BIZZELL ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1408216 TX COMAL COUNTY   school 4832370 46901   NEW BRAUNFELS ISD 483237007840 46901038 THE NBISD LEARNING CENTER   Alternative School No High 09 12 2021   grade_12                                                   <30                                             30
1408342 TX MONTGOMERY COUNTY   school 4832400 170908   NEW CANEY ISD 483240007079 170908002 THE LEARNING CTR   Alternative School No Other 02 12 2021   grade_12                                                   <10                                             10
1408358 TX LUBBOCK COUNTY   school 4832430 152902   NEW DEAL ISD 483243010944 152902003 NEW DEAL DAEP   Alternative School No High 10 12 2021   grade_12                                                   <10                                             10
1408544 TX GONZALES COUNTY   school 4832740 89903   NIXON-SMILEY CISD 483274010685 89903004 NIXON-SMILEY PACE   Alternative School No High 11 12 2021   grade_12                                                   <10                                             10
1408590 TX BEXAR COUNTY   school 4832940 15910   NORTH EAST ISD 483294021107 15910008 ACADEMY OF CREATIVE ED   Alternative School No High 11 12 2021   grade_12                                                   80                                             80
1408594 TX BEXAR COUNTY   school 4832940 15910   NORTH EAST ISD 483294006035 15910012 ALTER H S   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1408747 TX BEXAR COUNTY   school 4832940 15910   NORTH EAST ISD 483294015799 15910054 HOMEBASED COMP ED   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1408829 TX BEXAR COUNTY   school 4832940 15910   NORTH EAST ISD 483294007181 15910022 NORTH EAST J J A E P   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1409127 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312006149 15915008 ALTERNATIVE H S   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1409245 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312021113 15915011 CHAVEZ EXCEL ACADEMY   Alternative School No High 12 12 2021   grade_12                                                   70                                             70
1409452 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312003715 15915004 HOLMGREEN CENTER   Alternative School No Other PK 12 2021   grade_12                                                   <10                                             10
1409685 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312007184 15915039 NISD BEXAR COUNTY JJA   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1409768 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312002944 15915013 REDDIX CENTER   Alternative School No Other PK 12 2021   grade_12                                                   258                                             258
1410344 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023512289 14804005 GATEWAY TECH H S   Alternative School Yes High 09 12 2021   grade_12                                                   <10                                             10
1410544 TX PANOLA COUNTY   school 4800213 183801   PANOLA CHARTER SCHOOL 480021308891 183801001 PANOLA CS   Alternative School Yes High 08 12 2021   grade_12                                                   <10                                             10
1410609 TX LAMAR COUNTY   school 4834290 139909   PARIS ISD 483429013196 139909008 TRAVIS H S OF CHOICE   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1410895 TX HARRIS COUNTY   school 4834320 101917   PASADENA ISD 483432017033 101917007 TEGELER CAREER CENTER   Alternative School No High 07 12 2021   grade_12                                                   <50                                             50
1410899 TX HARRIS COUNTY   school 4834320 101917   PASADENA ISD 483432010775 101917014 THE SUMMIT (HIGH SCHOOL)   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1411066 TX FRIO COUNTY   school 4834470 82903   PEARSALL ISD 483447009244 82903003 ATASCOSA JUVENILE DETENTION CTR   Alternative School No High 10 12 2021   grade_12                                                   <10                                             10
1411124 TX DALLAS COUNTY   school 4800029 57802   PEGASUS SCHOOL OF LIBERAL ARTS AND 480002907561 57802001 PEGASUS CHARTER H S   Alternative School Yes Other KG 12 2021   grade_12                                                   29                                             29
1411163 TX OCHILTREE COUNTY   school 4834650 179901   PERRYTON ISD 483465009006 179901002 LUDI PENA MARTIN ACCELERATED EDUCA   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1411493 TX HIDALGO COUNTY   school 4834860 108909   PHARR-SAN JUAN-ALAMO ISD 483486012654 108909011 BUELL CENTRAL DAEP   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1411544 TX HIDALGO COUNTY   school 4834860 108909   PHARR-SAN JUAN-ALAMO ISD 483486007041 108909006 ELVIS J BALLEW H S   Alternative School No High 09 12 2021   grade_12                                                   119                                             119
1411626 TX HIDALGO COUNTY   school 4834860 108909   PHARR-SAN JUAN-ALAMO ISD 483486021041 108909005 PSJA SONIA M SOTOMAYOR H S   Alternative School No High 09 12 2021   grade_12                                                   <40                                             40
1412218 TX ATASCOSA COUNTY   school 4835190 7905   PLEASANTON ISD 483519007506 7905004 ATASCOSA CO ALTER   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1412230 TX ATASCOSA COUNTY   school 4835190 7905   PLEASANTON ISD 483519011945 7905005 PLEASANTON ISD SCHOOL OF CHOICE   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1412309 TX BEXAR COUNTY   school 4800004 15801   POR VIDA ACADEMY 480000407173 15801001 POR VIDA ACADEMY CHARTER H S   Alternative School Yes High 09 12 2021   grade_12                                                   17                                             17
1412313 TX BEXAR COUNTY   school 4800004 15801   POR VIDA ACADEMY 480000409116 15801002 POR VIDA ACADEMY CORPUS CHRISTI   Alternative School Yes High 09 12 2021   grade_12                                                   22                                             22
1412430 TX BEXAR COUNTY   school 4800059 15814   POSITIVE SOLUTIONS CHARTER SCHOOL 480005907798 15814001 POSITIVE SOLUTIONS CHARTER   Alternative School Yes High 09 12 2021   grade_12                                                   13                                             13
1412435 TX GARZA COUNTY   school 4835490 85902   POST ISD 483549012914 85902040 GARZA COUNTY REGIONAL JUVENILE CEN   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1412555 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020713758 72801150 PREMIER H S - SAN ANGELO   Alternative School Yes High 09 12 2021   grade_12                                                   40                                             40
1412567 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020708378 72801101 PREMIER H S OF ABILENE   Alternative School Yes High 09 12 2021   grade_12                                                   39                                             39
1412571 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020712986 72801142 PREMIER H S OF AMARILLO   Alternative School Yes High 09 12 2021   grade_12                                                   42                                             42
1412575 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020712402 72801131 PREMIER H S OF ARLINGTON   Alternative School Yes High 09 12 2021   grade_12                                                   43                                             43
1412579 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020709350 72801113 PREMIER H S OF AUSTIN   Alternative School Yes High 09 12 2021   grade_12                                                   41                                             41
1412583 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020708136 72801103 PREMIER H S OF BROWNSVILLE   Alternative School Yes High 09 12 2021   grade_12                                                   49                                             49
1412589 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020708780 72801001 PREMIER H S OF COMANCHE/EARLY   Alternative School Yes High 07 12 2021   grade_12                                                   25                                             25
1412593 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020712902 72801138 PREMIER H S OF DAYTON   Alternative School Yes High 09 12 2021   grade_12                                                   28                                             28
1412597 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020708396 72801107 PREMIER H S OF DEL RIO   Alternative School Yes High 09 12 2021   grade_12                                                   11                                             11
1412601 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020713288 72801143 PREMIER H S OF EAST EL PASO   Alternative School Yes High 09 12 2021   grade_12                                                   25                                             25
1412605 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020712102 72801129 PREMIER H S OF EL PASO   Alternative School Yes High 09 12 2021   grade_12                                                   34                                             34
1412609 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020708366 72801108 PREMIER H S OF FORT WORTH   Alternative School Yes High 09 12 2021   grade_12                                                   34                                             34
1412613 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020712540 72801137 PREMIER H S OF GRANBURY   Alternative School Yes High 09 12 2021   grade_12                                                   41                                             41
1412617 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020712412 72801135 PREMIER H S OF HUNTSVILLE   Alternative School Yes High 09 12 2021   grade_12                                                   18                                             18
1412621 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020708404 72801109 PREMIER H S OF LAREDO   Alternative School Yes High 09 12 2021   grade_12                                                   16                                             16
1412625 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020708327 72801110 PREMIER H S OF LUBBOCK   Alternative School Yes High 09 12 2021   grade_12                                                   59                                             59
1412629 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020708337 72801112 PREMIER H S OF MIDLAND   Alternative School Yes High 09 12 2021   grade_12                                                   36                                             36
1412633 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020710815 72801116 PREMIER H S OF MISSION   Alternative School Yes High 09 12 2021   grade_12                                                   34                                             34
1412637 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020712268 72801136 PREMIER H S OF NEW BRAUNFELS   Alternative School Yes High 09 12 2021   grade_12                                                   24                                             24
1412641 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020712092 72801128 PREMIER H S OF NORTH AUSTIN   Alternative School Yes High 09 12 2021   grade_12                                                   17                                             17
1412645 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020713396 72801147 PREMIER H S OF NORTH HOUSTON   Alternative School Yes High 09 12 2021   grade_12                                                   10                                             10
1412649 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020711464 72801104 PREMIER H S OF PALMVIEW   Alternative School Yes High 09 12 2021   grade_12                                                   27                                             27
1412653 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020713281 72801144 PREMIER H S OF PFLUGERVILLE   Alternative School Yes High 09 12 2021   grade_12                                                   31                                             31
1412657 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020708282 72801115 PREMIER H S OF PHARR   Alternative School Yes High 09 12 2021   grade_12                                                   19                                             19
1412661 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020712127 72801130 PREMIER H S OF SAN JUAN   Alternative School Yes High 09 12 2021   grade_12                                                   42                                             42
1412665 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020712816 72801139 PREMIER H S OF SOUTH IRVING   Alternative School Yes High 09 12 2021   grade_12                                                   13                                             13
1412669 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020713402 72801148 PREMIER H S OF TEXARKANA   Alternative School Yes High 09 12 2021   grade_12                                                   21                                             21
1412673 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020708357 72801118 PREMIER H S OF TYLER   Alternative School Yes High 09 12 2021   grade_12                                                   32                                             32
1412677 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020708331 72801121 PREMIER H S OF WACO   Alternative School Yes High 09 12 2021   grade_12                                                   51                                             51
1412681 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020713294 72801145 PREMIER H S ONLINE   Alternative School Yes High 09 12 2021   grade_12                                                   320                                             320
1412685 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020713657 72801149 PREMIER H S SAN ANTONIO - WEST   Alternative School Yes High 09 12 2021   grade_12                                                   17                                             17
1412689 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020708110 72801117 PREMIER H S SAN ANTONIO EAST   Alternative School Yes High 09 12 2021   grade_12                                                   20                                             20
1412693 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020713282 72801146 PREMIER HIGH SCHOOLS CAREER & TECH   Alternative School Yes High 09 12 2021   grade_12                                                   30                                             30
1412842 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007608098 14803101 TEMPLE CHARTER ACADEMY   Alternative School Yes Other PK 12 2021   grade_12                                                   <10                                             10
1413110 TX CROSBY COUNTY   school 4836390 54903   RALLS ISD 483639006825 54903002 RECOVERY EDUCATION CAMPUS   Alternative School No High 11 12 2021   grade_12                                                   <10                                             10
1413125 TX VAN ZANDT COUNTY   school 4800171 234801   RANCH ACADEMY 480017108398 234801001 RANCH ACADEMY   Alternative School Yes High 06 12 2021   grade_12                                                   17                                             17
1413210 TX WALKER COUNTY   school 4800048 236801   RAVEN SCHOOL 480004808075 236801001 THOMAS BUZBEE VOCATIONAL SCHOOL   Alternative School Yes High 09 12 2021   grade_12                                                   <10                                             10
1413229 TX WILLACY COUNTY   school 4836540 245903   RAYMONDVILLE ISD 483654012552 245903004 RAYMONDVILLE OPTIONS ACADEMIC ACAD   Alternative School No High 08 12 2021   grade_12                                                   24                                             24
1413371 TX COLORADO COUNTY   school 4836970 45903   RICE CISD 483697013214 45903004 RICE CHALLENGE ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1413403 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007509009 14801008 RICHARD MILBURN ACADEMY AMARILLO   Alternative School Yes High 09 12 2021   grade_12                                                   34                                             34
1413407 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007508344 14801007 RICHARD MILBURN ACADEMY CORPUS CHR   Alternative School Yes High 09 12 2021   grade_12                                                   47                                             47
1413411 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007509507 14801006 RICHARD MILBURN ACADEMY FORT WORTH   Alternative School Yes High 09 12 2021   grade_12                                                   47                                             47
1413415 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007513173 14801005 RICHARD MILBURN ACADEMY HOUSTON (S   Alternative School Yes High 09 12 2021   grade_12                                                   75                                             75
1413419 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007508324 14801004 RICHARD MILBURN ACADEMY LUBBOCK   Alternative School Yes High 09 12 2021   grade_12                                                   25                                             25
1413423 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007513433 14801010 RICHARD MILBURN ACADEMY MIDLAND SO   Alternative School Yes High 09 12 2021   grade_12                                                   29                                             29
1413427 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007509647 14801002 RICHARD MILBURN ACADEMY ODESSA   Alternative School Yes High 09 12 2021   grade_12                                                   103                                             103
1413431 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007513435 14801009 RICHARD MILBURN ACADEMY PASADENA   Alternative School Yes High 09 12 2021   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]);