enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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 ▼
1395157 1395157 TX HAYS COUNTY   school 4800010 105906   HAYS CISD 480001006990 105906002 ALTER IMPACT CTR   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1395252 1395252 TX HAYS COUNTY   school 4800010 105906   HAYS CISD 480001013567 105906006 MOE AND GENE JOHNSON H S   Regular School No High 09 12 2021   grade_12                                                   <10                                             10
1395346 1395346 TX WALLER COUNTY   school 4822920 237902   HEMPSTEAD ISD 482292013618 237902004 HEMPSTEAD ALTERNATIVE LEARNING CEN   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1396075 1396075 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364006270 101912013 COMMUNITY SERVICES-SEC   Alternative School No Other 01 12 2021   grade_12                                                   <10                                             10
1396404 1396404 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364011265 101912351 HARPER DAEP   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1397526 1397526 TX ERATH COUNTY   school 4823760 72908   HUCKABAY ISD 482376002629 72908001 HUCKABAY SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1397535 1397535 TX ANGELINA COUNTY   school 4823790 3902   HUDSON ISD 482379007162 3902004 STUBBLEFIELD LRN CTR   Alternative School No High 11 12 2021   grade_12                                                   <10                                             10
1397694 1397694 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391012774 101913015 HUMBLE COMMUNITY LEARNING CENTER   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1397899 1397899 TX ANGELINA COUNTY   school 4824000 3904   HUNTINGTON ISD 482400001969 3904005 PRIDE ALTER SCH   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1398865 1398865 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005309121 15808003 JHW INSPIRE ACADEMY - HAYS COUNTY   Alternative School Yes High 07 12 2021   grade_12                                                   <10                                             10
1398877 1398877 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313328 15808012 JHW INSPIRE ACADEMY - LEGACY RANCH   Alternative School Yes Other KG 12 2021   grade_12                                                   <10                                             10
1398884 1398884 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005312039 15808007 JHW INSPIRE ACADEMY - ROCKDALE   Alternative School Yes High 06 12 2021   grade_12                                                   <10                                             10
1399468 1399468 TX DALLAS COUNTY   school 4800098 57819   JEAN MASSIEU ACADEMY 480009808169 57819001 JEAN MASSIEU ACADEMY   Alternative School Yes Other PK 12 2021   grade_12                                                   <10                                             10
1399648 1399648 TX BEXAR COUNTY   school 4800179 15822   JUBILEE ACADEMIES 480017912180 15822004 JUBILEE - LAKE VIEW UNIVERSITY PRE   Regular School Yes Other PK 12 2021   grade_12                                                   10                                             10
1400299 1400299 TX HARRIS COUNTY   school 4825170 101914   KATY ISD 482517005516 101914003 OPPORT AWARENESS CTR   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1400437 1400437 TX KAUFMAN COUNTY   school 4825200 129903   KAUFMAN ISD 482520009321 129903003 GARY W CAMPBELL H S   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1400464 1400464 TX JOHNSON COUNTY   school 4825230 126906   KEENE ISD 482523007014 126906002 ALTER LEARNING CTR   Alternative School No High 11 12 2021   grade_12                                                   <10                                             10
1400689 1400689 TX WHEELER COUNTY   school 4825290 242905   KELTON ISD 482529005755 242905001 KELTON SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1400692 1400692 TX KAUFMAN COUNTY   school 4825320 129904   KEMP ISD 482532010871 129904003 KEMP ALTERNATIVE   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1400845 1400845 TX HAYS COUNTY   school 4801447 105803   KI CHARTER ACADEMY 480144713122 105803001 KI CHARTER ACADEMY   Alternative School Yes Other 01 12 2021   grade_12                                                   <10                                             10
1400853 1400853 TX HAYS COUNTY   school 4801447 105803   KI CHARTER ACADEMY 480144714140 105803002 KI CHARTER ACADEMY LIBERTY HILL   Regular School Yes High 05 12 2021   grade_12                                                   <10                                             10
1400953 1400953 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566006281 14906004 GATEWAY H S   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1401575 1401575 TX HARRIS COUNTY   school 4825740 101915   KLEIN ISD 482574007642 101915037 HARRIS CO JJAEP   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1401602 1401602 TX HARRIS COUNTY   school 4825740 101915   KLEIN ISD 482574008632 101915038 K E KAUFMAN ALTERNATIVE EDUCATION   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1402065 1402065 TX HIDALGO COUNTY   school 4826130 108912   LA JOYA ISD 482613009585 108912005 HOPE ACADEMY   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1402376 1402376 TX HOOD COUNTY   school 4801464 111801   LAKE GRANBURY ACADEMY CHARTER SCHO 480146413723 111801001 LAKE GRANBURY ACADEMY   Alternative School Yes High 07 12 2021   grade_12                                                   <10                                             10
1402473 1402473 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658006739 79901004 ALTERNATIVE LEARNING CENTER   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1402621 1402621 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658021244 79901133 JUVENILE DETENT CTR   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1402900 1402900 TX WEBB COUNTY   school 4826790 240901   LAREDO ISD 482679007475 240901007 F S LARA ACADEMY   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1403032 1403032 TX WEBB COUNTY   school 4826790 240901   LAREDO ISD 482679007748 240901010 WEBB COUNTY J J A E P   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1403075 1403075 TX PARMER COUNTY   school 4826970 185904   LAZBUDDIE ISD 482697003038 185904001 LAZBUDDIE SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1403225 1403225 TX WILLIAMSON COUNTY   school 4827030 246913   LEANDER ISD 482703013720 246913014 LEANDER EXTENDED OPPORTUNITY   Alternative School No High 06 12 2021   grade_12                                                   <10                                             10
1403415 1403415 TX DALLAS COUNTY   school 4801428 57846   LEGACY PREPARATORY 480142812855 57846003 LEGACY PREPARATORY CHARTER ACADEMY   Regular School Yes Other KG 12 2021   grade_12                                                   <10                                             10
1403917 1403917 TX WILLIAMSON COUNTY   school 4827420 246908   LIBERTY HILL ISD 482742009428 246908005 WILLIAMSON JJAEP   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1404304 1404304 TX MCCULLOCH COUNTY   school 4827930 160905   LOHN ISD 482793003132 160905001 LOHN SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1404308 1404308 TX LAMPASAS COUNTY   school 4827960 141902   LOMETA ISD 482796013689 141902003 LEON VALLEY   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1404442 1404442 TX GAINES COUNTY   school 4828140 83902   LOOP ISD 482814003154 83902001 LOOP SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1404456 1404456 TX MITCHELL COUNTY   school 4828170 168902   LORAINE ISD 482817003156 168902001 LORAINE SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1404494 1404494 TX CAMERON COUNTY   school 4828290 31906   LOS FRESNOS CISD 482829009454 31906005 CAMERON CO J J A E P   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1404779 1404779 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850008328 152901017 LUBBOCK CO JUVENILE JUSTICE CTR   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1404839 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
1405016 1405016 TX JONES COUNTY   school 4828530 127905   LUEDERS-AVOCA ISD 482853003223 127905001 LUEDERS-AVOCA H S   Regular School No High 09 12 2021   grade_12                                                   <10                                             10
1405122 1405122 TX ATASCOSA COUNTY   school 4828650 7904   LYTLE ISD 482865008422 7904002 LYTLE DAEP   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1405614 1405614 TX BREWSTER COUNTY   school 4828980 22902   MARATHON ISD 482898003272 22902001 MARATHON INDEPENDENT SCHOOL DIST   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1406251 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 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
1406730 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 1406856 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042007028 147903101 DEVELOPMENTAL CTR   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1407275 1407275 TX CLAY COUNTY   school 4830660 39905   MIDWAY ISD 483066003461 39905001 MIDWAY SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1407563 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
1407698 1407698 TX SHACKELFORD COUNTY   school 4831320 209902   MORAN ISD 483132003518 209902001 MORAN SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1407780 1407780 TX HILL COUNTY   school 4831620 109910   MOUNT CALM ISD 483162003529 109910101 MOUNT CALM ISD   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1407887 1407887 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192005557 167902001 MULLIN MAIN   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1407893 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 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
1408060 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
1408342 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 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 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
1408573 1408573 TX DEWITT COUNTY   school 4832880 62902   NORDHEIM ISD 483288003624 62902001 NORDHEIM SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1408594 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 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 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 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
1409452 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 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
1410116 1410116 TX EDWARDS COUNTY   school 4833240 69902   NUECES CANYON CISD 483324003739 69902001 NUECES CANYON JH/HS   Regular School No High 07 12 2021   grade_12                                                   10                                             10
1410235 1410235 TX RUNNELS COUNTY   school 4833570 200906   OLFEN ISD 483357003754 200906101 OLFEN SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1410344 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
1410416 1410416 TX HASKELL COUNTY   school 4833960 104907   PAINT CREEK ISD 483396003777 104907001 PAINT CREEK SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1410544 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
1410569 1410569 TX COLEMAN COUNTY   school 4800007 42905   PANTHER CREEK CISD 480000706343 42905001 PANTHER CREEK SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1410609 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
1410899 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
1410946 1410946 TX DICKENS COUNTY   school 4834380 63906   PATTON SPRINGS ISD 483438003858 63906001 PATTON SPRINGS SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1411066 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
1411163 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 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
1411739 1411739 TX DALLAS COUNTY   school 4801451 57850   PIONEER TECHNOLOGY & ARTS ACADEMY 480145113443 57850002 PIONEER TECHNOLOGY (PTAA) GREENVIL   Regular School Yes Other KG 12 2021   grade_12                                                   <10                                             10
1412218 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 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
1412435 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
1412525 1412525 TX MONTAGUE COUNTY   school 4835730 169909   PRAIRIE VALLEY ISD 483573004044 169909001 PRAIRIE VALLEY H S   Regular School No High 06 12 2021   grade_12                                                   <10                                             10
1412645 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
1412736 1412736 TX MILLS COUNTY   school 4835820 167904   PRIDDY ISD 483582004057 167904001 PRIDDY SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1412804 1412804 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007612994 14803004 CEDAR PARK CHARTER ACADEMY   Regular School Yes Other PK 12 2021   grade_12                                                   <10                                             10
1412818 1412818 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007613035 14803003 COVE CHARTER ACADEMY   Regular School Yes Other PK 12 2021   grade_12                                                   10                                             10
1412842 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 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
1413210 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
1413371 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
1413525 1413525 TX DALLAS COUNTY   school 4837020 57916   RICHARDSON ISD 483702005582 57916006 CHRISTA MCAULIFFE LEARNING CENTER   Alternative School No High 07 12 2021   grade_12                                                   <10                                             10
1414033 1414033 TX COKE COUNTY   school 4837380 41902   ROBERT LEE ISD 483738016035 41902002 FAIRVIEW ACCELERATED   Alternative School No High 11 12 2021   grade_12                                                   <10                                             10
1414035 1414035 TX COKE COUNTY   school 4837380 41902   ROBERT LEE ISD 483738010485 41902195 FAIRVIEW SPECIAL PROGRAMS   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1414086 1414086 TX NUECES COUNTY   school 4837440 178909   ROBSTOWN ISD 483744013203 178909005 SALAZAR CROSSROADS ACADEMY   Alternative School No High 10 12 2021   grade_12                                                   <10                                             10
1414125 1414125 TX MCCULLOCH COUNTY   school 4837500 160904   ROCHELLE ISD 483750004212 160904001 ROCHELLE SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   10                                             10
1414449 1414449 TX FISHER COUNTY   school 4838040 76904   ROTAN ISD 483804004245 76904001 ROTAN K-12   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1414758 1414758 TX WILLIAMSON COUNTY   school 4838080 246909   ROUND ROCK ISD 483808014024 246909018 WILLIAMSON COUNTY CORE   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1414868 1414868 TX HASKELL COUNTY   school 4838280 104903   RULE ISD 483828004270 104903001 RULE SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   <10                                             10
1414974 1414974 TX BELL COUNTY   school 4838580 14908   SALADO ISD 483858010411 14908005 BELL COUNTY DAEP   Alternative School No High 10 12 2021   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]);