enrollments

Data source: Big Local News · About: Big Local

10,768 rows where state = "SD" and year = 2020 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 10,768 ✖
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
487897 487897 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   grade_1 80.0   10.0 6.0             7.0   51.0 52.0                       103.0 80   10 6             7   51 52                 103
487902 487902 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   grade_10 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
487907 487907 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   grade_11 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
487912 487912 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   grade_12 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
487917 487917 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   grade_2 92.0   4.0 2.0             6.0   56.0 48.0                       104.0 92   4 2             6   56 48                 104
487922 487922 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   grade_3 90.0   5.0 3.0             4.0   42.0 60.0                       102.0 90   5 3             4   42 60                 102
487927 487927 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   grade_4 82.0   6.0 1.0             5.0   47.0 47.0                       94.0 82   6 1             5   47 47                 94
487932 487932 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   grade_5 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
487937 487937 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   grade_6 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
487942 487942 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   grade_7 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
487947 487947 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   grade_8 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
487952 487952 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   grade_9 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
487957 487957 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   k_12_total 344.0   25.0 12.0             22.0   196.0 207.0       0.7               403.0 344   25 12             22   196 207                 403
487962 487962 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   kindergarten 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
487967 487967 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   pk_12_total 344.0   25.0 12.0             22.0   196.0 207.0                       403.0 344   25 12             22   196 207                 403
487972 487972 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2020   pre_kindergarten 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
496204 496204 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   grade_1 132.0 1.0 11.0 1.0   2.0         2.0   72.0 77.0                       149.0 132 1 11 1   2         2   72 77                 149
496212 496212 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   grade_10 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
496220 496220 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   grade_11 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
496228 496228 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   grade_12 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
496236 496236 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   grade_2 143.0 0.0 6.0 4.0   0.0         4.0   72.0 85.0                       157.0 143 0 6 4   0         4   72 85                 157
496244 496244 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   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
496252 496252 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   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
496260 496260 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   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
496268 496268 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   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
496276 496276 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   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
496284 496284 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   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
496292 496292 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   grade_9 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
496300 496300 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   k_12_total 275.0 1.0 17.0 5.0   2.0         6.0   144.0 162.0       0.7               306.0 275 1 17 5   2         6   144 162                 306
496308 496308 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   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
496316 496316 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   pk_12_total 275.0 1.0 17.0 5.0   2.0         6.0   144.0 162.0                       306.0 275 1 17 5   2         6   144 162                 306
496324 496324 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School Not applicable Elementary 01 02 2020   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
491897 491897 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   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
491904 491904 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   grade_10 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
491911 491911 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   grade_11 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
491918 491918 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   grade_12 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
491925 491925 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   grade_2 75.0 4.0 79.0 3.0   66.0       0.0 9.0   128.0 108.0                       236.0 75 4 79 3   66       0 9   128 108                 236
491932 491932 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   grade_3 91.0 4.0 77.0 8.0   53.0       2.0 7.0   125.0 117.0                       242.0 91 4 77 8   53       2 7   125 117                 242
491939 491939 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   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
491946 491946 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   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
491953 491953 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   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
491960 491960 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   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
491967 491967 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   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
491974 491974 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   grade_9 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
491981 491981 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   k_12_total 166.0 8.0 156.0 11.0   119.0       2.0 16.0   253.0 225.0       44.8               478.0 166 8 156 11   119       2 16   253 225                 478
491988 491988 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   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
491995 491995 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   pk_12_total 166.0 8.0 156.0 11.0   119.0       2.0 16.0   253.0 225.0                       478.0 166 8 156 11   119       2 16   253 225                 478
492002 492002 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School Not applicable Elementary 02 03 2020   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
495369 495369 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   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
495411 495411 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   grade_10 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
495453 495453 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   grade_11 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
495495 495495 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   grade_12 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
495537 495537 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   grade_2 17.0 0.0 1.0 0.0   4.0         2.0   16.0 8.0                       24.0 17 0 1 0   4         2   16 8                 24
495579 495579 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   grade_3 44.0 0.0 2.0 0.0   1.0         5.0   24.0 28.0                       52.0 44 0 2 0   1         5   24 28                 52
495621 495621 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   grade_4 43.0 1.0 0.0 1.0   3.0         6.0   24.0 30.0                       54.0 43 1 0 1   3         6   24 30                 54
495663 495663 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   grade_5 36.0 5.0 3.0 0.0   3.0         1.0   25.0 23.0                       48.0 36 5 3 0   3         1   25 23                 48
495705 495705 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   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
495747 495747 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   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
495789 495789 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   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
495831 495831 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   grade_9 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
495873 495873 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   k_12_total 140.0 6.0 6.0 1.0   11.0         14.0   89.0 89.0       0.0               178.0 140 6 6 1   11         14   89 89                 178
495915 495915 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   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
495957 495957 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   pk_12_total 140.0 6.0 6.0 1.0   11.0         14.0   89.0 89.0                       178.0 140 6 6 1   11         14   89 89                 178
495999 495999 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School Not applicable Elementary 02 05 2020   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
496870 496870 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   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
496874 496874 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   grade_10 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
496878 496878 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   grade_11 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
496882 496882 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   grade_12 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
496886 496886 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   grade_2 71.0 2.0 2.0 15.0   2.0         3.0   51.0 44.0                       95.0 71 2 2 15   2         3   51 44                 95
496890 496890 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   grade_3 68.0 2.0 3.0 9.0   1.0         7.0   50.0 40.0                       90.0 68 2 3 9   1         7   50 40                 90
496894 496894 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   grade_4 57.0 0.0 1.0 7.0   2.0         6.0   33.0 40.0                       73.0 57 0 1 7   2         6   33 40                 73
496898 496898 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   grade_5 74.0 5.0 2.0 9.0   0.0         6.0   55.0 41.0                       96.0 74 5 2 9   0         6   55 41                 96
496902 496902 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   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
496906 496906 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   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
496910 496910 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   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
496914 496914 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   grade_9 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
496918 496918 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   k_12_total 270.0 9.0 8.0 40.0   5.0         22.0   189.0 165.0       1.4               354.0 270 9 8 40   5         22   189 165                 354
496922 496922 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   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
496926 496926 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   pk_12_total 270.0 9.0 8.0 40.0   5.0         22.0   189.0 165.0                       354.0 270 9 8 40   5         22   189 165                 354
496930 496930 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School Not applicable Elementary 02 05 2020   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
489944 489944 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   grade_1 0.0     0.0   0.0       0.0     0.0 0.0                       0.0 0     0   0       0     0 0                 0
489948 489948 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   grade_10 0.0     0.0   0.0       0.0     0.0 0.0                       0.0 0     0   0       0     0 0                 0
489952 489952 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   grade_11 0.0     0.0   0.0       0.0     0.0 0.0                       0.0 0     0   0       0     0 0                 0
489956 489956 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   grade_12 0.0     0.0   0.0       0.0     0.0 0.0                       0.0 0     0   0       0     0 0                 0
489960 489960 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   grade_2 0.0     0.0   0.0       0.0     0.0 0.0                       0.0 0     0   0       0     0 0                 0
489964 489964 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   grade_3 0.0     21.0   0.0       0.0     8.0 13.0                       21.0 0     21   0       0     8 13                 21
489968 489968 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   grade_4 1.0     71.0   0.0       1.0     41.0 32.0                       73.0 1     71   0       1     41 32                 73
489972 489972 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   grade_5 0.0     79.0   1.0       0.0     45.0 35.0                       80.0 0     79   1       0     45 35                 80
489976 489976 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   grade_6 0.0     54.0   0.0       0.0     35.0 19.0                       54.0 0     54   0       0     35 19                 54
489980 489980 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   grade_7 0.0     0.0   0.0       0.0     0.0 0.0                       0.0 0     0   0       0     0 0                 0
489984 489984 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   grade_8 0.0     0.0   0.0       0.0     0.0 0.0                       0.0 0     0   0       0     0 0                 0
489988 489988 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   grade_9 0.0     0.0   0.0       0.0     0.0 0.0                       0.0 0     0   0       0     0 0                 0
489992 489992 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   k_12_total 1.0     225.0   1.0       1.0     129.0 99.0       0.0               228.0 1     225   1       1     129 99                 228
489996 489996 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   kindergarten 0.0     0.0   0.0       0.0     0.0 0.0                       0.0 0     0   0       0     0 0                 0
490000 490000 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   pk_12_total 1.0     225.0   1.0       1.0     129.0 99.0                       228.0 1     225   1       1     129 99                 228
490004 490004 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2020   pre_kindergarten 0.0     0.0   0.0       0.0     0.0 0.0                       0.0 0     0   0       0     0 0                 0
493672 493672 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School Not applicable Elementary 03 05 2020   grade_1 0.0 0.0 0.0 0.0                 0.0 0.0                       0.0 0 0 0 0                 0 0                 0
493676 493676 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School Not applicable Elementary 03 05 2020   grade_10 0.0 0.0 0.0 0.0                 0.0 0.0                       0.0 0 0 0 0                 0 0                 0
493680 493680 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School Not applicable Elementary 03 05 2020   grade_11 0.0 0.0 0.0 0.0                 0.0 0.0                       0.0 0 0 0 0                 0 0                 0
493684 493684 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School Not applicable Elementary 03 05 2020   grade_12 0.0 0.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]);