enrollments

Data source: Big Local News · About: Big Local

1,068 rows where grade = "grade_3", state = "IN" and year = 2015 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 1,068 ✖

grade ✖

  • grade_3 · 1,068 ✖
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
1159976 1159976 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No 1.0 03 06 2015   grade_3                         0.0 1.0                       1.0                         0 1                 1
1160260 1160260 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No 1.0 03 08 2015   grade_3                         1.0 0.0                       1.0                         1 0                 1
1161371 1161371 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_3                         0.0 1.0                       1.0                         0 1                 1
1161539 1161539 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No 1.0 03 06 2015   grade_3                         0.0 1.0                       1.0                         0 1                 1
1162936 1162936 IN     school 1810360 3190   South Harrison Com Schools 181036000385 2663 Corydon Intermediate School   Regular School No 1.0 03 06 2015   grade_3                         0.0 1.0                       1.0                         0 1                 1
1163658 1163658 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No 1.0 PK 05 2015   grade_3                         1.0 0.0                       1.0                         1 0                 1
1168687 1168687 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_3                         1.0 0.0                       1.0                         1 0                 1
1170164 1170164 IN     school 1812180 8050   M S D Wabash County Schools 181218002178 8657 Sharp Creek Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         1.0 0.0                       1.0                         1 0                 1
1160079 1160079 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         49.0 51.0                       100.0                         49 51                 100
1160408 1160408 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         50.0 50.0                       100.0                         50 50                 100
1161453 1161453 IN     school 1803960 2120   Greater Jasper Con Schs 180396000684 1569 Ireland Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         43.0 57.0                       100.0                         43 57                 100
1161570 1161570 IN     school 1806600 2275   Middlebury Community Schools 180660001163 1656 Jefferson Elementary School   Regular School No 1.0 KG 03 2015   grade_3                         48.0 52.0                       100.0                         48 52                 100
1162618 1162618 IN     school 1801200 3060   Carmel Clay Schools 180120000036 2512 Smoky Row Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         53.0 47.0                       100.0                         53 47                 100
1162648 1162648 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         53.0 47.0                       100.0                         53 47                 100
1162698 1162698 IN     school 1807650 3070   Noblesville Schools 180765001311 2529 North Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         55.0 45.0                       100.0                         55 45                 100
1162705 1162705 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         57.0 43.0                       100.0                         57 43                 100
1162844 1162844 IN     school 1807260 3135   Mt Vernon Community Sch Corp 180726002192 2570 McCordsville Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         53.0 47.0                       100.0                         53 47                 100
1162986 1162986 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000994 2706 Brown Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         48.0 52.0                       100.0                         48 52                 100
1164978 1164978 IN     school 1804320 4710   School City of Hammond 180432002237 4469 Morton Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         60.0 40.0                       100.0                         60 40                 100
1165668 1165668 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002409 5194 South Creek Elementary   Regular School No 1.0 KG 05 2015   grade_3                         47.0 53.0                       100.0                         47 53                 100
1168117 1168117 IN     school 1811970 6560   Valparaiso Community Schools 181197000163 6893 Flint Lake Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         52.0 48.0                       100.0                         52 48                 100
1169435 1169435 IN     school 1805400 7855   Lafayette School Corporation 180540000971 8103 Miami Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         59.0 41.0                       100.0                         59 41                 100
1169571 1169571 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         52.0 48.0                       100.0                         52 48                 100
1161162 1161162 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000222 1351 James R Watson Elem School   Regular School No 1.0 PK 05 2015   grade_3                         59.0 42.0                       101.0                         59 42                 101
1161761 1161761 IN     school 1803270 2305   Elkhart Community Schools 180327000444 1801 Roosevelt Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         52.0 49.0                       101.0                         52 49                 101
1164962 1164962 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elem Sch   Regular School No 1.0 PK 05 2015   grade_3                         49.0 52.0                       101.0                         49 52                 101
1165514 1165514 IN     school 1810440 5255   South Madison Com Sch Corp 181044001676 5064 Maple Ridge Elementary Sch   Regular School No 1.0 KG 06 2015   grade_3                         49.0 52.0                       101.0                         49 52                 101
1165907 1165907 IN     school 1808820 5340   Perry Township Schools 180882001687 5366 Jeremiah Gray-Edison Elem   Regular School No 1.0 PK 05 2015   grade_3                         56.0 45.0                       101.0                         56 45                 101
1170058 1170058 IN     school 1812090 8030   Vigo County School Corp 181209001909 8549 Lost Creek Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         53.0 48.0                       101.0                         53 48                 101
1159490 1159490 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No 1.0 02 04 2015   grade_3                         54.0 48.0                       102.0                         54 48                 102
1160390 1160390 IN     school 1801290 750   Carroll Consolidated Sch Corp 180129002103 629 Carroll Elementary   Regular School No 1.0 PK 06 2015   grade_3                         54.0 48.0                       102.0                         54 48                 102
1162795 1162795 IN     school 1804050 3125   Greenfield-Central Com Schools 180405001665 2588 J B Stephens Elementary School   Regular School No 1.0 PK 03 2015   grade_3                         53.0 49.0                       102.0                         53 49                 102
1163892 1163892 IN     school 1801440 4205   Center Grove Com Sch Corp 180144000208 3435 Center Grove Elem School   Regular School No 1.0 PK 05 2015   grade_3                         44.0 58.0                       102.0                         44 58                 102
1165683 1165683 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002113 5198 Thompson Crossing Elementary Schl   Regular School No 1.0 KG 05 2015   grade_3                         54.0 48.0                       102.0                         54 48                 102
1166474 1166474 IN     school 1804770 5385   Indianapolis Public Schools 180477002404 5551 James Russell Lowell School 51   Regular School No 1.0 PK 06 2015   grade_3                         46.0 56.0                       102.0                         46 56                 102
1166552 1166552 IN     school 1804770 5385   Indianapolis Public Schools 180477000890 5567 Stephen Collins Foster Sch 67   Regular School No 1.0 PK 06 2015   grade_3                         57.0 45.0                       102.0                         57 45                 102
1159468 1159468 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         50.0 53.0                       103.0                         50 53                 103
1160548 1160548 IN     school 1801920 1000   Clarksville Com School Corp 180192000251 845 Clarksville Elementary School   Regular School No 1.0 PK 04 2015   grade_3                         56.0 47.0                       103.0                         56 47                 103
1162599 1162599 IN     school 1801200 3060   Carmel Clay Schools 180120000192 2509 Carmel Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         53.0 50.0                       103.0                         53 50                 103
1165899 1165899 IN     school 1808820 5340   Perry Township Schools 180882001470 5351 Winchester Village Elementary   Regular School No 1.0 PK 05 2015   grade_3                         47.0 56.0                       103.0                         47 56                 103
1166050 1166050 IN     school 1812360 5360   M S D Warren Township 181236001969 5386 Pleasant Run Elementary Sch   Regular School No 1.0 KG 04 2015   grade_3                         54.0 49.0                       103.0                         54 49                 103
1168648 1168648 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876000526 7383 Horizon Elem Sch   Regular School No 1.0 KG 05 2015   grade_3                         49.0 54.0                       103.0                         49 54                 103
1169374 1169374 IN     school 1810860 7715   Southwest School Corp 181086001771 7965 Sullivan Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         54.0 49.0                       103.0                         54 49                 103
1159517 1159517 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         57.0 47.0                       104.0                         57 47                 104
1161552 1161552 IN     school 1802400 2270   Concord Community Schools 180240000272 1723 Concord Ox-Bow Elementary Sch   Regular School No 1.0 KG 04 2015   grade_3                         52.0 52.0                       104.0                         52 52                 104
1162534 1162534 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   grade_3                         56.0 48.0                       104.0                         56 48                 104
1162774 1162774 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_3                         60.0 44.0                       104.0                         60 44                 104
1163019 1163019 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001567 2718 Delaware Trail Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         61.0 43.0                       104.0                         61 43                 104
1163145 1163145 IN     school 1808970 3330   Plainfield Community Sch Corp 180897001493 2751 Central Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         57.0 47.0                       104.0                         57 47                 104
1164430 1164430 IN     school 1809690 4600   Merrillville Community School 180969001582 3821 Henry P Fieler Elem Sch   Regular School No 1.0 KG 04 2015   grade_3                         63.0 41.0                       104.0                         63 41                 104
1164908 1164908 IN     school 1804320 4710   School City of Hammond 180432002236 4449 Thomas A Edison Elem Sch   Regular School No 1.0 PK 05 2015   grade_3                         53.0 51.0                       104.0                         53 51                 104
1164923 1164923 IN     school 1804320 4710   School City of Hammond 180432000750 4453 Warren G Harding Elem Sch   Regular School No 1.0 PK 05 2015   grade_3                         50.0 54.0                       104.0                         50 54                 104
1165616 1165616 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No 1.0 01 06 2015   grade_3                         47.0 57.0                       104.0                         47 57                 104
1165980 1165980 IN     school 1808910 5350   M S D Pike Township 180891001486 5360 Guion Creek Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         62.0 42.0                       104.0                         62 42                 104
1165995 1165995 IN     school 1808910 5350   M S D Pike Township 180891001275 5378 New Augusta Pub Aca-South   Regular School No 1.0 KG 05 2015   grade_3                         48.0 56.0                       104.0                         48 56                 104
1166483 1166483 IN     school 1804770 5385   Indianapolis Public Schools 180477000805 5554 Brookside School 54   Regular School No 1.0 KG 06 2015   grade_3                         49.0 55.0                       104.0                         49 55                 104
1168662 1168662 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001148 7390 Northpoint Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         60.0 44.0                       104.0                         60 44                 104
1159788 1159788 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         57.0 48.0                       105.0                         57 48                 105
1160232 1160232 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No 1.0 KG 03 2015   grade_3                         47.0 58.0                       105.0                         47 58                 105
1162713 1162713 IN     school 1807650 3070   Noblesville Schools 180765002414 2537 Noble Crossing Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         49.0 56.0                       105.0                         49 56                 105
1163577 1163577 IN     school 1810080 3675   Seymour Community Schools 181008001619 3153 Seymour-Jackson Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         58.0 47.0                       105.0                         58 47                 105
1165082 1165082 IN     school 1807350 4740   School Town of Munster 180735001255 4337 James B Eads Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         61.0 44.0                       105.0                         61 44                 105
1161785 1161785 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         58.0 48.0                       106.0                         58 48                 106
1162429 1162429 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000373 2475 Lantern Road Elementary Sch   Regular School No 1.0 KG 04 2015   grade_3                         59.0 47.0                       106.0                         59 47                 106
1162551 1162551 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   grade_3                         73.0 33.0                       106.0                         73 33                 106
1163974 1163974 IN     school 1803690 4225   Franklin Community School Corp 180369000584 3461 Northwood Elementary School   Regular School No 1.0 PK 04 2015   grade_3                         57.0 49.0                       106.0                         57 49                 106
1166223 1166223 IN     school 1812810 5375   M S D Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         50.0 56.0                       106.0                         50 56                 106
1166776 1166776 IN     school 1804770 5385   Indianapolis Public Schools 180477002393 5662 Clarence Farrington School 61   Regular School No 1.0 KG 06 2015   grade_3                         54.0 52.0                       106.0                         54 52                 106
1166904 1166904 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elem/Middle School   Regular School No 1.0 KG 08 2015   grade_3                         50.0 56.0                       106.0                         50 56                 106
1169521 1169521 IN     school 1811340 7865   Tippecanoe School Corp 181134001821 8024 Battle Ground Elem Sch   Regular School No 1.0 KG 05 2015   grade_3                         55.0 51.0                       106.0                         55 51                 106
1161950 1161950 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001268 1957 Grant Line School   Regular School No 1.0 KG 04 2015   grade_3                         48.0 59.0                       107.0                         48 59                 107
1163001 1163001 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000045 2711 Eagle Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         60.0 47.0                       107.0                         60 47                 107
1163640 1163640 IN     school 1805280 3785   Kankakee Valley School Corp 180528000935 3197 Wheatfield Elementary School   Regular School No 1.0 KG 03 2015   grade_3                         60.0 47.0                       107.0                         60 47                 107
1164509 1164509 IN     school 1805450 4615   Lake Central School Corp 180545002143 4349 Homan Elementary School   Regular School No 1.0 PK 04 2015   grade_3                         56.0 51.0                       107.0                         56 51                 107
1164677 1164677 IN     school 1802880 4670   School City of East Chicago 180288000368 3961 George Washington Elem School   Regular School No 1.0 PK 05 2015   grade_3                         55.0 52.0                       107.0                         55 52                 107
1166267 1166267 IN     school 1812810 5375   M S D Wayne Township 181281002123 5446 Bridgeport Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         47.0 60.0                       107.0                         47 60                 107
1168824 1168824 IN     school 1810290 7205   South Bend Community Sch Corp 181029001644 7533 Coquillard Primary Center   Regular School No 1.0 KG 04 2015   grade_3                         60.0 47.0                       107.0                         60 47                 107
1163037 1163037 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001570 2727 Cardinal Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         55.0 53.0                       108.0                         55 53                 108
1164885 1164885 IN     school 1804320 4710   School City of Hammond 180432002413 4422 Joseph Hess Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         62.0 46.0                       108.0                         62 46                 108
1166254 1166254 IN     school 1812810 5375   M S D Wayne Township 181281002031 5274 Chapelwood Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         64.0 44.0                       108.0                         64 44                 108
1166663 1166663 IN     school 1804770 5385   Indianapolis Public Schools 180477000873 5596 Meredith Nicholson School 96   Regular School No 1.0 KG 06 2015   grade_3                         49.0 59.0                       108.0                         49 59                 108
1167673 1167673 IN     school 1808640 6155   Paoli Community School Corp 180864001439 6587 Throop Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         58.0 50.0                       108.0                         58 50                 108
1169514 1169514 IN     school 1811340 7865   Tippecanoe School Corp 181134001305 8021 Wea Ridge Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         46.0 62.0                       108.0                         46 62                 108
1159781 1159781 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         63.0 46.0                       109.0                         63 46                 109
1161446 1161446 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001236 1590 Huntingburg Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         43.0 66.0                       109.0                         43 66                 109
1164516 1164516 IN     school 1805450 4615   Lake Central School Corp 180545000986 4351 Peifer Elementary School   Regular School No 1.0 PK 04 2015   grade_3                         69.0 40.0                       109.0                         69 40                 109
1169797 1169797 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000483 8321 Stockwell Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         49.0 60.0                       109.0                         49 60                 109
1170995 1170995 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2015   grade_3                         52.0 57.0                       109.0                         52 57                 109
1159709 1159709 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_3                         61.0 49.0                       110.0                         61 49                 110
1161736 1161736 IN     school 1803270 2305   Elkhart Community Schools 180327000441 1785 Pinewood Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         60.0 50.0                       110.0                         60 50                 110
1165489 1165489 IN     school 1810440 5255   South Madison Com Sch Corp 181044002167 4935 East Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         64.0 46.0                       110.0                         64 46                 110
1165552 1165552 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         55.0 55.0                       110.0                         55 55                 110
1165797 1165797 IN     school 1805670 5330   M S D Lawrence Township 180567001033 5296 Oaklandon Elementary School   Regular School No 1.0 01 06 2015   grade_3                         59.0 51.0                       110.0                         59 51                 110
1165878 1165878 IN     school 1808820 5340   Perry Township Schools 180882001457 5338 Douglas MacArthur Elem School   Regular School No 1.0 KG 05 2015   grade_3                         53.0 57.0                       110.0                         53 57                 110
1166070 1166070 IN     school 1812360 5360   M S D Warren Township 181236001690 5397 Liberty Park Elementary Sch   Regular School No 1.0 KG 04 2015   grade_3                         56.0 54.0                       110.0                         56 54                 110
1169125 1169125 IN     school 1810140 7365   Shelbyville Central Schools 181014001632 7729 Thomas A Hendricks Elem Sch   Regular School No 1.0 PK 05 2015   grade_3                         66.0 44.0                       110.0                         66 44                 110
1170097 1170097 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         49.0 61.0                       110.0                         49 61                 110
1171502 1171502 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes 1.0 KG 04 2015   grade_3                         63.0 47.0                       110.0                         63 47                 110
1160964 1160964 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001803 1189 North Dearborn Elementary School   Regular School No 1.0 PK 04 2015   grade_3                         53.0 58.0                       111.0                         53 58                 111
1162052 1162052 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No 1.0 PK 04 2015   grade_3                         55.0 56.0                       111.0                         55 56                 111

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