Data source: Big Local News · About: Big Local

2,217 rows where grade = "grade_10", state = "TX" and year = 2020 sorted by ccd_school_type

View and edit SQL

year

  • 2020 · 2,217

grade

  • grade_10 · 2,217
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
1613229 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2020   grade_10                                                   <10                                             10
1613256 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009497 221901008 JUVENILE DETENTION CENTER   Alternative School No Secondary 08 11 2020   grade_10                                                   <10                                             10
1613320 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007123 221901003 WOODSON CENTER FOR EXCELLENCE   Alternative School No High 08 12 2020   grade_10                                                   28                                             28
1613327 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009308164 57814001 DALLAS COUNTY JUVENILE JUSTICE   Alternative School Yes High 06 12 2020   grade_10                                                   56                                             56
1613333 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312248 57814002 DRC CAMPUS   Alternative School Yes Secondary 07 11 2020   grade_10                                                   12                                             12
1613338 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312005 57814005 LETOT CAMPUS   Alternative School Yes High 07 12 2020   grade_10                                                   <10                                             10
1613345 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312112 57814003 MEDLOCK YOUTH VILLAGE   Alternative School Yes High 06 12 2020   grade_10                                                   23                                             23
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
1613470 TX WOOD COUNTY   school 4807650 250906   ALBA-GOLDEN ISD 480765007158 250906002 ALTER SCHOOL   Alternative School No Secondary 09 11 2020   grade_10                                                   <10                                             10
1613619 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771012521 101902013 HALL CENTER FOR EDUCATION   Alternative School No High 09 12 2020   grade_10                                                   51                                             51
1613631 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771010723 101902098 HIGHPOINT   Alternative School No Middle 06 10 2020   grade_10                                                   <10                                             10
1613910 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783008805 101903047 ALIEF ISD J J A E P   Alternative School No Secondary 06 11 2020   grade_10                                                   <10                                             10
1613915 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783008599 101903005 ALIEF LEARNING CTR (6-12)   Alternative School No High 07 12 2020   grade_10                                                   16                                             16
1613971 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783011510 101903011 CROSSROADS   Alternative School No High 09 12 2020   grade_10                                                   20                                             20
1614172 TX COLLIN COUNTY   school 4807890 43901   ALLEN ISD 480789007551 43901003 COLLIN CO J J A E P   Alternative School No High 10 12 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
1614389 TX BRAZORIA COUNTY   school 4808090 20901   ALVIN ISD 480809008709 20901004 BRAZORIA CO J J A E P   Alternative School No High 07 12 2020   grade_10                                                   <10                                             10
1614696 TX POTTER COUNTY   school 4808130 188901   AMARILLO ISD 480813000167 188901138 NORTH HEIGHTS ALTER   Alternative School No High 09 12 2020   grade_10                                                   61                                             61
1614932 TX ANDREWS COUNTY   school 4808280 2901   ANDREWS ISD 480828007502 2901002 ANDREWS EDUCATION CENTER   Alternative School No High 09 12 2020   grade_10                                                   13                                             13
1614960 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831016825 20902003 BRAZORIA CO ALTER ED CTR   Alternative School No High 06 12 2020   grade_10                                                   <10                                             10
1614967 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831007814 20902004 BRAZORIA CO JUVENILE DETENTION   Alternative School No High 05 12 2020   grade_10                                                   12                                             12
1615008 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831006642 20902002 STUDENT ALTERNATIVE CTR   Alternative School No High 06 12 2020   grade_10                                                   <10                                             10
1615026 TX COLLIN COUNTY   school 4808340 43902   ANNA ISD 480834013928 43902005 ANNA ISD DAEP   Alternative School No High 07 12 2020   grade_10                                                   <10                                             10
1615244 TX TARRANT COUNTY   school 4808700 220901   ARLINGTON ISD 480870013043 220901011 ARLINGTON COLLEGIATE H S   Alternative School No High 09 12 2020   grade_10                                                   109                                             109
1615542 TX TARRANT COUNTY   school 4808700 220901   ARLINGTON ISD 480870007110 220901008 NEWCOMER CENTER   Alternative School No Secondary 07 10 2020   grade_10                                                   99                                             99
1615672 TX TARRANT COUNTY   school 4808700 220901   ARLINGTON ISD 480870008024 220901010 TARRANT CO J J A E P   Alternative School No Secondary 09 11 2020   grade_10                                                   <10                                             10
1615685 TX TARRANT COUNTY   school 4808700 220901   ARLINGTON ISD 480870005792 220901007 TURNING POINT SECONDARY SCHOOL   Alternative School No High 07 12 2020   grade_10                                                   28                                             28
1615689 TX TARRANT COUNTY   school 4808700 220901   ARLINGTON ISD 480870007066 220901006 VENTURE ALTER H S   Alternative School No High 09 12 2020   grade_10                                                   73                                             73
1615901 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894009076 227901012 ALTERNATIVE LEARNING CENTER   Alternative School No High 06 12 2020   grade_10                                                   <10                                             10
1615928 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005646 227901250 AUSTIN ST HOSPITAL   Alternative School No Other 01 12 2020   grade_10                                                   <10                                             10
1616142 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894008060 227901015 GARZA INDEPENDENCE H S   Alternative School No High 10 12 2020   grade_10                                                   <10                                             10
1616157 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894012824 227901026 GRADUATION PREP ACADEMY NAVARRO   Alternative School Yes High 09 12 2020   grade_10                                                   17                                             17
1616161 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894012864 227901025 GRADUATION PREP ACADEMY TRAVIS   Alternative School Yes High 09 12 2020   grade_10                                                   <20                                             20
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
1616284 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894007137 227901035 LEADERSHIP ACADEMY   Alternative School No High 08 12 2020   grade_10                                                   <10                                             10
1616474 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894008389 227901032 PHOENIX ACADEMY   Alternative School No High 08 12 2020   grade_10                                                   <10                                             10
1616512 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894011354 227901028 RICHARDS SCH FOR YOUNG WOMEN LEADE   Alternative School No High 06 12 2020   grade_10                                                   120                                             120
1616540 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005396 227901251 ROSEDALE   Alternative School No Other PK 12 2020   grade_10                                                   <10                                             10
1616589 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894012204 227901027 TRAVIS COUNTY DAY SCHOOL   Alternative School No Secondary 08 11 2020   grade_10                                                   <10                                             10
1616596 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894009077 227901030 TRAVIS COUNTY JUVENILE DETENTION C   Alternative School No High 06 12 2020   grade_10                                                   11                                             11
1616762 TX MCLENNAN COUNTY   school 4809150 161918   AXTELL ISD 480915006358 161918199 WACO CTR FOR YOUTH   Alternative School No High 07 12 2020   grade_10                                                   17                                             17
1616772 TX TARRANT COUNTY   school 4809200 220915   AZLE ISD 480920012892 220915003 AZLE HORNET ACADEMY   Alternative School No High 09 12 2020   grade_10                                                   15                                             15
1616846 TX RUNNELS COUNTY   school 4809300 200901   BALLINGER ISD 480930012897 200901005 FAIRVIEW ACCELERATED (DAEP)   Alternative School No High 07 12 2020   grade_10                                                   <10                                             10
1616918 TX CHAMBERS COUNTY   school 4809450 36902   BARBERS HILL ISD 480945011547 36902005 ALTERNATIVE SCHOOL   Alternative School No High 07 12 2020   grade_10                                                   <10                                             10
1617019 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957021082 11901022 GENESIS H S   Alternative School No High 09 12 2020   grade_10                                                   <20                                             20
1617164 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967007364 123910011 JEFFERSON CO YOUTH ACAD   Alternative School No Secondary 06 11 2020   grade_10                                                   <10                                             10
1617187 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967006510 123910006 PATHWAYS LEARNING CTR   Alternative School No High 06 12 2020   grade_10                                                   13                                             13
1617191 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967007976 123910012 PAUL A BROWN ALTERNATIVE CENTER   Alternative School No High 09 12 2020   grade_10                                                   21                                             21
1617312 TX BELL COUNTY   school 4809860 14903   BELTON ISD 480986008100 14903006 BELL CO J J A E P   Alternative School No Secondary 09 11 2020   grade_10                                                   <10                                             10
1617520 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022709011 193801001 BIG SPRINGS CHARTER SCHOOL   Alternative School Yes Other KG 12 2020   grade_10                                                   12                                             12
1617533 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022711321 193801101 HILL COUNTRY YOUTH RANCH   Alternative School Yes Other KG 12 2020   grade_10                                                   14                                             14
1617674 TX TARRANT COUNTY   school 4810230 220902   BIRDVILLE ISD 481023013066 220902012 SHANNON H S   Alternative School No High 09 12 2020   grade_10                                                   <30                                             30
1618152 TX OLDHAM COUNTY   school 4811040 180901   BOYS RANCH ISD 481104000571 180901001 BOYS RANCH H S   Alternative School No High 09 12 2020   grade_10                                                   45                                             45
1618211 TX AUSTIN COUNTY   school 4844470 8903   BRAZOS ISD 484447013001 8903103 PRAIRIE HARBOR ALTERNATIVE SCHOOL   Alternative School No High 06 12 2020   grade_10                                                   <10                                             10
1618224 TX SOMERVELL COUNTY   school 4800214 213801   BRAZOS RIVER CHARTER SCHOOL 480021408907 213801001 BRAZOS RIVER CHARTER SCHOOL   Alternative School Yes Other KG 12 2020   grade_10                                                   33                                             33
1618260 TX BRAZORIA COUNTY   school 4811190 20905   BRAZOSPORT ISD 481119008711 20905006 BRAZOS SUCCESS ACADEMY   Alternative School No High 09 12 2020   grade_10                                                   <30                                             30
1618309 TX BRAZORIA COUNTY   school 4811190 20905   BRAZOSPORT ISD 481119007528 20905004 LIGHTHOUSE LEARNING CENTER - DAEP   Alternative School No High 05 12 2020   grade_10                                                   11                                             11
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
1618516 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155013724 25908003 GENESIS CAMPUS   Alternative School No High 06 12 2020   grade_10                                                   <10                                             10
1618576 TX TERRY COUNTY   school 4811610 223901   BROWNFIELD ISD 481161012078 223901005 BROWNFIELD EDUCATION CENTER   Alternative School No High 09 12 2020   grade_10                                                   <10                                             10
1618667 TX CAMERON COUNTY   school 4811680 31901   BROWNSVILLE ISD 481168007541 31901034 CAMERON CO J J A E P   Alternative School No Other 04 12 2020   grade_10                                                   <10                                             10
1618946 TX BROWN COUNTY   school 4811700 25902   BROWNWOOD ISD 481170011156 25902003 BROWNWOOD ACCELERATED H S   Alternative School No High 09 12 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
1619022 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179008456 21902014 BRAZOS CO JUVENILE DETENTION CENTE   Alternative School No Other 04 12 2020   grade_10                                                   10                                             10
1619028 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179009145 21902015 BRAZOS COUNTY JJAEP   Alternative School No Secondary 06 11 2020   grade_10                                                   <10                                             10
1619044 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179007816 21902012 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No High 07 12 2020   grade_10                                                   18                                             18
1619126 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179011886 21902017 THE MARY CATHERINE HARRIS SCHOOL-S   Alternative School No High 07 12 2020   grade_10                                                   <30                                             30
1619227 TX WICHITA COUNTY   school 4812120 243901   BURKBURNETT ISD 481212007480 243901002 GATEWAY STUDENT SUPPORT CTR   Alternative School No High 10 12 2020   grade_10                                                   <10                                             10
1619247 TX WICHITA COUNTY   school 4812120 243901   BURKBURNETT ISD 481212011089 243901003 WICHITA CO JJAEP   Alternative School No Secondary 07 11 2020   grade_10                                                   <10                                             10
1619290 TX JOHNSON COUNTY   school 4812180 126902   BURLESON ISD 481218007978 126902003 CROSSROADS H S   Alternative School No High 09 12 2020   grade_10                                                   <20                                             20
1619387 TX BURNET COUNTY   school 4812220 27903   BURNET CISD 481222003287 27903003 QUEST H S   Alternative School No High 09 12 2020   grade_10                                                   10                                             10
1619535 TX CALHOUN COUNTY   school 4812480 29901   CALHOUN COUNTY ISD 481248007199 29901003 HOPE H S   Alternative School No High 09 12 2020   grade_10                                                   <10                                             10
1619580 TX COOKE COUNTY   school 4812510 49905   CALLISBURG ISD 481251012652 49905002 DAEP   Alternative School No Secondary 10 11 2020   grade_10                                                   <10                                             10
1619597 TX HARRIS COUNTY   school 4800124 101837   CALVIN NELMS CHARTER SCHOOLS 480012408248 101837001 CALVIN NELMS H S   Alternative School Yes High 09 12 2020   grade_10                                                   41                                             41
1619799 TX RANDALL COUNTY   school 4812810 191901   CANYON ISD 481281005172 191901003 YOUTH CTR OF HIGH PLAINS   Alternative School No High 06 12 2020   grade_10                                                   <10                                             10
1619920 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305007563 57903009 DALLAS COUNTY JJAEP CFB CAMPUS   Alternative School No Secondary 08 11 2020   grade_10                                                   <10                                             10
1619929 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305008510 57903008 DENTON COUNTY JJAEP CFB CAMPUS   Alternative School No High 09 12 2020   grade_10                                                   <10                                             10
1619972 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305005671 57903003 GRIMES EDUCATION CENTER   Alternative School No High 09 12 2020   grade_10                                                   <10                                             10
1620076 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305007241 57903005 SALAZAR DISTRICT ALTERNATIVE EDUCA   Alternative School No Other 03 12 2020   grade_10                                                   14                                             14
1620153 TX TARRANT COUNTY   school 4813170 220917   CASTLEBERRY ISD 481317007121 220917003 REACH H S   Alternative School No High 09 12 2020   grade_10                                                   <10                                             10
1620160 TX TARRANT COUNTY   school 4813170 220917   CASTLEBERRY ISD 481317007446 220917004 T R U C E LEARNING CTR   Alternative School No Secondary 06 11 2020   grade_10                                                   <10                                             10
1620314 TX SHELBY COUNTY   school 4813320 210901   CENTER ISD 481332013661 210901002 ROUGHRIDER ACADEMY   Alternative School No High 09 12 2020   grade_10                                                   <20                                             20
1620424 TX HARRIS COUNTY   school 4813590 101905   CHANNELVIEW ISD 481359001144 101905005 ENDEAVOR HS-JOE FRANK CAMPBELL LEA   Alternative School No High 09 12 2020   grade_10                                                   11                                             11
1620648 TX MCLENNAN COUNTY   school 4813960 161920   CHINA SPRING ISD 481396007995 161920002 TAG   Alternative School No High 09 12 2020   grade_10                                                   <10                                             10
1620710 TX EASTLAND COUNTY   school 4814070 67902   CISCO ISD 481407009215 67902004 CISCO LEARNING CENTER   Alternative School No High 09 12 2020   grade_10                                                   <10                                             10
1620887 TX GALVESTON COUNTY   school 4814280 84910   CLEAR CREEK ISD 481428009498 84910008 CLEAR PATH ALTERNATIVE SCHOOL   Alternative School No High 06 12 2020   grade_10                                                   15                                             15
1620895 TX GALVESTON COUNTY   school 4814280 84910   CLEAR CREEK ISD 481428006666 84910004 CLEAR VIEW H S   Alternative School No High 09 12 2020   grade_10                                                   35                                             35
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
1621131 TX JOHNSON COUNTY   school 4814310 126903   CLEBURNE ISD 481431001614 126903002 TEAM SCH   Alternative School No High 09 12 2020   grade_10                                                   <10                                             10
1621145 TX LIBERTY COUNTY   school 4814370 146901   CLEVELAND ISD 481437007381 146901003 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No High 06 12 2020   grade_10                                                   <10                                             10
1621156 TX LIBERTY COUNTY   school 4814370 146901   CLEVELAND ISD 481437012020 146901004 FREDERICK A DOUGLASS LEARNING ACAD   Alternative School No High 10 12 2020   grade_10                                                   <10                                             10
1621467 TX MITCHELL COUNTY   school 4814640 168901   COLORADO ISD 481464010962 168901003 WALLACE ACCELERATED H S   Alternative School No High 08 12 2020   grade_10                                                   <10                                             10
1621553 TX COMAL COUNTY   school 4814730 46902   COMAL ISD 481473012361 46902206 COMAL DISCIPLINE CENTER   Alternative School No High 05 12 2020   grade_10                                                   12                                             12
1621596 TX COMAL COUNTY   school 4814730 46902   COMAL ISD 481473013793 46902210 JJAEP   Alternative School No High 09 12 2020   grade_10                                                   <10                                             10
1621806 TX HARRIS COUNTY   school 4800127 101842   COMQUEST ACADEMY 480012708255 101842001 COMQUEST ACADEMY   Alternative School Yes Other 01 12 2020   grade_10                                                   <10                                             10
1621975 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500001004 170902002 HAUKE ALTER ED   Alternative School No High 09 12 2020   grade_10                                                   21                                             21
1621997 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500017045 170902010 JJAEP   Alternative School No High 06 12 2020   grade_10                                                   20                                             20
1622003 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500007998 170902201 JUVENILE DETENTION CTR   Alternative School No High 07 12 2020   grade_10                                                   <10                                             10
1622288 TX CORYELL COUNTY   school 4815240 50910   COPPERAS COVE ISD 481524007233 50910005 CROSSROADS H S   Alternative School No High 09 12 2020   grade_10                                                   <20                                             20
1622372 TX NUECES COUNTY   school 4815270 178904   CORPUS CHRISTI ISD 481527006082 178904009 COLES H S AND EDUCATIONAL CENTER   Alternative School No High 08 12 2020   grade_10                                                   27                                             27

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