enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 1,060 ✖

grade ✖

  • grade_2 · 1,060 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total ▼ white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1169095 1169095 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_2                         0.0 1.0                       1.0                         0 1                 1
1159467 1159467 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         50.0 50.0                       100.0                         50 50                 100
1159590 1159590 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         58.0 42.0                       100.0                         58 42                 100
1162794 1162794 IN     school 1804050 3125   Greenfield-Central Com Schools 180405001665 2588 J B Stephens Elementary School   Regular School No 1.0 PK 03 2015   grade_2                         48.0 52.0                       100.0                         48 52                 100
1162843 1162843 IN     school 1807260 3135   Mt Vernon Community Sch Corp 180726002192 2570 McCordsville Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         52.0 48.0                       100.0                         52 48                 100
1163011 1163011 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102002430 2714 Reagan Elementary   Regular School No 1.0 KG 05 2015   grade_2                         56.0 44.0                       100.0                         56 44                 100
1163558 1163558 IN     school 1810080 3675   Seymour Community Schools 181008001617 3135 Margaret R Brown Elem School   Regular School No 1.0 KG 05 2015   grade_2                         56.0 44.0                       100.0                         56 44                 100
1163973 1163973 IN     school 1803690 4225   Franklin Community School Corp 180369000584 3461 Northwood Elementary School   Regular School No 1.0 PK 04 2015   grade_2                         55.0 45.0                       100.0                         55 45                 100
1170572 1170572 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000149 9098 Bluffton-Harrison Elem Sch   Regular School No 1.0 KG 04 2015   grade_2                         54.0 46.0                       100.0                         54 46                 100
1170994 1170994 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2015   grade_2                         50.0 50.0                       100.0                         50 50                 100
1159757 1159757 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elem Sch   Regular School No 1.0 KG 05 2015   grade_2                         48.0 53.0                       101.0                         48 53                 101
1160231 1160231 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No 1.0 KG 03 2015   grade_2                         53.0 48.0                       101.0                         53 48                 101
1160906 1160906 IN     school 1807710 1375   North Daviess Com Schools 180771001648 1090 North Daviess Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         58.0 43.0                       101.0                         58 43                 101
1161563 1161563 IN     school 1802400 2270   Concord Community Schools 180240000274 1729 Concord West Side Elem School   Regular School No 1.0 KG 04 2015   grade_2                         56.0 45.0                       101.0                         56 45                 101
1161709 1161709 IN     school 1803270 2305   Elkhart Community Schools 180327000434 1769 Mary Beck Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         56.0 45.0                       101.0                         56 45                 101
1162697 1162697 IN     school 1807650 3070   Noblesville Schools 180765001311 2529 North Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         51.0 50.0                       101.0                         51 50                 101
1165906 1165906 IN     school 1808820 5340   Perry Township Schools 180882001687 5366 Jeremiah Gray-Edison Elem   Regular School No 1.0 PK 05 2015   grade_2                         57.0 44.0                       101.0                         57 44                 101
1160407 1160407 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         56.0 46.0                       102.0                         56 46                 102
1161611 1161611 IN     school 1812240 2285   Wa-Nee Community Schools 181224000028 1735 Wakarusa Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         54.0 48.0                       102.0                         54 48                 102
1162338 1162338 IN     school 1805910 2950   Linton-Stockton School Corp 180591001048 2441 Linton-Stockton Elementary   Regular School No 1.0 KG 05 2015   grade_2                         52.0 50.0                       102.0                         52 50                 102
1162625 1162625 IN     school 1801200 3060   Carmel Clay Schools 180120002267 2513 Orchard Park Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         48.0 54.0                       102.0                         48 54                 102
1163000 1163000 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000045 2711 Eagle Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         49.0 53.0                       102.0                         49 53                 102
1163223 1163223 IN     school 1808280 3435   Shenandoah School Corporation 180828002356 2815 Shenandoah Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         48.0 54.0                       102.0                         48 54                 102
1164049 1164049 IN     school 1807830 4315   North Knox School Corp 180783001332 3521 North Knox Primary School   Regular School No 1.0 KG 02 2015   grade_2                         54.0 48.0                       102.0                         54 48                 102
1164559 1164559 IN     school 1805460 4650   Lake Ridge Schools 180546000993 3885 Longfellow Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         57.0 45.0                       102.0                         57 45                 102
1165622 1165622 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No 1.0 01 06 2015   grade_2                         47.0 55.0                       102.0                         47 55                 102
1165781 1165781 IN     school 1805670 5330   M S D Lawrence Township 180567000150 5294 Forest Glen Elem Sch   Regular School No 1.0 KG 06 2015   grade_2                         54.0 48.0                       102.0                         54 48                 102
1166473 1166473 IN     school 1804770 5385   Indianapolis Public Schools 180477002404 5551 James Russell Lowell School 51   Regular School No 1.0 PK 06 2015   grade_2                         56.0 46.0                       102.0                         56 46                 102
1169520 1169520 IN     school 1811340 7865   Tippecanoe School Corp 181134001821 8024 Battle Ground Elem Sch   Regular School No 1.0 KG 05 2015   grade_2                         50.0 52.0                       102.0                         50 52                 102
1162520 1162520 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   grade_2                         61.0 42.0                       103.0                         61 42                 103
1162617 1162617 IN     school 1801200 3060   Carmel Clay Schools 180120000036 2512 Smoky Row Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         48.0 55.0                       103.0                         48 55                 103
1165513 1165513 IN     school 1810440 5255   South Madison Com Sch Corp 181044001676 5064 Maple Ridge Elementary Sch   Regular School No 1.0 KG 06 2015   grade_2                         49.0 54.0                       103.0                         49 54                 103
1168773 1168773 IN     school 1810290 7205   South Bend Community Sch Corp 181029001651 7435 Darden Primary Center   Regular School No 1.0 PK 04 2015   grade_2                         58.0 45.0                       103.0                         58 45                 103
1169064 1169064 IN     school 1808310 7350   Northwestern Con School Corp 180831001424 7691 Triton Central Elementary School   Regular School No 1.0 PK 04 2015   grade_2                         53.0 50.0                       103.0                         53 50                 103
1160291 1160291 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No 1.0 PK 04 2015   grade_2                         49.0 55.0                       104.0                         49 55                 104
1160298 1160298 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No 1.0 KG 04 2015   grade_2                         45.0 59.0                       104.0                         45 59                 104
1161445 1161445 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001236 1590 Huntingburg Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         59.0 45.0                       104.0                         59 45                 104
1162704 1162704 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         50.0 54.0                       104.0                         50 54                 104
1163884 1163884 IN     school 1801440 4205   Center Grove Com Sch Corp 180144000662 3434 Sugar Grove Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         50.0 54.0                       104.0                         50 54                 104
1165810 1165810 IN     school 1805670 5330   M S D Lawrence Township 180567001066 5299 Sunnyside Elementary Sch   Regular School No 1.0 01 06 2015   grade_2                         49.0 55.0                       104.0                         49 55                 104
1166189 1166189 IN     school 1812810 5375   M S D Wayne Township 181281002035 5257 McClelland Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         52.0 52.0                       104.0                         52 52                 104
1167463 1167463 IN     school 1807140 5930   Mooresville Con School Corp 180714001210 6385 North Madison Elem Sch   Regular School No 1.0 KG 06 2015   grade_2                         45.0 59.0                       104.0                         45 59                 104
1168876 1168876 IN     school 1810290 7205   South Bend Community Sch Corp 181029001673 7569 McKinley Primary Center   Regular School No 1.0 KG 04 2015   grade_2                         61.0 43.0                       104.0                         61 43                 104
1170320 1170320 IN     school 1812390 8130   Warrick County School Corp 181239001984 8817 Newburgh Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         62.0 42.0                       104.0                         62 42                 104
1162773 1162773 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_2                         56.0 49.0                       105.0                         56 49                 105
1165898 1165898 IN     school 1808820 5340   Perry Township Schools 180882001470 5351 Winchester Village Elementary   Regular School No 1.0 PK 05 2015   grade_2                         57.0 48.0                       105.0                         57 48                 105
1170096 1170096 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         57.0 48.0                       105.0                         57 48                 105
1159780 1159780 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         56.0 50.0                       106.0                         56 50                 106
1161784 1161784 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         62.0 44.0                       106.0                         62 44                 106
1163036 1163036 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001570 2727 Cardinal Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         56.0 50.0                       106.0                         56 50                 106
1164489 1164489 IN     school 1805450 4615   Lake Central School Corp 180545000981 3840 James H Watson Elem Sch   Regular School No 1.0 PK 04 2015   grade_2                         56.0 50.0                       106.0                         56 50                 106
1166465 1166465 IN     school 1804770 5385   Indianapolis Public Schools 180477000904 5549 William Penn School 49   Regular School No 1.0 KG 06 2015   grade_2                         56.0 50.0                       106.0                         56 50                 106
1169885 1169885 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000489 8381 West Terrace Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         48.0 58.0                       106.0                         48 58                 106
1170944 1170944 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2015   grade_2                         50.0 56.0                       106.0                         50 56                 106
1160105 1160105 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elem School   Regular School No 1.0 KG 06 2015   grade_2                         55.0 52.0                       107.0                         55 52                 107
1163153 1163153 IN     school 1808970 3330   Plainfield Community Sch Corp 180897001495 2761 Van Buren Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         62.0 45.0                       107.0                         62 45                 107
1164435 1164435 IN     school 1809690 4600   Merrillville Community School 180969001583 3822 Homer Iddings Elem Sch   Regular School No 1.0 KG 04 2015   grade_2                         45.0 62.0                       107.0                         45 62                 107
1164907 1164907 IN     school 1804320 4710   School City of Hammond 180432002236 4449 Thomas A Edison Elem Sch   Regular School No 1.0 PK 05 2015   grade_2                         60.0 47.0                       107.0                         60 47                 107
1165578 1165578 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         52.0 55.0                       107.0                         52 55                 107
1171501 1171501 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes 1.0 KG 04 2015   grade_2                         61.0 46.0                       107.0                         61 46                 107
1161470 1161470 IN     school 1803960 2120   Greater Jasper Con Schs 180396000683 1597 Fifth Street Elementary Sch   Regular School No 1.0 PK 02 2015   grade_2                         54.0 54.0                       108.0                         54 54                 108
1165604 1165604 IN     school 1803300 5280   Elwood Community School Corp 180330000448 5157 Elwood Elementary School   Regular School No 1.0 PK 02 2015   grade_2                         50.0 58.0                       108.0                         50 58                 108
1169513 1169513 IN     school 1811340 7865   Tippecanoe School Corp 181134001305 8021 Wea Ridge Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         51.0 57.0                       108.0                         51 57                 108
1162739 1162739 IN     school 1807650 3070   Noblesville Schools 180765001246 2547 White River Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         56.0 53.0                       109.0                         56 53                 109
1163355 1163355 IN     school 1803150 3480   Eastern Howard School Corp 180315000412 2909 Eastern Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         54.0 55.0                       109.0                         54 55                 109
1163986 1163986 IN     school 1803690 4225   Franklin Community School Corp 180369001030 3467 Creekside Elementary Sch   Regular School No 1.0 KG 04 2015   grade_2                         57.0 52.0                       109.0                         57 52                 109
1164961 1164961 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elem Sch   Regular School No 1.0 PK 05 2015   grade_2                         52.0 57.0                       109.0                         52 57                 109
1170057 1170057 IN     school 1812090 8030   Vigo County School Corp 181209001909 8549 Lost Creek Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         45.0 64.0                       109.0                         45 64                 109
1163538 1163538 IN     school 1801230 3640   Medora Community School Corp 180123002268 3095 Medora Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         7.0 4.0                       11.0                         7 4                 11
1170208 1170208 IN     school 1806080 8115   M S D Warren County 180608001072 8733 Pine Village Elementary Sch   Regular School No 1.0 KG 06 2015   grade_2                         7.0 4.0                       11.0                         7 4                 11
1161161 1161161 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_2                         45.0 65.0                       110.0                         45 65                 110
1165462 1165462 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002049 5009 Frankton Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         59.0 51.0                       110.0                         59 51                 110
1160547 1160547 IN     school 1801920 1000   Clarksville Com School Corp 180192000251 845 Clarksville Elementary School   Regular School No 1.0 PK 04 2015   grade_2                         57.0 54.0                       111.0                         57 54                 111
1162647 1162647 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         50.0 61.0                       111.0                         50 61                 111
1165971 1165971 IN     school 1808910 5350   M S D Pike Township 180891001485 5359 Eastbrook Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         59.0 52.0                       111.0                         59 52                 111
1161905 1161905 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001267 1929 Georgetown Elementary School   Regular School No 1.0 KG 04 2015   grade_2                         59.0 53.0                       112.0                         59 53                 112
1163576 1163576 IN     school 1810080 3675   Seymour Community Schools 181008001619 3153 Seymour-Jackson Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         53.0 59.0                       112.0                         53 59                 112
1164884 1164884 IN     school 1804320 4710   School City of Hammond 180432002413 4422 Joseph Hess Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         56.0 56.0                       112.0                         56 56                 112
1165488 1165488 IN     school 1810440 5255   South Madison Com Sch Corp 181044002167 4935 East Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         59.0 53.0                       112.0                         59 53                 112
1165571 1165571 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         61.0 51.0                       112.0                         61 51                 112
1165652 1165652 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No 1.0 01 06 2015   grade_2                         57.0 55.0                       112.0                         57 55                 112
1165862 1165862 IN     school 1808820 5340   Perry Township Schools 180882001459 5333 Glenns Valley Elem Sch   Regular School No 1.0 PK 05 2015   grade_2                         60.0 52.0                       112.0                         60 52                 112
1166163 1166163 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         51.0 61.0                       112.0                         51 61                 112
1166245 1166245 IN     school 1812810 5375   M S D Wayne Township 181281002042 5273 Westlake Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         52.0 60.0                       112.0                         52 60                 112
1159489 1159489 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No 1.0 02 04 2015   grade_2                         54.0 59.0                       113.0                         54 59                 113
1162712 1162712 IN     school 1807650 3070   Noblesville Schools 180765002414 2537 Noble Crossing Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         55.0 58.0                       113.0                         55 58                 113
1163600 1163600 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         62.0 51.0                       113.0                         62 51                 113
1164065 1164065 IN     school 1810410 4325   South Knox School Corp 181041001705 3489 South Knox Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         53.0 60.0                       113.0                         53 60                 113
1164790 1164790 IN     school 1803870 4690   Gary Community School Corp 180387002102 4155 Glen Park Acad for Excel in Lrn   Regular School No 1.0 KG 06 2015   grade_2                         63.0 50.0                       113.0                         63 50                 113
1167346 1167346 IN     school 1804140 5900   Monroe-Gregg School District 180414000715 6323 Monrovia Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         57.0 56.0                       113.0                         57 56                 113
1167882 1167882 IN     school 1800750 6460   M S D Boone Township 180075000152 6815 Hebron Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         53.0 60.0                       113.0                         53 60                 113
1162051 1162051 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No 1.0 PK 04 2015   grade_2                         56.0 58.0                       114.0                         56 58                 114
1162590 1162590 IN     school 1801200 3060   Carmel Clay Schools 180120002332 2508 Cherry Tree Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         52.0 62.0                       114.0                         52 62                 114
1162728 1162728 IN     school 1807650 3070   Noblesville Schools 180765002546 2539 Promise Road Elementary   Regular School No 1.0 KG 05 2015   grade_2                         62.0 52.0                       114.0                         62 52                 114
1166206 1166206 IN     school 1812810 5375   M S D Wayne Township 181281002037 5265 Robey Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         54.0 60.0                       114.0                         54 60                 114
1167672 1167672 IN     school 1808640 6155   Paoli Community School Corp 180864001439 6587 Throop Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         61.0 53.0                       114.0                         61 53                 114
1163926 1163926 IN     school 1801440 4205   Center Grove Com Sch Corp 180144002333 3444 Pleasant Grove Elem Sch   Regular School No 1.0 KG 05 2015   grade_2                         57.0 58.0                       115.0                         57 58                 115
1165733 1165733 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No 1.0 01 06 2015   grade_2                         54.0 61.0                       115.0                         54 61                 115
1165757 1165757 IN     school 1805670 5330   M S D Lawrence Township 180567002339 5287 Amy Beverland Elementary   Regular School No 1.0 01 06 2015   grade_2                         68.0 47.0                       115.0                         68 47                 115
1166172 1166172 IN     school 1812810 5375   M S D Wayne Township 181281002030 5227 Chapel Glen Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         68.0 47.0                       115.0                         68 47                 115

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