enrollments

Data source: Big Local News · About: Big Local

1,026 rows where grade = "kindergarten", state = "IN" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,026 ✖

grade ✖

  • kindergarten · 1,026 ✖
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
1918962 1918962 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         46.0 37.0                       83.0                         46 37                 83
1918985 1918985 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2021   kindergarten                         52.0 49.0                       101.0                         52 49                 101
1919003 1919003 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         47.0 37.0                       84.0                         47 37                 84
1919011 1919011 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         22.0 20.0                       42.0                         22 20                 42
1919018 1919018 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   kindergarten                         50.0 43.0                       93.0                         50 43                 93
1919035 1919035 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2021   kindergarten                         64.0 39.0                       103.0                         64 39                 103
1919046 1919046 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         33.0 32.0                       65.0                         33 32                 65
1919053 1919053 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2021   kindergarten                         40.0 33.0                       73.0                         40 33                 73
1919060 1919060 IN     school 1800030 125   MSD Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         81.0 61.0                       142.0                         81 61                 142
1919067 1919067 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2021   kindergarten                         19.0 22.0                       41.0                         19 22                 41
1919078 1919078 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         25.0 23.0                       48.0                         25 23                 48
1919086 1919086 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         47.0 57.0                       104.0                         47 57                 104
1919102 1919102 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         55.0 41.0                       96.0                         55 41                 96
1919109 1919109 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         40.0 30.0                       70.0                         40 30                 70
1919116 1919116 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         48.0 38.0                       86.0                         48 38                 86
1919124 1919124 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         49.0 43.0                       92.0                         49 43                 92
1919202 1919202 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         46.0 33.0                       79.0                         46 33                 79
1919210 1919210 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         45.0 41.0                       86.0                         45 41                 86
1919218 1919218 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         27.0 20.0                       47.0                         27 20                 47
1919226 1919226 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         30.0 26.0                       56.0                         30 26                 56
1919229 1919229 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No Elementary PK KG 2021   kindergarten                         28.0 33.0                       61.0                         28 33                 61
1919237 1919237 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         33.0 24.0                       57.0                         33 24                 57
1919245 1919245 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         48.0 54.0                       102.0                         48 54                 102
1919252 1919252 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         47.0 53.0                       100.0                         47 53                 100
1919260 1919260 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         32.0 26.0                       58.0                         32 26                 58
1919268 1919268 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         36.0 43.0                       79.0                         36 43                 79
1919275 1919275 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         47.0 40.0                       87.0                         47 40                 87
1919288 1919288 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         36.0 55.0                       91.0                         36 55                 91
1919296 1919296 IN     school 1803630 235   Fort Wayne Community Schools 180363000543 186 Mabel K Holland Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         36.0 34.0                       70.0                         36 34                 70
1919304 1919304 IN     school 1803630 235   Fort Wayne Community Schools 180363000532 189 Indian Village Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         23.0 30.0                       53.0                         23 30                 53
1919312 1919312 IN     school 1803630 235   Fort Wayne Community Schools 180363000535 193 John S Irwin Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         27.0 19.0                       46.0                         27 19                 46
1919319 1919319 IN     school 1803630 235   Fort Wayne Community Schools 180363000541 197 Lindley Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         23.0 27.0                       50.0                         23 27                 50
1919327 1919327 IN     school 1803630 235   Fort Wayne Community Schools 180363000544 205 Maplewood Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         50.0 38.0                       88.0                         50 38                 88
1919335 1919335 IN     school 1803630 235   Fort Wayne Community Schools 180363000572 209 Willard Shambaugh Elementary Sch   Regular School No Elementary KG 05 2021   kindergarten                         24.0 20.0                       44.0                         24 20                 44
1919342 1919342 IN     school 1803630 235   Fort Wayne Community Schools 180363000551 217 Northcrest Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         34.0 35.0                       69.0                         34 35                 69
1919355 1919355 IN     school 1803630 235   Fort Wayne Community Schools 180363000524 221 Francis M Price Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         36.0 27.0                       63.0                         36 27                 63
1919362 1919362 IN     school 1803630 235   Fort Wayne Community Schools 180363000559 233 Saint Joseph Central School   Regular School No Elementary KG 05 2021   kindergarten                         41.0 22.0                       63.0                         41 22                 63
1919369 1919369 IN     school 1803630 235   Fort Wayne Community Schools 180363000558 239 Robert C Harris Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         27.0 22.0                       49.0                         27 22                 49
1919375 1919375 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No Elementary PK KG 2021   kindergarten                         56.0 54.0                       110.0                         56 54                 110
1919383 1919383 IN     school 1803630 235   Fort Wayne Community Schools 180363000564 249 Levan R Scott Academy   Regular School No Elementary PK 05 2021   kindergarten                         37.0 32.0                       69.0                         37 32                 69
1919391 1919391 IN     school 1803630 235   Fort Wayne Community Schools 180363000563 253 South Wayne Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         30.0 22.0                       52.0                         30 22                 52
1919399 1919399 IN     school 1803630 235   Fort Wayne Community Schools 180363000948 257 Study Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         23.0 14.0                       37.0                         23 14                 37
1919407 1919407 IN     school 1803630 235   Fort Wayne Community Schools 180363000567 265 Washington Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         14.0 13.0                       27.0                         14 13                 27
1919415 1919415 IN     school 1803630 235   Fort Wayne Community Schools 180363000566 269 Washington Center Elementary Sch   Regular School No Elementary PK 05 2021   kindergarten                         50.0 37.0                       87.0                         50 37                 87
1919423 1919423 IN     school 1803630 235   Fort Wayne Community Schools 180363000540 270 Lincoln Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         48.0 42.0                       90.0                         48 42                 90
1919430 1919430 IN     school 1803630 235   Fort Wayne Community Schools 180363000569 273 Waynedale Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         30.0 41.0                       71.0                         30 41                 71
1919438 1919438 IN     school 1803630 235   Fort Wayne Community Schools 180363000514 275 Arlington Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         36.0 23.0                       59.0                         36 23                 59
1919467 1919467 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2021   kindergarten                         71.0 66.0                       137.0                         71 66                 137
1919476 1919476 IN     school 1802850 255   East Allen County Schools 180285000346 281 Heritage Elementary School   Regular School No Elementary KG 06 2021   kindergarten                         39.0 23.0                       62.0                         39 23                 62
1919489 1919489 IN     school 1802850 255   East Allen County Schools 180285000954 291 Cedarville Elementary School   Regular School No Elementary KG 03 2021   kindergarten                         102.0 101.0                       203.0                         102 101                 203
1919509 1919509 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2021   kindergarten                         79.0 87.0                       166.0                         79 87                 166
1919520 1919520 IN     school 1802850 255   East Allen County Schools 180285002514 323 Woodlan Elementary School   Regular School No Elementary KG 06 2021   kindergarten                         31.0 35.0                       66.0                         31 35                 66
1919533 1919533 IN     school 1800360 365   Bartholomew Con School Corp 180036002188 328 Clifty Creek Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         50.0 47.0                       97.0                         50 47                 97
1919542 1919542 IN     school 1800360 365   Bartholomew Con School Corp 180036002421 346 CSA Lincoln Campus   Regular School No Elementary KG 06 2021   kindergarten                         30.0 24.0                       54.0                         30 24                 54
1919550 1919550 IN     school 1800360 365   Bartholomew Con School Corp 180036000075 353 Mount Healthy Elementary School   Regular School No Elementary KG 06 2021   kindergarten                         24.0 27.0                       51.0                         24 27                 51
1919560 1919560 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         43.0 47.0                       90.0                         43 47                 90
1919569 1919569 IN     school 1800360 365   Bartholomew Con School Corp 180036000082 363 W D Richards Elementary School   Regular School No Elementary KG 06 2021   kindergarten                         34.0 36.0                       70.0                         34 36                 70
1919577 1919577 IN     school 1800360 365   Bartholomew Con School Corp 180036000079 366 Rockcreek Elementary School   Regular School No Elementary KG 06 2021   kindergarten                         23.0 23.0                       46.0                         23 23                 46
1919585 1919585 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         63.0 50.0                       113.0                         63 50                 113
1919594 1919594 IN     school 1800360 365   Bartholomew Con School Corp 180036000070 371 L F Smith Elementary   Regular School No Elementary KG 06 2021   kindergarten                         28.0 35.0                       63.0                         28 35                 63
1919602 1919602 IN     school 1800360 365   Bartholomew Con School Corp 180036002492 375 CSA Fodrea Campus   Regular School No Elementary PK 06 2021   kindergarten                         24.0 25.0                       49.0                         24 25                 49
1919611 1919611 IN     school 1800360 365   Bartholomew Con School Corp 180036000081 377 Taylorsville Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         37.0 50.0                       87.0                         37 50                 87
1919623 1919623 IN     school 1800360 365   Bartholomew Con School Corp 180036000080 392 Southside Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         71.0 52.0                       123.0                         71 52                 123
1919645 1919645 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000510 409 Hope Elementary School   Regular School No Elementary KG 06 2021   kindergarten                         33.0 27.0                       60.0                         33 27                 60
1919660 1919660 IN     school 1800480 395   Benton Community School Corp 180048000100 421 Otterbein Elementary School   Regular School No Elementary KG 06 2021   kindergarten                         25.0 11.0                       36.0                         25 11                 36
1919668 1919668 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         3.0 8.0                       11.0                         3 8                 11
1919684 1919684 IN     school 1800480 395   Benton Community School Corp 180048002403 446 Prairie Crossing Elementary School   Regular School No Elementary KG 06 2021   kindergarten                         28.0 38.0                       66.0                         28 38                 66
1919692 1919692 IN     school 1800570 515   Blackford County Schools 180057000107 485 Montpelier School   Regular School No Elementary KG 06 2021   kindergarten                         18.0 13.0                       31.0                         18 13                 31
1919708 1919708 IN     school 1800570 515   Blackford County Schools 180057000126 501 North Side Elementary School   Regular School No Elementary KG 02 2021   kindergarten                         53.0 48.0                       101.0                         53 48                 101
1919716 1919716 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002064 521 Granville Wells Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         35.0 18.0                       53.0                         35 18                 53
1919725 1919725 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002065 537 Thorntown Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         32.0 28.0                       60.0                         32 28                 60
1919756 1919756 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No Elementary PK 04 2021   kindergarten                         37.0 43.0                       80.0                         37 43                 80
1919763 1919763 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2021   kindergarten                         67.0 63.0                       130.0                         67 63                 130
1919770 1919770 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No Elementary PK 04 2021   kindergarten                         51.0 61.0                       112.0                         51 61                 112
1919777 1919777 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2021   kindergarten                         43.0 39.0                       82.0                         43 39                 82
1919784 1919784 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary KG 04 2021   kindergarten                         65.0 47.0                       112.0                         65 47                 112
1919791 1919791 IN     school 1805790 665   Lebanon Community School Corp 180579001042 534 Perry Worth Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         39.0 27.0                       66.0                         39 27                 66
1919807 1919807 IN     school 1805790 665   Lebanon Community School Corp 180579001038 561 Central Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         35.0 24.0                       59.0                         35 24                 59
1919814 1919814 IN     school 1805790 665   Lebanon Community School Corp 180579001039 565 Harney Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         37.0 23.0                       60.0                         37 23                 60
1919821 1919821 IN     school 1805790 665   Lebanon Community School Corp 180579001043 569 Hattie B Stokes Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         41.0 22.0                       63.0                         41 22                 63
1919836 1919836 IN     school 1800960 670   Brown County School Corporation 180096000173 577 Van Buren Elementary School   Regular School No Elementary PK 04 2021   kindergarten                         16.0 15.0                       31.0                         16 15                 31
1919843 1919843 IN     school 1800960 670   Brown County School Corporation 180096000170 581 Helmsburg Elementary School   Regular School No Elementary PK 04 2021   kindergarten                         18.0 16.0                       34.0                         18 16                 34
1919850 1919850 IN     school 1800960 670   Brown County School Corporation 180096000172 585 Sprunica Elementary School   Regular School No Elementary PK 04 2021   kindergarten                         20.0 18.0                       38.0                         20 18                 38
1919871 1919871 IN     school 1801290 750   Carroll Consolidated School Corp 180129002103 629 Carroll Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         42.0 34.0                       76.0                         42 34                 76
1919888 1919888 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         67.0 45.0                       112.0                         67 45                 112
1919904 1919904 IN     school 1808940 775   Pioneer Regional School Corp 180894001490 649 Pioneer Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         24.0 37.0                       61.0                         24 37                 61
1919921 1919921 IN     school 1810680 815   Lewis Cass Schools 181068002169 695 Lewis Cass Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         48.0 53.0                       101.0                         48 53                 101
1919940 1919940 IN     school 1806030 875   Logansport Community Sch Corp 180603001056 705 Franklin Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         48.0 29.0                       77.0                         48 29                 77
1919947 1919947 IN     school 1806030 875   Logansport Community Sch Corp 180603001055 709 Fairview Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         27.0 29.0                       56.0                         27 29                 56
1919955 1919955 IN     school 1806030 875   Logansport Community Sch Corp 180603002366 711 Landis Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         63.0 70.0                       133.0                         63 70                 133
1919963 1919963 IN     school 1806030 875   Logansport Community Sch Corp 180603001051 713 Columbia Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         31.0 34.0                       65.0                         31 34                 65
1919987 1919987 IN     school 1800212 935   Borden-Henryville School Corp 180021201530 767 Henryville Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         44.0 35.0                       79.0                         44 35                 79
1920004 1920004 IN     school 1800212 935   Borden-Henryville School Corp 180021201539 815 William W Borden Elementary School   Regular School No Elementary KG 06 2021   kindergarten                         16.0 25.0                       41.0                         16 25                 41
1920022 1920022 IN     school 1800213 945   Silver Creek School Corporation 180021302469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2021   kindergarten                         112.0 105.0                       217.0                         112 105                 217
1920034 1920034 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2021   kindergarten                         57.0 53.0                       110.0                         57 53                 110
1920054 1920054 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   kindergarten                         106.0 109.0                       215.0                         106 109                 215
1920061 1920061 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary PK 05 2021   kindergarten                         52.0 41.0                       93.0                         52 41                 93
1920069 1920069 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         30.0 19.0                       49.0                         30 19                 49
1920077 1920077 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         41.0 32.0                       73.0                         41 32                 73
1920085 1920085 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         43.0 53.0                       96.0                         43 53                 96

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