-
Notifications
You must be signed in to change notification settings - Fork 19
/
0114.sql
456 lines (443 loc) · 33.8 KB
/
0114.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
-- Add sleep-related questions to the end of the General Lifestyle and Hygiene Information section
-- Create the questions
INSERT INTO ag.survey_question (survey_question_id, american, question_shortname, retired, spanish, spain_spanish, japanese)
VALUES
(344, 'On days you have school or work, what time do you get up in the morning?', 'WEEKDAY_WAKE_TIME', FALSE, 'En los días que tiene escuela o trabajo, ¿a qué hora se levanta por la mañana?', 'En los días que tiene escuela o trabajo, ¿a qué hora se levanta por la mañana?', '学校や仕事がある日は、朝何時に起きますか?'),
(345, 'On nights before you have school or work, what time do you go to bed?', 'WEEKDAY_SLEEP_TIME', FALSE, 'En las noches antes de ir a la escuela o al trabajo, ¿a qué hora se acuesta?', 'En las noches antes de ir a la escuela o al trabajo, ¿a qué hora se acuesta?', '学校や仕事がある前の夜は、何時に寝ますか?'),
(346, 'On your off days (days when you do not have school or work), what time do you get up in the morning?', 'WEEKEND_WAKE_TIME', FALSE, 'En sus días libres (cuando no tiene escuela ni trabajo), ¿a qué hora se levanta por la mañana?', 'En sus días libres (cuando no tiene escuela ni trabajo), ¿a qué hora se levanta por la mañana?', '休みの日(学校や仕事がない日)は、朝何時に起きますか?'),
(347, 'On nights before your off days (days when you do not have school or work), what time do you go to bed?', 'WEEKEND_SLEEP_TIME', FALSE, 'En sus días libres (cuando no tiene escuela ni trabajo), ¿a qué hora se acuesta?', 'En sus días libres (cuando no tiene escuela ni trabajo), ¿a qué hora se acuesta?', '休みの日(学校や仕事がない日)の前の夜は、何時に寝ますか?'),
(348, 'Do you have a job or some other situation that requires you to work and sleep during atypical hours (e.g. work between 10pm-6am and sleep between 9am-5pm)?', 'ATYPICAL_SLEEP_TIME', FALSE, '¿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)?', '¿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)?', '不規則な時間帯に仕事や睡眠を必要とする仕事やその他の状況がありますか(午後10時~午前6時に仕事して、午前9時~午後5時に睡眠をとるなど)?'),
(349, 'If you use light emitting electronic devices such as a phone or laptop right before bed, do you use it in night or dark mode?', 'DARK_MODE_ON', FALSE, '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?', '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?', '電話やノートパソコンなどの発光電子機器を寝る直前に使用する場合、ナイトモードまたはダークモードで使用していますか?'),
(350, 'Over the past week, how would you rate your sleep quality?', 'SLEEP_QUALITY', FALSE, 'Durante la última semana, ¿cómo calificaría la calidad de su sueño?', 'Durante la última semana, ¿cómo calificaría la calidad de su sueño?', '過去1週間の睡眠の質はどんなでしたか?');
-- Set the question types
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type)
VALUES
(344, 'SINGLE'),
(345, 'SINGLE'),
(346, 'SINGLE'),
(347, 'SINGLE'),
(348, 'SINGLE'),
(349, 'SINGLE'),
(350, 'SINGLE');
-- Associate them with the group
INSERT INTO ag.group_questions (survey_group, survey_question_id, display_index)
VALUES
(2, 344, 13),
(2, 345, 14),
(2, 346, 15),
(2, 347, 16),
(2, 348, 17),
(2, 349, 18),
(2, 350, 19);
-- Create the responses we'll need for the questions
INSERT INTO ag.survey_response (american, spanish, spain_spanish, japanese)
VALUES
('10:00AM', '10:00AM', '10:00AM', '10:00午前'),
('10:00PM', '10:00PM', '10:00PM', '10:00午後'),
('10:30AM', '10:30AM', '10:30AM', '10:30午前'),
('10:30PM', '10:30PM', '10:30PM', '10:30午後'),
('11:00AM', '11:00AM', '11:00AM', '11:00午前'),
('11:00PM', '11:00PM', '11:00PM', '11:00午後'),
('11:30AM', '11:30AM', '11:30AM', '11:30午前'),
('11:30PM', '11:30PM', '11:30PM', '11:30午後'),
('12:00AM', '12:00AM', '12:00AM', '12:00午前'),
('12:00PM', '12:00PM', '12:00PM', '12:00午後'),
('12:30AM', '12:30AM', '12:30AM', '12:30午前'),
('12:30PM', '12:30PM', '12:30PM', '12:30午後'),
('1:00AM', '1:00AM', '1:00AM', '1:00午前'),
('1:00PM', '1:00PM', '1:00PM', '1:00午後'),
('1:30AM', '1:30AM', '1:30AM', '1:30午前'),
('1:30PM', '1:30PM', '1:30PM', '1:30午後'),
('2:00AM', '2:00AM', '2:00AM', '2:00午前'),
('2:00PM', '2:00PM', '2:00PM', '2:00午後'),
('2:30AM', '2:30AM', '2:30AM', '2:30午前'),
('2:30PM', '2:30PM', '2:30PM', '2:30午後'),
('3:00AM', '3:00AM', '3:00AM', '3:00午前'),
('3:00PM', '3:00PM', '3:00PM', '3:00午後'),
('3:30AM', '3:30AM', '3:30AM', '3:30午前'),
('3:30PM', '3:30PM', '3:30PM', '3:30午後'),
('4:00AM', '4:00AM', '4:00AM', '4:00午前'),
('4:00PM', '4:00PM', '4:00PM', '4:00午後'),
('4:30AM', '4:30AM', '4:30AM', '4:30午前'),
('4:30PM', '4:30PM', '4:30PM', '4:30午後'),
('5:00AM', '5:00AM', '5:00AM', '5:00午前'),
('5:00PM', '5:00PM', '5:00PM', '5:00午後'),
('5:30AM', '5:30AM', '5:30AM', '5:30午前'),
('5:30PM', '5:30PM', '5:30PM', '5:30午後'),
('6:00AM', '6:00AM', '6:00AM', '6:00午前'),
('6:00PM', '6:00PM', '6:00PM', '6:00午後'),
('6:30AM', '6:30AM', '6:30AM', '6:30午前'),
('6:30PM', '6:30PM', '6:30PM', '6:30午後'),
('7:00AM', '7:00AM', '7:00AM', '7:00午前'),
('7:00PM', '7:00PM', '7:00PM', '7:00午後'),
('7:30AM', '7:30AM', '7:30AM', '7:30午前'),
('7:30PM', '7:30PM', '7:30PM', '7:30午後'),
('8:00AM', '8:00AM', '8:00AM', '8:00午前'),
('8:00PM', '8:00PM', '8:00PM', '8:00午後'),
('8:30AM', '8:30AM', '8:30AM', '8:30午前'),
('8:30PM', '8:30PM', '8:30PM', '8:30午後'),
('9:00AM', '9:00AM', '9:00AM', '9:00午前'),
('9:00PM', '9:00PM', '9:00PM', '9:00午後'),
('9:30AM', '9:30AM', '9:30AM', '9:30午前'),
('9:30PM', '9:30PM', '9:30PM', '9:30午後'),
('I do not use these devices before bed', 'No uso estos dispositivos antes de acostarme.', 'No uso estos dispositivos antes de acostarme.', '寝る直前にこれらの機器は使用していません。');
-- Associate responses with questions
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index)
VALUES
(344, 'Unspecified', 0),
(344, '12:00AM', 1),
(344, '12:30AM', 2),
(344, '1:00AM', 3),
(344, '1:30AM', 4),
(344, '2:00AM', 5),
(344, '2:30AM', 6),
(344, '3:00AM', 7),
(344, '3:30AM', 8),
(344, '4:00AM', 9),
(344, '4:30AM', 10),
(344, '5:00AM', 11),
(344, '5:30AM', 12),
(344, '6:00AM', 13),
(344, '6:30AM', 14),
(344, '7:00AM', 15),
(344, '7:30AM', 16),
(344, '8:00AM', 17),
(344, '8:30AM', 18),
(344, '9:00AM', 19),
(344, '9:30AM', 20),
(344, '10:00AM', 21),
(344, '10:30AM', 22),
(344, '11:00AM', 23),
(344, '11:30AM', 24),
(344, '12:00PM', 25),
(344, '12:30PM', 26),
(344, '1:00PM', 27),
(344, '1:30PM', 28),
(344, '2:00PM', 29),
(344, '2:30PM', 30),
(344, '3:00PM', 31),
(344, '3:30PM', 32),
(344, '4:00PM', 33),
(344, '4:30PM', 34),
(344, '5:00PM', 35),
(344, '5:30PM', 36),
(344, '6:00PM', 37),
(344, '6:30PM', 38),
(344, '7:00PM', 39),
(344, '7:30PM', 40),
(344, '8:00PM', 41),
(344, '8:30PM', 42),
(344, '9:00PM', 43),
(344, '9:30PM', 44),
(344, '10:00PM', 45),
(344, '10:30PM', 46),
(344, '11:00PM', 47),
(344, '11:30PM', 48),
(345, 'Unspecified', 0),
(345, '12:00AM', 1),
(345, '12:30AM', 2),
(345, '1:00AM', 3),
(345, '1:30AM', 4),
(345, '2:00AM', 5),
(345, '2:30AM', 6),
(345, '3:00AM', 7),
(345, '3:30AM', 8),
(345, '4:00AM', 9),
(345, '4:30AM', 10),
(345, '5:00AM', 11),
(345, '5:30AM', 12),
(345, '6:00AM', 13),
(345, '6:30AM', 14),
(345, '7:00AM', 15),
(345, '7:30AM', 16),
(345, '8:00AM', 17),
(345, '8:30AM', 18),
(345, '9:00AM', 19),
(345, '9:30AM', 20),
(345, '10:00AM', 21),
(345, '10:30AM', 22),
(345, '11:00AM', 23),
(345, '11:30AM', 24),
(345, '12:00PM', 25),
(345, '12:30PM', 26),
(345, '1:00PM', 27),
(345, '1:30PM', 28),
(345, '2:00PM', 29),
(345, '2:30PM', 30),
(345, '3:00PM', 31),
(345, '3:30PM', 32),
(345, '4:00PM', 33),
(345, '4:30PM', 34),
(345, '5:00PM', 35),
(345, '5:30PM', 36),
(345, '6:00PM', 37),
(345, '6:30PM', 38),
(345, '7:00PM', 39),
(345, '7:30PM', 40),
(345, '8:00PM', 41),
(345, '8:30PM', 42),
(345, '9:00PM', 43),
(345, '9:30PM', 44),
(345, '10:00PM', 45),
(345, '10:30PM', 46),
(345, '11:00PM', 47),
(345, '11:30PM', 48),
(346, 'Unspecified', 0),
(346, '12:00AM', 1),
(346, '12:30AM', 2),
(346, '1:00AM', 3),
(346, '1:30AM', 4),
(346, '2:00AM', 5),
(346, '2:30AM', 6),
(346, '3:00AM', 7),
(346, '3:30AM', 8),
(346, '4:00AM', 9),
(346, '4:30AM', 10),
(346, '5:00AM', 11),
(346, '5:30AM', 12),
(346, '6:00AM', 13),
(346, '6:30AM', 14),
(346, '7:00AM', 15),
(346, '7:30AM', 16),
(346, '8:00AM', 17),
(346, '8:30AM', 18),
(346, '9:00AM', 19),
(346, '9:30AM', 20),
(346, '10:00AM', 21),
(346, '10:30AM', 22),
(346, '11:00AM', 23),
(346, '11:30AM', 24),
(346, '12:00PM', 25),
(346, '12:30PM', 26),
(346, '1:00PM', 27),
(346, '1:30PM', 28),
(346, '2:00PM', 29),
(346, '2:30PM', 30),
(346, '3:00PM', 31),
(346, '3:30PM', 32),
(346, '4:00PM', 33),
(346, '4:30PM', 34),
(346, '5:00PM', 35),
(346, '5:30PM', 36),
(346, '6:00PM', 37),
(346, '6:30PM', 38),
(346, '7:00PM', 39),
(346, '7:30PM', 40),
(346, '8:00PM', 41),
(346, '8:30PM', 42),
(346, '9:00PM', 43),
(346, '9:30PM', 44),
(346, '10:00PM', 45),
(346, '10:30PM', 46),
(346, '11:00PM', 47),
(346, '11:30PM', 48),
(347, 'Unspecified', 0),
(347, '12:00AM', 1),
(347, '12:30AM', 2),
(347, '1:00AM', 3),
(347, '1:30AM', 4),
(347, '2:00AM', 5),
(347, '2:30AM', 6),
(347, '3:00AM', 7),
(347, '3:30AM', 8),
(347, '4:00AM', 9),
(347, '4:30AM', 10),
(347, '5:00AM', 11),
(347, '5:30AM', 12),
(347, '6:00AM', 13),
(347, '6:30AM', 14),
(347, '7:00AM', 15),
(347, '7:30AM', 16),
(347, '8:00AM', 17),
(347, '8:30AM', 18),
(347, '9:00AM', 19),
(347, '9:30AM', 20),
(347, '10:00AM', 21),
(347, '10:30AM', 22),
(347, '11:00AM', 23),
(347, '11:30AM', 24),
(347, '12:00PM', 25),
(347, '12:30PM', 26),
(347, '1:00PM', 27),
(347, '1:30PM', 28),
(347, '2:00PM', 29),
(347, '2:30PM', 30),
(347, '3:00PM', 31),
(347, '3:30PM', 32),
(347, '4:00PM', 33),
(347, '4:30PM', 34),
(347, '5:00PM', 35),
(347, '5:30PM', 36),
(347, '6:00PM', 37),
(347, '6:30PM', 38),
(347, '7:00PM', 39),
(347, '7:30PM', 40),
(347, '8:00PM', 41),
(347, '8:30PM', 42),
(347, '9:00PM', 43),
(347, '9:30PM', 44),
(347, '10:00PM', 45),
(347, '10:30PM', 46),
(347, '11:00PM', 47),
(347, '11:30PM', 48),
(348, 'Unspecified', 0),
(348, 'Yes', 1),
(348, 'No', 2),
(349, 'Unspecified', 0),
(349, 'Yes', 1),
(349, 'No', 2),
(349, 'I do not use these devices before bed', 3),
(350, 'Unspecified', 0),
(350, 'Very poor', 1),
(350, 'Poor', 2),
(350, 'Fair', 3),
(350, 'Good', 4),
(350, 'Very good', 5);
-- Add artificial sweetener questions to Detailed Dietary Information section
-- Create the questions
INSERT INTO ag.survey_question (survey_question_id, american, question_shortname, retired, spanish, spain_spanish, japanese)
VALUES
(463, 'How often do you consume foods containing non-nutritive or low-calorie sweeteners?', 'ARTIFICIAL_SWEETENERS_FOOD', FALSE, '¿Con qué frecuencia consume alimentos que contienen edulcorantes no nutritivos o bajos en calorías?', '¿Con qué frecuencia consume alimentos que contienen edulcorantes no nutritivos o bajos en calorías?', 'ノンカロリーまたは低カロリーの甘味料を含む食品はどれくらい摂取していますか?'),
(465, 'When you consume foods or beverages containing non-nutritive or low-calorie sweeteners, do you tend to experience gastrointestinal disorders afterwards, such as gas, bloating, and/or diarrhea?', 'ARTIFICIAL_GI_DISORDERS', FALSE, '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?', '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?', 'ノンカロリーまたは低カロリーの甘味料を含む食品や飲料を摂取した場合、その後、ガス、膨張、下痢などの消化器の不具合が起きることがよくありますか?'),
(466, 'If you answered "yes", to the previous question, what are the symptoms? Select all that apply.', 'ARTIFICIAL_GI_DISORDER_TYPES', FALSE, 'Si respondió "sí" a la pregunta anterior, ¿cuáles son los síntomas? Seleccione todas las que correspondan.', 'Si respondió "sí" a la pregunta anterior, ¿cuáles son los síntomas? Seleccione todas las que correspondan.', '前の質問への回答が「はい」の場合、症状は何ですか?該当するものをすべて選択してください。');
-- Set the question types
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type)
VALUES
(463, 'SINGLE'),
(465, 'SINGLE'),
(466, 'MULTIPLE');
-- Associate them with the group. We need to make space for them, so we'll re-index a few existing questions first.
UPDATE ag.group_questions SET display_index = 28 WHERE survey_group = 4 AND display_index = 25;
UPDATE ag.group_questions SET display_index = 27 WHERE survey_group = 4 AND display_index = 24;
UPDATE ag.group_questions SET display_index = 26 WHERE survey_group = 4 AND display_index = 23;
INSERT INTO ag.group_questions (survey_group, survey_question_id, display_index)
VALUES
(4, 463, 23),
(4, 465, 24),
(4, 466, 25);
-- Create the responses we'll need for the questions
INSERT INTO ag.survey_response (american, spanish, spain_spanish, japanese)
VALUES
('Stomachache', 'Dolor de estómago', 'Dolor de estómago', '腹痛'),
('Soft stools', 'Heces blandas', 'Heces blandas', '軟便'),
('Constipation', 'Estriñimiento', 'Estriñimiento', '便秘');
-- Associate responses with questions
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index)
VALUES
(463, 'Unspecified', 0),
(463, 'Never', 1),
(463, 'Rarely (a few times/month)', 2),
(463, 'Occasionally (1-2 times/week)', 3),
(463, 'Regularly (3-5 times/week)', 4),
(463, 'Daily', 5),
(465, 'Unspecified', 0),
(465, 'Yes', 1),
(465, 'No', 2),
(466, 'Unspecified', 0),
(466, 'Stomachache', 1),
(466, 'Diarrhea', 2),
(466, 'Soft stools', 3),
(466, 'Constipation', 4),
(466, 'Other', 5);
-- Set up the triggers
INSERT INTO ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question)
VALUES
(157, 'Rarely (a few times/month)', 465),
(157, 'Occasionally (1-2 times/week)', 465),
(157, 'Regularly (3-5 times/week)', 465),
(157, 'Daily', 465),
(463, 'Rarely (a few times/month)', 465),
(463, 'Occasionally (1-2 times/week)', 465),
(463, 'Regularly (3-5 times/week)', 465),
(463, 'Daily', 465),
(465, 'Yes', 466);
-- Update translations for survey groups
UPDATE ag.survey_group SET japanese = '調理用油とシュウ酸が豊富な食品' WHERE group_order = -7; -- Cooing Oils & Oxalate-rich Foods
UPDATE ag.survey_group SET japanese = '新型コロナウイルス感染症調査票' WHERE group_order = -6; -- COVID-19
UPDATE ag.survey_group SET japanese = '発酵食品調査票' WHERE group_order = -3; -- Fermented Foods
UPDATE ag.survey_group SET japanese = 'Microsetta Initiative(マイクロセッタ・イニシアチブ)' WHERE group_order = -1; -- Microsetta Initative
UPDATE ag.survey_group SET japanese = '一般的な食事に関する情報' WHERE group_order = 0; -- General Diet
UPDATE ag.survey_group SET japanese = '一般情報' WHERE group_order = 1; -- General Information
UPDATE ag.survey_group SET japanese = '一般的な生活習慣と衛生に関する情報' WHERE group_order = 2; -- General Lifestyle and Hygiene Information
UPDATE ag.survey_group SET japanese = '一般的な健康情報' WHERE group_order = 3; -- General Health
UPDATE ag.survey_group SET japanese = '詳しい食事情報' WHERE group_order = 4; -- Detailed Diet
UPDATE ag.survey_group SET japanese = 'その他' WHERE group_order = 5; -- Anything else?
-- Update translations for survey questions
UPDATE ag.survey_question SET japanese = 'どれくらいの頻度でプロバイオティクスや乳酸菌を服用していますか?' WHERE american = 'How frequently do you take a probiotic?';
UPDATE ag.survey_question SET japanese = 'どれくらいの頻度でビタミンB複合体、葉酸塩または葉酸を服用していますか?' WHERE american = 'How frequently do you take Vitamin B complex, folate or folic acid?';
UPDATE ag.survey_question SET japanese = '抗生物質を投与した動物の肉や乳製品を食べますか?' WHERE american = 'Do you eat meat/dairy products from animals treated with antibiotics?';
UPDATE ag.survey_question SET japanese = '過去_以内に海外旅行をしたことがある。' WHERE american = 'I have traveled outside of my country of residence in the past _________.';
UPDATE ag.survey_question SET japanese = 'あなたの同居人でこの研究に参加している人はいますか?' WHERE american = 'Are any of your roommates participating in this study?';
UPDATE ag.survey_question SET japanese = 'スイミングプール/銭湯/スパはどれくらいの頻度で使用していますか?' WHERE american = 'How often do you use a swimming pool/hot tub?';
UPDATE ag.survey_question SET japanese = '私は過去___の間に抗生物質を服用しました。' WHERE american = 'I have taken antibiotics in the last ____________.';
UPDATE ag.survey_question SET japanese = '私は過去___の間にインフルエンザのワクチンを接種しました。' WHERE american = 'I have received a flu vaccine in the last ____________.';
UPDATE ag.survey_question SET japanese = '怖い夢や悪夢を見ることがありますか?' WHERE american = 'Do you have vivid and/or frightening dreams?';
UPDATE ag.survey_question SET japanese = '1週間のうち、1日に全粒粉を2食分以上を摂取する頻度はどのくらいですか? (1食分=100%全粒粉パン1枚、高繊維シリアル、オートミールなどの全粒シリアル1カップ、全粒クラッカー3~4枚、玄米や全粒パスタ1/2カップ)' WHERE american = 'In an average week, how often do you eat at least 2 servings of whole grains in a day?';
UPDATE ag.survey_question SET japanese = '1週間のうち、1日に2-3食分以上のでんぷん質野菜と非でんぷん質野菜を摂取する頻度はどのくらいですか?でんぷん質野菜の例としては、白イモ、トウモロコシ、エンドウ豆、キャベツなどが挙げられます。非でんぷん質野菜の例としては、生の葉野菜、キュウリ、トマト、ピーマン、ブロッコリー、ケールなどがあります。( 1食分=野菜/じゃがいも1/2カップ、生の葉野菜1カップ)' WHERE american = 'In an average week, how often do you consume at least 2-3 servings of starchy and non-starchy vegetables. Examples of starchy vegetables include white potatoes, corn, peas and cabbage. Examples of non-starchy vegetables include raw leafy greens, cucumbers, tomatoes, peppers, broccoli, and kale. (1 serving = ½ cup vegetables/potatoes; 1 cup leafy raw vegetables)';
UPDATE ag.survey_question SET japanese = '1 週間に何種類の植物(野菜、果物、穀物)を食べますか?例えばにんじん、じゃがいも、玉ねぎが入ったスープを消費した場合、 3 種類の野菜とみなします。多穀物パンを消費した場合、それぞれの穀物を数えてください。' WHERE american = 'In an average week, how many different plant species do you eat? e.g. If you consume a can of soup that contains carrots, potatoes, and onion, you can count this as 3 different plants; If you consume multi-grain bread, each different grain counts as a plant.';
UPDATE ag.survey_question SET japanese = '1週間のうち、1日に2食分以上の牛乳やチーズを摂取する頻度はどのくらいですか?( 1食分=牛乳またはヨーグルト1カップ、チーズ43〜57グラム))' WHERE american = 'In an average week, how often do you consume at least 2 servings of milk or cheese a day? (1 serving = 1 cup milk or yogurt; 1 1/2 - 2 ounces cheese)';
UPDATE ag.survey_question SET japanese = 'あなたの微生物に関連する食習慣や生活習慣があれば記入してください。' WHERE american = 'Please write anything else about yourself that you think could affect your personal microorganisms.';
UPDATE ag.survey_question SET japanese = '発酵食品を摂取する頻度または量は、過去____以内に2倍以上に増加しましたか?(ビール、ワイン、アルコールを除く)' WHERE american = 'Excluding beer, wine, and alcohol, I have significantly increased (i.e. more than doubled) my intake of fermented foods in frequency or quantity within the last ____.';
UPDATE ag.survey_question SET japanese = '発酵食品/飲料を自宅で個人消費用に製造していますか?該当するものをすべて選択してください。' WHERE american = 'Do you produce any of the following fermented foods/beverages at home for personal consumption? Check all that apply.';
UPDATE ag.survey_question SET japanese = 'その他この項に関する詳しい情報がありましたらご記入ください。ご協力ありがとうございます。' WHERE american = 'Volunteer more information about this activity.';
UPDATE ag.survey_question SET japanese = '1週間のうち、ラード、バター、ギーはどれくらいの頻度で使用・調理していますか?' WHERE american = 'In a given week, how often do you use or cook with lard, butter or ghee?';
UPDATE ag.survey_question SET japanese = '1週間のうち、ココナッツオイル、パームオイル、パームカーネルオイルをどれくらいの頻度で使用していますか?' WHERE american = 'In a given week, how often do you use or cook with coconut, palm or palm kernel oil?';
UPDATE ag.survey_question SET japanese = '1週間のうち、マーガリンや植物性ショートニングをどれくらいの頻度で使用していますか?' WHERE american = 'In a given week, how often do you use or cook with margarine or (vegetable) shortening?';
UPDATE ag.survey_question SET japanese = 'ほうれん草、ふだん草、ビーツまたはビーツの葉、オクラ、キノア、アマランス、蕎麦、小麦ふすままたは胚芽、ふすまシリアル、チアシード、ルバーブ、ダークチョコレートやココア粉末(> 70%)、又はナッツ(アーモンド、ピーナッツ、ピーカン、カシュー、ヘーゼルナッツ)などのシュウ酸塩が豊富な食品を平均してどれくらいの頻度で摂取していますか? ' WHERE american = 'On average, how often do you consume oxalate-rich foods, such as spinach, Swiss chard, beetroot or beet greens, okra, quinoa, amaranth, buckwheat, wheat bran or germ, Bran cereal, chia seeds, rhubarb, dark chocolate or cocoa powder (>70%), and nuts such as almonds, peanuts, pecans, cashews, and hazelnuts?';
UPDATE ag.survey_question SET japanese = 'あなたは毎日マルチビタミンサプリメントを服用していますか?' WHERE american = 'Are you taking a daily multivitamin?';
UPDATE ag.survey_question SET japanese = '現在の居住地にいつ越して来ましたか?' WHERE american = 'When did you move to current state of residence?';
UPDATE ag.survey_question SET japanese = '渡航先:' WHERE american = 'Travel:';
UPDATE ag.survey_question SET japanese = 'ペットの種類を記入してください。' WHERE american = 'Please list pets';
UPDATE ag.survey_question SET japanese = '歯磨きはどの程度しますか?' WHERE american = 'How often do you brush your teeth?';
UPDATE ag.survey_question SET japanese = '顔用化粧品はどの程度使用していますか?' WHERE american = 'How often do you wear facial cosmetics?';
UPDATE ag.survey_question SET japanese = '「アルミニウム入りの」デオドラントまたは制汗剤は使用していますか?' WHERE american = 'Do you use deodorant or antiperspirant (antiperspirants generally contain aluminum)?';
UPDATE ag.survey_question SET japanese = '出産予定日:' WHERE american = 'Pregnancy due date:';
UPDATE ag.survey_question SET japanese = '水ぼうそうにかかったことがありますか?' WHERE american = 'Have you had chickenpox?';
UPDATE ag.survey_question SET japanese = '今までに腸カンジダ症や腸内真菌異常増殖症(SIFO)と診断されたことはありますか?' WHERE american = 'Have you ever been diagnosed with Candida or fungal overgrowth in the gut?';
UPDATE ag.survey_question SET japanese = '今までに小腸内細菌異常増殖症と診断されたことがありますか?' WHERE american = 'Have you ever been diagnosed with small intestinal bacterial overgrowth (SIBO)?';
UPDATE ag.survey_question SET japanese = '胃酸逆流やGERD(胃食道逆流症)と診断されたことがありますか?' WHERE american = 'Have you ever been diagnosed with acid reflux or GERD (gastro-esophageal reflux disease)?';
UPDATE ag.survey_question SET japanese = 'あなたは1 日のカロリーの 75%以上を栄養剤(経腸栄養剤など)から摂取していますか?' WHERE american = 'Are you an infant who receives most of their nutrition from breast milk or formula, or an adult who receives most (more than 75% of daily calories) of their nutrition from adult nutritional shakes (i.e. Ensure)?';
UPDATE ag.survey_question SET japanese = '1週間のうち、1食分以上の発酵野菜または植物製品をどのくらいの頻度で摂取していますか?(1食分=ザワークラウト、キムチまたは発酵野菜1/2カップ、コンブチャ1カップ)' WHERE american = 'How often do you consume one or more servings of fermented vegetables in or plant products a day in an average week? (1 serving = 1/2 cup sauerkraut, kimchi or fermented vegetable or 1 cup of kombucha)';
UPDATE ag.survey_question SET japanese = '約450ミリリットル以上のダイエット用ではないソーダやフルーツドリンク/パンチ(100%果汁は含まない)等の清涼飲料水を1日にどのくらい摂取していますか?' WHERE american = 'Drink 16 ounces or more of a sugar sweetened beverage such as non-diet soda or fruit drink/punch (however, not including 100 % fruit juice) in a day? (1 can of soda = 12 ounces)';
UPDATE ag.survey_question SET japanese = '現在の幸福度についてお答えください。あなたの心身の健康や、直面している問題、人間関係、得られるチャンスの数や挑戦のための望ましい環境を得られているかを総合的に考えて、現在の幸福状態を言い表すと?' WHERE american = 'Please think about your current level of well-being. When you think about well-being, think about your physical health, your emotional health, any challenges you are experiencing, the people in your life, and the opportunities or resources you have available to you. How would you describe your current level of well-being?';
UPDATE ag.survey_question SET japanese = 'それはいつ頃ですか?' WHERE american = 'Please provide date';
UPDATE ag.survey_question SET japanese = '期間中、何らかの理由で外出した(例えば、出勤、店や公園などに行くために外出)回数は何回でしたか?' WHERE american = 'How many times have you gone outside of your home for any reason including work (e.g., left your property to go to stores, parks, etc.)?';
UPDATE ag.survey_question SET japanese = '相乗りタクシーを使用したことがありますか?' WHERE american = 'Have you used shared ride services including Lyft, Uber or alternative forms of taxi?';
UPDATE ag.survey_question SET japanese = '発酵食品/飲料のうち、週一回以上摂取しているものをすべて選択してください。記載がないものは「その他」を選択してください。' WHERE american = 'Which of the following fermented foods/beverages do you consume more than once a week? Check all that apply.';
UPDATE ag.survey_question SET japanese = '発酵食品/飲料を商用目的に製造していますか?該当するものをすべて選択してください。' WHERE american = 'Do you produce any of the following fermented foods/beverages for commercial purposes? Check all that apply.';
UPDATE ag.survey_question SET japanese = '1日に2~3食分以上の果物を摂取する頻度はどのくらいですか? (1食分 = 果物1/2カップ、中くらいの大きさの果物1個、100% フルーツ ジュース約 120 ミリリットル)。' WHERE american = 'In an average week, how often to you consume at least 2-3 servings of fruit in a day? (1 serving = 1/2 cup fruit; 1 medium sized fruit; 4 oz. 100% fruit juice.)';
-- Update translations for survey responses
UPDATE ag.survey_response SET japanese = '不明' WHERE american = 'Unspecified';
UPDATE ag.survey_response SET japanese = '肉と野菜両方食べる' WHERE american = 'Omnivore';
UPDATE ag.survey_response SET japanese = '肉と野菜両方食べるが、赤身肉は食べない' WHERE american = 'Omnivore but do not eat red meat';
UPDATE ag.survey_response SET japanese = 'ベジタリアン(菜食主義)' WHERE american = 'Vegetarian';
UPDATE ag.survey_response SET japanese = 'ビーガン(完全菜食主義)' WHERE american = 'Vegan';
UPDATE ag.survey_response SET japanese = 'ペットボトル・ミネラルウォーター' WHERE american = 'Bottled';
UPDATE ag.survey_response SET japanese = 'ろ過水' WHERE american = 'Filtered';
UPDATE ag.survey_response SET japanese = '分からない' WHERE american = 'Not sure';
UPDATE ag.survey_response SET japanese = '1年以上前から住んでいる' WHERE american = 'I have lived in my current state of residence for more than a year.';
UPDATE ag.survey_response SET japanese = '1回未満' WHERE american = 'Less than one';
UPDATE ag.survey_response SET japanese = '1回' WHERE american = 'One';
UPDATE ag.survey_response SET japanese = '2回' WHERE american = 'Two';
UPDATE ag.survey_response SET japanese = '3回' WHERE american = 'Three';
UPDATE ag.survey_response SET japanese = '4回' WHERE american = 'Four';
UPDATE ag.survey_response SET japanese = '5回以上' WHERE american = 'Five or more';
UPDATE ag.survey_response SET japanese = '分からない' WHERE american = 'I don''t know, I do not have a point of reference';
UPDATE ag.survey_response SET japanese = '医療従事者(医師、医師助手)に診断されたことがある' WHERE american = 'Diagnosed by a medical professional (doctor, physician assistant)';
UPDATE ag.survey_response SET japanese = '代替医療の医師に診断されたことがある' WHERE american = 'Diagnosed by an alternative medicine practitioner';
UPDATE ag.survey_response SET japanese = '自己診断したことがある' WHERE american = 'Self-diagnosed';
UPDATE ag.survey_response SET japanese = '固形食と粉ミルク/母乳の両方を食べている' WHERE american = 'I eat both solid food and formula/breast milk';
UPDATE ag.survey_response SET japanese = '水道水' WHERE american = 'City';
UPDATE ag.survey_response SET japanese = 'まれに (数回/月)' WHERE american = 'Rarely (a few times/month)';
UPDATE ag.survey_response SET japanese = '4.5キロ以上増加' WHERE american = 'Increased more than 10 pounds';
UPDATE ag.survey_response SET japanese = '4.5キロ以上減少' WHERE american = 'Decreased more than 10 pounds';
UPDATE ag.survey_response SET japanese = '主に粉ミルク' WHERE american = 'Primarily infant formula';
UPDATE ag.survey_response SET japanese = '母乳と粉ミルクの両方' WHERE american = 'A mixture of breast milk and formula';
UPDATE ag.survey_response SET japanese = 'ウルシ科の植物' WHERE american = 'Poison ivy/oak';
UPDATE ag.survey_response SET japanese = 'うつ病' WHERE american = 'Depression';
UPDATE ag.survey_response SET japanese = 'ほとんどない(1回/週未満)' WHERE american = 'Rarely (less than once/week)';
UPDATE ag.survey_response SET japanese = '5種以下' WHERE american = 'Less than 5';
UPDATE ag.survey_response SET japanese = '30種以上' WHERE american = 'More than 30';
UPDATE ag.survey_response SET japanese = 'はい、注射式の避妊薬を使用しています' WHERE american = 'Yes, I use an injected contraceptive (DMPA)';
UPDATE ag.survey_response SET japanese = 'はい、ホルモン性IUD/インプラント(ミレーナ)を使用しています' WHERE american = 'Yes, I use a hormonal IUD (Mirena)';
UPDATE ag.survey_response SET japanese = '全くない' WHERE american = 'None';