0058.sql

INSERT INTO ag.survey_group (group_order, american, british) VALUES (-6, 'COVID19 Questionnaire', 'COVID19 Questionnaire');
INSERT INTO ag.surveys (survey_id, survey_group) VALUES (6, -6);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (209, 'What is your occupation?', 'What is your occupation?', 'COVID_OCCUPATION', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 209, 1);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (209, 'STRING');

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (210, 'Please think about your current level of well-being. When you think about well-being, think about your physical health, your emotional health, any challenges you are experiencing, the people in your life, and the opportunities or resources you have available to you. How would you describe your current level of well-being?', 'Please think about your current level of well-being. When you think about well-being, think about your physical health, your emotional health, any challenges you are experiencing, the people in your life, and the opportunities or resources you have available to you. How would you describe your current level of well-being?', 'COVID_LEVEL_OF_WELLBEING', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 210, 2);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (210, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (210, 'Unspecified', 0);
INSERT INTO ag.survey_response (american, british) VALUES ('Excellent', 'Excellent');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (210, 'Excellent', 1);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (210, 'Very good', 2);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (210, 'Good', 3);
INSERT INTO ag.survey_response (american, british) VALUES ('Fair', 'Fair');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (210, 'Fair', 4);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (210, 'Poor', 5);
INSERT INTO ag.survey_response (american, british) VALUES ('Very poor', 'Very poor');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (210, 'Very poor', 6);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (211, 'Have you been exposed to someone likely to have Coronavirus/COVID-19? (check all that apply)', 'Have you been exposed to someone likely to have Coronavirus/COVID-19? (check all that apply)', 'COVID_LIKELY_EXPOSURE', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 211, 3);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (211, 'MULTIPLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (211, 'Unspecified', 0);
INSERT INTO ag.survey_response (american, british) VALUES ('Yes, someone with positive test', 'Yes, someone with positive test');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (211, 'Yes, someone with positive test', 1);
INSERT INTO ag.survey_response (american, british) VALUES ('Yes, someone with medical diagnosis, but no test', 'Yes, someone with medical diagnosis, but no test');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (211, 'Yes, someone with medical diagnosis, but no test', 2);
INSERT INTO ag.survey_response (american, british) VALUES ('Yes, someone with possible symptoms, but no diagnosis by doctor', 'Yes, someone with possible symptoms, but no diagnosis by doctor');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (211, 'Yes, someone with possible symptoms, but no diagnosis by doctor', 3);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (211, 'No', 4);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (212, 'Have you been suspected of having Coronavirus/COVID-19 infection?', 'Have you been suspected of having Coronavirus/COVID-19 infection?', 'COVID_SUSPECTED_POSITIVE', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 212, 4);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (212, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (212, 'Unspecified', 0);
INSERT INTO ag.survey_response (american, british) VALUES ('Yes, with a positive test', 'Yes, with a positive test');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (212, 'Yes, with a positive test', 1);
INSERT INTO ag.survey_response (american, british) VALUES ('Yes, medical diagnosis, but no test', 'Yes, medical diagnosis, but no test');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (212, 'Yes, medical diagnosis, but no test', 2);
INSERT INTO ag.survey_response (american, british) VALUES ('Yes, have had some possible symptoms, but no diagnosis by doctor', 'Yes, have had some possible symptoms, but no diagnosis by doctor');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (212, 'Yes, have had some possible symptoms, but no diagnosis by doctor', 3);
INSERT INTO ag.survey_response (american, british) VALUES ('No symptoms or signs', 'No symptoms or signs');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (212, 'No symptoms or signs', 4);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (213, 'Please provide date', 'Please provide date', 'COVID_SUSPECTED_POSITIVE_DATE', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 213, 5);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (213, 'STRING');
INSERT INTO ag.survey_question_triggers (survey_question_id, triggered_question,  triggering_response) VALUES (212, 213, 'Yes, with a positive test');
INSERT INTO ag.survey_question_triggers (survey_question_id, triggered_question,  triggering_response) VALUES (212, 213, 'Yes, medical diagnosis, but no test');

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (214, 'Have you had any of the following symptoms? (check all that apply)', 'Have you had any of the following symptoms? (check all that apply)', 'COVID_SYMPTOMS', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 214, 6);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (214, 'MULTIPLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (214, 'Unspecified', 0);
INSERT INTO ag.survey_response (american, british) VALUES ('Fever', 'Fever');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (214, 'Fever', 1);
INSERT INTO ag.survey_response (american, british) VALUES ('Cough', 'Cough');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (214, 'Cough', 2);
INSERT INTO ag.survey_response (american, british) VALUES ('Shortness of breath', 'Shortness of breath');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (214, 'Shortness of breath', 3);
INSERT INTO ag.survey_response (american, british) VALUES ('Sore throat', 'Sore throat');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (214, 'Sore throat', 4);
INSERT INTO ag.survey_response (american, british) VALUES ('Fatigue', 'Fatigue');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (214, 'Fatigue', 5);
INSERT INTO ag.survey_response (american, british) VALUES ('Loss of taste or smell', 'Loss of taste or smell');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (214, 'Loss of taste or smell', 6);
INSERT INTO ag.survey_response (american, british) VALUES ('Chest pain or tightness in chest', 'Chest pain or tightness in chest');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (214, 'Chest pain or tightness in chest', 7);
INSERT INTO ag.survey_response (american, british) VALUES ('Diarrhea', 'Diarrhea');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (214, 'Diarrhea', 8);
INSERT INTO ag.survey_response (american, british) VALUES ('Nausea', 'Nausea');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (214, 'Nausea', 9);
INSERT INTO ag.survey_response (american, british) VALUES ('Lack of appetitie', 'Lack of appetitie');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (214, 'Lack of appetitie', 10);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (214, 'Other', 11);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (215, NULL, NULL, 'COVID_SYMPTOMS_OTHER', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 215, 7);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (215, 'TEXT');
INSERT INTO ag.survey_question_triggers (survey_question_id, triggered_question,  triggering_response) VALUES (214, 215, 'Other');

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (216, 'If yes to any symptoms above, did you stay home from work while symptomatic?', 'If yes to any symptoms above, did you stay home from work while symptomatic?', 'COVID_SYMPTOMS_STAY_HOME', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 216, 8);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (216, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (216, 'Unspecified', 0);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (216, 'Yes', 1);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (216, 'No', 2);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (217, 'Have any of the following happened to your family members because of Coronavirus/COVID-19? (check all that apply)', 'Have any of the following happened to your family members because of Coronavirus/COVID-19? (check all that apply)', 'COVID_FAMILY_MEMBERS', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 217, 9);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (217, 'MULTIPLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (217, 'Unspecified', 0);
INSERT INTO ag.survey_response (american, british) VALUES ('Fallen ill physically', 'Fallen ill physically');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (217, 'Fallen ill physically', 1);
INSERT INTO ag.survey_response (american, british) VALUES ('Hospitalized', 'Hospitalized');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (217, 'Hospitalized', 2);
INSERT INTO ag.survey_response (american, british) VALUES ('Put into self-quarantine with symptoms', 'Put into self-quarantine with symptoms');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (217, 'Put into self-quarantine with symptoms', 3);
INSERT INTO ag.survey_response (american, british) VALUES ('Put into self-quarantine without symptoms (e.g., due to possible exposure)', 'Put into self-quarantine without symptoms (e.g., due to possible exposure)');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (217, 'Put into self-quarantine without symptoms (e.g., due to possible exposure)', 4);
INSERT INTO ag.survey_response (american, british) VALUES ('Lost job', 'Lost job');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (217, 'Lost job', 5);
INSERT INTO ag.survey_response (american, british) VALUES ('Reduced ability to earn money', 'Reduced ability to earn money');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (217, 'Reduced ability to earn money', 6);
INSERT INTO ag.survey_response (american, british) VALUES ('Passed away', 'Passed away');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (217, 'Passed away', 7);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (217, 'None of the above', 8);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (218, 'How many times have you gone outside of your home for any reason including work (e.g., left your property to go to stores, parks, etc.)?', 'How many times have you gone outside of your home for any reason including work (e.g., left your property to go to stores, parks, etc.)?', 'COVID_LEFT_HOME', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 218, 10);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (218, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (218, 'Unspecified', 0);
INSERT INTO ag.survey_response (american, british) VALUES ('Not at all', 'Not at all');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (218, 'Not at all', 1);
INSERT INTO ag.survey_response (american, british) VALUES ('1-2 days per week', '1-2 days per week');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (218, '1-2 days per week', 2);
INSERT INTO ag.survey_response (american, british) VALUES ('A few days per week', 'A few days per week');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (218, 'A few days per week', 3);
INSERT INTO ag.survey_response (american, british) VALUES ('Several days per week', 'Several days per week');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (218, 'Several days per week', 4);
INSERT INTO ag.survey_response (american, british) VALUES ('Every day', 'Every day');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (218, 'Every day', 5);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (219, 'Have you used shared ride services including Lyft, Uber or alternative forms of taxi?', 'Have you used shared ride services including Lyft, Uber or alternative forms of taxi?', 'COVID_RIDESHARE', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 219, 11);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (219, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (219, 'Unspecified', 0);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (219, 'Yes', 1);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (219, 'No', 2);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (220, 'Do you have any of the following chronic conditions (check all that apply):', 'Do you have any of the following chronic conditions (check all that apply):', 'COVID_CHRONIC_CONDITIONS', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 220, 12);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (220, 'MULTIPLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Unspecified', 0);
INSERT INTO ag.survey_response (american, british) VALUES ('Seasonal allergies', 'Seasonal allergies');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Seasonal allergies', 1);
INSERT INTO ag.survey_response (american, british) VALUES ('Asthma or other lung problems', 'Asthma or other lung problems');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Asthma or other lung problems', 2);
INSERT INTO ag.survey_response (american, british) VALUES ('Heart problems', 'Heart problems');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Heart problems', 3);
INSERT INTO ag.survey_response (american, british) VALUES ('Kidney problems', 'Kidney problems');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Kidney problems', 4);
INSERT INTO ag.survey_response (american, british) VALUES ('Immune disorder', 'Immune disorder');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Immune disorder', 5);
INSERT INTO ag.survey_response (american, british) VALUES ('Diabetes or high blood sugar', 'Diabetes or high blood sugar');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Diabetes or high blood sugar', 6);
INSERT INTO ag.survey_response (american, british) VALUES ('Cancer', 'Cancer');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Cancer', 7);
INSERT INTO ag.survey_response (american, british) VALUES ('Arthritis', 'Arthritis');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Arthritis', 8);
INSERT INTO ag.survey_response (american, british) VALUES ('Frequent or very bad headaches', 'Frequent or very bad headaches');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Frequent or very bad headaches', 9);
INSERT INTO ag.survey_response (american, british) VALUES ('Epilepsy or seizures', 'Epilepsy or seizures');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Epilepsy or seizures', 10);
INSERT INTO ag.survey_response (american, british) VALUES ('Serious stomach or bowel problems', 'Serious stomach or bowel problems');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Serious stomach or bowel problems', 11);
INSERT INTO ag.survey_response (american, british) VALUES ('Serious acne or skin problems', 'Serious acne or skin problems');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Serious acne or skin problems', 12);
INSERT INTO ag.survey_response (american, british) VALUES ('Hypertension', 'Hypertension');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Hypertension', 13);
INSERT INTO ag.survey_response (american, british) VALUES ('Chronic Obstructive Pulmonary Disease (COPD)', 'Chronic Obstructive Pulmonary Disease (COPD)');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Chronic Obstructive Pulmonary Disease (COPD)', 14);
INSERT INTO ag.survey_response (american, british) VALUES ('Congestive Heart Failure', 'Congestive Heart Failure');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Congestive Heart Failure', 15);
INSERT INTO ag.survey_response (american, british) VALUES ('Atrial Fibrillation or Atrial Flutter', 'Atrial Fibrillation or Atrial Flutter');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Atrial Fibrillation or Atrial Flutter', 16);
INSERT INTO ag.survey_response (american, british) VALUES ('Heart disease / Myocardial infarction', 'Heart disease / Myocardial infarction');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Heart disease / Myocardial infarction', 17);
INSERT INTO ag.survey_response (american, british) VALUES ('Stroke', 'Stroke');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Stroke', 18);
INSERT INTO ag.survey_response (american, british) VALUES ('Any autoimmune disease', 'Any autoimmune disease');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Any autoimmune disease', 19);
INSERT INTO ag.survey_response (american, british) VALUES ('HIV', 'HIV');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'HIV', 20);
INSERT INTO ag.survey_response (american, british) VALUES ('Deep vein thrombosis', 'Deep vein thrombosis');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Deep vein thrombosis', 21);
INSERT INTO ag.survey_response (american, british) VALUES ('Pulmonary embolism', 'Pulmonary embolism');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (220, 'Pulmonary embolism', 22);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (221, 'Over the last 2 weeks, how often have you been bothered by little interest or pleasure in doing things?', 'Over the last 2 weeks, how often have you been bothered by little interest or pleasure in doing things?', 'COVID_INTEREST_PLEASURE', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 221, 13);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (221, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (221, 'Unspecified', 0);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (221, 'Not at all', 1);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (221, 'Several days per week', 2);
INSERT INTO ag.survey_response (american, british) VALUES ('More than half the days', 'More than half the days');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (221, 'More than half the days', 3);
INSERT INTO ag.survey_response (american, british) VALUES ('Nearly every day', 'Nearly every day');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (221, 'Nearly every day', 4);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (222, 'Over the last 2 weeks, how often have you been bothered by feeling down, depressed or hopeless?', 'Over the last 2 weeks, how often have you been bothered by feeling down, depressed or hopeless?', 'COVID_DEPRESSED', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 222, 14);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (222, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (222, 'Unspecified', 0);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (222, 'Not at all', 1);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (222, 'Several days per week', 2);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (222, 'More than half the days', 3);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (222, 'Nearly every day', 4);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (223, 'Over the last 2 weeks, how often have you been bothered by feeling nervous, anxious, or on edge?', 'Over the last 2 weeks, how often have you been bothered by feeling nervous, anxious, or on edge?', 'COVID_ANXIOUS', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 223, 15);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (223, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (223, 'Unspecified', 0);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (223, 'Not at all', 1);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (223, 'Several days per week', 2);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (223, 'More than half the days', 3);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (223, 'Nearly every day', 4);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (224, 'Over the last 2 weeks, how often have you been bothered by not being able to stop or control worrying?', 'Over the last 2 weeks, how often have you been bothered by not being able to stop or control worrying?', 'COVID_WORRYING', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 224, 16);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (224, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (224, 'Unspecified', 0);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (224, 'Not at all', 1);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (224, 'Several days per week', 2);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (224, 'More than half the days', 3);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (224, 'Nearly every day', 4);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (225, 'Are you involved in patient care or work in a hospital / clinic setting?', 'Are you involved in patient care or work in a hospital / clinic setting?', 'COVID_PATIENT_CARE', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 225, 17);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (225, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (225, 'Unspecified', 0);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (225, 'Yes', 1);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (225, 'No', 2);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (226, 'Have you participated in direct patient care in the past seven days?', 'Have you participated in direct patient care in the past seven days?', 'COVID_PATIENT_CARE_SEVEN_DAYS', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 226, 18);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (226, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (226, 'Unspecified', 0);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (226, 'Yes', 1);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (226, 'No', 2);
INSERT INTO ag.survey_question_triggers (survey_question_id, triggered_question,  triggering_response) VALUES (225, 226, 'Yes');

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (227, 'Have you participated in direct patient care involving a patient with confirmed COVID-19 within the past 7 days?', 'Have you participated in direct patient care involving a patient with confirmed COVID-19 within the past 7 days?', 'COVID_PATIENT_CARE_SEVEN_DAYS_CONFIRMED', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 227, 19);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (227, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (227, 'Unspecified', 0);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (227, 'Yes', 1);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (227, 'No', 2);
INSERT INTO ag.survey_question_triggers (survey_question_id, triggered_question,  triggering_response) VALUES (226, 227, 'Yes');

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (228, 'During any health care interactions with a COVID-19 patients,  how often were you able to wear PPE as recommended for the level of contact?', 'During any health care interactions with a COVID-19 patients,  how often were you able to wear PPE as recommended for the level of contact?', 'COVID_PATIENT_CARE_PPE', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 228, 20);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (228, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (228, 'Unspecified', 0);
INSERT INTO ag.survey_response (american, british) VALUES ('Always, as recommended', 'Always, as recommended');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (228, 'Always, as recommended', 1);
INSERT INTO ag.survey_response (american, british) VALUES ('Most of the time', 'Most of the time');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (228, 'Most of the time', 2);
INSERT INTO ag.survey_response (american, british) VALUES ('Occasionally', 'Occasionally');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (228, 'Occasionally', 3);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (228, 'Rarely', 4);
INSERT INTO ag.survey_question_triggers (survey_question_id, triggered_question,  triggering_response) VALUES (227, 228, 'Yes');

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (229, 'Please rate the CURRENT (i.e. LAST 2 WEEKS) SEVERITY of any difficulty falling asleep.', 'Please rate the CURRENT (i.e. LAST 2 WEEKS) SEVERITY of any difficulty falling asleep.', 'COVID_DIFFICULTY_FALLING_ASLEEP', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 229, 21);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (229, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (229, 'Unspecified', 0);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (229, 'None', 1);
INSERT INTO ag.survey_response (american, british) VALUES ('Mild', 'Mild');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (229, 'Mild', 2);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (229, 'Moderate', 3);
INSERT INTO ag.survey_response (american, british) VALUES ('Severe', 'Severe');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (229, 'Severe', 4);
INSERT INTO ag.survey_response (american, british) VALUES ('Very Severe', 'Very Severe');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (229, 'Very Severe', 5);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (230, 'Please rate the CURRENT (i.e. LAST 2 WEEKS) SEVERITY of any difficulty staying asleep.', 'Please rate the CURRENT (i.e. LAST 2 WEEKS) SEVERITY of any difficulty staying asleep.', 'COVID_DIFFICULTY_STAYING_ASLEEP', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 230, 22);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (230, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (230, 'Unspecified', 0);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (230, 'None', 1);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (230, 'Mild', 2);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (230, 'Moderate', 3);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (230, 'Severe', 4);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (230, 'Very Severe', 5);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (231, 'Please rate the CURRENT (i.e. LAST 2 WEEKS) SEVERITY of any problems waking up too early.', 'Please rate the CURRENT (i.e. LAST 2 WEEKS) SEVERITY of any problems waking up too early.', 'COVID_WAKING_UP_EARLY', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 231, 23);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (231, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (231, 'Unspecified', 0);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (231, 'None', 1);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (231, 'Mild', 2);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (231, 'Moderate', 3);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (231, 'Severe', 4);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (231, 'Very Severe', 5);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (232, 'How SATISFIED/DISSATISFIED are you with your CURRENT sleep pattern?', 'How SATISFIED/DISSATISFIED are you with your CURRENT sleep pattern?', 'COVID_SLEEP_PATTERN', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 232, 24);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (232, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (232, 'Unspecified', 0);
INSERT INTO ag.survey_response (american, british) VALUES ('Very Satisfied', 'Very Satisfied');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (232, 'Very Satisfied', 1);
INSERT INTO ag.survey_response (american, british) VALUES ('Satisfied', 'Satisfied');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (232, 'Satisfied', 2);
INSERT INTO ag.survey_response (american, british) VALUES ('Moderately Satisfied', 'Moderately Satisfied');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (232, 'Moderately Satisfied', 3);
INSERT INTO ag.survey_response (american, british) VALUES ('Dissatisfied', 'Dissatisfied');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (232, 'Dissatisfied', 4);
INSERT INTO ag.survey_response (american, british) VALUES ('Very Dissatisfied', 'Very Dissatisfied');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (232, 'Very Dissatisfied', 5);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (233, 'How NOTICEABLE to others do you think your sleep problem is in terms of impairing the quality of your life?', 'How NOTICEABLE to others do you think your sleep problem is in terms of impairing the quality of your life?', 'COVID_QUALITY_OF_LIFE', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 233, 25);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (233, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (233, 'Unspecified', 0);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (233, 'Not at all', 1);
INSERT INTO ag.survey_response (american, british) VALUES ('Noticable', 'Noticable');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (233, 'Noticable', 2);
INSERT INTO ag.survey_response (american, british) VALUES ('A Little Somewhat', 'A Little Somewhat');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (233, 'A Little Somewhat', 3);
INSERT INTO ag.survey_response (american, british) VALUES ('Much', 'Much');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (233, 'Much', 4);
INSERT INTO ag.survey_response (american, british) VALUES ('Very Much Noticable', 'Very Much Noticable');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (233, 'Very Much Noticable', 5);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (234, 'How WORRIED/DISTRESSED are you about your current sleep problem?', 'How WORRIED/DISTRESSED are you about your current sleep problem?', 'COVID_WORRIED_SLEEP', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 234, 26);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (234, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (234, 'Unspecified', 0);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (234, 'Not at all', 1);
INSERT INTO ag.survey_response (american, british) VALUES ('Worried', 'Worried');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (234, 'Worried', 2);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (234, 'A Little Somewhat', 3);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (234, 'Much', 4);
INSERT INTO ag.survey_response (american, british) VALUES ('Very Much Worried', 'Very Much Worried');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (234, 'Very Much Worried', 5);

INSERT INTO ag.survey_question (survey_question_id, american, british,  question_shortname, retired) VALUES (235, 'To what extent do you consider your sleep problem to INTERFERE with your daily functioning (e.g. daytime fatigue, mood, ability to function at work/daily chores, concentration, memory, mood, etc.) CURRENTLY?', 'To what extent do you consider your sleep problem to INTERFERE with your daily functioning (e.g. daytime fatigue, mood, ability to function at work/daily chores, concentration, memory, mood, etc.) CURRENTLY?', 'COVID_SLEEP_INTERFERENCE', 'f');
INSERT INTO ag.group_questions (survey_group, survey_question_id,  display_index) VALUES ( -6, 235, 27);
INSERT INTO ag.survey_question_response_type (survey_question_id, survey_response_type) VALUES (235, 'SINGLE');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (235, 'Unspecified', 0);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (235, 'Not at all', 1);
INSERT INTO ag.survey_response (american, british) VALUES ('Interfering', 'Interfering');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (235, 'Interfering', 2);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (235, 'A Little Somewhat', 3);
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (235, 'Much', 4);
INSERT INTO ag.survey_response (american, british) VALUES ('Very Much Interfering', 'Very Much Interfering');
INSERT INTO ag.survey_question_response (survey_question_id, response, display_index) VALUES (235, 'Very Much Interfering', 5);