0120.sql

-- STEP 0: Add new desired constraints.
alter table ag.ag_login_surveys alter column creation_time set not null;


-- STEP 1: add survey_template_id to ag_login_surveys table and populate it.
alter table ag.ag_login_surveys add column survey_template_id integer;
-- create a table of survey_ids w/a single question_id associated w/that
-- survey and survey template.
create table ag.tmp_tbl1 as select a.survey_id, min(b.survey_question_id) from ag.ag_login_surveys a join ag.survey_answers b on a.survey_id = b.survey_id group by a.survey_id;

-- Add a UNIQUE constraint to the survey_id column, as we're about to add potential dupes and want to avoid that
ALTER TABLE ag.tmp_tbl1 ADD CONSTRAINT unique_sid UNIQUE(survey_id);
-- Retrieve free-text survey responses
INSERT INTO ag.tmp_tbl1 (survey_id, min) SELECT a.survey_id, MIN(b.survey_question_id) FROM ag.ag_login_surveys a JOIN ag.survey_answers_other b ON a.survey_id = b.survey_id GROUP BY a.survey_id ON CONFLICT (survey_id) DO NOTHING;

-- replace the question_ids in the table above w/the survey_group those
-- questions are associated with.
create table ag.tmp_tbl2 as select survey_id, survey_group from ag.tmp_tbl1 a join ag.group_questions b on a.min = b.survey_question_id;
-- replace the group_ids in the table above w/the template_ids those groups
-- are associated with.
create table ag.tmp_tbl3 as select a.survey_id, b.survey_id as survey_template_id from ag.tmp_tbl2 a join ag.surveys b on a.survey_group = b.survey_group;
-- use the mapping of survey_ids to survey_template_ids to populate the
-- new column of the existing table ag_login_surveys.
update ag.ag_login_surveys set survey_template_id = (select survey_template_id from ag.tmp_tbl3 where survey_id = ag_login_surveys.survey_id);
-- remove the temporary tables as they are no longer needed.
drop table ag.tmp_tbl1;
drop table ag.tmp_tbl2;
drop table ag.tmp_tbl3;
-- add survey_template_ids for remote surveys
update ag.ag_login_surveys set survey_template_id = 10001 where survey_id in (select vio_id from ag.vioscreen_registry);
update ag.ag_login_surveys set survey_template_id = 10002 where survey_id in (select myfoodrepo_id::text from ag.myfoodrepo_registry);
update ag.ag_login_surveys set survey_template_id = 10003 where survey_id in (select polyphenol_ffq_id::text from ag.polyphenol_ffq_registry);
update ag.ag_login_surveys set survey_template_id = 10004 where survey_id in (select spain_ffq_id::text from ag.spain_ffq_registry);

-- There are records with a non-null Vioscreen status that aren't in the vioscreen_registry table.
-- We can safely assume they're Vioscreen
UPDATE ag.ag_login_surveys SET survey_template_id = 10001 WHERE survey_template_id IS NULL and vioscreen_status IS NOT NULL;

-- The remaining null survey_template_id records are all associated with a sample, and can therefore be safely assumed to be the old primary survey
UPDATE ag.ag_login_surveys SET survey_template_id = 1 WHERE survey_template_id IS NULL;

-- survey_template_id should be filled for all rows. If not, there is an issue
-- and this update should stop. Every survey should be associated w/a
-- template_id.

alter table ag.ag_login_surveys alter column survey_template_id set not null;


-- STEP 2: add retired column to surveys table and retire existing survey
-- templates.
alter table ag.surveys add column retired boolean default false;
update ag.surveys set retired = true where survey_id < 10;


-- STEP 3: add the new list of categories to the set of groups.
-- These new groups will be 1:1 w/survey template_ids.
insert into ag.survey_group (group_order, american) values (-10, 'Basic Information');
insert into ag.survey_group (group_order, american) values (-11, 'At Home');
insert into ag.survey_group (group_order, american) values (-12, 'Lifestyle');
insert into ag.survey_group (group_order, american) values (-13, 'Gut');
insert into ag.survey_group (group_order, american) values (-14, 'General Health');
insert into ag.survey_group (group_order, american) values (-15, 'Health Diagnosis');
insert into ag.survey_group (group_order, american) values (-16, 'Allergies');
insert into ag.survey_group (group_order, american) values (-17, 'Diet');
insert into ag.survey_group (group_order, american) values (-18, 'Detailed Diet');
insert into ag.survey_group (group_order, american) values (-19, 'Migraine');
insert into ag.survey_group (group_order, american) values (-20, 'Surfers v2');
insert into ag.survey_group (group_order, american) values (-21, 'COVID-19');


-- STEP 4: once the categories have been added, they can be associated with
-- survey ids (survey_template_ids).
insert into ag.surveys (survey_id, survey_group) values(10, -10);
insert into ag.surveys (survey_id, survey_group) values(11, -11);
insert into ag.surveys (survey_id, survey_group) values(12, -12);
insert into ag.surveys (survey_id, survey_group) values(13, -13);
insert into ag.surveys (survey_id, survey_group) values(14, -14);
insert into ag.surveys (survey_id, survey_group) values(15, -15);
insert into ag.surveys (survey_id, survey_group) values(16, -16);
insert into ag.surveys (survey_id, survey_group) values(17, -17);
insert into ag.surveys (survey_id, survey_group) values(18, -18);
insert into ag.surveys (survey_id, survey_group) values(19, -19);
insert into ag.surveys (survey_id, survey_group) values(20, -20);
insert into ag.surveys (survey_id, survey_group) values(21, -21);


-- STEP 5: remove existing triggers from the database. Otherwise, we will need
-- a template_id column to record the trigger for when a question was a part
-- of a retired survey/question as well as a current survey/question.
delete from ag.survey_question_triggers;
-- delete from ag.group_questions;
--We're not going to delete existing entries from group_questions anymore.
--Instead we'll add new associations. I think that should be okay since queries on group_questions
--are by template_id, so it shouldn't mess up people's queries to have a question be in more than one template.
--(As long as its retired).
-- Just know that idx_human_survey_group_question_0 is on survey_question_id in the table so it's possible
-- someone is expecting or querying on that value.


-- STEP 6: Modify text in existing questions to new standard.
update ag.survey_question set american = 'How frequently do you take a Vitamin D supplement?' where survey_question_id = 5;
update ag.survey_question set american = 'What foods are you allergic to? Select all that apply.' where survey_question_id = 9;
update ag.survey_question set american = 'When did you move to your current location of residence (state)?' where survey_question_id = 15;
update ag.survey_question set american = 'I have traveled outside of the United States in the past _________.' where survey_question_id = 16;
update ag.survey_question set american = 'How many of the people you live with are not a part of your family?' where survey_question_id = 17;
update ag.survey_question set american = 'Are you related to any of the other participants in this study?' where survey_question_id = 19;
update ag.survey_question set american = 'How often do you wear facial cosmetics (includes the use of skin care products like sunscreen or moisturizer)?' where survey_question_id = 33;
update ag.survey_question set american = 'Approximately how many hours of sleep do you get in an average night?' where survey_question_id = 35;
update ag.survey_question set american = 'Describe the consistency of your bowel movements:' where survey_question_id = 38;
update ag.survey_question set american = 'Have you had your appendix removed?' where survey_question_id = 45;
update ag.survey_question set american = 'Have you had a chickenpox infection (not the varicella vaccine)?' where survey_question_id = 46;
update ag.survey_question set american = 'Do you use non-prescription products to control facial acne?' where survey_question_id = 48;
update ag.survey_question set american = 'Do you currently take non-prescription or prescription medication for other conditions?' where survey_question_id = 49;
update ag.survey_question set american = 'Were you born via cesarean section (C-section)?' where survey_question_id = 50;
update ag.survey_question set american = 'Do you have any of the following non-food allergies? Select all that apply.' where survey_question_id = 54;
update ag.survey_question set american = 'How often do you consume meat/eggs?' where survey_question_id = 56;
update ag.survey_question set american = 'How often do you cook and consume home cooked meals? (Exclude ready-to-eat meals like boxed macaroni and cheese, ramen noodles, lean cuisine)' where survey_question_id = 57;
update ag.survey_question set american = 'How often do you consume ready-to-eat meals (e.g. macaroni and cheese, ramen noodles, lean cuisine)?' where survey_question_id = 58;
update ag.survey_question set american = 'How often do you eat food prepared at a restaurant, including carry-out/take-out?' where survey_question_id = 59;
update ag.survey_question set american = 'How often do you consume at least 2-3 servings of fruit in a day? (1 serving = 1/2 cup (1 serving = 1/2 cup fruit juice.)' where survey_question_id = 61;
update ag.survey_question set american = '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 = 1/2 cup vegetables/potatoes; 1 cup leafy raw vegetables)' where survey_question_id = 62;
update ag.survey_question set american = 'How often do you consume at least 2 servings of milk or cheese a day? (1 serving = 1 cup milk or yogurt; 11/2 - 2 ounces cheese)' where survey_question_id = 64;
update ag.survey_question set american = 'How often do you consume milk substitutes (soy milk, lactose free milk, almond milk, etc.)?' where survey_question_id = 65;
update ag.survey_question set american = 'How often do you eat red meat?' where survey_question_id = 67;
update ag.survey_question set american = 'How often do you consume higher fat red meats like prime rib, T-bone steak, hamburger, ribs, bacon, etc.?' where survey_question_id = 68;
update ag.survey_question set american = 'How often do you consume chicken or turkey?' where survey_question_id = 69;
update ag.survey_question set american = 'How often do you consume seafood (fish, shrimp, lobster, crab, etc.)?' where survey_question_id = 70;
update ag.survey_question set american = 'How often do you consume salted snacks (potato chips, nacho chips, corn chips, popcorn with butter, French fries etc.)?' where survey_question_id = 71;
update ag.survey_question set american = 'How often do you consume sugary sweets (cake, cookies, pastries, donuts, muffins, chocolate etc.)' where survey_question_id = 72;
update ag.survey_question set american = 'How often do you cook with olive oil?' where survey_question_id = 73;
update ag.survey_question set american = 'How often do you consume whole eggs (does not include egg beaters or just egg whites).' where survey_question_id = 74;
update ag.survey_question set american = 'How often do you drink 16 ounces or more of sugar sweetened beverages such as non-diet soda or fruit drink/punch (not including 100 % fruit juice) in a day? (1 can of soda = 12 ounces)' where survey_question_id = 75;
update ag.survey_question set american = 'How often do you consume at least 1L (~32 ounces) of water in a day?' where survey_question_id = 76;
update ag.survey_question set american = 'Have you been diagnosed with Autism Spectrum Disorder or Condition (ASD/ASC)?' where survey_question_id = 77;
update ag.survey_question set american = 'Have you ever been diagnosed with irritable bowel syndrome (IBS)*?' where survey_question_id = 79;
update ag.survey_question set american = 'Have you been diagnosed with Alzheimer''s Disease/Dementia?' where survey_question_id = 84;
update ag.survey_question set american = 'Have you been diagnosed with ADD/ADHD?' where survey_question_id = 85;
update ag.survey_question set american = 'Have you been diagnosed with autoimmune disease such as Lupus (systemic lupus erythematosus), R.A. (rheumatoid arthritis), MS (multiple sclerosis), Hashimoto''s thyroiditis , or any other auto-immune disease?' where survey_question_id = 87;
update ag.survey_question set american = 'Have you ever been diagnosed with coronary artery disease, heart disease, heart attack, or stroke?' where survey_question_id = 89;
update ag.survey_question set american = 'How often do you eat at least 2 servings of whole grains in a day? (1 serving = 1 slice of 100% whole grain bread; 1 cup whole grain cereal like Shredded Wheat, Wheaties, Grape Nuts, high fiber cereals, or oatmeal; 3-4 whole grain crackers; 1/2 cup brown rice or whole wheat pasta)' where survey_question_id = 91;
update ag.survey_question set american = 'Have you been diagnosed with Asthma, Cystic fibrosis, COPD or other lung Disease?' where survey_question_id = 93;
update ag.survey_question set american = 'Have you ever been diagnosed with thyroid disease?' where survey_question_id = 96;
update ag.survey_question set american = 'Which medications are you taking?' where survey_question_id = 99;
update ag.survey_question set american = 'What types of supplements?' where survey_question_id = 104;
update ag.survey_question set american = 'What condition(s)?' where survey_question_id = 106;
update ag.survey_question set american = 'Birth month' where survey_question_id = 111;
update ag.survey_question set american = 'Birth year' where survey_question_id = 112;
update ag.survey_question set american = 'What type of antibiotic did you take?' where survey_question_id = 124;
update ag.survey_question set american = 'What was the antibiotic used to treat?' where survey_question_id = 126;
update ag.survey_question set american = 'In an average week, how many different plants do you eat? For example - 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. Include all fruits in the total.' where survey_question_id = 146;
update ag.survey_question set american = 'Do you have other (non-dog or cat) pets at home?' where survey_question_id = 149;
update ag.survey_question set american = 'What type(s) of pets?' where survey_question_id = 150;
update ag.survey_question set american = 'How often do you consume beverages with non-nutritive or low-calorie sweeteners*?' where survey_question_id = 157;
update ag.survey_question set american = 'If you eat a specialized diet, what type do you follow? Select all that apply.' where survey_question_id = 162;
update ag.survey_question set american = 'How many alcoholic beverages do you usually have per sitting?' where survey_question_id = 163;
update ag.survey_question set american = 'How often do you consume one or more servings of fermented vegetables or plant products? (1 serving = 1/2 cup sauerkraut, kimchi or fermented vegetable or 1 cup of kombucha)' where survey_question_id = 165;
update ag.survey_question set american = 'Which of the following fermented foods/beverages do you consume more than once a week? Select all that apply and write in any that are not listed under ''Other''.' where survey_question_id = 167;
update ag.survey_question set american = 'Do you produce any of the following fermented foods/beverages at home for personal consumption? Select all that apply and write in any that are not listed under ''Other''.' where survey_question_id = 169;
update ag.survey_question set american = 'Do you produce any of the following fermented foods/beverages for commercial purposes? Select all that apply and write in any that are not listed under ''Other''.' where survey_question_id = 171;
update ag.survey_question set american = 'How often do you consume beets (including raw, canned, pickled, or roasted)? (1 serving = 1 cup raw or cooked)' where survey_question_id = 236;
update ag.survey_question set american = 'How often do you eat plant-based sources of protein including tofu, tempeh, edamame, lentils, chickpeas, peanuts, almonds, walnuts, or quinoa?' where survey_question_id = 237;
update ag.survey_question set american = 'How often do you cook with vegetable oils (excluding coconut and palm oil) such as corn, soy, canola (rapeseed), olive, peanut, avocado, safflower or sunflower?' where survey_question_id = 239;
update ag.survey_question set american = 'How often do you cook with lard, butter or ghee?' where survey_question_id = 240;
update ag.survey_question set american = 'How often do you use or cook with coconut, palm or palm kernel oil?' where survey_question_id = 241;
update ag.survey_question set american = 'How often do you use or cook with margarine or (vegetable) shortening?' where survey_question_id = 242;
update ag.survey_question set american = '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, watermelon, dark chocolate or cocoa powder (>70%), and nuts such as almonds, peanuts pecans, cashews, and hazelnuts?' where survey_question_id = 243;
update ag.survey_question set american = 'How often do you consume soy products such as textured vegetable protein, tofu, tempeh, soybean flour, soy nuts, soy nut butter, soybeans, and miso (i.e. fermented soy)?' where survey_question_id = 244;


-- STEP 7: Retire questions that are no longer being used.
update ag.survey_question set retired = true where survey_question_id = 14;
update ag.survey_question set retired = true where survey_question_id = 23;
update ag.survey_question set retired = true where survey_question_id = 30;
update ag.survey_question set retired = true where survey_question_id = 31;
update ag.survey_question set retired = true where survey_question_id = 41;
update ag.survey_question set retired = true where survey_question_id = 55;
update ag.survey_question set retired = true where survey_question_id = 81;
update ag.survey_question set retired = true where survey_question_id = 88;
update ag.survey_question set retired = true where survey_question_id = 101;
update ag.survey_question set retired = true where survey_question_id = 107;
update ag.survey_question set retired = true where survey_question_id = 117;
update ag.survey_question set retired = true where survey_question_id = 153;
update ag.survey_question set retired = true where survey_question_id = 154;
update ag.survey_question set retired = true where survey_question_id = 155;
update ag.survey_question set retired = true where survey_question_id = 158;
update ag.survey_question set retired = true where survey_question_id = 10;
update ag.survey_question set retired = true where survey_question_id = 12;
update ag.survey_question set retired = true where survey_question_id = 13;
update ag.survey_question set retired = true where survey_question_id = 52;
update ag.survey_question set retired = true where survey_question_id = 63;
update ag.survey_question set retired = true where survey_question_id = 97;
update ag.survey_question set retired = true where survey_question_id = 98;
update ag.survey_question set retired = true where survey_question_id = 103;
update ag.survey_question set retired = true where survey_question_id = 105;
update ag.survey_question set retired = true where survey_question_id = 114;
update ag.survey_question set retired = true where survey_question_id = 118;
update ag.survey_question set retired = true where survey_question_id = 119;
update ag.survey_question set retired = true where survey_question_id = 120;
update ag.survey_question set retired = true where survey_question_id = 122;
update ag.survey_question set retired = true where survey_question_id = 127;
update ag.survey_question set retired = true where survey_question_id = 128;
update ag.survey_question set retired = true where survey_question_id = 129;
update ag.survey_question set retired = true where survey_question_id = 130;
update ag.survey_question set retired = true where survey_question_id = 131;
update ag.survey_question set retired = true where survey_question_id = 132;
update ag.survey_question set retired = true where survey_question_id = 133;
update ag.survey_question set retired = true where survey_question_id = 134;
update ag.survey_question set retired = true where survey_question_id = 135;
update ag.survey_question set retired = true where survey_question_id = 136;
update ag.survey_question set retired = true where survey_question_id = 137;
update ag.survey_question set retired = true where survey_question_id = 138;
update ag.survey_question set retired = true where survey_question_id = 139;
update ag.survey_question set retired = true where survey_question_id = 140;
update ag.survey_question set retired = true where survey_question_id = 141;
update ag.survey_question set retired = true where survey_question_id = 142;
update ag.survey_question set retired = true where survey_question_id = 143;
update ag.survey_question set retired = true where survey_question_id = 144;
update ag.survey_question set retired = true where survey_question_id = 145;
update ag.survey_question set retired = true where survey_question_id = 159;
update ag.survey_question set retired = true where survey_question_id = 160;
update ag.survey_question set retired = true where survey_question_id = 161;
update ag.survey_question set retired = true where survey_question_id = 164;
update ag.survey_question set retired = true where survey_question_id = 168;
update ag.survey_question set retired = true where survey_question_id = 170;
update ag.survey_question set retired = true where survey_question_id = 172;
update ag.survey_question set retired = true where survey_question_id = 173;
update ag.survey_question set retired = true where survey_question_id = 186;
update ag.survey_question set retired = true where survey_question_id = 187;
update ag.survey_question set retired = true where survey_question_id = 188;
update ag.survey_question set retired = true where survey_question_id = 189;
update ag.survey_question set retired = true where survey_question_id = 190;
update ag.survey_question set retired = true where survey_question_id = 191;
update ag.survey_question set retired = true where survey_question_id = 192;
update ag.survey_question set retired = true where survey_question_id = 193;
update ag.survey_question set retired = true where survey_question_id = 194;
update ag.survey_question set retired = true where survey_question_id = 195;
update ag.survey_question set retired = true where survey_question_id = 196;
update ag.survey_question set retired = true where survey_question_id = 197;
update ag.survey_question set retired = true where survey_question_id = 198;
update ag.survey_question set retired = true where survey_question_id = 199;
update ag.survey_question set retired = true where survey_question_id = 200;
update ag.survey_question set retired = true where survey_question_id = 201;
update ag.survey_question set retired = true where survey_question_id = 202;
update ag.survey_question set retired = true where survey_question_id = 203;
update ag.survey_question set retired = true where survey_question_id = 204;
update ag.survey_question set retired = true where survey_question_id = 205;
update ag.survey_question set retired = true where survey_question_id = 206;
update ag.survey_question set retired = true where survey_question_id = 207;
update ag.survey_question set retired = true where survey_question_id = 208;


-- STEP 8: Add new questions into the database.
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (313, 'Which of the following best describes the area in which you live?', 'URBANIZATION_LEVEL', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (316, 'What is your relationship to those in this study who have voluntarily told you of their participation (e.g. partner, children)? Note that we will only use information that both parties provide. This information is useful because studies have shown that our genes affect our microbiome.', 'RELATIONSHIPS_IN_STUDY', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (319, 'Who are your roommates who have voluntarily told you of their participation in this study? Note that we will only use information that both parties provide. This information is useful because studies have shown that the people we live with affect our microbiome.', 'ALL_ROOMMATES', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (326, 'Do you have frequent and regular contact with farm animals?', 'FARM_ANIMALS', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (328, 'Do you track any of the following using an app(s)? Select all that apply.', 'APP_TRACKER', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (331, 'What type of exercise do you typically do? Select all that apply.', 'TYPICAL_EXERCISE', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (332, 'What intensity of exercise do you typically do? Select all that apply.', 'EXERCISE_INTENSITY', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (333, 'How often do you take part in team sports?', 'TEAM_ACTIVITIES', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (334, 'When the season allows, how often do you garden or do yard work?', 'GARDENING', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (354, 'Do you surf in the ocean on a regular basis?', 'IS_SURFER', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (360, 'If you answered "yes", which type of IBD do you have?', 'IBD_DIAGNOSED_AS_TYPE', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (362, 'Over the last week, how frequently have you had abdominal pain or abdominal discomfort?', 'FREQ_ABDOMINAL_PAIN', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (363, 'Over the last week, how frequently have you had abdominal bloating?', 'FREQ_ABDOMINAL_BLOATING', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (364, 'Over the last week, how frequently have you had flatulence (passage of gas)?', 'FREQ_FLATULENCE', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (365, 'Over the last week, how frequently have you had borborygmi / rumbling stomach?', 'FREQ_RUMBLING_STOMACH', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (370, 'Pregnancy due date:', 'PREGNANCY_DUE_DATE', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (374, 'What kind of skin condition have you been diagnosed with?', 'SKIN_CONDITION_TYPES', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (375, 'How was your skin condition diagnosed?', 'SKIN_CONDITION_DIAG', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (387, 'On a scale of 1 to 10, where 1 means you have little or no stress and 10 means you have a great deal of stress, how would you rate your average level of stress during the past month?', 'STRESS_LEVEL', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (407, 'Approximately when were you diagnosed?', 'CANCER_DIAGNOSED', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (408, 'Do you currently have cancer?', 'HAS_CANCER', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (409, 'Which kind of cancer(s) did you / do you have? Select all that apply.', 'CANCER_TYPES', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (410, 'Which types of treatment(s) did you take/user? Select all that apply.', 'CANCER_TREATMENTS', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (413, 'How was this diagnosed?', 'CONDITION_DIAGNOSIS', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (415, 'Do you take medication to relieve your symptoms?', 'TAKING_ALLERGY_MEDS', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (423, 'If you practice intermittent fasting, what type do you follow?', 'FASTING_TYPE', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (424, 'Please list/describe any other special diet restrictions you follow that are not indicated above.', 'DIET_RESTRICTIONS', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (425, 'How many meals do you typically eat per day?', 'MEAL_COUNT', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (426, 'How many snacks do you typically eat per day?', 'SNACK_COUNT', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (427, 'When do you consume most of your daily calories?', 'PEAK_CONSUMPTION', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (428, 'At what time do you typically eat your last meal or snack before going to sleep?', 'LAST_MEAL_TIME', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (433, 'If you take a fiber supplement, what kind do you take? Select all that apply.', 'FIBER_SUPPLEMENT_TYPES', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (434, 'How frequently do you take a fiber supplement?', 'FREQ_FIBER_SUPPLEMENT', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (443, 'In an average week, how often do you eat foods that are fortified with high fiber content (e.g. Fiber One)?', 'WEEKLY_FIBER_FORTIFIED_FOODS', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (462, 'How much do you typically consume in a sitting?', 'ARTIFICIAL_BEVERAGE_CONSUMPTION', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (464, 'If you answered "yes", to Question 24 and/or 25, what type of non-nutritive or low-calorie sweetner(s) do you consume on a regular basis? Select all that apply.', 'ARTIFICIAL_SWEETENER_TYPES', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (474, 'At home, what is the main source of your plain, unflavored drinking water? This can include still or sparkling/carbonated water.', 'HOME_WATER_SOURCE', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (475, 'At home, do you apply additional treatment (not including filtering) to your drinking water prior to consumption (e.g., boiling, purification tablet, chlorine/bleach)?', 'HOME_WATER_TREATMENT', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (476, 'When you''re outside the home, what is the main source of your plain unflavored drinking water? This can include still or sparkling/carbonated water.', 'OUTSIDE_WATER_SOURCE', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (477, 'When you''re outside the home, do you apply additional treatment to your drinking water prior to consumption (e.g., boiling, purification tablet, chlorine/bleach)?', 'OUTSIDE_WATER_TREATMENT', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (478, 'When did you start eating fermented foods?', 'FERMENTED_FOODS_START', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (485, 'How often do you experience migraines?', 'FREQ_MIGRAINES', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (486, 'Please rank the main factors that lead to your migraines, where "1" is most likely, "2" is second most likely, etc. If the factor does not cause migraines leave blank', 'MIGRAINE_FACTORS', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (487, 'Of the following check all the symptoms you experience with a migraine:', 'MIGRAINE_SYMPTOMS', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (488, 'Do any of your first-degree relatives suffer from migraines?', 'RELATIVES_MIGRAINES', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (489, 'Do you take any migraine medication?', 'MIGRAINE_RX', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (490, 'Type/brand', 'MIGRAINE_RX_TYPES', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (492, 'Which of the following best describes you?', 'RACE_v2', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (493, 'What is your highest level of education?', 'LEVEL_OF_EDUCATION_v2', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (494, 'What type(s) of alcohol do you typically consume? Select all that apply.', 'ALCOHOL_TYPES_v2', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (495, 'How often do you brush your teeth?', 'TEETHBRUSHING_FREQUENCY_v2', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (497, 'Are you currently using some form of hormonal birth control?', 'CONTRACEPTIVE_v2', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (498, 'Are you an infant who receives most of your nutrition from breast milk or formula, or an adult who receives most (more than 75% of daily calories) of your nutrition from adult nutritional shakes (i.e. Ensure)?', 'BREASTMILK_FORMULA_ENSURE_v2', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (499, 'Have you ever been diagnosed with any other relevant clinical condition?', 'CLINICAL_CONDITION_v2', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (500, 'Have you ever been diagnosed with a skin condition?', 'SKIN_CONDITION_v2', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (501, 'Where does your dogs(s) mostly stay?', 'DOG_LOCATION_v2', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (502, 'Biological sex assigned at birth', 'GENDER_v2', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (503, 'Where does your cats(s) mostly stay?', 'CAT_LOCATION_v2', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (504, 'Have you ever been diagnosed with mental health illness?', 'mental_illness_v2', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (505, 'If you responded "yes", please select which disorder(s) from the following list:', 'mental_illness_type_v2', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (506, 'If you responded "yes", select which type of diabetes:', 'diabetes_type_v2', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (507, 'Have you ever been diagnosed with cancer?', 'cancer_v2', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (508, 'Participant Name', 'RIS_PARTICIPANT_NAME', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (509, 'Are you genetically related?', 'RIS_IS_RELATED', false);
insert into ag.survey_question (survey_question_id, american, question_shortname, retired) values (510, 'Does this person live with you?', 'RIS_IS_LIVING_WITH', false);


-- STEP 9: associate new and modified questions with a new survey_group,
-- in the new order of appearance. Move retired questions to group 10.
insert into ag.group_questions values (-10, 10, 1);
insert into ag.group_questions values (-10, 12, 2);
insert into ag.group_questions values (-10, 13, 3);
insert into ag.group_questions values (-10, 14, 4);
insert into ag.group_questions values (-10, 23, 5);
insert into ag.group_questions values (-10, 30, 6);
insert into ag.group_questions values (-10, 31, 7);
insert into ag.group_questions values (-10, 41, 8);
insert into ag.group_questions values (-10, 52, 9);
insert into ag.group_questions values (-10, 55, 10);
insert into ag.group_questions values (-10, 63, 11);
insert into ag.group_questions values (-10, 81, 12);
insert into ag.group_questions values (-10, 88, 13);
insert into ag.group_questions values (-10, 97, 14);
insert into ag.group_questions values (-10, 98, 15);
insert into ag.group_questions values (-10, 101, 16);
insert into ag.group_questions values (-10, 103, 17);
insert into ag.group_questions values (-10, 105, 18);
insert into ag.group_questions values (-10, 107, 19);
insert into ag.group_questions values (-10, 114, 20);
insert into ag.group_questions values (-10, 117, 22);
insert into ag.group_questions values (-10, 118, 23);
insert into ag.group_questions values (-10, 119, 24);
insert into ag.group_questions values (-10, 120, 25);
insert into ag.group_questions values (-10, 122, 26);
insert into ag.group_questions values (-10, 127, 27);
insert into ag.group_questions values (-10, 128, 28);
insert into ag.group_questions values (-10, 129, 29);
insert into ag.group_questions values (-10, 130, 30);
insert into ag.group_questions values (-10, 131, 31);
insert into ag.group_questions values (-10, 132, 32);
insert into ag.group_questions values (-10, 133, 33);
insert into ag.group_questions values (-10, 134, 34);
insert into ag.group_questions values (-10, 135, 35);
insert into ag.group_questions values (-10, 136, 36);
insert into ag.group_questions values (-10, 137, 37);
insert into ag.group_questions values (-10, 138, 38);
insert into ag.group_questions values (-10, 139, 39);
insert into ag.group_questions values (-10, 140, 40);
insert into ag.group_questions values (-10, 141, 41);
insert into ag.group_questions values (-10, 142, 42);
insert into ag.group_questions values (-10, 143, 43);
insert into ag.group_questions values (-10, 144, 44);
insert into ag.group_questions values (-10, 145, 45);
insert into ag.group_questions values (-10, 153, 46);
insert into ag.group_questions values (-10, 154, 47);
insert into ag.group_questions values (-10, 155, 48);
insert into ag.group_questions values (-10, 158, 49);
insert into ag.group_questions values (-10, 159, 50);
insert into ag.group_questions values (-10, 160, 51);
insert into ag.group_questions values (-10, 161, 52);
insert into ag.group_questions values (-10, 164, 53);
insert into ag.group_questions values (-10, 168, 54);
insert into ag.group_questions values (-10, 170, 55);
insert into ag.group_questions values (-10, 172, 56);
insert into ag.group_questions values (-10, 173, 57);
insert into ag.group_questions values (-10, 186, 58);
insert into ag.group_questions values (-10, 187, 59);
insert into ag.group_questions values (-10, 188, 60);
insert into ag.group_questions values (-10, 189, 61);
insert into ag.group_questions values (-10, 190, 62);
insert into ag.group_questions values (-10, 191, 63);
insert into ag.group_questions values (-10, 192, 64);
insert into ag.group_questions values (-10, 193, 65);
insert into ag.group_questions values (-10, 194, 66);
insert into ag.group_questions values (-10, 195, 67);
insert into ag.group_questions values (-10, 196, 68);
insert into ag.group_questions values (-10, 197, 69);
insert into ag.group_questions values (-10, 198, 70);
insert into ag.group_questions values (-10, 199, 71);
insert into ag.group_questions values (-10, 200, 72);
insert into ag.group_questions values (-10, 201, 73);
insert into ag.group_questions values (-10, 202, 74);
insert into ag.group_questions values (-10, 203, 75);
insert into ag.group_questions values (-10, 204, 76);
insert into ag.group_questions values (-10, 205, 77);
insert into ag.group_questions values (-10, 206, 78);
insert into ag.group_questions values (-10, 207, 79);
insert into ag.group_questions values (-10, 208, 80);
insert into ag.group_questions values(-10,111,81);
insert into ag.group_questions values(-10,112,82);
insert into ag.group_questions values(-10,502,83);
insert into ag.group_questions values(-10,108,84);
insert into ag.group_questions values(-10,109,85);
insert into ag.group_questions values(-10,113,86);
insert into ag.group_questions values(-10,110,87);
insert into ag.group_questions values(-10,148,88);
insert into ag.group_questions values(-10,115,89);
insert into ag.group_questions values(-10,492,90);
insert into ag.group_questions values(-10,493,91);
insert into ag.group_questions values(-10,22,92);
insert into ag.group_questions values (-10, 116, 93);
insert into ag.group_questions values(-11,313,1);
insert into ag.group_questions values(-11,15,2);
insert into ag.group_questions values(-11,19,3);
insert into ag.group_questions values(-11,316,4);
insert into ag.group_questions values(-11,508,5);
insert into ag.group_questions values(-11,509,6);
insert into ag.group_questions values(-11,510,7);
insert into ag.group_questions values(-11,17,8);
insert into ag.group_questions values(-11,18,9);
insert into ag.group_questions values(-11,319,10);
insert into ag.group_questions values(-11,20,11);
insert into ag.group_questions values(-11,501,12);
insert into ag.group_questions values(-11,21,13);
insert into ag.group_questions values(-11,503,14);
insert into ag.group_questions values(-11,149,15);
insert into ag.group_questions values(-11,150,16);
insert into ag.group_questions values(-11,326,17);
insert into ag.group_questions values(-12,16,1);
insert into ag.group_questions values(-12,328,2);
insert into ag.group_questions values(-12,24,3);
insert into ag.group_questions values(-12,25,4);
insert into ag.group_questions values(-12,331,5);
insert into ag.group_questions values(-12,332,6);
insert into ag.group_questions values(-12,333,7);
insert into ag.group_questions values(-12,334,8);
insert into ag.group_questions values(-12,28,9);
insert into ag.group_questions values(-12,29,10);
insert into ag.group_questions values(-12,494,11);
insert into ag.group_questions values(-12,163,12);
insert into ag.group_questions values(-12,495,13);
insert into ag.group_questions values(-12,32,14);
insert into ag.group_questions values(-12,33,15);
insert into ag.group_questions values(-12,34,16);
insert into ag.group_questions values(-12,35,17);
insert into ag.group_questions values(-12,344,18);
insert into ag.group_questions values(-12,345,19);
insert into ag.group_questions values(-12,346,20);
insert into ag.group_questions values(-12,347,21);
insert into ag.group_questions values(-12,348,22);
insert into ag.group_questions values(-12,349,23);
insert into ag.group_questions values(-12,350,24);
insert into ag.group_questions values(-12,36,25);
insert into ag.group_questions values(-12,26,26);
insert into ag.group_questions values(-12,27,27);
insert into ag.group_questions values(-12,354,28);
insert into ag.group_questions values(-13,37,1);
insert into ag.group_questions values(-13,38,2);
insert into ag.group_questions values(-13,95,3);
insert into ag.group_questions values(-13,79,4);
insert into ag.group_questions values(-13,83,5);
insert into ag.group_questions values(-13,360,6);
insert into ag.group_questions values(-13,78,7);
insert into ag.group_questions values(-13,362,8);
insert into ag.group_questions values(-13,363,9);
insert into ag.group_questions values(-13,364,10);
insert into ag.group_questions values(-13,365,11);
insert into ag.group_questions values(-14,50,1);
insert into ag.group_questions values(-14,51,2);
insert into ag.group_questions values(-14,497,3);
insert into ag.group_questions values(-14,42,4);
insert into ag.group_questions values(-14,370,5);
insert into ag.group_questions values(-14,43,6);
insert into ag.group_questions values(-14,156,7);
insert into ag.group_questions values(-14,500,8);
insert into ag.group_questions values(-14,374,9);
insert into ag.group_questions values(-14,375,10);
insert into ag.group_questions values(-14,47,11);
insert into ag.group_questions values(-14,48,12);
insert into ag.group_questions values(-14,49,13);
insert into ag.group_questions values(-14,99,14);
insert into ag.group_questions values(-14,39,15);
insert into ag.group_questions values(-14,124,16);
insert into ag.group_questions values(-14,126,17);
insert into ag.group_questions values(-14,40,18);
insert into ag.group_questions values(-14,44,19);
insert into ag.group_questions values(-14,45,20);
insert into ag.group_questions values(-14,46,21);
insert into ag.group_questions values(-14,387,22);
insert into ag.group_questions values(-15,85,1);
insert into ag.group_questions values(-15,84,2);
insert into ag.group_questions values(-15,93,3);
insert into ag.group_questions values(-15,77,4);
insert into ag.group_questions values(-15,87,5);
insert into ag.group_questions values(-15,80,6);
insert into ag.group_questions values(-15,89,7);
insert into ag.group_questions values(-15,504,8);
insert into ag.group_questions values(-15,505,9);
insert into ag.group_questions values(-15,82,10);
insert into ag.group_questions values(-15,506,11);
insert into ag.group_questions values(-15,90,12);
insert into ag.group_questions values(-15,92,13);
insert into ag.group_questions values(-15,60,14);
insert into ag.group_questions values(-15,86,15);
insert into ag.group_questions values(-15,94,16);
insert into ag.group_questions values(-15,96,17);
insert into ag.group_questions values(-15,507,18);
insert into ag.group_questions values(-15,407,19);
insert into ag.group_questions values(-15,408,20);
insert into ag.group_questions values(-15,409,21);
insert into ag.group_questions values(-15,410,22);
insert into ag.group_questions values(-15,499,23);
insert into ag.group_questions values(-15,106,24);
insert into ag.group_questions values(-15,413,25);
insert into ag.group_questions values(-16,53,1);
insert into ag.group_questions values(-16,415,2);
insert into ag.group_questions values(-16,54,3);
insert into ag.group_questions values(-16,7,4);
insert into ag.group_questions values(-16,8,5);
insert into ag.group_questions values(-16,9,6);
insert into ag.group_questions values(-17,1,1);
insert into ag.group_questions values(-17,162,2);
insert into ag.group_questions values(-17,11,3);
insert into ag.group_questions values(-17,423,4);
insert into ag.group_questions values(-17,424,5);
insert into ag.group_questions values(-17,425,6);
insert into ag.group_questions values(-17,426,7);
insert into ag.group_questions values(-17,427,8);
insert into ag.group_questions values(-17,428,9);
insert into ag.group_questions values(-17,2,10);
insert into ag.group_questions values(-17,3,11);
insert into ag.group_questions values(-17,4,12);
insert into ag.group_questions values(-17,5,13);
insert into ag.group_questions values(-17,433,14);
insert into ag.group_questions values(-17,434,15);
insert into ag.group_questions values(-17,6,16);
insert into ag.group_questions values(-17,104,17);
insert into ag.group_questions values(-17,498,18);
insert into ag.group_questions values(-18,56,1);
insert into ag.group_questions values(-18,57,2);
insert into ag.group_questions values(-18,58,3);
insert into ag.group_questions values(-18,59,4);
insert into ag.group_questions values(-18,91,5);
insert into ag.group_questions values(-18,443,6);
insert into ag.group_questions values(-18,61,7);
insert into ag.group_questions values(-18,62,8);
insert into ag.group_questions values(-18,236,9);
insert into ag.group_questions values(-18,237,10);
insert into ag.group_questions values(-18,146,11);
insert into ag.group_questions values(-18,64,12);
insert into ag.group_questions values(-18,65,13);
insert into ag.group_questions values(-18,66,14);
insert into ag.group_questions values(-18,67,15);
insert into ag.group_questions values(-18,68,16);
insert into ag.group_questions values(-18,69,17);
insert into ag.group_questions values(-18,70,18);
insert into ag.group_questions values(-18,71,19);
insert into ag.group_questions values(-18,72,20);
insert into ag.group_questions values(-18,73,21);
insert into ag.group_questions values(-18,74,22);
insert into ag.group_questions values(-18,75,23);
insert into ag.group_questions values(-18,157,24);
insert into ag.group_questions values(-18,462,25);
insert into ag.group_questions values(-18,463,26);
insert into ag.group_questions values(-18,464,27);
insert into ag.group_questions values(-18,465,28);
insert into ag.group_questions values(-18,466,29);
insert into ag.group_questions values(-18,239,30);
insert into ag.group_questions values(-18,240,31);
insert into ag.group_questions values(-18,241,32);
insert into ag.group_questions values(-18,242,33);
insert into ag.group_questions values(-18,243,34);
insert into ag.group_questions values(-18,244,35);
insert into ag.group_questions values(-18,76,36);
insert into ag.group_questions values(-18,474,37);
insert into ag.group_questions values(-18,475,38);
insert into ag.group_questions values(-18,476,39);
insert into ag.group_questions values(-18,477,40);
insert into ag.group_questions values(-18,478,41);
insert into ag.group_questions values(-18,166,42);
insert into ag.group_questions values(-18,165,43);
insert into ag.group_questions values(-18,167,44);
insert into ag.group_questions values(-18,169,45);
insert into ag.group_questions values(-18,171,46);
insert into ag.group_questions values(-19,485,1);
insert into ag.group_questions values(-19,486,2);
insert into ag.group_questions values(-19,487,3);
insert into ag.group_questions values(-19,488,4);
insert into ag.group_questions values(-19,489,5);
insert into ag.group_questions values(-19,490,6);
insert into ag.group_questions values(-20,174,1);
insert into ag.group_questions values(-20,175,2);
insert into ag.group_questions values(-20,176,3);
insert into ag.group_questions values(-20,177,4);
insert into ag.group_questions values(-20,178,5);
insert into ag.group_questions values(-20,179,6);
insert into ag.group_questions values(-20,180,7);
insert into ag.group_questions values(-20,181,8);
insert into ag.group_questions values(-20,182,9);
insert into ag.group_questions values(-20,183,10);
insert into ag.group_questions values(-20,184,11);
insert into ag.group_questions values(-20,185,12);
insert into ag.group_questions values(-21,209,1);
insert into ag.group_questions values(-21,210,2);
insert into ag.group_questions values(-21,211,3);
insert into ag.group_questions values(-21,212,4);
insert into ag.group_questions values(-21,213,5);
insert into ag.group_questions values(-21,214,6);
insert into ag.group_questions values(-21,215,7);
insert into ag.group_questions values(-21,216,8);
insert into ag.group_questions values(-21,217,9);
insert into ag.group_questions values(-21,238,10);
insert into ag.group_questions values(-21,218,11);
insert into ag.group_questions values(-21,219,12);
insert into ag.group_questions values(-21,220,13);
insert into ag.group_questions values(-21,221,14);
insert into ag.group_questions values(-21,222,15);
insert into ag.group_questions values(-21,223,16);
insert into ag.group_questions values(-21,224,17);
insert into ag.group_questions values(-21,225,18);
insert into ag.group_questions values(-21,226,19);
insert into ag.group_questions values(-21,227,20);
insert into ag.group_questions values(-21,228,21);
insert into ag.group_questions values(-21,229,22);
insert into ag.group_questions values(-21,230,23);
insert into ag.group_questions values(-21,231,24);
insert into ag.group_questions values(-21,232,25);
insert into ag.group_questions values(-21,233,26);
insert into ag.group_questions values(-21,234,27);
insert into ag.group_questions values(-21,235,28);


-- STEP 7: Add new unique values to the set of legal survey responses.
insert into ag.survey_response (american) values('0');
insert into ag.survey_response (american) values('1-2 times/week');
insert into ag.survey_response (american) values('10');
insert into ag.survey_response (american) values('11-20');
insert into ag.survey_response (american) values('12-16 fl oz (355-473 ml)');
insert into ag.survey_response (american) values('16-20 fl oz (473-591 ml)');
insert into ag.survey_response (american) values('2');
insert into ag.survey_response (american) values('2 times a day');
insert into ag.survey_response (american) values('2-3 days per week');
insert into ag.survey_response (american) values('21-30');
insert into ag.survey_response (american) values('24 hour fast (aka eat-stop-eat method)');
insert into ag.survey_response (american) values('3');
insert into ag.survey_response (american) values('3-5 times/week');
insert into ag.survey_response (american) values('4');
insert into ag.survey_response (american) values('4-6 days per week');
insert into ag.survey_response (american) values('4-8 fl oz (118-237 ml)');
insert into ag.survey_response (american) values('5');
insert into ag.survey_response (american) values('5-6');
insert into ag.survey_response (american) values('5:2 method');
insert into ag.survey_response (american) values('6');
insert into ag.survey_response (american) values('6-10');
insert into ag.survey_response (american) values('6-7');
insert into ag.survey_response (american) values('7');
insert into ag.survey_response (american) values('7-8');
insert into ag.survey_response (american) values('8');
insert into ag.survey_response (american) values('8-12 fl oz (237-355 ml)');
insert into ag.survey_response (american) values('9');
insert into ag.survey_response (american) values('<4 fl oz (<118 ml)');
insert into ag.survey_response (american) values('>20 fl oz (>591 ml)');
insert into ag.survey_response (american) values('A few times a year');
insert into ag.survey_response (american) values('Acesulfame potassium');
insert into ag.survey_response (american) values('Activity/exercise');
insert into ag.survey_response (american) values('Adrenal cancer');
insert into ag.survey_response (american) values('Aerobic/cardio training');
insert into ag.survey_response (american) values('Alternate day fasting');
insert into ag.survey_response (american) values('Apple fiber');
insert into ag.survey_response (american) values('Asian');
insert into ag.survey_response (american) values('Aspartame');
insert into ag.survey_response (american) values('Associate''s degree (e.g. AA, AS))');
insert into ag.survey_response (american) values('Aura');
insert into ag.survey_response (american) values('Bachelor''s degree (e.g. BA, BS)');
insert into ag.survey_response (american) values('Balance training');
insert into ag.survey_response (american) values('Bee stings');
insert into ag.survey_response (american) values('Black or African American');
insert into ag.survey_response (american) values('Bladder cancer');
insert into ag.survey_response (american) values('Body pain where it shouldn''t exist;');
insert into ag.survey_response (american) values('Bottled* purified water (does not indicate "spring water" or "natural mineral water" on the label)');
insert into ag.survey_response (american) values('Brain cancer (includes gliomas and glioblastomas)');
insert into ag.survey_response (american) values('Breast cancer');
insert into ag.survey_response (american) values('Caffeine________');
insert into ag.survey_response (american) values('Calories are evenly distributed throughout the day');
insert into ag.survey_response (american) values('Cervical cancer');
insert into ag.survey_response (american) values('Cholangiocarcinoma');
insert into ag.survey_response (american) values('College degree');
insert into ag.survey_response (american) values('Colon cancer');
insert into ag.survey_response (american) values('Colonic Crohn''s disease');
insert into ag.survey_response (american) values('Currently in K-12');
insert into ag.survey_response (american) values('Daily time-restricted eating (TRE)');
insert into ag.survey_response (american) values('Depression______');
insert into ag.survey_response (american) values('Diet');
insert into ag.survey_response (american) values('Doctorate (eg. PhD, EdD)');
insert into ag.survey_response (american) values('Don''t know');
insert into ag.survey_response (american) values('Esophageal cancer');
insert into ag.survey_response (american) values('Few times/month');
insert into ag.survey_response (american) values('Few times/year');
insert into ag.survey_response (american) values('Filtered tap water (pitcher, faucet or under the sink water purifiers, reverse osmosis systems, water softener)');
insert into ag.survey_response (american) values('Flexibility training');
insert into ag.survey_response (american) values('Foods (wine, chocolate,strawberries)_________');
insert into ag.survey_response (american) values('Fortified wine');
insert into ag.survey_response (american) values('Functional food (e.g. chia seeds, wheat bran)');
insert into ag.survey_response (american) values('Generalized anxiety disorder');
insert into ag.survey_response (american) values('Hard cider');
insert into ag.survey_response (american) values('Hard kombucha');
insert into ag.survey_response (american) values('Hard seltzer');
insert into ag.survey_response (american) values('Hard tea');
insert into ag.survey_response (american) values('Head and Neck cancer');
insert into ag.survey_response (american) values('High school diploma or GED equivalent');
insert into ag.survey_response (american) values('Hispanic or Latino');
insert into ag.survey_response (american) values('Homeopathic medicines');
insert into ag.survey_response (american) values('Hormone therapy');
insert into ag.survey_response (american) values('Hormones__________');
insert into ag.survey_response (american) values('Hyperthermia');
insert into ag.survey_response (american) values('I am left-handed');
insert into ag.survey_response (american) values('I am right-handed');
insert into ag.survey_response (american) values('I do not eat fermented foods');
insert into ag.survey_response (american) values('I do not practice intermittent fasting');
insert into ag.survey_response (american) values('I do not take fiber supplements');
insert into ag.survey_response (american) values('I do not track any of my activities');
insert into ag.survey_response (american) values('I don''t drink plain, unflavored water');
insert into ag.survey_response (american) values('I eat anything except red meat');
insert into ag.survey_response (american) values('I eat anything with no exclusions (omnivore)');
insert into ag.survey_response (american) values('I have not been outside of the United States in the past year');
insert into ag.survey_response (american) values('I take a supplement, but do not know what kind');
insert into ag.survey_response (american) values('I tend to have hard stool or have difficulty passing stool -- Types 1 and 2');
insert into ag.survey_response (american) values('I tend to have loose or watery stool - Types 5, 6, and 7');
insert into ag.survey_response (american) values('I tend to have normally formed stool - Types 3 and 4');
insert into ag.survey_response (american) values('Ileal Crohn''s disease');
insert into ag.survey_response (american) values('Ileal and Colonic Crohn''s disease');
insert into ag.survey_response (american) values('Immunotherapy');
insert into ag.survey_response (american) values('In the afternoon');
insert into ag.survey_response (american) values('In the evening');
insert into ag.survey_response (american) values('In the morning');
insert into ag.survey_response (american) values('Inulin (e.g. Fiber Choice)');
insert into ag.survey_response (american) values('Irritability or avoidance of routine;');
insert into ag.survey_response (american) values('Isolated house/farm (population is less than 100)');
insert into ag.survey_response (american) values('Kidney cancer');
insert into ag.survey_response (american) values('Lack of sleep____');
insert into ag.survey_response (american) values('Leukemia');
insert into ag.survey_response (american) values('Liver cancer');
insert into ag.survey_response (american) values('Lung cancer');
insert into ag.survey_response (american) values('Lymphoma');
insert into ag.survey_response (american) values('Malt liquor');
insert into ag.survey_response (american) values('Master''s degree (e.g. MS, MA)');
insert into ag.survey_response (american) values('Medications that contain barbiturates or opioids__________');
insert into ag.survey_response (american) values('Melanoma (skin)');
insert into ag.survey_response (american) values('Methylcellulose (e.g. Citrucel)');
insert into ag.survey_response (american) values('Metropolis (population is more than 1 million)');
insert into ag.survey_response (american) values('Modified paleo diet');
insert into ag.survey_response (american) values('Monk fruit');
insert into ag.survey_response (american) values('Monthly');
insert into ag.survey_response (american) values('More than 2 times a day');
insert into ag.survey_response (american) values('More than 4');
insert into ag.survey_response (american) values('More than 8');
insert into ag.survey_response (american) values('Multiracial');
insert into ag.survey_response (american) values('Native American or Alaska Native');
insert into ag.survey_response (american) values('Native Hawaiian or Other Pacific Islander');
insert into ag.survey_response (american) values('Natural mineral or spring water bottled* in another country in the European Union or the UK');
insert into ag.survey_response (american) values('Natural mineral or spring water bottled* in another country not in the European Union or the UK');
insert into ag.survey_response (american) values('Natural mineral or spring water bottled* locally (i.e. in your country of residence)');
insert into ag.survey_response (american) values('Nausea and/or vomiting;');
insert into ag.survey_response (american) values('Nitrates__________');
insert into ag.survey_response (american) values('No formal education');
insert into ag.survey_response (american) values('No, I do not have this condition');
insert into ag.survey_response (american) values('No, I do not take any medications for my allergies');
insert into ag.survey_response (american) values('No, I no longer have cancer');
insert into ag.survey_response (american) values('Not Sure');
insert into ag.survey_response (american) values('Not sure, but I use some form of deodorant or antiperspirant');
insert into ag.survey_response (american) values('Oat fiber');
insert into ag.survey_response (american) values('Once per week');
insert into ag.survey_response (american) values('Only during Ramadan');
insert into ag.survey_response (american) values('Other _____________');
insert into ag.survey_response (american) values('Other ___________________________________________');
insert into ag.survey_response (american) values('Ovarian cancer');
insert into ag.survey_response (american) values('Paleo-diet or primal diet');
insert into ag.survey_response (american) values('Pancreatic cancer');
insert into ag.survey_response (american) values('Periodic fasting');
insert into ag.survey_response (american) values('Pheochromocytoma and paraganglioma cancer');
insert into ag.survey_response (american) values('Phonophobia (sensitivity to sound);');
insert into ag.survey_response (american) values('Photodynamic therapy');
insert into ag.survey_response (american) values('Photophobia (sensitivity to light);');
insert into ag.survey_response (american) values('Poison ivy/oak/sumac');
insert into ag.survey_response (american) values('Professional degree (e.g. MD,DDS, DVM)');
insert into ag.survey_response (american) values('Prostate cancer');
insert into ag.survey_response (american) values('Psyllium (e.g. Metamucil)');
insert into ag.survey_response (american) values('Radiotherapy');
insert into ag.survey_response (american) values('Raw food diet');
insert into ag.survey_response (american) values('Rectal cancer');
insert into ag.survey_response (american) values('Rose wine');
insert into ag.survey_response (american) values('Saccharin');
insert into ag.survey_response (american) values('Sake');
insert into ag.survey_response (american) values('Sarcoma');
insert into ag.survey_response (american) values('Since infancy/childhood');
insert into ag.survey_response (american) values('Sleep');
insert into ag.survey_response (american) values('Small town or village (population is more than 100 and less than 1,000)');
insert into ag.survey_response (american) values('Sour beer');
insert into ag.survey_response (american) values('Sour cream/crème fraiche');
insert into ag.survey_response (american) values('Sparkling wine');
insert into ag.survey_response (american) values('Spirits/liquors/hard alcohol');
insert into ag.survey_response (american) values('Stem cell transplant');
insert into ag.survey_response (american) values('Stevia');
insert into ag.survey_response (american) values('Stomach cancer');
insert into ag.survey_response (american) values('Strength training');
insert into ag.survey_response (american) values('Stress__________');
insert into ag.survey_response (american) values('Sucralose');
insert into ag.survey_response (american) values('Sugar alcohols (sorbitol, xylitol, lactitol, mannitol, erythritol, and maltitol)');
insert into ag.survey_response (american) values('Surgery');
insert into ag.survey_response (american) values('Tap water');
insert into ag.survey_response (american) values('Targeted (medication) therapy');
insert into ag.survey_response (american) values('Testicular germ cell cancer');
insert into ag.survey_response (american) values('Thyroid cancer');
insert into ag.survey_response (american) values('Town (population is more than 1,000 and less than 100,000)');
insert into ag.survey_response (american) values('Ulcerative Colitis');
insert into ag.survey_response (american) values('Uterine cancer');
insert into ag.survey_response (american) values('Uveal melanoma');
insert into ag.survey_response (american) values('Vigorous');
insert into ag.survey_response (american) values('Vocational training');
insert into ag.survey_response (american) values('Weekly');
insert into ag.survey_response (american) values('Well water');
insert into ag.survey_response (american) values('What type(s) of pets?');
insert into ag.survey_response (american) values('Wheat dextrin (e.g. Benefiber)');
insert into ag.survey_response (american) values('Within the last 10 years');
insert into ag.survey_response (american) values('Within the last 5 years');
insert into ag.survey_response (american) values('Within the last year');
insert into ag.survey_response (american) values('Yes, I currently have cancer');
insert into ag.survey_response (american) values('Yes, I take homeopathic medication');
insert into ag.survey_response (american) values('Yes, I take over-the-counter medication');
insert into ag.survey_response (american) values('Yes, I take prescription medication');
insert into ag.survey_response (american) values('Yes, I use a contraceptive patch');
insert into ag.survey_response (american) values('Yes, I use a contraceptive vaginal ring');
insert into ag.survey_response (american) values('Yes, I use a copper IUD');
insert into ag.survey_response (american) values('Yes, I use a hormonal IUD/implant');
insert into ag.survey_response (american) values('Yes, I use an injected contraceptive');
insert into ag.survey_response (american) values('Yes, I use other types of medication not listed here');
insert into ag.survey_response (american) values('Yes, diagnosed by a licensed mental health professional');
insert into ag.survey_response (american) values('Yes, diagnosed by a medical professional (doctor, physician assistant)');
insert into ag.survey_response (american) values('Yes, diagnosed by an alternative medicine practitioner');
insert into ag.survey_response (american) values('Yes, diagnosed by an alternative or complementary practitioner');
insert into ag.survey_response (american) values('Yes, diagnosed with celiac disease');
insert into ag.survey_response (american) values('Yes, diagnosed with gluten allergy (anti-gluten IgG), but not celiac disease');
insert into ag.survey_response (american) values('Both equally');
insert into ag.survey_response (american) values('few times/month');
--insert into ag.survey_response (american) values('Indoors');
--insert into ag.survey_response (american) values('Outdoors');
insert into ag.survey_response (american) values ('City (population is more than 100,000 and less than 1 million)');
insert into ag.survey_response (american) values('2021');
insert into ag.survey_response (american) values('2022');


-- STEP 8: Add possible responses and their display order for all new multiple choice questions.
-- drop index to allow for updates
alter table ag.survey_question_response drop constraint idx_survey_question_response;
insert into ag.survey_question_response(survey_question_id, response, display_index) values (313, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (313, 'Metropolis (population is more than 1 million)', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (313, 'City (population is more than 100,000 and less than 1 million)', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (313, 'Town (population is more than 1,000 and less than 100,000)', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (313, 'Small town or village (population is more than 100 and less than 1,000)', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (313, 'Isolated house/farm (population is less than 100)', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (326, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (326, 'Yes', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (326, 'No', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (328, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (328, 'Sleep', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (328, 'Diet', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (328, 'Activity/exercise', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (328, 'Other', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (328, 'I do not track any of my activities', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (331, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (331, 'Strength training', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (331, 'Aerobic/cardio training', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (331, 'Balance training', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (331, 'Flexibility training', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (332, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (332, 'Low', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (332, 'Moderate', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (332, 'Vigorous', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (333, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (333, 'Never', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (333, 'Few times/year', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (333, 'Few times/month', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (333, '1-2 times/week', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (333, '3-5 times/week', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (333, 'Daily', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (334, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (334, 'Never', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (334, 'Few times/month', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (334, '1-2 times/week', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (334, '3-5 times/week', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (334, 'Daily', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (354, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (354, 'Yes', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (354, 'No', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (360, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (360, 'Ileal Crohn''s disease', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (360, 'Colonic Crohn''s disease', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (360, 'Ileal and Colonic Crohn''s disease', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (360, 'Ulcerative Colitis', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (360, 'Microcolitis', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (362, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (362, 'Never', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (362, 'Once per week', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (362, '2-3 days per week', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (362, '4-6 days per week', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (362, 'Daily', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (363, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (363, 'Never', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (363, 'Once per week', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (363, '2-3 days per week', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (363, '4-6 days per week', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (363, 'Daily', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (364, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (364, 'Never', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (364, 'Once per week', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (364, '2-3 days per week', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (364, '4-6 days per week', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (364, 'Daily', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (365, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (365, 'Never', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (365, 'Once per week', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (365, '2-3 days per week', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (365, '4-6 days per week', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (365, 'Daily', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (375, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (375, 'Diagnosed by a medical professional (doctor, physician assistant)', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (375, 'Diagnosed by an alternative medicine practitioner', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (375, 'Self-diagnosed', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (387, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (387, '1', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (387, '2', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (387, '3', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (387, '4', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (387, '5', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (387, '6', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (387, '7', 7);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (387, '8', 8);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (387, '9', 9);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (387, '10', 10);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (408, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (408, 'No, I no longer have cancer', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (408, 'Yes, I currently have cancer', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Adrenal cancer', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Bladder cancer', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Brain cancer (includes gliomas and glioblastomas)', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Breast cancer', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Cervical cancer', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Cholangiocarcinoma', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Colon cancer', 7);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Esophageal cancer', 8);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Head and Neck cancer', 9);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Kidney cancer', 10);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Leukemia', 11);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Liver cancer', 12);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Lung cancer', 13);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Lymphoma', 14);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Ovarian cancer', 15);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Pancreatic cancer', 16);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Pheochromocytoma and paraganglioma cancer', 17);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Prostate cancer', 18);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Rectal cancer', 19);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Sarcoma', 20);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Melanoma (skin)', 21);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Stomach cancer', 22);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Testicular germ cell cancer', 23);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Thyroid cancer', 24);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Uterine cancer', 25);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Uveal melanoma', 26);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (409, 'Other', 27);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (410, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (410, 'None', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (410, 'Homeopathic medicines', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (410, 'Radiotherapy', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (410, 'Chemotherapy', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (410, 'Immunotherapy', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (410, 'Hormone therapy', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (410, 'Hyperthermia', 7);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (410, 'Photodynamic therapy', 8);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (410, 'Stem cell transplant', 9);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (410, 'Surgery', 10);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (410, 'Targeted (medication) therapy', 11);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (410, 'Other', 12);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (413, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (413, 'Diagnosed by a medical professional (doctor, physician assistant)', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (413, 'Diagnosed by an alternative medicine practitioner', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (413, 'Self-diagnosed', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (415, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (415, 'Yes, I take over-the-counter medication', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (415, 'Yes, I take prescription medication', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (415, 'Yes, I take homeopathic medication', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (415, 'Yes, I use other types of medication not listed here', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (415, 'No, I do not take any medications for my allergies', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (423, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (423, 'Daily time-restricted eating (TRE)', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (423, 'Alternate day fasting', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (423, 'Periodic fasting', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (423, '5:2 method', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (423, '24 hour fast (aka eat-stop-eat method)', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (423, 'Only during Ramadan', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (423, 'Other', 7);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (423, 'I do not practice intermittent fasting', 8);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (425, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (425, '0', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (425, '1', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (425, '2', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (425, '3', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (425, '4', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (425, 'More than 4', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (426, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (426, '0', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (426, '1', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (426, '2', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (426, '3', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (426, '4', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (426, 'More than 4', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (427, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (427, 'In the morning', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (427, 'In the afternoon', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (427, 'In the evening', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (427, 'Calories are evenly distributed throughout the day', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '12:00PM', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '12:30PM', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '1:00PM', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '1:30PM', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '2:00PM', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '2:30PM', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '3:00PM', 7);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '3:30PM', 8);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '4:00PM', 9);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '4:30PM', 10);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '5:00PM', 11);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '5:30PM', 12);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '6:00PM', 13);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '6:30PM', 14);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '7:00PM', 15);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '7:30PM', 16);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '8:00PM', 17);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '8:30PM', 18);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '9:00PM', 19);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '9:30PM', 20);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '10:00PM', 21);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '10:30PM', 22);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '11:00PM', 23);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (428, '11:30PM', 24);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (433, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (433, 'Inulin (e.g. Fiber Choice)', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (433, 'Methylcellulose (e.g. Citrucel)', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (433, 'Psyllium (e.g. Metamucil)', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (433, 'Wheat dextrin (e.g. Benefiber)', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (433, 'Oat fiber', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (433, 'Apple fiber', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (433, 'Functional food (e.g. chia seeds, wheat bran)', 7);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (433, 'Other', 8);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (433, 'I take a supplement, but do not know what kind', 9);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (433, 'I do not take fiber supplements', 10);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (434, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (434, 'Few times/month', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (434, '1-2 times/week', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (434, '3-5 times/week', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (434, 'Daily', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (443, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (443, 'Never', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (443, 'Few times/month', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (443, '1-2 times/week', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (443, '3-5 times/week', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (443, 'Daily', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (462, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (462, '<4 fl oz (<118 ml)', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (462, '4-8 fl oz (118-237 ml)', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (462, '8-12 fl oz (237-355 ml)', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (462, '12-16 fl oz (355-473 ml)', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (462, '16-20 fl oz (473-591 ml)', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (462, '>20 fl oz (>591 ml)', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (464, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (464, 'Saccharin', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (464, 'Sucralose', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (464, 'Aspartame', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (464, 'Acesulfame potassium', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (464, 'Stevia', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (464, 'Monk fruit', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (464, 'Sugar alcohols (sorbitol, xylitol, lactitol, mannitol, erythritol, and maltitol)', 7);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (464, 'Other', 8);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (474, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (474, 'Natural mineral or spring water bottled* locally (i.e. in your country of residence)', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (474, 'Natural mineral or spring water bottled* in another country not in the European Union or the UK', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (474, 'Natural mineral or spring water bottled* in another country in the European Union or the UK', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (474, 'Bottled* purified water (does not indicate "spring water" or "natural mineral water" on the label)', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (474, 'Tap water', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (474, 'Filtered tap water (pitcher, faucet or under the sink water purifiers, reverse osmosis systems, water softener)', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (474, 'Well water', 7);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (474, 'Not sure', 8);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (474, 'Other _____________', 9);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (474, 'I don''t drink plain, unflavored water', 10);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (475, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (475, 'Yes', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (475, 'No', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (476, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (476, 'Natural mineral or spring water bottled* locally (i.e. in your country of residence)', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (476, 'Natural mineral or spring water bottled* in another country not in the European Union or the UK', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (476, 'Natural mineral or spring water bottled* in another country in the European Union or the UK', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (476, 'Bottled* purified water (does not indicate "spring water" or "natural mineral water" on the label)', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (476, 'Tap water', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (476, 'Filtered tap water (pitcher, faucet or under the sink water purifiers, reverse osmosis systems, water softener)', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (476, 'Well water', 7);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (476, 'Not sure', 8);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (476, 'Other', 9);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (476, 'I don''t drink plain, unflavored water', 10);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (477, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (477, 'Yes', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (477, 'No', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (478, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (478, 'Since infancy/childhood', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (478, 'Within the last year', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (478, 'Within the last 5 years', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (478, 'Within the last 10 years', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (478, 'I do not eat fermented foods', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (485, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (485, 'Daily', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (485, 'Weekly', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (485, 'Monthly', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (485, 'A few times a year', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (486, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (486, 'Stress__________', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (486, 'Caffeine________', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (486, 'Depression______', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (486, 'Lack of sleep____', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (486, 'Foods (wine, chocolate,strawberries)_________', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (486, 'Medications that contain barbiturates or opioids__________', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (486, 'Nitrates__________', 7);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (486, 'Hormones__________', 8);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (487, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (487, 'Body pain where it shouldn''t exist;', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (487, 'Photophobia (sensitivity to light);', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (487, 'Phonophobia (sensitivity to sound);', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (487, 'Nausea and/or vomiting;', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (487, 'Irritability or avoidance of routine;', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (487, 'Aura', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (488, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (488, 'Yes', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (488, 'No', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (488, 'Don''t know', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (489, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (489, 'Yes', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (489, 'No', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (492, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (492, 'Asian', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (492, 'Black or African American', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (492, 'Hispanic or Latino', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (492, 'Native American or Alaska Native', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (492, 'Native Hawaiian or Other Pacific Islander', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (492, 'White', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (492, 'Multiracial', 7);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (492, 'Other', 8);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (493, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (493, 'No formal education', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (493, 'Currently in K-12', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (493, 'High school diploma or GED equivalent', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (493, 'College degree', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (493, 'Vocational training', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (493, 'Associate''s degree (e.g. AA, AS))', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (493, 'Bachelor''s degree (e.g. BA, BS)', 7);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (493, 'Master''s degree (e.g. MS, MA)', 8);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (493, 'Professional degree (e.g. MD,DDS, DVM)', 9);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (493, 'Doctorate (eg. PhD, EdD)', 10);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (493, 'Other', 11);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'Beer', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'Sour beer', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'Hard cider', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'Hard kombucha', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'Hard seltzer', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'Hard tea', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'Malt liquor', 7);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'White wine', 8);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'Red wine', 9);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'Rose wine', 10);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'Sparkling wine', 11);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'Fortified wine', 12);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'Mead', 13);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'Sake', 14);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'Spirits/liquors/hard alcohol', 15);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (494, 'Other', 16);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (495, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (495, 'More than 2 times a day', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (495, '2 times a day', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (495, 'Once a day', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (495, 'Never', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (497, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (497, 'Yes, I am taking the "pill"', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (497, 'Yes, I use an injected contraceptive', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (497, 'Yes, I use a contraceptive patch', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (497, 'Yes, I use a contraceptive vaginal ring', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (497, 'Yes, I use a hormonal IUD/implant', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (497, 'Yes, I use a copper IUD', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (497, 'No', 7);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (498, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (498, 'Yes', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (498, 'No', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (499, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (499, 'Yes', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (499, 'No', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (500, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (500, 'Yes', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (500, 'No', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (501, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (501, 'Indoors', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (501, 'Outdoors', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (501, 'Both equally', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (502, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (502, 'Female', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (502, 'Male', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (502, 'Other', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (502, 'Not sure', 4);

insert into ag.survey_question_response(survey_question_id, response, display_index) values (503, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (503, 'Indoors', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (503, 'Outdoors', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (503, 'Both equally', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (504, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (504, 'No, I do not have this condition', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (504, 'Yes, diagnosed by a licensed mental health professional', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (504, 'Yes, diagnosed by an alternative or complementary practitioner', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (504, 'Self-diagnosed', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (505, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (505, 'Depression', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (505, 'Bipolar disorder', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (505, 'PTSD (post-traumatic stress disorder)', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (505, 'Schizophrenia', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (505, 'Anorexia nervosa', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (505, 'Bulimia nervosa', 6);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (505, 'Substance abuse', 7);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (505, 'Generalized anxiety disorder', 8);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (505, 'Other', 9);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (506, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (506, 'Prediabetes', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (506, 'Type I diabetes', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (506, 'Type II diabetes', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (506, 'Gestational diabetes', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (507, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (507, 'No, I do not have this condition', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (507, 'Yes, diagnosed by a medical professional (doctor, physician assistant)', 2);

insert into ag.survey_question_response(survey_question_id, response, display_index) values (153, 'Yes, diagnosed by a licensed mental health professional', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (153, 'Yes, diagnosed by an alternative or complementary practitioner', 4);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (153, 'Self-diagnosed', 5);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (509, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (509, 'Yes', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (509, 'No', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (509, 'Not sure', 3);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (510, 'Unspecified', 0);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (510, 'Yes', 1);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (510, 'No', 2);
insert into ag.survey_question_response(survey_question_id, response, display_index) values (510, 'Not sure', 3);
-- recreate constraint
alter table only ag.survey_question_response add constraint idx_survey_question_response unique (survey_question_id, display_index);


-- STEP 9: Add response types for new questions.
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (161, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (313, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (316, 'STRING');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (508, 'STRING');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (509, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (510, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (319, 'STRING');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (326, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (328, 'MULTIPLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (331, 'MULTIPLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (332, 'MULTIPLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (333, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (334, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (354, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (360, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (362, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (363, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (364, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (365, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (370, 'STRING');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (374, 'STRING');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (375, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (387, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (407, 'STRING');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (408, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (409, 'MULTIPLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (410, 'MULTIPLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (413, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (415, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (423, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (424, 'TEXT');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (425, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (426, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (427, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (428, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (433, 'MULTIPLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (434, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (443, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (462, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (464, 'MULTIPLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (474, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (475, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (476, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (477, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (478, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (485, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (486, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (487, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (488, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (489, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (490, 'STRING');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (492, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (493, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (494, 'MULTIPLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (495, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (497, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (498, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (499, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (500, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (501, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (502, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (503, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (504, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (505, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (506, 'SINGLE');
insert into ag.survey_question_response_type (survey_question_id, survey_response_type) values (507, 'SINGLE');


-- STEP 10 Add triggers for nested questions.
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (149, 'Yes',150);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (153, 'Self-diagnosed',154);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (153, 'Yes, diagnosed by a licensed mental health professional', 154);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (153, 'Yes, diagnosed by an alternative or complementary practitioner', 154);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (158, 'Diagnosed by a medical professional (doctor, physician assistant)',407);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (158, 'Diagnosed by a medical professional (doctor, physician assistant)',408);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (158, 'Diagnosed by a medical professional (doctor, physician assistant)',409);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (158, 'Diagnosed by a medical professional (doctor, physician assistant)',410);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (17, 'One',18);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (18, 'Yes',319);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (19, 'Yes',316);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (19, 'Yes',508);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (19, 'Yes',509);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (19, 'Yes',510);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (20, 'Yes',101);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (21, 'Yes',117);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (24, 'Daily',25);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (24, 'Daily',331);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (24, 'Daily',332);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (29, 'Occasionally (1-2 times/week)',163);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (29, 'Occasionally (1-2 times/week)',30);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (29, 'Regularly (3-5 times/week)',163);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (29, 'Regularly (3-5 times/week)',30);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (29, 'Daily',163);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (29, 'Daily',30);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (39, 'Month',124);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (39, 'Month',126);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (39, 'Week',124);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (39, 'Week',126);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (42, 'Yes',98);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (433, 'Apple fiber', 434);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (433, 'Functional food (e.g. chia seeds, wheat bran)', 434);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (433, 'I take a supplement, but do not know what kind', 434);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (433, 'Inulin (e.g. Fiber Choice)', 434);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (433, 'Methylcellulose (e.g. Citrucel)', 434);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (433, 'Oat fiber', 434);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (433, 'Other', 434);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (433, 'Psyllium (e.g. Metamucil)', 434);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (433, 'Wheat dextrin (e.g. Benefiber)', 434);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (49, 'Yes',99);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (53, 'Yes', 415);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (6, 'Yes', 104);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (499, 'Yes', 106);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (499, 'Yes', 413);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (82, 'Diagnosed by a medical professional (doctor, physician assistant)',155);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (82, 'Diagnosed by an alternative medicine practitioner',155);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (83, 'Self-diagnosed',164);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (500, 'Yes',374);
insert into ag.survey_question_triggers (survey_question_id, triggering_response, triggered_question) values (500, 'Yes',375);


-- Add two years to existing set of valid responses for birth year.
alter table ag.survey_question_response drop constraint idx_survey_question_response;
update ag.survey_question_response set display_index = -2 where response = 'Unspecified' and survey_question_id = 112;
insert into ag.survey_question_response (survey_question_id, response, display_index) values (112, '2021', 0);
insert into ag.survey_question_response (survey_question_id, response, display_index) values (112, '2022', -1);
update ag.survey_question_response set display_index = display_index + 2 where survey_question_id = 112;
alter table only ag.survey_question_response add constraint idx_survey_question_response unique (survey_question_id, display_index);