enrollments

Data source: Big Local News · About: Big Local

1,044 rows where grade = "grade_2", state = "IN" and year = 2021 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,044 ✖

grade ✖

  • grade_2 · 1,044 ✖
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
1926292 1926292 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No Elementary 02 06 2021   grade_2                         1.0 0.0                       1.0                         1 0                 1
1927137 1927137 IN     school   6510   East Porter County School Corp   6811 Porter County Education Services             2021   grade_2                         0.0 1.0                       1.0                         0 1                 1
1927211 1927211 IN     school   6530   Union Township School Corp   6811 Porter County Education Services             2021   grade_2                         0.0 1.0                       1.0                         0 1                 1
1930441 1930441 IN     school 1800043 9465   Rural Community Schools Inc 180004302138 7951 Rural Community Academy   Regular School Yes Elementary KG 08 2021   grade_2                         5.0 5.0                       10.0                         5 5                 10
1919781 1919781 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary KG 04 2021   grade_2                         56.0 44.0                       100.0                         56 44                 100
1920031 1920031 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2021   grade_2                         43.0 57.0                       100.0                         43 57                 100
1921243 1921243 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No Elementary KG 05 2021   grade_2                         54.0 46.0                       100.0                         54 46                 100
1924030 1924030 IN     school 1802490 4660   Crown Point Community School Corp 180249000295 3773 Dwight D Eisenhower Elem School   Regular School No Elementary PK 05 2021   grade_2                         57.0 43.0                       100.0                         57 43                 100
1924867 1924867 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 04 2021   grade_2                         44.0 56.0                       100.0                         44 56                 100
1925265 1925265 IN     school 1808910 5350   MSD Pike Township 180891001484 5357 Central Elementary School   Regular School No Elementary KG 05 2021   grade_2                         53.0 47.0                       100.0                         53 47                 100
1926878 1926878 IN     school 1808640 6155   Paoli Community School Corp 180864001439 6587 Throop Elementary School   Regular School No Elementary KG 06 2021   grade_2                         49.0 51.0                       100.0                         49 51                 100
1927008 1927008 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001282 6745 William Tell Elementary School   Regular School No Elementary PK 06 2021   grade_2                         54.0 46.0                       100.0                         54 46                 100
1927923 1927923 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001148 7390 Northpoint Elementary School   Regular School No Elementary KG 05 2021   grade_2                         54.0 46.0                       100.0                         54 46                 100
1919774 1919774 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2021   grade_2                         53.0 48.0                       101.0                         53 48                 101
1921417 1921417 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002204 1974 Mount Tabor Elementary School   Regular School No Elementary KG 04 2021   grade_2                         53.0 48.0                       101.0                         53 48                 101
1922007 1922007 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2021   grade_2                         53.0 48.0                       101.0                         53 48                 101
1922277 1922277 IN     school 1807260 3135   Mt Vernon Community School Corp 180726001220 2561 Mt Comfort Elementary School   Regular School No Elementary KG 05 2021   grade_2                         58.0 43.0                       101.0                         58 43                 101
1922686 1922686 IN     school 1808280 3435   Shenandoah School Corporation 180828002356 2815 Shenandoah Elementary School   Regular School No Elementary PK 05 2021   grade_2                         46.0 55.0                       101.0                         46 55                 101
1923116 1923116 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No Elementary PK 04 2021   grade_2                         56.0 45.0                       101.0                         56 45                 101
1924769 1924769 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002049 5009 Frankton Elementary School   Regular School No Elementary PK 06 2021   grade_2                         57.0 44.0                       101.0                         57 44                 101
1924795 1924795 IN     school 1810440 5255   South Madison Com Sch Corp 181044002167 4935 East Elementary School   Regular School No Elementary KG 06 2021   grade_2                         54.0 47.0                       101.0                         54 47                 101
1924884 1924884 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 04 2021   grade_2                         45.0 56.0                       101.0                         45 56                 101
1924924 1924924 IN     school 1802640 5300   MSD Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2021   grade_2                         44.0 57.0                       101.0                         44 57                 101
1925208 1925208 IN     school 1808820 5340   Perry Township Schools 180882001470 5351 Winchester Village Elementary   Regular School No Elementary PK 05 2021   grade_2                         54.0 47.0                       101.0                         54 47                 101
1919082 1919082 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   grade_2                         60.0 42.0                       102.0                         60 42                 102
1921857 1921857 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001750 2473 Fall Creek Elementary School   Regular School No Elementary PK 04 2021   grade_2                         45.0 57.0                       102.0                         45 57                 102
1923033 1923033 IN     school 1810080 3675   Seymour Community Schools 181008001619 3153 Seymour-Jackson Elementary School   Regular School No Elementary PK 05 2021   grade_2                         49.0 53.0                       102.0                         49 53                 102
1924747 1924747 IN     school 1806900 5085   Mitchell Community Schools 180690001196 4863 Hatfield Elementary School   Regular School No Elementary PK 02 2021   grade_2                         46.0 56.0                       102.0                         46 56                 102
1924820 1924820 IN     school 1810440 5255   South Madison Com Sch Corp 181044001676 5064 Maple Ridge Elementary School   Regular School No Elementary KG 06 2021   grade_2                         45.0 57.0                       102.0                         45 57                 102
1925216 1925216 IN     school 1808820 5340   Perry Township Schools 180882001687 5366 Jeremiah Gray Elementary School   Regular School No Elementary PK 05 2021   grade_2                         58.0 44.0                       102.0                         58 44                 102
1928673 1928673 IN     school 1805400 7855   Lafayette School Corporation 180540000963 8089 Edgelea Elementary School   Regular School No Elementary KG 04 2021   grade_2                         51.0 51.0                       102.0                         51 51                 102
1929980 1929980 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2021   grade_2                         55.0 47.0                       102.0                         55 47                 102
1918999 1918999 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2021   grade_2                         43.0 60.0                       103.0                         43 60                 103
1919555 1919555 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No Elementary PK 06 2021   grade_2                         48.0 55.0                       103.0                         48 55                 103
1919884 1919884 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No Elementary KG 05 2021   grade_2                         48.0 55.0                       103.0                         48 55                 103
1920990 1920990 IN     school 1802400 2270   Concord Community Schools 180240000270 1721 Concord East Side Elementary Sch   Regular School No Elementary KG 04 2021   grade_2                         45.0 58.0                       103.0                         45 58                 103
1922818 1922818 IN     school 1803150 3480   Eastern Howard School Corporation 180315000412 2909 Eastern Elementary School   Regular School No Elementary KG 05 2021   grade_2                         47.0 56.0                       103.0                         47 56                 103
1923057 1923057 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No Elementary PK 05 2021   grade_2                         51.0 52.0                       103.0                         51 52                 103
1924181 1924181 IN     school 1803870 4690   Gary Community School Corp 180387002104 4169 Daniel Hale Williams Elem Sch   Regular School No Elementary KG 05 2021   grade_2                         48.0 55.0                       103.0                         48 55                 103
1924316 1924316 IN     school 1804320 4710   School City of Hammond 180432000744 4465 Maywood Elementary School   Regular School No Elementary PK 05 2021   grade_2                         44.0 59.0                       103.0                         44 59                 103
1924787 1924787 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002052 5025 Lapel Elementary School   Regular School No Elementary PK 05 2021   grade_2                         57.0 46.0                       103.0                         57 46                 103
1924811 1924811 IN     school 1810440 5255   South Madison Com Sch Corp 181044001713 5061 Pendleton Elementary School   Regular School No Elementary PK 06 2021   grade_2                         46.0 57.0                       103.0                         46 57                 103
1925059 1925059 IN     school 1805670 5330   MSD Lawrence Township 180567002339 5287 Amy Beverland Elementary   Regular School No Elementary 01 06 2021   grade_2                         51.0 52.0                       103.0                         51 52                 103
1925475 1925475 IN     school 1812810 5375   MSD Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No Elementary PK 06 2021   grade_2                         51.0 52.0                       103.0                         51 52                 103
1925555 1925555 IN     school 1812810 5375   MSD Wayne Township 181281002042 5273 Westlake Elementary School   Regular School No Elementary PK 06 2021   grade_2                         68.0 35.0                       103.0                         68 35                 103
1919098 1919098 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   grade_2                         44.0 60.0                       104.0                         44 60                 104
1919241 1919241 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2021   grade_2                         55.0 49.0                       104.0                         55 49                 104
1920780 1920780 IN     school 1807320 1970   Muncie Community Schools 180732002153 1482 South View Elementary School   Regular School No Elementary PK 05 2021   grade_2                         55.0 49.0                       104.0                         55 49                 104
1925416 1925416 IN     school 1812720 5370   MSD Washington Township 181272002016 5418 Greenbriar Elementary School   Regular School No Elementary KG 05 2021   grade_2                         53.0 51.0                       104.0                         53 51                 104
1925577 1925577 IN     school 1812810 5375   MSD Wayne Township 181281002123 5446 Bridgeport Elementary School   Regular School No Elementary KG 06 2021   grade_2                         55.0 49.0                       104.0                         55 49                 104
1928827 1928827 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2021   grade_2                         56.0 48.0                       104.0                         56 48                 104
1921964 1921964 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2021   grade_2                         65.0 40.0                       105.0                         65 40                 105
1923957 1923957 IN     school 1805450 4615   Lake Central School Corporation 180545002143 4349 Homan Elementary School   Regular School No Elementary PK 04 2021   grade_2                         62.0 43.0                       105.0                         62 43                 105
1924443 1924443 IN     school 1807350 4740   School Town of Munster 180735001254 4343 Frank H Hammond Elementary School   Regular School No Elementary PK 05 2021   grade_2                         56.0 49.0                       105.0                         56 49                 105
1925350 1925350 IN     school 1812360 5360   MSD Warren Township 181236001966 5375 Lakeside Elementary School   Regular School No Elementary KG 04 2021   grade_2                         60.0 45.0                       105.0                         60 45                 105
1919264 1919264 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary School   Regular School No Elementary KG 05 2021   grade_2                         54.0 52.0                       106.0                         54 52                 106
1922782 1922782 IN     school 1811250 3460   Taylor Community School Corp 181125001812 2895 Taylor Elementary School   Regular School No Elementary PK 04 2021   grade_2                         50.0 57.0                       107.0                         50 57                 107
1924990 1924990 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002349 5200 Mary Adams Elementary School   Regular School No Elementary KG 03 2021   grade_2                         63.0 44.0                       107.0                         63 44                 107
1928117 1928117 IN     school 1810290 7205   South Bend Community School Corp 181029001663 7555 Kennedy Academy   Regular School No Elementary KG 05 2021   grade_2                         57.0 50.0                       107.0                         57 50                 107
1929622 1929622 IN     school 1812390 8130   Warrick County School Corp 181239002179 8819 Sharon Elementary School   Regular School No Elementary KG 05 2021   grade_2                         66.0 41.0                       107.0                         66 41                 107
1929486 1929486 IN     school 1812150 8060   Wabash City Schools 181215001937 8706 O J Neighbours Elementary School   Regular School No Elementary PK 04 2021   grade_2                         58.0 50.0                       108.0                         58 50                 108
1919120 1919120 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   grade_2                         50.0 59.0                       109.0                         50 59                 109
1919419 1919419 IN     school 1803630 235   Fort Wayne Community Schools 180363000540 270 Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_2                         44.0 65.0                       109.0                         44 65                 109
1920889 1920889 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001236 1590 Huntingburg Elementary School   Regular School No Elementary PK 05 2021   grade_2                         59.0 50.0                       109.0                         59 50                 109
1922115 1922115 IN     school 1801200 3060   Carmel Clay Schools 180120001405 2522 Towne Meadow Elementary School   Regular School No Elementary KG 05 2021   grade_2                         59.0 50.0                       109.0                         59 50                 109
1925076 1925076 IN     school 1805670 5330   MSD Lawrence Township 180567002278 5293 Indian Creek Elementary School   Regular School No Elementary 01 06 2021   grade_2                         64.0 45.0                       109.0                         64 45                 109
1925083 1925083 IN     school 1805670 5330   MSD Lawrence Township 180567000150 5294 Forest Glen Elementary School   Regular School No Elementary PK 06 2021   grade_2                         51.0 58.0                       109.0                         51 58                 109
1926130 1926130 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elementary/Middle School   Regular School No Elementary KG 08 2021   grade_2                         59.0 50.0                       109.0                         59 50                 109
1928384 1928384 IN     school 1810140 7365   Shelbyville Central Schools 181014001633 7733 William F Loper Elementary School   Regular School No Elementary KG 05 2021   grade_2                         49.0 60.0                       109.0                         49 60                 109
1929355 1929355 IN     school 1812090 8030   Vigo County School Corp 181209001909 8549 Lost Creek Elementary School   Regular School No Elementary PK 05 2021   grade_2                         57.0 52.0                       109.0                         57 52                 109
1930629 1930629 IN     school 1800086 9680   Paramount Brookside 180008602478 5508 Paramount Brookside   Regular School Yes Elementary KG 08 2021   grade_2                         59.0 50.0                       109.0                         59 50                 109
1919031 1919031 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2021   grade_2                         63.0 47.0                       110.0                         63 47                 110
1920631 1920631 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000225 1357 McKenney-Harrison Elementary Sch   Regular School No Elementary PK 05 2021   grade_2                         56.0 54.0                       110.0                         56 54                 110
1922291 1922291 IN     school 1807260 3135   Mt Vernon Community School Corp 180726002192 2570 McCordsville Elementary School   Regular School No Elementary KG 05 2021   grade_2                         46.0 64.0                       110.0                         46 64                 110
1924284 1924284 IN     school 1804320 4710   School City of Hammond 180432000751 4455 Washington Irving Elementary Sch   Regular School No Elementary PK 05 2021   grade_2                         51.0 59.0                       110.0                         51 59                 110
1925409 1925409 IN     school 1812720 5370   MSD Washington Township 181272002647 5408 Willow Lake Elementary School   Regular School No Elementary KG 05 2021   grade_2                         66.0 44.0                       110.0                         66 44                 110
1926276 1926276 IN     school 1808340 5625   Oak Hill United School Corp 180834001428 6073 Converse Elementary School   Regular School No Elementary PK 02 2021   grade_2                         61.0 49.0                       110.0                         61 49                 110
1922178 1922178 IN     school 1807650 3070   Noblesville Schools 180765002546 2539 Promise Road Elementary   Regular School No Elementary PK 05 2021   grade_2                         56.0 55.0                       111.0                         56 55                 111
1925388 1925388 IN     school 1812720 5370   MSD Washington Township 181272002010 5403 Allisonville Elementary School   Regular School No Elementary KG 05 2021   grade_2                         58.0 53.0                       111.0                         58 53                 111
1927908 1927908 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876000526 7383 Horizon Elementary School   Regular School No Elementary PK 05 2021   grade_2                         60.0 51.0                       111.0                         60 51                 111
1928763 1928763 IN     school 1811340 7865   Tippecanoe School Corp 181134001304 8019 Burnett Creek Elementary School   Regular School No Elementary KG 05 2021   grade_2                         49.0 62.0                       111.0                         49 62                 111
1930397 1930397 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes Elementary KG 05 2021   grade_2                         58.0 53.0                       111.0                         58 53                 111
1921014 1921014 IN     school 1806600 2275   Middlebury Community Schools 180660001163 1656 Jefferson Elementary School   Regular School No Elementary KG 03 2021   grade_2                         57.0 55.0                       112.0                         57 55                 112
1921398 1921398 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001268 1957 Grant Line Elementary School   Regular School No Elementary KG 04 2021   grade_2                         66.0 46.0                       112.0                         66 46                 112
1921882 1921882 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000967 2481 Harrison Parkway Elementary School   Regular School No Elementary KG 04 2021   grade_2                         47.0 65.0                       112.0                         47 65                 112
1922096 1922096 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary School   Regular School No Elementary KG 05 2021   grade_2                         59.0 53.0                       112.0                         59 53                 112
1925144 1925144 IN     school 1808820 5340   Perry Township Schools 180882001469 5321 William Henry Burkhart Elementary   Regular School No Elementary PK 05 2021   grade_2                         54.0 58.0                       112.0                         54 58                 112
1925286 1925286 IN     school 1808910 5350   MSD Pike Township 180891001486 5360 Guion Creek Elementary School   Regular School No Elementary KG 05 2021   grade_2                         59.0 53.0                       112.0                         59 53                 112
1922154 1922154 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No Elementary PK 05 2021   grade_2                         47.0 66.0                       113.0                         47 66                 113
1923292 1923292 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000244 3401 Clark Elementary School   Regular School No Elementary KG 05 2021   grade_2                         54.0 59.0                       113.0                         54 59                 113
1925000 1925000 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002222 5202 Arlington Elementary School   Regular School No Elementary KG 03 2021   grade_2                         52.0 61.0                       113.0                         52 61                 113
1928945 1928945 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002627 8242 McCutchanville Elementary School   Regular School No Elementary PK 06 2021   grade_2                         58.0 55.0                       113.0                         58 55                 113
1929869 1929869 IN     school 1800720 8445   MSD Bluffton-Harrison 180072000149 9098 Bluffton-Harrison Elementary Sch   Regular School No Elementary KG 04 2021   grade_2                         68.0 45.0                       113.0                         68 45                 113
1922139 1922139 IN     school 1807650 3070   Noblesville Schools 180765002158 2523 Hinkle Creek Elementary School   Regular School No Elementary PK 05 2021   grade_2                         66.0 48.0                       114.0                         66 48                 114
1923366 1923366 IN     school 1801440 4205   Center Grove Community School Corp 180144002105 3439 Maple Grove Elementary School   Regular School No Elementary KG 05 2021   grade_2                         57.0 57.0                       114.0                         57 57                 114
1924048 1924048 IN     school 1802490 4660   Crown Point Community School Corp 180249000296 3903 Lake Street Elementary School   Regular School No Elementary KG 05 2021   grade_2                         63.0 51.0                       114.0                         63 51                 114
1925402 1925402 IN     school 1812720 5370   MSD Washington Township 181272002657 5407 Clearwater Elementary School   Regular School No Elementary KG 05 2021   grade_2                         56.0 58.0                       114.0                         56 58                 114
1926445 1926445 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000132 6217 Rogers Elementary School   Regular School No Elementary KG 02 2021   grade_2                         52.0 62.0                       114.0                         52 62                 114
1919192 1919192 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2021   grade_2                         60.0 55.0                       115.0                         60 55                 115
1921870 1921870 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000373 2475 Lantern Road Elementary School   Regular School No Elementary KG 04 2021   grade_2                         51.0 64.0                       115.0                         51 64                 115

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