enrollments

Data source: Big Local News · About: Big Local

7,378 rows where grade = "grade_3" and state = "IN"

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_3 · 7,146 ✖
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
1162015 1162015 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No 1.0 KG 06 2015   grade_3                         48.0 31.0                       79.0                         48 31                 79
1162031 1162031 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   grade_3                         26.0 20.0                       46.0                         26 20                 46
1162052 1162052 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No 1.0 PK 04 2015   grade_3                         55.0 56.0                       111.0                         55 56                 111
1162059 1162059 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   grade_3                         31.0 22.0                       53.0                         31 22                 53
1162082 1162082 IN     school 1809630 2645   Rochester Community Sch Corp 180963001575 2185 George M Riddle Elem School   Regular School No 1.0 03 05 2015   grade_3                         77.0 81.0                       158.0                         77 81                 158
1162088 1162088 IN     school 1801410 2650   Caston School Corporation 180141000206 2157 Caston Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         29.0 25.0                       54.0                         29 25                 54
1162103 1162103 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2015   grade_3                         14.0 8.0                       22.0                         14 8                 22
1162114 1162114 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         7.0 10.0                       17.0                         7 10                 17
1162127 1162127 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         17.0 18.0                       35.0                         17 18                 35
1162136 1162136 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No 1.0 01 05 2015   grade_3                         78.0 71.0                       149.0                         78 71                 149
1162156 1162156 IN     school 1810350 2765   South Gibson School Corp 181035001689 2205 Haubstadt Community School   Regular School No 1.0 KG 08 2015   grade_3                         23.0 18.0                       41.0                         23 18                 41
1162171 1162171 IN     school 1810350 2765   South Gibson School Corp 181035002230 2214 Fort Branch Community School   Regular School No 1.0 KG 08 2015   grade_3                         19.0 30.0                       49.0                         19 30                 49
1162181 1162181 IN     school 1810350 2765   South Gibson School Corp 181035001691 2241 Owensville Community School   Regular School No 1.0 KG 08 2015   grade_3                         31.0 32.0                       63.0                         31 32                 63
1162191 1162191 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002473 2263 Eastbrook South Elementary   Regular School No 1.0 KG 06 2015   grade_3                         29.0 33.0                       62.0                         29 33                 62
1162199 1162199 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002489 2264 Eastbrook North Elementary   Regular School No 1.0 KG 06 2015   grade_3                         33.0 23.0                       56.0                         33 23                 56
1162225 1162225 IN     school 1806240 2825   Madison-Grant United Sch Corp 180624001098 2329 Park Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         27.0 26.0                       53.0                         27 26                 53
1162233 1162233 IN     school 1806240 2825   Madison-Grant United Sch Corp 180624001100 5037 Summitville School   Regular School No 1.0 PK 06 2015   grade_3                         26.0 25.0                       51.0                         26 25                 51
1162254 1162254 IN     school 1806870 2855   Mississinewa Community School Corp 180687001191 2346 Northview Elementary School   Regular School No 1.0 02 05 2015   grade_3                         94.0 90.0                       184.0                         94 90                 184
1162271 1162271 IN     school 1806390 2865   Marion Community Schools 180639001107 2369 Allen Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         50.0 33.0                       83.0                         50 33                 83
1162277 1162277 IN     school 1806390 2865   Marion Community Schools 180639001113 2393 John W Kendall Elem School   Regular School No 1.0 KG 04 2015   grade_3                         28.0 49.0                       77.0                         28 49                 77
1162283 1162283 IN     school 1806390 2865   Marion Community Schools 180639001119 2405 Riverview Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         38.0 35.0                       73.0                         38 35                 73
1162289 1162289 IN     school 1806390 2865   Marion Community Schools 180639001110 2409 Frances Slocum Elem School   Regular School No 1.0 KG 04 2015   grade_3                         39.0 30.0                       69.0                         39 30                 69
1162295 1162295 IN     school 1800600 2920   Bloomfield School District 180060000112 2417 Bloomfield Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         34.0 39.0                       73.0                         34 39                 73
1162312 1162312 IN     school 1803090 2940   Eastern Greene Schools 180309000407 2433 Eastern Greene Elementary School   Regular School No 1.0 PK 04 2015   grade_3                         46.0 43.0                       89.0                         46 43                 89
1162339 1162339 IN     school 1805910 2950   Linton-Stockton School Corp 180591001048 2441 Linton-Stockton Elementary   Regular School No 1.0 KG 05 2015   grade_3                         65.0 60.0                       125.0                         65 60                 125
1162353 1162353 IN     school 1810110 2960   M S D Shakamak Schools 181011001622 2449 Shakamak Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         36.0 30.0                       66.0                         36 30                 66
1162369 1162369 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         12.0 9.0                       21.0                         12 9                 21
1162377 1162377 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         19.0 12.0                       31.0                         19 12                 31
1162386 1162386 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No 1.0 PK 04 2015   grade_3                         70.0 78.0                       148.0                         70 78                 148
1162393 1162393 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002368 2468 New Britton Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         68.0 62.0                       130.0                         68 62                 130
1162399 1162399 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001751 2469 Fishers Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         44.0 52.0                       96.0                         44 52                 96
1162405 1162405 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No 1.0 KG 04 2015   grade_3                         63.0 54.0                       117.0                         63 54                 117
1162411 1162411 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001560 2471 Hoosier Road Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         82.0 76.0                       158.0                         82 76                 158
1162417 1162417 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001750 2473 Fall Creek Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         75.0 84.0                       159.0                         75 84                 159
1162423 1162423 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002060 2474 Geist Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         98.0 84.0                       182.0                         98 84                 182
1162429 1162429 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000373 2475 Lantern Road Elementary Sch   Regular School No 1.0 KG 04 2015   grade_3                         59.0 47.0                       106.0                         59 47                 106
1162441 1162441 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000967 2481 Harrison Parkway Elem School   Regular School No 1.0 KG 04 2015   grade_3                         64.0 56.0                       120.0                         64 56                 120
1162447 1162447 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002061 2482 Sand Creek Elementary   Regular School No 1.0 KG 04 2015   grade_3                         82.0 84.0                       166.0                         82 84                 166
1162453 1162453 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002429 2483 Thorpe Creek Elementary   Regular School No 1.0 KG 04 2015   grade_3                         88.0 87.0                       175.0                         88 87                 175
1162473 1162473 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001749 2497 Durbin Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         49.0 39.0                       88.0                         49 39                 88
1162490 1162490 IN     school 1804260 3025   Hamilton Heights School Corp 180426002134 2478 Hamilton Heights Elem School   Regular School No 1.0 03 05 2015   grade_3                         110.0 91.0                       201.0                         110 91                 201
1162509 1162509 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary Sch   Regular School No 1.0 KG 04 2015   grade_3                         59.0 59.0                       118.0                         59 59                 118
1162521 1162521 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   grade_3                         41.0 49.0                       90.0                         41 49                 90
1162528 1162528 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         41.0 44.0                       85.0                         41 44                 85
1162534 1162534 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   grade_3                         56.0 48.0                       104.0                         56 48                 104
1162541 1162541 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   grade_3                         20.0 22.0                       42.0                         20 22                 42
1162551 1162551 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   grade_3                         73.0 33.0                       106.0                         73 33                 106
1162563 1162563 IN     school 1806480 3055   Sheridan Community Schools 180648001125 2465 Sheridan Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         49.0 37.0                       86.0                         49 37                 86
1162584 1162584 IN     school 1801200 3060   Carmel Clay Schools 180120000200 2507 Woodbrook Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         45.0 44.0                       89.0                         45 44                 89
1162591 1162591 IN     school 1801200 3060   Carmel Clay Schools 180120002332 2508 Cherry Tree Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         63.0 56.0                       119.0                         63 56                 119
1162599 1162599 IN     school 1801200 3060   Carmel Clay Schools 180120000192 2509 Carmel Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         53.0 50.0                       103.0                         53 50                 103
1162606 1162606 IN     school 1801200 3060   Carmel Clay Schools 180120000196 2510 College Wood Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         72.0 69.0                       141.0                         72 69                 141
1162618 1162618 IN     school 1801200 3060   Carmel Clay Schools 180120000036 2512 Smoky Row Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         53.0 47.0                       100.0                         53 47                 100
1162626 1162626 IN     school 1801200 3060   Carmel Clay Schools 180120002267 2513 Orchard Park Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         42.0 54.0                       96.0                         42 54                 96
1162634 1162634 IN     school 1801200 3060   Carmel Clay Schools 180120000991 2515 Prairie Trace Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         53.0 43.0                       96.0                         53 43                 96
1162641 1162641 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         41.0 47.0                       88.0                         41 47                 88
1162648 1162648 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         53.0 47.0                       100.0                         53 47                 100
1162660 1162660 IN     school 1801200 3060   Carmel Clay Schools 180120001405 2522 Towne Meadow Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         58.0 57.0                       115.0                         58 57                 115
1162668 1162668 IN     school 1801200 3060   Carmel Clay Schools 180120002185 2526 West Clay Elementary   Regular School No 1.0 KG 05 2015   grade_3                         60.0 60.0                       120.0                         60 60                 120
1162690 1162690 IN     school 1807650 3070   Noblesville Schools 180765002158 2523 Hinkle Creek Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         82.0 68.0                       150.0                         82 68                 150
1162698 1162698 IN     school 1807650 3070   Noblesville Schools 180765001311 2529 North Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         55.0 45.0                       100.0                         55 45                 100
1162705 1162705 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         57.0 43.0                       100.0                         57 43                 100
1162713 1162713 IN     school 1807650 3070   Noblesville Schools 180765002414 2537 Noble Crossing Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         49.0 56.0                       105.0                         49 56                 105
1162721 1162721 IN     school 1807650 3070   Noblesville Schools 180765002340 2538 Hazel Dell Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         71.0 49.0                       120.0                         71 49                 120
1162729 1162729 IN     school 1807650 3070   Noblesville Schools 180765002546 2539 Promise Road Elementary   Regular School No 1.0 KG 05 2015   grade_3                         59.0 62.0                       121.0                         59 62                 121
1162740 1162740 IN     school 1807650 3070   Noblesville Schools 180765001246 2547 White River Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         58.0 71.0                       129.0                         58 71                 129
1162748 1162748 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001758 2563 Brandywine Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         24.0 22.0                       46.0                         24 22                 46
1162756 1162756 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_3                         42.0 32.0                       74.0                         42 32                 74
1162774 1162774 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_3                         60.0 44.0                       104.0                         60 44                 104
1162790 1162790 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000694 2581 Eden Elementary School   Regular School No 1.0 KG 03 2015   grade_3                         20.0 28.0                       48.0                         20 28                 48
1162795 1162795 IN     school 1804050 3125   Greenfield-Central Com Schools 180405001665 2588 J B Stephens Elementary School   Regular School No 1.0 PK 03 2015   grade_3                         53.0 49.0                       102.0                         53 49                 102
1162810 1162810 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000697 2597 Harris Elementary School   Regular School No 1.0 KG 03 2015   grade_3                         58.0 33.0                       91.0                         58 33                 91
1162815 1162815 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000702 2609 Weston Elementary School   Regular School No 1.0 KG 03 2015   grade_3                         31.0 44.0                       75.0                         31 44                 75
1162820 1162820 IN     school 1807260 3135   Mt Vernon Community Sch Corp 180726002152 2558 Fortville Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         31.0 35.0                       66.0                         31 35                 66
1162831 1162831 IN     school 1807260 3135   Mt Vernon Community Sch Corp 180726001220 2561 Mt Comfort Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         49.0 36.0                       85.0                         49 36                 85
1162844 1162844 IN     school 1807260 3135   Mt Vernon Community Sch Corp 180726002192 2570 McCordsville Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         53.0 47.0                       100.0                         53 47                 100
1162860 1162860 IN     school 1803120 3145   Eastern Hancock Co Com Sch Corp 180312000409 2586 Eastern Hancock Elem School   Regular School No 1.0 KG 05 2015   grade_3                         46.0 42.0                       88.0                         46 42                 88
1162867 1162867 IN     school 1803720 3160   Lanesville Community School Corp 180372000592 2611 Lanesville Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         16.0 32.0                       48.0                         16 32                 48
1162882 1162882 IN     school 1800690 3180   North Harrison Com School Corp 180069000142 2621 Morgan Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         38.0 49.0                       87.0                         38 49                 87
1162899 1162899 IN     school 1800690 3180   North Harrison Com School Corp 180069000143 2633 North Harrison Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         42.0 34.0                       76.0                         42 34                 76
1162914 1162914 IN     school 1810360 3190   South Harrison Com Schools 181036001693 2645 Corydon Elementary School   Regular School No 1.0 PK 03 2015   grade_3                         68.0 71.0                       139.0                         68 71                 139
1162920 1162920 IN     school 1810360 3190   South Harrison Com Schools 181036001698 2649 New Middletown Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         11.0 10.0                       21.0                         11 10                 21
1162929 1162929 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elem School   Regular School No 1.0 PK 06 2015   grade_3                         14.0 15.0                       29.0                         14 15                 29
1162936 1162936 IN     school 1810360 3190   South Harrison Com Schools 181036000385 2663 Corydon Intermediate School   Regular School No 1.0 03 06 2015   grade_3                         0.0 1.0                       1.0                         0 1                 1
1162943 1162943 IN     school 1810360 3190   South Harrison Com Schools 181036002284 2667 South Central Elementary   Regular School No 1.0 PK 05 2015   grade_3                         29.0 24.0                       53.0                         29 24                 53
1162968 1162968 IN     school 1808100 3295   North West Hendricks Schools 180810001385 2685 North Salem Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         27.0 19.0                       46.0                         27 19                 46
1162974 1162974 IN     school 1808100 3295   North West Hendricks Schools 180810001386 2725 Pittsboro Elementary   Regular School No 1.0 03 05 2015   grade_3                         52.0 45.0                       97.0                         52 45                 97
1162986 1162986 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000994 2706 Brown Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         48.0 52.0                       100.0                         48 52                 100
1163001 1163001 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000045 2711 Eagle Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         60.0 47.0                       107.0                         60 47                 107
1163012 1163012 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102002430 2714 Reagan Elementary   Regular School No 1.0 KG 05 2015   grade_3                         44.0 45.0                       89.0                         44 45                 89
1163019 1163019 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001567 2718 Delaware Trail Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         61.0 43.0                       104.0                         61 43                 104
1163030 1163030 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001671 2723 White Lick Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         49.0 45.0                       94.0                         49 45                 94
1163037 1163037 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001570 2727 Cardinal Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         55.0 53.0                       108.0                         55 53                 108
1163044 1163044 IN     school 1800270 3315   Avon Community School Corp 180027002480 2726 River Birch Elementary   Regular School No 1.0 KG 04 2015   grade_3                         89.0 73.0                       162.0                         89 73                 162
1163059 1163059 IN     school 1800270 3315   Avon Community School Corp 180027000059 2733 Maple Elementary Sch   Regular School No 1.0 KG 04 2015   grade_3                         28.0 21.0                       49.0                         28 21                 49
1163065 1163065 IN     school 1800270 3315   Avon Community School Corp 180027000058 2734 White Oak Elementary School   Regular School No 1.0 PK 04 2015   grade_3                         21.0 29.0                       50.0                         21 29                 50
1163072 1163072 IN     school 1800270 3315   Avon Community School Corp 180027000390 2735 Sycamore Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         39.0 36.0                       75.0                         39 36                 75
1163087 1163087 IN     school 1800270 3315   Avon Community School Corp 180027002194 2738 Cedar Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         75.0 55.0                       130.0                         75 55                 130
1163093 1163093 IN     school 1800270 3315   Avon Community School Corp 180027002330 2739 Pine Tree Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         35.0 25.0                       60.0                         35 25                 60
1163099 1163099 IN     school 1800270 3315   Avon Community School Corp 180027001675 2740 Hickory Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         58.0 61.0                       119.0                         58 61                 119

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