{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 10, "name": "DC COVID-19 Department of Corrections Personnel and Resident", "type": "Table", "description": "District of Columbia Department of Correction, both personnel and resident, testing for the number of positive tests, quarantined, returned to work, recovery and lives lost. Due to rapidly changing nature of COVID-19, data for March 2020 is limited.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "KPI_GROUP5", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "DATE_REPORTED", "type": "esriFieldTypeDate", "alias": "Date Reported", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATE_REPORTED" }, { "name": "KPI_GROUP5", "type": "esriFieldTypeString", "alias": "DOC - Personnel", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "KPI_GROUP5" }, { "name": "TOTAL_POSITIVE_PSDP", "type": "esriFieldTypeInteger", "alias": "Total Number of DOC Personnel Who Have Tested Positive", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTAL_POSITIVE_PSDP" }, { "name": "TOTAL_POSITIVE_OUT_PSDP", "type": "esriFieldTypeInteger", "alias": "Total Number of DOC Personnel Tested Positive OUT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTAL_POSITIVE_OUT_PSDP" }, { "name": "RECOVRD_RETURND_TO_WORK_PSDP", "type": "esriFieldTypeInteger", "alias": "Total Number of DOC Personnel Recovered aand Returned to Work", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RECOVRD_RETURND_TO_WORK_PSDP" }, { "name": "PERSON_QUARANTINE_PSDP", "type": "esriFieldTypeInteger", "alias": "Total Number of DOC Personnel in Quarantine Due to COVID-19", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PERSON_QUARANTINE_PSDP" }, { "name": "OUT_POSITIVE_QUARANTINE_PSDP", "type": "esriFieldTypeInteger", "alias": "Total Number of DOC Personnel Out Due to Positive Tests/Quarantine", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OUT_POSITIVE_QUARANTINE_PSDP" }, { "name": "RETURND_TO_WORK_PSDP", "type": "esriFieldTypeInteger", "alias": "Total Number of DOC Personnel Returned to Work", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RETURND_TO_WORK_PSDP" }, { "name": "LIVE_LOST_PERSONNEL_PSDP", "type": "esriFieldTypeInteger", "alias": "Total Number of DOC Personnel Lives Lost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIVE_LOST_PERSONNEL_PSDP" }, { "name": "KPI_GROUP6", "type": "esriFieldTypeString", "alias": "DOC - Residents", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "KPI_GROUP6" }, { "name": "TOTAL_POSITIVE_PSDR", "type": "esriFieldTypeInteger", "alias": "Total Number of DOC Residents Who Have Tested Positive", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTAL_POSITIVE_PSDR" }, { "name": "TOTAL_POSITIVE_ISO_PSDR", "type": "esriFieldTypeInteger", "alias": "Total Number of DOC Residents Tested Positive in Isolation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTAL_POSITIVE_ISO_PSDR" }, { "name": "RECOVRD_RES_PSDR", "type": "esriFieldTypeInteger", "alias": "Total Number of DOC Residents Recovered", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RECOVRD_RES_PSDR" }, { "name": "RES_QUARANTINE_PSDR", "type": "esriFieldTypeInteger", "alias": "Total Number of DOC Residents in Quarantine Due to COVID-19", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RES_QUARANTINE_PSDR" }, { "name": "OUT_POSITIVE_QUARANTINE_PSDR", "type": "esriFieldTypeInteger", "alias": "Total Number of DOC Residents Out Due to Positive Tests/Quarantine", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OUT_POSITIVE_QUARANTINE_PSDR" }, { "name": "RETURND_TO_GP_PSDR", "type": "esriFieldTypeInteger", "alias": "Total Number of DOC Residents Returned to General Population", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RETURND_TO_GP_PSDR" }, { "name": "LIVE_LOST_RES_PSDR", "type": "esriFieldTypeInteger", "alias": "Total Number of DOC Residents Lives Lost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIVE_LOST_RES_PSDR" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "DC COVID-19 Department of Corrections Personnel and Resident", "description": "", "prototype": { "attributes": { "LIVE_LOST_RES_PSDR": null, "DATE_REPORTED": null, "KPI_GROUP5": null, "TOTAL_POSITIVE_PSDP": null, "TOTAL_POSITIVE_OUT_PSDP": null, "RECOVRD_RETURND_TO_WORK_PSDP": null, "PERSON_QUARANTINE_PSDP": null, "OUT_POSITIVE_QUARANTINE_PSDP": null, "RETURND_TO_WORK_PSDP": null, "LIVE_LOST_PERSONNEL_PSDP": null, "KPI_GROUP6": null, "TOTAL_POSITIVE_PSDR": null, "TOTAL_POSITIVE_ISO_PSDR": null, "RECOVRD_RES_PSDR": null, "RES_QUARANTINE_PSDR": null, "OUT_POSITIVE_QUARANTINE_PSDR": null, "RETURND_TO_GP_PSDR": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }