enrollments

Data source: Big Local News · About: Big Local

1,030 rows where grade = "kindergarten", state = "IN" and year = 2019 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 1,030 ✖

grade ✖

  • kindergarten · 1,030 ✖
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
1757030 1757030 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No Elementary KG 06 2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1758219 1758219 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1758984 1758984 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1759003 1759003 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No Elementary KG 06 2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1763429 1763429 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1754978 1754978 IN     school 1810360 3190   South Harrison Com Schools 181036001698 2649 New Middletown Elementary School   Regular School No Elementary KG 06 2019   kindergarten                         5.0 5.0                       10.0                         5 5                 10
1751596 1751596 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         44.0 56.0                       100.0                         44 56                 100
1753501 1753501 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000684 1569 Ireland Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         49.0 51.0                       100.0                         49 51                 100
1753796 1753796 IN     school 1803270 2305   Elkhart Community Schools 180327000441 1785 Pinewood Elementary School   Regular School No Elementary KG 06 2019   kindergarten                         45.0 55.0                       100.0                         45 55                 100
1754082 1754082 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No Elementary PK 06 2019   kindergarten                         63.0 37.0                       100.0                         63 37                 100
1754899 1754899 IN     school 1807260 3135   Mt Vernon Community School Corp 180726002192 2570 McCordsville Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         45.0 55.0                       100.0                         45 55                 100
1755073 1755073 IN     school 1801020 3305   Brownsburg Community School Corp 180102001567 2718 Delaware Trail Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         52.0 48.0                       100.0                         52 48                 100
1755887 1755887 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000244 3401 Clark Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         47.0 53.0                       100.0                         47 53                 100
1756037 1756037 IN     school 1803690 4225   Franklin Community School Corp 180369001030 3467 Creekside Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         51.0 49.0                       100.0                         51 49                 100
1760797 1760797 IN     school 1810290 7205   South Bend Community School Corp 181029001673 7569 McKinley Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         53.0 47.0                       100.0                         53 47                 100
1760845 1760845 IN     school 1810290 7205   South Bend Community School Corp 181029001664 7601 Nuner Fine Arts Academy   Regular School No Elementary KG 05 2019   kindergarten                         45.0 55.0                       100.0                         45 55                 100
1760891 1760891 IN     school 1809990 7230   Scott County School District 1 180999001604 7630 Austin Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         46.0 54.0                       100.0                         46 54                 100
1761338 1761338 IN     school 1805400 7855   Lafayette School Corporation 180540000963 8089 Edgelea Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         47.0 53.0                       100.0                         47 53                 100
1762941 1762941 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes Elementary KG 04 2019   kindergarten                         54.0 46.0                       100.0                         54 46                 100
1753195 1753195 IN     school 1803840 1820   Garrett-Keyser-Butler Com Sch Corp 180384000606 1329 J E Ober Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         52.0 49.0                       101.0                         52 49                 101
1754704 1754704 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         52.0 49.0                       101.0                         52 49                 101
1756408 1756408 IN     school 1804350 4580   Hanover Community School Corp 180435000754 3781 Jane Ball Elementary School   Regular School No Elementary PK 04 2019   kindergarten                         56.0 45.0                       101.0                         56 45                 101
1758145 1758145 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No Elementary PK 06 2019   kindergarten                         55.0 46.0                       101.0                         55 46                 101
1761038 1761038 IN     school 1810140 7365   Shelbyville Central Schools 181014001632 7729 Thomas A Hendricks Elementary Sch   Regular School No Elementary PK 05 2019   kindergarten                         58.0 43.0                       101.0                         58 43                 101
1762302 1762302 IN     school 1803000 8215   East Washington School Corp 180300002195 8904 East Washington Elementary School   Regular School No Elementary PK 04 2019   kindergarten                         46.0 55.0                       101.0                         46 55                 101
1752181 1752181 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elementary School   Regular School No Elementary KG 06 2019   kindergarten                         45.0 57.0                       102.0                         45 57                 102
1755416 1755416 IN     school 1803150 3480   Eastern Howard School Corporation 180315000412 2909 Eastern Elementary School   Regular School No Elementary PK 07 2019   kindergarten                         42.0 60.0                       102.0                         42 60                 102
1756778 1756778 IN     school 1803870 4690   Gary Community School Corp 180387002104 4169 Daniel Hale Williams Elem Sch   Regular School No Elementary KG 05 2019   kindergarten                         50.0 52.0                       102.0                         50 52                 102
1751839 1751839 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         54.0 49.0                       103.0                         54 49                 103
1752017 1752017 IN     school 1803630 235   Fort Wayne Community Schools 180363000540 270 Lincoln Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         43.0 60.0                       103.0                         43 60                 103
1752373 1752373 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2019   kindergarten                         56.0 47.0                       103.0                         56 47                 103
1753248 1753248 IN     school 1802660 1875   Delaware Community School Corp 180266000324 1365 Royerton Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         51.0 52.0                       103.0                         51 52                 103
1753304 1753304 IN     school 1805880 1895   Liberty-Perry Community Sch Corp 180588001045 1381 Selma Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         51.0 52.0                       103.0                         51 52                 103
1754655 1754655 IN     school 1801200 3060   Carmel Clay Schools 180120002332 2508 Cherry Tree Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         61.0 42.0                       103.0                         61 42                 103
1755091 1755091 IN     school 1801020 3305   Brownsburg Community School Corp 180102001570 2727 Cardinal Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         49.0 54.0                       103.0                         49 54                 103
1755284 1755284 IN     school 1808280 3435   Shenandoah School Corporation 180828002356 2815 Shenandoah Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         48.0 55.0                       103.0                         48 55                 103
1755456 1755456 IN     school 1805370 3500   Kokomo School Corporation 180537000959 2943 Sycamore Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         54.0 49.0                       103.0                         54 49                 103
1755632 1755632 IN     school 1810080 3675   Seymour Community Schools 181008001619 3153 Seymour-Jackson Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         45.0 58.0                       103.0                         45 58                 103
1757061 1757061 IN     school 1807350 4740   School Town of Munster 180735001254 4343 Frank H Hammond Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         53.0 50.0                       103.0                         53 50                 103
1759901 1759901 IN     school 1809180 6520   Porter Township School Corp 180918001522 6840 Porter Lakes Elementary School   Regular School No Elementary PK 03 2019   kindergarten                         54.0 49.0                       103.0                         54 49                 103
1762272 1762272 IN     school 1812390 8130   Warrick County School Corp 181239001984 8817 Newburgh Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         56.0 47.0                       103.0                         56 47                 103
1751846 1751846 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         50.0 54.0                       104.0                         50 54                 104
1752380 1752380 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2019   kindergarten                         51.0 53.0                       104.0                         51 53                 104
1752483 1752483 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         52.0 52.0                       104.0                         52 52                 104
1753615 1753615 IN     school 1806600 2275   Middlebury Community Schools 180660001163 1656 Jefferson Elementary School   Regular School No Elementary KG 03 2019   kindergarten                         52.0 52.0                       104.0                         52 52                 104
1755818 1755818 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001766 3341 Southwestern Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         44.0 60.0                       104.0                         44 60                 104
1756472 1756472 IN     school 1809690 4600   Merrillville Community School Corp 180969001583 3822 Homer Iddings Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         56.0 48.0                       104.0                         56 48                 104
1757403 1757403 IN     school 1806900 5085   Mitchell Community Schools 180690001196 4863 Hatfield Elementary School   Regular School No Elementary PK 02 2019   kindergarten                         49.0 55.0                       104.0                         49 55                 104
1757445 1757445 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002052 5025 Lapel Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         60.0 44.0                       104.0                         60 44                 104
1757573 1757573 IN     school 1803300 5280   Elwood Community School Corp 180330000448 5157 Elwood Elementary School   Regular School No Elementary PK 02 2019   kindergarten                         63.0 41.0                       104.0                         63 41                 104
1758837 1758837 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elementary/Middle School   Regular School No Elementary KG 08 2019   kindergarten                         59.0 45.0                       104.0                         59 45                 104
1761493 1761493 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         55.0 49.0                       104.0                         55 49                 104
1752582 1752582 IN     school 1809370 940   West Clark Community Schools 180937001530 767 Henryville Elementary School   Regular School No Elementary PK 06 2019   kindergarten                         52.0 53.0                       105.0                         52 53                 105
1753372 1753372 IN     school 1807320 1970   Muncie Community Schools 180732001235 1470 Grissom Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         57.0 48.0                       105.0                         57 48                 105
1755055 1755055 IN     school 1801020 3305   Brownsburg Community School Corp 180102000045 2711 Eagle Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         65.0 40.0                       105.0                         65 40                 105
1761350 1761350 IN     school 1805400 7855   Lafayette School Corporation 180540000971 8103 Miami Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         49.0 56.0                       105.0                         49 56                 105
1761374 1761374 IN     school 1805400 7855   Lafayette School Corporation 180540000978 8117 Vinton Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         55.0 50.0                       105.0                         55 50                 105
1761742 1761742 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000483 8321 Stockwell Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         58.0 47.0                       105.0                         58 47                 105
1762047 1762047 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         53.0 52.0                       105.0                         53 52                 105
1752304 1752304 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No Elementary KG 02 2019   kindergarten                         57.0 49.0                       106.0                         57 49                 106
1752518 1752518 IN     school 1810680 815   Lewis Cass Schools 181068002169 695 Lewis Cass Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         46.0 60.0                       106.0                         46 60                 106
1752968 1752968 IN     school 1807710 1375   North Daviess Com Schools 180771001648 1090 North Daviess Elementary School   Regular School No Elementary KG 06 2019   kindergarten                         68.0 38.0                       106.0                         68 38                 106
1753591 1753591 IN     school 1802400 2270   Concord Community Schools 180240000270 1721 Concord East Side Elementary Sch   Regular School No Elementary KG 04 2019   kindergarten                         47.0 59.0                       106.0                         47 59                 106
1754032 1754032 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002204 1974 Mount Tabor Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         58.0 48.0                       106.0                         58 48                 106
1757496 1757496 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2019   kindergarten                         59.0 47.0                       106.0                         59 47                 106
1757556 1757556 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         51.0 55.0                       106.0                         51 55                 106
1761046 1761046 IN     school 1810140 7365   Shelbyville Central Schools 181014001633 7733 William F Loper Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         49.0 57.0                       106.0                         49 57                 106
1761344 1761344 IN     school 1805400 7855   Lafayette School Corporation 180540000965 8091 Glen Acres Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         55.0 51.0                       106.0                         55 51                 106
1754454 1754454 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001751 2469 Fishers Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         53.0 54.0                       107.0                         53 54                 107
1754848 1754848 IN     school 1804050 3125   Greenfield-Central Com Schools 180405001665 2588 JB Stephens Elementary School   Regular School No Elementary KG 03 2019   kindergarten                         57.0 50.0                       107.0                         57 50                 107
1759596 1759596 IN     school 1808640 6155   Paoli Community School Corp 180864001439 6587 Throop Elementary School   Regular School No Elementary PK 06 2019   kindergarten                         50.0 57.0                       107.0                         50 57                 107
1760576 1760576 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876000526 7383 Horizon Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         54.0 53.0                       107.0                         54 53                 107
1761429 1761429 IN     school 1811340 7865   Tippecanoe School Corp 181134001304 8019 Burnett Creek Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         51.0 56.0                       107.0                         51 56                 107
1752129 1752129 IN     school 1800360 365   Bartholomew Con School Corp 180036002188 328 Clifty Creek Elementary School   Regular School No Elementary PK 06 2019   kindergarten                         59.0 49.0                       108.0                         59 49                 108
1752868 1752868 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2019   kindergarten                         56.0 52.0                       108.0                         56 52                 108
1755657 1755657 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         55.0 53.0                       108.0                         55 53                 108
1756118 1756118 IN     school 1810410 4325   South Knox School Corp 181041001705 3489 South Knox Elementary School   Regular School No Elementary KG 06 2019   kindergarten                         49.0 59.0                       108.0                         49 59                 108
1756544 1756544 IN     school 1805450 4615   Lake Central School Corporation 180545002143 4349 Homan Elementary School   Regular School No Elementary PK 04 2019   kindergarten                         66.0 42.0                       108.0                         66 42                 108
1756736 1756736 IN     school 1803870 4690   Gary Community School Corp 180387000613 4053 Banneker Elementary at Marquette   Regular School No Elementary KG 05 2019   kindergarten                         49.0 59.0                       108.0                         49 59                 108
1758179 1758179 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2019   kindergarten                         50.0 58.0                       108.0                         50 58                 108
1761356 1761356 IN     school 1805400 7855   Lafayette School Corporation 180540000976 8104 Thomas Miller Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         62.0 46.0                       108.0                         62 46                 108
1763488 1763488 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2019   kindergarten                         62.0 46.0                       108.0                         62 46                 108
1752630 1752630 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2019   kindergarten                         52.0 57.0                       109.0                         52 57                 109
1752955 1752955 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000062 1073 Barr Reeve Primary Grade School   Regular School No Elementary KG 01 2019   kindergarten                         53.0 56.0                       109.0                         53 56                 109
1754874 1754874 IN     school 1807260 3135   Mt Vernon Community School Corp 180726002152 2558 Fortville Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         59.0 50.0                       109.0                         59 50                 109
1755149 1755149 IN     school 1800270 3315   Avon Community School Corp 180027002194 2738 Cedar Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         61.0 48.0                       109.0                         61 48                 109
1762235 1762235 IN     school 1812390 8130   Warrick County School Corp 181239001987 8785 Tennyson Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         8.0 3.0                       11.0                         8 3                 11
1753493 1753493 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001236 1590 Huntingburg Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         60.0 50.0                       110.0                         60 50                 110
1754614 1754614 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2019   kindergarten                         59.0 51.0                       110.0                         59 51                 110
1754747 1754747 IN     school 1807650 3070   Noblesville Schools 180765002158 2523 Hinkle Creek Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         60.0 50.0                       110.0                         60 50                 110
1755379 1755379 IN     school 1811250 3460   Taylor Community School Corp 181125001812 2895 Taylor Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         54.0 56.0                       110.0                         54 56                 110
1755640 1755640 IN     school 1810080 3675   Seymour Community Schools 181008001620 3157 Seymour-Redding Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         53.0 57.0                       110.0                         53 57                 110
1755715 1755715 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No Elementary PK 05 2019   kindergarten                         61.0 49.0                       110.0                         61 49                 110
1762492 1762492 IN     school 1808220 8435   Northern Wells Community Schools 180822001411 9081 Ossian Elementary   Regular School No Elementary PK 05 2019   kindergarten                         61.0 49.0                       110.0                         61 49                 110
1763503 1763503 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 04 2019   kindergarten                         57.0 53.0                       110.0                         57 53                 110
1754763 1754763 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         50.0 61.0                       111.0                         50 61                 111
1755976 1755976 IN     school 1801440 4205   Center Grove Community School Corp 180144002333 3444 Pleasant Grove Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         55.0 56.0                       111.0                         55 56                 111
1756642 1756642 IN     school 1802490 4660   Crown Point Community School Corp 180249000296 3903 Lake Street Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         62.0 49.0                       111.0                         62 49                 111
1757470 1757470 IN     school 1810440 5255   South Madison Com Sch Corp 181044001713 5061 Pendleton Elementary School   Regular School No Elementary PK 06 2019   kindergarten                         49.0 62.0                       111.0                         49 62                 111
1754502 1754502 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002061 2482 Sand Creek Elementary   Regular School No Elementary KG 04 2019   kindergarten                         51.0 61.0                       112.0                         51 61                 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]);