| Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
|---|---|---|---|---|---|---|
| number | None | BIGINT | ||||
| caseid | None | TEXT | ||||
| contact_phone_number | None | BIGINT | ||||
| contact_phone_number_is_verified | None | BIGINT | ||||
| facility_assessment_date | None | TEXT | ||||
| facility_assessment_time | None | TEXT | ||||
| facility_district | None | TEXT | ||||
| facility_location | None | TEXT | ||||
| facility_mask_count | None | DOUBLE PRECISION | ||||
| facility_name | None | TEXT | ||||
| facility_pin_code | None | DOUBLE PRECISION | ||||
| facility_ppe_count | None | DOUBLE PRECISION | ||||
| facility_readiness_commodities | None | TEXT | ||||
| facility_readiness_waste_management | None | TEXT | ||||
| facility_state | None | TEXT | ||||
| facility_stock_dose_kit_count | None | BIGINT | ||||
| facility_street_address | None | DOUBLE PRECISION | ||||
| language_code | None | TEXT | ||||
| name | None | TEXT | ||||
| owner_id | None | TEXT | ||||
| primary_contact_full_name | None | DOUBLE PRECISION | ||||
| primary_contact_phone_number | None | DOUBLE PRECISION | ||||
| primary_contact_role | None | DOUBLE PRECISION | ||||
| secondary_contact_full_name | None | DOUBLE PRECISION | ||||
| secondary_contact_phone_number | None | TEXT | ||||
| secondary_contact_role | None | TEXT | ||||
| target_number_of_beneficiaries | None | BIGINT | ||||
| total_icu_beds | None | DOUBLE PRECISION | ||||
| total_non_icu_beds | None | DOUBLE PRECISION | ||||
| whether_facility_ready | None | TEXT | ||||
| whether_staff_trained_side_effects | None | TEXT | ||||
| closed | None | BOOLEAN | ||||
| closed_by_username | None | TEXT | ||||
| closed_date | None | TEXT | ||||
| last_modified_by_user_username | None | TEXT | ||||
| last_modified_date | None | TEXT | ||||
| opened_by_username | None | TEXT | ||||
| opened_date | None | TEXT | ||||
| owner_name | None | TEXT | ||||
| latitude | Lat | DOUBLE PRECISION | ||||
| longitude | Long | DOUBLE PRECISION |
| Table Name | facility_case |
|---|---|
| Sql | None |
| Enable Filter Select | False |
| Fetch Values Predicate | None |
| Database | COVID Vaccine Demo |
| Schema | public |
| Description | None |
| Owners | [] |
| Main Datetime Column | None |
| Default Endpoint | None |
| Offset | 0 |
| Cache Timeout | None |
| SQL Lab View | False |
| Template parameters | None |
| Perm | [COVID Vaccine Demo].[facility_case](id:68) |
| Associated Charts | [Active Facilities_n] |