enrollments

Data source: Big Local News · About: Big Local

2,227 rows where grade = "grade_9", state = "TX" and year = 2020 sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,227 ✖

grade ✖

  • grade_9 · 2,227 ✖
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 ▼
1613255 1613255 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009497 221901008 JUVENILE DETENTION CENTER   Alternative School No Secondary 08 11 2020   grade_9                                                   <10                                             10
1613297 1613297 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009062 221901007 TAYLOR COUNTY LEARNING CENTER   Alternative School No Middle 05 11 2020   grade_9                                                   <10                                             10
1613400 1613400 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2020   grade_9                                                   10                                             10
1613469 1613469 TX WOOD COUNTY   school 4807650 250906   ALBA-GOLDEN ISD 480765007158 250906002 ALTER SCHOOL   Alternative School No Secondary 09 11 2020   grade_9                                                   <10                                             10
1613676 1613676 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000075 101902108 LANE SCHOOL   Special Education School No Other PK 12 2020   grade_9                                                   <10                                             10
1613804 1613804 TX PARKER COUNTY   school 4807780 184907   ALEDO ISD 480778000089 184907001 ALEDO H S   Regular School No High 09 12 2020   grade_9                                                   <10                                             10
1613909 1613909 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_9                                                   <10                                             10
1614127 1614127 TX COLLIN COUNTY   school 4807890 43901   ALLEN ISD 480789000117 43901001 ALLEN H S   Regular School No High 09 12 2020   grade_9                                                   <10                                             10
1614388 1614388 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_9                                                   <10                                             10
1614545 1614545 TX POTTER COUNTY   school 4808130 188901   AMARILLO ISD 480813007086 188901003 AMARILLO AREA CTR FOR ADVANCED LRN   Regular School No Secondary 09 11 2020   grade_9                                                   <10                                             10
1614883 1614883 TX LAMB COUNTY   school 4808160 140901   AMHERST ISD 480816000188 140901001 AMHERST SCHOOL   Regular School No Other PK 12 2020   grade_9                                                   <10                                             10
1614914 1614914 TX CHAMBERS COUNTY   school 4808190 36901   ANAHUAC ISD 480819013185 36901006 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No Secondary 06 11 2020   grade_9                                                   <10                                             10
1614931 1614931 TX ANDREWS COUNTY   school 4808280 2901   ANDREWS ISD 480828007502 2901002 ANDREWS EDUCATION CENTER   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1614959 1614959 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831016825 20902003 BRAZORIA CO ALTER ED CTR   Alternative School No High 06 12 2020   grade_9                                                   <10                                             10
1614966 1614966 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831007814 20902004 BRAZORIA CO JUVENILE DETENTION   Alternative School No High 05 12 2020   grade_9                                                   <10                                             10
1615025 1615025 TX COLLIN COUNTY   school 4808340 43902   ANNA ISD 480834013928 43902005 ANNA ISD DAEP   Alternative School No High 07 12 2020   grade_9                                                   <10                                             10
1615106 1615106 TX TRINITY COUNTY   school 4808490 228905   APPLE SPRINGS ISD 480849000216 228905001 APPLE SPRINGS H S   Regular School No High 07 12 2020   grade_9                                                   <10                                             10
1615147 1615147 TX SAN PATRICIO COUNTY   school 4808580 205901   ARANSAS PASS ISD 480858009519 205901002 ARANSAS PASS JJAEP   Alternative School No Secondary 09 09 2020   grade_9                                                   <10                                             10
1615671 1615671 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_9                                                   <10                                             10
1615927 1615927 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005646 227901250 AUSTIN ST HOSPITAL   Alternative School No Other 01 12 2020   grade_9                                                   <10                                             10
1616156 1616156 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894012824 227901026 GRADUATION PREP ACADEMY NAVARRO   Alternative School Yes High 09 12 2020   grade_9                                                   <10                                             10
1616160 1616160 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894012864 227901025 GRADUATION PREP ACADEMY TRAVIS   Alternative School Yes High 09 12 2020   grade_9                                                   <10                                             10
1616283 1616283 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894007137 227901035 LEADERSHIP ACADEMY   Alternative School No High 08 12 2020   grade_9                                                   <10                                             10
1616473 1616473 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894008389 227901032 PHOENIX ACADEMY   Alternative School No High 08 12 2020   grade_9                                                   <10                                             10
1616539 1616539 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005396 227901251 ROSEDALE   Alternative School No Other PK 12 2020   grade_9                                                   <10                                             10
1616588 1616588 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894012204 227901027 TRAVIS COUNTY DAY SCHOOL   Alternative School No Secondary 08 11 2020   grade_9                                                   <10                                             10
1616591 1616591 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894007741 227901036 TRAVIS COUNTY J J A E P   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1616697 1616697 TX REFUGIO COUNTY   school 4809000 196901   AUSTWELL-TIVOLI ISD 480900000371 196901001 AUSTWELL-TIVOLI H S   Regular School No High 07 12 2020   grade_9                                                   <10                                             10
1616740 1616740 TX CASS COUNTY   school 4809090 34902   AVINGER ISD 480909000378 34902001 AVINGER SCHOOL   Regular School No Other PK 12 2020   grade_9                                                   10                                             10
1616845 1616845 TX RUNNELS COUNTY   school 4809300 200901   BALLINGER ISD 480930012897 200901005 FAIRVIEW ACCELERATED (DAEP)   Alternative School No High 07 12 2020   grade_9                                                   <10                                             10
1616859 1616859 TX REEVES COUNTY   school 4809330 195902   BALMORHEA ISD 480933000392 195902001 BALMORHEA SCHOOL   Regular School No Other PK 12 2020   grade_9                                                   10                                             10
1616917 1616917 TX CHAMBERS COUNTY   school 4809450 36902   BARBERS HILL ISD 480945011547 36902005 ALTERNATIVE SCHOOL   Alternative School No High 07 12 2020   grade_9                                                   <10                                             10
1617018 1617018 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957021082 11901022 GENESIS H S   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1617163 1617163 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967007364 123910011 JEFFERSON CO YOUTH ACAD   Alternative School No Secondary 06 11 2020   grade_9                                                   <10                                             10
1617271 1617271 TX CLAY COUNTY   school 4809750 39904   BELLEVUE ISD 480975000446 39904001 BELLEVUE SCHOOL   Regular School No Other PK 12 2020   grade_9                                                   <10                                             10
1617311 1617311 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_9                                                   <10                                             10
1617673 1617673 TX TARRANT COUNTY   school 4810230 220902   BIRDVILLE ISD 481023013066 220902012 SHANNON H S   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1618259 1618259 TX BRAZORIA COUNTY   school 4811190 20905   BRAZOSPORT ISD 481119008711 20905006 BRAZOS SUCCESS ACADEMY   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1618313 1618313 TX BRAZORIA COUNTY   school 4811190 20905   BRAZOSPORT ISD 481119008710 20905005 LIGHTHOUSE LEARNING CENTER - JJAEP   Alternative School No Secondary 07 10 2020   grade_9                                                   <10                                             10
1618508 1618508 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155000627 25908001 BROOKESMITH SCHOOL   Regular School No Other PK 12 2020   grade_9                                                   <10                                             10
1618515 1618515 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155013724 25908003 GENESIS CAMPUS   Alternative School No High 06 12 2020   grade_9                                                   <10                                             10
1618575 1618575 TX TERRY COUNTY   school 4811610 223901   BROWNFIELD ISD 481161012078 223901005 BROWNFIELD EDUCATION CENTER   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1618666 1618666 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_9                                                   <10                                             10
1618945 1618945 TX BROWN COUNTY   school 4811700 25902   BROWNWOOD ISD 481170011156 25902003 BROWNWOOD ACCELERATED H S   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1618975 1618975 TX MCLENNAN COUNTY   school 4811730 161919   BRUCEVILLE-EDDY ISD 481173011401 161919005 AXTELL/BE DAEP   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1619021 1619021 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179008456 21902014 BRAZOS CO JUVENILE DETENTION CENTE   Alternative School No Other 04 12 2020   grade_9                                                   <10                                             10
1619027 1619027 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179009145 21902015 BRAZOS COUNTY JJAEP   Alternative School No Secondary 06 11 2020   grade_9                                                   <10                                             10
1619125 1619125 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179011886 21902017 THE MARY CATHERINE HARRIS SCHOOL-S   Alternative School No High 07 12 2020   grade_9                                                   <10                                             10
1619157 1619157 TX MILAM COUNTY   school 4811850 166907   BUCKHOLTS ISD 481185000697 166907001 BUCKHOLTS SCHOOL   Regular School No Other PK 12 2020   grade_9                                                   <10                                             10
1619289 1619289 TX JOHNSON COUNTY   school 4812180 126902   BURLESON ISD 481218007978 126902003 CROSSROADS H S   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1619320 1619320 TX JOHNSON COUNTY   school 4812180 126902   BURLESON ISD 481218010856 126902004 JOHNSON COUNTY JJAEP   Alternative School No Secondary 09 09 2020   grade_9                                                   <10                                             10
1619386 1619386 TX BURNET COUNTY   school 4812220 27903   BURNET CISD 481222003287 27903003 QUEST H S   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1619534 1619534 TX CALHOUN COUNTY   school 4812480 29901   CALHOUN COUNTY ISD 481248007199 29901003 HOPE H S   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1619592 1619592 TX ROBERTSON COUNTY   school 4812540 198902   CALVERT ISD 481254000756 198902101 CALVERT SCHOOL   Regular School No Other PK 12 2020   grade_9                                                   10                                             10
1619919 1619919 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_9                                                   <10                                             10
1619928 1619928 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_9                                                   <10                                             10
1619971 1619971 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305005671 57903003 GRIMES EDUCATION CENTER   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1620152 1620152 TX TARRANT COUNTY   school 4813170 220917   CASTLEBERRY ISD 481317007121 220917003 REACH H S   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1620159 1620159 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_9                                                   <10                                             10
1620162 1620162 TX TARRANT COUNTY   school 4813170 220917   CASTLEBERRY ISD 481317008044 220917005 TARRANT CO J J A E P   Alternative School No Secondary 09 09 2020   grade_9                                                   <10                                             10
1620313 1620313 TX SHELBY COUNTY   school 4813320 210901   CENTER ISD 481332013661 210901002 ROUGHRIDER ACADEMY   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1620332 1620332 TX KERR COUNTY   school 4813350 133901   CENTER POINT ISD 481335013963 133901004 NORTH STAR H S   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1620647 1620647 TX MCLENNAN COUNTY   school 4813960 161920   CHINA SPRING ISD 481396007995 161920002 TAG   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1620709 1620709 TX EASTLAND COUNTY   school 4814070 67902   CISCO ISD 481407009215 67902004 CISCO LEARNING CENTER   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1620938 1620938 TX GALVESTON COUNTY   school 4814280 84910   CLEAR CREEK ISD 481428008790 84910005 GALVESTON CO JJAEP   Alternative School No Secondary 09 09 2020   grade_9                                                   <10                                             10
1621130 1621130 TX JOHNSON COUNTY   school 4814310 126903   CLEBURNE ISD 481431001614 126903002 TEAM SCH   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1621342 1621342 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735010464 21901015 COLLEGE STATION JJAEP   Alternative School No Secondary 08 11 2020   grade_9                                                   <10                                             10
1621466 1621466 TX MITCHELL COUNTY   school 4814640 168901   COLORADO ISD 481464010962 168901003 WALLACE ACCELERATED H S   Alternative School No High 08 12 2020   grade_9                                                   <10                                             10
1621595 1621595 TX COMAL COUNTY   school 4814730 46902   COMAL ISD 481473013793 46902210 JJAEP   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1621743 1621743 TX COLLIN COUNTY   school 4814850 43918   COMMUNITY ISD 481485010523 43918003 BRAVES ACADEMY   Alternative School No High 08 12 2020   grade_9                                                   <10                                             10
1621805 1621805 TX HARRIS COUNTY   school 4800127 101842   COMQUEST ACADEMY 480012708255 101842001 COMQUEST ACADEMY   Alternative School Yes Other 01 12 2020   grade_9                                                   <10                                             10
1621996 1621996 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500017045 170902010 JJAEP   Alternative School No High 06 12 2020   grade_9                                                   <10                                             10
1622002 1622002 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500007998 170902201 JUVENILE DETENTION CTR   Alternative School No High 07 12 2020   grade_9                                                   <10                                             10
1622287 1622287 TX CORYELL COUNTY   school 4815240 50910   COPPERAS COVE ISD 481524007233 50910005 CROSSROADS H S   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1622575 1622575 TX NUECES COUNTY   school 4815270 178904   CORPUS CHRISTI ISD 481527008346 178904012 NUECES CO J J A E P   Alternative School No Secondary 09 09 2020   grade_9                                                   <10                                             10
1622810 1622810 TX KAUFMAN COUNTY   school 4815510 129901   CRANDALL ISD 481551007370 129901002 CRANDALL COMPASS ACADEMY   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1622881 1622881 TX BOSQUE COUNTY   school 4815570 18908   CRANFILLS GAP ISD 481557001129 18908001 CRANFILLS GAP SCHOOL   Regular School No Other PK 12 2020   grade_9                                                   10                                             10
1622959 1622959 TX HARRIS COUNTY   school 4815750 101906   CROSBY ISD 481575010727 101906105 HIGHPOINT SCHOOL EAST (CROSBY)   Alternative School No High 07 12 2020   grade_9                                                   <10                                             10
1622987 1622987 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 09 2020   grade_9                                                   <10                                             10
1623076 1623076 TX TARRANT COUNTY   school 4815910 220912   CROWLEY ISD 481591001157 220912041 H F STEVENS MIDDLE   Regular School No Secondary 07 10 2020   grade_9                                                   <10                                             10
1623163 1623163 TX TARRANT COUNTY   school 4815910 220912   CROWLEY ISD 481591012022 220912043 SUMMER CREEK MIDDLE   Regular School No Middle 06 09 2020   grade_9                                                   <10                                             10
1623390 1623390 TX HARRIS COUNTY   school 4816110 101907   CYPRESS-FAIRBANKS ISD 481611007624 101907037 CYPRESS-FAIRBANKS J J A E P   Alternative School No Secondary 08 11 2020   grade_9                                                   <10                                             10
1624594 1624594 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623010565 57905096 JUVENILE JUSTICE AEP   Alternative School No High 07 12 2020   grade_9                                                   <10                                             10
1624782 1624782 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006965 57905030 MAYA ANGELOU H S   Alternative School No High 06 12 2020   grade_9                                                   <10                                             10
1625337 1625337 TX DAWSON COUNTY   school 4816350 58902   DAWSON ISD 481635001399 58902001 DAWSON SCHOOL   Regular School No Other KG 12 2020   grade_9                                                   <10                                             10
1625574 1625574 TX TRAVIS COUNTY   school 4816620 227910   DEL VALLE ISD 481662007743 227910005 TRAVIS CO J J A E P   Alternative School No Secondary 09 11 2020   grade_9                                                   <10                                             10
1625587 1625587 TX HUDSPETH COUNTY   school 4816650 115903   DELL CITY ISD 481665001429 115903001 DELL CITY SCHOOL   Regular School No Other PK 12 2020   grade_9                                                   <10                                             10
1625625 1625625 TX GRAYSON COUNTY   school 4816710 91903   DENISON ISD 481671007294 91903002 PATHWAYS H S   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1625684 1625684 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_9                                                   <10                                             10
1625714 1625714 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674021219 61901039 FRED MOORE H S   Alternative School No High 09 12 2020   grade_9                                                   <10                                             10
1625985 1625985 TX MEDINA COUNTY   school 4816950 163901   DEVINE ISD 481695012708 163901004 DEVINE DAEP SCHOOL   Alternative School No High 07 12 2020   grade_9                                                   <10                                             10
1626059 1626059 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707012502 84901014 COASTAL ALTERNATIVE PROGRAM (CAP)   Alternative School No Secondary 09 10 2020   grade_9                                                   <10                                             10
1626081 1626081 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707007889 84901010 GALVESTON CO J J A E P   Alternative School No Secondary 09 11 2020   grade_9                                                   <10                                             10
1626125 1626125 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707007289 84901011 TRANSFORMING LIVES COOPERATIVE (TL   Alternative School No Secondary 07 11 2020   grade_9                                                   <10                                             10
1626153 1626153 TX LEE COUNTY   school 4817130 144903   DIME BOX ISD 481713001486 144903001 DIME BOX SCHOOL   Regular School No Other PK 12 2020   grade_9                                                   <10                                             10
1626192 1626192 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739012205 108902006 3D ACADEMY   Alternative School No High 09 12 2020   grade_9                                                   10                                             10
1626257 1626257 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739007961 108902003 HIDALGO CO J J A E P   Alternative School No Middle 07 09 2020   grade_9                                                   <10                                             10
1626548 1626548 TX DALLAS COUNTY   school 4817640 57907   DUNCANVILLE ISD 481764008519 57907005 SUMMIT LEARNING CENTER   Alternative School No High 07 12 2020   grade_9                                                   <10                                             10
1626561 1626561 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770007447 220918003 ALTER DISCIPLINE CAMPUS   Alternative School No High 07 12 2020   grade_9                                                   <10                                             10
1626620 1626620 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770005450 220918002 ELMER C WATSON H S   Alternative School No High 09 12 2020   grade_9                                                   <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]);