enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 959 ✖

grade ✖

  • grade_5 · 959 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total ▼ white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1788499 1788499 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 05 12 2018   grade_5                         1.0 0.0                       1.0                         1 0                 1
1789355 1789355 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Other 04 11 2018   grade_5                         1.0 0.0                       1.0                         1 0                 1
1789382 1789382 IN     school 1806600 2275   Middlebury Community Schools 180660000199 1734 Orchard View School   Regular School No Elementary KG 05 2018   grade_5                         1.0 0.0                       1.0                         1 0                 1
1789573 1789573 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 05 12 2018   grade_5                         0.0 1.0                       1.0                         0 1                 1
1791840 1791840 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001306 3409 Indian Creek Elementary School   Regular School No Elementary PK 05 2018   grade_5                         1.0 0.0                       1.0                         1 0                 1
1794656 1794656 IN     school 1809060 5485   Plymouth Community School Corp 180906001503 5933 Menominee Elementary School   Regular School No Elementary KG 05 2018   grade_5                         1.0 0.0                       1.0                         1 0                 1
1793282 1793282 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2018   grade_5                         49.0 51.0                       100.0                         49 51                 100
1793563 1793563 IN     school 1805670 5330   M S D Lawrence Township 180567001033 5296 Oaklandon Elementary School   Regular School No Elementary 01 06 2018   grade_5                         47.0 53.0                       100.0                         47 53                 100
1794993 1794993 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000138 6226 University Elementary School   Regular School No Elementary PK 06 2018   grade_5                         52.0 48.0                       100.0                         52 48                 100
1796348 1796348 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001442 7361 Elm Road Elementary School   Regular School No Elementary PK 05 2018   grade_5                         57.0 43.0                       100.0                         57 43                 100
1797388 1797388 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000460 8225 Cynthia Heights Elementary School   Regular School No Elementary KG 05 2018   grade_5                         55.0 45.0                       100.0                         55 45                 100
1797829 1797829 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No Elementary KG 05 2018   grade_5                         52.0 48.0                       100.0                         52 48                 100
1787336 1787336 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   grade_5                         53.0 48.0                       101.0                         53 48                 101
1787582 1787582 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2018   grade_5                         51.0 50.0                       101.0                         51 50                 101
1790828 1790828 IN     school 1801020 3305   Brownsburg Community School Corp 180102001671 2723 White Lick Elementary School   Regular School No Elementary KG 05 2018   grade_5                         59.0 42.0                       101.0                         59 42                 101
1791648 1791648 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000244 3401 Clark Elementary School   Regular School No Elementary KG 05 2018   grade_5                         47.0 54.0                       101.0                         47 54                 101
1792643 1792643 IN     school 1804320 4710   School City of Hammond 180432002413 4422 Joseph Hess Elementary School   Regular School No Elementary PK 05 2018   grade_5                         50.0 51.0                       101.0                         50 51                 101
1794646 1794646 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elementary/Middle School   Regular School No Elementary KG 08 2018   grade_5                         60.0 41.0                       101.0                         60 41                 101
1797533 1797533 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000483 8321 Stockwell Elementary School   Regular School No Elementary KG 05 2018   grade_5                         50.0 51.0                       101.0                         50 51                 101
1798410 1798410 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2018   grade_5                         61.0 40.0                       101.0                         61 40                 101
1790140 1790140 IN     school 1805910 2950   Linton-Stockton School Corporation 180591001048 2441 Linton-Stockton Elementary   Regular School No Elementary KG 05 2018   grade_5                         51.0 51.0                       102.0                         51 51                 102
1791135 1791135 IN     school 1802040 3470   Northwestern School Corp 180204000254 2904 Northwestern Elementary School   Regular School No Elementary KG 06 2018   grade_5                         48.0 54.0                       102.0                         48 54                 102
1793479 1793479 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000596 5205 Bunker Hill Elementary School   Regular School No Elementary KG 05 2018   grade_5                         57.0 45.0                       102.0                         57 45                 102
1793670 1793670 IN     school 1808820 5340   Perry Township Schools 180882001470 5351 Winchester Village Elementary   Regular School No Elementary PK 05 2018   grade_5                         60.0 42.0                       102.0                         60 42                 102
1793712 1793712 IN     school 1808910 5350   M S D Pike Township 180891002324 5354 College Park Elementary School   Regular School No Elementary KG 05 2018   grade_5                         52.0 50.0                       102.0                         52 50                 102
1793880 1793880 IN     school 1812720 5370   M S D Washington Township 181272002020 5427 Nora Elementary School   Regular School No Elementary KG 05 2018   grade_5                         58.0 44.0                       102.0                         58 44                 102
1795508 1795508 IN     school 1801740 6325   Perry Central Com Schools Corp 180174000232 6705 Perry Central Elementary School   Regular School No Elementary PK 06 2018   grade_5                         62.0 40.0                       102.0                         62 40                 102
1795620 1795620 IN     school 1800750 6460   M S D Boone Township 180075000152 6815 Hebron Elementary School   Regular School No Elementary KG 05 2018   grade_5                         48.0 54.0                       102.0                         48 54                 102
1790628 1790628 IN     school 1807260 3135   Mt Vernon Community School Corp 180726001220 2561 Mt Comfort Elementary School   Regular School No Elementary KG 05 2018   grade_5                         57.0 46.0                       103.0                         57 46                 103
1790835 1790835 IN     school 1801020 3305   Brownsburg Community School Corp 180102001570 2727 Cardinal Elementary School   Regular School No Elementary KG 05 2018   grade_5                         64.0 39.0                       103.0                         64 39                 103
1793741 1793741 IN     school 1808910 5350   M S D Pike Township 180891001485 5359 Eastbrook Elementary School   Regular School No Elementary KG 05 2018   grade_5                         49.0 54.0                       103.0                         49 54                 103
1795714 1795714 IN     school 1809180 6520   Porter Township School Corp 180918001520 6837 Boone Grove Elementary School   Regular School No Elementary 04 05 2018   grade_5                         58.0 45.0                       103.0                         58 45                 103
1795957 1795957 IN     school 1807110 6620   Eastern Pulaski Community Sch Corp 180711001204 6994 Eastern Pulaski Elementary School   Regular School No Elementary KG 05 2018   grade_5                         50.0 53.0                       103.0                         50 53                 103
1797223 1797223 IN     school 1811340 7865   Tippecanoe School Corp 181134001826 8007 Hershey Elementary School   Regular School No Elementary KG 05 2018   grade_5                         56.0 47.0                       103.0                         56 47                 103
1797623 1797623 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000489 8381 West Terrace Elementary School   Regular School No Elementary KG 05 2018   grade_5                         46.0 57.0                       103.0                         46 57                 103
1792666 1792666 IN     school 1804320 4710   School City of Hammond 180432002236 4449 Thomas A Edison Elementary School   Regular School No Elementary PK 05 2018   grade_5                         54.0 50.0                       104.0                         54 50                 104
1793654 1793654 IN     school 1808820 5340   Perry Township Schools 180882001460 5345 Homecroft Elementary School   Regular School No Elementary PK 05 2018   grade_5                         61.0 43.0                       104.0                         61 43                 104
1793700 1793700 IN     school 1808910 5350   M S D Pike Township 180891002374 5352 Deer Run Elementary   Regular School No Elementary KG 05 2018   grade_5                         59.0 45.0                       104.0                         59 45                 104
1795210 1795210 IN     school 1807140 5930   Mooresville Con School Corp 180714001210 6385 North Madison Elementary School   Regular School No Elementary KG 06 2018   grade_5                         48.0 56.0                       104.0                         48 56                 104
1787605 1787605 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary School   Regular School No Elementary KG 05 2018   grade_5                         47.0 58.0                       105.0                         47 58                 105
1787625 1787625 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary School   Regular School No Elementary PK 05 2018   grade_5                         61.0 44.0                       105.0                         61 44                 105
1788707 1788707 IN     school 1807710 1375   North Daviess Com Schools 180771001648 1090 North Daviess Elementary School   Regular School No Elementary KG 06 2018   grade_5                         58.0 47.0                       105.0                         58 47                 105
1789231 1789231 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001236 1590 Huntingburg Elementary School   Regular School No Elementary KG 05 2018   grade_5                         63.0 42.0                       105.0                         63 42                 105
1790428 1790428 IN     school 1801200 3060   Carmel Clay Schools 180120002267 2513 Orchard Park Elementary School   Regular School No Elementary PK 05 2018   grade_5                         55.0 50.0                       105.0                         55 50                 105
1791021 1791021 IN     school 1808280 3435   Shenandoah School Corporation 180828002356 2815 Shenandoah Elementary School   Regular School No Elementary PK 05 2018   grade_5                         51.0 54.0                       105.0                         51 54                 105
1791870 1791870 IN     school 1807830 4315   North Knox School Corp 180783001335 3545 North Knox Intermediate   Regular School No Elementary 03 06 2018   grade_5                         53.0 52.0                       105.0                         53 52                 105
1792388 1792388 IN     school 1802490 4660   Crown Point Community School Corp 180249000295 3773 Dwight D Eisenhower Elem School   Regular School No Elementary PK 05 2018   grade_5                         61.0 44.0                       105.0                         61 44                 105
1793269 1793269 IN     school 1810440 5255   South Madison Com Sch Corp 181044001676 5064 Maple Ridge Elementary School   Regular School No Elementary KG 06 2018   grade_5                         44.0 61.0                       105.0                         44 61                 105
1796691 1796691 IN     school 1811910 7215   Union-North United School Corp 181191002242 7400 LaVille Elementary School   Regular School No Elementary KG 06 2018   grade_5                         49.0 56.0                       105.0                         49 56                 105
1797251 1797251 IN     school 1811340 7865   Tippecanoe School Corp 181134001305 8021 Wea Ridge Elementary School   Regular School No Elementary KG 05 2018   grade_5                         53.0 52.0                       105.0                         53 52                 105
1787419 1787419 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2018   grade_5                         65.0 41.0                       106.0                         65 41                 106
1793358 1793358 IN     school 1803300 5280   Elwood Community School Corp 180330002309 5151 Elwood Intermediate School   Regular School No Elementary 03 06 2018   grade_5                         53.0 53.0                       106.0                         53 53                 106
1793450 1793450 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002349 5200 Mary Adams Elementary School   Regular School No Elementary KG 05 2018   grade_5                         47.0 59.0                       106.0                         47 59                 106
1798300 1798300 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000147 9093 Bluffton-Harrison Middle School   Regular School No Middle 05 08 2018   grade_5                         53.0 53.0                       106.0                         53 53                 106
1790443 1790443 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary School   Regular School No Elementary KG 05 2018   grade_5                         63.0 44.0                       107.0                         63 44                 107
1791579 1791579 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001766 3341 Southwestern Elementary School   Regular School No Elementary PK 05 2018   grade_5                         47.0 60.0                       107.0                         47 60                 107
1792720 1792720 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2018   grade_5                         59.0 48.0                       107.0                         59 48                 107
1794345 1794345 IN     school 1804770 5385   Indianapolis Public Schools 180477000808 5579 Carl Wilde School 79   Regular School No Elementary PK 06 2018   grade_5                         49.0 58.0                       107.0                         49 58                 107
1796501 1796501 IN     school 1810290 7205   South Bend Community School Corp 181029001650 7425 Clay International Academy   Regular School No Middle 05 08 2018   grade_5                         57.0 50.0                       107.0                         57 50                 107
1797742 1797742 IN     school 1812090 8030   Vigo County School Corp 181209001903 8511 Dixie Bee Elementary School   Regular School No Elementary KG 05 2018   grade_5                         50.0 57.0                       107.0                         50 57                 107
1798056 1798056 IN     school 1812390 8130   Warrick County School Corp 181239001984 8817 Newburgh Elementary School   Regular School No Elementary KG 05 2018   grade_5                         58.0 49.0                       107.0                         58 49                 107
1787295 1787295 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_5                         51.0 57.0                       108.0                         51 57                 108
1787899 1787899 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No Elementary PK 06 2018   grade_5                         54.0 54.0                       108.0                         54 54                 108
1789238 1789238 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000684 1569 Ireland Elementary School   Regular School No Elementary KG 05 2018   grade_5                         57.0 51.0                       108.0                         57 51                 108
1793311 1793311 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2018   grade_5                         59.0 49.0                       108.0                         59 49                 108
1794023 1794023 IN     school 1812810 5375   M S D Wayne Township 181281002031 5274 Chapelwood Elementary School   Regular School No Elementary KG 06 2018   grade_5                         57.0 51.0                       108.0                         57 51                 108
1789258 1789258 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000687 1601 Tenth Street School   Regular School No Elementary 03 05 2018   grade_5                         55.0 54.0                       109.0                         55 54                 109
1790617 1790617 IN     school 1807260 3135   Mt Vernon Community School Corp 180726002152 2558 Fortville Elementary School   Regular School No Elementary KG 05 2018   grade_5                         59.0 50.0                       109.0                         59 50                 109
1792681 1792681 IN     school 1804320 4710   School City of Hammond 180432000750 4453 Warren G Harding Elementary School   Regular School No Elementary PK 05 2018   grade_5                         66.0 43.0                       109.0                         66 43                 109
1793376 1793376 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2018   grade_5                         47.0 62.0                       109.0                         47 62                 109
1794036 1794036 IN     school 1812810 5375   M S D Wayne Township 181281002123 5446 Bridgeport Elementary School   Regular School No Elementary KG 06 2018   grade_5                         57.0 52.0                       109.0                         57 52                 109
1791337 1791337 IN     school 1801230 3640   Medora Community School Corp 180123002268 3095 Medora Elementary School   Regular School No Elementary PK 06 2018   grade_5                         5.0 6.0                       11.0                         5 6                 11
1797074 1797074 IN     school 1808160 7645   Northeast School Corp 180816001401 7941 Northeast East Elementary School   Regular School No Elementary PK 05 2018   grade_5                         6.0 5.0                       11.0                         6 5                 11
1799010 1799010 IN     school 1800152 9780   Indianapolis Academy of Excellence 180015202570 5761 Indianapolis Academy of Excellence   Regular School Yes Elementary KG 06 2018   grade_5                         5.0 6.0                       11.0                         5 6                 11
1799195 1799195 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2018   grade_5                         9.0 2.0                       11.0                         9 2                 11
1787449 1787449 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2018   grade_5                         57.0 53.0                       110.0                         57 53                 110
1787533 1787533 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2018   grade_5                         61.0 49.0                       110.0                         61 49                 110
1791877 1791877 IN     school 1810410 4325   South Knox School Corp 181041001705 3489 South Knox Elementary School   Regular School No Elementary KG 06 2018   grade_5                         55.0 55.0                       110.0                         55 55                 110
1793727 1793727 IN     school 1808910 5350   M S D Pike Township 180891001484 5357 Central Elementary School   Regular School No Elementary KG 05 2018   grade_5                         59.0 51.0                       110.0                         59 51                 110
1793976 1793976 IN     school 1812810 5375   M S D Wayne Township 181281002037 5265 Robey Elementary School   Regular School No Elementary KG 06 2018   grade_5                         55.0 55.0                       110.0                         55 55                 110
1796795 1796795 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No Middle 05 08 2018   grade_5                         61.0 49.0                       110.0                         61 49                 110
1796851 1796851 IN     school 1810140 7365   Shelbyville Central Schools 181014001632 7729 Thomas A Hendricks Elementary Sch   Regular School No Elementary PK 05 2018   grade_5                         61.0 49.0                       110.0                         61 49                 110
1796859 1796859 IN     school 1810140 7365   Shelbyville Central Schools 181014001633 7733 William F Loper Elementary School   Regular School No Elementary PK 05 2018   grade_5                         60.0 50.0                       110.0                         60 50                 110
1798049 1798049 IN     school 1812390 8130   Warrick County School Corp 181239001979 8813 Chandler Elementary School   Regular School No Elementary KG 05 2018   grade_5                         56.0 54.0                       110.0                         56 54                 110
1798748 1798748 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2018   grade_5                         55.0 55.0                       110.0                         55 55                 110
1789849 1789849 IN     school 1803700 2475   Franklin County Community Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No Elementary PK 05 2018   grade_5                         50.0 61.0                       111.0                         50 61                 111
1791376 1791376 IN     school 1810080 3675   Seymour Community Schools 181008001619 3153 Seymour-Jackson Elementary School   Regular School No Elementary PK 05 2018   grade_5                         54.0 57.0                       111.0                         54 57                 111
1793338 1793338 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2018   grade_5                         49.0 62.0                       111.0                         49 62                 111
1793967 1793967 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2018   grade_5                         60.0 51.0                       111.0                         60 51                 111
1797308 1797308 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2018   grade_5                         53.0 58.0                       111.0                         53 58                 111
1799096 1799096 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2018   grade_5                         56.0 55.0                       111.0                         56 55                 111
1793383 1793383 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2018   grade_5                         61.0 51.0                       112.0                         61 51                 112
1796383 1796383 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876000526 7383 Horizon Elementary School   Regular School No Elementary PK 05 2018   grade_5                         49.0 63.0                       112.0                         49 63                 112
1796398 1796398 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001148 7390 Northpoint Elementary School   Regular School No Elementary KG 05 2018   grade_5                         55.0 57.0                       112.0                         55 57                 112
1787612 1787612 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary School   Regular School No Elementary PK 05 2018   grade_5                         68.0 45.0                       113.0                         68 45                 113
1788231 1788231 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No Elementary PK 05 2018   grade_5                         63.0 50.0                       113.0                         63 50                 113
1788634 1788634 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary School   Regular School No Elementary PK 05 2018   grade_5                         54.0 59.0                       113.0                         54 59                 113
1788962 1788962 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000222 1351 James R Watson Elementary School   Regular School No Elementary PK 05 2018   grade_5                         47.0 66.0                       113.0                         47 66                 113
1790450 1790450 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No Elementary PK 05 2018   grade_5                         51.0 62.0                       113.0                         51 62                 113
1793630 1793630 IN     school 1808820 5340   Perry Township Schools 180882001459 5333 Glenns Valley Elementary School   Regular School No Elementary PK 05 2018   grade_5                         65.0 48.0                       113.0                         65 48                 113

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