Data source: Big Local News · About: Big Local

387 rows where grade = "pre_kindergarten", state = "IN" and year = 2015 sorted by male_int

View and edit SQL

year

  • 2015 · 364

grade

  • pre_kindergarten · 364
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
1161458 IN     school 1803960 2120   Greater Jasper Con Schs 180396000684 1569 Ireland Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         3.0 0.0                       3.0                         3 0                 3
1165138 IN     school 1807560 4805   New Prairie United School Corp 180756001301 4693 Rolling Prairie Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         3.0 0.0                       3.0                         3 0                 3
1165904 IN     school 1808820 5340   Perry Township Schools 180882001470 5351 Winchester Village Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                         3.0 2.0                       5.0                         3 2                 5
1166981 IN     school 1810170 5520   Shoals Community School Corp 181017001634 5989 Shoals Community Elem School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         3.0 2.0                       5.0                         3 2                 5
1167352 IN     school 1804140 5900   Monroe-Gregg School District 180414000715 6323 Monrovia Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         3.0 6.0                       9.0                         3 6                 9
1167568 IN     school 1802970 6060   East Noble School Corp 180297000387 6457 Avilla Elementary School   Regular School No 1.0 PK 07 2015   pre_kindergarten                         3.0 2.0                       5.0                         3 2                 5
1167663 IN     school 1808490 6145   Orleans Community Schools 180849001436 6577 Orleans Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         3.0 4.0                       7.0                         3 4                 7
1167831 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801857 6647 Turkey Run Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         3.0 1.0                       4.0                         3 1                 4
1171066 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   pre_kindergarten                         3.0 3.0                       6.0                         3 3                 6
1160879 IN     school 1802440 1300   Crawford Co Com School Corp 180244000282 1061 Marengo Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         4.0 5.0                       9.0                         4 5                 9
1162935 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elem School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         4.0 9.0                       13.0                         4 9                 13
1169616 IN     school 1811400 7945   Tipton Community School Corp 181140001844 8163 Tipton Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         4.0 1.0                       5.0                         4 1                 5
1159881 IN     school 1803630 235   Fort Wayne Community Schools 180363000524 221 Francis M Price Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         5.0 5.0                       10.0                         5 5                 10
1160535 IN     school 1809370 940   West Clark Community Schools 180937001539 815 William W Borden Elem Sch   Regular School No 1.0 PK 06 2015   pre_kindergarten                         5.0 1.0                       6.0                         5 1                 6
1161408 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001746 1563 Pine Ridge Elementary School   Regular School No 1.0 PK 04 2015   pre_kindergarten                         5.0 6.0                       11.0                         5 6                 11
1163738 IN     school 1806120 3995   Madison Consolidated Schools 180612001085 3301 Deputy Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         5.0 3.0                       8.0                         5 3                 8
1166877 IN     school 1802520 5455   Culver Community Schools Corp 180252000302 5928 Culver Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         5.0 2.0                       7.0                         5 2                 7
1167122 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000129 6134 Lakeview Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         5.0 7.0                       12.0                         5 7                 12
1167603 IN     school 1802970 6060   East Noble School Corp 180297000888 6478 South Side Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         5.0 3.0                       8.0                         5 3                 8
1168850 IN     school 1810290 7205   South Bend Community Sch Corp 181029001865 7546 Hamilton Traditional School   Regular School No 1.0 PK 04 2015   pre_kindergarten                         5.0 3.0                       8.0                         5 3                 8
1168928 IN     school 1810290 7205   South Bend Community Sch Corp 181029001664 7601 Nuner Primary Center   Regular School No 1.0 PK 04 2015   pre_kindergarten                         5.0 1.0                       6.0                         5 1                 6
1169921 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001736 8431 Ernie Pyle Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         5.0 0.0                       5.0                         5 0                 5
1160413 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         6.0 1.0                       7.0                         6 1                 7
1162745 IN     school 1807650 3070   Noblesville Schools 180765001246 2547 White River Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         6.0 15.0                       21.0                         6 15                 21
1165852 IN     school 1808820 5340   Perry Township Schools 180882002280 5322 Mary Bryan Elementary Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         6.0 6.0                       12.0                         6 6                 12
1166375 IN     school 1804770 5385   Indianapolis Public Schools 180477000896 5515 Thomas D Gregg School 15   Regular School No 1.0 PK 06 2015   pre_kindergarten                         6.0 9.0                       15.0                         6 9                 15
1166726 IN     school 1804770 5385   Indianapolis Public Schools 180477000882 5614 Paul I Miller School 114   Regular School No 1.0 PK 06 2015   pre_kindergarten                         6.0 8.0                       14.0                         6 8                 14
1167613 IN     school 1802970 6060   East Noble School Corp 180297000394 6485 Wayne Center Elem Sch   Regular School No 1.0 PK 07 2015   pre_kindergarten                         6.0 5.0                       11.0                         6 5                 11
1169361 IN     school 1810860 7715   Southwest School Corp 181086001770 7953 Carlisle Elem and Junior High   Regular School No 1.0 PK 08 2015   pre_kindergarten                         6.0 10.0                       16.0                         6 10                 16
1160779 IN     school 1802130 1150   Clinton Central School Corp 180213000256 961 Clinton Central Elem School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         7.0 4.0                       11.0                         7 4                 11
1160888 IN     school 1802440 1300   Crawford Co Com School Corp 180244000283 1065 Milltown School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         7.0 8.0                       15.0                         7 8                 15
1160913 IN     school 1807710 1375   North Daviess Com Schools 180771001648 1090 North Daviess Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         7.0 5.0                       12.0                         7 5                 12
1162545 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   pre_kindergarten                         7.0 2.0                       9.0                         7 2                 9
1162926 IN     school 1810360 3190   South Harrison Com Schools 181036001698 2649 New Middletown Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         7.0 8.0                       15.0                         7 8                 15
1163362 IN     school 1803150 3480   Eastern Howard School Corp 180315000412 2909 Eastern Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         7.0 3.0                       10.0                         7 3                 10
1163544 IN     school 1801230 3640   Medora Community School Corp 180123002268 3095 Medora Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         7.0 4.0                       11.0                         7 4                 11
1164513 IN     school 1805450 4615   Lake Central School Corp 180545002143 4349 Homan Elementary School   Regular School No 1.0 PK 04 2015   pre_kindergarten                         7.0 0.0                       7.0                         7 0                 7
1166407 IN     school 1804770 5385   Indianapolis Public Schools 180477000821 5534 Eleanor Skillen School 34   Regular School No 1.0 PK 06 2015   pre_kindergarten                         7.0 12.0                       19.0                         7 12                 19
1168455 IN     school 1800390 6895   Batesville Community Sch Corp 180039002381 7218 Batesville Primary School   Regular School No 1.0 PK 02 2015   pre_kindergarten                         7.0 1.0                       8.0                         7 1                 8
1159793 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         8.0 5.0                       13.0                         8 5                 13
1159942 IN     school 1803630 235   Fort Wayne Community Schools 180363000566 269 Washington Center Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         8.0 1.0                       9.0                         8 1                 9
1162555 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                         8.0 5.0                       13.0                         8 5                 13
1162568 IN     school 1806480 3055   Sheridan Community Schools 180648001125 2465 Sheridan Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         8.0 3.0                       11.0                         8 3                 11
1162653 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         8.0 1.0                       9.0                         8 1                 9
1166633 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No 1.0 PK 06 2015   pre_kindergarten                         8.0 7.0                       15.0                         8 7                 15
1166642 IN     school 1804770 5385   Indianapolis Public Schools 180477000826 5590 Ernie Pyle School 90   Regular School No 1.0 PK 06 2015   pre_kindergarten                         8.0 5.0                       13.0                         8 5                 13
1167208 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000127 6197 Fairview Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         8.0 10.0                       18.0                         8 10                 18
1168778 IN     school 1810290 7205   South Bend Community Sch Corp 181029001651 7435 Darden Primary Center   Regular School No 1.0 PK 04 2015   pre_kindergarten                         8.0 0.0                       8.0                         8 0                 8
1169754 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000463 8289 Dexter Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         8.0 4.0                       12.0                         8 4                 12
1170063 IN     school 1812090 8030   Vigo County School Corp 181209001909 8549 Lost Creek Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         8.0 4.0                       12.0                         8 4                 12
1159755 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         9.0 9.0                       18.0                         9 9                 18
1160552 IN     school 1801920 1000   Clarksville Com School Corp 180192000251 845 Clarksville Elementary School   Regular School No 1.0 PK 04 2015   pre_kindergarten                         9.0 13.0                       22.0                         9 13                 22
1165242 IN     school 1806570 4925   Michigan City Area Schools 180657001151 4825 Knapp Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         9.0 4.0                       13.0                         9 4                 13
1165302 IN     school 1805580 4945   LaPorte Community School Corp 180558001013 4727 Kingsbury Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         9.0 14.0                       23.0                         9 14                 23
1166170 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         9.0 11.0                       20.0                         9 11                 20
1166540 IN     school 1804770 5385   Indianapolis Public Schools 180477002394 5563 Wendell Phillips School 63   Regular School No 1.0 PK 06 2015   pre_kindergarten                         9.0 7.0                       16.0                         9 7                 16
1167049 IN     school 1808340 5625   Oak Hill United School Corp 180834001428 6073 Converse Elementary School   Regular School No 1.0 PK 02 2015   pre_kindergarten                         9.0 6.0                       15.0                         9 6                 15
1168427 IN     school 1803180 6835   Randolph Eastern School Corp 180318000414 7164 North Side Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         9.0 13.0                       22.0                         9 13                 22
1170670 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         9.0 2.0                       11.0                         9 2                 11
1160074 IN     school 1800360 365   Bartholomew Con School Corp 180036000075 353 Mount Healthy Elementary Sch   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1162718 IN     school 1807650 3070   Noblesville Schools 180765002414 2537 Noble Crossing Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         10.0 3.0                       13.0                         10 3                 13
1163770 IN     school 1806120 3995   Madison Consolidated Schools 180612001088 3333 Emery O Muncie Elem School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         10.0 12.0                       22.0                         10 12                 22
1164185 IN     school 1812420 4415   Warsaw Community Schools 181242001993 3613 Leesburg Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1164256 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         10.0 2.0                       12.0                         10 2                 12
1165233 IN     school 1806570 4925   Michigan City Area Schools 180657001150 4821 Joy Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1166187 IN     school 1812810 5375   M S D Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1166204 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1166463 IN     school 1804770 5385   Indianapolis Public Schools 180477000867 5548 Louis B Russell Jr School 48   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 4.0                       14.0                         10 4                 14
1166480 IN     school 1804770 5385   Indianapolis Public Schools 180477002404 5551 James Russell Lowell School 51   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 8.0                       18.0                         10 8                 18
1167131 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000128 6157 Grandview Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 8.0                       18.0                         10 8                 18
1169156 IN     school 1808010 7385   North Spencer County Sch Corp 180801001375 7753 David Turnham Edl Ctr   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 17.0                       27.0                         10 17                 27
1169713 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000457 8261 Caze Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         10.0 9.0                       19.0                         10 9                 19
1170079 IN     school 1812090 8030   Vigo County School Corp 181209002176 8575 Ouabache Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         10.0 12.0                       22.0                         10 12                 22
1170493 IN     school 1809510 8385   Richmond Community Schools 180951002455 9038 Elizabeth Starr Acad for Young Ent   Regular School No 1.0 PK 04 2015   pre_kindergarten                         10.0 22.0                       32.0                         10 22                 32
1160746 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         11.0 15.0                       26.0                         11 15                 26
1161750 IN     school 1803270 2305   Elkhart Community Schools 180327000437 1789 Monger Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         11.0 18.0                       29.0                         11 18                 29
1162056 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No 1.0 PK 04 2015   pre_kindergarten                         11.0 7.0                       18.0                         11 7                 18
1162710 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1163110 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         11.0 1.0                       12.0                         11 1                 12
1163606 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         11.0 3.0                       14.0                         11 3                 14
1166549 IN     school 1804770 5385   Indianapolis Public Schools 180477000884 5565 Raymond F Brandes School 65   Regular School No 1.0 PK 06 2015   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1167032 IN     school 1807890 5620   North Miami Community Schools 180789001350 6051 North Miami Elem School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         11.0 17.0                       28.0                         11 17                 28
1167173 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000118 6173 Binford Elementary School   Regular School No 1.0 03 06 2015   pre_kindergarten                         11.0 4.0                       15.0                         11 4                 15
1167190 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000123 6187 Childs Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         11.0 7.0                       18.0                         11 7                 18
1167822 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801578 6645 Rockville Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         11.0 1.0                       12.0                         11 1                 12
1169724 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000458 8265 Cedar Hall Community School   Regular School No 1.0 PK 08 2015   pre_kindergarten                         11.0 6.0                       17.0                         11 6                 17
1170032 IN     school 1812090 8030   Vigo County School Corp 181209001914 8525 Rio Grande Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         11.0 7.0                       18.0                         11 7                 18
1170102 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         11.0 24.0                       35.0                         11 24                 35
1170486 IN     school 1809510 8385   Richmond Community Schools 180951001556 9017 Fairview Elementary School   Regular School No 1.0 PK 04 2015   pre_kindergarten                         11.0 22.0                       33.0                         11 22                 33
1160103 IN     school 1800360 365   Bartholomew Con School Corp 180036000079 366 Rockcreek Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         12.0 8.0                       20.0                         12 8                 20
1160120 IN     school 1800360 365   Bartholomew Con School Corp 180036000070 371 L F Smith Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                         12.0 15.0                       27.0                         12 15                 27
1160252 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002065 537 Thorntown Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         12.0 8.0                       20.0                         12 8                 20
1162153 IN     school 1807770 2735   North Gibson School Corp 180777001325 2257 Princeton Comm Primary School   Regular School No 1.0 PK 02 2015   pre_kindergarten                         12.0 4.0                       16.0                         12 4                 16
1162780 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001407 2567 Sugar Creek Elementary Sch   Regular School No 1.0 PK 06 2015   pre_kindergarten                         12.0 8.0                       20.0                         12 8                 20
1166803 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No 1.0 PK 08 2015   pre_kindergarten                         12.0 4.0                       16.0                         12 4                 16
1167586 IN     school 1802970 6060   East Noble School Corp 180297000393 6465 Rome City Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         12.0 11.0                       23.0                         12 11                 23
1167790 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elem & High School   Regular School No 4.0 PK 12 2015   pre_kindergarten                         12.0 11.0                       23.0                         12 11                 23
1167871 IN     school 1808900 6445   Pike County School Corp 180890001481 6809 Petersburg Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         12.0 12.0                       24.0                         12 12                 24
1168276 IN     school 1807980 6715   North Putnam Community Schools 180798001368 7041 Bainbridge Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         12.0 16.0                       28.0                         12 16                 28
1169041 IN     school 1803210 7285   Shelby Eastern Schools 180321000417 7663 Morristown Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         12.0 6.0                       18.0                         12 6                 18

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