Data source: Big Local News · About: Big Local

469 rows where grade = "pre_kindergarten", state = "IN" and year = 2020 sorted by male

View and edit SQL

year

  • 2020 · 369

grade

  • pre_kindergarten · 369
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
1917231 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002275 8376 Daniel Wertz Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         13.0 7.0                       20.0                         13 7                 20
1917354 IN     school 1812090 8030   Vigo County School Corp 181209001902 8509 Deming Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         13.0 15.0                       28.0                         13 15                 28
1916259 IN     school 1810290 7205   South Bend Community School Corp 181029002574 7617 Studebaker Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         130.0 82.0                       212.0                         130 82                 212
1913109 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002678 5317 Wanamaker Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         133.0 71.0                       204.0                         133 71                 204
1912948 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         135.0 108.0                       243.0                         135 108                 243
1907466 IN     school 1803630 235   Fort Wayne Community Schools 180363000569 273 Waynedale Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         14.0 22.0                       36.0                         14 22                 36
1908023 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   pre_kindergarten                         14.0 8.0                       22.0                         14 8                 22
1908713 IN     school 1804500 1885   Wes-Del Community Schools 180450002607 1412 Wes-Del Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         14.0 10.0                       24.0                         14 10                 24
1908908 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001776 1529 Holland Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         14.0 12.0                       26.0                         14 12                 26
1910230 IN     school 1807650 3070   Noblesville Schools 180765002546 2539 Promise Road Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                         14.0 9.0                       23.0                         14 9                 23
1910761 IN     school 1807440 3445   New Castle Community School Corp 180744002156 2832 Eastwood Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         14.0 6.0                       20.0                         14 6                 20
1913241 IN     school 1808820 5340   Perry Township Schools 180882001469 5321 William Henry Burkhart Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                         14.0 15.0                       29.0                         14 15                 29
1913388 IN     school 1808910 5350   M S D Pike Township 180891001598 5363 Snacks Crossing Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         14.0 5.0                       19.0                         14 5                 19
1914029 IN     school 1804770 5385   Indianapolis Public Schools 180477000873 5596 Meredith Nicholson School 96   Regular School No Elementary PK 06 2020   pre_kindergarten                         14.0 28.0                       42.0                         14 28                 42
1914513 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000118 6173 Binford Elementary School   Regular School No Elementary 03 06 2020   pre_kindergarten                         14.0 3.0                       17.0                         14 3                 17
1910936 IN     school 1805370 3500   Kokomo School Corporation 180537000946 2961 Elwood Haynes Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         141.0 148.0                       289.0                         141 148                 289
1916256 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2020   pre_kindergarten                         142.0 59.0                       201.0                         142 59                 201
1916435 IN     school 1810140 7365   Shelbyville Central Schools 181014002687 7723 Golden Bear Preschool   Regular School No Elementary PK KG 2020   pre_kindergarten                         144.0 125.0                       269.0                         144 125                 269
1907152 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         15.0 9.0                       24.0                         15 9                 24
1907658 IN     school 1800360 365   Bartholomew Con School Corp 180036000080 392 Southside Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         15.0 13.0                       28.0                         15 13                 28
1907760 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002065 537 Thorntown Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         15.0 15.0                       30.0                         15 15                 30
1907940 IN     school 1808940 775   Pioneer Regional School Corp 180894001490 649 Pioneer Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         15.0 14.0                       29.0                         15 14                 29
1908187 IN     school 1803940 1010   Greater Clark County Schools 180394000675 879 Parkwood Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         15.0 12.0                       27.0                         15 12                 27
1908376 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000283 1065 East Crawford Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         15.0 10.0                       25.0                         15 10                 25
1908821 IN     school 1807320 1970   Muncie Community Schools 180732001237 1485 Longfellow Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         15.0 8.0                       23.0                         15 8                 23
1910733 IN     school 1808280 3435   Shenandoah School Corporation 180828002356 2815 Shenandoah Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         15.0 8.0                       23.0                         15 8                 23
1911243 IN     school 1806120 3995   Madison Consolidated Schools 180612001089 3329 Lydia Middleton Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         15.0 15.0                       30.0                         15 15                 30
1911445 IN     school 1803240 4215   Edinburgh Community School Corp 180324000421 3452 East Side Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         15.0 24.0                       39.0                         15 24                 39
1911475 IN     school 1803690 4225   Franklin Community School Corp 180369000584 3461 Northwood Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         15.0 4.0                       19.0                         15 4                 19
1912695 IN     school 1805580 4945   LaPorte Community School Corp 180558001013 4727 Kingsbury Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         15.0 19.0                       34.0                         15 19                 34
1914925 IN     school 1802970 6060   East Noble School Corporation 180297000392 6477 North Side Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         15.0 9.0                       24.0                         15 9                 24
1916312 IN     school 1810020 7255   Scott County School District 2 181002001609 7633 Johnson Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         15.0 14.0                       29.0                         15 14                 29
1917377 IN     school 1812090 8030   Vigo County School Corp 181209001904 8517 Farrington Grove Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         15.0 10.0                       25.0                         15 10                 25
1917448 IN     school 1812090 8030   Vigo County School Corp 181209001913 8593 Riley Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         15.0 2.0                       17.0                         15 2                 17
1918572 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   pre_kindergarten                         15.0 11.0                       26.0                         15 11                 26
1907637 IN     school 1800360 365   Bartholomew Con School Corp 180036002492 375 CSA Fodrea Campus   Regular School No Elementary PK 06 2020   pre_kindergarten                         16.0 22.0                       38.0                         16 22                 38
1907872 IN     school 1800960 670   Brown County School Corporation 180096000173 577 Van Buren Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         16.0 12.0                       28.0                         16 12                 28
1908135 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten                         16.0 11.0                       27.0                         16 11                 27
1909222 IN     school 1803270 2305   Elkhart Community Schools 180327000431 1777 Hawthorne Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         16.0 18.0                       34.0                         16 18                 34
1910034 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         16.0 8.0                       24.0                         16 8                 24
1912414 IN     school 1804560 4720   School Town of Highland 180456000766 4285 Judith Morton Johnston Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                         16.0 9.0                       25.0                         16 9                 25
1913702 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten                         16.0 9.0                       25.0                         16 9                 25
1915585 IN     school 1810500 6705   South Putnam Community Schools 181050001724 7057 Fillmore Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         16.0 10.0                       26.0                         16 10                 26
1916320 IN     school 1810020 7255   Scott County School District 2 181002001610 7637 Lexington Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         16.0 17.0                       33.0                         16 17                 33
1917049 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000457 8261 Caze Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         16.0 15.0                       31.0                         16 15                 31
1917346 IN     school 1812090 8030   Vigo County School Corp 181209001901 8505 Davis Park Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         16.0 12.0                       28.0                         16 12                 28
1907990 IN     school 1806030 875   Logansport Community Sch Corp 180603002366 711 Landis Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         17.0 23.0                       40.0                         17 23                 40
1908098 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         17.0 8.0                       25.0                         17 8                 25
1908252 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         17.0 11.0                       28.0                         17 11                 28
1908260 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         17.0 10.0                       27.0                         17 10                 27
1908299 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         17.0 19.0                       36.0                         17 19                 36
1908657 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000222 1351 James R Watson Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         17.0 31.0                       48.0                         17 31                 48
1910124 IN     school 1801200 3060   Carmel Clay Schools 180120000036 2512 Smoky Row Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         17.0 18.0                       35.0                         17 18                 35
1911921 IN     school 1809690 4600   Merrillville Community School Corp 180969001583 3822 Homer Iddings Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         17.0 15.0                       32.0                         17 15                 32
1912664 IN     school 1802190 4940   South Central Com School Corp 180219000262 4734 South Central Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         17.0 18.0                       35.0                         17 18                 35
1912732 IN     school 1805580 4945   LaPorte Community School Corp 180558001020 4767 Riley Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         17.0 20.0                       37.0                         17 20                 37
1914324 IN     school 1810170 5520   Shoals Community School Corp 181017001634 5989 Shoals Community Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         17.0 9.0                       26.0                         17 9                 26
1915073 IN     school 1810900 6260   Southwest Parke Com Sch Corp 181090002286 6621 Rosedale Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         17.0 26.0                       43.0                         17 26                 43
1915765 IN     school 1803180 6835   Randolph Eastern School Corp 180318000414 7164 North Side Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         17.0 11.0                       28.0                         17 11                 28
1909877 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                         170.0 118.0                       288.0                         170 118                 288
1913469 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         175.0 147.0                       322.0                         175 147                 322
1907246 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         18.0 22.0                       40.0                         18 22                 40
1907428 IN     school 1803630 235   Fort Wayne Community Schools 180363000563 253 South Wayne Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         18.0 14.0                       32.0                         18 14                 32
1907751 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002064 521 Granville Wells Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         18.0 9.0                       27.0                         18 9                 27
1911764 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         18.0 12.0                       30.0                         18 12                 30
1912365 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         18.0 22.0                       40.0                         18 22                 40
1912678 IN     school 1805580 4945   LaPorte Community School Corp 180558002338 4707 Indian Trail Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         18.0 21.0                       39.0                         18 21                 39
1913991 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2020   pre_kindergarten                         18.0 25.0                       43.0                         18 25                 43
1914473 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000128 6157 Grandview Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         18.0 19.0                       37.0                         18 19                 37
1914482 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002347 6162 Highland Park Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         18.0 13.0                       31.0                         18 13                 31
1914951 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2020   pre_kindergarten                         18.0 5.0                       23.0                         18 5                 23
1915187 IN     school 1808900 6445   Pike County School Corp 180890001481 6809 Petersburg Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         18.0 11.0                       29.0                         18 11                 29
1915532 IN     school 1807950 6600   M S D North Posey Co Schools 180795001367 6989 South Terrace Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                         18.0 18.0                       36.0                         18 18                 36
1915598 IN     school 1807980 6715   North Putnam Community Schools 180798001368 7041 Bainbridge Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         18.0 23.0                       41.0                         18 23                 41
1917424 IN     school 1812090 8030   Vigo County School Corp 181209001909 8549 Lost Creek Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         18.0 3.0                       21.0                         18 3                 21
1917842 IN     school 1809510 8385   Richmond Community Schools 180951001553 9013 Charles Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         18.0 16.0                       34.0                         18 16                 34
1907420 IN     school 1803630 235   Fort Wayne Community Schools 180363000564 249 Levan R Scott Academy   Regular School No Elementary PK 05 2020   pre_kindergarten                         19.0 12.0                       31.0                         19 12                 31
1907444 IN     school 1803630 235   Fort Wayne Community Schools 180363000567 265 Washington Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         19.0 15.0                       34.0                         19 15                 34
1908179 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         19.0 8.0                       27.0                         19 8                 27
1908538 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2020   pre_kindergarten                         19.0 12.0                       31.0                         19 12                 31
1908947 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten                         19.0 8.0                       27.0                         19 8                 27
1909772 IN     school 1806390 2865   Marion Community Schools 180639001113 2393 John W Kendall Elem School   Regular School No Elementary PK 04 2020   pre_kindergarten                         19.0 18.0                       37.0                         19 18                 37
1910098 IN     school 1801200 3060   Carmel Clay Schools 180120002332 2508 Cherry Tree Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         19.0 11.0                       30.0                         19 11                 30
1911488 IN     school 1803690 4225   Franklin Community School Corp 180369001030 3467 Creekside Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         19.0 7.0                       26.0                         19 7                 26
1911513 IN     school 1804110 4245   Greenwood Community Sch Corp 180411000670 3479 Westwood Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         19.0 15.0                       34.0                         19 15                 34
1912718 IN     school 1805580 4945   LaPorte Community School Corp 180558001009 4753 F Willard Crichfield Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                         19.0 21.0                       40.0                         19 21                 40
1912725 IN     school 1805580 4945   LaPorte Community School Corp 180558001016 4757 Lincoln Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         19.0 17.0                       36.0                         19 17                 36
1913980 IN     school 1804770 5385   Indianapolis Public Schools 180477000829 5583 Floro Torrence School 83   Regular School No Elementary PK 06 2020   pre_kindergarten                         19.0 12.0                       31.0                         19 12                 31
1915723 IN     school 1807080 6820   Monroe Central School Corp 180708002226 7152 Monroe Central Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         19.0 14.0                       33.0                         19 14                 33
1917472 IN     school 1812090 8030   Vigo County School Corp 181209001922 8609 West Vigo Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         19.0 7.0                       26.0                         19 7                 26
1910198 IN     school 1807650 3070   Noblesville Schools 180765001311 2529 North Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         2.0 0.0                       2.0                         2 0                 2
1913580 IN     school 1812810 5375   M S D Wayne Township 181281002030 5227 Chapel Glen Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         2.0 3.0                       5.0                         2 3                 5
1913625 IN     school 1812810 5375   M S D Wayne Township 181281000238 5267 North Wayne Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         2.0 0.0                       2.0                         2 0                 2
1913656 IN     school 1812810 5375   M S D Wayne Township 181281002042 5273 Westlake Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         2.0 2.0                       4.0                         2 2                 4
1914637 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001714 6233 Ladoga Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         2.0 2.0                       4.0                         2 2                 4
1915954 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001442 7361 Elm Road Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         2.0 1.0                       3.0                         2 1                 3
1915981 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876002161 7379 Bittersweet Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         2.0 2.0                       4.0                         2 2                 4
1907262 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         20.0 16.0                       36.0                         20 16                 36
1907886 IN     school 1800960 670   Brown County School Corporation 180096000172 585 Sprunica Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         20.0 14.0                       34.0                         20 14                 34
1910041 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         20.0 7.0                       27.0                         20 7                 27

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