Column | Verbose Name | Type | Business Data Type | Groupable | Filterable | Is temporal | Extra | |
---|---|---|---|---|---|---|---|---|
date | DATETIME | None | None | |||||
year | DATETIME | None | None | |||||
boys_total | None | BIGINT | None | None | ||||
girls_total | None | BIGINT | None | None | ||||
total_injured | None | BIGINT | None | None | ||||
boys_injured | None | BIGINT | None | None | ||||
girls_injured | None | BIGINT | None | None | ||||
total_amputeted | None | BIGINT | None | None | ||||
boys_amputeted | None | BIGINT | None | None | ||||
girls_amputeted | None | BIGINT | None | None | ||||
total_killed | None | BIGINT | None | None | ||||
boys_killed | None | BIGINT | None | None | ||||
girls_killed | None | BIGINT | None | None | ||||
total_total | None | BIGINT | None | None |
Metric | Verbose Name | Type | Extra | |
---|---|---|---|---|
avg__girls_injured | None | avg | None | |
avg__year | None | avg | None | |
avg__girls_killed | None | avg | None | |
avg__total_total | None | avg | None | |
avg__boys_killed | None | avg | None | |
avg__boys_total | None | avg | None | |
avg__total_killed | None | avg | None | |
avg__girls_total | None | avg | None | |
avg__girls_amputeted | None | avg | None | |
avg__total_injured | None | avg | None | |
avg__boys_amputeted | None | avg | None | |
avg__boys_injured | None | avg | None | |
avg__total_amputeted | None | avg | None | |
count | COUNT(*) | count | None | |
sum__total_amputeted | None | sum | None | |
sum__girls_injured | None | sum | None | |
sum__boys_amputeted | None | sum | None | |
sum__boys_injured | None | sum | None | |
sum__girls_amputeted | None | sum | None | |
sum__total_injured | None | sum | None | |
sum__total_killed | None | sum | None | |
sum__girls_total | None | sum | None | |
sum__boys_killed | None | sum | None | |
sum__boys_total | None | sum | None | |
sum__girls_killed | None | sum | None | |
sum__total_total | None | sum | None | |
sum__year | None | sum | None |
Table Name | indicator5_17_trend |
---|---|
Sql | None |
Enable Filter Select | False |
Fetch Values Predicate | None |
Database | UNICEF Cambodia |
Schema | None |
Description | None |
Owners | [Ona ] |
Main Datetime Column | None |
Default Endpoint | None |
Offset | 0 |
Cache Timeout | None |
SQL Lab View | False |
Template parameters | None |
Extra | None |
Normalize Columns | True |
Perm | [UNICEF Cambodia].[indicator5_17_trend](id:47) |
Associated Charts | [Number of Total casualties over time, Injured over time, Amputated over time, Number of Total casualties over time, Injured over time, Amputated over time, Killed over time, Killed over time] |