enrollments

Data source: Big Local News · About: Big Local

1,060 rows where grade = "grade_1", state = "IN" and year = 2015 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 1,060 ✖

grade ✖

  • grade_1 · 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
1162134 1162134 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No 1.0 01 05 2015   grade_1                         1.0 0.0                       1.0                         1 0                 1
1169091 1169091 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_1                         1.0 0.0                       1.0                         1 0                 1
1159713 1159713 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         45.0 55.0                       100.0                         45 55                 100
1164428 1164428 IN     school 1809690 4600   Merrillville Community School 180969001582 3821 Henry P Fieler Elem Sch   Regular School No 1.0 KG 04 2015   grade_1                         60.0 40.0                       100.0                         60 40                 100
1164778 1164778 IN     school 1803870 4690   Gary Community School Corp 180387002096 4121 Jacques Marquette Elem School   Regular School No 1.0 KG 06 2015   grade_1                         55.0 45.0                       100.0                         55 45                 100
1165780 1165780 IN     school 1805670 5330   M S D Lawrence Township 180567000150 5294 Forest Glen Elem Sch   Regular School No 1.0 KG 06 2015   grade_1                         44.0 56.0                       100.0                         44 56                 100
1166205 1166205 IN     school 1812810 5375   M S D Wayne Township 181281002037 5265 Robey Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         54.0 46.0                       100.0                         54 46                 100
1166774 1166774 IN     school 1804770 5385   Indianapolis Public Schools 180477002393 5662 Clarence Farrington School 61   Regular School No 1.0 KG 06 2015   grade_1                         51.0 49.0                       100.0                         51 49                 100
1169484 1169484 IN     school 1811340 7865   Tippecanoe School Corp 181134001826 8007 Hershey Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         46.0 54.0                       100.0                         46 54                 100
1160962 1160962 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001803 1189 North Dearborn Elementary School   Regular School No 1.0 PK 04 2015   grade_1                         50.0 51.0                       101.0                         50 51                 101
1162646 1162646 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         49.0 52.0                       101.0                         49 52                 101
1163097 1163097 IN     school 1800270 3315   Avon Community School Corp 180027001675 2740 Hickory Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         64.0 37.0                       101.0                         64 37                 101
1164991 1164991 IN     school 1804320 4710   School City of Hammond 180432002106 4484 Frank O'Bannon Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         45.0 56.0                       101.0                         45 56                 101
1165651 1165651 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No 1.0 01 06 2015   grade_1                         49.0 52.0                       101.0                         49 52                 101
1166367 1166367 IN     school 1804770 5385   Indianapolis Public Schools 180477000896 5515 Thomas D Gregg School 15   Regular School No 1.0 PK 06 2015   grade_1                         55.0 46.0                       101.0                         55 46                 101
1166938 1166938 IN     school 1809060 5485   Plymouth Community School Corp 180906001501 5965 Washington Discovery Academy   Regular School No 1.0 KG 04 2015   grade_1                         48.0 53.0                       101.0                         48 53                 101
1168911 1168911 IN     school 1810290 7205   South Bend Community Sch Corp 181029001674 7593 Muessel Primary Center   Regular School No 1.0 KG 04 2015   grade_1                         49.0 52.0                       101.0                         49 52                 101
1161783 1161783 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         49.0 53.0                       102.0                         49 53                 102
1163152 1163152 IN     school 1808970 3330   Plainfield Community Sch Corp 180897001495 2761 Van Buren Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         49.0 53.0                       102.0                         49 53                 102
1164064 1164064 IN     school 1810410 4325   South Knox School Corp 181041001705 3489 South Knox Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         49.0 53.0                       102.0                         49 53                 102
1164960 1164960 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elem Sch   Regular School No 1.0 PK 05 2015   grade_1                         50.0 52.0                       102.0                         50 52                 102
1165479 1165479 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002052 5025 Lapel Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         51.0 51.0                       102.0                         51 51                 102
1165487 1165487 IN     school 1810440 5255   South Madison Com Sch Corp 181044002167 4935 East Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         51.0 51.0                       102.0                         51 51                 102
1165512 1165512 IN     school 1810440 5255   South Madison Com Sch Corp 181044001676 5064 Maple Ridge Elementary Sch   Regular School No 1.0 KG 06 2015   grade_1                         48.0 54.0                       102.0                         48 54                 102
1165614 1165614 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No 1.0 01 06 2015   grade_1                         56.0 46.0                       102.0                         56 46                 102
1166018 1166018 IN     school 1812360 5360   M S D Warren Township 181236001962 5369 Eastridge Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         45.0 57.0                       102.0                         45 57                 102
1168431 1168431 IN     school 1810530 6865   South Ripley Com Sch Corp 181053002380 7178 South Ripley Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         53.0 49.0                       102.0                         53 49                 102
1168875 1168875 IN     school 1810290 7205   South Bend Community Sch Corp 181029001673 7569 McKinley Primary Center   Regular School No 1.0 KG 04 2015   grade_1                         49.0 53.0                       102.0                         49 53                 102
1159466 1159466 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         63.0 40.0                       103.0                         63 40                 103
1160813 1160813 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         50.0 53.0                       103.0                         50 53                 103
1162589 1162589 IN     school 1801200 3060   Carmel Clay Schools 180120002332 2508 Cherry Tree Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         54.0 49.0                       103.0                         54 49                 103
1163010 1163010 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102002430 2714 Reagan Elementary   Regular School No 1.0 KG 05 2015   grade_1                         60.0 43.0                       103.0                         60 43                 103
1159756 1159756 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elem Sch   Regular School No 1.0 KG 05 2015   grade_1                         54.0 50.0                       104.0                         54 50                 104
1161182 1161182 IN     school 1802660 1875   Delaware Community School Corp 180266000324 1365 Royerton Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         48.0 56.0                       104.0                         48 56                 104
1161444 1161444 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001236 1590 Huntingburg Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         49.0 55.0                       104.0                         49 55                 104
1164667 1164667 IN     school 1802880 4670   School City of East Chicago 180288000375 3953 William McKinley Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         50.0 54.0                       104.0                         50 54                 104
1165710 1165710 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000596 5205 Bunker Hill Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         48.0 56.0                       104.0                         48 56                 104
1159771 1159771 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         58.0 47.0                       105.0                         58 47                 105
1160230 1160230 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No 1.0 KG 03 2015   grade_1                         52.0 53.0                       105.0                         52 53                 105
1161568 1161568 IN     school 1806600 2275   Middlebury Community Schools 180660001163 1656 Jefferson Elementary School   Regular School No 1.0 KG 03 2015   grade_1                         65.0 40.0                       105.0                         65 40                 105
1162427 1162427 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000373 2475 Lantern Road Elementary Sch   Regular School No 1.0 KG 04 2015   grade_1                         58.0 47.0                       105.0                         58 47                 105
1166162 1166162 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         51.0 54.0                       105.0                         51 54                 105
1166472 1166472 IN     school 1804770 5385   Indianapolis Public Schools 180477002404 5551 James Russell Lowell School 51   Regular School No 1.0 PK 06 2015   grade_1                         59.0 46.0                       105.0                         59 46                 105
1169123 1169123 IN     school 1810140 7365   Shelbyville Central Schools 181014001632 7729 Thomas A Hendricks Elem Sch   Regular School No 1.0 PK 05 2015   grade_1                         53.0 52.0                       105.0                         53 52                 105
1169131 1169131 IN     school 1810140 7365   Shelbyville Central Schools 181014001633 7733 William F Loper Elem Sch   Regular School No 1.0 PK 05 2015   grade_1                         54.0 51.0                       105.0                         54 51                 105
1170192 1170192 IN     school 1812150 8060   Wabash City Schools 181215001937 8706 O J Neighbours Elem Sch   Regular School No 1.0 PK 04 2015   grade_1                         56.0 49.0                       105.0                         56 49                 105
1159763 1159763 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         49.0 57.0                       106.0                         49 57                 106
1161562 1161562 IN     school 1802400 2270   Concord Community Schools 180240000274 1729 Concord West Side Elem School   Regular School No 1.0 KG 04 2015   grade_1                         56.0 50.0                       106.0                         56 50                 106
1163925 1163925 IN     school 1801440 4205   Center Grove Com Sch Corp 180144002333 3444 Pleasant Grove Elem Sch   Regular School No 1.0 KG 05 2015   grade_1                         51.0 55.0                       106.0                         51 55                 106
1165876 1165876 IN     school 1808820 5340   Perry Township Schools 180882001457 5338 Douglas MacArthur Elem School   Regular School No 1.0 KG 05 2015   grade_1                         51.0 55.0                       106.0                         51 55                 106
1168976 1168976 IN     school 1809990 7230   Scott County School District 1 180999001604 7630 Austin Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         57.0 49.0                       106.0                         57 49                 106
1169795 1169795 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000483 8321 Stockwell Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         67.0 39.0                       106.0                         67 39                 106
1160905 1160905 IN     school 1807710 1375   North Daviess Com Schools 180771001648 1090 North Daviess Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         59.0 48.0                       107.0                         59 48                 107
1161637 1161637 IN     school 1803270 2305   Elkhart Community Schools 180327000426 1617 Cleveland Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         66.0 41.0                       107.0                         66 41                 107
1162666 1162666 IN     school 1801200 3060   Carmel Clay Schools 180120002185 2526 West Clay Elementary   Regular School No 1.0 KG 05 2015   grade_1                         55.0 52.0                       107.0                         55 52                 107
1163638 1163638 IN     school 1805280 3785   Kankakee Valley School Corp 180528000935 3197 Wheatfield Elementary School   Regular School No 1.0 KG 03 2015   grade_1                         54.0 53.0                       107.0                         54 53                 107
1166054 1166054 IN     school 1812360 5360   M S D Warren Township 181236001971 5389 Sunny Heights Elementary Sch   Regular School No 1.0 KG 04 2015   grade_1                         56.0 51.0                       107.0                         56 51                 107
1166550 1166550 IN     school 1804770 5385   Indianapolis Public Schools 180477000890 5567 Stephen Collins Foster Sch 67   Regular School No 1.0 PK 06 2015   grade_1                         47.0 60.0                       107.0                         47 60                 107
1168646 1168646 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876000526 7383 Horizon Elem Sch   Regular School No 1.0 KG 05 2015   grade_1                         53.0 54.0                       107.0                         53 54                 107
1170004 1170004 IN     school 1812090 8030   Vigo County School Corp 181209001903 8511 Dixie Bee Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         60.0 47.0                       107.0                         60 47                 107
1162403 1162403 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No 1.0 KG 04 2015   grade_1                         69.0 39.0                       108.0                         69 39                 108
1162439 1162439 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000967 2481 Harrison Parkway Elem School   Regular School No 1.0 KG 04 2015   grade_1                         59.0 49.0                       108.0                         59 49                 108
1163599 1163599 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         63.0 45.0                       108.0                         63 45                 108
1165802 1165802 IN     school 1805670 5330   M S D Lawrence Township 180567001034 5298 Skiles Test Elementary School   Regular School No 1.0 01 06 2015   grade_1                         63.0 45.0                       108.0                         63 45                 108
1165897 1165897 IN     school 1808820 5340   Perry Township Schools 180882001470 5351 Winchester Village Elementary   Regular School No 1.0 PK 05 2015   grade_1                         60.0 48.0                       108.0                         60 48                 108
1169372 1169372 IN     school 1810860 7715   Southwest School Corp 181086001771 7965 Sullivan Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         53.0 55.0                       108.0                         53 55                 108
1169512 1169512 IN     school 1811340 7865   Tippecanoe School Corp 181134001305 8021 Wea Ridge Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         56.0 52.0                       108.0                         56 52                 108
1170537 1170537 IN     school 1808220 8435   Northern Wells Com Schools 180822001411 9081 Ossian Elementary   Regular School No 1.0 KG 05 2015   grade_1                         50.0 58.0                       108.0                         50 58                 108
1162772 1162772 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001407 2567 Sugar Creek Elementary Sch   Regular School No 1.0 PK 06 2015   grade_1                         56.0 53.0                       109.0                         56 53                 109
1162984 1162984 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000994 2706 Brown Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         57.0 52.0                       109.0                         57 52                 109
1163910 1163910 IN     school 1801440 4205   Center Grove Com Sch Corp 180144000211 3440 North Grove Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         51.0 58.0                       109.0                         51 58                 109
1164470 1164470 IN     school 1805450 4615   Lake Central School Corp 180545000983 3837 Kolling Elementary School   Regular School No 1.0 PK 04 2015   grade_1                         56.0 53.0                       109.0                         56 53                 109
1165913 1165913 IN     school 1808820 5340   Perry Township Schools 180882001809 5372 Rosa Parks-Edison Elem   Regular School No 1.0 PK 05 2015   grade_1                         51.0 58.0                       109.0                         51 58                 109
1171067 1171067 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_1                         2.0 9.0                       11.0                         2 9                 11
1163017 1163017 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001567 2718 Delaware Trail Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         58.0 52.0                       110.0                         58 52                 110
1163394 1163394 IN     school 1805370 3500   Kokomo School Corporation 180537000959 2943 Sycamore Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         57.0 53.0                       110.0                         57 53                 110
1163656 1163656 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No 1.0 PK 05 2015   grade_1                         67.0 43.0                       110.0                         67 43                 110
1166036 1166036 IN     school 1812360 5360   M S D Warren Township 181236001966 5375 Lakeside Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         54.0 56.0                       110.0                         54 56                 110
1170095 1170095 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         59.0 51.0                       110.0                         59 51                 110
1171500 1171500 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes 1.0 KG 04 2015   grade_1                         58.0 52.0                       110.0                         58 52                 110
1170326 1170326 IN     school 1812390 8130   Warrick County School Corp 181239002179 8819 Sharon Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         60.0 51.0                       111.0                         60 51                 111
1161759 1161759 IN     school 1803270 2305   Elkhart Community Schools 180327000444 1801 Roosevelt Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         58.0 54.0                       112.0                         58 54                 112
1165080 1165080 IN     school 1807350 4740   School Town of Munster 180735001255 4337 James B Eads Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         46.0 66.0                       112.0                         46 66                 112
1165532 1165532 IN     school 1800120 5265   Alexandria Com School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No 1.0 PK 03 2015   grade_1                         59.0 53.0                       112.0                         59 53                 112
1165970 1165970 IN     school 1808910 5350   M S D Pike Township 180891001485 5359 Eastbrook Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         60.0 52.0                       112.0                         60 52                 112
1166024 1166024 IN     school 1812360 5360   M S D Warren Township 181236001964 5370 Hawthorne Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         71.0 41.0                       112.0                         71 41                 112
1166590 1166590 IN     school 1804770 5385   Indianapolis Public Schools 180477000808 5579 Carl Wilde School 79   Regular School No 1.0 KG 06 2015   grade_1                         63.0 49.0                       112.0                         63 49                 112
1166902 1166902 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elem/Middle School   Regular School No 1.0 KG 08 2015   grade_1                         43.0 69.0                       112.0                         43 69                 112
1168212 1168212 IN     school 1807110 6620   Eastern Pulaski Com Sch Corp 180711001204 6994 Eastern Pulaski Elem Sch   Regular School No 1.0 PK 05 2015   grade_1                         63.0 49.0                       112.0                         63 49                 112
1164048 1164048 IN     school 1807830 4315   North Knox School Corp 180783001332 3521 North Knox Primary School   Regular School No 1.0 KG 02 2015   grade_1                         50.0 63.0                       113.0                         50 63                 113
1164789 1164789 IN     school 1803870 4690   Gary Community School Corp 180387002102 4155 Glen Park Acad for Excel in Lrn   Regular School No 1.0 KG 06 2015   grade_1                         65.0 48.0                       113.0                         65 48                 113
1165570 1165570 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         68.0 45.0                       113.0                         68 45                 113
1165739 1165739 IN     school 1805670 5330   M S D Lawrence Township 180567001032 5283 Mary Evelyn Castle Elem Sch   Regular School No 1.0 01 06 2015   grade_1                         55.0 58.0                       113.0                         55 58                 113
1167345 1167345 IN     school 1804140 5900   Monroe-Gregg School District 180414000715 6323 Monrovia Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         54.0 59.0                       113.0                         54 59                 113
1162397 1162397 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001751 2469 Fishers Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         56.0 58.0                       114.0                         56 58                 114
1162532 1162532 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   grade_1                         52.0 62.0                       114.0                         52 62                 114
1164434 1164434 IN     school 1809690 4600   Merrillville Community School 180969001583 3822 Homer Iddings Elem Sch   Regular School No 1.0 KG 04 2015   grade_1                         50.0 64.0                       114.0                         50 64                 114
1165773 1165773 IN     school 1805670 5330   M S D Lawrence Township 180567002278 5293 Indian Creek Elem Sch   Regular School No 1.0 01 06 2015   grade_1                         65.0 49.0                       114.0                         65 49                 114
1165838 1165838 IN     school 1808820 5340   Perry Township Schools 180882001469 5321 William Henry Burkhart Elem   Regular School No 1.0 KG 05 2015   grade_1                         59.0 55.0                       114.0                         59 55                 114
1165956 1165956 IN     school 1808910 5350   M S D Pike Township 180891001484 5357 Central Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         53.0 61.0                       114.0                         53 61                 114

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