enrollments

Data source: Big Local News · About: Big Local

1,060 rows where grade = "grade_4", state = "IN" and year = 2016 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 1,060 ✖

grade ✖

  • grade_4 · 1,060 ✖
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
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
1280881 1280881 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No 1.0 02 04 2016   grade_4                         56.0 54.0                       110.0                         56 54                 110
1281675 1281675 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         49.0 36.0                       85.0                         49 36                 85
1281682 1281682 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No 1.0 PK 04 2016   grade_4                         76.0 75.0                       151.0                         76 75                 151
1281689 1281689 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         71.0 52.0                       123.0                         71 52                 123
1281696 1281696 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No 1.0 PK 04 2016   grade_4                         55.0 41.0                       96.0                         55 41                 96
1281703 1281703 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No 1.0 PK 04 2016   grade_4                         19.0 28.0                       47.0                         19 28                 47
1281756 1281756 IN     school 1800960 670   Brown County School Corporation 180096000173 577 Van Buren Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         19.0 31.0                       50.0                         19 31                 50
1281763 1281763 IN     school 1800960 670   Brown County School Corporation 180096000170 581 Helmsburg Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         18.0 23.0                       41.0                         18 23                 41
1281770 1281770 IN     school 1800960 670   Brown County School Corporation 180096000172 585 Sprunica Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         24.0 26.0                       50.0                         24 26                 50
1281944 1281944 IN     school 1801920 1000   Clarksville Com School Corp 180192000251 845 Clarksville Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         56.0 39.0                       95.0                         56 39                 95
1282785 1282785 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001388 1543 Celestine Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         7.0 12.0                       19.0                         7 12                 19
1282801 1282801 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001390 1577 Dubois Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         27.0 21.0                       48.0                         27 21                 48
1282808 1282808 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001746 1563 Pine Ridge Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         18.0 16.0                       34.0                         18 16                 34
1282815 1282815 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001744 1581 Ferdinand Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         27.0 25.0                       52.0                         27 25                 52
1282948 1282948 IN     school 1802400 2270   Concord Community Schools 180240000270 1721 Concord East Side Elem School   Regular School No 1.0 KG 04 2016   grade_4                         63.0 53.0                       116.0                         63 53                 116
1282954 1282954 IN     school 1802400 2270   Concord Community Schools 180240000272 1723 Concord Ox-Bow Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         49.0 52.0                       101.0                         49 52                 101
1282960 1282960 IN     school 1802400 2270   Concord Community Schools 180240000273 1725 Concord South Side Elem School   Regular School No 1.0 KG 04 2016   grade_4                         50.0 50.0                       100.0                         50 50                 100
1282966 1282966 IN     school 1802400 2270   Concord Community Schools 180240000274 1729 Concord West Side Elem School   Regular School No 1.0 KG 04 2016   grade_4                         57.0 54.0                       111.0                         57 54                 111
1283001 1283001 IN     school 1806600 2275   Middlebury Community Schools 180660000199 1734 Orchard View Sch   Regular School No 1.0 KG 04 2016   grade_4                         0.0 2.0                       2.0                         0 2                 2
1283318 1283318 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001267 1929 Georgetown Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         71.0 79.0                       150.0                         71 79                 150
1283344 1283344 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001281 1943 Slate Run Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         29.0 29.0                       58.0                         29 29                 58
1283350 1283350 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001264 1949 Fairmont Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         37.0 35.0                       72.0                         37 35                 72
1283356 1283356 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001270 1953 Greenville Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         54.0 46.0                       100.0                         54 46                 100
1283362 1283362 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001268 1957 Grant Line School   Regular School No 1.0 KG 04 2016   grade_4                         49.0 62.0                       111.0                         49 62                 111
1283368 1283368 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001269 1961 Green Valley Elementary Sch   Regular School No 1.0 KG 04 2016   grade_4                         33.0 28.0                       61.0                         33 28                 61
1283374 1283374 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741000852 1966 Floyds Knobs Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         68.0 55.0                       123.0                         68 55                 123
1283380 1283380 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002204 1974 Mount Tabor School   Regular School No 1.0 KG 04 2016   grade_4                         86.0 69.0                       155.0                         86 69                 155
1283386 1283386 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001278 1981 S Ellen Jones Elementary Sch   Regular School No 1.0 KG 04 2016   grade_4                         30.0 27.0                       57.0                         30 27                 57
1283463 1283463 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         53.0 54.0                       107.0                         53 54                 107
1283682 1283682 IN     school 1806390 2865   Marion Community Schools 180639001107 2369 Allen Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         37.0 34.0                       71.0                         37 34                 71
1283690 1283690 IN     school 1806390 2865   Marion Community Schools 180639001113 2393 John W Kendall Elem School   Regular School No 1.0 KG 04 2016   grade_4                         22.0 43.0                       65.0                         22 43                 65
1283696 1283696 IN     school 1806390 2865   Marion Community Schools 180639001119 2405 Riverview Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         38.0 37.0                       75.0                         38 37                 75
1283702 1283702 IN     school 1806390 2865   Marion Community Schools 180639001110 2409 Frances Slocum Elem School   Regular School No 1.0 KG 04 2016   grade_4                         33.0 19.0                       52.0                         33 19                 52
1283725 1283725 IN     school 1803090 2940   Eastern Greene Schools 180309000407 2433 Eastern Greene Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         44.0 49.0                       93.0                         44 49                 93
1283797 1283797 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No 1.0 PK 04 2016   grade_4                         73.0 72.0                       145.0                         73 72                 145
1283804 1283804 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002368 2468 New Britton Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         73.0 82.0                       155.0                         73 82                 155
1283810 1283810 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001751 2469 Fishers Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         43.0 47.0                       90.0                         43 47                 90
1283816 1283816 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No 1.0 KG 04 2016   grade_4                         78.0 62.0                       140.0                         78 62                 140
1283822 1283822 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001560 2471 Hoosier Road Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         81.0 78.0                       159.0                         81 78                 159
1283828 1283828 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001750 2473 Fall Creek Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         78.0 92.0                       170.0                         78 92                 170
1283834 1283834 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002060 2474 Geist Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         86.0 84.0                       170.0                         86 84                 170
1283840 1283840 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000373 2475 Lantern Road Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         82.0 59.0                       141.0                         82 59                 141
1283852 1283852 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000967 2481 Harrison Parkway Elem School   Regular School No 1.0 KG 04 2016   grade_4                         74.0 64.0                       138.0                         74 64                 138
1283858 1283858 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002061 2482 Sand Creek Elementary   Regular School No 1.0 KG 04 2016   grade_4                         70.0 58.0                       128.0                         70 58                 128
1283864 1283864 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002429 2483 Thorpe Creek Elementary   Regular School No 1.0 KG 04 2016   grade_4                         74.0 77.0                       151.0                         74 77                 151
1283889 1283889 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001749 2497 Durbin Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         43.0 32.0                       75.0                         43 32                 75
1283925 1283925 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         64.0 61.0                       125.0                         64 61                 125
1283937 1283937 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         48.0 52.0                       100.0                         48 52                 100
1283944 1283944 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         47.0 38.0                       85.0                         47 38                 85
1283950 1283950 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         57.0 52.0                       109.0                         57 52                 109
1283957 1283957 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         19.0 26.0                       45.0                         19 26                 45
1283967 1283967 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2016   grade_4                         74.0 40.0                       114.0                         74 40                 114
1284450 1284450 IN     school 1800270 3315   Avon Community School Corp 180027002480 2726 River Birch Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         93.0 69.0                       162.0                         93 69                 162
1284466 1284466 IN     school 1800270 3315   Avon Community School Corp 180027000059 2733 Maple Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         28.0 23.0                       51.0                         28 23                 51
1284472 1284472 IN     school 1800270 3315   Avon Community School Corp 180027000058 2734 White Oak Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         20.0 21.0                       41.0                         20 21                 41
1284479 1284479 IN     school 1800270 3315   Avon Community School Corp 180027000390 2735 Sycamore Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         45.0 36.0                       81.0                         45 36                 81
1284494 1284494 IN     school 1800270 3315   Avon Community School Corp 180027002194 2738 Cedar Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         79.0 52.0                       131.0                         79 52                 131
1284500 1284500 IN     school 1800270 3315   Avon Community School Corp 180027002330 2739 Pine Tree Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         37.0 24.0                       61.0                         37 24                 61
1284506 1284506 IN     school 1800270 3315   Avon Community School Corp 180027001675 2740 Hickory Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         66.0 61.0                       127.0                         66 61                 127
1284531 1284531 IN     school 1802550 3325   Danville Community School Corp 180255000307 2745 South Elementary School   Regular School No 1.0 03 04 2016   grade_4                         82.0 94.0                       176.0                         82 94                 176
1285254 1285254 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000244 3401 Clark Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         52.0 68.0                       120.0                         52 68                 120
1285272 1285272 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000247 3425 Whiteland Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         33.0 36.0                       69.0                         33 36                 69
1285281 1285281 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000243 3429 Break-O-Day Elementary School   Regular School No 1.0 02 04 2016   grade_4                         99.0 88.0                       187.0                         99 88                 187
1285286 1285286 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189002411 3430 Pleasant Crossing Elementary   Regular School No 1.0 KG 04 2016   grade_4                         81.0 63.0                       144.0                         81 63                 144
1285358 1285358 IN     school 1803690 4225   Franklin Community School Corp 180369000583 3413 Needham Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         44.0 38.0                       82.0                         44 38                 82
1285364 1285364 IN     school 1803690 4225   Franklin Community School Corp 180369000585 3433 Union Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         13.0 15.0                       28.0                         13 15                 28
1285381 1285381 IN     school 1803690 4225   Franklin Community School Corp 180369000584 3461 Northwood Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         52.0 48.0                       100.0                         52 48                 100
1285388 1285388 IN     school 1803690 4225   Franklin Community School Corp 180369000586 3465 Webb Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         31.0 34.0                       65.0                         31 34                 65
1285394 1285394 IN     school 1803690 4225   Franklin Community School Corp 180369001030 3467 Creekside Elementary Sch   Regular School No 1.0 KG 04 2016   grade_4                         56.0 61.0                       117.0                         56 61                 117
1285683 1285683 IN     school 1809300 4515   Prairie Heights Com Sch Corp 180930001524 3686 Prairie Heights Elem Sch   Regular School No 1.0 KG 04 2016   grade_4                         60.0 43.0                       103.0                         60 43                 103
1285708 1285708 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         26.0 46.0                       72.0                         26 46                 72
1285725 1285725 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No 1.0 KG 04 2016   grade_4                         40.0 37.0                       77.0                         40 37                 77
1285818 1285818 IN     school 1809690 4600   Merrillville Community School 180969001582 3821 Henry P Fieler Elem Sch   Regular School No 1.0 KG 04 2016   grade_4                         63.0 49.0                       112.0                         63 49                 112
1285824 1285824 IN     school 1809690 4600   Merrillville Community School 180969001583 3822 Homer Iddings Elem Sch   Regular School No 1.0 KG 04 2016   grade_4                         60.0 49.0                       109.0                         60 49                 109
1285830 1285830 IN     school 1809690 4600   Merrillville Community School 180969001580 3826 Edgar L Miller Elem Sch   Regular School No 1.0 KG 04 2016   grade_4                         33.0 31.0                       64.0                         33 31                 64
1285836 1285836 IN     school 1809690 4600   Merrillville Community School 180969001584 3827 John Wood Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         29.0 19.0                       48.0                         29 19                 48
1285843 1285843 IN     school 1809690 4600   Merrillville Community School 180969001585 3829 Jonas E Salk Elem Sch   Regular School No 1.0 KG 04 2016   grade_4                         69.0 65.0                       134.0                         69 65                 134
1285860 1285860 IN     school 1805450 4615   Lake Central School Corp 180545000983 3837 Kolling Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         77.0 60.0                       137.0                         77 60                 137
1285871 1285871 IN     school 1805450 4615   Lake Central School Corp 180545000980 3839 George Bibich Elementary Sch   Regular School No 1.0 KG 04 2016   grade_4                         53.0 41.0                       94.0                         53 41                 94
1285877 1285877 IN     school 1805450 4615   Lake Central School Corp 180545000981 3840 James H Watson Elem Sch   Regular School No 1.0 PK 04 2016   grade_4                         62.0 47.0                       109.0                         62 47                 109
1285889 1285889 IN     school 1805450 4615   Lake Central School Corp 180545000987 3843 Protsman Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         62.0 69.0                       131.0                         62 69                 131
1285896 1285896 IN     school 1805450 4615   Lake Central School Corp 180545002143 4349 Homan Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         54.0 47.0                       101.0                         54 47                 101
1285903 1285903 IN     school 1805450 4615   Lake Central School Corp 180545000986 4351 Peifer Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         68.0 41.0                       109.0                         68 41                 109
1287423 1287423 IN     school 1812360 5360   M S D Warren Township 181236001962 5369 Eastridge Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         48.0 36.0                       84.0                         48 36                 84
1287429 1287429 IN     school 1812360 5360   M S D Warren Township 181236001964 5370 Hawthorne Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         40.0 39.0                       79.0                         40 39                 79
1287435 1287435 IN     school 1812360 5360   M S D Warren Township 181236001963 5373 Grassy Creek Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         46.0 36.0                       82.0                         46 36                 82
1287441 1287441 IN     school 1812360 5360   M S D Warren Township 181236001966 5375 Lakeside Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         70.0 59.0                       129.0                         70 59                 129
1287447 1287447 IN     school 1812360 5360   M S D Warren Township 181236001967 5377 Lowell Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         54.0 74.0                       128.0                         54 74                 128
1287453 1287453 IN     school 1812360 5360   M S D Warren Township 181236001969 5386 Pleasant Run Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         53.0 54.0                       107.0                         53 54                 107
1287459 1287459 IN     school 1812360 5360   M S D Warren Township 181236001971 5389 Sunny Heights Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         47.0 47.0                       94.0                         47 47                 94
1287465 1287465 IN     school 1812360 5360   M S D Warren Township 181236001959 5391 Brookview Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         54.0 58.0                       112.0                         54 58                 112
1287473 1287473 IN     school 1812360 5360   M S D Warren Township 181236001690 5397 Liberty Park Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         56.0 56.0                       112.0                         56 56                 112
1288333 1288333 IN     school 1809060 5485   Plymouth Community School Corp 180906001498 5961 Jefferson Elementary School   Regular School No 1.0 PK 04 2016   grade_4                         27.0 23.0                       50.0                         27 23                 50
1288340 1288340 IN     school 1809060 5485   Plymouth Community School Corp 180906001501 5965 Washington Discovery Academy   Regular School No 1.0 KG 04 2016   grade_4                         35.0 44.0                       79.0                         35 44                 79
1288346 1288346 IN     school 1809060 5485   Plymouth Community School Corp 180906001502 5969 Webster Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         33.0 43.0                       76.0                         33 43                 76
1288383 1288383 IN     school 1806060 5525   Loogootee Community Sch Corp 180606001069 5997 Loogootee Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         35.0 25.0                       60.0                         35 25                 60
1288448 1288448 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No 1.0 03 04 2016   grade_4                         67.0 66.0                       133.0                         67 66                 133
1289029 1289029 IN     school 1812900 6065   West Noble School Corporation 181290002231 6510 West Noble Elementary School   Regular School No 1.0 02 04 2016   grade_4                         79.0 103.0                       182.0                         79 103                 182
1289289 1289289 IN     school 1802800 6470   Duneland School Corporation 180280000334 6817 Jackson Elementary School   Regular School No 1.0 KG 04 2016   grade_4                         31.0 23.0                       54.0                         31 23                 54

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