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:
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