Data source: Big Local News · About: Big Local

12,019 rows where state = "IN" and year = 2018 sorted by ccd_school_lvl

View and edit SQL

grade

year

  • 2018 · 12,019
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
1787852 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2018   pk_12_total 36.0 4.0 6.0     2.0             32.0 16.0     0.0         24.0   43.0   48.0 36 4 6     2             32 16     0     24 43   48
1787853 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2018   pre_kindergarten                         32.0 16.0                       48.0                         32 16                 48
1790091 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2018   grade_10                         1.0 0.0                       1.0                         1 0                 1
1790092 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2018   pk_12_total 1.0                       1.0 0.0     0.0             0.0   1.0 1                       1 0     0       0   1
1793997 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_1                         2.0 2.0                       4.0                         2 2                 4
1793998 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_10                         12.0 1.0                       13.0                         12 1                 13
1793999 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_11                         8.0 0.0                       8.0                         8 0                 8
1794000 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_12                         5.0 0.0                       5.0                         5 0                 5
1794001 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_2                         7.0 0.0                       7.0                         7 0                 7
1794002 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_3                         3.0 0.0                       3.0                         3 0                 3
1794003 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_4                         11.0 2.0                       13.0                         11 2                 13
1794004 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_5                         5.0 2.0                       7.0                         5 2                 7
1794005 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_6                         5.0 1.0                       6.0                         5 1                 6
1794006 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_7                         4.0 1.0                       5.0                         4 1                 5
1794007 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_8                         7.0 1.0                       8.0                         7 1                 8
1794008 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_9                         10.0 1.0                       11.0                         10 1                 11
1794009 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1794010 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   pk_12_total 46.0 30.0 7.0               8.0   80.0 11.0     6.0         58.0   88.0   91.0 46 30 7               8   80 11     6     58 88   91
1796657 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2018   pk_12_total 90.0 38.0 33.0               17.0   120.0 58.0     0.0         87.0   119.0   178.0 90 38 33               17   120 58     0     87 119   178
1796658 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2018   pre_kindergarten                         120.0 58.0                       178.0                         120 58                 178
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
1787292 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_2                         52.0 42.0                       94.0                         52 42                 94
1787293 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_3                         56.0 50.0                       106.0                         56 50                 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
1787295 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_5                         51.0 57.0                       108.0                         51 57                 108
1787296 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         59.0 63.0                       122.0                         59 63                 122
1787297 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 586.0 6.0 25.0 1.0   5.0         13.0   341.0 295.0     22.0         172.0   106.0   636.0 586 6 25 1   5         13   341 295     22     172 106   636
1787298 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         1.0 3.0                       4.0                         1 3                 4
1787315 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary 02 04 2018   grade_2                         71.0 52.0                       123.0                         71 52                 123
1787316 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary 02 04 2018   grade_3                         62.0 66.0                       128.0                         62 66                 128
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
1787318 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary 02 04 2018   pk_12_total 301.0 13.0 39.0     3.0     2.0   18.0   191.0 185.0     0.0         251.0   81.0   376.0 301 13 39     3     2   18   191 185     0     251 81   376
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
1787320 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   kindergarten                         65.0 46.0                       111.0                         65 46                 111
1787321 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   pk_12_total 222.0 13.0 35.0     1.0         17.0   148.0 140.0     1.0         191.0   50.0   288.0 222 13 35     1         17   148 140     1     191 50   288
1787322 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   pre_kindergarten                         32.0 38.0                       70.0                         32 38                 70
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
1787333 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   grade_2                         49.0 54.0                       103.0                         49 54                 103
1787334 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   grade_3                         41.0 42.0                       83.0                         41 42                 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
1787336 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   grade_5                         53.0 48.0                       101.0                         53 48                 101
1787337 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         42.0 44.0                       86.0                         42 44                 86
1787338 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 526.0 4.0 76.0     5.0         11.0   326.0 296.0     65.0         268.0   140.0   622.0 526 4 76     5         11   326 296     65     268 140   622
1787339 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         42.0 18.0                       60.0                         42 18                 60
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
1787341 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   grade_2                         48.0 34.0                       82.0                         48 34                 82
1787342 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   grade_3                         54.0 51.0                       105.0                         54 51                 105
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
1787344 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   grade_5                         68.0 52.0                       120.0                         68 52                 120
1787345 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         22.0 26.0                       48.0                         22 26                 48
1787346 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 411.0 11.0 26.0 1.0   38.0         23.0   268.0 242.0     0.0         64.0   22.0   510.0 411 11 26 1   38         23   268 242     0     64 22   510
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
1787348 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_2                         44.0 39.0                       83.0                         44 39                 83
1787349 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_3                         39.0 35.0                       74.0                         39 35                 74
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
1787351 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_5                         40.0 35.0                       75.0                         40 35                 75
1787352 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2018   kindergarten                         51.0 40.0                       91.0                         51 40                 91
1787353 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2018   pk_12_total 362.0 56.0 32.0 3.0   37.0     2.0   24.0   286.0 230.0     28.0         108.0   63.0   516.0 362 56 32 3   37     2   24   286 230     28     108 63   516
1787354 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2018   pre_kindergarten                         20.0 10.0                       30.0                         20 10                 30
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
1787365 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   grade_2                         59.0 46.0                       105.0                         59 46                 105
1787366 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   grade_3                         41.0 44.0                       85.0                         41 44                 85
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
1787368 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   grade_5                         57.0 40.0                       97.0                         57 40                 97
1787369 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   kindergarten                         57.0 47.0                       104.0                         57 47                 104
1787370 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   pk_12_total 498.0 20.0 24.0 1.0   7.0         19.0   308.0 261.0     1.0         76.0   39.0   569.0 498 20 24 1   7         19   308 261     1     76 39   569
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
1787376 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2018   grade_2                         36.0 38.0                       74.0                         36 38                 74
1787377 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2018   grade_3                         40.0 27.0                       67.0                         40 27                 67
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
1787379 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2018   grade_5                         36.0 30.0                       66.0                         36 30                 66
1787380 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         35.0 36.0                       71.0                         35 36                 71
1787381 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 340.0 15.0 19.0 1.0   15.0         20.0   214.0 196.0     5.0         71.0   50.0   410.0 340 15 19 1   15         20   214 196     5     71 50   410
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
1787383 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2018   grade_2                         34.0 34.0                       68.0                         34 34                 68
1787384 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2018   grade_3                         34.0 42.0                       76.0                         34 42                 76
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
1787386 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2018   grade_5                         41.0 46.0                       87.0                         41 46                 87
1787387 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2018   kindergarten                         37.0 31.0                       68.0                         37 31                 68
1787388 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2018   pk_12_total 353.0 12.0 14.0     34.0         23.0   218.0 218.0     2.0         33.0   34.0   436.0 353 12 14     34         23   218 218     2     33 34   436
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
1787390 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   grade_2                         68.0 59.0                       127.0                         68 59                 127
1787391 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   grade_3                         76.0 64.0                       140.0                         76 64                 140
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
1787393 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   grade_5                         60.0 77.0                       137.0                         60 77                 137
1787394 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         95.0 58.0                       153.0                         95 58                 153
1787395 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 624.0 88.0 46.0     19.0     1.0   48.0   425.0 401.0     9.0         170.0   63.0   826.0 624 88 46     19     1   48   425 401     9     170 63   826
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
1787397 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2018   grade_2                         17.0 18.0                       35.0                         17 18                 35
1787398 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2018   grade_3                         18.0 13.0                       31.0                         18 13                 31
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
1787400 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2018   grade_5                         15.0 17.0                       32.0                         15 17                 32
1787401 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2018   kindergarten                         14.0 13.0                       27.0                         14 13                 27
1787402 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2018   pk_12_total 155.0 2.0 13.0 2.0             9.0   91.0 90.0     3.0         57.0   30.0   181.0 155 2 13 2             9   91 90     3     57 30   181
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
1787408 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2018   grade_2                         39.0 36.0                       75.0                         39 36                 75
1787409 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2018   grade_3                         31.0 38.0                       69.0                         31 38                 69
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
1787411 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2018   grade_5                         35.0 37.0                       72.0                         35 37                 72
1787412 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         26.0 36.0                       62.0                         26 36                 62

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