enrollments

Data source: Big Local News · About: Big Local

7,227 rows where grade = "pre_kindergarten" and state = "TX" sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pre_kindergarten · 7,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 ▼
1374590 1374590 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1376049 1376049 TX LAMB COUNTY   school 4808160 140901   AMHERST ISD 480816000188 140901001 AMHERST SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1377823 1377823 TX REFUGIO COUNTY   school 4809000 196901   AUSTWELL-TIVOLI ISD 480900000372 196901102 AUSTWELL-TIVOLI EL   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   <10                                             10
1377865 1377865 TX CASS COUNTY   school 4809090 34902   AVINGER ISD 480909000378 34902001 AVINGER SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1377981 1377981 TX REEVES COUNTY   school 4809330 195902   BALMORHEA ISD 480933000392 195902001 BALMORHEA SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1378393 1378393 TX CLAY COUNTY   school 4809750 39904   BELLEVUE ISD 480975000446 39904001 BELLEVUE SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1378538 1378538 TX DUVAL COUNTY   school 4899130 66901   BENAVIDES ISD 489913005628 66901041 BENAVIDES EL   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   <10                                             10
1378552 1378552 TX KNOX COUNTY   school 4809980 138904   BENJAMIN ISD 480998000468 138904001 BENJAMIN SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1378883 1378883 TX NUECES COUNTY   school 4810260 178902   BISHOP CISD 481026000510 178902103 PETRONILA EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1378891 1378891 TX NOLAN COUNTY   school 4800005 177903   BLACKWELL CISD 480000500513 177903001 BLACKWELL SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   10                                             10
1378935 1378935 TX BROWN COUNTY   school 4810380 25904   BLANKET ISD 481038005661 25904001 BLANKET SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1378980 1378980 TX VICTORIA COUNTY   school 4810500 235901   BLOOMINGTON ISD 481050000526 235901101 BLOOMINGTON EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1379105 1379105 TX KENDALL COUNTY   school 4810710 130901   BOERNE ISD 481071007055 130901103 FAIR OAKS RANCH EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   10                                             10
1379129 1379129 TX KENDALL COUNTY   school 4810710 130901   BOERNE ISD 481071011292 130901106 VAN RAUB EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1379607 1379607 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155000627 25908001 BROOKESMITH SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1380255 1380255 TX PECOS COUNTY   school 4811910 186901   BUENA VISTA ISD 481191000699 186901001 BUENA VISTA SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1380536 1380536 TX HILL COUNTY   school 4812360 109902   BYNUM ISD 481236000730 109902001 BYNUM SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1380632 1380632 TX CALHOUN COUNTY   school 4812480 29901   CALHOUN COUNTY ISD 481248000749 29901105 PORT O CONNOR EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1380670 1380670 TX ROBERTSON COUNTY   school 4812540 198902   CALVERT ISD 481254000756 198902101 CALVERT SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1381424 1381424 TX TRINITY COUNTY   school 4813380 228904   CENTERVILLE ISD 481338000839 228904001 CENTERVILLE H S   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1381534 1381534 TX HARTLEY COUNTY   school 4813620 103901   CHANNING ISD 481362000857 103901001 CHANNING SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1381634 1381634 TX TYLER COUNTY   school 4813770 229906   CHESTER ISD 481377000867 229906101 CHESTER EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1381988 1381988 TX GALVESTON COUNTY   school 4814280 84910   CLEAR CREEK ISD 481428009248 84910124 FALCON PASS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   10                                             10
1383812 1383812 TX HALE COUNTY   school 4815360 95902   COTTON CENTER ISD 481536001112 95902001 COTTON CENTER SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1383871 1383871 TX KAUFMAN COUNTY   school 4815510 129901   CRANDALL ISD 481551012027 129901103 BARBARA WALKER EL   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   <10                                             10
1383939 1383939 TX BOSQUE COUNTY   school 4815570 18908   CRANFILLS GAP ISD 481557001129 18908001 CRANFILLS GAP SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1384279 1384279 TX SMITH COUNTY   school 4800034 212801   CUMBERLAND ACADEMY 480003408020 212801101 CUMBERLAND ACADEMY   Alternative School Yes Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1384874 1384874 TX MEDINA COUNTY   school 4816140 163902   D'HANIS ISD 481614001195 163902001 D'HANIS SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   10                                             10
1386337 1386337 TX BRAZORIA COUNTY   school 4816260 20910   DAMON ISD 481626001391 20910101 DAMON EL   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   <10                                             10
1386348 1386348 TX BRAZORIA COUNTY   school 4816290 20904   DANBURY ISD 481629001392 20904101 DANBURY EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1386641 1386641 TX HUDSPETH COUNTY   school 4816650 115903   DELL CITY ISD 481665001429 115903001 DELL CITY SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1386682 1386682 TX GRAYSON COUNTY   school 4816710 91903   DENISON ISD 481671001440 91903112 MAYES EL   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   <10                                             10
1386711 1386711 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674011871 61901122 BLANTON EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1386795 1386795 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674010610 61901118 HAWK EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1387055 1387055 TX FREESTONE COUNTY   school 4816980 81906   DEW ISD 481698001471 81906101 DEW EL   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   10                                             10
1387216 1387216 TX KERR COUNTY   school 4817190 133905   DIVIDE ISD 481719001490 133905101 DIVIDE EL   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   <10                                             10
1387372 1387372 TX GILLESPIE COUNTY   school 4817400 86024   DOSS CONSOLIDATED CSD 481740001503 86024101 DOSS EL   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   <10                                             10
1388928 1388928 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830005983 71902142 COLLINS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   10                                             10
1389269 1389269 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830001720 71902146 WESTERN HILLS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   10                                             10
1389610 1389610 TX SHELBY COUNTY   school 4818840 210906   EXCELSIOR ISD 481884001762 210906101 EXCELSIOR EL   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   <10                                             10
1389620 1389620 TX LAVACA COUNTY   school 4818890 143906   EZZELL ISD 481889001764 143906101 EZZELL EL   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   <10                                             10
1389859 1389859 TX LIPSCOMB COUNTY   school 4819500 148902   FOLLETT ISD 481950001806 148902001 FOLLETT SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1389874 1389874 TX MONTAGUE COUNTY   school 4819530 169910   FORESTBURG ISD 481953001808 169910001 FORESTBURG SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1391908 1391908 TX JEFF DAVIS COUNTY   school 4820100 122901   FT DAVIS ISD 482010001962 122901001 FT DAVIS SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   10                                             10
1392236 1392236 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034002014 57909103 CALDWELL EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   10                                             10
1392300 1392300 TX DALLAS COUNTY   school 4820340 57909   GARLAND ISD 482034002023 57909109 FREEMAN EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1392846 1392846 TX MCLENNAN COUNTY   school 4820610 161925   GHOLSON ISD 482061002073 161925101 GHOLSON SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1392953 1392953 TX MONTAGUE COUNTY   school 4820970 169906   GOLD BURG ISD 482097002091 169906001 GOLD BURG SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1393059 1393059 TX POLK COUNTY   school 4821090 187903   GOODRICH ISD 482109001873 187903101 GOODRICH EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1393244 1393244 TX PALO PINTO COUNTY   school 4821180 182901   GORDON ISD 482118002125 182901001 GORDON SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1393272 1393272 TX MARTIN COUNTY   school 4821300 156905   GRADY ISD 482130002131 156905001 GRADY SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1394024 1394024 TX CARSON COUNTY   school 4821840 33901   GROOM ISD 482184002205 33901001 GROOM SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1394082 1394082 TX COMANCHE COUNTY   school 4821990 47903   GUSTINE ISD 482199002215 47903001 GUSTINE SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1394096 1394096 TX KING COUNTY   school 4822020 135001   GUTHRIE CSD 482202002217 135001001 GUTHRIE SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   10                                             10
1395086 1395086 TX HARTLEY COUNTY   school 4822680 103902   HARTLEY ISD 482268002302 103902001 HARTLEY SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1395315 1395315 TX DONLEY COUNTY   school 4822850 65902   HEDLEY ISD 482285002317 65902001 HEDLEY SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1395515 1395515 TX GALVESTON COUNTY   school 4823160 84903   HIGH ISLAND ISD 482316002351 84903001 HIGH ISLAND SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1395597 1395597 TX DALLAS COUNTY   school 4823250 57911   HIGHLAND PARK ISD 482325002358 57911103 HYER EL   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   <10                                             10
1395952 1395952 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364002406 101912116 BRIARGROVE EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1400176 1400176 TX HARRIS COUNTY   school 4825170 101914   KATY ISD 482517002808 101914102 KATY EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1400676 1400676 TX WHEELER COUNTY   school 4825290 242905   KELTON ISD 482529005755 242905001 KELTON SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1401818 1401818 TX BOSQUE COUNTY   school 4825890 18907   KOPPERL ISD 482589002917 18907001 KOPPERL SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1401932 1401932 TX JIM WELLS COUNTY   school 4826070 125906   LA GLORIA ISD 482607002931 125906101 LA GLORIA EL   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   <10                                             10
1403376 1403376 TX GRAY COUNTY   school 4827090 90902   LEFORS ISD 482709003047 90902001 LEFORS SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1404291 1404291 TX MCCULLOCH COUNTY   school 4827930 160905   LOHN ISD 482793003132 160905001 LOHN SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1404380 1404380 TX GREGG COUNTY   school 4828110 92903   LONGVIEW ISD 482811012528 92903122 J L EVERHART MAGNET EL   Regular School Yes Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1404387 1404387 TX GREGG COUNTY   school 4828110 92903   LONGVIEW ISD 482811012529 92903123 JOHNSTON-MCQUEEN EL   Regular School Yes Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1404410 1404410 TX GREGG COUNTY   school 4828110 92903   LONGVIEW ISD 482811012484 92903126 NED E WILLIAMS EL   Regular School Yes Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1405003 1405003 TX JONES COUNTY   school 4828530 127905   LUEDERS-AVOCA ISD 482853003224 127905101 LUEDERS-AVOCA EL/J H   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   <10                                             10
1405601 1405601 TX BREWSTER COUNTY   school 4828980 22902   MARATHON ISD 482898003272 22902001 MARATHON INDEPENDENT SCHOOL DIST   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1405804 1405804 TX MATAGORDA COUNTY   school 4829370 158904   MATAGORDA ISD 482937003310 158904101 MATAGORDA SCHOOL   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   10                                             10
1405844 1405844 TX BROWN COUNTY   school 4829520 25905   MAY ISD 482952003318 25905101 MAY EL   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   <10                                             10
1407262 1407262 TX CLAY COUNTY   school 4830660 39905   MIDWAY ISD 483066003461 39905001 MIDWAY SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1407685 1407685 TX SHACKELFORD COUNTY   school 4831320 209902   MORAN ISD 483132003518 209902001 MORAN SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1407699 1407699 TX BOSQUE COUNTY   school 4831380 18903   MORGAN ISD 483138003520 18903001 MORGAN SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1407874 1407874 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192005557 167902001 MULLIN MAIN   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1408061 1408061 TX CASTRO COUNTY   school 4832220 35903   NAZARETH ISD 483222003573 35903001 NAZARETH SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   10                                             10
1408094 1408094 TX JEFFERSON COUNTY   school 4832280 123905   NEDERLAND ISD 483228003577 123905101 HELENA PARK EL   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   10                                             10
1408115 1408115 TX JEFFERSON COUNTY   school 4832280 123905   NEDERLAND ISD 483228003580 123905104 LANGHAM EL   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   10                                             10
1409130 1409130 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312011468 15915178 AUE EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1409138 1409138 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312009471 15915180 BEARD EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1409440 1409440 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312003715 15915004 HOLMGREEN CENTER   Alternative School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1409483 1409483 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312013247 15915223 KALLISON EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1409507 1409507 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312012098 15915191 KUENTZ EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1409523 1409523 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312021115 15915152 LEON SPRINGS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1410064 1410064 TX DENTON COUNTY   school 4833180 61911   NORTHWEST ISD 483318007876 61911110 W R HATFIELD EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1410103 1410103 TX EDWARDS COUNTY   school 4833240 69902   NUECES CANYON CISD 483324003738 69902101 NUECES CANYON EL   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   <10                                             10
1410222 1410222 TX RUNNELS COUNTY   school 4833570 200906   OLFEN ISD 483357003754 200906101 OLFEN SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1410389 1410389 TX COTTLE COUNTY   school 4833900 51901   PADUCAH ISD 483390003775 51901001 PADUCAH SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1410403 1410403 TX HASKELL COUNTY   school 4833960 104907   PAINT CREEK ISD 483396003777 104907001 PAINT CREEK SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1410483 1410483 TX PALO PINTO COUNTY   school 4834140 182906   PALO PINTO ISD 483414003795 182906101 PALO PINTO EL   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   <10                                             10
1410933 1410933 TX DICKENS COUNTY   school 4834380 63906   PATTON SPRINGS ISD 483438003858 63906001 PATTON SPRINGS SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1411051 1411051 TX BRAZORIA COUNTY   school 4834440 20908   PEARLAND ISD 483444009143 20908110 SILVERCREST EL   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   10                                             10
1411141 1411141 TX JACK COUNTY   school 4834630 119903   PERRIN-WHITT CISD 483463003886 119903101 PERRIN EL   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   <10                                             10
1411958 1411958 TX COLLIN COUNTY   school 4835100 43910   PLANO ISD 483510003961 43910109 FORMAN EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1412498 1412498 TX CALDWELL COUNTY   school 4835700 28906   PRAIRIE LEA ISD 483570004042 28906001 PRAIRIE LEA SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   10                                             10
1412512 1412512 TX MONTAGUE COUNTY   school 4835730 169909   PRAIRIE VALLEY ISD 483573004043 169909101 PRAIRIE VALLEY EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   10                                             10
1412549 1412549 TX ERATH COUNTY   school 4800207 72801   PREMIER HIGH SCHOOLS 480020713927 72801151 FOUNDATION SCHOOL OF AUTISM - SAN   Special Education School Yes Elementary PK 01 2021   pre_kindergarten                                                   <10                                             10
1412780 1412780 TX HANSFORD COUNTY   school 4835890 98903   PRINGLE-MORSE CISD 483589004061 98903101 PRINGLE-MORSE SCHOOLS   Regular School No Other PK 09 2021   pre_kindergarten                                                   <10                                             10
1412791 1412791 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007612994 14803004 CEDAR PARK CHARTER ACADEMY   Regular School Yes Other PK 12 2021   pre_kindergarten                                                   <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]);