enrollments

Data source: Big Local News · About: Big Local

10,704 rows where state = "SD" and year = 2017 sorted by ccd_school_type

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 10,704 ✖
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
3006236 3006236 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   grade_1 0.0 0.0 0.0 0.0                 0.0 0.0                       0.0 0 0 0 0                 0 0                 0
3006246 3006246 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   grade_10 2.0 0.0 0.0 3.0                 2.0 3.0                       5.0 2 0 0 3                 2 3                 5
3006256 3006256 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   grade_11 0.0 0.0 1.0 1.0                 1.0 1.0                       2.0 0 0 1 1                 1 1                 2
3006266 3006266 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   grade_12 0.0 0.0 0.0 0.0                 0.0 0.0                       0.0 0 0 0 0                 0 0                 0
3006276 3006276 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   grade_2 0.0 0.0 0.0 0.0                 0.0 0.0                       0.0 0 0 0 0                 0 0                 0
3006286 3006286 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   grade_3 0.0 0.0 0.0 0.0                 0.0 0.0                       0.0 0 0 0 0                 0 0                 0
3006296 3006296 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   grade_4 0.0 0.0 0.0 0.0                 0.0 0.0                       0.0 0 0 0 0                 0 0                 0
3006306 3006306 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   grade_5 0.0 0.0 0.0 0.0                 0.0 0.0                       0.0 0 0 0 0                 0 0                 0
3006316 3006316 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   grade_6 0.0 0.0 0.0 0.0                 0.0 0.0                       0.0 0 0 0 0                 0 0                 0
3006326 3006326 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   grade_7 0.0 0.0 0.0 1.0                 0.0 1.0                       1.0 0 0 0 1                 0 1                 1
3006336 3006336 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   grade_8 0.0 0.0 0.0 1.0                 0.0 1.0                       1.0 0 0 0 1                 0 1                 1
3006346 3006346 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   grade_9 0.0 1.0 0.0 4.0                 0.0 5.0                       5.0 0 1 0 4                 0 5                 5
3006356 3006356 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   k_12_total 2.0 1.0 1.0 10.0                 3.0 11.0       7.1               14.0 2 1 1 10                 3 11                 14
3006366 3006366 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   kindergarten 0.0 0.0 0.0 0.0                 0.0 0.0                       0.0 0 0 0 0                 0 0                 0
3006376 3006376 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   pk_12_total 2.0 1.0 1.0 10.0                 3.0 11.0                       14.0 2 1 1 10                 3 11                 14
3006386 3006386 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   pre_kindergarten 0.0 0.0 0.0 0.0                 0.0 0.0                       0.0 0 0 0 0                 0 0                 0
3006790 3006790 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative 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   0 0                 0
3006795 3006795 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2017   grade_10 6.0   1.0 1.0             1.0   5.0 4.0                       9.0 6   1 1             1   5 4                 9
3006800 3006800 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2017   grade_11 10.0   0.0 0.0             0.0   8.0 2.0                       10.0 10   0 0             0   8 2                 10
3006805 3006805 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2017   grade_12 9.0   1.0 3.0             0.0   7.0 6.0                       13.0 9   1 3             0   7 6                 13
3006810 3006810 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative 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   0 0                 0
3006815 3006815 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative 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   0 0                 0
3006820 3006820 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative 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   0 0                 0
3006825 3006825 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative 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   0 0                 0
3006830 3006830 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2017   grade_6 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
3006835 3006835 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2017   grade_7 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
3006840 3006840 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2017   grade_8 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
3006845 3006845 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2017   grade_9 1.0   0.0 0.0             0.0   1.0 0.0                       1.0 1   0 0             0   1 0                 1
3006850 3006850 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2017   k_12_total 26.0   2.0 4.0             1.0   21.0 12.0       0.0               33.0 26   2 4             1   21 12                 33
3006855 3006855 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2017   kindergarten 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
3006860 3006860 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2017   pk_12_total 26.0   2.0 4.0             1.0   21.0 12.0                       33.0 26   2 4             1   21 12                 33
3006865 3006865 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2017   pre_kindergarten 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
3007862 3007862 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative 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 0 0             0   0 0                 0
3007863 3007863 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   grade_1 0.0                       0.0 0.0                       0.0 0                       0 0                 0
3007869 3007869 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative School No High 09 12 2017   grade_10 15.0 0.0 0.0 0.0             0.0   6.0 9.0                       15.0 15 0 0 0             0   6 9                 15
3007870 3007870 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   grade_10 42.0                       24.0 18.0                       42.0 42                       24 18                 42
3007876 3007876 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative School No High 09 12 2017   grade_11 9.0 0.0 1.0 0.0             2.0   3.0 9.0                       12.0 9 0 1 0             2   3 9                 12
3007877 3007877 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   grade_11 30.0                       18.0 12.0                       30.0 30                       18 12                 30
3007883 3007883 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative School No High 09 12 2017   grade_12 16.0 1.0 0.0 2.0             0.0   7.0 12.0                       19.0 16 1 0 2             0   7 12                 19
3007884 3007884 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   grade_12 21.0                       12.0 9.0                       21.0 21                       12 9                 21
3007890 3007890 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative 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 0 0             0   0 0                 0
3007891 3007891 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   grade_2 0.0                       0.0 0.0                       0.0 0                       0 0                 0
3007897 3007897 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative 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 0 0             0   0 0                 0
3007898 3007898 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   grade_3 0.0                       0.0 0.0                       0.0 0                       0 0                 0
3007904 3007904 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative 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 0 0             0   0 0                 0
3007905 3007905 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   grade_4 0.0                       0.0 0.0                       0.0 0                       0 0                 0
3007911 3007911 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative 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 0 0             0   0 0                 0
3007912 3007912 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   grade_5 0.0                       0.0 0.0                       0.0 0                       0 0                 0
3007918 3007918 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative School No High 09 12 2017   grade_6 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
3007919 3007919 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   grade_6 0.0                       0.0 0.0                       0.0 0                       0 0                 0
3007925 3007925 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative School No High 09 12 2017   grade_7 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
3007926 3007926 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   grade_7 0.0                       0.0 0.0                       0.0 0                       0 0                 0
3007932 3007932 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative School No High 09 12 2017   grade_8 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
3007933 3007933 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   grade_8 0.0                       0.0 0.0                       0.0 0                       0 0                 0
3007939 3007939 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative School No High 09 12 2017   grade_9 8.0 0.0 0.0 0.0             0.0   3.0 5.0                       8.0 8 0 0 0             0   3 5                 8
3007940 3007940 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   grade_9 68.0                       43.0 25.0                       68.0 68                       43 25                 68
3007946 3007946 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative School No High 09 12 2017   k_12_total 48.0 1.0 1.0 2.0             2.0   19.0 35.0       0.0               54.0 48 1 1 2             2   19 35                 54
3007947 3007947 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   k_12_total 161.0                       97.0 64.0       11.8               161.0 161                       97 64                 161
3007953 3007953 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative School No High 09 12 2017   kindergarten 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
3007954 3007954 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
3007960 3007960 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative School No High 09 12 2017   pk_12_total 48.0 1.0 1.0 2.0             2.0   19.0 35.0                       54.0 48 1 1 2             2   19 35                 54
3007961 3007961 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   pk_12_total 161.0                       97.0 64.0                       161.0 161                       97 64                 161
3007967 3007967 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative School No High 09 12 2017   pre_kindergarten 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
3007968 3007968 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Alternative School No High 09 12 2017   pre_kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
3011494 3011494 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative 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                       0.0 0 0 0 0   0       0 0   0 0                 0
3011498 3011498 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2017   grade_10 9.0 1.0 1.0 4.0   2.0       0.0 3.0   12.0 8.0                       20.0 9 1 1 4   2       0 3   12 8                 20
3011502 3011502 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2017   grade_11 5.0 0.0 0.0 3.0   0.0       0.0 1.0   4.0 5.0                       9.0 5 0 0 3   0       0 1   4 5                 9
3011506 3011506 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2017   grade_12 6.0 2.0 1.0 3.0   1.0       2.0 0.0   9.0 6.0                       15.0 6 2 1 3   1       2 0   9 6                 15
3011510 3011510 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative 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                       0.0 0 0 0 0   0       0 0   0 0                 0
3011514 3011514 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative 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                       0.0 0 0 0 0   0       0 0   0 0                 0
3011518 3011518 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative 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                       0.0 0 0 0 0   0       0 0   0 0                 0
3011522 3011522 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative 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                       0.0 0 0 0 0   0       0 0   0 0                 0
3011526 3011526 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2017   grade_6 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
3011530 3011530 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2017   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
3011534 3011534 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2017   grade_8 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
3011538 3011538 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2017   grade_9 7.0 13.0 1.0 12.0   9.0       1.0 0.0   27.0 16.0                       43.0 7 13 1 12   9       1 0   27 16                 43
3011542 3011542 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2017   k_12_total 27.0 16.0 3.0 22.0   12.0       3.0 4.0   52.0 35.0       35.6               87.0 27 16 3 22   12       3 4   52 35                 87
3011546 3011546 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2017   kindergarten 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
3011550 3011550 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2017   pk_12_total 27.0 16.0 3.0 22.0   12.0       3.0 4.0   52.0 35.0                       87.0 27 16 3 22   12       3 4   52 35                 87
3011554 3011554 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2017   pre_kindergarten 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
3012935 3012935 SD     school 4665460 65001   Oglala Lakota 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative School No Elementary KG 08 2017   grade_1       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3012941 3012941 SD     school 4665460 65001   Oglala Lakota 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative School No Elementary KG 08 2017   grade_10       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3012947 3012947 SD     school 4665460 65001   Oglala Lakota 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative School No Elementary KG 08 2017   grade_11       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3012953 3012953 SD     school 4665460 65001   Oglala Lakota 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative School No Elementary KG 08 2017   grade_12       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3012959 3012959 SD     school 4665460 65001   Oglala Lakota 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative School No Elementary KG 08 2017   grade_2       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3012965 3012965 SD     school 4665460 65001   Oglala Lakota 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative School No Elementary KG 08 2017   grade_3       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3012971 3012971 SD     school 4665460 65001   Oglala Lakota 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative School No Elementary KG 08 2017   grade_4       1.0                 1.0 0.0                       1.0       1                 1 0                 1
3012977 3012977 SD     school 4665460 65001   Oglala Lakota 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative School No Elementary KG 08 2017   grade_5       3.0                 3.0 0.0                       3.0       3                 3 0                 3
3012983 3012983 SD     school 4665460 65001   Oglala Lakota 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative School No Elementary KG 08 2017   grade_6       5.0                 5.0 0.0                       5.0       5                 5 0                 5
3012989 3012989 SD     school 4665460 65001   Oglala Lakota 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative School No Elementary KG 08 2017   grade_7       9.0                 5.0 4.0                       9.0       9                 5 4                 9
3012995 3012995 SD     school 4665460 65001   Oglala Lakota 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative School No Elementary KG 08 2017   grade_8       6.0                 2.0 4.0                       6.0       6                 2 4                 6
3013001 3013001 SD     school 4665460 65001   Oglala Lakota 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative School No Elementary KG 08 2017   grade_9       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3013007 3013007 SD     school 4665460 65001   Oglala Lakota 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative School No Elementary KG 08 2017   k_12_total       24.0                 16.0 8.0       4.2               24.0       24                 16 8                 24
3013013 3013013 SD     school 4665460 65001   Oglala Lakota 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative School No Elementary KG 08 2017   kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3013019 3013019 SD     school 4665460 65001   Oglala Lakota 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative School No Elementary KG 08 2017   pk_12_total       24.0                 16.0 8.0                       24.0       24                 16 8                 24
3013025 3013025 SD     school 4665460 65001   Oglala Lakota 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative School No Elementary KG 08 2017   pre_kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3013160 3013160 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School No Other 05 12 2017   grade_1 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
3013166 3013166 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School No Other 05 12 2017   grade_10 3.0   0.0 6.0             0.0   2.0 7.0                       9.0 3   0 6             0   2 7                 9
3013172 3013172 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School No Other 05 12 2017   grade_11 2.0   0.0 3.0             0.0   1.0 4.0                       5.0 2   0 3             0   1 4                 5
3013178 3013178 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School No Other 05 12 2017   grade_12 0.0   0.0 2.0             0.0   1.0 1.0                       2.0 0   0 2             0   1 1                 2

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