enrollments

Data source: Big Local News · About: Big Local

75,136 rows where state = "SD" 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
2970346 2970346 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   grade_10       8.0                 2.0 6.0                       8.0       8                 2 6                 8
2970347 2970347 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   grade_10       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970348 2970348 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2015   grade_11   0.0   0.0             0.0   0.0 0.0                       0.0   0   0             0   0 0                 0
2970349 2970349 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   grade_11       7.0                 5.0 2.0                       7.0       7                 5 2                 7
2970350 2970350 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   grade_11       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970351 2970351 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2015   grade_12   0.0   0.0             0.0   0.0 0.0                       0.0   0   0             0   0 0                 0
2970352 2970352 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   grade_12       10.0                 7.0 3.0                       10.0       10                 7 3                 10
2970353 2970353 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   grade_12       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970354 2970354 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2015   grade_2   1.0   15.0             1.0   9.0 8.0                       17.0   1   15             1   9 8                 17
2970355 2970355 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   grade_2       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970356 2970356 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   grade_2       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970357 2970357 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2015   grade_3   0.0   17.0             0.0   9.0 8.0                       17.0   0   17             0   9 8                 17
2970358 2970358 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   grade_3       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970359 2970359 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   grade_3       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970360 2970360 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2015   grade_4   0.0   15.0             0.0   11.0 4.0                       15.0   0   15             0   11 4                 15
2970361 2970361 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   grade_4       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970362 2970362 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   grade_4       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970363 2970363 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2015   grade_5   1.0   17.0             0.0   7.0 11.0                       18.0   1   17             0   7 11                 18
2970364 2970364 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   grade_5       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970365 2970365 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   grade_5       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970366 2970366 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2015   grade_6   0.0   0.0             0.0   0.0 0.0                       0.0   0   0             0   0 0                 0
2970367 2970367 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   grade_6       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970368 2970368 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   grade_6       18.0                 9.0 9.0                       18.0       18                 9 9                 18
2970369 2970369 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2015   grade_7   0.0   0.0             0.0   0.0 0.0                       0.0   0   0             0   0 0                 0
2970370 2970370 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   grade_7       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970371 2970371 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   grade_7       14.0                 3.0 11.0                       14.0       14                 3 11                 14
2970372 2970372 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2015   grade_8   0.0   0.0             0.0   0.0 0.0                       0.0   0   0             0   0 0                 0
2970373 2970373 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   grade_8       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970374 2970374 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   grade_8       14.0                 10.0 4.0                       14.0       14                 10 4                 14
2970375 2970375 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2015   grade_9   0.0   0.0             0.0   0.0 0.0                       0.0   0   0             0   0 0                 0
2970376 2970376 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   grade_9       17.0                 8.0 9.0                       17.0       17                 8 9                 17
2970377 2970377 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   grade_9       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970378 2970378 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2015   k_12_total   3.0   90.0             3.0   53.0 43.0                       96.0   3   90             3   53 43                 96
2970379 2970379 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   k_12_total       42.0                 22.0 20.0                       42.0       42                 22 20                 42
2970380 2970380 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   k_12_total       46.0                 22.0 24.0                       46.0       46                 22 24                 46
2970381 2970381 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2015   kindergarten   1.0   16.0             1.0   12.0 6.0                       18.0   1   16             1   12 6                 18
2970382 2970382 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970383 2970383 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970384 2970384 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2015   pk_12_total   3.0   90.0             3.0   53.0 43.0                       96.0   3   90             3   53 43                 96
2970385 2970385 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   pk_12_total       42.0                 22.0 20.0                       42.0       42                 22 20                 42
2970386 2970386 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   pk_12_total       46.0                 22.0 24.0                       46.0       46                 22 24                 46
2970387 2970387 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2015   pre_kindergarten   0.0   0.0             0.0   0.0 0.0                       0.0   0   0             0   0 0                 0
2970388 2970388 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2015   pre_kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970389 2970389 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   pre_kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970838 2970838 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No 1 KG 05 2015   grade_1     1.0 26.0                 18.0 9.0                       27.0     1 26                 18 9                 27
2970844 2970844 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2015   grade_1       8.0                 3.0 5.0                       8.0       8                 3 5                 8
2970848 2970848 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No 1 KG 05 2015   grade_10     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2970854 2970854 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2015   grade_10       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970858 2970858 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No 1 KG 05 2015   grade_11     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2970864 2970864 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2015   grade_11       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970868 2970868 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No 1 KG 05 2015   grade_12     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2970874 2970874 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2015   grade_12       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970878 2970878 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No 1 KG 05 2015   grade_2     0.0 14.0                 5.0 9.0                       14.0     0 14                 5 9                 14
2970884 2970884 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2015   grade_2       8.0                 5.0 3.0                       8.0       8                 5 3                 8
2970888 2970888 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No 1 KG 05 2015   grade_3     0.0 15.0                 8.0 7.0                       15.0     0 15                 8 7                 15
2970894 2970894 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2015   grade_3       4.0                 2.0 2.0                       4.0       4                 2 2                 4
2970898 2970898 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No 1 KG 05 2015   grade_4     1.0 18.0                 11.0 8.0                       19.0     1 18                 11 8                 19
2970904 2970904 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2015   grade_4       5.0                 2.0 3.0                       5.0       5                 2 3                 5
2970908 2970908 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No 1 KG 05 2015   grade_5     0.0 12.0                 3.0 9.0                       12.0     0 12                 3 9                 12
2970914 2970914 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2015   grade_5       8.0                 1.0 7.0                       8.0       8                 1 7                 8
2970918 2970918 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No 1 KG 05 2015   grade_6     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2970924 2970924 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2015   grade_6       10.0                 7.0 3.0                       10.0       10                 7 3                 10
2970928 2970928 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No 1 KG 05 2015   grade_7     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2970934 2970934 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2015   grade_7       8.0                 7.0 1.0                       8.0       8                 7 1                 8
2970938 2970938 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No 1 KG 05 2015   grade_8     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2970944 2970944 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2015   grade_8       13.0                 4.0 9.0                       13.0       13                 4 9                 13
2970948 2970948 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No 1 KG 05 2015   grade_9     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2970954 2970954 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2015   grade_9       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2970958 2970958 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No 1 KG 05 2015   k_12_total     3.0 114.0                 65.0 52.0                       117.0     3 114                 65 52                 117
2970964 2970964 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2015   k_12_total       76.0                 37.0 39.0                       76.0       76                 37 39                 76
2970968 2970968 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No 1 KG 05 2015   kindergarten     1.0 29.0                 20.0 10.0                       30.0     1 29                 20 10                 30
2970974 2970974 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2015   kindergarten       12.0                 6.0 6.0                       12.0       12                 6 6                 12
2970978 2970978 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No 1 KG 05 2015   pk_12_total     3.0 114.0                 65.0 52.0                       117.0     3 114                 65 52                 117
2970984 2970984 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2015   pk_12_total       76.0                 37.0 39.0                       76.0       76                 37 39                 76
2970988 2970988 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No 1 KG 05 2015   pre_kindergarten     0.0 0.0                 0.0 0.0                       0.0     0 0                 0 0                 0
2970994 2970994 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2015   pre_kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2971878 2971878 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No 1 PK 05 2015   grade_1       6.0                 2.0 4.0                       6.0       6                 2 4                 6
2971882 2971882 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No 1 PK 05 2015   grade_10       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2971886 2971886 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No 1 PK 05 2015   grade_11       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2971890 2971890 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No 1 PK 05 2015   grade_12       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2971894 2971894 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No 1 PK 05 2015   grade_2       7.0                 6.0 1.0                       7.0       7                 6 1                 7
2971898 2971898 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No 1 PK 05 2015   grade_3       11.0                 7.0 4.0                       11.0       11                 7 4                 11
2971902 2971902 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No 1 PK 05 2015   grade_4       6.0                 4.0 2.0                       6.0       6                 4 2                 6
2971906 2971906 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No 1 PK 05 2015   grade_5       7.0                 6.0 1.0                       7.0       7                 6 1                 7
2971910 2971910 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No 1 PK 05 2015   grade_6       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2971914 2971914 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No 1 PK 05 2015   grade_7       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2971918 2971918 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No 1 PK 05 2015   grade_8       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2971922 2971922 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No 1 PK 05 2015   grade_9       0.0                 0.0 0.0                       0.0       0                 0 0                 0
2971926 2971926 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No 1 PK 05 2015   k_12_total       47.0                 32.0 15.0                       47.0       47                 32 15                 47
2971930 2971930 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No 1 PK 05 2015   kindergarten       10.0                 7.0 3.0                       10.0       10                 7 3                 10
2971934 2971934 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No 1 PK 05 2015   pk_12_total       50.0                 34.0 16.0                       50.0       50                 34 16                 50
2971938 2971938 SD     school 4678570 47001   White River 47-1 467857000749 8 Norris Elementary   Regular School No 1 PK 05 2015   pre_kindergarten       3.0                 2.0 1.0                       3.0       3                 2 1                 3
3012055 3012055 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School No High 09 12 2017   grade_1     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
3012058 3012058 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School No High 09 12 2017   grade_10     0.0 55.0             0.0   35.0 20.0                       55.0     0 55             0   35 20                 55
3012061 3012061 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School No High 09 12 2017   grade_11     0.0 23.0             0.0   9.0 14.0                       23.0     0 23             0   9 14                 23
3012064 3012064 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School No High 09 12 2017   grade_12     1.0 20.0             0.0   10.0 11.0                       21.0     1 20             0   10 11                 21
3012067 3012067 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School No High 09 12 2017   grade_2     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
3012070 3012070 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School No High 09 12 2017   grade_3     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
3012073 3012073 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School No High 09 12 2017   grade_4     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
3012076 3012076 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School No High 09 12 2017   grade_5     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0

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