enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2018 · 12,019 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id ▼ school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1798514 1798514 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2018   adult                         8.0 0.0                       8.0                         8 0                 8
1798515 1798515 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2018   grade_10                         41.0 0.0                       41.0                         41 0                 41
1798516 1798516 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2018   grade_11                         17.0 0.0                       17.0                         17 0                 17
1798517 1798517 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2018   grade_12                         5.0 0.0                       5.0                         5 0                 5
1798518 1798518 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2018   grade_8                         5.0 0.0                       5.0                         5 0                 5
1798519 1798519 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2018   grade_9                         91.0 0.0                       91.0                         91 0                 91
1798520 1798520 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2018   pk_12_total 67.0 67.0 17.0     1.0         15.0   167.0 0.0     7.0         167.0   77.0   167.0 67 67 17     1         15   167 0     7     167 77   167
1798521 1798521 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 Madison Juvenile Correctional   Regular School No High 09 12 2018   grade_10                         0.0 9.0                       9.0                         0 9                 9
1798522 1798522 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 Madison Juvenile Correctional   Regular School No High 09 12 2018   grade_11                         0.0 5.0                       5.0                         0 5                 5
1798523 1798523 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 Madison Juvenile Correctional   Regular School No High 09 12 2018   grade_12                         0.0 4.0                       4.0                         0 4                 4
1798524 1798524 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 Madison Juvenile Correctional   Regular School No High 09 12 2018   grade_9                         0.0 13.0                       13.0                         0 13                 13
1798525 1798525 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 Madison Juvenile Correctional   Regular School No High 09 12 2018   pk_12_total 18.0 10.0 1.0               2.0   0.0 31.0     0.0         31.0   10.0   31.0 18 10 1               2   0 31     0     31 10   31
1798500 1798500 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2018   adult                         17.0 0.0                       17.0                         17 0                 17
1798501 1798501 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2018   grade_10                         36.0 0.0                       36.0                         36 0                 36
1798502 1798502 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2018   grade_11                         15.0 0.0                       15.0                         15 0                 15
1798503 1798503 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2018   grade_12                         6.0 0.0                       6.0                         6 0                 6
1798504 1798504 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2018   grade_7                         5.0 0.0                       5.0                         5 0                 5
1798505 1798505 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2018   grade_8                         7.0 0.0                       7.0                         7 0                 7
1798506 1798506 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2018   grade_9                         38.0 0.0                       38.0                         38 0                 38
1798507 1798507 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2018   pk_12_total 72.0 34.0 8.0               10.0   124.0 0.0     0.0         124.0   47.0   124.0 72 34 8               10   124 0     0     124 47   124
1798508 1798508 IN     school 1800006 9100   Indiana Department of Correction 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 09 12 2018   adult                         6.0 0.0                       6.0                         6 0                 6
1798509 1798509 IN     school 1800006 9100   Indiana Department of Correction 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 09 12 2018   grade_10                         16.0 0.0                       16.0                         16 0                 16
1798510 1798510 IN     school 1800006 9100   Indiana Department of Correction 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 09 12 2018   grade_11                         24.0 0.0                       24.0                         24 0                 24
1798511 1798511 IN     school 1800006 9100   Indiana Department of Correction 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 09 12 2018   grade_12                         9.0 0.0                       9.0                         9 0                 9
1798512 1798512 IN     school 1800006 9100   Indiana Department of Correction 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 09 12 2018   grade_9                         8.0 0.0                       8.0                         8 0                 8
1798513 1798513 IN     school 1800006 9100   Indiana Department of Correction 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 09 12 2018   pk_12_total 25.0 23.0 9.0               6.0   63.0 0.0     1.0         63.0   18.0   63.0 25 23 9               6   63 0     1     63 18   63
1790168 1790168 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   grade_1                         25.0 26.0                       51.0                         25 26                 51
1790169 1790169 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   grade_2                         23.0 29.0                       52.0                         23 29                 52
1790170 1790170 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   grade_3                         36.0 27.0                       63.0                         36 27                 63
1790171 1790171 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   grade_4                         30.0 27.0                       57.0                         30 27                 57
1790172 1790172 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   kindergarten                         20.0 21.0                       41.0                         20 21                 41
1790173 1790173 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   pk_12_total 283.0 2.0 13.0     1.0         4.0   161.0 142.0     2.0         176.0   69.0   303.0 283 2 13     1         4   161 142     2     176 69   303
1790174 1790174 IN     school 1800008 2980   White River Valley School District 180000802090 2460 White River Valley Elementary Sch   Regular School No Elementary PK 04 2018   pre_kindergarten                         27.0 12.0                       39.0                         27 12                 39
1790158 1790158 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2018   grade_10                         42.0 35.0                       77.0                         42 35                 77
1790159 1790159 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2018   grade_11                         32.0 40.0                       72.0                         32 40                 72
1790160 1790160 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2018   grade_12                         40.0 26.0                       66.0                         40 26                 66
1790161 1790161 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2018   grade_9                         27.0 32.0                       59.0                         27 32                 59
1790162 1790162 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2018   pk_12_total 259.0   10.0     1.0         4.0   141.0 133.0     2.0         123.0   32.0   274.0 259   10     1         4   141 133     2     123 32   274
1790163 1790163 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2018   grade_5                         15.0 32.0                       47.0                         15 32                 47
1790164 1790164 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2018   grade_6                         28.0 21.0                       49.0                         28 21                 49
1790165 1790165 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2018   grade_7                         30.0 24.0                       54.0                         30 24                 54
1790166 1790166 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2018   grade_8                         40.0 32.0                       72.0                         40 32                 72
1790167 1790167 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 08 2018   pk_12_total 195.0 5.0 13.0     2.0     1.0   6.0   113.0 109.0     0.0         126.0   35.0   222.0 195 5 13     2     1   6   113 109     0     126 35   222
1798568 1798568 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_1                         21.0 23.0                       44.0                         21 23                 44
1798569 1798569 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_10                         24.0 15.0                       39.0                         24 15                 39
1798570 1798570 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_11                         22.0 19.0                       41.0                         22 19                 41
1798571 1798571 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_12                         14.0 16.0                       30.0                         14 16                 30
1798572 1798572 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_2                         18.0 20.0                       38.0                         18 20                 38
1798573 1798573 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_3                         28.0 18.0                       46.0                         28 18                 46
1798574 1798574 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_4                         23.0 21.0                       44.0                         23 21                 44
1798575 1798575 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_5                         22.0 24.0                       46.0                         22 24                 46
1798576 1798576 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_6                         16.0 22.0                       38.0                         16 22                 38
1798577 1798577 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_7                         19.0 19.0                       38.0                         19 19                 38
1798578 1798578 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_8                         23.0 21.0                       44.0                         23 21                 44
1798579 1798579 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_9                         19.0 22.0                       41.0                         19 22                 41
1798580 1798580 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   kindergarten                         26.0 24.0                       50.0                         26 24                 50
1798581 1798581 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   pk_12_total 477.0 8.0 13.0     6.0     4.0   31.0   275.0 264.0     0.0         117.0   130.0   539.0 477 8 13     6     4   31   275 264     0     117 130   539
1798609 1798609 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2018   grade_1                         29.0 30.0                       59.0                         29 30                 59
1798610 1798610 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2018   grade_2                         29.0 19.0                       48.0                         29 19                 48
1798611 1798611 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2018   grade_3                         20.0 28.0                       48.0                         20 28                 48
1798612 1798612 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2018   grade_4                         20.0 21.0                       41.0                         20 21                 41
1798613 1798613 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2018   grade_5                         13.0 9.0                       22.0                         13 9                 22
1798614 1798614 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2018   grade_6                         16.0 22.0                       38.0                         16 22                 38
1798615 1798615 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2018   kindergarten                         30.0 26.0                       56.0                         30 26                 56
1798616 1798616 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes Elementary KG 06 2018   pk_12_total 5.0 168.0 18.0     102.0         19.0   157.0 155.0     97.0         309.0   22.0   312.0 5 168 18     102         19   157 155     97     309 22   312
1798587 1798587 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   grade_1                         33.0 41.0                       74.0                         33 41                 74
1798588 1798588 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   grade_10                         45.0 32.0                       77.0                         45 32                 77
1798589 1798589 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   grade_11                         49.0 49.0                       98.0                         49 49                 98
1798590 1798590 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   grade_12                         47.0 29.0                       76.0                         47 29                 76
1798591 1798591 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   grade_2                         39.0 30.0                       69.0                         39 30                 69
1798592 1798592 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   grade_3                         30.0 41.0                       71.0                         30 41                 71
1798593 1798593 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   grade_4                         32.0 42.0                       74.0                         32 42                 74
1798594 1798594 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   grade_5                         30.0 40.0                       70.0                         30 40                 70
1798595 1798595 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   grade_6                         36.0 40.0                       76.0                         36 40                 76
1798596 1798596 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   grade_7                         42.0 35.0                       77.0                         42 35                 77
1798597 1798597 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   grade_8                         38.0 41.0                       79.0                         38 41                 79
1798598 1798598 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   grade_9                         49.0 29.0                       78.0                         49 29                 78
1798599 1798599 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   kindergarten                         38.0 37.0                       75.0                         38 37                 75
1798600 1798600 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   pk_12_total 652.0 126.0 109.0     3.0         104.0   508.0 486.0     14.0         647.0   173.0   994.0 652 126 109     3         104   508 486     14     647 173   994
1798582 1798582 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2018   grade_10                         5.0 8.0                       13.0                         5 8                 13
1798583 1798583 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2018   grade_11                         19.0 17.0                       36.0                         19 17                 36
1798584 1798584 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2018   grade_12                         55.0 69.0                       124.0                         55 69                 124
1798585 1798585 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2018   grade_9                         6.0 0.0                       6.0                         6 0                 6
1798586 1798586 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2018   pk_12_total 123.0 23.0 15.0 2.0   2.0         14.0   85.0 94.0     2.0         55.0   42.0   179.0 123 23 15 2   2         14   85 94     2     55 42   179
1798630 1798630 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_1                         27.0 29.0                       56.0                         27 29                 56
1798631 1798631 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_10                         19.0 26.0                       45.0                         19 26                 45
1798632 1798632 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_11                         29.0 10.0                       39.0                         29 10                 39
1798633 1798633 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_12                         13.0 14.0                       27.0                         13 14                 27
1798634 1798634 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_2                         25.0 29.0                       54.0                         25 29                 54
1798635 1798635 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_3                         28.0 26.0                       54.0                         28 26                 54
1798636 1798636 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_4                         26.0 28.0                       54.0                         26 28                 54
1798637 1798637 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_5                         18.0 36.0                       54.0                         18 36                 54
1798638 1798638 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_6                         26.0 30.0                       56.0                         26 30                 56
1798639 1798639 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_7                         28.0 26.0                       54.0                         28 26                 54
1798640 1798640 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_8                         29.0 26.0                       55.0                         29 26                 55
1798641 1798641 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_9                         25.0 32.0                       57.0                         25 32                 57
1798642 1798642 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   kindergarten                         32.0 22.0                       54.0                         32 22                 54
1798643 1798643 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   pk_12_total 204.0 78.0 328.0 1.0             48.0   325.0 334.0     169.0         600.0   84.0   659.0 204 78 328 1             48   325 334     169     600 84   659
1798563 1798563 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2018   grade_10                         53.0 51.0                       104.0                         53 51                 104
1798564 1798564 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2018   grade_11                         31.0 53.0                       84.0                         31 53                 84

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