Data source: Big Local News · About: Big Local

12,002 rows where state = "IN" and year = 2021

View and edit SQL

grade

year

  • 2021 · 11,902
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
1919053 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2021   kindergarten                         40.0 33.0                       73.0                         40 33                 73
1919054 IN     school 1800030 125   MSD Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2021   pk_12_total 308.0 14.0 22.0 4.0   30.0         21.0   217.0 182.0     5.0         30.0   31.0   399.0 308 14 22 4   30         21   217 182     5     30 31   399
1919055 IN     school 1800030 125   MSD Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2021   grade_1                         80.0 72.0                       152.0                         80 72                 152
1919056 IN     school 1800030 125   MSD Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2021   grade_2                         79.0 55.0                       134.0                         79 55                 134
1919057 IN     school 1800030 125   MSD Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2021   grade_3                         87.0 55.0                       142.0                         87 55                 142
1919058 IN     school 1800030 125   MSD Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2021   grade_4                         56.0 68.0                       124.0                         56 68                 124
1919059 IN     school 1800030 125   MSD Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2021   grade_5                         56.0 62.0                       118.0                         56 62                 118
1919060 IN     school 1800030 125   MSD Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         81.0 61.0                       142.0                         81 61                 142
1919061 IN     school 1800030 125   MSD Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 562.0 108.0 51.0     35.0     1.0   55.0   439.0 373.0     4.0         185.0   77.0   812.0 562 108 51     35     1   55   439 373     4     185 77   812
1919062 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2021   grade_1                         20.0 10.0                       30.0                         20 10                 30
1919063 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2021   grade_2                         17.0 19.0                       36.0                         17 19                 36
1919064 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2021   grade_3                         14.0 15.0                       29.0                         14 15                 29
1919065 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2021   grade_4                         18.0 13.0                       31.0                         18 13                 31
1919066 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2021   grade_5                         17.0 15.0                       32.0                         17 15                 32
1919067 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2021   kindergarten                         19.0 22.0                       41.0                         19 22                 41
1919068 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2021   pk_12_total 167.0 1.0 16.0 2.0             13.0   105.0 94.0     4.0         66.0   31.0   199.0 167 1 16 2             13   105 94     4     66 31   199
1919069 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2021   grade_6                         145.0 149.0                       294.0                         145 149                 294
1919070 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2021   grade_7                         143.0 153.0                       296.0                         143 153                 296
1919071 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2021   grade_8                         173.0 154.0                       327.0                         173 154                 327
1919072 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2021   pk_12_total 769.0 28.0 40.0     38.0         42.0   461.0 456.0     10.0         133.0   110.0   917.0 769 28 40     38         42   461 456     10     133 110   917
1919073 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   grade_1                         31.0 26.0                       57.0                         31 26                 57
1919074 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   grade_2                         27.0 24.0                       51.0                         27 24                 51
1919075 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   grade_3                         29.0 27.0                       56.0                         29 27                 56
1919076 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   grade_4                         37.0 31.0                       68.0                         37 31                 68
1919077 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   grade_5                         42.0 43.0                       85.0                         42 43                 85
1919078 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         25.0 23.0                       48.0                         25 23                 48
1919079 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 289.0 14.0 15.0 4.0   25.0         25.0   196.0 176.0     17.0         92.0   68.0   372.0 289 14 15 4   25         25   196 176     17     92 68   372
1919080 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         5.0 2.0                       7.0                         5 2                 7
1919081 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   grade_1                         51.0 41.0                       92.0                         51 41                 92
1919082 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   grade_2                         60.0 42.0                       102.0                         60 42                 102
1919083 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   grade_3                         65.0 52.0                       117.0                         65 52                 117
1919084 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   grade_4                         55.0 70.0                       125.0                         55 70                 125
1919085 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   grade_5                         51.0 49.0                       100.0                         51 49                 100
1919086 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         47.0 57.0                       104.0                         47 57                 104
1919087 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 498.0 12.0 37.0 3.0   52.0     2.0   36.0   329.0 311.0     45.0         242.0   117.0   640.0 498 12 37 3   52     2   36   329 311     45     242 117   640
1919088 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2021   grade_6                         167.0 147.0                       314.0                         167 147                 314
1919089 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2021   grade_7                         160.0 174.0                       334.0                         160 174                 334
1919090 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2021   grade_8                         165.0 160.0                       325.0                         165 160                 325
1919091 IN     school 1808250 225   Northwest Allen County Schools 180825002294 90 Carroll Middle School   Regular School No Middle 06 08 2021   pk_12_total 781.0 29.0 48.0 2.0   47.0         66.0   492.0 481.0     21.0         267.0   138.0   973.0 781 29 48 2   47         66   492 481     21     267 138   973
1919092 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2021   grade_10                         301.0 326.0                       627.0                         301 326                 627
1919093 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2021   grade_11                         314.0 280.0                       594.0                         314 280                 594
1919094 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2021   grade_12                         326.0 287.0                       613.0                         326 287                 613
1919095 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2021   grade_9                         331.0 310.0                       641.0                         331 310                 641
1919096 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2021   pk_12_total 2094.0 56.0 119.0 3.0   96.0     2.0   105.0   1272.0 1203.0     23.0         447.0   297.0   2475.0 2094 56 119 3   96     2   105   1272 1203     23     447 297   2475
1919097 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   grade_1                         58.0 46.0                       104.0                         58 46                 104
1919098 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   grade_2                         44.0 60.0                       104.0                         44 60                 104
1919099 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   grade_3                         50.0 58.0                       108.0                         50 58                 108
1919100 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   grade_4                         53.0 44.0                       97.0                         53 44                 97
1919101 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   grade_5                         50.0 52.0                       102.0                         50 52                 102
1919102 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         55.0 41.0                       96.0                         55 41                 96
1919103 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 501.0 19.0 30.0 1.0   21.0         39.0   310.0 301.0     16.0         107.0   68.0   611.0 501 19 30 1   21         39   310 301     16     107 68   611
1919104 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   grade_1                         48.0 33.0                       81.0                         48 33                 81
1919105 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   grade_2                         31.0 41.0                       72.0                         31 41                 72
1919106 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   grade_3                         54.0 41.0                       95.0                         54 41                 95
1919107 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   grade_4                         52.0 49.0                       101.0                         52 49                 101
1919108 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   grade_5                         40.0 42.0                       82.0                         40 42                 82
1919109 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         40.0 30.0                       70.0                         40 30                 70
1919110 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 413.0 12.0 21.0     31.0     1.0   23.0   265.0 236.0     13.0         45.0   74.0   501.0 413 12 21     31     1   23   265 236     13     45 74   501
1919111 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   grade_1                         60.0 58.0                       118.0                         60 58                 118
1919112 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   grade_2                         57.0 37.0                       94.0                         57 37                 94
1919113 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   grade_3                         51.0 57.0                       108.0                         51 57                 108
1919114 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   grade_4                         43.0 51.0                       94.0                         43 51                 94
1919115 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   grade_5                         48.0 45.0                       93.0                         48 45                 93
1919116 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         48.0 38.0                       86.0                         48 38                 86
1919117 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 507.0 17.0 27.0 1.0   44.0         21.0   320.0 297.0     6.0         58.0   109.0   617.0 507 17 27 1   44         21   320 297     6     58 109   617
1919118 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         13.0 11.0                       24.0                         13 11                 24
1919119 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   grade_1                         50.0 40.0                       90.0                         50 40                 90
1919120 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   grade_2                         50.0 59.0                       109.0                         50 59                 109
1919121 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   grade_3                         57.0 40.0                       97.0                         57 40                 97
1919122 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   grade_4                         52.0 46.0                       98.0                         52 46                 98
1919123 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   grade_5                         42.0 38.0                       80.0                         42 38                 80
1919124 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         49.0 43.0                       92.0                         49 43                 92
1919125 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 445.0 17.0 29.0     31.0         44.0   300.0 266.0     27.0         119.0   81.0   566.0 445 17 29     31         44   300 266     27     119 81   566
1919126 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1919127 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_11                         3.0 0.0                       3.0                         3 0                 3
1919128 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1919129 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_8                         1.0 0.0                       1.0                         1 0                 1
1919130 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   pk_12_total 2.0 2.0 2.0                   6.0 0.0     0.0             1.0   6.0 2 2 2                   6 0     0       1   6
1919131 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2021   grade_10                         216.0 202.0                       418.0                         216 202                 418
1919132 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2021   grade_11                         167.0 182.0                       349.0                         167 182                 349
1919133 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2021   grade_12                         189.0 174.0                       363.0                         189 174                 363
1919134 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2021   grade_9                         216.0 201.0                       417.0                         216 201                 417
1919135 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2021   pk_12_total 631.0 362.0 272.0 1.0   97.0     4.0   180.0   788.0 759.0     106.0         1064.0   312.0   1547.0 631 362 272 1   97     4   180   788 759     106     1064 312   1547
1919136 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2021   grade_10                         213.0 250.0                       463.0                         213 250                 463
1919137 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2021   grade_11                         224.0 221.0                       445.0                         224 221                 445
1919138 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2021   grade_12                         216.0 217.0                       433.0                         216 217                 433
1919139 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2021   grade_9                         235.0 254.0                       489.0                         235 254                 489
1919140 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2021   pk_12_total 910.0 411.0 258.0 6.0   85.0     1.0   159.0   888.0 942.0     80.0         876.0   244.0   1830.0 910 411 258 6   85     1   159   888 942     80     876 244   1830
1919141 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2021   grade_10                         204.0 201.0                       405.0                         204 201                 405
1919142 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2021   grade_11                         155.0 170.0                       325.0                         155 170                 325
1919143 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2021   grade_12                         157.0 149.0                       306.0                         157 149                 306
1919144 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2021   grade_9                         181.0 198.0                       379.0                         181 198                 379
1919145 IN     school 1803630 235   Fort Wayne Community Schools 180363000562 105 South Side High School   Regular School No High 09 12 2021   pk_12_total 268.0 424.0 486.0 1.0   98.0     2.0   136.0   697.0 718.0     198.0         1036.0   249.0   1415.0 268 424 486 1   98     2   136   697 718     198     1036 249   1415
1919146 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2021   grade_6                         129.0 136.0                       265.0                         129 136                 265
1919147 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2021   grade_7                         145.0 144.0                       289.0                         145 144                 289
1919148 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2021   grade_8                         138.0 134.0                       272.0                         138 134                 272
1919149 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2021   pk_12_total 422.0 183.0 101.0 2.0   47.0         71.0   412.0 414.0     41.0         415.0   112.0   826.0 422 183 101 2   47         71   412 414     41     415 112   826
1919150 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_1                         31.0 35.0                       66.0                         31 35                 66
1919151 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_2                         31.0 35.0                       66.0                         31 35                 66
1919152 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_3                         39.0 34.0                       73.0                         39 34                 73

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