enrollments

Data source: Big Local News · About: Big Local

1,045 rows where grade = "grade_3", state = "IN" and year = 2019 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 1,045 ✖

grade ✖

  • grade_3 · 1,045 ✖
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
1758212 1758212 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_3                         5.0 0.0                       5.0                         5 0                 5
1752082 1752082 IN     school 1802850 255   East Allen County Schools 180285000954 291 Cedarville Elementary School   Regular School No Elementary KG 03 2019   grade_3                         108.0 114.0                       222.0                         108 114                 222
1753614 1753614 IN     school 1806600 2275   Middlebury Community Schools 180660001163 1656 Jefferson Elementary School   Regular School No Elementary KG 03 2019   grade_3                         56.0 51.0                       107.0                         56 51                 107
1753625 1753625 IN     school 1806600 2275   Middlebury Community Schools 180660001166 1697 York Elementary School   Regular School No Elementary KG 03 2019   grade_3                         37.0 28.0                       65.0                         37 28                 65
1753634 1753634 IN     school 1806600 2275   Middlebury Community Schools 180660001164 1732 Middlebury Elementary School   Regular School No Elementary KG 03 2019   grade_3                         45.0 29.0                       74.0                         45 29                 74
1753645 1753645 IN     school 1806600 2275   Middlebury Community Schools 180660000199 1734 Orchard View School   Regular School No Elementary KG 03 2019   grade_3                         46.0 51.0                       97.0                         46 51                 97
1754842 1754842 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000694 2581 Eden Elementary School   Regular School No Elementary KG 03 2019   grade_3                         19.0 24.0                       43.0                         19 24                 43
1754847 1754847 IN     school 1804050 3125   Greenfield-Central Com Schools 180405001665 2588 JB Stephens Elementary School   Regular School No Elementary KG 03 2019   grade_3                         66.0 54.0                       120.0                         66 54                 120
1754861 1754861 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000697 2597 Harris Elementary School   Regular School No Elementary KG 03 2019   grade_3                         31.0 33.0                       64.0                         31 33                 64
1754866 1754866 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000702 2609 Weston Elementary School   Regular School No Elementary KG 03 2019   grade_3                         44.0 38.0                       82.0                         44 38                 82
1754968 1754968 IN     school 1810360 3190   South Harrison Com Schools 181036001693 2645 Corydon Elementary School   Regular School No Elementary PK 03 2019   grade_3                         59.0 66.0                       125.0                         59 66                 125
1755165 1755165 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No Elementary KG 03 2019   grade_3                         1.0 0.0                       1.0                         1 0                 1
1755333 1755333 IN     school 1807440 3445   New Castle Community School Corp 180744001289 2853 Sunnyside Elementary School   Regular School No Elementary KG 03 2019   grade_3                         10.0 1.0                       11.0                         10 1                 11
1755365 1755365 IN     school 1801060 3455   C A Beard Memorial School Corp 180106002290 2887 Knightstown Elementary School   Regular School No Elementary PK 03 2019   grade_3                         35.0 40.0                       75.0                         35 40                 75
1755448 1755448 IN     school 1804470 3490   Western School Corporation 180447000755 2935 Western Primary School   Regular School No Elementary KG 03 2019   grade_3                         1.0 0.0                       1.0                         1 0                 1
1755687 1755687 IN     school 1805280 3785   Kankakee Valley School Corp 180528000932 3184 DeMotte Elementary School   Regular School No Elementary PK 03 2019   grade_3                         94.0 93.0                       187.0                         94 93                 187
1755693 1755693 IN     school 1805280 3785   Kankakee Valley School Corp 180528000935 3197 Wheatfield Elementary School   Regular School No Elementary KG 03 2019   grade_3                         38.0 35.0                       73.0                         38 35                 73
1758264 1758264 IN     school 1800450 5380   Beech Grove City Schools 180045000094 5457 Central Elementary School   Regular School No Elementary 02 03 2019   grade_3                         98.0 121.0                       219.0                         98 121                 219
1759263 1759263 IN     school 1802460 5855   Crawfordsville Community Schools 180246000291 6301 Meredith Nicholson Elementary Sch   Regular School No Elementary 02 03 2019   grade_3                         92.0 103.0                       195.0                         92 103                 195
1759900 1759900 IN     school 1809180 6520   Porter Township School Corp 180918001522 6840 Porter Lakes Elementary School   Regular School No Elementary PK 03 2019   grade_3                         50.0 49.0                       99.0                         50 49                 99
1761509 1761509 IN     school 1812870 7875   West Lafayette Com School Corp 181287002043 8138 Cumberland Elementary School   Regular School No Elementary KG 03 2019   grade_3                         100.0 99.0                       199.0                         100 99                 199
1762079 1762079 IN     school 1806270 8045   Manchester Community Schools 180627001101 8633 Manchester Elementary School   Regular School No Elementary PK 03 2019   grade_3                         49.0 53.0                       102.0                         49 53                 102
1762124 1762124 IN     school 1812180 8050   M S D Wabash County Schools 181218001944 8677 Metro North Elementary School   Regular School No Elementary PK 03 2019   grade_3                         35.0 31.0                       66.0                         35 31                 66
1763496 1763496 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   grade_3                         6.0 8.0                       14.0                         6 8                 14
1752350 1752350 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No Elementary PK 04 2019   grade_3                         28.0 31.0                       59.0                         28 31                 59
1752357 1752357 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2019   grade_3                         71.0 74.0                       145.0                         71 74                 145
1752364 1752364 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No Elementary PK 04 2019   grade_3                         71.0 64.0                       135.0                         71 64                 135
1752371 1752371 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2019   grade_3                         47.0 54.0                       101.0                         47 54                 101
1752378 1752378 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2019   grade_3                         55.0 49.0                       104.0                         55 49                 104
1752430 1752430 IN     school 1800960 670   Brown County School Corporation 180096000173 577 Van Buren Elementary School   Regular School No Elementary PK 04 2019   grade_3                         18.0 23.0                       41.0                         18 23                 41
1752437 1752437 IN     school 1800960 670   Brown County School Corporation 180096000170 581 Helmsburg Elementary School   Regular School No Elementary PK 04 2019   grade_3                         18.0 21.0                       39.0                         18 21                 39
1752444 1752444 IN     school 1800960 670   Brown County School Corporation 180096000172 585 Sprunica Elementary School   Regular School No Elementary PK 04 2019   grade_3                         27.0 20.0                       47.0                         27 20                 47
1752628 1752628 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2019   grade_3                         56.0 48.0                       104.0                         56 48                 104
1753424 1753424 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001388 1543 Celestine Elementary School   Regular School No Elementary KG 04 2019   grade_3                         7.0 7.0                       14.0                         7 7                 14
1753440 1753440 IN     school 1808120 2040   Northeast Dubois Co Sch Corp 180812001390 1577 Dubois Elementary School   Regular School No Elementary PK 04 2019   grade_3                         20.0 21.0                       41.0                         20 21                 41
1753447 1753447 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001746 1563 Pine Ridge Elementary School   Regular School No Elementary PK 04 2019   grade_3                         14.0 18.0                       32.0                         14 18                 32
1753454 1753454 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001744 1581 Ferdinand Elementary School   Regular School No Elementary PK 04 2019   grade_3                         20.0 28.0                       48.0                         20 28                 48
1753589 1753589 IN     school 1802400 2270   Concord Community Schools 180240000270 1721 Concord East Side Elementary Sch   Regular School No Elementary KG 04 2019   grade_3                         52.0 51.0                       103.0                         52 51                 103
1753602 1753602 IN     school 1802400 2270   Concord Community Schools 180240000273 1725 Concord South Side Elementary Sch   Regular School No Elementary KG 04 2019   grade_3                         48.0 34.0                       82.0                         48 34                 82
1753608 1753608 IN     school 1802400 2270   Concord Community Schools 180240000274 1729 Concord West Side Elem School   Regular School No Elementary KG 04 2019   grade_3                         53.0 67.0                       120.0                         53 67                 120
1753967 1753967 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001267 1929 Georgetown Elementary School   Regular School No Elementary KG 04 2019   grade_3                         61.0 49.0                       110.0                         61 49                 110
1753993 1753993 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001281 1943 Slate Run Elementary School   Regular School No Elementary KG 04 2019   grade_3                         32.0 25.0                       57.0                         32 25                 57
1753999 1753999 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001264 1949 Fairmont Elementary School   Regular School No Elementary KG 04 2019   grade_3                         35.0 31.0                       66.0                         35 31                 66
1754005 1754005 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001270 1953 Greenville Elementary School   Regular School No Elementary KG 04 2019   grade_3                         36.0 36.0                       72.0                         36 36                 72
1754011 1754011 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001268 1957 Grant Line Elementary School   Regular School No Elementary KG 04 2019   grade_3                         52.0 61.0                       113.0                         52 61                 113
1754017 1754017 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001269 1961 Green Valley Elementary School   Regular School No Elementary PK 04 2019   grade_3                         37.0 36.0                       73.0                         37 36                 73
1754024 1754024 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741000852 1966 Floyds Knobs Elementary School   Regular School No Elementary KG 04 2019   grade_3                         81.0 84.0                       165.0                         81 84                 165
1754030 1754030 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002204 1974 Mount Tabor Elementary School   Regular School No Elementary KG 04 2019   grade_3                         75.0 85.0                       160.0                         75 85                 160
1754036 1754036 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001278 1981 S Ellen Jones Elementary School   Regular School No Elementary PK 04 2019   grade_3                         20.0 15.0                       35.0                         20 15                 35
1754332 1754332 IN     school 1806390 2865   Marion Community Schools 180639001107 2369 Allen Elementary School   Regular School No Elementary KG 04 2019   grade_3                         47.0 31.0                       78.0                         47 31                 78
1754340 1754340 IN     school 1806390 2865   Marion Community Schools 180639001113 2393 John W Kendall Elem School   Regular School No Elementary KG 04 2019   grade_3                         37.0 39.0                       76.0                         37 39                 76
1754346 1754346 IN     school 1806390 2865   Marion Community Schools 180639001119 2405 Riverview Elementary School   Regular School No Elementary KG 04 2019   grade_3                         37.0 27.0                       64.0                         37 27                 64
1754352 1754352 IN     school 1806390 2865   Marion Community Schools 180639001110 2409 Frances Slocum Elem School   Regular School No Elementary KG 04 2019   grade_3                         28.0 29.0                       57.0                         28 29                 57
1754375 1754375 IN     school 1803090 2940   Eastern Greene Schools 180309000407 2433 Eastern Greene Elementary School   Regular School No Elementary PK 04 2019   grade_3                         58.0 45.0                       103.0                         58 45                 103
1754433 1754433 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2019   grade_3                         30.0 29.0                       59.0                         30 29                 59
1754440 1754440 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No Elementary KG 04 2019   grade_3                         74.0 83.0                       157.0                         74 83                 157
1754446 1754446 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002368 2468 New Britton Elementary School   Regular School No Elementary KG 04 2019   grade_3                         61.0 82.0                       143.0                         61 82                 143
1754452 1754452 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001751 2469 Fishers Elementary School   Regular School No Elementary KG 04 2019   grade_3                         38.0 54.0                       92.0                         38 54                 92
1754458 1754458 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No Elementary KG 04 2019   grade_3                         59.0 53.0                       112.0                         59 53                 112
1754464 1754464 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001560 2471 Hoosier Road Elementary School   Regular School No Elementary KG 04 2019   grade_3                         74.0 50.0                       124.0                         74 50                 124
1754470 1754470 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001750 2473 Fall Creek Elementary School   Regular School No Elementary KG 04 2019   grade_3                         59.0 67.0                       126.0                         59 67                 126
1754476 1754476 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002060 2474 Geist Elementary School   Regular School No Elementary KG 04 2019   grade_3                         89.0 100.0                       189.0                         89 100                 189
1754482 1754482 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000373 2475 Lantern Road Elementary School   Regular School No Elementary KG 04 2019   grade_3                         81.0 92.0                       173.0                         81 92                 173
1754494 1754494 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000967 2481 Harrison Parkway Elementary School   Regular School No Elementary KG 04 2019   grade_3                         60.0 49.0                       109.0                         60 49                 109
1754500 1754500 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002061 2482 Sand Creek Elementary   Regular School No Elementary KG 04 2019   grade_3                         67.0 57.0                       124.0                         67 57                 124
1754506 1754506 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002429 2483 Thorpe Creek Elementary   Regular School No Elementary KG 04 2019   grade_3                         93.0 100.0                       193.0                         93 100                 193
1754531 1754531 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001749 2497 Durbin Elementary School   Regular School No Elementary KG 04 2019   grade_3                         47.0 36.0                       83.0                         47 36                 83
1754569 1754569 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2019   grade_3                         49.0 40.0                       89.0                         49 40                 89
1754582 1754582 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2019   grade_3                         53.0 63.0                       116.0                         53 63                 116
1754589 1754589 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2019   grade_3                         46.0 37.0                       83.0                         46 37                 83
1754596 1754596 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2019   grade_3                         71.0 46.0                       117.0                         71 46                 117
1754603 1754603 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2019   grade_3                         64.0 56.0                       120.0                         64 56                 120
1754612 1754612 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2019   grade_3                         72.0 45.0                       117.0                         72 45                 117
1754807 1754807 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001758 2563 Brandywine Elementary School   Regular School No Elementary KG 04 2019   grade_3                         28.0 26.0                       54.0                         28 26                 54
1754813 1754813 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001760 2564 New Palestine Elementary School   Regular School No Elementary PK 04 2019   grade_3                         52.0 49.0                       101.0                         52 49                 101
1754829 1754829 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001407 2567 Sugar Creek Elementary Sch   Regular School No Elementary KG 04 2019   grade_3                         70.0 63.0                       133.0                         70 63                 133
1755102 1755102 IN     school 1800270 3315   Avon Community School Corp 180027002480 2726 River Birch Elementary School   Regular School No Elementary KG 04 2019   grade_3                         81.0 83.0                       164.0                         81 83                 164
1755118 1755118 IN     school 1800270 3315   Avon Community School Corp 180027000059 2733 Maple Elementary School   Regular School No Elementary PK 04 2019   grade_3                         32.0 32.0                       64.0                         32 32                 64
1755125 1755125 IN     school 1800270 3315   Avon Community School Corp 180027000058 2734 White Oak Elementary School   Regular School No Elementary PK 04 2019   grade_3                         36.0 30.0                       66.0                         36 30                 66
1755132 1755132 IN     school 1800270 3315   Avon Community School Corp 180027000390 2735 Sycamore Elementary School   Regular School No Elementary KG 04 2019   grade_3                         50.0 49.0                       99.0                         50 49                 99
1755147 1755147 IN     school 1800270 3315   Avon Community School Corp 180027002194 2738 Cedar Elementary School   Regular School No Elementary KG 04 2019   grade_3                         79.0 65.0                       144.0                         79 65                 144
1755153 1755153 IN     school 1800270 3315   Avon Community School Corp 180027002330 2739 Pine Tree Elementary School   Regular School No Elementary KG 04 2019   grade_3                         30.0 36.0                       66.0                         30 36                 66
1755159 1755159 IN     school 1800270 3315   Avon Community School Corp 180027001675 2740 Hickory Elementary School   Regular School No Elementary KG 04 2019   grade_3                         54.0 49.0                       103.0                         54 49                 103
1755181 1755181 IN     school 1802550 3325   Danville Community School Corp 180255000307 2745 South Elementary School   Regular School No Elementary 03 04 2019   grade_3                         93.0 105.0                       198.0                         93 105                 198
1755768 1755768 IN     school 1806120 3995   Madison Consolidated Schools 180612001085 3301 Deputy Elementary School   Regular School No Elementary PK 04 2019   grade_3                         11.0 8.0                       19.0                         11 8                 19
1755787 1755787 IN     school 1806120 3995   Madison Consolidated Schools 180612001093 3321 Rykers' Ridge Elementary School   Regular School No Elementary PK 04 2019   grade_3                         12.0 20.0                       32.0                         12 20                 32
1755796 1755796 IN     school 1806120 3995   Madison Consolidated Schools 180612001089 3329 Lydia Middleton Elementary School   Regular School No Elementary PK 04 2019   grade_3                         24.0 30.0                       54.0                         24 30                 54
1755998 1755998 IN     school 1803690 4225   Franklin Community School Corp 180369000583 3413 Needham Elementary School   Regular School No Elementary KG 04 2019   grade_3                         58.0 35.0                       93.0                         58 35                 93
1756004 1756004 IN     school 1803690 4225   Franklin Community School Corp 180369000585 3433 Union Elementary School   Regular School No Elementary KG 04 2019   grade_3                         15.0 15.0                       30.0                         15 15                 30
1756022 1756022 IN     school 1803690 4225   Franklin Community School Corp 180369000584 3461 Northwood Elementary School   Regular School No Elementary PK 04 2019   grade_3                         45.0 49.0                       94.0                         45 49                 94
1756029 1756029 IN     school 1803690 4225   Franklin Community School Corp 180369000586 3465 Webb Elementary School   Regular School No Elementary KG 04 2019   grade_3                         34.0 28.0                       62.0                         34 28                 62
1756035 1756035 IN     school 1803690 4225   Franklin Community School Corp 180369001030 3467 Creekside Elementary School   Regular School No Elementary KG 04 2019   grade_3                         59.0 63.0                       122.0                         59 63                 122
1756325 1756325 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001524 3686 Prairie Heights Elementary School   Regular School No Elementary KG 04 2019   grade_3                         48.0 52.0                       100.0                         48 52                 100
1756351 1756351 IN     school 1813110 4525   Westview School Corporation 181311002078 3698 Topeka Elementary School   Regular School No Elementary KG 04 2019   grade_3                         32.0 25.0                       57.0                         32 25                 57
1756369 1756369 IN     school 1813110 4525   Westview School Corporation 181311002077 3714 Shipshewana-Scott Elementary Sch   Regular School No Elementary KG 04 2019   grade_3                         33.0 33.0                       66.0                         33 33                 66
1756406 1756406 IN     school 1804350 4580   Hanover Community School Corp 180435000754 3781 Jane Ball Elementary School   Regular School No Elementary PK 04 2019   grade_3                         47.0 42.0                       89.0                         47 42                 89
1756413 1756413 IN     school 1804350 4580   Hanover Community School Corp 180435000871 3782 Lincoln Elementary School   Regular School No Elementary KG 04 2019   grade_3                         46.0 46.0                       92.0                         46 46                 92
1756463 1756463 IN     school 1809690 4600   Merrillville Community School Corp 180969001582 3821 Henry P Fieler Elementary School   Regular School No Elementary PK 04 2019   grade_3                         55.0 55.0                       110.0                         55 55                 110
1756470 1756470 IN     school 1809690 4600   Merrillville Community School Corp 180969001583 3822 Homer Iddings Elementary School   Regular School No Elementary KG 04 2019   grade_3                         49.0 67.0                       116.0                         49 67                 116
1756476 1756476 IN     school 1809690 4600   Merrillville Community School Corp 180969001580 3826 Edgar L Miller Elementary School   Regular School No Elementary KG 04 2019   grade_3                         44.0 44.0                       88.0                         44 44                 88

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);