Show Table

Column Verbose Name Type Groupable Filterable Is temporal
patient_id None TEXT
created_date None TIMESTAMP WITHOUT TIME ZONE
first_contacted_date None TIMESTAMP WITHOUT TIME ZONE
contacted_within_24hrs None BOOLEAN
final_lab_result None TEXT
symptomatic None BOOLEAN
symptomatic_onset_date None TIMESTAMP WITHOUT TIME ZONE
symptomatic_reported_date None TIMESTAMP WITHOUT TIME ZONE
case_registered_within_2days_sample_collection None BOOLEAN
symptomatic_tested_under_4days None BOOLEAN
number_of_contacts None BIGINT
age_in_years None DOUBLE PRECISION
owner_name Registered by TEXT
merged_case_status None TEXT
contacted_within_2days None BOOLEAN
Record Count: 15
Metric Verbose Name Type
count Count of patients None
Record Count: 1
Table Name suspected_and_confirmed_patients
Sql None
Enable Filter Select False
Fetch Values Predicate None
Database rf-indicators
Schema rf_indicator
Description None
Owners []
Main Datetime Column created_date
Default Endpoint None
Offset 0
Cache Timeout None
SQL Lab View False
Template parameters None
Perm [rf-indicators].[suspected_and_confirmed_patients](id:15)
Associated Charts [% Contacted within 2 days of positive result, [9] Contacted within 2 days of positive result, Suspected and confirmed COVID-19 patients by age group, [1] Suspected and confirmed cases, Patient registration by user, Cumulative COVID-19 cases registered, [9] % contacted within 2 days of positive result, Cumulative COVID-19 cases registered, Suspected and confirmed COVID-19 patients by age group, COVID-19 case registration by district, Number of contacts per patient (for patients with >0 contacts), [8] % positive cases registered within 2 days of specimen collection, [1] Suspected and confirmed cases, [9] % contacted within 2 days of positive result, Number of contacts per patient (for patients with >0 contacts), [9] % contacted within 2 days of positive result - over time, Cumulative COVID-19 cases registered, [8] % positive cases registered within 2 days of specimen collection - over time, [9] % contacted within 2 days of positive result - over time, [8] % positive cases registered within 2 days of specimen collection, [8] % positive cases registered within 2 days of specimen collection - over time, Cumulative COVID-19 cases registered by district]