| Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
|---|---|---|---|---|---|---|
| code | None | VARCHAR(3) | ||||
| total_number | None | INTEGER | ||||
| meet_standard | None | INTEGER | ||||
| meet_standard_percentage | None | NUMERIC(7, 4) | ||||
| have_at_least_one_mou | None | INTEGER | ||||
| have_at_least_one_mou_percentage | None | NUMERIC(7, 4) | ||||
| have_authorization | None | INTEGER | ||||
| have_authorization_percentage | None | NUMERIC(7, 4) | ||||
| year | INTEGER |
| Metric | Verbose Name | Type | |
|---|---|---|---|
| sum__year | None | sum | |
| avg__year | None | avg | |
| sum__total_number | None | sum | |
| avg__total_number | None | avg | |
| sum__meet_standard | None | sum | |
| avg__meet_standard | None | avg | |
| sum__meet_standard_percentage | None | sum | |
| avg__meet_standard_percentage | None | avg | |
| sum__have_at_least_one_mou | None | sum | |
| avg__have_at_least_one_mou | None | avg | |
| sum__have_at_least_one_mou_percentage | None | sum | |
| avg__have_at_least_one_mou_percentage | None | avg | |
| sum__have_authorization | None | sum | |
| avg__have_authorization | None | avg | |
| sum__have_authorization_percentage | None | sum | |
| avg__have_authorization_percentage | None | avg | |
| count | COUNT(*) | count |
| Table Name | overall_care_facilities_data |
|---|---|
| Sql | None |
| Enable Filter Select | False |
| Fetch Values Predicate | None |
| Database | UNICEF Cambodia |
| 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 | [UNICEF Cambodia].[overall_care_facilities_data](id:49) |
| Associated Charts | [Percentage of RCIs Meeting Standards, Overall has at least one mou, Number of RCIs with authorization, Total Number of RCIs Inspected, Percentage of RCIs that have Authorization, Number of RCIs Meeting standards, Number of RCIs with at least one mou, Percentage of RCIs with at least one mou, Overall Meeting Standards, Overall has authorization, Inspection 2018, ចំនួនសរុបនៃមណ្ឌលថែទាំកុមារដែលត្រូវបានធ្វើអធិការកិច្ច, ភាគរយនៃមណ្ឌលថែទាំកុមារដែលអនុវត្តស្របតាមបទដ្ឋាន, ចំនួនមណ្ឌលថែទាំកុមារដែលមានលិខិតអនុញ្ញាត, ភាគរយនៃមណ្ឌលថែទាំកុមារដែលមានលិខិតអនុញ្ញាត, ចំនួនមណ្ឌលថែទាំកុមារដែលអនុវត្តស្របតាមបទដ្ឋាន, ចំនួនមណ្ឌលថែទាំកុមារ ដែល MoU យ៉ាងហោចណាស់មួយ, ភាគរយនៃមណ្ឌលថែទាំកុមារ ដែល MoU យ៉ាងហោចណាស់មួយ, Overall has at least one mou, Total Number of RCIs Inspected, Percentage of RCIs Meeting Standards, Number of RCIs with authorization, Percentage of RCIs that have Authorization, Number of RCIs Meeting standards, Number of RCIs with at least one mou, Percentage of RCIs with at least one mou, Overall Meeting Standards, Overall has authorization, Inspection 2018] |