SDG coding of museum exhibitions and monthly audience-interest indicators (TripAdvisor, visitors), Mar 2017–Sep 2025
Description
This dataset contains source materials and derived data used in a monthly analysis linking SDG-related exhibition content to audience-interest indicators. The temporal coverage is March 2017 – September 2025 (103 monthly observations). The unit of observation is an exhibition (N=61) for the coding materials and a month for the analytical dataset. Files: exhibition codes.pdf – SDG coding for 61 exhibitions (Exhibition 1–Exhibition 61) across 17 SDGs (SDG1–SDG17) on a 0–2 scale, provided in two versions: “my code (0–2)” and “museum staff member’s code (0–2)”. SDGs.pdf – exhibition scheduling and SDG aggregation over time: scheduling section: exhibition list (EXHIBITION, TIME) plus an exhibition–month matrix where 1 indicates the exhibition was on display (blank cells = not on display); aggregation section: monthly indicators for 11 SDGs (SDG3, SDG4, SDG5, SDG9, SDG10, SDG11, SDG12, SDG13, SDG15, SDG16, SDG17) including SUM of all exhibitions and, for each SDG: no. of exhibitions, mean_SDG, sum_SDG, share_SDG, mean_SDG_pos, any_SDG. OLS.xlsx – regression-ready monthly dataset: includes TripAdvisor_rating, TripAdvisor_reviews, log transforms (ln(reviews), ln(visitors+1)), visitors, exhibition counts (n_exhibitions, no_exhibitions), SDG indicators (mean_/sum_/share_/mean_*pos/any), and controls: COVID, open_museum, season (1 = tourist season; 0 = off-season), trend; sheet provides an auxiliary working extract of selected SDG shares (share_SDG4 / share_SDG10 / share_SDG11 / share_SDG15 / share_SDG16).
Files
Institutions
- Akademia Wychowania Fizycznego i Sportu im Jedrzeja Sniadeckiego w Gdansku