Name: Sioux Falls Case Data
Display Field: name
Type: Table
Description: <span style="font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;">A feature layer containing COVID-19 case data for the Sioux Falls area, includes only Lincoln and Minnehaha Counties.</span><div style="font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;"><br /></div><div style="font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;"><div style="font-family:"Avenir Next", Avenir, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size:15px;">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 style="font-family:"Avenir Next", Avenir, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size:15px;"><br /></div><p style="margin-top:0px; margin-bottom:0.75rem; font-family:"Avenir Next", Avenir, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size:15px; max-width:100%;"><span style="max-width:100%; display:inherit;"></span></p><div style="font-family:"Avenir Next", Avenir, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size:15px;"><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:
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:
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)
- NewCases (type: esriFieldTypeInteger, alias: New Daily Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CurrentlyHospitalizedCases (type: esriFieldTypeInteger, alias: Currently Hospitalized, 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)
- 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)
- 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: Sioux Falls 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:27:48 PM
Schema Last Edit Date: 5/11/2023 3:26:04 PM
Data Last Edit Date: 5/11/2023 3:26:04 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat