enrollments

Data source: Big Local News · About: Big Local

1,046 rows where grade = "grade_2", state = "IN" and year = 2020 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,046 ✖

grade ✖

  • grade_2 · 1,046 ✖
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
1907998 1907998 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 02 09 2020   grade_2                         1.0 0.0                       1.0                         1 0                 1
1914399 1914399 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No Elementary KG 04 2020   grade_2                         0.0 1.0                       1.0                         0 1                 1
1918107 1918107 IN     school 1800205 8690   Dynamic Minds Academy 180020502673 8692 Dynamic Minds Academy   Regular School Yes Other KG 12 2020   grade_2                         1.0 0.0                       1.0                         1 0                 1
1907146 1907146 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2020   grade_2                         46.0 54.0                       100.0                         46 54                 100
1910200 1910200 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No Elementary PK 05 2020   grade_2                         55.0 45.0                       100.0                         55 45                 100
1910482 1910482 IN     school 1801020 3305   Brownsburg Community School Corp 180102000994 2706 Brown Elementary School   Regular School No Elementary KG 05 2020   grade_2                         56.0 44.0                       100.0                         56 44                 100
1911098 1911098 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No Elementary PK 05 2020   grade_2                         49.0 51.0                       100.0                         49 51                 100
1911326 1911326 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000244 3401 Clark Elementary School   Regular School No Elementary KG 05 2020   grade_2                         50.0 50.0                       100.0                         50 50                 100
1913024 1913024 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2020   grade_2                         49.0 51.0                       100.0                         49 51                 100
1917213 1917213 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000487 8365 Vogel Elementary School   Regular School No Elementary KG 06 2020   grade_2                         56.0 44.0                       100.0                         56 44                 100
1907917 1907917 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No Elementary PK 05 2020   grade_2                         60.0 41.0                       101.0                         60 41                 101
1911554 1911554 IN     school 1807830 4315   North Knox School Corp 180783001332 3521 North Knox Primary School   Regular School No Elementary KG 02 2020   grade_2                         55.0 46.0                       101.0                         55 46                 101
1913183 1913183 IN     school 1805670 5330   M S D Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No Elementary 01 06 2020   grade_2                         45.0 56.0                       101.0                         45 56                 101
1913206 1913206 IN     school 1805670 5330   M S D Lawrence Township 180567001066 5299 Sunnyside Elementary School   Regular School No Elementary 01 06 2020   grade_2                         50.0 51.0                       101.0                         50 51                 101
1913299 1913299 IN     school 1808820 5340   Perry Township Schools 180882001470 5351 Winchester Village Elementary   Regular School No Elementary PK 05 2020   grade_2                         41.0 60.0                       101.0                         41 60                 101
1913307 1913307 IN     school 1808820 5340   Perry Township Schools 180882001687 5366 Jeremiah Gray Elementary School   Regular School No Elementary 01 05 2020   grade_2                         52.0 49.0                       101.0                         52 49                 101
1913451 1913451 IN     school 1812360 5360   M S D Warren Township 181236001969 5386 Pleasant Run Elementary School   Regular School No Elementary KG 04 2020   grade_2                         50.0 51.0                       101.0                         50 51                 101
1916163 1916163 IN     school 1810290 7205   South Bend Community School Corp 181029001646 7545 Harrison Elementary School   Regular School No Elementary KG 05 2020   grade_2                         44.0 57.0                       101.0                         44 57                 101
1916385 1916385 IN     school 1808310 7350   Northwestern Con School Corp 180831001424 7691 Triton Central Elementary School   Regular School No Elementary PK 04 2020   grade_2                         54.0 47.0                       101.0                         54 47                 101
1916451 1916451 IN     school 1810140 7365   Shelbyville Central Schools 181014001633 7733 William F Loper Elementary School   Regular School No Elementary KG 05 2020   grade_2                         55.0 46.0                       101.0                         55 46                 101
1916742 1916742 IN     school 1805400 7855   Lafayette School Corporation 180540000963 8089 Edgelea Elementary School   Regular School No Elementary KG 04 2020   grade_2                         56.0 45.0                       101.0                         56 45                 101
1918484 1918484 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2020   grade_2                         54.0 47.0                       101.0                         54 47                 101
1909074 1909074 IN     school 1806600 2275   Middlebury Community Schools 180660000199 1734 Orchard View School   Regular School No Elementary KG 04 2020   grade_2                         46.0 56.0                       102.0                         46 56                 102
1909271 1909271 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No Elementary KG 05 2020   grade_2                         53.0 49.0                       102.0                         53 49                 102
1910648 1910648 IN     school 1808970 3330   Plainfield Community School Corp 180897001493 2751 Central Elementary School   Regular School No Elementary KG 05 2020   grade_2                         53.0 49.0                       102.0                         53 49                 102
1910841 1910841 IN     school 1802040 3470   Northwestern School Corp 180204000254 2904 Northwestern Elementary School   Regular School No Elementary KG 06 2020   grade_2                         52.0 50.0                       102.0                         52 50                 102
1911056 1911056 IN     school 1810080 3675   Seymour Community Schools 181008001617 3135 Margaret R Brown Elementary School   Regular School No Elementary KG 05 2020   grade_2                         54.0 48.0                       102.0                         54 48                 102
1912017 1912017 IN     school 1811460 4645   Tri-Creek School Corporation 181146002360 3848 Three Creeks Elem School   Regular School No Elementary KG 05 2020   grade_2                         60.0 42.0                       102.0                         60 42                 102
1912336 1912336 IN     school 1804320 4710   School City of Hammond 180432000751 4455 Washington Irving Elementary Sch   Regular School No Elementary PK 05 2020   grade_2                         56.0 46.0                       102.0                         56 46                 102
1912848 1912848 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002049 5009 Frankton Elementary School   Regular School No Elementary PK 06 2020   grade_2                         63.0 39.0                       102.0                         63 39                 102
1912965 1912965 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 04 2020   grade_2                         50.0 52.0                       102.0                         50 52                 102
1912971 1912971 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 04 2020   grade_2                         62.0 40.0                       102.0                         62 40                 102
1915131 1915131 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001282 6745 William Tell Elementary School   Regular School No Elementary PK 06 2020   grade_2                         59.0 43.0                       102.0                         59 43                 102
1912086 1912086 IN     school 1802490 4660   Crown Point Community School Corp 180249000298 3905 Solon Robinson Elementary School   Regular School No Elementary KG 05 2020   grade_2                         46.0 57.0                       103.0                         46 57                 103
1912898 1912898 IN     school 1810440 5255   South Madison Com Sch Corp 181044001676 5064 Maple Ridge Elementary School   Regular School No Elementary KG 06 2020   grade_2                         52.0 51.0                       103.0                         52 51                 103
1913036 1913036 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2020   grade_2                         59.0 44.0                       103.0                         59 44                 103
1916181 1916181 IN     school 1810290 7205   South Bend Community School Corp 181029001663 7555 Kennedy Academy   Regular School No Elementary KG 05 2020   grade_2                         50.0 53.0                       103.0                         50 53                 103
1916811 1916811 IN     school 1811340 7865   Tippecanoe School Corp 181134001826 8007 Hershey Elementary School   Regular School No Elementary KG 05 2020   grade_2                         48.0 55.0                       103.0                         48 55                 103
1917458 1917458 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No Elementary PK 05 2020   grade_2                         54.0 49.0                       103.0                         54 49                 103
1907275 1907275 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2020   grade_2                         66.0 38.0                       104.0                         66 38                 104
1910036 1910036 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2020   grade_2                         61.0 43.0                       104.0                         61 43                 104
1910533 1910533 IN     school 1801020 3305   Brownsburg Community School Corp 180102001570 2727 Cardinal Elementary School   Regular School No Elementary KG 05 2020   grade_2                         57.0 47.0                       104.0                         57 47                 104
1910727 1910727 IN     school 1808280 3435   Shenandoah School Corporation 180828002356 2815 Shenandoah Elementary School   Regular School No Elementary PK 05 2020   grade_2                         46.0 58.0                       104.0                         46 58                 104
1907305 1907305 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary School   Regular School No Elementary PK 05 2020   grade_2                         51.0 54.0                       105.0                         51 54                 105
1908675 1908675 IN     school 1802660 1875   Delaware Community School Corp 180266000324 1365 Royerton Elementary School   Regular School No Elementary KG 05 2020   grade_2                         53.0 52.0                       105.0                         53 52                 105
1910604 1910604 IN     school 1800270 3315   Avon Community School Corp 180027001675 2740 Hickory Elementary School   Regular School No Elementary KG 04 2020   grade_2                         56.0 49.0                       105.0                         56 49                 105
1911138 1911138 IN     school 1805280 3785   Kankakee Valley School Corp 180528000935 3197 Wheatfield Elementary School   Regular School No Elementary KG 03 2020   grade_2                         57.0 48.0                       105.0                         57 48                 105
1912450 1912450 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2020   grade_2                         48.0 57.0                       105.0                         48 57                 105
1913283 1913283 IN     school 1808820 5340   Perry Township Schools 180882001460 5345 Homecroft Elementary School   Regular School No Elementary PK 05 2020   grade_2                         55.0 50.0                       105.0                         55 50                 105
1913354 1913354 IN     school 1808910 5350   M S D Pike Township 180891001484 5357 Central Elementary School   Regular School No Elementary KG 05 2020   grade_2                         58.0 47.0                       105.0                         58 47                 105
1916936 1916936 IN     school 1811400 7945   Tipton Community School Corp 181140001844 8163 Tipton Elementary School   Regular School No Elementary PK 05 2020   grade_2                         51.0 54.0                       105.0                         51 54                 105
1909430 1909430 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001270 1953 Greenville Elementary School   Regular School No Elementary KG 04 2020   grade_2                         53.0 53.0                       106.0                         53 53                 106
1910134 1910134 IN     school 1801200 3060   Carmel Clay Schools 180120000991 2515 Prairie Trace Elementary School   Regular School No Elementary KG 05 2020   grade_2                         58.0 48.0                       106.0                         58 48                 106
1910460 1910460 IN     school 1808100 3295   North West Hendricks Schools 180810002465 2684 Pittsboro Primary School   Regular School No Elementary PK 02 2020   grade_2                         58.0 48.0                       106.0                         58 48                 106
1912328 1912328 IN     school 1804320 4710   School City of Hammond 180432000750 4453 Warren G Harding Elementary School   Regular School No Elementary PK 05 2020   grade_2                         53.0 53.0                       106.0                         53 53                 106
1913445 1913445 IN     school 1812360 5360   M S D Warren Township 181236001967 5377 Lowell Elementary School   Regular School No Elementary KG 04 2020   grade_2                         58.0 48.0                       106.0                         58 48                 106
1918893 1918893 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2020   grade_2                         49.0 57.0                       106.0                         49 57                 106
1911422 1911422 IN     school 1801440 4205   Center Grove Community School Corp 180144002333 3444 Pleasant Grove Elementary School   Regular School No Elementary KG 05 2020   grade_2                         59.0 48.0                       107.0                         59 48                 107
1913463 1913463 IN     school 1812360 5360   M S D Warren Township 181236001959 5391 Brookview Elementary School   Regular School No Elementary KG 04 2020   grade_2                         51.0 56.0                       107.0                         51 56                 107
1918401 1918401 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes Elementary KG 05 2020   grade_2                         59.0 48.0                       107.0                         59 48                 107
1907453 1907453 IN     school 1803630 235   Fort Wayne Community Schools 180363000540 270 Lincoln Elementary School   Regular School No Elementary KG 05 2020   grade_2                         53.0 55.0                       108.0                         53 55                 108
1912039 1912039 IN     school 1805460 4650   Lake Ridge New Tech Schools 180546000993 3885 Longfellow New Tech Elementary Sch   Regular School No Elementary KG 04 2020   grade_2                         56.0 52.0                       108.0                         56 52                 108
1912866 1912866 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002052 5025 Lapel Elementary School   Regular School No Elementary PK 05 2020   grade_2                         52.0 56.0                       108.0                         52 56                 108
1913671 1913671 IN     school 1812810 5375   M S D Wayne Township 181281002123 5446 Bridgeport Elementary School   Regular School No Elementary PK 06 2020   grade_2                         60.0 48.0                       108.0                         60 48                 108
1915998 1915998 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001148 7390 Northpoint Elementary School   Regular School No Elementary KG 05 2020   grade_2                         57.0 51.0                       108.0                         57 51                 108
1916846 1916846 IN     school 1811340 7865   Tippecanoe School Corp 181134001821 8024 Battle Ground Elementary School   Regular School No Elementary KG 05 2020   grade_2                         61.0 47.0                       108.0                         61 47                 108
1910824 1910824 IN     school 1811250 3460   Taylor Community School Corp 181125001812 2895 Taylor Elementary School   Regular School No Elementary PK 04 2020   grade_2                         62.0 47.0                       109.0                         62 47                 109
1911373 1911373 IN     school 1801440 4205   Center Grove Community School Corp 180144000662 3434 Sugar Grove Elementary School   Regular School No Elementary PK 05 2020   grade_2                         58.0 51.0                       109.0                         58 51                 109
1911407 1911407 IN     school 1801440 4205   Center Grove Community School Corp 180144000211 3440 North Grove Elementary School   Regular School No Elementary KG 05 2020   grade_2                         52.0 57.0                       109.0                         52 57                 109
1913375 1913375 IN     school 1808910 5350   M S D Pike Township 180891001486 5360 Guion Creek Elementary School   Regular School No Elementary KG 05 2020   grade_2                         46.0 63.0                       109.0                         46 63                 109
1914248 1914248 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elementary/Middle School   Regular School No Elementary KG 08 2020   grade_2                         59.0 50.0                       109.0                         59 50                 109
1917418 1917418 IN     school 1812090 8030   Vigo County School Corp 181209001909 8549 Lost Creek Elementary School   Regular School No Elementary PK 05 2020   grade_2                         63.0 46.0                       109.0                         63 46                 109
1917650 1917650 IN     school 1812390 8130   Warrick County School Corp 181239001987 8785 Tennyson Elementary School   Regular School No Elementary KG 05 2020   grade_2                         6.0 5.0                       11.0                         6 5                 11
1907132 1907132 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2020   grade_2                         56.0 54.0                       110.0                         56 54                 110
1908450 1908450 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001803 1189 North Dearborn Elementary School   Regular School No Elementary PK 05 2020   grade_2                         53.0 57.0                       110.0                         53 57                 110
1910043 1910043 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2020   grade_2                         62.0 48.0                       110.0                         62 48                 110
1912827 1912827 IN     school 1806900 5085   Mitchell Community Schools 180690001196 4863 Hatfield Elementary School   Regular School No Elementary PK 02 2020   grade_2                         61.0 49.0                       110.0                         61 49                 110
1913600 1913600 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2020   grade_2                         60.0 50.0                       110.0                         60 50                 110
1916208 1916208 IN     school 1810290 7205   South Bend Community School Corp 181029001658 7573 Madison S.T.E.A.M. Academy   Regular School No Elementary KG 05 2020   grade_2                         64.0 46.0                       110.0                         64 46                 110
1917558 1917558 IN     school 1812150 8060   Wabash City Schools 181215001937 8706 O J Neighbours Elementary School   Regular School No Elementary PK 04 2020   grade_2                         51.0 59.0                       110.0                         51 59                 110
1907814 1907814 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2020   grade_2                         40.0 71.0                       111.0                         40 71                 111
1909563 1909563 IN     school 1809630 2645   Rochester Community School Corp 180963001574 2181 Columbia Elementary School   Regular School No Elementary PK 02 2020   grade_2                         57.0 54.0                       111.0                         57 54                 111
1910009 1910009 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2020   grade_2                         54.0 57.0                       111.0                         54 57                 111
1912989 1912989 IN     school 1803300 5280   Elwood Community School Corp 180330000448 5157 Elwood Elementary School   Regular School No Elementary PK 02 2020   grade_2                         55.0 56.0                       111.0                         55 56                 111
1913102 1913102 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000596 5205 Bunker Hill Elementary School   Regular School No Elementary KG 05 2020   grade_2                         54.0 57.0                       111.0                         54 57                 111
1913126 1913126 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2020   grade_2                         57.0 54.0                       111.0                         57 54                 111
1913174 1913174 IN     school 1805670 5330   M S D Lawrence Township 180567000150 5294 Forest Glen Elementary School   Regular School No Elementary PK 06 2020   grade_2                         60.0 51.0                       111.0                         60 51                 111
1917364 1917364 IN     school 1812090 8030   Vigo County School Corp 181209001903 8511 Dixie Bee Elementary School   Regular School No Elementary KG 05 2020   grade_2                         59.0 52.0                       111.0                         59 52                 111
1917688 1917688 IN     school 1812390 8130   Warrick County School Corp 181239001984 8817 Newburgh Elementary School   Regular School No Elementary KG 05 2020   grade_2                         56.0 55.0                       111.0                         56 55                 111
1909872 1909872 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No Elementary PK 04 2020   grade_2                         53.0 59.0                       112.0                         53 59                 112
1909891 1909891 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No Elementary KG 04 2020   grade_2                         50.0 62.0                       112.0                         50 62                 112
1913439 1913439 IN     school 1812360 5360   M S D Warren Township 181236001966 5375 Lakeside Elementary School   Regular School No Elementary KG 04 2020   grade_2                         55.0 57.0                       112.0                         55 57                 112
1915983 1915983 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876000526 7383 Horizon Elementary School   Regular School No Elementary PK 05 2020   grade_2                         49.0 63.0                       112.0                         49 63                 112
1909897 1909897 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001560 2471 Hoosier Road Elementary School   Regular School No Elementary PK 04 2020   grade_2                         51.0 62.0                       113.0                         51 62                 113
1910208 1910208 IN     school 1807650 3070   Noblesville Schools 180765002414 2537 Noble Crossing Elementary School   Regular School No Elementary PK 05 2020   grade_2                         61.0 52.0                       113.0                         61 52                 113
1910271 1910271 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001407 2567 Sugar Creek Elementary Sch   Regular School No Elementary KG 04 2020   grade_2                         68.0 45.0                       113.0                         68 45                 113
1910497 1910497 IN     school 1801020 3305   Brownsburg Community School Corp 180102000045 2711 Eagle Elementary School   Regular School No Elementary KG 05 2020   grade_2                         60.0 53.0                       113.0                         60 53                 113
1910216 1910216 IN     school 1807650 3070   Noblesville Schools 180765002340 2538 Hazel Dell Elementary School   Regular School No Elementary PK 05 2020   grade_2                         61.0 53.0                       114.0                         61 53                 114
1911257 1911257 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001766 3341 Southwestern Elementary School   Regular School No Elementary PK 05 2020   grade_2                         60.0 54.0                       114.0                         60 54                 114
1911483 1911483 IN     school 1803690 4225   Franklin Community School Corp 180369001030 3467 Creekside Elementary School   Regular School No Elementary PK 04 2020   grade_2                         56.0 58.0                       114.0                         56 58                 114

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