Data source: Big Local News · About: Big Local

4,819 rows where grade = "grade_8" and state = "TX" sorted by ccd_school_type

View and edit SQL

year

grade

  • grade_8 · 4,719
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
1394391 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247010424 15904048 TEJEDA JUNIOR ACADEMY   Alternative School No Middle 07 08 2021   grade_8                                                   12                                             12
1394564 TX CAMERON COUNTY   school 4822530 31903   HARLINGEN CISD 482253006940 31903118 SECONDARY ALTER CTR   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1395430 TX BEXAR COUNTY   school 4800080 15815   HERITAGE ACADEMY 480008008109 15815101 HERITAGE ACADEMY   Alternative School Yes Middle 07 08 2021   grade_8                                                   19                                             19
1395439 TX BEXAR COUNTY   school 4800080 15815   HERITAGE ACADEMY 480008013778 15815042 HERITAGE ACADEMY OF DEL RIO MIDDLE   Alternative School Yes Middle 04 08 2021   grade_8                                                   73                                             73
1396071 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364006270 101912013 COMMUNITY SERVICES-SEC   Alternative School No Other 01 12 2021   grade_8                                                   <10                                             10
1396388 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364012602 101912456 H S AHEAD ACADEMY   Alternative School No Middle 06 08 2021   grade_8                                                   10                                             10
1396400 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364011265 101912351 HARPER DAEP   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1396626 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364008608 101912340 LAS AMERICAS   Alternative School No Middle 04 08 2021   grade_8                                                   50                                             50
1397129 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364012655 101912402 SECONDARY DAEP   Alternative School No Secondary 07 11 2021   grade_8                                                   <10                                             10
1397690 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391012774 101913015 HUMBLE COMMUNITY LEARNING CENTER   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1397717 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391011544 101913198 JJAEP CAMPUS   Alternative School No Secondary 08 10 2021   grade_8                                                   <10                                             10
1398120 TX TARRANT COUNTY   school 4824060 220916   HURST-EULESS-BEDFORD ISD 482406008043 220916007 TARRANT CO J J A E P   Alternative School No Secondary 08 10 2021   grade_8                                                   <10                                             10
1398861 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005309121 15808003 JHW INSPIRE ACADEMY - HAYS COUNTY   Alternative School Yes High 07 12 2021   grade_8                                                   <10                                             10
1398874 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313328 15808012 JHW INSPIRE ACADEMY - LEGACY RANCH   Alternative School Yes Other KG 12 2021   grade_8                                                   <10                                             10
1398880 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005312039 15808007 JHW INSPIRE ACADEMY - ROCKDALE   Alternative School Yes High 06 12 2021   grade_8                                                   10                                             10
1399364 TX CHEROKEE COUNTY   school 4824590 37904   JACKSONVILLE ISD 482459007213 37904004 COMPASS CENTER   Alternative School No Middle 05 11 2021   grade_8                                                   <10                                             10
1399464 TX DALLAS COUNTY   school 4800098 57819   JEAN MASSIEU ACADEMY 480009808169 57819001 JEAN MASSIEU ACADEMY   Alternative School Yes Other PK 12 2021   grade_8                                                   14                                             14
1399615 TX ATASCOSA COUNTY   school 4824960 7902   JOURDANTON ISD 482496007778 7902005 ATASCOSA COUNTY JUVENILE JUSTICE C   Alternative School No Secondary 07 11 2021   grade_8                                                   <10                                             10
1400295 TX HARRIS COUNTY   school 4825170 101914   KATY ISD 482517005516 101914003 OPPORT AWARENESS CTR   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1400841 TX HAYS COUNTY   school 4801447 105803   KI CHARTER ACADEMY 480144713122 105803001 KI CHARTER ACADEMY   Alternative School Yes Other 01 12 2021   grade_8                                                   31                                             31
1400956 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566000118 14906009 GATEWAY MIDDLE   Alternative School No Middle 06 08 2021   grade_8                                                   17                                             17
1401598 TX HARRIS COUNTY   school 4825740 101915   KLEIN ISD 482574008632 101915038 K E KAUFMAN ALTERNATIVE EDUCATION   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1402061 TX HIDALGO COUNTY   school 4826130 108912   LA JOYA ISD 482613009585 108912005 HOPE ACADEMY   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1402372 TX HOOD COUNTY   school 4801464 111801   LAKE GRANBURY ACADEMY CHARTER SCHO 480146413723 111801001 LAKE GRANBURY ACADEMY   Alternative School Yes High 07 12 2021   grade_8                                                   <10                                             10
1402469 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658006739 79901004 ALTERNATIVE LEARNING CENTER   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1402617 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658021244 79901133 JUVENILE DETENT CTR   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1402896 TX WEBB COUNTY   school 4826790 240901   LAREDO ISD 482679007475 240901007 F S LARA ACADEMY   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1403029 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_8                                                   <10                                             10
1403221 TX WILLIAMSON COUNTY   school 4827030 246913   LEANDER ISD 482703013720 246913014 LEANDER EXTENDED OPPORTUNITY   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1403706 TX DENTON COUNTY   school 4827300 61902   LEWISVILLE ISD 482730006744 61902005 LEARNING CTR   Alternative School No Other 01 12 2021   grade_8                                                   22                                             22
1404397 TX GREGG COUNTY   school 4828110 92903   LONGVIEW ISD 482811001116 92903200 JUVENILE DETENT CTR   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1404490 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_8                                                   <10                                             10
1404770 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850007677 152901015 LUBBOCK CO J J A E P   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1404775 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850008328 152901017 LUBBOCK CO JUVENILE JUSTICE CTR   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1404835 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850003208 152901007 PRIORITY INTERVENTION ACADEMY   Alternative School No High 06 12 2021   grade_8                                                   22                                             22
1405041 TX ANGELINA COUNTY   school 4828550 3903   LUFKIN ISD 482855000536 3903201 JUVENILE DETENT CTR   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1405179 TX MONTGOMERY COUNTY   school 4828740 170906   MAGNOLIA ISD 482874008995 170906011 AEP   Alternative School No Secondary 08 10 2021   grade_8                                                   <10                                             10
1405672 TX GUADALUPE COUNTY   school 4829100 94904   MARION ISD 482910013401 94904003 MARION ALTERNATIVE CENTER   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1405968 TX HIDALGO COUNTY   school 4829670 108906   MCALLEN ISD 482967006752 108906005 INSTR/GUID CENTER   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1406142 TX COLLIN COUNTY   school 4829850 43907   MCKINNEY ISD 482985008486 43907006 COUNTY RESIDENTIAL CENTER   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1406335 TX KENDALL COUNTY   school 4801404 130801   MEADOWLAND CHARTER DISTRICT 480140412137 130801001 OAKS ACADEMY   Alternative School Yes Other 01 11 2021   grade_8                                                   <20                                             20
1406341 TX KENDALL COUNTY   school 4801404 130801   MEADOWLAND CHARTER DISTRICT 480140413750 130801003 STEPPING STONES ACADEMY   Alternative School Yes Other 04 12 2021   grade_8                                                   <10                                             10
1406453 TX HIDALGO COUNTY   school 4830250 108907   MERCEDES ISD 483025008655 108907003 JJAEP-SOUTHWEST KEY PROGRAM   Alternative School No Middle 07 09 2021   grade_8                                                   <10                                             10
1406852 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042007028 147903101 DEVELOPMENTAL CTR   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1406908 TX MIDLAND COUNTY   school 4800148 165802   MIDLAND ACADEMY CHARTER SCHOOL 480014808336 165802101 MIDLAND ACADEMY CHARTER SCHOOL   Alternative School Yes Elementary PK 08 2021   grade_8                                                   21                                             21
1406913 TX MIDLAND COUNTY   school 4830570 165901   MIDLAND ISD 483057013277 165901020 BARBARA CULVER JUVENILE DETENTION   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1407071 TX MIDLAND COUNTY   school 4830570 165901   MIDLAND ISD 483057012704 165901030 MIDLAND ALTERNATIVE PROGRAM   Alternative School No Secondary 08 09 2021   grade_8                                                   <10                                             10
1407889 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192013019 167902002 MULLIN OAKS   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1407898 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192013338 167902056 PARKVIEW SCHOOL - LEVELLAND   Alternative School No Other 03 12 2021   grade_8                                                   <10                                             10
1408338 TX MONTGOMERY COUNTY   school 4832400 170908   NEW CANEY ISD 483240007079 170908002 THE LEARNING CTR   Alternative School No Other 02 12 2021   grade_8                                                   <10                                             10
1408397 TX BEXAR COUNTY   school 4800061 15805   NEW FRONTIERS PUBLIC SCHOOLS INC 480006111122 15805041 FRANK L MADLA ACCELERATED COLLEGIA   Alternative School Yes Elementary PK 08 2021   grade_8                                                   52                                             52
1408597 TX BEXAR COUNTY   school 4832940 15910   NORTH EAST ISD 483294006889 15910053 ALTER MIDDLE   Alternative School No Middle 06 08 2021   grade_8                                                   <10                                             10
1408745 TX BEXAR COUNTY   school 4832940 15910   NORTH EAST ISD 483294015799 15910054 HOMEBASED COMP ED   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1409128 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312007521 15915062 ALTERNATIVE MIDDLE   Alternative School No Middle 08 08 2021   grade_8                                                   <10                                             10
1409448 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312003715 15915004 HOLMGREEN CENTER   Alternative School No Other PK 12 2021   grade_8                                                   <10                                             10
1410362 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023511986 14804002 NEW HORIZONS   Alternative School Yes Other 01 11 2021   grade_8                                                   <10                                             10
1410540 TX PANOLA COUNTY   school 4800213 183801   PANOLA CHARTER SCHOOL 480021308891 183801001 PANOLA CS   Alternative School Yes High 08 12 2021   grade_8                                                   <10                                             10
1410891 TX HARRIS COUNTY   school 4834320 101917   PASADENA ISD 483432017033 101917007 TEGELER CAREER CENTER   Alternative School No High 07 12 2021   grade_8                                                   <80                                             80
1410903 TX HARRIS COUNTY   school 4834320 101917   PASADENA ISD 483432010777 101917055 THE SUMMIT (INTERMEDIATE)   Alternative School No Middle 05 08 2021   grade_8                                                   <10                                             10
1411120 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_8                                                   55                                             55
1411489 TX HIDALGO COUNTY   school 4834860 108909   PHARR-SAN JUAN-ALAMO ISD 483486012654 108909011 BUELL CENTRAL DAEP   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1411819 TX HALE COUNTY   school 4835070 95905   PLAINVIEW ISD 483507008224 95905004 HALE COUNTY JJAEP   Alternative School No Secondary 07 10 2021   grade_8                                                   <10                                             10
1412215 TX ATASCOSA COUNTY   school 4835190 7905   PLEASANTON ISD 483519007506 7905004 ATASCOSA CO ALTER   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1412431 TX GARZA COUNTY   school 4835490 85902   POST ISD 483549012914 85902040 GARZA COUNTY REGIONAL JUVENILE CEN   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1412585 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_8                                                   <10                                             10
1412838 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007608098 14803101 TEMPLE CHARTER ACADEMY   Alternative School Yes Other PK 12 2021   grade_8                                                   24                                             24
1413121 TX VAN ZANDT COUNTY   school 4800171 234801   RANCH ACADEMY 480017108398 234801001 RANCH ACADEMY   Alternative School Yes High 06 12 2021   grade_8                                                   <10                                             10
1413225 TX WILLACY COUNTY   school 4836540 245903   RAYMONDVILLE ISD 483654012552 245903004 RAYMONDVILLE OPTIONS ACADEMIC ACAD   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1413521 TX DALLAS COUNTY   school 4837020 57916   RICHARDSON ISD 483702005582 57916006 CHRISTA MCAULIFFE LEARNING CENTER   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1413677 TX DALLAS COUNTY   school 4837020 57916   RICHARDSON ISD 483702007580 57916008 P A S S LEARNING CTR   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1415071 TX TOM GREEN COUNTY   school 4838700 226903   SAN ANGELO ISD 483870005460 226903038 CARVER ALTER LRN CTR   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1415235 TX BEXAR COUNTY   school 4838730 15907   SAN ANTONIO ISD 483873009126 15907064 BREWER ACADEMY   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1415378 TX BEXAR COUNTY   school 4838730 15907   SAN ANTONIO ISD 483873006611 15907010 ESTRADA ACHIEVEMENT CTR   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1415524 TX BEXAR COUNTY   school 4838730 15907   SAN ANTONIO ISD 483873021101 15907195 JUVENILE DETENT CTR   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1415824 TX CAMERON COUNTY   school 4838790 31912   SAN BENITO CISD 483879008467 31912003 CAMERON CO J J A E P   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1415858 TX CAMERON COUNTY   school 4838790 31912   SAN BENITO CISD 483879006942 31912201 HESTER JUVENILE DETENT   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1415904 TX CAMERON COUNTY   school 4838790 31912   SAN BENITO CISD 483879012122 31912008 RGV YOUTH RECOVERY HOME   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1415963 TX VAL VERDE COUNTY   school 4838900 233901   SAN FELIPE-DEL RIO CISD 483890013253 233901004 BLENDED ACADEMY   Alternative School No High 08 12 2021   grade_8                                                   51                                             51
1416625 TX GUADALUPE COUNTY   school 4839690 94901   SEGUIN ISD 483969004070 94901111 DISCIPLINE ALTERNATIVE SCHOOL AT S   Alternative School No Secondary 07 10 2021   grade_8                                                   <10                                             10
1416931 TX GRAYSON COUNTY   school 4840080 91906   SHERMAN ISD 484008008794 91906004 COOKE/FANNIN/GRAYSON CO JUVENILE P   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1417395 TX EL PASO COUNTY   school 4840710 71909   SOCORRO ISD 484071016996 71909003 KEYS ACAD   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1417859 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006310419 15807005 NEW DIRECTIONS   Alternative School Yes High 06 12 2021   grade_8                                                   16                                             16
1417891 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006309118 15807004 SOUTHWEST PREPARATORY SCHOOL-NORTH   Alternative School Yes Other 03 12 2021   grade_8                                                   24                                             24
1417905 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006308433 15807002 SOUTHWEST PREPARATORY SOUTHEAST CA   Alternative School Yes Other PK 12 2021   grade_8                                                   16                                             16
1417912 TX HARRIS COUNTY   school 4800125 101838   SOUTHWEST SCHOOL 480012511234 101838041 DISCOVERY MIDDLE   Alternative School Yes Middle 06 08 2021   grade_8                                                   111                                             111
1417925 TX HARRIS COUNTY   school 4800125 101838   SOUTHWEST SCHOOL 480012508252 101838004 PHOENIX SCHOOL AT SOUTHWEST SCHOOL   Alternative School Yes Other KG 12 2021   grade_8                                                   13                                             13
1418482 TX HARRIS COUNTY   school 4841220 101919   SPRING ISD 484122013248 101919022 RICHEY ACADEMY   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1418721 TX WILSON COUNTY   school 4841610 247906   STOCKDALE ISD 484161008092 247906002 ALTERNATIVE SCHOOL   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1419078 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233009458 14909198 SCOTT & WHITE HOSPITAL   Alternative School No Middle 08 08 2021   grade_8                                                   <10                                             10
1419254 TX BOWIE COUNTY   school 4842480 19907   TEXARKANA ISD 484248013901 19907006 ESCHOOL PREP   Alternative School No High 05 12 2021   grade_8                                                   138                                             138
1419373 TX GALVESTON COUNTY   school 4842510 84906   TEXAS CITY ISD 484251009544 84906006 WOODROW WILSON DAEP   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1419386 TX TAYLOR COUNTY   school 4800163 221801   TEXAS COLLEGE PREPARATORY ACADEMIE 480016311503 221801011 AMARILLO COLLEGIATE ACADEMY   Alternative School Yes Other KG 12 2021   grade_8                                                   24                                             24
1419492 TX TAYLOR COUNTY   school 4800163 221801   TEXAS COLLEGE PREPARATORY ACADEMIE 480016311536 221801020 FOUNDERS CLASSICAL ACADEMY CORINTH   Alternative School Yes High 07 12 2021   grade_8                                                   75                                             75
1419574 TX TAYLOR COUNTY   school 4800163 221801   TEXAS COLLEGE PREPARATORY ACADEMIE 480016309583 221801022 ISCHOOL VIRTUAL ACADEMY OF TEXAS   Alternative School Yes Other 03 12 2021   grade_8                                                   375                                             375
1419792 TX MONTGOMERY COUNTY   school 4800151 170801   TEXAS SERENITY ACADEMY 480015111306 170801003 TEXAS SERENITY ACADEMY   Alternative School Yes Elementary KG 08 2021   grade_8                                                   34                                             34
1419853 TX HARRIS COUNTY   school 4801418 101864   THE LAWSON ACADEMY 480141812485 101864041 THE LAWSON ACADEMY   Alternative School Yes Middle 06 08 2021   grade_8                                                   60                                             60
1419859 TX HARRIS COUNTY   school 4801434 101868   THE PRO-VISION ACADEMY 480143412953 101868002 PRO-VISION MIDDLE   Alternative School Yes Middle 03 08 2021   grade_8                                                   81                                             81
1420267 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913178 46802010 AZLEWAY - BIG SANDY   Alternative School Yes High 08 12 2021   grade_8                                                   <10                                             10
1420275 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913198 46802011 AZLEWAY - WILLOW BEND   Alternative School Yes High 05 12 2021   grade_8                                                   <10                                             10
1420286 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025912947 46802007 PEGASUS SCHOOL   Alternative School Yes High 05 12 2021   grade_8                                                   37                                             37

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