enrollments

Data source: Big Local News · About: Big Local

10,752 rows where state = "SD" and year = 2019 sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 4,695 ✖
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 ▼
357154 357154 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No High 05 12 2019   grade_8 0.0 1.0   0.0                 1.0 0.0                       1.0 0 1   0                 1 0                 1
357353 357353 SD     school 4639540 11001   Andes Central 11-1 463954001080 5 Lakeview Colony Elem   Regular School No Elementary KG 08 2019   grade_4 1.0                       0.0 1.0                       1.0 1                       0 1                 1
357374 357374 SD     school 4639540 11001   Andes Central 11-1 463954001379 6 Pease Creek Colony Elementary   Regular School No Elementary KG 08 2019   grade_8 1.0                       1.0 0.0                       1.0 1                       1 0                 1
357931 357931 SD     school 4607400 4002   Bon Homme 04-2 460740001393 20 Dawson Colony School   Regular School No Elementary KG 08 2019   grade_4 1.0                       0.0 1.0                       1.0 1                       0 1                 1
357939 357939 SD     school 4607400 4002   Bon Homme 04-2 460740001393 20 Dawson Colony School   Regular School No Elementary KG 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
357947 357947 SD     school 4607400 4002   Bon Homme 04-2 460740001393 20 Dawson Colony School   Regular School No Elementary KG 08 2019   grade_6 1.0                       0.0 1.0                       1.0 1                       0 1                 1
357955 357955 SD     school 4607400 4002   Bon Homme 04-2 460740001393 20 Dawson Colony School   Regular School No Elementary KG 08 2019   grade_7 1.0                       0.0 1.0                       1.0 1                       0 1                 1
357963 357963 SD     school 4607400 4002   Bon Homme 04-2 460740001393 20 Dawson Colony School   Regular School No Elementary KG 08 2019   grade_8 1.0                       0.0 1.0                       1.0 1                       0 1                 1
358219 358219 SD     school 4600041 45004   Britton-Hecla 45-4 460004101143 4 Sunset Colony Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
358238 358238 SD     school 4600041 45004   Britton-Hecla 45-4 460004101364 6 Sunset Colony High School   Regular School No High 09 12 2019   grade_12 1.0                       0.0 1.0                       1.0 1                       0 1                 1
358245 358245 SD     school 4600041 45004   Britton-Hecla 45-4 460004101180 5 Westwood Rural Elementary   Regular School No Elementary KG 08 2019   grade_2 1.0                       0.0 1.0                       1.0 1                       0 1                 1
358249 358249 SD     school 4600041 45004   Britton-Hecla 45-4 460004101143 4 Sunset Colony Elementary   Regular School No Elementary KG 08 2019   grade_3 1.0                       1.0 0.0                       1.0 1                       1 0                 1
358269 358269 SD     school 4600041 45004   Britton-Hecla 45-4 460004101180 5 Westwood Rural Elementary   Regular School No Elementary KG 08 2019   grade_6 1.0                       0.0 1.0                       1.0 1                       0 1                 1
358555 358555 SD     school 4611280 28001   Castlewood 28-1 461128001126 4 Claremont Colony Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       0.0 1.0                       1.0 1                       0 1                 1
358587 358587 SD     school 4611280 28001   Castlewood 28-1 461128001126 4 Claremont Colony Elementary   Regular School No Elementary KG 08 2019   grade_6 1.0                       1.0 0.0                       1.0 1                       1 0                 1
358591 358591 SD     school 4611280 28001   Castlewood 28-1 461128001126 4 Claremont Colony Elementary   Regular School No Elementary KG 08 2019   grade_7 1.0                       1.0 0.0                       1.0 1                       1 0                 1
358758 358758 SD     school 4612300 39001   Chester Area 39-1 461230001377 7 Gracevale Colony   Regular School No Elementary KG 08 2019   grade_4 1.0                       0.0 1.0                       1.0 1                       0 1                 1
358772 358772 SD     school 4612300 39001   Chester Area 39-1 461230001377 7 Gracevale Colony   Regular School No Elementary KG 08 2019   grade_6 1.0                       0.0 1.0                       1.0 1                       0 1                 1
358774 358774 SD     school 4612300 39001   Chester Area 39-1 461230001092 4 Rustic Acres   Regular School No Elementary KG 08 2019   grade_6 1.0                       1.0 0.0                       1.0 1                       1 0                 1
358781 358781 SD     school 4612300 39001   Chester Area 39-1 461230001092 4 Rustic Acres   Regular School No Elementary KG 08 2019   grade_7 1.0                       0.0 1.0                       1.0 1                       0 1                 1
358788 358788 SD     school 4612300 39001   Chester Area 39-1 461230001092 4 Rustic Acres   Regular School No Elementary KG 08 2019   grade_8 1.0                       1.0 0.0                       1.0 1                       1 0                 1
358829 358829 SD     school 4612940 12002   Clark 12-2 461294001319 7 Silver Creek Colony   Regular School No Elementary KG 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
358906 358906 SD     school 4612940 12002   Clark 12-2 461294001082 5 Hillcrest Colony Elementary   Regular School No Elementary KG 08 2019   kindergarten 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359011 359011 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School No Elementary KG 08 2019   grade_8 0.0     1.0                 1.0 0.0                       1.0 0     1                 1 0                 1
359342 359342 SD     school 4678300 5006   Deubrook Area 05-6 467830001154 7 Norfeld Colony School   Regular School No Elementary KG 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359343 359343 SD     school 4678300 5006   Deubrook Area 05-6 467830001320 9 Red Willow Colony School   Regular School No Elementary KG 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359352 359352 SD     school 4678300 5006   Deubrook Area 05-6 467830001154 7 Norfeld Colony School   Regular School No Elementary KG 08 2019   grade_7 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359372 359372 SD     school 4678300 5006   Deubrook Area 05-6 467830001154 7 Norfeld Colony School   Regular School No Elementary KG 08 2019   kindergarten 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359433 359433 SD     school 4619170 56002   Doland 56-2 461917001101 5 Clark Colony Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359437 359437 SD     school 4619170 56002   Doland 56-2 461917001100 4 Hillside Colony Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359461 359461 SD     school 4619170 56002   Doland 56-2 461917001101 5 Clark Colony Elementary   Regular School No Elementary KG 08 2019   grade_2 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359468 359468 SD     school 4619170 56002   Doland 56-2 461917001101 5 Clark Colony Elementary   Regular School No Elementary KG 08 2019   grade_3 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359475 359475 SD     school 4619170 56002   Doland 56-2 461917001101 5 Clark Colony Elementary   Regular School No Elementary KG 08 2019   grade_4 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359488 359488 SD     school 4619170 56002   Doland 56-2 461917001299 6 Camrose Colony Elementary   Regular School No Elementary KG 08 2019   grade_6 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359500 359500 SD     school 4619170 56002   Doland 56-2 461917001100 4 Hillside Colony Elementary   Regular School No Elementary KG 08 2019   grade_7 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359503 359503 SD     school 4619170 56002   Doland 56-2 461917001101 5 Clark Colony Elementary   Regular School No Elementary KG 08 2019   grade_8 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359752 359752 SD     school 4634440 22005   Edmunds Central 22-5 463444001385 6 Boulder Colony School   Regular School No Elementary KG 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359776 359776 SD     school 4634440 22005   Edmunds Central 22-5 463444001385 6 Boulder Colony School   Regular School No Elementary KG 08 2019   grade_4 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359784 359784 SD     school 4634440 22005   Edmunds Central 22-5 463444001385 6 Boulder Colony School   Regular School No Elementary KG 08 2019   grade_6 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359792 359792 SD     school 4634440 22005   Edmunds Central 22-5 463444001385 6 Boulder Colony School   Regular School No Elementary KG 08 2019   grade_8 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359816 359816 SD     school 4621300 16002   Elk Mountain 16-2 462130000899 1 Elk Mountain Elem   Regular School No Elementary PK 08 2019   grade_1 0.0   1.0                   0.0 1.0                       1.0 0   1                   0 1                 1
359819 359819 SD     school 4621300 16002   Elk Mountain 16-2 462130001371 4 Elk Mountain High School   Regular School No High 09 12 2019   grade_10 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359821 359821 SD     school 4621300 16002   Elk Mountain 16-2 462130001371 4 Elk Mountain High School   Regular School No High 09 12 2019   grade_11 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359824 359824 SD     school 4621300 16002   Elk Mountain 16-2 462130000899 1 Elk Mountain Elem   Regular School No Elementary PK 08 2019   grade_2 0.0   1.0                   1.0 0.0                       1.0 0   1                   1 0                 1
359832 359832 SD     school 4621300 16002   Elk Mountain 16-2 462130000899 1 Elk Mountain Elem   Regular School No Elementary PK 08 2019   grade_6 0.0   1.0                   1.0 0.0                       1.0 0   1                   1 0                 1
359834 359834 SD     school 4621300 16002   Elk Mountain 16-2 462130000899 1 Elk Mountain Elem   Regular School No Elementary PK 08 2019   grade_7 1.0   0.0                   1.0 0.0                       1.0 1   0                   1 0                 1
359836 359836 SD     school 4621300 16002   Elk Mountain 16-2 462130000899 1 Elk Mountain Elem   Regular School No Elementary PK 08 2019   grade_8 1.0   0.0                   1.0 0.0                       1.0 1   0                   1 0                 1
359839 359839 SD     school 4621300 16002   Elk Mountain 16-2 462130001371 4 Elk Mountain High School   Regular School No High 09 12 2019   grade_9 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359846 359846 SD     school 4621300 16002   Elk Mountain 16-2 462130000899 1 Elk Mountain Elem   Regular School No Elementary PK 08 2019   pre_kindergarten 1.0   0.0                   1.0 0.0                       1.0 1   0                   1 0                 1
359920 359920 SD     school 4621390 5003   Elkton 05-3 462139001168 5 Rolland Colony Elem   Regular School No Elementary KG 08 2019   grade_2 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359929 359929 SD     school 4621390 5003   Elkton 05-3 462139001078 4 Newdale Colony Elem   Regular School No Elementary KG 08 2019   grade_4 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359940 359940 SD     school 4621390 5003   Elkton 05-3 462139001168 5 Rolland Colony Elem   Regular School No Elementary KG 08 2019   grade_6 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359950 359950 SD     school 4621390 5003   Elkton 05-3 462139001168 5 Rolland Colony Elem   Regular School No Elementary KG 08 2019   grade_8 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360123 360123 SD     school 4622940 46002   Faith 46-2 462294000412 4 Maurine Elem.   Regular School No Elementary KG 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360139 360139 SD     school 4622940 46002   Faith 46-2 462294000412 4 Maurine Elem.   Regular School No Elementary KG 08 2019   grade_2 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360147 360147 SD     school 4622940 46002   Faith 46-2 462294000412 4 Maurine Elem.   Regular School No Elementary KG 08 2019   grade_4 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360189 360189 SD     school 4624030 24004   Faulkton Area 462403001160 10 Thunderbird Colony Elem   Regular School No Elementary KG 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360233 360233 SD     school 4624030 24004   Faulkton Area 462403001090 5 Brentwood Colony School   Regular School No Elementary KG 08 2019   grade_6 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360239 360239 SD     school 4624030 24004   Faulkton Area 462403001090 5 Brentwood Colony School   Regular School No Elementary KG 08 2019   grade_7 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360443 360443 SD     school 4625500 33001   Freeman 33-1 462550000221 3 Tschetter Colony Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360444 360444 SD     school 4625500 33001   Freeman 33-1 462550000222 4 Wolf Creek Colony Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360483 360483 SD     school 4625500 33001   Freeman 33-1 462550000221 3 Tschetter Colony Elementary   Regular School No Elementary KG 08 2019   grade_6 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360493 360493 SD     school 4625500 33001   Freeman 33-1 462550000221 3 Tschetter Colony Elementary   Regular School No Elementary KG 08 2019   grade_8 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360760 360760 SD     school 4630490 27001   Haakon 27-1 463049000647 8 Milesville Elem   Regular School No Elementary KG 08 2019   grade_1 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360780 360780 SD     school 4630490 27001   Haakon 27-1 463049000647 8 Milesville Elem   Regular School No Elementary KG 08 2019   grade_3 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360788 360788 SD     school 4630490 27001   Haakon 27-1 463049000647 8 Milesville Elem   Regular School No Elementary KG 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360800 360800 SD     school 4630490 27001   Haakon 27-1 463049000647 8 Milesville Elem   Regular School No Elementary KG 08 2019   grade_8 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360876 360876 SD     school 4602640 30001   Hanson 30-1 460264000015 4 Millbrook Colony Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360918 360918 SD     school 4602640 30001   Hanson 30-1 460264000015 4 Millbrook Colony Elementary   Regular School No Elementary KG 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360924 360924 SD     school 4602640 30001   Hanson 30-1 460264000015 4 Millbrook Colony Elementary   Regular School No Elementary KG 08 2019   grade_6 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360936 360936 SD     school 4602640 30001   Hanson 30-1 460264000015 4 Millbrook Colony Elementary   Regular School No Elementary KG 08 2019   grade_8 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360969 360969 SD     school 4609300 31001   Harding County 31-1 460930000701 8 Camp Crook Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360994 360994 SD     school 4609300 31001   Harding County 31-1 460930000701 8 Camp Crook Elementary   Regular School No Elementary KG 08 2019   grade_3 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360997 360997 SD     school 4609300 31001   Harding County 31-1 460930000667 6 Ludlow Elementary   Regular School No Elementary KG 08 2019   grade_3 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361002 361002 SD     school 4609300 31001   Harding County 31-1 460930000667 6 Ludlow Elementary   Regular School No Elementary KG 08 2019   grade_4 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361004 361004 SD     school 4609300 31001   Harding County 31-1 460930000701 8 Camp Crook Elementary   Regular School No Elementary KG 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361007 361007 SD     school 4609300 31001   Harding County 31-1 460930000667 6 Ludlow Elementary   Regular School No Elementary KG 08 2019   grade_5 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361037 361037 SD     school 4609300 31001   Harding County 31-1 460930000667 6 Ludlow Elementary   Regular School No Elementary KG 08 2019   kindergarten 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361428 361428 SD     school 4600046 56006   Hitchcock-Tulare 460004601165 3 Spink Colony Elem   Regular School No Elementary KG 08 2019   grade_6 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361599 361599 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School No Elementary KG 08 2019   grade_7 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361629 361629 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361664 361664 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School No Elementary KG 08 2019   grade_3 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361671 361671 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School No Elementary KG 08 2019   grade_4 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361674 361674 SD     school 4635480 2002   Huron 02-2 463548000312 13 Huron Colony Elementary   Regular School No Elementary KG 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361695 361695 SD     school 4635480 2002   Huron 02-2 463548000312 13 Huron Colony Elementary   Regular School No Elementary KG 08 2019   grade_8 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361699 361699 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School No Elementary KG 08 2019   grade_8 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361716 361716 SD     school 4635480 2002   Huron 02-2 463548000312 13 Huron Colony Elementary   Regular School No Elementary KG 08 2019   kindergarten 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361741 361741 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School No Elementary PK 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361771 361771 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School No Elementary PK 08 2019   grade_3 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361772 361772 SD     school 4636060 22006   Ipswich Public 22-6 463606001085 5 Deerfield Colony Elem   Regular School No Elementary PK 08 2019   grade_4 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361777 361777 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School No Elementary PK 08 2019   grade_4 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361778 361778 SD     school 4636060 22006   Ipswich Public 22-6 463606001085 5 Deerfield Colony Elem   Regular School No Elementary PK 08 2019   grade_5 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361782 361782 SD     school 4636060 22006   Ipswich Public 22-6 463606001086 6 Pembrook Colony Elem   Regular School No Elementary PK 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361783 361783 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School No Elementary PK 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361800 361800 SD     school 4636060 22006   Ipswich Public 22-6 463606001086 6 Pembrook Colony Elem   Regular School No Elementary PK 08 2019   grade_8 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361801 361801 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School No Elementary PK 08 2019   grade_8 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361911 361911 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No Middle 04 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361923 361923 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No Middle 04 08 2019   grade_8 1.0                       1.0 0.0                       1.0 1                       1 0                 1
362051 362051 SD     school 4680437 35002   Kadoka Area 35-2 468043701257 11 Midland Elementary   Regular School No Elementary KG 08 2019   grade_7 1.0                       0.0 1.0                       1.0 1                       0 1                 1
362243 362243 SD     school 4640860 45005   Langford Area 464086001097 4 Newport Colony Elem   Regular School No Elementary KG 08 2019   grade_4 1.0                       1.0 0.0                       1.0 1                       1 0                 1

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