enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2021 · 12,002 ✖
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
1930180 1930180 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2021   adult                         2.0 0.0                       2.0                         2 0                 2
1930181 1930181 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2021   grade_10                         21.0 0.0                       21.0                         21 0                 21
1930182 1930182 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2021   grade_11                         32.0 0.0                       32.0                         32 0                 32
1930183 1930183 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2021   grade_12                         37.0 0.0                       37.0                         37 0                 37
1930184 1930184 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2021   grade_8                         2.0 0.0                       2.0                         2 0                 2
1930185 1930185 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2021   grade_9                         5.0 0.0                       5.0                         5 0                 5
1930186 1930186 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2021   pk_12_total 55.0 29.0 12.0               3.0   99.0 0.0     4.0         99.0   37.0   99.0 55 29 12               3   99 0     4     99 37   99
1930187 1930187 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2021   adult                         43.0 0.0                       43.0                         43 0                 43
1930188 1930188 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2021   grade_10                         34.0 0.0                       34.0                         34 0                 34
1930189 1930189 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2021   grade_11                         33.0 0.0                       33.0                         33 0                 33
1930190 1930190 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2021   grade_12                         16.0 0.0                       16.0                         16 0                 16
1930191 1930191 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2021   grade_8                         5.0 0.0                       5.0                         5 0                 5
1930192 1930192 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2021   grade_9                         27.0 0.0                       27.0                         27 0                 27
1930193 1930193 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2021   pk_12_total 72.0 62.0 9.0 1.0             14.0   158.0 0.0     4.0         158.0   65.0   158.0 72 62 9 1             14   158 0     4     158 65   158
1930194 1930194 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 LaPorte Juvenile Correctional   Regular School No High 08 12 2021   grade_10                         0.0 6.0                       6.0                         0 6                 6
1930195 1930195 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 LaPorte Juvenile Correctional   Regular School No High 08 12 2021   grade_11                         0.0 5.0                       5.0                         0 5                 5
1930196 1930196 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 LaPorte Juvenile Correctional   Regular School No High 08 12 2021   grade_12                         0.0 3.0                       3.0                         0 3                 3
1930197 1930197 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 LaPorte Juvenile Correctional   Regular School No High 08 12 2021   grade_8                         0.0 4.0                       4.0                         0 4                 4
1930198 1930198 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 LaPorte Juvenile Correctional   Regular School No High 08 12 2021   grade_9                         0.0 8.0                       8.0                         0 8                 8
1930199 1930199 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 LaPorte Juvenile Correctional   Regular School No High 08 12 2021   pk_12_total 16.0 7.0 1.0               2.0   0.0 26.0     0.0         26.0   9.0   26.0 16 7 1               2   0 26     0     26 9   26
1930200 1930200 IN     school 1800006 9100   Indiana Department of Correction 180000602453 5616 Dept of Correction Adult Schools   Special Education School No High 07 12 2021   adult                         70.0 3.0                       73.0                         70 3                 73
1930201 1930201 IN     school 1800006 9100   Indiana Department of Correction 180000602453 5616 Dept of Correction Adult Schools   Special Education School No High 07 12 2021   pk_12_total 26.0 33.0 4.0 2.0             8.0   70.0 3.0     1.0         73.0   42.0   73.0 26 33 4 2             8   70 3     1     73 42   73
1921807 1921807 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2021   grade_10                         27.0 23.0                       50.0                         27 23                 50
1921808 1921808 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2021   grade_11                         35.0 35.0                       70.0                         35 35                 70
1921809 1921809 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2021   grade_12                         22.0 34.0                       56.0                         22 34                 56
1921810 1921810 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2021   grade_9                         34.0 29.0                       63.0                         34 29                 63
1921811 1921811 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2021   pk_12_total 206.0 5.0 16.0     2.0     2.0   8.0   118.0 121.0     4.0         113.0   33.0   239.0 206 5 16     2     2   8   118 121     4     113 33   239
1921812 1921812 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2021   grade_5                         27.0 26.0                       53.0                         27 26                 53
1921813 1921813 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2021   grade_6                         33.0 28.0                       61.0                         33 28                 61
1921814 1921814 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2021   grade_7                         37.0 29.0                       66.0                         37 29                 66
1921815 1921815 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2021   grade_8                         23.0 37.0                       60.0                         23 37                 60
1921816 1921816 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2021   pk_12_total 225.0 2.0 11.0     1.0         1.0   120.0 120.0     2.0         144.0   34.0   240.0 225 2 11     1         1   120 120     2     144 34   240
1921817 1921817 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   grade_1                         30.0 23.0                       53.0                         30 23                 53
1921818 1921818 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   grade_2                         32.0 19.0                       51.0                         32 19                 51
1921819 1921819 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   grade_3                         22.0 24.0                       46.0                         22 24                 46
1921820 1921820 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   grade_4                         28.0 28.0                       56.0                         28 28                 56
1921821 1921821 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   kindergarten                         42.0 28.0                       70.0                         42 28                 70
1921822 1921822 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   pk_12_total 285.0   22.0               4.0   173.0 138.0     3.0         186.0   75.0   311.0 285   22               4   173 138     3     186 75   311
1921823 1921823 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2021   pre_kindergarten                         19.0 16.0                       35.0                         19 16                 35
1930281 1930281 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_1                         17.0 22.0                       39.0                         17 22                 39
1930282 1930282 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_10                         19.0 17.0                       36.0                         19 17                 36
1930283 1930283 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_11                         23.0 21.0                       44.0                         23 21                 44
1930284 1930284 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_12                         15.0 15.0                       30.0                         15 15                 30
1930285 1930285 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_2                         24.0 18.0                       42.0                         24 18                 42
1930286 1930286 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_3                         16.0 28.0                       44.0                         16 28                 44
1930287 1930287 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_4                         22.0 23.0                       45.0                         22 23                 45
1930288 1930288 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_5                         24.0 20.0                       44.0                         24 20                 44
1930289 1930289 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_6                         27.0 15.0                       42.0                         27 15                 42
1930290 1930290 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_7                         20.0 22.0                       42.0                         20 22                 42
1930291 1930291 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_8                         20.0 23.0                       43.0                         20 23                 43
1930292 1930292 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_9                         17.0 15.0                       32.0                         17 15                 32
1930293 1930293 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   kindergarten                         27.0 21.0                       48.0                         27 21                 48
1930294 1930294 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   pk_12_total 462.0 12.0 11.0 1.0   4.0     5.0   39.0   274.0 260.0     0.0         126.0   122.0   534.0 462 12 11 1   4     5   39   274 260     0     126 122   534
1930295 1930295 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   pre_kindergarten                         3.0 0.0                       3.0                         3 0                 3
1930342 1930342 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2021   grade_1                         27.0 39.0                       66.0                         27 39                 66
1930343 1930343 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2021   grade_2                         30.0 27.0                       57.0                         30 27                 57
1930344 1930344 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2021   grade_3                         37.0 32.0                       69.0                         37 32                 69
1930345 1930345 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2021   grade_4                         33.0 32.0                       65.0                         33 32                 65
1930346 1930346 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2021   grade_5                         34.0 29.0                       63.0                         34 29                 63
1930347 1930347 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2021   kindergarten                         27.0 28.0                       55.0                         27 28                 55
1930348 1930348 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 05 2021   pk_12_total 2.0 143.0 29.0     190.0         11.0   188.0 187.0     203.0         313.0   24.0   375.0 2 143 29     190         11   188 187     203     313 24   375
1930320 1930320 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   grade_1                         36.0 36.0                       72.0                         36 36                 72
1930321 1930321 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   grade_10                         61.0 50.0                       111.0                         61 50                 111
1930322 1930322 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   grade_11                         44.0 39.0                       83.0                         44 39                 83
1930323 1930323 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   grade_12                         52.0 40.0                       92.0                         52 40                 92
1930324 1930324 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   grade_2                         39.0 28.0                       67.0                         39 28                 67
1930325 1930325 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   grade_3                         34.0 29.0                       63.0                         34 29                 63
1930326 1930326 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   grade_4                         28.0 41.0                       69.0                         28 41                 69
1930327 1930327 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   grade_5                         34.0 32.0                       66.0                         34 32                 66
1930328 1930328 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   grade_6                         38.0 34.0                       72.0                         38 34                 72
1930329 1930329 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   grade_7                         40.0 47.0                       87.0                         40 47                 87
1930330 1930330 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   grade_8                         28.0 57.0                       85.0                         28 57                 85
1930331 1930331 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   grade_9                         39.0 58.0                       97.0                         39 58                 97
1930332 1930332 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   kindergarten                         31.0 42.0                       73.0                         31 42                 73
1930333 1930333 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   pk_12_total 669.0 157.0 121.0     3.0     1.0   86.0   504.0 533.0     32.0         678.0   163.0   1037.0 669 157 121     3     1   86   504 533     32     678 163   1037
1930296 1930296 IN     school 1800016 9325   Options Charter Schools 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 06 12 2021   grade_10                         12.0 7.0                       19.0                         12 7                 19
1930297 1930297 IN     school 1800016 9325   Options Charter Schools 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 06 12 2021   grade_11                         22.0 12.0                       34.0                         22 12                 34
1930298 1930298 IN     school 1800016 9325   Options Charter Schools 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 06 12 2021   grade_12                         39.0 29.0                       68.0                         39 29                 68
1930299 1930299 IN     school 1800016 9325   Options Charter Schools 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 06 12 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1930300 1930300 IN     school 1800016 9325   Options Charter Schools 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 06 12 2021   grade_7                         2.0 2.0                       4.0                         2 2                 4
1930301 1930301 IN     school 1800016 9325   Options Charter Schools 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 06 12 2021   grade_8                         4.0 2.0                       6.0                         4 2                 6
1930302 1930302 IN     school 1800016 9325   Options Charter Schools 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 06 12 2021   grade_9                         4.0 7.0                       11.0                         4 7                 11
1930303 1930303 IN     school 1800016 9325   Options Charter Schools 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 06 12 2021   pk_12_total 102.0 20.0 7.0     1.0         13.0   84.0 59.0     3.0         25.0   52.0   143.0 102 20 7     1         13   84 59     3     25 52   143
1930304 1930304 IN     school 1800016 9325   Options Charter Schools 180001602313 2551 Options Charter School Noblesville   Regular School Yes High 06 12 2021   grade_10                         26.0 15.0                       41.0                         26 15                 41
1930305 1930305 IN     school 1800016 9325   Options Charter Schools 180001602313 2551 Options Charter School Noblesville   Regular School Yes High 06 12 2021   grade_11                         19.0 13.0                       32.0                         19 13                 32
1930306 1930306 IN     school 1800016 9325   Options Charter Schools 180001602313 2551 Options Charter School Noblesville   Regular School Yes High 06 12 2021   grade_12                         42.0 20.0                       62.0                         42 20                 62
1930307 1930307 IN     school 1800016 9325   Options Charter Schools 180001602313 2551 Options Charter School Noblesville   Regular School Yes High 06 12 2021   grade_6                         4.0 5.0                       9.0                         4 5                 9
1930308 1930308 IN     school 1800016 9325   Options Charter Schools 180001602313 2551 Options Charter School Noblesville   Regular School Yes High 06 12 2021   grade_7                         11.0 5.0                       16.0                         11 5                 16
1930309 1930309 IN     school 1800016 9325   Options Charter Schools 180001602313 2551 Options Charter School Noblesville   Regular School Yes High 06 12 2021   grade_8                         9.0 7.0                       16.0                         9 7                 16
1930310 1930310 IN     school 1800016 9325   Options Charter Schools 180001602313 2551 Options Charter School Noblesville   Regular School Yes High 06 12 2021   grade_9                         8.0 17.0                       25.0                         8 17                 25
1930311 1930311 IN     school 1800016 9325   Options Charter Schools 180001602313 2551 Options Charter School Noblesville   Regular School Yes High 06 12 2021   pk_12_total 138.0 29.0 14.0     4.0         16.0   119.0 82.0     4.0         38.0   89.0   201.0 138 29 14     4         16   119 82     4     38 89   201
1930312 1930312 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_10                         14.0 13.0                       27.0                         14 13                 27
1930313 1930313 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_11                         25.0 33.0                       58.0                         25 33                 58
1930314 1930314 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_12                         79.0 105.0                       184.0                         79 105                 184
1930315 1930315 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_6                         4.0 1.0                       5.0                         4 1                 5
1930316 1930316 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_7                         3.0 1.0                       4.0                         3 1                 4
1930317 1930317 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_8                         5.0 5.0                       10.0                         5 5                 10
1930318 1930318 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_9                         5.0 7.0                       12.0                         5 7                 12
1930319 1930319 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   pk_12_total 223.0 26.0 28.0 1.0   4.0         18.0   135.0 165.0     7.0         52.0   76.0   300.0 223 26 28 1   4         18   135 165     7     52 76   300
1930363 1930363 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   grade_1                         24.0 31.0                       55.0                         24 31                 55

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