enrollments

Data source: Big Local News · About: Big Local

9,313 rows where grade = "grade_1" and state = "TX" sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 9,313 ✖
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 ▼
1374592 1374592 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1376051 1376051 TX LAMB COUNTY   school 4808160 140901   AMHERST ISD 480816000188 140901001 AMHERST SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   10                                             10
1376255 1376255 TX HOCKLEY COUNTY   school 4808460 110901   ANTON ISD 480846000214 110901001 ANTON SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1377689 1377689 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005396 227901251 ROSEDALE   Alternative School No Other PK 12 2021   grade_1                                                   <10                                             10
1377825 1377825 TX REFUGIO COUNTY   school 4809000 196901   AUSTWELL-TIVOLI ISD 480900000372 196901102 AUSTWELL-TIVOLI EL   Regular School No Elementary PK 06 2021   grade_1                                                   <10                                             10
1377867 1377867 TX CASS COUNTY   school 4809090 34902   AVINGER ISD 480909000378 34902001 AVINGER SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   10                                             10
1378395 1378395 TX CLAY COUNTY   school 4809750 39904   BELLEVUE ISD 480975000446 39904001 BELLEVUE SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1378554 1378554 TX KNOX COUNTY   school 4809980 138904   BENJAMIN ISD 480998000468 138904001 BENJAMIN SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1378642 1378642 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022709011 193801001 BIG SPRINGS CHARTER SCHOOL   Alternative School Yes Other KG 12 2021   grade_1                                                   <10                                             10
1378655 1378655 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022711321 193801101 HILL COUNTRY YOUTH RANCH   Alternative School Yes Other KG 12 2021   grade_1                                                   <10                                             10
1378937 1378937 TX BROWN COUNTY   school 4810380 25904   BLANKET ISD 481038005661 25904001 BLANKET SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1379292 1379292 TX OLDHAM COUNTY   school 4811040 180901   BOYS RANCH ISD 481104000570 180901101 MIMI FARLEY EL   Regular School No Elementary KG 05 2021   grade_1                                                   <10                                             10
1379342 1379342 TX SOMERVELL COUNTY   school 4800214 213801   BRAZOS RIVER CHARTER SCHOOL 480021408907 213801001 BRAZOS RIVER CHARTER SCHOOL   Alternative School Yes Other KG 12 2021   grade_1                                                   <10                                             10
1379609 1379609 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155000627 25908001 BROOKESMITH SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   10                                             10
1380050 1380050 TX BROWN COUNTY   school 4811700 25902   BROWNWOOD ISD 481170000674 25902101 COGGIN INT   Regular School No Elementary 01 06 2021   grade_1                                                   <10                                             10
1380243 1380243 TX MILAM COUNTY   school 4811850 166907   BUCKHOLTS ISD 481185000697 166907001 BUCKHOLTS SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1381057 1381057 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305005854 57903117 HUIE SPECIAL EDUC CTR   Alternative School No Other PK 12 2021   grade_1                                                   <10                                             10
1381426 1381426 TX TRINITY COUNTY   school 4813380 228904   CENTERVILLE ISD 481338000839 228904001 CENTERVILLE H S   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1381622 1381622 TX SAN SABA COUNTY   school 4813740 206903   CHEROKEE ISD 481374000866 206903001 CHEROKEE SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1381636 1381636 TX TYLER COUNTY   school 4813770 229906   CHESTER ISD 481377000867 229906101 CHESTER EL   Regular School No Elementary PK 05 2021   grade_1                                                   <10                                             10
1382882 1382882 TX HARRIS COUNTY   school 4800127 101842   COMQUEST ACADEMY 480012708255 101842001 COMQUEST ACADEMY   Alternative School Yes Other KG 12 2021   grade_1                                                   <10                                             10
1383814 1383814 TX HALE COUNTY   school 4815360 95902   COTTON CENTER ISD 481536001112 95902001 COTTON CENTER SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1383941 1383941 TX BOSQUE COUNTY   school 4815570 18908   CRANFILLS GAP ISD 481557001129 18908001 CRANFILLS GAP SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1385474 1385474 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006391 57905099 HOSPITAL/HOMEBOUND   Alternative School No Other KG 12 2021   grade_1                                                   <10                                             10
1386339 1386339 TX BRAZORIA COUNTY   school 4816260 20910   DAMON ISD 481626001391 20910101 DAMON EL   Regular School No Elementary PK 08 2021   grade_1                                                   <10                                             10
1386364 1386364 TX LIPSCOMB COUNTY   school 4816320 148905   DARROUZETT ISD 481632001699 148905101 DARROUZETT SCHOOLS   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1386643 1386643 TX HUDSPETH COUNTY   school 4816650 115903   DELL CITY ISD 481665001429 115903001 DELL CITY SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1387218 1387218 TX KERR COUNTY   school 4817190 133905   DIVIDE ISD 481719001490 133905101 DIVIDE EL   Regular School No Elementary PK 06 2021   grade_1                                                   <10                                             10
1387374 1387374 TX GILLESPIE COUNTY   school 4817400 86024   DOSS CONSOLIDATED CSD 481740001503 86024101 DOSS EL   Regular School No Elementary PK 08 2021   grade_1                                                   <10                                             10
1387857 1387857 TX MAVERICK COUNTY   school 4817730 159901   EAGLE PASS ISD 481773007987 159901115 SAM HOUSTON EL   Regular School No Elementary 01 06 2021   grade_1                                                   <10                                             10
1389612 1389612 TX SHELBY COUNTY   school 4818840 210906   EXCELSIOR ISD 481884001762 210906101 EXCELSIOR EL   Regular School No Elementary PK 08 2021   grade_1                                                   <10                                             10
1389876 1389876 TX MONTAGUE COUNTY   school 4819530 169910   FORESTBURG ISD 481953001808 169910001 FORESTBURG SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1390500 1390500 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970007724 220905251 ASSESSMENT CTR   Alternative School No Elementary KG 08 2021   grade_1                                                   <10                                             10
1390611 1390611 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021056 220905210 CHILDREN'S MEDICAL CTR   Alternative School No Other KG 12 2021   grade_1                                                   <10                                             10
1390833 1390833 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005717 220905026 JO KELLY SP ED   Alternative School No Other PK 12 2021   grade_1                                                   <10                                             10
1391285 1391285 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021057 220905211 WOMEN'S HAVEN   Alternative School No Other KG 09 2021   grade_1                                                   <10                                             10
1391910 1391910 TX JEFF DAVIS COUNTY   school 4820100 122901   FT DAVIS ISD 482010001962 122901001 FT DAVIS SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1392139 1392139 TX GALVESTON COUNTY   school 4820280 84902   GALVESTON ISD 482028001997 84902102 CRENSHAW EL AND MIDDLE   Regular School No Elementary PK 08 2021   grade_1                                                   <10                                             10
1392955 1392955 TX MONTAGUE COUNTY   school 4820970 169906   GOLD BURG ISD 482097002091 169906001 GOLD BURG SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1393003 1393003 TX DALLAS COUNTY   school 4800237 57835   GOLDEN RULE CHARTER SCHOOL 480023713576 57835105 GOLDEN RULE SCHOOLS INC - WILMER   Regular School Yes Elementary PK 01 2021   grade_1                                                   <10                                             10
1393545 1393545 TX DALLAS COUNTY   school 4821420 57910   GRAND PRAIRIE ISD 482142013172 57910135 SCHOOL FOR THE HIGHLY GIFTED   Regular School Yes Elementary 01 08 2021   grade_1                                                   <10                                             10
1393656 1393656 TX GRAY COUNTY   school 4821560 90905   GRANDVIEW-HOPKINS ISD 482156002172 90905101 GRANDVIEW-HOPKINS EL   Regular School No Elementary KG 06 2021   grade_1                                                   10                                             10
1394026 1394026 TX CARSON COUNTY   school 4821840 33901   GROOM ISD 482184002205 33901001 GROOM SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   10                                             10
1394084 1394084 TX COMANCHE COUNTY   school 4821990 47903   GUSTINE ISD 482199002215 47903001 GUSTINE SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   10                                             10
1394098 1394098 TX KING COUNTY   school 4822020 135001   GUTHRIE CSD 482202002217 135001001 GUTHRIE SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1394124 1394124 TX LAVACA COUNTY   school 4822120 143901   HALLETTSVILLE ISD 482212009327 143901002 G O A L S PROGRAM   Alternative School No Elementary 01 07 2021   grade_1                                                   <10                                             10
1395060 1395060 TX WILBARGER COUNTY   school 4822620 244901   HARROLD ISD 482262002298 244901001 HARROLD SCHOOL   Regular School No Other KG 12 2021   grade_1                                                   <10                                             10
1395317 1395317 TX DONLEY COUNTY   school 4822850 65902   HEDLEY ISD 482285002317 65902001 HEDLEY SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1395517 1395517 TX GALVESTON COUNTY   school 4823160 84903   HIGH ISLAND ISD 482316002351 84903001 HIGH ISLAND SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   10                                             10
1396067 1396067 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364006270 101912013 COMMUNITY SERVICES-SEC   Alternative School No Other 01 12 2021   grade_1                                                   <10                                             10
1397457 1397457 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364007949 101912371 YOUNG SCHOLARS ACADEMY FOR EXCELLE   Regular School Yes Elementary PK 08 2021   grade_1                                                   10                                             10
1397504 1397504 TX BOWIE COUNTY   school 4823700 19913   HUBBARD ISD 482370002624 19913101 HUBBARD ISD   Regular School No Elementary PK 08 2021   grade_1                                                   <10                                             10
1398867 1398867 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313328 15808012 JHW INSPIRE ACADEMY - LEGACY RANCH   Alternative School Yes Other KG 12 2021   grade_1                                                   <10                                             10
1399736 1399736 TX BEXAR COUNTY   school 4800179 15822   JUBILEE ACADEMIES 480017913941 15822014 JUBILEE SENDERO   Regular School Yes Elementary PK 06 2021   grade_1                                                   <10                                             10
1400834 1400834 TX HAYS COUNTY   school 4801447 105803   KI CHARTER ACADEMY 480144713122 105803001 KI CHARTER ACADEMY   Alternative School Yes Other 01 12 2021   grade_1                                                   <10                                             10
1400946 1400946 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566009455 14906100 EL ALTER LEARNING CENTER   Alternative School No Elementary 01 05 2021   grade_1                                                   <10                                             10
1401820 1401820 TX BOSQUE COUNTY   school 4825890 18907   KOPPERL ISD 482589002917 18907001 KOPPERL SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1402822 1402822 TX RUSK COUNTY   school 4826700 201903   LANEVILLE ISD 482670006577 201903001 LANEVILLE SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1403367 1403367 TX BOWIE COUNTY   school 4827060 19914   LEARY ISD 482706003045 19914101 LEARY EL   Regular School No Elementary PK 08 2021   grade_1                                                   <10                                             10
1403701 1403701 TX DENTON COUNTY   school 4827300 61902   LEWISVILLE ISD 482730006744 61902005 LEARNING CTR   Alternative School No Other 01 12 2021   grade_1                                                   <10                                             10
1404293 1404293 TX MCCULLOCH COUNTY   school 4827930 160905   LOHN ISD 482793003132 160905001 LOHN SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1404445 1404445 TX MITCHELL COUNTY   school 4828170 168902   LORAINE ISD 482817003156 168902001 LORAINE SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1404740 1404740 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850005539 152901009 HOMEBOUND   Regular School No Elementary PK 08 2021   grade_1                                                   <10                                             10
1405005 1405005 TX JONES COUNTY   school 4828530 127905   LUEDERS-AVOCA ISD 482853003224 127905101 LUEDERS-AVOCA EL/J H   Regular School No Elementary PK 08 2021   grade_1                                                   <10                                             10
1405603 1405603 TX BREWSTER COUNTY   school 4828980 22902   MARATHON ISD 482898003272 22902001 MARATHON INDEPENDENT SCHOOL DIST   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1405806 1405806 TX MATAGORDA COUNTY   school 4829370 158904   MATAGORDA ISD 482937003310 158904101 MATAGORDA SCHOOL   Regular School No Elementary PK 08 2021   grade_1                                                   <10                                             10
1406328 1406328 TX KENDALL COUNTY   school 4801404 130801   MEADOWLAND CHARTER DISTRICT 480140412137 130801001 OAKS ACADEMY   Alternative School Yes Other 01 11 2021   grade_1                                                   <10                                             10
1407264 1407264 TX CLAY COUNTY   school 4830660 39905   MIDWAY ISD 483066003461 39905001 MIDWAY SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1407687 1407687 TX SHACKELFORD COUNTY   school 4831320 209902   MORAN ISD 483132003518 209902001 MORAN SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1407739 1407739 TX MOTLEY COUNTY   school 4831500 173901   MOTLEY COUNTY ISD 483150003526 173901001 MOTLEY COUNTY SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   10                                             10
1407876 1407876 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192005557 167902001 MULLIN MAIN   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1408562 1408562 TX DEWITT COUNTY   school 4832880 62902   NORDHEIM ISD 483288003624 62902001 NORDHEIM SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   10                                             10
1408598 1408598 TX BEXAR COUNTY   school 4832940 15910   NORTH EAST ISD 483294011135 15910160 ALTERNATIVE EL   Alternative School No Elementary 01 02 2021   grade_1                                                   <10                                             10
1409442 1409442 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312003715 15915004 HOLMGREEN CENTER   Alternative School No Other PK 12 2021   grade_1                                                   <10                                             10
1410346 1410346 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023513524 14804008 KINGSLAND SCHOOL   Regular School Yes Other KG 10 2021   grade_1                                                   <10                                             10
1410356 1410356 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023511986 14804002 NEW HORIZONS   Alternative School Yes Other 01 11 2021   grade_1                                                   <10                                             10
1410405 1410405 TX HASKELL COUNTY   school 4833960 104907   PAINT CREEK ISD 483396003777 104907001 PAINT CREEK SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1410434 1410434 TX CONCHO COUNTY   school 4833980 48903   PAINT ROCK ISD 483398009184 48903190 WALL SPECIAL PROGRAMS   Alternative School No Elementary 01 07 2021   grade_1                                                   <10                                             10
1410485 1410485 TX PALO PINTO COUNTY   school 4834140 182906   PALO PINTO ISD 483414003795 182906101 PALO PINTO EL   Regular School No Elementary PK 06 2021   grade_1                                                   <10                                             10
1410558 1410558 TX COLEMAN COUNTY   school 4800007 42905   PANTHER CREEK CISD 480000706343 42905001 PANTHER CREEK SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1410935 1410935 TX DICKENS COUNTY   school 4834380 63906   PATTON SPRINGS ISD 483438003858 63906001 PATTON SPRINGS SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1412725 1412725 TX MILLS COUNTY   school 4835820 167904   PRIDDY ISD 483582004057 167904001 PRIDDY SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1413113 1413113 TX DUVAL COUNTY   school 4836420 66005   RAMIREZ CSD 483642004086 66005101 RAMIREZ EL   Regular School No Elementary PK 06 2021   grade_1                                                   <10                                             10
1413820 1413820 TX SAN SABA COUNTY   school 4837080 206902   RICHLAND SPRINGS ISD 483708004169 206902001 RICHLAND SPRINGS SCHOOL   Regular School No Other KG 12 2021   grade_1                                                   <10                                             10
1414857 1414857 TX HASKELL COUNTY   school 4838280 104903   RULE ISD 483828004270 104903001 RULE SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1415296 1415296 TX BEXAR COUNTY   school 4838730 15907   SAN ANTONIO ISD 483873000289 15907201 CHILDREN'S SHELTER OF SA   Alternative School No Elementary PK 05 2021   grade_1                                                   <10                                             10
1415300 1415300 TX BEXAR COUNTY   school 4838730 15907   SAN ANTONIO ISD 483873002915 15907184 CHRISTUS SANTA ROSA   Alternative School No Other 01 10 2021   grade_1                                                   <10                                             10
1417027 1417027 TX HUDSPETH COUNTY   school 4840200 115902   SIERRA BLANCA ISD 484020004558 115902001 SIERRA BLANCA SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1417104 1417104 TX COOKE COUNTY   school 4840380 49909   SIVELLS BEND ISD 484038004574 49909101 SIVELLS BEND EL   Regular School No Elementary PK 08 2021   grade_1                                                   <10                                             10
1417701 1417701 TX GARZA COUNTY   school 4840890 85903   SOUTHLAND ISD 484089004650 85903001 SOUTHLAND SCHOOL   Regular School No Other KG 12 2021   grade_1                                                   10                                             10
1417877 1417877 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006313011 15807101 SOUTHWEST PREP NORTHWEST EL   Regular School Yes Elementary PK 02 2021   grade_1                                                   <10                                             10
1417918 1417918 TX HARRIS COUNTY   school 4800125 101838   SOUTHWEST SCHOOL 480012508252 101838004 PHOENIX SCHOOL AT SOUTHWEST SCHOOL   Alternative School Yes Other KG 12 2021   grade_1                                                   <10                                             10
1418141 1418141 TX HARRIS COUNTY   school 4841100 101920   SPRING BRANCH ISD 484110013209 101920018 SPRING BRANCH ACADEMIC INSTITUTE   Regular School No Other KG 11 2021   grade_1                                                   <10                                             10
1418715 1418715 TX STERLING COUNTY   school 4841550 216901   STERLING CITY ISD 484155009373 216901180 WALL SPECIAL PROGRAMS   Alternative School No Elementary 01 07 2021   grade_1                                                   <10                                             10
1419128 1419128 TX BREWSTER COUNTY   school 4842390 22004   TERLINGUA CSD 484239007193 22004001 BIG BEND H S   Regular School No Other KG 12 2021   grade_1                                                   <10                                             10
1419142 1419142 TX TERRELL COUNTY   school 4842420 222901   TERRELL COUNTY ISD 484242004837 222901001 SANDERSON SCHOOLS   Regular School No Other PK 12 2021   grade_1                                                   <10                                             10
1419189 1419189 TX KAUFMAN COUNTY   school 4842450 129906   TERRELL ISD 484245005604 129906104 TISD CHILD & ADOLESCENT SCHOOL   Regular School No Other 01 11 2021   grade_1                                                   <10                                             10
1419771 1419771 TX HAYS COUNTY   school 4800194 105802   TEXAS PREPARATORY SCHOOL 480019412933 105802101 TEXAS PREPARATORY SCHOOL - AUSTIN   Regular School Yes Elementary KG 06 2021   grade_1                                                   <10                                             10
1419794 1419794 TX MONTGOMERY COUNTY   school 4800151 170801   TEXAS SERENITY ACADEMY 480015113543 170801004 TEXAS SERENITY ACADEMY - GANO   Regular School Yes Elementary KG 05 2021   grade_1                                                   <10                                             10
1419974 1419974 TX THROCKMORTON COUNTY   school 4842780 224901   THROCKMORTON COLLEGIATE ISD 484278004880 224901001 THROCKMORTON COLLEGIATE ISD   Regular School Yes Other PK 12 2021   grade_1                                                   <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]);