Sql |
SELECT "Form of violence" as form_of_violence,
"Ever",
"Often",
"Sometimes",
"Often or sometimes" as often_sometimes,
year,
type,
CASE WHEN "Form of violence" = 'Forced her with threats or in any other way to perform sexual acts she did not want to' THEN 'គំរាមឱ្យធ្វើសកម្មភាពផ្លូវភេទ'
WHEN "Form of violence" = 'Slapped her' THEN 'ទះកំផ្លៀង'
WHEN "Form of violence" = 'Physically forced her to perform any other sexual acts she did not want to' THEN 'បង្ខំឱ្យធ្វើសកម្មភាពផ្លូវភេទ'
WHEN "Form of violence" = 'Physically forced her to have sexual intercourse with him when she did not want to' THEN 'ខាងរាងកាយបង្ខំនាងឱ្យរួមភេទជាមួយគាត់នៅពេលនាងមិនចង់'
WHEN "Form of violence" = 'Tried to choke her or burn her on purpose' THEN 'ធ្វើឱ្យឈ្លក់/ដុត'
WHEN "Form of violence" = 'Any physical violence' THEN 'អំពើហិង្សាផ្លូវកាយ'
WHEN "Form of violence" = 'Pushed her, shook her, or threw something at her' THEN 'រុញ/អង្រួន/គប់'
WHEN "Form of violence" = 'Punched her with his fist or with something that could hurt her' THEN 'ដាល់'
WHEN "Form of violence" = 'Twisted her arm or pulled her hair' THEN 'កាច់ដៃឬបោចសក់'
WHEN "Form of violence" = 'Threatened her or attacked her with a knife, gun, or other weapon' THEN 'គំរាម/ប្រើកាំបិត/អាវុធ'
WHEN "Form of violence" = 'Kicked her, dragged her, or beat her up' THEN 'ទាត់/ចាប់អូស'
WHEN "Form of violence" = 'Any sexual violence' THEN 'អំពើហិង្សាផ្លូវភេទ'
END as khmer_updated
FROM indicator5_12_data
|