Data source: Big Local News · About: Big Local

4,696 rows where grade = "pk_12_total" and state = "SD" sorted by male

View and edit SQL

year

grade

  • pk_12_total · 4,696
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
252602 SD     school 4621300 16002   Elk Mountain 16-2 462130001371 4 Elk Mountain High School   Regular School No High 09 12 2018   pk_12_total 2.0                       1.0 1.0                       2.0 2                       1 1                 2
257411 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No Other PK 12 2018   pk_12_total 2.0                       1.0 1.0                       2.0 2                       1 1                 2
259589 SD     school 4675660 51005   Wall 51-5 467566000779 8 Big White Elementary School   Regular School No Elementary KG 06 2018   pk_12_total 6.0                       1.0 5.0                       6.0 6                       1 5                 6
365672 SD     school 4666270 49005   Sioux Falls 49-5 466627001305 37 Career and Technical Education Academy   Career and Technical School No High 09 12 2019   pk_12_total 1.0                   1.0   1.0 1.0                       2.0 1                   1   1 1                 2
367233 SD     school 4677460 36002   Wessington Springs 36-2 467746001372 93 Wessington Springs Middle School Cyber S   Regular School No Middle 07 08 2019   pk_12_total 2.0                       1.0 1.0                       2.0 2                       1 1                 2
455062 SD     school 4600002 25004   Milbank 25-4 460000201390 4 Blue Sky Colony   Regular School Not applicable Elementary KG 08 2021   pk_12_total 7.0                       1.0 6.0                       7.0 7                       1 6                 7
458437 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000067 5 Greenwood Colony Elementary   Regular School Not applicable Elementary KG 08 2021   pk_12_total 5.0                       1.0 4.0                       5.0 5                       1 4                 5
493485 SD     school 4600002 25004   Milbank 25-4 460000201390 4 Blue Sky Colony   Regular School Not applicable Elementary KG 08 2020   pk_12_total 6.0                       1.0 5.0                       6.0 6                       1 5                 6
2961746 SD     school 4602070 6001   Aberdeen 06-1 460207001230 12 Aberdeen Alternative Learning Center   Alternative Education School No 4 06 12 2015   pk_12_total 2.0                       1.0 1.0                       2.0 2                       1 1                 2
2964308 SD     school 4621300 16002   Elk Mountain 16-2 462130001186 3 Elk Mountain Virtual HS   Regular School No 3 09 12 2015   pk_12_total 3.0                       1.0 2.0                       3.0 3                       1 2                 3
2965600 SD     school 4609300 31001   Harding County 31-1 460930000667 6 Ludlow Elementary   Regular School No 1 KG 08 2015   pk_12_total 4.0                       1.0 3.0                       4.0 4                       1 3                 4
2972043 SD     school 4679350 12003   Willow Lake 12-3 467935001327 8 Shamrock Colony Alternative HS   Regular School No 3 09 12 2015   pk_12_total 2.0                       1.0 1.0                       2.0 2                       1 1                 2
3009011 SD     school 4621300 16002   Elk Mountain 16-2 462130001186 92 Elk Mountain Virtual HS   Regular School No High 09 12 2017   pk_12_total 1.0                   1.0   1.0 1.0                       2.0 1                   1   1 1                 2
3010272 SD     school 4609300 31001   Harding County 31-1 460930000667 6 Ludlow Elementary   Regular School No Elementary KG 08 2017   pk_12_total 7.0                       1.0 6.0                       7.0 7                       1 6                 7
3015982 SD     school 4675660 51005   Wall 51-5 467566000779 8 Big White Elementary School   Regular School No Elementary KG 06 2017   pk_12_total 6.0                       1.0 5.0                       6.0 6                       1 5                 6
3348184 SD     school 4609300 31001   Harding County 31-1 460930000667 6 Ludlow Elementary   Regular School No 1 KG 08 2016   pk_12_total 5.0                       1.0 4.0                       5.0 5                       1 4                 5
3350968 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701339 5 Spring Lake Colony HS   Regular School No 3 09 12 2016   pk_12_total 3.0                       1.0 2.0                       3.0 3                       1 2                 3
3354547 SD     school 4679350 12003   Willow Lake 12-3 467935001327 8 Shamrock Colony Alternative HS   Regular School No 3 09 12 2016   pk_12_total 2.0                       1.0 1.0                       2.0 2                       1 1                 2
250150 SD     school 4639540 11001   Andes Central 11-1 463954001080 5 Lakeview Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 30.0                       10.0 20.0                       30.0 30                       10 20                 30
250216 SD     school 4603720 38001   Arlington 38-1 460372001381 4 Arlington PreSchool   Regular School No Prekindergarten PK PK 2018   pk_12_total 17.0   2.0                   10.0 9.0                       19.0 17   2                   10 9                 19
253045 SD     school 4624030 24004   Faulkton Area 462403000204 8 Faulkton Jr Hi   Regular School No Middle 07 08 2018   pk_12_total 30.0 1.0   1.0                 10.0 22.0                       32.0 30 1   1                 10 22                 32
254500 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 15.0                       10.0 5.0                       15.0 15                       10 5                 15
256661 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701035 3 Oldham-Ramona Junior High School   Regular School No Middle 07 08 2018   pk_12_total 22.0                   1.0   10.0 13.0                       23.0 22                   1   10 13                 23
256662 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701112 4 Spring Lake Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 27.0                       10.0 17.0                       27.0 27                       10 17                 27
258444 SD     school 4666270 49005   Sioux Falls 49-5 466627000609 40 Summit Oaks Day Program   Special Education School No Other KG 12 2018   pk_12_total 8.0 3.0 3.0                   10.0 4.0                       14.0 8 3 3                   10 4                 14
260105 SD     school 4678510 1003   White Lake 01-3 467851000950 3 White Lake JH   Regular School No Middle 07 08 2018   pk_12_total 16.0 1.0 2.0                   10.0 9.0                       19.0 16 1 2                   10 9                 19
357829 SD     school 4606960 25001   Big Stone City 25-1 460696000352 3 Big Stone MS   Regular School No Middle 06 08 2019   pk_12_total 20.0 1.0                     10.0 11.0                       21.0 20 1                     10 11                 21
362784 SD     school 4601026 43007   McCook Central 43-7 460102601281 4 Golden View Colony Elementary   Regular School No Elementary KG 08 2019   pk_12_total 23.0                       10.0 13.0                       23.0 23                       10 13                 23
363150 SD     school 4647100 33002   Menno 33-2 464710000417 3 Jamesville Colony Elementary   Regular School No Elementary KG 08 2019   pk_12_total 19.0                       10.0 9.0                       19.0 19                       10 9                 19
366562 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000059 2 Tripp-Delmont JH   Regular School No Middle 07 08 2019   pk_12_total 16.0     2.0   1.0         1.0   10.0 10.0                       20.0 16     2   1         1   10 10                 20
367516 SD     school 4679350 12003   Willow Lake 12-3 467935001297 6 Collins Colony Elem   Regular School No Elementary KG 08 2019   pk_12_total 19.0                       10.0 9.0                       19.0 19                       10 9                 19
449241 SD     school 4639540 11001   Andes Central 11-1 463954001080 5 Lakeview Colony Elem   Regular School Not applicable Elementary KG 08 2021   pk_12_total 29.0                       10.0 19.0                       29.0 29                       10 19                 29
451946 SD     school 4622560 44001   Eureka 44-1 462256000958 3 Eureka Jr. High   Regular School Not applicable Middle 07 08 2021   pk_12_total 15.0                       10.0 5.0                       15.0 15                       10 5                 15
452009 SD     school 4622940 46002   Faith 46-2 462294000412 4 Maurine Elem.   Regular School Not applicable Elementary KG 08 2021   pk_12_total 17.0                       10.0 7.0                       17.0 17                       10 7                 17
452662 SD     school 4630490 27001   Haakon 27-1 463049000647 8 Milesville Elem   Regular School Not applicable Elementary KG 08 2021   pk_12_total 11.0                       10.0 1.0                       11.0 11                       10 1                 11
453671 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School Not applicable Elementary PK 08 2021   pk_12_total 18.0                       10.0 8.0                       18.0 18                       10 8                 18
489804 SD     school 4619170 56002   Doland 56-2 461917001100 4 Hillside Colony Elementary   Regular School Not applicable Elementary KG 08 2020   pk_12_total 20.0                       10.0 10.0                       20.0 20                       10 10                 20
489885 SD     school 4619410 51001   Douglas 51-1 461941001125 8 Douglas Preschool   Regular School Not applicable Prekindergarten PK PK 2020   pk_12_total 16.0   2.0 1.0             1.0   10.0 10.0                       20.0 16   2 1             1   10 10                 20
492825 SD     school 4641640 44002   Leola 44-2 464164001069 6 Grassland Colony Elem   Regular School Not applicable Elementary KG 08 2020   pk_12_total 18.0                       10.0 8.0                       18.0 18                       10 8                 18
493053 SD     school 4601026 43007   McCook Central 43-7 460102601281 4 Golden View Colony Elementary   Regular School Not applicable Elementary KG 08 2020   pk_12_total 25.0                       10.0 15.0                       25.0 25                       10 15                 25
494206 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701112 4 Spring Lake Colony Elementary   Regular School Not applicable Elementary KG 08 2020   pk_12_total 29.0                       10.0 19.0                       29.0 29                       10 19                 29
494604 SD     school 4680438 11005   Platte-Geddes 11-5 468043801267 10 Platte Colony School   Regular School Not applicable Elementary KG 08 2020   pk_12_total 23.0                       10.0 13.0                       23.0 23                       10 13                 23
495990 SD     school 4666270 49005   Sioux Falls 49-5 466627001133 48 Summit Oaks Residential Program   Alternative School Not applicable Other KG 12 2020   pk_12_total 23.0     4.0             2.0   10.0 19.0                       29.0 23     4             2   10 19                 29
2966000 SD     school 4600046 56006   Hitchcock-Tulare 460004601165 3 Spink Colony Elem   Regular School No 1 KG 08 2015   pk_12_total 21.0                       10.0 11.0                       21.0 21                       10 11                 21
2966653 SD     school 4638220 7002   Kimball 07-2 463822001185 15 Grass Ranch Colony High School   Regular School No 3 09 12 2015   pk_12_total 15.0                       10.0 5.0                       15.0 15                       10 5                 15
2966769 SD     school 4640860 45005   Langford Area 464086001097 4 Newport Colony Elem   Regular School No 1 KG 08 2015   pk_12_total 21.0                       10.0 11.0                       21.0 21                       10 11                 21
2967037 SD     school 4641640 44002   Leola 44-2 464164000919 3 Leola MS   Regular School No 2 07 08 2015   pk_12_total 12.0                       10.0 2.0                       12.0 12                       10 2                 12
2968194 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2015   pk_12_total       14.0                 10.0 4.0                       14.0       14                 10 4                 14
2968256 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701035 3 Oldham-Ramona Junior High School   Regular School No 2 07 08 2015   pk_12_total 13.0                       10.0 3.0                       13.0 13                       10 3                 13
2968257 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701112 4 Spring Lake Colony Elementary   Regular School No 1 KG 08 2015   pk_12_total 26.0                       10.0 16.0                       26.0 26                       10 16                 26
2968394 SD     school 4654300 33003   Parkston 33-3 465430000490 8 New Elm Spring Colony Elem   Regular School No 1 KG 08 2015   pk_12_total 26.0                       10.0 16.0                       26.0 26                       10 16                 26
2970551 SD     school 4666930 40002   Spearfish 40-2 466693001347 10 Black Hills Academy at Canyon Hills H.S.   Alternative Education School No 3 09 12 2015   pk_12_total 10.0   1.0 5.0                 10.0 6.0                       16.0 10   1 5                 10 6                 16
3009889 SD     school 4629340 25003   Grant-Deuel 25-3 462934000236 1 Grant-Deuel High School   Regular School No High 09 12 2017   pk_12_total 17.0                       10.0 7.0                       17.0 17                       10 7                 17
3010046 SD     school 4630490 27001   Haakon 27-1 463049000647 8 Milesville Elem   Regular School No Elementary KG 08 2017   pk_12_total 14.0                       10.0 4.0                       14.0 14                       10 4                 14
3011426 SD     school 4639990 38003   Lake Preston 38-3 463999000918 3 Lake Preston Jr High   Regular School No Middle 07 08 2017   pk_12_total 20.0                   1.0   10.0 11.0                       21.0 20                   1   10 11                 21
3013103 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701112 4 Spring Lake Colony Elementary   Regular School No Elementary KG 08 2017   pk_12_total 30.0                       10.0 20.0                       30.0 30                       10 20                 30
3014870 SD     school 4666270 49005   Sioux Falls 49-5 466627001133 48 Summit Oaks Residential Program   Alternative School No Other 05 12 2017   pk_12_total 21.0 2.0 2.0 4.0                 10.0 19.0                       29.0 21 2 2 4                 10 19                 29
3015208 SD     school 4666930 40002   Spearfish 40-2 466693001347 10 Black Hills Academy at Canyon Hills H.S.   Alternative School No High 09 12 2017   pk_12_total 10.0     7.0                 10.0 7.0                       17.0 10     7                 10 7                 17
3344649 SD     school 4604270 4001   Avon 04-1 460427001325 6 Avon PK   Regular School No 1 PK PK 2016   pk_12_total 14.0   1.0                   10.0 5.0                       15.0 14   1                   10 5                 15
3344954 SD     school 4607050 52001   Bison 52-1 460705000879 4 Bison JH   Regular School No 2 07 08 2016   pk_12_total 18.0                       10.0 8.0                       18.0 18                       10 8                 18
3345399 SD     school 4600041 45004   Britton-Hecla 45-4 460004101180 5 Westwood Colony   Regular School No 1 KG 08 2016   pk_12_total 17.0                       10.0 7.0                       17.0 17                       10 7                 17
3348103 SD     school 4602640 30001   Hanson 30-1 460264000875 5 Oaklane Colony   Regular School No 1 KG 08 2016   pk_12_total 22.0   1.0                   10.0 13.0                       23.0 22   1                   10 13                 23
3348580 SD     school 4600046 56006   Hitchcock-Tulare 460004601166 4 Glendale Colony Elem   Regular School No 1 KG 08 2016   pk_12_total 19.0                       10.0 9.0                       19.0 19                       10 9                 19
3348919 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School No 1 PK 08 2016   pk_12_total 21.0                       10.0 11.0                       21.0 21                       10 11                 21
3350313 SD     school 4647942 29004   Miller 464794200431 11 Millerdale Colony Elem   Regular School No 1 KG 08 2016   pk_12_total 18.0                       10.0 8.0                       18.0 18                       10 8                 18
3350422 SD     school 4648390 17002   Mitchell 17-2 464839000445 11 Rosedale Colony Elem   Regular School No 1 KG 08 2016   pk_12_total 16.0   1.0                   10.0 7.0                       17.0 16   1                   10 7                 17
3351945 SD     school 4664140 39004   Rutland 39-4 466414000932 3 Rutland Jr Hi   Regular School No 2 07 08 2016   pk_12_total 16.0     1.0                 10.0 7.0                       17.0 16     1                 10 7                 17
3352749 SD     school 4666270 49005   Sioux Falls 49-5 466627000609 40 Summit Oaks Day Program   Special Education School No 4 KG 12 2016   pk_12_total 7.0 4.0 1.0 2.0             3.0   10.0 7.0                       17.0 7 4 1 2             3   10 7                 17
252723 SD     school 4621390 5003   Elkton 05-3 462139000187 2 Elkton Elementary School   Regular School No Elementary PK 06 2018   pk_12_total 141.0   38.0               9.0   100.0 88.0                       188.0 141   38               9   100 88                 188
456649 SD     school 4660450 56004   Redfield 56-4 466045000552 1 Redfield High School   Regular School Not applicable High 09 12 2021   pk_12_total 1.0 6.0 6.0 3.0             163.0   100.0 78.0                       178.0 1 6 6 3             163   100 78                 178
490160 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000186 1 Elk Point Jefferson High School   Regular School Not applicable High 09 12 2020   pk_12_total 186.0 1.0 11.0     1.0         3.0   100.0 102.0                       202.0 186 1 11     1         3   100 102                 202
496543 SD     school 4671880 20003   Timber Lake 20-3 467188000664 2 Timber Lake Elementary K-5   Regular School Not applicable Elementary PK 05 2020   pk_12_total 77.0   2.0 100.0                 100.0 79.0                       179.0 77   2 100                 100 79                 179
2970336 SD     school 4600053 54002   Sisseton 54-2 460005301258 2 Sisseton Middle School   Regular School No 2 06 08 2015   pk_12_total 60.0 1.0 6.0 105.0             3.0   100.0 75.0                       175.0 60 1 6 105             3   100 75                 175
3006558 SD     school 4639540 11001   Andes Central 11-1 463954000359 2 Andes Central Elementary   Regular School No Elementary PK 06 2017   pk_12_total 41.0   8.0 110.0           1.0 24.0   100.0 84.0                       184.0 41   8 110           1 24   100 84                 184
3009744 SD     school 4626370 49004   Garretson 49-4 462637000223 2 Garretson Elementary   Regular School No Elementary PK 05 2017   pk_12_total 185.0   9.0 3.0   1.0         18.0   100.0 116.0                       216.0 185   9 3   1         18   100 116                 216
3010187 SD     school 4602640 30001   Hanson 30-1 460264000876 6 Hanson Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 191.0   5.0               4.0   100.0 100.0                       200.0 191   5               4   100 100                 200
3011678 SD     school 4641550 41004   Lennox 41-4 464155001363 9 Lennox Intermediate   Regular School No Middle 05 06 2017   pk_12_total 172.0 2.0 7.0 3.0             2.0   100.0 86.0                       186.0 172 2 7 3             2   100 86                 186
365708 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2019   pk_12_total 1050.0 357.0 238.0 76.0   137.0       1.0 61.0   1000.0 920.0                       1920.0 1050 357 238 76   137       1 61   1000 920                 1920
259988 SD     school 4677460 36002   Wessington Springs 36-2 467746000732 2 Wessington Springs Elem   Regular School No Elementary PK 06 2018   pk_12_total 171.0   9.0                   101.0 79.0                       180.0 171   9                   101 79                 180
362465 SD     school 4641550 41004   Lennox 41-4 464155000963 8 Lennox Jr. High   Regular School No Middle 07 08 2019   pk_12_total 176.0 1.0 6.0 2.0             3.0   101.0 87.0                       188.0 176 1 6 2             3   101 87                 188
454728 SD     school 4646380 15002   McLaughlin 15-2 464638000415 2 McLaughlin Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 6.0   2.0 186.0             3.0   101.0 96.0                       197.0 6   2 186             3   101 96                 197
455303 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100449 1 Mobridge High School   Regular School Not applicable High 09 12 2021   pk_12_total 109.0   5.0 71.0             11.0   101.0 95.0                       196.0 109   5 71             11   101 95                 196
459529 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School Not applicable High 09 12 2021   pk_12_total 152.0 1.0 2.0 47.0   1.0             101.0 102.0                       203.0 152 1 2 47   1             101 102                 203
489472 SD     school 4636990 61008   Dakota Valley 61-8 463699001075 4 Dakota Valley Upper Elem   Regular School Not applicable Elementary 04 05 2020   pk_12_total 175.0 3.0 17.0 3.0   5.0       1.0 9.0   101.0 112.0                       213.0 175 3 17 3   5       1 9   101 112                 213
491777 SD     school 4634480 23002   Hot Springs 23-2 463448000911 6 Hot Springs Middle Sch   Regular School Not applicable Middle 06 08 2020   pk_12_total 133.0 2.0 11.0 15.0   2.0         23.0   101.0 85.0                       186.0 133 2 11 15   2         23   101 85                 186
2963292 SD     school 4612300 39001   Chester Area 39-1 461230000131 2 Chester Area Elementary School   Regular School No 1 PK 05 2015   pk_12_total 202.0 1.0 2.0 4.0             3.0   101.0 111.0                       212.0 202 1 2 4             3   101 111                 212
2963664 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School No 2 07 08 2015   pk_12_total 167.0 3.0 13.0 1.0   2.0         8.0   101.0 93.0                       194.0 167 3 13 1   2         8   101 93                 194
2966050 SD     school 4634480 23002   Hot Springs 23-2 463448000911 6 Hot Springs Middle Sch   Regular School No 2 06 08 2015   pk_12_total 158.0 6.0 3.0 22.0   1.0       1.0 1.0   101.0 91.0                       192.0 158 6 3 22   1       1 1   101 91                 192
2966832 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000374 1 Lead-Deadwood High School   Regular School No 3 09 12 2015   pk_12_total 193.0 1.0 11.0     2.0         3.0   101.0 109.0                       210.0 193 1 11     2         3   101 109                 210
2970623 SD     school 4624850 57001   Stanley County 57-1 462485000213 8 Stanley County Elementary   Regular School No 1 KG 05 2015   pk_12_total 145.0 2.0 3.0 33.0             8.0   101.0 90.0                       191.0 145 2 3 33             8   101 90                 191
3015279 SD     school 4624850 57001   Stanley County 57-1 462485000213 8 Stanley County Elementary   Regular School No Elementary KG 05 2017   pk_12_total 152.0 2.0 3.0 20.0           1.0 14.0   101.0 91.0                       192.0 152 2 3 20           1 14   101 91                 192
3349863 SD     school 4601026 43007   McCook Central 43-7 460102600404 2 McCook Central Elementary   Regular School No 1 PK 05 2016   pk_12_total 175.0   5.0               4.0   101.0 83.0                       184.0 175   5               4   101 83                 184
3014854 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No High 09 12 2017   pk_12_total 1440.0 196.0 119.0 93.0   59.0         72.0   1010.0 969.0                       1979.0 1440 196 119 93   59         72   1010 969                 1979
253953 SD     school 4631350 41002   Harrisburg 41-2 463135001375 9 Horizon Elementary   Regular School No Elementary KG 05 2018   pk_12_total 177.0 8.0 8.0     5.0         7.0   102.0 103.0                       205.0 177 8 8     5         7   102 103                 205
454631 SD     school 4601026 43007   McCook Central 43-7 460102600404 2 McCook Central Elementary   Regular School Not applicable Elementary PK 04 2021   pk_12_total 156.0   9.0               8.0   102.0 71.0                       173.0 156   9               8   102 71                 173
457657 SD     school 4666300 5005   Sioux Valley 05-5 466630000612 1 Sioux Valley High School   Regular School Not applicable High 09 12 2021   pk_12_total 175.0   10.0     2.0         9.0   102.0 94.0                       196.0 175   10     2         9   102 94                 196
3009792 SD     school 4626490 63001   Gayville-Volin 63-1 462649000228 2 Gayville-Volin Elementary   Regular School No Elementary PK 06 2017   pk_12_total 167.0   14.0               6.0   102.0 85.0                       187.0 167   14               6   102 85                 187
3348634 SD     school 4634480 23002   Hot Springs 23-2 463448000911 6 Hot Springs Middle Sch   Regular School No 2 06 08 2016   pk_12_total 151.0 4.0 5.0 23.0   4.0       1.0 3.0   102.0 89.0                       191.0 151 4 5 23   4       1 3   102 89                 191
3354696 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000783 2 Wolsey-Wessington Elementary   Regular School No 1 PK 06 2016   pk_12_total 187.0 6.0 15.0               10.0   102.0 116.0                       218.0 187 6 15               10   102 116                 218
495974 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School Not applicable High 09 12 2020   pk_12_total 1432.0 212.0 163.0 109.0   58.0       1.0 77.0   1021.0 1031.0                       2052.0 1432 212 163 109   58       1 77   1021 1031                 2052

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