enrollments

Data source: Big Local News · About: Big Local

7,228 rows where grade = "kindergarten" and state = "IN"

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • kindergarten · 7,028 ✖
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
1161757 1161757 IN     school 1803270 2305   Elkhart Community Schools 180327000443 1797 Riverview Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         27.0 33.0                       60.0                         27 33                 60
1161765 1161765 IN     school 1803270 2305   Elkhart Community Schools 180327000444 1801 Roosevelt Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         61.0 46.0                       107.0                         61 46                 107
1161774 1161774 IN     school 1803270 2305   Elkhart Community Schools 180327000447 1817 Woodland Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         38.0 39.0                       77.0                         38 39                 77
1161788 1161788 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         53.0 57.0                       110.0                         53 57                 110
1161795 1161795 IN     school 1803930 2315   Goshen Community Schools 180393000660 1641 Waterford Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         41.0 33.0                       74.0                         41 33                 74
1161807 1161807 IN     school 1803930 2315   Goshen Community Schools 180393000652 1829 Chamberlain Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         33.0 19.0                       52.0                         33 19                 52
1161814 1161814 IN     school 1803930 2315   Goshen Community Schools 180393000653 1833 Chandler Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         44.0 30.0                       74.0                         44 30                 74
1161821 1161821 IN     school 1803930 2315   Goshen Community Schools 180393000657 1843 Parkside Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         50.0 40.0                       90.0                         50 40                 90
1161828 1161828 IN     school 1803930 2315   Goshen Community Schools 180393002180 1847 Prairie View Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         45.0 34.0                       79.0                         45 34                 79
1161836 1161836 IN     school 1803930 2315   Goshen Community Schools 180393000661 1849 West Goshen Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         34.0 37.0                       71.0                         34 37                 71
1161844 1161844 IN     school 1803510 2395   Fayette County School Corp 180351000500 1869 Everton Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         13.0 17.0                       30.0                         13 17                 30
1161861 1161861 IN     school 1803510 2395   Fayette County School Corp 180351000499 1897 Eastview Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         15.0 19.0                       34.0                         15 19                 34
1161870 1161870 IN     school 1803510 2395   Fayette County School Corp 180351000503 1909 Frazee Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         24.0 22.0                       46.0                         24 22                 46
1161879 1161879 IN     school 1803510 2395   Fayette County School Corp 180351000504 1913 Grandview Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         30.0 20.0                       50.0                         30 20                 50
1161888 1161888 IN     school 1803510 2395   Fayette County School Corp 180351000505 1917 Maplewood Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         33.0 14.0                       47.0                         33 14                 47
1161896 1161896 IN     school 1803510 2395   Fayette County School Corp 180351000501 1921 Fayette Central Elementary   Regular School No 1.0 PK 06 2015   kindergarten                         28.0 18.0                       46.0                         28 18                 46
1161908 1161908 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001267 1929 Georgetown Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         54.0 50.0                       104.0                         54 50                 104
1161934 1161934 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001281 1943 Slate Run Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         35.0 44.0                       79.0                         35 44                 79
1161940 1161940 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001264 1949 Fairmont Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         39.0 38.0                       77.0                         39 38                 77
1161946 1161946 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001270 1953 Greenville Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         43.0 33.0                       76.0                         43 33                 76
1161952 1161952 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001268 1957 Grant Line School   Regular School No 1.0 KG 04 2015   kindergarten                         70.0 49.0                       119.0                         70 49                 119
1161958 1161958 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001269 1961 Green Valley Elementary Sch   Regular School No 1.0 KG 04 2015   kindergarten                         43.0 32.0                       75.0                         43 32                 75
1161964 1161964 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741000852 1966 Floyds Knobs Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         53.0 50.0                       103.0                         53 50                 103
1161970 1161970 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002204 1974 Mount Tabor School   Regular School No 1.0 KG 04 2015   kindergarten                         81.0 69.0                       150.0                         81 69                 150
1161976 1161976 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   kindergarten                         25.0 33.0                       58.0                         25 33                 58
1161993 1161993 IN     school 1800210 2435   Attica Consolidated Sch Corp 180021000049 2057 Attica Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         34.0 25.0                       59.0                         34 25                 59
1162006 1162006 IN     school 1802430 2440   Covington Community Sch Corp 180243000276 2009 Covington Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         29.0 30.0                       59.0                         29 30                 59
1162019 1162019 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No 1.0 KG 06 2015   kindergarten                         39.0 40.0                       79.0                         39 40                 79
1162037 1162037 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   kindergarten                         23.0 18.0                       41.0                         23 18                 41
1162054 1162054 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No 1.0 PK 04 2015   kindergarten                         37.0 32.0                       69.0                         37 32                 69
1162065 1162065 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   kindergarten                         23.0 20.0                       43.0                         23 20                 43
1162079 1162079 IN     school 1809630 2645   Rochester Community Sch Corp 180963001574 2181 Columbia Elementary School   Regular School No 1.0 PK 02 2015   kindergarten                         73.0 86.0                       159.0                         73 86                 159
1162092 1162092 IN     school 1801410 2650   Caston School Corporation 180141000206 2157 Caston Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         20.0 19.0                       39.0                         20 19                 39
1162107 1162107 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2015   kindergarten                         11.0 9.0                       20.0                         11 9                 20
1162118 1162118 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         6.0 4.0                       10.0                         6 4                 10
1162131 1162131 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         18.0 21.0                       39.0                         18 21                 39
1162151 1162151 IN     school 1807770 2735   North Gibson School Corp 180777001325 2257 Princeton Comm Primary School   Regular School No 1.0 PK 02 2015   kindergarten                         77.0 73.0                       150.0                         77 73                 150
1162162 1162162 IN     school 1810350 2765   South Gibson School Corp 181035001689 2205 Haubstadt Community School   Regular School No 1.0 KG 08 2015   kindergarten                         7.0 17.0                       24.0                         7 17                 24
1162177 1162177 IN     school 1810350 2765   South Gibson School Corp 181035002230 2214 Fort Branch Community School   Regular School No 1.0 KG 08 2015   kindergarten                         28.0 26.0                       54.0                         28 26                 54
1162187 1162187 IN     school 1810350 2765   South Gibson School Corp 181035001691 2241 Owensville Community School   Regular School No 1.0 KG 08 2015   kindergarten                         27.0 27.0                       54.0                         27 27                 54
1162195 1162195 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002473 2263 Eastbrook South Elementary   Regular School No 1.0 KG 06 2015   kindergarten                         30.0 38.0                       68.0                         30 38                 68
1162203 1162203 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002489 2264 Eastbrook North Elementary   Regular School No 1.0 KG 06 2015   kindergarten                         27.0 18.0                       45.0                         27 18                 45
1162229 1162229 IN     school 1806240 2825   Madison-Grant United Sch Corp 180624001098 2329 Park Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         22.0 22.0                       44.0                         22 22                 44
1162237 1162237 IN     school 1806240 2825   Madison-Grant United Sch Corp 180624001100 5037 Summitville School   Regular School No 1.0 PK 06 2015   kindergarten                         19.0 12.0                       31.0                         19 12                 31
1162250 1162250 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No 1.0 PK 01 2015   kindergarten                         80.0 70.0                       150.0                         80 70                 150
1162273 1162273 IN     school 1806390 2865   Marion Community Schools 180639001107 2369 Allen Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         42.0 36.0                       78.0                         42 36                 78
1162279 1162279 IN     school 1806390 2865   Marion Community Schools 180639001113 2393 John W Kendall Elem School   Regular School No 1.0 KG 04 2015   kindergarten                         40.0 44.0                       84.0                         40 44                 84
1162285 1162285 IN     school 1806390 2865   Marion Community Schools 180639001119 2405 Riverview Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         37.0 35.0                       72.0                         37 35                 72
1162291 1162291 IN     school 1806390 2865   Marion Community Schools 180639001110 2409 Frances Slocum Elem School   Regular School No 1.0 KG 04 2015   kindergarten                         47.0 33.0                       80.0                         47 33                 80
1162299 1162299 IN     school 1800600 2920   Bloomfield School District 180060000112 2417 Bloomfield Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         35.0 31.0                       66.0                         35 31                 66
1162314 1162314 IN     school 1803090 2940   Eastern Greene Schools 180309000407 2433 Eastern Greene Elementary School   Regular School No 1.0 PK 04 2015   kindergarten                         42.0 42.0                       84.0                         42 42                 84
1162342 1162342 IN     school 1805910 2950   Linton-Stockton School Corp 180591001048 2441 Linton-Stockton Elementary   Regular School No 1.0 KG 05 2015   kindergarten                         56.0 68.0                       124.0                         56 68                 124
1162357 1162357 IN     school 1810110 2960   M S D Shakamak Schools 181011001622 2449 Shakamak Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         40.0 26.0                       66.0                         40 26                 66
1162373 1162373 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         17.0 10.0                       27.0                         17 10                 27
1162381 1162381 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         20.0 17.0                       37.0                         20 17                 37
1162388 1162388 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No 1.0 PK 04 2015   kindergarten                         69.0 64.0                       133.0                         69 64                 133
1162395 1162395 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002368 2468 New Britton Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         59.0 53.0                       112.0                         59 53                 112
1162401 1162401 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001751 2469 Fishers Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         40.0 36.0                       76.0                         40 36                 76
1162407 1162407 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No 1.0 KG 04 2015   kindergarten                         42.0 46.0                       88.0                         42 46                 88
1162413 1162413 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001560 2471 Hoosier Road Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         83.0 85.0                       168.0                         83 85                 168
1162419 1162419 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001750 2473 Fall Creek Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         70.0 53.0                       123.0                         70 53                 123
1162425 1162425 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002060 2474 Geist Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         63.0 79.0                       142.0                         63 79                 142
1162431 1162431 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000373 2475 Lantern Road Elementary Sch   Regular School No 1.0 KG 04 2015   kindergarten                         50.0 40.0                       90.0                         50 40                 90
1162443 1162443 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000967 2481 Harrison Parkway Elem School   Regular School No 1.0 KG 04 2015   kindergarten                         47.0 49.0                       96.0                         47 49                 96
1162449 1162449 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002061 2482 Sand Creek Elementary   Regular School No 1.0 KG 04 2015   kindergarten                         90.0 73.0                       163.0                         90 73                 163
1162455 1162455 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002429 2483 Thorpe Creek Elementary   Regular School No 1.0 KG 04 2015   kindergarten                         74.0 93.0                       167.0                         74 93                 167
1162475 1162475 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001749 2497 Durbin Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         56.0 40.0                       96.0                         56 40                 96
1162500 1162500 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No 1.0 PK 02 2015   kindergarten                         68.0 68.0                       136.0                         68 68                 136
1162511 1162511 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary Sch   Regular School No 1.0 KG 04 2015   kindergarten                         44.0 43.0                       87.0                         44 43                 87
1162523 1162523 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   kindergarten                         55.0 46.0                       101.0                         55 46                 101
1162530 1162530 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         38.0 28.0                       66.0                         38 28                 66
1162536 1162536 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   kindergarten                         60.0 57.0                       117.0                         60 57                 117
1162543 1162543 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   kindergarten                         49.0 29.0                       78.0                         49 29                 78
1162553 1162553 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   kindergarten                         53.0 55.0                       108.0                         53 55                 108
1162566 1162566 IN     school 1806480 3055   Sheridan Community Schools 180648001125 2465 Sheridan Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         38.0 43.0                       81.0                         38 43                 81
1162587 1162587 IN     school 1801200 3060   Carmel Clay Schools 180120000200 2507 Woodbrook Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         39.0 29.0                       68.0                         39 29                 68
1162594 1162594 IN     school 1801200 3060   Carmel Clay Schools 180120002332 2508 Cherry Tree Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         53.0 51.0                       104.0                         53 51                 104
1162602 1162602 IN     school 1801200 3060   Carmel Clay Schools 180120000192 2509 Carmel Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         38.0 36.0                       74.0                         38 36                 74
1162609 1162609 IN     school 1801200 3060   Carmel Clay Schools 180120000196 2510 College Wood Elementary Sch   Regular School No 1.0 PK 05 2015   kindergarten                         81.0 49.0                       130.0                         81 49                 130
1162621 1162621 IN     school 1801200 3060   Carmel Clay Schools 180120000036 2512 Smoky Row Elementary Sch   Regular School No 1.0 PK 05 2015   kindergarten                         31.0 52.0                       83.0                         31 52                 83
1162629 1162629 IN     school 1801200 3060   Carmel Clay Schools 180120002267 2513 Orchard Park Elementary Sch   Regular School No 1.0 PK 05 2015   kindergarten                         59.0 50.0                       109.0                         59 50                 109
1162637 1162637 IN     school 1801200 3060   Carmel Clay Schools 180120000991 2515 Prairie Trace Elementary Sch   Regular School No 1.0 KG 05 2015   kindergarten                         51.0 48.0                       99.0                         51 48                 99
1162644 1162644 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary Sch   Regular School No 1.0 KG 05 2015   kindergarten                         46.0 42.0                       88.0                         46 42                 88
1162651 1162651 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         56.0 43.0                       99.0                         56 43                 99
1162663 1162663 IN     school 1801200 3060   Carmel Clay Schools 180120001405 2522 Towne Meadow Elementary Sch   Regular School No 1.0 PK 05 2015   kindergarten                         52.0 47.0                       99.0                         52 47                 99
1162671 1162671 IN     school 1801200 3060   Carmel Clay Schools 180120002185 2526 West Clay Elementary   Regular School No 1.0 KG 05 2015   kindergarten                         53.0 51.0                       104.0                         53 51                 104
1162693 1162693 IN     school 1807650 3070   Noblesville Schools 180765002158 2523 Hinkle Creek Elementary Sch   Regular School No 1.0 PK 05 2015   kindergarten                         83.0 69.0                       152.0                         83 69                 152
1162701 1162701 IN     school 1807650 3070   Noblesville Schools 180765001311 2529 North Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         43.0 36.0                       79.0                         43 36                 79
1162708 1162708 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         42.0 47.0                       89.0                         42 47                 89
1162716 1162716 IN     school 1807650 3070   Noblesville Schools 180765002414 2537 Noble Crossing Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         58.0 52.0                       110.0                         58 52                 110
1162724 1162724 IN     school 1807650 3070   Noblesville Schools 180765002340 2538 Hazel Dell Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         50.0 55.0                       105.0                         50 55                 105
1162732 1162732 IN     school 1807650 3070   Noblesville Schools 180765002546 2539 Promise Road Elementary   Regular School No 1.0 KG 05 2015   kindergarten                         58.0 62.0                       120.0                         58 62                 120
1162743 1162743 IN     school 1807650 3070   Noblesville Schools 180765001246 2547 White River Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         51.0 62.0                       113.0                         51 62                 113
1162752 1162752 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001758 2563 Brandywine Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         20.0 14.0                       34.0                         20 14                 34
1162760 1162760 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001760 2564 New Palestine Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         36.0 33.0                       69.0                         36 33                 69
1162778 1162778 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001407 2567 Sugar Creek Elementary Sch   Regular School No 1.0 PK 06 2015   kindergarten                         50.0 55.0                       105.0                         50 55                 105
1162791 1162791 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000694 2581 Eden Elementary School   Regular School No 1.0 KG 03 2015   kindergarten                         32.0 23.0                       55.0                         32 23                 55
1162796 1162796 IN     school 1804050 3125   Greenfield-Central Com Schools 180405001665 2588 J B Stephens Elementary School   Regular School No 1.0 PK 03 2015   kindergarten                         66.0 63.0                       129.0                         66 63                 129
1162811 1162811 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000697 2597 Harris Elementary School   Regular School No 1.0 KG 03 2015   kindergarten                         42.0 49.0                       91.0                         42 49                 91
1162816 1162816 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000702 2609 Weston Elementary School   Regular School No 1.0 KG 03 2015   kindergarten                         34.0 48.0                       82.0                         34 48                 82

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