关于“透過 BigQuery 建構資料倉儲：挑戰實驗室”的评价

Mahesh S. · 评论about 1 year之前

Rose Belinda M. · 评论about 1 year之前

To Q. · 评论about 1 year之前

Aslam thowfik. S 2. · 评论about 1 year之前

ADITI SANJAY P. · 评论about 1 year之前

Nice!

Chaitanya D. · 评论about 1 year之前

Doli Clem R. · 评论about 1 year之前

Quika S. · 评论about 1 year之前

Hendy A. · 评论about 1 year之前

Doli Clem R. · 评论about 1 year之前

Doli Clem R. · 评论about 1 year之前

Allan M. · 评论about 1 year之前

Sakshi A. · 评论about 1 year之前

Dawn B. · 评论about 1 year之前

First task was wrong, because 1080 days means all the partitions are already expired, so the first task is literally impossible without changing the date manually CREATE TABLE IF NOT EXISTS `qwiklabs-gcp-02-04b751bfd3a1.covid.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.") ) PARTITION BY date OPTIONS(partition_expiration_days=1080); INSERT INTO `qwiklabs-gcp-02-04b751bfd3a1.covid.oxford_policy_tracker` (country_name , alpha_3_code , region_name , region_code , date , school_closing , school_closing_flag , school_closing_notes , workplace_closing , workplace_closing_flag , workplace_closing_notes , cancel_public_events , cancel_public_events_flag , cancel_public_events_notes , restrictions_on_gatherings , restrictions_on_gatherings_flag , restrictions_on_gatherings_notes , close_public_transit , close_public_transit_flag , close_public_transit_notes , stay_at_home_requirements , stay_at_home_requirements_flag , stay_at_home_requirements_notes , restrictions_on_internal_movement , restrictions_on_internal_movement_flag , restrictions_on_internal_movement_notes , international_travel_controls , international_travel_controls_notes , income_support , income_support_flag , income_support_notes , debt_contract_relief , debt_contract_relief_notes , fiscal_measures , fiscal_measures_notes , international_support , international_support_notes , public_information_campaigns , public_information_campaigns_flag , public_information_campaigns_notes , testing_policy , testing_policy_notes , contact_tracing , contact_tracing_notes , emergency_healthcare_investment , emergency_healthcare_investment_notes , vaccine_investment , vaccine_investment_notes , misc_wildcard , misc_wildcard_notes , confirmed_cases , deaths , stringency_index) (SELECT country_name , alpha_3_code , region_name , region_code , DATE_ADD(date, INTERVAL 500 DAY) as date , school_closing , school_closing_flag , school_closing_notes , workplace_closing , workplace_closing_flag , workplace_closing_notes , cancel_public_events , cancel_public_events_flag , cancel_public_events_notes , restrictions_on_gatherings , restrictions_on_gatherings_flag , restrictions_on_gatherings_notes , close_public_transit , close_public_transit_flag , close_public_transit_notes , stay_at_home_requirements , stay_at_home_requirements_flag , stay_at_home_requirements_notes , restrictions_on_internal_movement , restrictions_on_internal_movement_flag , restrictions_on_internal_movement_notes , international_travel_controls , international_travel_controls_notes , income_support , income_support_flag , income_support_notes , debt_contract_relief , debt_contract_relief_notes , fiscal_measures , fiscal_measures_notes , international_support , international_support_notes , public_information_campaigns , public_information_campaigns_flag , public_information_campaigns_notes , testing_policy , testing_policy_notes , contact_tracing , contact_tracing_notes , emergency_healthcare_investment , emergency_healthcare_investment_notes , vaccine_investment , vaccine_investment_notes , misc_wildcard , misc_wildcard_notes , confirmed_cases , deaths , stringency_index FROM `bigquery-public-data.covid19_govt_response.oxford_policy_tracker` WHERE alpha_3_code NOT IN ('GBR', 'BRA', 'CAN', 'USA'));

Philip M. · 评论about 1 year之前

Prameela A. · 评论about 1 year之前

vanshika s. · 评论about 1 year之前

:((

Dawn B. · 评论about 1 year之前

Fuck this lab. Progress is not been done. Or checked,

Meetrajsinh P. · 评论about 1 year之前

Ladani N. · 评论about 1 year之前

Erik Feri F. · 评论about 1 year之前

vanshika s. · 评论about 1 year之前

:((

Dawn B. · 评论about 1 year之前

:((

Dawn B. · 评论about 1 year之前

Dawn B. · 评论about 1 year之前