enrollments

Data source: Big Local News · About: Big Local

976 rows where grade = "grade_5", state = "IN" and year = 2016 sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 976 ✖

grade ✖

  • grade_5 · 976 ✖
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
1283004 1283004 IN     school 1812240 2285   Wa-Nee Community Schools 181224001958 1669 North Wood Middle School   Regular School No 2.0 05 09 2016   grade_5                         0.0 1.0                       1.0                         0 1                 1
1284513 1284513 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         0.0 1.0                       1.0                         0 1                 1
1286144 1286144 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No 1.0 KG 08 2016   grade_5                         0.0 49.0                       49.0                         0 49                 49
1288315 1288315 IN     school 1809060 5485   Plymouth Community School Corp 180906001503 5933 Menominee Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         0.0 2.0                       2.0                         0 2                 2
1281027 1281027 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative Education School No 4.0 01 10 2016   grade_5                         1.0 1.0                       2.0                         1 1                 2
1285066 1285066 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No 1.0 PK 05 2016   grade_5                         1.0 1.0                       2.0                         1 1                 2
1285718 1285718 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         1.0 1.0                       2.0                         1 1                 2
1292870 1292870 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes 2.0 05 08 2016   grade_5                         1.0 61.0                       62.0                         1 61                 62
1281249 1281249 IN     school 1803630 235   Fort Wayne Community Schools 180363000549 213 Nebraska Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         10.0 11.0                       21.0                         10 11                 21
1282047 1282047 IN     school 1803940 1010   Greater Clark County Schools 180394000668 869 Maple Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         10.0 20.0                       30.0                         10 20                 30
1283526 1283526 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         10.0 8.0                       18.0                         10 8                 18
1285091 1285091 IN     school 1804980 3945   Jay School Corp 180498000917 3247 Redkey Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         10.0 12.0                       22.0                         10 12                 22
1286570 1286570 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No 1.0 KG 08 2016   grade_5                         10.0 18.0                       28.0                         10 18                 28
1288686 1288686 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001714 6233 Ladoga Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         10.0 10.0                       20.0                         10 10                 20
1289660 1289660 IN     school 1810500 6705   South Putnam Community Schools 181050001724 7057 Fillmore Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         10.0 10.0                       20.0                         10 10                 20
1284790 1284790 IN     school 1804470 3490   Western School Corp 180447002224 2923 Western Intermediate School   Regular School No 1.0 02 08 2016   grade_5                         100.0 92.0                       192.0                         100 92                 192
1281913 1281913 IN     school 1809370 940   West Clark Community Schools 180937001538 789 Silver Creek Elementary School   Regular School No 1.0 02 05 2016   grade_5                         102.0 93.0                       195.0                         102 93                 195
1287691 1287691 IN     school 1800450 5380   Beech Grove City Schools 180045000095 5461 South Grove Intermediate School   Regular School No 1.0 03 06 2016   grade_5                         103.0 110.0                       213.0                         103 110                 213
1285846 1285846 IN     school 1805450 4615   Lake Central School Corp 180545000985 3831 Michael Grimmer Middle School   Regular School No 2.0 05 08 2016   grade_5                         104.0 112.0                       216.0                         104 112                 216
1284208 1284208 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000695 2593 Greenfield Intermediate School   Regular School No 2.0 04 06 2016   grade_5                         106.0 81.0                       187.0                         106 81                 187
1281322 1281322 IN     school 1803630 235   Fort Wayne Community Schools 180363000567 265 Washington Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         11.0 10.0                       21.0                         11 10                 21
1282277 1282277 IN     school 1802440 1300   Crawford Co Com School Corp 180244000282 1061 Marengo Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         11.0 12.0                       23.0                         11 12                 23
1284659 1284659 IN     school 1807440 3445   New Castle Community Sch Corp 180744002156 2832 Eastwood Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         11.0 14.0                       25.0                         11 14                 25
1284892 1284892 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000792 3035 Salamonie School   Regular School No 1.0 KG 05 2016   grade_5                         11.0 22.0                       33.0                         11 22                 33
1287955 1287955 IN     school 1804770 5385   Indianapolis Public Schools 180477000884 5565 Raymond F Brandes School 65   Regular School No 1.0 PK 06 2016   grade_5                         11.0 13.0                       24.0                         11 13                 24
1289738 1289738 IN     school 1811730 6795   Union School Corporation 181173001874 7117 Union Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         11.0 6.0                       17.0                         11 6                 17
1292554 1292554 IN     school 1800065 9690   Renaissance Academy Charter School 180006502415 4711 Renaissance Academy Charter School   Regular School Yes 1.0 KG 08 2016   grade_5                         11.0 15.0                       26.0                         11 15                 26
1292592 1292592 IN     school 1800123 9735   Inspire Academy - A Sch of Inquiry 180012302560 1518 Inspire Academy - A Sch of Inquiry   Regular School Yes 1.0 KG 07 2016   grade_5                         11.0 22.0                       33.0                         11 22                 33
1292717 1292717 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes 1.0 KG 08 2016   grade_5                         11.0 13.0                       24.0                         11 13                 24
1283331 1283331 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001271 1933 Hazelwood Middle School   Regular School No 2.0 05 08 2016   grade_5                         111.0 127.0                       238.0                         111 127                 238
1285711 1285711 IN     school 1813110 4525   Westview School Corporation 181311002365 3702 Westview Elementary School   Regular School No 2.0 05 06 2016   grade_5                         111.0 92.0                       203.0                         111 92                 203
1281655 1281655 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No 2.0 04 08 2016   grade_5                         112.0 119.0                       231.0                         112 119                 231
1283336 1283336 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001276 1937 Nathaniel Scribner Middle School   Regular School No 2.0 05 08 2016   grade_5                         116.0 120.0                       236.0                         116 120                 236
1282252 1282252 IN     school 1802440 1300   Crawford Co Com School Corp 180244000284 1045 Patoka Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         12.0 8.0                       20.0                         12 8                 20
1284954 1284954 IN     school 1810080 3675   Seymour Community Schools 181008001615 3105 Cortland Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         12.0 6.0                       18.0                         12 6                 18
1286134 1286134 IN     school 1803870 4690   Gary Community School Corp 180387000617 4081 Dr Bernard C Watson Acad for Boys   Regular School No 1.0 KG 08 2016   grade_5                         12.0 0.0                       12.0                         12 0                 12
1286752 1286752 IN     school 1807860 5075   North Lawrence Com Schools 180786001339 4857 Fayetteville Elementary Sch   Regular School No 1.0 KG 05 2016   grade_5                         12.0 16.0                       28.0                         12 16                 28
1289108 1289108 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001787 6605 Gosport Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         12.0 11.0                       23.0                         12 11                 23
1289992 1289992 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001447 7341 Madison Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         12.0 11.0                       23.0                         12 11                 23
1291085 1291085 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000475 8251 Lincoln School   Regular School No 1.0 KG 08 2016   grade_5                         12.0 17.0                       29.0                         12 17                 29
1291591 1291591 IN     school 1806080 8115   M S D Warren County 180608001075 8729 Williamsport Elementary Sch   Regular School No 1.0 KG 06 2016   grade_5                         12.0 15.0                       27.0                         12 15                 27
1285881 1285881 IN     school 1805450 4615   Lake Central School Corp 180545000982 3841 Kahler Middle School   Regular School No 2.0 05 08 2016   grade_5                         122.0 127.0                       249.0                         122 127                 249
1283668 1283668 IN     school 1806390 2865   Marion Community Schools 180639001115 2350 Justice Thurgood Marshall Intrmd   Regular School No 2.0 05 06 2016   grade_5                         123.0 108.0                       231.0                         123 108                 231
1287479 1287479 IN     school 1812360 5360   M S D Warren Township 181236002477 5401 Stonybrook Intermediate Academy   Regular School No 2.0 05 06 2016   grade_5                         129.0 160.0                       289.0                         129 160                 289
1283568 1283568 IN     school 1810350 2765   South Gibson School Corp 181035001689 2205 Haubstadt Community School   Regular School No 1.0 KG 08 2016   grade_5                         13.0 15.0                       28.0                         13 15                 28
1283781 1283781 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         13.0 10.0                       23.0                         13 10                 23
1284338 1284338 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         13.0 12.0                       25.0                         13 12                 25
1284683 1284683 IN     school 1807440 3445   New Castle Community Sch Corp 180744001289 2853 Sunnyside Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         13.0 7.0                       20.0                         13 7                 20
1285141 1285141 IN     school 1806120 3995   Madison Consolidated Schools 180612001085 3301 Deputy Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         13.0 8.0                       21.0                         13 8                 21
1285158 1285158 IN     school 1806120 3995   Madison Consolidated Schools 180612001093 3321 Rykers' Ridge Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         13.0 23.0                       36.0                         13 23                 36
1287910 1287910 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No 1.0 PK 08 2016   grade_5                         13.0 11.0                       24.0                         13 11                 24
1288480 1288480 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001549 6117 Stinesville Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         13.0 19.0                       32.0                         13 19                 32
1288699 1288699 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001717 6258 Walnut Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         13.0 12.0                       25.0                         13 12                 25
1289241 1289241 IN     school 1808900 6445   Pike County School Corp 180890001480 6759 Otwell Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         13.0 15.0                       28.0                         13 15                 28
1289753 1289753 IN     school 1810740 6805   Randolph Southern School Corp 181074001762 7113 Randolph Southern Elem Sch   Regular School No 1.0 KG 06 2016   grade_5                         13.0 21.0                       34.0                         13 21                 34
1290668 1290668 IN     school 1804230 7610   Hamilton Community Schools 180423000723 7889 Hamilton Community Elem Sch   Regular School No 1.0 KG 06 2016   grade_5                         13.0 12.0                       25.0                         13 12                 25
1290738 1290738 IN     school 1810860 7715   Southwest School Corp 181086001770 7953 Carlisle Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         13.0 6.0                       19.0                         13 6                 19
1285863 1285863 IN     school 1805450 4615   Lake Central School Corp 180545002420 3838 Hal E Clark Middle School   Regular School No 2.0 05 08 2016   grade_5                         135.0 109.0                       244.0                         135 109                 244
1282162 1282162 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elem School   Regular School No 1.0 PK 05 2016   grade_5                         14.0 21.0                       35.0                         14 21                 35
1284753 1284753 IN     school 1802040 3470   Northwestern School Corp 180204000253 2905 Howard Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         14.0 22.0                       36.0                         14 22                 36
1285116 1285116 IN     school 1804980 3945   Jay School Corp 180498000915 3277 Judge Haynes Elementary Sch   Regular School No 1.0 KG 05 2016   grade_5                         14.0 10.0                       24.0                         14 10                 24
1289139 1289139 IN     school 1810900 6260   Southwest Parke Com Sch Corp 181090002286 6621 Rosedale Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         14.0 18.0                       32.0                         14 18                 32
1281661 1281661 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No 2.0 05 08 2016   grade_5                         143.0 139.0                       282.0                         143 139                 282
1288327 1288327 IN     school 1809060 5485   Plymouth Community School Corp 180906002211 5956 Riverside Intermediate   Regular School No 2.0 05 06 2016   grade_5                         143.0 120.0                       263.0                         143 120                 263
1285051 1285051 IN     school 1805280 3785   Kankakee Valley School Corp 180528001412 3198 Kankakee Valley Intermediate Schl   Regular School No 2.0 04 05 2016   grade_5                         144.0 136.0                       280.0                         144 136                 280
1287476 1287476 IN     school 1812360 5360   M S D Warren Township 181236002490 5399 Creston Intermediate Academy   Regular School No 2.0 05 06 2016   grade_5                         145.0 137.0                       282.0                         145 137                 282
1289312 1289312 IN     school 1802800 6470   Duneland School Corporation 180280000338 6927 Westchester Intermediate School   Regular School No 2.0 05 06 2016   grade_5                         146.0 123.0                       269.0                         146 123                 269
1283878 1283878 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton SE Int and Jr High Sch   Regular School No 2.0 05 08 2016   grade_5                         148.0 153.0                       301.0                         148 153                 301
1283789 1283789 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         15.0 10.0                       25.0                         15 10                 25
1286608 1286608 IN     school 1806570 4925   Michigan City Area Schools 180657001145 4805 Edgewood Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         15.0 22.0                       37.0                         15 22                 37
1288083 1288083 IN     school 1804770 5385   Indianapolis Public Schools 180477002577 5597 Emma Donnan Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         15.0 12.0                       27.0                         15 12                 27
1288235 1288235 IN     school 1810920 5400   School Town of Speedway 181092001783 5893 James A Allison Elem School 3   Regular School No 1.0 KG 06 2016   grade_5                         15.0 25.0                       40.0                         15 25                 40
1288898 1288898 IN     school 1807920 5945   North Newton School Corp 180792001359 6405 Lake Village Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         15.0 13.0                       28.0                         15 13                 28
1289155 1289155 IN     school 1810900 6260   Southwest Parke Com Sch Corp 181090002288 6629 Montezuma Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         15.0 14.0                       29.0                         15 14                 29
1289225 1289225 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801857 6647 Turkey Run Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         15.0 17.0                       32.0                         15 17                 32
1290383 1290383 IN     school 1810020 7255   Scott County School District 2 181002001610 7637 Lexington Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         15.0 13.0                       28.0                         15 13                 28
1282063 1282063 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         16.0 10.0                       26.0                         16 10                 26
1282335 1282335 IN     school 1812450 1405   Washington Com Schools 181245002005 1105 Veale Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         16.0 11.0                       27.0                         16 11                 27
1283645 1283645 IN     school 1806240 2825   Madison-Grant United Sch Corp 180624001100 5037 Summitville School   Regular School No 1.0 PK 06 2016   grade_5                         16.0 20.0                       36.0                         16 20                 36
1284861 1284861 IN     school 1805370 3500   Kokomo School Corporation 180537000960 3005 Wallace Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         16.0 29.0                       45.0                         16 29                 45
1286107 1286107 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No 1.0 01 06 2016   grade_5                         16.0 11.0                       27.0                         16 11                 27
1286674 1286674 IN     school 1805580 4945   LaPorte Community School Corp 180558002338 4707 Indian Trail Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         16.0 24.0                       40.0                         16 24                 40
1287938 1287938 IN     school 1804770 5385   Indianapolis Public Schools 180477000901 5560 William A Bell Reggio Acad Sch 60   Regular School No 1.0 PK 05 2016   grade_5                         16.0 9.0                       25.0                         16 9                 25
1288617 1288617 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000131 6213 Marlin Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         16.0 10.0                       26.0                         16 10                 26
1288793 1288793 IN     school 1806510 5925   M S D Martinsville Schools 180651001128 6337 Brooklyn Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         16.0 16.0                       32.0                         16 16                 32
1288954 1288954 IN     school 1801710 6055   Central Noble Com School Corp 180171000228 6454 Albion Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         16.0 29.0                       45.0                         16 29                 45
1289007 1289007 IN     school 1802970 6060   East Noble School Corp 180297000394 6485 Wayne Center Elem School   Regular School No 1.0 PK 06 2016   grade_5                         16.0 21.0                       37.0                         16 21                 37
1291412 1291412 IN     school 1812090 8030   Vigo County School Corp 181209001905 8521 Fayette Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         16.0 17.0                       33.0                         16 17                 33
1291640 1291640 IN     school 1812390 8130   Warrick County School Corp 181239001980 8769 Elberfeld Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         16.0 13.0                       29.0                         16 13                 29
1292095 1292095 IN     school 1802280 8665   Whitley Co Cons Schools 180228002108 9196 Mary Raber Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         16.0 28.0                       44.0                         16 28                 44
1284457 1284457 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No 2.0 04 06 2016   grade_5                         164.0 180.0                       344.0                         164 180                 344
1287482 1287482 IN     school 1812360 5360   M S D Warren Township 181236002479 5402 Raymond Park Intermediate   Regular School No 2.0 05 06 2016   grade_5                         167.0 146.0                       313.0                         167 146                 313
1282129 1282129 IN     school 1800840 1125   Clay Community Schools 180084000164 923 Van Buren Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         17.0 17.0                       34.0                         17 17                 34
1282581 1282581 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000847 1359 Country Meadow Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         17.0 20.0                       37.0                         17 20                 37
1282704 1282704 IN     school 1807320 1970   Muncie Community Schools 180732002319 1423 Storer Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         17.0 22.0                       39.0                         17 22                 39
1283166 1283166 IN     school 1803270 2305   Elkhart Community Schools 180327000443 1797 Riverview Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         17.0 25.0                       42.0                         17 25                 42
1284376 1284376 IN     school 1808100 3295   North West Hendricks Schools 180810001385 2685 North Salem Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         17.0 15.0                       32.0                         17 15                 32
1285026 1285026 IN     school 1812060 3710   Crothersville Community Schools 181206001892 3122 Crothersville Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         17.0 15.0                       32.0                         17 15                 32
1285744 1285744 IN     school 1805520 4535   Lakeland School Corporation 180552001000 3741 Wolcott Mills Elementary Sch   Regular School No 1.0 KG 05 2016   grade_5                         17.0 15.0                       32.0                         17 15                 32
1288096 1288096 IN     school 1804770 5385   Indianapolis Public Schools 180477000834 5603 Phalen at Francis Scott Key 103   Regular School No 1.0 PK 06 2016   grade_5                         17.0 19.0                       36.0                         17 19                 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]);