Help us improve
Share bugs, ideas, or general feedback.
Produces step-by-step navigation guides for public databases (Eurostat, WHO, World Bank) to find, filter, and download data tailored to a story angle.
npx claudepluginhub ur-grue/autopunk-media-skills --plugin autopunk-media-skillsHow this skill is triggered — by the user, by Claude, or both
Slash command
/autopunk-media-skills:public-database-guideThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Produces a step-by-step guide — tailored to a journalist's specific story angle — for finding, filtering, and downloading the right data from a named public database.
Finds the authoritative official source for any statistical indicator, including where to get the latest figures and what to watch for.
Queries public statistical data from Data Commons (demographics, economics, health, environment) via the Python API v2. Use for population, GDP, unemployment, disease prevalence, and geographic entity resolution.
Queries official Stats NZ data including CPI, GDP, population estimates/projections, migration, and CSV catalogue via CLI without API keys or authentication.
Share bugs, ideas, or general feedback.
Produces a step-by-step guide — tailored to a journalist's specific story angle — for finding, filtering, and downloading the right data from a named public database.
Required: The name of the database (e.g., "Eurostat", "WHO Global Health Observatory", "World Bank Open Data") and what data you are looking for (topic, indicator name, country or region, and approximate date range).
Optional: The format you need the data in (CSV, Excel, JSON, API); the geographic level of detail required (national, regional, city-level); any known indicator codes you have already found; your publication's preferred citation style.
A numbered navigation guide of 400–700 words, written in plain English. Structured as: (1) a one-paragraph orientation to the database section, (2) step-by-step navigation instructions, (3) filter settings, (4) export instructions, (5) a short caveats and citation note. No jargon — every interface element referenced by its exact on-screen label. Suitable for forwarding directly to a researcher or junior reporter.
Database: Eurostat Data needed: Monthly unemployment rates by age group (15–24 and 25–74) for France, Germany, Spain, and the EU27 average, from January 2018 to the most recent month available. Format needed: CSV, with country labels included. Story angle: Comparing youth unemployment trends before and after the 2020 economic shock.
Where to go first
Eurostat's unemployment data lives in the "Employment and unemployment (Labour Force Survey)" section of the Statistics database. You do not need to browse the full catalogue — the fastest path is through the data browser using the indicator code below.
Navigation steps
Filter settings
Apply the following filters in order:
After applying all filters, the table should show four geographic columns and two age-group rows. If you see more rows, re-check that Sex is set to "Total" and Citizen is set to "Total".
Exporting
Click the blue "Download" button above the table. In the download dialog:
Click Download. The file will be named something like une_rt_m_1_Data.csv. Open it in your spreadsheet application to confirm all four countries and both age groups are present.
Caveats and citation