enrollments

Data source: Big Local News · About: Big Local

6,726 rows where grade = "grade_5" and state = "IN"

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_5 · 6,517 ✖
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
1162017 1162017 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No 1.0 KG 06 2015   grade_5                         45.0 41.0                       86.0                         45 41                 86
1162033 1162033 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   grade_5                         24.0 14.0                       38.0                         24 14                 38
1162045 1162045 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000589 2123 Brookville Middle Sch   Regular School No 2.0 05 08 2015   grade_5                         55.0 55.0                       110.0                         55 55                 110
1162061 1162061 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   grade_5                         25.0 28.0                       53.0                         25 28                 53
1162084 1162084 IN     school 1809630 2645   Rochester Community Sch Corp 180963001575 2185 George M Riddle Elem School   Regular School No 1.0 03 05 2015   grade_5                         66.0 80.0                       146.0                         66 80                 146
1162090 1162090 IN     school 1801410 2650   Caston School Corporation 180141000206 2157 Caston Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         27.0 33.0                       60.0                         27 33                 60
1162105 1162105 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2015   grade_5                         10.0 14.0                       24.0                         10 14                 24
1162116 1162116 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         3.0 8.0                       11.0                         3 8                 11
1162129 1162129 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         18.0 15.0                       33.0                         18 15                 33
1162138 1162138 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No 1.0 01 05 2015   grade_5                         88.0 72.0                       160.0                         88 72                 160
1162158 1162158 IN     school 1810350 2765   South Gibson School Corp 181035001689 2205 Haubstadt Community School   Regular School No 1.0 KG 08 2015   grade_5                         18.0 11.0                       29.0                         18 11                 29
1162173 1162173 IN     school 1810350 2765   South Gibson School Corp 181035002230 2214 Fort Branch Community School   Regular School No 1.0 KG 08 2015   grade_5                         25.0 37.0                       62.0                         25 37                 62
1162183 1162183 IN     school 1810350 2765   South Gibson School Corp 181035001691 2241 Owensville Community School   Regular School No 1.0 KG 08 2015   grade_5                         25.0 23.0                       48.0                         25 23                 48
1162193 1162193 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002473 2263 Eastbrook South Elementary   Regular School No 1.0 KG 06 2015   grade_5                         33.0 30.0                       63.0                         33 30                 63
1162201 1162201 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002489 2264 Eastbrook North Elementary   Regular School No 1.0 KG 06 2015   grade_5                         24.0 26.0                       50.0                         24 26                 50
1162227 1162227 IN     school 1806240 2825   Madison-Grant United Sch Corp 180624001098 2329 Park Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         29.0 20.0                       49.0                         29 20                 49
1162235 1162235 IN     school 1806240 2825   Madison-Grant United Sch Corp 180624001100 5037 Summitville School   Regular School No 1.0 PK 06 2015   grade_5                         13.0 28.0                       41.0                         13 28                 41
1162256 1162256 IN     school 1806870 2855   Mississinewa Community School Corp 180687001191 2346 Northview Elementary School   Regular School No 1.0 02 05 2015   grade_5                         105.0 99.0                       204.0                         105 99                 204
1162258 1162258 IN     school 1806390 2865   Marion Community Schools 180639001115 2350 Justice Thurgood Marshall Intrmd   Regular School No 2.0 05 06 2015   grade_5                         141.0 136.0                       277.0                         141 136                 277
1162297 1162297 IN     school 1800600 2920   Bloomfield School District 180060000112 2417 Bloomfield Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         44.0 39.0                       83.0                         44 39                 83
1162322 1162322 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No 2.0 05 08 2015   grade_5                         44.0 48.0                       92.0                         44 48                 92
1162341 1162341 IN     school 1805910 2950   Linton-Stockton School Corp 180591001048 2441 Linton-Stockton Elementary   Regular School No 1.0 KG 05 2015   grade_5                         62.0 57.0                       119.0                         62 57                 119
1162355 1162355 IN     school 1810110 2960   M S D Shakamak Schools 181011001622 2449 Shakamak Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         31.0 24.0                       55.0                         31 24                 55
1162371 1162371 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         13.0 9.0                       22.0                         13 9                 22
1162379 1162379 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         21.0 14.0                       35.0                         21 14                 35
1162436 1162436 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001753 2479 Sand Creek Intermediate School   Regular School No 2.0 05 06 2015   grade_5                         334.0 284.0                       618.0                         334 284                 618
1162457 1162457 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000970 2485 Fall Creek Intermediate Sch   Regular School No 2.0 05 06 2015   grade_5                         323.0 283.0                       606.0                         323 283                 606
1162482 1162482 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No 2.0 05 06 2015   grade_5                         256.0 239.0                       495.0                         256 239                 495
1162492 1162492 IN     school 1804260 3025   Hamilton Heights School Corp 180426002134 2478 Hamilton Heights Elem School   Regular School No 1.0 03 05 2015   grade_5                         88.0 84.0                       172.0                         88 84                 172
1162546 1162546 IN     school 1813080 3030   Westfield-Washington Schools 181308000857 2503 Westfield Intermediate School   Regular School No 2.0 05 06 2015   grade_5                         306.0 279.0                       585.0                         306 279                 585
1162565 1162565 IN     school 1806480 3055   Sheridan Community Schools 180648001125 2465 Sheridan Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         47.0 36.0                       83.0                         47 36                 83
1162586 1162586 IN     school 1801200 3060   Carmel Clay Schools 180120000200 2507 Woodbrook Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         54.0 54.0                       108.0                         54 54                 108
1162593 1162593 IN     school 1801200 3060   Carmel Clay Schools 180120002332 2508 Cherry Tree Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         66.0 69.0                       135.0                         66 69                 135
1162601 1162601 IN     school 1801200 3060   Carmel Clay Schools 180120000192 2509 Carmel Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         43.0 50.0                       93.0                         43 50                 93
1162608 1162608 IN     school 1801200 3060   Carmel Clay Schools 180120000196 2510 College Wood Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         75.0 68.0                       143.0                         75 68                 143
1162620 1162620 IN     school 1801200 3060   Carmel Clay Schools 180120000036 2512 Smoky Row Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         73.0 53.0                       126.0                         73 53                 126
1162628 1162628 IN     school 1801200 3060   Carmel Clay Schools 180120002267 2513 Orchard Park Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         51.0 64.0                       115.0                         51 64                 115
1162636 1162636 IN     school 1801200 3060   Carmel Clay Schools 180120000991 2515 Prairie Trace Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         55.0 49.0                       104.0                         55 49                 104
1162643 1162643 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         51.0 50.0                       101.0                         51 50                 101
1162650 1162650 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         63.0 59.0                       122.0                         63 59                 122
1162662 1162662 IN     school 1801200 3060   Carmel Clay Schools 180120001405 2522 Towne Meadow Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         70.0 67.0                       137.0                         70 67                 137
1162670 1162670 IN     school 1801200 3060   Carmel Clay Schools 180120002185 2526 West Clay Elementary   Regular School No 1.0 KG 05 2015   grade_5                         53.0 81.0                       134.0                         53 81                 134
1162692 1162692 IN     school 1807650 3070   Noblesville Schools 180765002158 2523 Hinkle Creek Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         86.0 81.0                       167.0                         86 81                 167
1162700 1162700 IN     school 1807650 3070   Noblesville Schools 180765001311 2529 North Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         45.0 39.0                       84.0                         45 39                 84
1162707 1162707 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         56.0 59.0                       115.0                         56 59                 115
1162715 1162715 IN     school 1807650 3070   Noblesville Schools 180765002414 2537 Noble Crossing Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         51.0 61.0                       112.0                         51 61                 112
1162723 1162723 IN     school 1807650 3070   Noblesville Schools 180765002340 2538 Hazel Dell Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         51.0 49.0                       100.0                         51 49                 100
1162731 1162731 IN     school 1807650 3070   Noblesville Schools 180765002546 2539 Promise Road Elementary   Regular School No 1.0 KG 05 2015   grade_5                         50.0 38.0                       88.0                         50 38                 88
1162742 1162742 IN     school 1807650 3070   Noblesville Schools 180765001246 2547 White River Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         62.0 61.0                       123.0                         62 61                 123
1162750 1162750 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001758 2563 Brandywine Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         19.0 21.0                       40.0                         19 21                 40
1162758 1162758 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_5                         47.0 33.0                       80.0                         47 33                 80
1162776 1162776 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_5                         69.0 48.0                       117.0                         69 48                 117
1162782 1162782 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000699 2577 Maxwell Intermediate School   Regular School No 2.0 04 06 2015   grade_5                         89.0 81.0                       170.0                         89 81                 170
1162800 1162800 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000695 2593 Greenfield Intermediate School   Regular School No 2.0 04 06 2015   grade_5                         95.0 78.0                       173.0                         95 78                 173
1162822 1162822 IN     school 1807260 3135   Mt Vernon Community Sch Corp 180726002152 2558 Fortville Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         43.0 45.0                       88.0                         43 45                 88
1162833 1162833 IN     school 1807260 3135   Mt Vernon Community Sch Corp 180726001220 2561 Mt Comfort Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         45.0 50.0                       95.0                         45 50                 95
1162846 1162846 IN     school 1807260 3135   Mt Vernon Community Sch Corp 180726002192 2570 McCordsville Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         46.0 36.0                       82.0                         46 36                 82
1162862 1162862 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_5                         44.0 50.0                       94.0                         44 50                 94
1162869 1162869 IN     school 1803720 3160   Lanesville Community School Corp 180372000592 2611 Lanesville Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         25.0 27.0                       52.0                         25 27                 52
1162884 1162884 IN     school 1800690 3180   North Harrison Com School Corp 180069000142 2621 Morgan Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         55.0 47.0                       102.0                         55 47                 102
1162901 1162901 IN     school 1800690 3180   North Harrison Com School Corp 180069000143 2633 North Harrison Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         48.0 43.0                       91.0                         48 43                 91
1162922 1162922 IN     school 1810360 3190   South Harrison Com Schools 181036001698 2649 New Middletown Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         12.0 8.0                       20.0                         12 8                 20
1162931 1162931 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elem School   Regular School No 1.0 PK 06 2015   grade_5                         10.0 15.0                       25.0                         10 15                 25
1162938 1162938 IN     school 1810360 3190   South Harrison Com Schools 181036000385 2663 Corydon Intermediate School   Regular School No 1.0 03 06 2015   grade_5                         58.0 63.0                       121.0                         58 63                 121
1162945 1162945 IN     school 1810360 3190   South Harrison Com Schools 181036002284 2667 South Central Elementary   Regular School No 1.0 PK 05 2015   grade_5                         20.0 29.0                       49.0                         20 29                 49
1162970 1162970 IN     school 1808100 3295   North West Hendricks Schools 180810001385 2685 North Salem Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         30.0 25.0                       55.0                         30 25                 55
1162976 1162976 IN     school 1808100 3295   North West Hendricks Schools 180810001386 2725 Pittsboro Elementary   Regular School No 1.0 03 05 2015   grade_5                         56.0 43.0                       99.0                         56 43                 99
1162988 1162988 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000994 2706 Brown Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         57.0 43.0                       100.0                         57 43                 100
1163003 1163003 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000045 2711 Eagle Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         61.0 46.0                       107.0                         61 46                 107
1163014 1163014 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102002430 2714 Reagan Elementary   Regular School No 1.0 KG 05 2015   grade_5                         49.0 62.0                       111.0                         49 62                 111
1163021 1163021 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001567 2718 Delaware Trail Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         51.0 53.0                       104.0                         51 53                 104
1163032 1163032 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001671 2723 White Lick Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         60.0 53.0                       113.0                         60 53                 113
1163039 1163039 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001570 2727 Cardinal Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         58.0 63.0                       121.0                         58 63                 121
1163048 1163048 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No 2.0 05 06 2015   grade_5                         200.0 179.0                       379.0                         200 179                 379
1163051 1163051 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No 2.0 05 06 2015   grade_5                         179.0 165.0                       344.0                         179 165                 344
1163107 1163107 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         1.0 0.0                       1.0                         1 0                 1
1163118 1163118 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No 2.0 04 08 2015   grade_5                         98.0 92.0                       190.0                         98 92                 190
1163130 1163130 IN     school 1808970 3330   Plainfield Community Sch Corp 180897002438 2748 Clarks Creek Elementary   Regular School No 1.0 KG 05 2015   grade_5                         55.0 65.0                       120.0                         55 65                 120
1163147 1163147 IN     school 1808970 3330   Plainfield Community Sch Corp 180897001493 2751 Central Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         46.0 47.0                       93.0                         46 47                 93
1163156 1163156 IN     school 1808970 3330   Plainfield Community Sch Corp 180897001495 2761 Van Buren Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         45.0 39.0                       84.0                         45 39                 84
1163163 1163163 IN     school 1808970 3330   Plainfield Community Sch Corp 180897001492 2763 Brentwood Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         32.0 37.0                       69.0                         32 37                 69
1163170 1163170 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001172 2675 Mill Creek East Elementary   Regular School No 1.0 PK 05 2015   grade_5                         40.0 45.0                       85.0                         40 45                 85
1163178 1163178 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666002248 2677 Mill Creek West Elementary   Regular School No 1.0 KG 05 2015   grade_5                         24.0 24.0                       48.0                         24 24                 48
1163201 1163201 IN     school 1800660 3405   Blue River Valley Schools 180066000140 2803 Blue River Valley Elem School   Regular School No 1.0 PK 06 2015   grade_5                         26.0 24.0                       50.0                         26 24                 50
1163218 1163218 IN     school 1810380 3415   South Henry School Corp 181038001703 2777 Tri-Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         28.0 29.0                       57.0                         28 29                 57
1163226 1163226 IN     school 1808280 3435   Shenandoah School Corporation 180828002356 2815 Shenandoah Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         51.0 65.0                       116.0                         51 65                 116
1163251 1163251 IN     school 1807440 3445   New Castle Community Sch Corp 180744002156 2832 Eastwood Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         18.0 16.0                       34.0                         18 16                 34
1163260 1163260 IN     school 1807440 3445   New Castle Community Sch Corp 180744002157 2847 Parker Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         29.0 30.0                       59.0                         29 30                 59
1163268 1163268 IN     school 1807440 3445   New Castle Community Sch Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No 1.0 01 06 2015   grade_5                         27.0 17.0                       44.0                         27 17                 44
1163275 1163275 IN     school 1807440 3445   New Castle Community Sch Corp 180744001289 2853 Sunnyside Elementary School   Regular School No 1.0 KG 07 2015   grade_5                         11.0 11.0                       22.0                         11 11                 22
1163284 1163284 IN     school 1807440 3445   New Castle Community Sch Corp 180744001291 2861 Westwood Elementary School   Regular School No 1.0 01 06 2015   grade_5                         28.0 21.0                       49.0                         28 21                 49
1163291 1163291 IN     school 1807440 3445   New Castle Community Sch Corp 180744001292 2865 Wilbur Wright Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         22.0 33.0                       55.0                         22 33                 55
1163301 1163301 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002012 2870 Knightstown Intermediate School   Regular School No 2.0 04 08 2015   grade_5                         48.0 39.0                       87.0                         48 39                 87
1163322 1163322 IN     school 1811250 3460   Taylor Community School Corp 181125001812 2895 Taylor Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         44.0 42.0                       86.0                         44 42                 86
1163339 1163339 IN     school 1802040 3470   Northwestern School Corp 180204000254 2904 Northwestern Elementary Sch   Regular School No 1.0 KG 06 2015   grade_5                         55.0 51.0                       106.0                         55 51                 106
1163347 1163347 IN     school 1802040 3470   Northwestern School Corp 180204000253 2905 Howard Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         23.0 18.0                       41.0                         23 18                 41
1163358 1163358 IN     school 1803150 3480   Eastern Howard School Corp 180315000412 2909 Eastern Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         50.0 61.0                       111.0                         50 61                 111
1163375 1163375 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   grade_5                         2.0 0.0                       2.0                         2 0                 2
1163388 1163388 IN     school 1804470 3490   Western School Corp 180447002224 2923 Western Intermediate School   Regular School No 1.0 02 05 2015   grade_5                         106.0 111.0                       217.0                         106 111                 217
1163398 1163398 IN     school 1805370 3500   Kokomo School Corporation 180537000959 2943 Sycamore Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         44.0 44.0                       88.0                         44 44                 88

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