enrollments

Data source: Big Local News · About: Big Local

1,048 rows where grade = "grade_2", state = "IN" and year = 2019 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 1,048 ✖

grade ✖

  • grade_2 · 1,048 ✖
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
1754194 1754194 IN     school 1807770 2735   North Gibson School Corporation 180777001324 2223 Princeton Comm Intermediate School   Regular School No Elementary KG 05 2019   grade_2                         1.0 0.0                       1.0                         1 0                 1
1758981 1758981 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No Elementary KG 04 2019   grade_2                         1.0 0.0                       1.0                         1 0                 1
1758998 1758998 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No Elementary KG 06 2019   grade_2                         0.0 1.0                       1.0                         0 1                 1
1751592 1751592 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2019   grade_2                         57.0 43.0                       100.0                         57 43                 100
1754677 1754677 IN     school 1801200 3060   Carmel Clay Schools 180120000036 2512 Smoky Row Elementary School   Regular School No Elementary PK 05 2019   grade_2                         56.0 44.0                       100.0                         56 44                 100
1754693 1754693 IN     school 1801200 3060   Carmel Clay Schools 180120000991 2515 Prairie Trace Elementary School   Regular School No Elementary KG 05 2019   grade_2                         52.0 48.0                       100.0                         52 48                 100
1754795 1754795 IN     school 1807650 3070   Noblesville Schools 180765001246 2547 White River Elementary School   Regular School No Elementary PK 05 2019   grade_2                         45.0 55.0                       100.0                         45 55                 100
1756324 1756324 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001524 3686 Prairie Heights Elementary School   Regular School No Elementary KG 04 2019   grade_2                         53.0 47.0                       100.0                         53 47                 100
1758183 1758183 IN     school 1812810 5375   M S D Wayne Township 181281002037 5265 Robey Elementary School   Regular School No Elementary KG 06 2019   grade_2                         53.0 47.0                       100.0                         53 47                 100
1761530 1761530 IN     school 1811400 7945   Tipton Community School Corp 181140001844 8163 Tipton Elementary School   Regular School No Elementary PK 05 2019   grade_2                         51.0 49.0                       100.0                         51 49                 100
1762003 1762003 IN     school 1812090 8030   Vigo County School Corp 181209001909 8549 Lost Creek Elementary School   Regular School No Elementary PK 05 2019   grade_2                         45.0 55.0                       100.0                         45 55                 100
1762389 1762389 IN     school 1808190 8375   Northeastern Wayne Schools 180819002228 8928 Northeastern Elementary School   Regular School No Elementary PK 05 2019   grade_2                         56.0 44.0                       100.0                         56 44                 100
1751800 1751800 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2019   grade_2                         53.0 48.0                       101.0                         53 48                 101
1753244 1753244 IN     school 1802660 1875   Delaware Community School Corp 180266000324 1365 Royerton Elementary School   Regular School No Elementary KG 05 2019   grade_2                         64.0 37.0                       101.0                         64 37                 101
1755080 1755080 IN     school 1801020 3305   Brownsburg Community School Corp 180102001671 2723 White Lick Elementary School   Regular School No Elementary KG 05 2019   grade_2                         57.0 44.0                       101.0                         57 44                 101
1755610 1755610 IN     school 1810080 3675   Seymour Community Schools 181008001617 3135 Margaret R Brown Elementary School   Regular School No Elementary KG 05 2019   grade_2                         55.0 46.0                       101.0                         55 46                 101
1757013 1757013 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2019   grade_2                         46.0 55.0                       101.0                         46 55                 101
1757572 1757572 IN     school 1803300 5280   Elwood Community School Corp 180330000448 5157 Elwood Elementary School   Regular School No Elementary PK 02 2019   grade_2                         64.0 37.0                       101.0                         64 37                 101
1757606 1757606 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2019   grade_2                         51.0 50.0                       101.0                         51 50                 101
1758976 1758976 IN     school 1808340 5625   Oak Hill United School Corp 180834001428 6073 Converse Elementary School   Regular School No Elementary PK 02 2019   grade_2                         51.0 50.0                       101.0                         51 50                 101
1761489 1761489 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2019   grade_2                         51.0 50.0                       101.0                         51 50                 101
1761950 1761950 IN     school 1812090 8030   Vigo County School Corp 181209001903 8511 Dixie Bee Elementary School   Regular School No Elementary KG 05 2019   grade_2                         39.0 62.0                       101.0                         39 62                 101
1762299 1762299 IN     school 1803000 8215   East Washington School Corp 180300002195 8904 East Washington Elementary School   Regular School No Elementary PK 04 2019   grade_2                         52.0 49.0                       101.0                         52 49                 101
1763172 1763172 IN     school 1800086 9680   Paramount Brookside 180008602478 5508 Paramount Brookside   Regular School Yes Elementary KG 08 2019   grade_2                         48.0 53.0                       101.0                         48 53                 101
1751698 1751698 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   grade_2                         52.0 50.0                       102.0                         52 50                 102
1751878 1751878 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary School   Regular School No Elementary PK 05 2019   grade_2                         56.0 46.0                       102.0                         56 46                 102
1752151 1752151 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No Elementary PK 06 2019   grade_2                         46.0 56.0                       102.0                         46 56                 102
1754812 1754812 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001760 2564 New Palestine Elementary School   Regular School No Elementary PK 04 2019   grade_2                         51.0 51.0                       102.0                         51 51                 102
1756469 1756469 IN     school 1809690 4600   Merrillville Community School Corp 180969001583 3822 Homer Iddings Elementary School   Regular School No Elementary KG 04 2019   grade_2                         56.0 46.0                       102.0                         56 46                 102
1756656 1756656 IN     school 1802490 4660   Crown Point Community School Corp 180249000299 3913 Timothy Ball Elementary School   Regular School No Elementary KG 05 2019   grade_2                         58.0 44.0                       102.0                         58 44                 102
1757888 1757888 IN     school 1808820 5340   Perry Township Schools 180882001687 5366 Jeremiah Gray Elementary School   Regular School No Elementary 01 05 2019   grade_2                         55.0 47.0                       102.0                         55 47                 102
1752963 1752963 IN     school 1807710 1375   North Daviess Com Schools 180771001648 1090 North Daviess Elementary School   Regular School No Elementary KG 06 2019   grade_2                         42.0 61.0                       103.0                         42 61                 103
1754602 1754602 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2019   grade_2                         53.0 50.0                       103.0                         53 50                 103
1755392 1755392 IN     school 1802040 3470   Northwestern School Corp 180204000254 2904 Northwestern Elementary School   Regular School No Elementary KG 06 2019   grade_2                         50.0 53.0                       103.0                         50 53                 103
1755411 1755411 IN     school 1803150 3480   Eastern Howard School Corporation 180315000412 2909 Eastern Elementary School   Regular School No Elementary PK 07 2019   grade_2                         47.0 56.0                       103.0                         47 56                 103
1756113 1756113 IN     school 1810410 4325   South Knox School Corp 181041001705 3489 South Knox Elementary School   Regular School No Elementary KG 06 2019   grade_2                         60.0 43.0                       103.0                         60 43                 103
1756548 1756548 IN     school 1805450 4615   Lake Central School Corporation 180545000986 4351 Peifer Elementary School   Regular School No Elementary KG 04 2019   grade_2                         53.0 50.0                       103.0                         53 50                 103
1757764 1757764 IN     school 1805670 5330   M S D Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No Elementary 01 06 2019   grade_2                         46.0 57.0                       103.0                         46 57                 103
1758095 1758095 IN     school 1812720 5370   M S D Washington Township 181272002023 5430 Spring Mill Elementary School   Regular School No Elementary KG 05 2019   grade_2                         53.0 50.0                       103.0                         53 50                 103
1761042 1761042 IN     school 1810140 7365   Shelbyville Central Schools 181014001633 7733 William F Loper Elementary School   Regular School No Elementary PK 05 2019   grade_2                         62.0 41.0                       103.0                         62 41                 103
1751574 1751574 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   grade_2                         49.0 55.0                       104.0                         49 55                 104
1754685 1754685 IN     school 1801200 3060   Carmel Clay Schools 180120002267 2513 Orchard Park Elementary School   Regular School No Elementary PK 05 2019   grade_2                         43.0 61.0                       104.0                         43 61                 104
1757582 1757582 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2019   grade_2                         58.0 46.0                       104.0                         58 46                 104
1757618 1757618 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2019   grade_2                         47.0 57.0                       104.0                         47 57                 104
1759720 1759720 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001282 6745 William Tell Elementary School   Regular School No Elementary PK 06 2019   grade_2                         54.0 50.0                       104.0                         54 50                 104
1761034 1761034 IN     school 1810140 7365   Shelbyville Central Schools 181014001632 7729 Thomas A Hendricks Elementary Sch   Regular School No Elementary PK 05 2019   grade_2                         51.0 53.0                       104.0                         51 53                 104
1762275 1762275 IN     school 1812390 8130   Warrick County School Corp 181239002179 8819 Sharon Elementary School   Regular School No Elementary KG 05 2019   grade_2                         48.0 56.0                       104.0                         48 56                 104
1762938 1762938 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes Elementary KG 04 2019   grade_2                         64.0 40.0                       104.0                         64 40                 104
1751713 1751713 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   grade_2                         50.0 55.0                       105.0                         50 55                 105
1753791 1753791 IN     school 1803270 2305   Elkhart Community Schools 180327000441 1785 Pinewood Elementary School   Regular School No Elementary KG 06 2019   grade_2                         56.0 49.0                       105.0                         56 49                 105
1754870 1754870 IN     school 1807260 3135   Mt Vernon Community School Corp 180726002152 2558 Fortville Elementary School   Regular School No Elementary KG 05 2019   grade_2                         48.0 57.0                       105.0                         48 57                 105
1755062 1755062 IN     school 1801020 3305   Brownsburg Community School Corp 180102002430 2714 Reagan Elementary School   Regular School No Elementary KG 05 2019   grade_2                         49.0 56.0                       105.0                         49 56                 105
1755069 1755069 IN     school 1801020 3305   Brownsburg Community School Corp 180102001567 2718 Delaware Trail Elementary School   Regular School No Elementary KG 05 2019   grade_2                         57.0 48.0                       105.0                         57 48                 105
1755636 1755636 IN     school 1810080 3675   Seymour Community Schools 181008001620 3157 Seymour-Redding Elementary School   Regular School No Elementary KG 05 2019   grade_2                         55.0 50.0                       105.0                         55 50                 105
1756732 1756732 IN     school 1803870 4690   Gary Community School Corp 180387000613 4053 Banneker Elementary at Marquette   Regular School No Elementary KG 05 2019   grade_2                         54.0 51.0                       105.0                         54 51                 105
1757057 1757057 IN     school 1807350 4740   School Town of Munster 180735001254 4343 Frank H Hammond Elementary School   Regular School No Elementary PK 05 2019   grade_2                         51.0 54.0                       105.0                         51 54                 105
1757465 1757465 IN     school 1810440 5255   South Madison Com Sch Corp 181044001713 5061 Pendleton Elementary School   Regular School No Elementary PK 06 2019   grade_2                         64.0 41.0                       105.0                         64 41                 105
1751865 1751865 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary School   Regular School No Elementary PK 05 2019   grade_2                         49.0 57.0                       106.0                         49 57                 106
1755375 1755375 IN     school 1811250 3460   Taylor Community School Corp 181125001812 2895 Taylor Elementary School   Regular School No Elementary PK 05 2019   grade_2                         53.0 53.0                       106.0                         53 53                 106
1756097 1756097 IN     school 1807830 4315   North Knox School Corp 180783001332 3521 North Knox Primary School   Regular School No Elementary KG 02 2019   grade_2                         54.0 52.0                       106.0                         54 52                 106
1757495 1757495 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2019   grade_2                         52.0 54.0                       106.0                         52 54                 106
1757552 1757552 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 05 2019   grade_2                         57.0 49.0                       106.0                         57 49                 106
1754719 1754719 IN     school 1801200 3060   Carmel Clay Schools 180120001405 2522 Towne Meadow Elementary School   Regular School No Elementary KG 05 2019   grade_2                         54.0 53.0                       107.0                         54 53                 107
1755211 1755211 IN     school 1808970 3330   Plainfield Community School Corp 180897001495 2761 Van Buren Elementary School   Regular School No Elementary KG 05 2019   grade_2                         48.0 59.0                       107.0                         48 59                 107
1755814 1755814 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001766 3341 Southwestern Elementary School   Regular School No Elementary PK 05 2019   grade_2                         58.0 49.0                       107.0                         58 49                 107
1757714 1757714 IN     school 1805670 5330   M S D Lawrence Township 180567001032 5283 Mary Evelyn Castle Elementary Sch   Regular School No Elementary 01 06 2019   grade_2                         52.0 55.0                       107.0                         52 55                 107
1755158 1755158 IN     school 1800270 3315   Avon Community School Corp 180027001675 2740 Hickory Elementary School   Regular School No Elementary KG 04 2019   grade_2                         51.0 57.0                       108.0                         51 57                 108
1755972 1755972 IN     school 1801440 4205   Center Grove Community School Corp 180144002333 3444 Pleasant Grove Elementary School   Regular School No Elementary KG 05 2019   grade_2                         50.0 58.0                       108.0                         50 58                 108
1757755 1757755 IN     school 1805670 5330   M S D Lawrence Township 180567000150 5294 Forest Glen Elementary School   Regular School No Elementary PK 06 2019   grade_2                         48.0 60.0                       108.0                         48 60                 108
1758014 1758014 IN     school 1812360 5360   M S D Warren Township 181236001966 5375 Lakeside Elementary School   Regular School No Elementary KG 04 2019   grade_2                         49.0 59.0                       108.0                         49 59                 108
1761347 1761347 IN     school 1805400 7855   Lafayette School Corporation 180540000971 8103 Miami Elementary School   Regular School No Elementary KG 04 2019   grade_2                         63.0 45.0                       108.0                         63 45                 108
1761828 1761828 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000489 8381 West Terrace Elementary School   Regular School No Elementary KG 05 2019   grade_2                         54.0 54.0                       108.0                         54 54                 108
1753019 1753019 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001803 1189 North Dearborn Elementary School   Regular School No Elementary PK 05 2019   grade_2                         57.0 52.0                       109.0                         57 52                 109
1754581 1754581 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2019   grade_2                         63.0 46.0                       109.0                         63 46                 109
1754759 1754759 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No Elementary PK 05 2019   grade_2                         56.0 53.0                       109.0                         56 53                 109
1757657 1757657 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002349 5200 Mary Adams Elementary School   Regular School No Elementary KG 05 2019   grade_2                         61.0 48.0                       109.0                         61 48                 109
1758067 1758067 IN     school 1812720 5370   M S D Washington Township 181272002255 5406 Crooked Creek Elementary School   Regular School No Elementary KG 05 2019   grade_2                         58.0 51.0                       109.0                         58 51                 109
1758104 1758104 IN     school 1812720 5370   M S D Washington Township 181272002376 5436 Fox Hill Elementary School   Regular School No Elementary KG 05 2019   grade_2                         45.0 64.0                       109.0                         45 64                 109
1761335 1761335 IN     school 1805400 7855   Lafayette School Corporation 180540000963 8089 Edgelea Elementary School   Regular School No Elementary KG 04 2019   grade_2                         44.0 65.0                       109.0                         44 65                 109
1754846 1754846 IN     school 1804050 3125   Greenfield-Central Com Schools 180405001665 2588 JB Stephens Elementary School   Regular School No Elementary KG 03 2019   grade_2                         55.0 55.0                       110.0                         55 55                 110
1754895 1754895 IN     school 1807260 3135   Mt Vernon Community School Corp 180726002192 2570 McCordsville Elementary School   Regular School No Elementary KG 05 2019   grade_2                         51.0 59.0                       110.0                         51 59                 110
1755051 1755051 IN     school 1801020 3305   Brownsburg Community School Corp 180102000045 2711 Eagle Elementary School   Regular School No Elementary KG 05 2019   grade_2                         55.0 55.0                       110.0                         55 55                 110
1755653 1755653 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No Elementary PK 05 2019   grade_2                         62.0 48.0                       110.0                         62 48                 110
1755957 1755957 IN     school 1801440 4205   Center Grove Community School Corp 180144000211 3440 North Grove Elementary School   Regular School No Elementary KG 05 2019   grade_2                         48.0 62.0                       110.0                         48 62                 110
1757441 1757441 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002052 5025 Lapel Elementary School   Regular School No Elementary PK 05 2019   grade_2                         54.0 56.0                       110.0                         54 56                 110
1757707 1757707 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2019   grade_2                         55.0 55.0                       110.0                         55 55                 110
1758166 1758166 IN     school 1812810 5375   M S D Wayne Township 181281002035 5257 McClelland Elementary School   Regular School No Elementary KG 06 2019   grade_2                         65.0 45.0                       110.0                         65 45                 110
1753842 1753842 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No Elementary KG 05 2019   grade_2                         52.0 59.0                       111.0                         52 59                 111
1754400 1754400 IN     school 1805910 2950   Linton-Stockton School Corporation 180591001048 2441 Linton-Stockton Elementary   Regular School No Elementary KG 05 2019   grade_2                         61.0 50.0                       111.0                         61 50                 111
1754457 1754457 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No Elementary KG 04 2019   grade_2                         56.0 55.0                       111.0                         56 55                 111
1754611 1754611 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2019   grade_2                         62.0 49.0                       111.0                         62 49                 111
1757935 1757935 IN     school 1808910 5350   M S D Pike Township 180891001484 5357 Central Elementary School   Regular School No Elementary KG 05 2019   grade_2                         62.0 49.0                       111.0                         62 49                 111
1754767 1754767 IN     school 1807650 3070   Noblesville Schools 180765002414 2537 Noble Crossing Elementary School   Regular School No Elementary PK 05 2019   grade_2                         54.0 58.0                       112.0                         54 58                 112
1754828 1754828 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001407 2567 Sugar Creek Elementary Sch   Regular School No Elementary KG 04 2019   grade_2                         63.0 49.0                       112.0                         63 49                 112
1757864 1757864 IN     school 1808820 5340   Perry Township Schools 180882001460 5345 Homecroft Elementary School   Regular School No Elementary PK 05 2019   grade_2                         51.0 61.0                       112.0                         51 61                 112
1757872 1757872 IN     school 1808820 5340   Perry Township Schools 180882001466 5347 Southport Elementary School   Regular School No Elementary PK 05 2019   grade_2                         60.0 52.0                       112.0                         60 52                 112
1758026 1758026 IN     school 1812360 5360   M S D Warren Township 181236001969 5386 Pleasant Run Elementary School   Regular School No Elementary KG 04 2019   grade_2                         64.0 48.0                       112.0                         64 48                 112
1758088 1758088 IN     school 1812720 5370   M S D Washington Township 181272002020 5427 Nora Elementary School   Regular School No Elementary KG 05 2019   grade_2                         65.0 47.0                       112.0                         65 47                 112
1758140 1758140 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No Elementary PK 06 2019   grade_2                         46.0 66.0                       112.0                         46 66                 112
1758174 1758174 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2019   grade_2                         54.0 58.0                       112.0                         54 58                 112

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