enrollments

Data source: Big Local News · About: Big Local

7,359 rows where grade = "grade_1" and state = "IN" sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 7,359 ✖
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
1159466 1159466 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         63.0 40.0                       103.0                         63 40                 103
1280856 1280856 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         51.0 52.0                       103.0                         51 52                 103
1292918 1292918 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_1                         54.0 40.0                       94.0                         54 40                 94
1751550 1751550 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_1                         64.0 62.0                       126.0                         64 62                 126
1787291 1787291 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_1                         59.0 42.0                       101.0                         59 42                 101
1906991 1906991 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   grade_1                         49.0 46.0                       95.0                         49 46                 95
1918957 1918957 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_1                         48.0 47.0                       95.0                         48 47                 95
1159507 1159507 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_1                         39.0 54.0                       93.0                         39 54                 93
1280897 1280897 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2016   grade_1                         40.0 43.0                       83.0                         40 43                 83
1292959 1292959 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2017   grade_1                         48.0 58.0                       106.0                         48 58                 106
1751591 1751591 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2019   grade_1                         45.0 40.0                       85.0                         45 40                 85
1787332 1787332 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   grade_1                         60.0 41.0                       101.0                         60 41                 101
1907032 1907032 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2020   grade_1                         45.0 60.0                       105.0                         45 60                 105
1918998 1918998 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2021   grade_1                         48.0 55.0                       103.0                         48 55                 103
1751573 1751573 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   grade_1                         51.0 44.0                       95.0                         51 44                 95
1907014 1907014 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2020   grade_1                         46.0 56.0                       102.0                         46 56                 102
1918980 1918980 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2021   grade_1                         60.0 53.0                       113.0                         60 53                 113
1159493 1159493 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No 1.0 PK 01 2015   grade_1                         59.0 62.0                       121.0                         59 62                 121
1280883 1280883 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No 1.0 PK 01 2016   grade_1                         60.0 61.0                       121.0                         60 61                 121
1292946 1292946 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2017   grade_1                         66.0 49.0                       115.0                         66 49                 115
1787319 1787319 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   grade_1                         51.0 56.0                       107.0                         51 56                 107
1159515 1159515 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         27.0 28.0                       55.0                         27 28                 55
1280905 1280905 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         42.0 27.0                       69.0                         42 27                 69
1292967 1292967 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_1                         33.0 22.0                       55.0                         33 22                 55
1751599 1751599 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_1                         34.0 26.0                       60.0                         34 26                 60
1787340 1787340 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   grade_1                         35.0 27.0                       62.0                         35 27                 62
1907040 1907040 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_1                         36.0 22.0                       58.0                         36 22                 58
1919006 1919006 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_1                         24.0 31.0                       55.0                         24 31                 55
1159522 1159522 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   grade_1                         43.0 38.0                       81.0                         43 38                 81
1280912 1280912 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2016   grade_1                         39.0 41.0                       80.0                         39 41                 80
1292974 1292974 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2017   grade_1                         42.0 39.0                       81.0                         42 39                 81
1751606 1751606 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2019   grade_1                         48.0 39.0                       87.0                         48 39                 87
1787347 1787347 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2018   grade_1                         38.0 40.0                       78.0                         38 40                 78
1907047 1907047 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2020   grade_1                         37.0 46.0                       83.0                         37 46                 83
1919013 1919013 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   grade_1                         55.0 38.0                       93.0                         55 38                 93
1159539 1159539 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   grade_1                         54.0 32.0                       86.0                         54 32                 86
1280929 1280929 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2016   grade_1                         46.0 42.0                       88.0                         46 42                 88
1292991 1292991 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   grade_1                         61.0 48.0                       109.0                         61 48                 109
1751623 1751623 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2019   grade_1                         56.0 49.0                       105.0                         56 49                 105
1787364 1787364 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   grade_1                         42.0 44.0                       86.0                         42 44                 86
1907064 1907064 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2020   grade_1                         51.0 48.0                       99.0                         51 48                 99
1919030 1919030 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2021   grade_1                         56.0 41.0                       97.0                         56 41                 97
1159550 1159550 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         27.0 31.0                       58.0                         27 31                 58
1280940 1280940 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         47.0 27.0                       74.0                         47 27                 74
1293002 1293002 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2017   grade_1                         33.0 40.0                       73.0                         33 40                 73
1751634 1751634 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2019   grade_1                         34.0 38.0                       72.0                         34 38                 72
1787375 1787375 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2018   grade_1                         42.0 32.0                       74.0                         42 32                 74
1907075 1907075 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2020   grade_1                         31.0 38.0                       69.0                         31 38                 69
1919041 1919041 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2021   grade_1                         39.0 42.0                       81.0                         39 42                 81
1159571 1159571 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No 1.0 KG 05 2015   grade_1                         12.0 16.0                       28.0                         12 16                 28
1280961 1280961 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No 1.0 KG 05 2016   grade_1                         18.0 13.0                       31.0                         18 13                 31
1293023 1293023 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2017   grade_1                         18.0 19.0                       37.0                         18 19                 37
1751655 1751655 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2019   grade_1                         11.0 14.0                       25.0                         11 14                 25
1787396 1787396 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2018   grade_1                         15.0 11.0                       26.0                         15 11                 26
1907096 1907096 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2020   grade_1                         15.0 23.0                       38.0                         15 23                 38
1919062 1919062 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2021   grade_1                         20.0 10.0                       30.0                         20 10                 30
1159557 1159557 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No 1.0 KG 05 2015   grade_1                         28.0 34.0                       62.0                         28 34                 62
1280947 1280947 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No 1.0 KG 05 2016   grade_1                         36.0 36.0                       72.0                         36 36                 72
1293009 1293009 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2017   grade_1                         35.0 30.0                       65.0                         35 30                 65
1751641 1751641 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2019   grade_1                         38.0 27.0                       65.0                         38 27                 65
1787382 1787382 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2018   grade_1                         40.0 30.0                       70.0                         40 30                 70
1907082 1907082 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2020   grade_1                         45.0 33.0                       78.0                         45 33                 78
1919048 1919048 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2021   grade_1                         32.0 24.0                       56.0                         32 24                 56
1159564 1159564 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         53.0 70.0                       123.0                         53 70                 123
1280954 1280954 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         71.0 63.0                       134.0                         71 63                 134
1293016 1293016 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2017   grade_1                         67.0 64.0                       131.0                         67 64                 131
1751648 1751648 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2019   grade_1                         94.0 61.0                       155.0                         94 61                 155
1787389 1787389 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   grade_1                         60.0 70.0                       130.0                         60 70                 130
1907089 1907089 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2020   grade_1                         78.0 55.0                       133.0                         78 55                 133
1919055 1919055 IN     school 1800030 125   MSD Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2021   grade_1                         80.0 72.0                       152.0                         80 72                 152
1159988 1159988 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No 1.0 PK 02 2015   grade_1                         81.0 72.0                       153.0                         81 72                 153
1281381 1281381 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No 1.0 PK 02 2016   grade_1                         63.0 75.0                       138.0                         63 75                 138
1293436 1293436 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2017   grade_1                         73.0 70.0                       143.0                         73 70                 143
1752059 1752059 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2019   grade_1                         62.0 69.0                       131.0                         62 69                 131
1787804 1787804 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2018   grade_1                         76.0 61.0                       137.0                         76 61                 137
1907499 1907499 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2020   grade_1                         70.0 75.0                       145.0                         70 75                 145
1919465 1919465 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2021   grade_1                         70.0 74.0                       144.0                         70 74                 144
1159582 1159582 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         30.0 41.0                       71.0                         30 41                 71
1280972 1280972 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         34.0 41.0                       75.0                         34 41                 75
1293034 1293034 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2017   grade_1                         36.0 37.0                       73.0                         36 37                 73
1751666 1751666 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2019   grade_1                         30.0 40.0                       70.0                         30 40                 70
1787407 1787407 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2018   grade_1                         35.0 36.0                       71.0                         35 36                 71
1907107 1907107 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2020   grade_1                         29.0 22.0                       51.0                         29 22                 51
1919073 1919073 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   grade_1                         31.0 26.0                       57.0                         31 26                 57
1159589 1159589 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         46.0 40.0                       86.0                         46 40                 86
1280979 1280979 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         55.0 56.0                       111.0                         55 56                 111
1293042 1293042 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2017   grade_1                         53.0 38.0                       91.0                         53 38                 91
1751674 1751674 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2019   grade_1                         66.0 47.0                       113.0                         66 47                 113
1787415 1787415 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2018   grade_1                         53.0 65.0                       118.0                         53 65                 118
1907115 1907115 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2020   grade_1                         62.0 38.0                       100.0                         62 38                 100
1919081 1919081 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   grade_1                         51.0 41.0                       92.0                         51 41                 92
1159605 1159605 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         33.0 34.0                       67.0                         33 34                 67
1280995 1280995 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         39.0 43.0                       82.0                         39 43                 82
1293058 1293058 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2017   grade_1                         47.0 38.0                       85.0                         47 38                 85
1751690 1751690 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2019   grade_1                         51.0 50.0                       101.0                         51 50                 101
1787431 1787431 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2018   grade_1                         48.0 33.0                       81.0                         48 33                 81
1907131 1907131 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2020   grade_1                         43.0 57.0                       100.0                         43 57                 100
1919097 1919097 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   grade_1                         58.0 46.0                       104.0                         58 46                 104
1159612 1159612 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         32.0 35.0                       67.0                         32 35                 67
1281002 1281002 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         38.0 37.0                       75.0                         38 37                 75

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