enrollments

Data source: Big Local News · About: Big Local

5,234 rows where grade = "grade_6" and state = "TX" sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 5,234 ✖
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 ▼
1374430 1374430 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1374521 1374521 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007123 221901003 WOODSON CENTER FOR EXCELLENCE   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1374529 1374529 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009308164 57814001 DALLAS COUNTY JUVENILE JUSTICE   Alternative School Yes High 05 12 2021   grade_6                                                   <10                                             10
1374597 1374597 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1375755 1375755 TX POTTER COUNTY   school 4808130 188901   AMARILLO ISD 480813000148 188901042 BOWIE MIDDLE   Regular School No Middle 06 09 2021   grade_6                                                   <10                                             10
1375860 1375860 TX POTTER COUNTY   school 4808130 188901   AMARILLO ISD 480813000165 188901046 MANN MIDDLE   Regular School No Middle 06 09 2021   grade_6                                                   <10                                             10
1375994 1375994 TX POTTER COUNTY   school 4808130 188901   AMARILLO ISD 480813000182 188901047 TRAVIS MIDDLE   Regular School No Middle 06 08 2021   grade_6                                                   <10                                             10
1376056 1376056 TX LAMB COUNTY   school 4808160 140901   AMHERST ISD 480816000188 140901001 AMHERST SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1376131 1376131 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831007814 20902004 BRAZORIA CO JUVENILE DETENTION   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1376297 1376297 TX HILL COUNTY   school 4808520 109912   AQUILLA ISD 480852010845 109912010 HILL CO J J A E P   Alternative School No Middle 06 06 2021   grade_6                                                   <10                                             10
1376938 1376938 TX BRAZOS COUNTY   school 4801416 21805   ARROW ACADEMY 480141613152 21805105 ARROW ACADEMY - CHAMPIONS ACADEMY   Regular School Yes Elementary KG 06 2021   grade_6                                                   <10                                             10
1376968 1376968 TX STONEWALL COUNTY   school 4800006 217901   ASPERMONT ISD 480000600275 217901001 ASPERMONT H S   Regular School No High 06 12 2021   grade_6                                                   10                                             10
1377102 1377102 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005646 227901250 AUSTIN ST HOSPITAL   Alternative School No High 05 12 2021   grade_6                                                   <10                                             10
1377694 1377694 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005396 227901251 ROSEDALE   Alternative School No Other PK 12 2021   grade_6                                                   <10                                             10
1377830 1377830 TX REFUGIO COUNTY   school 4809000 196901   AUSTWELL-TIVOLI ISD 480900000372 196901102 AUSTWELL-TIVOLI EL   Regular School No Elementary PK 06 2021   grade_6                                                   10                                             10
1377894 1377894 TX MCLENNAN COUNTY   school 4809150 161918   AXTELL ISD 480915006358 161918199 WACO CTR FOR YOUTH   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1378559 1378559 TX KNOX COUNTY   school 4809980 138904   BENJAMIN ISD 480998000468 138904001 BENJAMIN SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1379284 1379284 TX OLDHAM COUNTY   school 4811040 180901   BOYS RANCH ISD 481104005141 180901041 BLAKEMORE MIDDLE   Alternative School No Middle 06 08 2021   grade_6                                                   <10                                             10
1379347 1379347 TX SOMERVELL COUNTY   school 4800214 213801   BRAZOS RIVER CHARTER SCHOOL 480021408907 213801001 BRAZOS RIVER CHARTER SCHOOL   Alternative School Yes Other KG 12 2021   grade_6                                                   <10                                             10
1379369 1379369 TX BRAZOS COUNTY   school 4800086 21803   BRAZOS SCHOOL FOR INQUIRY & CREATI 480008610461 21803102 BRAZOS SCHOOL FOR INQUIRY AND CREA   Regular School Yes Elementary PK 06 2021   grade_6                                                   <10                                             10
1379422 1379422 TX BRAZORIA COUNTY   school 4811190 20905   BRAZOSPORT ISD 481119007528 20905004 LIGHTHOUSE LEARNING CENTER - DAEP   Alternative School No Other 04 12 2021   grade_6                                                   <10                                             10
1379614 1379614 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155000627 25908001 BROOKESMITH SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1379625 1379625 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155013724 25908003 GENESIS CAMPUS   Alternative School No Other 04 11 2021   grade_6                                                   <10                                             10
1380248 1380248 TX MILAM COUNTY   school 4811850 166907   BUCKHOLTS ISD 481185000697 166907001 BUCKHOLTS SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   10                                             10
1380543 1380543 TX HILL COUNTY   school 4812360 109902   BYNUM ISD 481236000730 109902001 BYNUM SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1380677 1380677 TX ROBERTSON COUNTY   school 4812540 198902   CALVERT ISD 481254000756 198902101 CALVERT SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1380881 1380881 TX RANDALL COUNTY   school 4812810 191901   CANYON ISD 481281005172 191901003 YOUTH CTR OF HIGH PLAINS   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1381431 1381431 TX TRINITY COUNTY   school 4813380 228904   CENTERVILLE ISD 481338000839 228904001 CENTERVILLE H S   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1381627 1381627 TX SAN SABA COUNTY   school 4813740 206903   CHEROKEE ISD 481374000866 206903001 CHEROKEE SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1381956 1381956 TX GALVESTON COUNTY   school 4814280 84910   CLEAR CREEK ISD 481428009498 84910008 CLEAR PATH ALTERNATIVE SCHOOL   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1382617 1382617 TX COMAL COUNTY   school 4814730 46902   COMAL ISD 481473012361 46902206 COMAL DISCIPLINE CENTER   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1382885 1382885 TX HARRIS COUNTY   school 4800127 101842   COMQUEST ACADEMY 480012708255 101842001 COMQUEST ACADEMY   Alternative School Yes Other KG 12 2021   grade_6                                                   <10                                             10
1383818 1383818 TX HALE COUNTY   school 4815360 95902   COTTON CENTER ISD 481536001112 95902001 COTTON CENTER SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1384048 1384048 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 12 2021   grade_6                                                   <10                                             10
1384299 1384299 TX SMITH COUNTY   school 4800034 212801   CUMBERLAND ACADEMY 480003413578 212801102 THE LEADERSHIP ACADEMY   Regular School Yes Elementary KG 08 2021   grade_6                                                   <10                                             10
1385307 1385307 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623010564 57905079 FRANCISCO PANCHO MEDRANO J H   Regular School No Middle 06 08 2021   grade_6                                                   <10                                             10
1385477 1385477 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006391 57905099 HOSPITAL/HOMEBOUND   Alternative School No Other KG 12 2021   grade_6                                                   <10                                             10
1386369 1386369 TX LIPSCOMB COUNTY   school 4816320 148905   DARROUZETT ISD 481632001699 148905101 DARROUZETT SCHOOLS   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1386648 1386648 TX HUDSPETH COUNTY   school 4816650 115903   DELL CITY ISD 481665001429 115903001 DELL CITY SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1387222 1387222 TX KERR COUNTY   school 4817190 133905   DIVIDE ISD 481719001490 133905101 DIVIDE EL   Regular School No Elementary PK 06 2021   grade_6                                                   <10                                             10
1388069 1388069 TX ECTOR COUNTY   school 4818000 68901   ECTOR COUNTY ISD 481800001596 68901004 ALTER ED CTR   Alternative School No Secondary 06 11 2021   grade_6                                                   <10                                             10
1389464 1389464 TX NACOGDOCHES COUNTY   school 4818660 174910   ETOILE ISD 481866001747 174910101 ETOILE EL   Regular School No Elementary PK 08 2021   grade_6                                                   10                                             10
1389587 1389587 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908231 101811004 HARRIS COUNTY YOUTH VILLAGE   Alternative School Yes High 06 12 2021   grade_6                                                   <10                                             10
1389617 1389617 TX SHELBY COUNTY   school 4818840 210906   EXCELSIOR ISD 481884001762 210906101 EXCELSIOR EL   Regular School No Elementary PK 08 2021   grade_6                                                   <10                                             10
1389627 1389627 TX LAVACA COUNTY   school 4818890 143906   EZZELL ISD 481889001764 143906101 EZZELL EL   Regular School No Elementary PK 08 2021   grade_6                                                   <10                                             10
1389770 1389770 TX FAYETTE COUNTY   school 4819280 75901   FLATONIA ISD 481928012888 75901103 WHISPERING HILLS ACHIEVEMENT CENTE   Alternative School No Other 04 12 2021   grade_6                                                   <10                                             10
1389790 1389790 TX WILSON COUNTY   school 4819350 247901   FLORESVILLE ISD 481935007499 247901002 FLORESVILLE ALTER CTR   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1389855 1389855 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944009239 77901004 FLOYDADA ISD DAEP   Alternative School No Middle 05 11 2021   grade_6                                                   <10                                             10
1390548 1390548 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001832 220905104 BOULEVARD HEIGHTS   Alternative School No Other KG 12 2021   grade_6                                                   <10                                             10
1390616 1390616 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021056 220905210 CHILDREN'S MEDICAL CTR   Alternative School No Other KG 12 2021   grade_6                                                   <10                                             10
1390689 1390689 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005469 220905024 DETENT CTR   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1390838 1390838 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005717 220905026 JO KELLY SP ED   Alternative School No Other PK 12 2021   grade_6                                                   <10                                             10
1390929 1390929 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001879 220905050 MCLEAN MIDDLE   Regular School No Middle 06 08 2021   grade_6                                                   <10                                             10
1391066 1391066 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001904 220905057 ROSEMONT MIDDLE   Regular School No Middle 06 08 2021   grade_6                                                   <10                                             10
1391286 1391286 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021057 220905211 WOMEN'S HAVEN   Alternative School No Other KG 09 2021   grade_6                                                   <10                                             10
1391563 1391563 TX COLLIN COUNTY   school 4820010 43905   FRISCO ISD 482001011403 43905127 CARROLL EL   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1392107 1392107 TX GALVESTON COUNTY   school 4820280 84902   GALVESTON ISD 482028012288 84902007 AIM COLLEGE & CAREER PREP   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1392196 1392196 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034006706 57909143 ABBETT EL   Regular School No Elementary PK 06 2021   grade_6                                                   <10                                             10
1392629 1392629 TX NACOGDOCHES COUNTY   school 4820400 174903   GARRISON ISD 482040011313 174903003 NACOGDOCHES COUNTY DAEP COOP   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1392835 1392835 TX WILLIAMSON COUNTY   school 4820600 246904   GEORGETOWN ISD 482060001018 246904199 WILLIAMSON CO JUVENILE DETENTION C   Alternative School No Secondary 06 11 2021   grade_6                                                   <10                                             10
1392960 1392960 TX MONTAGUE COUNTY   school 4820970 169906   GOLD BURG ISD 482097002091 169906001 GOLD BURG SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1393200 1393200 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115008605 101911006 POINT ALTERNATIVE CENTER   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1393508 1393508 TX DALLAS COUNTY   school 4821420 57910   GRAND PRAIRIE ISD 482142006970 57910004 LYNDON B JOHNSON DAEP   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1393661 1393661 TX GRAY COUNTY   school 4821560 90905   GRANDVIEW-HOPKINS ISD 482156002172 90905101 GRANDVIEW-HOPKINS EL   Regular School No Elementary KG 06 2021   grade_6                                                   <10                                             10
1394089 1394089 TX COMANCHE COUNTY   school 4821990 47903   GUSTINE ISD 482199002215 47903001 GUSTINE SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   10                                             10
1394321 1394321 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247009123 15904047 FENLEY TRANSITIONAL MIDDLE   Alternative School No Middle 06 07 2021   grade_6                                                   <10                                             10
1394358 1394358 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247002267 15904115 JEWEL C WIETZEL CENTER   Special Education School No Other 04 12 2021   grade_6                                                   <10                                             10
1394562 1394562 TX CAMERON COUNTY   school 4822530 31903   HARLINGEN CISD 482253006940 31903118 SECONDARY ALTER CTR   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1395322 1395322 TX DONLEY COUNTY   school 4822850 65902   HEDLEY ISD 482285002317 65902001 HEDLEY SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1395522 1395522 TX GALVESTON COUNTY   school 4823160 84903   HIGH ISLAND ISD 482316002351 84903001 HIGH ISLAND SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   10                                             10
1395740 1395740 TX HIDALGO COUNTY   school 4800065 108802   HORIZON MONTESSORI PUBLIC SCHOOLS 480006513976 108802104 HORIZON MONTESSORI - PEARLAND   Regular School Yes Elementary PK 08 2021   grade_6                                                   10                                             10
1396398 1396398 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364011265 101912351 HARPER DAEP   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1397202 1397202 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364007018 101912069 SOAR CTR   Special Education School No Other PK 12 2021   grade_6                                                   <10                                             10
1397509 1397509 TX BOWIE COUNTY   school 4823700 19913   HUBBARD ISD 482370002624 19913101 HUBBARD ISD   Regular School No Elementary PK 08 2021   grade_6                                                   <10                                             10
1397689 1397689 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391012774 101913015 HUMBLE COMMUNITY LEARNING CENTER   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1398872 1398872 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313328 15808012 JHW INSPIRE ACADEMY - LEGACY RANCH   Alternative School Yes Other KG 12 2021   grade_6                                                   <10                                             10
1398878 1398878 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005312039 15808007 JHW INSPIRE ACADEMY - ROCKDALE   Alternative School Yes High 06 12 2021   grade_6                                                   <10                                             10
1399741 1399741 TX BEXAR COUNTY   school 4800179 15822   JUBILEE ACADEMIES 480017913941 15822014 JUBILEE SENDERO   Regular School Yes Elementary PK 06 2021   grade_6                                                   <10                                             10
1400683 1400683 TX WHEELER COUNTY   school 4825290 242905   KELTON ISD 482529005755 242905001 KELTON SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1400715 1400715 TX KENEDY COUNTY   school 4825410 131001   KENEDY COUNTY WIDE CSD 482541002831 131001103 SARITA EL   Regular School No Elementary PK 06 2021   grade_6                                                   <10                                             10
1400872 1400872 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002861 14906022 ADVENTHEALTH SCHOOL   Alternative School No Other 02 12 2021   grade_6                                                   <10                                             10
1400954 1400954 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566000118 14906009 GATEWAY MIDDLE   Alternative School No Middle 06 08 2021   grade_6                                                   <10                                             10
1401596 1401596 TX HARRIS COUNTY   school 4825740 101915   KLEIN ISD 482574008632 101915038 K E KAUFMAN ALTERNATIVE EDUCATION   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1402244 1402244 TX HARRIS COUNTY   school 4826190 101916   LA PORTE ISD 482619002950 101916043 LOMAX J H   Regular School No Middle 06 08 2021   grade_6                                                   <10                                             10
1402467 1402467 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658006739 79901004 ALTERNATIVE LEARNING CENTER   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1402894 1402894 TX WEBB COUNTY   school 4826790 240901   LAREDO ISD 482679007475 240901007 F S LARA ACADEMY   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1403069 1403069 TX PARMER COUNTY   school 4826970 185904   LAZBUDDIE ISD 482697003038 185904001 LAZBUDDIE SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   10                                             10
1403220 1403220 TX WILLIAMSON COUNTY   school 4827030 246913   LEANDER ISD 482703013720 246913014 LEANDER EXTENDED OPPORTUNITY   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1403479 1403479 TX HOCKLEY COUNTY   school 4827240 110902   LEVELLAND ISD 482724003059 110902042 LEVELLAND INT   Regular School No Middle 04 06 2021   grade_6                                                   <10                                             10
1404298 1404298 TX MCCULLOCH COUNTY   school 4827930 160905   LOHN ISD 482793003132 160905001 LOHN SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1404436 1404436 TX GAINES COUNTY   school 4828140 83902   LOOP ISD 482814003154 83902001 LOOP SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   10                                             10
1404745 1404745 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850005539 152901009 HOMEBOUND   Regular School No Elementary PK 08 2021   grade_6                                                   <10                                             10
1404833 1404833 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850003208 152901007 PRIORITY INTERVENTION ACADEMY   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1405010 1405010 TX JONES COUNTY   school 4828530 127905   LUEDERS-AVOCA ISD 482853003224 127905101 LUEDERS-AVOCA EL/J H   Regular School No Elementary PK 08 2021   grade_6                                                   <10                                             10
1405300 1405300 TX BOWIE COUNTY   school 4828830 19910   MALTA ISD 482883003261 19910101 MALTA EL   Regular School No Elementary PK 06 2021   grade_6                                                   <10                                             10
1405608 1405608 TX BREWSTER COUNTY   school 4828980 22902   MARATHON ISD 482898003272 22902001 MARATHON INDEPENDENT SCHOOL DIST   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1405811 1405811 TX MATAGORDA COUNTY   school 4829370 158904   MATAGORDA ISD 482937003310 158904101 MATAGORDA SCHOOL   Regular School No Elementary PK 08 2021   grade_6                                                   10                                             10
1406333 1406333 TX KENDALL COUNTY   school 4801404 130801   MEADOWLAND CHARTER DISTRICT 480140412137 130801001 OAKS ACADEMY   Alternative School Yes Other 01 11 2021   grade_6                                                   <10                                             10
1406892 1406892 TX ROBERTS COUNTY   school 4830480 197902   MIAMI ISD 483048003429 197902001 MIAMI SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   <10                                             10
1407269 1407269 TX CLAY COUNTY   school 4830660 39905   MIDWAY ISD 483066003461 39905001 MIDWAY SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   <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]);