enrollments

Data source: Big Local News · About: Big Local

1,060 rows where grade = "grade_2", state = "IN" and year = 2015 sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 1,060 ✖

grade ✖

  • grade_2 · 1,060 ✖
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
1164749 1164749 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No 1.0 KG 07 2015   grade_2                         0.0 69.0                       69.0                         0 69                 69
1169095 1169095 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_2                         0.0 1.0                       1.0                         0 1                 1
1169729 1169729 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 KG 12 2015   grade_2                         1.0 2.0                       3.0                         1 2                 3
1162368 1162368 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         10.0 17.0                       27.0                         10 17                 27
1167284 1167284 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001714 6233 Ladoga Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         10.0 19.0                       29.0                         10 19                 29
1167707 1167707 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001787 6605 Gosport Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         10.0 13.0                       23.0                         10 13                 23
1170915 1170915 IN     school 1800149 9395   Christel House Academy West 180014902568 5871 Christel House Academy West   Regular School Yes 1.0 KG 02 2015   grade_2                         10.0 19.0                       29.0                         10 19                 29
1171071 1171071 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_2                         10.0 11.0                       21.0                         10 11                 21
1167012 1167012 IN     school 1806090 5615   Maconaquah School Corp 180609001077 6035 Maconaquah Elementary School   Regular School No 1.0 02 05 2015   grade_2                         100.0 88.0                       188.0                         100 88                 188
1167099 1167099 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001707 6151 Edgewood Primary School   Regular School No 1.0 KG 02 2015   grade_2                         100.0 87.0                       187.0                         100 87                 187
1162253 1162253 IN     school 1806870 2855   Mississinewa Community School Corp 180687001191 2346 Northview Elementary School   Regular School No 1.0 02 05 2015   grade_2                         101.0 95.0                       196.0                         101 95                 196
1160514 1160514 IN     school 1809370 940   West Clark Community Schools 180937001538 789 Silver Creek Elementary School   Regular School No 1.0 02 05 2015   grade_2                         103.0 100.0                       203.0                         103 100                 203
1163391 1163391 IN     school 1804470 3490   Western School Corp 180447000755 2935 Western Primary School   Regular School No 1.0 KG 02 2015   grade_2                         103.0 91.0                       194.0                         103 91                 194
1171373 1171373 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes 4.0 KG 12 2015   grade_2                         103.0 96.0                       199.0                         103 96                 199
1167629 1167629 IN     school 1812900 6065   West Noble School Corporation 181290002231 6510 West Noble Elementary School   Regular School No 1.0 02 04 2015   grade_2                         105.0 93.0                       198.0                         105 93                 198
1160188 1160188 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         11.0 8.0                       19.0                         11 8                 19
1161380 1161380 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001388 1543 Celestine Elementary School   Regular School No 1.0 KG 04 2015   grade_2                         11.0 10.0                       21.0                         11 10                 21
1167362 1167362 IN     school 1803330 5910   Eminence Community School Corp 180333002274 6327 Eminence Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         11.0 11.0                       22.0                         11 11                 22
1167432 1167432 IN     school 1806510 5925   M S D Martinsville Schools 180651001130 6367 Central Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         11.0 16.0                       27.0                         11 16                 27
1168257 1168257 IN     school 1810500 6705   South Putnam Community Schools 181050001724 7057 Fillmore Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         11.0 7.0                       18.0                         11 7                 18
1170264 1170264 IN     school 1812390 8130   Warrick County School Corp 181239001983 8773 Lynnville Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         11.0 11.0                       22.0                         11 11                 22
1170285 1170285 IN     school 1812390 8130   Warrick County School Corp 181239001987 8785 Tennyson Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         11.0 6.0                       17.0                         11 6                 17
1165703 1165703 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002499 5203 Lillie Idella Kitley Elementary   Regular School No 1.0 PK 05 2015   grade_2                         114.0 102.0                       216.0                         114 102                 216
1160528 1160528 IN     school 1809370 940   West Clark Community Schools 180937001539 815 William W Borden Elem Sch   Regular School No 1.0 PK 06 2015   grade_2                         12.0 31.0                       43.0                         12 31                 43
1160846 1160846 IN     school 1802440 1300   Crawford Co Com School Corp 180244000284 1045 Patoka Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         12.0 10.0                       22.0                         12 10                 22
1163682 1163682 IN     school 1804980 3945   Jay School Corp 180498000917 3247 Redkey Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         12.0 12.0                       24.0                         12 12                 24
1163956 1163956 IN     school 1803690 4225   Franklin Community School Corp 180369000585 3433 Union Elementary School   Regular School No 1.0 KG 04 2015   grade_2                         12.0 17.0                       29.0                         12 17                 29
1166490 1166490 IN     school 1804770 5385   Indianapolis Public Schools 180477000822 5555 Eliza A Blaker School 55   Regular School No 1.0 PK 06 2015   grade_2                         12.0 6.0                       18.0                         12 6                 18
1167780 1167780 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elem & High School   Regular School No 4.0 PK 12 2015   grade_2                         12.0 10.0                       22.0                         12 10                 22
1168602 1168602 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001447 7341 Madison Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         12.0 17.0                       29.0                         12 17                 29
1169692 1169692 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000475 8251 Lincoln School   Regular School No 1.0 KG 08 2015   grade_2                         12.0 21.0                       33.0                         12 21                 33
1169915 1169915 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001736 8431 Ernie Pyle Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         12.0 18.0                       30.0                         12 18                 30
1170019 1170019 IN     school 1812090 8030   Vigo County School Corp 181209001905 8521 Fayette Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         12.0 24.0                       36.0                         12 24                 36
1170872 1170872 IN     school 1800137 9365   Enlace Academy 180013702551 5667 Enlace Academy   Regular School Yes 1.0 KG 04 2015   grade_2                         12.0 19.0                       31.0                         12 19                 31
1171188 1171188 IN     school 1800092 9715   Andrew Academy 180009202493 5785 Andrew Academy   Regular School Yes 1.0 KG 08 2015   grade_2                         12.0 15.0                       27.0                         12 15                 27
1166285 1166285 IN     school 1800450 5380   Beech Grove City Schools 180045000094 5457 Central Elementary School   Regular School No 1.0 02 03 2015   grade_2                         124.0 119.0                       243.0                         124 119                 243
1160855 1160855 IN     school 1802440 1300   Crawford Co Com School Corp 180244000280 1057 English School   Regular School No 1.0 PK 06 2015   grade_2                         13.0 9.0                       22.0                         13 9                 22
1160930 1160930 IN     school 1812450 1405   Washington Com Schools 181245002005 1105 Veale Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         13.0 12.0                       25.0                         13 12                 25
1162928 1162928 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elem School   Regular School No 1.0 PK 06 2015   grade_2                         13.0 13.0                       26.0                         13 13                 26
1163546 1163546 IN     school 1810080 3675   Seymour Community Schools 181008001615 3105 Cortland Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         13.0 12.0                       25.0                         13 12                 25
1165172 1165172 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No 1.0 KG 08 2015   grade_2                         13.0 18.0                       31.0                         13 18                 31
1166542 1166542 IN     school 1804770 5385   Indianapolis Public Schools 180477000884 5565 Raymond F Brandes School 65   Regular School No 1.0 PK 06 2015   grade_2                         13.0 17.0                       30.0                         13 17                 30
1167107 1167107 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000136 6123 Unionville Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         13.0 16.0                       29.0                         13 16                 29
1167699 1167699 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001792 6601 Patricksburg Elementary Sch   Regular School No 1.0 KG 06 2015   grade_2                         13.0 10.0                       23.0                         13 10                 23
1168497 1168497 IN     school 1809750 6995   Rush County Schools 180975001594 7233 Milroy Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         13.0 16.0                       29.0                         13 16                 29
1159572 1159572 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No 1.0 KG 05 2015   grade_2                         14.0 18.0                       32.0                         14 18                 32
1161428 1161428 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001776 1529 Holland Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         14.0 12.0                       26.0                         14 12                 26
1163718 1163718 IN     school 1804980 3945   Jay School Corp 180498000911 3287 East Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         14.0 23.0                       37.0                         14 23                 37
1163732 1163732 IN     school 1806120 3995   Madison Consolidated Schools 180612001085 3301 Deputy Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         14.0 11.0                       25.0                         14 11                 25
1167080 1167080 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001549 6117 Stinesville Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         14.0 11.0                       25.0                         14 11                 25
1167389 1167389 IN     school 1806510 5925   M S D Martinsville Schools 180651001128 6337 Brooklyn Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         14.0 15.0                       29.0                         14 15                 29
1167840 1167840 IN     school 1808900 6445   Pike County School Corp 180890001480 6759 Otwell Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         14.0 17.0                       31.0                         14 17                 31
1168696 1168696 IN     school 1806840 7200   School City of Mishawaka 180684001174 7469 Battell Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         14.0 17.0                       31.0                         14 17                 31
1170899 1170899 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2015   grade_2                         14.0 39.0                       53.0                         14 39                 53
1163248 1163248 IN     school 1807440 3445   New Castle Community Sch Corp 180744002156 2832 Eastwood Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         15.0 10.0                       25.0                         15 10                 25
1163453 1163453 IN     school 1805370 3500   Kokomo School Corporation 180537000960 3005 Wallace Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         15.0 50.0                       65.0                         15 50                 65
1164699 1164699 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No 1.0 01 06 2015   grade_2                         15.0 33.0                       48.0                         15 33                 48
1166332 1166332 IN     school 1804770 5385   Indianapolis Public Schools 180477000814 5498 Cold Spring School   Regular School No 1.0 KG 06 2015   grade_2                         15.0 26.0                       41.0                         15 26                 41
1168988 1168988 IN     school 1810020 7255   Scott County School District 2 181002001609 7633 Johnson Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         15.0 24.0                       39.0                         15 24                 39
1169035 1169035 IN     school 1803210 7285   Shelby Eastern Schools 180321000417 7663 Morristown Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         15.0 19.0                       34.0                         15 19                 34
1170595 1170595 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No 1.0 KG 06 2015   grade_2                         15.0 33.0                       48.0                         15 33                 48
1160881 1160881 IN     school 1802440 1300   Crawford Co Com School Corp 180244000283 1065 Milltown School   Regular School No 1.0 PK 06 2015   grade_2                         16.0 15.0                       31.0                         16 15                 31
1160995 1160995 IN     school 1800240 1600   South Dearborn Com School Corp 180024000053 1141 Dillsboro Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         16.0 10.0                       26.0                         16 10                 26
1161341 1161341 IN     school 1807320 1970   Muncie Community Schools 180732001243 1496 North View Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         16.0 25.0                       41.0                         16 25                 41
1161362 1161362 IN     school 1807320 1970   Muncie Community Schools 180732001251 1517 West View Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         16.0 22.0                       38.0                         16 22                 38
1162919 1162919 IN     school 1810360 3190   South Harrison Com Schools 181036001698 2649 New Middletown Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         16.0 5.0                       21.0                         16 5                 21
1164900 1164900 IN     school 1804320 4710   School City of Hammond 180432000733 4447 Columbia Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         16.0 27.0                       43.0                         16 27                 43
1166783 1166783 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry III   Regular School No 1.0 PK 08 2015   grade_2                         16.0 24.0                       40.0                         16 24                 40
1166849 1166849 IN     school 1810920 5400   School Town of Speedway 181092001780 5901 Arthur C Newby Elem School 2   Regular School No 1.0 KG 06 2015   grade_2                         16.0 13.0                       29.0                         16 13                 29
1167297 1167297 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001717 6258 Walnut Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         16.0 16.0                       32.0                         16 16                 32
1167496 1167496 IN     school 1807920 5945   North Newton School Corp 180792001359 6405 Lake Village Elementary Sch   Regular School No 1.0 KG 06 2015   grade_2                         16.0 19.0                       35.0                         16 19                 35
1168932 1168932 IN     school 1810290 7205   South Bend Community Sch Corp 181029001678 7613 Perley Fine Arts Academy   Regular School No 1.0 KG 04 2015   grade_2                         16.0 24.0                       40.0                         16 24                 40
1169140 1169140 IN     school 1808010 7385   North Spencer County Sch Corp 180801001373 7751 Chrisney Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         16.0 14.0                       30.0                         16 14                 30
1169158 1169158 IN     school 1808010 7385   North Spencer County Sch Corp 180801000167 7755 Nancy Hanks Elementary Sch   Regular School No 1.0 PK 06 2015   grade_2                         16.0 16.0                       32.0                         16 16                 32
1169932 1169932 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001741 8435 Van Duyn Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         16.0 16.0                       32.0                         16 16                 32
1160211 1160211 IN     school 1800570 515   Blackford County Schools 180057000107 485 Montpelier School   Regular School No 1.0 KG 06 2015   grade_2                         17.0 14.0                       31.0                         17 14                 31
1160588 1160588 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   grade_2                         17.0 24.0                       41.0                         17 24                 41
1162155 1162155 IN     school 1810350 2765   South Gibson School Corp 181035001689 2205 Haubstadt Community School   Regular School No 1.0 KG 08 2015   grade_2                         17.0 9.0                       26.0                         17 9                 26
1163707 1163707 IN     school 1804980 3945   Jay School Corp 180498000915 3277 Judge Haynes Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         17.0 17.0                       34.0                         17 17                 34
1163811 1163811 IN     school 1805190 4015   Jennings County Schools 180519000921 3361 Graham Creek Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         17.0 18.0                       35.0                         17 18                 35
1165288 1165288 IN     school 1805580 4945   LaPorte Community School Corp 180558001014 4721 Kingsford Heights Elem Sch   Regular School No 1.0 PK 05 2015   grade_2                         17.0 10.0                       27.0                         17 10                 27
1165361 1165361 IN     school 1807860 5075   North Lawrence Com Schools 180786001342 4865 Needmore Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         17.0 13.0                       30.0                         17 13                 30
1167824 1167824 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801857 6647 Turkey Run Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         17.0 13.0                       30.0                         17 13                 30
1168356 1168356 IN     school 1810740 6805   Randolph Southern School Corp 181074001762 7113 Randolph Southern Elem Sch   Regular School No 1.0 KG 06 2015   grade_2                         17.0 20.0                       37.0                         17 20                 37
1168996 1168996 IN     school 1810020 7255   Scott County School District 2 181002001610 7637 Lexington Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         17.0 22.0                       39.0                         17 22                 39
1171170 1171170 IN     school 1800065 9690   Renaissance Academy Charter School 180006502415 4711 Renaissance Academy Charter Schl   Regular School Yes 1.0 KG 08 2015   grade_2                         17.0 5.0                       22.0                         17 5                 22
1160837 1160837 IN     school 1802440 1300   Crawford Co Com School Corp 180244000281 1037 Leavenworth Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         18.0 14.0                       32.0                         18 14                 32
1161003 1161003 IN     school 1800240 1600   South Dearborn Com School Corp 180024000054 1165 Manchester Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         18.0 21.0                       39.0                         18 21                 39
1161856 1161856 IN     school 1803510 2395   Fayette County School Corp 180351000499 1897 Eastview Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         18.0 15.0                       33.0                         18 15                 33
1163281 1163281 IN     school 1807440 3445   New Castle Community Sch Corp 180744001291 2861 Westwood Elementary School   Regular School No 1.0 01 06 2015   grade_2                         18.0 25.0                       43.0                         18 25                 43
1163466 1163466 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000782 3021 Andrews Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         18.0 33.0                       51.0                         18 33                 51
1163819 1163819 IN     school 1805190 4015   Jennings County Schools 180519000922 3385 Hayden Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         18.0 16.0                       34.0                         18 16                 34
1164946 1164946 IN     school 1804320 4710   School City of Hammond 180432000740 4459 Kenwood Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         18.0 25.0                       43.0                         18 25                 43
1165009 1165009 IN     school 1804560 4720   School Town of Highland 180456000766 4285 Judith Morton Johnston Elem   Regular School No 1.0 KG 05 2015   grade_2                         18.0 27.0                       45.0                         18 27                 45
1165354 1165354 IN     school 1807860 5075   North Lawrence Com Schools 180786001339 4857 Fayetteville Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         18.0 14.0                       32.0                         18 14                 32
1166857 1166857 IN     school 1810920 5400   School Town of Speedway 181092001782 5905 Frank H Wheeler Elem School 4   Regular School No 1.0 KG 06 2015   grade_2                         18.0 22.0                       40.0                         18 22                 40
1168278 1168278 IN     school 1807980 6715   North Putnam Community Schools 180798001371 7045 Roachdale Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         18.0 20.0                       38.0                         18 20                 38
1168738 1168738 IN     school 1806840 7200   School City of Mishawaka 180684001186 7499 Twin Branch Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         18.0 30.0                       48.0                         18 30                 48
1170249 1170249 IN     school 1812390 8130   Warrick County School Corp 181239001980 8769 Elberfeld Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         18.0 20.0                       38.0                         18 20                 38
1160659 1160659 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         19.0 17.0                       36.0                         19 17                 36

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