Data source: Big Local News · About: Big Local

944 rows where grade = "grade_5", state = "IN" and year = 2020 sorted by male

View and edit SQL

year

  • 2020 · 944

grade

  • grade_5 · 944
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
1914261 IN     school 1809060 5485   Plymouth Community School Corp 180906001503 5933 Menominee Elementary School   Regular School No Elementary KG 05 2020   grade_5                         0.0 2.0                       2.0                         0 2                 2
1916418 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 01 12 2020   grade_5                         0.0 2.0                       2.0                         0 2                 2
1908001 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 02 09 2020   grade_5                         1.0 0.0                       1.0                         1 0                 1
1909028 IN     school 1802400 2270   Concord Community Schools 180240000272 1723 Concord Ox-Bow Elementary School   Regular School No Elementary KG 05 2020   grade_5                         1.0 0.0                       1.0                         1 0                 1
1910003 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2020   grade_5                         1.0 0.0                       1.0                         1 0                 1
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
1917495 IN     school 1806270 8045   Manchester Community Schools 180627001101 8633 Manchester Elementary School   Regular School No Elementary PK 06 2020   grade_5                         1.0 0.0                       1.0                         1 0                 1
1917662 IN     school 1812390 8130   Warrick County School Corp 181239001976 8793 Boonville Middle School   Regular School No Middle 05 08 2020   grade_5                         1.0 0.0                       1.0                         1 0                 1
1908347 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000281 1037 South Crawford Elementary School   Regular School No Elementary PK 05 2020   grade_5                         10.0 6.0                       16.0                         10 6                 16
1912743 IN     school 1807860 5075   North Lawrence Com Schools 180786001339 4857 Fayetteville Elementary School   Regular School No Elementary KG 05 2020   grade_5                         10.0 25.0                       35.0                         10 25                 35
1914647 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001717 6258 Walnut Elementary School   Regular School No Elementary PK 05 2020   grade_5                         10.0 14.0                       24.0                         10 14                 24
1914831 IN     school 1807920 5945   North Newton School Corp 180792001361 6397 Morocco Elementary School   Regular School No Elementary KG 06 2020   grade_5                         10.0 14.0                       24.0                         10 14                 24
1915938 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001447 7341 Madison Elementary School   Regular School No Elementary KG 05 2020   grade_5                         10.0 7.0                       17.0                         10 7                 17
1910436 IN     school 1810360 3190   South Harrison Com Schools 181036000385 2663 Corydon Intermediate School   Regular School No Middle 04 06 2020   grade_5                         100.0 59.0                       159.0                         100 59                 159
1914674 IN     school 1802460 5855   Crawfordsville Community Schools 180246000292 6289 Mollie B Hoover Elementary School   Regular School No Elementary 04 05 2020   grade_5                         101.0 115.0                       216.0                         101 115                 216
1907488 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2020   grade_5                         102.0 92.0                       194.0                         102 92                 194
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
1911225 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No Middle 05 08 2020   grade_5                         103.0 80.0                       183.0                         103 80                 183
1913098 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002499 5203 Lillie Idella Kitley Elementary   Regular School No Elementary KG 05 2020   grade_5                         103.0 107.0                       210.0                         103 107                 210
1910634 IN     school 1808970 3330   Plainfield Community School Corp 180897002438 2748 Clarks Creek Elementary   Regular School No Elementary KG 05 2020   grade_5                         104.0 82.0                       186.0                         104 82                 186
1910887 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2020   grade_5                         104.0 89.0                       193.0                         104 89                 193
1911942 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2020   grade_5                         104.0 83.0                       187.0                         104 83                 187
1918024 IN     school 1811580 8565   Twin Lakes School Corp 181158001860 9163 Meadowlawn Elementary School   Regular School No Elementary KG 05 2020   grade_5                         106.0 89.0                       195.0                         106 89                 195
1918824 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2020   grade_5                         106.0 89.0                       195.0                         106 89                 195
1911143 IN     school 1805280 3785   Kankakee Valley School Corp 180528001412 3198 Kankakee Valley Intermediate Sch   Regular School No Elementary 04 05 2020   grade_5                         107.0 116.0                       223.0                         107 116                 223
1914952 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No Middle 05 08 2020   grade_5                         107.0 88.0                       195.0                         107 88                 195
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
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
1907723 IN     school 1800570 515   Blackford County Schools 180057000107 485 Montpelier School   Regular School No Elementary KG 06 2020   grade_5                         11.0 14.0                       25.0                         11 14                 25
1914713 IN     school 1803330 5910   Eminence Community School Corp 180333002274 6327 Eminence Elementary School   Regular School No Elementary PK 05 2020   grade_5                         11.0 9.0                       20.0                         11 9                 20
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
1916644 IN     school 1811100 7615   M S D Steuben County 181110001801 7905 Pleasant Lake Elementary School   Regular School No Elementary KG 05 2020   grade_5                         11.0 9.0                       20.0                         11 9                 20
1917031 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000475 8251 Lincoln School   Regular School No Elementary KG 08 2020   grade_5                         11.0 15.0                       26.0                         11 15                 26
1917171 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000476 8329 Lodge Community School   Regular School No Elementary KG 08 2020   grade_5                         11.0 18.0                       29.0                         11 18                 29
1917576 IN     school 1806080 8115   M S D Warren County 180608001072 8733 Pine Village Elementary School   Regular School No Elementary KG 06 2020   grade_5                         11.0 8.0                       19.0                         11 8                 19
1911978 IN     school 1805450 4615   Lake Central School Corporation 180545000982 3841 Kahler Middle School   Regular School No Middle 05 08 2020   grade_5                         110.0 106.0                       216.0                         110 106                 216
1911812 IN     school 1813110 4525   Westview School Corporation 181311002365 3702 Westview Elementary School   Regular School No Middle 05 06 2020   grade_5                         112.0 98.0                       210.0                         112 98                 210
1911959 IN     school 1805450 4615   Lake Central School Corporation 180545002420 3838 Hal E Clark Middle School   Regular School No Middle 05 08 2020   grade_5                         113.0 109.0                       222.0                         113 109                 222
1909412 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001276 1937 Nathaniel Scribner Middle School   Regular School No Middle 05 08 2020   grade_5                         118.0 130.0                       248.0                         118 130                 248
1913696 IN     school 1800450 5380   Beech Grove City Schools 180045000095 5461 South Grove Intermediate School   Regular School No Middle 04 06 2020   grade_5                         118.0 114.0                       232.0                         118 114                 232
1907699 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2020   grade_5                         12.0 8.0                       20.0                         12 8                 20
1908355 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000284 1045 West Crawford Elementary School   Regular School No Elementary PK 05 2020   grade_5                         12.0 21.0                       33.0                         12 21                 33
1908485 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000053 1141 Dillsboro Elementary School   Regular School No Elementary KG 06 2020   grade_5                         12.0 13.0                       25.0                         12 13                 25
1911604 IN     school 1812120 4335   Vincennes Community School Corp 181212001929 3573 James Whitcomb Riley Elem Sch   Regular School No Elementary KG 05 2020   grade_5                         12.0 14.0                       26.0                         12 14                 26
1913824 IN     school 1804770 5385   Indianapolis Public Schools 180477000867 5548 Louis B Russell Jr School 48   Regular School No Elementary PK 06 2020   grade_5                         12.0 20.0                       32.0                         12 20                 32
1914561 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000131 6213 Marlin Elementary School   Regular School No Elementary KG 06 2020   grade_5                         12.0 8.0                       20.0                         12 8                 20
1914822 IN     school 1807140 5930   Mooresville Con School Corp 180714001213 6393 Waverly Elementary School   Regular School No Elementary PK 06 2020   grade_5                         12.0 20.0                       32.0                         12 20                 32
1914839 IN     school 1807920 5945   North Newton School Corp 180792001359 6405 Lake Village Elementary School   Regular School No Elementary KG 06 2020   grade_5                         12.0 14.0                       26.0                         12 14                 26
1917112 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000467 8301 Glenwood Leadership Academy   Regular School No Elementary KG 08 2020   grade_5                         12.0 24.0                       36.0                         12 24                 36
1917826 IN     school 1809510 8385   Richmond Community Schools 180951001561 8997 Test Intermediate School   Regular School No Middle 05 08 2020   grade_5                         126.0 99.0                       225.0                         126 99                 225
1915677 IN     school 1811730 6795   Union School Corporation 181173002654 7122 Indiana Digital Elementary   Regular School No Elementary KG 06 2020   grade_5                         128.0 116.0                       244.0                         128 116                 244
1915231 IN     school 1802800 6470   Duneland School Corporation 180280000338 6927 Westchester Intermediate School   Regular School No Middle 05 06 2020   grade_5                         129.0 138.0                       267.0                         129 138                 267
1908249 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No Elementary PK 05 2020   grade_5                         13.0 19.0                       32.0                         13 19                 32
1908420 IN     school 1812450 1405   Washington Community Schools 181245002005 1105 Veale Elementary School   Regular School No Elementary KG 06 2020   grade_5                         13.0 9.0                       22.0                         13 9                 22
1908826 IN     school 1807320 1970   Muncie Community Schools 180732001243 1496 North View Elementary School   Regular School No Elementary KG 05 2020   grade_5                         13.0 17.0                       30.0                         13 17                 30
1909201 IN     school 1803270 2305   Elkhart Community Schools 180327000434 1769 Mary Beck Elementary School   Regular School No Elementary PK 06 2020   grade_5                         13.0 12.0                       25.0                         13 12                 25
1909355 IN     school 1803510 2395   Fayette County School Corporation 180351000503 1909 Frazee Elementary School   Regular School No Elementary KG 06 2020   grade_5                         13.0 18.0                       31.0                         13 18                 31
1910422 IN     school 1810360 3190   South Harrison Com Schools 181036001698 2649 New Middletown Elementary School   Regular School No Elementary KG 06 2020   grade_5                         13.0 4.0                       17.0                         13 4                 17
1910430 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elementary School   Regular School No Elementary PK 06 2020   grade_5                         13.0 4.0                       17.0                         13 4                 17
1910757 IN     school 1807440 3445   New Castle Community School Corp 180744002156 2832 Eastwood Elementary School   Regular School No Elementary PK 06 2020   grade_5                         13.0 22.0                       35.0                         13 22                 35
1915431 IN     school 1811970 6560   Valparaiso Community Schools 181197001882 6891 Central Elementary School   Regular School No Elementary KG 05 2020   grade_5                         13.0 12.0                       25.0                         13 12                 25
1917267 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001736 8431 Ernie Pyle Elementary School   Regular School No Elementary PK 05 2020   grade_5                         13.0 13.0                       26.0                         13 13                 26
1917568 IN     school 1806080 8115   M S D Warren County 180608001075 8729 Williamsport Elementary School   Regular School No Elementary KG 06 2020   grade_5                         13.0 11.0                       24.0                         13 11                 24
1918697 IN     school 1800123 9735   Inspire Academy - A Sch of Inquiry 180012302560 1518 Inspire Academy - A Sch of Inquiry   Regular School Yes Elementary KG 08 2020   grade_5                         13.0 8.0                       21.0                         13 8                 21
1918754 IN     school 1800083 9835   The Bloomington Project School 180008302446 6215 The Bloomington Project School   Regular School Yes Elementary KG 08 2020   grade_5                         13.0 14.0                       27.0                         13 14                 27
1918944 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2020   grade_5                         13.0 11.0                       24.0                         13 11                 24
1909407 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001271 1933 Hazelwood Middle School   Regular School No Middle 05 08 2020   grade_5                         130.0 96.0                       226.0                         130 96                 226
1908037 IN     school   940   West Clark Community Schools   789 Silver Creek Elementary School             2020   grade_5                         133.0 93.0                       226.0                         133 93                 226
1909962 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton SE Int and Jr High Sch   Regular School No Middle 05 08 2020   grade_5                         135.0 156.0                       291.0                         135 156                 291
1910245 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071002659 2543 New Palestine Intermediate School   Regular School No Middle 05 06 2020   grade_5                         138.0 136.0                       274.0                         138 136                 274
1908161 IN     school 1803940 1010   Greater Clark County Schools 180394000668 869 Maple Elementary School   Regular School No Elementary KG 05 2020   grade_5                         14.0 12.0                       26.0                         14 12                 26
1910774 IN     school 1807440 3445   New Castle Community School Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No Elementary KG 06 2020   grade_5                         14.0 23.0                       37.0                         14 23                 37
1911038 IN     school 1801230 3640   Medora Community School Corp 180123002268 3095 Medora Elementary School   Regular School No Elementary PK 06 2020   grade_5                         14.0 2.0                       16.0                         14 2                 16
1911186 IN     school 1804980 3945   Jay School Corporation 180498000917 3247 Redkey Elementary School   Regular School No Elementary KG 05 2020   grade_5                         14.0 18.0                       32.0                         14 18                 32
1915697 IN     school 1810740 6805   Randolph Southern School Corp 181074001762 7113 Randolph Southern Elementary Sch   Regular School No Elementary KG 06 2020   grade_5                         14.0 23.0                       37.0                         14 23                 37
1916309 IN     school 1810020 7255   Scott County School District 2 181002001609 7633 Johnson Elementary School   Regular School No Elementary PK 05 2020   grade_5                         14.0 19.0                       33.0                         14 19                 33
1918419 IN     school 1800148 9430   Tindley Summit Academy 180014802563 5629 Tindley Summit Academy   Regular School Yes Elementary KG 06 2020   grade_5                         14.0 16.0                       30.0                         14 16                 30
1909745 IN     school 1806390 2865   Marion Community Schools 180639001115 2350 Justice Thurgood Marshall Intrmd   Regular School No Middle 05 06 2020   grade_5                         141.0 132.0                       273.0                         141 132                 273
1914274 IN     school 1809060 5485   Plymouth Community School Corp 180906002211 5956 Riverside Intermediate   Regular School No Middle 05 06 2020   grade_5                         142.0 124.0                       266.0                         142 124                 266
1907768 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2020   grade_5                         145.0 138.0                       283.0                         145 138                 283
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
1908636 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000226 1341 Waterloo Elementary School   Regular School No Elementary PK 05 2020   grade_5                         15.0 15.0                       30.0                         15 15                 30
1909331 IN     school 1803510 2395   Fayette County School Corporation 180351000500 1869 Everton Elementary School   Regular School No Elementary KG 06 2020   grade_5                         15.0 19.0                       34.0                         15 19                 34
1911179 IN     school 1804980 3945   Jay School Corporation 180498000910 3241 Bloomfield Elementary School   Regular School No Elementary KG 05 2020   grade_5                         15.0 16.0                       31.0                         15 16                 31
1911760 IN     school 1813230 4455   Whitko Community School Corp 181323002084 3642 Pierceton Elementary School   Regular School No Elementary PK 06 2020   grade_5                         15.0 34.0                       49.0                         15 34                 49
1912571 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2020   grade_5                         15.0 9.0                       24.0                         15 9                 24
1913944 IN     school 1804770 5385   Indianapolis Public Schools 180477000893 5574 Theodore Potter School 74   Regular School No Elementary KG 06 2020   grade_5                         15.0 18.0                       33.0                         15 18                 33
1913976 IN     school 1804770 5385   Indianapolis Public Schools 180477000829 5583 Floro Torrence School 83   Regular School No Elementary PK 06 2020   grade_5                         15.0 18.0                       33.0                         15 18                 33
1914063 IN     school 1804770 5385   Indianapolis Public Schools 180477000887 5606 Robert Lee Frost School 106   Regular School No Elementary PK 06 2020   grade_5                         15.0 25.0                       40.0                         15 25                 40
1914634 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001714 6233 Ladoga Elementary School   Regular School No Elementary PK 05 2020   grade_5                         15.0 16.0                       31.0                         15 16                 31
1915424 IN     school 1811970 6560   Valparaiso Community Schools 181197001889 6888 Thomas Jefferson Elementary School   Regular School No Elementary KG 05 2020   grade_5                         15.0 16.0                       31.0                         15 16                 31
1916470 IN     school 1808010 7385   North Spencer County Sch Corp 180801001375 7753 David Turnham Education Center   Regular School No Elementary PK 06 2020   grade_5                         15.0 21.0                       36.0                         15 21                 36
1916530 IN     school 1808460 7495   Oregon-Davis School Corp 180846002209 7818 Oregon-Davis Elementary School   Regular School No Elementary KG 06 2020   grade_5                         15.0 16.0                       31.0                         15 16                 31
1916658 IN     school 1808160 7645   Northeast School Corp 180816001400 7921 Northeast North Elementary School   Regular School No Elementary KG 06 2020   grade_5                         15.0 22.0                       37.0                         15 22                 37
1907774 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No Middle 05 08 2020   grade_5                         155.0 136.0                       291.0                         155 136                 291
1913405 IN     school 1812360 5360   M S D Warren Township 181236001961 5364 Creston Intermediate & Middle Schl   Regular School No Middle 05 08 2020   grade_5                         155.0 159.0                       314.0                         155 159                 314
1913415 IN     school 1812360 5360   M S D Warren Township 181236000229 5368 Raymond Park Intermediate & Middle   Regular School No Middle 05 08 2020   grade_5                         156.0 139.0                       295.0                         156 139                 295
1913410 IN     school 1812360 5360   M S D Warren Township 181236001970 5367 Stonybrook Intermediate & Middle   Regular School No Middle 05 08 2020   grade_5                         159.0 109.0                       268.0                         159 109                 268
1908176 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No Elementary PK 05 2020   grade_5                         16.0 11.0                       27.0                         16 11                 27
1908226 IN     school 1800840 1125   Clay Community Schools 180084000162 907 Staunton Elementary School   Regular School No Elementary KG 05 2020   grade_5                         16.0 30.0                       46.0                         16 30                 46

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