enrollments

Data source: Big Local News · About: Big Local

1,035 rows where grade = "grade_4", state = "IN" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,035 ✖

grade ✖

  • grade_4 · 1,035 ✖
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
1918960 1918960 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_4                         58.0 41.0                       99.0                         58 41                 99
1918983 1918983 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2021   grade_4                         51.0 51.0                       102.0                         51 51                 102
1919001 1919001 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2021   grade_4                         59.0 37.0                       96.0                         59 37                 96
1919009 1919009 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_4                         52.0 39.0                       91.0                         52 39                 91
1919016 1919016 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   grade_4                         40.0 44.0                       84.0                         40 44                 84
1919033 1919033 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2021   grade_4                         54.0 60.0                       114.0                         54 60                 114
1919044 1919044 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2021   grade_4                         47.0 36.0                       83.0                         47 36                 83
1919051 1919051 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2021   grade_4                         41.0 35.0                       76.0                         41 35                 76
1919058 1919058 IN     school 1800030 125   MSD Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2021   grade_4                         56.0 68.0                       124.0                         56 68                 124
1919065 1919065 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2021   grade_4                         18.0 13.0                       31.0                         18 13                 31
1919076 1919076 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   grade_4                         37.0 31.0                       68.0                         37 31                 68
1919084 1919084 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   grade_4                         55.0 70.0                       125.0                         55 70                 125
1919100 1919100 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   grade_4                         53.0 44.0                       97.0                         53 44                 97
1919107 1919107 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   grade_4                         52.0 49.0                       101.0                         52 49                 101
1919114 1919114 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   grade_4                         43.0 51.0                       94.0                         43 51                 94
1919122 1919122 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   grade_4                         52.0 46.0                       98.0                         52 46                 98
1919153 1919153 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_4                         29.0 37.0                       66.0                         29 37                 66
1919194 1919194 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2021   grade_4                         63.0 54.0                       117.0                         63 54                 117
1919200 1919200 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2021   grade_4                         38.0 59.0                       97.0                         38 59                 97
1919208 1919208 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2021   grade_4                         46.0 41.0                       87.0                         46 41                 87
1919216 1919216 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_4                         25.0 27.0                       52.0                         25 27                 52
1919224 1919224 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2021   grade_4                         26.0 28.0                       54.0                         26 28                 54
1919235 1919235 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2021   grade_4                         26.0 29.0                       55.0                         26 29                 55
1919243 1919243 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2021   grade_4                         66.0 62.0                       128.0                         66 62                 128
1919250 1919250 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2021   grade_4                         32.0 46.0                       78.0                         32 46                 78
1919258 1919258 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No Elementary PK 05 2021   grade_4                         29.0 34.0                       63.0                         29 34                 63
1919266 1919266 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary School   Regular School No Elementary KG 05 2021   grade_4                         42.0 50.0                       92.0                         42 50                 92
1919273 1919273 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary School   Regular School No Elementary PK 05 2021   grade_4                         49.0 52.0                       101.0                         49 52                 101
1919286 1919286 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary School   Regular School No Elementary PK 05 2021   grade_4                         56.0 35.0                       91.0                         56 35                 91
1919294 1919294 IN     school 1803630 235   Fort Wayne Community Schools 180363000543 186 Mabel K Holland Elementary School   Regular School No Elementary PK 05 2021   grade_4                         34.0 31.0                       65.0                         34 31                 65
1919302 1919302 IN     school 1803630 235   Fort Wayne Community Schools 180363000532 189 Indian Village Elementary School   Regular School No Elementary PK 05 2021   grade_4                         41.0 27.0                       68.0                         41 27                 68
1919310 1919310 IN     school 1803630 235   Fort Wayne Community Schools 180363000535 193 John S Irwin Elementary School   Regular School No Elementary KG 05 2021   grade_4                         28.0 21.0                       49.0                         28 21                 49
1919317 1919317 IN     school 1803630 235   Fort Wayne Community Schools 180363000541 197 Lindley Elementary School   Regular School No Elementary PK 05 2021   grade_4                         27.0 24.0                       51.0                         27 24                 51
1919325 1919325 IN     school 1803630 235   Fort Wayne Community Schools 180363000544 205 Maplewood Elementary School   Regular School No Elementary PK 05 2021   grade_4                         41.0 26.0                       67.0                         41 26                 67
1919333 1919333 IN     school 1803630 235   Fort Wayne Community Schools 180363000572 209 Willard Shambaugh Elementary Sch   Regular School No Elementary KG 05 2021   grade_4                         22.0 29.0                       51.0                         22 29                 51
1919340 1919340 IN     school 1803630 235   Fort Wayne Community Schools 180363000551 217 Northcrest Elementary School   Regular School No Elementary PK 05 2021   grade_4                         25.0 33.0                       58.0                         25 33                 58
1919353 1919353 IN     school 1803630 235   Fort Wayne Community Schools 180363000524 221 Francis M Price Elementary School   Regular School No Elementary KG 05 2021   grade_4                         41.0 20.0                       61.0                         41 20                 61
1919360 1919360 IN     school 1803630 235   Fort Wayne Community Schools 180363000559 233 Saint Joseph Central School   Regular School No Elementary KG 05 2021   grade_4                         44.0 31.0                       75.0                         44 31                 75
1919367 1919367 IN     school 1803630 235   Fort Wayne Community Schools 180363000558 239 Robert C Harris Elementary School   Regular School No Elementary KG 05 2021   grade_4                         36.0 29.0                       65.0                         36 29                 65
1919381 1919381 IN     school 1803630 235   Fort Wayne Community Schools 180363000564 249 Levan R Scott Academy   Regular School No Elementary PK 05 2021   grade_4                         27.0 35.0                       62.0                         27 35                 62
1919389 1919389 IN     school 1803630 235   Fort Wayne Community Schools 180363000563 253 South Wayne Elementary School   Regular School No Elementary PK 05 2021   grade_4                         25.0 27.0                       52.0                         25 27                 52
1919397 1919397 IN     school 1803630 235   Fort Wayne Community Schools 180363000948 257 Study Elementary School   Regular School No Elementary PK 05 2021   grade_4                         29.0 22.0                       51.0                         29 22                 51
1919405 1919405 IN     school 1803630 235   Fort Wayne Community Schools 180363000567 265 Washington Elementary School   Regular School No Elementary PK 05 2021   grade_4                         16.0 15.0                       31.0                         16 15                 31
1919413 1919413 IN     school 1803630 235   Fort Wayne Community Schools 180363000566 269 Washington Center Elementary Sch   Regular School No Elementary PK 05 2021   grade_4                         39.0 38.0                       77.0                         39 38                 77
1919421 1919421 IN     school 1803630 235   Fort Wayne Community Schools 180363000540 270 Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_4                         66.0 59.0                       125.0                         66 59                 125
1919428 1919428 IN     school 1803630 235   Fort Wayne Community Schools 180363000569 273 Waynedale Elementary School   Regular School No Elementary PK 05 2021   grade_4                         26.0 27.0                       53.0                         26 27                 53
1919436 1919436 IN     school 1803630 235   Fort Wayne Community Schools 180363000514 275 Arlington Elementary School   Regular School No Elementary KG 05 2021   grade_4                         38.0 27.0                       65.0                         38 27                 65
1919441 1919441 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2021   grade_4                         95.0 96.0                       191.0                         95 96                 191
1919453 1919453 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2021   grade_4                         118.0 89.0                       207.0                         118 89                 207
1919473 1919473 IN     school 1802850 255   East Allen County Schools 180285000346 281 Heritage Elementary School   Regular School No Elementary KG 06 2021   grade_4                         33.0 32.0                       65.0                         33 32                 65
1919503 1919503 IN     school 1802850 255   East Allen County Schools 180285000350 305 New Haven Intermediate School   Regular School No Elementary 03 06 2021   grade_4                         79.0 56.0                       135.0                         79 56                 135
1919517 1919517 IN     school 1802850 255   East Allen County Schools 180285002514 323 Woodlan Elementary School   Regular School No Elementary KG 06 2021   grade_4                         33.0 34.0                       67.0                         33 34                 67
1919530 1919530 IN     school 1800360 365   Bartholomew Con School Corp 180036002188 328 Clifty Creek Elementary School   Regular School No Elementary PK 06 2021   grade_4                         31.0 25.0                       56.0                         31 25                 56
1919539 1919539 IN     school 1800360 365   Bartholomew Con School Corp 180036002421 346 CSA Lincoln Campus   Regular School No Elementary KG 06 2021   grade_4                         26.0 23.0                       49.0                         26 23                 49
1919547 1919547 IN     school 1800360 365   Bartholomew Con School Corp 180036000075 353 Mount Healthy Elementary School   Regular School No Elementary KG 06 2021   grade_4                         28.0 32.0                       60.0                         28 32                 60
1919557 1919557 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No Elementary PK 06 2021   grade_4                         46.0 60.0                       106.0                         46 60                 106
1919566 1919566 IN     school 1800360 365   Bartholomew Con School Corp 180036000082 363 W D Richards Elementary School   Regular School No Elementary KG 06 2021   grade_4                         46.0 39.0                       85.0                         46 39                 85
1919574 1919574 IN     school 1800360 365   Bartholomew Con School Corp 180036000079 366 Rockcreek Elementary School   Regular School No Elementary KG 06 2021   grade_4                         26.0 24.0                       50.0                         26 24                 50
1919582 1919582 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elementary School   Regular School No Elementary PK 06 2021   grade_4                         46.0 41.0                       87.0                         46 41                 87
1919591 1919591 IN     school 1800360 365   Bartholomew Con School Corp 180036000070 371 L F Smith Elementary   Regular School No Elementary KG 06 2021   grade_4                         33.0 34.0                       67.0                         33 34                 67
1919599 1919599 IN     school 1800360 365   Bartholomew Con School Corp 180036002492 375 CSA Fodrea Campus   Regular School No Elementary PK 06 2021   grade_4                         29.0 23.0                       52.0                         29 23                 52
1919608 1919608 IN     school 1800360 365   Bartholomew Con School Corp 180036000081 377 Taylorsville Elementary School   Regular School No Elementary PK 06 2021   grade_4                         39.0 40.0                       79.0                         39 40                 79
1919620 1919620 IN     school 1800360 365   Bartholomew Con School Corp 180036000080 392 Southside Elementary School   Regular School No Elementary PK 06 2021   grade_4                         53.0 61.0                       114.0                         53 61                 114
1919642 1919642 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000510 409 Hope Elementary School   Regular School No Elementary KG 06 2021   grade_4                         28.0 36.0                       64.0                         28 36                 64
1919657 1919657 IN     school 1800480 395   Benton Community School Corp 180048000100 421 Otterbein Elementary School   Regular School No Elementary KG 06 2021   grade_4                         22.0 21.0                       43.0                         22 21                 43
1919665 1919665 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2021   grade_4                         8.0 8.0                       16.0                         8 8                 16
1919681 1919681 IN     school 1800480 395   Benton Community School Corp 180048002403 446 Prairie Crossing Elementary School   Regular School No Elementary KG 06 2021   grade_4                         36.0 23.0                       59.0                         36 23                 59
1919689 1919689 IN     school 1800570 515   Blackford County Schools 180057000107 485 Montpelier School   Regular School No Elementary KG 06 2021   grade_4                         14.0 10.0                       24.0                         14 10                 24
1919702 1919702 IN     school 1800570 515   Blackford County Schools 180057000108 494 Blackford Intermediate School   Regular School No Elementary 03 06 2021   grade_4                         41.0 47.0                       88.0                         41 47                 88
1919713 1919713 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002064 521 Granville Wells Elementary School   Regular School No Elementary PK 06 2021   grade_4                         26.0 27.0                       53.0                         26 27                 53
1919722 1919722 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002065 537 Thorntown Elementary School   Regular School No Elementary PK 06 2021   grade_4                         24.0 24.0                       48.0                         24 24                 48
1919755 1919755 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No Elementary PK 04 2021   grade_4                         42.0 32.0                       74.0                         42 32                 74
1919762 1919762 IN     school 1802830 630   Zionsville Community Schools 180283001551 517 Zionsville Pleasant View Elem Sch   Regular School No Elementary PK 04 2021   grade_4                         92.0 74.0                       166.0                         92 74                 166
1919769 1919769 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No Elementary PK 04 2021   grade_4                         61.0 77.0                       138.0                         61 77                 138
1919776 1919776 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2021   grade_4                         40.0 47.0                       87.0                         40 47                 87
1919783 1919783 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary KG 04 2021   grade_4                         45.0 54.0                       99.0                         45 54                 99
1919789 1919789 IN     school 1805790 665   Lebanon Community School Corp 180579001042 534 Perry Worth Elementary School   Regular School No Elementary KG 05 2021   grade_4                         24.0 22.0                       46.0                         24 22                 46
1919805 1919805 IN     school 1805790 665   Lebanon Community School Corp 180579001038 561 Central Elementary School   Regular School No Elementary KG 05 2021   grade_4                         34.0 26.0                       60.0                         34 26                 60
1919812 1919812 IN     school 1805790 665   Lebanon Community School Corp 180579001039 565 Harney Elementary School   Regular School No Elementary KG 05 2021   grade_4                         24.0 41.0                       65.0                         24 41                 65
1919819 1919819 IN     school 1805790 665   Lebanon Community School Corp 180579001043 569 Hattie B Stokes Elementary School   Regular School No Elementary KG 05 2021   grade_4                         33.0 34.0                       67.0                         33 34                 67
1919835 1919835 IN     school 1800960 670   Brown County School Corporation 180096000173 577 Van Buren Elementary School   Regular School No Elementary PK 04 2021   grade_4                         19.0 21.0                       40.0                         19 21                 40
1919842 1919842 IN     school 1800960 670   Brown County School Corporation 180096000170 581 Helmsburg Elementary School   Regular School No Elementary PK 04 2021   grade_4                         11.0 17.0                       28.0                         11 17                 28
1919849 1919849 IN     school 1800960 670   Brown County School Corporation 180096000172 585 Sprunica Elementary School   Regular School No Elementary PK 04 2021   grade_4                         32.0 25.0                       57.0                         32 25                 57
1919868 1919868 IN     school 1801290 750   Carroll Consolidated School Corp 180129002103 629 Carroll Elementary School   Regular School No Elementary PK 06 2021   grade_4                         45.0 35.0                       80.0                         45 35                 80
1919886 1919886 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No Elementary KG 05 2021   grade_4                         47.0 47.0                       94.0                         47 47                 94
1919901 1919901 IN     school 1808940 775   Pioneer Regional School Corp 180894001490 649 Pioneer Elementary School   Regular School No Elementary PK 06 2021   grade_4                         34.0 26.0                       60.0                         34 26                 60
1919919 1919919 IN     school 1810680 815   Lewis Cass Schools 181068002169 695 Lewis Cass Elementary School   Regular School No Elementary PK 05 2021   grade_4                         57.0 40.0                       97.0                         57 40                 97
1919938 1919938 IN     school 1806030 875   Logansport Community Sch Corp 180603001056 705 Franklin Elementary School   Regular School No Elementary KG 05 2021   grade_4                         30.0 38.0                       68.0                         30 38                 68
1919945 1919945 IN     school 1806030 875   Logansport Community Sch Corp 180603001055 709 Fairview Elementary School   Regular School No Elementary PK 05 2021   grade_4                         26.0 24.0                       50.0                         26 24                 50
1919953 1919953 IN     school 1806030 875   Logansport Community Sch Corp 180603002366 711 Landis Elementary School   Regular School No Elementary PK 05 2021   grade_4                         66.0 55.0                       121.0                         66 55                 121
1919961 1919961 IN     school 1806030 875   Logansport Community Sch Corp 180603001051 713 Columbia Elementary School   Regular School No Elementary KG 05 2021   grade_4                         39.0 31.0                       70.0                         39 31                 70
1919967 1919967 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 03 12 2021   grade_4                         2.0 1.0                       3.0                         2 1                 3
1919984 1919984 IN     school 1800212 935   Borden-Henryville School Corp 180021201530 767 Henryville Elementary School   Regular School No Elementary PK 06 2021   grade_4                         53.0 47.0                       100.0                         53 47                 100
1920001 1920001 IN     school 1800212 935   Borden-Henryville School Corp 180021201539 815 William W Borden Elementary School   Regular School No Elementary KG 06 2021   grade_4                         11.0 17.0                       28.0                         11 17                 28
1920018 1920018 IN     school 1800213 945   Silver Creek School Corporation 180021301538 789 Silver Creek Elementary School   Regular School No Elementary 02 05 2021   grade_4                         124.0 92.0                       216.0                         124 92                 216
1920033 1920033 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2021   grade_4                         41.0 41.0                       82.0                         41 41                 82
1920048 1920048 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_4                         78.0 70.0                       148.0                         78 70                 148
1920059 1920059 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary PK 05 2021   grade_4                         36.0 34.0                       70.0                         36 34                 70
1920067 1920067 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2021   grade_4                         27.0 26.0                       53.0                         27 26                 53
1920075 1920075 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2021   grade_4                         49.0 35.0                       84.0                         49 35                 84

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