Data source: Big Local News · About: Big Local

12,058 rows where state = "IN" and year = 2017 sorted by ccd_school_lvl

View and edit SQL

grade

year

  • 2017 · 12,058
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
1293484 IN     school   255   East Allen County Schools   318 Park Hill Learning Center             2017   pk_12_total 47.0 7.0 6.0     1.0         1.0   37.0 25.0     0.0             47.0   62.0 47 7 6     1         1   37 25     0       47   62
1293485 IN     school   255   East Allen County Schools   318 Park Hill Learning Center             2017   pre_kindergarten                         37.0 25.0                       62.0                         37 25                 62
1299669 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_1                         3.0 0.0                       3.0                         3 0                 3
1299670 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_10                         8.0 0.0                       8.0                         8 0                 8
1299671 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_11                         5.0 0.0                       5.0                         5 0                 5
1299672 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_12                         6.0 1.0                       7.0                         6 1                 7
1299673 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_2                         6.0 0.0                       6.0                         6 0                 6
1299674 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_3                         6.0 1.0                       7.0                         6 1                 7
1299675 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_4                         5.0 1.0                       6.0                         5 1                 6
1299676 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_5                         7.0 1.0                       8.0                         7 1                 8
1299677 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_6                         4.0 1.0                       5.0                         4 1                 5
1299678 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_7                         10.0 2.0                       12.0                         10 2                 12
1299679 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_8                         6.0 1.0                       7.0                         6 1                 7
1299680 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_9                         19.0 1.0                       20.0                         19 1                 20
1299681 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   kindergarten                         1.0 2.0                       3.0                         1 2                 3
1299682 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   pk_12_total 48.0 35.0 6.0               8.0   86.0 11.0     5.0             89.0   97.0 48 35 6               8   86 11     5       89   97
1302344 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2017   pk_12_total 95.0 28.0 26.0               8.0   102.0 55.0     0.0             113.0   157.0 95 28 26               8   102 55     0       113   157
1302345 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2017   pre_kindergarten                         102.0 55.0                       157.0                         102 55                 157
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
1292919 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_2                         53.0 52.0                       105.0                         53 52                 105
1292920 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_3                         63.0 38.0                       101.0                         63 38                 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
1292922 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_5                         50.0 51.0                       101.0                         50 51                 101
1292923 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         62.0 42.0                       104.0                         62 42                 104
1292924 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 566.0 8.0 25.0     4.0         9.0   335.0 277.0     22.0             88.0   612.0 566 8 25     4         9   335 277     22       88   612
1292925 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         2.0 2.0                       4.0                         2 2                 4
1292942 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No Elementary 02 04 2017   grade_2                         60.0 62.0                       122.0                         60 62                 122
1292943 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No Elementary 02 04 2017   grade_3                         63.0 64.0                       127.0                         63 64                 127
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
1292945 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No Elementary 02 04 2017   pk_12_total 290.0 10.0 39.0     3.0     2.0   16.0   173.0 187.0     2.0             70.0   360.0 290 10 39     3     2   16   173 187     2       70   360
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
1292947 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2017   kindergarten                         63.0 62.0                       125.0                         63 62                 125
1292948 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2017   pk_12_total 230.0 9.0 38.0     1.0     1.0   14.0   156.0 137.0     1.0             49.0   293.0 230 9 38     1     1   14   156 137     1       49   293
1292949 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2017   pre_kindergarten                         27.0 26.0                       53.0                         27 26                 53
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
1292960 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2017   grade_2                         39.0 43.0                       82.0                         39 43                 82
1292961 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2017   grade_3                         43.0 51.0                       94.0                         43 51                 94
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
1292963 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2017   grade_5                         42.0 49.0                       91.0                         42 49                 91
1292964 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         64.0 40.0                       104.0                         64 40                 104
1292965 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 521.0 3.0 74.0 2.0   6.0         13.0   313.0 306.0     63.0             125.0   619.0 521 3 74 2   6         13   313 306     63       125   619
1292966 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         27.0 19.0                       46.0                         27 19                 46
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
1292968 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_2                         47.0 38.0                       85.0                         47 38                 85
1292969 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_3                         39.0 50.0                       89.0                         39 50                 89
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
1292971 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_5                         53.0 45.0                       98.0                         53 45                 98
1292972 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         13.0 21.0                       34.0                         13 21                 34
1292973 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 376.0 8.0 20.0 1.0   38.0         25.0   245.0 223.0     1.0             16.0   468.0 376 8 20 1   38         25   245 223     1       16   468
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
1292975 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_2                         35.0 37.0                       72.0                         35 37                 72
1292976 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_3                         50.0 34.0                       84.0                         50 34                 84
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
1292978 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_5                         26.0 42.0                       68.0                         26 42                 68
1292979 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2017   kindergarten                         43.0 38.0                       81.0                         43 38                 81
1292980 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2017   pk_12_total 339.0 39.0 34.0 2.0   35.0     2.0   34.0   250.0 235.0     17.0             50.0   485.0 339 39 34 2   35     2   34   250 235     17       50   485
1292981 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2017   pre_kindergarten                         19.0 8.0                       27.0                         19 8                 27
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
1292992 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   grade_2                         40.0 44.0                       84.0                         40 44                 84
1292993 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   grade_3                         50.0 42.0                       92.0                         50 42                 92
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
1292995 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   grade_5                         42.0 52.0                       94.0                         42 52                 94
1292996 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   kindergarten                         43.0 43.0                       86.0                         43 43                 86
1292997 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   pk_12_total 493.0 18.0 20.0 2.0   7.0         18.0   290.0 268.0     1.0             36.0   558.0 493 18 20 2   7         18   290 268     1       36   558
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
1293003 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2017   grade_2                         43.0 29.0                       72.0                         43 29                 72
1293004 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2017   grade_3                         24.0 28.0                       52.0                         24 28                 52
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
1293006 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2017   grade_5                         37.0 34.0                       71.0                         37 34                 71
1293007 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         39.0 33.0                       72.0                         39 33                 72
1293008 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 342.0 10.0 17.0 1.0   5.0         16.0   202.0 189.0     1.0             37.0   391.0 342 10 17 1   5         16   202 189     1       37   391
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
1293010 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2017   grade_2                         35.0 40.0                       75.0                         35 40                 75
1293011 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2017   grade_3                         27.0 31.0                       58.0                         27 31                 58
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
1293013 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2017   grade_5                         42.0 28.0                       70.0                         42 28                 70
1293014 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2017   kindergarten                         39.0 27.0                       66.0                         39 27                 66
1293015 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2017   pk_12_total 338.0 14.0 17.0     29.0     1.0   15.0   216.0 198.0     3.0             31.0   414.0 338 14 17     29     1   15   216 198     3       31   414
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
1293017 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2017   grade_2                         73.0 63.0                       136.0                         73 63                 136
1293018 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2017   grade_3                         53.0 72.0                       125.0                         53 72                 125
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
1293020 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2017   grade_5                         58.0 80.0                       138.0                         58 80                 138
1293021 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         58.0 63.0                       121.0                         58 63                 121
1293022 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 601.0 80.0 36.0 1.0   26.0     1.0   42.0   373.0 414.0     2.0             55.0   787.0 601 80 36 1   26     1   42   373 414     2       55   787
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
1293024 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2017   grade_2                         20.0 13.0                       33.0                         20 13                 33
1293025 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2017   grade_3                         11.0 16.0                       27.0                         11 16                 27
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
1293027 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2017   grade_5                         15.0 11.0                       26.0                         15 11                 26
1293028 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2017   kindergarten                         14.0 10.0                       24.0                         14 10                 24
1293029 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2017   pk_12_total 152.0   13.0 2.0             11.0   92.0 86.0     1.0             30.0   178.0 152   13 2             11   92 86     1       30   178
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
1293035 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2017   grade_2                         33.0 40.0                       73.0                         33 40                 73
1293036 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2017   grade_3                         30.0 38.0                       68.0                         30 38                 68
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
1293038 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2017   grade_5                         40.0 42.0                       82.0                         40 42                 82
1293039 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         36.0 37.0                       73.0                         36 37                 73
1293040 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 371.0 6.0 17.0 2.0   14.0         36.0   219.0 227.0     11.0             81.0   446.0 371 6 17 2   14         36   219 227     11       81   446
1293041 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         10.0 1.0                       11.0                         10 1                 11

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