Name: COVID19 Dashboard Stats

Display Field: Date

Type: Table

Geometry Type: N/A

Description:

Service Item Id: bc70625b06f2431389384cc0bbac1b5d

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Date ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date )
• CurrentData ( type: esriFieldTypeString, alias: CurrentData, editable: true, nullable: false, length: 10, defaultValue: No, modelName: CurrentData , Coded Values: [Yes: Yes] , [No: No] )
• NewCases ( type: esriFieldTypeInteger, alias: NewCases, editable: true, nullable: true, defaultValue: null, modelName: NewCases )
• ConfirmedCases ( type: esriFieldTypeInteger, alias: ConfirmedCases, editable: true, nullable: true, defaultValue: null, modelName: ConfirmedCases )
• ActiveCases ( type: esriFieldTypeInteger, alias: ActiveCases, editable: true, nullable: true, defaultValue: null, modelName: ActiveCases )
• CurrentHospitalized ( type: esriFieldTypeInteger, alias: CurrentHospitalized, editable: true, nullable: true, defaultValue: null, modelName: CurrentHospitalized )
• CumulativeHospitalized ( type: esriFieldTypeInteger, alias: CumulativeHospitalized, editable: true, nullable: true, defaultValue: null, modelName: CumulativeHospitalized )
• PercentHospitalized ( type: esriFieldTypeDouble, alias: PercentHospitalized, editable: true, nullable: true, defaultValue: null, modelName: PercentHospitalized )
• PersonsMonitored ( type: esriFieldTypeInteger, alias: PersonsMonitored, editable: true, nullable: true, defaultValue: null, modelName: PersonsMonitored )
• PersonsRecovered ( type: esriFieldTypeInteger, alias: PersonsRecovered, editable: true, nullable: true, defaultValue: null, modelName: PersonsRecovered )
• PersonsDeceased ( type: esriFieldTypeInteger, alias: PersonsDeceased, editable: true, nullable: true, defaultValue: null, modelName: PersonsDeceased )
• TotalTests ( type: esriFieldTypeInteger, alias: TotalTests, editable: true, nullable: true, defaultValue: null, modelName: TotalTests )
• TotalTestsAsOfDate ( type: esriFieldTypeDate, alias: TotalTestsAsOfDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TotalTestsAsOfDate )
• AgeLessThan1 ( type: esriFieldTypeInteger, alias: AgeLessThan1, editable: true, nullable: true, defaultValue: null, modelName: AgeLessThan1 )
• Age1to10 ( type: esriFieldTypeInteger, alias: Age1to10, editable: true, nullable: true, defaultValue: null, modelName: Age1to10 )
• Age11to19 ( type: esriFieldTypeInteger, alias: Age11to19, editable: true, nullable: true, defaultValue: null, modelName: Age11to19 )
• Age20to29 ( type: esriFieldTypeInteger, alias: Age20to29, editable: true, nullable: true, defaultValue: null, modelName: Age20to29 )
• Age30to39 ( type: esriFieldTypeInteger, alias: Age30to39, editable: true, nullable: true, defaultValue: null, modelName: Age30to39 )
• Age40to49 ( type: esriFieldTypeInteger, alias: Age40to49, editable: true, nullable: true, defaultValue: null, modelName: Age40to49 )
• Age50to59 ( type: esriFieldTypeInteger, alias: Age50to59, editable: true, nullable: true, defaultValue: null, modelName: Age50to59 )
• Age60to64 ( type: esriFieldTypeInteger, alias: Age60to64, editable: true, nullable: true, defaultValue: null, modelName: Age60to64 )
• Age65to69 ( type: esriFieldTypeInteger, alias: Age65to69, editable: true, nullable: true, defaultValue: null, modelName: Age65to69 )
• Age70to74 ( type: esriFieldTypeInteger, alias: Age70to74, editable: true, nullable: true, defaultValue: null, modelName: Age70to74 )
• Age75to79 ( type: esriFieldTypeInteger, alias: Age75to79, editable: true, nullable: true, defaultValue: null, modelName: Age75to79 )
• Age80orMore ( type: esriFieldTypeInteger, alias: Age80orMore, editable: true, nullable: true, defaultValue: null, modelName: Age80orMore )
• AgeUnknown ( type: esriFieldTypeInteger, alias: AgeUnknown, editable: true, nullable: true, defaultValue: null, modelName: AgeUnknown )
• Male ( type: esriFieldTypeInteger, alias: Male, editable: true, nullable: true, defaultValue: null, modelName: Male )
• Female ( type: esriFieldTypeInteger, alias: Female, editable: true, nullable: true, defaultValue: null, modelName: Female )
• Hispanic ( type: esriFieldTypeInteger, alias: Hispanic, editable: true, nullable: true, defaultValue: null, modelName: Hispanic )
• WhiteNonHispanic ( type: esriFieldTypeInteger, alias: WhiteNonHispanic, editable: true, nullable: true, defaultValue: null, modelName: WhiteNonHispanic )
• BlackNonHispanic ( type: esriFieldTypeInteger, alias: BlackNonHispanic, editable: true, nullable: true, defaultValue: null, modelName: BlackNonHispanic )
• RaceOther ( type: esriFieldTypeInteger, alias: RaceOther, editable: true, nullable: true, defaultValue: null, modelName: RaceOther )
• RaceUnknown ( type: esriFieldTypeInteger, alias: RaceUnknown, editable: true, nullable: true, defaultValue: null, modelName: RaceUnknown )
• HospitalBeds ( type: esriFieldTypeInteger, alias: HospitalBeds, editable: true, nullable: true, defaultValue: 521, modelName: HospitalBeds )
• Ventilators ( type: esriFieldTypeInteger, alias: Ventilators, editable: true, nullable: true, defaultValue: 70, modelName: Ventilators )
• VentilatorsInUse ( type: esriFieldTypeInteger, alias: VentilatorsInUse, editable: true, nullable: true, defaultValue: null, modelName: VentilatorsInUse )
• VentilatorsInUseCOVID ( type: esriFieldTypeInteger, alias: VentilatorsInUseCOVID, editable: true, nullable: true, defaultValue: null, modelName: VentilatorsInUseCOVID )
• ICUBeds ( type: esriFieldTypeInteger, alias: ICUBeds, editable: true, nullable: true, defaultValue: 54, modelName: ICUBeds )
• ICUBedsInUse ( type: esriFieldTypeInteger, alias: ICUBedsInUse, editable: true, nullable: true, defaultValue: null, modelName: ICUBedsInUse )
• NegativePressure ( type: esriFieldTypeInteger, alias: NegativePressure, editable: true, nullable: true, defaultValue: 27, modelName: NegativePressure )
• NegativePressureInUse ( type: esriFieldTypeInteger, alias: NegativePressureInUse, editable: true, nullable: true, defaultValue: null, modelName: NegativePressureInUse )
• DeathAge0to19 ( type: esriFieldTypeInteger, alias: DeathAge0to19, editable: true, nullable: true, defaultValue: null, modelName: DeathAge0to19 )
• DeathAge20to29 ( type: esriFieldTypeInteger, alias: DeathAge20to29, editable: true, nullable: true, defaultValue: null, modelName: DeathAge20to29 )
• DeathAge30to39 ( type: esriFieldTypeInteger, alias: DeathAge30to39, editable: true, nullable: true, defaultValue: null, modelName: DeathAge30to39 )
• DeathAge40to49 ( type: esriFieldTypeInteger, alias: DeathAge40to49, editable: true, nullable: true, defaultValue: null, modelName: DeathAge40to49 )
• DeathAge50to59 ( type: esriFieldTypeInteger, alias: DeathAge50to59, editable: true, nullable: true, defaultValue: null, modelName: DeathAge50to59 )
• DeathAge60orMore ( type: esriFieldTypeInteger, alias: DeathAge60orMore, editable: true, nullable: true, defaultValue: null, modelName: DeathAge60orMore )
• DeathMale ( type: esriFieldTypeInteger, alias: DeathMale, editable: true, nullable: true, defaultValue: null, modelName: DeathMale )
• DeathFemale ( type: esriFieldTypeInteger, alias: DeathFemale, editable: true, nullable: true, defaultValue: null, modelName: DeathFemale )
• DeathWhiteHispanic ( type: esriFieldTypeInteger, alias: DeathWhiteHispanic, editable: true, nullable: true, defaultValue: null, modelName: DeathWhiteHispanic )
• DeathWhiteNonHispanic ( type: esriFieldTypeInteger, alias: DeathWhiteNonHispanic, editable: true, nullable: true, defaultValue: null, modelName: DeathWhiteNonHispanic )
• DeathBlackHispanic ( type: esriFieldTypeInteger, alias: DeathBlackHispanic, editable: true, nullable: true, defaultValue: null, modelName: DeathBlackHispanic )
• DeathBlackNonHispanic ( type: esriFieldTypeInteger, alias: DeathBlackNonHispanic, editable: true, nullable: true, defaultValue: null, modelName: DeathBlackNonHispanic )
• DeathRaceOther ( type: esriFieldTypeInteger, alias: DeathRaceOther, editable: true, nullable: true, defaultValue: null, modelName: DeathRaceOther )
• DeathRaceUnknown ( type: esriFieldTypeInteger, alias: DeathRaceUnknown, editable: true, nullable: true, defaultValue: null, modelName: DeathRaceUnknown )
• RecoveredAge0to19 ( type: esriFieldTypeInteger, alias: RecoveredAge0to19, editable: true, nullable: true, defaultValue: null, modelName: RecoveredAge0to19 )
• RecoveredAge20to29 ( type: esriFieldTypeInteger, alias: RecoveredAge20to29, editable: true, nullable: true, defaultValue: null, modelName: RecoveredAge20to29 )
• RecoveredAge30to39 ( type: esriFieldTypeInteger, alias: RecoveredAge30to39, editable: true, nullable: true, defaultValue: null, modelName: RecoveredAge30to39 )
• RecoveredAge40to49 ( type: esriFieldTypeInteger, alias: RecoveredAge40to49, editable: true, nullable: true, defaultValue: null, modelName: RecoveredAge40to49 )
• RecoveredAge50to59 ( type: esriFieldTypeInteger, alias: RecoveredAge50to59, editable: true, nullable: true, defaultValue: null, modelName: RecoveredAge50to59 )
• RecoveredAge60orMore ( type: esriFieldTypeInteger, alias: RecoveredAge60orMore, editable: true, nullable: true, defaultValue: null, modelName: RecoveredAge60orMore )
• RecoveredMale ( type: esriFieldTypeInteger, alias: RecoveredMale, editable: true, nullable: true, defaultValue: null, modelName: RecoveredMale )
• RecoveredFemale ( type: esriFieldTypeInteger, alias: RecoveredFemale, editable: true, nullable: true, defaultValue: null, modelName: RecoveredFemale )
• RecoveredWhiteHispanic ( type: esriFieldTypeInteger, alias: RecoveredWhiteHispanic, editable: true, nullable: true, defaultValue: null, modelName: RecoveredWhiteHispanic )
• RecoveredWhiteNonHispanic ( type: esriFieldTypeInteger, alias: RecoveredWhiteNonHispanic, editable: true, nullable: true, defaultValue: null, modelName: RecoveredWhiteNonHispanic )
• RecoveredBlackHispanic ( type: esriFieldTypeInteger, alias: RecoveredBlackHispanic, editable: true, nullable: true, defaultValue: null, modelName: RecoveredBlackHispanic )
• RecoveredBlackNonHispanic ( type: esriFieldTypeInteger, alias: RecoveredBlackNonHispanic, editable: true, nullable: true, defaultValue: null, modelName: RecoveredBlackNonHispanic )
• RecoveredRaceOther ( type: esriFieldTypeInteger, alias: RecoveredRaceOther, editable: true, nullable: true, defaultValue: null, modelName: RecoveredRaceOther )
• RecoveredRaceUnknown ( type: esriFieldTypeInteger, alias: RecoveredRaceUnknown, editable: true, nullable: true, defaultValue: null, modelName: RecoveredRaceUnknown )
• NewCasesConfirmed ( type: esriFieldTypeInteger, alias: NewCasesConfirmed, editable: true, nullable: true, defaultValue: null, modelName: NewCasesConfirmed )
• NewCasesProbable ( type: esriFieldTypeInteger, alias: NewCasesProbable, editable: true, nullable: true, defaultValue: null, modelName: NewCasesProbable )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: COVID19 Dashboard Stats
  Description:
  Prototype:
  NewCasesProbable: null
  NewCasesConfirmed: null
  Date: null
  CurrentData: No
  NewCases: null
  ConfirmedCases: null
  ActiveCases: null
  CurrentHospitalized: null
  CumulativeHospitalized: null
  PercentHospitalized: null
  PersonsMonitored: null
  PersonsRecovered: null
  PersonsDeceased: null
  TotalTests: null
  TotalTestsAsOfDate: null
  AgeLessThan1: null
  Age1to10: null
  Age11to19: null
  Age20to29: null
  Age30to39: null
  Age40to49: null
  Age50to59: null
  Age60to64: null
  Age65to69: null
  Age70to74: null
  Age75to79: null
  Age80orMore: null
  AgeUnknown: null
  Male: null
  Female: null
  Hispanic: null
  WhiteNonHispanic: null
  BlackNonHispanic: null
  RaceOther: null
  RaceUnknown: null
  HospitalBeds: 521
  Ventilators: 70
  VentilatorsInUse: null
  VentilatorsInUseCOVID: null
  ICUBeds: 54
  ICUBedsInUse: null
  NegativePressure: 27
  NegativePressureInUse: null
  DeathAge0to19: null
  DeathAge20to29: null
  DeathAge30to39: null
  DeathAge40to49: null
  DeathAge50to59: null
  DeathAge60orMore: null
  DeathMale: null
  DeathFemale: null
  DeathWhiteHispanic: null
  DeathWhiteNonHispanic: null
  DeathBlackHispanic: null
  DeathBlackNonHispanic: null
  DeathRaceOther: null
  DeathRaceUnknown: null
  RecoveredAge0to19: null
  RecoveredAge20to29: null
  RecoveredAge30to39: null
  RecoveredAge40to49: null
  RecoveredAge50to59: null
  RecoveredAge60orMore: null
  RecoveredMale: null
  RecoveredFemale: null
  RecoveredWhiteHispanic: null
  RecoveredWhiteNonHispanic: null
  RecoveredBlackHispanic: null
  RecoveredBlackNonHispanic: null
  RecoveredRaceOther: null
  RecoveredRaceUnknown: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata