find-chart-references

name	find-chart-references
description	Find every OWID surface that references a chart, indicator, MDIM, or explorer — articles (links vs embeds), explorers, narrative charts, data insights, static viz, key-chart slots, MDIM views. Answers "what breaks or goes stale if this changes or goes away", and distinguishes surfaces a URL redirect fixes from surfaces that render the object themselves. Read-only, pure SQL. Trigger when the user asks "what references this chart/indicator", "where is this chart embedded", "what's the blast radius of this change", "which articles link to X", "what do I have to update if I retire this chart", or when another skill needs the surface sweep (map-charts-to-mdim, check-empty-entities, check-hardcoded-years, update-dataset).
metadata	{"internal":true}

Find what references a chart, indicator, MDIM, or explorer

One question — what would break, go stale, or need editing if this object changed or went away? — asked the same way for every grapher object, so each skill that needs it stops re-deriving its own surface list.

For how to point at the right database, see query-grapher-db. Everything here is read-only SQL and needs no ADMIN_API_KEY.

The kind field is the point

Every finding carries a kind that decides what a fix costs:

kind	meaning	does a URL redirect fix it?
render	the surface resolves the object and draws it — a chart on an indicator, an MDIM view, an explorer view, a key-chart slot	n/a — the object is the content
embed	the surface holds it by id/slug and renders its config directly — article chart blocks, data insights, static viz, explorers, narrative charts pinned to an MDIM view	No. Must be migrated by hand
link	a hyperlink in prose or a raw URL	Yes — but the href is still worth updating

The discriminator for articles is posts_gdocs_links.componentType: a span-* value is a hyperlink inside body text; anything else is a block-level component that renders the chart. Skills that only count rows in posts_gdocs_links cannot tell these apart, and will report an embed as if a redirect covered it.

Usage

ENV_FILE=<creds> DATA_API_ENV=production .venv/bin/python \
  .claude/skills/find-chart-references/scripts/find_references.py \
  --chart-slugs life-expectancy,child-mortality \
  --json ai/refs.json --csv ai/refs.csv

Subjects (combinable): --chart-ids · --chart-slugs · --variable-ids · --dataset-id · --mdim <slug|catalogPath> · --explorer <slug>.

--transitive adds a second hop for indicator subjects only: after finding the charts that render an indicator, sweep the articles referencing those charts. Off by default — it multiplies the work on a widely-charted dataset. It changes nothing for a --mdim or --explorer subject (their references are all direct), and the run says so rather than letting the flag imply a wider sweep than it made.

Output rows: subject_type, subject, subject_id, surface, kind, where, where_path, surface_id, config_id, context, query_string, text, published.

Two fields carry the weight for callers:

• config_id — the surface's chart_configs.id, present for every config-bearing surface (charts, MDim views, explorer views, narrative charts). This is what lets a caller inspect configs without re-deriving any joins: a single SELECT ... FROM chart_configs WHERE id IN (...) covers charts, MDim views and explorer views alike. One exception: for a narrative chart read AdminAPI.get_narrative_chart(id)["configFull"] instead — the stored row lags a parent edit until the child is re-saved. A row with an empty config_id has no config to read: the explorer surface (as opposed to explorer view) is the fallback for an indicator registered on an explorer whose view configs never name it, and article, static-viz and key-chart rows never had one.
• query_string — the reference's own URL params (country=, time=, tab=), where article-level pins live and what makes a replacement URL reconstructable.

admin_url is the chart's editor in whichever environment was audited — a staging sweep yields staging admin links, a production sweep yields admin.owid.io (tailscale suffixes are stripped, since the short host resolves and the long one is noise). MDim views deliberately have none: they are not editable in the admin, and their fix belongs in the ETL YAML.

surface_id identifies the surface object itself (chart id, multi_dim_x_chart_configs.id, narrative chart id, explorer slug, tag id), for when you need to edit it rather than read it. For any gdoc-backed surface (articles, data insights) it is the Google Doc id — posts_gdocs.id is literally the Doc id, so https://docs.google.com/document/d/<surface_id>/edit opens the source document.

--markdown — the report to hand a human

--markdown ai/refs.md renders one table per surface, grouped by kind, so a long list stays scannable. For every article reference the table gives three ways to reach it:

• 📄 the Google Doc to edit,
• 🔎 the anchor text to search for inside that doc,
• 🔗 a scroll-to-reference link into the published article (a #:~:text= fragment, built the same way as chart_diff/citations.py:create_text_fragment_url), which opens the page scrolled to and highlighting the exact sentence.

Every row also gets a 👁 preview — the referenced view itself, as the reader sees it: the chart plus that reference's own params, or the MDIM at that view's exact dimensions. A slug alone doesn't tell you which of an MDIM's hundred views is in play, so this is what makes a row judgeable without opening the article.

Block embeds have no anchor text, so those fall back to the plain article URL.

Indicator subjects are labelled with the indicator's name (not a bare variable id), cells are truncated and pipe-escaped so the tables can't break, and drafts are marked ⚠️. For spreadsheet work use --csv, which carries the untruncated values.

Optional surfaces fail open (an absent legacy table, a subject that does not resolve): the run keeps going and prints COVERAGE GAP: ... for each, then repeats them all at the end. Read that block before reporting a result — those surfaces were not swept, so an empty answer for them means UNKNOWN, not "nothing references it". --gaps-json <path> writes the same list as JSON, which is how a wrapper carries them into its own report instead of leaving them in stdout.

Surface catalog

What is swept, per subject type. Anything not on this list is not covered — say so rather than implying full coverage.

Chart subjects (expanded to every old slug that still reaches the chart, since references written before a rename point at the old one):

surface	source	kind
articles	posts_gdocs_links (grapher, guided-chart) + linkType='url' scan	embed or link by componentType
explorers	explorer_charts (by chart id)	embed
narrative charts	narrative_charts.parentChartId	link (renders its own config)
↳ its placements	posts_gdocs_links where linkType='narrative-chart', target = the name	embed, surface gdoc (narrative chart)
data insights	posts_gdocs.content->>'$."grapher-url"'	embed
static viz	static_viz.grapherSlug	embed
key charts	chart_tags where keyChartLevel > 0	render
featured metrics	featured_metrics matched on pathname (the table is read whole)	render

Narrative charts get a second hop, always (sweep_articles_placing_narrative_charts, run over the findings after every sweep — it needs no --transitive). A narrative chart is not itself in an article; articles place it by name in a {.narrative-chart} block. So a narrative-chart row alone says what has to change and not where the change lands, and every fix for one includes an article edit. Same table and column the admin's own references endpoint reads (getNarrativeChartReferences → getPublishedLinksTo(…, ContentGraphLinkType.NarrativeChart)), with one deliberate difference: unpublished drafts are kept, because a draft referencing the name is exactly what surprises you at delete time. published rides along so a consumer can rank it below the live ones.

The placement rows carry the narrative chart as subject (not the chart that reached it), because find_in_doc falls through to subject when there is no anchor text — and the name is precisely what the ArchieML block spells out, so the search string comes out right for free. text is forced empty for the same reason.

A featured metric is the one render surface a redirect does not rescue. Like a key chart it is a topic-page slot in no reference table — but held by URL, and resolved only when Algolia indexes, matching pathname and the exact query-param map against published records. So retiring what it names empties the slot silently, and re-adding the old URL is then refused (creating a row validates that the slug resolves to something published). It must be swapped by hand, before the migration — see docs/guides/data-work/redirect-to-mdims.md.

Matching is on pathname alone, deliberately: for an MDIM or explorer the row's query string is the view, so a params-equal test would hide the rows a migration most needs to see — those whose params no longer name a live view. The params travel in query_string instead. One object can hold several rows; the key is (url, parentTagId, incomeGroup).

WordPress (posts / posts_links) is not swept, and adding it back would be a regression. Every published post there that links a chart 404s on the live site, and none of those slugs exists as a published gdoc — they are a dead mirror, not migrated content.

Indicator subjects: charts (chart_dimensions), MDIM views (multi_dim_x_chart_configs plus a config scan — that column records only the first y indicator, so multi-indicator views are invisible to the join alone), explorer views (explorer_variables narrows to the explorers involved, then each one's explorer_views → chart_configs says which of its views actually render the indicator). Explorer views are emitted one row per view, so a dataset powering a large explorer yields hundreds of rows — that is the price of every row carrying a config_id. Under --transitive, also the narrative charts parented to any chart or MDIM view that renders the indicators (parentMultiDimXChartConfigId): a narrative chart holds its own config, so skipping that hop leaves it unaudited — and the featured metrics held by those charts, which no other hop reaches.

MDIM findings are keyed by (mdim, view, indicator), not by view: one view can render several of the requested indicators, and each one is its own reference. The config scan resolves every stored indicator shape (an id, a {id: …} dict, a {catalogPath: …} dict, or a bare catalog-path string), so a view holding a catalog path is not silently skipped.

MDIM subjects: article links/embeds, narrative charts pinned to a view (parentMultiDimXChartConfigId), inbound multi_dim_redirects, and featured metrics — an MDIM's rows sit under /grapher/<slug>, the same namespace as a chart's, because multi-dims are served from /grapher/. A row with no query string names the default view.

Explorer subjects: article links/embeds (linkType='explorer') plus a linkType='url' scan, as for charts and MDIMs — an article that pastes /explorers/<slug>?… produces a url-typed row, and only that row carries the country=/time= pins the downstream audits grade. Also featured metrics, under /explorers/<slug>; an explorer's row always carries a query string, since the admin refuses one without it.

Raw-URL targets are un-wrapped before matching: a link pasted through Google Docs can arrive as google.com/url?q=<encoded> (or ?url=<encoded>), with the real URL and its parameters inside. Every raw-URL sweep keeps wrapper rows as SQL candidates and decides the path in Python, because the url= form percent-encodes its slashes and a LIKE '%/grapher/<slug>%' prefilter would drop it before it could be decoded.

Who uses this, and what stays theirs

This skill answers which surfaces reference the object. It deliberately does not interpret them — each caller keeps the analysis only it can do:

Skill	Uses the sweep for	Keeps
check-hardcoded-years	the surface list for a dataset/indicator, plus each reference's query_string (article time= pins)	reading configs for minTime/maxTime/map.time, grading pins against the data's latest time, the where-the-fix-goes table
check-empty-entities	the same list, plus query_string (country= pins) and old-slug expansion	entity-selection vs entities-with-data checks, grading findings against production
update-dataset (step 7)	one sweep shared by both audits above	the update workflow around them
review-data-pr (§8d)	a cheap "which surfaces carry this dataset" check	judging whether the author's audit was complete
map-charts-to-mdim	the sweep for the charts being redirected	replacement URLs, redirect severity, param-collision detection
edit-faust-metadata	— (keeps blast_radius.py)	per-field inheritance analysis: which surfaces are shielded by their own patch override, which have no inheritance path. A generic sweep can't answer that

When a caller needs a surface this doesn't cover, add it here rather than locally — that's the point of the split.

Known gaps

State these when reporting; silence reads as full coverage. --markdown now ends with a Not searched section carrying this list plus the limits of that particular run (no --transitive hop, excluded 'All charts' entries) — keep the two in step, and still state them yourself when you report on a --json/--csv run.

Optional surfaces fail open: an absent legacy table or a subject that does not resolve prints COVERAGE GAP: …, is repeated at the end of the run, leads the report's Not searched section, and is available as JSON via --gaps-json <path> for a wrapper that builds its own report. An empty answer for one of those surfaces means UNKNOWN, not "nothing references it".

• Non-ETL explorers whose config lives in the explorers TSV are not parsed.
• Legacy CSV-backed explorers (data://explorers/... wide tables — e.g. the poverty explorer) appear in no DB table: their data and selections live in the explorer TSV, outside grapher configs. Report them as a coverage caveat rather than letting them pass silently.
• linkType='url' rows pointing at archive.ourworldindata.org are dropped as frozen by design. As of 2026-07 every url-typed grapher row was an archive snapshot — don't bet an audit on that classification continuing to hold.
• Indicator-level presentation.grapher_config lives in garden/grapher .meta.yml, not the DB. It is invisible here and needs a repo grep, and it fans out to every thin MDim/explorer view that inherits it.
• Data insights are matched on grapher-url; one storing the reference elsewhere is missed.
• Article sweeps cover what posts_gdocs_links recorded — charts nested inside layout containers may not produce a row.
• Public Datasette's posts_gdocs_links lags; verify article fixes against the live page, not the mirror.

Notes for skills that consume this

• A narrative chart survives its parent chart being unpublished. It owns a materialized full config written at creation and renders from that; the parent is joined in only to build the "Explore the data" href from its slug. So it is a link, not an embed, and a redirect covers it — don't gate a migration on it. Do check the href's query params, which ride along to the target. There is still no API to repoint a narrative chart (parentChartId/parentMultiDimXChartConfigId are written only at creation — updateNarrativeChart reads both off the existing row), so the parent pointer stays stale. That matters for a narrative chart pinned to an MDIM view — that one is a genuine embed, and it can block the MDIM's next re-publish via an unguarded FK.
• Only an MDIM can spawn a narrative chart through the UI. Never tell anyone to use a chart's "Create narrative chart" control: CreateNarrativeChartEditorPage returns NotFoundPage unless type === "multiDim", and the site-side affordance is gated on manager.adminCreateNarrativeChartPath, set only by site/multiDim/MultiDim.tsx and MultiDimDataPageContent.tsx. The POST route does accept {"type": "chart", "parentChartId": …}, so for a chart parent the API is the only path — there is no click-path to it at all.
• A chart redirect's target_query_param merges with the incoming query key by key, the incoming side winning per key. A reference's params cost the reader exactly the stored keys they collide with. Verified on production 2026-08-14 with a distinguishing pair — global-forestry-area-1958-2014 → forest-area-km?tab=line sends a bare ?country=~FRA on to ?tab=line&country=%7EFRA (stored tab=line SURVIVES), and ?tab=map&country=~FRA on to ?tab=map&country=%7EFRA (incoming tab wins). A test whose query sets every stored key cannot tell merge from wholesale replacement — an earlier version of this note concluded "wholesale" from exactly that. Staging's serving layer and a fresh row's first-week static 302 both behave differently (stored query wins, visitor params dropped — both verified live 2026-08-14). Do not generalize from functions/_common/redirectTools.ts: its explorer path also merges per key but with the TARGET winning — the opposite winner, and a different code path. MDIM dimension collisions are the same question — compare each reference's against the target's dimension slugs — but the answer is stronger than "the reference overrides that one key": it discards the target's whole query.

Lessons

When a run reveals a surface this catalog misses, add it here — this file is the shared list, and a gap fixed here fixes it for every skill that reads it.