enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 1,045 ✖

grade ✖

  • grade_3 · 1,045 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total ▼ white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1755165 1755165 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No Elementary KG 03 2019   grade_3                         1.0 0.0                       1.0                         1 0                 1
1755448 1755448 IN     school 1804470 3490   Western School Corporation 180447000755 2935 Western Primary School   Regular School No Elementary KG 03 2019   grade_3                         1.0 0.0                       1.0                         1 0                 1
1761008 1761008 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other PK 12 2019   grade_3                         1.0 0.0                       1.0                         1 0                 1
1754173 1754173 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No Elementary KG 06 2019   grade_3                         2.0 8.0                       10.0                         2 8                 10
1752864 1752864 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2019   grade_3                         46.0 54.0                       100.0                         46 54                 100
1756325 1756325 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001524 3686 Prairie Heights Elementary School   Regular School No Elementary KG 04 2019   grade_3                         48.0 52.0                       100.0                         48 52                 100
1756517 1756517 IN     school 1805450 4615   Lake Central School Corporation 180545000980 3839 George Bibich Elementary School   Regular School No Elementary PK 04 2019   grade_3                         43.0 57.0                       100.0                         43 57                 100
1757686 1757686 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000596 5205 Bunker Hill Elementary School   Regular School No Elementary KG 05 2019   grade_3                         55.0 45.0                       100.0                         55 45                 100
1758141 1758141 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No Elementary PK 06 2019   grade_3                         44.0 56.0                       100.0                         44 56                 100
1760755 1760755 IN     school 1810290 7205   South Bend Community School Corp 181029001646 7545 Harrison Elementary School   Regular School No Elementary PK 05 2019   grade_3                         50.0 50.0                       100.0                         50 50                 100
1752371 1752371 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2019   grade_3                         47.0 54.0                       101.0                         47 54                 101
1753498 1753498 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000684 1569 Ireland Elementary School   Regular School No Elementary KG 05 2019   grade_3                         42.0 59.0                       101.0                         42 59                 101
1754776 1754776 IN     school 1807650 3070   Noblesville Schools 180765002340 2538 Hazel Dell Elementary School   Regular School No Elementary PK 05 2019   grade_3                         52.0 49.0                       101.0                         52 49                 101
1754813 1754813 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001760 2564 New Palestine Elementary School   Regular School No Elementary PK 04 2019   grade_3                         52.0 49.0                       101.0                         52 49                 101
1754882 1754882 IN     school 1807260 3135   Mt Vernon Community School Corp 180726001220 2561 Mt Comfort Elementary School   Regular School No Elementary KG 05 2019   grade_3                         52.0 49.0                       101.0                         52 49                 101
1755052 1755052 IN     school 1801020 3305   Brownsburg Community School Corp 180102000045 2711 Eagle Elementary School   Regular School No Elementary KG 05 2019   grade_3                         53.0 48.0                       101.0                         53 48                 101
1755081 1755081 IN     school 1801020 3305   Brownsburg Community School Corp 180102001671 2723 White Lick Elementary School   Regular School No Elementary KG 05 2019   grade_3                         47.0 54.0                       101.0                         47 54                 101
1757881 1757881 IN     school 1808820 5340   Perry Township Schools 180882001470 5351 Winchester Village Elementary   Regular School No Elementary PK 05 2019   grade_3                         50.0 51.0                       101.0                         50 51                 101
1758027 1758027 IN     school 1812360 5360   M S D Warren Township 181236001969 5386 Pleasant Run Elementary School   Regular School No Elementary KG 04 2019   grade_3                         62.0 39.0                       101.0                         62 39                 101
1753490 1753490 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001236 1590 Huntingburg Elementary School   Regular School No Elementary PK 05 2019   grade_3                         49.0 53.0                       102.0                         49 53                 102
1753843 1753843 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No Elementary KG 05 2019   grade_3                         47.0 55.0                       102.0                         47 55                 102
1757450 1757450 IN     school 1810440 5255   South Madison Com Sch Corp 181044002167 4935 East Elementary School   Regular School No Elementary KG 06 2019   grade_3                         48.0 54.0                       102.0                         48 54                 102
1761035 1761035 IN     school 1810140 7365   Shelbyville Central Schools 181014001632 7729 Thomas A Hendricks Elementary Sch   Regular School No Elementary PK 05 2019   grade_3                         46.0 56.0                       102.0                         46 56                 102
1761578 1761578 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000482 8229 Scott Elementary School   Regular School No Elementary PK 06 2019   grade_3                         64.0 38.0                       102.0                         64 38                 102
1762079 1762079 IN     school 1806270 8045   Manchester Community Schools 180627001101 8633 Manchester Elementary School   Regular School No Elementary PK 03 2019   grade_3                         49.0 53.0                       102.0                         49 53                 102
1751836 1751836 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2019   grade_3                         56.0 47.0                       103.0                         56 47                 103
1753589 1753589 IN     school 1802400 2270   Concord Community Schools 180240000270 1721 Concord East Side Elementary Sch   Regular School No Elementary KG 04 2019   grade_3                         52.0 51.0                       103.0                         52 51                 103
1754375 1754375 IN     school 1803090 2940   Eastern Greene Schools 180309000407 2433 Eastern Greene Elementary School   Regular School No Elementary PK 04 2019   grade_3                         58.0 45.0                       103.0                         58 45                 103
1754871 1754871 IN     school 1807260 3135   Mt Vernon Community School Corp 180726002152 2558 Fortville Elementary School   Regular School No Elementary KG 05 2019   grade_3                         59.0 44.0                       103.0                         59 44                 103
1755159 1755159 IN     school 1800270 3315   Avon Community School Corp 180027001675 2740 Hickory Elementary School   Regular School No Elementary KG 04 2019   grade_3                         54.0 49.0                       103.0                         54 49                 103
1755376 1755376 IN     school 1811250 3460   Taylor Community School Corp 181125001812 2895 Taylor Elementary School   Regular School No Elementary PK 05 2019   grade_3                         56.0 47.0                       103.0                         56 47                 103
1757044 1757044 IN     school 1807350 4740   School Town of Munster 180735001255 4337 James B Eads Elementary School   Regular School No Elementary KG 05 2019   grade_3                         58.0 45.0                       103.0                         58 45                 103
1757619 1757619 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2019   grade_3                         53.0 50.0                       103.0                         53 50                 103
1757658 1757658 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002349 5200 Mary Adams Elementary School   Regular School No Elementary KG 05 2019   grade_3                         53.0 50.0                       103.0                         53 50                 103
1757715 1757715 IN     school 1805670 5330   M S D Lawrence Township 180567001032 5283 Mary Evelyn Castle Elementary Sch   Regular School No Elementary 01 06 2019   grade_3                         46.0 57.0                       103.0                         46 57                 103
1761531 1761531 IN     school 1811400 7945   Tipton Community School Corp 181140001844 8163 Tipton Elementary School   Regular School No Elementary PK 05 2019   grade_3                         56.0 47.0                       103.0                         56 47                 103
1762939 1762939 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes Elementary KG 04 2019   grade_3                         52.0 51.0                       103.0                         52 51                 103
1752378 1752378 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2019   grade_3                         55.0 49.0                       104.0                         55 49                 104
1752628 1752628 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2019   grade_3                         56.0 48.0                       104.0                         56 48                 104
1754760 1754760 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No Elementary PK 05 2019   grade_3                         60.0 44.0                       104.0                         60 44                 104
1760127 1760127 IN     school 1807110 6620   Eastern Pulaski Community Sch Corp 180711001204 6994 Eastern Pulaski Elementary School   Regular School No Elementary PK 05 2019   grade_3                         60.0 44.0                       104.0                         60 44                 104
1761336 1761336 IN     school 1805400 7855   Lafayette School Corporation 180540000963 8089 Edgelea Elementary School   Regular School No Elementary KG 04 2019   grade_3                         47.0 57.0                       104.0                         47 57                 104
1762140 1762140 IN     school 1812150 8060   Wabash City Schools 181215001937 8706 O J Neighbours Elementary School   Regular School No Elementary PK 04 2019   grade_3                         45.0 59.0                       104.0                         45 59                 104
1751866 1751866 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary School   Regular School No Elementary PK 05 2019   grade_3                         56.0 49.0                       105.0                         56 49                 105
1752014 1752014 IN     school 1803630 235   Fort Wayne Community Schools 180363000540 270 Lincoln Elementary School   Regular School No Elementary KG 05 2019   grade_3                         55.0 50.0                       105.0                         55 50                 105
1752964 1752964 IN     school 1807710 1375   North Daviess Com Schools 180771001648 1090 North Daviess Elementary School   Regular School No Elementary KG 06 2019   grade_3                         52.0 53.0                       105.0                         52 53                 105
1754708 1754708 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No Elementary PK 05 2019   grade_3                         58.0 47.0                       105.0                         58 47                 105
1757528 1757528 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2019   grade_3                         56.0 49.0                       105.0                         56 49                 105
1757756 1757756 IN     school 1805670 5330   M S D Lawrence Township 180567000150 5294 Forest Glen Elementary School   Regular School No Elementary PK 06 2019   grade_3                         53.0 52.0                       105.0                         53 52                 105
1758200 1758200 IN     school 1812810 5375   M S D Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No Elementary PK 06 2019   grade_3                         63.0 42.0                       105.0                         63 42                 105
1761951 1761951 IN     school 1812090 8030   Vigo County School Corp 181209001903 8511 Dixie Bee Elementary School   Regular School No Elementary KG 05 2019   grade_3                         71.0 34.0                       105.0                         71 34                 105
1751625 1751625 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2019   grade_3                         63.0 43.0                       106.0                         63 43                 106
1755412 1755412 IN     school 1803150 3480   Eastern Howard School Corporation 180315000412 2909 Eastern Elementary School   Regular School No Elementary PK 07 2019   grade_3                         49.0 57.0                       106.0                         49 57                 106
1755629 1755629 IN     school 1810080 3675   Seymour Community Schools 181008001619 3153 Seymour-Jackson Elementary School   Regular School No Elementary PK 05 2019   grade_3                         59.0 47.0                       106.0                         59 47                 106
1755924 1755924 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189002411 3430 Pleasant Crossing Elementary   Regular School No Elementary KG 05 2019   grade_3                         56.0 50.0                       106.0                         56 50                 106
1757397 1757397 IN     school 1806900 5085   Mitchell Community Schools 180690001194 4861 Burris Elementary School   Regular School No Elementary 03 05 2019   grade_3                         62.0 44.0                       106.0                         62 44                 106
1758021 1758021 IN     school 1812360 5360   M S D Warren Township 181236001967 5377 Lowell Elementary School   Regular School No Elementary KG 04 2019   grade_3                         59.0 47.0                       106.0                         59 47                 106
1758231 1758231 IN     school 1812810 5375   M S D Wayne Township 181281002031 5274 Chapelwood Elementary School   Regular School No Elementary KG 06 2019   grade_3                         47.0 59.0                       106.0                         47 59                 106
1760801 1760801 IN     school 1810290 7205   South Bend Community School Corp 181029001658 7573 Madison S.T.E.A.M. Academy   Regular School No Elementary KG 05 2019   grade_3                         60.0 46.0                       106.0                         60 46                 106
1761348 1761348 IN     school 1805400 7855   Lafayette School Corporation 180540000971 8103 Miami Elementary School   Regular School No Elementary KG 04 2019   grade_3                         50.0 56.0                       106.0                         50 56                 106
1761405 1761405 IN     school 1811340 7865   Tippecanoe School Corp 181134001826 8007 Hershey Elementary School   Regular School No Elementary KG 05 2019   grade_3                         59.0 47.0                       106.0                         59 47                 106
1762004 1762004 IN     school 1812090 8030   Vigo County School Corp 181209001909 8549 Lost Creek Elementary School   Regular School No Elementary PK 05 2019   grade_3                         47.0 59.0                       106.0                         47 59                 106
1753595 1753595 IN     school 1802400 2270   Concord Community Schools 180240000272 1723 Concord Ox-Bow Elementary School   Regular School No Elementary KG 05 2019   grade_3                         58.0 49.0                       107.0                         58 49                 107
1753614 1753614 IN     school 1806600 2275   Middlebury Community Schools 180660001163 1656 Jefferson Elementary School   Regular School No Elementary KG 03 2019   grade_3                         56.0 51.0                       107.0                         56 51                 107
1757442 1757442 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002052 5025 Lapel Elementary School   Regular School No Elementary PK 05 2019   grade_3                         53.0 54.0                       107.0                         53 54                 107
1755654 1755654 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No Elementary PK 05 2019   grade_3                         57.0 51.0                       108.0                         57 51                 108
1756887 1756887 IN     school 1804320 4710   School City of Hammond 180432000750 4453 Warren G Harding Elementary School   Regular School No Elementary PK 05 2019   grade_3                         53.0 55.0                       108.0                         53 55                 108
1757590 1757590 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2019   grade_3                         56.0 52.0                       108.0                         56 52                 108
1757651 1757651 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002113 5198 Thompson Crossing Elementary Sch   Regular School No Elementary KG 05 2019   grade_3                         55.0 53.0                       108.0                         55 53                 108
1757708 1757708 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2019   grade_3                         64.0 44.0                       108.0                         64 44                 108
1757873 1757873 IN     school 1808820 5340   Perry Township Schools 180882001466 5347 Southport Elementary School   Regular School No Elementary PK 05 2019   grade_3                         56.0 52.0                       108.0                         56 52                 108
1757936 1757936 IN     school 1808910 5350   M S D Pike Township 180891001484 5357 Central Elementary School   Regular School No Elementary KG 05 2019   grade_3                         57.0 51.0                       108.0                         57 51                 108
1758033 1758033 IN     school 1812360 5360   M S D Warren Township 181236001971 5389 Sunny Heights Elementary School   Regular School No Elementary KG 04 2019   grade_3                         57.0 51.0                       108.0                         57 51                 108
1758175 1758175 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2019   grade_3                         50.0 58.0                       108.0                         50 58                 108
1752480 1752480 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No Elementary PK 05 2019   grade_3                         55.0 54.0                       109.0                         55 54                 109
1754494 1754494 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000967 2481 Harrison Parkway Elementary School   Regular School No Elementary KG 04 2019   grade_3                         60.0 49.0                       109.0                         60 49                 109
1757553 1757553 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 05 2019   grade_3                         61.0 48.0                       109.0                         61 48                 109
1761739 1761739 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000483 8321 Stockwell Elementary School   Regular School No Elementary KG 05 2019   grade_3                         64.0 45.0                       109.0                         64 45                 109
1762300 1762300 IN     school 1803000 8215   East Washington School Corp 180300002195 8904 East Washington Elementary School   Regular School No Elementary PK 04 2019   grade_3                         55.0 54.0                       109.0                         55 54                 109
1762489 1762489 IN     school 1808220 8435   Northern Wells Community Schools 180822001411 9081 Ossian Elementary   Regular School No Elementary PK 05 2019   grade_3                         47.0 62.0                       109.0                         47 62                 109
1755333 1755333 IN     school 1807440 3445   New Castle Community School Corp 180744001289 2853 Sunnyside Elementary School   Regular School No Elementary KG 03 2019   grade_3                         10.0 1.0                       11.0                         10 1                 11
1753967 1753967 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001267 1929 Georgetown Elementary School   Regular School No Elementary KG 04 2019   grade_3                         61.0 49.0                       110.0                         61 49                 110
1756463 1756463 IN     school 1809690 4600   Merrillville Community School Corp 180969001582 3821 Henry P Fieler Elementary School   Regular School No Elementary PK 04 2019   grade_3                         55.0 55.0                       110.0                         55 55                 110
1757725 1757725 IN     school 1805670 5330   M S D Lawrence Township 180567001026 5285 Crestview Elementary School   Regular School No Elementary 01 06 2019   grade_3                         62.0 48.0                       110.0                         62 48                 110
1761490 1761490 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2019   grade_3                         63.0 47.0                       110.0                         63 47                 110
1762269 1762269 IN     school 1812390 8130   Warrick County School Corp 181239001984 8817 Newburgh Elementary School   Regular School No Elementary KG 05 2019   grade_3                         59.0 51.0                       110.0                         59 51                 110
1754720 1754720 IN     school 1801200 3060   Carmel Clay Schools 180120001405 2522 Towne Meadow Elementary School   Regular School No Elementary KG 05 2019   grade_3                         58.0 53.0                       111.0                         58 53                 111
1755815 1755815 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001766 3341 Southwestern Elementary School   Regular School No Elementary PK 05 2019   grade_3                         64.0 47.0                       111.0                         64 47                 111
1758167 1758167 IN     school 1812810 5375   M S D Wayne Township 181281002035 5257 McClelland Elementary School   Regular School No Elementary KG 06 2019   grade_3                         64.0 47.0                       111.0                         64 47                 111
1758192 1758192 IN     school 1812810 5375   M S D Wayne Township 181281000238 5267 North Wayne Elementary School   Regular School No Elementary KG 06 2019   grade_3                         57.0 54.0                       111.0                         57 54                 111
1758831 1758831 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elementary/Middle School   Regular School No Elementary KG 08 2019   grade_3                         63.0 48.0                       111.0                         63 48                 111
1754458 1754458 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No Elementary KG 04 2019   grade_3                         59.0 53.0                       112.0                         59 53                 112
1755973 1755973 IN     school 1801440 4205   Center Grove Community School Corp 180144002333 3444 Pleasant Grove Elementary School   Regular School No Elementary KG 05 2019   grade_3                         55.0 57.0                       112.0                         55 57                 112
1758244 1758244 IN     school 1812810 5375   M S D Wayne Township 181281002123 5446 Bridgeport Elementary School   Regular School No Elementary KG 06 2019   grade_3                         56.0 56.0                       112.0                         56 56                 112
1762390 1762390 IN     school 1808190 8375   Northeastern Wayne Schools 180819002228 8928 Northeastern Elementary School   Regular School No Elementary PK 05 2019   grade_3                         57.0 55.0                       112.0                         57 55                 112
1751859 1751859 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary School   Regular School No Elementary KG 05 2019   grade_3                         58.0 55.0                       113.0                         58 55                 113
1753020 1753020 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001803 1189 North Dearborn Elementary School   Regular School No Elementary PK 05 2019   grade_3                         61.0 52.0                       113.0                         61 52                 113
1754011 1754011 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001268 1957 Grant Line Elementary School   Regular School No Elementary KG 04 2019   grade_3                         52.0 61.0                       113.0                         52 61                 113
1757424 1757424 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002049 5009 Frankton Elementary School   Regular School No Elementary PK 06 2019   grade_3                         55.0 58.0                       113.0                         55 58                 113
1754401 1754401 IN     school 1805910 2950   Linton-Stockton School Corporation 180591001048 2441 Linton-Stockton Elementary   Regular School No Elementary KG 05 2019   grade_3                         53.0 61.0                       114.0                         53 61                 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]);