Data source: Big Local News · About: Big Local

959 rows where grade = "grade_5", state = "IN" and year = 2018 sorted by male

View and edit SQL

year

  • 2018 · 959

grade

  • grade_5 · 959
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
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
1792522 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No Elementary KG 08 2018   grade_5                         0.0 51.0                       51.0                         0 51                 51
1788499 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 05 12 2018   grade_5                         1.0 0.0                       1.0                         1 0                 1
1789355 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Other 04 11 2018   grade_5                         1.0 0.0                       1.0                         1 0                 1
1789382 IN     school 1806600 2275   Middlebury Community Schools 180660000199 1734 Orchard View School   Regular School No Elementary KG 05 2018   grade_5                         1.0 0.0                       1.0                         1 0                 1
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
1791840 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001306 3409 Indian Creek Elementary School   Regular School No Elementary PK 05 2018   grade_5                         1.0 0.0                       1.0                         1 0                 1
1792124 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2018   grade_5                         1.0 2.0                       3.0                         1 2                 3
1794656 IN     school 1809060 5485   Plymouth Community School Corp 180906001503 5933 Menominee Elementary School   Regular School No Elementary KG 05 2018   grade_5                         1.0 0.0                       1.0                         1 0                 1
1798669 IN     school 1800145 9425   Tindley Genesis Academy 180014502595 5621 Tindley Genesis Academy   Regular School Yes Elementary KG 05 2018   grade_5                         10.0 8.0                       18.0                         10 8                 18
1798966 IN     school 1800123 9735   Inspire Academy - A Sch of Inquiry 180012302560 1518 Inspire Academy - A Sch of Inquiry   Regular School Yes Elementary KG 08 2018   grade_5                         10.0 8.0                       18.0                         10 8                 18
1799078 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes Elementary KG 08 2018   grade_5                         10.0 11.0                       21.0                         10 11                 21
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
1794846 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001708 6153 Edgewood Intermediate School   Regular School No Elementary 03 05 2018   grade_5                         103.0 91.0                       194.0                         103 91                 194
1795367 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No Middle 05 08 2018   grade_5                         103.0 91.0                       194.0                         103 91                 194
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
1793471 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002499 5203 Lillie Idella Kitley Elementary   Regular School No Elementary PK 05 2018   grade_5                         104.0 88.0                       192.0                         104 88                 192
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
1792258 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2018   grade_5                         105.0 111.0                       216.0                         105 111                 216
1791543 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No Middle 03 08 2018   grade_5                         107.0 71.0                       178.0                         107 71                 178
1794057 IN     school 1800450 5380   Beech Grove City Schools 180045000095 5461 South Grove Intermediate School   Regular School No Middle 04 06 2018   grade_5                         109.0 128.0                       237.0                         109 128                 237
1790729 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elementary School   Regular School No Elementary PK 06 2018   grade_5                         11.0 11.0                       22.0                         11 11                 22
1793131 IN     school 1807860 5075   North Lawrence Com Schools 180786001340 4873 Heltonville Elementary School   Regular School No Elementary KG 05 2018   grade_5                         11.0 7.0                       18.0                         11 7                 18
1794258 IN     school 1804770 5385   Indianapolis Public Schools 180477000841 5557 George W Julian School 57   Regular School No Elementary KG 07 2018   grade_5                         11.0 5.0                       16.0                         11 5                 16
1794296 IN     school 1804770 5385   Indianapolis Public Schools 180477000884 5565 Raymond F Brandes School 65   Regular School No Elementary PK 06 2018   grade_5                         11.0 15.0                       26.0                         11 15                 26
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
1796237 IN     school 1809750 6995   Rush County Schools 180975001594 7233 Milroy Elementary School   Regular School No Elementary KG 06 2018   grade_5                         11.0 13.0                       24.0                         11 13                 24
1797934 IN     school 1806080 8115   M S D Warren County 180608001075 8729 Williamsport Elementary School   Regular School No Elementary KG 06 2018   grade_5                         11.0 19.0                       30.0                         11 19                 30
1798727 IN     school 1800158 9490   Indiana College Preparatory School 180015802594 5441 Indiana College Preparatory School   Regular School Yes Elementary KG 08 2018   grade_5                         11.0 13.0                       24.0                         11 13                 24
1798976 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes Elementary KG 08 2018   grade_5                         11.0 3.0                       14.0                         11 3                 14
1787781 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2018   grade_5                         111.0 92.0                       203.0                         111 92                 203
1790051 IN     school 1806870 2855   Mississinewa Community School Corp 180687001191 2346 Northview Elementary School   Regular School No Elementary 02 05 2018   grade_5                         112.0 88.0                       200.0                         112 88                 200
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
1788007 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2018   grade_5                         12.0 6.0                       18.0                         12 6                 18
1788480 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No Elementary PK 05 2018   grade_5                         12.0 12.0                       24.0                         12 12                 24
1788811 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000055 1169 Moores Hill Elementary School   Regular School No Elementary KG 06 2018   grade_5                         12.0 9.0                       21.0                         12 9                 21
1789214 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001776 1529 Holland Elementary School   Regular School No Elementary KG 05 2018   grade_5                         12.0 11.0                       23.0                         12 11                 23
1791346 IN     school 1810080 3675   Seymour Community Schools 181008001615 3105 Cortland Elementary School   Regular School No Elementary KG 05 2018   grade_5                         12.0 14.0                       26.0                         12 14                 26
1791507 IN     school 1804980 3945   Jay School Corporation 180498000915 3277 Judge Haynes Elementary School   Regular School No Elementary KG 05 2018   grade_5                         12.0 17.0                       29.0                         12 17                 29
1793044 IN     school 1805580 4945   LaPorte Community School Corp 180558001014 4721 Kingsford Heights Elementary Sch   Regular School No Elementary PK 05 2018   grade_5                         12.0 12.0                       24.0                         12 12                 24
1794238 IN     school 1804770 5385   Indianapolis Public Schools 180477000822 5555 IPS/ Butler Eliza Blaker School 55   Regular School No Elementary PK 06 2018   grade_5                         12.0 3.0                       15.0                         12 3                 15
1794948 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000127 6197 Fairview Elementary School   Regular School No Elementary PK 06 2018   grade_5                         12.0 16.0                       28.0                         12 16                 28
1795113 IN     school 1803330 5910   Eminence Community School Corp 180333002274 6327 Eminence Elementary School   Regular School No Elementary PK 05 2018   grade_5                         12.0 15.0                       27.0                         12 15                 27
1795235 IN     school 1807920 5945   North Newton School Corp 180792001361 6397 Morocco Elementary School   Regular School No Elementary KG 06 2018   grade_5                         12.0 15.0                       27.0                         12 15                 27
1795445 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001792 6601 Patricksburg Elementary School   Regular School No Elementary KG 06 2018   grade_5                         12.0 13.0                       25.0                         12 13                 25
1797011 IN     school 1804230 7610   Hamilton Community Schools 180423000723 7889 Hamilton Community Elementary Sch   Regular School No Elementary KG 06 2018   grade_5                         12.0 13.0                       25.0                         12 13                 25
1797430 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000475 8251 Lincoln School   Regular School No Elementary KG 08 2018   grade_5                         12.0 13.0                       25.0                         12 13                 25
1798707 IN     school 1800043 9465   Rural Community Schools Inc 180004302138 7951 Rural Community Academy   Regular School Yes Elementary KG 08 2018   grade_5                         12.0 8.0                       20.0                         12 8                 20
1799287 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   grade_5                         12.0 11.0                       23.0                         12 11                 23
1795650 IN     school 1802800 6470   Duneland School Corporation 180280000338 6927 Westchester Intermediate School   Regular School No Middle 05 06 2018   grade_5                         121.0 130.0                       251.0                         121 130                 251
1788078 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2018   grade_5                         126.0 135.0                       261.0                         126 135                 261
1792294 IN     school 1805450 4615   Lake Central School Corporation 180545000982 3841 Kahler Middle School   Regular School No Middle 05 08 2018   grade_5                         127.0 119.0                       246.0                         127 119                 246
1788577 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elementary School   Regular School No Elementary PK 05 2018   grade_5                         13.0 18.0                       31.0                         13 18                 31
1792927 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2018   grade_5                         13.0 17.0                       30.0                         13 17                 30
1795046 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001717 6258 Walnut Elementary School   Regular School No Elementary PK 06 2018   grade_5                         13.0 11.0                       24.0                         13 11                 24
1796022 IN     school 1807980 6715   North Putnam Community Schools 180798001371 7045 Roachdale Elementary School   Regular School No Elementary KG 05 2018   grade_5                         13.0 20.0                       33.0                         13 20                 33
1796433 IN     school 1806840 7200   School City of Mishawaka 180684001174 7469 Battell Elementary School   Regular School No Elementary KG 06 2018   grade_5                         13.0 18.0                       31.0                         13 18                 31
1797082 IN     school 1810860 7715   Southwest School Corporation 181086001770 7953 Carlisle Elementary School   Regular School No Elementary PK 05 2018   grade_5                         13.0 6.0                       19.0                         13 6                 19
1798613 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2018   grade_5                         13.0 9.0                       22.0                         13 9                 22
1789717 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001271 1933 Hazelwood Middle School   Regular School No Middle 05 08 2018   grade_5                         131.0 133.0                       264.0                         131 133                 264
1791448 IN     school 1805280 3785   Kankakee Valley School Corp 180528001412 3198 Kankakee Valley Intermediate Sch   Regular School No Elementary 04 05 2018   grade_5                         131.0 134.0                       265.0                         131 134                 265
1788658 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000281 1037 South Crawford Elementary School   Regular School No Elementary PK 05 2018   grade_5                         14.0 13.0                       27.0                         14 13                 27
1791253 IN     school 1805370 3500   Kokomo School Corporation 180537000960 3005 Wallace Elementary School   Regular School No Elementary KG 05 2018   grade_5                         14.0 44.0                       58.0                         14 44                 58
1791525 IN     school 1804980 3945   Jay School Corporation 180498000919 3289 Westlawn Elementary School   Regular School No Elementary KG 05 2018   grade_5                         14.0 16.0                       30.0                         14 16                 30
1792152 IN     school 1805520 4535   Lakeland School Corporation 180552001000 3741 Wolcott Mills Elementary School   Regular School No Elementary KG 05 2018   grade_5                         14.0 18.0                       32.0                         14 18                 32
1796335 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001447 7341 Madison Elementary School   Regular School No Elementary KG 05 2018   grade_5                         14.0 14.0                       28.0                         14 14                 28
1796937 IN     school 1808460 7495   Oregon-Davis School Corp 180846002209 7818 Oregon-Davis Elementary School   Regular School No Elementary KG 06 2018   grade_5                         14.0 16.0                       30.0                         14 16                 30
1797051 IN     school 1811100 7615   M S D Steuben County 181110001801 7905 Pleasant Lake Elementary School   Regular School No Elementary KG 05 2018   grade_5                         14.0 8.0                       22.0                         14 8                 22
1797756 IN     school 1812090 8030   Vigo County School Corp 181209001905 8521 Fayette Elementary School   Regular School No Elementary KG 05 2018   grade_5                         14.0 25.0                       39.0                         14 25                 39
1798676 IN     school 1800148 9430   Tindley Summit Academy 180014802563 5629 Tindley Summit Academy   Regular School Yes Elementary KG 05 2018   grade_5                         14.0 17.0                       31.0                         14 17                 31
1792275 IN     school 1805450 4615   Lake Central School Corporation 180545002420 3838 Hal E Clark Middle School   Regular School No Middle 05 08 2018   grade_5                         142.0 121.0                       263.0                         142 121                 263
1794669 IN     school 1809060 5485   Plymouth Community School Corp 180906002211 5956 Riverside Intermediate   Regular School No Middle 05 06 2018   grade_5                         143.0 127.0                       270.0                         143 127                 270
1788084 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No Middle 05 08 2018   grade_5                         145.0 141.0                       286.0                         145 141                 286
1787400 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2018   grade_5                         15.0 17.0                       32.0                         15 17                 32
1788730 IN     school 1812450 1405   Washington Community Schools 181245002005 1105 Veale Elementary School   Regular School No Elementary KG 06 2018   grade_5                         15.0 16.0                       31.0                         15 16                 31
1790163 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2018   grade_5                         15.0 32.0                       47.0                         15 32                 47
1791307 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000789 3075 Northwest Elementary School   Regular School No Elementary KG 05 2018   grade_5                         15.0 19.0                       34.0                         15 19                 34
1791489 IN     school 1804980 3945   Jay School Corporation 180498000917 3247 Redkey Elementary School   Regular School No Elementary KG 05 2018   grade_5                         15.0 15.0                       30.0                         15 15                 30
1791908 IN     school 1812120 4335   Vincennes Community School Corp 181212001929 3573 James Whitcomb Riley Elem Sch   Regular School No Elementary KG 05 2018   grade_5                         15.0 23.0                       38.0                         15 23                 38
1792659 IN     school 1804320 4710   School City of Hammond 180432000733 4447 Columbia Elementary School   Regular School No Elementary KG 05 2018   grade_5                         15.0 33.0                       48.0                         15 33                 48
1796723 IN     school 1810020 7255   Scott County School District 2 181002001610 7637 Lexington Elementary School   Regular School No Elementary KG 05 2018   grade_5                         15.0 21.0                       36.0                         15 21                 36
1796885 IN     school 1808010 7385   North Spencer County Sch Corp 180801000167 7755 Nancy Hanks Elementary School   Regular School No Elementary PK 06 2018   grade_5                         15.0 15.0                       30.0                         15 15                 30
1797999 IN     school 1812390 8130   Warrick County School Corp 181239001983 8773 Lynnville Elementary School   Regular School No Elementary KG 05 2018   grade_5                         15.0 12.0                       27.0                         15 12                 27
1790261 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton SE Int and Jr High Sch   Regular School No Middle 05 08 2018   grade_5                         152.0 137.0                       289.0                         152 137                 289
1793840 IN     school 1812360 5360   M S D Warren Township 181236002490 5399 Creston Intermediate Academy   Regular School No Middle 05 06 2018   grade_5                         152.0 130.0                       282.0                         152 130                 282
1788464 IN     school 1803940 1010   Greater Clark County Schools 180394000668 869 Maple Elementary School   Regular School No Elementary PK 05 2018   grade_5                         16.0 15.0                       31.0                         16 15                 31
1788795 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000053 1141 Dillsboro Elementary School   Regular School No Elementary KG 06 2018   grade_5                         16.0 12.0                       28.0                         16 12                 28
1789953 IN     school 1810350 2765   South Gibson School Corporation 181035001689 2205 Haubstadt Community School   Regular School No Elementary KG 08 2018   grade_5                         16.0 7.0                       23.0                         16 7                 23
1790030 IN     school 1806240 2825   Madison-Grant United School Corp 180624001100 5037 Summitville School   Regular School No Elementary PK 06 2018   grade_5                         16.0 23.0                       39.0                         16 23                 39
1791058 IN     school 1807440 3445   New Castle Community School Corp 180744002157 2847 Parker Elementary School   Regular School No Elementary KG 06 2018   grade_5                         16.0 24.0                       40.0                         16 24                 40
1791613 IN     school 1805190 4015   Jennings County School Corporation 180519000921 3361 Graham Creek Elementary School   Regular School No Elementary KG 06 2018   grade_5                         16.0 22.0                       38.0                         16 22                 38
1793110 IN     school 1807860 5075   North Lawrence Com Schools 180786001339 4857 Fayetteville Elementary School   Regular School No Elementary KG 05 2018   grade_5                         16.0 19.0                       35.0                         16 19                 35
1795202 IN     school 1807140 5930   Mooresville Con School Corp 180714001209 6381 Newby Memorial Elementary School   Regular School No Elementary KG 06 2018   grade_5                         16.0 26.0                       42.0                         16 26                 42
1795243 IN     school 1807920 5945   North Newton School Corp 180792001359 6405 Lake Village Elementary School   Regular School No Elementary KG 06 2018   grade_5                         16.0 19.0                       35.0                         16 19                 35
1796867 IN     school 1808010 7385   North Spencer County Sch Corp 180801001373 7751 Chrisney Elementary School   Regular School No Elementary PK 06 2018   grade_5                         16.0 17.0                       33.0                         16 17                 33
1797836 IN     school 1812090 8030   Vigo County School Corp 181209001922 8609 West Vigo Elementary School   Regular School No Elementary PK 05 2018   grade_5                         16.0 18.0                       34.0                         16 18                 34
1798625 IN     school 1800137 9365   Enlace Academy 180013702551 5667 Enlace Academy   Regular School Yes Elementary KG 07 2018   grade_5                         16.0 19.0                       35.0                         16 19                 35
1798653 IN     school 1800149 9395   Christel House Academy West 180014902568 5871 Christel House Academy West   Regular School Yes Elementary KG 05 2018   grade_5                         16.0 25.0                       41.0                         16 25                 41
1799206 IN     school 1800124 9925   Phalen Leadership Academy - IN Inc 180012402550 5496 Phalen Leadership Academy - IN Inc   Regular School Yes Elementary KG 06 2018   grade_5                         16.0 9.0                       25.0                         16 9                 25
1793843 IN     school 1812360 5360   M S D Warren Township 181236002477 5401 Stonybrook Intermediate Academy   Regular School No Middle 05 06 2018   grade_5                         161.0 149.0                       310.0                         161 149                 310

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