enrollments

Data source: Big Local News · About: Big Local

3,371,677 rows sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
1386503 1386503 TX HARRIS COUNTY   school 4816530 101908   DEER PARK ISD 481653001415 101908001 DEER PARK H S   Regular School No High 08 12 2021   grade_12                                                   <940                                             940
1375006 1375006 TX PARKER COUNTY   school 4807780 184907   ALEDO ISD 480778006501 184907102 CODER EL   Regular School No Elementary PK 05 2021   kindergarten                                                   <90                                             90
1375011 1375011 TX PARKER COUNTY   school 4807780 184907   ALEDO ISD 480778006501 184907102 CODER EL   Regular School No Elementary PK 05 2021   grade_5                                                   <90                                             90
1375023 1375023 TX PARKER COUNTY   school 4807780 184907   ALEDO ISD 480778008897 184907103 STUARD EL   Regular School No Elementary PK 05 2021   grade_1                                                   <90                                             90
1375121 1375121 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783007622 101903121 BUSH EL   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   <90                                             90
1375433 1375433 TX COLLIN COUNTY   school 4807890 43901   ALLEN ISD 480789008726 43901111 KERR EL   Regular School No Elementary PK 06 2021   grade_4                                                   <90                                             90
1375778 1375778 TX POTTER COUNTY   school 4808130 188901   AMARILLO ISD 480813000153 188901105 EASTRIDGE EL   Regular School No Elementary PK 05 2021   grade_3                                                   <90                                             90
1376115 1376115 TX ANDREWS COUNTY   school 4808280 2901   ANDREWS ISD 480828005844 2901105 CLEARFORK EL   Regular School No Elementary PK 01 2021   pre_kindergarten                                                   <90                                             90
1377027 1377027 TX DENTON COUNTY   school 4808910 61907   AUBREY ISD 480891000287 61907101 HL BROCKETT   Regular School No Elementary KG 05 2021   grade_2                                                   <90                                             90
1377926 1377926 TX TARRANT COUNTY   school 4809200 220915   AZLE ISD 480920005401 220915105 LIBERTY EL   Regular School No Elementary KG 04 2021   grade_2                                                   <90                                             90
1377970 1377970 TX RUNNELS COUNTY   school 4809300 200901   BALLINGER ISD 480930000389 200901001 BALLINGER H S   Regular School No High 09 12 2021   grade_10                                                   <90                                             90
1378134 1378134 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957002476 11901103 CEDAR CREEK EL   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   <90                                             90
1378247 1378247 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967004635 123910105 CURTIS EL   Regular School No Elementary PK 05 2021   grade_1                                                   <90                                             90
1378311 1378311 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967012429 123910128 MARTIN EL   Regular School No Elementary PK 05 2021   grade_4                                                   <90                                             90
1379683 1379683 TX BROOKS COUNTY   school 4811580 24901   BROOKS COUNTY ISD 481158000632 24901103 LASATER EL   Regular School No Elementary PK KG 2021   kindergarten                                                   <90                                             90
1379763 1379763 TX CAMERON COUNTY   school 4811680 31901   BROWNSVILLE ISD 481168012172 31901008 BROWNSVILLE EARLY COLLEGE H S   Regular School No High 09 12 2021   grade_12                                                   <90                                             90
1379869 1379869 TX CAMERON COUNTY   school 4811680 31901   BROWNSVILLE ISD 481168007821 31901134 HUDSON EL   Regular School No Elementary PK 05 2021   kindergarten                                                   <90                                             90
1380018 1380018 TX CAMERON COUNTY   school 4811680 31901   BROWNSVILLE ISD 481168005416 31901126 VERMILLION ROAD EL   Regular School No Elementary PK 05 2021   grade_1                                                   <90                                             90
1380412 1380412 TX JOHNSON COUNTY   school 4812180 126902   BURLESON ISD 481218011540 126902109 JUDY HAJEK EL   Regular School No Elementary PK 05 2021   kindergarten                                                   <90                                             90
1380812 1380812 TX RANDALL COUNTY   school 4812810 191901   CANYON ISD 481281006372 191901106 ARDEN ROAD EL   Regular School No Elementary PK 04 2021   kindergarten                                                   <90                                             90
1380833 1380833 TX RANDALL COUNTY   school 4812810 191901   CANYON ISD 481281007090 191901107 CRESTVIEW EL   Regular School No Elementary PK 04 2021   grade_1                                                   <90                                             90
1381270 1381270 TX DALLAS COUNTY   school 4813230 57904   CEDAR HILL ISD 481323012181 57904003 CEDAR HILL COLLEGIATE H S   Regular School No High 09 12 2021   grade_10                                                   <90                                             90
1382209 1382209 TX LIBERTY COUNTY   school 4814370 146901   CLEVELAND ISD 481437013664 146901105 COTTONWOOD EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1382906 1382906 TX MCLENNAN COUNTY   school 4814970 161921   CONNALLY ISD 481497013354 161921106 CONNALLY EARLY CHILDHOOD CENTER   Regular School No Elementary PK KG 2021   pre_kindergarten                                                   <90                                             90
1383165 1383165 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500001012 170902103 RUNYAN EL   Regular School No Elementary PK 04 2021   grade_2                                                   <90                                             90
1383668 1383668 TX NUECES COUNTY   school 4815270 178904   CORPUS CHRISTI ISD 481527001073 178904003 ROY MILLER H S AND METRO SCHOOL OF   Regular School No High 07 12 2021   grade_8                                                   <90                                             90
1384514 1384514 TX HARRIS COUNTY   school 4816110 101907   CYPRESS-FAIRBANKS ISD 481611005685 101907117 FRAZIER EL   Regular School No Elementary PK 05 2021   kindergarten                                                   <90                                             90
1384806 1384806 TX HARRIS COUNTY   school 4816110 101907   CYPRESS-FAIRBANKS ISD 481611009630 101907141 TIPPS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1385460 1385460 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623010575 57905284 HIGHLAND MEADOWS EL   Regular School No Elementary PK 05 2021   grade_4                                                   <90                                             90
1385632 1385632 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623012062 57905107 JOSE 'JOE' MAY EL   Regular School No Elementary PK 06 2021   grade_4                                                   <90                                             90
1385689 1385689 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623001296 57905167 KLEBERG EL   Regular School No Elementary PK 05 2021   grade_3                                                   <90                                             90
1386772 1386772 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674006092 61901112 EVERS PARK EL   Regular School No Elementary PK 05 2021   grade_1                                                   <90                                             90
1386908 1386908 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674010611 61901119 SAVANNAH EL   Regular School No Elementary PK 05 2021   kindergarten                                                   <90                                             90
1387619 1387619 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770006095 220918104 BRYSON EL   Regular School No Elementary PK 05 2021   grade_4                                                   <90                                             90
1387654 1387654 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770013221 220918115 DOZIER EL   Regular School No Elementary PK 05 2021   grade_4                                                   <90                                             90
1387657 1387657 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770001532 220918102 EAGLE MOUNTAIN EL   Regular School No Elementary PK 05 2021   kindergarten                                                   <90                                             90
1387687 1387687 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770009059 220918106 HIGH COUNTRY EL   Regular School No Elementary PK 05 2021   grade_1                                                   <90                                             90
1387754 1387754 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770012416 220918114 WILLOW CREEK EL   Regular School No Elementary PK 05 2021   grade_2                                                   <90                                             90
1387858 1387858 TX MAVERICK COUNTY   school 4817730 159901   EAGLE PASS ISD 481773007987 159901115 SAM HOUSTON EL   Regular School No Elementary 01 06 2021   grade_2                                                   <90                                             90
1388040 1388040 TX CHAMBERS COUNTY   school 4817880 36903   EAST CHAMBERS ISD 481788013732 36903103 EAST CHAMBERS PRI   Regular School No Elementary PK 02 2021   kindergarten                                                   <90                                             90
1388756 1388756 TX JACKSON COUNTY   school 4818210 120901   EDNA ISD 481821001651 120901001 EDNA H S   Regular School No High 09 12 2021   grade_11                                                   <90                                             90
1389350 1389350 TX BASTROP COUNTY   school 4818360 11902   ELGIN ISD 481836001730 11902102 ELGIN EL   Regular School No Elementary PK 04 2021   grade_3                                                   <90                                             90
1389361 1389361 TX BASTROP COUNTY   school 4818360 11902   ELGIN ISD 481836010393 11902103 NEIDIG EL   Regular School No Elementary PK 04 2021   kindergarten                                                   <90                                             90
1389492 1389492 TX HENDERSON COUNTY   school 4818720 107905   EUSTACE ISD 481872001750 107905101 EUSTACE PRI   Regular School No Elementary PK 02 2021   pre_kindergarten                                                   <90                                             90
1389811 1389811 TX WILSON COUNTY   school 4819350 247901   FLORESVILLE ISD 481935012576 247901106 FLORESVILLE SOUTH EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1390224 1390224 TX FORT BEND COUNTY   school 4819650 79907   FORT BEND ISD 481965008786 79907139 LULA BELLE GOODMAN EL   Regular School No Elementary PK 05 2021   kindergarten                                                   <90                                             90
1390297 1390297 TX FORT BEND COUNTY   school 4819650 79907   FORT BEND ISD 481965006106 79907121 PALMER EL   Regular School No Elementary PK 05 2021   grade_1                                                   <90                                             90
1390357 1390357 TX FORT BEND COUNTY   school 4819650 79907   FORT BEND ISD 481965010672 79907142 SCANLAN OAKS EL   Regular School No Elementary PK 05 2021   kindergarten                                                   <90                                             90
1391231 1391231 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001926 220905176 WAVERLY PARK EL   Regular School No Elementary PK 05 2021   grade_1                                                   <90                                             90
1391682 1391682 TX COLLIN COUNTY   school 4820010 43905   FRISCO ISD 482001013002 43905138 MCSPEDDEN EL   Regular School No Elementary PK 05 2021   kindergarten                                                   <90                                             90
1391976 1391976 TX HARRIS COUNTY   school 4820250 101910   GALENA PARK ISD 482025001981 101910102 CLOVERLEAF EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1393038 1393038 TX GOLIAD COUNTY   school 4821030 88902   GOLIAD ISD 482103002096 88902001 GOLIAD H S   Regular School No High 09 12 2021   grade_10                                                   <90                                             90
1393039 1393039 TX GOLIAD COUNTY   school 4821030 88902   GOLIAD ISD 482103002096 88902001 GOLIAD H S   Regular School No High 09 12 2021   grade_11                                                   <90                                             90
1393168 1393168 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115005479 101911117 HOPPER PRI   Regular School No Elementary PK 01 2021   pre_kindergarten                                                   <90                                             90
1393353 1393353 TX HOOD COUNTY   school 4821390 111901   GRANBURY ISD 482139006419 111901105 NETTIE BACCUS EL   Regular School No Elementary PK 05 2021   grade_1                                                   <90                                             90
1393420 1393420 TX DALLAS COUNTY   school 4821420 57910   GRAND PRAIRIE ISD 482142008523 57910126 ERVIN C WHITT EL   Regular School No Elementary PK 05 2021   kindergarten                                                   <90                                             90
1393479 1393479 TX DALLAS COUNTY   school 4821420 57910   GRAND PRAIRIE ISD 482142012066 57910131 HOBBS WILLIAMS EL   Regular School No Elementary PK 05 2021   grade_3                                                   <90                                             90
1393621 1393621 TX VAN ZANDT COUNTY   school 4821450 234904   GRAND SALINE ISD 482145005483 234904041 GRAND SALINE MIDDLE   Regular School No Middle 06 08 2021   grade_8                                                   <90                                             90
1393683 1393683 TX TOM GREEN COUNTY   school 4821600 226907   GRAPE CREEK ISD 482160007458 226907001 GRAPE CREEK H S   Regular School No High 09 12 2021   grade_9                                                   <90                                             90
1394586 1394586 TX CAMERON COUNTY   school 4822530 31903   HARLINGEN CISD 482253005487 31903117 TREASURE HILLS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1395357 1395357 TX WALLER COUNTY   school 4822920 237902   HEMPSTEAD ISD 482292002321 237902001 HEMPSTEAD H S   Regular School No High 09 12 2021   grade_11                                                   <90                                             90
1395810 1395810 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364002387 101912104 ALMEDA EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1395897 1395897 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364001389 101912295 BENAVIDEZ EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1396664 1396664 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364002523 101912196 LONGFELLOW EL   Regular School No Elementary PK 05 2021   grade_1                                                   <90                                             90
1397115 1397115 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364010744 101912353 SCHOOL AT ST GEORGE PLACE   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1397611 1397611 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391002642 101913106 BEAR BRANCH EL   Regular School No Elementary PK 05 2021   grade_1                                                   <90                                             90
1397664 1397664 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391002644 101913104 FOSTER EL   Regular School No Elementary PK 05 2021   grade_5                                                   <90                                             90
1397667 1397667 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391005747 101913109 GREENTREE EL   Regular School No Elementary PK 05 2021   grade_1                                                   <90                                             90
1397731 1397731 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391002649 101913102 LAKELAND EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1397777 1397777 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391010757 101913122 PARK LAKES EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1397803 1397803 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391010758 101913123 RIVER PINES EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1399903 1399903 TX BEXAR COUNTY   school 4824990 15916   JUDSON ISD 482499010447 15916116 RICARDO SALINAS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1399911 1399911 TX BEXAR COUNTY   school 4824990 15916   JUDSON ISD 482499012467 15916118 ROLLING MEADOWS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1400475 1400475 TX JOHNSON COUNTY   school 4825230 126906   KEENE ISD 482523006726 126906001 KEENE H S   Regular School No High 09 12 2021   grade_11                                                   <90                                             90
1400704 1400704 TX KAUFMAN COUNTY   school 4825320 129904   KEMP ISD 482532002825 129904101 KEMP PRI   Regular School No Elementary PK 02 2021   pre_kindergarten                                                   <90                                             90
1400875 1400875 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566013235 14906140 ALICE W DOUSE EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1400977 1400977 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566012378 14906138 HAYNES EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1401839 1401839 TX HARDIN COUNTY   school 4825920 100903   KOUNTZE ISD 482592002919 100903002 KOUNTZE H S   Regular School No High 09 12 2021   grade_9                                                   <90                                             90
1402916 1402916 TX WEBB COUNTY   school 4826790 240901   LAREDO ISD 482679003016 240901121 H B ZACHRY EL   Regular School No Elementary PK 05 2021   grade_5                                                   <90                                             90
1403930 1403930 TX LIBERTY COUNTY   school 4827450 146906   LIBERTY ISD 482745003089 146906102 SAN JACINTO EL   Regular School No Elementary PK 01 2021   pre_kindergarten                                                   <90                                             90
1404143 1404143 TX DENTON COUNTY   school 4827720 61914   LITTLE ELM ISD 482772010626 61914107 LAKEVIEW EL   Regular School No Elementary PK 05 2021   grade_3                                                   <90                                             90
1404360 1404360 TX GREGG COUNTY   school 4828110 92903   LONGVIEW ISD 482811013615 92903127 BRAMLETTE STEAM ACADEMY   Regular School Yes Elementary PK 05 2021   grade_1                                                   <90                                             90
1405068 1405068 TX ANGELINA COUNTY   school 4828550 3903   LUFKIN ISD 482855007774 3903130 TROUT PRI   Regular School No Elementary PK 02 2021   grade_1                                                   <90                                             90
1405135 1405135 TX ATASCOSA COUNTY   school 4828650 7904   LYTLE ISD 482865008424 7904103 LYTLE PRIMARY SCHOOL   Regular School No Elementary PK 01 2021   pre_kindergarten                                                   <90                                             90
1405142 1405142 TX KAUFMAN COUNTY   school 4828680 129905   MABANK ISD 482868007372 129905103 CENTRAL EL   Regular School No Elementary PK 04 2021   grade_2                                                   <90                                             90
1405584 1405584 TX TARRANT COUNTY   school 4828920 220908   MANSFIELD ISD 482892013423 220908009 TCCSE EARLY COLLEGE H S AT TIMBERV   Regular School No High 09 12 2021   grade_11                                                   <90                                             90
1406848 1406848 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042003424 147903103 A B MCBAY EL   Regular School No Elementary PK 02 2021   pre_kindergarten                                                   <90                                             90
1407478 1407478 TX HIDALGO COUNTY   school 4831040 108908   MISSION CISD 483104009483 108908115 HURLA M MIDKIFF EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1407500 1407500 TX HIDALGO COUNTY   school 4831040 108908   MISSION CISD 483104006146 108908110 MIMS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1408264 1408264 TX MONTGOMERY COUNTY   school 4832400 170908   NEW CANEY ISD 483240013059 170908007 INFINITY EARLY COLLEGE H S   Regular School No High 09 12 2021   grade_11                                                   <90                                             90
1408666 1408666 TX BEXAR COUNTY   school 4832940 15910   NORTH EAST ISD 483294003633 15910103 COLONIAL HILLS EL   Regular School No Elementary PK 05 2021   grade_3                                                   <90                                             90
1408764 1408764 TX BEXAR COUNTY   school 4832940 15910   NORTH EAST ISD 483294006590 15910107 JACKSON-KELLER EL   Regular School No Elementary PK 05 2021   grade_1                                                   <90                                             90
1410035 1410035 TX DENTON COUNTY   school 4833180 61911   NORTHWEST ISD 483318012004 61911115 SENDERA RANCH EL   Regular School No Elementary PK 05 2021   grade_1                                                   <90                                             90
1411550 1411550 TX HIDALGO COUNTY   school 4834860 108909   PHARR-SAN JUAN-ALAMO ISD 483486003917 108909107 GERALDINE PALMER EL   Regular School No Elementary PK 05 2021   grade_3                                                   <90                                             90
1411561 1411561 TX HIDALGO COUNTY   school 4834860 108909   PHARR-SAN JUAN-ALAMO ISD 483486003915 108909108 HENRY FORD EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1411593 1411593 TX HIDALGO COUNTY   school 4834860 108909   PHARR-SAN JUAN-ALAMO ISD 483486006598 108909117 KELLY-PHARR EL   Regular School No Elementary PK 05 2021   grade_5                                                   <90                                             90
1412983 1412983 TX COLLIN COUNTY   school 4836000 43912   PROSPER ISD 483600004063 43912101 R STEVE FOLSOM EL   Regular School No Elementary PK 05 2021   kindergarten                                                   <90                                             90
1414518 1414518 TX WILLIAMSON COUNTY   school 4838080 246909   ROUND ROCK ISD 483808011105 246909135 CHANDLER OAKS EL   Regular School No Elementary PK 05 2021   grade_4                                                   <90                                             90
1414885 1414885 TX CHEROKEE COUNTY   school 4838360 37907   RUSK ISD 483836005807 37907103 GW BRADFORD PRI   Regular School No Elementary PK 01 2021   pre_kindergarten                                                   <90                                             90
1415936 1415936 TX DUVAL COUNTY   school 4838820 66902   SAN DIEGO ISD 483882004428 66902101 COLLINS-PARR EL   Regular School No Elementary PK 05 2021   grade_2                                                   <90                                             90

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