Data source: Big Local News · About: Big Local

1,039 rows where grade = "kindergarten", state = "IN" and year = 2016 sorted by total

View and edit SQL

year

  • 2016 · 1,039

grade

  • kindergarten · 1,039
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
1286463 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1287204 IN     school 1805670 5330   M S D Lawrence Township 180567001034 5298 Skiles Test Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         0.0 1.0                       1.0                         0 1                 1
1291907 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1281183 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         50.0 50.0                       100.0                         50 50                 100
1281196 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         53.0 47.0                       100.0                         53 47                 100
1284427 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001567 2718 Delaware Trail Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         53.0 47.0                       100.0                         53 47                 100
1286101 IN     school 1802910 4680   Lake Station Community Schools 180291000381 3975 Virgil I Bailey Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         59.0 41.0                       100.0                         59 41                 100
1287424 IN     school 1812360 5360   M S D Warren Township 181236001962 5369 Eastridge Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         49.0 51.0                       100.0                         49 51                 100
1290965 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         59.0 41.0                       100.0                         59 41                 100
1291004 IN     school 1811400 7945   Tipton Community School Corp 181140001844 8163 Tipton Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         54.0 46.0                       100.0                         54 46                 100
1281627 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No 1.0 KG 03 2016   kindergarten                         55.0 46.0                       101.0                         55 46                 101
1284309 IN     school 1800690 3180   North Harrison Com School Corp 180069000143 2633 North Harrison Elementary Sch   Regular School No 1.0 KG 05 2016   kindergarten                         48.0 53.0                       101.0                         48 53                 101
1286950 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         59.0 42.0                       101.0                         59 42                 101
1290915 IN     school 1811340 7865   Tippecanoe School Corp 181134001821 8024 Battle Ground Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         46.0 55.0                       101.0                         46 55                 101
1291741 IN     school 1803000 8215   East Washington School Corp 180300002195 8904 East Washington Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         47.0 54.0                       101.0                         47 54                 101
1283319 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001267 1929 Georgetown Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         46.0 56.0                       102.0                         46 56                 102
1283829 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001750 2473 Fall Creek Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         47.0 55.0                       102.0                         47 55                 102
1284153 IN     school 1807650 3070   Noblesville Schools 180765001246 2547 White River Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         47.0 55.0                       102.0                         47 55                 102
1285249 IN     school 1805190 4015   Jennings County School Corporation 180519000924 3397 North Vernon Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         48.0 54.0                       102.0                         48 54                 102
1286063 IN     school 1802880 4670   School City of East Chicago 180288000375 3953 William McKinley Elementary School   Regular School No 1.0 PK 06 2016   kindergarten                         52.0 50.0                       102.0                         52 50                 102
1287533 IN     school 1812720 5370   M S D Washington Township 181272002376 5436 Fox Hill Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         56.0 46.0                       102.0                         56 46                 102
1289731 IN     school 1803990 6755   Greencastle Community Sch Corp 180399001625 7107 Deer Meadow Primary School   Regular School No 1.0 PK 02 2016   kindergarten                         63.0 39.0                       102.0                         63 39                 102
1282221 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         50.0 53.0                       103.0                         50 53                 103
1284765 IN     school 1803150 3480   Eastern Howard School Corporation 180315000412 2909 Eastern Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         52.0 51.0                       103.0                         52 51                 103
1291420 IN     school 1812090 8030   Vigo County School Corp 181209001914 8525 Rio Grande Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         52.0 51.0                       103.0                         52 51                 103
1284085 IN     school 1801200 3060   Carmel Clay Schools 180120002185 2526 West Clay Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         55.0 49.0                       104.0                         55 49                 104
1285067 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No 1.0 PK 05 2016   kindergarten                         51.0 53.0                       104.0                         51 53                 104
1285336 IN     school 1801440 4205   Center Grove Com Sch Corp 180144002333 3444 Pleasant Grove Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         50.0 54.0                       104.0                         50 54                 104
1287312 IN     school 1808820 5340   Perry Township Schools 180882001687 5366 Jeremiah Gray-Edison Elementary   Regular School No 1.0 PK 05 2016   kindergarten                         49.0 55.0                       104.0                         49 55                 104
1287363 IN     school 1808910 5350   M S D Pike Township 180891001484 5357 Central Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         57.0 47.0                       104.0                         57 47                 104
1288309 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elem/Middle School   Regular School No 1.0 KG 08 2016   kindergarten                         56.0 48.0                       104.0                         56 48                 104
1289518 IN     school 1811970 6560   Valparaiso Community Schools 181197000163 6893 Flint Lake Elementary Sch   Regular School No 1.0 KG 05 2016   kindergarten                         57.0 47.0                       104.0                         57 47                 104
1280902 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2016   kindergarten                         52.0 53.0                       105.0                         52 53                 105
1288198 IN     school 1804770 5385   Indianapolis Public Schools 180477002393 5662 Clarence Farrington School 61   Regular School No 1.0 PK 06 2016   kindergarten                         53.0 52.0                       105.0                         53 52                 105
1284135 IN     school 1807650 3070   Noblesville Schools 180765002340 2538 Hazel Dell Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         53.0 53.0                       106.0                         53 53                 106
1284187 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001407 2567 Sugar Creek Elementary Sch   Regular School No 1.0 KG 06 2016   kindergarten                         54.0 52.0                       106.0                         54 52                 106
1284394 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000994 2706 Brown Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         59.0 47.0                       106.0                         59 47                 106
1290846 IN     school 1805400 7855   Lafayette School Corporation 180540000978 8117 Vinton Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         57.0 49.0                       106.0                         57 49                 106
1280934 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2016   kindergarten                         62.0 45.0                       107.0                         62 45                 107
1282972 IN     school 1806600 2275   Middlebury Community Schools 180660001163 1656 Jefferson Elementary School   Regular School No 1.0 KG 03 2016   kindergarten                         58.0 49.0                       107.0                         58 49                 107
1283938 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No 1.0 PK 04 2016   kindergarten                         57.0 50.0                       107.0                         57 50                 107
1284044 IN     school 1801200 3060   Carmel Clay Schools 180120002267 2513 Orchard Park Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         54.0 53.0                       107.0                         54 53                 107
1287336 IN     school 1808910 5350   M S D Pike Township 180891002374 5352 Deer Run Elementary   Regular School No 1.0 KG 05 2016   kindergarten                         56.0 51.0                       107.0                         56 51                 107
1290512 IN     school 1810140 7365   Shelbyville Central Schools 181014001632 7729 Thomas A Hendricks Elementary Sch   Regular School No 1.0 PK 05 2016   kindergarten                         53.0 54.0                       107.0                         53 54                 107
1290520 IN     school 1810140 7365   Shelbyville Central Schools 181014001633 7733 William F Loper Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         60.0 47.0                       107.0                         60 47                 107
1281477 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2016   kindergarten                         67.0 41.0                       108.0                         67 41                 108
1284009 IN     school 1801200 3060   Carmel Clay Schools 180120002332 2508 Cherry Tree Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         57.0 51.0                       108.0                         57 51                 108
1284685 IN     school 1807440 3445   New Castle Community Sch Corp 180744001289 2853 Sunnyside Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         56.0 52.0                       108.0                         56 52                 108
1285395 IN     school 1803690 4225   Franklin Community School Corp 180369001030 3467 Creekside Elementary Sch   Regular School No 1.0 KG 04 2016   kindergarten                         51.0 57.0                       108.0                         51 57                 108
1287570 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No 1.0 PK 06 2016   kindergarten                         52.0 56.0                       108.0                         52 56                 108
1282967 IN     school 1802400 2270   Concord Community Schools 180240000274 1729 Concord West Side Elem School   Regular School No 1.0 KG 04 2016   kindergarten                         58.0 51.0                       109.0                         58 51                 109
1284066 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         61.0 48.0                       109.0                         61 48                 109
1284985 IN     school 1810080 3675   Seymour Community Schools 181008001619 3153 Seymour-Jackson Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         56.0 53.0                       109.0                         56 53                 109
1286863 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002049 5009 Frankton Elementary School   Regular School No 1.0 PK 06 2016   kindergarten                         57.0 52.0                       109.0                         57 52                 109
1286138 IN     school 1803870 4690   Gary Community School Corp 180387000617 4081 Dr Bernard C Watson Acad for Boys   Regular School No 1.0 KG 08 2016   kindergarten                         11.0 0.0                       11.0                         11 0                 11
1281690 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No 1.0 PK 04 2016   kindergarten                         60.0 50.0                       110.0                         60 50                 110
1282313 IN     school 1807710 1375   North Daviess Com Schools 180771001648 1090 North Daviess Elementary School   Regular School No 1.0 PK 06 2016   kindergarten                         50.0 60.0                       110.0                         50 60                 110
1284204 IN     school 1804050 3125   Greenfield-Central Com Schools 180405001665 2588 J B Stephens Elementary School   Regular School No 1.0 PK 03 2016   kindergarten                         60.0 50.0                       110.0                         60 50                 110
1286970 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         57.0 53.0                       110.0                         57 53                 110
1290761 IN     school 1810860 7715   Southwest School Corp 181086001771 7965 Sullivan Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         56.0 54.0                       110.0                         56 54                 110
1282852 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001236 1590 Huntingburg Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         54.0 57.0                       111.0                         54 57                 111
1283199 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         60.0 51.0                       111.0                         60 51                 111
1286889 IN     school 1810440 5255   South Madison Com Sch Corp 181044002167 4935 East Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         52.0 59.0                       111.0                         52 59                 111
1287182 IN     school 1805670 5330   M S D Lawrence Township 180567000150 5294 Forest Glen Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         60.0 51.0                       111.0                         60 51                 111
1287629 IN     school 1812810 5375   M S D Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No 1.0 PK 06 2016   kindergarten                         60.0 51.0                       111.0                         60 51                 111
1290816 IN     school 1805400 7855   Lafayette School Corporation 180540000965 8091 Glen Acres Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         59.0 52.0                       111.0                         59 52                 111
1291964 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000149 9098 Bluffton-Harrison Elem Sch   Regular School No 1.0 KG 04 2016   kindergarten                         53.0 58.0                       111.0                         53 58                 111
1283817 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No 1.0 KG 04 2016   kindergarten                         55.0 57.0                       112.0                         55 57                 112
1287264 IN     school 1808820 5340   Perry Township Schools 180882001459 5333 Glenns Valley Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         58.0 54.0                       112.0                         58 54                 112
1287385 IN     school 1808910 5350   M S D Pike Township 180891001486 5360 Guion Creek Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         62.0 50.0                       112.0                         62 50                 112
1290168 IN     school 1810290 7205   South Bend Community Sch Corp 181029001651 7435 Darden Primary Center   Regular School No 1.0 KG 04 2016   kindergarten                         61.0 51.0                       112.0                         61 51                 112
1291279 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000489 8381 West Terrace Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         58.0 54.0                       112.0                         58 54                 112
1282369 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001803 1189 North Dearborn Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         65.0 48.0                       113.0                         65 48                 113
1283853 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000967 2481 Harrison Parkway Elem School   Regular School No 1.0 KG 04 2016   kindergarten                         61.0 52.0                       113.0                         61 52                 113
1283951 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No 1.0 PK 04 2016   kindergarten                         65.0 48.0                       113.0                         65 48                 113
1283968 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No 1.0 PK 04 2016   kindergarten                         73.0 40.0                       113.0                         73 40                 113
1287256 IN     school 1808820 5340   Perry Township Schools 180882001456 5325 Clinton Young Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         54.0 59.0                       113.0                         54 59                 113
1287304 IN     school 1808820 5340   Perry Township Schools 180882001470 5351 Winchester Village Elementary   Regular School No 1.0 PK 05 2016   kindergarten                         66.0 47.0                       113.0                         66 47                 113
1287651 IN     school 1812810 5375   M S D Wayne Township 181281002042 5273 Westlake Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         60.0 53.0                       113.0                         60 53                 113
1287659 IN     school 1812810 5375   M S D Wayne Township 181281002031 5274 Chapelwood Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         58.0 55.0                       113.0                         58 55                 113
1289616 IN     school 1807110 6620   Eastern Pulaski Com Sch Corp 180711001204 6994 Eastern Pulaski Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         64.0 49.0                       113.0                         64 49                 113
1291719 IN     school 1812390 8130   Warrick County School Corp 181239002179 8819 Sharon Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         61.0 52.0                       113.0                         61 52                 113
1280884 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No 1.0 PK 01 2016   kindergarten                         65.0 49.0                       114.0                         65 49                 114
1281291 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No 1.0 PK KG 2016   kindergarten                         56.0 58.0                       114.0                         56 58                 114
1281339 IN     school 1803630 235   Fort Wayne Community Schools 180363000540 270 Lincoln Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         57.0 57.0                       114.0                         57 57                 114
1282949 IN     school 1802400 2270   Concord Community Schools 180240000270 1721 Concord East Side Elem School   Regular School No 1.0 KG 04 2016   kindergarten                         58.0 56.0                       114.0                         58 56                 114
1287377 IN     school 1808910 5350   M S D Pike Township 180891001485 5359 Eastbrook Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         59.0 55.0                       114.0                         59 55                 114
1281945 IN     school 1801920 1000   Clarksville Com School Corp 180192000251 845 Clarksville Elementary School   Regular School No 1.0 PK 04 2016   kindergarten                         54.0 61.0                       115.0                         54 61                 115
1283375 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741000852 1966 Floyds Knobs Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         56.0 60.0                       116.0                         56 60                 116
1287069 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002409 5194 South Creek Elementary   Regular School No 1.0 KG 05 2016   kindergarten                         60.0 56.0                       116.0                         60 56                 116
1287240 IN     school 1808820 5340   Perry Township Schools 180882001469 5321 William Henry Burkhart Elementary   Regular School No 1.0 PK 05 2016   kindergarten                         58.0 58.0                       116.0                         58 58                 116
1287466 IN     school 1812360 5360   M S D Warren Township 181236001959 5391 Brookview Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         61.0 55.0                       116.0                         61 55                 116
1287604 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No 1.0 PK 06 2016   kindergarten                         54.0 62.0                       116.0                         54 62                 116
1290228 IN     school 1810290 7205   South Bend Community Sch Corp 181029001646 7545 Harrison Primary Center   Regular School No 1.0 PK 04 2016   kindergarten                         58.0 58.0                       116.0                         58 58                 116
1290246 IN     school 1810290 7205   South Bend Community Sch Corp 181029001663 7555 Kennedy Primary Academy   Regular School No 1.0 KG 04 2016   kindergarten                         48.0 68.0                       116.0                         48 68                 116
1290908 IN     school 1811340 7865   Tippecanoe School Corp 181134001305 8021 Wea Ridge Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         60.0 56.0                       116.0                         60 56                 116
1285011 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         63.0 54.0                       117.0                         63 54                 117
1290822 IN     school 1805400 7855   Lafayette School Corporation 180540000971 8103 Miami Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         59.0 58.0                       117.0                         59 58                 117
1284127 IN     school 1807650 3070   Noblesville Schools 180765002414 2537 Noble Crossing Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         62.0 56.0                       118.0                         62 56                 118
1285844 IN     school 1809690 4600   Merrillville Community School 180969001585 3829 Jonas E Salk Elem Sch   Regular School No 1.0 KG 04 2016   kindergarten                         58.0 60.0                       118.0                         58 60                 118

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