enrollments

Data source: Big Local News · About: Big Local

6,726 rows where grade = "grade_5" and state = "IN" sorted by female

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_5 · 6,626 ✖
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
1754562 1754562 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2019   grade_5                         0.0 1.0                       1.0                         0 1                 1
1756362 1756362 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2019   grade_5                         4.0 1.0                       5.0                         4 1                 5
1758214 1758214 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_5                         6.0 1.0                       7.0                         6 1                 7
1759339 1759339 IN     school 1806510 5925   M S D Martinsville Schools 180651002355 6344 South Elementary School   Regular School No Elementary PK 06 2019   grade_5                         2.0 1.0                       3.0                         2 1                 3
1761009 1761009 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other PK 12 2019   grade_5                         2.0 1.0                       3.0                         2 1                 3
1761662 1761662 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_5                         10.0 1.0                       11.0                         10 1                 11
1763424 1763424 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2019   grade_5                         12.0 1.0                       13.0                         12 1                 13
1789573 1789573 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 05 12 2018   grade_5                         0.0 1.0                       1.0                         0 1                 1
1791073 1791073 IN     school 1807440 3445   New Castle Community School Corp 180744001289 2853 Sunnyside Elementary School   Regular School No Elementary KG 06 2018   grade_5                         1.0 1.0                       2.0                         1 1                 2
1794803 1794803 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No Middle 05 08 2018   grade_5                         4.0 1.0                       5.0                         4 1                 5
1798249 1798249 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2018   grade_5                         8.0 1.0                       9.0                         8 1                 9
1909173 1909173 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other KG 12 2020   grade_5                         4.0 1.0                       5.0                         4 1                 5
1912191 1912191 IN     school 1803870 4690   Gary Community School Corp 180387002684 4068 Gary Virtual Academy   Regular School No Other 02 09 2020   grade_5                         1.0 1.0                       2.0                         1 1                 2
1917078 1917078 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other 02 12 2020   grade_5                         4.0 1.0                       5.0                         4 1                 5
1918110 1918110 IN     school 1800205 8690   Dynamic Minds Academy 180020502673 8692 Dynamic Minds Academy   Regular School Yes Other KG 12 2020   grade_5                         8.0 1.0                       9.0                         8 1                 9
1921047 1921047 IN     school 1806600 2275   Middlebury Community Schools 180660000199 1734 Orchard View School   Regular School No Elementary KG 05 2021   grade_5                         0.0 1.0                       1.0                         0 1                 1
1925548 1925548 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_5                         4.0 1.0                       5.0                         4 1                 5
1925613 1925613 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2021   grade_5                         5.0 1.0                       6.0                         5 1                 6
1926143 1926143 IN     school 1809060 5485   Plymouth Community School Corp 180906001503 5933 Menominee Elementary School   Regular School No Elementary KG 05 2021   grade_5                         1.0 1.0                       2.0                         1 1                 2
1928010 1928010 IN     school 1810290 7205   South Bend Community School Corp 181029002699 7248 South Bend Virtual School   Regular School No Other 01 12 2021   grade_5                         5.0 1.0                       6.0                         5 1                 6
1928350 1928350 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2021   grade_5                         2.0 1.0                       3.0                         2 1                 3
1930042 1930042 IN     school 1800205 8690   Dynamic Minds Academy 180020502673 8692 Dynamic Minds Academy   Regular School Yes Other KG 12 2021   grade_5                         7.0 1.0                       8.0                         7 1                 8
1930831 1930831 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2021   grade_5                         10.0 1.0                       11.0                         10 1                 11
1159857 1159857 IN     school 1803630 235   Fort Wayne Community Schools 180363000549 213 Nebraska Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         22.0 10.0                       32.0                         22 10                 32
1160875 1160875 IN     school 1802440 1300   Crawford Co Com School Corp 180244000282 1061 Marengo Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         16.0 10.0                       26.0                         16 10                 26
1161124 1161124 IN     school 1803060 1805   DeKalb Co Eastern Com Sch Dist 180306000406 1335 Riverdale Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         21.0 10.0                       31.0                         21 10                 31
1163541 1163541 IN     school 1801230 3640   Medora Community School Corp 180123002268 3095 Medora Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         7.0 10.0                       17.0                         7 10                 17
1168177 1168177 IN     school 1807290 6590   M S D Mount Vernon 180729001223 6965 Farmersville Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         22.0 10.0                       32.0                         22 10                 32
1168344 1168344 IN     school 1811730 6795   Union School Corporation 181173001874 7117 Union Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         14.0 10.0                       24.0                         14 10                 24
1168671 1168671 IN     school 1806840 7200   School City of Mishawaka 180684001178 7459 Fred J Hums Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         21.0 10.0                       31.0                         21 10                 31
1169340 1169340 IN     school 1808160 7645   Northeast School Corp 180816001400 7921 Northeast North Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         27.0 10.0                       37.0                         27 10                 37
1170252 1170252 IN     school 1812390 8130   Warrick County School Corp 181239001980 8769 Elberfeld Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         13.0 10.0                       23.0                         13 10                 23
1171173 1171173 IN     school 1800065 9690   Renaissance Academy Charter School 180006502415 4711 Renaissance Academy Charter Schl   Regular School Yes 1.0 KG 08 2015   grade_5                         12.0 10.0                       22.0                         12 10                 22
1171191 1171191 IN     school 1800092 9715   Andrew Academy 180009202493 5785 Andrew Academy   Regular School Yes 1.0 KG 08 2015   grade_5                         8.0 10.0                       18.0                         8 10                 18
1281322 1281322 IN     school 1803630 235   Fort Wayne Community Schools 180363000567 265 Washington Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         11.0 10.0                       21.0                         11 10                 21
1282063 1282063 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         16.0 10.0                       26.0                         16 10                 26
1283781 1283781 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         13.0 10.0                       23.0                         13 10                 23
1283789 1283789 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         15.0 10.0                       25.0                         15 10                 25
1285116 1285116 IN     school 1804980 3945   Jay School Corp 180498000915 3277 Judge Haynes Elementary Sch   Regular School No 1.0 KG 05 2016   grade_5                         14.0 10.0                       24.0                         14 10                 24
1287901 1287901 IN     school 1804770 5385   Indianapolis Public Schools 180477000822 5555 Eliza A Blaker School 55   Regular School No 1.0 PK 06 2016   grade_5                         9.0 10.0                       19.0                         9 10                 19
1288617 1288617 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000131 6213 Marlin Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         16.0 10.0                       26.0                         16 10                 26
1288686 1288686 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001714 6233 Ladoga Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         10.0 10.0                       20.0                         10 10                 20
1288890 1288890 IN     school 1807920 5945   North Newton School Corp 180792001361 6397 Morocco Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         8.0 10.0                       18.0                         8 10                 18
1289660 1289660 IN     school 1810500 6705   South Putnam Community Schools 181050001724 7057 Fillmore Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         10.0 10.0                       20.0                         10 10                 20
1292211 1292211 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2016   grade_5                         18.0 10.0                       28.0                         18 10                 28
1292249 1292249 IN     school 1800137 9365   Enlace Academy 180013702551 5667 Enlace Academy   Regular School Yes 1.0 KG 05 2016   grade_5                         20.0 10.0                       30.0                         20 10                 30
1297126 1297126 IN     school 1804980 3945   Jay School Corporation 180498000917 3247 Redkey Elementary School   Regular School No Elementary KG 05 2017   grade_5                         23.0 10.0                       33.0                         23 10                 33
1298723 1298723 IN     school 1805580 4945   LaPorte Community School Corp 180558001014 4721 Kingsford Heights Elementary Sch   Regular School No Elementary PK 05 2017   grade_5                         11.0 10.0                       21.0                         11 10                 21
1299928 1299928 IN     school 1804770 5385   Indianapolis Public Schools 180477000822 5555 Eliza A Blaker School 55   Regular School No Elementary PK 06 2017   grade_5                         15.0 10.0                       25.0                         15 10                 25
1299937 1299937 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2017   grade_5                         16.0 10.0                       26.0                         16 10                 26
1299983 1299983 IN     school 1804770 5385   Indianapolis Public Schools 180477000884 5565 Raymond F Brandes School 65   Regular School No Elementary PK 06 2017   grade_5                         25.0 10.0                       35.0                         25 10                 35
1300631 1300631 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000127 6197 Fairview Elementary School   Regular School No Elementary PK 06 2017   grade_5                         26.0 10.0                       36.0                         26 10                 36
1301683 1301683 IN     school 1810500 6705   South Putnam Community Schools 181050001724 7057 Fillmore Elementary School   Regular School No Elementary PK 05 2017   grade_5                         16.0 10.0                       26.0                         16 10                 26
1302695 1302695 IN     school 1804230 7610   Hamilton Community Schools 180423000723 7889 Hamilton Community Elementary Sch   Regular School No Elementary KG 06 2017   grade_5                         12.0 10.0                       22.0                         12 10                 22
1304928 1304928 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 06 2017   grade_5                         10.0 10.0                       20.0                         10 10                 20
1754164 1754164 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Township Elementary   Regular School No Elementary KG 06 2019   grade_5                         11.0 10.0                       21.0                         11 10                 21
1757350 1757350 IN     school 1807860 5075   North Lawrence Com Schools 180786001344 4885 Dollens Elementary School   Regular School No Elementary KG 05 2019   grade_5                         28.0 10.0                       38.0                         28 10                 38
1758517 1758517 IN     school 1804770 5385   Indianapolis Public Schools 180477000893 5574 Theodore Potter School 74   Regular School No Elementary KG 06 2019   grade_5                         18.0 10.0                       28.0                         18 10                 28
1762739 1762739 IN     school 1800193 9080   Vanguard Collegiate of Indy 180019302639 1004 Vanguard Collegiate of Indy   Regular School Yes Middle 05 07 2019   grade_5                         10.0 10.0                       20.0                         10 10                 20
1763043 1763043 IN     school 1800048 9555   East Chicago Urban Enterprise Acad 180004802163 3935 East Chicago Urban Enterprise Acad   Regular School Yes Elementary KG 08 2019   grade_5                         31.0 10.0                       41.0                         31 10                 41
1763297 1763297 IN     school 1800074 9795   Dr Robert H Faulkner Academy 180007402426 2411 Dr Robert H Faulkner Academy   Regular School Yes Elementary KG 06 2019   grade_5                         2.0 10.0                       12.0                         2 10                 12
1795453 1795453 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001787 6605 Gosport Elementary School   Regular School No Elementary KG 06 2018   grade_5                         11.0 10.0                       21.0                         11 10                 21
1798737 1798737 IN     school 1800037 9495   Joshua Academy 180003702146 8203 Joshua Academy   Regular School Yes Elementary KG 06 2018   grade_5                         9.0 10.0                       19.0                         9 10                 19
1907100 1907100 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2020   grade_5                         15.0 10.0                       25.0                         15 10                 25
1915746 1915746 IN     school 1801770 6825   Randolph Central School Corp 180177002191 7146 Deerfield Elementary School   Regular School No Elementary PK 05 2020   grade_5                         11.0 10.0                       21.0                         11 10                 21
1916034 1916034 IN     school 1806840 7200   School City of Mishawaka 180684001174 7469 Battell Elementary School   Regular School No Elementary KG 06 2020   grade_5                         28.0 10.0                       38.0                         28 10                 38
1918184 1918184 IN     school 1800196 9060   Paramount Community Heights 180019602643 139 Paramount Community Heights   Regular School Yes Elementary KG 05 2020   grade_5                         8.0 10.0                       18.0                         8 10                 18
1918274 1918274 IN     school 1800208 9165   Paramount Englewood 180020802655 7861 Paramount Englewood   Regular School Yes Middle 05 08 2020   grade_5                         5.0 10.0                       15.0                         5 10                 15
1923006 1923006 IN     school 1810080 3675   Seymour Community Schools 181008001615 3105 Cortland Elementary School   Regular School No Elementary KG 05 2021   grade_5                         15.0 10.0                       25.0                         15 10                 25
1926526 1926526 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001717 6258 Walnut Elementary School   Regular School No Elementary PK 05 2021   grade_5                         9.0 10.0                       19.0                         9 10                 19
1928575 1928575 IN     school 1811100 7615   MSD Steuben County 181110001801 7905 Pleasant Lake Elementary School   Regular School No Elementary KG 05 2021   grade_5                         8.0 10.0                       18.0                         8 10                 18
1928606 1928606 IN     school 1810860 7715   Southwest School Corporation 181086001770 7953 Carlisle Elementary School   Regular School No Elementary PK 05 2021   grade_5                         11.0 10.0                       21.0                         11 10                 21
1930112 1930112 IN     school 1800189 9030   Otwell Miller Academy 180018902616 2019 Otwell Miller Academy   Regular School Yes Elementary KG 05 2021   grade_5                         10.0 10.0                       20.0                         10 10                 20
1930561 1930561 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_5                         8.0 10.0                       18.0                         8 10                 18
1797320 1797320 IN     school 1812870 7875   West Lafayette Com School Corp 181287002045 8135 West Lafayette Intermediate School   Regular School No Middle 04 06 2018   grade_5                         92.0 100.0                       192.0                         92 100                 192
1798190 1798190 IN     school 1809510 8385   Richmond Community Schools 180951001561 8997 Test Intermediate School   Regular School No Middle 05 08 2018   grade_5                         104.0 100.0                       204.0                         104 100                 204
1910295 1910295 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000695 2593 Greenfield Intermediate School   Regular School No Middle 04 06 2020   grade_5                         75.0 100.0                       175.0                         75 100                 175
1910621 1910621 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2020   grade_5                         98.0 100.0                       198.0                         98 100                 198
1297896 1297896 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2017   grade_5                         118.0 101.0                       219.0                         118 101                 219
1762406 1762406 IN     school 1809510 8385   Richmond Community Schools 180951001561 8997 Test Intermediate School   Regular School No Middle 05 08 2019   grade_5                         103.0 101.0                       204.0                         103 101                 204
1926156 1926156 IN     school 1809060 5485   Plymouth Community School Corp 180906002211 5956 Riverside Intermediate   Regular School No Middle 05 06 2021   grade_5                         142.0 101.0                       243.0                         142 101                 243
1167104 1167104 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001708 6153 Edgewood Intermediate School   Regular School No 1.0 03 05 2015   grade_5                         96.0 102.0                       198.0                         96 102                 198
1755175 1755175 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2019   grade_5                         107.0 102.0                       209.0                         107 102                 209
1756493 1756493 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2019   grade_5                         95.0 102.0                       197.0                         95 102                 197
1756510 1756510 IN     school 1805450 4615   Lake Central School Corporation 180545002420 3838 Hal E Clark Middle School   Regular School No Middle 05 08 2019   grade_5                         123.0 102.0                       225.0                         123 102                 225
1791182 1791182 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2018   grade_5                         112.0 102.0                       214.0                         112 102                 214
1914445 1914445 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001708 6153 Edgewood Intermediate School   Regular School No Elementary 03 05 2020   grade_5                         102.0 102.0                       204.0                         102 102                 204
1164459 1164459 IN     school 1805450 4615   Lake Central School Corp 180545000985 3831 Michael Grimmer Middle School   Regular School No 2.0 05 08 2015   grade_5                         104.0 103.0                       207.0                         104 103                 207
1169585 1169585 IN     school 1812870 7875   West Lafayette Com School Corp 181287002045 8135 Happy Hollow Elementary   Regular School No 2.0 04 06 2015   grade_5                         97.0 103.0                       200.0                         97 103                 200
1298057 1298057 IN     school 1802490 4660   Crown Point Community School Corp 180249002025 3907 Jerry Ross Elementary School   Regular School No Elementary 03 05 2017   grade_5                         90.0 103.0                       193.0                         90 103                 193
1755441 1755441 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2019   grade_5                         113.0 103.0                       216.0                         113 103                 216
1799169 1799169 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2018   grade_5                         97.0 103.0                       200.0                         97 103                 200
1907476 1907476 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2020   grade_5                         108.0 103.0                       211.0                         108 103                 211
1922573 1922573 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2021   grade_5                         91.0 104.0                       195.0                         91 104                 195
1922846 1922846 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2021   grade_5                         92.0 104.0                       196.0                         92 104                 196
1281370 1281370 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No 2.0 04 06 2016   grade_5                         97.0 105.0                       202.0                         97 105                 202
1756417 1756417 IN     school 1804350 4580   Hanover Community School Corp 180435001908 3784 Hanover Central Middle School   Regular School No Middle 05 08 2019   grade_5                         81.0 105.0                       186.0                         81 105                 186
1789722 1789722 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001276 1937 Nathaniel Scribner Middle School   Regular School No Middle 05 08 2018   grade_5                         103.0 105.0                       208.0                         103 105                 208
1911864 1911864 IN     school 1804350 4580   Hanover Community School Corp 180435001908 3784 Hanover Central Middle School   Regular School No Middle 05 08 2020   grade_5                         108.0 105.0                       213.0                         108 105                 213
1788337 1788337 IN     school 1809370 940   West Clark Community Schools 180937001538 789 Silver Creek Elementary School   Regular School No Elementary 02 05 2018   grade_5                         104.0 106.0                       210.0                         104 106                 210

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