enrollments

Data source: Big Local News · About: Big Local

7,359 rows where grade = "grade_1" and state = "IN"

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 7,159 ✖
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
1161751 1161751 IN     school 1803270 2305   Elkhart Community Schools 180327000443 1797 Riverview Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         39.0 31.0                       70.0                         39 31                 70
1161759 1161759 IN     school 1803270 2305   Elkhart Community Schools 180327000444 1801 Roosevelt Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         58.0 54.0                       112.0                         58 54                 112
1161768 1161768 IN     school 1803270 2305   Elkhart Community Schools 180327000447 1817 Woodland Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         37.0 34.0                       71.0                         37 34                 71
1161783 1161783 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         49.0 53.0                       102.0                         49 53                 102
1161790 1161790 IN     school 1803930 2315   Goshen Community Schools 180393000660 1641 Waterford Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         44.0 45.0                       89.0                         44 45                 89
1161802 1161802 IN     school 1803930 2315   Goshen Community Schools 180393000652 1829 Chamberlain Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         35.0 29.0                       64.0                         35 29                 64
1161809 1161809 IN     school 1803930 2315   Goshen Community Schools 180393000653 1833 Chandler Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         30.0 41.0                       71.0                         30 41                 71
1161816 1161816 IN     school 1803930 2315   Goshen Community Schools 180393000657 1843 Parkside Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         30.0 32.0                       62.0                         30 32                 62
1161823 1161823 IN     school 1803930 2315   Goshen Community Schools 180393002180 1847 Prairie View Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         44.0 36.0                       80.0                         44 36                 80
1161831 1161831 IN     school 1803930 2315   Goshen Community Schools 180393000661 1849 West Goshen Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         50.0 36.0                       86.0                         50 36                 86
1161838 1161838 IN     school 1803510 2395   Fayette County School Corp 180351000500 1869 Everton Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         17.0 25.0                       42.0                         17 25                 42
1161855 1161855 IN     school 1803510 2395   Fayette County School Corp 180351000499 1897 Eastview Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         20.0 19.0                       39.0                         20 19                 39
1161864 1161864 IN     school 1803510 2395   Fayette County School Corp 180351000503 1909 Frazee Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         24.0 23.0                       47.0                         24 23                 47
1161873 1161873 IN     school 1803510 2395   Fayette County School Corp 180351000504 1913 Grandview Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         25.0 26.0                       51.0                         25 26                 51
1161882 1161882 IN     school 1803510 2395   Fayette County School Corp 180351000505 1917 Maplewood Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         23.0 29.0                       52.0                         23 29                 52
1161890 1161890 IN     school 1803510 2395   Fayette County School Corp 180351000501 1921 Fayette Central Elementary   Regular School No 1.0 PK 06 2015   grade_1                         27.0 20.0                       47.0                         27 20                 47
1161904 1161904 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001267 1929 Georgetown Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         70.0 69.0                       139.0                         70 69                 139
1161930 1161930 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001281 1943 Slate Run Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         33.0 31.0                       64.0                         33 31                 64
1161936 1161936 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001264 1949 Fairmont Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         39.0 34.0                       73.0                         39 34                 73
1161942 1161942 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001270 1953 Greenville Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         45.0 35.0                       80.0                         45 35                 80
1161948 1161948 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001268 1957 Grant Line School   Regular School No 1.0 KG 04 2015   grade_1                         46.0 48.0                       94.0                         46 48                 94
1161954 1161954 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001269 1961 Green Valley Elementary Sch   Regular School No 1.0 KG 04 2015   grade_1                         24.0 29.0                       53.0                         24 29                 53
1161960 1161960 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741000852 1966 Floyds Knobs Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         51.0 66.0                       117.0                         51 66                 117
1161966 1161966 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002204 1974 Mount Tabor School   Regular School No 1.0 KG 04 2015   grade_1                         84.0 67.0                       151.0                         84 67                 151
1161972 1161972 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001278 1981 S Ellen Jones Elementary Sch   Regular School No 1.0 KG 04 2015   grade_1                         27.0 31.0                       58.0                         27 31                 58
1161987 1161987 IN     school 1800210 2435   Attica Consolidated Sch Corp 180021000049 2057 Attica Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         35.0 23.0                       58.0                         35 23                 58
1162001 1162001 IN     school 1802430 2440   Covington Community Sch Corp 180243000276 2009 Covington Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         38.0 36.0                       74.0                         38 36                 74
1162013 1162013 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No 1.0 KG 06 2015   grade_1                         36.0 52.0                       88.0                         36 52                 88
1162029 1162029 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   grade_1                         31.0 25.0                       56.0                         31 25                 56
1162050 1162050 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No 1.0 PK 04 2015   grade_1                         41.0 51.0                       92.0                         41 51                 92
1162057 1162057 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   grade_1                         18.0 22.0                       40.0                         18 22                 40
1162077 1162077 IN     school 1809630 2645   Rochester Community Sch Corp 180963001574 2181 Columbia Elementary School   Regular School No 1.0 PK 02 2015   grade_1                         89.0 74.0                       163.0                         89 74                 163
1162086 1162086 IN     school 1801410 2650   Caston School Corporation 180141000206 2157 Caston Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         21.0 23.0                       44.0                         21 23                 44
1162101 1162101 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2015   grade_1                         9.0 10.0                       19.0                         9 10                 19
1162112 1162112 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         8.0 4.0                       12.0                         8 4                 12
1162125 1162125 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         23.0 12.0                       35.0                         23 12                 35
1162134 1162134 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No 1.0 01 05 2015   grade_1                         1.0 0.0                       1.0                         1 0                 1
1162149 1162149 IN     school 1807770 2735   North Gibson School Corp 180777001325 2257 Princeton Comm Primary School   Regular School No 1.0 PK 02 2015   grade_1                         91.0 82.0                       173.0                         91 82                 173
1162154 1162154 IN     school 1810350 2765   South Gibson School Corp 181035001689 2205 Haubstadt Community School   Regular School No 1.0 KG 08 2015   grade_1                         15.0 18.0                       33.0                         15 18                 33
1162169 1162169 IN     school 1810350 2765   South Gibson School Corp 181035002230 2214 Fort Branch Community School   Regular School No 1.0 KG 08 2015   grade_1                         21.0 26.0                       47.0                         21 26                 47
1162179 1162179 IN     school 1810350 2765   South Gibson School Corp 181035001691 2241 Owensville Community School   Regular School No 1.0 KG 08 2015   grade_1                         30.0 33.0                       63.0                         30 33                 63
1162189 1162189 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002473 2263 Eastbrook South Elementary   Regular School No 1.0 KG 06 2015   grade_1                         37.0 28.0                       65.0                         37 28                 65
1162197 1162197 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002489 2264 Eastbrook North Elementary   Regular School No 1.0 KG 06 2015   grade_1                         22.0 25.0                       47.0                         22 25                 47
1162223 1162223 IN     school 1806240 2825   Madison-Grant United Sch Corp 180624001098 2329 Park Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         30.0 27.0                       57.0                         30 27                 57
1162231 1162231 IN     school 1806240 2825   Madison-Grant United Sch Corp 180624001100 5037 Summitville School   Regular School No 1.0 PK 06 2015   grade_1                         14.0 13.0                       27.0                         14 13                 27
1162249 1162249 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No 1.0 PK 01 2015   grade_1                         76.0 77.0                       153.0                         76 77                 153
1162269 1162269 IN     school 1806390 2865   Marion Community Schools 180639001107 2369 Allen Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         47.0 40.0                       87.0                         47 40                 87
1162275 1162275 IN     school 1806390 2865   Marion Community Schools 180639001113 2393 John W Kendall Elem School   Regular School No 1.0 KG 04 2015   grade_1                         40.0 36.0                       76.0                         40 36                 76
1162281 1162281 IN     school 1806390 2865   Marion Community Schools 180639001119 2405 Riverview Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         45.0 32.0                       77.0                         45 32                 77
1162287 1162287 IN     school 1806390 2865   Marion Community Schools 180639001110 2409 Frances Slocum Elem School   Regular School No 1.0 KG 04 2015   grade_1                         47.0 31.0                       78.0                         47 31                 78
1162293 1162293 IN     school 1800600 2920   Bloomfield School District 180060000112 2417 Bloomfield Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         39.0 27.0                       66.0                         39 27                 66
1162310 1162310 IN     school 1803090 2940   Eastern Greene Schools 180309000407 2433 Eastern Greene Elementary School   Regular School No 1.0 PK 04 2015   grade_1                         46.0 39.0                       85.0                         46 39                 85
1162337 1162337 IN     school 1805910 2950   Linton-Stockton School Corp 180591001048 2441 Linton-Stockton Elementary   Regular School No 1.0 KG 05 2015   grade_1                         58.0 57.0                       115.0                         58 57                 115
1162351 1162351 IN     school 1810110 2960   M S D Shakamak Schools 181011001622 2449 Shakamak Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         29.0 31.0                       60.0                         29 31                 60
1162367 1162367 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         14.0 13.0                       27.0                         14 13                 27
1162375 1162375 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         23.0 8.0                       31.0                         23 8                 31
1162384 1162384 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No 1.0 PK 04 2015   grade_1                         67.0 73.0                       140.0                         67 73                 140
1162391 1162391 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002368 2468 New Britton Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         69.0 58.0                       127.0                         69 58                 127
1162397 1162397 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001751 2469 Fishers Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         56.0 58.0                       114.0                         56 58                 114
1162403 1162403 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No 1.0 KG 04 2015   grade_1                         69.0 39.0                       108.0                         69 39                 108
1162409 1162409 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001560 2471 Hoosier Road Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         75.0 75.0                       150.0                         75 75                 150
1162415 1162415 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001750 2473 Fall Creek Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         72.0 59.0                       131.0                         72 59                 131
1162421 1162421 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002060 2474 Geist Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         89.0 69.0                       158.0                         89 69                 158
1162427 1162427 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000373 2475 Lantern Road Elementary Sch   Regular School No 1.0 KG 04 2015   grade_1                         58.0 47.0                       105.0                         58 47                 105
1162439 1162439 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000967 2481 Harrison Parkway Elem School   Regular School No 1.0 KG 04 2015   grade_1                         59.0 49.0                       108.0                         59 49                 108
1162445 1162445 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002061 2482 Sand Creek Elementary   Regular School No 1.0 KG 04 2015   grade_1                         97.0 81.0                       178.0                         97 81                 178
1162451 1162451 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002429 2483 Thorpe Creek Elementary   Regular School No 1.0 KG 04 2015   grade_1                         105.0 105.0                       210.0                         105 105                 210
1162471 1162471 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001749 2497 Durbin Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         36.0 36.0                       72.0                         36 36                 72
1162498 1162498 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No 1.0 PK 02 2015   grade_1                         89.0 67.0                       156.0                         89 67                 156
1162507 1162507 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary Sch   Regular School No 1.0 KG 04 2015   grade_1                         43.0 53.0                       96.0                         43 53                 96
1162519 1162519 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   grade_1                         64.0 66.0                       130.0                         64 66                 130
1162526 1162526 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         38.0 47.0                       85.0                         38 47                 85
1162532 1162532 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   grade_1                         52.0 62.0                       114.0                         52 62                 114
1162539 1162539 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   grade_1                         34.0 28.0                       62.0                         34 28                 62
1162549 1162549 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   grade_1                         49.0 32.0                       81.0                         49 32                 81
1162561 1162561 IN     school 1806480 3055   Sheridan Community Schools 180648001125 2465 Sheridan Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         39.0 36.0                       75.0                         39 36                 75
1162582 1162582 IN     school 1801200 3060   Carmel Clay Schools 180120000200 2507 Woodbrook Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         47.0 42.0                       89.0                         47 42                 89
1162589 1162589 IN     school 1801200 3060   Carmel Clay Schools 180120002332 2508 Cherry Tree Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         54.0 49.0                       103.0                         54 49                 103
1162597 1162597 IN     school 1801200 3060   Carmel Clay Schools 180120000192 2509 Carmel Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         40.0 36.0                       76.0                         40 36                 76
1162604 1162604 IN     school 1801200 3060   Carmel Clay Schools 180120000196 2510 College Wood Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         62.0 66.0                       128.0                         62 66                 128
1162616 1162616 IN     school 1801200 3060   Carmel Clay Schools 180120000036 2512 Smoky Row Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         49.0 49.0                       98.0                         49 49                 98
1162624 1162624 IN     school 1801200 3060   Carmel Clay Schools 180120002267 2513 Orchard Park Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         56.0 66.0                       122.0                         56 66                 122
1162632 1162632 IN     school 1801200 3060   Carmel Clay Schools 180120000991 2515 Prairie Trace Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         32.0 50.0                       82.0                         32 50                 82
1162639 1162639 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         48.0 30.0                       78.0                         48 30                 78
1162646 1162646 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         49.0 52.0                       101.0                         49 52                 101
1162658 1162658 IN     school 1801200 3060   Carmel Clay Schools 180120001405 2522 Towne Meadow Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         34.0 60.0                       94.0                         34 60                 94
1162666 1162666 IN     school 1801200 3060   Carmel Clay Schools 180120002185 2526 West Clay Elementary   Regular School No 1.0 KG 05 2015   grade_1                         55.0 52.0                       107.0                         55 52                 107
1162688 1162688 IN     school 1807650 3070   Noblesville Schools 180765002158 2523 Hinkle Creek Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         69.0 76.0                       145.0                         69 76                 145
1162696 1162696 IN     school 1807650 3070   Noblesville Schools 180765001311 2529 North Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         42.0 35.0                       77.0                         42 35                 77
1162703 1162703 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         67.0 52.0                       119.0                         67 52                 119
1162711 1162711 IN     school 1807650 3070   Noblesville Schools 180765002414 2537 Noble Crossing Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         65.0 51.0                       116.0                         65 51                 116
1162719 1162719 IN     school 1807650 3070   Noblesville Schools 180765002340 2538 Hazel Dell Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         55.0 44.0                       99.0                         55 44                 99
1162727 1162727 IN     school 1807650 3070   Noblesville Schools 180765002546 2539 Promise Road Elementary   Regular School No 1.0 KG 05 2015   grade_1                         69.0 62.0                       131.0                         69 62                 131
1162738 1162738 IN     school 1807650 3070   Noblesville Schools 180765001246 2547 White River Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         59.0 56.0                       115.0                         59 56                 115
1162746 1162746 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001758 2563 Brandywine Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         20.0 24.0                       44.0                         20 24                 44
1162754 1162754 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001760 2564 New Palestine Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         42.0 28.0                       70.0                         42 28                 70
1162772 1162772 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_1                         56.0 53.0                       109.0                         56 53                 109
1162788 1162788 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000694 2581 Eden Elementary School   Regular School No 1.0 KG 03 2015   grade_1                         29.0 24.0                       53.0                         29 24                 53
1162793 1162793 IN     school 1804050 3125   Greenfield-Central Com Schools 180405001665 2588 J B Stephens Elementary School   Regular School No 1.0 PK 03 2015   grade_1                         75.0 64.0                       139.0                         75 64                 139
1162808 1162808 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000697 2597 Harris Elementary School   Regular School No 1.0 KG 03 2015   grade_1                         45.0 49.0                       94.0                         45 49                 94

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