Name: Coronavirus Overall Statistics

Display Field: KPI_GROUP1

Type: Table

Geometry Type: N/A

Description: The data in this table includes overall COVID-19 statistics for the District of Columbia. The number of hospital beds and ventilators available and in use are included. The number of positive tests and lives lost from the disease are also broken down by electoral ward and race. In addition, there is data on testing of FEMS, MPD, DOC, DYRS, St. Elizabeths, and shelter employees and residents.

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• DATE_REPORTED ( type: esriFieldTypeDate, alias: Date Reported, length: 8 )
• KPI_GROUP1 ( type: esriFieldTypeString, alias: Testing, length: 100 )
• OVERALL_TESTED_TST ( type: esriFieldTypeInteger, alias: People Tested Overall )
• TOTAL_RESIDENTS_TESTED_TST ( type: esriFieldTypeInteger, alias: Total Residents Tested )
• TOTAL_POSITIVES_TST ( type: esriFieldTypeInteger, alias: Total Positives )
• NO_DEATH_TST ( type: esriFieldTypeInteger, alias: Number of Lives Lost )
• NO_RECOVERED_TST ( type: esriFieldTypeInteger, alias: People Recovered )
• KPI_GROUP2 ( type: esriFieldTypeString, alias: Hospitals, length: 100 )
• TOTAL_ICU_BEDS_HOS ( type: esriFieldTypeInteger, alias: Total ICU Beds in Hospitals )
• ICU_BEDS_AVAILABLE_HOS ( type: esriFieldTypeInteger, alias: ICU Beds Available )
• TOTAL_VENTILATORS_HOS ( type: esriFieldTypeInteger, alias: Total Reported Ventilators in Hospitals )
• VENTILATORS_IN_USE_HOS ( type: esriFieldTypeInteger, alias: In-Use Ventilators in Hospitals )
• VENTILATORS_AVAILABLE_HOS ( type: esriFieldTypeInteger, alias: Ventilators Available in Hospitals )
• KPI_GROUP3 ( type: esriFieldTypeString, alias: Public Safety - FEMS, length: 100 )
• TOTAL_POSITIVE_FEMS ( type: esriFieldTypeInteger, alias: Total Number of FEMS Personnel Who Have Tested Positive )
• TOTAL_POSITIVE_OUT_FEMS ( type: esriFieldTypeInteger, alias: Total Number of FEMS Personnel Who Tested Positive and OUT )
• PERSON_RETRND_TO_WORK_FEMS ( type: esriFieldTypeInteger, alias: Total Number of FEMS Personnel Recovered and Returned to Work )
• PERSON_QUARANTINE_FEMS ( type: esriFieldTypeInteger, alias: Total Number of FEMS Personnel In Quarantine Due to COVID-19 )
• OUT_POSITIVE_QUARANTINE_FEMS ( type: esriFieldTypeInteger, alias: Total Number of FEMS Personnel Out Due to Positive Tests/Quarantine )
• RETURND_TO_WORK_FEMS ( type: esriFieldTypeInteger, alias: Total Number of FEMS Personnel Returned to Work )
• KPI_GROUP4 ( type: esriFieldTypeString, alias: Public Safety - MPD, length: 100 )
• TOTAL_POSITIVE_PSMPD ( type: esriFieldTypeInteger, alias: Total Number of MPD Personnel Who Have Tested Positive )
• TOTAL_POSITIVE_OUT_PSMPD ( type: esriFieldTypeInteger, alias: Total Number of MPD Personnel Who Have Tested Positve and OUT )
• RECOVRD_RETURND_TO_WORK_PSMPD ( type: esriFieldTypeInteger, alias: Total Number of MPD Personnel Recovered and Returned to Work )
• PERSON_QUARANTINE_PSMPD ( type: esriFieldTypeInteger, alias: Total Number of MPD Personnel in Quarantine Due to COVID-19 )
• OUT_POSITIVE_QUARANTINE_PSMPD ( type: esriFieldTypeInteger, alias: Total Number of MPD Personnel Out Due to Positive Tests/Quarantine )
• RETURND_TO_WORK_PSMPD ( type: esriFieldTypeInteger, alias: Total Number of MPD Personnel Returned to Work )
• LIVE_LOST_MPD ( type: esriFieldTypeInteger, alias: Total Number of Lives Lost Among MPD Personnel )
• KPI_GROUP5 ( type: esriFieldTypeString, alias: Public Safety - DOC Personnel, length: 100 )
• TOTAL_POSITIVE_PSDP ( type: esriFieldTypeInteger, alias: Total Number of DOC Personnel Who Have Tested Positive )
• TOTAL_POSITIVE_OUT_PSDP ( type: esriFieldTypeInteger, alias: Total Number of DOC Personnel Tested Positive OUT )
• RECOVRD_RETURND_TO_WORK_PSDP ( type: esriFieldTypeInteger, alias: Total Number of DOC Personnel Recovered aand Returned to Work )
• PERSON_QUARANTINE_PSDP ( type: esriFieldTypeInteger, alias: Total Number of DOC Personnel in Quarantine Due to COVID-19 )
• OUT_POSITIVE_QUARANTINE_PSDP ( type: esriFieldTypeInteger, alias: Total Number of DOC Personnel Out Due to Positive Tests/Quarantine )
• RETURND_TO_WORK_PSDP ( type: esriFieldTypeInteger, alias: Total Number of DOC Personnel Returned to Work )
• LIVE_LOST_PERSONNEL_PSDP ( type: esriFieldTypeInteger, alias: Total Number of DOC Personnel Lives Lost Among DOC Personnel )
• KPI_GROUP6 ( type: esriFieldTypeString, alias: Public Safety - DOC Residents, length: 100 )
• TOTAL_POSITIVE_PSDR ( type: esriFieldTypeInteger, alias: Total Number of DOC Residents Who Have Tested Positive )
• TOTAL_POSITIVE_ISO_PSDR ( type: esriFieldTypeInteger, alias: Total Number of DOC Residents Tested Positive in Isolation )
• RECOVRD_RES_PSDR ( type: esriFieldTypeInteger, alias: Total Number of DOC Residents Recovered )
• RES_QUARANTINE_PSDR ( type: esriFieldTypeInteger, alias: Total Number of DOC Residents in Quarantine Due to COVID-19 )
• OUT_POSITIVE_QUARANTINE_PSDR ( type: esriFieldTypeInteger, alias: Total Number of DOC Residents Out Due to Positive Tests/Quarantine )
• RETURND_TO_GP_PSDR ( type: esriFieldTypeInteger, alias: Total Number of DOC Residents Returned to General Population )
• LIVE_LOST_RES_PSDR ( type: esriFieldTypeInteger, alias: Total Number of DOC Resident Lives Among Residents )
• KPI_GROUP7 ( type: esriFieldTypeString, alias: Public Safety - DYRS Personnel, length: 100 )
• TOTAL_POSITIVE_PSDYP ( type: esriFieldTypeInteger, alias: Total Number of DYRS Personnel Out Who Have Tested Positive )
• TOTAL_POSITIVE_OUT_PSDYP ( type: esriFieldTypeInteger, alias: Total Number of DYRS Personnel Tested Positive OUT )
• RETURND_TO_WORK_PSDYP ( type: esriFieldTypeInteger, alias: Total Number of DYRS Personnel Returned to Work )
• PERSON_QUARANTINE_PSDYP ( type: esriFieldTypeInteger, alias: Total Number of DYRS Personnel in Quarantine Due to COVID-19 )
• OUT_POSITIVE_QUARANTINE_PSDYP ( type: esriFieldTypeInteger, alias: Total Number of DYRS Personnel Out Due to Positive Tests/Quarantine )
• RETURND_PER_TO_WORK_PSDYP ( type: esriFieldTypeInteger, alias: Total Number of DYRS Personnel Returned to Work )
• LIVE_LOST_PERSONNEL_PSDYP ( type: esriFieldTypeInteger, alias: Total Number of Lives Among DYRS Personnel )
• KPI_GROUP8 ( type: esriFieldTypeString, alias: Public Safety - DYRS Residents, length: 100 )
• TOTAL_POSITIVE_PSDYR ( type: esriFieldTypeInteger, alias: Total Number of DYRS Residents Isolated Who Have Tested Positive )
• TOTAL_POSITIVE_OUT_PSDYR ( type: esriFieldTypeInteger, alias: Total Number of DYRS Residents Tested Positive OUT )
• RECOVRD_RES_PSDYR ( type: esriFieldTypeInteger, alias: Total Number of DYRS Residents Recovered )
• RES_QUARANTINE_PSDYR ( type: esriFieldTypeInteger, alias: Total Number of DYRS Residents in Quarantine Due to COVID-19 )
• OUT_POSITIVE_QUARANTINE_PSDYR ( type: esriFieldTypeInteger, alias: Total Number of DYRS Residents Not in General Population Due to Positive Tests/Quarantine )
• NO_LONGER_ISO_QUAR_PSDYR ( type: esriFieldTypeInteger, alias: Total Number of DYRS Residents No Longer Isolated/In Quarantine )
• RETURND_TO_GP_PSDYR ( type: esriFieldTypeInteger, alias: Total Number of DYRS Residents Returned to General Population After Recovery )
• KPI_GROUP9 ( type: esriFieldTypeString, alias: Human Services - DHS, length: 100 )
• TOTAL_REMOTE_QTRN_SHELTER_DHS ( type: esriFieldTypeInteger, alias: Total Number of DHS Positive Cases of People Who Were in Shelter )
• TOTAL_REMOTE_QRTN_DHS ( type: esriFieldTypeInteger, alias: Total Number of DHS People in Remote Quarantine )
• REMOTE_QUARN_SHELTER_DHS ( type: esriFieldTypeInteger, alias: Total Number of DHS People in Remote Quarantine, Total Number from Shelters )
• LIVE_LOST_DHS ( type: esriFieldTypeInteger, alias: Total Number of DHS Lives Lost Among Individuals in the Homeless Service System )
• KPI_GROUP10 ( type: esriFieldTypeString, alias: Saint Elizabeths Hospital Personnel, length: 100 )
• TOTAL_POSITIVE_SEHP ( type: esriFieldTypeInteger, alias: Total Number of SEH Personnel Out Who Have Tested Positive )
• PERSON_QUARANTINE_SEHP ( type: esriFieldTypeInteger, alias: Total Number of SEH Personnel in Quarantine Due to COVID-19 )
• POSITIVE_OUT_QUARN_SEHP ( type: esriFieldTypeInteger, alias: Total Number of SEH Personnel Out Due to Positive Tests/Quarantine )
• RETURND_TO_WORK_SEHP ( type: esriFieldTypeInteger, alias: Total Number of SEH Personnel Returned to Work )
• LIVE_LOST_SEHP ( type: esriFieldTypeInteger, alias: Total Number of SEH Personnel Lives Lost )
• KPI_GROUP11 ( type: esriFieldTypeString, alias: Saint Elizabeths Hospital Individuals in Care, length: 100 )
• IIC_QRNT_ISLTD_POSITIVE_SEHI ( type: esriFieldTypeInteger, alias: Total Number of SEH IIC in Quarantine or Isolation Who Have Tested Positive )
• IIC_QRNT_ISLTD_EXPO_SYM_SEHI ( type: esriFieldTypeInteger, alias: Total Number of SEH IIC in Quarantine or Isolation Due to Exposure to or Symptoms Consistent with COVID-19 )
• TOTAL_IIC_ISLD_QTRN_SEHI ( type: esriFieldTypeInteger, alias: Total Number of SEH IIC Who Currently are Isolated/In Quarantine )
• TOTAL_RES_NOT_ISLTD_QRTN_SEHI ( type: esriFieldTypeInteger, alias: Total Number of SEH Residents No Longer Isolated/In Quarantine )
• LIVE_LOST_SEHI ( type: esriFieldTypeInteger, alias: Total Number of SEH Resident Lives Lost Among IIC )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• KPI_GROUP12 ( type: esriFieldTypeString, alias: Human Services - DDS, length: 100 )
• DDA_POSITIVE_HSDDS ( type: esriFieldTypeInteger, alias: Total Number of DDA Connected Individuals Who Have Tested Positive )
• DDA_RECOVERED_HSDDS ( type: esriFieldTypeInteger, alias: Total Number of DDA Connected Individuals Who Have Recovered )
• DDA_LIVE_LOST_HSDDS ( type: esriFieldTypeInteger, alias: Total Number of Lives Lost Among DDA Connected Individuals )
• TOTAL_COVID19_PATIS_DCHOS_HOS ( type: esriFieldTypeInteger, alias: Total COVID-19 Patients in DC Hospitals )
• TOTAL_COVID19_NON_DCHOS_HOS ( type: esriFieldTypeInteger, alias: Total Patients in DC Hospitals (COVID and non-COVID) )
• TOTAL_COVID19_PATIENTS_ICU_HOS ( type: esriFieldTypeInteger, alias: Total COVID-19 Patients in ICU )
• KPI_GROUP13 ( type: esriFieldTypeString, alias: Office of Unified Communications Personnel - OUC, length: 100 )
• TOTAL_POSITIVE_PSOUCP ( type: esriFieldTypeInteger, alias: Total Number of OUC Personnel Out Who Have Tested Positive )
• TOTAL_POSITIVE_OUT_PSOUCP ( type: esriFieldTypeInteger, alias: Total Number of OUC Personnel Tested Positive OUT )
• RETURND_TO_WORK_PSOUCP ( type: esriFieldTypeInteger, alias: Total Number of OUC Personnel Returned to Work )
• PERSON_QUARANTINE_PSOUCP ( type: esriFieldTypeInteger, alias: Total Number of OUC Personnel in Quarantine Due to COVID-19 )
• OUT_POSITIVE_QUARANTINE_PSOUCP ( type: esriFieldTypeInteger, alias: Total Number of OUC Personnel Out Due to Positive Tests/Quarantine )
• RETURND_PER_TO_WORK_PSOUCP ( type: esriFieldTypeInteger, alias: Total Number of OUC Personnel Returned to Work )
• KPI_GROUP14 ( type: esriFieldTypeString, alias: Human Services - CFSA, length: 100 )
• TOTAL_POSITIVE_CFSA ( type: esriFieldTypeInteger, alias: Total Number of CFSA Personnel Who Have Tested Positive )
• PERSON_QUARANTINE_CFSA ( type: esriFieldTypeInteger, alias: Total Number of CFSA Personnel Currently in Quarantine )
• RETURND_TO_WORK_CFSA ( type: esriFieldTypeInteger, alias: Total Number of CFSA Personnel Returned to Work )
• LIVE_LOST_CFSA ( type: esriFieldTypeInteger, alias: Total Number of Lives Lost Among CFSA Personnel )
• KPI_GROUP15 ( type: esriFieldTypeString, alias: Transportation - DMV, length: 100 )
• TOTAL_POSITIVE_DMVP ( type: esriFieldTypeInteger, alias: Total Number of DMV Personnel Who Have Tested Positive )
• TOTAL_POSITIVE_OUT_DMVP ( type: esriFieldTypeInteger, alias: Total Number DMV Personnel Who Have Tested Positive and OUT )
• RECOVERED_RETURNED_WRK_DMVP ( type: esriFieldTypeInteger, alias: Total Number DMV Personnel Recovered and Returned to Work )
• TOTAL_QUARN_DMVP ( type: esriFieldTypeInteger, alias: Total Number of DMV Personnel in Quarantine Due to COVID-19 )
• POSITIVE_OUT_QUARN_DMVP ( type: esriFieldTypeInteger, alias: Total Number of DMV Personnel Out Due to Positive Tests/Quarantine )
• RETURNED_TO_WORK_DMVP ( type: esriFieldTypeInteger, alias: Total Number of DMV Personnel Returned to Work )
• LIVE_LOST_DMVP ( type: esriFieldTypeInteger, alias: Total Number of Lives Lost Among DMV Personnel )
• KPI_GROUP16 ( type: esriFieldTypeString, alias: DCPS Personnel Working In-Person, length: 100 )
• TOTAL_POSITIVE_CONF_DCPSPWIP ( type: esriFieldTypeInteger, alias: Total Number of Personnel Tested Positive – Confirmed )
• TOTAL_RPRTD_PENDCONF_DCPSPWIP ( type: esriFieldTypeInteger, alias: Total Number of Personnel Reported Positive – Pending Confirmation )
• TOTAL_CURR_QUARN_DCPSPWIP ( type: esriFieldTypeInteger, alias: Total Number of Personnel Currently in Quarantine )
• KPI_GROUP17 ( type: esriFieldTypeString, alias: DCPS Students Participating in In-Person Activities, length: 100 )
• TOTAL_POSITIVE_CONF_DCPSSPIPA ( type: esriFieldTypeInteger, alias: Total Number of Students Tested Positive )
• TOTAL_RPRTD_PENDCONF_DCPSSPIPA ( type: esriFieldTypeInteger, alias: Total Number of Students Reported Positive – Pending Confirmation )
• TOTAL_CURR_QUARN_DCPSSPIPA ( type: esriFieldTypeInteger, alias: Total Number of Students Currently in Quarantine )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata