-
Notifications
You must be signed in to change notification settings - Fork 19
/
0125.sql
2691 lines (2682 loc) · 292 KB
/
0125.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
-- Standardize the frequency-oriented questions to the legacy responses. The new, shorter responses have not actually been used so it's safe to change them.
-- However, we need to temporarily drop the constraint on ag.survey_question_triggers.
ALTER TABLE ag.survey_question_triggers DROP CONSTRAINT fk_survey_question_triggers0;
-- Update the triggers table
UPDATE ag.survey_question_triggers SET triggering_response = 'Rarely (a few times/month)' WHERE triggering_response = 'Few times/month';
UPDATE ag.survey_question_triggers SET triggering_response = 'Occasionally (1-2 times/week)' WHERE triggering_response = '1-2 times/week';
UPDATE ag.survey_question_triggers SET triggering_response = 'Regularly (3-5 times/week)' WHERE triggering_response = '3-5 times/week';
-- Update the association between questions and valid responses
UPDATE ag.survey_question_response SET response = 'Rarely (a few times/month)' WHERE response = 'Few times/month';
UPDATE ag.survey_question_response SET response = 'Occasionally (1-2 times/week)' WHERE response = '1-2 times/week';
UPDATE ag.survey_question_response SET response = 'Regularly (3-5 times/week)' WHERE response = '3-5 times/week';
-- Now we'll recreate the constraint
ALTER TABLE ag.survey_question_triggers ADD CONSTRAINT fk_survey_question_triggers0 FOREIGN KEY (survey_question_id, triggering_response)
REFERENCES ag.survey_question_response(survey_question_id, response);
-- Adjust some questions/responses
UPDATE ag.survey_question SET american = 'Have you ever been diagnosed with irritable bowel syndrome (IBS)? Note: IBS should not be confused with IBD. IBS is defined by symptoms, usually recurrent abdominal pain and changes in bowel movements. IBD is marked by inflammation or damage to the lining of the gastrointestinal tract.' WHERE survey_question_id = 79;
UPDATE ag.survey_question SET american = 'Please rate the current (i.e. last 2 weeks) severity of any difficulty falling asleep.' WHERE survey_question_id = 229;
UPDATE ag.survey_question SET american = 'Please rate the current (i.e. last 2 weeks) severity of any difficulty staying asleep.' WHERE survey_question_id = 230;
UPDATE ag.survey_question SET american = 'Please rate the current (i.e. last 2 weeks) severity of any problems waking up too early.' WHERE survey_question_id = 231;
UPDATE ag.survey_question SET american = 'How satisfied/dissatisfied are you with your current sleep pattern?' WHERE survey_question_id = 232;
UPDATE ag.survey_question SET american = 'How noticeable to others do you think your sleep problem is in terms of impairing the quality of your life?' WHERE survey_question_id = 233;
UPDATE ag.survey_question SET american = 'How worried/distressed are you about your current sleep problem?' WHERE survey_question_id = 234;
UPDATE ag.survey_question SET american = 'To what extent do you consider your sleep problem to interfere with your daily functioning (e.g. daytime fatigue, mood, ability to function at work/daily chores, concentration, memory, mood, etc.) currently?' WHERE survey_question_id = 235;
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES
(428, '12:00AM', 25),
(428, '12:30AM', 26),
(428, '1:00AM', 27),
(428, '1:30AM', 28),
(428, '2:00AM', 29),
(428, '2:30AM', 30),
(428, '3:00AM', 31),
(428, '3:30AM', 32),
(428, '4:00AM', 33),
(428, '4:30AM', 34),
(428, '5:00AM', 35),
(428, '5:30AM', 36),
(428, '6:00AM', 37),
(428, '6:30AM', 38),
(428, '7:00AM', 39),
(428, '7:30AM', 40),
(428, '8:00AM', 41),
(428, '8:30AM', 42),
(428, '9:00AM', 43),
(428, '9:30AM', 44),
(428, '10:00AM', 45),
(428, '10:30AM', 46),
(428, '11:00AM', 47),
(428, '11:30AM', 48);
-- All of the queries need to update two locales, for which we've determined there aren't any relevant differences
-- 1) Mexican Spanish (es_mx) - column suffix is _spanish
-- 2) Spanish Spanish (es_es) - column suffix is _spain_spanish
-- Update survey_group names
UPDATE ag.survey_group SET spanish = 'Información básica', spain_spanish = 'Información básica' WHERE group_order = -10; -- Basic Information
UPDATE ag.survey_group SET spanish = 'En casa', spain_spanish = 'En casa' WHERE group_order = -11; -- At Home
UPDATE ag.survey_group SET spanish = 'Estilo de vida', spain_spanish = 'Estilo de vida' WHERE group_order = -12; -- Lifestyle
UPDATE ag.survey_group SET spanish = 'Intestino', spain_spanish = 'Intestino' WHERE group_order = -13; -- Gut
UPDATE ag.survey_group SET spanish = 'Salud general', spain_spanish = 'Salud general' WHERE group_order = -14; -- General Health
UPDATE ag.survey_group SET spanish = 'Diagnóstico de Salud', spain_spanish = 'Diagnóstico de Salud' WHERE group_order = -15; -- Health Diagnosis
UPDATE ag.survey_group SET spanish = 'Alergias', spain_spanish = 'Alergias' WHERE group_order = -16; -- Allergies
UPDATE ag.survey_group SET spanish = 'Dieta', spain_spanish = 'Dieta' WHERE group_order = -17; -- Diet
UPDATE ag.survey_group SET spanish = 'Dieta detallada', spain_spanish = 'Dieta detallada' WHERE group_order = -18; -- Detailed Diet
UPDATE ag.survey_group SET spanish = 'Otro', spain_spanish = 'Otro' WHERE group_order = -22; -- Other
-- Update survey_question entries
UPDATE ag.survey_question SET spanish = 'Sexo biológico asignado al nacer', spain_spanish = 'Sexo biológico asignado al nacer' WHERE survey_question_id = 502;
UPDATE ag.survey_question SET spanish = '¿Cuál de las siguientes le describe mejor?', spain_spanish = '¿Cuál de las siguientes le describe mejor?' WHERE survey_question_id = 492;
UPDATE ag.survey_question SET spanish = '¿Cuál es su nivel de educación más alto?', spain_spanish = '¿Cuál es su nivel de educación más alto?' WHERE survey_question_id = 493;
UPDATE ag.survey_question SET spanish = '¿Cuál de las siguientes opciones describe mejor el área en la que vive?', spain_spanish = '¿Cuál de las siguientes opciones describe mejor el área en la que vive?' WHERE survey_question_id = 313;
UPDATE ag.survey_question SET spanish = '¿Tiene contacto frecuente y regular con animales de granja?', spain_spanish = '¿Tiene contacto frecuente y regular con animales de granja?' WHERE survey_question_id = 326;
UPDATE ag.survey_question SET spanish = '¿Cuál es su relación con las personas de este estudio que voluntariamente le informaron de su participación (por ejemplo, pareja, hijos)? Tenga en cuenta que solo utilizaremos la información que ambas partes proporcionen. Esta información es útil porque los estudios han demostrado que nuestros genes afectan nuestro microbioma.', spain_spanish = '¿Cuál es su relación con las personas de este estudio que voluntariamente le informaron de su participación (por ejemplo, pareja, hijos)? Tenga en cuenta que solo utilizaremos la información que ambas partes proporcionen. Esta información es útil porque los estudios han demostrado que nuestros genes afectan nuestro microbioma.' WHERE survey_question_id = 316;
UPDATE ag.survey_question SET spanish = 'En las noches antes de ir a la escuela o al trabajo, ¿a qué hora se acuesta?', spain_spanish = 'En las noches antes de ir a la escuela o al trabajo, ¿a qué hora se acuesta?' WHERE survey_question_id = 345;
UPDATE ag.survey_question SET spanish = 'Tipo/marca', spain_spanish = 'Tipo/marca' WHERE survey_question_id = 490;
UPDATE ag.survey_question SET spanish = '¿Quiénes son sus compañeros de cuarto que voluntariamente le han informado de su participación en este estudio? Tenga en cuenta que solo utilizaremos la información que ambas partes proporcionen. Esta información es útil porque los estudios han demostrado que las personas con las que vivimos afectan nuestro microbioma.', spain_spanish = '¿Quiénes son sus compañeros de cuarto que voluntariamente le han informado de su participación en este estudio? Tenga en cuenta que solo utilizaremos la información que ambas partes proporcionen. Esta información es útil porque los estudios han demostrado que las personas con las que vivimos afectan nuestro microbioma.' WHERE survey_question_id = 319;
UPDATE ag.survey_question SET spanish = 'Nombre del participante', spain_spanish = 'Nombre del participante' WHERE survey_question_id = 508;
UPDATE ag.survey_question SET spanish = '¿Están genéticamente relacionados?', spain_spanish = '¿Están genéticamente relacionados?' WHERE survey_question_id = 509;
UPDATE ag.survey_question SET spanish = '¿Esta persona vive con usted?', spain_spanish = '¿Esta persona vive con usted?' WHERE survey_question_id = 510;
UPDATE ag.survey_question SET spanish = '¿Dónde se quedan principalmente su(s) perro(s)?', spain_spanish = '¿Dónde se quedan principalmente su(s) perro(s)?' WHERE survey_question_id = 501;
UPDATE ag.survey_question SET spanish = '¿Dónde se quedan principalmente su(s) gatos(s)?', spain_spanish = '¿Dónde se quedan principalmente su(s) gatos(s)?' WHERE survey_question_id = 503;
UPDATE ag.survey_question SET spanish = 'Durante la última semana, ¿cómo calificaría la calidad de su sueño?', spain_spanish = 'Durante la última semana, ¿cómo calificaría la calidad de su sueño?' WHERE survey_question_id = 350;
UPDATE ag.survey_question SET spanish = '¿Con qué frecuencia se cepilla los dientes?', spain_spanish = '¿Con qué frecuencia se cepilla los dientes?' WHERE survey_question_id = 495;
UPDATE ag.survey_question SET spanish = '¿Hace un seguimiento de cualquiera de las siguientes opciones mediante el uso de una(s) aplicación(es)? Seleccione todas las que correspondan.', spain_spanish = '¿Hace un seguimiento de cualquiera de las siguientes opciones mediante el uso de una(s) aplicación(es)? Seleccione todas las que correspondan.' WHERE survey_question_id = 328;
UPDATE ag.survey_question SET spanish = '¿Con qué frecuencia participa en deportes de equipo?', spain_spanish = '¿Con qué frecuencia participa en deportes de equipo?' WHERE survey_question_id = 333;
UPDATE ag.survey_question SET spanish = 'Cuando el clima lo permite, ¿con qué frecuencia hace jardinería ?', spain_spanish = 'Cuando el clima lo permite, ¿con qué frecuencia hace jardinería ?' WHERE survey_question_id = 334;
UPDATE ag.survey_question SET spanish = '¿Qué tipo de ejercicio suele hacer? Seleccione todas las que correspondan.', spain_spanish = '¿Qué tipo de ejercicio suele hacer? Seleccione todas las que correspondan.' WHERE survey_question_id = 331;
UPDATE ag.survey_question SET spanish = '¿Qué nivel de intensidad de ejercicio suele hacer? Seleccione todas las que correspondan.', spain_spanish = '¿Qué nivel de intensidad de ejercicio suele hacer? Seleccione todas las que correspondan.' WHERE survey_question_id = 332;
UPDATE ag.survey_question SET spanish = '¿Qué tipo(s) de alcohol consume normalmente? Seleccione todas las que correspondan.', spain_spanish = '¿Qué tipo(s) de alcohol consume normalmente? Seleccione todas las que correspondan.' WHERE survey_question_id = 494;
UPDATE ag.survey_question SET spanish = 'En los días que tiene escuela o trabajo, ¿a qué hora se levanta por la mañana?', spain_spanish = 'En los días que tiene escuela o trabajo, ¿a qué hora se levanta por la mañana?' WHERE survey_question_id = 344;
UPDATE ag.survey_question SET spanish = 'En sus días libres (cuando no tiene escuela ni trabajo), ¿a qué hora se levanta por la mañana?', spain_spanish = 'En sus días libres (cuando no tiene escuela ni trabajo), ¿a qué hora se levanta por la mañana?' WHERE survey_question_id = 346;
UPDATE ag.survey_question SET spanish = 'En sus días libres (cuando no tiene escuela ni trabajo), ¿a qué hora se acuesta?', spain_spanish = 'En sus días libres (cuando no tiene escuela ni trabajo), ¿a qué hora se acuesta?' WHERE survey_question_id = 347;
UPDATE ag.survey_question SET spanish = 'Nitratos', spain_spanish = 'Nitratos' WHERE survey_question_id = 517;
UPDATE ag.survey_question SET spanish = '¿Tiene un trabajo o alguna otra situación que requiera que trabaje y duerma en horarios atípicos (por ejemplo, trabaje entre las 10 pm y las 6 am y duerma entre las 9 am y las 5 pm)?', spain_spanish = '¿Tiene un trabajo o alguna otra situación que requiera que trabaje y duerma en horarios atípicos (por ejemplo, trabaje entre las 10 pm y las 6 am y duerma entre las 9 am y las 5 pm)?' WHERE survey_question_id = 348;
UPDATE ag.survey_question SET spanish = 'Si usa dispositivos electrónicos que emiten luz, como un teléfono o una computadora portátil, justo antes de acostarse, ¿los usa en modo nocturno u oscuro?', spain_spanish = 'Si usa dispositivos electrónicos que emiten luz, como un teléfono o una computadora portátil, justo antes de acostarse, ¿los usa en modo nocturno u oscuro?' WHERE survey_question_id = 349;
UPDATE ag.survey_question SET spanish = '¿Usted surfea en el mar regularmente?', spain_spanish = '¿Usted surfea en el mar regularmente?' WHERE survey_question_id = 354;
UPDATE ag.survey_question SET spanish = 'Si respondió "sí", ¿qué tipo de EII tiene?', spain_spanish = 'Si respondió "sí", ¿qué tipo de EII tiene?' WHERE survey_question_id = 360;
UPDATE ag.survey_question SET spanish = 'Durante la última semana, ¿con qué frecuencia ha tenido dolor abdominal o malestar abdominal?', spain_spanish = 'Durante la última semana, ¿con qué frecuencia ha tenido dolor abdominal o malestar abdominal?' WHERE survey_question_id = 362;
UPDATE ag.survey_question SET spanish = 'Durante la última semana, ¿con qué frecuencia ha tenido distensión abdominal?', spain_spanish = 'Durante la última semana, ¿con qué frecuencia ha tenido distensión abdominal?' WHERE survey_question_id = 363;
UPDATE ag.survey_question SET spanish = 'Durante la última semana, ¿con qué frecuencia ha tenido flatulencias (expulsión de gases)?', spain_spanish = 'Durante la última semana, ¿con qué frecuencia ha tenido flatulencias (expulsión de gases)?' WHERE survey_question_id = 364;
UPDATE ag.survey_question SET spanish = 'Durante la última semana, ¿con qué frecuencia ha tenido borborigmos/ruidos estomacales?', spain_spanish = 'Durante la última semana, ¿con qué frecuencia ha tenido borborigmos/ruidos estomacales?' WHERE survey_question_id = 365;
UPDATE ag.survey_question SET spanish = 'Hormonas', spain_spanish = 'Hormonas' WHERE survey_question_id = 518;
UPDATE ag.survey_question SET spanish = '¿Alguna vez le han diagnosticado una afección de la piel?', spain_spanish = '¿Alguna vez le han diagnosticado una afección de la piel?' WHERE survey_question_id = 500;
UPDATE ag.survey_question SET spanish = '¿Está utilizando actualmente algún tipo de anticonceptivo?', spain_spanish = '¿Está utilizando actualmente algún tipo de anticonceptivo?' WHERE survey_question_id = 497;
UPDATE ag.survey_question SET spanish = '¿Qué tipo de afección de la piel le han diagnosticado?', spain_spanish = '¿Qué tipo de afección de la piel le han diagnosticado?' WHERE survey_question_id = 374;
UPDATE ag.survey_question SET spanish = '¿Quién diagnosticó su condición de la piel?', spain_spanish = '¿Quién diagnosticó su condición de la piel?' WHERE survey_question_id = 375;
UPDATE ag.survey_question SET spanish = 'Fecha estimada de parto:', spain_spanish = 'Fecha estimada de parto:' WHERE survey_question_id = 370;
UPDATE ag.survey_question SET spanish = 'En una escala del 1 al 10, donde 1 significa que tiene poco o nada de estrés y 10 significa que tiene mucho estrés, ¿cómo calificaría su nivel promedio de estrés durante el último mes?', spain_spanish = 'En una escala del 1 al 10, donde 1 significa que tiene poco o nada de estrés y 10 significa que tiene mucho estrés, ¿cómo calificaría su nivel promedio de estrés durante el último mes?' WHERE survey_question_id = 387;
UPDATE ag.survey_question SET spanish = '¿Aproximadamente cuándo le diagnosticaron?', spain_spanish = '¿Aproximadamente cuándo le diagnosticaron?' WHERE survey_question_id = 407;
UPDATE ag.survey_question SET spanish = '¿Alguna vez le han diagnosticado una enfermedad de salud mental?', spain_spanish = '¿Alguna vez le han diagnosticado una enfermedad de salud mental?' WHERE survey_question_id = 504;
UPDATE ag.survey_question SET spanish = '¿Qué tipo de cáncer(es) tuvo/tiene? Seleccione todas las que correspondan.', spain_spanish = '¿Qué tipo de cáncer(es) tuvo/tiene? Seleccione todas las que correspondan.' WHERE survey_question_id = 409;
UPDATE ag.survey_question SET spanish = '¿Qué tipo de tratamiento(s) tomó/toma? Seleccione todas las que correspondan.', spain_spanish = '¿Qué tipo de tratamiento(s) tomó/toma? Seleccione todas las que correspondan.' WHERE survey_question_id = 410;
UPDATE ag.survey_question SET spanish = 'De los siguientes, marque todos los síntomas que presenta con una migraña:', spain_spanish = 'De los siguientes, marque todos los síntomas que presenta con una migraña:' WHERE survey_question_id = 487;
UPDATE ag.survey_question SET spanish = 'Si respondió "sí", por favor seleccione qué trastorno(s) de la siguiente lista:', spain_spanish = 'Si respondió "sí", por favor seleccione qué trastorno(s) de la siguiente lista:' WHERE survey_question_id = 505;
UPDATE ag.survey_question SET spanish = '¿Quién le diagnosticó esto?', spain_spanish = '¿Quién le diagnosticó esto?' WHERE survey_question_id = 413;
UPDATE ag.survey_question SET spanish = '¿Con qué frecuencia experimenta migrañas?', spain_spanish = '¿Con qué frecuencia experimenta migrañas?' WHERE survey_question_id = 485;
UPDATE ag.survey_question SET spanish = 'Si respondió "sí", seleccione qué tipo de diabetes:', spain_spanish = 'Si respondió "sí", seleccione qué tipo de diabetes:' WHERE survey_question_id = 506;
UPDATE ag.survey_question SET spanish = '¿Actualmente tiene cáncer?', spain_spanish = '¿Actualmente tiene cáncer?' WHERE survey_question_id = 408;
UPDATE ag.survey_question SET spanish = '¿Alguno de sus familiares de primer grado sufre de migraña?', spain_spanish = '¿Alguno de sus familiares de primer grado sufre de migraña?' WHERE survey_question_id = 488;
UPDATE ag.survey_question SET spanish = '¿Toma algún medicamento para la migraña?', spain_spanish = '¿Toma algún medicamento para la migraña?' WHERE survey_question_id = 489;
UPDATE ag.survey_question SET spanish = 'Para las preguntas 11b - 11i, clasifique el factor del listado basado en la probabilidad de que le provoque sus migrañas, donde "1" es el más probable, "2" es el segundo más probable, etc. Si el factor no causa migrañas, elija N /A', spain_spanish = 'Para las preguntas 11b - 11i, clasifique el factor del listado basado en la probabilidad de que le provoque sus migrañas, donde "1" es el más probable, "2" es el segundo más probable, etc. Si el factor no causa migrañas, elija N /A' WHERE survey_question_id = 511;
UPDATE ag.survey_question SET spanish = 'Cafeína', spain_spanish = 'Cafeína' WHERE survey_question_id = 512;
UPDATE ag.survey_question SET spanish = 'Depresión', spain_spanish = 'Depresión' WHERE survey_question_id = 513;
UPDATE ag.survey_question SET spanish = 'Falta de sueño', spain_spanish = 'Falta de sueño' WHERE survey_question_id = 514;
UPDATE ag.survey_question SET spanish = 'Alimentos (vino, chocolate, fresas)', spain_spanish = 'Alimentos (vino, chocolate, fresas)' WHERE survey_question_id = 515;
UPDATE ag.survey_question SET spanish = 'Medicamentos que contienen barbitúricos o opioides', spain_spanish = 'Medicamentos que contienen barbitúricos o opioides' WHERE survey_question_id = 516;
UPDATE ag.survey_question SET spanish = '¿Alguna vez le han diagnosticado alguna otra condición clínica relevante?', spain_spanish = '¿Alguna vez le han diagnosticado alguna otra condición clínica relevante?' WHERE survey_question_id = 499;
UPDATE ag.survey_question SET spanish = '¿Alguna vez le han diagnosticado cáncer?', spain_spanish = '¿Alguna vez le han diagnosticado cáncer?' WHERE survey_question_id = 507;
UPDATE ag.survey_question SET spanish = '¿Toma medicamentos para aliviar sus síntomas?', spain_spanish = '¿Toma medicamentos para aliviar sus síntomas?' WHERE survey_question_id = 415;
UPDATE ag.survey_question SET spanish = 'Si practicas el ayuno intermitente, ¿qué tipo sigues?', spain_spanish = 'Si practicas el ayuno intermitente, ¿qué tipo sigues?' WHERE survey_question_id = 423;
UPDATE ag.survey_question SET spanish = '¿Cuántas comidas sueles comer al día?', spain_spanish = '¿Cuántas comidas sueles comer al día?' WHERE survey_question_id = 425;
UPDATE ag.survey_question SET spanish = '¿Cuántas meriendas/snacks comes típicamente al día?', spain_spanish = '¿Cuántas meriendas/snacks comes típicamente al día?' WHERE survey_question_id = 426;
UPDATE ag.survey_question SET spanish = '¿Cuándo consume la mayor parte de sus calorías diarias?', spain_spanish = '¿Cuándo consume la mayor parte de sus calorías diarias?' WHERE survey_question_id = 427;
UPDATE ag.survey_question SET spanish = 'Si toma un suplemento de fibra, ¿qué tipo toma? Seleccione todas las que correspondan.', spain_spanish = 'Si toma un suplemento de fibra, ¿qué tipo toma? Seleccione todas las que correspondan.' WHERE survey_question_id = 433;
UPDATE ag.survey_question SET spanish = '¿Es usted un bebé que recibe la mayor parte de su nutrición de la leche materna o fórmula, o un adulto que recibe la mayor parte (más del 75 % de las calorías diarias) de su alimentación de batidos nutricionales para adultos (por ejemplo, Ensure)?', spain_spanish = '¿Es usted un bebé que recibe la mayor parte de su nutrición de la leche materna o fórmula, o un adulto que recibe la mayor parte (más del 75 % de las calorías diarias) de su alimentación de batidos nutricionales para adultos (por ejemplo, Ensure)?' WHERE survey_question_id = 498;
UPDATE ag.survey_question SET spanish = 'Enumere/describa cualquier otra restricción dietética especial que siga que no se haya indicado anteriormente.', spain_spanish = 'Enumere/describa cualquier otra restricción dietética especial que siga que no se haya indicado anteriormente.' WHERE survey_question_id = 424;
UPDATE ag.survey_question SET spanish = '¿A qué hora suele comer su última comida o merienda antes de irse a dormir?', spain_spanish = '¿A qué hora suele comer su última comida o merienda antes de irse a dormir?' WHERE survey_question_id = 428;
UPDATE ag.survey_question SET spanish = '¿Con qué frecuencia toma un suplemento de fibra?', spain_spanish = '¿Con qué frecuencia toma un suplemento de fibra?' WHERE survey_question_id = 434;
UPDATE ag.survey_question SET spanish = 'En una semana promedio, ¿con qué frecuencia consume alimentos fortificados con alto contenido de fibra (por ejemplo, Fiber One)?', spain_spanish = 'En una semana promedio, ¿con qué frecuencia consume alimentos fortificados con alto contenido de fibra (por ejemplo, Fiber One)?' WHERE survey_question_id = 443;
UPDATE ag.survey_question SET spanish = '¿Con qué frecuencia consume alimentos que contienen edulcorantes no nutritivos o bajos en calorías?', spain_spanish = '¿Con qué frecuencia consume alimentos que contienen edulcorantes no nutritivos o bajos en calorías?' WHERE survey_question_id = 463;
UPDATE ag.survey_question SET spanish = 'En casa, ¿cuál es la principal fuente de agua potable sin saborizantes? Esto puede incluir agua sin gas o con gas/carbonatada. *En las opciones a continuación, "embotellado" incluye botellas, jarras, enfriadores de agua o dispensadores de agua.', spain_spanish = 'En casa, ¿cuál es la principal fuente de agua potable sin saborizantes? Esto puede incluir agua sin gas o con gas/carbonatada. *En las opciones a continuación, "embotellado" incluye botellas, jarras, enfriadores de agua o dispensadores de agua.' WHERE survey_question_id = 474;
UPDATE ag.survey_question SET spanish = 'Cuando está fuera de casa, ¿cuál es la principal fuente de agua potable sin saborizantes? Esto puede incluir agua sin gas o con gas/carbonatada. *En las opciones a continuación, "embotellado" incluye botellas, jarras, enfriadores de agua o dispensadores de agua.', spain_spanish = 'Cuando está fuera de casa, ¿cuál es la principal fuente de agua potable sin saborizantes? Esto puede incluir agua sin gas o con gas/carbonatada. *En las opciones a continuación, "embotellado" incluye botellas, jarras, enfriadores de agua o dispensadores de agua.' WHERE survey_question_id = 476;
UPDATE ag.survey_question SET spanish = '¿Cuándo empezaste a consumir alimentos fermentados?', spain_spanish = '¿Cuándo empezaste a consumir alimentos fermentados?' WHERE survey_question_id = 478;
UPDATE ag.survey_question SET spanish = '¿Cuánto consume normalmente en una sentada?', spain_spanish = '¿Cuánto consume normalmente en una sentada?' WHERE survey_question_id = 462;
UPDATE ag.survey_question SET spanish = 'Si respondió "sí" a consumir bebidas y/o alimentos que contienen edulcorantes no nutritivos o bajos en calorías, ¿qué tipo de edulcorantes no nutritivos o bajos en calorías consume regularmente? Seleccione todas las que correspondan.', spain_spanish = 'Si respondió "sí" a consumir bebidas y/o alimentos que contienen edulcorantes no nutritivos o bajos en calorías, ¿qué tipo de edulcorantes no nutritivos o bajos en calorías consume regularmente? Seleccione todas las que correspondan.' WHERE survey_question_id = 464;
UPDATE ag.survey_question SET spanish = 'Si respondió "sí" a la pregunta anterior, ¿cuáles son los síntomas? Seleccione todas las que correspondan.', spain_spanish = 'Si respondió "sí" a la pregunta anterior, ¿cuáles son los síntomas? Seleccione todas las que correspondan.' WHERE survey_question_id = 466;
UPDATE ag.survey_question SET spanish = 'Cuando consume alimentos o bebidas que contienen edulcorantes no nutritivos o bajos en calorías, ¿tiende a experimentar sintomas gastrointestinales posteriores, como gases, inflamación y/o diarrea?', spain_spanish = 'Cuando consume alimentos o bebidas que contienen edulcorantes no nutritivos o bajos en calorías, ¿tiende a experimentar sintomas gastrointestinales posteriores, como gases, inflamación y/o diarrea?' WHERE survey_question_id = 465;
UPDATE ag.survey_question SET spanish = 'En casa, ¿aplica tratamiento adicional (sin incluir el filtrado) al agua que bebe antes de su consumo (p. ej., hervir, tabletas de purificación, cloro/lejía)?', spain_spanish = 'En casa, ¿aplica tratamiento adicional (sin incluir el filtrado) al agua que bebe antes de su consumo (p. ej., hervir, tabletas de purificación, cloro/lejía)?' WHERE survey_question_id = 475;
UPDATE ag.survey_question SET spanish = 'Cuando está fuera de casa, ¿aplica tratamiento adicional al agua que bebe antes de consumirla (p. ej., hervir, tabletas de purificación, cloro/lejía)?', spain_spanish = 'Cuando está fuera de casa, ¿aplica tratamiento adicional al agua que bebe antes de consumirla (p. ej., hervir, tabletas de purificación, cloro/lejía)?' WHERE survey_question_id = 477;
UPDATE ag.survey_question SET spanish = 'Por favor, describa su principal fuente de agua en el hogar:', spain_spanish = 'Por favor, describa su principal fuente de agua en el hogar:' WHERE survey_question_id = 519;
UPDATE ag.survey_question SET spanish = 'Por favor, describa su principal fuente de agua fuera del hogar:', spain_spanish = 'Por favor, describa su principal fuente de agua fuera del hogar:' WHERE survey_question_id = 520;
UPDATE ag.survey_question SET spanish = 'En el último mes, ¿ha estado expuesto a alguien que probablemente tenga coronavirus/COVID-19? (marque todas las que correspondan)', spain_spanish = 'En el último mes, ¿ha estado expuesto a alguien que probablemente tenga coronavirus/COVID-19? (marque todas las que correspondan)' WHERE survey_question_id = 211;
UPDATE ag.survey_question SET spanish = 'En el último mes, ¿ha sido sospechoso de tener una infección por Coronavirus/COVID-19?', spain_spanish = 'En el último mes, ¿ha sido sospechoso de tener una infección por Coronavirus/COVID-19?' WHERE survey_question_id = 212;
UPDATE ag.survey_question SET spanish = 'En las últimas 6 semanas, ¿ha tenido alguno de los siguientes síntomas? (marque todos los que correspondan)', spain_spanish = 'En las últimas 6 semanas, ¿ha tenido alguno de los siguientes síntomas? (marque todos los que correspondan)' WHERE survey_question_id = 214;
UPDATE ag.survey_question SET spanish = '¿Cuántas veces se has contagiado de Coronavirus/COVID-19?', spain_spanish = '¿Cuántas veces se has contagiado de Coronavirus/COVID-19?' WHERE survey_question_id = 521;
UPDATE ag.survey_question SET spanish = 'Describa la calidad de la evacuación:<br /><div class="bristol-img-container"><img src="/static/img/bristol_1.png" id="bristol-chart-1" /></div><span class="bristol-chart-text">Tipo 1: Heces en bolas duras y separadas. Como frutos secos.<br />Tipo 2: Heces con forma alargada como una salchicha pero con relieves como formada por bolas unidas.</span><div class="bristol-img-container"><img src="/static/img/bristol_2.png" id="bristol-chart-2" /></div><span class="bristol-chart-text">Tipo 3: Heces con forma alargada como una salchicha, con grietas en la superficie.<br />Tipo 4: Heces con forma alargada como una salchicha, lisa y blanda.</span><div class="bristol-img-container"><img src="/static/img/bristol_3.png" id="bristol-chart-3" /></div><span class="bristol-chart-text">Tipo 5: Heces blandas y a trozos separadas o con bordes definidos.<br />Tipo 6: Heces blandas y a trozos separadas o con bordes pegados como mermelada o puré.<br />Tipo 7: Heces líquidas sin trozos sólidos.</span>', spain_spanish = 'Describa la calidad de la evacuación:<br /><div class="bristol-img-container"><img src="/static/img/bristol_1.png" id="bristol-chart-1" /></div><span class="bristol-chart-text">Tipo 1: Heces en bolas duras y separadas. Como frutos secos.<br />Tipo 2: Heces con forma alargada como una salchicha pero con relieves como formada por bolas unidas.</span><div class="bristol-img-container"><img src="/static/img/bristol_2.png" id="bristol-chart-2" /></div><span class="bristol-chart-text">Tipo 3: Heces con forma alargada como una salchicha, con grietas en la superficie.<br />Tipo 4: Heces con forma alargada como una salchicha, lisa y blanda.</span><div class="bristol-img-container"><img src="/static/img/bristol_3.png" id="bristol-chart-3" /></div><span class="bristol-chart-text">Tipo 5: Heces blandas y a trozos separadas o con bordes definidos.<br />Tipo 6: Heces blandas y a trozos separadas o con bordes pegados como mermelada o puré.<br />Tipo 7: Heces líquidas sin trozos sólidos.</span>' WHERE survey_question_id = 38;
UPDATE ag.survey_question SET spanish = '¿Con qué frecuencia usa cosméticos faciales (incluido el uso de productos para el cuidado de la piel como protector solar o humectante)?', spain_spanish = '¿Con qué frecuencia usa cosméticos faciales (incluido el uso de productos para el cuidado de la piel como protector solar o humectante)?' WHERE survey_question_id = 33;
UPDATE ag.survey_question SET spanish = '¿Con qué frecuencia come al menos 2 porciones de cereales integrales en un día? (1 porción = 1 rebanada de pan 100% integral; 1 taza de cereal integral como Shredded Wheat, Wheaties, Grape Nuts, cereales con alto contenido de fibra o avena; 3-4 galletas integrales; 1/2 taza de arroz integral o pasta integral)', spain_spanish = '¿Con qué frecuencia come al menos 2 porciones de cereales integrales en un día? (1 porción = 1 rebanada de pan 100% integral; 1 taza de cereal integral como Shredded Wheat, Wheaties, Grape Nuts, cereales con alto contenido de fibra o avena; 3-4 galletas integrales; 1/2 taza de arroz integral o pasta integral)' WHERE survey_question_id = 91;
UPDATE ag.survey_question SET spanish = '¿Con qué frecuencia consume al menos 2-3 porciones de fruta en un día? (1 porción = 1/2 taza (1 porción = 1/2 taza de jugo de fruta).', spain_spanish = '¿Con qué frecuencia consume al menos 2-3 porciones de fruta en un día? (1 porción = 1/2 taza (1 porción = 1/2 taza de jugo de fruta).' WHERE survey_question_id = 61;
UPDATE ag.survey_question SET spanish = '¿Con qué frecuencia consume al menos 2-3 porciones de verduras con almidón y sin almidón? Ejemplos de vegetales con almidón incluyen papas blancas, maíz, guisantes y repollo. Ejemplos de verduras sin almidón incluyen verduras de hoja verde crudas, pepino, tomates, pimientos, brócoli y col rizada. (1 porción = 1/2 taza de vegetales/papas; 1 taza de vegetales de hoja crudos)', spain_spanish = '¿Con qué frecuencia consume al menos 2-3 porciones de verduras con almidón y sin almidón? Ejemplos de vegetales con almidón incluyen papas blancas, maíz, guisantes y repollo. Ejemplos de verduras sin almidón incluyen verduras de hoja verde crudas, pepino, tomates, pimientos, brócoli y col rizada. (1 porción = 1/2 taza de vegetales/papas; 1 taza de vegetales de hoja crudos)' WHERE survey_question_id = 62;
UPDATE ag.survey_question SET spanish = '¿Con qué frecuencia come fuentes de proteínas de origen vegetal, como tofu, tempeh, edamame, lentejas, garbanzos, maní, almendras, nueces o quinua?', spain_spanish = '¿Con qué frecuencia come fuentes de proteínas de origen vegetal, como tofu, tempeh, edamame, lentejas, garbanzos, maní, almendras, nueces o quinua?' WHERE survey_question_id = 237;
UPDATE ag.survey_question SET spanish = 'En una semana promedio, ¿cuántas plantas diferentes come? Por ejemplo, si consume una lata de sopa que contiene zanahorias, papas y cebolla, puede contar esto como 3 plantas diferentes; Si consume pan multigrano, cada grano diferente cuenta como una planta. Incluya todas las frutas en el total.', spain_spanish = 'En una semana promedio, ¿cuántas plantas diferentes come? Por ejemplo, si consume una lata de sopa que contiene zanahorias, papas y cebolla, puede contar esto como 3 plantas diferentes; Si consume pan multigrano, cada grano diferente cuenta como una planta. Incluya todas las frutas en el total.' WHERE survey_question_id = 146;
UPDATE ag.survey_question SET spanish = 'Por lo general, ¿cuántas veces a la semana consume productos sin lactosa (leche de soja, leche sin lactosa, leche de almendras, etc.)?', spain_spanish = 'Por lo general, ¿cuántas veces a la semana consume productos sin lactosa (leche de soja, leche sin lactosa, leche de almendras, etc.)?' WHERE survey_question_id = 65;
UPDATE ag.survey_question SET spanish = 'Por lo general, ¿cuántos días a la semana consume carne de ave (pollo, pavo, etc.)?', spain_spanish = 'Por lo general, ¿cuántos días a la semana consume carne de ave (pollo, pavo, etc.)?' WHERE survey_question_id = 69;
UPDATE ag.survey_question SET spanish = 'Por lo general, ¿cuántos días a la semana consume cosas dulces (tartas, galletas, bollos, rosquillas, pastelillos, chocolate, etc.)?', spain_spanish = 'Por lo general, ¿cuántos días a la semana consume cosas dulces (tartas, galletas, bollos, rosquillas, pastelillos, chocolate, etc.)?' WHERE survey_question_id = 72;
UPDATE ag.survey_question SET spanish = '¿Con qué frecuencia cocina con aceite de oliva?', spain_spanish = '¿Con qué frecuencia cocina con aceite de oliva?' WHERE survey_question_id = 73;
UPDATE ag.survey_question SET spanish = '¿Con qué frecuencia consume bebidas con edulcorantes no nutritivos o bajos en calorías*?', spain_spanish = '¿Con qué frecuencia consume bebidas con edulcorantes no nutritivos o bajos en calorías*?' WHERE survey_question_id = 157;
UPDATE ag.survey_question SET spanish = '¿Con qué frecuencia consume alimentos ricos en oxalatos, como espinacas, acelgas, remolacha o hojas de remolacha, okra, quinua, amaranto, trigo sarraceno, salvado o germen de trigo, cereal de salvado, semillas de chía, ruibarbo, sandía, chocolate negro o cacao en polvo? (>70 %) y frutos secos como almendras, cacahuetes, nueces, anacardos y avellanas?', spain_spanish = '¿Con qué frecuencia consume alimentos ricos en oxalatos, como espinacas, acelgas, remolacha o hojas de remolacha, okra, quinua, amaranto, trigo sarraceno, salvado o germen de trigo, cereal de salvado, semillas de chía, ruibarbo, sandía, chocolate negro o cacao en polvo? (>70 %) y frutos secos como almendras, cacahuetes, nueces, anacardos y avellanas?' WHERE survey_question_id = 243;
UPDATE ag.survey_question SET spanish = 'Excluyendo la cerveza, el vino y el alcohol, he aumentado significativamente (es decir, más del doble) mi ingesta de alimentos fermentados en frecuencia o cantidad en los últimos ____.', spain_spanish = 'Excluyendo la cerveza, el vino y el alcohol, he aumentado significativamente (es decir, más del doble) mi ingesta de alimentos fermentados en frecuencia o cantidad en los últimos ____.' WHERE survey_question_id = 166;
UPDATE ag.survey_question SET spanish = '¿Con qué frecuencia consume una o más porciones de vegetales o productos vegetales fermentados? (1 porción = 1/2 taza de chucrut, kimchi o vegetales fermentados o 1 taza de kombucha)', spain_spanish = '¿Con qué frecuencia consume una o más porciones de vegetales o productos vegetales fermentados? (1 porción = 1/2 taza de chucrut, kimchi o vegetales fermentados o 1 taza de kombucha)' WHERE survey_question_id = 165;
-- Update survey_response entries
UPDATE ag.survey_response SET spanish = 'Prediabetes', spain_spanish = 'Prediabetes' WHERE american = 'Prediabetes';
UPDATE ag.survey_response SET spanish = 'Blanco', spain_spanish = 'Blanco' WHERE american = 'White';
UPDATE ag.survey_response SET spanish = '0', spain_spanish = '0' WHERE american = '0';
UPDATE ag.survey_response SET spanish = '1-2 veces/semana', spain_spanish = '1-2 veces/semana' WHERE american = '1-2 times/week';
UPDATE ag.survey_response SET spanish = '10', spain_spanish = '10' WHERE american = '10';
UPDATE ag.survey_response SET spanish = '10:00AM', spain_spanish = '10:00AM' WHERE american = '10:00AM';
UPDATE ag.survey_response SET spanish = '10:00PM', spain_spanish = '10:00PM' WHERE american = '10:00PM';
UPDATE ag.survey_response SET spanish = '10:30AM', spain_spanish = '10:30AM' WHERE american = '10:30AM';
UPDATE ag.survey_response SET spanish = '10:30PM', spain_spanish = '10:30PM' WHERE american = '10:30PM';
UPDATE ag.survey_response SET spanish = '11:00AM', spain_spanish = '11:00AM' WHERE american = '11:00AM';
UPDATE ag.survey_response SET spanish = '11:00PM', spain_spanish = '11:00PM' WHERE american = '11:00PM';
UPDATE ag.survey_response SET spanish = '11:30AM', spain_spanish = '11:30AM' WHERE american = '11:30AM';
UPDATE ag.survey_response SET spanish = '11:30PM', spain_spanish = '11:30PM' WHERE american = '11:30PM';
UPDATE ag.survey_response SET spanish = '12-16 fl oz (355-473 ml)', spain_spanish = '12-16 fl oz (355-473 ml)' WHERE american = '12-16 fl oz (355-473 ml)';
UPDATE ag.survey_response SET spanish = '12:00AM', spain_spanish = '12:00AM' WHERE american = '12:00AM';
UPDATE ag.survey_response SET spanish = '12:00PM', spain_spanish = '12:00PM' WHERE american = '12:00PM';
UPDATE ag.survey_response SET spanish = '12:30AM', spain_spanish = '12:30AM' WHERE american = '12:30AM';
UPDATE ag.survey_response SET spanish = '12:30PM', spain_spanish = '12:30PM' WHERE american = '12:30PM';
UPDATE ag.survey_response SET spanish = '16-20 fl oz (473-591 ml)', spain_spanish = '16-20 fl oz (473-591 ml)' WHERE american = '16-20 fl oz (473-591 ml)';
UPDATE ag.survey_response SET spanish = '1:00AM', spain_spanish = '1:00AM' WHERE american = '1:00AM';
UPDATE ag.survey_response SET spanish = '1:00PM', spain_spanish = '1:00PM' WHERE american = '1:00PM';
UPDATE ag.survey_response SET spanish = '1:30AM', spain_spanish = '1:30AM' WHERE american = '1:30AM';
UPDATE ag.survey_response SET spanish = '1:30PM', spain_spanish = '1:30PM' WHERE american = '1:30PM';
UPDATE ag.survey_response SET spanish = '2', spain_spanish = '2' WHERE american = '2';
UPDATE ag.survey_response SET spanish = '2 veces al día', spain_spanish = '2 veces al día' WHERE american = '2 times a day';
UPDATE ag.survey_response SET spanish = '2-3 días por semana', spain_spanish = '2-3 días por semana' WHERE american = '2-3 days per week';
UPDATE ag.survey_response SET spanish = 'Ayuno de 24 horas ', spain_spanish = 'Ayuno de 24 horas ' WHERE american = '24 hour fast (aka eat-stop-eat method)';
UPDATE ag.survey_response SET spanish = '2:00AM', spain_spanish = '2:00AM' WHERE american = '2:00AM';
UPDATE ag.survey_response SET spanish = '2:00PM', spain_spanish = '2:00PM' WHERE american = '2:00PM';
UPDATE ag.survey_response SET spanish = '2:30AM', spain_spanish = '2:30AM' WHERE american = '2:30AM';
UPDATE ag.survey_response SET spanish = '2:30PM', spain_spanish = '2:30PM' WHERE american = '2:30PM';
UPDATE ag.survey_response SET spanish = '3', spain_spanish = '3' WHERE american = '3';
UPDATE ag.survey_response SET spanish = '3-5 veces/semana', spain_spanish = '3-5 veces/semana' WHERE american = '3-5 times/week';
UPDATE ag.survey_response SET spanish = '3:00AM', spain_spanish = '3:00AM' WHERE american = '3:00AM';
UPDATE ag.survey_response SET spanish = '3:00PM', spain_spanish = '3:00PM' WHERE american = '3:00PM';
UPDATE ag.survey_response SET spanish = '3:30AM', spain_spanish = '3:30AM' WHERE american = '3:30AM';
UPDATE ag.survey_response SET spanish = '3:30PM', spain_spanish = '3:30PM' WHERE american = '3:30PM';
UPDATE ag.survey_response SET spanish = '4', spain_spanish = '4' WHERE american = '4';
UPDATE ag.survey_response SET spanish = '4-6 días por semana', spain_spanish = '4-6 días por semana' WHERE american = '4-6 days per week';
UPDATE ag.survey_response SET spanish = '4-8 fl oz (118-237 ml)', spain_spanish = '4-8 fl oz (118-237 ml)' WHERE american = '4-8 fl oz (118-237 ml)';
UPDATE ag.survey_response SET spanish = '4:00AM', spain_spanish = '4:00AM' WHERE american = '4:00AM';
UPDATE ag.survey_response SET spanish = '4:00PM', spain_spanish = '4:00PM' WHERE american = '4:00PM';
UPDATE ag.survey_response SET spanish = '4:30AM', spain_spanish = '4:30AM' WHERE american = '4:30AM';
UPDATE ag.survey_response SET spanish = '4:30PM', spain_spanish = '4:30PM' WHERE american = '4:30PM';
UPDATE ag.survey_response SET spanish = '5', spain_spanish = '5' WHERE american = '5';
UPDATE ag.survey_response SET spanish = '5:00AM', spain_spanish = '5:00AM' WHERE american = '5:00AM';
UPDATE ag.survey_response SET spanish = '5:00PM', spain_spanish = '5:00PM' WHERE american = '5:00PM';
UPDATE ag.survey_response SET spanish = 'Método 5:2 ', spain_spanish = 'Método 5:2 ' WHERE american = '5:2 method';
UPDATE ag.survey_response SET spanish = '5:30AM', spain_spanish = '5:30AM' WHERE american = '5:30AM';
UPDATE ag.survey_response SET spanish = '5:30PM', spain_spanish = '5:30PM' WHERE american = '5:30PM';
UPDATE ag.survey_response SET spanish = '6', spain_spanish = '6' WHERE american = '6';
UPDATE ag.survey_response SET spanish = '6:00AM', spain_spanish = '6:00AM' WHERE american = '6:00AM';
UPDATE ag.survey_response SET spanish = '6:00PM', spain_spanish = '6:00PM' WHERE american = '6:00PM';
UPDATE ag.survey_response SET spanish = '6:30AM', spain_spanish = '6:30AM' WHERE american = '6:30AM';
UPDATE ag.survey_response SET spanish = '6:30PM', spain_spanish = '6:30PM' WHERE american = '6:30PM';
UPDATE ag.survey_response SET spanish = '7', spain_spanish = '7' WHERE american = '7';
UPDATE ag.survey_response SET spanish = '7:00AM', spain_spanish = '7:00AM' WHERE american = '7:00AM';
UPDATE ag.survey_response SET spanish = '7:00PM', spain_spanish = '7:00PM' WHERE american = '7:00PM';
UPDATE ag.survey_response SET spanish = '7:30AM', spain_spanish = '7:30AM' WHERE american = '7:30AM';
UPDATE ag.survey_response SET spanish = '7:30PM', spain_spanish = '7:30PM' WHERE american = '7:30PM';
UPDATE ag.survey_response SET spanish = '8', spain_spanish = '8' WHERE american = '8';
UPDATE ag.survey_response SET spanish = '8-12 fl oz (237-355 ml)', spain_spanish = '8-12 fl oz (237-355 ml)' WHERE american = '8-12 fl oz (237-355 ml)';
UPDATE ag.survey_response SET spanish = '8:00AM', spain_spanish = '8:00AM' WHERE american = '8:00AM';
UPDATE ag.survey_response SET spanish = '8:00PM', spain_spanish = '8:00PM' WHERE american = '8:00PM';
UPDATE ag.survey_response SET spanish = '8:30AM', spain_spanish = '8:30AM' WHERE american = '8:30AM';
UPDATE ag.survey_response SET spanish = '8:30PM', spain_spanish = '8:30PM' WHERE american = '8:30PM';
UPDATE ag.survey_response SET spanish = '9', spain_spanish = '9' WHERE american = '9';
UPDATE ag.survey_response SET spanish = '9:00AM', spain_spanish = '9:00AM' WHERE american = '9:00AM';
UPDATE ag.survey_response SET spanish = '9:00PM', spain_spanish = '9:00PM' WHERE american = '9:00PM';
UPDATE ag.survey_response SET spanish = '9:30AM', spain_spanish = '9:30AM' WHERE american = '9:30AM';
UPDATE ag.survey_response SET spanish = '9:30PM', spain_spanish = '9:30PM' WHERE american = '9:30PM';
UPDATE ag.survey_response SET spanish = '<4 fl oz (<118 ml)', spain_spanish = '<4 fl oz (<118 ml)' WHERE american = '<4 fl oz (<118 ml)';
UPDATE ag.survey_response SET spanish = '>20 fl oz (>591 ml)', spain_spanish = '>20 fl oz (>591 ml)' WHERE american = '>20 fl oz (>591 ml)';
UPDATE ag.survey_response SET spanish = 'Algunas veces al año', spain_spanish = 'Algunas veces al año' WHERE american = 'A few times a year';
UPDATE ag.survey_response SET spanish = 'Acesulfamo de potasio', spain_spanish = 'Acesulfamo de potasio' WHERE american = 'Acesulfame potassium';
UPDATE ag.survey_response SET spanish = 'Actividad/ejercicio', spain_spanish = 'Actividad/ejercicio' WHERE american = 'Activity/exercise';
UPDATE ag.survey_response SET spanish = 'Cáncer suprarrenal', spain_spanish = 'Cáncer suprarrenal' WHERE american = 'Adrenal cancer';
UPDATE ag.survey_response SET spanish = 'Entrenamiento aeróbico/cardio', spain_spanish = 'Entrenamiento aeróbico/cardio' WHERE american = 'Aerobic/cardio training';
UPDATE ag.survey_response SET spanish = 'Ayuno en días alternos', spain_spanish = 'Ayuno en días alternos' WHERE american = 'Alternate day fasting';
UPDATE ag.survey_response SET spanish = 'Fibra de manzana', spain_spanish = 'Fibra de manzana' WHERE american = 'Apple fiber';
UPDATE ag.survey_response SET spanish = 'Asiático', spain_spanish = 'Asiático' WHERE american = 'Asian';
UPDATE ag.survey_response SET spanish = 'Aspartame', spain_spanish = 'Aspartame' WHERE american = 'Aspartame';
UPDATE ag.survey_response SET spanish = 'Certificados de grado asociados (generalmente de 2 años)', spain_spanish = 'Certificados de grado asociados (generalmente de 2 años)' WHERE american = 'Associate''s degree (e.g. AA, AS))';
UPDATE ag.survey_response SET spanish = 'Aura', spain_spanish = 'Aura' WHERE american = 'Aura';
UPDATE ag.survey_response SET spanish = 'Título de licenciatura', spain_spanish = 'Título de licenciatura' WHERE american = 'Bachelor''s degree (e.g. BA, BS)';
UPDATE ag.survey_response SET spanish = 'Entrenamiento de equilibrio', spain_spanish = 'Entrenamiento de equilibrio' WHERE american = 'Balance training';
UPDATE ag.survey_response SET spanish = 'Negro o afroamericano', spain_spanish = 'Negro o afroamericano' WHERE american = 'Black or African American';
UPDATE ag.survey_response SET spanish = 'Cáncer de vejiga', spain_spanish = 'Cáncer de vejiga' WHERE american = 'Bladder cancer';
UPDATE ag.survey_response SET spanish = 'Dolor corporal donde no debería existir;', spain_spanish = 'Dolor corporal donde no debería existir;' WHERE american = 'Body pain where it shouldn''t exist;';
UPDATE ag.survey_response SET spanish = 'Agua purificada embotellada* (no indica "agua de manantial" o "agua mineral natural" en la etiqueta)', spain_spanish = 'Agua purificada embotellada* (no indica "agua de manantial" o "agua mineral natural" en la etiqueta)' WHERE american = 'Bottled* purified water (does not indicate "spring water" or "natural mineral water" on the label)';
UPDATE ag.survey_response SET spanish = 'Cáncer cerebral (incluye gliomas y glioblastomas)', spain_spanish = 'Cáncer cerebral (incluye gliomas y glioblastomas)' WHERE american = 'Brain cancer (includes gliomas and glioblastomas)';
UPDATE ag.survey_response SET spanish = 'Cáncer de mama', spain_spanish = 'Cáncer de mama' WHERE american = 'Breast cancer';
UPDATE ag.survey_response SET spanish = 'Las calorías son distribuidas uniformemente a lo largo del día.', spain_spanish = 'Las calorías son distribuidas uniformemente a lo largo del día.' WHERE american = 'Calories are evenly distributed throughout the day';
UPDATE ag.survey_response SET spanish = 'Cáncer de cuello uterino', spain_spanish = 'Cáncer de cuello uterino' WHERE american = 'Cervical cancer';
UPDATE ag.survey_response SET spanish = 'Colangiocarcinoma', spain_spanish = 'Colangiocarcinoma' WHERE american = 'Cholangiocarcinoma';
UPDATE ag.survey_response SET spanish = 'Cáncer de colon', spain_spanish = 'Cáncer de colon' WHERE american = 'Colon cancer';
UPDATE ag.survey_response SET spanish = 'Enfermedad de Crohn colónica', spain_spanish = 'Enfermedad de Crohn colónica' WHERE american = 'Colonic Crohn''s disease';
UPDATE ag.survey_response SET spanish = 'Estriñimiento', spain_spanish = 'Estriñimiento' WHERE american = 'Constipation';
UPDATE ag.survey_response SET spanish = 'Kinder a Secundaria', spain_spanish = 'Kinder a Secundaria' WHERE american = 'Currently in K-12';
UPDATE ag.survey_response SET spanish = 'Alimentación restringida en el tiempo (TRE)', spain_spanish = 'Alimentación restringida en el tiempo (TRE)' WHERE american = 'Daily time-restricted eating (TRE)';
UPDATE ag.survey_response SET spanish = 'Dieta', spain_spanish = 'Dieta' WHERE american = 'Diet';
UPDATE ag.survey_response SET spanish = 'Título de Doctor', spain_spanish = 'Título de Doctor' WHERE american = 'Doctorate (eg. PhD, EdD)';
UPDATE ag.survey_response SET spanish = 'No sé', spain_spanish = 'No sé' WHERE american = 'Don''t know';
UPDATE ag.survey_response SET spanish = 'Cáncer de esófago', spain_spanish = 'Cáncer de esófago' WHERE american = 'Esophageal cancer';
UPDATE ag.survey_response SET spanish = 'Pocas veces/mes', spain_spanish = 'Pocas veces/mes' WHERE american = 'Few times/month';
UPDATE ag.survey_response SET spanish = 'Pocas veces/año', spain_spanish = 'Pocas veces/año' WHERE american = 'Few times/year';
UPDATE ag.survey_response SET spanish = 'Agua del grifo filtrada (jarra con filtro, grifo o purificadores de agua debajo del fregadero, sistemas de ósmosis inversa, ablandador de agua)', spain_spanish = 'Agua del grifo filtrada (jarra con filtro, grifo o purificadores de agua debajo del fregadero, sistemas de ósmosis inversa, ablandador de agua)' WHERE american = 'Filtered tap water (pitcher, faucet or under the sink water purifiers, reverse osmosis systems, water softener)';
UPDATE ag.survey_response SET spanish = 'Entrenamiento de flexibilidad', spain_spanish = 'Entrenamiento de flexibilidad' WHERE american = 'Flexibility training';
UPDATE ag.survey_response SET spanish = 'Vino fortificado', spain_spanish = 'Vino fortificado' WHERE american = 'Fortified wine';
UPDATE ag.survey_response SET spanish = 'Alimentos funcionales (por ejemplo, semillas de chía, salvado de trigo)', spain_spanish = 'Alimentos funcionales (por ejemplo, semillas de chía, salvado de trigo)' WHERE american = 'Functional food (e.g. chia seeds, wheat bran)';
UPDATE ag.survey_response SET spanish = 'Trastorno de ansiedad generalizada', spain_spanish = 'Trastorno de ansiedad generalizada' WHERE american = 'Generalized anxiety disorder';
UPDATE ag.survey_response SET spanish = 'Hard cider', spain_spanish = 'Hard cider' WHERE american = 'Hard cider';
UPDATE ag.survey_response SET spanish = 'Hard kombucha', spain_spanish = 'Hard kombucha' WHERE american = 'Hard kombucha';
UPDATE ag.survey_response SET spanish = 'Hard seltzer', spain_spanish = 'Hard seltzer' WHERE american = 'Hard seltzer';
UPDATE ag.survey_response SET spanish = 'Hard tea', spain_spanish = 'Hard tea' WHERE american = 'Hard tea';
UPDATE ag.survey_response SET spanish = 'Cáncer de cabeza y cuello', spain_spanish = 'Cáncer de cabeza y cuello' WHERE american = 'Head and Neck cancer';
UPDATE ag.survey_response SET spanish = 'Preparatoria', spain_spanish = 'Preparatoria' WHERE american = 'High school diploma or GED equivalent';
UPDATE ag.survey_response SET spanish = 'Hispano o latino', spain_spanish = 'Hispano o latino' WHERE american = 'Hispanic or Latino';
UPDATE ag.survey_response SET spanish = 'Medicamentos homeopáticos', spain_spanish = 'Medicamentos homeopáticos' WHERE american = 'Homeopathic medicines';
UPDATE ag.survey_response SET spanish = 'Terapia hormonal', spain_spanish = 'Terapia hormonal' WHERE american = 'Hormone therapy';
UPDATE ag.survey_response SET spanish = 'Hipertermia', spain_spanish = 'Hipertermia' WHERE american = 'Hyperthermia';
UPDATE ag.survey_response SET spanish = 'No como alimentos fermentados', spain_spanish = 'No como alimentos fermentados' WHERE american = 'I do not eat fermented foods';
UPDATE ag.survey_response SET spanish = 'No practico el ayuno intermitente', spain_spanish = 'No practico el ayuno intermitente' WHERE american = 'I do not practice intermittent fasting';
UPDATE ag.survey_response SET spanish = 'No tomo suplementos de fibra', spain_spanish = 'No tomo suplementos de fibra' WHERE american = 'I do not take fiber supplements';
UPDATE ag.survey_response SET spanish = 'No registro ninguna de mis actividades.', spain_spanish = 'No registro ninguna de mis actividades.' WHERE american = 'I do not track any of my activities';
UPDATE ag.survey_response SET spanish = 'No uso estos dispositivos antes de acostarme.', spain_spanish = 'No uso estos dispositivos antes de acostarme.' WHERE american = 'I do not use these devices before bed';
UPDATE ag.survey_response SET spanish = 'No bebo agua natural, sin sabor', spain_spanish = 'No bebo agua natural, sin sabor' WHERE american = 'I don''t drink plain, unflavored water';
UPDATE ag.survey_response SET spanish = 'Tomo un suplemento, pero no sé de qué tipo.', spain_spanish = 'Tomo un suplemento, pero no sé de qué tipo.' WHERE american = 'I take a supplement, but do not know what kind';
UPDATE ag.survey_response SET spanish = 'Enfermedad de Crohn ileal', spain_spanish = 'Enfermedad de Crohn ileal' WHERE american = 'Ileal Crohn''s disease';
UPDATE ag.survey_response SET spanish = 'Enfermedad de Crohn ileal y colónica', spain_spanish = 'Enfermedad de Crohn ileal y colónica' WHERE american = 'Ileal and Colonic Crohn''s disease';
UPDATE ag.survey_response SET spanish = 'Inmunoterapia', spain_spanish = 'Inmunoterapia' WHERE american = 'Immunotherapy';
UPDATE ag.survey_response SET spanish = 'Por la tarde', spain_spanish = 'Por la tarde' WHERE american = 'In the afternoon';
UPDATE ag.survey_response SET spanish = 'Por la noche', spain_spanish = 'Por la noche' WHERE american = 'In the evening';
UPDATE ag.survey_response SET spanish = 'Por la mañana', spain_spanish = 'Por la mañana' WHERE american = 'In the morning';
UPDATE ag.survey_response SET spanish = 'Inulina (por ejemplo, fiber choice)', spain_spanish = 'Inulina (por ejemplo, fiber choice)' WHERE american = 'Inulin (e.g. Fiber Choice)';
UPDATE ag.survey_response SET spanish = 'Irritabilidad o evitación de la rutina;', spain_spanish = 'Irritabilidad o evitación de la rutina;' WHERE american = 'Irritability or avoidance of routine;';
UPDATE ag.survey_response SET spanish = 'Casa/propiedad aislada (la población es inferior a 100)', spain_spanish = 'Casa/propiedad aislada (la población es inferior a 100)' WHERE american = 'Isolated house/farm (population is less than 100)';
UPDATE ag.survey_response SET spanish = 'Cáncer de riñon', spain_spanish = 'Cáncer de riñon' WHERE american = 'Kidney cancer';
UPDATE ag.survey_response SET spanish = 'Leucemia', spain_spanish = 'Leucemia' WHERE american = 'Leukemia';
UPDATE ag.survey_response SET spanish = 'Cáncer de hígado', spain_spanish = 'Cáncer de hígado' WHERE american = 'Liver cancer';
UPDATE ag.survey_response SET spanish = 'Cáncer de pulmón', spain_spanish = 'Cáncer de pulmón' WHERE american = 'Lung cancer';
UPDATE ag.survey_response SET spanish = 'Linfoma', spain_spanish = 'Linfoma' WHERE american = 'Lymphoma';
UPDATE ag.survey_response SET spanish = 'Licor de malta', spain_spanish = 'Licor de malta' WHERE american = 'Malt liquor';
UPDATE ag.survey_response SET spanish = 'Título de Maestría', spain_spanish = 'Título de Maestría' WHERE american = 'Master''s degree (e.g. MS, MA)';
UPDATE ag.survey_response SET spanish = 'Melanoma (piel)', spain_spanish = 'Melanoma (piel)' WHERE american = 'Melanoma (skin)';
UPDATE ag.survey_response SET spanish = 'Metilcelulosa (por ejemplo, Citrucel)', spain_spanish = 'Metilcelulosa (por ejemplo, Citrucel)' WHERE american = 'Methylcellulose (e.g. Citrucel)';
UPDATE ag.survey_response SET spanish = 'Metrópolis (la población es más de 1 millón)', spain_spanish = 'Metrópolis (la población es más de 1 millón)' WHERE american = 'Metropolis (population is more than 1 million)';
UPDATE ag.survey_response SET spanish = 'Fruta del monje', spain_spanish = 'Fruta del monje' WHERE american = 'Monk fruit';
UPDATE ag.survey_response SET spanish = 'Mensual', spain_spanish = 'Mensual' WHERE american = 'Monthly';
UPDATE ag.survey_response SET spanish = 'Más de 2 veces al día', spain_spanish = 'Más de 2 veces al día' WHERE american = 'More than 2 times a day';
UPDATE ag.survey_response SET spanish = 'Más de 4', spain_spanish = 'Más de 4' WHERE american = 'More than 4';
UPDATE ag.survey_response SET spanish = 'Multirracial', spain_spanish = 'Multirracial' WHERE american = 'Multiracial';
UPDATE ag.survey_response SET spanish = 'Nativo Americano o Nativo de Alaska', spain_spanish = 'Nativo Americano o Nativo de Alaska' WHERE american = 'Native American or Alaska Native';
UPDATE ag.survey_response SET spanish = 'Nativo Hawaiano u otro Isleño del Pacífico', spain_spanish = 'Nativo Hawaiano u otro Isleño del Pacífico' WHERE american = 'Native Hawaiian or Other Pacific Islander';
UPDATE ag.survey_response SET spanish = 'Agua mineral natural o de manantial embotellada* en otro país de la Unión Europea o del Reino Unido', spain_spanish = 'Agua mineral natural o de manantial embotellada* en otro país de la Unión Europea o del Reino Unido' WHERE american = 'Natural mineral or spring water bottled* in another country in the European Union or the UK';
UPDATE ag.survey_response SET spanish = 'Agua mineral natural o de manantial embotellada* en otro país fuera de la Unión Europea o el Reino Unido', spain_spanish = 'Agua mineral natural o de manantial embotellada* en otro país fuera de la Unión Europea o el Reino Unido' WHERE american = 'Natural mineral or spring water bottled* in another country not in the European Union or the UK';
UPDATE ag.survey_response SET spanish = 'Agua mineral natural o de manantial embotellada* localmente (es decir, en su país de residencia)', spain_spanish = 'Agua mineral natural o de manantial embotellada* localmente (es decir, en su país de residencia)' WHERE american = 'Natural mineral or spring water bottled* locally (i.e. in your country of residence)';
UPDATE ag.survey_response SET spanish = 'Náuseas y/o vómitos;', spain_spanish = 'Náuseas y/o vómitos;' WHERE american = 'Nausea and/or vomiting;';
UPDATE ag.survey_response SET spanish = 'Sin estudios formales', spain_spanish = 'Sin estudios formales' WHERE american = 'No formal education';
UPDATE ag.survey_response SET spanish = 'No, no tengo esta condición', spain_spanish = 'No, no tengo esta condición' WHERE american = 'No, I do not have this condition';
UPDATE ag.survey_response SET spanish = 'No, no tomo ningún medicamento para mis alergias', spain_spanish = 'No, no tomo ningún medicamento para mis alergias' WHERE american = 'No, I do not take any medications for my allergies';
UPDATE ag.survey_response SET spanish = 'No, ya no tengo cáncer', spain_spanish = 'No, ya no tengo cáncer' WHERE american = 'No, I no longer have cancer';
UPDATE ag.survey_response SET spanish = 'Fibra de avena', spain_spanish = 'Fibra de avena' WHERE american = 'Oat fiber';
UPDATE ag.survey_response SET spanish = 'Una vez por semana', spain_spanish = 'Una vez por semana' WHERE american = 'Once per week';
UPDATE ag.survey_response SET spanish = 'Solo durante el Ramadán', spain_spanish = 'Solo durante el Ramadán' WHERE american = 'Only during Ramadan';
UPDATE ag.survey_response SET spanish = 'Cáncer de ovarios', spain_spanish = 'Cáncer de ovarios' WHERE american = 'Ovarian cancer';
UPDATE ag.survey_response SET spanish = 'Cáncer de páncreas', spain_spanish = 'Cáncer de páncreas' WHERE american = 'Pancreatic cancer';
UPDATE ag.survey_response SET spanish = 'Ayuno periódico', spain_spanish = 'Ayuno periódico' WHERE american = 'Periodic fasting';
UPDATE ag.survey_response SET spanish = 'Cáncer de feocromocitoma y paraganglioma', spain_spanish = 'Cáncer de feocromocitoma y paraganglioma' WHERE american = 'Pheochromocytoma and paraganglioma cancer';
UPDATE ag.survey_response SET spanish = 'Fonofobia (sensibilidad al sonido);', spain_spanish = 'Fonofobia (sensibilidad al sonido);' WHERE american = 'Phonophobia (sensitivity to sound);';
UPDATE ag.survey_response SET spanish = 'Terapia fotodinámica', spain_spanish = 'Terapia fotodinámica' WHERE american = 'Photodynamic therapy';
UPDATE ag.survey_response SET spanish = 'Fotofobia (sensibilidad a la luz);', spain_spanish = 'Fotofobia (sensibilidad a la luz);' WHERE american = 'Photophobia (sensitivity to light);';
UPDATE ag.survey_response SET spanish = 'Título professional (quiropractico, veterinario)', spain_spanish = 'Título professional (quiropractico, veterinario)' WHERE american = 'Professional degree (e.g. MD,DDS, DVM)';
UPDATE ag.survey_response SET spanish = 'Cáncer de prostata', spain_spanish = 'Cáncer de prostata' WHERE american = 'Prostate cancer';
UPDATE ag.survey_response SET spanish = 'Psyllium (por ejemplo, Metamucil)', spain_spanish = 'Psyllium (por ejemplo, Metamucil)' WHERE american = 'Psyllium (e.g. Metamucil)';
UPDATE ag.survey_response SET spanish = 'Radioterapia', spain_spanish = 'Radioterapia' WHERE american = 'Radiotherapy';
UPDATE ag.survey_response SET spanish = 'Cáncer de recto', spain_spanish = 'Cáncer de recto' WHERE american = 'Rectal cancer';
UPDATE ag.survey_response SET spanish = 'Vino rosado', spain_spanish = 'Vino rosado' WHERE american = 'Rose wine';
UPDATE ag.survey_response SET spanish = 'Sacarina', spain_spanish = 'Sacarina' WHERE american = 'Saccharin';
UPDATE ag.survey_response SET spanish = 'Sake', spain_spanish = 'Sake' WHERE american = 'Sake';
UPDATE ag.survey_response SET spanish = 'Sarcoma', spain_spanish = 'Sarcoma' WHERE american = 'Sarcoma';
UPDATE ag.survey_response SET spanish = 'Desde la infancia/niñez', spain_spanish = 'Desde la infancia/niñez' WHERE american = 'Since infancy/childhood';
UPDATE ag.survey_response SET spanish = 'Dormir', spain_spanish = 'Dormir' WHERE american = 'Sleep';
UPDATE ag.survey_response SET spanish = 'Ciudad pequeña o pueblo (la población es de más de 100 y menos de 1000)', spain_spanish = 'Ciudad pequeña o pueblo (la población es de más de 100 y menos de 1000)' WHERE american = 'Small town or village (population is more than 100 and less than 1,000)';
UPDATE ag.survey_response SET spanish = 'Heces blandas', spain_spanish = 'Heces blandas' WHERE american = 'Soft stools';
UPDATE ag.survey_response SET spanish = 'Cerveza agria', spain_spanish = 'Cerveza agria' WHERE american = 'Sour beer';
UPDATE ag.survey_response SET spanish = 'Vino espumoso', spain_spanish = 'Vino espumoso' WHERE american = 'Sparkling wine';
UPDATE ag.survey_response SET spanish = 'Licores/cócteles', spain_spanish = 'Licores/cócteles' WHERE american = 'Spirits/liquors/hard alcohol';
UPDATE ag.survey_response SET spanish = 'Trasplante de células madre', spain_spanish = 'Trasplante de células madre' WHERE american = 'Stem cell transplant';
UPDATE ag.survey_response SET spanish = 'Stevia', spain_spanish = 'Stevia' WHERE american = 'Stevia';
UPDATE ag.survey_response SET spanish = 'Cáncer de estómago', spain_spanish = 'Cáncer de estómago' WHERE american = 'Stomach cancer';
UPDATE ag.survey_response SET spanish = 'Dolor de estómago', spain_spanish = 'Dolor de estómago' WHERE american = 'Stomachache';
UPDATE ag.survey_response SET spanish = 'Entrenamiento de fuerza', spain_spanish = 'Entrenamiento de fuerza' WHERE american = 'Strength training';
UPDATE ag.survey_response SET spanish = 'Sucralosa', spain_spanish = 'Sucralosa' WHERE american = 'Sucralose';
UPDATE ag.survey_response SET spanish = 'Alcoholes de azúcar (sorbitol, xilitol, lactitol, manitol, eritritol y maltitol)', spain_spanish = 'Alcoholes de azúcar (sorbitol, xilitol, lactitol, manitol, eritritol y maltitol)' WHERE american = 'Sugar alcohols (sorbitol, xylitol, lactitol, mannitol, erythritol, and maltitol)';
UPDATE ag.survey_response SET spanish = 'Cirugía', spain_spanish = 'Cirugía' WHERE american = 'Surgery';
UPDATE ag.survey_response SET spanish = 'Agua del grifo', spain_spanish = 'Agua del grifo' WHERE american = 'Tap water';
UPDATE ag.survey_response SET spanish = 'Terapia farmacológica dirigida ', spain_spanish = 'Terapia farmacológica dirigida ' WHERE american = 'Targeted (medication) therapy';
UPDATE ag.survey_response SET spanish = 'Cáncer testicular de células germinales', spain_spanish = 'Cáncer testicular de células germinales' WHERE american = 'Testicular germ cell cancer';
UPDATE ag.survey_response SET spanish = 'Cáncer de tiroides', spain_spanish = 'Cáncer de tiroides' WHERE american = 'Thyroid cancer';
UPDATE ag.survey_response SET spanish = 'Ciudad mediana (la población es de más de 1000 y menos de 100 000)', spain_spanish = 'Ciudad mediana (la población es de más de 1000 y menos de 100 000)' WHERE american = 'Town (population is more than 1,000 and less than 100,000)';
UPDATE ag.survey_response SET spanish = 'Colitis ulcerosa', spain_spanish = 'Colitis ulcerosa' WHERE american = 'Ulcerative Colitis';
UPDATE ag.survey_response SET spanish = 'Cáncer uterino', spain_spanish = 'Cáncer uterino' WHERE american = 'Uterine cancer';
UPDATE ag.survey_response SET spanish = 'Melanoma uveal', spain_spanish = 'Melanoma uveal' WHERE american = 'Uveal melanoma';
UPDATE ag.survey_response SET spanish = 'Vigoroso', spain_spanish = 'Vigoroso' WHERE american = 'Vigorous';
UPDATE ag.survey_response SET spanish = 'Especializaciones vocacionales', spain_spanish = 'Especializaciones vocacionales' WHERE american = 'Vocational training';
UPDATE ag.survey_response SET spanish = 'Semanalmente', spain_spanish = 'Semanalmente' WHERE american = 'Weekly';
UPDATE ag.survey_response SET spanish = 'Agua de pozo', spain_spanish = 'Agua de pozo' WHERE american = 'Well water';
UPDATE ag.survey_response SET spanish = 'Dextrina de trigo (por ejemplo, Benefiber)', spain_spanish = 'Dextrina de trigo (por ejemplo, Benefiber)' WHERE american = 'Wheat dextrin (e.g. Benefiber)';
UPDATE ag.survey_response SET spanish = 'En los últimos 10 años', spain_spanish = 'En los últimos 10 años' WHERE american = 'Within the last 10 years';
UPDATE ag.survey_response SET spanish = 'En los últimos 5 años', spain_spanish = 'En los últimos 5 años' WHERE american = 'Within the last 5 years';
UPDATE ag.survey_response SET spanish = 'En el último año', spain_spanish = 'En el último año' WHERE american = 'Within the last year';
UPDATE ag.survey_response SET spanish = 'Sí, actualmente tengo cáncer', spain_spanish = 'Sí, actualmente tengo cáncer' WHERE american = 'Yes, I currently have cancer';
UPDATE ag.survey_response SET spanish = 'Sí, tomo medicamentos homeopáticos', spain_spanish = 'Sí, tomo medicamentos homeopáticos' WHERE american = 'Yes, I take homeopathic medication';
UPDATE ag.survey_response SET spanish = 'Sí, tomo medicamentos de venta libre (sin receta)', spain_spanish = 'Sí, tomo medicamentos de venta libre (sin receta)' WHERE american = 'Yes, I take over-the-counter medication';
UPDATE ag.survey_response SET spanish = 'Sí, tomo medicamentos de venta con receta', spain_spanish = 'Sí, tomo medicamentos de venta con receta' WHERE american = 'Yes, I take prescription medication';
UPDATE ag.survey_response SET spanish = 'Sí, uso un parche anticonceptivo', spain_spanish = 'Sí, uso un parche anticonceptivo' WHERE american = 'Yes, I use a contraceptive patch';
UPDATE ag.survey_response SET spanish = 'Sí, uso un anillo vaginal anticonceptivo', spain_spanish = 'Sí, uso un anillo vaginal anticonceptivo' WHERE american = 'Yes, I use a contraceptive vaginal ring';
UPDATE ag.survey_response SET spanish = 'Sí, uso un DIU de cobre', spain_spanish = 'Sí, uso un DIU de cobre' WHERE american = 'Yes, I use a copper IUD';
UPDATE ag.survey_response SET spanish = 'Sí, uso un DIU hormonal/implante ', spain_spanish = 'Sí, uso un DIU hormonal/implante ' WHERE american = 'Yes, I use a hormonal IUD/implant';
UPDATE ag.survey_response SET spanish = 'Sí, uso un anticonceptivo inyectado', spain_spanish = 'Sí, uso un anticonceptivo inyectado' WHERE american = 'Yes, I use an injected contraceptive';
UPDATE ag.survey_response SET spanish = 'Sí, uso otros tipos de medicamentos que no son mencionados en esta lista', spain_spanish = 'Sí, uso otros tipos de medicamentos que no son mencionados en esta lista' WHERE american = 'Yes, I use other types of medication not listed here';
UPDATE ag.survey_response SET spanish = 'Sí, diagnosticado por un profesional médico especializado el área de la salud mental', spain_spanish = 'Sí, diagnosticado por un profesional médico especializado el área de la salud mental' WHERE american = 'Yes, diagnosed by a licensed mental health professional';
UPDATE ag.survey_response SET spanish = 'Sí, diagnosticado por un médico general o un asistente médico', spain_spanish = 'Sí, diagnosticado por un médico general o un asistente médico' WHERE american = 'Yes, diagnosed by a medical professional (doctor, physician assistant)';
UPDATE ag.survey_response SET spanish = 'Sí, diagnosticado por un médico alternativo o complementario', spain_spanish = 'Sí, diagnosticado por un médico alternativo o complementario' WHERE american = 'Yes, diagnosed by an alternative or complementary practitioner';
UPDATE ag.survey_response SET spanish = 'Ambos por igual', spain_spanish = 'Ambos por igual' WHERE american = 'Both equally';
UPDATE ag.survey_response SET spanish = 'Ciudad grande (la población es de más de 100.000 y menos de 1 millón)', spain_spanish = 'Ciudad grande (la población es de más de 100.000 y menos de 1 millón)' WHERE american = 'City (population is more than 100,000 and less than 1 million)';
UPDATE ag.survey_response SET spanish = '2021', spain_spanish = '2021' WHERE american = '2021';
UPDATE ag.survey_response SET spanish = '2022', spain_spanish = '2022' WHERE american = '2022';
UPDATE ag.survey_response SET spanish = 'N/A', spain_spanish = 'N/A' WHERE american = 'N/A';
UPDATE ag.survey_response SET spanish = 'Falta de aire o dificultad para respirar', spain_spanish = 'Falta de aire o dificultad para respirar' WHERE american = 'Shortness of breath or difficulty breathing';
UPDATE ag.survey_response SET spanish = 'Dolores de cabeza', spain_spanish = 'Dolores de cabeza' WHERE american = 'Headaches';
UPDATE ag.survey_response SET spanish = 'Dolores musculares', spain_spanish = 'Dolores musculares' WHERE american = 'Muscle aches';
UPDATE ag.survey_response SET spanish = 'Escurrimiento o congestión nasal', spain_spanish = 'Escurrimiento o congestión nasal' WHERE american = 'Runny or stuffy nose';
UPDATE ag.survey_response SET spanish = 'Sibilancias', spain_spanish = 'Sibilancias' WHERE american = 'Wheezing';
UPDATE ag.survey_response SET spanish = '3 o más', spain_spanish = '3 o más' WHERE american = '3 or more';
UPDATE ag.survey_response SET spanish = 'Escuela o carrera técnica', spain_spanish = 'Escuela o carrera técnica' WHERE american = 'Some college or technical school';
UPDATE ag.survey_response SET spanish = 'La diagnosticó un practicante de medicina alternativa', spain_spanish = 'La diagnosticó un practicante de medicina alternativa' WHERE american = 'Diagnosed by an alternative medicine practitioner';
-- Every consent/assent document was updated with varying degrees of minor changes since the last update.
-- Since none of them have been used in production yet, we can safely update in place rather than insert new versions.
-- This patch will include en_US, es_MX, and es_ES. ja_JP documents will be handled separately in the Japanese updates branch.
-- For any future maintainers, this practice should NOT be carried forward beyond the TMI relaunch - even minor verbiage updates should be inserted as new records in the table with reconsent = true
UPDATE ag.consent_documents SET date_time = NOW(), consent_content = '<p class="consent_title">
<strong>University of California San Diego</strong><br />
Assent to Act as a Research Subject<br />
(Ages 13-17 years)
</p>
<p class="consent_title">
<strong>The Microsetta Initiative</strong><br />
Biospecimen and Future Use Research
</p>
<p class="consent_header">
Who is conducting the study, why have you been asked to participate, how were you selected, and what is the approximate number of participants in the study?
</p>
<p class="consent_content">
Dr. Rob Knight from the University of California San Diego (UC San Diego) is conducting a research study to find out more about all the many bacteria and other microorganisms (called your microbiome) that live on and within your body. You have been asked to participate in this study because you, and everyone else on earth, have a unique microbiome, and the more people we study of all ages, the more we will understand about how the microorganisms may help or harm us. There will be approximately 500,000 participants in total in the study from across the USA and from other countries around the world.
</p>
<p class="consent_header">
Why is this study being done?
</p>
<p class="consent_content">
The purpose of this study is to assess more accurately the microbial differences between people and whether these differences can be attributed to factors such as lifestyle, diet, body type, age or the presence of associated diseases. Biospecimens are samples from your body such as stool, skin, urine, or blood which are used for research purposes. This study involves the collection, storage, and use of your information and biospecimens for the purpose of processing your biospecimens and for future research. The results will be used to create a database of DNA sequence and other data from various body sites, as well as details about you (the participant supplying the sample). Researchers can then use that data while studying relevant topics, such as gut-related health conditions.
</p>
<p class="consent_header">
What will happen to you in this study and which procedures are standard of care and which are experimental?
</p>
<p class="consent_content">
If you agree to participate in this study, the following will happen to you:
</p>
<p class="consent_content">
You will sample yourself using the kit that was provided to you. Instructions are included in the kit so you know what to do. The most common sample is of your poop (stool) where you apply a small smear to the tips of a swab from used toilet tissue or to a card (called an FOBT card). You may also be asked to scoop some poop using a small spoon-like tool, place used toilet paper into a special receptacle we provide, or poop into a plastic container that you place under the toilet seat. You may also need to sample a small area of skin, your tongue or mouth, your nostrils, ear wax, or vagina. We may also ask someone (like your mom or dad) to take a small sample of blood by pricking your finger and then collecting the blood on 2 small swabs. None of these samples or investigations will allow us to make a diagnosis of disease and we are not looking at anything in your own DNA that can also be found in your poop, skin, or saliva.
</p>
<p class="consent_header">
How much time will each study procedure take, what is your total time commitment, and how long will the study last?
</p>
<p class="consent_content">
Each sample you send can be obtained in 5 minutes or less. We expect the study to continue for many years, but your results will be available to you before the end of the study.
</p>
<p class="consent_header">
What risks are associated with this study?
</p>
<p class="consent_content">
Participation in this study may involve some added risks or discomforts. These include the following:<br />
<ol>
<li>You may experience temporary pain or a bruise at the site of the needle-stick if you take the blood test.</li>
<li>There is a risk of loss of confidentiality.</li>
</ol>
</p>
<p class="consent_content">
Because this is a research study, there may be some unknown risks that are currently unforeseeable. You and your parents will be informed of any significant new findings.
</p>
<p class="consent_header">
What are the alternatives to participating in this study? Can you withdraw from the study or be withdrawn?
</p>
<p class="consent_content">
Your participation in this study is completely voluntary. We will inform you if any important new information is found during the course of this study that may affect your wanting to continue.
</p>
<p class="consent_content">
You can refuse to participate or withdraw at any time by deleting your online profile, or by requesting the deletion of your account. Our researchers will still use the data about you that was collected before you withdrew. These data will not include any personal information that could directly identify you. After you withdraw, no further data will be collected from you.
</p>
<p class="consent_content">
You may be withdrawn from the study if you do not follow the instructions given to you by the study personnel.
</p>
<p class="consent_header">
What benefits can be reasonably expected?
</p>
<p class="consent_content">
There is no direct benefit to you for participating in this study. You will get access to your data that will give you and your parents an idea of what kinds of microorganisms are in your sample and how it compares with other people like you (age, sex).
</p>
<p class="consent_header">
Will you be compensated for participating in this study?
</p>
<p class="consent_content">
You will not be financially compensated in this study.
</p>
<p class="consent_header">
Are there any costs associated with participating in this study?
</p>
<p class="consent_content">
There may be costs associated with obtaining a kit. Once you receive your kit, there will be no additional cost to you for participating in this sampling procedure.
</p>
<p class="consent_header">
What about your confidentiality?
</p>
<p class="consent_content">
Research records will be kept confidential to the extent allowed by law. As part of your participation in the study, you will provide personal and/or sensitive information that could allow you to be identified if it was made public, such as name, date of birth, or address. We take every precaution to protect your identity. All data you provide is stored on secure systems within UC San Diego''s infrastructure and directly identifying information is accessible only to critical study personnel. The database that stores participant personal and sample information runs on a password-protected server that is accessible only to relevant staff such as Dr. Knight, Co-Investigators, project and sample coordinators, IT administrator and the database coders. Research records may be reviewed by the UC San Diego Institutional Review Board.
</p>
<p class="consent_header">
How we will use your Sample
</p>
<p class="consent_content">
Information from analyses of your data and biospecimen(s) will be used to study the non-human DNA (e.g. bacterial DNA) in it. The data from the samples in the project (including yours) may be analyzed and published in scientific articles. We may save some of your sample to be accessible to researchers so they can conduct additional studies using the other compounds from it, such as RNA, proteins or metabolites. If we do so, we will remove all directly identifiable information before use or sharing. Once identifiers have been removed, we will not ask for your consent for the use or sharing of your data and/or sample(s) in other research. In addition, data that has been removed of directly identifying information will be uploaded to the European Bioinformatics Institute (http://www.ebi.ac.uk) and Qiita (https://qiita.ucsd.edu) for other researchers to access and use. We may contact you if additional information or action is needed in order to process your sample(s) and/or for re-consenting purposes.
</p>
<p class="consent_content">
Biospecimens (such as stool, saliva, mucus, skin, urine, or blood) collected from you for this study and information obtained from your biospecimens may be used in this research or other research, and shared with other organizations. You will not share in any commercial value or profit derived from the use of your biospecimens and/or information obtained from them.
</p>
<p class="consent_content">
<strong><u>Please Note</u></strong>:<br />
Please be aware that <strong>no human DNA</strong> will be analyzed as part of this or any future studies. Furthermore, the methods we use for identifying microorganisms in your sample <strong>cannot be used to diagnose disease or infection</strong>.
</p>
<p class="consent_header">
Who can you call if you have questions?
</p>
<p class="consent_content">
If you have questions or research-related problems, you may reach us by emailing our help account microsetta@ucsd.edu or Rob Knight at 858-246-1184.
</p>
<p class="consent_content">
You may contact UC San Diego Office of IRB Administration at 858-246-4777 or email at irb@ucsd.edu to inquire about your rights as a research subject or to report research-related problems.
</p>
<p class="consent_header">
Your Signature and Assent
</p>
<p class="consent_content">
You may download a copy of this assent document and a copy of the "<a href="https://oag.ca.gov/sites/all/files/agweb/pdfs/research/bill_of_rights.pdf" target="_blank">Experimental Subject''s Bill of Rights</a>" to keep.
</p>' WHERE locale = 'en_US' AND consent_type = 'adolescent_biospecimen';
UPDATE ag.consent_documents SET date_time = NOW(), consent_content = '<p class="consent_title">
<strong>University of California San Diego</strong><br />
Assent to Act as a Research Subject<br />
(Ages 13-17 years)
</p>
<p class="consent_title">
<strong>The Microsetta Initiative</strong>
</p>
<p class="consent_header">
Who is conducting the study, why have you been asked to participate, how were you selected, and what is the approximate number of participants in the study?
</p>
<p class="consent_content">
Dr. Rob Knight from the University of California San Diego (UC San Diego) is conducting a research study to find out more about all the many bacteria and other microorganisms (called your microbiome) that live on and within your body. You have been asked to participate in this study because you, and everyone else on earth, have a unique microbiome, and the more people we study of all ages, the more we will understand about how the microorganisms may help or harm us. There will be approximately 500,000 participants in total in the study from across the USA and from other countries around the world.
</p>
<p class="consent_header">
Why is this study being done and what will happen to you?
</p>
<p class="consent_content">
The purpose of this research study is to assess more accurately the differences among people and whether these differences can be attributed to factors such as lifestyle, diet, body type, age or the presence of associated diseases. If you agree to take part in this study, you will be asked to complete online surveys/questionnaires. This survey/questionnaire will ask questions about you, such as your age, weight, height, lifestyle, diet, and if you have certain medical or health conditions. You should expect to spend an average of 5-10 minutes on each survey, but some may take up to 30 minutes to complete.
</p>
<p class="consent_header">
What benefits can be reasonably expected?
</p>
<p class="consent_content">
There is no monetary or direct benefit for participating in this study. If you complete one of the questionnaires called the Food Frequency Questionnaire (FFQ), you may receive a nutritional report evaluating your eating pattern and nutrient intake with an overall diet score. The investigator(s), however, may learn more about relevant topics, such as gut-related health conditions.
</p>
<p class="consent_header">
What risks and confidentiality are associated with this study?
</p>
<p class="consent_content">
Participation in this study can involve some added minimal risks or discomforts. While answering surveys, you may feel frustration, emotional discomfort, fatigue, and/or boredom. There is also a risk of loss of confidentiality, but we take every precaution to protect your identity and minimize the risks. All data you provide is stored on secure systems within UC San Diego''s infrastructure and directly identifying information is accessible only to critical research personnel. The database that stores participant personal and sample information runs on a password-protected server that is accessible only to relevant staff such as Dr. Knight, Co-Investigators, project and sample coordinators, IT administrator and the database coders. Research records will be kept confidential to the extent allowed by law and may be reviewed by the UC San Diego Institutional Review Board.
</p>
<p class="consent_header">
What are the alternatives to participating in this study and can you withdraw?
</p>
<p class="consent_content">
Your participation in this study is completely voluntary and you are free to skip any question that you choose. We will inform you if any important new information is found during the course of this study that may affect your wanting to continue.
</p>
<p class="consent_content">
You can refuse to participate or withdraw at any time by deleting your online profile. Our researchers will still use the data about you that was collected before you withdrew. These data will not include any personal information that could directly identify you. After you withdraw, no further data will be collected from you.
</p>
<p class="consent_header">
Know what we will collect
</p>
<p class="consent_content">
As part of this research study, we will create and obtain information related to you and your participation in the study from you or from collaborators so we can properly conduct this research. Research study data will include contact information, demographic information, personal experiences, lifestyle preferences, health information, date of birth, opinions or beliefs.
</p>
<p class="consent_header">
How we will use your Personal Data
</p>
<p class="consent_content">
The Personal Data you provide will be used for the following purposes:<br />
<ul>
<li>To share with members of the research team so they can properly conduct the research.</li>
<li>For future research studies or additional research by other researchers.</li>
<li>To contact you for the purpose of receiving alerts of your participation status, general program updates, opportunities to take part in new or future research, and/or as a follow-up to questions you have responded to in the questionnaire(s).</li>
<li>To comply with legal and regulatory requirements, including requirements to share data with regulatory agencies overseeing the research.</li>
<li>To confirm proper conduct of the study and research integrity.</li>
</ul>
</p>
<p class="consent_header">
Retention of your Personal Data
</p>
<p class="consent_content">
We may retain your Personal Data for as long as necessary to fulfill the objectives of the research and to ensure the integrity of the research. We will delete your Personal Data when it is no longer needed for the study or if you withdraw your consent provided such deletion does not render impossible or seriously impair the achievement of the objectives of the research project. However, your information will be retained as necessary to comply with legal or regulatory requirements.
</p>
<p class="consent_header">
Your Privacy Rights
</p>
<p class="consent_content">
The General Data Protection Regulation ("GDPR") requires researchers to provide information to you when we collect and use research data if you are located within the European Union (EU) or the European Economic Area (EEA). The GDPR gives you rights relating to your Personal Data, including the right to access, correct, restrict, and withdraw your personal information.
</p>
<p class="consent_content">
The research team will store and process your Personal Data at our research site in the United States. The United States does not have the same laws to protect your Personal Data as countries in the EU/EEA. However, the research team is committed to protecting the confidentiality of your Personal Data. Additional information about the protections we will use is included in this consent document and in our Privacy Statement.
</p>
<p class="consent_header">
Who can you call if you have questions?
</p>
<p class="consent_content">
If you have questions or research-related problems, you may reach Rob Knight at 858-246-1184 or email our help account: microsetta@ucsd.edu.
</p>
<p class="consent_content">
You may contact UC San Diego Office of IRB Administration at 858-246-4777 or email at irb@ucsd.edu to inquire about your rights as a research subject or to report research-related problems.
</p>
<p class="consent_content">
If you have questions or complaints about our treatment of your Personal Data, or about our privacy practices more generally, please feel free to contact the UC San Diego Privacy Official by email at ucsdprivacy@ucsd.edu.
</p>
<p class="consent_header">
Your Signature and Consent
</p>
<p class="consent_content">
You may download a copy of this consent document and a copy of the "<a href="https://oag.ca.gov/sites/all/files/agweb/pdfs/research/bill_of_rights.pdf" target="_blank">Experimental Subject''s Bill of Rights</a>" to keep.
</p>
<p class="consent_content">
Your consent is entirely voluntary, but declining to provide it may impede your ability to participate in this research.
</p>' WHERE locale = 'en_US' AND consent_type = 'adolescent_data';
UPDATE ag.consent_documents SET date_time = NOW(), consent_content = '<p class="consent_title">
<strong>University of California San Diego<br />
Consent to Act as a Research Subject</strong>
</p>
<p class="consent_title">
<strong>The Microsetta Initiative</strong><br />
Biospecimen and Future Use Research
</p>
<p class="consent_header">
Who is conducting the study, why have you been asked to participate, how were you selected, and what is the approximate number of participants in the study?
</p>
<p class="consent_content">
Dr. Rob Knight is conducting a research study to find out more about the trillions of bacteria and other microorganisms (called your microbiome) that live in and on your body. This includes eukaryotes like fungi and parasites, prokaryotes like bacteria and archaea, and viruses. You have been asked to participate in this study because your microbiome is unique – not the same as anyone else''s on earth. There will be approximately 500,000 participants in the study from across the USA and from other countries around the world.
</p>
<p class="consent_header">
Why is this study being done?
</p>
<p class="consent_content">
The purpose of this study is to assess more accurately the microbial differences among people and whether these differences can be attributed to factors such as lifestyle, diet, body type, age or the presence of associated diseases. Biospecimens are samples from your body such as stool, skin, urine, or blood which are used for research purposes. This study involves the collection, storage, and use of your information and biospecimens for the purpose of processing your biospecimens and for future research. The results will be used to create a database of DNA sequence and other data from various body sites, as well as details about you (the participant supplying the sample). Researchers can then use that data while studying relevant topics, such as gut-related health conditions.
</p>
<p class="consent_header">
What will happen to you in this study?
</p>
<p class="consent_content">
If you agree to the collection and processing of your biospecimen(s), the following will happen to you:
</p>
<p class="consent_content">
You have received or will receive a sample kit. The kit contains devices used to collect samples and instructions for use. The collection device may also include 95% ethanol to preserve the sample and make it non-infectious. You will then collect a sample of yourself (e.g. feces, skin, mouth, nostril, ear, vagina), pet, or environment as described in the kit instructions or in the instructions provided to you by study coordinators. You will also be asked to provide general collection information such as the date and time your sample was collected. All samples should be returned to us in the included containers according to the instructions provided.
</p>
<p class="consent_content">
If collecting from stool, you will be asked to sample in one of a variety of ways, such as the following:<br />
<ol>
<li>By inserting swab tip(s) into used toilet tissue and returning the swab(s) in the provided plastic container;</li>
<li>By inserting swab tip(s) into used toilet tissue and applying the tips to the surface of a Fecal Occult Blood Test (FOBT) card, then returning the card to us. The FOBT card is the same device used by your doctor to check for blood in your stool. The FOBT card stabilizes the stool material for later analysis. We will not check if there is blood in the stool for diagnostic purposes because we are not a clinical laboratory;</li>
<li>By using a scooper device to scoop a part of the fecal material into the provided tube;</li>
<li>Depositing soiled toilet paper into the provided receptacle;</li>
<li>Submitting a whole stool sample in a shipping container we will provide. This container will have ice packs that reliably cool the sample to -20 degrees Celsius/-4 degrees Fahrenheit.</li>
</ol>
</p>
<p class="consent_content">
If you received a blood collection kit, it contains materials and instructions on how to collect a blood sample at home. It is similar to the test used to test glucose levels by pricking your finger.
</p>
<p class="consent_content">
Once your sample has been analyzed, we will upload results to your account and send you an email with a link to log in and view them. We estimate that it can take 1-3 months for you to learn the results of your microbiome analysis. If you are a part of a specific sub-study, it may take longer, depending on the duration of the study.
</p>
<p class="consent_header">
How much time will each study procedure take, what is your total time commitment, and how long will the study last?
</p>
<p class="consent_content">
Each sample you send can be obtained in 5 minutes or less. We expect the study to continue for many years but your results will be available to you before the end of the study.
</p>
<p class="consent_header">
What risks are associated with this study?
</p>
<p class="consent_content">
Participation in this study may involve some added risks or discomforts. These include the following:<br />
<ol>
<li>If using the blood collection device, you may experience temporary pain or a bruise at the site of the needle-stick.</li>
<li>There is a risk of loss of confidentiality.</li>
</ol>
</p>
<p class="consent_content">
Because this is a research study, there may be some unknown risks that are currently unforeseeable. You will be informed of any significant new findings.
</p>
<p class="consent_header">
What are the alternatives to participating in this study? Can you withdraw from the study or be withdrawn?
</p>
<p class="consent_content">
Your participation in this study is completely voluntary. We will inform you if any important new information is found during the course of this study that may affect your wanting to continue.
</p>
<p class="consent_content">
You can refuse to participate or withdraw at any time by deleting your online profile, or by requesting the deletion of your account. Our researchers will still use the data about you that was collected before you withdrew. These data will not include any personal information that could directly identify you. After you withdraw, no further data will be collected from you.
</p>
<p class="consent_content">
You may be withdrawn from the study if you do not follow the instructions given to you by the study personnel.
</p>
<p class="consent_header">
What benefits can be reasonably expected?
</p>
<p class="consent_content">
There is no monetary or direct benefit for participating in this study. You will receive a report detailing the results of our analysis on your biospecimen(s), as well as facts and figures comparing your microbiome''s composition to that of other study participants. The investigator, however, may learn more about the human microbiome in health and disease and provide a valuable resource for other researchers.
</p>
<p class="consent_header">
Are there any costs associated with participating in the collection of your biospecimen(s)?
</p>
<p class="consent_content">
There may be costs associated with obtaining a kit. Once you receive your kit, there will be no additional cost to you for participating in this sampling procedure.
</p>
<p class="consent_header">
What about your confidentiality?
</p>
<p class="consent_content">
Research records will be kept confidential to the extent allowed by law. As part of your participation in the study, you will provide personal and/or sensitive information that could allow you to be identified if it was made public, such as name, date of birth, or address. We take every precaution to protect your identity. All data you provide is stored on secure systems within UC San Diego''s infrastructure and directly identifying information is accessible only to critical research personnel. The database that stores participant personal and sample information runs on a password-protected server that is accessible only to relevant staff such as Dr. Knight, Co-Investigators, project and sample coordinators, IT administrator and the database coders. The professionally maintained database server has several layers of security: it is password protected, firewalled, only allows network connectivity from defined UC San Diego managed systems, employs access control lists, and is physically housed in a key card controlled UC San Diego facility. Nightly backups of the database are taken and maintained on a separate co-located system with additional security measures in place. Sample analysis is performed using data from which directly identifying information has been removed, and all data shared with public repositories also undergo this treatment. Research records may be reviewed by the UC San Diego Institutional Review Board.
</p>
<p class="consent_header">
How we will use your Sample
</p>
<p class="consent_content">
Information from analyses of your data and biospecimen(s) will be used to study the non-human DNA (e.g. bacterial DNA) in it. The data from the samples in the project (including yours) may be analyzed and published in scientific articles. We may save some of your sample to be accessible to researchers so they can conduct additional studies using the other compounds from it, such as RNA, proteins or metabolites. If we do so, we will remove all directly identifiable information before use or sharing. Once identifiers have been removed, we will not ask for your consent for the use or sharing of your data and/or biospecimen(s) in other research. In addition, data that has been removed of directly identifying information will be uploaded to the European Bioinformatics Institute (http://www.ebi.ac.uk) and Qiita (https://qiita.ucsd.edu) for other researchers to access and use.We may contact you if additional information or action is needed in order to process your sample(s) and/or for re-consenting purposes.
</p>
<p class="consent_content">
Biospecimens (such as stool, saliva, mucus, skin, urine, or blood) collected from you for this study and information obtained from your biospecimens may be used in this research or other research, and shared with other organizations. You will not share in any commercial value or profit derived from the use of your biospecimens and/or information obtained from them.
</p>
<p class="consent_content">
<strong><u>Please Note</u></strong>:<br />
Please be aware that <strong>no human DNA</strong> will be analyzed as part of this or any future studies. Furthermore, the methods we use for identifying microorganisms in your sample <strong>cannot be used to diagnose disease or infection</strong>.
</p>
<p class="consent_header">
Who can you call if you have questions?
</p>
<p class="consent_content">
If you have questions or research-related problems, you may reach Rob Knight at 858-246-1184 or email our help account: microsetta@ucsd.edu.
</p>
<p class="consent_content">
You may contact UC San Diego Office of IRB Administration at 858-246-4777 or email at irb@ucsd.edu to inquire about your rights as a research subject or to report research-related problems.
</p>
<p class="consent_header">
Your Signature and Consent
</p>
<p class="consent_content">
You may download a copy of this consent document and a copy of the "<a href="https://oag.ca.gov/sites/all/files/agweb/pdfs/research/bill_of_rights.pdf" target="_blank">Experimental Subject''s Bill of Rights</a>" to keep.
</p>
<p class="consent_content">
Your consent is entirely voluntary, but declining to provide it may impede your ability to participate in this research and have your sample(s) processed.
</p>' WHERE locale = 'en_US' AND consent_type = 'adult_biospecimen';
UPDATE ag.consent_documents SET date_time = NOW(), consent_content = '<p class="consent_title">
<strong>University of California San Diego<br />
Consent to Act as a Research Subject</strong>
</p>
<p class="consent_title">
<strong>The Microsetta Initiative</strong>
</p>
<p class="consent_header">
Who is conducting the study, why have you been asked to participate, how were you selected, and what is the approximate number of participants in the study?
</p>
<p class="consent_content">
You are being invited to participate in a research study titled The Microsetta Initiative. This study is being done by Dr. Rob Knight from the University of California San Diego (UC San Diego). You were selected to participate in this study because you are unique and your microbiome is unique – not the same as anyone else''s on earth. There will be approximately 500,000 participants in the study from across the USA and from other countries around the world.
</p>
<p class="consent_header">
Why is this study being done and what will happen to you?
</p>
<p class="consent_content">
The purpose of this research study is to assess more accurately the microbial differences among people and whether these differences can be attributed to factors such as lifestyle, diet, body type, age or the presence of associated diseases. If you agree to take part in this study, you will be asked to complete online surveys/questionnaires. These surveys/questionnaires are categorized by content type and will ask questions about you, such as your age, weight, height, lifestyle, diet, and if you have certain medical or health conditions. You should expect to spend an average of 5-10 minutes on each survey, but some may take up to 30 minutes to complete.
</p>
<p class="consent_header">
What benefits can be reasonably expected?
</p>
<p class="consent_content">
There is no monetary or direct benefit for participating in this study. If you complete one of the questionnaires, called a Food Frequency Questionnaire (FFQ), you may receive a nutritional report evaluating your eating pattern and nutrient intake with an overall diet score. The investigator(s), however, may learn more about relevant topics, such as gut-related health conditions.
</p>
<p class="consent_header">
What risks and confidentiality are associated with this study?
</p>
<p class="consent_content">
Participation in this study may involve some added minimal risks or discomforts. While answering surveys, you may feel frustration, emotional discomfort, fatigue, and/or boredom. There is also a risk of loss of confidentiality, but we take every precaution to protect your identity and minimize the risks. All data you provide is stored on secure systems within UC San Diego''s infrastructure and directly identifying information is accessible only to critical research personnel. The database that stores participant personal and sample information runs on a password-protected server that is accessible only to relevant staff such as Dr. Knight, Co-Investigators, project and sample coordinators, IT administrator and the database coders. The professionally maintained database server has several layers of security: it is password protected, firewalled, only allows network connectivity from defined UC San Diego managed systems, employs access control lists, and is physically housed in a key card controlled UC San Diego facility. Nightly backups of the database are taken and maintained on a separate co-located system with additional security measures in place. Research records will be kept confidential to the extent allowed by law and may be reviewed by the UC San Diego Institutional Review Board.
</p>
<p class="consent_content">
We may need to report information about known or reasonably suspected incidents of abuse or neglect of a child, dependent adult or elder including physical, sexual, emotional, and financial abuse or neglect. If any investigator has or is given such information, they may report such information to the appropriate authorities.
</p>
<p class="consent_content">
Federal and State laws generally make it illegal for health insurance companies, group health plans, and most employers to discriminate against you based on your genetic information. This law generally will protect you in the following ways: a) Health insurance companies and group health plans may not request your genetic information that we get from this research. b) Health insurance companies and group health plans may not use your genetic information when making decisions regarding your eligibility or premiums. c) Employers with 5 or more employees may not use your genetic information that we get from this research when making a decision to hire, promote, or fire you or when setting the terms of your employment.
</p>
<p class="consent_content">
Be aware that these laws do not protect you against genetic discrimination by companies that sell life insurance, disability insurance, or long-term care insurance.
</p>
<p class="consent_header">
What are the alternatives to participating in this study and can you withdraw?
</p>
<p class="consent_content">
Your participation in this study is completely voluntary and you are free to skip any question that you choose. We will inform you if any important new information is found during the course of this study that may affect your wanting to continue.
</p>
<p class="consent_content">
You can withdraw at any time by deleting your online profile, or by requesting the deletion of your account. Our researchers will still use the data about you that was collected before you withdrew. These data will not include any personal information that could directly identify you. After you withdraw, no further data will be collected from you.
</p>
<p class="consent_content">
You may be withdrawn from the study if you do not follow the instructions given to you by the study personnel.
</p>
<p class="consent_header">
Will you be compensated for participating in this study?
</p>
<p class="consent_content">
You will not be financially compensated in this study.
</p>
<p class="consent_header">
Are there any costs associated with participating in this study?
</p>
<p class="consent_content">
There will be no cost to you for completing the standard survey/questionnaire(s). However, there may be costs associated with having certain diet assessment tools made available to you, such as the Food Frequency Questionnaire (FFQ).
</p>
<p class="consent_header">
Know what we will collect
</p>
<p class="consent_content">
As part of this research study, we will create and obtain information related to you and your participation in the study from you or from collaborators so we can properly conduct this research. Research study data will include contact information, demographic information, personal experiences, lifestyle preferences, health information, date of birth, opinions or beliefs.
</p>
<p class="consent_header">
How we will use your Personal Data
</p>
<p class="consent_content">
The Personal Data you provide will be used for the following purposes:<br />
<ul>
<li>To share with members of the research team so they can properly conduct the research.</li>
<li>For future research studies or additional research by other researchers.</li>
<li>To contact you for the purpose of receiving alerts of your participation status, general program updates, opportunities to take part in new or future research, and/or as a follow-up to questions you have responded to in the questionnaire(s).</li>
<li>To comply with legal and regulatory requirements, including requirements to share data with regulatory agencies overseeing the research.</li>
<li>To confirm proper conduct of the study and research integrity.</li>
</ul>
</p>
<p class="consent_header">
Retention of your Personal Data
</p>
<p class="consent_content">
We may retain your Personal Data for as long as necessary to fulfill the objectives of the research and to ensure the integrity of the research. We will delete your Personal Data when it is no longer needed for the study or if you withdraw your consent provided such deletion does not render impossible or seriously impair the achievement of the objectives of the research project. However, your information will be retained as necessary to comply with legal or regulatory requirements.
</p>
<p class="consent_header">
Your Privacy Rights
</p>
<p class="consent_content">
The General Data Protection Regulation ("GDPR") requires researchers to provide information to you when we collect and use research data if you are located within the European Union (EU) or the European Economic Area (EEA). The GDPR gives you rights relating to your Personal Data, including the right to access, correct, restrict, and withdraw your personal information.
</p>
<p class="consent_content">
The research team will store and process your Personal Data at our research site in the United States. The United States does not have the same laws to protect your Personal Data as countries in the EU/EEA. However, the research team is committed to protecting the confidentiality of your Personal Data. Additional information about the protections we will use is included in this consent document and in our Privacy Statement.
</p>
<p class="consent_header">
Who can you call if you have questions?
</p>
<p class="consent_content">
If you have questions or research-related problems, you may reach Rob Knight at 858-246-1184 or email our help account: microsetta@ucsd.edu.
</p>
<p class="consent_content">
You may contact UC San Diego Office of IRB Administration at 858-246-4777 or email at irb@ucsd.edu to inquire about your rights as a research subject or to report research-related problems.
</p>
<p class="consent_content">
If you have questions or complaints about our treatment of your Personal Data, or about our privacy practices more generally, please feel free to contact the UC San Diego Privacy Official by email at ucsdprivacy@ucsd.edu.
</p>
<p class="consent_header">
Your Signature and Consent
</p>
<p class="consent_content">
You may download a copy of this consent document and a copy of the "<a href="https://oag.ca.gov/sites/all/files/agweb/pdfs/research/bill_of_rights.pdf" target="_blank">Experimental Subject''s Bill of Rights</a>" to keep.
</p>
<p class="consent_content">
Your consent is entirely voluntary, but declining to provide it may impede your ability to participate in this research.
</p>' WHERE locale = 'en_US' AND consent_type = 'adult_data';
UPDATE ag.consent_documents SET date_time = NOW(), consent_content = '<p class="consent_title">
<strong>University of California San Diego</strong><br />
Assent to Act as a Research Subject<br />
(Ages 7-12 years)
</p>
<p class="consent_title">
<strong>The Microsetta Initiative (a study about microbes)</strong>
</p>
<p class="consent_content">
Dr. Rob Knight and his research team are doing a research study to find out more about the trillions of tiny living things like bacteria and viruses that live in you or on you. These tiny things are called microbes, and you are being asked if you want to be in this study because the kinds of microbes you have is unique - not the same as anyone else on earth. We may be able to tell if you have been infected with something but we can''t tell you that because we are not allowed to do that.
</p>
<p class="consent_content">
If you decide you want to be in this research study, this is what will happen to you:<br />
We will ask you or your mom or dad to sample some place on your body (like skin or mouth) or your poop (from toilet paper) with something that looks like 2 Q-tips. Sometimes we need more poop for our research and then we will ask you to poop into a plastic bowl that is under the seat of the toilet and catches the poop as it comes out. Your mom or dad will send it to us in the bowl. We may also ask your mom or dad to prick your finger so that we can get a little bit of your blood.
</p>
<p class="consent_content">
Sometimes kids don''t feel good while being in this study. You might feel a little bit sore if your skin is rubbed with the Q-tip and temporary pain if they prick your finger to get blood. Most people don''t mind these feelings.
</p>
<p class="consent_content">
If you feel any of these things, or other things, be sure to tell your mom or dad.
</p>
<p class="consent_content">
You don''t have to be in this research study if you don''t want to. Nobody will be mad at you if you say no. Even if you say yes now and change your mind after you start doing this study, you can stop and no one will be mad.
</p>
<p class="consent_content">
Be sure to ask your parents if you have questions. You can also ask them to call Dr. Knight or his research team so they can tell you more about anything you don''t understand.
</p>' WHERE locale = 'en_US' AND consent_type = 'child_biospecimen';
UPDATE ag.consent_documents SET date_time = NOW(), consent_content = '<p class="consent_title">
<strong>University of California San Diego</strong><br />
Assent to Act as a Research Subject<br />
(Ages 7-12 years)
</p>
<p class="consent_title">
<strong>The Microsetta Initiative (a study about microbes)</strong>
</p>
<p class="consent_content">
Dr. Rob Knight and his research team are doing a research study to find out more about the trillions of tiny living things like bacteria and viruses that live in you or on you. These tiny things are called microbes, and you are being asked if you want to be in this study because the kinds of microbes you have is unique - not the same as anyone else on earth. We may be able to tell if you have been infected with something but we can''t tell you that because we are not allowed to do that.
</p>
<p class="consent_content">
If you decide you want to be in this research study, this is what will happen to you:<br />
We will ask you to answer survey questions about you, like your age, weight, height, your lifestyle, what you eat, if you have taken antibiotics, if you have certain diseases and if you take supplements like vitamins. There are also other surveys that you can choose to complete if you want to.
</p>
<p class="consent_content">
Your answers will be kept private. We will not share any information about whether or not you took part in this study.
</p>
<p class="consent_content">
Sometimes kids don''t feel good while being in this study. You might feel a little tired, bored, or uncomfortable. Most people don''t mind these feelings.
</p>
<p class="consent_content">
If you feel any of these things, or other things, be sure to tell your mom or dad.
</p>
<p class="consent_content">
You don''t have to be in this research study if you don''t want to. Nobody will be mad at you if you say no. Even if you say yes now and change your mind after you start doing this study, you can stop and no one will be mad.
</p>
<p class="consent_content">
Be sure to ask your parents if you have questions. You can also ask them to call Dr. Knight or his research team so they can tell you more about anything you don''t understand.
</p>' WHERE locale = 'en_US' AND consent_type = 'child_data';
UPDATE ag.consent_documents SET date_time = NOW(), consent_content = '<p class="consent_title">
<strong>University of California San Diego</strong><br />
Parent Consent for Child to Act as a Research Subject
</p>
<p class="consent_title">
<strong>The Microsetta Initiative</strong><br />
Biospecimen and Future Use Research
</p>
<p class="consent_header">
Who is conducting the study, why has your child been asked to participate, how was your child selected, and what is the approximate number of participants in the study?
</p>
<p class="consent_content">
Dr. Rob Knight is conducting a research study to find out more about the trillions of bacteria and other microorganisms (called the microbiome) that live in and on the body. This includes eukaryotes like fungi and parasites, prokaryotes like bacteria and archaea, and viruses. You are volunteering your child for this study because you want to know more about the microbiome of your child. Children like all humans have a unique microbiome and including them in the study will help elucidate the development of the microbiome. There will be approximately 500,000 participants in the study from across the USA and from other countries around the world.
</p>
<p class="consent_header">
Why is this study being done?
</p>
<p class="consent_content">
The purpose of this study is to assess more accurately the microbial differences between people and whether these differences can be attributed to factors such as lifestyle, diet, body type, age or the presence of associated diseases. Biospecimens are samples from your body such as stool, skin, urine, or blood which are used for research purposes. This study involves the collection, storage, and use of your child''s information and biospecimens for the purpose of processing your child''s biospecimens and for future research. The results will be used to create a database of DNA sequence and other data from various body sites, as well as details about the child participant supplying the sample. Researchers can then use that data while studying relevant topics, such as gut-related health conditions.
</p>
<p class="consent_header">
What will happen to your child in this study?
</p>
<p class="consent_content">
If you agree to the collection and processing of your child''s biospecimen(s), the following will happen to your child:
</p>
<p class="consent_content">
You have received or will receive a sample kit. The kit contains devices used to collect samples and instructions for use. The collection device may also include 95% ethanol to preserve the sample and make it non-infectious.
</p>
<p class="consent_content">
You will sample a part of your child''s body (e.g. feces, skin, mouth, nostril, ear, vagina) as described in the kit instructions. You will also be asked to provide general collection information such as the date and time your child''s sample was collected. All samples should be returned to us in the included containers according to the instructions provided.
</p>
<p class="consent_content">
If collecting from your child''s stool, you will be asked to sample in one of a variety of ways, such as the following:<br />
<ol>
<li>By inserting swab tips into used toilet tissue or diaper and returning the sample in the provided plastic container;</li>
<li>By inserting swab tips into used toilet tissue and applying the tips to the surface of a Fecal Occult Blood Test (FOBT) card, then returning the card to us. The FOBT card is the same device used by your doctor to check for blood in your stool. The FOBT card stabilizes the stool material for later analysis. We will not check if there is blood in the stool for diagnostic purposes because we are not a clinical laboratory;</li>
<li>By using a scooper device to scoop a part of the fecal material into the provided tube;</li>
<li>Depositing soiled toilet paper into the provided receptacle;</li>
<li>Submitting a whole stool sample in a shipping container we will provide. This container will have ice packs that reliably cool the sample to -20 degrees Celcius/-4 degrees Fahrenheit.</li>
</ol>
</p>
<p class="consent_content">
If you received a blood collection kit, it contains materials and instructions on how to collect a blood sample at home. It is similar to the test used to test glucose levels by pricking your child''s finger.
</p>
<p class="consent_content">
Once your child''s sample has been analyzed, we will upload results to your account and send you an email with a link to log in and view them. We estimate that it can take 1-3 months for you to learn the results of your child''s microbiome analysis. If your child is a part of a specific sub-study, it may take longer, depending on the duration of the study.
</p>
<p class="consent_header">
How much time will each study procedure take, what is your child''s total time commitment, and how long will the study last?
</p>
<p class="consent_content">
Each sample you send can be obtained in 5 minutes or less. We expect the study to continue for many years but the results will be available to you before the end of the study.
</p>
<p class="consent_header">
What risks are associated with this study?
</p>
<p class="consent_content">
Participation in this study may involve some added risks or discomforts. These include the following:<br />
<ol>
<li>If using the blood collection device, your child may experience temporary pain or a bruise at the site of the needle-stick.</li>
<li>There is a risk of loss of confidentiality.</li>
</ol>
</p>
<p class="consent_content">
Because this is a research study, there may be some unknown risks that are currently unforeseeable. You will be informed of any significant new findings.
</p>
<p class="consent_header">
What are the alternatives to participating in this study? Can your child withdraw or be withdrawn from the study?
</p>
<p class="consent_content">
Participation in research is entirely voluntary. We will inform you if any important new information is found during the course of this study that may affect your child wanting to continue.
</p>
<p class="consent_content">