Data source: Big Local News · About: Big Local

4,396 rows where grade = "grade_10" and state = "TX" sorted by ccd_school_high_grade

View and edit SQL

year

grade

  • grade_10 · 4,396
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
1374501 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009062 221901007 TAYLOR COUNTY LEARNING CENTER   Alternative School No Middle 05 10 2021   grade_10                                                   <10                                             10
1374537 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312248 57814002 DRC CAMPUS   Alternative School Yes Secondary 09 10 2021   grade_10                                                   <10                                             10
1374694 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771013696 101902015 AVALOS P-TECH SCHOOL   Regular School No Secondary 09 10 2021   grade_10                                                   122                                             122
1375099 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783008805 101903047 ALIEF ISD J J A E P   Alternative School No Secondary 08 10 2021   grade_10                                                   <10                                             10
1376420 TX TARRANT COUNTY   school 4808700 220901   ARLINGTON ISD 480870013677 220901014 ARLINGTON COLLEGE AND CAREER H S   Regular School No Secondary 09 10 2021   grade_10                                                   108                                             108
1376724 TX TARRANT COUNTY   school 4808700 220901   ARLINGTON ISD 480870007110 220901008 NEWCOMER CENTER   Alternative School No Secondary 07 10 2021   grade_10                                                   45                                             45
1377400 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894011057 227901029 INTERNATIONAL H S   Alternative School No Secondary 09 10 2021   grade_10                                                   215                                             215
1378443 TX BELL COUNTY   school 4809860 14903   BELTON ISD 480986008100 14903006 BELL CO J J A E P   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1378478 TX BELL COUNTY   school 4809860 14903   BELTON ISD 480986013935 14903010 LAKE BELTON H S   Regular School No Secondary 09 10 2021   grade_10                                                   <440                                             440
1378825 TX TARRANT COUNTY   school 4810230 220902   BIRDVILLE ISD 481023009375 220902009 TARRANT CO J J A E P   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1380077 TX MCLENNAN COUNTY   school 4811730 161919   BRUCEVILLE-EDDY ISD 481173007994 161919002 AXTELL/BRUCEVILLE-EDDY LEARNING CE   Alternative School No Secondary 09 10 2021   grade_10                                                   <10                                             10
1380123 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179009145 21902015 BRAZOS COUNTY JJAEP   Alternative School No Secondary 09 10 2021   grade_10                                                   <10                                             10
1380442 TX JOHNSON COUNTY   school 4812180 126902   BURLESON ISD 481218013766 126902008 REALM   Regular School No Middle 06 10 2021   grade_10                                                   <30                                             30
1380923 TX TARRANT COUNTY   school 4813020 220919   CARROLL ISD 481302009392 220919003 CARROLL H S   Regular School No Secondary 09 10 2021   grade_10                                                   744                                             744
1382867 TX BEXAR COUNTY   school 4801457 15838   COMPASS ROSE ACADEMY 480145713398 15838001 COMPASS ROSE ACADEMY   Regular School Yes Middle 06 10 2021   grade_10                                                   67                                             67
1385845 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006965 57905030 MAYA ANGELOU H S   Alternative School No Secondary 07 10 2021   grade_10                                                   <10                                             10
1385913 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623013924 57905387 NORTH LAKE EARLY COLLEGE H S   Regular School No Secondary 09 10 2021   grade_10                                                   70                                             70
1387954 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785007183 15911004 BEXAR CO J J A E P   Alternative School No Secondary 09 10 2021   grade_10                                                   <10                                             10
1389298 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830013596 71902019 YOUNG WOMEN'S STEAM RESEARCH & PRE   Regular School No Middle 06 10 2021   grade_10                                                   30                                             30
1389838 TX NUECES COUNTY   school 4819380 178914   FLOUR BLUFF ISD 481938008010 178914004 NUECES CO J J A E P   Alternative School No Secondary 08 10 2021   grade_10                                                   <10                                             10
1391428 TX LUBBOCK COUNTY   school 4819830 152907   FRENSHIP ISD 481983009331 152907003 LUBBOCK CO J J A E P   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1391582 TX COLLIN COUNTY   school 4820010 43905   FRISCO ISD 482001010493 43905003 COLLIN CO J J A E P   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1392834 TX WILLIAMSON COUNTY   school 4820600 246904   GEORGETOWN ISD 482060007491 246904197 WILLIAMSON CO J J A E P   Alternative School No Secondary 09 10 2021   grade_10                                                   <10                                             10
1395619 TX HILL COUNTY   school 4823280 109904   HILLSBORO ISD 482328009309 109904010 HILL CO J J A E P   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1397718 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391011544 101913198 JJAEP CAMPUS   Alternative School No Secondary 08 10 2021   grade_10                                                   <10                                             10
1398121 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_10                                                   <10                                             10
1398217 TX WILLIAMSON COUNTY   school 4824100 246906   HUTTO ISD 482410011094 246906002 WILLIAMSON COUNTY JJAEP   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1398298 TX HIDALGO COUNTY   school 4800211 108807   IDEA PUBLIC SCHOOLS 480021113523 108807037 IDEA BLUFF SPRINGS COLLEGE PREPARA   Regular School Yes Middle 06 10 2021   grade_10                                                   89                                             89
1398512 TX HIDALGO COUNTY   school 4800211 108807   IDEA PUBLIC SCHOOLS 480021113508 108807025 IDEA JUDSON COLLEGE PREPARATORY   Regular School Yes Middle 06 10 2021   grade_10                                                   97                                             97
1398538 TX HIDALGO COUNTY   school 4800211 108807   IDEA PUBLIC SCHOOLS 480021113504 108807026 IDEA MAYS COLLEGE PREPARATORY   Regular School Yes Middle 06 10 2021   grade_10                                                   94                                             94
1398734 TX HIDALGO COUNTY   school 4800211 108807   IDEA PUBLIC SCHOOLS 480021114077 108807096 IDEA SPORTS PARK COLLEGE PREPARATO   Regular School Yes Secondary 09 10 2021   grade_10                                                   42                                             42
1398900 TX DALLAS COUNTY   school 4801440 57848   INTERNATIONAL LEADERSHIP OF TEXAS 480144014101 57848034 ILTEXAS AGGIELAND H S   Regular School Yes Secondary 09 10 2021   grade_10                                                   38                                             38
1399845 TX BEXAR COUNTY   school 4824990 15916   JUDSON ISD 482499007187 15916005 JUDSON CARE ACADEMY   Alternative School No Secondary 09 10 2021   grade_10                                                   <10                                             10
1399992 TX KARNES COUNTY   school 4825140 128901   KARNES CITY ISD 482514011954 128901004 KCISD - DAEP   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1400174 TX HARRIS COUNTY   school 4825170 101914   KATY ISD 482517013663 101914014 JORDAN H S   Regular School No Secondary 09 10 2021   grade_10                                                   <510                                             510
1401422 TX TRAVIS COUNTY   school 4800264 227820   KIPP TEXAS PUBLIC SCHOOLS 480026413986 227820021 KIPP SOMOS H S   Regular School Yes Secondary 09 10 2021   grade_10                                                   116                                             116
1401833 TX HARDIN COUNTY   school 4825920 100903   KOUNTZE ISD 482592008226 100903003 HARDIN CO ALTER ED   Alternative School No Secondary 09 10 2021   grade_10                                                   <10                                             10
1401868 TX DENTON COUNTY   school 4825980 61905   KRUM ISD 482598009212 61905002 DENTON CO J J A E P   Alternative School No Secondary 09 10 2021   grade_10                                                   <10                                             10
1402208 TX HARRIS COUNTY   school 4826190 101916   LA PORTE ISD 482619017032 101916009 HIGHPOINT - DAEP   Alternative School No Secondary 09 10 2021   grade_10                                                   <10                                             10
1403915 TX WILLIAMSON COUNTY   school 4827420 246908   LIBERTY HILL ISD 482742014095 246908007 WILLIAMSON COUNTY CORE   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1405180 TX MONTGOMERY COUNTY   school 4828740 170906   MAGNOLIA ISD 482874008995 170906011 AEP   Alternative School No Secondary 08 10 2021   grade_10                                                   <10                                             10
1405259 TX HENDERSON COUNTY   school 4828780 107906   MALAKOFF ISD 482878007959 107906003 MALAKOFF ALTERNATIVE PROGRAM (MAP)   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1410355 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023513524 14804008 KINGSLAND SCHOOL   Regular School Yes Other KG 10 2021   grade_10                                                   <10                                             10
1411125 TX HILL COUNTY   school 4834560 109914   PENELOPE ISD 483456012428 109914011 HILL COUNTY JJAEP   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1411397 TX TRAVIS COUNTY   school 4834830 227904   PFLUGERVILLE ISD 483483008941 227904008 TRAVIS CO J J A E P   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1411821 TX HALE COUNTY   school 4835070 95905   PLAINVIEW ISD 483507008224 95905004 HALE COUNTY JJAEP   Alternative School No Secondary 07 10 2021   grade_10                                                   <10                                             10
1411913 TX COLLIN COUNTY   school 4835100 43910   PLANO ISD 483510012193 43910011 C A MCMILLEN H S   Regular School No Secondary 09 10 2021   grade_10                                                   642                                             642
1411939 TX COLLIN COUNTY   school 4835100 43910   PLANO ISD 483510005571 43910005 CLARK H S   Regular School No Secondary 09 10 2021   grade_10                                                   655                                             655
1412011 TX COLLIN COUNTY   school 4835100 43910   PLANO ISD 483510010510 43910200 HOSPITAL/HOMEBOUND   Alternative School No Secondary 09 10 2021   grade_10                                                   <10                                             10
1412035 TX COLLIN COUNTY   school 4835100 43910   PLANO ISD 483510007221 43910009 JASPER H S   Regular School No Secondary 09 10 2021   grade_10                                                   710                                             710
1412147 TX COLLIN COUNTY   school 4835100 43910   PLANO ISD 483510006028 43910007 SHEPTON H S   Regular School No Secondary 09 10 2021   grade_10                                                   658                                             658
1412175 TX COLLIN COUNTY   school 4835100 43910   PLANO ISD 483510003974 43910004 VINES H S   Regular School No Secondary 09 10 2021   grade_10                                                   486                                             486
1412190 TX COLLIN COUNTY   school 4835100 43910   PLANO ISD 483510003977 43910003 WILLIAMS H S   Regular School No Secondary 09 10 2021   grade_10                                                   575                                             575
1412253 TX CAMERON COUNTY   school 4835250 31909   POINT ISABEL ISD 483525010479 31909003 CAMERON CO J J A E P   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1412399 TX JEFFERSON COUNTY   school 4835430 123908   PORT NECHES-GROVES ISD 483543008310 123908003 JEFFERSON CO J J A E P   Alternative School No Middle 06 10 2021   grade_10                                                   <10                                             10
1414302 TX BELL COUNTY   school 4837710 14907   ROGERS ISD 483771012091 14907043 BELL COUNTY DAEP   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1414342 TX STARR COUNTY   school 4837740 214903   ROMA ISD 483774007108 214903003 INSTRUCTIONAL & GUIDANCE CENTER   Alternative School No Secondary 09 10 2021   grade_10                                                   <10                                             10
1415272 TX BEXAR COUNTY   school 4838730 15907   SAN ANTONIO ISD 483873013894 15907028 CAST MED H S   Regular School Yes Secondary 09 10 2021   grade_10                                                   100                                             100
1415301 TX BEXAR COUNTY   school 4838730 15907   SAN ANTONIO ISD 483873002915 15907184 CHRISTUS SANTA ROSA   Alternative School No Other 01 10 2021   grade_10                                                   <10                                             10
1416254 TX CAMERON COUNTY   school 4839330 31913   SANTA MARIA ISD 483933009156 31913005 SANTA MARIA DAEP   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1416627 TX GUADALUPE COUNTY   school 4839690 94901   SEGUIN ISD 483969004070 94901111 DISCIPLINE ALTERNATIVE SCHOOL AT S   Alternative School No Secondary 07 10 2021   grade_10                                                   <10                                             10
1416733 TX LUBBOCK COUNTY   school 4839870 152909   SHALLOWATER ISD 483987009334 152909003 DAEP   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1417135 TX LUBBOCK COUNTY   school 4840440 152903   SLATON ISD 484044013610 152903008 SLATON ISD DAEP   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1417679 TX BEXAR COUNTY   school 4840680 15908   SOUTH SAN ANTONIO ISD 484068014086 15908006 SOUTH SAN ANTONIO H S - WEST CAMPU   Regular School No Secondary 09 10 2021   grade_10                                                   29                                             29
1417968 TX MONTGOMERY COUNTY   school 4841070 170907   SPLENDORA ISD 484107008002 170907010 JUVENILE JUSTICE ALTERNATIVE EDUCA   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1419371 TX GALVESTON COUNTY   school 4842510 84906   TEXAS CITY ISD 484251007611 84906010 TEXAS CITY J J A E P   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1419401 TX TAYLOR COUNTY   school 4800163 221801   TEXAS COLLEGE PREPARATORY ACADEMIE 480016312148 221801023 CARROLLTON CLASSICAL ACADEMY   Regular School Yes Other KG 10 2021   grade_10                                                   <10                                             10
1419483 TX TAYLOR COUNTY   school 4800163 221801   TEXAS COLLEGE PREPARATORY ACADEMIE 480016313683 221801068 FOUNDERS CLASSICAL ACADEMY - FRISC   Regular School Yes Other KG 10 2021   grade_10                                                   36                                             36
1419507 TX TAYLOR COUNTY   school 4800163 221801   TEXAS COLLEGE PREPARATORY ACADEMIE 480016313318 221801063 FOUNDERS CLASSICAL ACADEMY OF FLOW   Regular School Yes Other KG 10 2021   grade_10                                                   35                                             35
1419723 TX TOM GREEN COUNTY   school 4801409 226801   TEXAS LEADERSHIP PUBLIC SCHOOLS 480140913213 226801004 TEXAS LEADERSHIP OF ABILENE   Regular School Yes Other KG 10 2021   grade_10                                                   14                                             14
1420282 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913143 46802008 CARSON PARKE   Alternative School Yes Secondary 07 10 2021   grade_10                                                   <10                                             10
1420381 TX DENTON COUNTY   school 4801456 61805   TRIVIUM ACADEMY 480145613454 61805001 TRIVIUM ACADEMY   Regular School Yes Other KG 10 2021   grade_10                                                   18                                             18
1421088 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007108932 227806009 PATHFINDER CAMP   Alternative School Yes Middle 05 10 2021   grade_10                                                   <10                                             10
1421346 TX DALLAS COUNTY   school 4800030 57803   UPLIFT EDUCATION 480003014097 57803019 WISDOM H S   Regular School Yes Secondary 09 10 2021   grade_10                                                   69                                             69
1421543 TX TRAVIS COUNTY   school 4801461 227829   VALOR PUBLIC SCHOOLS 480146113593 227829001 VALOR SOUTH AUSTIN   Regular School Yes Other KG 10 2021   grade_10                                                   19                                             19
1421607 TX HIDALGO COUNTY   school 4800195 108808   VANGUARD ACADEMY 480019513536 108808105 VANGUARD BEETHOVEN   Regular School Yes Other PK 10 2021   grade_10                                                   41                                             41
1421988 TX MCLENNAN COUNTY   school 4844280 161914   WACO ISD 484428007039 161914005 G L WILEY OPPORTUNITY CENTER   Alternative School No Middle 06 10 2021   grade_10                                                   <10                                             10
1422623 TX HARDIN COUNTY   school 4845000 100908   WEST HARDIN COUNTY CISD 484500009255 100908003 HARDIN CO ALTERNATIVE AEP   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1422870 TX TARRANT COUNTY   school 4845540 220920   WHITE SETTLEMENT ISD 484554008046 220920004 TARRANT CO J J A E P   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1423339 TX RUNNELS COUNTY   school 4846260 200904   WINTERS ISD 484626013966 200904005 WINTERS/FAIRVIEW DAEP   Alternative School No Secondary 09 10 2021   grade_10                                                   <10                                             10
1613440 TX BEXAR COUNTY   school 4807590 15901   ALAMO HEIGHTS ISD 480759007509 15901002 BEXAR CO J J A E P   Alternative School No Secondary 07 10 2020   grade_10                                                   <10                                             10
1613631 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771010723 101902098 HIGHPOINT   Alternative School No Middle 06 10 2020   grade_10                                                   <10                                             10
1614336 TX JOHNSON COUNTY   school 4800011 126901   ALVARADO ISD 480001110855 126901003 JUVENILE JUSTICE ALTERNATIVE   Alternative School No Secondary 10 10 2020   grade_10                                                   <10                                             10
1615542 TX TARRANT COUNTY   school 4808700 220901   ARLINGTON ISD 480870007110 220901008 NEWCOMER CENTER   Alternative School No Secondary 07 10 2020   grade_10                                                   99                                             99
1616227 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894011057 227901029 INTERNATIONAL H S   Alternative School No Secondary 09 10 2020   grade_10                                                   144                                             144
1617446 TX HARRIS COUNTY   school 4801446 101870   BETA ACADEMY 480144613188 101870001 BETA ACADEMY   Regular School Yes Other PK 10 2020   grade_10                                                   21                                             21
1618314 TX BRAZORIA COUNTY   school 4811190 20905   BRAZOSPORT ISD 481119008710 20905005 LIGHTHOUSE LEARNING CENTER - JJAEP   Alternative School No Secondary 07 10 2020   grade_10                                                   <10                                             10
1618978 TX MCLENNAN COUNTY   school 4811730 161919   BRUCEVILLE-EDDY ISD 481173007994 161919002 AXTELL/BRUCEVILLE-EDDY LEARNING CE   Alternative School No Secondary 10 10 2020   grade_10                                                   <10                                             10
1621111 TX JOHNSON COUNTY   school 4814310 126903   CLEBURNE ISD 481431008680 126903004 J J A E P   Alternative School No Secondary 10 10 2020   grade_10                                                   <10                                             10
1621793 TX ECTOR COUNTY   school 4801417 68802   COMPASS ACADEMY CHARTER SCHOOL 480141712503 68802001 COMPASS ACADEMY CHARTER SCHOOL   Regular School Yes Other KG 10 2020   grade_10                                                   65                                             65
1623077 TX TARRANT COUNTY   school 4815910 220912   CROWLEY ISD 481591001157 220912041 H F STEVENS MIDDLE   Regular School No Secondary 07 10 2020   grade_10                                                   <10                                             10
1625685 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674007581 61901006 DENTON CO J J A E P   Alternative School No Secondary 08 10 2020   grade_10                                                   <10                                             10
1626060 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707012502 84901014 COASTAL ALTERNATIVE PROGRAM (CAP)   Alternative School No Secondary 09 10 2020   grade_10                                                   <10                                             10
1626989 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785012320 15911006 WILSON COUNTY BOOT CAMP   Alternative School No Secondary 09 10 2020   grade_10                                                   <10                                             10
1627429 TX BEXAR COUNTY   school 4818150 15905   EDGEWOOD ISD 481815013735 15905015 STEAM AT THE FINE ARTS ACADEMY   Regular School No Secondary 09 10 2020   grade_10                                                   84                                             84
1627591 TX HIDALGO COUNTY   school 4818180 108904   EDINBURG CISD 481818007651 108904039 J J A E P   Alternative School No Secondary 07 10 2020   grade_10                                                   <10                                             10
1628323 TX BASTROP COUNTY   school 4818360 11902   ELGIN ISD 481836010392 11902003 BASTROP COUNTY JUVENILE BOOT CAMP   Alternative School No Secondary 07 10 2020   grade_10                                                   <10                                             10
1628665 TX KARNES COUNTY   school 4819020 128904   FALLS CITY ISD 481902011482 128904003 WILSON CO J J A E P   Alternative School No Secondary 10 10 2020   grade_10                                                   <10                                             10
1629809 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970013388 220905087 IM TERRELL ACADEMY FOR STEM AND VP   Regular School No Secondary 09 10 2020   grade_10                                                   136                                             136
1631725 TX HARRIS COUNTY   school 4800020 101804   GEORGE I SANCHEZ CHARTER 480002013387 101804004 GEORGE I SANCHEZ NORTH   Alternative School Yes Middle 06 10 2020   grade_10                                                   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]);