enrollments

Data source: Big Local News · About: Big Local

84,143 rows where state = "IN" sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
1159705 1159705 IN     school 1803630 235   Fort Wayne Community Schools 180363000555 133 Portage Middle School   Regular School No 2.0 06 08 2015   grade_8                         99.0 75.0                       174.0                         99 75                 174
1159707 1159707 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_1                         57.0 62.0                       119.0                         57 62                 119
1159708 1159708 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_2                         69.0 49.0                       118.0                         69 49                 118
1159709 1159709 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_3                         61.0 49.0                       110.0                         61 49                 110
1159710 1159710 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_4                         50.0 57.0                       107.0                         50 57                 107
1159711 1159711 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_5                         43.0 63.0                       106.0                         43 63                 106
1159713 1159713 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         45.0 55.0                       100.0                         45 55                 100
1159714 1159714 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         48.0 32.0                       80.0                         48 32                 80
1159715 1159715 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         47.0 48.0                       95.0                         47 48                 95
1159716 1159716 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         37.0 51.0                       88.0                         37 51                 88
1159717 1159717 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         40.0 44.0                       84.0                         40 44                 84
1159718 1159718 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         44.0 69.0                       113.0                         44 69                 113
1159720 1159720 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         14.0 17.0                       31.0                         14 17                 31
1159721 1159721 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         39.0 41.0                       80.0                         39 41                 80
1159722 1159722 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         44.0 25.0                       69.0                         44 25                 69
1159723 1159723 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         24.0 29.0                       53.0                         24 29                 53
1159724 1159724 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary Sch   Regular School No 1.0 PK 05 2015   grade_4                         32.0 24.0                       56.0                         32 24                 56
1159725 1159725 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         16.0 26.0                       42.0                         16 26                 42
1159726 1159726 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary Sch   Regular School No 1.0 PK 05 2015   kindergarten                         37.0 40.0                       77.0                         37 40                 77
1159728 1159728 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         14.0 18.0                       32.0                         14 18                 32
1159729 1159729 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         26.0 18.0                       44.0                         26 18                 44
1159730 1159730 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         28.0 27.0                       55.0                         28 27                 55
1159731 1159731 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         26.0 21.0                       47.0                         26 21                 47
1159732 1159732 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         22.0 20.0                       42.0                         22 20                 42
1159733 1159733 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         20.0 22.0                       42.0                         20 22                 42
1159734 1159734 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         26.0 32.0                       58.0                         26 32                 58
1159736 1159736 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         15.0 16.0                       31.0                         15 16                 31
1159737 1159737 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         31.0 23.0                       54.0                         31 23                 54
1159738 1159738 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         24.0 20.0                       44.0                         24 20                 44
1159739 1159739 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         23.0 23.0                       46.0                         23 23                 46
1159740 1159740 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary Sch   Regular School No 1.0 PK 05 2015   grade_4                         20.0 20.0                       40.0                         20 20                 40
1159741 1159741 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         21.0 11.0                       32.0                         21 11                 32
1159742 1159742 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary Sch   Regular School No 1.0 PK 05 2015   kindergarten                         32.0 25.0                       57.0                         32 25                 57
1159744 1159744 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         18.0 14.0                       32.0                         18 14                 32
1159745 1159745 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No 1.0 PK KG 2015   kindergarten                         44.0 39.0                       83.0                         44 39                 83
1159747 1159747 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No 1.0 PK KG 2015   pre_kindergarten                         83.0 76.0                       159.0                         83 76                 159
1159748 1159748 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         53.0 37.0                       90.0                         53 37                 90
1159749 1159749 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         35.0 36.0                       71.0                         35 36                 71
1159750 1159750 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         45.0 44.0                       89.0                         45 44                 89
1159751 1159751 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         41.0 38.0                       79.0                         41 38                 79
1159752 1159752 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         33.0 40.0                       73.0                         33 40                 73
1159753 1159753 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         39.0 43.0                       82.0                         39 43                 82
1159755 1159755 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         9.0 9.0                       18.0                         9 9                 18
1159756 1159756 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elem Sch   Regular School No 1.0 KG 05 2015   grade_1                         54.0 50.0                       104.0                         54 50                 104
1159757 1159757 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elem Sch   Regular School No 1.0 KG 05 2015   grade_2                         48.0 53.0                       101.0                         48 53                 101
1159758 1159758 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elem Sch   Regular School No 1.0 KG 05 2015   grade_3                         53.0 44.0                       97.0                         53 44                 97
1159759 1159759 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elem Sch   Regular School No 1.0 KG 05 2015   grade_4                         50.0 53.0                       103.0                         50 53                 103
1159760 1159760 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elem Sch   Regular School No 1.0 KG 05 2015   grade_5                         49.0 48.0                       97.0                         49 48                 97
1159761 1159761 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elem Sch   Regular School No 1.0 KG 05 2015   kindergarten                         54.0 44.0                       98.0                         54 44                 98
1159763 1159763 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         49.0 57.0                       106.0                         49 57                 106
1159764 1159764 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         42.0 41.0                       83.0                         42 41                 83
1159765 1159765 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         52.0 46.0                       98.0                         52 46                 98
1159766 1159766 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         36.0 38.0                       74.0                         36 38                 74
1159767 1159767 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         46.0 43.0                       89.0                         46 43                 89
1159768 1159768 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         59.0 60.0                       119.0                         59 60                 119
1159770 1159770 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         28.0 15.0                       43.0                         28 15                 43
1159771 1159771 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         58.0 47.0                       105.0                         58 47                 105
1159772 1159772 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         46.0 47.0                       93.0                         46 47                 93
1159773 1159773 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         43.0 46.0                       89.0                         43 46                 89
1159774 1159774 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         42.0 45.0                       87.0                         42 45                 87
1159775 1159775 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         35.0 41.0                       76.0                         35 41                 76
1159776 1159776 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         39.0 41.0                       80.0                         39 41                 80
1159778 1159778 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         17.0 15.0                       32.0                         17 15                 32
1159779 1159779 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         57.0 68.0                       125.0                         57 68                 125
1159780 1159780 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         56.0 50.0                       106.0                         56 50                 106
1159781 1159781 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         63.0 46.0                       109.0                         63 46                 109
1159782 1159782 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         49.0 37.0                       86.0                         49 37                 86
1159783 1159783 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         48.0 38.0                       86.0                         48 38                 86
1159784 1159784 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary Sch   Regular School No 1.0 KG 05 2015   kindergarten                         45.0 44.0                       89.0                         45 44                 89
1159786 1159786 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         42.0 50.0                       92.0                         42 50                 92
1159787 1159787 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         60.0 38.0                       98.0                         60 38                 98
1159788 1159788 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         57.0 48.0                       105.0                         57 48                 105
1159789 1159789 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary Sch   Regular School No 1.0 PK 05 2015   grade_4                         36.0 56.0                       92.0                         36 56                 92
1159790 1159790 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         46.0 47.0                       93.0                         46 47                 93
1159791 1159791 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary Sch   Regular School No 1.0 PK 05 2015   kindergarten                         45.0 39.0                       84.0                         45 39                 84
1159793 1159793 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         8.0 5.0                       13.0                         8 5                 13
1159794 1159794 IN     school 1803630 235   Fort Wayne Community Schools 180363000568 177 Wayne High School   Regular School No 3.0 09 12 2015   grade_10                         179.0 137.0                       316.0                         179 137                 316
1159795 1159795 IN     school 1803630 235   Fort Wayne Community Schools 180363000568 177 Wayne High School   Regular School No 3.0 09 12 2015   grade_11                         184.0 148.0                       332.0                         184 148                 332
1159796 1159796 IN     school 1803630 235   Fort Wayne Community Schools 180363000568 177 Wayne High School   Regular School No 3.0 09 12 2015   grade_12                         167.0 155.0                       322.0                         167 155                 322
1159797 1159797 IN     school 1803630 235   Fort Wayne Community Schools 180363000568 177 Wayne High School   Regular School No 3.0 09 12 2015   grade_9                         154.0 147.0                       301.0                         154 147                 301
1159799 1159799 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         41.0 53.0                       94.0                         41 53                 94
1159800 1159800 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         55.0 41.0                       96.0                         55 41                 96
1159801 1159801 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         53.0 46.0                       99.0                         53 46                 99
1159802 1159802 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary Sch   Regular School No 1.0 PK 05 2015   grade_4                         52.0 42.0                       94.0                         52 42                 94
1159803 1159803 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         41.0 56.0                       97.0                         41 56                 97
1159804 1159804 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary Sch   Regular School No 1.0 PK 05 2015   kindergarten                         57.0 55.0                       112.0                         57 55                 112
1159806 1159806 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         24.0 17.0                       41.0                         24 17                 41
1159807 1159807 IN     school 1803630 235   Fort Wayne Community Schools 180363000543 186 Mabel K Holland Elem Sch   Regular School No 1.0 PK 05 2015   grade_1                         42.0 43.0                       85.0                         42 43                 85
1159808 1159808 IN     school 1803630 235   Fort Wayne Community Schools 180363000543 186 Mabel K Holland Elem Sch   Regular School No 1.0 PK 05 2015   grade_2                         39.0 45.0                       84.0                         39 45                 84
1159809 1159809 IN     school 1803630 235   Fort Wayne Community Schools 180363000543 186 Mabel K Holland Elem Sch   Regular School No 1.0 PK 05 2015   grade_3                         37.0 34.0                       71.0                         37 34                 71
1159810 1159810 IN     school 1803630 235   Fort Wayne Community Schools 180363000543 186 Mabel K Holland Elem Sch   Regular School No 1.0 PK 05 2015   grade_4                         36.0 46.0                       82.0                         36 46                 82
1159811 1159811 IN     school 1803630 235   Fort Wayne Community Schools 180363000543 186 Mabel K Holland Elem Sch   Regular School No 1.0 PK 05 2015   grade_5                         41.0 45.0                       86.0                         41 45                 86
1159812 1159812 IN     school 1803630 235   Fort Wayne Community Schools 180363000543 186 Mabel K Holland Elem Sch   Regular School No 1.0 PK 05 2015   kindergarten                         44.0 33.0                       77.0                         44 33                 77
1159814 1159814 IN     school 1803630 235   Fort Wayne Community Schools 180363000543 186 Mabel K Holland Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         31.0 22.0                       53.0                         31 22                 53
1159815 1159815 IN     school 1803630 235   Fort Wayne Community Schools 180363000532 189 Indian Village Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         45.0 35.0                       80.0                         45 35                 80
1159816 1159816 IN     school 1803630 235   Fort Wayne Community Schools 180363000532 189 Indian Village Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         41.0 43.0                       84.0                         41 43                 84
1159817 1159817 IN     school 1803630 235   Fort Wayne Community Schools 180363000532 189 Indian Village Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         42.0 38.0                       80.0                         42 38                 80
1159818 1159818 IN     school 1803630 235   Fort Wayne Community Schools 180363000532 189 Indian Village Elementary Sch   Regular School No 1.0 PK 05 2015   grade_4                         36.0 40.0                       76.0                         36 40                 76
1159819 1159819 IN     school 1803630 235   Fort Wayne Community Schools 180363000532 189 Indian Village Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         47.0 34.0                       81.0                         47 34                 81
1159820 1159820 IN     school 1803630 235   Fort Wayne Community Schools 180363000532 189 Indian Village Elementary Sch   Regular School No 1.0 PK 05 2015   kindergarten                         39.0 37.0                       76.0                         39 37                 76

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