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,479
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
1630288 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970006257 220905066 WILLOUGHBY HOUSE   Alternative School No High 08 12 2020   grade_8                                                   <10                                             10
1630435 TX LUBBOCK COUNTY   school 4819830 152907   FRENSHIP ISD 481983009331 152907003 LUBBOCK CO J J A E P   Alternative School No Secondary 08 11 2020   grade_8                                                   <10                                             10
1631018 TX HARRIS COUNTY   school 4820250 101910   GALENA PARK ISD 482025006973 101910006 HIGHPOINT SCHOOL EAST (DAEP)   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1631115 TX GALVESTON COUNTY   school 4820280 84902   GALVESTON ISD 482028012288 84902007 AIM COLLEGE & CAREER PREP   Alternative School No High 06 12 2020   grade_8                                                   14                                             14
1631318 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034000518 57909053 GARLAND AEC   Alternative School No Other 01 12 2020   grade_8                                                   <10                                             10
1631708 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001410415 15802004 RUTH JONES MCCLENDON MIDDLE   Alternative School Yes High 06 12 2020   grade_8                                                   24                                             24
1631716 TX HARRIS COUNTY   school 4800020 101804   GEORGE I SANCHEZ CHARTER 480002007304 101804001 GEORGE I SANCHEZ CHARTER   Alternative School Yes Other PK 12 2020   grade_8                                                   81                                             81
1631723 TX HARRIS COUNTY   school 4800020 101804   GEORGE I SANCHEZ CHARTER 480002013387 101804004 GEORGE I SANCHEZ NORTH   Alternative School Yes Middle 06 10 2020   grade_8                                                   53                                             53
1631791 TX WILLIAMSON COUNTY   school 4820600 246904   GEORGETOWN ISD 482060007097 246904003 GEORGETOWN ALTER PROG   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1632152 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115010738 101911012 HIGH POINT SCHOOL   Alternative School No High 08 12 2020   grade_8                                                   <10                                             10
1632200 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115008605 101911006 POINT ALTERNATIVE CENTER   Alternative School No High 06 12 2020   grade_8                                                   10                                             10
1632507 TX DALLAS COUNTY   school 4821420 57910   GRAND PRAIRIE ISD 482142006970 57910004 LYNDON B JOHNSON DAEP   Alternative School No High 06 12 2020   grade_8                                                   13                                             13
1632625 TX VAN ZANDT COUNTY   school 4821450 234904   GRAND SALINE ISD 482145008069 234904002 VAN ZANDT CO YOUTH MULTI-SERVICE C   Alternative School No Secondary 06 11 2020   grade_8                                                   <10                                             10
1632908 TX HUNT COUNTY   school 4821720 116905   GREENVILLE ISD 482172007361 116905004 GREENVILLE ALTERNATIVE EDUCATIONAL   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1633161 TX HARRISON COUNTY   school 4822170 102904   HALLSVILLE ISD 482217012918 102904010 TEXAS VIRTUAL ACADEMY AT HALLSVILL   Alternative School No Other 03 12 2020   grade_8                                                   805                                             805
1633311 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247009123 15904047 FENLEY TRANSITIONAL MIDDLE   Alternative School No Middle 08 08 2020   grade_8                                                   <10                                             10
1633337 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247007799 15904045 HAC DAEP MIDDLE   Alternative School No Middle 06 08 2020   grade_8                                                   11                                             11
1633382 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247010424 15904048 TEJEDA JUNIOR ACADEMY   Alternative School No Middle 08 08 2020   grade_8                                                   26                                             26
1633559 TX CAMERON COUNTY   school 4822530 31903   HARLINGEN CISD 482253006940 31903118 SECONDARY ALTER CTR   Alternative School No High 06 12 2020   grade_8                                                   12                                             12
1634138 TX HAYS COUNTY   school 4800010 105906   HAYS CISD 480001006990 105906002 ALTER IMPACT CTR   Alternative School No High 05 12 2020   grade_8                                                   <10                                             10
1634419 TX BEXAR COUNTY   school 4800080 15815   HERITAGE ACADEMY 480008008109 15815101 HERITAGE ACADEMY   Alternative School Yes Middle 07 08 2020   grade_8                                                   13                                             13
1634428 TX BEXAR COUNTY   school 4800080 15815   HERITAGE ACADEMY 480008013778 15815042 HERITAGE ACADEMY OF DEL RIO MIDDLE   Alternative School Yes Middle 04 08 2020   grade_8                                                   52                                             52
1635073 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364006270 101912013 COMMUNITY SERVICES-SEC   Alternative School No Other PK 12 2020   grade_8                                                   <10                                             10
1635409 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364012602 101912456 H S AHEAD ACADEMY   Alternative School No Middle 06 08 2020   grade_8                                                   36                                             36
1635424 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364007934 101912320 HARRIS CO J J A E P   Alternative School No Secondary 07 11 2020   grade_8                                                   <10                                             10
1635562 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364012042 101912300 INSPIRED FOR EXCELLENCE ACADEMY IN   Alternative School Yes Middle 05 08 2020   grade_8                                                   76                                             76
1635664 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364008608 101912340 LAS AMERICAS   Alternative School No Middle 04 08 2020   grade_8                                                   139                                             139
1636182 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364012655 101912402 SECONDARY DAEP   Alternative School No High 06 12 2020   grade_8                                                   19                                             19
1636749 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391012774 101913015 HUMBLE COMMUNITY LEARNING CENTER   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1636777 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391011544 101913198 JJAEP CAMPUS   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1637008 TX TARRANT COUNTY   school 4824060 220916   HURST-EULESS-BEDFORD ISD 482406007730 220916004 ALTER ED PROG   Alternative School No High 05 12 2020   grade_8                                                   <10                                             10
1637181 TX TARRANT COUNTY   school 4824060 220916   HURST-EULESS-BEDFORD ISD 482406008043 220916007 TARRANT CO J J A E P   Alternative School No High 08 12 2020   grade_8                                                   <10                                             10
1637827 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005307796 15808001 JHW INSPIRE ACADEMY - AFTON OAKS   Alternative School Yes High 06 12 2020   grade_8                                                   27                                             27
1637832 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313600 15808014 JHW INSPIRE ACADEMY - BELL COUNTY   Alternative School Yes High 08 12 2020   grade_8                                                   <10                                             10
1637837 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005309121 15808003 JHW INSPIRE ACADEMY - HAYS COUNTY   Alternative School Yes High 07 12 2020   grade_8                                                   <10                                             10
1637849 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313328 15808012 JHW INSPIRE ACADEMY - LEGACY RANCH   Alternative School Yes Other KG 12 2020   grade_8                                                   <10                                             10
1637853 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313204 15808010 JHW INSPIRE ACADEMY - MERIDELL   Alternative School Yes High 06 12 2020   grade_8                                                   16                                             16
1637861 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005312039 15808007 JHW INSPIRE ACADEMY - ROCKDALE   Alternative School Yes High 05 12 2020   grade_8                                                   11                                             11
1637869 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313326 15808011 JHW INSPIRE ACADEMY - WILLIAMS HOU   Alternative School Yes High 05 12 2020   grade_8                                                   <10                                             10
1638336 TX CHEROKEE COUNTY   school 4824590 37904   JACKSONVILLE ISD 482459007213 37904004 COMPASS CENTER   Alternative School No High 08 12 2020   grade_8                                                   <10                                             10
1638438 TX DALLAS COUNTY   school 4800098 57819   JEAN MASSIEU ACADEMY 480009808169 57819001 JEAN MASSIEU ACADEMY   Alternative School Yes Other PK 12 2020   grade_8                                                   <10                                             10
1638596 TX ATASCOSA COUNTY   school 4824960 7902   JOURDANTON ISD 482496007778 7902005 ATASCOSA COUNTY JUVENILE JUSTICE C   Alternative School No Secondary 07 11 2020   grade_8                                                   <10                                             10
1638826 TX BEXAR COUNTY   school 4824990 15916   JUDSON ISD 482499007187 15916005 JUDSON CARE ACADEMY   Alternative School No High 06 12 2020   grade_8                                                   14                                             14
1638984 TX HAYS COUNTY   school 4800132 105801   KATHERINE ANNE PORTER SCHOOL 480013208279 105801001 KATHERINE ANNE PORTER SCHOOL   Alternative School Yes High 08 12 2020   grade_8                                                   16                                             16
1639096 TX HARRIS COUNTY   school 4825170 101914   KATY ISD 482517008823 101914033 HARRIS CO SCH FOR ACCELERATED LRN   Alternative School No Secondary 08 10 2020   grade_8                                                   <10                                             10
1639272 TX HARRIS COUNTY   school 4825170 101914   KATY ISD 482517005516 101914003 OPPORT AWARENESS CTR   Alternative School No High 07 12 2020   grade_8                                                   13                                             13
1639410 TX JOHNSON COUNTY   school 4801455 126801   KAUFFMAN LEADERSHIP ACADEMY 480145513372 126801001 KAUFFMAN LEADERSHIP ACADEMY   Alternative School Yes High 05 12 2020   grade_8                                                   14                                             14
1639596 TX TARRANT COUNTY   school 4825260 220907   KELLER ISD 482526008035 220907003 TARRANT CO J J A E P   Alternative School No Secondary 08 11 2020   grade_8                                                   <10                                             10
1639793 TX HAYS COUNTY   school 4801447 105803   KI CHARTER ACADEMY 480144713122 105803001 KI CHARTER ACADEMY   Alternative School Yes Other 02 12 2020   grade_8                                                   29                                             29
1639818 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002861 14906022 ADVENTHEALTH SCHOOL   Alternative School No Other 01 12 2020   grade_8                                                   <10                                             10
1639907 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566000118 14906009 GATEWAY MIDDLE   Alternative School No Middle 06 08 2020   grade_8                                                   29                                             29
1639957 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566007783 14906026 KILLEEN JJAEP   Alternative School No Secondary 08 09 2020   grade_8                                                   <10                                             10
1640499 TX HARRIS COUNTY   school 4825740 101915   KLEIN ISD 482574007642 101915037 HARRIS CO JJAEP   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1640535 TX HARRIS COUNTY   school 4825740 101915   KLEIN ISD 482574008632 101915038 KLEIN ANNEX   Alternative School No High 06 12 2020   grade_8                                                   12                                             12
1640760 TX HARDIN COUNTY   school 4825920 100903   KOUNTZE ISD 482592008226 100903003 HARDIN CO ALTER ED   Alternative School No Middle 08 08 2020   grade_8                                                   <10                                             10
1640989 TX HIDALGO COUNTY   school 4826130 108912   LA JOYA ISD 482613009585 108912005 HOPE ACADEMY   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1641212 TX WILSON COUNTY   school 4826310 247903   LA VERNIA ISD 482631007500 247903002 FLORESVILLE ALTERNATIVE EDUCATION   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1641310 TX HOOD COUNTY   school 4801464 111801   LAKE GRANBURY ACADEMY CHARTER SCHO 480146413723 111801001 LAKE GRANBURY ACADEMY   Alternative School Yes High 06 12 2020   grade_8                                                   <10                                             10
1641402 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658006739 79901004 ALTERNATIVE LEARNING CENTER   Alternative School No High 05 12 2020   grade_8                                                   <10                                             10
1641461 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658006999 79901008 FORT BEND CO ALTER   Alternative School No Secondary 08 11 2020   grade_8                                                   <10                                             10
1641550 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658021244 79901133 JUVENILE DETENT CTR   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1641823 TX WEBB COUNTY   school 4826790 240901   LAREDO ISD 482679007475 240901007 F S LARA ACADEMY   Alternative School No High 06 12 2020   grade_8                                                   24                                             24
1641963 TX WEBB COUNTY   school 4826790 240901   LAREDO ISD 482679007748 240901010 WEBB COUNTY J J A E P   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1642153 TX WILLIAMSON COUNTY   school 4827030 246913   LEANDER ISD 482703013720 246913014 LEANDER EXTENDED OPPORTUNITY   Alternative School No High 06 12 2020   grade_8                                                   15                                             15
1642289 TX WILLIAMSON COUNTY   school 4827030 246913   LEANDER ISD 482703007758 246913010 WILLIAMSON CO ACADEMY   Alternative School No Secondary 08 11 2020   grade_8                                                   <10                                             10
1642293 TX WILLIAMSON COUNTY   school 4827030 246913   LEANDER ISD 482703009438 246913012 WILLIAMSON COUNTY DETENTION CENTER   Alternative School No Secondary 08 11 2020   grade_8                                                   <10                                             10
1642643 TX DENTON COUNTY   school 4827300 61902   LEWISVILLE ISD 482730006744 61902005 LEARNING CTR   Alternative School No Other 01 12 2020   grade_8                                                   13                                             13
1643334 TX GREGG COUNTY   school 4828110 92903   LONGVIEW ISD 482811013580 92903044 JUDSON STEAM ACADEMY   Alternative School Yes Middle 06 08 2020   grade_8                                                   189                                             189
1643336 TX GREGG COUNTY   school 4828110 92903   LONGVIEW ISD 482811001116 92903200 JUVENILE DETENT CTR   Alternative School No Secondary 07 11 2020   grade_8                                                   <10                                             10
1643431 TX CAMERON COUNTY   school 4828290 31906   LOS FRESNOS CISD 482829009454 31906005 CAMERON CO J J A E P   Alternative School No High 08 12 2020   grade_8                                                   <10                                             10
1643714 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850007677 152901015 LUBBOCK CO J J A E P   Alternative School No Secondary 06 11 2020   grade_8                                                   <10                                             10
1643720 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850008328 152901017 LUBBOCK CO JUVENILE JUSTICE CTR   Alternative School No High 06 12 2020   grade_8                                                   17                                             17
1643740 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850007030 152901011 MATTHEWS LEARNING CENTER   Alternative School No High 08 12 2020   grade_8                                                   <10                                             10
1643783 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850003208 152901007 PRIORITY INTERVENTION ACADEMY   Alternative School No High 06 12 2020   grade_8                                                   20                                             20
1643995 TX ANGELINA COUNTY   school 4828550 3903   LUFKIN ISD 482855000536 3903201 JUVENILE DETENT CTR   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1644076 TX ATASCOSA COUNTY   school 4828650 7904   LYTLE ISD 482865010389 7904003 JJAEP   Alternative School No Middle 08 08 2020   grade_8                                                   <10                                             10
1644078 TX ATASCOSA COUNTY   school 4828650 7904   LYTLE ISD 482865008422 7904002 LYTLE DAEP   Alternative School No Other 04 09 2020   grade_8                                                   <10                                             10
1644200 TX MONTGOMERY COUNTY   school 4828740 170906   MAGNOLIA ISD 482874009354 170906010 PROJECT RESTORE   Alternative School No Secondary 08 11 2020   grade_8                                                   <10                                             10
1644220 TX HENDERSON COUNTY   school 4828780 107906   MALAKOFF ISD 482878007959 107906003 MALAKOFF ALTERNATIVE PROGRAM (MAP)   Alternative School No Secondary 06 11 2020   grade_8                                                   <10                                             10
1644935 TX HIDALGO COUNTY   school 4829670 108906   MCALLEN ISD 482967006752 108906005 INSTR/GUID CENTER   Alternative School No High 06 12 2020   grade_8                                                   16                                             16
1645117 TX COLLIN COUNTY   school 4829850 43907   MCKINNEY ISD 482985008486 43907006 COUNTY RESIDENTIAL CENTER   Alternative School No High 05 12 2020   grade_8                                                   12                                             12
1645170 TX COLLIN COUNTY   school 4829850 43907   MCKINNEY ISD 482985007556 43907197 J J A E P   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1645313 TX KENDALL COUNTY   school 4801404 130801   MEADOWLAND CHARTER DISTRICT 480140412137 130801001 OAKS ACADEMY   Alternative School Yes Other 02 12 2020   grade_8                                                   <10                                             10
1645426 TX HIDALGO COUNTY   school 4830250 108907   MERCEDES ISD 483025008655 108907003 JJAEP-SOUTHWEST KEY PROGRAM   Alternative School No Middle 08 08 2020   grade_8                                                   <10                                             10
1645696 TX DALLAS COUNTY   school 4830390 57914   MESQUITE ISD 483039007578 57914007 PASS LEARNING CTR   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1645819 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042007028 147903101 DEVELOPMENTAL CTR   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1645875 TX MIDLAND COUNTY   school 4800148 165802   MIDLAND ACADEMY CHARTER SCHOOL 480014808336 165802101 MIDLAND ACADEMY CHARTER SCHOOL   Alternative School Yes Elementary PK 08 2020   grade_8                                                   19                                             19
1646517 TX HIDALGO COUNTY   school 4831040 108908   MISSION CISD 483104008657 108908039 ROOSEVELT ALTERNATIVE SCHOOL   Alternative School No Other 04 12 2020   grade_8                                                   <10                                             10
1646803 TX TITUS COUNTY   school 4831760 225902   MOUNT PLEASANT ISD 483176009399 225902003 MOUNT PLEASANT DAEP   Alternative School No High 05 12 2020   grade_8                                                   <10                                             10
1646884 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192013019 167902002 MULLIN OAKS   Alternative School No High 07 12 2020   grade_8                                                   <10                                             10
1646893 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192013338 167902056 PARKVIEW SCHOOL - LEVELLAND   Alternative School No Other 04 10 2020   grade_8                                                   <10                                             10
1646901 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192013340 167902055 PARKVIEW SCHOOL - LUBBOCK   Alternative School No Other KG 11 2020   grade_8                                                   <10                                             10
1647316 TX MONTGOMERY COUNTY   school 4832400 170908   NEW CANEY ISD 483240009358 170908003 PROJECT RESTORE   Alternative School No High 05 12 2020   grade_8                                                   <10                                             10
1647348 TX MONTGOMERY COUNTY   school 4832400 170908   NEW CANEY ISD 483240007079 170908002 THE LEARNING CTR   Alternative School No High 05 12 2020   grade_8                                                   <10                                             10
1647405 TX BEXAR COUNTY   school 4800061 15805   NEW FRONTIERS PUBLIC SCHOOLS INC 480006111122 15805041 FRANK L MADLA ACCELERATED COLLEGIA   Alternative School Yes Elementary PK 08 2020   grade_8                                                   52                                             52
1647604 TX BEXAR COUNTY   school 4832940 15910   NORTH EAST ISD 483294006889 15910053 ALTER MIDDLE   Alternative School No Middle 06 08 2020   grade_8                                                   <20                                             20
1647832 TX BEXAR COUNTY   school 4832940 15910   NORTH EAST ISD 483294007181 15910022 NORTH EAST J J A E P   Alternative School No High 08 12 2020   grade_8                                                   <10                                             10
1648138 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312007521 15915062 ALTERNATIVE MIDDLE   Alternative School No Middle 06 08 2020   grade_8                                                   <20                                             20
1648464 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312003715 15915004 HOLMGREEN CENTER   Alternative School No Other PK 12 2020   grade_8                                                   <10                                             10
1648700 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312007184 15915039 NISD BEXAR COUNTY JJA   Alternative School No High 07 12 2020   grade_8                                                   <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]);