search

owid / etl

A compute graph for loading and transforming OWID's data
https://docs.owid.io/projects/etl
MIT License
83 stars 22 forks source link

📊 tourism: UNWTO supplementary datasets #3178

Closed veronikasamborska1994 closed 2 months ago

owidbot commented 2 months ago
Quick links (staging server): Site Admin Wizard

Login: ssh owid@staging-site-unwto-suppl

chart-diff: ✅
  • 2/2 reviewed charts
    • Modified: 2/2
    • New: 0/0
data-diff: ❌ Found differences ```diff + Dataset garden/biodiversity/2024-08-12/invasive_species + + Table invasive_species + + Column birds + + Column fishes + + Column insects + + Column mammals + + Column molluscs + + Column vascular_plants + + Column all + + Column bryophytes + + Column algae + + Column reptiles + + Column amphibians + + Column crustaceans + + Column arachnids + + Column invertebrates__excl__arthropods__molluscs + + Column fungi + + Column bacteria_and_protozoans + + Column birds_cumulative + + Column fishes_cumulative + + Column insects_cumulative + + Column mammals_cumulative + + Column molluscs_cumulative + + Column vascular_plants_cumulative + + Column all_cumulative + + Column bryophytes_cumulative + + Column algae_cumulative + + Column reptiles_cumulative + + Column amphibians_cumulative + + Column crustaceans_cumulative + + Column arachnids_cumulative + + Column invertebrates__excl__arthropods__molluscs_cumulative + + Column fungi_cumulative + + Column bacteria_and_protozoans_cumulative = Dataset garden/oecd/2024-08-21/co2_air_transport = Table co2_air_transport ~ Column int_inb_out_per_capita (changed metadata) + + url: https://www.unwto.org/copyright ~ Column int_inb_out_tot (changed metadata) + + url: https://www.unwto.org/copyright = Dataset garden/tourism/2024-08-17/unwto = Table unwto ~ Column business_personal_ratio (changed metadata) + + url: https://www.unwto.org/copyright ~ Column dom_tour_accom_hotels_and_similar_estab_guests (changed metadata) + + url: https://www.unwto.org/copyright ~ Column dom_tour_accom_hotels_and_similar_estab_ovn (changed metadata) + + url: https://www.unwto.org/copyright ~ Column dom_tour_accom_total_guests (changed metadata) + + url: https://www.unwto.org/copyright ~ Column dom_tour_accom_total_ovn (changed metadata) + + url: https://www.unwto.org/copyright ~ Column dom_tour_trips_ovn_vis_tourists (changed metadata) + + url: https://www.unwto.org/copyright ~ Column dom_tour_trips_ovn_vis_tourists_per_person (changed metadata) + + url: https://www.unwto.org/copyright ~ Column dom_tour_trips_same_day_vis_excur (changed metadata) + + url: https://www.unwto.org/copyright ~ Column dom_tour_trips_same_day_vis_excur_per_1000 (changed metadata) + + url: https://www.unwto.org/copyright ~ Column dom_tour_trips_total (changed metadata) + + url: https://www.unwto.org/copyright ~ Column employment_accom_services_for_vis_hotels_and_similar_estab (changed metadata) + + url: https://www.unwto.org/copyright ~ Column employment_food_and_beverage_serving_act (changed metadata) + + url: https://www.unwto.org/copyright ~ Column employment_food_and_beverage_serving_act_per_1000 (changed metadata) + + url: https://www.unwto.org/copyright ~ Column employment_other_accom_services (changed metadata) + + url: https://www.unwto.org/copyright ~ Column employment_other_tour_ind (changed metadata) + + url: https://www.unwto.org/copyright ~ Column employment_passenger_trans (changed metadata) + + url: https://www.unwto.org/copyright ~ Column employment_total (changed metadata) + + url: https://www.unwto.org/copyright ~ Column employment_total_per_1000 (changed metadata) + + url: https://www.unwto.org/copyright ~ Column employment_travel_agencies_and_other_reservatio_services_act (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_accom_hotels_and_similar_estab_guests (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_accom_hotels_and_similar_estab_ovn (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_accom_total_guests (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_accom_total_ovn (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_arrivals_of_which_cruise_pass (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_arrivals_ovn_vis_tourists (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_arrivals_ovn_vis_tourists_per_1000 (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_arrivals_same_day_vis_excur (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_arrivals_same_day_vis_excur_per_1000 (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_arrivals_total (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_exp_passenger_transport (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_exp_the_country (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_exp_travel (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_purpose_business_and_prof (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_purpose_personal (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_purpose_total (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_regions_africa (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_regions_americas (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_regions_east_asia_and_the_pacific (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_regions_europe (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_regions_middle_east (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_regions_of_which_nat_res_abroad (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_regions_other_not_class (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_regions_south_asia (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_regions_total (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_transport_air (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_transport_land (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_transport_total (changed metadata) + + url: https://www.unwto.org/copyright ~ Column in_tour_transport_water (changed metadata) + + url: https://www.unwto.org/copyright ~ Column inbound_outbound_tourism (changed metadata) + + url: https://www.unwto.org/copyright ~ Column inbound_ppp_cpi_adj_2021 (changed metadata) + + url: https://www.unwto.org/copyright ~ Column inbound_tourism_by_region (changed metadata) + + url: https://www.unwto.org/copyright ~ Column out_tour_departures_ovn_vis_tourists (changed metadata) + + url: https://www.unwto.org/copyright ~ Column out_tour_departures_ovn_vis_tourists_per_1000 (changed metadata) + + url: https://www.unwto.org/copyright ~ Column out_tour_departures_same_day_vis_excur (changed metadata) + + url: https://www.unwto.org/copyright ~ Column out_tour_departures_total (changed metadata) + + url: https://www.unwto.org/copyright ~ Column out_tour_exp_in_other_countries (changed metadata) + + url: https://www.unwto.org/copyright ~ Column out_tour_exp_passenger_transport (changed metadata) + + url: https://www.unwto.org/copyright ~ Column out_tour_exp_travel (changed metadata) + + url: https://www.unwto.org/copyright ~ Column outbound_exp_us_cpi_adjust (changed metadata) + + url: https://www.unwto.org/copyright ~ Column same_day_tourist_ratio (changed metadata) + + url: https://www.unwto.org/copyright ~ Column tour_ind_avail_cap_bed_places_per_1000_inhabitans (changed metadata) + + url: https://www.unwto.org/copyright ~ Column tour_ind_avg_length_of_stay (changed metadata) + + url: https://www.unwto.org/copyright ~ Column tour_ind_num_of_bed_places (changed metadata) + + url: https://www.unwto.org/copyright ~ Column tour_ind_num_of_estab (changed metadata) + + url: https://www.unwto.org/copyright ~ Column tour_ind_num_of_rooms (changed metadata) + + url: https://www.unwto.org/copyright ~ Column tour_ind_occ_rate_bed_places (changed metadata) + + url: https://www.unwto.org/copyright ~ Column tour_ind_occ_rate_rooms (changed metadata) + + url: https://www.unwto.org/copyright + Dataset garden/tourism/2024-08-17/unwto_environment + + Table unwto_environment + + Column seea_tables + + Column tsa_tables + + Column total_tables + Dataset garden/tourism/2024-08-17/unwto_gdp + + Table unwto_gdp + + Column tourism_share_gdp Legend: +New ~Modified -Removed =Identical Details Hint: Run this locally with etl diff REMOTE data/ --include yourdataset --verbose --snippet ``` Automatically updated datasets matching _weekly_wildfires|excess_mortality|covid|fluid|flunet|country_profile|garden/ihme_gbd/2019/gbd_risk_ are not included

Edited: 2024-08-23 12:22:14 UTC Execution time: 14.72 seconds