enrollments

Data source: Big Local News · About: Big Local

9,241 rows where grade = "grade_4" and state = "TX" sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 9,241 ✖
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 ▼
1374595 1374595 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1376054 1376054 TX LAMB COUNTY   school 4808160 140901   AMHERST ISD 480816000188 140901001 AMHERST SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1376258 1376258 TX HOCKLEY COUNTY   school 4808460 110901   ANTON ISD 480846000214 110901001 ANTON SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   10                                             10
1376374 1376374 TX HARRIS COUNTY   school 4800019 101803   ARISTOI CLASSICAL ACADEMY 480001914072 101803002 ARISTOI CLASSICAL ACADEMY   Regular School Yes Elementary KG 04 2021   grade_4                                                   10                                             10
1377692 1377692 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005396 227901251 ROSEDALE   Alternative School No Other PK 12 2021   grade_4                                                   <10                                             10
1377870 1377870 TX CASS COUNTY   school 4809090 34902   AVINGER ISD 480909000378 34902001 AVINGER SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   10                                             10
1377986 1377986 TX REEVES COUNTY   school 4809330 195902   BALMORHEA ISD 480933000392 195902001 BALMORHEA SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1378398 1378398 TX CLAY COUNTY   school 4809750 39904   BELLEVUE ISD 480975000446 39904001 BELLEVUE SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1378557 1378557 TX KNOX COUNTY   school 4809980 138904   BENJAMIN ISD 480998000468 138904001 BENJAMIN SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1378645 1378645 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022709011 193801001 BIG SPRINGS CHARTER SCHOOL   Alternative School Yes Other KG 12 2021   grade_4                                                   <10                                             10
1378658 1378658 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022711321 193801101 HILL COUNTRY YOUTH RANCH   Alternative School Yes Other KG 12 2021   grade_4                                                   <10                                             10
1378896 1378896 TX NOLAN COUNTY   school 4800005 177903   BLACKWELL CISD 480000500513 177903001 BLACKWELL SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1379295 1379295 TX OLDHAM COUNTY   school 4811040 180901   BOYS RANCH ISD 481104000570 180901101 MIMI FARLEY EL   Regular School No Elementary KG 05 2021   grade_4                                                   <10                                             10
1379345 1379345 TX SOMERVELL COUNTY   school 4800214 213801   BRAZOS RIVER CHARTER SCHOOL 480021408907 213801001 BRAZOS RIVER CHARTER SCHOOL   Alternative School Yes Other KG 12 2021   grade_4                                                   <10                                             10
1379420 1379420 TX BRAZORIA COUNTY   school 4811190 20905   BRAZOSPORT ISD 481119007528 20905004 LIGHTHOUSE LEARNING CENTER - DAEP   Alternative School No Other 04 12 2021   grade_4                                                   <10                                             10
1379547 1379547 TX DALLAS COUNTY   school 4801462 57851   BRIDGEWAY PREPARATORY ACADEMY 480146213560 57851101 BRIDGEWAY PREPARATORY ACADEMY   Regular School Yes Elementary PK 05 2021   grade_4                                                   <10                                             10
1379624 1379624 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155013724 25908003 GENESIS CAMPUS   Alternative School No Other 04 11 2021   grade_4                                                   <10                                             10
1380115 1380115 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179008456 21902014 BRAZOS CO JUVENILE DETENTION CENTE   Alternative School No Other 04 12 2021   grade_4                                                   <10                                             10
1380246 1380246 TX MILAM COUNTY   school 4811850 166907   BUCKHOLTS ISD 481185000697 166907001 BUCKHOLTS SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1380541 1380541 TX HILL COUNTY   school 4812360 109902   BYNUM ISD 481236000730 109902001 BYNUM SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   10                                             10
1380675 1380675 TX ROBERTSON COUNTY   school 4812540 198902   CALVERT ISD 481254000756 198902101 CALVERT SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1381060 1381060 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305005854 57903117 HUIE SPECIAL EDUC CTR   Alternative School No Other PK 12 2021   grade_4                                                   <10                                             10
1381429 1381429 TX TRINITY COUNTY   school 4813380 228904   CENTERVILLE ISD 481338000839 228904001 CENTERVILLE H S   Regular School No Other PK 12 2021   grade_4                                                   10                                             10
1382884 1382884 TX HARRIS COUNTY   school 4800127 101842   COMQUEST ACADEMY 480012708255 101842001 COMQUEST ACADEMY   Alternative School Yes Other KG 12 2021   grade_4                                                   <10                                             10
1383756 1383756 TX NUECES COUNTY   school 4800279 178807   CORPUS CHRISTI MONTESSORI SCHOOL 480027911317 178807101 CORPUS CHRISTI MONTESSORI SCHOOL   Regular School Yes Elementary 01 08 2021   grade_4                                                   <10                                             10
1383944 1383944 TX BOSQUE COUNTY   school 4815570 18908   CRANFILLS GAP ISD 481557001129 18908001 CRANFILLS GAP SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1385476 1385476 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006391 57905099 HOSPITAL/HOMEBOUND   Alternative School No Other KG 12 2021   grade_4                                                   <10                                             10
1386367 1386367 TX LIPSCOMB COUNTY   school 4816320 148905   DARROUZETT ISD 481632001699 148905101 DARROUZETT SCHOOLS   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1386646 1386646 TX HUDSPETH COUNTY   school 4816650 115903   DELL CITY ISD 481665001429 115903001 DELL CITY SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1387220 1387220 TX KERR COUNTY   school 4817190 133905   DIVIDE ISD 481719001490 133905101 DIVIDE EL   Regular School No Elementary PK 06 2021   grade_4                                                   <10                                             10
1387377 1387377 TX GILLESPIE COUNTY   school 4817400 86024   DOSS CONSOLIDATED CSD 481740001503 86024101 DOSS EL   Regular School No Elementary PK 08 2021   grade_4                                                   <10                                             10
1388820 1388820 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830010643 71902171 ABOUT FACE PROGRAM EL   Alternative School No Elementary 04 05 2021   grade_4                                                   <10                                             10
1389462 1389462 TX NACOGDOCHES COUNTY   school 4818660 174910   ETOILE ISD 481866001747 174910101 ETOILE EL   Regular School No Elementary PK 08 2021   grade_4                                                   <10                                             10
1389615 1389615 TX SHELBY COUNTY   school 4818840 210906   EXCELSIOR ISD 481884001762 210906101 EXCELSIOR EL   Regular School No Elementary PK 08 2021   grade_4                                                   <10                                             10
1389625 1389625 TX LAVACA COUNTY   school 4818890 143906   EZZELL ISD 481889001764 143906101 EZZELL EL   Regular School No Elementary PK 08 2021   grade_4                                                   <10                                             10
1389768 1389768 TX FAYETTE COUNTY   school 4819280 75901   FLATONIA ISD 481928012888 75901103 WHISPERING HILLS ACHIEVEMENT CENTE   Alternative School No Other 04 12 2021   grade_4                                                   <10                                             10
1389864 1389864 TX LIPSCOMB COUNTY   school 4819500 148902   FOLLETT ISD 481950001806 148902001 FOLLETT SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   10                                             10
1390502 1390502 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970007724 220905251 ASSESSMENT CTR   Alternative School No Elementary KG 08 2021   grade_4                                                   <10                                             10
1390546 1390546 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001832 220905104 BOULEVARD HEIGHTS   Alternative School No Other KG 12 2021   grade_4                                                   <10                                             10
1390614 1390614 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021056 220905210 CHILDREN'S MEDICAL CTR   Alternative School No Other KG 12 2021   grade_4                                                   <10                                             10
1390836 1390836 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005717 220905026 JO KELLY SP ED   Alternative School No Other PK 12 2021   grade_4                                                   <10                                             10
1392958 1392958 TX MONTAGUE COUNTY   school 4820970 169906   GOLD BURG ISD 482097002091 169906001 GOLD BURG SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1393000 1393000 TX DALLAS COUNTY   school 4800237 57835   GOLDEN RULE CHARTER SCHOOL 480023712866 57835104 GOLDEN RULE GRAND PRAIRIE   Regular School Yes Elementary PK 04 2021   grade_4                                                   <10                                             10
1393631 1393631 TX WARD COUNTY   school 4821480 238904   GRANDFALLS-ROYALTY ISD 482148002168 238904001 GRANDFALLS-ROYALTY SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   10                                             10
1393659 1393659 TX GRAY COUNTY   school 4821560 90905   GRANDVIEW-HOPKINS ISD 482156002172 90905101 GRANDVIEW-HOPKINS EL   Regular School No Elementary KG 06 2021   grade_4                                                   <10                                             10
1394357 1394357 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247002267 15904115 JEWEL C WIETZEL CENTER   Special Education School No Other 04 12 2021   grade_4                                                   <10                                             10
1395063 1395063 TX WILBARGER COUNTY   school 4822620 244901   HARROLD ISD 482262002298 244901001 HARROLD SCHOOL   Regular School No Other KG 12 2021   grade_4                                                   <10                                             10
1395738 1395738 TX HIDALGO COUNTY   school 4800065 108802   HORIZON MONTESSORI PUBLIC SCHOOLS 480006513976 108802104 HORIZON MONTESSORI - PEARLAND   Regular School Yes Elementary PK 08 2021   grade_4                                                   <10                                             10
1396069 1396069 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364006270 101912013 COMMUNITY SERVICES-SEC   Alternative School No Other 01 12 2021   grade_4                                                   <10                                             10
1396622 1396622 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364008608 101912340 LAS AMERICAS   Alternative School No Middle 04 08 2021   grade_4                                                   <10                                             10
1396992 1396992 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364008618 101912380 R D S P D   Special Education School No Elementary PK 04 2021   grade_4                                                   <10                                             10
1397507 1397507 TX BOWIE COUNTY   school 4823700 19913   HUBBARD ISD 482370002624 19913101 HUBBARD ISD   Regular School No Elementary PK 08 2021   grade_4                                                   <10                                             10
1398870 1398870 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313328 15808012 JHW INSPIRE ACADEMY - LEGACY RANCH   Alternative School Yes Other KG 12 2021   grade_4                                                   <10                                             10
1399105 1399105 TX BOSQUE COUNTY   school 4824360 18906   IREDELL ISD 482436002714 18906001 IREDELL SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1399739 1399739 TX BEXAR COUNTY   school 4800179 15822   JUBILEE ACADEMIES 480017913941 15822014 JUBILEE SENDERO   Regular School Yes Elementary PK 06 2021   grade_4                                                   <10                                             10
1400871 1400871 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002861 14906022 ADVENTHEALTH SCHOOL   Alternative School No Other 02 12 2021   grade_4                                                   <10                                             10
1400948 1400948 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566009455 14906100 EL ALTER LEARNING CENTER   Alternative School No Elementary 01 05 2021   grade_4                                                   <10                                             10
1401823 1401823 TX BOSQUE COUNTY   school 4825890 18907   KOPPERL ISD 482589002917 18907001 KOPPERL SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1403370 1403370 TX BOWIE COUNTY   school 4827060 19914   LEARY ISD 482706003045 19914101 LEARY EL   Regular School No Elementary PK 08 2021   grade_4                                                   <10                                             10
1403381 1403381 TX GRAY COUNTY   school 4827090 90902   LEFORS ISD 482709003047 90902001 LEFORS SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   10                                             10
1404296 1404296 TX MCCULLOCH COUNTY   school 4827930 160905   LOHN ISD 482793003132 160905001 LOHN SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1404434 1404434 TX GAINES COUNTY   school 4828140 83902   LOOP ISD 482814003154 83902001 LOOP SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1404448 1404448 TX MITCHELL COUNTY   school 4828170 168902   LORAINE ISD 482817003156 168902001 LORAINE SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   10                                             10
1404743 1404743 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850005539 152901009 HOMEBOUND   Regular School No Elementary PK 08 2021   grade_4                                                   <10                                             10
1405008 1405008 TX JONES COUNTY   school 4828530 127905   LUEDERS-AVOCA ISD 482853003224 127905101 LUEDERS-AVOCA EL/J H   Regular School No Elementary PK 08 2021   grade_4                                                   <10                                             10
1405288 1405288 TX HILL COUNTY   school 4828800 109908   MALONE ISD 482880003260 109908101 MALONE EL   Regular School No Elementary PK 08 2021   grade_4                                                   10                                             10
1405606 1405606 TX BREWSTER COUNTY   school 4828980 22902   MARATHON ISD 482898003272 22902001 MARATHON INDEPENDENT SCHOOL DIST   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1405809 1405809 TX MATAGORDA COUNTY   school 4829370 158904   MATAGORDA ISD 482937003310 158904101 MATAGORDA SCHOOL   Regular School No Elementary PK 08 2021   grade_4                                                   <10                                             10
1405849 1405849 TX BROWN COUNTY   school 4829520 25905   MAY ISD 482952003318 25905101 MAY EL   Regular School No Elementary PK 06 2021   grade_4                                                   <10                                             10
1406277 1406277 TX GRAY COUNTY   school 4829880 90903   MCLEAN ISD 482988003364 90903001 MCLEAN SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1406331 1406331 TX KENDALL COUNTY   school 4801404 130801   MEADOWLAND CHARTER DISTRICT 480140412137 130801001 OAKS ACADEMY   Alternative School Yes Other 01 11 2021   grade_4                                                   <10                                             10
1406339 1406339 TX KENDALL COUNTY   school 4801404 130801   MEADOWLAND CHARTER DISTRICT 480140413750 130801003 STEPPING STONES ACADEMY   Alternative School Yes Other 04 12 2021   grade_4                                                   <10                                             10
1407267 1407267 TX CLAY COUNTY   school 4830660 39905   MIDWAY ISD 483066003461 39905001 MIDWAY SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1407690 1407690 TX SHACKELFORD COUNTY   school 4831320 209902   MORAN ISD 483132003518 209902001 MORAN SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1407704 1407704 TX BOSQUE COUNTY   school 4831380 18903   MORGAN ISD 483138003520 18903001 MORGAN SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1407879 1407879 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192005557 167902001 MULLIN MAIN   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1409445 1409445 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312003715 15915004 HOLMGREEN CENTER   Alternative School No Other PK 12 2021   grade_4                                                   <10                                             10
1410089 1410089 TX DALLAS COUNTY   school 4800201 57827   NOVA ACADEMY SOUTHEAST 480020108755 57827101 NOVA ACADEMY CEDAR HILL   Regular School Yes Elementary PK 06 2021   grade_4                                                   <10                                             10
1410211 1410211 TX CORYELL COUNTY   school 4833420 50904   OGLESBY ISD 483342003751 50904001 OGLESBY SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   10                                             10
1410236 1410236 TX RUNNELS COUNTY   school 4833570 200906   OLFEN ISD 483357011543 200906103 WALL SPECIAL PROGRAMS   Alternative School No Elementary 04 05 2021   grade_4                                                   <10                                             10
1410408 1410408 TX HASKELL COUNTY   school 4833960 104907   PAINT CREEK ISD 483396003777 104907001 PAINT CREEK SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1410561 1410561 TX COLEMAN COUNTY   school 4800007 42905   PANTHER CREEK CISD 480000706343 42905001 PANTHER CREEK SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1410938 1410938 TX DICKENS COUNTY   school 4834380 63906   PATTON SPRINGS ISD 483438003858 63906001 PATTON SPRINGS SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1411131 1411131 TX HILL COUNTY   school 4834560 109914   PENELOPE ISD 483456003885 109914001 PENELOPE SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1412517 1412517 TX MONTAGUE COUNTY   school 4835730 169909   PRAIRIE VALLEY ISD 483573004043 169909101 PRAIRIE VALLEY EL   Regular School No Elementary PK 05 2021   grade_4                                                   <10                                             10
1412728 1412728 TX MILLS COUNTY   school 4835820 167904   PRIDDY ISD 483582004057 167904001 PRIDDY SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1412824 1412824 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007612905 14803002 GEORGETOWN CHARTER ACADEMY   Regular School Yes Elementary PK 08 2021   grade_4                                                   <10                                             10
1413116 1413116 TX DUVAL COUNTY   school 4836420 66005   RAMIREZ CSD 483642004086 66005101 RAMIREZ EL   Regular School No Elementary PK 06 2021   grade_4                                                   <10                                             10
1413441 1413441 TX GRIMES COUNTY   school 4836990 93905   RICHARDS ISD 483699004120 93905101 RICHARDS EL   Regular School No Elementary PK 06 2021   grade_4                                                   <10                                             10
1413823 1413823 TX SAN SABA COUNTY   school 4837080 206902   RICHLAND SPRINGS ISD 483708004169 206902001 RICHLAND SPRINGS SCHOOL   Regular School No Other KG 12 2021   grade_4                                                   <10                                             10
1414860 1414860 TX HASKELL COUNTY   school 4838280 104903   RULE ISD 483828004270 104903001 RULE SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1415298 1415298 TX BEXAR COUNTY   school 4838730 15907   SAN ANTONIO ISD 483873000289 15907201 CHILDREN'S SHELTER OF SA   Alternative School No Elementary PK 05 2021   grade_4                                                   <10                                             10
1417016 1417016 TX COMANCHE COUNTY   school 4840170 47905   SIDNEY ISD 484017004556 47905001 SIDNEY SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1417107 1417107 TX COOKE COUNTY   school 4840380 49909   SIVELLS BEND ISD 484038004574 49909101 SIVELLS BEND EL   Regular School No Elementary PK 08 2021   grade_4                                                   <10                                             10
1417921 1417921 TX HARRIS COUNTY   school 4800125 101838   SOUTHWEST SCHOOL 480012508252 101838004 PHOENIX SCHOOL AT SOUTHWEST SCHOOL   Alternative School Yes Other KG 12 2021   grade_4                                                   <10                                             10
1418256 1418256 TX HUTCHINSON COUNTY   school 4841130 117907   SPRING CREEK ISD 484113004707 117907101 SPRING CREEK SCHOOL   Regular School No Other KG 11 2021   grade_4                                                   <10                                             10
1418577 1418577 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1418758 1418758 TX PALO PINTO COUNTY   school 4841700 182905   STRAWN ISD 484170004759 182905001 STRAWN SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1419021 1419021 TX JEFFERSON COUNTY   school 4800139 123803   TEKOA ACADEMY OF ACCELERATED STUDI 480013912116 123803103 TEKOA ACADEMY OF ACCELERATED STUDI   Regular School Yes Elementary PK 08 2021   grade_4                                                   <10                                             10
1419131 1419131 TX BREWSTER COUNTY   school 4842390 22004   TERLINGUA CSD 484239007193 22004001 BIG BEND H S   Regular School No Other KG 12 2021   grade_4                                                   <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]);