enrollments

Data source: Big Local News · About: Big Local

7,343 rows where grade = "grade_4" and state = "IN" sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 7,343 ✖
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
1166236 1166236 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_4                         5.0 1.0                       6.0                         5 1                 6
1287638 1287638 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_4                         1.0 1.0                       2.0                         1 1                 2
1299675 1299675 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_4                         5.0 1.0                       6.0                         5 1                 6
1758213 1758213 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_4                         3.0 0.0                       3.0                         3 0                 3
1794003 1794003 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_4                         11.0 2.0                       13.0                         11 2                 13
1908018 1908018 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   grade_4                         48.0 47.0                       95.0                         48 47                 95
1908036 1908036 IN     school   940   West Clark Community Schools   789 Silver Creek Elementary School             2020   grade_4                         96.0 104.0                       200.0                         96 104                 200
1908050 1908050 IN     school   940   West Clark Community Schools   815 William W Borden Elementary School             2020   grade_4                         25.0 17.0                       42.0                         25 17                 42
1913641 1913641 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_4                         4.0 1.0                       5.0                         4 1                 5
1925547 1925547 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_4                         5.0 1.0                       6.0                         5 1                 6
1927086 1927086 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   grade_4                         3.0 1.0                       4.0                         3 1                 4
1927138 1927138 IN     school   6510   East Porter County School Corp   6811 Porter County Education Services             2021   grade_4                         0.0 1.0                       1.0                         0 1                 1
1927245 1927245 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_4                         4.0 0.0                       4.0                         4 0                 4
1927328 1927328 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_4                         2.0 1.0                       3.0                         2 1                 3
1159491 1159491 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No 1.0 02 04 2015   grade_4                         42.0 62.0                       104.0                         42 62                 104
1160280 1160280 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         39.0 30.0                       69.0                         39 30                 69
1160286 1160286 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No 1.0 PK 04 2015   grade_4                         83.0 87.0                       170.0                         83 87                 170
1160293 1160293 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         55.0 48.0                       103.0                         55 48                 103
1160300 1160300 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No 1.0 KG 04 2015   grade_4                         44.0 58.0                       102.0                         44 58                 102
1160306 1160306 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No 1.0 PK 04 2015   grade_4                         24.0 31.0                       55.0                         24 31                 55
1160359 1160359 IN     school 1800960 670   Brown County School Corporation 180096000173 577 Van Buren Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         25.0 13.0                       38.0                         25 13                 38
1160366 1160366 IN     school 1800960 670   Brown County School Corporation 180096000170 581 Helmsburg Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         21.0 21.0                       42.0                         21 21                 42
1160373 1160373 IN     school 1800960 670   Brown County School Corporation 180096000172 585 Sprunica Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         24.0 26.0                       50.0                         24 26                 50
1160549 1160549 IN     school 1801920 1000   Clarksville Com School Corp 180192000251 845 Clarksville Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         42.0 42.0                       84.0                         42 42                 84
1160965 1160965 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001803 1189 North Dearborn Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         52.0 63.0                       115.0                         52 63                 115
1160978 1160978 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119000371 1193 Bright Elementary Sch   Regular School No 1.0 KG 04 2015   grade_4                         53.0 37.0                       90.0                         53 37                 90
1160984 1160984 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001805 7211 Sunman Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         56.0 41.0                       97.0                         56 41                 97
1161382 1161382 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001388 1543 Celestine Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         14.0 14.0                       28.0                         14 14                 28
1161398 1161398 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001390 1577 Dubois Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         27.0 16.0                       43.0                         27 16                 43
1161405 1161405 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001746 1563 Pine Ridge Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         22.0 24.0                       46.0                         22 24                 46
1161412 1161412 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001744 1581 Ferdinand Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         27.0 20.0                       47.0                         27 20                 47
1161547 1161547 IN     school 1802400 2270   Concord Community Schools 180240000270 1721 Concord East Side Elem School   Regular School No 1.0 KG 04 2015   grade_4                         46.0 50.0                       96.0                         46 50                 96
1161553 1161553 IN     school 1802400 2270   Concord Community Schools 180240000272 1723 Concord Ox-Bow Elementary Sch   Regular School No 1.0 KG 04 2015   grade_4                         50.0 57.0                       107.0                         50 57                 107
1161559 1161559 IN     school 1802400 2270   Concord Community Schools 180240000273 1725 Concord South Side Elem School   Regular School No 1.0 KG 04 2015   grade_4                         33.0 43.0                       76.0                         33 43                 76
1161565 1161565 IN     school 1802400 2270   Concord Community Schools 180240000274 1729 Concord West Side Elem School   Regular School No 1.0 KG 04 2015   grade_4                         44.0 49.0                       93.0                         44 49                 93
1161602 1161602 IN     school 1806600 2275   Middlebury Community Schools 180660000199 1734 Orchard View Sch   Regular School No 1.0 KG 04 2015   grade_4                         1.0 0.0                       1.0                         1 0                 1
1161907 1161907 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001267 1929 Georgetown Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         55.0 56.0                       111.0                         55 56                 111
1161933 1161933 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001281 1943 Slate Run Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         28.0 28.0                       56.0                         28 28                 56
1161939 1161939 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001264 1949 Fairmont Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         29.0 34.0                       63.0                         29 34                 63
1161945 1161945 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001270 1953 Greenville Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         28.0 41.0                       69.0                         28 41                 69
1161951 1161951 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001268 1957 Grant Line School   Regular School No 1.0 KG 04 2015   grade_4                         65.0 62.0                       127.0                         65 62                 127
1161957 1161957 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001269 1961 Green Valley Elementary Sch   Regular School No 1.0 KG 04 2015   grade_4                         37.0 31.0                       68.0                         37 31                 68
1161963 1161963 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741000852 1966 Floyds Knobs Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         71.0 84.0                       155.0                         71 84                 155
1161969 1161969 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002204 1974 Mount Tabor School   Regular School No 1.0 KG 04 2015   grade_4                         76.0 68.0                       144.0                         76 68                 144
1161975 1161975 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001278 1981 S Ellen Jones Elementary Sch   Regular School No 1.0 KG 04 2015   grade_4                         25.0 28.0                       53.0                         25 28                 53
1162053 1162053 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         45.0 45.0                       90.0                         45 45                 90
1162272 1162272 IN     school 1806390 2865   Marion Community Schools 180639001107 2369 Allen Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         32.0 26.0                       58.0                         32 26                 58
1162278 1162278 IN     school 1806390 2865   Marion Community Schools 180639001113 2393 John W Kendall Elem School   Regular School No 1.0 KG 04 2015   grade_4                         40.0 33.0                       73.0                         40 33                 73
1162284 1162284 IN     school 1806390 2865   Marion Community Schools 180639001119 2405 Riverview Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         22.0 33.0                       55.0                         22 33                 55
1162290 1162290 IN     school 1806390 2865   Marion Community Schools 180639001110 2409 Frances Slocum Elem School   Regular School No 1.0 KG 04 2015   grade_4                         25.0 25.0                       50.0                         25 25                 50
1162313 1162313 IN     school 1803090 2940   Eastern Greene Schools 180309000407 2433 Eastern Greene Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         40.0 35.0                       75.0                         40 35                 75
1162387 1162387 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No 1.0 PK 04 2015   grade_4                         74.0 78.0                       152.0                         74 78                 152
1162394 1162394 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002368 2468 New Britton Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         63.0 61.0                       124.0                         63 61                 124
1162400 1162400 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001751 2469 Fishers Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         45.0 44.0                       89.0                         45 44                 89
1162406 1162406 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No 1.0 KG 04 2015   grade_4                         80.0 62.0                       142.0                         80 62                 142
1162412 1162412 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001560 2471 Hoosier Road Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         81.0 75.0                       156.0                         81 75                 156
1162418 1162418 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001750 2473 Fall Creek Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         69.0 84.0                       153.0                         69 84                 153
1162424 1162424 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002060 2474 Geist Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         89.0 97.0                       186.0                         89 97                 186
1162430 1162430 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000373 2475 Lantern Road Elementary Sch   Regular School No 1.0 KG 04 2015   grade_4                         62.0 56.0                       118.0                         62 56                 118
1162442 1162442 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000967 2481 Harrison Parkway Elem School   Regular School No 1.0 KG 04 2015   grade_4                         61.0 61.0                       122.0                         61 61                 122
1162448 1162448 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002061 2482 Sand Creek Elementary   Regular School No 1.0 KG 04 2015   grade_4                         91.0 83.0                       174.0                         91 83                 174
1162454 1162454 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002429 2483 Thorpe Creek Elementary   Regular School No 1.0 KG 04 2015   grade_4                         83.0 85.0                       168.0                         83 85                 168
1162474 1162474 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001749 2497 Durbin Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         35.0 47.0                       82.0                         35 47                 82
1162510 1162510 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary Sch   Regular School No 1.0 KG 04 2015   grade_4                         51.0 40.0                       91.0                         51 40                 91
1162522 1162522 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   grade_4                         47.0 47.0                       94.0                         47 47                 94
1162529 1162529 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         49.0 27.0                       76.0                         49 27                 76
1162535 1162535 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary Sch   Regular School No 1.0 PK 04 2015   grade_4                         57.0 47.0                       104.0                         57 47                 104
1162542 1162542 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         30.0 21.0                       51.0                         30 21                 51
1162552 1162552 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2015   grade_4                         48.0 51.0                       99.0                         48 51                 99
1163045 1163045 IN     school 1800270 3315   Avon Community School Corp 180027002480 2726 River Birch Elementary   Regular School No 1.0 KG 04 2015   grade_4                         85.0 62.0                       147.0                         85 62                 147
1163060 1163060 IN     school 1800270 3315   Avon Community School Corp 180027000059 2733 Maple Elementary Sch   Regular School No 1.0 KG 04 2015   grade_4                         34.0 27.0                       61.0                         34 27                 61
1163066 1163066 IN     school 1800270 3315   Avon Community School Corp 180027000058 2734 White Oak Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         39.0 24.0                       63.0                         39 24                 63
1163073 1163073 IN     school 1800270 3315   Avon Community School Corp 180027000390 2735 Sycamore Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         41.0 50.0                       91.0                         41 50                 91
1163088 1163088 IN     school 1800270 3315   Avon Community School Corp 180027002194 2738 Cedar Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         70.0 60.0                       130.0                         70 60                 130
1163094 1163094 IN     school 1800270 3315   Avon Community School Corp 180027002330 2739 Pine Tree Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         33.0 49.0                       82.0                         33 49                 82
1163100 1163100 IN     school 1800270 3315   Avon Community School Corp 180027001675 2740 Hickory Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         48.0 60.0                       108.0                         48 60                 108
1163124 1163124 IN     school 1802550 3325   Danville Community School Corp 180255000307 2745 South Elementary School   Regular School No 1.0 03 04 2015   grade_4                         98.0 88.0                       186.0                         98 88                 186
1163848 1163848 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000244 3401 Clark Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         42.0 54.0                       96.0                         42 54                 96
1163866 1163866 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000247 3425 Whiteland Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         43.0 29.0                       72.0                         43 29                 72
1163875 1163875 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000243 3429 Break-O-Day Elementary School   Regular School No 1.0 02 04 2015   grade_4                         85.0 85.0                       170.0                         85 85                 170
1163880 1163880 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189002411 3430 Pleasant Crossing Elementary   Regular School No 1.0 KG 04 2015   grade_4                         77.0 58.0                       135.0                         77 58                 135
1163952 1163952 IN     school 1803690 4225   Franklin Community School Corp 180369000583 3413 Needham Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         49.0 33.0                       82.0                         49 33                 82
1163958 1163958 IN     school 1803690 4225   Franklin Community School Corp 180369000585 3433 Union Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         29.0 15.0                       44.0                         29 15                 44
1163975 1163975 IN     school 1803690 4225   Franklin Community School Corp 180369000584 3461 Northwood Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         43.0 47.0                       90.0                         43 47                 90
1163982 1163982 IN     school 1803690 4225   Franklin Community School Corp 180369000586 3465 Webb Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         25.0 33.0                       58.0                         25 33                 58
1163988 1163988 IN     school 1803690 4225   Franklin Community School Corp 180369001030 3467 Creekside Elementary Sch   Regular School No 1.0 KG 04 2015   grade_4                         58.0 57.0                       115.0                         58 57                 115
1164277 1164277 IN     school 1809300 4515   Prairie Heights Com Sch Corp 180930001524 3686 Prairie Heights Elem Sch   Regular School No 1.0 PK 04 2015   grade_4                         56.0 37.0                       93.0                         56 37                 93
1164302 1164302 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         42.0 32.0                       74.0                         42 32                 74
1164318 1164318 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elem School   Regular School No 1.0 KG 04 2015   grade_4                         30.0 39.0                       69.0                         30 39                 69
1164431 1164431 IN     school 1809690 4600   Merrillville Community School 180969001582 3821 Henry P Fieler Elem Sch   Regular School No 1.0 KG 04 2015   grade_4                         41.0 38.0                       79.0                         41 38                 79
1164437 1164437 IN     school 1809690 4600   Merrillville Community School 180969001583 3822 Homer Iddings Elem Sch   Regular School No 1.0 KG 04 2015   grade_4                         56.0 50.0                       106.0                         56 50                 106
1164443 1164443 IN     school 1809690 4600   Merrillville Community School 180969001580 3826 Edgar L Miller Elem Sch   Regular School No 1.0 KG 04 2015   grade_4                         31.0 44.0                       75.0                         31 44                 75
1164449 1164449 IN     school 1809690 4600   Merrillville Community School 180969001584 3827 John Wood Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         25.0 24.0                       49.0                         25 24                 49
1164456 1164456 IN     school 1809690 4600   Merrillville Community School 180969001585 3829 Jonas E Salk Elem Sch   Regular School No 1.0 KG 04 2015   grade_4                         61.0 78.0                       139.0                         61 78                 139
1164473 1164473 IN     school 1805450 4615   Lake Central School Corp 180545000983 3837 Kolling Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         68.0 62.0                       130.0                         68 62                 130
1164485 1164485 IN     school 1805450 4615   Lake Central School Corp 180545000980 3839 George Bibich Elementary Sch   Regular School No 1.0 KG 04 2015   grade_4                         52.0 58.0                       110.0                         52 58                 110
1164491 1164491 IN     school 1805450 4615   Lake Central School Corp 180545000981 3840 James H Watson Elem Sch   Regular School No 1.0 PK 04 2015   grade_4                         55.0 44.0                       99.0                         55 44                 99
1164503 1164503 IN     school 1805450 4615   Lake Central School Corp 180545000987 3843 Protsman Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         71.0 60.0                       131.0                         71 60                 131
1164510 1164510 IN     school 1805450 4615   Lake Central School Corp 180545002143 4349 Homan Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         54.0 66.0                       120.0                         54 66                 120
1164517 1164517 IN     school 1805450 4615   Lake Central School Corp 180545000986 4351 Peifer Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         58.0 41.0                       99.0                         58 41                 99

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