-
Notifications
You must be signed in to change notification settings - Fork 19
/
0081.sql
1710 lines (1679 loc) · 244 KB
/
0081.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- language is a reserved keyword in some variants of sql, (but not Postgres)
-- so we use preferred_language at the DB layer.
ALTER TABLE account ADD COLUMN preferred_language VARCHAR;
UPDATE account SET preferred_language='en_US';
ALTER TABLE account ALTER COLUMN preferred_language SET NOT NULL;
-- add missing headers for spanish
ALTER TABLE ag.survey_group ADD COLUMN spanish VARCHAR;
UPDATE ag.survey_group SET spanish='Información general sobre la dieta' WHERE group_order=0;
UPDATE ag.survey_group SET spanish='Información general' WHERE group_order=1;
UPDATE ag.survey_group SET spanish='Información general sobre higiene y estilo de vida' WHERE group_order=2;
UPDATE ag.survey_group SET spanish='Información general de salud' WHERE group_order=3;
UPDATE ag.survey_group SET spanish='Información dietética detallada' WHERE group_order=4;
UPDATE ag.survey_group SET spanish='¿Algo más?' WHERE group_order=5;
UPDATE ag.survey_group SET spanish='Información sobre mascotas' WHERE group_order=-2;
UPDATE ag.survey_group SET spanish='Comidas fermentadas' WHERE group_order=-3;
UPDATE ag.survey_group SET spanish='Surfistas' WHERE group_order=-4;
UPDATE ag.survey_group SET spanish='Microbioma personal' WHERE group_order=-5;
UPDATE ag.survey_group SET spanish='Cuestionario COVID19' WHERE group_order=-6;
UPDATE ag.survey_group SET spanish='Iniciativa Microsetta' WHERE group_order=-1;
-- set a stylizable ID for bristol images
UPDATE ag.survey_question
SET
american = 'Describe the quality of your bowel movements. Use the chart below as a reference:<br/><img src="/static/img/en_us/bristol_stool.jpg" id="bristol-chart">',
british = 'Describe the quality of your bowel movements. Use the chart below as a reference:<br/><img src="/static/img/en_us/bristol_stool.jpg" id="bristol-chart">',
spanish = 'Describa la calidad de la evacuación. Utilice el siguiente cuadro a modo de referencia:<br/><img src="/static/img/es_mx/bristol_stool.jpg" id="bristol-chart">',
french = 'Veuillez décrire la qualité de vos selles. Vous pouvez utiliser le tableau ci-dessous comme référence:<br/><img src="/static/img/fr_fr/bristol_stool.jpg" id="bristol-chart">',
chinese = '描述您的排便质量。使用下面的图表作为参考:<br/><img src="/static/img/zh_cn/bristol_stool.jpg" id="bristol-chart">'
WHERE
survey_question_id = 38;
-- add in missing questions (note: the responses are already covered as they're standard frequency)
UPDATE ag.survey_question
SET spanish='En una semana promedio, ¿con qué frecuencia consume betabel (incluyendo cruda, enlatada, en escabeche o asada)? (1 porción = 1 taza cruda o cocida)'
WHERE survey_question_id=236;
UPDATE ag.survey_question
SET spanish='En una semana promedio, ¿con qué frecuencia come varias fuentes vegetales de proteínas, como tofu, tempeh, edamame, lentejas, garbanzos, maní, almendras, nueces o quinoa?'
WHERE survey_question_id=237;
-- responses went into the wrong table... ugh. Migrate them
ALTER TABLE ag.survey_response
ADD COLUMN spanish VARCHAR;
ALTER TABLE ag.survey_response
ADD COLUMN french varchar;
ALTER TABLE ag.survey_response
ADD COLUMN chinese varchar;
UPDATE ag.survey_response SET spanish = 'Hombre', french = 'Homme', chinese = '男性' WHERE american = 'Male';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Omnívora', french = 'Omnivore', chinese = '杂食' WHERE american = 'Omnivore';
UPDATE ag.survey_response SET spanish = 'Omnívora, pero no consumo carne roja', french = 'Omnivore, mais je ne mange pas de viande rouge', chinese = '杂食但不吃红肉' WHERE american = 'Omnivore but do not eat red meat';
UPDATE ag.survey_response SET spanish = 'Vegetariana', french = 'Végétarien', chinese = '素食' WHERE american = 'Vegetarian';
UPDATE ag.survey_response SET spanish = 'Vegetariana, pero consumo pescado y mariscos', french = 'Végétarien, mais je mange des produits de la mer', chinese = '素食但吃海鲜' WHERE american = 'Vegetarian but eat seafood';
UPDATE ag.survey_response SET spanish = 'Vegana', french = 'Végane', chinese = '纯素食' WHERE american = 'Vegan';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Mujer', french = 'Femme', chinese = '女性' WHERE american = 'Female';
UPDATE ag.survey_response SET spanish = 'Otro', french = 'Autre', chinese = '其他' WHERE american = 'Other';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'pulgadas', french = 'pouces', chinese = '英寸' WHERE american = 'inches';
UPDATE ag.survey_response SET spanish = 'centímetros', french = 'centimètres', chinese = '厘米' WHERE american = 'centimeters';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'No estoy seguro', french = 'Je ne sais pas', chinese = '不确定' WHERE american = 'Not sure';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Afganistán', french = 'Afghanistan', chinese = '阿富汗' WHERE american = 'Afghanistan';
UPDATE ag.survey_response SET spanish = 'Islas Aland', french = 'Iles Aland', chinese = '奥兰群岛' WHERE american = 'Aland Islands';
UPDATE ag.survey_response SET spanish = 'Albania', french = 'Albanie', chinese = '阿尔巴尼亚' WHERE american = 'Albania';
UPDATE ag.survey_response SET spanish = 'Argelia', french = 'Algérie', chinese = '阿尔及利亚' WHERE american = 'Algeria';
UPDATE ag.survey_response SET spanish = 'Samoa Americana', french = 'Samoa américaines', chinese = '美属萨摩亚' WHERE american = 'American Samoa';
UPDATE ag.survey_response SET spanish = 'Andorra', french = 'Andorre', chinese = '安道尔' WHERE american = 'Andorra';
UPDATE ag.survey_response SET spanish = 'Angola', french = 'Angola', chinese = '安哥拉' WHERE american = 'Angola';
UPDATE ag.survey_response SET spanish = 'Anguila', french = 'Anguilla', chinese = '安圭拉岛' WHERE american = 'Anguilla';
UPDATE ag.survey_response SET spanish = 'Antártida', french = 'Antarctique', chinese = '南极洲' WHERE american = 'Antarctica';
UPDATE ag.survey_response SET spanish = 'Antigua y Barbuda', french = 'Antigua-et-Barbuda', chinese = '安提瓜和巴布达' WHERE american = 'Antigua and Barbuda';
UPDATE ag.survey_response SET spanish = 'Argentina', french = 'Argentine', chinese = '阿根廷' WHERE american = 'Argentina';
UPDATE ag.survey_response SET spanish = 'Armenia', french = 'Arménie', chinese = '亚美尼亚' WHERE american = 'Armenia';
UPDATE ag.survey_response SET spanish = 'Aruba', french = 'Aruba', chinese = '阿鲁巴岛' WHERE american = 'Aruba';
UPDATE ag.survey_response SET spanish = 'Australia', french = 'Australie', chinese = '澳大利亚' WHERE american = 'Australia';
UPDATE ag.survey_response SET spanish = 'Austria', french = 'L''Autriche', chinese = '奥地利' WHERE american = 'Austria';
UPDATE ag.survey_response SET spanish = 'Azerbaiyán', french = 'Azerbaïdjan', chinese = '阿塞拜疆' WHERE american = 'Azerbaijan';
UPDATE ag.survey_response SET spanish = 'Bahamas', french = 'Bahamas', chinese = '巴哈马' WHERE american = 'Bahamas';
UPDATE ag.survey_response SET spanish = 'Bahrein', french = 'Bahrein', chinese = '巴林' WHERE american = 'Bahrain';
UPDATE ag.survey_response SET spanish = 'Bangladesh', french = 'Bangladesh', chinese = '孟加拉国' WHERE american = 'Bangladesh';
UPDATE ag.survey_response SET spanish = 'Barbados', french = 'Barbade', chinese = '巴巴多斯' WHERE american = 'Barbados';
UPDATE ag.survey_response SET spanish = 'Bielorrusia', french = 'Biélorussie', chinese = '白俄罗斯' WHERE american = 'Belarus';
UPDATE ag.survey_response SET spanish = 'Bélgica', french = 'Belgique', chinese = '比利时' WHERE american = 'Belgium';
UPDATE ag.survey_response SET spanish = 'Belice', french = 'Belize', chinese = '伯利兹' WHERE american = 'Belize';
UPDATE ag.survey_response SET spanish = 'Benin', french = 'Bénin', chinese = '贝宁' WHERE american = 'Benin';
UPDATE ag.survey_response SET spanish = 'islas Bermudas', french = 'Bermudes', chinese = '百慕大' WHERE american = 'Bermuda';
UPDATE ag.survey_response SET spanish = 'Bután', french = 'Bhoutan', chinese = '不丹' WHERE american = 'Bhutan';
UPDATE ag.survey_response SET spanish = 'Bolivia', french = 'Bolivie', chinese = '玻利维亚' WHERE american = 'Bolivia';
UPDATE ag.survey_response SET spanish = 'Bosnia y Herzegovina', french = 'Bosnie Herzégovine', chinese = '波斯尼亚和黑塞哥维那' WHERE american = 'Bosnia and Herzegovina';
UPDATE ag.survey_response SET spanish = 'Botsuana', french = 'Botswana', chinese = '博茨瓦纳' WHERE american = 'Botswana';
UPDATE ag.survey_response SET spanish = 'Isla Bouvet', french = 'Île Bouvet', chinese = '布维岛' WHERE american = 'Bouvet Island';
UPDATE ag.survey_response SET spanish = 'Brasil', french = 'Brésil', chinese = '巴西' WHERE american = 'Brazil';
UPDATE ag.survey_response SET spanish = 'Territorio Británico del Océano Índico', french = 'Territoire britannique de l''océan Indien', chinese = '英属印度洋领地' WHERE american = 'British Indian Ocean Territory';
UPDATE ag.survey_response SET spanish = 'Brunei Darussalam', french = 'Brunei Darussalam', chinese = '文莱达鲁萨兰国' WHERE american = 'Brunei Darussalam';
UPDATE ag.survey_response SET spanish = 'Bulgaria', french = 'Bulgarie', chinese = '保加利亚' WHERE american = 'Bulgaria';
UPDATE ag.survey_response SET spanish = 'Burkina Faso', french = 'Burkina Faso', chinese = '布基纳法索' WHERE american = 'Burkina Faso';
UPDATE ag.survey_response SET spanish = 'Burundi', french = 'Burundi', chinese = '布隆迪' WHERE american = 'Burundi';
UPDATE ag.survey_response SET spanish = 'Camboya', french = 'Cambodge', chinese = '柬埔寨' WHERE american = 'Cambodia';
UPDATE ag.survey_response SET spanish = 'Camerún', french = 'Cameroun', chinese = '喀麦隆' WHERE american = 'Cameroon';
UPDATE ag.survey_response SET spanish = 'Canadá', french = 'Canada', chinese = '加拿大' WHERE american = 'Canada';
UPDATE ag.survey_response SET spanish = 'Cabo Verde', french = 'Cap-Vert', chinese = '佛得角' WHERE american = 'Cape Verde';
UPDATE ag.survey_response SET spanish = 'Islas Caimán', french = 'Îles Caïmans', chinese = '开曼群岛' WHERE american = 'Cayman Islands';
UPDATE ag.survey_response SET spanish = 'República Centroafricana', french = 'République centrafricaine', chinese = '中非共和国' WHERE american = 'Central African Republic';
UPDATE ag.survey_response SET spanish = 'Chad', french = 'Tchad', chinese = '乍得' WHERE american = 'Chad';
UPDATE ag.survey_response SET spanish = 'Chile', french = 'Chili', chinese = '智利' WHERE american = 'Chile';
UPDATE ag.survey_response SET spanish = 'China', french = 'Chine', chinese = '中国' WHERE american = 'China';
UPDATE ag.survey_response SET spanish = 'Isla de Navidad', french = 'L''île de noël', chinese = '圣诞岛' WHERE american = 'Christmas Island';
UPDATE ag.survey_response SET spanish = 'Islas Cocos (Keeling)', french = 'Îles Cocos (Keeling)', chinese = '科科斯(基林)群岛' WHERE american = 'Cocos (Keeling) Islands';
UPDATE ag.survey_response SET spanish = 'Colombia', french = 'Colombie', chinese = '哥伦比亚' WHERE american = 'Colombia';
UPDATE ag.survey_response SET spanish = 'Comoras', french = 'Comores', chinese = '科摩罗' WHERE american = 'Comoros';
UPDATE ag.survey_response SET spanish = 'Congo', french = 'Congo', chinese = '刚果' WHERE american = 'Congo';
UPDATE ag.survey_response SET spanish = 'Congo, República Democrática del', french = 'Congo, République démocratique du', chinese = '刚果民主共和国' WHERE american = 'Congo, The Democratic Republic of The';
UPDATE ag.survey_response SET spanish = 'Islas Cook', french = 'les Îles Cook', chinese = '库克群岛' WHERE american = 'Cook Islands';
UPDATE ag.survey_response SET spanish = 'Costa Rica', french = 'Costa Rica', chinese = '哥斯达黎加' WHERE american = 'Costa Rica';
UPDATE ag.survey_response SET spanish = 'Costa de Marfil', french = 'Côte d''Ivoire', chinese = '科特迪瓦' WHERE american = 'Cote D''ivoire';
UPDATE ag.survey_response SET spanish = 'Croacia', french = 'Croatie', chinese = '克罗地亚' WHERE american = 'Croatia';
UPDATE ag.survey_response SET spanish = 'Cuba', french = 'Cuba', chinese = '古巴' WHERE american = 'Cuba';
UPDATE ag.survey_response SET spanish = 'Chipre', french = 'Chypre', chinese = '塞浦路斯' WHERE american = 'Cyprus';
UPDATE ag.survey_response SET spanish = 'Republica checa', french = 'République Tchèque', chinese = '捷克共和国' WHERE american = 'Czech Republic';
UPDATE ag.survey_response SET spanish = 'Dinamarca', french = 'Danemark', chinese = '丹麦' WHERE american = 'Denmark';
UPDATE ag.survey_response SET spanish = 'Djibouti', french = 'Djibouti', chinese = '吉布地' WHERE american = 'Djibouti';
UPDATE ag.survey_response SET spanish = 'Dominica', french = 'Dominique', chinese = '多米尼加' WHERE american = 'Dominica';
UPDATE ag.survey_response SET spanish = 'República Dominicana', french = 'République Dominicaine', chinese = '多明尼加共和国' WHERE american = 'Dominican Republic';
UPDATE ag.survey_response SET spanish = 'Ecuador', french = 'Équateur', chinese = '厄瓜多尔' WHERE american = 'Ecuador';
UPDATE ag.survey_response SET spanish = 'Egipto', french = 'Egypte', chinese = '埃及' WHERE american = 'Egypt';
UPDATE ag.survey_response SET spanish = 'El Salvador', french = 'Le Salvador', chinese = '萨尔瓦多' WHERE american = 'El Salvador';
UPDATE ag.survey_response SET spanish = 'Guinea Ecuatorial', french = 'Guinée Équatoriale', chinese = '赤道几内亚' WHERE american = 'Equatorial Guinea';
UPDATE ag.survey_response SET spanish = 'Eritrea', french = 'Érythrée', chinese = '厄立特里亚' WHERE american = 'Eritrea';
UPDATE ag.survey_response SET spanish = 'Estonia', french = 'Estonie', chinese = '爱沙尼亚' WHERE american = 'Estonia';
UPDATE ag.survey_response SET spanish = 'Etiopía', french = 'Ethiopie', chinese = '埃塞俄比亚' WHERE american = 'Ethiopia';
UPDATE ag.survey_response SET spanish = 'Islas Malvinas (Falkland Islands)', french = 'Îles Falkland (Malvinas)', chinese = '福克兰群岛(马尔维纳斯)' WHERE american = 'Falkland Islands (Malvinas)';
UPDATE ag.survey_response SET spanish = 'Islas Faroe', french = 'Îles Féroé', chinese = '法罗群岛' WHERE american = 'Faroe Islands';
UPDATE ag.survey_response SET spanish = 'Fiyi', french = 'Fidji', chinese = '斐济' WHERE american = 'Fiji';
UPDATE ag.survey_response SET spanish = 'Finlandia', french = 'Finlande', chinese = '芬兰' WHERE american = 'Finland';
UPDATE ag.survey_response SET spanish = 'Francia', french = 'France', chinese = '法国' WHERE american = 'France';
UPDATE ag.survey_response SET spanish = 'Guayana Francesa', french = 'Guyane Française', chinese = '法属圭亚那' WHERE american = 'French Guiana';
UPDATE ag.survey_response SET spanish = 'Polinesia francés', french = 'Polynésie française', chinese = '法属波利尼西亚' WHERE american = 'French Polynesia';
UPDATE ag.survey_response SET spanish = 'Territorios Franceses del Sur', french = 'Territoires français du Sud', chinese = '法属南部领地' WHERE american = 'French Southern Territories';
UPDATE ag.survey_response SET spanish = 'Gabón', french = 'Gabon', chinese = '加蓬' WHERE american = 'Gabon';
UPDATE ag.survey_response SET spanish = 'Gambia', french = 'Gambie', chinese = '冈比亚' WHERE american = 'Gambia';
UPDATE ag.survey_response SET spanish = 'Georgia', french = 'Géorgie', chinese = '佐治亚州' WHERE american = 'Georgia';
UPDATE ag.survey_response SET spanish = 'Alemania', french = 'Allemagne', chinese = '德国' WHERE american = 'Germany';
UPDATE ag.survey_response SET spanish = 'Ghana', french = 'Ghana', chinese = '加纳' WHERE american = 'Ghana';
UPDATE ag.survey_response SET spanish = 'Gibraltar', french = 'Gibraltar', chinese = '直布罗陀' WHERE american = 'Gibraltar';
UPDATE ag.survey_response SET spanish = 'Grecia', french = 'Grèce', chinese = '希腊' WHERE american = 'Greece';
UPDATE ag.survey_response SET spanish = 'Groenlandia', french = 'Groenland', chinese = '格陵兰' WHERE american = 'Greenland';
UPDATE ag.survey_response SET spanish = 'Granada', french = 'Grenade', chinese = '格林纳达' WHERE american = 'Grenada';
UPDATE ag.survey_response SET spanish = 'Guadalupe', french = 'Guadeloupe', chinese = '瓜德罗普岛' WHERE american = 'Guadeloupe';
UPDATE ag.survey_response SET spanish = 'Guam', french = 'Guam', chinese = '关岛' WHERE american = 'Guam';
UPDATE ag.survey_response SET spanish = 'Guatemala', french = 'Guatemala', chinese = '危地马拉' WHERE american = 'Guatemala';
UPDATE ag.survey_response SET spanish = 'Guernsey', french = 'Guernesey', chinese = '根西岛' WHERE american = 'Guernsey';
UPDATE ag.survey_response SET spanish = 'Guinea', french = 'Guinée', chinese = '几内亚' WHERE american = 'Guinea';
UPDATE ag.survey_response SET spanish = 'Guinea-Bissau', french = 'Guinée-bissau', chinese = '几内亚比绍' WHERE american = 'Guinea-bissau';
UPDATE ag.survey_response SET spanish = 'Guayana', french = 'Guyane', chinese = '圭亚那' WHERE american = 'Guyana';
UPDATE ag.survey_response SET spanish = 'Haití', french = 'Haïti', chinese = '海地' WHERE american = 'Haiti';
UPDATE ag.survey_response SET spanish = 'Islas Heard y Mcdonald', french = 'Îles Heard et Mcdonald', chinese = '希尔德岛和麦当劳群岛' WHERE american = 'Heard Island and Mcdonald Islands';
UPDATE ag.survey_response SET spanish = 'Santa Sede (Estado de la Ciudad del Vaticano)', french = 'Saint-Siège (État de la Cité du Vatican)', chinese = '罗马教廷(梵蒂冈城国)' WHERE american = 'Holy See (Vatican City State)';
UPDATE ag.survey_response SET spanish = 'Honduras', french = 'Honduras', chinese = '洪都拉斯' WHERE american = 'Honduras';
UPDATE ag.survey_response SET spanish = 'Hong Kong', french = 'Hong Kong', chinese = '香港' WHERE american = 'Hong Kong';
UPDATE ag.survey_response SET spanish = 'Hungría', french = 'Hongrie', chinese = '匈牙利' WHERE american = 'Hungary';
UPDATE ag.survey_response SET spanish = 'Islandia', french = 'Islande', chinese = '冰岛' WHERE american = 'Iceland';
UPDATE ag.survey_response SET spanish = 'India', french = 'Inde', chinese = '印度' WHERE american = 'India';
UPDATE ag.survey_response SET spanish = 'Indonesia', french = 'Indonésie', chinese = '印度尼西亚' WHERE american = 'Indonesia';
UPDATE ag.survey_response SET spanish = 'Irán (República Islámica de', french = 'Iran (République islamique d', chinese = '伊朗伊斯兰共和国' WHERE american = 'Iran, Islamic Republic of';
UPDATE ag.survey_response SET spanish = 'Irak', french = 'Irak', chinese = '伊拉克' WHERE american = 'Iraq';
UPDATE ag.survey_response SET spanish = 'Irlanda', french = 'Irlande', chinese = '爱尔兰' WHERE american = 'Ireland';
UPDATE ag.survey_response SET spanish = 'Isla del hombre', french = 'île de Man', chinese = '马恩岛' WHERE american = 'Isle of Man';
UPDATE ag.survey_response SET spanish = 'Israel', french = 'Israël', chinese = '以色列' WHERE american = 'Israel';
UPDATE ag.survey_response SET spanish = 'Italia', french = 'Italie', chinese = '意大利' WHERE american = 'Italy';
UPDATE ag.survey_response SET spanish = 'Jamaica', french = 'Jamaïque', chinese = '牙买加' WHERE american = 'Jamaica';
UPDATE ag.survey_response SET spanish = 'Japón', french = 'Japon', chinese = '日本' WHERE american = 'Japan';
UPDATE ag.survey_response SET spanish = 'Jersey', french = 'Jersey', chinese = '泽西岛' WHERE american = 'Jersey';
UPDATE ag.survey_response SET spanish = 'Jordán', french = 'Jordan', chinese = '约旦' WHERE american = 'Jordan';
UPDATE ag.survey_response SET spanish = 'Kazajstán', french = 'Kazakhstan', chinese = '哈萨克斯坦' WHERE american = 'Kazakhstan';
UPDATE ag.survey_response SET spanish = 'Kenia', french = 'Kenya', chinese = '肯尼亚' WHERE american = 'Kenya';
UPDATE ag.survey_response SET spanish = 'Kiribati', french = 'Kiribati', chinese = '基里巴斯' WHERE american = 'Kiribati';
UPDATE ag.survey_response SET spanish = 'República de Corea, Popular Democrática de', french = 'République populaire démocratique de Corée', chinese = '韩国,朝鲜民主主义人民共和国' WHERE american = 'Korea, Democratic People''s Republic of';
UPDATE ag.survey_response SET spanish = 'Corea, república de', french = 'Corée, République de', chinese = '韩国' WHERE american = 'Korea, Republic of';
UPDATE ag.survey_response SET spanish = 'Kuwait', french = 'Koweit', chinese = '科威特' WHERE american = 'Kuwait';
UPDATE ag.survey_response SET spanish = 'Kirguistán', french = 'Kirghizistan', chinese = '吉尔吉斯斯坦' WHERE american = 'Kyrgyzstan';
UPDATE ag.survey_response SET spanish = 'República Democrática Popular Lao', french = 'République démocratique populaire lao', chinese = '老挝人民民主共和国' WHERE american = 'Lao People''s Democratic Republic';
UPDATE ag.survey_response SET spanish = 'Letonia', french = 'Lettonie', chinese = '拉脱维亚' WHERE american = 'Latvia';
UPDATE ag.survey_response SET spanish = 'Líbano', french = 'Liban', chinese = '黎巴嫩' WHERE american = 'Lebanon';
UPDATE ag.survey_response SET spanish = 'Lesoto', french = 'Lesotho', chinese = '莱索托' WHERE american = 'Lesotho';
UPDATE ag.survey_response SET spanish = 'Liberia', french = 'Libéria', chinese = '利比里亚' WHERE american = 'Liberia';
UPDATE ag.survey_response SET spanish = 'Jamahiriya Árabe Libia', french = 'Jamahiriya arabe libyenne', chinese = '阿拉伯利比亚民众国' WHERE american = 'Libyan Arab Jamahiriya';
UPDATE ag.survey_response SET spanish = 'Liechtenstein', french = 'Liechtenstein', chinese = '列支敦士登' WHERE american = 'Liechtenstein';
UPDATE ag.survey_response SET spanish = 'Lituania', french = 'Lituanie', chinese = '立陶宛' WHERE american = 'Lithuania';
UPDATE ag.survey_response SET spanish = 'Luxemburgo', french = 'Luxembourg', chinese = '卢森堡' WHERE american = 'Luxembourg';
UPDATE ag.survey_response SET spanish = 'Macao', french = 'Macao', chinese = '澳门' WHERE american = 'Macao';
UPDATE ag.survey_response SET spanish = 'Macedonia, la ex República Yugoslava de', french = 'Macédoine, ancienne République yougoslave de', chinese = '马其顿,前南斯拉夫共和国' WHERE american = 'Macedonia, The Former Yugoslav Republic of';
UPDATE ag.survey_response SET spanish = 'Madagascar', french = 'Madagascar', chinese = '马达加斯加' WHERE american = 'Madagascar';
UPDATE ag.survey_response SET spanish = 'Malawi', french = 'Malawi', chinese = '马拉维' WHERE american = 'Malawi';
UPDATE ag.survey_response SET spanish = 'Malasia', french = 'Malaisie', chinese = '马来西亚' WHERE american = 'Malaysia';
UPDATE ag.survey_response SET spanish = 'Maldivas', french = 'Maldives', chinese = '马尔代夫' WHERE american = 'Maldives';
UPDATE ag.survey_response SET spanish = 'Mali', french = 'Mali', chinese = '马里' WHERE american = 'Mali';
UPDATE ag.survey_response SET spanish = 'Malta', french = 'Malte', chinese = '马耳他' WHERE american = 'Malta';
UPDATE ag.survey_response SET spanish = 'Islas Marshall', french = 'Iles Marshall', chinese = '马绍尔群岛' WHERE american = 'Marshall Islands';
UPDATE ag.survey_response SET spanish = 'Martinica', french = 'Martinique', chinese = '马提尼克岛' WHERE american = 'Martinique';
UPDATE ag.survey_response SET spanish = 'Mauritania', french = 'Mauritanie', chinese = '毛里塔尼亚' WHERE american = 'Mauritania';
UPDATE ag.survey_response SET spanish = 'Mauricio', french = 'Maurice', chinese = '毛里求斯' WHERE american = 'Mauritius';
UPDATE ag.survey_response SET spanish = 'Mayotte', french = 'Mayotte', chinese = '马约特岛' WHERE american = 'Mayotte';
UPDATE ag.survey_response SET spanish = 'Mexico', french = 'Mexique', chinese = '墨西哥' WHERE american = 'Mexico';
UPDATE ag.survey_response SET spanish = 'Micronesia, Estados Federados de', french = 'Micronésie, États fédérés de', chinese = '密克罗尼西亚联邦' WHERE american = 'Micronesia, Federated States of';
UPDATE ag.survey_response SET spanish = 'Moldavia, República de', french = 'Moldova, République de', chinese = '摩尔多瓦共和国' WHERE american = 'Moldova, Republic of';
UPDATE ag.survey_response SET spanish = 'Mónaco', french = 'Monaco', chinese = '摩纳哥' WHERE american = 'Monaco';
UPDATE ag.survey_response SET spanish = 'Mongolia', french = 'Mongolie', chinese = '蒙古' WHERE american = 'Mongolia';
UPDATE ag.survey_response SET spanish = 'Montenegro', french = 'Monténégro', chinese = '黑山共和国' WHERE american = 'Montenegro';
UPDATE ag.survey_response SET spanish = 'Montserrat', french = 'Montserrat', chinese = '蒙特塞拉特' WHERE american = 'Montserrat';
UPDATE ag.survey_response SET spanish = 'Marruecos', french = 'Maroc', chinese = '摩洛哥' WHERE american = 'Morocco';
UPDATE ag.survey_response SET spanish = 'Mozambique', french = 'Mozambique', chinese = '莫桑比克' WHERE american = 'Mozambique';
UPDATE ag.survey_response SET spanish = 'Myanmar', french = 'Myanmar', chinese = '缅甸' WHERE american = 'Myanmar';
UPDATE ag.survey_response SET spanish = 'Namibia', french = 'Namibie', chinese = '纳米比亚' WHERE american = 'Namibia';
UPDATE ag.survey_response SET spanish = 'Nauru', french = 'Nauru', chinese = '瑙鲁' WHERE american = 'Nauru';
UPDATE ag.survey_response SET spanish = 'Nepal', french = 'Népal', chinese = '尼泊尔' WHERE american = 'Nepal';
UPDATE ag.survey_response SET spanish = 'Países Bajos', french = 'Pays-Bas', chinese = '荷兰' WHERE american = 'Netherlands';
UPDATE ag.survey_response SET spanish = 'Antillas Holandesas', french = 'Antilles néerlandaises', chinese = '荷属安的列斯' WHERE american = 'Netherlands Antilles';
UPDATE ag.survey_response SET spanish = 'Nueva Caledonia', french = 'Nouvelle Calédonie', chinese = '新喀里多尼亚' WHERE american = 'New Caledonia';
UPDATE ag.survey_response SET spanish = 'Nueva Zelanda', french = 'Nouvelle-Zélande', chinese = '新西兰' WHERE american = 'New Zealand';
UPDATE ag.survey_response SET spanish = 'Nicaragua', french = 'Nicaragua', chinese = '尼加拉瓜' WHERE american = 'Nicaragua';
UPDATE ag.survey_response SET spanish = 'Níger', french = 'Niger', chinese = '尼日尔' WHERE american = 'Niger';
UPDATE ag.survey_response SET spanish = 'Nigeria', french = 'Nigeria', chinese = '奈及利亚' WHERE american = 'Nigeria';
UPDATE ag.survey_response SET spanish = 'Niue', french = 'Niue', chinese = '纽埃' WHERE american = 'Niue';
UPDATE ag.survey_response SET spanish = 'Isla Norfolk', french = 'l''ile de Norfolk', chinese = '诺福克岛' WHERE american = 'Norfolk Island';
UPDATE ag.survey_response SET spanish = 'Islas Marianas del Norte', french = 'Îles Mariannes du Nord', chinese = '北马里亚纳群岛' WHERE american = 'Northern Mariana Islands';
UPDATE ag.survey_response SET spanish = 'Noruega', french = 'Norvège', chinese = '挪威' WHERE american = 'Norway';
UPDATE ag.survey_response SET spanish = 'Omán', french = 'Oman', chinese = '阿曼' WHERE american = 'Oman';
UPDATE ag.survey_response SET spanish = 'Pakistán', french = 'Pakistan', chinese = '巴基斯坦' WHERE american = 'Pakistan';
UPDATE ag.survey_response SET spanish = 'Palau', french = 'Palau', chinese = 'u琉' WHERE american = 'Palau';
UPDATE ag.survey_response SET spanish = 'Territorio Palestino, Ocupado', french = 'Territoire palestinien, occupé', chinese = '被占领的巴勒斯坦领土' WHERE american = 'Palestinian Territory, Occupied';
UPDATE ag.survey_response SET spanish = 'Panamá', french = 'Panama', chinese = '巴拿马' WHERE american = 'Panama';
UPDATE ag.survey_response SET spanish = 'Papúa Nueva Guinea', french = 'Papouasie Nouvelle Guinée', chinese = '巴布亚新几内亚' WHERE american = 'Papua New Guinea';
UPDATE ag.survey_response SET spanish = 'Paraguay', french = 'Paraguay', chinese = '巴拉圭' WHERE american = 'Paraguay';
UPDATE ag.survey_response SET spanish = 'Perú', french = 'Pérou', chinese = '秘鲁' WHERE american = 'Peru';
UPDATE ag.survey_response SET spanish = 'Filipinas', french = 'Philippines', chinese = '菲律宾' WHERE american = 'Philippines';
UPDATE ag.survey_response SET spanish = 'Pitcairn', french = 'Pitcairn', chinese = '皮特凯恩' WHERE american = 'Pitcairn';
UPDATE ag.survey_response SET spanish = 'Polonia', french = 'Pologne', chinese = '波兰' WHERE american = 'Poland';
UPDATE ag.survey_response SET spanish = 'Portugal', french = 'le Portugal', chinese = '葡萄牙' WHERE american = 'Portugal';
UPDATE ag.survey_response SET spanish = 'Puerto Rico', french = 'Porto Rico', chinese = '波多黎各' WHERE american = 'Puerto Rico';
UPDATE ag.survey_response SET spanish = 'Katar', french = 'Qatar', chinese = '卡塔尔' WHERE american = 'Qatar';
UPDATE ag.survey_response SET spanish = 'Reunión', french = 'Réunion', chinese = '团圆' WHERE american = 'Reunion';
UPDATE ag.survey_response SET spanish = 'Rumania', french = 'Roumanie', chinese = '罗马尼亚' WHERE american = 'Romania';
UPDATE ag.survey_response SET spanish = 'Federación Rusa', french = 'Fédération Russe', chinese = '俄罗斯联邦' WHERE american = 'Russian Federation';
UPDATE ag.survey_response SET spanish = 'Ruanda', french = 'Rwanda', chinese = '卢旺达' WHERE american = 'Rwanda';
UPDATE ag.survey_response SET spanish = 'Santa helena', french = 'Sainte-Hélène', chinese = '圣海伦娜' WHERE american = 'Saint Helena';
UPDATE ag.survey_response SET spanish = 'San Cristóbal y Nieves', french = 'Saint-Christophe-et-Niévès', chinese = '圣基茨和尼维斯' WHERE american = 'Saint Kitts and Nevis';
UPDATE ag.survey_response SET spanish = 'Santa Lucía', french = 'Sainte-Lucie', chinese = '圣卢西亚' WHERE american = 'Saint Lucia';
UPDATE ag.survey_response SET spanish = 'San Pedro y Miquelón', french = 'Saint-Pierre-et-Miquelon', chinese = '圣皮埃尔和密克隆群岛' WHERE american = 'Saint Pierre and Miquelon';
UPDATE ag.survey_response SET spanish = 'San Vicente y las Granadinas', french = 'Saint-Vincent-et-les-Grenadines', chinese = '圣文森特和格林纳丁斯' WHERE american = 'Saint Vincent and The Grenadines';
UPDATE ag.survey_response SET spanish = 'Samoa', french = 'Samoa', chinese = '萨摩亚' WHERE american = 'Samoa';
UPDATE ag.survey_response SET spanish = 'San Marino', french = 'Saint Marin', chinese = '圣马力诺' WHERE american = 'San Marino';
UPDATE ag.survey_response SET spanish = 'Santo Tomé y Príncipe', french = 'Sao Tomé et Principe', chinese = '圣多美和普林西比' WHERE american = 'Sao Tome and Principe';
UPDATE ag.survey_response SET spanish = 'Arabia Saudita', french = 'Arabie Saoudite', chinese = '沙特阿拉伯' WHERE american = 'Saudi Arabia';
UPDATE ag.survey_response SET spanish = 'Senegal', french = 'Sénégal', chinese = '塞内加尔' WHERE american = 'Senegal';
UPDATE ag.survey_response SET spanish = 'Serbia', french = 'Serbie', chinese = '塞尔维亚' WHERE american = 'Serbia';
UPDATE ag.survey_response SET spanish = 'Seychelles', french = 'les Seychelles', chinese = '塞舌尔' WHERE american = 'Seychelles';
UPDATE ag.survey_response SET spanish = 'Sierra Leona', french = 'Sierra Leone', chinese = '塞拉利昂' WHERE american = 'Sierra Leone';
UPDATE ag.survey_response SET spanish = 'Singapur', french = 'Singapour', chinese = '新加坡' WHERE american = 'Singapore';
UPDATE ag.survey_response SET spanish = 'Eslovaquia', french = 'Slovaquie', chinese = '斯洛伐克' WHERE american = 'Slovakia';
UPDATE ag.survey_response SET spanish = 'Eslovenia', french = 'Slovénie', chinese = '斯洛文尼亚' WHERE american = 'Slovenia';
UPDATE ag.survey_response SET spanish = 'Islas Salomón', french = 'Les îles Salomon', chinese = '所罗门群岛' WHERE american = 'Solomon Islands';
UPDATE ag.survey_response SET spanish = 'Somalia', french = 'Somalie', chinese = '索马里' WHERE american = 'Somalia';
UPDATE ag.survey_response SET spanish = 'Sudáfrica', french = 'Afrique du Sud', chinese = '南非' WHERE american = 'South Africa';
UPDATE ag.survey_response SET spanish = 'Georgia del sur y las islas Sandwich del sur', french = 'Géorgie du Sud et les îles Sandwich du Sud', chinese = '南乔治亚岛和南桑威奇群岛' WHERE american = 'South Georgia and The South Sandwich Islands';
UPDATE ag.survey_response SET spanish = 'España', french = 'Espagne', chinese = '西班牙' WHERE american = 'Spain';
UPDATE ag.survey_response SET spanish = 'Sri Lanka', french = 'Sri Lanka', chinese = '斯里兰卡' WHERE american = 'Sri Lanka';
UPDATE ag.survey_response SET spanish = 'Sudán', french = 'Soudan', chinese = '苏丹' WHERE american = 'Sudan';
UPDATE ag.survey_response SET spanish = 'Surinam', french = 'Suriname', chinese = '苏里南' WHERE american = 'Suriname';
UPDATE ag.survey_response SET spanish = 'Svalbard y Jan Mayen', french = 'Svalbard et Jan Mayen', chinese = '斯瓦尔巴和扬·马延' WHERE american = 'Svalbard and Jan Mayen';
UPDATE ag.survey_response SET spanish = 'Swazilandia', french = 'Swaziland', chinese = '斯威士兰' WHERE american = 'Swaziland';
UPDATE ag.survey_response SET spanish = 'Suecia', french = 'Suède', chinese = '瑞典' WHERE american = 'Sweden';
UPDATE ag.survey_response SET spanish = 'Suiza', french = 'Suisse', chinese = '瑞士' WHERE american = 'Switzerland';
UPDATE ag.survey_response SET spanish = 'República Árabe Siria', french = 'République arabe syrienne', chinese = '阿拉伯叙利亚共和国' WHERE american = 'Syrian Arab Republic';
UPDATE ag.survey_response SET spanish = 'Taiwan, provincia de China', french = 'Taiwan, Province de Chine', chinese = '中国台湾省' WHERE american = 'Taiwan, Province of China';
UPDATE ag.survey_response SET spanish = 'Tayikistán', french = 'Tadjikistan', chinese = '塔吉克斯坦' WHERE american = 'Tajikistan';
UPDATE ag.survey_response SET spanish = 'Tanzania, República Unida de', french = 'Tanzanie, République-Unie de', chinese = '坦桑尼亚联合共和国' WHERE american = 'Tanzania, United Republic of';
UPDATE ag.survey_response SET spanish = 'Tailandia', french = 'Thaïlande', chinese = '泰国' WHERE american = 'Thailand';
UPDATE ag.survey_response SET spanish = 'Timor-leste', french = 'Timor-leste', chinese = '东帝汶' WHERE american = 'Timor-leste';
UPDATE ag.survey_response SET spanish = 'Ir', french = 'Aller', chinese = '多哥' WHERE american = 'Togo';
UPDATE ag.survey_response SET spanish = 'Tokelau', french = 'Tokelau', chinese = '托克劳' WHERE american = 'Tokelau';
UPDATE ag.survey_response SET spanish = 'Tonga', french = 'Tonga', chinese = '汤加' WHERE american = 'Tonga';
UPDATE ag.survey_response SET spanish = 'Trinidad y Tobago', french = 'Trinité-et-Tobago', chinese = '特立尼达和多巴哥' WHERE american = 'Trinidad and Tobago';
UPDATE ag.survey_response SET spanish = 'Túnez', french = 'Tunisie', chinese = '突尼斯' WHERE american = 'Tunisia';
UPDATE ag.survey_response SET spanish = 'pavo', french = 'Turquie', chinese = '火鸡' WHERE american = 'Turkey';
UPDATE ag.survey_response SET spanish = 'Turkmenistán', french = 'Turkménistan', chinese = '土库曼斯坦' WHERE american = 'Turkmenistan';
UPDATE ag.survey_response SET spanish = 'Islas Turcas y Caicos', french = 'îles Turques-et-Caïques', chinese = '特克斯和凯科斯群岛' WHERE american = 'Turks and Caicos Islands';
UPDATE ag.survey_response SET spanish = 'Tuvalu', french = 'Tuvalu', chinese = '图瓦卢' WHERE american = 'Tuvalu';
UPDATE ag.survey_response SET spanish = 'Uganda', french = 'Ouganda', chinese = '乌干达' WHERE american = 'Uganda';
UPDATE ag.survey_response SET spanish = 'Ucrania', french = 'Ukraine', chinese = '乌克兰' WHERE american = 'Ukraine';
UPDATE ag.survey_response SET spanish = 'Emiratos Árabes Unidos', french = 'Emirats Arabes Unis', chinese = '阿拉伯联合酋长国' WHERE american = 'United Arab Emirates';
UPDATE ag.survey_response SET spanish = 'Reino Unido', french = 'Royaume-Uni', chinese = '英国' WHERE american = 'United Kingdom';
UPDATE ag.survey_response SET spanish = 'Estados Unidos', french = 'États Unis', chinese = '美国' WHERE american = 'United States';
UPDATE ag.survey_response SET spanish = 'Islas ultramarinas menores de Estados Unidos', french = 'Îles mineures éloignées des États-Unis', chinese = '美国本土外小岛屿' WHERE american = 'United States Minor Outlying Islands';
UPDATE ag.survey_response SET spanish = 'Uruguay', french = 'Uruguay', chinese = '乌拉圭' WHERE american = 'Uruguay';
UPDATE ag.survey_response SET spanish = 'Uzbekistán', french = 'Ouzbékistan', chinese = '乌兹别克斯坦' WHERE american = 'Uzbekistan';
UPDATE ag.survey_response SET spanish = 'Vanuatu', french = 'Vanuatu', chinese = '瓦努阿图' WHERE american = 'Vanuatu';
UPDATE ag.survey_response SET spanish = 'Venezuela', french = 'Venezuela', chinese = '委内瑞拉' WHERE american = 'Venezuela';
UPDATE ag.survey_response SET spanish = 'Vietnam', french = 'Viet Nam', chinese = '越南' WHERE american = 'Viet Nam';
UPDATE ag.survey_response SET spanish = 'Islas Vírgenes Británicas', french = 'Îles Vierges britanniques', chinese = '英属维尔京群岛' WHERE american = 'Virgin Islands, British';
UPDATE ag.survey_response SET spanish = 'Islas Vírgenes, EE. UU.', french = 'Îles Vierges américaines', chinese = '美国维尔京群岛' WHERE american = 'Virgin Islands, U.S.';
UPDATE ag.survey_response SET spanish = 'Wallis y Futuna', french = 'Wallis et Futuna', chinese = '瓦利斯和富图纳群岛' WHERE american = 'Wallis and Futuna';
UPDATE ag.survey_response SET spanish = 'Sahara Occidental', french = 'Sahara occidental', chinese = '撒哈拉沙漠西部' WHERE american = 'Western Sahara';
UPDATE ag.survey_response SET spanish = 'Yemen', french = 'Yémen', chinese = '也门' WHERE american = 'Yemen';
UPDATE ag.survey_response SET spanish = 'Zambia', french = 'Zambie', chinese = '赞比亚' WHERE american = 'Zambia';
UPDATE ag.survey_response SET spanish = 'Zimbabue', french = 'Zimbabwe', chinese = '津巴布韦' WHERE american = 'Zimbabwe';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'enero', french = 'janvier', chinese = '一月' WHERE american = 'January';
UPDATE ag.survey_response SET spanish = 'febrero', french = 'février', chinese = '二月' WHERE american = 'February';
UPDATE ag.survey_response SET spanish = 'marzo', french = 'Mars', chinese = '游行' WHERE american = 'March';
UPDATE ag.survey_response SET spanish = 'abril', french = 'avril', chinese = '四月' WHERE american = 'April';
UPDATE ag.survey_response SET spanish = 'mayo', french = 'Mai', chinese = '可以' WHERE american = 'May';
UPDATE ag.survey_response SET spanish = 'junio', french = 'juin', chinese = '六月' WHERE american = 'June';
UPDATE ag.survey_response SET spanish = 'julio', french = 'juillet', chinese = '七月' WHERE american = 'July';
UPDATE ag.survey_response SET spanish = 'agosto', french = 'août', chinese = '八月' WHERE american = 'August';
UPDATE ag.survey_response SET spanish = 'septiembre', french = 'septembre', chinese = '九月' WHERE american = 'September';
UPDATE ag.survey_response SET spanish = 'octubre', french = 'octobre', chinese = '十月' WHERE american = 'October';
UPDATE ag.survey_response SET spanish = 'noviembre', french = 'novembre', chinese = '十一月' WHERE american = 'November';
UPDATE ag.survey_response SET spanish = 'diciembre', french = 'décembre', chinese = '十二月' WHERE american = 'December';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'libras', french = 'livres', chinese = '英镑' WHERE american = 'pounds';
UPDATE ag.survey_response SET spanish = 'kilogramos', french = 'kilogrammes', chinese = '公斤' WHERE american = 'kilograms';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Agua del acueducto local', french = 'Eau du robinet', chinese = '城市水' WHERE american = 'City';
UPDATE ag.survey_response SET spanish = 'Agua de pozo', french = 'Puits', chinese = '井水' WHERE american = 'Well';
UPDATE ag.survey_response SET spanish = 'Agua embotellada', french = 'Bouteille', chinese = '瓶装水' WHERE american = 'Bottled';
UPDATE ag.survey_response SET spanish = 'Agua filtrada', french = 'Filtrée', chinese = '过滤水' WHERE american = 'Filtered';
UPDATE ag.survey_response SET spanish = 'No estoy seguro', french = 'Je ne sais pas', chinese = '不确定' WHERE american = 'Not sure';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Blanco', french = 'Caucasienne', chinese = '白种人' WHERE american = 'Caucasian';
UPDATE ag.survey_response SET spanish = 'Asiático o isleño del Pacífico', french = 'Asiatique ou insulaire du Pacifique', chinese = '亚洲人或太平洋岛民' WHERE american = 'Asian or Pacific Islander';
UPDATE ag.survey_response SET spanish = 'Afroamericano', french = 'Afro-américaine', chinese = '非裔美国人' WHERE american = 'African American';
UPDATE ag.survey_response SET spanish = 'Hispano', french = 'Hispanique', chinese = '西班牙人' WHERE american = 'Hispanic';
UPDATE ag.survey_response SET spanish = 'Otro', french = 'Autre', chinese = '其他' WHERE american = 'Other';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Menos de 5', french = 'Moins de 5', chinese = '小于 5 种' WHERE american = 'Less than 5';
UPDATE ag.survey_response SET spanish = 'De 6 a 10', french = '6 à 10', chinese = '6 到 10 种' WHERE american = '6 to 10';
UPDATE ag.survey_response SET spanish = 'De 11 a 20', french = '11 à 20', chinese = '11 到 20 种' WHERE american = '11 to 20';
UPDATE ag.survey_response SET spanish = 'De 21 a 30', french = '21 à 30', chinese = '21 到 30 种' WHERE american = '21 to 30';
UPDATE ag.survey_response SET spanish = 'Más de 30', french = 'Plus de 30', chinese = '多于 30 种' WHERE american = 'More than 30';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Afganistán', french = 'Afghanistan', chinese = '阿富汗' WHERE american = 'Afghanistan';
UPDATE ag.survey_response SET spanish = 'Islas Aland', french = 'Iles Aland', chinese = '奥兰群岛' WHERE american = 'Aland Islands';
UPDATE ag.survey_response SET spanish = 'Albania', french = 'Albanie', chinese = '阿尔巴尼亚' WHERE american = 'Albania';
UPDATE ag.survey_response SET spanish = 'Argelia', french = 'Algérie', chinese = '阿尔及利亚' WHERE american = 'Algeria';
UPDATE ag.survey_response SET spanish = 'Samoa Americana', french = 'Samoa américaines', chinese = '美属萨摩亚' WHERE american = 'American Samoa';
UPDATE ag.survey_response SET spanish = 'Andorra', french = 'Andorre', chinese = '安道尔' WHERE american = 'Andorra';
UPDATE ag.survey_response SET spanish = 'Angola', french = 'Angola', chinese = '安哥拉' WHERE american = 'Angola';
UPDATE ag.survey_response SET spanish = 'Anguila', french = 'Anguilla', chinese = '安圭拉岛' WHERE american = 'Anguilla';
UPDATE ag.survey_response SET spanish = 'Antártida', french = 'Antarctique', chinese = '南极洲' WHERE american = 'Antarctica';
UPDATE ag.survey_response SET spanish = 'Antigua y Barbuda', french = 'Antigua-et-Barbuda', chinese = '安提瓜和巴布达' WHERE american = 'Antigua and Barbuda';
UPDATE ag.survey_response SET spanish = 'Argentina', french = 'Argentine', chinese = '阿根廷' WHERE american = 'Argentina';
UPDATE ag.survey_response SET spanish = 'Armenia', french = 'Arménie', chinese = '亚美尼亚' WHERE american = 'Armenia';
UPDATE ag.survey_response SET spanish = 'Aruba', french = 'Aruba', chinese = '阿鲁巴岛' WHERE american = 'Aruba';
UPDATE ag.survey_response SET spanish = 'Australia', french = 'Australie', chinese = '澳大利亚' WHERE american = 'Australia';
UPDATE ag.survey_response SET spanish = 'Austria', french = 'L''Autriche', chinese = '奥地利' WHERE american = 'Austria';
UPDATE ag.survey_response SET spanish = 'Azerbaiyán', french = 'Azerbaïdjan', chinese = '阿塞拜疆' WHERE american = 'Azerbaijan';
UPDATE ag.survey_response SET spanish = 'Bahamas', french = 'Bahamas', chinese = '巴哈马' WHERE american = 'Bahamas';
UPDATE ag.survey_response SET spanish = 'Bahrein', french = 'Bahrein', chinese = '巴林' WHERE american = 'Bahrain';
UPDATE ag.survey_response SET spanish = 'Bangladesh', french = 'Bangladesh', chinese = '孟加拉国' WHERE american = 'Bangladesh';
UPDATE ag.survey_response SET spanish = 'Barbados', french = 'Barbade', chinese = '巴巴多斯' WHERE american = 'Barbados';
UPDATE ag.survey_response SET spanish = 'Bielorrusia', french = 'Biélorussie', chinese = '白俄罗斯' WHERE american = 'Belarus';
UPDATE ag.survey_response SET spanish = 'Bélgica', french = 'Belgique', chinese = '比利时' WHERE american = 'Belgium';
UPDATE ag.survey_response SET spanish = 'Belice', french = 'Belize', chinese = '伯利兹' WHERE american = 'Belize';
UPDATE ag.survey_response SET spanish = 'Benin', french = 'Bénin', chinese = '贝宁' WHERE american = 'Benin';
UPDATE ag.survey_response SET spanish = 'islas Bermudas', french = 'Bermudes', chinese = '百慕大' WHERE american = 'Bermuda';
UPDATE ag.survey_response SET spanish = 'Bután', french = 'Bhoutan', chinese = '不丹' WHERE american = 'Bhutan';
UPDATE ag.survey_response SET spanish = 'Bolivia', french = 'Bolivie', chinese = '玻利维亚' WHERE american = 'Bolivia';
UPDATE ag.survey_response SET spanish = 'Bosnia y Herzegovina', french = 'Bosnie Herzégovine', chinese = '波斯尼亚和黑塞哥维那' WHERE american = 'Bosnia and Herzegovina';
UPDATE ag.survey_response SET spanish = 'Botsuana', french = 'Botswana', chinese = '博茨瓦纳' WHERE american = 'Botswana';
UPDATE ag.survey_response SET spanish = 'Isla Bouvet', french = 'Île Bouvet', chinese = '布维岛' WHERE american = 'Bouvet Island';
UPDATE ag.survey_response SET spanish = 'Brasil', french = 'Brésil', chinese = '巴西' WHERE american = 'Brazil';
UPDATE ag.survey_response SET spanish = 'Territorio Británico del Océano Índico', french = 'Territoire britannique de l''océan Indien', chinese = '英属印度洋领地' WHERE american = 'British Indian Ocean Territory';
UPDATE ag.survey_response SET spanish = 'Brunei Darussalam', french = 'Brunei Darussalam', chinese = '文莱达鲁萨兰国' WHERE american = 'Brunei Darussalam';
UPDATE ag.survey_response SET spanish = 'Bulgaria', french = 'Bulgarie', chinese = '保加利亚' WHERE american = 'Bulgaria';
UPDATE ag.survey_response SET spanish = 'Burkina Faso', french = 'Burkina Faso', chinese = '布基纳法索' WHERE american = 'Burkina Faso';
UPDATE ag.survey_response SET spanish = 'Burundi', french = 'Burundi', chinese = '布隆迪' WHERE american = 'Burundi';
UPDATE ag.survey_response SET spanish = 'Camboya', french = 'Cambodge', chinese = '柬埔寨' WHERE american = 'Cambodia';
UPDATE ag.survey_response SET spanish = 'Camerún', french = 'Cameroun', chinese = '喀麦隆' WHERE american = 'Cameroon';
UPDATE ag.survey_response SET spanish = 'Canadá', french = 'Canada', chinese = '加拿大' WHERE american = 'Canada';
UPDATE ag.survey_response SET spanish = 'Cabo Verde', french = 'Cap-Vert', chinese = '佛得角' WHERE american = 'Cape Verde';
UPDATE ag.survey_response SET spanish = 'Islas Caimán', french = 'Îles Caïmans', chinese = '开曼群岛' WHERE american = 'Cayman Islands';
UPDATE ag.survey_response SET spanish = 'República Centroafricana', french = 'République centrafricaine', chinese = '中非共和国' WHERE american = 'Central African Republic';
UPDATE ag.survey_response SET spanish = 'Chad', french = 'Tchad', chinese = '乍得' WHERE american = 'Chad';
UPDATE ag.survey_response SET spanish = 'Chile', french = 'Chili', chinese = '智利' WHERE american = 'Chile';
UPDATE ag.survey_response SET spanish = 'China', french = 'Chine', chinese = '中国' WHERE american = 'China';
UPDATE ag.survey_response SET spanish = 'Isla de Navidad', french = 'L''île de noël', chinese = '圣诞岛' WHERE american = 'Christmas Island';
UPDATE ag.survey_response SET spanish = 'Islas Cocos (Keeling)', french = 'Îles Cocos (Keeling)', chinese = '科科斯(基林)群岛' WHERE american = 'Cocos (Keeling) Islands';
UPDATE ag.survey_response SET spanish = 'Colombia', french = 'Colombie', chinese = '哥伦比亚' WHERE american = 'Colombia';
UPDATE ag.survey_response SET spanish = 'Comoras', french = 'Comores', chinese = '科摩罗' WHERE american = 'Comoros';
UPDATE ag.survey_response SET spanish = 'Congo', french = 'Congo', chinese = '刚果' WHERE american = 'Congo';
UPDATE ag.survey_response SET spanish = 'Congo, República Democrática del', french = 'Congo, République démocratique du', chinese = '刚果民主共和国' WHERE american = 'Congo, The Democratic Republic of The';
UPDATE ag.survey_response SET spanish = 'Islas Cook', french = 'les Îles Cook', chinese = '库克群岛' WHERE american = 'Cook Islands';
UPDATE ag.survey_response SET spanish = 'Costa Rica', french = 'Costa Rica', chinese = '哥斯达黎加' WHERE american = 'Costa Rica';
UPDATE ag.survey_response SET spanish = 'Costa de Marfil', french = 'Côte d''Ivoire', chinese = '科特迪瓦' WHERE american = 'Cote D''ivoire';
UPDATE ag.survey_response SET spanish = 'Croacia', french = 'Croatie', chinese = '克罗地亚' WHERE american = 'Croatia';
UPDATE ag.survey_response SET spanish = 'Cuba', french = 'Cuba', chinese = '古巴' WHERE american = 'Cuba';
UPDATE ag.survey_response SET spanish = 'Chipre', french = 'Chypre', chinese = '塞浦路斯' WHERE american = 'Cyprus';
UPDATE ag.survey_response SET spanish = 'Republica checa', french = 'République Tchèque', chinese = '捷克共和国' WHERE american = 'Czech Republic';
UPDATE ag.survey_response SET spanish = 'Dinamarca', french = 'Danemark', chinese = '丹麦' WHERE american = 'Denmark';
UPDATE ag.survey_response SET spanish = 'Djibouti', french = 'Djibouti', chinese = '吉布地' WHERE american = 'Djibouti';
UPDATE ag.survey_response SET spanish = 'Dominica', french = 'Dominique', chinese = '多米尼加' WHERE american = 'Dominica';
UPDATE ag.survey_response SET spanish = 'República Dominicana', french = 'République Dominicaine', chinese = '多明尼加共和国' WHERE american = 'Dominican Republic';
UPDATE ag.survey_response SET spanish = 'Ecuador', french = 'Équateur', chinese = '厄瓜多尔' WHERE american = 'Ecuador';
UPDATE ag.survey_response SET spanish = 'Egipto', french = 'Egypte', chinese = '埃及' WHERE american = 'Egypt';
UPDATE ag.survey_response SET spanish = 'El Salvador', french = 'Le Salvador', chinese = '萨尔瓦多' WHERE american = 'El Salvador';
UPDATE ag.survey_response SET spanish = 'Guinea Ecuatorial', french = 'Guinée Équatoriale', chinese = '赤道几内亚' WHERE american = 'Equatorial Guinea';
UPDATE ag.survey_response SET spanish = 'Eritrea', french = 'Érythrée', chinese = '厄立特里亚' WHERE american = 'Eritrea';
UPDATE ag.survey_response SET spanish = 'Estonia', french = 'Estonie', chinese = '爱沙尼亚' WHERE american = 'Estonia';
UPDATE ag.survey_response SET spanish = 'Etiopía', french = 'Ethiopie', chinese = '埃塞俄比亚' WHERE american = 'Ethiopia';
UPDATE ag.survey_response SET spanish = 'Islas Malvinas (Falkland Islands)', french = 'Îles Falkland (Malvinas)', chinese = '福克兰群岛(马尔维纳斯)' WHERE american = 'Falkland Islands (Malvinas)';
UPDATE ag.survey_response SET spanish = 'Islas Faroe', french = 'Îles Féroé', chinese = '法罗群岛' WHERE american = 'Faroe Islands';
UPDATE ag.survey_response SET spanish = 'Fiyi', french = 'Fidji', chinese = '斐济' WHERE american = 'Fiji';
UPDATE ag.survey_response SET spanish = 'Finlandia', french = 'Finlande', chinese = '芬兰' WHERE american = 'Finland';
UPDATE ag.survey_response SET spanish = 'Francia', french = 'France', chinese = '法国' WHERE american = 'France';
UPDATE ag.survey_response SET spanish = 'Guayana Francesa', french = 'Guyane Française', chinese = '法属圭亚那' WHERE american = 'French Guiana';
UPDATE ag.survey_response SET spanish = 'Polinesia francés', french = 'Polynésie française', chinese = '法属波利尼西亚' WHERE american = 'French Polynesia';
UPDATE ag.survey_response SET spanish = 'Territorios Franceses del Sur', french = 'Territoires français du Sud', chinese = '法属南部领地' WHERE american = 'French Southern Territories';
UPDATE ag.survey_response SET spanish = 'Gabón', french = 'Gabon', chinese = '加蓬' WHERE american = 'Gabon';
UPDATE ag.survey_response SET spanish = 'Gambia', french = 'Gambie', chinese = '冈比亚' WHERE american = 'Gambia';
UPDATE ag.survey_response SET spanish = 'Georgia', french = 'Géorgie', chinese = '佐治亚州' WHERE american = 'Georgia';
UPDATE ag.survey_response SET spanish = 'Alemania', french = 'Allemagne', chinese = '德国' WHERE american = 'Germany';
UPDATE ag.survey_response SET spanish = 'Ghana', french = 'Ghana', chinese = '加纳' WHERE american = 'Ghana';
UPDATE ag.survey_response SET spanish = 'Gibraltar', french = 'Gibraltar', chinese = '直布罗陀' WHERE american = 'Gibraltar';
UPDATE ag.survey_response SET spanish = 'Grecia', french = 'Grèce', chinese = '希腊' WHERE american = 'Greece';
UPDATE ag.survey_response SET spanish = 'Groenlandia', french = 'Groenland', chinese = '格陵兰' WHERE american = 'Greenland';
UPDATE ag.survey_response SET spanish = 'Granada', french = 'Grenade', chinese = '格林纳达' WHERE american = 'Grenada';
UPDATE ag.survey_response SET spanish = 'Guadalupe', french = 'Guadeloupe', chinese = '瓜德罗普岛' WHERE american = 'Guadeloupe';
UPDATE ag.survey_response SET spanish = 'Guam', french = 'Guam', chinese = '关岛' WHERE american = 'Guam';
UPDATE ag.survey_response SET spanish = 'Guatemala', french = 'Guatemala', chinese = '危地马拉' WHERE american = 'Guatemala';
UPDATE ag.survey_response SET spanish = 'Guernsey', french = 'Guernesey', chinese = '根西岛' WHERE american = 'Guernsey';
UPDATE ag.survey_response SET spanish = 'Guinea', french = 'Guinée', chinese = '几内亚' WHERE american = 'Guinea';
UPDATE ag.survey_response SET spanish = 'Guinea-Bissau', french = 'Guinée-bissau', chinese = '几内亚比绍' WHERE american = 'Guinea-bissau';
UPDATE ag.survey_response SET spanish = 'Guayana', french = 'Guyane', chinese = '圭亚那' WHERE american = 'Guyana';
UPDATE ag.survey_response SET spanish = 'Haití', french = 'Haïti', chinese = '海地' WHERE american = 'Haiti';
UPDATE ag.survey_response SET spanish = 'Islas Heard y Mcdonald', french = 'Îles Heard et Mcdonald', chinese = '希尔德岛和麦当劳群岛' WHERE american = 'Heard Island and Mcdonald Islands';
UPDATE ag.survey_response SET spanish = 'Santa Sede (Estado de la Ciudad del Vaticano)', french = 'Saint-Siège (État de la Cité du Vatican)', chinese = '罗马教廷(梵蒂冈城国)' WHERE american = 'Holy See (Vatican City State)';
UPDATE ag.survey_response SET spanish = 'Honduras', french = 'Honduras', chinese = '洪都拉斯' WHERE american = 'Honduras';
UPDATE ag.survey_response SET spanish = 'Hong Kong', french = 'Hong Kong', chinese = '香港' WHERE american = 'Hong Kong';
UPDATE ag.survey_response SET spanish = 'Hungría', french = 'Hongrie', chinese = '匈牙利' WHERE american = 'Hungary';
UPDATE ag.survey_response SET spanish = 'Islandia', french = 'Islande', chinese = '冰岛' WHERE american = 'Iceland';
UPDATE ag.survey_response SET spanish = 'India', french = 'Inde', chinese = '印度' WHERE american = 'India';
UPDATE ag.survey_response SET spanish = 'Indonesia', french = 'Indonésie', chinese = '印度尼西亚' WHERE american = 'Indonesia';
UPDATE ag.survey_response SET spanish = 'Irán (República Islámica de', french = 'Iran (République islamique d', chinese = '伊朗伊斯兰共和国' WHERE american = 'Iran, Islamic Republic of';
UPDATE ag.survey_response SET spanish = 'Irak', french = 'Irak', chinese = '伊拉克' WHERE american = 'Iraq';
UPDATE ag.survey_response SET spanish = 'Irlanda', french = 'Irlande', chinese = '爱尔兰' WHERE american = 'Ireland';
UPDATE ag.survey_response SET spanish = 'Isla del hombre', french = 'île de Man', chinese = '马恩岛' WHERE american = 'Isle of Man';
UPDATE ag.survey_response SET spanish = 'Israel', french = 'Israël', chinese = '以色列' WHERE american = 'Israel';
UPDATE ag.survey_response SET spanish = 'Italia', french = 'Italie', chinese = '意大利' WHERE american = 'Italy';
UPDATE ag.survey_response SET spanish = 'Jamaica', french = 'Jamaïque', chinese = '牙买加' WHERE american = 'Jamaica';
UPDATE ag.survey_response SET spanish = 'Japón', french = 'Japon', chinese = '日本' WHERE american = 'Japan';
UPDATE ag.survey_response SET spanish = 'Jersey', french = 'Jersey', chinese = '泽西岛' WHERE american = 'Jersey';
UPDATE ag.survey_response SET spanish = 'Jordán', french = 'Jordan', chinese = '约旦' WHERE american = 'Jordan';
UPDATE ag.survey_response SET spanish = 'Kazajstán', french = 'Kazakhstan', chinese = '哈萨克斯坦' WHERE american = 'Kazakhstan';
UPDATE ag.survey_response SET spanish = 'Kenia', french = 'Kenya', chinese = '肯尼亚' WHERE american = 'Kenya';
UPDATE ag.survey_response SET spanish = 'Kiribati', french = 'Kiribati', chinese = '基里巴斯' WHERE american = 'Kiribati';
UPDATE ag.survey_response SET spanish = 'República de Corea, Popular Democrática de', french = 'République populaire démocratique de Corée', chinese = '韩国,朝鲜民主主义人民共和国' WHERE american = 'Korea, Democratic People''s Republic of';
UPDATE ag.survey_response SET spanish = 'Corea, república de', french = 'Corée, République de', chinese = '韩国' WHERE american = 'Korea, Republic of';
UPDATE ag.survey_response SET spanish = 'Kuwait', french = 'Koweit', chinese = '科威特' WHERE american = 'Kuwait';
UPDATE ag.survey_response SET spanish = 'Kirguistán', french = 'Kirghizistan', chinese = '吉尔吉斯斯坦' WHERE american = 'Kyrgyzstan';
UPDATE ag.survey_response SET spanish = 'República Democrática Popular Lao', french = 'République démocratique populaire lao', chinese = '老挝人民民主共和国' WHERE american = 'Lao People''s Democratic Republic';
UPDATE ag.survey_response SET spanish = 'Letonia', french = 'Lettonie', chinese = '拉脱维亚' WHERE american = 'Latvia';
UPDATE ag.survey_response SET spanish = 'Líbano', french = 'Liban', chinese = '黎巴嫩' WHERE american = 'Lebanon';
UPDATE ag.survey_response SET spanish = 'Lesoto', french = 'Lesotho', chinese = '莱索托' WHERE american = 'Lesotho';
UPDATE ag.survey_response SET spanish = 'Liberia', french = 'Libéria', chinese = '利比里亚' WHERE american = 'Liberia';
UPDATE ag.survey_response SET spanish = 'Jamahiriya Árabe Libia', french = 'Jamahiriya arabe libyenne', chinese = '阿拉伯利比亚民众国' WHERE american = 'Libya';
UPDATE ag.survey_response SET spanish = 'Liechtenstein', french = 'Liechtenstein', chinese = '列支敦士登' WHERE american = 'Liechtenstein';
UPDATE ag.survey_response SET spanish = 'Lituania', french = 'Lituanie', chinese = '立陶宛' WHERE american = 'Lithuania';
UPDATE ag.survey_response SET spanish = 'Luxemburgo', french = 'Luxembourg', chinese = '卢森堡' WHERE american = 'Luxembourg';
UPDATE ag.survey_response SET spanish = 'Macao', french = 'Macao', chinese = '澳门' WHERE american = 'Macao';
UPDATE ag.survey_response SET spanish = 'Macedonia, la ex República Yugoslava de', french = 'Macédoine, ancienne République yougoslave de', chinese = '马其顿,前南斯拉夫共和国' WHERE american = 'Macedonia, The Former Yugoslav Republic of';
UPDATE ag.survey_response SET spanish = 'Madagascar', french = 'Madagascar', chinese = '马达加斯加' WHERE american = 'Madagascar';
UPDATE ag.survey_response SET spanish = 'Malawi', french = 'Malawi', chinese = '马拉维' WHERE american = 'Malawi';
UPDATE ag.survey_response SET spanish = 'Malasia', french = 'Malaisie', chinese = '马来西亚' WHERE american = 'Malaysia';
UPDATE ag.survey_response SET spanish = 'Maldivas', french = 'Maldives', chinese = '马尔代夫' WHERE american = 'Maldives';
UPDATE ag.survey_response SET spanish = 'Mali', french = 'Mali', chinese = '马里' WHERE american = 'Mali';
UPDATE ag.survey_response SET spanish = 'Malta', french = 'Malte', chinese = '马耳他' WHERE american = 'Malta';
UPDATE ag.survey_response SET spanish = 'Islas Marshall', french = 'Iles Marshall', chinese = '马绍尔群岛' WHERE american = 'Marshall Islands';
UPDATE ag.survey_response SET spanish = 'Martinica', french = 'Martinique', chinese = '马提尼克岛' WHERE american = 'Martinique';
UPDATE ag.survey_response SET spanish = 'Mauritania', french = 'Mauritanie', chinese = '毛里塔尼亚' WHERE american = 'Mauritania';
UPDATE ag.survey_response SET spanish = 'Mauricio', french = 'Maurice', chinese = '毛里求斯' WHERE american = 'Mauritius';
UPDATE ag.survey_response SET spanish = 'Mayotte', french = 'Mayotte', chinese = '马约特岛' WHERE american = 'Mayotte';
UPDATE ag.survey_response SET spanish = 'Mexico', french = 'Mexique', chinese = '墨西哥' WHERE american = 'Mexico';
UPDATE ag.survey_response SET spanish = 'Micronesia, Estados Federados de', french = 'Micronésie, États fédérés de', chinese = '密克罗尼西亚联邦' WHERE american = 'Micronesia, Federated States of';
UPDATE ag.survey_response SET spanish = 'Moldavia, República de', french = 'Moldova, République de', chinese = '摩尔多瓦共和国' WHERE american = 'Moldova, Republic of';
UPDATE ag.survey_response SET spanish = 'Mónaco', french = 'Monaco', chinese = '摩纳哥' WHERE american = 'Monaco';
UPDATE ag.survey_response SET spanish = 'Mongolia', french = 'Mongolie', chinese = '蒙古' WHERE american = 'Mongolia';
UPDATE ag.survey_response SET spanish = 'Montenegro', french = 'Monténégro', chinese = '黑山共和国' WHERE american = 'Montenegro';
UPDATE ag.survey_response SET spanish = 'Montserrat', french = 'Montserrat', chinese = '蒙特塞拉特' WHERE american = 'Montserrat';
UPDATE ag.survey_response SET spanish = 'Marruecos', french = 'Maroc', chinese = '摩洛哥' WHERE american = 'Morocco';
UPDATE ag.survey_response SET spanish = 'Mozambique', french = 'Mozambique', chinese = '莫桑比克' WHERE american = 'Mozambique';
UPDATE ag.survey_response SET spanish = 'Myanmar', french = 'Myanmar', chinese = '缅甸' WHERE american = 'Myanmar';
UPDATE ag.survey_response SET spanish = 'Namibia', french = 'Namibie', chinese = '纳米比亚' WHERE american = 'Namibia';
UPDATE ag.survey_response SET spanish = 'Nauru', french = 'Nauru', chinese = '瑙鲁' WHERE american = 'Nauru';
UPDATE ag.survey_response SET spanish = 'Nepal', french = 'Népal', chinese = '尼泊尔' WHERE american = 'Nepal';
UPDATE ag.survey_response SET spanish = 'Países Bajos', french = 'Pays-Bas', chinese = '荷兰' WHERE american = 'Netherlands';
UPDATE ag.survey_response SET spanish = 'Antillas Holandesas', french = 'Antilles néerlandaises', chinese = '荷属安的列斯' WHERE american = 'Netherlands Antilles';
UPDATE ag.survey_response SET spanish = 'Nueva Caledonia', french = 'Nouvelle Calédonie', chinese = '新喀里多尼亚' WHERE american = 'New Caledonia';
UPDATE ag.survey_response SET spanish = 'Nueva Zelanda', french = 'Nouvelle-Zélande', chinese = '新西兰' WHERE american = 'New Zealand';
UPDATE ag.survey_response SET spanish = 'Nicaragua', french = 'Nicaragua', chinese = '尼加拉瓜' WHERE american = 'Nicaragua';
UPDATE ag.survey_response SET spanish = 'Níger', french = 'Niger', chinese = '尼日尔' WHERE american = 'Niger';
UPDATE ag.survey_response SET spanish = 'Nigeria', french = 'Nigeria', chinese = '奈及利亚' WHERE american = 'Nigeria';
UPDATE ag.survey_response SET spanish = 'Niue', french = 'Niue', chinese = '纽埃' WHERE american = 'Niue';
UPDATE ag.survey_response SET spanish = 'Isla Norfolk', french = 'l''ile de Norfolk', chinese = '诺福克岛' WHERE american = 'Norfolk Island';
UPDATE ag.survey_response SET spanish = 'Islas Marianas del Norte', french = 'Îles Mariannes du Nord', chinese = '北马里亚纳群岛' WHERE american = 'Northern Mariana Islands';
UPDATE ag.survey_response SET spanish = 'Noruega', french = 'Norvège', chinese = '挪威' WHERE american = 'Norway';
UPDATE ag.survey_response SET spanish = 'Omán', french = 'Oman', chinese = '阿曼' WHERE american = 'Oman';
UPDATE ag.survey_response SET spanish = 'Pakistán', french = 'Pakistan', chinese = '巴基斯坦' WHERE american = 'Pakistan';
UPDATE ag.survey_response SET spanish = 'Palau', french = 'Palau', chinese = 'u琉' WHERE american = 'Palau';
UPDATE ag.survey_response SET spanish = 'Territorio Palestino, Ocupado', french = 'Territoire palestinien, occupé', chinese = '被占领的巴勒斯坦领土' WHERE american = 'Palestinian Territory, Occupied';
UPDATE ag.survey_response SET spanish = 'Panamá', french = 'Panama', chinese = '巴拿马' WHERE american = 'Panama';
UPDATE ag.survey_response SET spanish = 'Papúa Nueva Guinea', french = 'Papouasie Nouvelle Guinée', chinese = '巴布亚新几内亚' WHERE american = 'Papua New Guinea';
UPDATE ag.survey_response SET spanish = 'Paraguay', french = 'Paraguay', chinese = '巴拉圭' WHERE american = 'Paraguay';
UPDATE ag.survey_response SET spanish = 'Perú', french = 'Pérou', chinese = '秘鲁' WHERE american = 'Peru';
UPDATE ag.survey_response SET spanish = 'Filipinas', french = 'Philippines', chinese = '菲律宾' WHERE american = 'Philippines';
UPDATE ag.survey_response SET spanish = 'Pitcairn', french = 'Pitcairn', chinese = '皮特凯恩' WHERE american = 'Pitcairn';
UPDATE ag.survey_response SET spanish = 'Polonia', french = 'Pologne', chinese = '波兰' WHERE american = 'Poland';
UPDATE ag.survey_response SET spanish = 'Portugal', french = 'le Portugal', chinese = '葡萄牙' WHERE american = 'Portugal';
UPDATE ag.survey_response SET spanish = 'Puerto Rico', french = 'Porto Rico', chinese = '波多黎各' WHERE american = 'Puerto Rico';
UPDATE ag.survey_response SET spanish = 'Katar', french = 'Qatar', chinese = '卡塔尔' WHERE american = 'Qatar';
UPDATE ag.survey_response SET spanish = 'Reunión', french = 'Réunion', chinese = '团圆' WHERE american = 'Reunion';
UPDATE ag.survey_response SET spanish = 'Rumania', french = 'Roumanie', chinese = '罗马尼亚' WHERE american = 'Romania';
UPDATE ag.survey_response SET spanish = 'Federación Rusa', french = 'Fédération Russe', chinese = '俄罗斯联邦' WHERE american = 'Russian Federation';
UPDATE ag.survey_response SET spanish = 'Ruanda', french = 'Rwanda', chinese = '卢旺达' WHERE american = 'Rwanda';
UPDATE ag.survey_response SET spanish = 'Santa helena', french = 'Sainte-Hélène', chinese = '圣海伦娜' WHERE american = 'Saint Helena';
UPDATE ag.survey_response SET spanish = 'San Cristóbal y Nieves', french = 'Saint-Christophe-et-Niévès', chinese = '圣基茨和尼维斯' WHERE american = 'Saint Kitts and Nevis';
UPDATE ag.survey_response SET spanish = 'Santa Lucía', french = 'Sainte-Lucie', chinese = '圣卢西亚' WHERE american = 'Saint Lucia';
UPDATE ag.survey_response SET spanish = 'San Pedro y Miquelón', french = 'Saint-Pierre-et-Miquelon', chinese = '圣皮埃尔和密克隆群岛' WHERE american = 'Saint Pierre and Miquelon';
UPDATE ag.survey_response SET spanish = 'San Vicente y las Granadinas', french = 'Saint-Vincent-et-les-Grenadines', chinese = '圣文森特和格林纳丁斯' WHERE american = 'Saint Vincent and The Grenadines';
UPDATE ag.survey_response SET spanish = 'Samoa', french = 'Samoa', chinese = '萨摩亚' WHERE american = 'Samoa';
UPDATE ag.survey_response SET spanish = 'San Marino', french = 'Saint Marin', chinese = '圣马力诺' WHERE american = 'San Marino';
UPDATE ag.survey_response SET spanish = 'Santo Tomé y Príncipe', french = 'Sao Tomé et Principe', chinese = '圣多美和普林西比' WHERE american = 'Sao Tome and Principe';
UPDATE ag.survey_response SET spanish = 'Arabia Saudita', french = 'Arabie Saoudite', chinese = '沙特阿拉伯' WHERE american = 'Saudi Arabia';
UPDATE ag.survey_response SET spanish = 'Senegal', french = 'Sénégal', chinese = '塞内加尔' WHERE american = 'Senegal';
UPDATE ag.survey_response SET spanish = 'Serbia', french = 'Serbie', chinese = '塞尔维亚' WHERE american = 'Serbia';
UPDATE ag.survey_response SET spanish = 'Seychelles', french = 'les Seychelles', chinese = '塞舌尔' WHERE american = 'Seychelles';
UPDATE ag.survey_response SET spanish = 'Sierra Leona', french = 'Sierra Leone', chinese = '塞拉利昂' WHERE american = 'Sierra Leone';
UPDATE ag.survey_response SET spanish = 'Singapur', french = 'Singapour', chinese = '新加坡' WHERE american = 'Singapore';
UPDATE ag.survey_response SET spanish = 'Eslovaquia', french = 'Slovaquie', chinese = '斯洛伐克' WHERE american = 'Slovakia';
UPDATE ag.survey_response SET spanish = 'Eslovenia', french = 'Slovénie', chinese = '斯洛文尼亚' WHERE american = 'Slovenia';
UPDATE ag.survey_response SET spanish = 'Islas Salomón', french = 'Les îles Salomon', chinese = '所罗门群岛' WHERE american = 'Solomon Islands';
UPDATE ag.survey_response SET spanish = 'Somalia', french = 'Somalie', chinese = '索马里' WHERE american = 'Somalia';
UPDATE ag.survey_response SET spanish = 'Sudáfrica', french = 'Afrique du Sud', chinese = '南非' WHERE american = 'South Africa';
UPDATE ag.survey_response SET spanish = 'Georgia del sur y las islas Sandwich del sur', french = 'Géorgie du Sud et les îles Sandwich du Sud', chinese = '南乔治亚岛和南桑威奇群岛' WHERE american = 'South Georgia and The South Sandwich Islands';
UPDATE ag.survey_response SET spanish = 'España', french = 'Espagne', chinese = '西班牙' WHERE american = 'Spain';
UPDATE ag.survey_response SET spanish = 'Sri Lanka', french = 'Sri Lanka', chinese = '斯里兰卡' WHERE american = 'Sri Lanka';
UPDATE ag.survey_response SET spanish = 'Sudán', french = 'Soudan', chinese = '苏丹' WHERE american = 'Sudan';
UPDATE ag.survey_response SET spanish = 'Surinam', french = 'Suriname', chinese = '苏里南' WHERE american = 'Suriname';
UPDATE ag.survey_response SET spanish = 'Svalbard y Jan Mayen', french = 'Svalbard et Jan Mayen', chinese = '斯瓦尔巴和扬·马延' WHERE american = 'Svalbard and Jan Mayen';
UPDATE ag.survey_response SET spanish = 'Swazilandia', french = 'Swaziland', chinese = '斯威士兰' WHERE american = 'Swaziland';
UPDATE ag.survey_response SET spanish = 'Suecia', french = 'Suède', chinese = '瑞典' WHERE american = 'Sweden';
UPDATE ag.survey_response SET spanish = 'Suiza', french = 'Suisse', chinese = '瑞士' WHERE american = 'Switzerland';
UPDATE ag.survey_response SET spanish = 'República Árabe Siria', french = 'République arabe syrienne', chinese = '阿拉伯叙利亚共和国' WHERE american = 'Syrian Arab Republic';
UPDATE ag.survey_response SET spanish = 'Taiwan, provincia de China', french = 'Taiwan, Province de Chine', chinese = '中国台湾省' WHERE american = 'Taiwan';
UPDATE ag.survey_response SET spanish = 'Tayikistán', french = 'Tadjikistan', chinese = '塔吉克斯坦' WHERE american = 'Tajikistan';
UPDATE ag.survey_response SET spanish = 'Tanzania, República Unida de', french = 'Tanzanie, République-Unie de', chinese = '坦桑尼亚联合共和国' WHERE american = 'Tanzania, United Republic of';
UPDATE ag.survey_response SET spanish = 'Tailandia', french = 'Thaïlande', chinese = '泰国' WHERE american = 'Thailand';
UPDATE ag.survey_response SET spanish = 'Timor-leste', french = 'Timor-leste', chinese = '东帝汶' WHERE american = 'Timor-leste';
UPDATE ag.survey_response SET spanish = 'Ir', french = 'Aller', chinese = '多哥' WHERE american = 'Togo';
UPDATE ag.survey_response SET spanish = 'Tokelau', french = 'Tokelau', chinese = '托克劳' WHERE american = 'Tokelau';
UPDATE ag.survey_response SET spanish = 'Tonga', french = 'Tonga', chinese = '汤加' WHERE american = 'Tonga';
UPDATE ag.survey_response SET spanish = 'Trinidad y Tobago', french = 'Trinité-et-Tobago', chinese = '特立尼达和多巴哥' WHERE american = 'Trinidad and Tobago';
UPDATE ag.survey_response SET spanish = 'Túnez', french = 'Tunisie', chinese = '突尼斯' WHERE american = 'Tunisia';
UPDATE ag.survey_response SET spanish = 'pavo', french = 'Turquie', chinese = '火鸡' WHERE american = 'Turkey';
UPDATE ag.survey_response SET spanish = 'Turkmenistán', french = 'Turkménistan', chinese = '土库曼斯坦' WHERE american = 'Turkmenistan';
UPDATE ag.survey_response SET spanish = 'Islas Turcas y Caicos', french = 'îles Turques-et-Caïques', chinese = '特克斯和凯科斯群岛' WHERE american = 'Turks and Caicos Islands';
UPDATE ag.survey_response SET spanish = 'Tuvalu', french = 'Tuvalu', chinese = '图瓦卢' WHERE american = 'Tuvalu';
UPDATE ag.survey_response SET spanish = 'Uganda', french = 'Ouganda', chinese = '乌干达' WHERE american = 'Uganda';
UPDATE ag.survey_response SET spanish = 'Ucrania', french = 'Ukraine', chinese = '乌克兰' WHERE american = 'Ukraine';
UPDATE ag.survey_response SET spanish = 'Emiratos Árabes Unidos', french = 'Emirats Arabes Unis', chinese = '阿拉伯联合酋长国' WHERE american = 'United Arab Emirates';
UPDATE ag.survey_response SET spanish = 'Reino Unido', french = 'Royaume-Uni', chinese = '英国' WHERE american = 'United Kingdom';
UPDATE ag.survey_response SET spanish = 'Estados Unidos', french = 'États Unis', chinese = '美国' WHERE american = 'United States';
UPDATE ag.survey_response SET spanish = 'Islas ultramarinas menores de Estados Unidos', french = 'Îles mineures éloignées des États-Unis', chinese = '美国本土外小岛屿' WHERE american = 'United States Minor Outlying Islands';
UPDATE ag.survey_response SET spanish = 'Uruguay', french = 'Uruguay', chinese = '乌拉圭' WHERE american = 'Uruguay';
UPDATE ag.survey_response SET spanish = 'Uzbekistán', french = 'Ouzbékistan', chinese = '乌兹别克斯坦' WHERE american = 'Uzbekistan';
UPDATE ag.survey_response SET spanish = 'Vanuatu', french = 'Vanuatu', chinese = '瓦努阿图' WHERE american = 'Vanuatu';
UPDATE ag.survey_response SET spanish = 'Venezuela', french = 'Venezuela', chinese = '委内瑞拉' WHERE american = 'Venezuela';
UPDATE ag.survey_response SET spanish = 'Vietnam', french = 'Viet Nam', chinese = '越南' WHERE american = 'Vietnam';
UPDATE ag.survey_response SET spanish = 'Islas Vírgenes Británicas', french = 'Îles Vierges britanniques', chinese = '英属维尔京群岛' WHERE american = 'Virgin Islands, British';
UPDATE ag.survey_response SET spanish = 'Islas Vírgenes, EE. UU.', french = 'Îles Vierges américaines', chinese = '美国维尔京群岛' WHERE american = 'Virgin Islands, U.S.';
UPDATE ag.survey_response SET spanish = 'Wallis y Futuna', french = 'Wallis et Futuna', chinese = '瓦利斯和富图纳群岛' WHERE american = 'Wallis and Futuna';
UPDATE ag.survey_response SET spanish = 'Sahara Occidental', french = 'Sahara occidental', chinese = '撒哈拉沙漠西部' WHERE american = 'Western Sahara';
UPDATE ag.survey_response SET spanish = 'Yemen', french = 'Yémen', chinese = '也门' WHERE american = 'Yemen';
UPDATE ag.survey_response SET spanish = 'Zambia', french = 'Zambie', chinese = '赞比亚' WHERE american = 'Zambia';
UPDATE ag.survey_response SET spanish = 'Zimbabue', french = 'Zimbabwe', chinese = '津巴布韦' WHERE american = 'Zimbabwe';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'En el último mes', french = 'Au cours du mois dernier', chinese = '在过去的一个月内' WHERE american = 'Within the past month';
UPDATE ag.survey_response SET spanish = 'En los últimos 3 meses', french = 'Au cours des 3 derniers mois', chinese = '在过去的 3 个月内' WHERE american = 'Within the past 3 months';
UPDATE ag.survey_response SET spanish = 'En los últimos 6 meses', french = 'Au cours des 6 derniers mois', chinese = '在过去的 6 个月内' WHERE american = 'Within the past 6 months';
UPDATE ag.survey_response SET spanish = 'En el último año', french = 'Au cours de l’année dernière', chinese = '在过去的一年内' WHERE american = 'Within the past year';
UPDATE ag.survey_response SET spanish = 'Llevo más de un año viviendo en el estado en el que resido actualmente.', french = 'Je vis dans mon lieu de résidence actuel depuis plus d’un an.', chinese = '我居住在目前的居住地超过一年。' WHERE american = 'I have lived in my current state of residence for more than a year.';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Depresión', french = 'Dépression', chinese = '抑郁症' WHERE american = 'Depression';
UPDATE ag.survey_response SET spanish = 'Trastorno bipolar', french = 'Trouble bipolaire', chinese = '双相情感障碍' WHERE american = 'Bipolar disorder';
UPDATE ag.survey_response SET spanish = 'Trastorno por estrés postraumático', french = 'ESPT (état de stress post-traumatique)', chinese = 'PTSD(创伤后应激障碍)' WHERE american = 'PTSD (post-traumatic stress disorder)';
UPDATE ag.survey_response SET spanish = 'Esquizofrenia', french = 'Schizophrénie', chinese = '精神分裂症' WHERE american = 'Schizophrenia';
UPDATE ag.survey_response SET spanish = 'Anorexia nerviosa', french = 'Anorexie mentale', chinese = '神经性厌食症' WHERE american = 'Anorexia nervosa';
UPDATE ag.survey_response SET spanish = 'Bulimia nerviosa', french = 'Boulimie', chinese = '神经性贪食症' WHERE american = 'Bulimia nervosa';
UPDATE ag.survey_response SET spanish = 'Drogadicción', french = 'Toxicomanie', chinese = '药物滥用' WHERE american = 'Substance abuse';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Diabetes de tipo 1', french = 'Diabète de type I', chinese = 'I 型糖尿病' WHERE american = 'Type I diabetes';
UPDATE ag.survey_response SET spanish = 'Diabetes de tipo 2', french = 'Diabète de type II', chinese = 'II 型糖尿病' WHERE american = 'Type II diabetes';
UPDATE ag.survey_response SET spanish = 'Diabetes gestacional', french = 'Diabète gestationnel', chinese = '妊娠期糖尿病' WHERE american = 'Gestational diabetes';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (unas cuantas veces al mes)', french = 'Rarement (quelques fois/mois)', chinese = '很少(几次/月)' WHERE american = 'Rarely (a few times/month)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (alguna vez al mes)', french = 'Rarement (quelques fois/mois)', chinese = '很少(几次/月)' WHERE american = 'Rarely (a few times/month)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'No tengo esa afección', french = 'Je n’ai pas cette maladie', chinese = '我没有患过该病症' WHERE american = 'I do not have this condition';
UPDATE ag.survey_response SET spanish = 'La diagnosticó un profesional médico (médico o auxiliar médico)', french = 'Diagnostiqué par un professionnel de santé (médecin, médecin assistant)', chinese = '由医疗专业人员(医生、医师助理)做出诊断' WHERE american = 'Diagnosed by a medical professional (doctor, physician assistant)';
UPDATE ag.survey_response SET spanish = 'La diagnosticó un profesional de medicina alternativa', french = 'Diagnostiqué par un thérapeute de médecine alternative', chinese = '由另类医学从业者诊断' WHERE american = 'Diagnosed by an alternative medicine practitioner';
UPDATE ag.survey_response SET spanish = 'Yo mismo me diagnostiqué', french = 'Auto-diagnostiqué', chinese = '自我诊断' WHERE american = 'Self-diagnosed';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sin tratamiento', french = 'Aucun traitement', chinese = '没有治疗' WHERE american = 'No treatment';
UPDATE ag.survey_response SET spanish = 'Solo cirugía', french = 'Par chirurgie uniquement', chinese = '仅应用手术治疗' WHERE american = 'Surgery only';
UPDATE ag.survey_response SET spanish = 'Quimioterapia', french = 'Par chimiothérapie', chinese = '化疗' WHERE american = 'Chemotherapy';
UPDATE ag.survey_response SET spanish = 'Radioterapia', french = 'Par radiothérapie', chinese = '放疗' WHERE american = 'Radiation therapy';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'mes', french = 'Du mois dernier', chinese = '1 个月' WHERE american = 'Month';
UPDATE ag.survey_response SET spanish = '3 meses', french = 'Des 3 derniers mois', chinese = '3 个月' WHERE american = '3 months';
UPDATE ag.survey_response SET spanish = '6 meses', french = 'Des 6 derniers mois', chinese = '6 个月' WHERE american = '6 months';
UPDATE ag.survey_response SET spanish = 'año', french = 'De l’année dernière', chinese = '1 年' WHERE american = '1 year';
UPDATE ag.survey_response SET spanish = 'No he salido del país en el que resido en el último año.', french = 'Je n’ai pas voyagé hors de mon pays de résidence au cours de l’année dernière.', chinese = '我在过去的一年内未曾到我居住国家之外的地区旅行。' WHERE american = 'I have not been outside of my country of residence in the past year.';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'No tengo esa afección', french = 'Je n’ai pas cette maladie', chinese = '我没有患过该病症' WHERE american = 'I do not have this condition';
UPDATE ag.survey_response SET spanish = 'La diagnosticó un profesional médico (médico o auxiliar médico)', french = 'Diagnostiqué par un professionnel de santé (médecin, médecin assistant)', chinese = '由医疗专业人员(医生、医师助理)做出诊断' WHERE american = 'Diagnosed by a medical professional (doctor, physician assistant)';
UPDATE ag.survey_response SET spanish = 'La diagnosticó un profesional de medicina alternativa', french = 'Diagnostiqué par un thérapeute de médecine alternative', chinese = '由另类医学从业者诊断' WHERE american = 'Diagnosed by an alternative medicine practitioner';
UPDATE ag.survey_response SET spanish = 'Yo mismo me diagnostiqué', french = 'Auto-diagnostiqué', chinese = '自我诊断' WHERE american = 'Self-diagnosed';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Colitis ulcerosa', french = 'Rectocolite hémorragique', chinese = '溃疡性结肠炎' WHERE american = 'Ulcerative colitis';
UPDATE ag.survey_response SET spanish = 'Enfermedad de Crohn', french = 'Maladie de Crohn', chinese = '克罗恩病' WHERE american = 'Crohn''s disease';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Dieta paleolítica o primitiva', french = 'Régime paléolithique ou primitif', chinese = '旧石器时代饮食或远古饮食' WHERE american = 'paleo-diet or primal diet';
UPDATE ag.survey_response SET spanish = 'Dieta paleolítica modificada', french = 'Régime paléolithique modifié', chinese = '改良的旧石器时代饮食' WHERE american = 'modified paleo diet';
UPDATE ag.survey_response SET spanish = 'Dieta de alimentos crudos', french = 'Crudivore', chinese = '生食饮食' WHERE american = 'raw food diet';
UPDATE ag.survey_response SET spanish = 'FODMAP', french = 'FODMAP', chinese = 'FODMAP' WHERE american = 'FODMAP';
UPDATE ag.survey_response SET spanish = 'Kosher', french = 'Casher', chinese = '犹太食物' WHERE american = 'Kosher';
UPDATE ag.survey_response SET spanish = 'Halal', french = 'Halal', chinese = '清真食物' WHERE american = 'Halaal';
UPDATE ag.survey_response SET spanish = 'No consumo verduras solanáceas', french = 'Pas de solanacées', chinese = '排除茄属植物' WHERE american = 'Exclude nightshades';
UPDATE ag.survey_response SET spanish = 'No consumo productos lácteos', french = 'Pas de produits laitiers', chinese = '排除乳制品' WHERE american = 'Exclude dairy';
UPDATE ag.survey_response SET spanish = 'No consumo azúcares refinados', french = 'Pas de sucres raffinés', chinese = '排除精制糖' WHERE american = 'Exclude refined sugars';
UPDATE ag.survey_response SET spanish = 'Otras restricciones no indicadas aquí', french = 'Autres restrictions non décrites ici', chinese = '此处未描述的其他限制' WHERE american = 'Other restrictions not described here';
UPDATE ag.survey_response SET spanish = 'No llevo una dieta especial', french = 'Mon régime alimentaire n’est pas spécialisé', chinese = '我不吃特定的饮食' WHERE american = 'I do not eat a specialized diet';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = '1', french = '1', chinese = '1' WHERE american = '1';
UPDATE ag.survey_response SET spanish = '1-2', french = '1 à 2', chinese = '1-2' WHERE american = '1-2';
UPDATE ag.survey_response SET spanish = '2-3', french = '2 à 3', chinese = '2-3' WHERE american = '2-3';
UPDATE ag.survey_response SET spanish = '3-4', french = '3 à 4', chinese = '3-4' WHERE american = '3-4';
UPDATE ag.survey_response SET spanish = 'Más de 4', french = 'Plus de 4', chinese = '4+' WHERE american = '4+';
UPDATE ag.survey_response SET spanish = 'No bebo', french = 'Je ne bois pas', chinese = '我不喝酒' WHERE american = 'I don''t drink';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Enfermedad de Crohn, localización ileal', french = 'Maladie de Crohn iléale', chinese = '回肠克罗恩病' WHERE american = 'Ileal Crohn''s Disease';
UPDATE ag.survey_response SET spanish = 'Enfermedad de Crohn, localización colónica', french = 'Maladie de Crohn colique', chinese = '结肠克罗恩病' WHERE american = 'Colonic Crohn''s Disease';
UPDATE ag.survey_response SET spanish = 'Enfermedad de Crohn, localización ilecolónica', french = 'Maladie de Crohn iléale et colique', chinese = '回肠和结肠克罗恩病' WHERE american = 'Ileal and Colonic Crohn''s Disease';
UPDATE ag.survey_response SET spanish = 'Colitis ulcerosa', french = 'Rectocolite hémorragique', chinese = '溃疡性结肠炎' WHERE american = 'Ulcerative colitis';
UPDATE ag.survey_response SET spanish = 'Colitis microscópica', french = 'Colite microscopique', chinese = '显微镜结肠炎' WHERE american = 'Microcolitis';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Ninguna', french = 'Aucune', chinese = '无' WHERE american = 'None';
UPDATE ag.survey_response SET spanish = 'Una', french = 'Une', chinese = '一个' WHERE american = 'One';
UPDATE ag.survey_response SET spanish = 'Dos', french = 'Deux', chinese = '两个' WHERE american = 'Two';
UPDATE ag.survey_response SET spanish = 'Tres', french = 'Trois', chinese = '三个' WHERE american = 'Three';
UPDATE ag.survey_response SET spanish = 'Más de tres', french = 'Plus de trois', chinese = '多于三个' WHERE american = 'More than three';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'No estoy seguro', french = 'Je ne sais pas', chinese = '不确定' WHERE american = 'Not sure';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'No estoy seguro', french = 'Je ne sais pas', chinese = '不确定' WHERE american = 'Not sure';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Soy diestro', french = 'Je suis droitier/droitière', chinese = '我的右手是优势手' WHERE american = 'I am right handed';
UPDATE ag.survey_response SET spanish = 'Soy zurdo', french = 'Je suis gaucher/gauchère', chinese = '我的左手是优势手' WHERE american = 'I am left handed';
UPDATE ag.survey_response SET spanish = 'Soy ambidiestro', french = 'Je suis ambidextre', chinese = '我的两只手都是优势手' WHERE american = 'I am ambidextrous';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'No terminé la escuela secundaria', french = 'Je n’ai pas terminé le lycée', chinese = '没上完高中' WHERE american = 'Did not complete high school';
UPDATE ag.survey_response SET spanish = 'Título de estudios secundarios o equivalente al GED', french = 'Lycée ou équivalent du baccalauréat', chinese = '高中或高中同等学历(GED)' WHERE american = 'High School or GED equilivant';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Estudios universitarios o técnicos incompletos', french = 'Une partie d’un cursus universitaire ou technique post-bac', chinese = '大学或技术学校' WHERE american = 'Some college or technical school';
UPDATE ag.survey_response SET spanish = 'Título de pregrado (grado tras 2 años de universidad)', french = 'DEUG/BTS/DUT', chinese = '副学士学位' WHERE american = 'Associate''s degree';
UPDATE ag.survey_response SET spanish = 'Licenciatura (grado tras 4 o más años de universidad)', french = 'Licence ou équivalent', chinese = '学士学位' WHERE american = 'Bachelor''s degree';
UPDATE ag.survey_response SET spanish = 'Estudios de posgrado o profesionales incompletos', french = 'Une partie d’un cursus de l’enseignement supérieur ou professionnel', chinese = '研究生院或专业教育' WHERE american = 'Some graduate school or professional';
UPDATE ag.survey_response SET spanish = 'Título de estudios de posgrado o profesionales', french = 'Diplôme de l’enseignement supérieur ou professionnel', chinese = '研究生或专业学位' WHERE american = 'Graduate or Professional degree';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (unas cuantas veces al mes)', french = 'Rarement (quelques fois/mois)', chinese = '很少(几次/月)' WHERE american = 'Rarely (a few times/month)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'En interiores', french = 'À l’intérieur', chinese = '室内' WHERE american = 'Indoors';
UPDATE ag.survey_response SET spanish = 'Al aire libre', french = 'À l’extérieur', chinese = '室外' WHERE american = 'Outdoors';
UPDATE ag.survey_response SET spanish = 'Ambos', french = 'Les deux', chinese = '两者都有' WHERE american = 'Both';
UPDATE ag.survey_response SET spanish = 'Depende de la estación', french = 'Cela dépend de la saison', chinese = '取决于季节' WHERE american = 'Depends on the season';
UPDATE ag.survey_response SET spanish = 'Ninguna de las opciones anteriores', french = 'Aucune des réponses ci-dessus', chinese = '以上都不是' WHERE american = 'None of the above';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (unas cuantas veces al mes)', french = 'Rarement (quelques fois/mois)', chinese = '很少(几次/月)' WHERE american = 'Rarely (a few times/month)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (unas cuantas veces al mes)', french = 'Rarement (quelques fois/mois)', chinese = '很少(几次/月)' WHERE american = 'Rarely (a few times/month)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (unas cuantas veces al mes)', french = 'Rarement (quelques fois/mois)', chinese = '很少(几次/月)' WHERE american = 'Rarely (a few times/month)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (unas cuantas veces al mes)', french = 'Rarement (quelques fois/mois)', chinese = '很少(几次/月)' WHERE american = 'Rarely (a few times/month)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次 /周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Cerveza/sidra', french = 'Bière/cidre', chinese = '啤酒/苹果酒' WHERE american = 'Beer/Cider';
UPDATE ag.survey_response SET spanish = 'Cervezas ácidas', french = 'Bières amères', chinese = '酸啤酒' WHERE american = 'Sour beers';
UPDATE ag.survey_response SET spanish = 'Vino blanco', french = 'Vin blanc', chinese = '白酒' WHERE american = 'White wine';
UPDATE ag.survey_response SET spanish = 'Vino tinto', french = 'Vin rouge', chinese = '红酒' WHERE american = 'Red wine';
UPDATE ag.survey_response SET spanish = 'Bebidas destiladas/con alto grado alcohólico', french = 'Spiritueux/alcool fort', chinese = '烈酒饮料/烈酒' WHERE american = 'Spirits/hard alcohol';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (menos de una vez al día)', french = 'Occasionnellement (moins d’une fois par jour)', chinese = '偶尔(每天不到一次)' WHERE american = 'Rarely (a few times/month)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (1-2 veces al día)', french = 'Régulièrement (1 à 2 fois par jour)', chinese = '经常(每天 1-2 次)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Frecuentemente (más de 2 veces al día)', french = 'Fréquemment (plus de 2 fois par jour)', chinese = '频繁(每天 2 次以上)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (una cuantas veces al mes)', french = 'Rarement (quelques fois/mois)', chinese = '很少(几次/月)' WHERE american = 'Rarely (a few times/month)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (unas cuantas veces al mes)', french = 'Rarement (quelques fois/mois)', chinese = '很少(几次/月)' WHERE american = 'Rarely (a few times/month)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Uso desodorante', french = 'J’utilise un déodorant', chinese = '我用除臭剂' WHERE american = 'I use deodorant';
UPDATE ag.survey_response SET spanish = 'Uso antisudorífico', french = 'J’utilise un antitranspirant', chinese = '我用止汗剂' WHERE american = 'I use an antiperspirant';
UPDATE ag.survey_response SET spanish = 'No estoy seguro, pero uso algún tipo de desodorante/antisudorífico', french = 'Je ne sais pas, mais j’utilise une forme de déodorant/antitranspirant', chinese = '不确定,但我使用某种类型的除臭剂/止汗剂' WHERE american = 'Not sure, but I use some form of deodorant/antiperspirant';
UPDATE ag.survey_response SET spanish = 'No uso desodorante ni antisudorífico', french = 'Je n’utilise pas de déodorant ou d’antitranspirant', chinese = '我不使用除臭剂或止汗剂' WHERE american = 'I do not use deodorant or an antiperspirant';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Menos de 5 horas', french = 'Moins de 5 heures', chinese = '少于 5 个小时' WHERE american = 'Less than 5 hours';
UPDATE ag.survey_response SET spanish = '5-6 horas', french = '5 à 6 heures', chinese = '5-6 个小时' WHERE american = '5-6 hours';
UPDATE ag.survey_response SET spanish = '6-7 horas', french = '6 à 7 heures', chinese = '6-7 个小时' WHERE american = '6-7 hours';
UPDATE ag.survey_response SET spanish = '7-8 horas', french = '7 à 8 heures', chinese = '7-8 个小时' WHERE american = '7-8 hours';
UPDATE ag.survey_response SET spanish = '8 horas o más', french = '8 heures ou plus', chinese = '8 个小时或以上' WHERE american = '8 or more hours';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Menos de una', french = 'Mois d’une fois', chinese = '少于一次' WHERE american = 'Less than one';
UPDATE ag.survey_response SET spanish = 'Una', french = 'Une fois', chinese = '一次' WHERE american = 'One';
UPDATE ag.survey_response SET spanish = 'Dos', french = 'Deux fois', chinese = '两次' WHERE american = 'Two';
UPDATE ag.survey_response SET spanish = 'Tres', french = 'Trois fois', chinese = '三次' WHERE american = 'Three';
UPDATE ag.survey_response SET spanish = 'Cuatro', french = 'Quatre fois', chinese = '四次' WHERE american = 'Four';
UPDATE ag.survey_response SET spanish = 'Cinco o más', french = 'Cinq fois ou plus', chinese = '五次或更多' WHERE american = 'Five or more';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Suelo estreñirme (dificultad para evacuar): tipos 1 y 2', french = 'J’ai tendance à être constipé(e) (j’ai du mal à aller à la selle) - Type 1 et 2', chinese = '我容易发生便秘(粪便难以排出) - 1 型和 2 型' WHERE american = 'I tend to be constipated (have difficulty passing stool) - Type 1 and 2';
UPDATE ag.survey_response SET spanish = 'Suelo tener diarrea (heces líquidas): tipos 5, 6 y 7', french = 'J’ai tendance à avoir la diarrhée (selles liquides) - Type 5, 6 et 7', chinese = '我容易发生腹泻(水样便) - 5 型、6 型和 7 型' WHERE american = 'I tend to have diarrhea (watery stool) - Type 5, 6 and 7';
UPDATE ag.survey_response SET spanish = 'Suelo evacuar heces normales: tipos 3 y 4', french = 'J’ai tendance à avoir des selles de forme normale - Type 3 et 4', chinese = '我的大便形态通常为正常 - 3 型和 4 型' WHERE american = 'I tend to have normal formed stool - Type 3 and 4';
UPDATE ag.survey_response SET spanish = 'No estoy seguro, no tengo ningún punto de referencia', french = 'Je ne sais pas, je n’ai pas de point de référence.', chinese = '我不知道,我没有参照物' WHERE american = 'I don''t know, I do not have a point of reference';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Semana', french = 'De la semaine dernière', chinese = '1 周' WHERE american = 'Week';
UPDATE ag.survey_response SET spanish = 'Mes', french = 'Du mois dernier', chinese = '1 个月' WHERE american = 'Month';
UPDATE ag.survey_response SET spanish = '6 meses', french = 'Des 6 derniers mois', chinese = '6 个月' WHERE american = '6 months';
UPDATE ag.survey_response SET spanish = 'Año', french = 'De l’année dernière', chinese = '1 年' WHERE american = 'Year';
UPDATE ag.survey_response SET spanish = 'No he tomado antibióticos a lo largo del último año.', french = 'Je n’ai pas pris d’antibiotiques au cours de l’année dernière.', chinese = '我在过去的一年里没有服用过抗生素。' WHERE american = 'I have not taken antibiotics in the past year.';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (unas cuantas veces al mes)', french = 'Rarement (quelques fois/mois)', chinese = '很少(几次/月)' WHERE american = 'Rarely (a few times/month)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次 /周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Semana', french = 'De la semaine dernière', chinese = '1 周' WHERE american = 'Week';
UPDATE ag.survey_response SET spanish = 'Mes', french = 'Du mois dernier', chinese = '1 个月' WHERE american = 'Month';
UPDATE ag.survey_response SET spanish = '6 meses', french = 'Des 6 derniers mois', chinese = '6 个月' WHERE american = '6 months';
UPDATE ag.survey_response SET spanish = 'Año', french = 'De l’année dernière', chinese = '1 年' WHERE american = 'Year';
UPDATE ag.survey_response SET spanish = 'No me han puesto la vacuna antigripal a lo largo del último año.', french = 'Je n’ai pas reçu de vaccin contre la grippe au cours de l’année dernière.', chinese = '我在过去的一年内没有接种流感疫苗。' WHERE american = 'I have not gotten the flu vaccine in the past year.';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí, tomo la píldora', french = 'Oui, je prends la pilule', chinese = '是的,我正在服用“避孕药”' WHERE american = 'Yes, I am taking the "pill"';
UPDATE ag.survey_response SET spanish = 'Sí, uso un anticonceptivo inyectable (DMPA)', french = 'Oui, j’utilise un contraceptif injectable (acétate de médroxyprogestérone)', chinese = '是的,我使用注射避孕药(DMPA)' WHERE american = 'Yes, I use an injected contraceptive (DMPA)';
UPDATE ag.survey_response SET spanish = 'Sí, uso un parche anticonceptivo (Ortho-Evra)', french = 'Oui, j’utilise un patch contraceptif (Evra)', chinese = '是的,我使用避孕贴片(Ortho-Evra)' WHERE american = 'Yes, I use a contraceptive patch (Ortho-Evra)';
UPDATE ag.survey_response SET spanish = 'Sí, uso NuvaRing', french = 'Oui, j’utilise NuvaRing', chinese = '是的,我使用阴道环(NuvaRing)' WHERE american = 'Yes, I use the NuvaRing';
UPDATE ag.survey_response SET spanish = 'Sí, uso un DIU hormonal (Mirena)', french = 'Oui, j’utilise un dispositif intra-utérin (DIU) hormonal (Mirena)', chinese = '是的,我使用荷尔蒙宫内节育器(Mirena)' WHERE american = 'Yes, I use a hormonal IUD (Mirena)';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'No estoy segura', french = 'Je ne sais pas', chinese = '不确定' WHERE american = 'Not sure';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'aumentó más de 10 libras', french = 'A augmenté de plus de 10 livres (5 kg)', chinese = '增加超过 10 磅' WHERE american = 'Increased more than 10 pounds';
UPDATE ag.survey_response SET spanish = 'se redujo más de 10 libras', french = 'A diminué de plus de 10 livres (5 kg)', chinese = '降低超过 10 磅' WHERE american = 'Decreased more than 10 pounds';
UPDATE ag.survey_response SET spanish = 'se mantuvo estable', french = 'Est resté stable', chinese = '保持稳定' WHERE american = 'Remained stable';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'No estoy seguro', french = 'Je ne sais pas', chinese = '不确定' WHERE american = 'Not sure';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'No estoy seguro', french = 'Je ne sais pas', chinese = '不确定' WHERE american = 'Not sure';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'No estoy seguro', french = 'Je ne sais pas', chinese = '不确定' WHERE american = 'Not sure';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (unas cuantas veces al mes)', french = 'Rarement (quelques fois/mois)', chinese = '很少(几次/月)' WHERE american = 'Rarely (a few times/month)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次 /周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'No estoy seguro', french = 'Je ne sais pas', chinese = '不确定' WHERE american = 'Not sure';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Principalmente con leche materna', french = 'Principalement du lait maternel', chinese = '主要是母乳' WHERE american = 'Primarily breast milk';
UPDATE ag.survey_response SET spanish = 'Principalmente con fórmula para recién nacidos', french = 'Principalement des préparations pour nourrissons', chinese = '主要是婴儿配方奶粉' WHERE american = 'Primarily infant formula';
UPDATE ag.survey_response SET spanish = 'Con una mezcla de leche materna y fórmula para recién nacidos', french = 'Un mélange de lait maternel et de préparations pour nourrissons', chinese = '母乳和配方奶粉的混合' WHERE american = 'A mixture of breast milk and formula';
UPDATE ag.survey_response SET spanish = 'No estoy seguro', french = 'Je ne sais pas', chinese = '不确定' WHERE american = 'Not sure';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Fármacos (p. ej., penicilina)', french = 'Médicament (par exemple, pénicilline)', chinese = '药物(如青霉素)' WHERE american = 'Drug (e.g. Penicillin)';
UPDATE ag.survey_response SET spanish = 'Caspa de los animales', french = 'Phanères animaux', chinese = '宠物皮屑' WHERE american = 'Pet dander';
UPDATE ag.survey_response SET spanish = 'Picadura de las abejas', french = 'Piqûres d’abeilles', chinese = '蜂蜇' WHERE american = 'Beestings';
UPDATE ag.survey_response SET spanish = 'Roble/hiedra venenoso', french = 'Sumac vénéneux / sumac occidental', chinese = '毒藤/橡树' WHERE american = 'Poison ivy/oak';
UPDATE ag.survey_response SET spanish = 'Sol', french = 'Soleil', chinese = '日光' WHERE american = 'Sun';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Consumo alimentos sólidos y leche materna/fórmula', french = 'Je mange à la fois de la nourriture solide et du lait maternel / des préparations pour nourrissons', chinese = '我同时吃固体食物和配方奶粉/母乳' WHERE american = 'I eat both solid food and formula/breast milk';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 次/周)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 次/周)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 次/周)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 次/周)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'No tengo esa afección', french = 'Je n’ai pas cette maladie', chinese = '我没有患过该病症' WHERE american = 'I do not have this condition';
UPDATE ag.survey_response SET spanish = 'La diagnosticó un profesional médico (médico o auxiliar médico)', french = 'Diagnostiquée par un professionnel de santé (médecin, médecin assistant)', chinese = '由医疗专业人员(医生、医师助理)诊断' WHERE american = 'Diagnosed by a medical professional (doctor, physician assistant)';
UPDATE ag.survey_response SET spanish = 'La diagnosticó un profesional de medicina alternativa', french = 'Diagnostiquée par un thérapeute de médecine alternative', chinese = '由另类医学从业者诊断' WHERE american = 'Diagnosed by an alternative medicine practitioner';
UPDATE ag.survey_response SET spanish = 'Yo mismo me diagnostiqué', french = 'Auto-diagnostiquée', chinese = '自我诊断' WHERE american = 'Self-diagnosed';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 次/周)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 次/周)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 次/周)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 次/周)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 次/周)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 次/周)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 次/周)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 次/周)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 次/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 次/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 天/周)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 天/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 天/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Sí', french = 'Oui', chinese = '是' WHERE american = 'Yes';
UPDATE ag.survey_response SET spanish = 'No', french = 'Non', chinese = '否' WHERE american = 'No';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 天/周)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 天/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 天/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 天/周)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 天/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 天/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 天/周)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET spanish = 'Ocasionalmente (1-2 veces a la semana)', french = 'Occasionnellement (1 à 2 fois/semaine)', chinese = '偶尔(1-2 天/周)' WHERE american = 'Occasionally (1-2 times/week)';
UPDATE ag.survey_response SET spanish = 'Periódicamente (3-5 veces a la semana)', french = 'Régulièrement (3 à 5 fois/semaine)', chinese = '经常(3-5 天/周)' WHERE american = 'Regularly (3-5 times/week)';
UPDATE ag.survey_response SET spanish = 'A diario', french = 'Tous les jours', chinese = '每天' WHERE american = 'Daily';
UPDATE ag.survey_response SET spanish = 'Sin determinar', french = 'Non précisé', chinese = '未指明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET spanish = 'Nunca', french = 'Jamais', chinese = '从来没有' WHERE american = 'Never';
UPDATE ag.survey_response SET spanish = 'Casi nunca (menos de 1 vez a la semana)', french = 'Rarement (moins d’une fois/semaine)', chinese = '很少(小于 1 天/周)' WHERE american = 'Rarely (less than once/week)';