Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2017 · 11,958
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
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
1292998 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2017   grade_6                         172.0 152.0                       324.0                         172 152                 324
1292999 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2017   grade_7                         183.0 186.0                       369.0                         183 186                 369
1293000 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2017   grade_8                         171.0 169.0                       340.0                         171 169                 340
1293001 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2017   pk_12_total 813.0 55.0 51.0 3.0   60.0     3.0   48.0   526.0 507.0     5.0             73.0   1033.0 813 55 51 3   60     3   48   526 507     5       73   1033
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
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
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
1293030 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2017   grade_6                         150.0 135.0                       285.0                         150 135                 285
1293031 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2017   grade_7                         129.0 124.0                       253.0                         129 124                 253
1293032 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2017   grade_8                         142.0 143.0                       285.0                         142 143                 285
1293033 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2017   pk_12_total 696.0 15.0 40.0 1.0   46.0     1.0   24.0   421.0 402.0     7.0             77.0   823.0 696 15 40 1   46     1   24   421 402     7       77   823
1293428 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2017   adult                         7.0 1.0                       8.0                         7 1                 8
1293429 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2017   grade_10                         84.0 83.0                       167.0                         84 83                 167
1293430 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2017   grade_11                         81.0 69.0                       150.0                         81 69                 150
1293431 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2017   grade_12                         67.0 69.0                       136.0                         67 69                 136
1293432 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2017   grade_7                         45.0 35.0                       80.0                         45 35                 80
1293433 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2017   grade_8                         35.0 45.0                       80.0                         35 45                 80
1293434 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2017   grade_9                         72.0 71.0                       143.0                         72 71                 143
1293435 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No High 07 12 2017   pk_12_total 512.0 85.0 48.0 7.0   66.0         46.0   391.0 373.0     45.0             115.0   764.0 512 85 48 7   66         46   391 373     45       115   764
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
1293437 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2017   grade_2                         72.0 72.0                       144.0                         72 72                 144
1293438 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2017   kindergarten                         78.0 68.0                       146.0                         78 68                 146
1293439 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2017   pk_12_total 354.0 53.0 35.0 1.0   2.0         44.0   249.0 240.0     9.0             64.0   489.0 354 53 35 1   2         44   249 240     9       64   489
1293440 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         26.0 30.0                       56.0                         26 30                 56
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
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
1293043 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2017   grade_2                         56.0 52.0                       108.0                         56 52                 108
1293044 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2017   grade_3                         52.0 51.0                       103.0                         52 51                 103
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
1293046 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2017   grade_5                         50.0 44.0                       94.0                         50 44                 94
1293047 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         57.0 59.0                       116.0                         57 59                 116
1293048 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 548.0 7.0 31.0 1.0   5.0     1.0   30.0   334.0 289.0     2.0             90.0   623.0 548 7 31 1   5     1   30   334 289     2       90   623
1293049 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2017   grade_6                         135.0 143.0                       278.0                         135 143                 278
1293050 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2017   grade_7                         173.0 127.0                       300.0                         173 127                 300
1293051 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2017   grade_8                         185.0 170.0                       355.0                         185 170                 355
1293052 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2017   pk_12_total 800.0 18.0 49.0 3.0   22.0         41.0   493.0 440.0     5.0             129.0   933.0 800 18 49 3   22         41   493 440     5       129   933
1293053 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2017   grade_10                         269.0 323.0                       592.0                         269 323                 592
1293054 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2017   grade_11                         299.0 281.0                       580.0                         299 281                 580
1293055 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2017   grade_12                         248.0 258.0                       506.0                         248 258                 506
1293056 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2017   grade_9                         285.0 317.0                       602.0                         285 317                 602
1293057 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2017   pk_12_total 1984.0 51.0 88.0 4.0   68.0     1.0   84.0   1101.0 1179.0     7.0             227.0   2280.0 1984 51 88 4   68     1   84   1101 1179     7       227   2280
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
1293059 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2017   grade_2                         42.0 43.0                       85.0                         42 43                 85
1293060 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2017   grade_3                         34.0 40.0                       74.0                         34 40                 74
1293061 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2017   grade_4                         45.0 40.0                       85.0                         45 40                 85
1293062 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2017   grade_5                         48.0 42.0                       90.0                         48 42                 90
1293063 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         51.0 30.0                       81.0                         51 30                 81
1293064 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 432.0 13.0 20.0     10.0         25.0   267.0 233.0     6.0             67.0   500.0 432 13 20     10         25   267 233     6       67   500
1293065 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2017   grade_1                         44.0 33.0                       77.0                         44 33                 77
1293066 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2017   grade_2                         41.0 36.0                       77.0                         41 36                 77
1293067 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2017   grade_3                         37.0 35.0                       72.0                         37 35                 72
1293068 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2017   grade_4                         44.0 37.0                       81.0                         44 37                 81
1293069 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2017   grade_5                         47.0 29.0                       76.0                         47 29                 76
1293070 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         42.0 45.0                       87.0                         42 45                 87
1293071 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 387.0 10.0 27.0     22.0         24.0   255.0 215.0     11.0             47.0   470.0 387 10 27     22         24   255 215     11       47   470
1293072 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   grade_1                         37.0 35.0                       72.0                         37 35                 72
1293073 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   grade_2                         41.0 41.0                       82.0                         41 41                 82
1293074 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   grade_3                         51.0 48.0                       99.0                         51 48                 99
1293075 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   grade_4                         53.0 52.0                       105.0                         53 52                 105
1293076 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   grade_5                         60.0 48.0                       108.0                         60 48                 108
1293077 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         31.0 49.0                       80.0                         31 49                 80
1293078 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 479.0 10.0 36.0     23.0         19.0   289.0 278.0     12.0             65.0   567.0 479 10 36     23         19   289 278     12       65   567
1293079 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         16.0 5.0                       21.0                         16 5                 21
1293080 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2017   grade_1                         37.0 35.0                       72.0                         37 35                 72
1293081 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2017   grade_2                         43.0 34.0                       77.0                         43 34                 77
1293082 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2017   grade_3                         49.0 53.0                       102.0                         49 53                 102

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