Data source: Big Local News · About: Big Local

7,343 rows where grade = "grade_4" and state = "IN" sorted by school_state_id

View and edit SQL

year

grade

  • grade_4 · 7,343
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
1159469 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         52.0 35.0                       87.0                         52 35                 87
1280859 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         50.0 51.0                       101.0                         50 51                 101
1292921 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_4                         51.0 52.0                       103.0                         51 52                 103
1751553 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_4                         54.0 52.0                       106.0                         54 52                 106
1787294 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_4                         63.0 38.0                       101.0                         63 38                 101
1906994 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   grade_4                         52.0 44.0                       96.0                         52 44                 96
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
1159510 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_4                         50.0 51.0                       101.0                         50 51                 101
1280900 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2016   grade_4                         41.0 47.0                       88.0                         41 47                 88
1292962 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2017   grade_4                         50.0 46.0                       96.0                         50 46                 96
1751594 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2019   grade_4                         39.0 44.0                       83.0                         39 44                 83
1787335 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   grade_4                         39.0 49.0                       88.0                         39 49                 88
1907035 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2020   grade_4                         50.0 53.0                       103.0                         50 53                 103
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
1159491 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No 1.0 02 04 2015   grade_4                         42.0 62.0                       104.0                         42 62                 104
1280881 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No 1.0 02 04 2016   grade_4                         56.0 54.0                       110.0                         56 54                 110
1292944 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No Elementary 02 04 2017   grade_4                         50.0 61.0                       111.0                         50 61                 111
1751576 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   grade_4                         62.0 59.0                       121.0                         62 59                 121
1787317 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary 02 04 2018   grade_4                         58.0 67.0                       125.0                         58 67                 125
1907017 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2020   grade_4                         65.0 45.0                       110.0                         65 45                 110
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
1159965 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No 1.0 03 06 2015   grade_4                         68.0 70.0                       138.0                         68 70                 138
1281357 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No 1.0 03 06 2016   grade_4                         79.0 93.0                       172.0                         79 93                 172
1293411 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2017   grade_4                         92.0 83.0                       175.0                         92 83                 175
1752035 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2019   grade_4                         100.0 103.0                       203.0                         100 103                 203
1787780 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2018   grade_4                         97.0 88.0                       185.0                         97 88                 185
1907475 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2020   grade_4                         115.0 101.0                       216.0                         115 101                 216
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
1159518 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_4                         52.0 54.0                       106.0                         52 54                 106
1280908 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_4                         53.0 45.0                       98.0                         53 45                 98
1292970 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_4                         60.0 47.0                       107.0                         60 47                 107
1751602 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_4                         56.0 45.0                       101.0                         56 45                 101
1787343 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   grade_4                         41.0 52.0                       93.0                         41 52                 93
1907043 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_4                         56.0 44.0                       100.0                         56 44                 100
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
1159525 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_4                         33.0 34.0                       67.0                         33 34                 67
1280915 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_4                         24.0 41.0                       65.0                         24 41                 65
1292977 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_4                         35.0 37.0                       72.0                         35 37                 72
1751609 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_4                         41.0 37.0                       78.0                         41 37                 78
1787350 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_4                         54.0 31.0                       85.0                         54 31                 85
1907050 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_4                         50.0 40.0                       90.0                         50 40                 90
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
1159977 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No 1.0 03 06 2015   grade_4                         97.0 94.0                       191.0                         97 94                 191
1281369 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No 2.0 04 06 2016   grade_4                         97.0 104.0                       201.0                         97 104                 201
1293424 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Elementary 03 06 2017   grade_4                         87.0 89.0                       176.0                         87 89                 176
1752047 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2019   grade_4                         93.0 91.0                       184.0                         93 91                 184
1787792 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2018   grade_4                         98.0 82.0                       180.0                         98 82                 180
1907487 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2020   grade_4                         111.0 114.0                       225.0                         111 114                 225
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
1159542 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_4                         38.0 35.0                       73.0                         38 35                 73
1280932 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_4                         38.0 50.0                       88.0                         38 50                 88
1292994 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   grade_4                         54.0 39.0                       93.0                         54 39                 93
1751626 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2019   grade_4                         44.0 46.0                       90.0                         44 46                 90
1787367 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   grade_4                         52.0 40.0                       92.0                         52 40                 92
1907067 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2020   grade_4                         71.0 53.0                       124.0                         71 53                 124
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
1159553 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_4                         31.0 31.0                       62.0                         31 31                 62
1280943 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_4                         33.0 32.0                       65.0                         33 32                 65
1293005 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2017   grade_4                         26.0 25.0                       51.0                         26 25                 51
1751637 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2019   grade_4                         45.0 23.0                       68.0                         45 23                 68
1787378 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2018   grade_4                         25.0 33.0                       58.0                         25 33                 58
1907078 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2020   grade_4                         31.0 39.0                       70.0                         31 39                 70
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
1159574 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No 1.0 KG 05 2015   grade_4                         13.0 19.0                       32.0                         13 19                 32
1280964 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No 1.0 KG 05 2016   grade_4                         12.0 14.0                       26.0                         12 14                 26
1293026 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2017   grade_4                         14.0 17.0                       31.0                         14 17                 31
1751658 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2019   grade_4                         15.0 15.0                       30.0                         15 15                 30
1787399 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2018   grade_4                         12.0 18.0                       30.0                         12 18                 30
1907099 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2020   grade_4                         18.0 17.0                       35.0                         18 17                 35
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
1159560 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_4                         35.0 36.0                       71.0                         35 36                 71
1280950 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_4                         38.0 27.0                       65.0                         38 27                 65
1293012 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2017   grade_4                         38.0 42.0                       80.0                         38 42                 80
1751644 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2019   grade_4                         38.0 44.0                       82.0                         38 44                 82
1787385 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2018   grade_4                         32.0 35.0                       67.0                         32 35                 67
1907085 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2020   grade_4                         30.0 33.0                       63.0                         30 33                 63
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
1159567 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_4                         71.0 55.0                       126.0                         71 55                 126
1280957 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_4                         55.0 67.0                       122.0                         55 67                 122
1293019 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2017   grade_4                         64.0 72.0                       136.0                         64 72                 136
1751651 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2019   grade_4                         74.0 72.0                       146.0                         74 72                 146
1787392 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   grade_4                         66.0 73.0                       139.0                         66 73                 139
1907092 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2020   grade_4                         64.0 59.0                       123.0                         64 59                 123
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
1159585 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         28.0 35.0                       63.0                         28 35                 63
1280975 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         39.0 39.0                       78.0                         39 39                 78
1293037 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2017   grade_4                         34.0 32.0                       66.0                         34 32                 66
1751669 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2019   grade_4                         32.0 40.0                       72.0                         32 40                 72
1787410 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2018   grade_4                         32.0 43.0                       75.0                         32 43                 75
1907110 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2020   grade_4                         41.0 38.0                       79.0                         41 38                 79
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
1159592 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         55.0 34.0                       89.0                         55 34                 89
1280982 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         45.0 40.0                       85.0                         45 40                 85
1293045 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2017   grade_4                         66.0 45.0                       111.0                         66 45                 111
1751677 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2019   grade_4                         56.0 58.0                       114.0                         56 58                 114
1787418 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2018   grade_4                         56.0 57.0                       113.0                         56 57                 113
1907118 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2020   grade_4                         53.0 46.0                       99.0                         53 46                 99
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
1159608 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         50.0 52.0                       102.0                         50 52                 102
1280998 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         50.0 43.0                       93.0                         50 43                 93

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