enrollments

Data source: Big Local News · About: Big Local

974 rows where grade = "grade_5", state = "IN" and year = 2015 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 974 ✖

grade ✖

  • grade_5 · 974 ✖
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
1163107 1163107 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         1.0 0.0                       1.0                         1 0                 1
1164402 1164402 IN     school 1804620 4590   River Forest Community Sch Corp 180462000778 3797 Henry S Evans Elementary Sch   Regular School No 1.0 KG 06 2015   grade_5                         1.0 0.0                       1.0                         1 0                 1
1164413 1164413 IN     school 1804620 4590   River Forest Community Sch Corp 180462000779 3805 John I Meister Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         0.0 1.0                       1.0                         0 1                 1
1167060 1167060 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No 2.0 04 09 2015   grade_5                         1.0 0.0                       1.0                         1 0                 1
1168689 1168689 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_5                         1.0 0.0                       1.0                         1 0                 1
1166237 1166237 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_5                         9.0 1.0                       10.0                         9 1                 10
1171211 1171211 IN     school 1800129 9725   Canaan Community Academy 180012902534 3312 Canaan Community Academy   Regular School Yes 1.0 KG 06 2015   grade_5                         4.0 6.0                       10.0                         4 6                 10
1159543 1159543 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   grade_5                         58.0 42.0                       100.0                         58 42                 100
1161164 1161164 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_5                         56.0 44.0                       100.0                         56 44                 100
1162723 1162723 IN     school 1807650 3070   Noblesville Schools 180765002340 2538 Hazel Dell Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         51.0 49.0                       100.0                         51 49                 100
1162988 1162988 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000994 2706 Brown Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         57.0 43.0                       100.0                         57 43                 100
1164591 1164591 IN     school 1802490 4660   Crown Point Community Sch Corp 180249000295 3773 Dwight D Eisenhower Elem Sch   Regular School No 1.0 PK 05 2015   grade_5                         46.0 54.0                       100.0                         46 54                 100
1166200 1166200 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         54.0 46.0                       100.0                         54 46                 100
1166225 1166225 IN     school 1812810 5375   M S D Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         50.0 50.0                       100.0                         50 50                 100
1170187 1170187 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No 2.0 05 08 2015   grade_5                         58.0 42.0                       100.0                         58 42                 100
1162643 1162643 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         51.0 50.0                       101.0                         51 50                 101
1163654 1163654 IN     school 1809420 3815   Rensselaer Central School Corp 180942001545 3205 Van Rensselaer Elementary School   Regular School No 1.0 03 05 2015   grade_5                         52.0 49.0                       101.0                         52 49                 101
1165655 1165655 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No 1.0 01 06 2015   grade_5                         50.0 51.0                       101.0                         50 51                 101
1165967 1165967 IN     school 1808910 5350   M S D Pike Township 180891002250 5358 Eagle Creek Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         49.0 52.0                       101.0                         49 52                 101
1167723 1167723 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001794 6617 Spencer Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         56.0 45.0                       101.0                         56 45                 101
1171119 1171119 IN     school 1800057 9645   Challenge Foundation Academy 180005702314 5716 Avondale Meadows Academy   Regular School Yes 1.0 KG 05 2015   grade_5                         55.0 46.0                       101.0                         55 46                 101
1162884 1162884 IN     school 1800690 3180   North Harrison Com School Corp 180069000142 2621 Morgan Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         55.0 47.0                       102.0                         55 47                 102
1165529 1165529 IN     school 1800120 5265   Alexandria Com School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2015   grade_5                         47.0 55.0                       102.0                         47 55                 102
1165880 1165880 IN     school 1808820 5340   Perry Township Schools 180882001457 5338 Douglas MacArthur Elem School   Regular School No 1.0 KG 05 2015   grade_5                         49.0 53.0                       102.0                         49 53                 102
1166121 1166121 IN     school 1812720 5370   M S D Washington Township 181272002023 5430 Spring Mill Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         47.0 55.0                       102.0                         47 55                 102
1170099 1170099 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         59.0 43.0                       102.0                         59 43                 102
1166114 1166114 IN     school 1812720 5370   M S D Washington Township 181272002020 5427 Nora Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         57.0 46.0                       103.0                         57 46                 103
1168894 1168894 IN     school 1810290 7205   South Bend Community Sch Corp 181029001666 7581 Marshall Intermediate Center   Regular School No 2.0 05 08 2015   grade_5                         48.0 55.0                       103.0                         48 55                 103
1169509 1169509 IN     school 1811340 7865   Tippecanoe School Corp 181134001304 8019 Burnett Creek Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         56.0 47.0                       103.0                         56 47                 103
1160553 1160553 IN     school 1801920 1000   Clarksville Com School Corp 180192000248 851 Clarksville Middle School   Regular School No 2.0 05 08 2015   grade_5                         50.0 54.0                       104.0                         50 54                 104
1161641 1161641 IN     school 1803270 2305   Elkhart Community Schools 180327000426 1617 Cleveland Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         47.0 57.0                       104.0                         47 57                 104
1162636 1162636 IN     school 1801200 3060   Carmel Clay Schools 180120000991 2515 Prairie Trace Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         55.0 49.0                       104.0                         55 49                 104
1163021 1163021 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001567 2718 Delaware Trail Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         51.0 53.0                       104.0                         51 53                 104
1163579 1163579 IN     school 1810080 3675   Seymour Community Schools 181008001619 3153 Seymour-Jackson Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         52.0 52.0                       104.0                         52 52                 104
1163767 1163767 IN     school 1806120 3995   Madison Consolidated Schools 180612001088 3333 Emery O Muncie Elem School   Regular School No 1.0 PK 05 2015   grade_5                         58.0 46.0                       104.0                         58 46                 104
1164627 1164627 IN     school 1802490 4660   Crown Point Community Sch Corp 180249000299 3913 Timothy Ball Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         50.0 54.0                       104.0                         50 54                 104
1166192 1166192 IN     school 1812810 5375   M S D Wayne Township 181281002035 5257 McClelland Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         60.0 44.0                       104.0                         60 44                 104
1168046 1168046 IN     school 1809150 6550   Portage Township Schools 180915001508 6865 Central Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         51.0 53.0                       104.0                         51 53                 104
1169516 1169516 IN     school 1811340 7865   Tippecanoe School Corp 181134001305 8021 Wea Ridge Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         55.0 49.0                       104.0                         55 49                 104
1164061 1164061 IN     school 1807830 4315   North Knox School Corp 180783001335 3545 North Knox Intermediate   Regular School No 1.0 03 06 2015   grade_5                         43.0 62.0                       105.0                         43 62                 105
1164736 1164736 IN     school 1803870 4690   Gary Community School Corp 180387000615 4061 Beveridge Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         59.0 46.0                       105.0                         59 46                 105
1164910 1164910 IN     school 1804320 4710   School City of Hammond 180432002236 4449 Thomas A Edison Elem Sch   Regular School No 1.0 PK 05 2015   grade_5                         50.0 55.0                       105.0                         50 55                 105
1170316 1170316 IN     school 1812390 8130   Warrick County School Corp 181239001979 8813 Chandler Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         60.0 45.0                       105.0                         60 45                 105
1159711 1159711 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_5                         43.0 63.0                       106.0                         43 63                 106
1163339 1163339 IN     school 1802040 3470   Northwestern School Corp 180204000254 2904 Northwestern Elementary Sch   Regular School No 1.0 KG 06 2015   grade_5                         55.0 51.0                       106.0                         55 51                 106
1165736 1165736 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No 1.0 01 06 2015   grade_5                         60.0 46.0                       106.0                         60 46                 106
1167170 1167170 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000118 6173 Binford Elementary School   Regular School No 1.0 03 06 2015   grade_5                         60.0 46.0                       106.0                         60 46                 106
1169070 1169070 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No 2.0 05 08 2015   grade_5                         59.0 47.0                       106.0                         59 47                 106
1163003 1163003 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000045 2711 Eagle Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         61.0 46.0                       107.0                         61 46                 107
1165098 1165098 IN     school 1807350 4740   School Town of Munster 180735001254 4343 Frank H Hammond Elem Sch   Regular School No 1.0 PK 05 2015   grade_5                         46.0 61.0                       107.0                         46 61                 107
1165933 1165933 IN     school 1808910 5350   M S D Pike Township 180891002374 5352 Deer Run Elementary   Regular School No 1.0 KG 05 2015   grade_5                         56.0 51.0                       107.0                         56 51                 107
1168767 1168767 IN     school 1810290 7205   South Bend Community Sch Corp 181029001650 7425 Clay Intermediate Center   Regular School No 2.0 05 08 2015   grade_5                         45.0 62.0                       107.0                         45 62                 107
1169488 1169488 IN     school 1811340 7865   Tippecanoe School Corp 181134001826 8007 Hershey Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         54.0 53.0                       107.0                         54 53                 107
1160227 1160227 IN     school 1800570 515   Blackford County Schools 180057000108 494 North Side Elementary School   Regular School No 2.0 04 06 2015   grade_5                         57.0 51.0                       108.0                         57 51                 108
1160817 1160817 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         62.0 46.0                       108.0                         62 46                 108
1161424 1161424 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064002177 1586 Cedar Crest Intermediate School   Regular School No 2.0 05 06 2015   grade_5                         56.0 52.0                       108.0                         56 52                 108
1162586 1162586 IN     school 1801200 3060   Carmel Clay Schools 180120000200 2507 Woodbrook Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         54.0 54.0                       108.0                         54 54                 108
1165857 1165857 IN     school 1808820 5340   Perry Township Schools 180882001456 5325 Clinton Young Elem Sch   Regular School No 1.0 PK 05 2015   grade_5                         53.0 55.0                       108.0                         53 55                 108
1166093 1166093 IN     school 1812720 5370   M S D Washington Township 181272002255 5406 Crooked Creek Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         52.0 56.0                       108.0                         52 56                 108
1168812 1168812 IN     school 1810290 7205   South Bend Community Sch Corp 181029002296 7521 Brown Intermediate Center   Regular School No 1.0 03 08 2015   grade_5                         61.0 47.0                       108.0                         61 47                 108
1169672 1169672 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002507 8231 Oak Hill Elementary   Regular School No 1.0 KG 06 2015   grade_5                         51.0 57.0                       108.0                         51 57                 108
1170361 1170361 IN     school 1803000 8215   East Washington School Corp 180300000073 8906 East Washington Middle Sch   Regular School No 2.0 05 08 2015   grade_5                         51.0 57.0                       108.0                         51 57                 108
1161738 1161738 IN     school 1803270 2305   Elkhart Community Schools 180327000441 1785 Pinewood Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         49.0 60.0                       109.0                         49 60                 109
1165618 1165618 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No 1.0 01 06 2015   grade_5                         50.0 59.0                       109.0                         50 59                 109
1165699 1165699 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002222 5202 Arlington Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         54.0 55.0                       109.0                         54 55                 109
1165799 1165799 IN     school 1805670 5330   M S D Lawrence Township 180567001033 5296 Oaklandon Elementary School   Regular School No 1.0 01 06 2015   grade_5                         52.0 57.0                       109.0                         52 57                 109
1162116 1162116 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         3.0 8.0                       11.0                         3 8                 11
1162045 1162045 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000589 2123 Brookville Middle Sch   Regular School No 2.0 05 08 2015   grade_5                         55.0 55.0                       110.0                         55 55                 110
1169888 1169888 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000489 8381 West Terrace Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         59.0 51.0                       110.0                         59 51                 110
1163014 1163014 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102002430 2714 Reagan Elementary   Regular School No 1.0 KG 05 2015   grade_5                         49.0 62.0                       111.0                         49 62                 111
1163358 1163358 IN     school 1803150 3480   Eastern Howard School Corp 180315000412 2909 Eastern Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         50.0 61.0                       111.0                         50 61                 111
1165743 1165743 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_5                         58.0 53.0                       111.0                         58 53                 111
1166217 1166217 IN     school 1812810 5375   M S D Wayne Township 181281000238 5267 North Wayne Elem School   Regular School No 1.0 KG 06 2015   grade_5                         56.0 55.0                       111.0                         56 55                 111
1162715 1162715 IN     school 1807650 3070   Noblesville Schools 180765002414 2537 Noble Crossing Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         51.0 61.0                       112.0                         51 61                 112
1164925 1164925 IN     school 1804320 4710   School City of Hammond 180432000750 4453 Warren G Harding Elem Sch   Regular School No 1.0 PK 05 2015   grade_5                         56.0 56.0                       112.0                         56 56                 112
1164964 1164964 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elem Sch   Regular School No 1.0 PK 05 2015   grade_5                         59.0 53.0                       112.0                         59 53                 112
1165438 1165438 IN     school 1806900 5085   Mitchell Community Schools 180690001194 4861 Burris Elementary School   Regular School No 1.0 03 05 2015   grade_5                         57.0 55.0                       112.0                         57 55                 112
1165974 1165974 IN     school 1808910 5350   M S D Pike Township 180891001485 5359 Eastbrook Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         57.0 55.0                       112.0                         57 55                 112
1167978 1167978 IN     school 1809180 6520   Porter Township School Corp 180918001520 6837 Boone Grove Elementary School   Regular School No 2.0 04 05 2015   grade_5                         56.0 56.0                       112.0                         56 56                 112
1163032 1163032 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001671 2723 White Lick Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         60.0 53.0                       113.0                         60 53                 113
1163841 1163841 IN     school 1805190 4015   Jennings County Schools 180519000924 3397 North Vernon Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         59.0 55.0                       114.0                         59 55                 114
1165813 1165813 IN     school 1805670 5330   M S D Lawrence Township 180567001066 5299 Sunnyside Elementary Sch   Regular School No 1.0 01 06 2015   grade_5                         71.0 43.0                       114.0                         71 43                 114
1170652 1170652 IN     school 1811580 8565   Twin Lakes School Corp 181158001860 9163 Meadowlawn Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         56.0 58.0                       114.0                         56 58                 114
1162628 1162628 IN     school 1801200 3060   Carmel Clay Schools 180120002267 2513 Orchard Park Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         51.0 64.0                       115.0                         51 64                 115
1162707 1162707 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         56.0 59.0                       115.0                         56 59                 115
1165483 1165483 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002052 5025 Lapel Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         56.0 59.0                       115.0                         56 59                 115
1165865 1165865 IN     school 1808820 5340   Perry Township Schools 180882001459 5333 Glenns Valley Elem Sch   Regular School No 1.0 PK 05 2015   grade_5                         54.0 61.0                       115.0                         54 61                 115
1159966 1159966 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No 1.0 03 06 2015   grade_5                         53.0 63.0                       116.0                         53 63                 116
1163226 1163226 IN     school 1808280 3435   Shenandoah School Corporation 180828002356 2815 Shenandoah Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         51.0 65.0                       116.0                         51 65                 116
1165600 1165600 IN     school 1803300 5280   Elwood Community School Corp 180330002309 5151 Elwood Intermediate School   Regular School No 1.0 03 06 2015   grade_5                         65.0 51.0                       116.0                         65 51                 116
1170330 1170330 IN     school 1812390 8130   Warrick County School Corp 181239002179 8819 Sharon Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         49.0 67.0                       116.0                         49 67                 116
1162776 1162776 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_5                         69.0 48.0                       117.0                         69 48                 117
1163780 1163780 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001766 3341 Southwestern Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         66.0 51.0                       117.0                         66 51                 117
1164406 1164406 IN     school 1804620 4590   River Forest Community Sch Corp 180462000780 3801 River Forest Intermediate   Regular School No 2.0 05 06 2015   grade_5                         53.0 64.0                       117.0                         53 64                 117
1165465 1165465 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002049 5009 Frankton Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         68.0 49.0                       117.0                         68 49                 117
1170008 1170008 IN     school 1812090 8030   Vigo County School Corp 181209001903 8511 Dixie Bee Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         57.0 60.0                       117.0                         57 60                 117
1165777 1165777 IN     school 1805670 5330   M S D Lawrence Township 180567002278 5293 Indian Creek Elem Sch   Regular School No 1.0 01 06 2015   grade_5                         59.0 59.0                       118.0                         59 59                 118
1166248 1166248 IN     school 1812810 5375   M S D Wayne Township 181281002042 5273 Westlake Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         61.0 57.0                       118.0                         61 57                 118
1168216 1168216 IN     school 1807110 6620   Eastern Pulaski Com Sch Corp 180711001204 6994 Eastern Pulaski Elem Sch   Regular School No 1.0 PK 05 2015   grade_5                         61.0 57.0                       118.0                         61 57                 118
1170138 1170138 IN     school 1806270 8045   Manchester Community Schools 180627001102 8645 Manchester Intermediate School   Regular School No 2.0 04 06 2015   grade_5                         48.0 70.0                       118.0                         48 70                 118

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