Name: South Dakota Case Data

Display Field: name

Type: Table

Description: <div>A feature layer containing COVID-19 case data for South Dakota.</div><div><br /></div><div><div>Data was updated based on case information from the <a href="https://doh.sd.gov/news/Coronavirus.aspx" target="_blank">South Dakota Department of Health</a> and ranges from March 8, 2020 to April 19 2023.<br /></div><div><br /></div><p style="margin-top:0px; margin-bottom:0.75rem; max-width:100%;"><span style="max-width:100%; display:inherit;"></span></p><div><div>Notes: </div><div>- According to the State of SD Department of Health, on June 20 2020, in reviewing addresses a number of addresses were realigned from Minnehaha to Lincoln County, resulting in a negative daily case number for Minnehaha.</div><div><div><div>- No records will exist on November 26, 2020 as the State of SD Department of Health did not post any new updates that day.  Instead case data for November 27, 2020 includes records for the 26th and the 27th.</div><div>- No records will exist on December 25, 2020 as the State of SD Department of Health did not post any new updates that day.  Instead case data for December 26, 2020 includes records for the 25th and the 26th. </div></div><div>- No records will exist on January 1, 2021 as the State of SD Department of Health did not post any new updates that day.  Instead case data for January 2, 2021 includes records for the 1st and the 2nd. </div></div></div></div>

Copyright Text: City of Sioux Falls

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• reportdt (type: esriFieldTypeDate, alias: Date Reported, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• confirmed (type: esriFieldTypeInteger, alias: Confirmed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• recovered (type: esriFieldTypeInteger, alias: Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deaths (type: esriFieldTypeInteger, alias: Deaths, SQL Type: sqlTypeOther, nullable: true, editable: true)
• active (type: esriFieldTypeInteger, alias: Active, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• tested (type: esriFieldTypeInteger, alias: Tested, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Negative (type: esriFieldTypeInteger, alias: Negative, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pending (type: esriFieldTypeInteger, alias: Pending, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MaleCases (type: esriFieldTypeInteger, alias: Male Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FemaleCases (type: esriFieldTypeInteger, alias: Female Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cases0to19 (type: esriFieldTypeInteger, alias: Ages 0 to 19, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cases20to29 (type: esriFieldTypeInteger, alias: Ages 20 to 29, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cases30to39 (type: esriFieldTypeInteger, alias: Ages 30 to 39, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cases40to49 (type: esriFieldTypeInteger, alias: Ages 40 to 49, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cases50to59 (type: esriFieldTypeInteger, alias: Ages 50 to 59, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cases60to69 (type: esriFieldTypeInteger, alias: Ages 60 to 69, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cases70to79 (type: esriFieldTypeInteger, alias: Ages 70 to 79, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cases80plus (type: esriFieldTypeInteger, alias: Ages 80 plus, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NewCases (type: esriFieldTypeInteger, alias: New Daily Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MaleDeaths (type: esriFieldTypeInteger, alias: Male Deaths, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FemaleDeaths (type: esriFieldTypeInteger, alias: Female Deaths, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Deaths0to19 (type: esriFieldTypeInteger, alias: Deaths 0 to 19, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Deaths20to29 (type: esriFieldTypeInteger, alias: Deaths 20 to 29, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Deaths30to39 (type: esriFieldTypeInteger, alias: Deaths 30 to 39, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Deaths40to49 (type: esriFieldTypeInteger, alias: Deaths 40 to 49, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Deaths50to59 (type: esriFieldTypeInteger, alias: Deaths 50 to 59, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Deaths60to69 (type: esriFieldTypeInteger, alias: Deaths 60 to 69, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Deaths70to79 (type: esriFieldTypeInteger, alias: Deaths 70 to 79, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Deaths80plus (type: esriFieldTypeInteger, alias: Deaths 80 plus, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AsianCases (type: esriFieldTypeInteger, alias: Asian Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BlackCases (type: esriFieldTypeInteger, alias: Black Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HispanicCases (type: esriFieldTypeInteger, alias: Hispanic Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NativeAmCases (type: esriFieldTypeInteger, alias: Native American Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OtherCases (type: esriFieldTypeInteger, alias: Other Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WhiteCases (type: esriFieldTypeInteger, alias: White Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CurrentlyHospitalizedCases (type: esriFieldTypeInteger, alias: Currently Hospitalized, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PercAsianCases (type: esriFieldTypeDouble, alias: PercAsianCases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PercBlackCases (type: esriFieldTypeDouble, alias: PercBlackCases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PercHispanicCases (type: esriFieldTypeDouble, alias: PercHispanicCases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PercNativeAmCases (type: esriFieldTypeDouble, alias: PercNativeAmCases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PercOtherCases (type: esriFieldTypeDouble, alias: PercOtherCases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PercWhiteCases (type: esriFieldTypeDouble, alias: PercWhiteCases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PercPopAsianCases (type: esriFieldTypeDouble, alias: PercPopAsianCases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PercPopBlackCases (type: esriFieldTypeDouble, alias: PercPopBlackCases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PercPopHispanicCases (type: esriFieldTypeDouble, alias: PercPopHispanicCases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PercPopNativeAmCases (type: esriFieldTypeDouble, alias: PercPopNativeAmCases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PercPopOtherCases (type: esriFieldTypeDouble, alias: PercPopOtherCases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PercPopWhiteCases (type: esriFieldTypeDouble, alias: PercPopWhiteCases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NewDailyDeaths (type: esriFieldTypeInteger, alias: New Daily Deaths, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NewDailyTested (type: esriFieldTypeInteger, alias: New Daily Tested, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DailyPercentPositive (type: esriFieldTypeDouble, alias: Daily Percent Positive, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalPercentPositive (type: esriFieldTypeDouble, alias: TotalPercentPositive, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NewDailyNegative (type: esriFieldTypeInteger, alias: New Daily Negatives, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ThreeDayAvg (type: esriFieldTypeDouble, alias: 3-Day Average, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SevenDayAvg (type: esriFieldTypeDouble, alias: 7-Day Average, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cases0to9 (type: esriFieldTypeInteger, alias: Cases 0 to 9, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cases10to19 (type: esriFieldTypeInteger, alias: Cases 10 to 19, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Deaths0to9 (type: esriFieldTypeInteger, alias: Deaths 0 to 9, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Deaths10to19 (type: esriFieldTypeInteger, alias: Deaths 10 to 19, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalDoses (type: esriFieldTypeInteger, alias: Total Doses, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalRecipients (type: esriFieldTypeInteger, alias: Total Recipients, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MalesVaccinated (type: esriFieldTypeInteger, alias: Males Vaccinated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FemalesVaccinated (type: esriFieldTypeInteger, alias: Females Vaccinated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vaccinated0to9 (type: esriFieldTypeInteger, alias: Vaccinated 0 to 9, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vaccinated10to19 (type: esriFieldTypeInteger, alias: Vaccinated 10 to 19, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vaccinated20to29 (type: esriFieldTypeInteger, alias: Vaccinated 20 to 29, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vaccinated30to39 (type: esriFieldTypeInteger, alias: Vaccinated 30 to 39, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vaccinated40to49 (type: esriFieldTypeInteger, alias: Vaccinated 40 to 49, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vaccinated50to59 (type: esriFieldTypeInteger, alias: Vaccinated 50 to 59, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vaccinated60to69 (type: esriFieldTypeInteger, alias: Vaccinated 60 to 69, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vaccinated70to79 (type: esriFieldTypeInteger, alias: Vaccinated 70 to 79, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vaccinated80plus (type: esriFieldTypeInteger, alias: Vaccinated 80 plus, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NewDailyDoses (type: esriFieldTypeInteger, alias: New Daily Doses, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NewDailyRecipients (type: esriFieldTypeInteger, alias: New Daily Recipients, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total1DoseRecipients (type: esriFieldTypeInteger, alias: Total 1 Dose Recipients, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total2DoseRecipients (type: esriFieldTypeInteger, alias: Total 2 Dose Recipients, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalJJDoses (type: esriFieldTypeInteger, alias: Total Johnson-Johnson Doses, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalJJRecipients (type: esriFieldTypeInteger, alias: Total Johnson-Johnson Recipients, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalVaccinated (type: esriFieldTypeInteger, alias: Total Vaccinated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pfizer3DoseRecipients (type: esriFieldTypeInteger, alias: Pfizer 3-Dose Recipients, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Moderna3DoseRecipients (type: esriFieldTypeInteger, alias: Moderna 3-Dose Recipients, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total3DoseRecipients (type: esriFieldTypeInteger, alias: Total 3 Dose Recipients, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PartialVaccinated (type: esriFieldTypeInteger, alias: PartialVaccinated, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: South Dakota Case Data
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/11/2023 4:28:09 PM

Schema Last Edit Date: 5/11/2023 3:26:05 PM

Data Last Edit Date: 5/11/2023 3:26:05 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat