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,819
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
1374432 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2021   grade_8                                                   17                                             17
1374460 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009497 221901008 JUVENILE DETENTION CENTER   Alternative School No Secondary 07 11 2021   grade_8                                                   <10                                             10
1374484 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744011037 221901142 OCEANS BEHAVIORAL HEALTH   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1374523 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007123 221901003 WOODSON CENTER FOR EXCELLENCE   Alternative School No High 06 12 2021   grade_8                                                   11                                             11
1374531 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009308164 57814001 DALLAS COUNTY JUVENILE JUSTICE   Alternative School Yes High 05 12 2021   grade_8                                                   21                                             21
1374538 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312005 57814005 LETOT CAMPUS   Alternative School Yes Secondary 08 11 2021   grade_8                                                   <10                                             10
1374543 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312112 57814003 MEDLOCK YOUTH VILLAGE   Alternative School Yes High 07 12 2021   grade_8                                                   <10                                             10
1374813 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771012521 101902013 HALL SUCCESS ACADEMY   Alternative School No High 08 12 2021   grade_8                                                   11                                             11
1375098 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_8                                                   <10                                             10
1375100 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783008599 101903005 ALIEF LEARNING CTR (6-12)   Alternative School No Secondary 08 09 2021   grade_8                                                   <10                                             10
1376133 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831007814 20902004 BRAZORIA CO JUVENILE DETENTION   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1376177 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831006642 20902002 STUDENT ALTERNATIVE CTR   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1376320 TX SAN PATRICIO COUNTY   school 4808580 205901   ARANSAS PASS ISD 480858009519 205901002 ARANSAS PASS JJAEP   Alternative School No Middle 08 08 2021   grade_8                                                   <10                                             10
1376722 TX TARRANT COUNTY   school 4808700 220901   ARLINGTON ISD 480870007110 220901008 NEWCOMER CENTER   Alternative School No Secondary 07 10 2021   grade_8                                                   <40                                             40
1376863 TX TARRANT COUNTY   school 4808700 220901   ARLINGTON ISD 480870005792 220901007 TURNING POINT SECONDARY SCHOOL   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1377081 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894009076 227901012 ALTERNATIVE LEARNING CENTER   Alternative School No Secondary 07 11 2021   grade_8                                                   <10                                             10
1377104 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005646 227901250 AUSTIN ST HOSPITAL   Alternative School No High 05 12 2021   grade_8                                                   <10                                             10
1377454 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894007137 227901035 LEADERSHIP ACADEMY   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1377668 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894011354 227901028 RICHARDS SCH FOR YOUNG WOMEN LEADE   Alternative School No High 06 12 2021   grade_8                                                   153                                             153
1377696 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005396 227901251 ROSEDALE   Alternative School No Other PK 12 2021   grade_8                                                   <10                                             10
1377739 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894009077 227901030 TRAVIS COUNTY JUVENILE DETENTION C   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1377896 TX MCLENNAN COUNTY   school 4809150 161918   AXTELL ISD 480915006358 161918199 WACO CTR FOR YOUTH   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1378649 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022709011 193801001 BIG SPRINGS CHARTER SCHOOL   Alternative School Yes Other KG 12 2021   grade_8                                                   13                                             13
1378662 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022711321 193801101 HILL COUNTRY YOUTH RANCH   Alternative School Yes Other KG 12 2021   grade_8                                                   14                                             14
1379286 TX OLDHAM COUNTY   school 4811040 180901   BOYS RANCH ISD 481104005141 180901041 BLAKEMORE MIDDLE   Alternative School No Middle 06 08 2021   grade_8                                                   16                                             16
1379349 TX SOMERVELL COUNTY   school 4800214 213801   BRAZOS RIVER CHARTER SCHOOL 480021408907 213801001 BRAZOS RIVER CHARTER SCHOOL   Alternative School Yes Other KG 12 2021   grade_8                                                   23                                             23
1379424 TX BRAZORIA COUNTY   school 4811190 20905   BRAZOSPORT ISD 481119007528 20905004 LIGHTHOUSE LEARNING CENTER - DAEP   Alternative School No Other 04 12 2021   grade_8                                                   10                                             10
1379772 TX CAMERON COUNTY   school 4811680 31901   BROWNSVILLE ISD 481168007541 31901034 CAMERON CO J J A E P   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1380072 TX MCLENNAN COUNTY   school 4811730 161919   BRUCEVILLE-EDDY ISD 481173011401 161919005 AXTELL/BE DAEP   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1380118 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179008456 21902014 BRAZOS CO JUVENILE DETENTION CENTE   Alternative School No Other 04 12 2021   grade_8                                                   <10                                             10
1380136 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179007816 21902012 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1380340 TX WICHITA COUNTY   school 4812120 243901   BURKBURNETT ISD 481212011089 243901003 WICHITA CO JJAEP   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1380667 TX COOKE COUNTY   school 4812510 49905   CALLISBURG ISD 481251012652 49905002 DAEP   Alternative School No Secondary 08 09 2021   grade_8                                                   <10                                             10
1380690 TX HARRIS COUNTY   school 4800124 101837   CALVIN NELMS CHARTER SCHOOLS 480012409258 101837041 CALVIN NELMS MIDDLE   Alternative School Yes Middle 06 08 2021   grade_8                                                   36                                             36
1380882 TX RANDALL COUNTY   school 4812810 191901   CANYON ISD 481281005172 191901003 YOUTH CTR OF HIGH PLAINS   Alternative School No High 06 12 2021   grade_8                                                   11                                             11
1381062 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305005854 57903117 HUIE SPECIAL EDUC CTR   Alternative School No Other PK 12 2021   grade_8                                                   <10                                             10
1381155 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305007241 57903005 SALAZAR DISTRICT ALTERNATIVE EDUCA   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1381237 TX TARRANT COUNTY   school 4813170 220917   CASTLEBERRY ISD 481317007446 220917004 T R U C E LEARNING CTR   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1381411 TX KERR COUNTY   school 4813350 133901   CENTER POINT ISD 481335013963 133901004 NORTH STAR H S   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1381957 TX GALVESTON COUNTY   school 4814280 84910   CLEAR CREEK ISD 481428009498 84910008 CLEAR PATH ALTERNATIVE SCHOOL   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1382217 TX LIBERTY COUNTY   school 4814370 146901   CLEVELAND ISD 481437007381 146901003 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1382619 TX COMAL COUNTY   school 4814730 46902   COMAL ISD 481473012361 46902206 COMAL DISCIPLINE CENTER   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1382809 TX COLLIN COUNTY   school 4814850 43918   COMMUNITY ISD 481485010523 43918003 BRAVES ACADEMY   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1382887 TX HARRIS COUNTY   school 4800127 101842   COMQUEST ACADEMY 480012708255 101842001 COMQUEST ACADEMY   Alternative School Yes Other KG 12 2021   grade_8                                                   <10                                             10
1383077 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500017045 170902010 JJAEP   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1383083 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500007998 170902201 JUVENILE DETENTION CTR   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1383446 TX NUECES COUNTY   school 4815270 178904   CORPUS CHRISTI ISD 481527006082 178904009 COLES H S AND EDUCATIONAL CENTER   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1384026 TX HARRIS COUNTY   school 4815750 101906   CROSBY ISD 481575010727 101906105 HIGHPOINT SCHOOL EAST (CROSBY)   Alternative School No Middle 08 08 2021   grade_8                                                   <10                                             10
1385031 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623007244 57905011 BARBARA M MANNS MIDDLE DAEP   Alternative School No Middle 08 08 2021   grade_8                                                   <10                                             10
1385479 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006391 57905099 HOSPITAL/HOMEBOUND   Alternative School No Other KG 12 2021   grade_8                                                   <10                                             10
1385665 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623010565 57905096 JUVENILE JUSTICE AEP   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1385843 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006965 57905030 MAYA ANGELOU H S   Alternative School No Secondary 07 10 2021   grade_8                                                   <10                                             10
1386819 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674003735 61901040 JOE DALE SPARKS CAMPUS   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1386825 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674007265 61901005 LESTER DAVIS   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1387111 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707012520 84901009 DICKINSON CONTINUATION CENTER   Alternative School No High 08 12 2021   grade_8                                                   12                                             12
1387127 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707007290 84901012 GALVESTON CO DETENTION CTR   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1387131 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707007889 84901010 GALVESTON CO J J A E P   Alternative School No Secondary 08 09 2021   grade_8                                                   <10                                             10
1387302 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739007961 108902003 HIDALGO CO J J A E P   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1387402 TX NUECES COUNTY   school 4800025 178801   DR M L GARZA-GONZALEZ CHARTER SCHO 480002507411 178801001 DR M L GARZA-GONZALEZ CHARTER SCHO   Alternative School Yes Elementary PK 08 2021   grade_8                                                   20                                             20
1387412 TX HARRIS COUNTY   school 4800263 101856   DRAW ACADEMY 480026310720 101856101 DRAW ACADEMY   Alternative School Yes Elementary PK 08 2021   grade_8                                                   57                                             57
1387586 TX DALLAS COUNTY   school 4817640 57907   DUNCANVILLE ISD 481764007255 57907007 P A S S LEARNING CTR   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1387605 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770007447 220918003 ALTER DISCIPLINE CAMPUS   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1387956 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785007517 15911005 BEXAR COUNTY LRN CTR   Alternative School No Secondary 07 11 2021   grade_8                                                   <10                                             10
1388071 TX ECTOR COUNTY   school 4818000 68901   ECTOR COUNTY ISD 481800001596 68901004 ALTER ED CTR   Alternative School No Secondary 06 11 2021   grade_8                                                   <10                                             10
1388134 TX ECTOR COUNTY   school 4818000 68901   ECTOR COUNTY ISD 481800016986 68901005 ECTOR CO YOUTH CTR   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1388623 TX HIDALGO COUNTY   school 4818180 108904   EDINBURG CISD 481818007651 108904039 J J A E P   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1388641 TX HIDALGO COUNTY   school 4818180 108904   EDINBURG CISD 481818006693 108904040 JUVENILE DETENTION CTR   Alternative School No Secondary 07 11 2021   grade_8                                                   <10                                             10
1388963 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830003812 71902025 DELTA ACADEMY   Alternative School No Middle 05 11 2021   grade_8                                                   <10                                             10
1389236 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830006945 71902027 TELLES ACADEMY   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1389445 TX ERATH COUNTY   school 4800159 72802   ERATH EXCELS ACADEMY INC 480015912097 72802002 COASTAL HORIZONS ACADEMY   Alternative School Yes High 07 12 2021   grade_8                                                   <10                                             10
1389582 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004907909 101811001 HARRIS COUNTY JUVENILE DETENTION C   Alternative School Yes High 07 12 2021   grade_8                                                   16                                             16
1389589 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908231 101811004 HARRIS COUNTY YOUTH VILLAGE   Alternative School Yes High 06 12 2021   grade_8                                                   <10                                             10
1389595 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908233 101811006 LEADERSHIP ACADEMY   Alternative School Yes High 07 12 2021   grade_8                                                   <10                                             10
1389772 TX FAYETTE COUNTY   school 4819280 75901   FLATONIA ISD 481928012888 75901103 WHISPERING HILLS ACHIEVEMENT CENTE   Alternative School No Other 04 12 2021   grade_8                                                   <10                                             10
1389819 TX WILSON COUNTY   school 4819350 247901   FLORESVILLE ISD 481935008091 247901003 WILSON CO J J A E P   Alternative School No Secondary 07 11 2021   grade_8                                                   <10                                             10
1389836 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_8                                                   <10                                             10
1390111 TX FORT BEND COUNTY   school 4819650 79907   FORT BEND ISD 481965007605 79907010 FORT BEND CO ALTER   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1390504 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970007724 220905251 ASSESSMENT CTR   Alternative School No Elementary KG 08 2021   grade_8                                                   <10                                             10
1390550 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001832 220905104 BOULEVARD HEIGHTS   Alternative School No Other KG 12 2021   grade_8                                                   <10                                             10
1390556 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021058 220905212 BRIDGE ASSOC   Alternative School No Secondary 07 11 2021   grade_8                                                   <10                                             10
1390618 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021056 220905210 CHILDREN'S MEDICAL CTR   Alternative School No Other KG 12 2021   grade_8                                                   <10                                             10
1390691 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005469 220905024 DETENT CTR   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1390812 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005395 220905062 INT'L NEWCOMER ACAD   Alternative School No Middle 06 09 2021   grade_8                                                   27                                             27
1390840 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005717 220905026 JO KELLY SP ED   Alternative School No Other PK 12 2021   grade_8                                                   <10                                             10
1390854 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970009035 220905040 JUVENILE JUSTICE ALTERNATIVE ED PR   Alternative School No High 07 12 2021   grade_8                                                   <10                                             10
1391177 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970008371 220905242 TARRANT YOUTH RECOVERY   Alternative School No Secondary 07 11 2021   grade_8                                                   <10                                             10
1391287 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021057 220905211 WOMEN'S HAVEN   Alternative School No Other KG 09 2021   grade_8                                                   <10                                             10
1392109 TX GALVESTON COUNTY   school 4820280 84902   GALVESTON ISD 482028012288 84902007 AIM COLLEGE & CAREER PREP   Alternative School No High 06 12 2021   grade_8                                                   14                                             14
1392700 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001410415 15802004 RUTH JONES MCCLENDON MIDDLE   Alternative School Yes High 06 12 2021   grade_8                                                   19                                             19
1392707 TX HARRIS COUNTY   school 4800020 101804   GEORGE I SANCHEZ CHARTER 480002007304 101804001 GEORGE I SANCHEZ CHARTER   Alternative School Yes Other PK 12 2021   grade_8                                                   82                                             82
1392714 TX HARRIS COUNTY   school 4800020 101804   GEORGE I SANCHEZ CHARTER 480002013387 101804004 GEORGE I SANCHEZ NORTH   Alternative School Yes Secondary 06 11 2021   grade_8                                                   53                                             53
1392776 TX WILLIAMSON COUNTY   school 4820600 246904   GEORGETOWN ISD 482060007097 246904003 GEORGETOWN ALTER PROG   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1393157 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115010738 101911012 HIGH POINT SCHOOL   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1393201 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115008605 101911006 POINT ALTERNATIVE CENTER   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1393510 TX DALLAS COUNTY   school 4821420 57910   GRAND PRAIRIE ISD 482142006970 57910004 LYNDON B JOHNSON DAEP   Alternative School No High 06 12 2021   grade_8                                                   <10                                             10
1393622 TX VAN ZANDT COUNTY   school 4821450 234904   GRAND SALINE ISD 482145008069 234904002 VAN ZANDT CO YOUTH MULTI-SERVICE C   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1393678 TX TOM GREEN COUNTY   school 4821600 226907   GRAPE CREEK ISD 482160008930 226907005 FAIRVIEW DAEP   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1394173 TX HARRISON COUNTY   school 4822170 102904   HALLSVILLE ISD 482217012918 102904010 TEXAS VIRTUAL ACADEMY AT HALLSVILL   Alternative School No Other 03 12 2021   grade_8                                                   1241                                             1241
1394285 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247007175 15904007 BEXAR CO J J A E P   Alternative School No Secondary 08 11 2021   grade_8                                                   <10                                             10
1394345 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247007799 15904045 HAC DAEP MIDDLE   Alternative School No Middle 07 08 2021   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]);