Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_5 · 6,726
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
1159511 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_5                         51.0 48.0                       99.0                         51 48                 99
1162976 IN     school 1808100 3295   North West Hendricks Schools 180810001386 2725 Pittsboro Elementary   Regular School No 1.0 03 05 2015   grade_5                         56.0 43.0                       99.0                         56 43                 99
1165516 IN     school 1810440 5255   South Madison Com Sch Corp 181044001676 5064 Maple Ridge Elementary Sch   Regular School No 1.0 KG 06 2015   grade_5                         48.0 51.0                       99.0                         48 51                 99
1165714 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000596 5205 Bunker Hill Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         51.0 48.0                       99.0                         51 48                 99
1167466 IN     school 1807140 5930   Mooresville Con School Corp 180714001210 6385 North Madison Elem Sch   Regular School No 1.0 KG 06 2015   grade_5                         51.0 48.0                       99.0                         51 48                 99
1169868 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000487 8365 Vogel Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         43.0 56.0                       99.0                         43 56                 99
1170029 IN     school 1812090 8030   Vigo County School Corp 181209001914 8525 Rio Grande Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         60.0 39.0                       99.0                         60 39                 99
1280909 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         49.0 50.0                       99.0                         49 50                 99
1284126 IN     school 1807650 3070   Noblesville Schools 180765002414 2537 Noble Crossing Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         55.0 44.0                       99.0                         55 44                 99
1284308 IN     school 1800690 3180   North Harrison Com School Corp 180069000143 2633 North Harrison Elementary Sch   Regular School No 1.0 KG 05 2016   grade_5                         50.0 49.0                       99.0                         50 49                 99
1286479 IN     school 1807350 4740   School Town of Munster 180735001255 4337 James B Eads Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         44.0 55.0                       99.0                         44 55                 99
1287602 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         48.0 51.0                       99.0                         48 51                 99
1290055 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001148 7390 Northpoint Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         64.0 35.0                       99.0                         64 35                 99
1293236 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary School   Regular School No Elementary KG 05 2017   grade_5                         50.0 49.0                       99.0                         50 49                 99
1293863 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No Elementary PK 05 2017   grade_5                         48.0 51.0                       99.0                         48 51                 99
1297222 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001766 3341 Southwestern Elementary School   Regular School No Elementary PK 05 2017   grade_5                         51.0 48.0                       99.0                         51 48                 99
1299115 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002113 5198 Thompson Crossing Elementary Sch   Regular School No Elementary KG 05 2017   grade_5                         46.0 53.0                       99.0                         46 53                 99
1299428 IN     school 1808910 5350   M S D Pike Township 180891001598 5363 Snacks Crossing Elementary School   Regular School No Elementary PK 05 2017   grade_5                         54.0 45.0                       99.0                         54 45                 99
1301303 IN     school 1800750 6460   M S D Boone Township 180075000152 6815 Hebron Elementary School   Regular School No Elementary KG 05 2017   grade_5                         51.0 48.0                       99.0                         51 48                 99
1301397 IN     school 1809180 6520   Porter Township School Corp 180918001520 6837 Boone Grove Elementary School   Regular School No Elementary 04 05 2017   grade_5                         53.0 46.0                       99.0                         53 46                 99
1301638 IN     school 1807110 6620   Eastern Pulaski Community Sch Corp 180711001204 6994 Eastern Pulaski Elementary School   Regular School No Elementary PK 05 2017   grade_5                         57.0 42.0                       99.0                         57 42                 99
1302992 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2017   grade_5                         44.0 55.0                       99.0                         44 55                 99
1303511 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No Elementary KG 05 2017   grade_5                         46.0 53.0                       99.0                         46 53                 99
1752154 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No Elementary PK 06 2019   grade_5                         57.0 42.0                       99.0                         57 42                 99
1752748 IN     school 1803940 1010   Greater Clark County Schools 180394000675 879 Parkwood Elementary School   Regular School No Elementary PK 05 2019   grade_5                         56.0 43.0                       99.0                         56 43                 99
1753657 IN     school 1812240 2285   Wa-Nee Community Schools 181224000028 1735 Wakarusa Elementary School   Regular School No Elementary KG 05 2019   grade_5                         55.0 44.0                       99.0                         55 44                 99
1755878 IN     school 1805190 4015   Jennings County School Corporation 180519000924 3397 North Vernon Elementary School   Regular School No Elementary KG 06 2019   grade_5                         61.0 38.0                       99.0                         61 38                 99
1756329 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No Middle 05 08 2019   grade_5                         55.0 44.0                       99.0                         55 44                 99
1757674 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002222 5202 Arlington Elementary School   Regular School No Elementary KG 05 2019   grade_5                         52.0 47.0                       99.0                         52 47                 99
1757945 IN     school 1808910 5350   M S D Pike Township 180891002250 5358 Eagle Creek Elementary School   Regular School No Elementary KG 05 2019   grade_5                         55.0 44.0                       99.0                         55 44                 99
1787457 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2018   grade_5                         50.0 49.0                       99.0                         50 49                 99
1787925 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elementary School   Regular School No Elementary KG 06 2018   grade_5                         45.0 54.0                       99.0                         45 54                 99
1789422 IN     school 1803270 2305   Elkhart Community Schools 180327000426 1617 Cleveland Elementary School   Regular School No Elementary KG 06 2018   grade_5                         50.0 49.0                       99.0                         50 49                 99
1791640 IN     school 1805190 4015   Jennings County School Corporation 180519000924 3397 North Vernon Elementary School   Regular School No Elementary KG 06 2018   grade_5                         53.0 46.0                       99.0                         53 46                 99
1792459 IN     school 1802880 4670   School City of East Chicago 180288000375 3953 William McKinley Elementary School   Regular School No Elementary KG 06 2018   grade_5                         46.0 53.0                       99.0                         46 53                 99
1792736 IN     school 1804320 4710   School City of Hammond 180432002237 4469 Morton Elementary School   Regular School No Elementary KG 05 2018   grade_5                         57.0 42.0                       99.0                         57 42                 99
1796171 IN     school 1810530 6865   South Ripley Com Sch Corp 181053002380 7178 South Ripley Elementary School   Regular School No Elementary KG 06 2018   grade_5                         48.0 51.0                       99.0                         48 51                 99
1797793 IN     school 1812090 8030   Vigo County School Corp 181209001909 8549 Lost Creek Elementary School   Regular School No Elementary KG 05 2018   grade_5                         44.0 55.0                       99.0                         44 55                 99
1908295 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2020   grade_5                         59.0 40.0                       99.0                         59 40                 99
1911260 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001766 3341 Southwestern Elementary School   Regular School No Elementary PK 05 2020   grade_5                         53.0 46.0                       99.0                         53 46                 99
1916900 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2020   grade_5                         42.0 57.0                       99.0                         42 57                 99
1917684 IN     school 1812390 8130   Warrick County School Corp 181239001979 8813 Chandler Elementary School   Regular School No Elementary KG 05 2020   grade_5                         60.0 39.0                       99.0                         60 39                 99
1922084 IN     school 1801200 3060   Carmel Clay Schools 180120002267 2513 Orchard Park Elementary School   Regular School No Elementary PK 05 2021   grade_5                         60.0 39.0                       99.0                         60 39                 99
1925558 IN     school 1812810 5375   MSD Wayne Township 181281002042 5273 Westlake Elementary School   Regular School No Elementary PK 06 2021   grade_5                         49.0 50.0                       99.0                         49 50                 99
1926576 IN     school 1804140 5900   Monroe-Gregg School District 180414000715 6323 Monrovia Elementary School   Regular School No Elementary PK 05 2021   grade_5                         56.0 43.0                       99.0                         56 43                 99
1927193 IN     school 1809180 6520   Porter Township School Corp 180918001520 6837 Boone Grove Elementary School   Regular School No Elementary 04 05 2021   grade_5                         53.0 46.0                       99.0                         53 46                 99
1928387 IN     school 1810140 7365   Shelbyville Central Schools 181014001633 7733 William F Loper Elementary School   Regular School No Elementary KG 05 2021   grade_5                         47.0 52.0                       99.0                         47 52                 99
1929305 IN     school 1812090 8030   Vigo County School Corp 181209001903 8511 Dixie Bee Elementary School   Regular School No Elementary KG 05 2021   grade_5                         66.0 33.0                       99.0                         66 33                 99
1929480 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No Middle 05 08 2021   grade_5                         46.0 53.0                       99.0                         46 53                 99
1159593 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         56.0 42.0                       98.0                         56 42                 98
1165767 IN     school 1805670 5330   M S D Lawrence Township 180567001027 5289 Harrison Hill Elem Sch   Regular School No 1.0 01 06 2015   grade_5                         55.0 43.0                       98.0                         55 43                 98
1165792 IN     school 1805670 5330   M S D Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No 1.0 01 06 2015   grade_5                         50.0 48.0                       98.0                         50 48                 98
1165925 IN     school 1808910 5350   M S D Pike Township 180891001099 5349 Fishback Creek Public Aca   Regular School No 1.0 PK 05 2015   grade_5                         48.0 50.0                       98.0                         48 50                 98
1166256 IN     school 1812810 5375   M S D Wayne Township 181281002031 5274 Chapelwood Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         48.0 50.0                       98.0                         48 50                 98
1166468 IN     school 1804770 5385   Indianapolis Public Schools 180477000904 5549 William Penn School 49   Regular School No 1.0 KG 06 2015   grade_5                         58.0 40.0                       98.0                         58 40                 98
1168435 IN     school 1810530 6865   South Ripley Com Sch Corp 181053002380 7178 South Ripley Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         42.0 56.0                       98.0                         42 56                 98
1170323 IN     school 1812390 8130   Warrick County School Corp 181239001984 8817 Newburgh Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         50.0 48.0                       98.0                         50 48                 98
1170997 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2015   grade_5                         41.0 57.0                       98.0                         41 57                 98
1281152 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         49.0 49.0                       98.0                         49 49                 98
1284745 IN     school 1802040 3470   Northwestern School Corp 180204000254 2904 Northwestern Elementary Sch   Regular School No 1.0 KG 06 2016   grade_5                         50.0 48.0                       98.0                         50 48                 98
1285475 IN     school 1810410 4325   South Knox School Corp 181041001705 3489 South Knox Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         63.0 35.0                       98.0                         63 35                 98
1287031 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elem Sch   Regular School No 1.0 01 06 2016   grade_5                         49.0 49.0                       98.0                         49 49                 98
1287239 IN     school 1808820 5340   Perry Township Schools 180882001469 5321 William Henry Burkhart Elementary   Regular School No 1.0 PK 05 2016   grade_5                         51.0 47.0                       98.0                         51 47                 98
1287369 IN     school 1808910 5350   M S D Pike Township 180891002250 5358 Eagle Creek Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         42.0 56.0                       98.0                         42 56                 98
1290159 IN     school 1810290 7205   South Bend Community Sch Corp 181029001650 7425 Clay Intermediate Center   Regular School No 2.0 05 08 2016   grade_5                         59.0 39.0                       98.0                         59 39                 98
1292971 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_5                         53.0 45.0                       98.0                         53 45                 98
1294006 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2017   grade_5                         56.0 42.0                       98.0                         56 42                 98
1296092 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary School   Regular School No Elementary KG 05 2017   grade_5                         48.0 50.0                       98.0                         48 50                 98
1296668 IN     school 1808280 3435   Shenandoah School Corporation 180828002356 2815 Shenandoah Elementary School   Regular School No Elementary PK 05 2017   grade_5                         47.0 51.0                       98.0                         47 51                 98
1297291 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000244 3401 Clark Elementary School   Regular School No Elementary KG 05 2017   grade_5                         47.0 51.0                       98.0                         47 51                 98
1301538 IN     school 1811970 6560   Valparaiso Community Schools 181197000163 6893 Flint Lake Elementary School   Regular School No Elementary KG 05 2017   grade_5                         52.0 46.0                       98.0                         52 46                 98
1302231 IN     school 1810290 7205   South Bend Community School Corp 181029002296 7521 Brown Intermediate Center   Regular School No Elementary 03 08 2017   grade_5                         60.0 38.0                       98.0                         60 38                 98
1302907 IN     school 1811340 7865   Tippecanoe School Corp 181134001826 8007 Hershey Elementary School   Regular School No Elementary KG 05 2017   grade_5                         47.0 51.0                       98.0                         47 51                 98
1755378 IN     school 1811250 3460   Taylor Community School Corp 181125001812 2895 Taylor Elementary School   Regular School No Elementary PK 05 2019   grade_5                         51.0 47.0                       98.0                         51 47                 98
1756897 IN     school 1804320 4710   School City of Hammond 180432000751 4455 Washington Irving Elementary Sch   Regular School No Elementary PK 05 2019   grade_5                         52.0 46.0                       98.0                         52 46                 98
1757477 IN     school 1810440 5255   South Madison Com Sch Corp 181044001676 5064 Maple Ridge Elementary School   Regular School No Elementary PK 06 2019   grade_5                         46.0 52.0                       98.0                         46 52                 98
1757727 IN     school 1805670 5330   M S D Lawrence Township 180567001026 5285 Crestview Elementary School   Regular School No Elementary 01 06 2019   grade_5                         54.0 44.0                       98.0                         54 44                 98
1758098 IN     school 1812720 5370   M S D Washington Township 181272002023 5430 Spring Mill Elementary School   Regular School No Elementary KG 05 2019   grade_5                         40.0 58.0                       98.0                         40 58                 98
1758406 IN     school 1804770 5385   Indianapolis Public Schools 180477000904 5549 William Penn School 49   Regular School No Elementary PK 08 2019   grade_5                         49.0 49.0                       98.0                         49 49                 98
1758533 IN     school 1804770 5385   Indianapolis Public Schools 180477000808 5579 Carl Wilde School 79   Regular School No Elementary KG 06 2019   grade_5                         53.0 45.0                       98.0                         53 45                 98
1761492 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2019   grade_5                         52.0 46.0                       98.0                         52 46                 98
1762647 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2019   grade_5                         52.0 46.0                       98.0                         52 46                 98
1763018 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2019   grade_5                         57.0 41.0                       98.0                         57 41                 98
1789118 IN     school 1807320 1970   Muncie Community Schools 180732002153 1482 South View Elementary School   Regular School No Elementary PK 05 2018   grade_5                         43.0 55.0                       98.0                         43 55                 98
1796843 IN     school 1810140 7365   Shelbyville Central Schools 181014001627 7725 Coulston Elementary School   Regular School No Elementary PK 05 2018   grade_5                         51.0 47.0                       98.0                         51 47                 98
1907135 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2020   grade_5                         50.0 48.0                       98.0                         50 48                 98
1907149 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2020   grade_5                         50.0 48.0                       98.0                         50 48                 98
1908019 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   grade_5                         50.0 48.0                       98.0                         50 48                 98
1909315 IN     school 1803930 2315   Goshen Community Schools 180393002180 1847 Prairie View Elementary School   Regular School No Elementary PK 06 2020   grade_5                         53.0 45.0                       98.0                         53 45                 98
1910830 IN     school 1811250 3460   Taylor Community School Corp 181125001263 2896 Taylor Middle School   Regular School No Middle 05 08 2020   grade_5                         42.0 56.0                       98.0                         42 56                 98
1911410 IN     school 1801440 4205   Center Grove Community School Corp 180144000211 3440 North Grove Elementary School   Regular School No Elementary KG 05 2020   grade_5                         54.0 44.0                       98.0                         54 44                 98
1914697 IN     school 1804140 5900   Monroe-Gregg School District 180414000715 6323 Monrovia Elementary School   Regular School No Elementary PK 05 2020   grade_5                         51.0 47.0                       98.0                         51 47                 98
1917812 IN     school 1808190 8375   Northeastern Wayne Schools 180819002228 8928 Northeastern Elementary School   Regular School No Elementary PK 05 2020   grade_5                         41.0 57.0                       98.0                         41 57                 98
1920159 IN     school 1803940 1010   Greater Clark County Schools 180394000675 879 Parkwood Elementary School   Regular School No Elementary PK 05 2021   grade_5                         58.0 40.0                       98.0                         58 40                 98
1922181 IN     school 1807650 3070   Noblesville Schools 180765002546 2539 Promise Road Elementary   Regular School No Elementary PK 05 2021   grade_5                         60.0 38.0                       98.0                         60 38                 98
1923018 IN     school 1810080 3675   Seymour Community Schools 181008001617 3135 Margaret R Brown Elementary School   Regular School No Elementary KG 05 2021   grade_5                         57.0 41.0                       98.0                         57 41                 98
1925086 IN     school 1805670 5330   MSD Lawrence Township 180567000150 5294 Forest Glen Elementary School   Regular School No Elementary PK 06 2021   grade_5                         45.0 53.0                       98.0                         45 53                 98
1927465 IN     school 1807110 6620   Eastern Pulaski Community Sch Corp 180711001204 6994 Eastern Pulaski Elementary School   Regular School No Elementary PK 05 2021   grade_5                         59.0 39.0                       98.0                         59 39                 98
1159760 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elem Sch   Regular School No 1.0 KG 05 2015   grade_5                         49.0 48.0                       97.0                         49 48                 97
1159803 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         41.0 56.0                       97.0                         41 56                 97

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