enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 1,060 ✖

grade ✖

  • grade_4 · 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
1160680 1160680 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_4                         1.0 0.0                       1.0                         1 0                 1
1161573 1161573 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No 2.0 04 09 2015   grade_4                         1.0 0.0                       1.0                         1 0                 1
1161602 1161602 IN     school 1806600 2275   Middlebury Community Schools 180660000199 1734 Orchard View Sch   Regular School No 1.0 KG 04 2015   grade_4                         1.0 0.0                       1.0                         1 0                 1
1163106 1163106 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         0.0 1.0                       1.0                         0 1                 1
1163117 1163117 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No 2.0 04 08 2015   grade_4                         0.0 1.0                       1.0                         0 1                 1
1163374 1163374 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   grade_4                         0.0 1.0                       1.0                         0 1                 1
1167059 1167059 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No 2.0 04 09 2015   grade_4                         0.0 1.0                       1.0                         0 1                 1
1171232 1171232 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes 1.0 KG 08 2015   grade_4                         8.0 2.0                       10.0                         8 2                 10
1171469 1171469 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_4                         9.0 1.0                       10.0                         9 1                 10
1160430 1160430 IN     school 1810680 815   Southeastern School Corp 181068001754 673 Galveston Elementary School   Regular School No 2.0 04 06 2015   grade_4                         52.0 48.0                       100.0                         52 48                 100
1162642 1162642 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         51.0 49.0                       100.0                         51 49                 100
1165669 1165669 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002409 5194 South Creek Elementary   Regular School No 1.0 KG 05 2015   grade_4                         56.0 44.0                       100.0                         56 44                 100
1165879 1165879 IN     school 1808820 5340   Perry Township Schools 180882001457 5338 Douglas MacArthur Elem School   Regular School No 1.0 KG 05 2015   grade_4                         54.0 46.0                       100.0                         54 46                 100
1169375 1169375 IN     school 1810860 7715   Southwest School Corp 181086001771 7965 Sullivan Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         54.0 46.0                       100.0                         54 46                 100
1169436 1169436 IN     school 1805400 7855   Lafayette School Corporation 180540000971 8103 Miami Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         49.0 51.0                       100.0                         49 51                 100
1159510 1159510 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_4                         50.0 51.0                       101.0                         50 51                 101
1165634 1165634 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elem Sch   Regular School No 1.0 01 06 2015   grade_4                         54.0 47.0                       101.0                         54 47                 101
1165735 1165735 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No 1.0 01 06 2015   grade_4                         53.0 48.0                       101.0                         53 48                 101
1166039 1166039 IN     school 1812360 5360   M S D Warren Township 181236001966 5375 Lakeside Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         47.0 54.0                       101.0                         47 54                 101
1169424 1169424 IN     school 1805400 7855   Lafayette School Corporation 180540000963 8089 Edgelea Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         55.0 46.0                       101.0                         55 46                 101
1170315 1170315 IN     school 1812390 8130   Warrick County School Corp 181239001979 8813 Chandler Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         43.0 58.0                       101.0                         43 58                 101
1159608 1159608 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         50.0 52.0                       102.0                         50 52                 102
1160300 1160300 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No 1.0 KG 04 2015   grade_4                         44.0 58.0                       102.0                         44 58                 102
1162706 1162706 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         56.0 46.0                       102.0                         56 46                 102
1163913 1163913 IN     school 1801440 4205   Center Grove Com Sch Corp 180144000211 3440 North Grove Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         65.0 37.0                       102.0                         65 37                 102
1164590 1164590 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_4                         55.0 47.0                       102.0                         55 47                 102
1165553 1165553 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         46.0 56.0                       102.0                         46 56                 102
1166174 1166174 IN     school 1812810 5375   M S D Wayne Township 181281002030 5227 Chapel Glen Elementary School   Regular School No 1.0 KG 06 2015   grade_4                         58.0 44.0                       102.0                         58 44                 102
1159759 1159759 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elem Sch   Regular School No 1.0 KG 05 2015   grade_4                         50.0 53.0                       103.0                         50 53                 103
1160293 1160293 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         55.0 48.0                       103.0                         55 48                 103
1165713 1165713 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000596 5205 Bunker Hill Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         51.0 52.0                       103.0                         51 52                 103
1165973 1165973 IN     school 1808910 5350   M S D Pike Township 180891001485 5359 Eastbrook Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         52.0 51.0                       103.0                         52 51                 103
1159491 1159491 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No 1.0 02 04 2015   grade_4                         42.0 62.0                       104.0                         42 62                 104
1159946 1159946 IN     school 1803630 235   Fort Wayne Community Schools 180363000540 270 Lincoln Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         49.0 55.0                       104.0                         49 55                 104
1162535 1162535 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   grade_4                         57.0 47.0                       104.0                         57 47                 104
1162730 1162730 IN     school 1807650 3070   Noblesville Schools 180765002546 2539 Promise Road Elementary   Regular School No 1.0 KG 05 2015   grade_4                         42.0 62.0                       104.0                         42 62                 104
1165528 1165528 IN     school 1800120 5265   Alexandria Com School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2015   grade_4                         47.0 57.0                       104.0                         47 57                 104
1166045 1166045 IN     school 1812360 5360   M S D Warren Township 181236001967 5377 Lowell Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         54.0 50.0                       104.0                         54 50                 104
1168775 1168775 IN     school 1810290 7205   South Bend Community Sch Corp 181029001651 7435 Darden Primary Center   Regular School No 1.0 PK 04 2015   grade_4                         56.0 48.0                       104.0                         56 48                 104
1169887 1169887 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000489 8381 West Terrace Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         48.0 56.0                       104.0                         48 56                 104
1163155 1163155 IN     school 1808970 3330   Plainfield Community Sch Corp 180897001495 2761 Van Buren Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         53.0 52.0                       105.0                         53 52                 105
1163766 1163766 IN     school 1806120 3995   Madison Consolidated Schools 180612001088 3333 Emery O Muncie Elem School   Regular School No 1.0 PK 05 2015   grade_4                         48.0 57.0                       105.0                         48 57                 105
1163840 1163840 IN     school 1805190 4015   Jennings County Schools 180519000924 3397 North Vernon Elementary School   Regular School No 1.0 KG 06 2015   grade_4                         57.0 48.0                       105.0                         57 48                 105
1164060 1164060 IN     school 1807830 4315   North Knox School Corp 180783001335 3545 North Knox Intermediate   Regular School No 1.0 03 06 2015   grade_4                         47.0 58.0                       105.0                         47 58                 105
1166071 1166071 IN     school 1812360 5360   M S D Warren Township 181236001690 5397 Liberty Park Elementary Sch   Regular School No 1.0 KG 04 2015   grade_4                         58.0 47.0                       105.0                         58 47                 105
1168841 1168841 IN     school 1810290 7205   South Bend Community Sch Corp 181029001646 7545 Harrison Primary Center   Regular School No 1.0 KG 04 2015   grade_4                         52.0 53.0                       105.0                         52 53                 105
1159518 1159518 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         52.0 54.0                       106.0                         52 54                 106
1162619 1162619 IN     school 1801200 3060   Carmel Clay Schools 180120000036 2512 Smoky Row Elementary Sch   Regular School No 1.0 PK 05 2015   grade_4                         52.0 54.0                       106.0                         52 54                 106
1163602 1163602 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         58.0 48.0                       106.0                         58 48                 106
1163779 1163779 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001766 3341 Southwestern Elementary Sch   Regular School No 1.0 PK 05 2015   grade_4                         58.0 48.0                       106.0                         58 48                 106
1163928 1163928 IN     school 1801440 4205   Center Grove Com Sch Corp 180144002333 3444 Pleasant Grove Elem Sch   Regular School No 1.0 KG 05 2015   grade_4                         56.0 50.0                       106.0                         56 50                 106
1164437 1164437 IN     school 1809690 4600   Merrillville Community School 180969001583 3822 Homer Iddings Elem Sch   Regular School No 1.0 KG 04 2015   grade_4                         56.0 50.0                       106.0                         56 50                 106
1165097 1165097 IN     school 1807350 4740   School Town of Munster 180735001254 4343 Frank H Hammond Elem Sch   Regular School No 1.0 PK 05 2015   grade_4                         55.0 51.0                       106.0                         55 51                 106
1165482 1165482 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002052 5025 Lapel Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         46.0 60.0                       106.0                         46 60                 106
1165959 1165959 IN     school 1808910 5350   M S D Pike Township 180891001484 5357 Central Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         56.0 50.0                       106.0                         56 50                 106
1170098 1170098 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         63.0 43.0                       106.0                         63 43                 106
1159710 1159710 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_4                         50.0 57.0                       107.0                         50 57                 107
1161171 1161171 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000225 1357 McKenney-Harrison Elem School   Regular School No 1.0 KG 05 2015   grade_4                         59.0 48.0                       107.0                         59 48                 107
1161553 1161553 IN     school 1802400 2270   Concord Community Schools 180240000272 1723 Concord Ox-Bow Elementary Sch   Regular School No 1.0 KG 04 2015   grade_4                         50.0 57.0                       107.0                         50 57                 107
1162775 1162775 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_4                         54.0 53.0                       107.0                         54 53                 107
1163002 1163002 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000045 2711 Eagle Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         54.0 53.0                       107.0                         54 53                 107
1163357 1163357 IN     school 1803150 3480   Eastern Howard School Corp 180315000412 2909 Eastern Elementary School   Regular School No 1.0 PK 06 2015   grade_4                         52.0 55.0                       107.0                         52 55                 107
1166113 1166113 IN     school 1812720 5370   M S D Washington Township 181272002020 5427 Nora Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         52.0 55.0                       107.0                         52 55                 107
1170540 1170540 IN     school 1808220 8435   Northern Wells Com Schools 180822001411 9081 Ossian Elementary   Regular School No 1.0 KG 05 2015   grade_4                         56.0 51.0                       107.0                         56 51                 107
1160409 1160409 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         53.0 55.0                       108.0                         53 55                 108
1163100 1163100 IN     school 1800270 3315   Avon Community School Corp 180027001675 2740 Hickory Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         48.0 60.0                       108.0                         48 60                 108
1166120 1166120 IN     school 1812720 5370   M S D Washington Township 181272002023 5430 Spring Mill Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         63.0 45.0                       108.0                         63 45                 108
1170195 1170195 IN     school 1812150 8060   Wabash City Schools 181215001937 8706 O J Neighbours Elem Sch   Regular School No 1.0 PK 04 2015   grade_4                         61.0 47.0                       108.0                         61 47                 108
1161240 1161240 IN     school 1805880 1895   Liberty-Perry Com School Corp 180588001045 1381 Selma Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         58.0 51.0                       109.0                         58 51                 109
1161737 1161737 IN     school 1803270 2305   Elkhart Community Schools 180327000441 1785 Pinewood Elementary School   Regular School No 1.0 KG 06 2015   grade_4                         60.0 49.0                       109.0                         60 49                 109
1162340 1162340 IN     school 1805910 2950   Linton-Stockton School Corp 180591001048 2441 Linton-Stockton Elementary   Regular School No 1.0 KG 05 2015   grade_4                         62.0 47.0                       109.0                         62 47                 109
1165864 1165864 IN     school 1808820 5340   Perry Township Schools 180882001459 5333 Glenns Valley Elem Sch   Regular School No 1.0 PK 05 2015   grade_4                         56.0 53.0                       109.0                         56 53                 109
1169134 1169134 IN     school 1810140 7365   Shelbyville Central Schools 181014001633 7733 William F Loper Elem Sch   Regular School No 1.0 PK 05 2015   grade_4                         62.0 47.0                       109.0                         62 47                 109
1170322 1170322 IN     school 1812390 8130   Warrick County School Corp 181239001984 8817 Newburgh Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         44.0 65.0                       109.0                         44 65                 109
1162104 1162104 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2015   grade_4                         5.0 6.0                       11.0                         5 6                 11
1160473 1160473 IN     school 1806030 875   Logansport Community Sch Corp 180603002366 711 Landis Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         56.0 54.0                       110.0                         56 54                 110
1164485 1164485 IN     school 1805450 4615   Lake Central School Corp 180545000980 3839 George Bibich Elementary Sch   Regular School No 1.0 KG 04 2015   grade_4                         52.0 58.0                       110.0                         52 58                 110
1165599 1165599 IN     school 1803300 5280   Elwood Community School Corp 180330002309 5151 Elwood Intermediate School   Regular School No 1.0 03 06 2015   grade_4                         63.0 47.0                       110.0                         63 47                 110
1167348 1167348 IN     school 1804140 5900   Monroe-Gregg School District 180414000715 6323 Monrovia Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         63.0 47.0                       110.0                         63 47                 110
1170353 1170353 IN     school 1803000 8215   East Washington School Corp 180300002195 8904 East Washington Elem Sch   Regular School No 1.0 KG 04 2015   grade_4                         52.0 58.0                       110.0                         52 58                 110
1161907 1161907 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001267 1929 Georgetown Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         55.0 56.0                       111.0                         55 56                 111
1162741 1162741 IN     school 1807650 3070   Noblesville Schools 180765001246 2547 White River Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         69.0 42.0                       111.0                         69 42                 111
1165798 1165798 IN     school 1805670 5330   M S D Lawrence Township 180567001033 5296 Oaklandon Elementary School   Regular School No 1.0 01 06 2015   grade_4                         57.0 54.0                       111.0                         57 54                 111
1163225 1163225 IN     school 1808280 3435   Shenandoah School Corporation 180828002356 2815 Shenandoah Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         58.0 54.0                       112.0                         58 54                 112
1165848 1165848 IN     school 1808820 5340   Perry Township Schools 180882002280 5322 Mary Bryan Elementary Sch   Regular School No 1.0 PK 05 2015   grade_4                         59.0 53.0                       112.0                         59 53                 112
1166182 1166182 IN     school 1812810 5375   M S D Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No 1.0 PK 06 2015   grade_4                         54.0 58.0                       112.0                         54 58                 112
1169515 1169515 IN     school 1811340 7865   Tippecanoe School Corp 181134001305 8021 Wea Ridge Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         62.0 50.0                       112.0                         62 50                 112
1170574 1170574 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000149 9098 Bluffton-Harrison Elem Sch   Regular School No 1.0 KG 04 2015   grade_4                         52.0 60.0                       112.0                         52 60                 112
1164524 1164524 IN     school 1811460 4645   Tri-Creek School Corporation 181146001853 3753 Oak Hill Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         60.0 53.0                       113.0                         60 53                 113
1165684 1165684 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002113 5198 Thompson Crossing Elementary Schl   Regular School No 1.0 KG 05 2015   grade_4                         52.0 61.0                       113.0                         52 61                 113
1165872 1165872 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elem Sch   Regular School No 1.0 KG 05 2015   grade_4                         62.0 51.0                       113.0                         62 51                 113
1167051 1167051 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No 1.0 03 04 2015   grade_4                         60.0 53.0                       113.0                         60 53                 113
1167977 1167977 IN     school 1809180 6520   Porter Township School Corp 180918001520 6837 Boone Grove Elementary School   Regular School No 2.0 04 05 2015   grade_4                         58.0 55.0                       113.0                         58 55                 113
1165766 1165766 IN     school 1805670 5330   M S D Lawrence Township 180567001027 5289 Harrison Hill Elem Sch   Regular School No 1.0 01 06 2015   grade_4                         56.0 58.0                       114.0                         56 58                 114
1166191 1166191 IN     school 1812810 5375   M S D Wayne Township 181281002035 5257 McClelland Elementary School   Regular School No 1.0 KG 06 2015   grade_4                         55.0 59.0                       114.0                         55 59                 114
1170059 1170059 IN     school 1812090 8030   Vigo County School Corp 181209001909 8549 Lost Creek Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         61.0 53.0                       114.0                         61 53                 114
1160965 1160965 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001803 1189 North Dearborn Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         52.0 63.0                       115.0                         52 63                 115
1163988 1163988 IN     school 1803690 4225   Franklin Community School Corp 180369001030 3467 Creekside Elementary Sch   Regular School No 1.0 KG 04 2015   grade_4                         58.0 57.0                       115.0                         58 57                 115
1166063 1166063 IN     school 1812360 5360   M S D Warren Township 181236001959 5391 Brookview Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         51.0 64.0                       115.0                         51 64                 115
1169126 1169126 IN     school 1810140 7365   Shelbyville Central Schools 181014001632 7729 Thomas A Hendricks Elem Sch   Regular School No 1.0 PK 05 2015   grade_4                         59.0 56.0                       115.0                         59 56                 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]);