Data source: Big Local News · About: Big Local

7,371 rows where grade = "grade_2" and state = "IN" sorted by male_int

View and edit SQL

year

grade

  • grade_2 · 7,271
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
1918547 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2020   grade_2                         5.0 3.0                       8.0                         5 3                 8
1918680 IN     school 1800129 9725   Canaan Community Academy 180012902534 3312 Canaan Community Academy   Regular School Yes Elementary KG 06 2020   grade_2                         5.0 15.0                       20.0                         5 15                 20
1930079 IN     school 1800221 8990   HIM By HER Collegiate School for t 180022102706 9991 HIM By HER Collegiate School for t   Regular School Yes Elementary KG 02 2021   grade_2                         5.0 3.0                       8.0                         5 3                 8
1930441 IN     school 1800043 9465   Rural Community Schools Inc 180004302138 7951 Rural Community Academy   Regular School Yes Elementary KG 08 2021   grade_2                         5.0 5.0                       10.0                         5 5                 10
1162102 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2015   grade_2                         6.0 10.0                       16.0                         6 10                 16
1162113 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         6.0 6.0                       12.0                         6 6                 12
1163689 IN     school 1804980 3945   Jay School Corp 180498000916 3257 Pennville Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         6.0 7.0                       13.0                         6 7                 13
1164356 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_2                         6.0 1.0                       7.0                         6 1                 7
1171208 IN     school 1800129 9725   Canaan Community Academy 180012902534 3312 Canaan Community Academy   Regular School Yes 1.0 KG 06 2015   grade_2                         6.0 7.0                       13.0                         6 7                 13
1171467 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_2                         6.0 0.0                       6.0                         6 0                 6
1287636 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_2                         6.0 1.0                       7.0                         6 1                 7
1291671 IN     school 1812390 8130   Warrick County School Corp 181239001987 8785 Tennyson Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         6.0 4.0                       10.0                         6 4                 10
1292683 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2016   grade_2                         6.0 3.0                       9.0                         6 3                 9
1295568 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No Elementary KG 06 2017   grade_2                         6.0 3.0                       9.0                         6 3                 9
1296986 IN     school 1810080 3675   Seymour Community Schools 181008001615 3105 Cortland Elementary School   Regular School No Elementary KG 05 2017   grade_2                         6.0 11.0                       17.0                         6 11                 17
1297173 IN     school 1806120 3995   Madison Consolidated Schools 180612001085 3301 Deputy Elementary School   Regular School No Elementary PK 05 2017   grade_2                         6.0 13.0                       19.0                         6 13                 19
1298807 IN     school 1807860 5075   North Lawrence Com Schools 180786001340 4873 Heltonville Elementary School   Regular School No Elementary KG 05 2017   grade_2                         6.0 3.0                       9.0                         6 3                 9
1299673 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_2                         6.0 0.0                       6.0                         6 0                 6
1303694 IN     school 1812390 8130   Warrick County School Corp 181239001987 8785 Tennyson Elementary School   Regular School No Elementary KG 05 2017   grade_2                         6.0 6.0                       12.0                         6 6                 12
1304241 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes Elementary KG 08 2017   grade_2                         6.0 10.0                       16.0                         6 10                 16
1304481 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_2                         6.0 4.0                       10.0                         6 4                 10
1762231 IN     school 1812390 8130   Warrick County School Corp 181239001987 8785 Tennyson Elementary School   Regular School No Elementary KG 05 2019   grade_2                         6.0 9.0                       15.0                         6 9                 15
1794255 IN     school 1804770 5385   Indianapolis Public Schools 180477000841 5557 George W Julian School 57   Regular School No Elementary KG 07 2018   grade_2                         6.0 11.0                       17.0                         6 11                 17
1798016 IN     school 1812390 8130   Warrick County School Corp 181239001987 8785 Tennyson Elementary School   Regular School No Elementary KG 05 2018   grade_2                         6.0 10.0                       16.0                         6 10                 16
1798479 IN     school 1800189 9030   Otwell Miller Academy 180018902616 2019 Otwell Miller Academy   Regular School Yes Elementary KG 05 2018   grade_2                         6.0 10.0                       16.0                         6 10                 16
1798950 IN     school 1800129 9725   Canaan Community Academy 180012902534 3312 Canaan Community Academy   Regular School Yes Elementary KG 06 2018   grade_2                         6.0 9.0                       15.0                         6 9                 15
1799240 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2018   grade_2                         6.0 8.0                       14.0                         6 8                 14
1908854 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001388 1543 Celestine Elementary School   Regular School No Elementary KG 04 2020   grade_2                         6.0 9.0                       15.0                         6 9                 15
1915027 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001792 6601 Patricksburg Elementary School   Regular School No Elementary KG 06 2020   grade_2                         6.0 8.0                       14.0                         6 8                 14
1917650 IN     school 1812390 8130   Warrick County School Corp 181239001987 8785 Tennyson Elementary School   Regular School No Elementary KG 05 2020   grade_2                         6.0 5.0                       11.0                         6 5                 11
1919663 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2021   grade_2                         6.0 7.0                       13.0                         6 7                 13
1925545 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_2                         6.0 0.0                       6.0                         6 0                 6
1926988 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2021   grade_2                         6.0 11.0                       17.0                         6 11                 17
1927243 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_2                         6.0 1.0                       7.0                         6 1                 7
1927762 IN     school 1809750 6995   Rush County Schools 180975001594 7233 Milroy Elementary School   Regular School No Elementary KG 06 2021   grade_2                         6.0 14.0                       20.0                         6 14                 20
1928995 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_2                         6.0 0.0                       6.0                         6 0                 6
1163272 IN     school 1807440 3445   New Castle Community Sch Corp 180744001289 2853 Sunnyside Elementary School   Regular School No 1.0 KG 07 2015   grade_2                         7.0 10.0                       17.0                         7 10                 17
1163538 IN     school 1801230 3640   Medora Community School Corp 180123002268 3095 Medora Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         7.0 4.0                       11.0                         7 4                 11
1170200 IN     school 1806080 8115   M S D Warren County 180608001075 8729 Williamsport Elementary Sch   Regular School No 1.0 KG 06 2015   grade_2                         7.0 16.0                       23.0                         7 16                 23
1170208 IN     school 1806080 8115   M S D Warren County 180608001072 8733 Pine Village Elementary Sch   Regular School No 1.0 KG 06 2015   grade_2                         7.0 4.0                       11.0                         7 4                 11
1171198 IN     school 1800096 9720   Padua Academy 180009602470 5786 Padua Academy   Regular School Yes 1.0 KG 08 2015   grade_2                         7.0 20.0                       27.0                         7 20                 27
1171222 IN     school 1800123 9735   Inspire Academy - A Sch of Inquiry 180012302560 1518 Inspire Academy - A Sch of Inquiry   Regular School Yes 1.0 KG 06 2015   grade_2                         7.0 12.0                       19.0                         7 12                 19
1171230 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes 1.0 KG 08 2015   grade_2                         7.0 8.0                       15.0                         7 8                 15
1171323 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2015   grade_2                         7.0 14.0                       21.0                         7 14                 21
1288761 IN     school 1803330 5910   Eminence Community School Corp 180333002274 6327 Eminence Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         7.0 9.0                       16.0                         7 9                 16
1294801 IN     school 1807320 1970   Muncie Community Schools 180732001251 1517 West View Elementary School   Regular School No Elementary KG 05 2017   grade_2                         7.0 27.0                       34.0                         7 27                 34
1297130 IN     school 1804980 3945   Jay School Corporation 180498000916 3257 Pennville Elementary School   Regular School No Elementary KG 05 2017   grade_2                         7.0 5.0                       12.0                         7 5                 12
1302755 IN     school 1808160 7645   Northeast School Corp 180816001401 7941 Northeast East Elementary School   Regular School No Elementary PK 05 2017   grade_2                         7.0 12.0                       19.0                         7 12                 19
1304616 IN     school 1800129 9725   Canaan Community Academy 180012902534 3312 Canaan Community Academy   Regular School Yes Elementary KG 06 2017   grade_2                         7.0 10.0                       17.0                         7 10                 17
1304914 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2017   grade_2                         7.0 7.0                       14.0                         7 7                 14
1754172 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No Elementary KG 06 2019   grade_2                         7.0 7.0                       14.0                         7 7                 14
1757322 IN     school 1807860 5075   North Lawrence Com Schools 180786001342 4865 Needmore Elementary School   Regular School No Elementary KG 05 2019   grade_2                         7.0 10.0                       17.0                         7 10                 17
1758211 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_2                         7.0 1.0                       8.0                         7 1                 8
1761659 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_2                         7.0 1.0                       8.0                         7 1                 8
1762744 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 02 2019   grade_2                         7.0 13.0                       20.0                         7 13                 20
1763078 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_2                         7.0 0.0                       7.0                         7 0                 7
1763294 IN     school 1800074 9795   Dr Robert H Faulkner Academy 180007402426 2411 Dr Robert H Faulkner Academy   Regular School Yes Elementary KG 06 2019   grade_2                         7.0 6.0                       13.0                         7 6                 13
1789163 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001388 1543 Celestine Elementary School   Regular School No Elementary KG 04 2018   grade_2                         7.0 9.0                       16.0                         7 9                 16
1794001 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_2                         7.0 0.0                       7.0                         7 0                 7
1795232 IN     school 1807920 5945   North Newton School Corp 180792001361 6397 Morocco Elementary School   Regular School No Elementary KG 06 2018   grade_2                         7.0 8.0                       15.0                         7 8                 15
1797427 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000475 8251 Lincoln School   Regular School No Elementary KG 08 2018   grade_2                         7.0 18.0                       25.0                         7 18                 25
1799050 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2018   grade_2                         7.0 7.0                       14.0                         7 7                 14
1911213 IN     school 1806120 3995   Madison Consolidated Schools 180612001085 3301 Deputy Elementary School   Regular School No Elementary PK 04 2020   grade_2                         7.0 13.0                       20.0                         7 13                 20
1912568 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2020   grade_2                         7.0 8.0                       15.0                         7 8                 15
1913639 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_2                         7.0 1.0                       8.0                         7 1                 8
1915112 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2020   grade_2                         7.0 6.0                       13.0                         7 6                 13
1915428 IN     school 1811970 6560   Valparaiso Community Schools 181197001882 6891 Central Elementary School   Regular School No Elementary KG 05 2020   grade_2                         7.0 10.0                       17.0                         7 10                 17
1918089 IN     school 1800207 8675   Invent Learning Hub 180020702683 9532 Invent Learning Hub   Regular School Yes Elementary KG 05 2020   grade_2                         7.0 7.0                       14.0                         7 7                 14
1918445 IN     school 1800043 9465   Rural Community Schools Inc 180004302138 7951 Rural Community Academy   Regular School Yes Elementary KG 08 2020   grade_2                         7.0 2.0                       9.0                         7 2                 9
1918562 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_2                         7.0 20.0                       27.0                         7 20                 27
1920472 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000055 1169 Moores Hill Elementary School   Regular School No Elementary KG 06 2021   grade_2                         7.0 16.0                       23.0                         7 16                 23
1922369 IN     school 1810360 3190   South Harrison Com Schools 181036001698 2649 New Middletown Elementary School   Regular School No Elementary KG 06 2021   grade_2                         7.0 6.0                       13.0                         7 6                 13
1922738 IN     school 1807440 3445   New Castle Community School Corp 180744001289 2853 Sunnyside Elementary School   Regular School No Elementary KG 04 2021   grade_2                         7.0 5.0                       12.0                         7 5                 12
1926588 IN     school 1803330 5910   Eminence Community School Corp 180333002274 6327 Eminence Elementary School   Regular School No Elementary PK 06 2021   grade_2                         7.0 9.0                       16.0                         7 9                 16
1926716 IN     school 1807920 5945   North Newton School Corp 180792001359 6405 Lake Village Elementary School   Regular School No Elementary KG 06 2021   grade_2                         7.0 13.0                       20.0                         7 13                 20
1927355 IN     school 1811970 6560   Valparaiso Community Schools 181197001882 6891 Central Elementary School   Regular School No Elementary KG 05 2021   grade_2                         7.0 8.0                       15.0                         7 8                 15
1927584 IN     school 1811730 6795   Union School Corporation 181173001874 7117 Union Elementary School   Regular School No Elementary KG 06 2021   grade_2                         7.0 10.0                       17.0                         7 10                 17
1929578 IN     school 1812390 8130   Warrick County School Corp 181239001987 8785 Tennyson Elementary School   Regular School No Elementary KG 05 2021   grade_2                         7.0 2.0                       9.0                         7 2                 9
1930109 IN     school 1800189 9030   Otwell Miller Academy 180018902616 2019 Otwell Miller Academy   Regular School Yes Elementary KG 05 2021   grade_2                         7.0 13.0                       20.0                         7 13                 20
1161011 IN     school 1800240 1600   South Dearborn Com School Corp 180024000055 1169 Moores Hill Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         8.0 9.0                       17.0                         8 9                 17
1162376 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         8.0 16.0                       24.0                         8 16                 24
1166840 IN     school 1810920 5400   School Town of Speedway 181092001781 5897 Carl G Fisher Elem School 1   Regular School No 1.0 PK 06 2015   grade_2                         8.0 16.0                       24.0                         8 16                 24
1167488 IN     school 1807920 5945   North Newton School Corp 180792001361 6397 Morocco Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         8.0 15.0                       23.0                         8 15                 23
1168341 IN     school 1811730 6795   Union School Corporation 181173001874 7117 Union Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         8.0 13.0                       21.0                         8 13                 21
1170862 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2015   grade_2                         8.0 4.0                       12.0                         8 4                 12
1171312 IN     school 1800074 9795   Dr Robert H Faulkner Academy 180007402426 2411 Dr Robert H Faulkner Academy   Regular School Yes 1.0 KG 06 2015   grade_2                         8.0 10.0                       18.0                         8 10                 18
1289238 IN     school 1808900 6445   Pike County School Corp 180890001480 6759 Otwell Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         8.0 13.0                       21.0                         8 13                 21
1289735 IN     school 1811730 6795   Union School Corporation 181173001874 7117 Union Elementary School   Regular School No 1.0 KG 06 2016   grade_2                         8.0 6.0                       14.0                         8 6                 14
1290727 IN     school 1808160 7645   Northeast School Corp 180816001401 7941 Northeast East Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         8.0 6.0                       14.0                         8 6                 14
1292840 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2016   grade_2                         8.0 1.0                       9.0                         8 1                 9
1294433 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000053 1141 Dillsboro Elementary School   Regular School No Elementary KG 06 2017   grade_2                         8.0 12.0                       20.0                         8 12                 20
1300505 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001549 6117 Stinesville Elementary School   Regular School No Elementary KG 05 2017   grade_2                         8.0 10.0                       18.0                         8 10                 18
1300724 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001717 6258 Walnut Elementary School   Regular School No Elementary PK 06 2017   grade_2                         8.0 12.0                       20.0                         8 12                 20
1758451 IN     school 1804770 5385   Indianapolis Public Schools 180477000841 5557 George W Julian School 57   Regular School No Elementary KG 08 2019   grade_2                         8.0 8.0                       16.0                         8 8                 16
1759294 IN     school 1803330 5910   Eminence Community School Corp 180333002274 6327 Eminence Elementary School   Regular School No Elementary PK 05 2019   grade_2                         8.0 12.0                       20.0                         8 12                 20
1759626 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001787 6605 Gosport Elementary School   Regular School No Elementary KG 06 2019   grade_2                         8.0 12.0                       20.0                         8 12                 20
1760691 IN     school 1810290 7205   South Bend Community School Corp 181029001650 7425 Clay International Academy   Regular School No Elementary KG 08 2019   grade_2                         8.0 14.0                       22.0                         8 14                 22
1762657 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2019   grade_2                         8.0 21.0                       29.0                         8 21                 29
1762699 IN     school 1800189 9030   Otwell Miller Academy 180018902616 2019 Otwell Miller Academy   Regular School Yes Elementary KG 05 2019   grade_2                         8.0 1.0                       9.0                         8 1                 9
1789896 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Township Elementary   Regular School No Elementary KG 06 2018   grade_2                         8.0 7.0                       15.0                         8 7                 15

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