Build a Data Warehouse with BigQuery: Challenge Lab Reviews

AMAZING

MAWERICK G. · Reviewed أكثر من 4 سنوات ago

Kevin M. · Reviewed أكثر من 4 سنوات ago

Kevin M. · Reviewed أكثر من 4 سنوات ago

Very challenging

Katia V. · Reviewed أكثر من 4 سنوات ago

Francesco G. · Reviewed أكثر من 4 سنوات ago

Shin Tien H. · Reviewed أكثر من 4 سنوات ago

Meiyalagan K. · Reviewed أكثر من 4 سنوات ago

Katia V. · Reviewed أكثر من 4 سنوات ago

Saylock N. · Reviewed أكثر من 4 سنوات ago

Karthic K. · Reviewed أكثر من 4 سنوات ago

Paula Andrea B. · Reviewed أكثر من 4 سنوات ago

sanju c. · Reviewed أكثر من 4 سنوات ago

Kevin M. · Reviewed أكثر من 4 سنوات ago

Dharmesh G. · Reviewed أكثر من 4 سنوات ago

Hey People! I'm dissapointed because of all the errors appeared in the other labs. I would like an explanation of how I'm not partitioning and how I dont have the same columns If i queried the DDL of the oxford table, and mine and oxford one have the same 53 columns with My partitioned table. Please show me how I'm wrong. I can send the used queries: ``` SELECT table_name, ddl FROM `bigquery-public-data`.covid19_govt_response.INFORMATION_SCHEMA.TABLES WHERE table_name="oxford_policy_tracker"; /* CREATE TABLE `bigquery-public-data.covid19_govt_response.oxford_policy_tracker` ( country_name STRING OPTIONS(description="Name of the country"), alpha_3_code STRING OPTIONS(description="3-letter alpha code abbreviation of the country/region. See `bigquery-public-data.utility_us.country_code_iso` for more details"), region_name STRING OPTIONS(description="Name of the region within the country"), region_code STRING OPTIONS(description="Code of the region within the country"), date DATE OPTIONS(description="Date of the measured policy action status"), school_closing STRING OPTIONS(description="C1 - Ordinal scale record closings of schools and universities; 0 - No measures 1 - recommend closing 2 - Require closing (only some levels or categories, eg just high school, or just public schools) 3 - Require closing all levels No data - blank"), school_closing_flag STRING OPTIONS(description="Are C1 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), school_closing_notes STRING OPTIONS(description="Additional details about C1 policy actions"), workplace_closing STRING OPTIONS(description="C2 - Ordinal scale record closings of workplace; 0 - No measures 1 - recommend closing (or work from home) 2 - require closing (or work from home) for some sectors or categories of workers 3 - require closing (or work from home) all-but-essential workplaces (eg grocery stores, doctors) No data - blank"), workplace_closing_flag STRING OPTIONS(description="Are C2 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), workplace_closing_notes STRING OPTIONS(description="Additional details about C2 policy actions"), cancel_public_events STRING OPTIONS(description="C3 - Ordinal scale record cancellations of public events;0- No measures 1 - Recommend cancelling 2 - Require cancelling No data - blank"), cancel_public_events_flag STRING OPTIONS(description="Are C3 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), cancel_public_events_notes STRING OPTIONS(description="Additional details about C3 policy actions"), restrictions_on_gatherings STRING OPTIONS(description="C4 - Ordinal scale to record the cut-off size for bans on private gatherings; 0 - No restrictions 1 - Restrictions on very large gatherings (the limit is above 1000 people) 2 - Restrictions on gatherings between 100-1000 people 3 - Restrictions on gatherings between 10-100 people 4 - Restrictions on gatherings of less than 10 people No data - blank"), restrictions_on_gatherings_flag STRING OPTIONS(description="Are C4 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), restrictions_on_gatherings_notes STRING OPTIONS(description="Additional details about C4 policy actions"), close_public_transit STRING OPTIONS(description="C5 - Ordinal scale to record closing of public transportation; 0 - No measures 1 - Recommend closing (or significantly reduce volume/route/means of transport available) 2 - Require closing (or prohibit most citizens from using it)"), close_public_transit_flag STRING OPTIONS(description="Are C5 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), close_public_transit_notes STRING OPTIONS(description="Additional details about C5 policy actions"), stay_at_home_requirements STRING OPTIONS(description="C6 - Ordinal scale record of orders to “shelter-in- place” and otherwise confine to home."), stay_at_home_requirements_flag STRING OPTIONS(description="Are C6 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"\"), stay_at_home_requirements_notes STRING OPTIONS(description="Additional details about C6 policy actions"), restrictions_on_internal_movement STRING OPTIONS(description="C7 - Ordinal scale of restrictions on internal movement; 0 - No measures 1 - Recommend closing (or significantly reduce volume/route/means of transport) 2 - Require closing (or prohibit most people from using it)"), restrictions_on_internal_movement_flag STRING OPTIONS(description="Are C7 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), restrictions_on_internal_movement_notes STRING OPTIONS(description="Additional details about C7 policy actions"), international_travel_controls STRING OPTIONS(description="C8 - Ordinal scale record of restrictions on international travel; 0 - No measures 1 - Screening 2 - Quarantine arrivals from high-risk regions 3 - Ban on high-risk regions 4 - Total border closure No data - blank"), international_travel_controls_notes STRING OPTIONS(description="Additional details about C8 policy actions"), income_support STRING OPTIONS(description="E1 - Ordinal scale record if the government is covering the salaries or providing direct cash payments, universal basic income, or similar, of people who lose their jobs or cannot work. (Includes payments to firms if explicitly linked to payroll/ salaries)"), income_support_flag STRING OPTIONS(description="Sector scope of E1 actions; 0 - formal sector workers only 1 - transfers to informal sector workers too No data - blank"), income_support_notes STRING OPTIONS(description="Additional details about E1 policy actions"), debt_contract_relief STRING OPTIONS(description="E2 - Record if govt. is freezing financial obligations (eg stopping loan repayments, preventing services like water from stopping, or banning evictions)"), debt_contract_relief_notes STRING OPTIONS(description="Additional details about E2 policy actions"), fiscal_measures FLOAT64 OPTIONS(description="E3 - What economic stimulus policies are adopted (in USD); Record monetary value USD of fiscal stimuli, including spending or tax cuts NOT included in S10 (see below) -If none, enter 0 No data - blank Please use the exchange rate of the date you are coding, not the current date."), fiscal_measures_notes STRING OPTIONS(description="Additional details about E3 policy actions"), international_support FLOAT64 OPTIONS(description="E4 - Announced offers of COVID-19 related aid spending to other countries (in USD); Record monetary value announced if additional to previously announced spending -if none, enter 0 No data - blank Please use the exchange rate of the date you are coding, not the current date."), international_support_notes STRING OPTIONS(description="Additional details about E4 policy actions"), public_information_campaigns STRING OPTIONS(description="H1 - Ordinal scale record presence of public info campaigns; 0 -No COVID-19 public information campaign 1 - public officials urging caution about COVID-19 2 - coordinated public information campaign (e.g. across traditional and social media) No data - blank"), public_information_campaigns_flag STRING OPTIONS(description="Sector scope of H1 actions; 0 - formal sector workers only 1 - transfers to informal sector workers too No data - blank"), public_information_campaigns_notes STRING OPTIONS(description="Additional details about H1 policy actions"), testing_policy STRING OPTIONS(description="H2 - Ordinal scale record of who can get tested; 0 – No testing policy 1 – Only those who both (a) have symptoms AND (b) meet specific criteria (eg key workers, admitted to hospital, came into contact with a known case, returned from overseas) 2 – testing of anyone showing COVID-19 symptoms 3 – open public testing (eg “drive through” testing available to asymptomatic people) No data Nb we are looking for policies about testing for having an infection (PCR tests) - not for policies about testing for immunity (antibody tests)."), testing_policy_notes STRING OPTIONS(description="Additional details about H2 policy actions"), contact_tracing STRING OPTIONS(description="H3 - Ordinal scale record if governments doing contact tracing; 0 - No contact tracing 1 - Limited contact tracing - not done for all cases 2 - Comprehensive contact tracing - done for all cases No data"), contact_tracing_notes STRING OPTIONS(description="Additional details about H3 policy actions"), emergency_healthcare_investment FLOAT64 OPTIONS(description="H4 - Short-term spending on, e.g, hospitals, masks, etc in USD; Record monetary value in USD of new short-term spending on health. If none, enter 0. No data - blank Please use the exchange rate of the date you are coding, not the current date."), emergency_healthcare_investment_notes STRING OPTIONS(description="Additional details about H4 policy actions"), vaccine_investment FLOAT64 OPTIONS(description="H5 - Announced public spending on vaccine development in USD; Record monetary value in USD of new short-term spending on health. If none, enter 0. No data - blank Please use the exchange rate of the date you are coding, not the current date."), vaccine_investment_notes STRING OPTIONS(description="Additional details about H5 policy actions"), misc_wildcard STRING OPTIONS(description="M1 - Record policy announcements that do not fit anywhere else"), misc_wildcard_notes STRING OPTIONS(description="Additional details about M1 policy actions"), confirmed_cases INT64 OPTIONS(description="Number of confirmed COVID-19 cases"), deaths INT64 OPTIONS(description="Number of confirmed COVID-19 deaths"), stringency_index FLOAT64 OPTIONS(description="Used after April 28, 2020. Nine-point aggregation of the eight containment and closure indicators as well as H1 (public information campaigns). It reports a number between 0 to 100 that reflects the overall stringency of the governments response. This is a measure of how many of the these nine indicators (mostly around social isolation) a government has acted upon, and to what degree.") );*/ -- LET'S ADD THE PARTITION CREATE TABLE `qwiklabs-gcp-04-b9913df67b36.covid_535.oxford_policy_tracker_407` ( country_name STRING OPTIONS(description="Name of the country"), alpha_3_code STRING OPTIONS(description="3-letter alpha code abbreviation of the country/region. See `bigquery-public-data.utility_us.country_code_iso` for more details"), region_name STRING OPTIONS(description="Name of the region within the country"), region_code STRING OPTIONS(description="Code of the region within the country"), date DATE OPTIONS(description="Date of the measured policy action status"), school_closing STRING OPTIONS(description="C1 - Ordinal scale record closings of schools and universities; 0 - No measures 1 - recommend closing 2 - Require closing (only some levels or categories, eg just high school, or just public schools) 3 - Require closing all levels No data - blank"), school_closing_flag STRING OPTIONS(description="Are C1 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), school_closing_notes STRING OPTIONS(description="Additional details about C1 policy actions"), workplace_closing STRING OPTIONS(description="C2 - Ordinal scale record closings of workplace; 0 - No measures 1 - recommend closing (or work from home) 2 - require closing (or work from home) for some sectors or categories of workers 3 - require closing (or work from home) all-but-essential workplaces (eg grocery stores, doctors) No data - blank"), workplace_closing_flag STRING OPTIONS(description="Are C2 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), workplace_closing_notes STRING OPTIONS(description="Additional details about C2 policy actions"), cancel_public_events STRING OPTIONS(description="C3 - Ordinal scale record cancellations of public events;0- No measures 1 - Recommend cancelling 2 - Require cancelling No data - blank"), cancel_public_events_flag STRING OPTIONS(description="Are C3 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), cancel_public_events_notes STRING OPTIONS(description="Additional details about C3 policy actions"), restrictions_on_gatherings STRING OPTIONS(description="C4 - Ordinal scale to record the cut-off size for bans on private gatherings; 0 - No restrictions 1 - Restrictions on very large gatherings (the limit is above 1000 people) 2 - Restrictions on gatherings between 100-1000 people 3 - Restrictions on gatherings between 10-100 people 4 - Restrictions on gatherings of less than 10 people No data - blank"), restrictions_on_gatherings_flag STRING OPTIONS(description="Are C4 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), restrictions_on_gatherings_notes STRING OPTIONS(description="Additional details about C4 policy actions"), close_public_transit STRING OPTIONS(description="C5 - Ordinal scale to record closing of public transportation; 0 - No measures 1 - Recommend closing (or significantly reduce volume/route/means of transport available) 2 - Require closing (or prohibit most citizens from using it)"), close_public_transit_flag STRING OPTIONS(description="Are C5 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), close_public_transit_notes STRING OPTIONS(description="Additional details about C5 policy actions"), stay_at_home_requirements STRING OPTIONS(description="C6 - Ordinal scale record of orders to “shelter-in- place” and otherwise confine to home."), stay_at_home_requirements_flag STRING OPTIONS(description="Are C6 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), stay_at_home_requirements_notes STRING OPTIONS(description="Additional details about C6 policy actions"), restrictions_on_internal_movement STRING OPTIONS(description="C7 - Ordinal scale of restrictions on internal movement; 0 - No measures 1 - Recommend closing (or significantly reduce volume/route/means of transport) 2 - Require closing (or prohibit most people from using it)"), restrictions_on_internal_movement_flag STRING OPTIONS(description="Are C7 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), restrictions_on_internal_movement_notes STRING OPTIONS(description="Additional details about C7 policy actions"), international_travel_controls STRING OPTIONS(description="C8 - Ordinal scale record of restrictions on international travel; 0 - No measures 1 - Screening 2 - Quarantine arrivals from high-risk regions 3 - Ban on high-risk regions 4 - Total border closure No data - blank"), international_travel_controls_notes STRING OPTIONS(description="Additional details about C8 policy actions"), income_support STRING OPTIONS(description="E1 - Ordinal scale record if the government is covering the salaries or providing direct cash payments, universal basic income, or similar, of people who lose their jobs or cannot work. (Includes payments to firms if explicitly linked to payroll/ salaries)"), income_support_flag STRING OPTIONS(description="Sector scope of E1 actions; 0 - formal sector workers only 1 - transfers to informal sector workers too No data - blank"), income_support_notes STRING OPTIONS(description="Additional details about E1 policy actions"), debt_contract_relief STRING OPTIONS(description="E2 - Record if govt. is freezing financial obligations (eg stopping loan repayments, preventing services like water from stopping, or banning evictions)"), debt_contract_relief_notes STRING OPTIONS(description="Additional details about E2 policy actions"), fiscal_measures FLOAT64 OPTIONS(description="E3 - What economic stimulus policies are adopted (in USD); Record monetary value USD of fiscal stimuli, including spending or tax cuts NOT included in S10 (see below) -If none, enter 0 No data - blank Please use the exchange rate of the date you are coding, not the current date."), fiscal_measures_notes STRING OPTIONS(description="Additional details about E3 policy actions"), international_support FLOAT64 OPTIONS(description="E4 - Announced offers of COVID-19 related aid spending to other countries (in USD); Record monetary value announced if additional to previously announced spending -if none, enter 0 No data - blank Please use the exchange rate of the date you are coding, not the current date."), international_support_notes STRING OPTIONS(description="Additional details about E4 policy actions"), public_information_campaigns STRING OPTIONS(description="H1 - Ordinal scale record presence of public info campaigns; 0 -No COVID-19 public information campaign 1 - public officials urging caution about COVID-19 2 - coordinated public information campaign (e.g. across traditional and social media) No data - blank"), public_information_campaigns_flag STRING OPTIONS(description="Sector scope of H1 actions; 0 - formal sector workers only 1 - transfers to informal sector workers too No data - blank"), public_information_campaigns_notes STRING OPTIONS(description="Additional details about H1 policy actions"), testing_policy STRING OPTIONS(description="H2 - Ordinal scale record of who can get tested; 0 – No testing policy 1 – Only those who both (a) have symptoms AND (b) meet specific criteria (eg key workers, admitted to hospital, came into contact with a known case, returned from overseas) 2 – testing of anyone showing COVID-19 symptoms 3 – open public testing (eg “drive through” testing available to asymptomatic people) No data Nb we are looking for policies about testing for having an infection (PCR tests) - not for policies about testing for immunity (antibody tests)."), testing_policy_notes STRING OPTIONS(description="Additional details about H2 policy actions"), contact_tracing STRING OPTIONS(description="H3 - Ordinal scale record if governments doing contact tracing; 0 - No contact tracing 1 - Limited contact tracing - not done for all cases 2 - Comprehensive contact tracing - done for all cases No data"), contact_tracing_notes STRING OPTIONS(description="Additional details about H3 policy actions"), emergency_healthcare_investment FLOAT64 OPTIONS(description="H4 - Short-term spending on, e.g, hospitals, masks, etc in USD; Record monetary value in USD of new short-term spending on health. If none, enter 0. No data - blank Please use the exchange rate of the date you are coding, not the current date."), emergency_healthcare_investment_notes STRING OPTIONS(description="Additional details about H4 policy actions"), vaccine_investment FLOAT64 OPTIONS(description="H5 - Announced public spending on vaccine development in USD; Record monetary value in USD of new short-term spending on health. If none, enter 0. No data - blank Please use the exchange rate of the date you are coding, not the current date."), vaccine_investment_notes STRING OPTIONS(description="Additional details about H5 policy actions"), misc_wildcard STRING OPTIONS(description="M1 - Record policy announcements that do not fit anywhere else"), misc_wildcard_notes STRING OPTIONS(description="Additional details about M1 policy actions"), confirmed_cases INT64 OPTIONS(description="Number of confirmed COVID-19 cases"), deaths INT64 OPTIONS(description="Number of confirmed COVID-19 deaths"), stringency_index FLOAT64 OPTIONS(description="Used after April 28, 2020. Nine-point aggregation of the eight containment and closure indicators as well as H1 (public information campaigns). It reports a number between 0 to 100 that reflects the overall stringency of the governments response. This is a measure of how many of the these nine indicators (mostly around social isolation) a government has acted upon, and to what degree.") ) PARTITION BY date OPTIONS( partition_expiration_days=180 ); INSERT INTO qwiklabs-gcp-04-b9913df67b36.covid_535.oxford_policy_tracker_407 SELECT * FROM `bigquery-public-data.covid19_govt_response.oxford_policy_tracker` ori where 1=1 and ori.alpha_3_code not in ('GBR','BRA','CAN','USA'); SELECT table_name, ddl FROM `bigquery-public-data`.covid19_govt_response.INFORMATION_SCHEMA.TABLES WHERE table_name="oxford_policy_tracker"; /*DDL*/ /* CREATE TABLE `bigquery-public-data.covid19_govt_response.oxford_policy_tracker` ( country_name STRING OPTIONS(description="Name of the country"), alpha_3_code STRING OPTIONS(description="3-letter alpha code abbreviation of the country/region. See `bigquery-public-data.utility_us.country_code_iso` for more details"), region_name STRING OPTIONS(description="Name of the region within the country"), region_code STRING OPTIONS(description="Code of the region within the country"), date DATE OPTIONS(description="Date of the measured policy action status"), school_closing STRING OPTIONS(description="C1 - Ordinal scale record closings of schools and universities; 0 - No measures 1 - recommend closing 2 - Require closing (only some levels or categories, eg just high school, or just public schools) 3 - Require closing all levels No data - blank"), school_closing_flag STRING OPTIONS(description="Are C1 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), school_closing_notes STRING OPTIONS(description="Additional details about C1 policy actions"), workplace_closing STRING OPTIONS(description="C2 - Ordinal scale record closings of workplace; 0 - No measures 1 - recommend closing (or work from home) 2 - require closing (or work from home) for some sectors or categories of workers 3 - require closing (or work from home) all-but-essential workplaces (eg grocery stores, doctors) No data - blank"), workplace_closing_flag STRING OPTIONS(description="Are C2 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), workplace_closing_notes STRING OPTIONS(description="Additional details about C2 policy actions"), cancel_public_events STRING OPTIONS(description="C3 - Ordinal scale record cancellations of public events;0- No measures 1 - Recommend cancelling 2 - Require cancelling No data - blank"), cancel_public_events_flag STRING OPTIONS(description="Are C3 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), cancel_public_events_notes STRING OPTIONS(description="Additional details about C3 policy actions"), restrictions_on_gatherings STRING OPTIONS(description="C4 - Ordinal scale to record the cut-off size for bans on private gatherings; 0 - No restrictions 1 - Restrictions on very large gatherings (the limit is above 1000 people) 2 - Restrictions on gatherings between 100-1000 people 3 - Restrictions on gatherings between 10-100 people 4 - Restrictions on gatherings of less than 10 people No data - blank"), restrictions_on_gatherings_flag STRING OPTIONS(description="Are C4 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), restrictions_on_gatherings_notes STRING OPTIONS(description="Additional details about C4 policy actions"), close_public_transit STRING OPTIONS(description="C5 - Ordinal scale to record closing of public transportation; 0 - No measures 1 - Recommend closing (or significantly reduce volume/route/means of transport available) 2 - Require closing (or prohibit most citizens from using it)"), close_public_transit_flag STRING OPTIONS(description="Are C5 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), close_public_transit_notes STRING OPTIONS(description="Additional details about C5 policy actions"), stay_at_home_requirements STRING OPTIONS(description="C6 - Ordinal scale record of orders to “shelter-in- place” and otherwise confine to home."), stay_at_home_requirements_flag STRING OPTIONS(description="Are C6 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"\"), stay_at_home_requirements_notes STRING OPTIONS(description="Additional details about C6 policy actions"), restrictions_on_internal_movement STRING OPTIONS(description="C7 - Ordinal scale of restrictions on internal movement; 0 - No measures 1 - Recommend closing (or significantly reduce volume/route/means of transport) 2 - Require closing (or prohibit most people from using it)"), restrictions_on_internal_movement_flag STRING OPTIONS(description="Are C7 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), restrictions_on_internal_movement_notes STRING OPTIONS(description="Additional details about C7 policy actions"), international_travel_controls STRING OPTIONS(description="C8 - Ordinal scale record of restrictions on international travel; 0 - No measures 1 - Screening 2 - Quarantine arrivals from high-risk regions 3 - Ban on high-risk regions 4 - Total border closure No data - blank"), international_travel_controls_notes STRING OPTIONS(description="Additional details about C8 policy actions"), income_support STRING OPTIONS(description="E1 - Ordinal scale record if the government is covering the salaries or providing direct cash payments, universal basic income, or similar, of people who lose their jobs or cannot work. (Includes payments to firms if explicitly linked to payroll/ salaries)"), income_support_flag STRING OPTIONS(description="Sector scope of E1 actions; 0 - formal sector workers only 1 - transfers to informal sector workers too No data - blank"), income_support_notes STRING OPTIONS(description="Additional details about E1 policy actions"), debt_contract_relief STRING OPTIONS(description="E2 - Record if govt. is freezing financial obligations (eg stopping loan repayments, preventing services like water from stopping, or banning evictions)"), debt_contract_relief_notes STRING OPTIONS(description="Additional details about E2 policy actions"), fiscal_measures FLOAT64 OPTIONS(description="E3 - What economic stimulus policies are adopted (in USD); Record monetary value USD of fiscal stimuli, including spending or tax cuts NOT included in S10 (see below) -If none, enter 0 No data - blank Please use the exchange rate of the date you are coding, not the current date."), fiscal_measures_notes STRING OPTIONS(description="Additional details about E3 policy actions"), international_support FLOAT64 OPTIONS(description="E4 - Announced offers of COVID-19 related aid spending to other countries (in USD); Record monetary value announced if additional to previously announced spending -if none, enter 0 No data - blank Please use the exchange rate of the date you are coding, not the current date."), international_support_notes STRING OPTIONS(description="Additional details about E4 policy actions"), public_information_campaigns STRING OPTIONS(description="H1 - Ordinal scale record presence of public info campaigns; 0 -No COVID-19 public information campaign 1 - public officials urging caution about COVID-19 2 - coordinated public information campaign (e.g. across traditional and social media) No data - blank"), public_information_campaigns_flag STRING OPTIONS(description="Sector scope of H1 actions; 0 - formal sector workers only 1 - transfers to informal sector workers too No data - blank"), public_information_campaigns_notes STRING OPTIONS(description="Additional details about H1 policy actions"), testing_policy STRING OPTIONS(description="H2 - Ordinal scale record of who can get tested; 0 – No testing policy 1 – Only those who both (a) have symptoms AND (b) meet specific criteria (eg key workers, admitted to hospital, came into contact with a known case, returned from overseas) 2 – testing of anyone showing COVID-19 symptoms 3 – open public testing (eg “drive through” testing available to asymptomatic people) No data Nb we are looking for policies about testing for having an infection (PCR tests) - not for policies about testing for immunity (antibody tests)."), testing_policy_notes STRING OPTIONS(description="Additional details about H2 policy actions"), contact_tracing STRING OPTIONS(description="H3 - Ordinal scale record if governments doing contact tracing; 0 - No contact tracing 1 - Limited contact tracing - not done for all cases 2 - Comprehensive contact tracing - done for all cases No data"), contact_tracing_notes STRING OPTIONS(description="Additional details about H3 policy actions"), emergency_healthcare_investment FLOAT64 OPTIONS(description="H4 - Short-term spending on, e.g, hospitals, masks, etc in USD; Record monetary value in USD of new short-term spending on health. If none, enter 0. No data - blank Please use the exchange rate of the date you are coding, not the current date."), emergency_healthcare_investment_notes STRING OPTIONS(description="Additional details about H4 policy actions"), vaccine_investment FLOAT64 OPTIONS(description="H5 - Announced public spending on vaccine development in USD; Record monetary value in USD of new short-term spending on health. If none, enter 0. No data - blank Please use the exchange rate of the date you are coding, not the current date."), vaccine_investment_notes STRING OPTIONS(description="Additional details about H5 policy actions"), misc_wildcard STRING OPTIONS(description="M1 - Record policy announcements that do not fit anywhere else"), misc_wildcard_notes STRING OPTIONS(description="Additional details about M1 policy actions"), confirmed_cases INT64 OPTIONS(description="Number of confirmed COVID-19 cases"), deaths INT64 OPTIONS(description="Number of confirmed COVID-19 deaths"), stringency_index FLOAT64 OPTIONS(description="Used after April 28, 2020. Nine-point aggregation of the eight containment and closure indicators as well as H1 (public information campaigns). It reports a number between 0 to 100 that reflects the overall stringency of the governments response. This is a measure of how many of the these nine indicators (mostly around social isolation) a government has acted upon, and to what degree.") ); */ SELECT table_name, ddl FROM `qwiklabs-gcp-04-b9913df67b36.covid_535`.INFORMATION_SCHEMA.TABLES WHERE table_name="oxford_policy_tracker_407"; /*DDL*/ /* CREATE TABLE `qwiklabs-gcp-04-b9913df67b36.covid_535.oxford_policy_tracker_407` ( country_name STRING OPTIONS(description="Name of the country"), alpha_3_code STRING OPTIONS(description="3-letter alpha code abbreviation of the country/region. See `bigquery-public-data.utility_us.country_code_iso` for more details"), region_name STRING OPTIONS(description="Name of the region within the country"), region_code STRING OPTIONS(description="Code of the region within the country"), date DATE OPTIONS(description="Date of the measured policy action status"), school_closing STRING OPTIONS(description="C1 - Ordinal scale record closings of schools and universities; 0 - No measures 1 - recommend closing 2 - Require closing (only some levels or categories, eg just high school, or just public schools) 3 - Require closing all levels No data - blank"), school_closing_flag STRING OPTIONS(description="Are C1 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), school_closing_notes STRING OPTIONS(description="Additional details about C1 policy actions"), workplace_closing STRING OPTIONS(description="C2 - Ordinal scale record closings of workplace; 0 - No measures 1 - recommend closing (or work from home) 2 - require closing (or work from home) for some sectors or categories of workers 3 - require closing (or work from home) all-but-essential workplaces (eg grocery stores, doctors) No data - blank"), workplace_closing_flag STRING OPTIONS(description="Are C2 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), workplace_closing_notes STRING OPTIONS(description="Additional details about C2 policy actions"), cancel_public_events STRING OPTIONS(description="C3 - Ordinal scale record cancellations of public events;0- No measures 1 - Recommend cancelling 2 - Require cancelling No data - blank"), cancel_public_events_flag STRING OPTIONS(description="Are C3 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), cancel_public_events_notes STRING OPTIONS(description="Additional details about C3 policy actions"), restrictions_on_gatherings STRING OPTIONS(description="C4 - Ordinal scale to record the cut-off size for bans on private gatherings; 0 - No restrictions 1 - Restrictions on very large gatherings (the limit is above 1000 people) 2 - Restrictions on gatherings between 100-1000 people 3 - Restrictions on gatherings between 10-100 people 4 - Restrictions on gatherings of less than 10 people No data - blank"), restrictions_on_gatherings_flag STRING OPTIONS(description="Are C4 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), restrictions_on_gatherings_notes STRING OPTIONS(description="Additional details about C4 policy actions"), close_public_transit STRING OPTIONS(description="C5 - Ordinal scale to record closing of public transportation; 0 - No measures 1 - Recommend closing (or significantly reduce volume/route/means of transport available) 2 - Require closing (or prohibit most citizens from using it)"), close_public_transit_flag STRING OPTIONS(description="Are C5 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), close_public_transit_notes STRING OPTIONS(description="Additional details about C5 policy actions"), stay_at_home_requirements STRING OPTIONS(description="C6 - Ordinal scale record of orders to “shelter-in- place” and otherwise confine to home."), stay_at_home_requirements_flag STRING OPTIONS(description="Are C6 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), stay_at_home_requirements_notes STRING OPTIONS(description="Additional details about C6 policy actions"), restrictions_on_internal_movement STRING OPTIONS(description="C7 - Ordinal scale of restrictions on internal movement; 0 - No measures 1 - Recommend closing (or significantly reduce volume/route/means of transport) 2 - Require closing (or prohibit most people from using it)"), restrictions_on_internal_movement_flag STRING OPTIONS(description="Are C7 actions targeted at specific areas or general: 0 - Targeted 1- General No data - blank"), restrictions_on_internal_movement_notes STRING OPTIONS(description="Additional details about C7 policy actions"), international_travel_controls STRING OPTIONS(description="C8 - Ordinal scale record of restrictions on international travel; 0 - No measures 1 - Screening 2 - Quarantine arrivals from high-risk regions 3 - Ban on high-risk regions 4 - Total border closure No data - blank"), international_travel_controls_notes STRING OPTIONS(description="Additional details about C8 policy actions"), income_support STRING OPTIONS(description="E1 - Ordinal scale record if the government is covering the salaries or providing direct cash payments, universal basic income, or similar, of people who lose their jobs or cannot work. (Includes payments to firms if explicitly linked to payroll/ salaries)"), income_support_flag STRING OPTIONS(description="Sector scope of E1 actions; 0 - formal sector workers only 1 - transfers to informal sector workers too No data - blank"), income_support_notes STRING OPTIONS(description="Additional details about E1 policy actions"), debt_contract_relief STRING OPTIONS(description="E2 - Record if govt. is freezing financial obligations (eg stopping loan repayments, preventing services like water from stopping, or banning evictions)"), debt_contract_relief_notes STRING OPTIONS(description="Additional details about E2 policy actions"), fiscal_measures FLOAT64 OPTIONS(description="E3 - What economic stimulus policies are adopted (in USD); Record monetary value USD of fiscal stimuli, including spending or tax cuts NOT included in S10 (see below) -If none, enter 0 No data - blank Please use the exchange rate of the date you are coding, not the current date."), fiscal_measures_notes STRING OPTIONS(description="Additional details about E3 policy actions"), international_support FLOAT64 OPTIONS(description="E4 - Announced offers of COVID-19 related aid spending to other countries (in USD); Record monetary value announced if additional to previously announced spending -if none, enter 0 No data - blank Please use the exchange rate of the date you are coding, not the current date."), international_support_notes STRING OPTIONS(description="Additional details about E4 policy actions"), public_information_campaigns STRING OPTIONS(description="H1 - Ordinal scale record presence of public info campaigns; 0 -No COVID-19 public information campaign 1 - public officials urging caution about COVID-19 2 - coordinated public information campaign (e.g. across traditional and social media) No data - blank"), public_information_campaigns_flag STRING OPTIONS(description="Sector scope of H1 actions; 0 - formal sector workers only 1 - transfers to informal sector workers too No data - blank"), public_information_campaigns_notes STRING OPTIONS(description="Additional details about H1 policy actions"), testing_policy STRING OPTIONS(description="H2 - Ordinal scale record of who can get tested; 0 – No testing policy 1 – Only those who both (a) have symptoms AND (b) meet specific criteria (eg key workers, admitted to hospital, came into contact with a known case, returned from overseas) 2 – testing of anyone showing COVID-19 symptoms 3 – open public testing (eg “drive through” testing available to asymptomatic people) No data Nb we are looking for policies about testing for having an infection (PCR tests) - not for policies about testing for immunity (antibody tests)."), testing_policy_notes STRING OPTIONS(description="Additional details about H2 policy actions"), contact_tracing STRING OPTIONS(description="H3 - Ordinal scale record if governments doing contact tracing; 0 - No contact tracing 1 - Limited contact tracing - not done for all cases 2 - Comprehensive contact tracing - done for all cases No data"), contact_tracing_notes STRING OPTIONS(description="Additional details about H3 policy actions"), emergency_healthcare_investment FLOAT64 OPTIONS(description="H4 - Short-term spending on, e.g, hospitals, masks, etc in USD; Record monetary value in USD of new short-term spending on health. If none, enter 0. No data - blank Please use the exchange rate of the date you are coding, not the current date."), emergency_healthcare_investment_notes STRING OPTIONS(description="Additional details about H4 policy actions"), vaccine_investment FLOAT64 OPTIONS(description="H5 - Announced public spending on vaccine development in USD; Record monetary value in USD of new short-term spending on health. If none, enter 0. No data - blank Please use the exchange rate of the date you are coding, not the current date."), vaccine_investment_notes STRING OPTIONS(description="Additional details about H5 policy actions"), misc_wildcard STRING OPTIONS(description="M1 - Record policy announcements that do not fit anywhere else"), misc_wildcard_notes STRING OPTIONS(description="Additional details about M1 policy actions"), confirmed_cases INT64 OPTIONS(description="Number of confirmed COVID-19 cases"), deaths INT64 OPTIONS(description="Number of confirmed COVID-19 deaths"), stringency_index FLOAT64 OPTIONS(description="Used after April 28, 2020. Nine-point aggregation of the eight containment and closure indicators as well as H1 (public information campaigns). It reports a number between 0 to 100 that reflects the overall stringency of the governments response. This is a measure of how many of the these nine indicators (mostly around social isolation) a government has acted upon, and to what degree.") ) PARTITION BY date OPTIONS( partition_expiration_days=180.0 ); */ ALTER TABLE `qwiklabs-gcp-04-b9913df67b36.covid_535.oxford_policy_tracker_407` ADD COLUMN population INTEGER; ALTER TABLE `qwiklabs-gcp-04-b9913df67b36.covid_535.oxford_policy_tracker_407` ADD COLUMN country_area NUMERIC; ALTER TABLE `qwiklabs-gcp-04-b9913df67b36.covid_535.oxford_policy_tracker_407` ADD COLUMN mobility STRUCT< avg_retail NUMERIC, avg_grocery NUMERIC, avg_parks NUMERIC, avg_transit NUMERIC, avg_workplace NUMERIC, avg_residential NUMERIC >; SELECT * FROM qwiklabs-gcp-04-b9913df67b36.covid_535.oxford_policy_tracker_407; ```

Alejandro D. · Reviewed أكثر من 4 سنوات ago

this lab not worked, is so bad

Cesar V. · Reviewed أكثر من 4 سنوات ago

Shubham S. · Reviewed أكثر من 4 سنوات ago

THOMAS K. · Reviewed أكثر من 4 سنوات ago

Katarzyna Z. · Reviewed أكثر من 4 سنوات ago

Rajdeep K. · Reviewed أكثر من 4 سنوات ago

Krzysztof K. · Reviewed أكثر من 4 سنوات ago

Karol R. · Reviewed أكثر من 4 سنوات ago