Name: Cases

Display Field: name

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

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:

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)
• deaths (type: esriFieldTypeInteger, alias: Total COVID 19 Associated Deaths, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesmale (type: esriFieldTypeInteger, alias: Male case count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesfemale (type: esriFieldTypeInteger, alias: Female case count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casessexother (type: esriFieldTypeInteger, alias: Gender Unknown case count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesagerange1 (type: esriFieldTypeInteger, alias: Under 18 case count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesagerange2 (type: esriFieldTypeInteger, alias: 18-40 case count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesagerange3 (type: esriFieldTypeInteger, alias: 41-64 case count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesagerange4 (type: esriFieldTypeInteger, alias: 65 Plus case count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deathsmale (type: esriFieldTypeInteger, alias: Male deaths count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deathsfemale (type: esriFieldTypeInteger, alias: Female deaths count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hospitalized (type: esriFieldTypeInteger, alias: Ever Hospitalized, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hospitalizedother (type: esriFieldTypeInteger, alias: Hospitalized Unknown, SQL Type: sqlTypeOther, nullable: true, editable: true)
• positiveincrease (type: esriFieldTypeInteger, alias: New Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deathsincrease (type: esriFieldTypeInteger, alias: New Deaths, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Cumulative_Cases (type: esriFieldTypeInteger, alias: Total Lab-Confirmed Cases, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Facility_Confirmed_Cases (type: esriFieldTypeInteger, alias: Facility-Associated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Death_Median_Age (type: esriFieldTypeInteger, alias: Median Age at Death, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesracewhite (type: esriFieldTypeInteger, alias: Cases - White, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesraceblack (type: esriFieldTypeInteger, alias: Cases - Black, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesraceasian (type: esriFieldTypeInteger, alias: Cases - Asian, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesraceother (type: esriFieldTypeInteger, alias: Cases - Race Other, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesraceunknown (type: esriFieldTypeInteger, alias: Cases - Race Unknown, SQL Type: sqlTypeOther, nullable: true, editable: true)
• caseslatinx (type: esriFieldTypeInteger, alias: Cases - Latinx, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hospitalized_pct (type: esriFieldTypeDouble, alias: Ever Hospitalized %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Facility_Confirmed_Cases_pct (type: esriFieldTypeDouble, alias: Facility Associated %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesmale_pct (type: esriFieldTypeDouble, alias: Male Cases %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesfemale_pct (type: esriFieldTypeDouble, alias: Female Cases %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casessexother_pct (type: esriFieldTypeDouble, alias: Unknown Cases %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesagerange1_pct (type: esriFieldTypeDouble, alias: <18 %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesagerange2_pct (type: esriFieldTypeDouble, alias: 18-40 %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesagerange3_pct (type: esriFieldTypeDouble, alias: 41-64 %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesagerange4_pct (type: esriFieldTypeDouble, alias: 65+ %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesracewhite_pct (type: esriFieldTypeDouble, alias: White %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• caseslatinx_pct (type: esriFieldTypeDouble, alias: Latinx %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesraceblack_pct (type: esriFieldTypeDouble, alias: Black/African American %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesraceasian_pct (type: esriFieldTypeDouble, alias: Asian/Pacific Islander %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesraceother_pct (type: esriFieldTypeDouble, alias: Other %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• casesraceunknown_pct (type: esriFieldTypeDouble, alias: Unknown/TBD %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deathsracewhite (type: esriFieldTypeInteger, alias: Deaths - White, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deathsracewhitepct (type: esriFieldTypeDouble, alias: Deaths - White %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deathslatinx (type: esriFieldTypeInteger, alias: Deaths - Latinx, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deathslatinxpct (type: esriFieldTypeDouble, alias: Deaths - Latinx %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deathsraceblack (type: esriFieldTypeInteger, alias: Deaths - Black, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deathsraceblackpct (type: esriFieldTypeDouble, alias: Deaths - Black %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deathsraceasian (type: esriFieldTypeInteger, alias: Deaths - Asian, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deathsraceasianpct (type: esriFieldTypeDouble, alias: Deaths - Asian %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deathsraceother (type: esriFieldTypeInteger, alias: Deaths - Race Other, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deathsraceotherpct (type: esriFieldTypeDouble, alias: Deaths - Race Other %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deathsraceunknown (type: esriFieldTypeInteger, alias: Deaths - Race Unknown, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deathsraceunknownpct (type: esriFieldTypeDouble, alias: Deaths - Race Unknown %, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Cases
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• positive: 0
• negative: 0
• pending: 0
• totaltests: 0
• deaths: 0
• recovered: 0
• active: 0
• casesmale: 0
• casesfemale: 0
• casessexother: 0
• casesagerange1: 0
• casesagerange2: 0
• casesagerange3: 0
• casesagerange4: 0
• casesagerange5: 0
• casesagerange6: 0
• casesagerange7: 0
• casesagerange8: 0
• casesagerange9: 0
• casesagerange10: 0
• casesageother: 0
• deathsmale: 0
• deathsfemale: 0
• deathssexother: 0
• deathsagerange1: 0
• deathsagerange2: 0
• deathsagerange3: 0
• deathsagerange4: 0
• deathsagerange5: 0
• deathsagerange6: 0
• deathsagerange7: 0
• deathsagerange8: 0
• deathsagerange9: 0
• deathsagerange10: 0
• deathsageother: 0
• hospitalized: 0
• nothospitalized: 0
• hospitalizedother: 0
• hospitalizedmale: 0
• hospitalizedfemale: 0
• hospitalizedsexother: 0
• hospitalizedagerange1: 0
• hospitalizedagerange2: 0
• hospitalizedagerange3: 0
• hospitalizedagerange4: 0
• hospitalizedagerange5: 0
• hospitalizedagerange6: 0
• hospitalizedagerange7: 0
• hospitalizedagerange8: 0
• hospitalizedagerange9: 0
• hospitalizedagerange10: 0
• hospitalizedageother: 0
• positiveincrease: 0
• totaltestsincrease: 0
• deathsincrease: 0
• hospitalizedincrease: 0
• sourceclosecontact: 0
• sourcepossibletravel: 0
• sourceunderinvestigation: 0
• sourceTravel: 0
• sourcecommunity: 0
• sourceother: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/30/2020 6:45:05 AM

Schema Last Edit Date: 4/30/2020 6:45:05 AM

Data Last Edit Date: 4/30/2020 6:45:05 AM

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