Data source: Big Local News · About: Big Local

433 rows where grade = "pre_kindergarten", state = "IN" and year = 2018 sorted by female

View and edit SQL

year

  • 2018 · 333

grade

  • pre_kindergarten · 333
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
1794422 IN     school 1804770 5385   Indianapolis Public Schools 180477000873 5596 Meredith Nicholson School 96   Regular School No Elementary PK 06 2018   pre_kindergarten                         6.0 14.0                       20.0                         6 14                 20
1796163 IN     school 1803180 6835   Randolph Eastern School Corp 180318000414 7164 North Side Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         16.0 14.0                       30.0                         16 14                 30
1796454 IN     school 1806840 7200   School City of Mishawaka 180684001285 7478 Liberty Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         13.0 14.0                       27.0                         13 14                 27
1798833 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2018   pre_kindergarten                         13.0 14.0                       27.0                         13 14                 27
1793833 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         193.0 140.0                       333.0                         193 140                 333
1797553 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002491 8327 Culver Family Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         289.0 142.0                       431.0                         289 142                 431
1787732 IN     school 1803630 235   Fort Wayne Community Schools 180363000563 253 South Wayne Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         14.0 15.0                       29.0                         14 15                 29
1787808 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         15.0 15.0                       30.0                         15 15                 30
1787851 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         15.0 15.0                       30.0                         15 15                 30
1788183 IN     school 1800960 670   Brown County School Corporation 180096000173 577 Van Buren Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         12.0 15.0                       27.0                         12 15                 27
1789198 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001744 1581 Ferdinand Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         19.0 15.0                       34.0                         19 15                 34
1789451 IN     school 1803270 2305   Elkhart Community Schools 180327000435 1681 Mary Feeser Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         20.0 15.0                       35.0                         20 15                 35
1790505 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         24.0 15.0                       39.0                         24 15                 39
1791053 IN     school 1807440 3445   New Castle Community School Corp 180744002156 2832 Eastwood Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         23.0 15.0                       38.0                         23 15                 38
1791121 IN     school 1811250 3460   Taylor Community School Corp 181125001812 2895 Taylor Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         21.0 15.0                       36.0                         21 15                 36
1791698 IN     school 1801440 4205   Center Grove Community School Corp 180144000662 3434 Sugar Grove Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         34.0 15.0                       49.0                         34 15                 49
1791843 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001306 3409 Indian Creek Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         15.0 15.0                       30.0                         15 15                 30
1793035 IN     school 1805580 4945   LaPorte Community School Corp 180558002338 4707 Indian Trail Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         26.0 15.0                       41.0                         26 15                 41
1794366 IN     school 1804770 5385   Indianapolis Public Schools 180477000829 5583 Floro Torrence School 83   Regular School No Elementary PK 06 2018   pre_kindergarten                         20.0 15.0                       35.0                         20 15                 35
1795503 IN     school 1810900 6260   Southwest Parke Com Sch Corp 181090002288 6629 Montezuma Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         13.0 15.0                       28.0                         13 15                 28
1797618 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002275 8376 Daniel Wertz Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         22.0 15.0                       37.0                         22 15                 37
1798179 IN     school 1808190 8375   Northeastern Wayne Schools 180819002228 8928 Northeastern Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         11.0 15.0                       26.0                         11 15                 26
1798234 IN     school 1809510 8385   Richmond Community Schools 180951001569 9045 Vaile Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         17.0 15.0                       32.0                         17 15                 32
1791228 IN     school 1805370 3500   Kokomo School Corporation 180537000946 2961 Elwood Haynes Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         162.0 157.0                       319.0                         162 157                 319
1787667 IN     school 1803630 235   Fort Wayne Community Schools 180363000544 205 Maplewood Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         15.0 16.0                       31.0                         15 16                 31
1787724 IN     school 1803630 235   Fort Wayne Community Schools 180363000564 249 Levan R Scott Academy   Regular School No Elementary PK 05 2018   pre_kindergarten                         14.0 16.0                       30.0                         14 16                 30
1787853 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2018   pre_kindergarten                         32.0 16.0                       48.0                         32 16                 48
1788400 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         10.0 16.0                       26.0                         10 16                 26
1788973 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000225 1357 McKenney-Harrison Elementary Sch   Regular School No Elementary PK 05 2018   pre_kindergarten                         19.0 16.0                       35.0                         19 16                 35
1791108 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002290 2887 Knightstown Elementary School   Regular School No Elementary PK 03 2018   pre_kindergarten                         24.0 16.0                       40.0                         24 16                 40
1791823 IN     school 1804110 4245   Greenwood Community Sch Corp 180411000670 3479 Westwood Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         22.0 16.0                       38.0                         22 16                 38
1793020 IN     school 1802190 4940   South Central Com School Corp 180219000262 4734 South Central Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         12.0 16.0                       28.0                         12 16                 28
1794883 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002347 6162 Highland Park Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         18.0 16.0                       34.0                         18 16                 34
1795050 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001717 6258 Walnut Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         29.0 16.0                       45.0                         29 16                 45
1798014 IN     school 1812390 8130   Warrick County School Corp 181239002512 8779 Warrick County Preschool   Special Education School No Prekindergarten PK PK 2018   pre_kindergarten                         42.0 16.0                       58.0                         42 16                 58
1798206 IN     school 1809510 8385   Richmond Community Schools 180951001553 9013 Charles Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         16.0 16.0                       32.0                         16 16                 32
1787577 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         31.0 17.0                       48.0                         31 17                 48
1787659 IN     school 1803630 235   Fort Wayne Community Schools 180363000541 197 Lindley Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         6.0 17.0                       23.0                         6 17                 23
1788101 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         21.0 17.0                       38.0                         21 17                 38
1788217 IN     school 1801290 750   Carroll Consolidated School Corp 180129002103 629 Carroll Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         15.0 17.0                       32.0                         15 17                 32
1790034 IN     school 1806240 2825   Madison-Grant United School Corp 180624001100 5037 Summitville School   Regular School No Elementary PK 06 2018   pre_kindergarten                         21.0 17.0                       38.0                         21 17                 38
1790115 IN     school 1803090 2940   Eastern Greene Schools 180309000407 2433 Eastern Greene Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         36.0 17.0                       53.0                         36 17                 53
1790521 IN     school 1807650 3070   Noblesville Schools 180765002340 2538 Hazel Dell Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         19.0 17.0                       36.0                         19 17                 36
1790867 IN     school 1800270 3315   Avon Community School Corp 180027000058 2734 White Oak Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         22.0 17.0                       39.0                         22 17                 39
1791248 IN     school 1805370 3500   Kokomo School Corporation 180537000956 2993 Pettit Park School   Regular School No Elementary PK 05 2018   pre_kindergarten                         20.0 17.0                       37.0                         20 17                 37
1792910 IN     school 1807470 4860   M S D of New Durham Township 180747001293 4699 Westville Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         8.0 17.0                       25.0                         8 17                 25
1793090 IN     school 1805580 4945   LaPorte Community School Corp 180558001016 4757 Lincoln Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         15.0 17.0                       32.0                         15 17                 32
1793177 IN     school 1807860 5075   North Lawrence Com Schools 180786001345 4917 Parkview Primary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         35.0 17.0                       52.0                         35 17                 52
1793758 IN     school 1808910 5350   M S D Pike Township 180891001598 5363 Snacks Crossing Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         32.0 17.0                       49.0                         32 17                 49
1796409 IN     school 1806840 7200   School City of Mishawaka 180684001178 7459 Fred J Hums Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         12.0 17.0                       29.0                         12 17                 29
1793511 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No Elementary PK KG 2018   pre_kindergarten                         264.0 175.0                       439.0                         264 175                 439
1787339 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         42.0 18.0                       60.0                         42 18                 60
1787592 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         25.0 18.0                       43.0                         25 18                 43
1788083 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2018   pre_kindergarten                         29.0 18.0                       47.0                         29 18                 47
1788625 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2018   pre_kindergarten                         26.0 18.0                       44.0                         26 18                 44
1788981 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000847 1359 Country Meadow Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         30.0 18.0                       48.0                         30 18                 48
1791467 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         17.0 18.0                       35.0                         17 18                 35
1791582 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001766 3341 Southwestern Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         19.0 18.0                       37.0                         19 18                 37
1792391 IN     school 1802490 4660   Crown Point Community School Corp 180249000295 3773 Dwight D Eisenhower Elem School   Regular School No Elementary PK 05 2018   pre_kindergarten                         31.0 18.0                       49.0                         31 18                 49
1793055 IN     school 1805580 4945   LaPorte Community School Corp 180558001013 4727 Kingsbury Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         18.0 18.0                       36.0                         18 18                 36
1793264 IN     school 1810440 5255   South Madison Com Sch Corp 181044001713 5061 Pendleton Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         40.0 18.0                       58.0                         40 18                 58
1793289 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                         17.0 18.0                       35.0                         17 18                 35
1793673 IN     school 1808820 5340   Perry Township Schools 180882001470 5351 Winchester Village Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                         22.0 18.0                       40.0                         22 18                 40
1794187 IN     school 1804770 5385   Indianapolis Public Schools 180477000885 5544 Riverside School 44   Regular School No Middle 04 06 2018   pre_kindergarten                         34.0 18.0                       52.0                         34 18                 52
1796265 IN     school 1809750 6995   Rush County Schools 180975002485 7272 Rushville Elementary School West   Regular School No Elementary PK 06 2018   pre_kindergarten                         37.0 18.0                       55.0                         37 18                 55
1798220 IN     school 1809510 8385   Richmond Community Schools 180951001556 9017 Fairview Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         23.0 18.0                       41.0                         23 18                 41
1790072 IN     school 1806390 2865   Marion Community Schools 180639002396 2370 Marion Early Childhood Ed Cntr   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         156.0 182.0                       338.0                         156 182                 338
1787628 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         28.0 19.0                       47.0                         28 19                 47
1787682 IN     school 1803630 235   Fort Wayne Community Schools 180363000551 217 Northcrest Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         24.0 19.0                       43.0                         24 19                 43
1788190 IN     school 1800960 670   Brown County School Corporation 180096000170 581 Helmsburg Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         17.0 19.0                       36.0                         17 19                 36
1791756 IN     school 1803240 4215   Edinburgh Community School Corp 180324000421 3452 East Side Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         26.0 19.0                       45.0                         26 19                 45
1792251 IN     school 1809690 4600   Merrillville Community School Corp 180969001584 3827 John Wood Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         34.0 19.0                       53.0                         34 19                 53
1794122 IN     school 1804770 5385   Indianapolis Public Schools 180477000897 5514 Washington Irving School 14   Regular School No Elementary PK 07 2018   pre_kindergarten                         31.0 19.0                       50.0                         31 19                 50
1794874 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000128 6157 Grandview Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         19.0 19.0                       38.0                         19 19                 38
1795952 IN     school 1807950 6600   M S D North Posey Co Schools 180795001367 6989 South Terrace Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                         17.0 19.0                       36.0                         17 19                 36
1798227 IN     school 1809510 8385   Richmond Community Schools 180951002455 9038 Starr Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         13.0 19.0                       32.0                         13 19                 32
1787636 IN     school 1803630 235   Fort Wayne Community Schools 180363000543 186 Mabel K Holland Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         13.0 2.0                       15.0                         13 2                 15
1787695 IN     school 1803630 235   Fort Wayne Community Schools 180363000524 221 Francis M Price Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         5.0 2.0                       7.0                         5 2                 7
1788866 IN     school 1802610 1655   Decatur County Community Schools 180261000310 1265 South Decatur Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         6.0 2.0                       8.0                         6 2                 8
1790326 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         7.0 2.0                       9.0                         7 2                 9
1790356 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                         9.0 2.0                       11.0                         9 2                 11
1790733 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         15.0 2.0                       17.0                         15 2                 17
1791994 IN     school 1812420 4415   Warsaw Community Schools 181242001993 3613 Leesburg Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         1.0 2.0                       3.0                         1 2                 3
1793609 IN     school 1808820 5340   Perry Township Schools 180882001469 5321 William Henry Burkhart Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                         15.0 2.0                       17.0                         15 2                 17
1794349 IN     school 1804770 5385   Indianapolis Public Schools 180477000808 5579 Carl Wilde School 79   Regular School No Elementary PK 06 2018   pre_kindergarten                         2.0 2.0                       4.0                         2 2                 4
1794486 IN     school 1804770 5385   Indianapolis Public Schools 180477000882 5614 Paul I Miller School 114   Regular School No Elementary PK 06 2018   pre_kindergarten                         4.0 2.0                       6.0                         4 2                 6
1795150 IN     school 1806510 5925   M S D Martinsville Schools 180651001129 6341 Centerton Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         2.0 2.0                       4.0                         2 2                 4
1795347 IN     school 1802970 6060   East Noble School Corporation 180297000888 6478 South Side Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         9.0 2.0                       11.0                         9 2                 11
1796191 IN     school 1800390 6895   Batesville Community School Corp 180039002381 7218 Batesville Primary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         8.0 2.0                       10.0                         8 2                 10
1796215 IN     school 1804800 6900   Jac-Cen-Del Community Sch Corp 180480002353 7203 Jac-Cen-Del Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         12.0 2.0                       14.0                         12 2                 14
1787644 IN     school 1803630 235   Fort Wayne Community Schools 180363000532 189 Indian Village Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         10.0 20.0                       30.0                         10 20                 30
1792723 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         20.0 20.0                       40.0                         20 20                 40
1793082 IN     school 1805580 4945   LaPorte Community School Corp 180558001009 4753 F Willard Crichfield Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                         21.0 20.0                       41.0                         21 20                 41
1793474 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002499 5203 Lillie Idella Kitley Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                         55.0 20.0                       75.0                         55 20                 75
1793625 IN     school 1808820 5340   Perry Township Schools 180882001456 5325 Clinton Young Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         25.0 20.0                       45.0                         25 20                 45
1793665 IN     school 1808820 5340   Perry Township Schools 180882001466 5347 Southport Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         22.0 20.0                       42.0                         22 20                 42
1794155 IN     school 1804770 5385   Indianapolis Public Schools 180477000821 5534 Eleanor Skillen School 34   Regular School No Elementary PK 06 2018   pre_kindergarten                         19.0 20.0                       39.0                         19 20                 39
1794628 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                         14.0 20.0                       34.0                         14 20                 34
1794820 IN     school 1808850 5635   Peru Community Schools 180885001472 6097 Elmwood Primary Learning Center   Regular School No Elementary PK 02 2018   pre_kindergarten                         28.0 20.0                       48.0                         28 20                 48
1796017 IN     school 1807980 6715   North Putnam Community Schools 180798001368 7041 Bainbridge Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         27.0 20.0                       47.0                         27 20                 47

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