enrollments

Data source: Big Local News · About: Big Local

1,061 rows where grade = "grade_4", state = "IN" and year = 2017 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 1,061 ✖

grade ✖

  • grade_4 · 1,061 ✖
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
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
1292944 1292944 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No Elementary 02 04 2017   grade_4                         50.0 61.0                       111.0                         50 61                 111
1293730 1293730 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No Elementary PK 04 2017   grade_4                         43.0 37.0                       80.0                         43 37                 80
1293737 1293737 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2017   grade_4                         82.0 76.0                       158.0                         82 76                 158
1293744 1293744 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No Elementary PK 04 2017   grade_4                         62.0 63.0                       125.0                         62 63                 125
1293751 1293751 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2017   grade_4                         38.0 64.0                       102.0                         38 64                 102
1293758 1293758 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2017   grade_4                         39.0 32.0                       71.0                         39 32                 71
1293811 1293811 IN     school 1800960 670   Brown County School Corporation 180096000173 577 Van Buren Elementary School   Regular School No Elementary PK 04 2017   grade_4                         19.0 16.0                       35.0                         19 16                 35
1293818 1293818 IN     school 1800960 670   Brown County School Corporation 180096000170 581 Helmsburg Elementary School   Regular School No Elementary PK 04 2017   grade_4                         21.0 12.0                       33.0                         21 12                 33
1293825 1293825 IN     school 1800960 670   Brown County School Corporation 180096000172 585 Sprunica Elementary School   Regular School No Elementary PK 04 2017   grade_4                         21.0 23.0                       44.0                         21 23                 44
1294002 1294002 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2017   grade_4                         60.0 59.0                       119.0                         60 59                 119
1294821 1294821 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001388 1543 Celestine Elementary School   Regular School No Elementary KG 04 2017   grade_4                         10.0 9.0                       19.0                         10 9                 19
1294837 1294837 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001390 1577 Dubois Elementary School   Regular School No Elementary PK 04 2017   grade_4                         26.0 23.0                       49.0                         26 23                 49
1294844 1294844 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001746 1563 Pine Ridge Elementary School   Regular School No Elementary PK 04 2017   grade_4                         27.0 17.0                       44.0                         27 17                 44
1294851 1294851 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001744 1581 Ferdinand Elementary School   Regular School No Elementary PK 04 2017   grade_4                         44.0 31.0                       75.0                         44 31                 75
1294985 1294985 IN     school 1802400 2270   Concord Community Schools 180240000270 1721 Concord East Side Elementary Sch   Regular School No Elementary KG 04 2017   grade_4                         62.0 55.0                       117.0                         62 55                 117
1294991 1294991 IN     school 1802400 2270   Concord Community Schools 180240000272 1723 Concord Ox-Bow Elementary School   Regular School No Elementary KG 04 2017   grade_4                         53.0 43.0                       96.0                         53 43                 96
1294997 1294997 IN     school 1802400 2270   Concord Community Schools 180240000273 1725 Concord South Side Elementary Sch   Regular School No Elementary KG 04 2017   grade_4                         58.0 27.0                       85.0                         58 27                 85
1295003 1295003 IN     school 1802400 2270   Concord Community Schools 180240000274 1729 Concord West Side Elem School   Regular School No Elementary KG 04 2017   grade_4                         60.0 57.0                       117.0                         60 57                 117
1295040 1295040 IN     school 1806600 2275   Middlebury Community Schools 180660000199 1734 Orchard View School   Regular School No Elementary KG 04 2017   grade_4                         1.0 1.0                       2.0                         1 1                 2
1295361 1295361 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001267 1929 Georgetown Elementary School   Regular School No Elementary KG 04 2017   grade_4                         57.0 53.0                       110.0                         57 53                 110
1295387 1295387 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001281 1943 Slate Run Elementary School   Regular School No Elementary KG 04 2017   grade_4                         22.0 31.0                       53.0                         22 31                 53
1295393 1295393 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001264 1949 Fairmont Elementary School   Regular School No Elementary KG 04 2017   grade_4                         40.0 38.0                       78.0                         40 38                 78
1295399 1295399 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001270 1953 Greenville Elementary School   Regular School No Elementary KG 04 2017   grade_4                         47.0 43.0                       90.0                         47 43                 90
1295405 1295405 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001268 1957 Grant Line Elementary School   Regular School No Elementary KG 04 2017   grade_4                         59.0 52.0                       111.0                         59 52                 111
1295411 1295411 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001269 1961 Green Valley Elementary School   Regular School No Elementary KG 04 2017   grade_4                         25.0 29.0                       54.0                         25 29                 54
1295417 1295417 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741000852 1966 Floyds Knobs Elementary School   Regular School No Elementary KG 04 2017   grade_4                         87.0 64.0                       151.0                         87 64                 151
1295423 1295423 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002204 1974 Mount Tabor Elementary School   Regular School No Elementary KG 04 2017   grade_4                         76.0 79.0                       155.0                         76 79                 155
1295429 1295429 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001278 1981 S Ellen Jones Elementary School   Regular School No Elementary KG 04 2017   grade_4                         24.0 25.0                       49.0                         24 25                 49
1295508 1295508 IN     school 1803700 2475   Franklin County Community Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No Elementary PK 04 2017   grade_4                         49.0 58.0                       107.0                         49 58                 107
1295726 1295726 IN     school 1806390 2865   Marion Community Schools 180639001107 2369 Allen Elementary School   Regular School No Elementary KG 04 2017   grade_4                         35.0 34.0                       69.0                         35 34                 69
1295734 1295734 IN     school 1806390 2865   Marion Community Schools 180639001113 2393 John W Kendall Elem School   Regular School No Elementary KG 04 2017   grade_4                         42.0 36.0                       78.0                         42 36                 78
1295740 1295740 IN     school 1806390 2865   Marion Community Schools 180639001119 2405 Riverview Elementary School   Regular School No Elementary KG 04 2017   grade_4                         41.0 28.0                       69.0                         41 28                 69
1295746 1295746 IN     school 1806390 2865   Marion Community Schools 180639001110 2409 Frances Slocum Elem School   Regular School No Elementary KG 04 2017   grade_4                         35.0 24.0                       59.0                         35 24                 59
1295767 1295767 IN     school 1803090 2940   Eastern Greene Schools 180309000407 2433 Eastern Greene Elementary School   Regular School No Elementary PK 04 2017   grade_4                         47.0 39.0                       86.0                         47 39                 86
1295825 1295825 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2017   grade_4                         15.0 30.0                       45.0                         15 30                 45
1295832 1295832 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No Elementary PK 04 2017   grade_4                         83.0 85.0                       168.0                         83 85                 168
1295839 1295839 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002368 2468 New Britton Elementary School   Regular School No Elementary KG 04 2017   grade_4                         71.0 71.0                       142.0                         71 71                 142
1295845 1295845 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001751 2469 Fishers Elementary School   Regular School No Elementary KG 04 2017   grade_4                         49.0 54.0                       103.0                         49 54                 103
1295851 1295851 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No Elementary KG 04 2017   grade_4                         88.0 74.0                       162.0                         88 74                 162
1295857 1295857 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001560 2471 Hoosier Road Elementary School   Regular School No Elementary KG 04 2017   grade_4                         80.0 66.0                       146.0                         80 66                 146
1295863 1295863 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001750 2473 Fall Creek Elementary School   Regular School No Elementary KG 04 2017   grade_4                         76.0 91.0                       167.0                         76 91                 167
1295869 1295869 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002060 2474 Geist Elementary School   Regular School No Elementary KG 04 2017   grade_4                         84.0 81.0                       165.0                         84 81                 165
1295875 1295875 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000373 2475 Lantern Road Elementary School   Regular School No Elementary KG 04 2017   grade_4                         75.0 70.0                       145.0                         75 70                 145
1295887 1295887 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000967 2481 Harrison Parkway Elementary School   Regular School No Elementary KG 04 2017   grade_4                         66.0 74.0                       140.0                         66 74                 140
1295893 1295893 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002061 2482 Sand Creek Elementary   Regular School No Elementary KG 04 2017   grade_4                         67.0 53.0                       120.0                         67 53                 120
1295899 1295899 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002429 2483 Thorpe Creek Elementary   Regular School No Elementary KG 04 2017   grade_4                         70.0 65.0                       135.0                         70 65                 135
1295924 1295924 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001749 2497 Durbin Elementary School   Regular School No Elementary KG 04 2017   grade_4                         34.0 43.0                       77.0                         34 43                 77
1295960 1295960 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2017   grade_4                         38.0 47.0                       85.0                         38 47                 85
1295973 1295973 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2017   grade_4                         60.0 41.0                       101.0                         60 41                 101
1295980 1295980 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary KG 04 2017   grade_4                         41.0 45.0                       86.0                         41 45                 86
1295986 1295986 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2017   grade_4                         66.0 62.0                       128.0                         66 62                 128
1295993 1295993 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2017   grade_4                         36.0 27.0                       63.0                         36 27                 63
1296002 1296002 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2017   grade_4                         68.0 60.0                       128.0                         68 60                 128
1296488 1296488 IN     school 1800270 3315   Avon Community School Corp 180027002480 2726 River Birch Elementary School   Regular School No Elementary KG 04 2017   grade_4                         89.0 83.0                       172.0                         89 83                 172
1296504 1296504 IN     school 1800270 3315   Avon Community School Corp 180027000059 2733 Maple Elementary School   Regular School No Elementary KG 04 2017   grade_4                         22.0 38.0                       60.0                         22 38                 60
1296510 1296510 IN     school 1800270 3315   Avon Community School Corp 180027000058 2734 White Oak Elementary School   Regular School No Elementary PK 04 2017   grade_4                         26.0 23.0                       49.0                         26 23                 49
1296517 1296517 IN     school 1800270 3315   Avon Community School Corp 180027000390 2735 Sycamore Elementary School   Regular School No Elementary KG 04 2017   grade_4                         48.0 49.0                       97.0                         48 49                 97
1296532 1296532 IN     school 1800270 3315   Avon Community School Corp 180027002194 2738 Cedar Elementary School   Regular School No Elementary KG 04 2017   grade_4                         82.0 72.0                       154.0                         82 72                 154
1296538 1296538 IN     school 1800270 3315   Avon Community School Corp 180027002330 2739 Pine Tree Elementary School   Regular School No Elementary KG 04 2017   grade_4                         39.0 45.0                       84.0                         39 45                 84
1296544 1296544 IN     school 1800270 3315   Avon Community School Corp 180027001675 2740 Hickory Elementary School   Regular School No Elementary KG 04 2017   grade_4                         52.0 64.0                       116.0                         52 64                 116
1296567 1296567 IN     school 1802550 3325   Danville Community School Corp 180255000307 2745 South Elementary School   Regular School No Elementary 03 04 2017   grade_4                         93.0 90.0                       183.0                         93 90                 183
1297404 1297404 IN     school 1803690 4225   Franklin Community School Corp 180369000583 3413 Needham Elementary School   Regular School No Elementary KG 04 2017   grade_4                         31.0 48.0                       79.0                         31 48                 79
1297410 1297410 IN     school 1803690 4225   Franklin Community School Corp 180369000585 3433 Union Elementary School   Regular School No Elementary KG 04 2017   grade_4                         15.0 14.0                       29.0                         15 14                 29
1297427 1297427 IN     school 1803690 4225   Franklin Community School Corp 180369000584 3461 Northwood Elementary School   Regular School No Elementary PK 04 2017   grade_4                         48.0 44.0                       92.0                         48 44                 92
1297434 1297434 IN     school 1803690 4225   Franklin Community School Corp 180369000586 3465 Webb Elementary School   Regular School No Elementary KG 04 2017   grade_4                         22.0 22.0                       44.0                         22 22                 44
1297440 1297440 IN     school 1803690 4225   Franklin Community School Corp 180369001030 3467 Creekside Elementary School   Regular School No Elementary KG 04 2017   grade_4                         62.0 58.0                       120.0                         62 58                 120
1297484 1297484 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001306 3409 Indian Creek Elementary School   Regular School No Elementary PK 04 2017   grade_4                         1.0 1.0                       2.0                         1 1                 2
1297730 1297730 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001524 3686 Prairie Heights Elementary School   Regular School No Elementary KG 04 2017   grade_4                         43.0 48.0                       91.0                         43 48                 91
1297755 1297755 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2017   grade_4                         25.0 27.0                       52.0                         25 27                 52
1297772 1297772 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2017   grade_4                         41.0 32.0                       73.0                         41 32                 73
1297868 1297868 IN     school 1809690 4600   Merrillville Community School Corp 180969001582 3821 Henry P Fieler Elementary School   Regular School No Elementary KG 04 2017   grade_4                         44.0 48.0                       92.0                         44 48                 92
1297874 1297874 IN     school 1809690 4600   Merrillville Community School Corp 180969001583 3822 Homer Iddings Elementary School   Regular School No Elementary KG 04 2017   grade_4                         43.0 54.0                       97.0                         43 54                 97
1297880 1297880 IN     school 1809690 4600   Merrillville Community School Corp 180969001580 3826 Edgar L Miller Elementary School   Regular School No Elementary KG 04 2017   grade_4                         46.0 30.0                       76.0                         46 30                 76
1297886 1297886 IN     school 1809690 4600   Merrillville Community School Corp 180969001584 3827 John Wood Elementary School   Regular School No Elementary PK 04 2017   grade_4                         28.0 26.0                       54.0                         28 26                 54
1297893 1297893 IN     school 1809690 4600   Merrillville Community School Corp 180969001585 3829 Jonas E Salk Elementary School   Regular School No Elementary KG 04 2017   grade_4                         64.0 65.0                       129.0                         64 65                 129
1297910 1297910 IN     school 1805450 4615   Lake Central School Corporation 180545000983 3837 Kolling Elementary School   Regular School No Elementary KG 04 2017   grade_4                         84.0 74.0                       158.0                         84 74                 158
1297921 1297921 IN     school 1805450 4615   Lake Central School Corporation 180545000980 3839 George Bibich Elementary School   Regular School No Elementary PK 04 2017   grade_4                         49.0 50.0                       99.0                         49 50                 99
1297928 1297928 IN     school 1805450 4615   Lake Central School Corporation 180545000981 3840 James H Watson Elementary School   Regular School No Elementary PK 04 2017   grade_4                         55.0 44.0                       99.0                         55 44                 99
1297940 1297940 IN     school 1805450 4615   Lake Central School Corporation 180545000987 3843 Protsman Elementary School   Regular School No Elementary KG 04 2017   grade_4                         81.0 67.0                       148.0                         81 67                 148
1297946 1297946 IN     school 1805450 4615   Lake Central School Corporation 180545002143 4349 Homan Elementary School   Regular School No Elementary PK 04 2017   grade_4                         54.0 63.0                       117.0                         54 63                 117
1297953 1297953 IN     school 1805450 4615   Lake Central School Corporation 180545000986 4351 Peifer Elementary School   Regular School No Elementary KG 04 2017   grade_4                         48.0 46.0                       94.0                         48 46                 94
1299460 1299460 IN     school 1812360 5360   M S D Warren Township 181236001962 5369 Eastridge Elementary School   Regular School No Elementary KG 04 2017   grade_4                         47.0 34.0                       81.0                         47 34                 81
1299466 1299466 IN     school 1812360 5360   M S D Warren Township 181236001964 5370 Hawthorne Elementary School   Regular School No Elementary KG 04 2017   grade_4                         44.0 42.0                       86.0                         44 42                 86
1299472 1299472 IN     school 1812360 5360   M S D Warren Township 181236001963 5373 Grassy Creek Elementary School   Regular School No Elementary KG 04 2017   grade_4                         49.0 55.0                       104.0                         49 55                 104
1299478 1299478 IN     school 1812360 5360   M S D Warren Township 181236001966 5375 Lakeside Elementary School   Regular School No Elementary KG 04 2017   grade_4                         57.0 42.0                       99.0                         57 42                 99
1299484 1299484 IN     school 1812360 5360   M S D Warren Township 181236001967 5377 Lowell Elementary School   Regular School No Elementary KG 04 2017   grade_4                         58.0 51.0                       109.0                         58 51                 109
1299490 1299490 IN     school 1812360 5360   M S D Warren Township 181236001969 5386 Pleasant Run Elementary School   Regular School No Elementary KG 04 2017   grade_4                         61.0 55.0                       116.0                         61 55                 116
1299496 1299496 IN     school 1812360 5360   M S D Warren Township 181236001971 5389 Sunny Heights Elementary School   Regular School No Elementary KG 04 2017   grade_4                         56.0 42.0                       98.0                         56 42                 98
1299502 1299502 IN     school 1812360 5360   M S D Warren Township 181236001959 5391 Brookview Elementary School   Regular School No Elementary KG 04 2017   grade_4                         63.0 59.0                       122.0                         63 59                 122
1299510 1299510 IN     school 1812360 5360   M S D Warren Township 181236001690 5397 Liberty Park Elementary School   Regular School No Elementary KG 04 2017   grade_4                         53.0 52.0                       105.0                         53 52                 105
1300358 1300358 IN     school 1809060 5485   Plymouth Community School Corp 180906001498 5961 Jefferson Elementary School   Regular School No Elementary PK 04 2017   grade_4                         34.0 16.0                       50.0                         34 16                 50
1300365 1300365 IN     school 1809060 5485   Plymouth Community School Corp 180906001501 5965 Washington Discovery Academy   Regular School No Elementary KG 04 2017   grade_4                         35.0 36.0                       71.0                         35 36                 71
1300371 1300371 IN     school 1809060 5485   Plymouth Community School Corp 180906001502 5969 Webster Elementary School   Regular School No Elementary KG 04 2017   grade_4                         29.0 40.0                       69.0                         29 40                 69
1300408 1300408 IN     school 1806060 5525   Loogootee Community Sch Corp 180606001069 5997 Loogootee Elementary School   Regular School No Elementary KG 04 2017   grade_4                         30.0 39.0                       69.0                         30 39                 69
1301058 1301058 IN     school 1812900 6065   West Noble School Corporation 181290002231 6510 West Noble Elementary School   Regular School No Elementary 02 04 2017   grade_4                         95.0 92.0                       187.0                         95 92                 187
1301309 1301309 IN     school 1802800 6470   Duneland School Corporation 180280000334 6817 Jackson Elementary School   Regular School No Elementary KG 04 2017   grade_4                         37.0 36.0                       73.0                         37 36                 73
1301315 1301315 IN     school 1802800 6470   Duneland School Corporation 180280000332 6819 Brummitt Elementary School   Regular School No Elementary KG 04 2017   grade_4                         35.0 31.0                       66.0                         35 31                 66
1301324 1301324 IN     school 1802800 6470   Duneland School Corporation 180280000335 6823 Liberty Elementary School   Regular School No Elementary KG 04 2017   grade_4                         50.0 48.0                       98.0                         50 48                 98
1301339 1301339 IN     school 1802800 6470   Duneland School Corporation 180280000331 6928 Bailly Elementary School   Regular School No Elementary KG 04 2017   grade_4                         34.0 43.0                       77.0                         34 43                 77

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