Field reference
Internal columns
The columns on a grant or funder record that no page shows — identifiers, timestamps and extraction plumbing — listed so that no column is unaccounted for.
Every column on the grant and funder tables has a page in this section
except the ones listed here. Those columns exist and are not shown to anyone,
and this page is where they are accounted for.
The reason to list them rather than to leave them out: a documentation set that
covers the fields it feels like covering is a set nobody can tell is complete.
scripts/docs-check.ts reads the column list out of the Drizzle schema and
fails if any column has neither a page nor a row below, so a column added next
year is a failing check rather than an omission nobody notices.
Grant
| Column | What it is |
|---|---|
id | Primary key. Never appears in a URL; the slug does. |
funder_id | Foreign key to the funder record. The funder is shown by name and link, not by id. |
source_id | Foreign key to the feed the record came from. Which feeds are connected is published on data sources. |
source_snapshot_key | Points at the stored capture of the source page this record was built from. It is the evidence behind every claim on the record, and it is not deleted. |
source_post_id | The identifier the source portal gave the posting. Used for deduplication. |
source_fingerprint | What recognises a re-posted notice as the same notice rather than a new one. |
extraction_model | Which model read the source page. Recorded because an extraction is a claim and the thing that made it is part of the claim. |
extraction_run_id | Which run produced this version of the record. |
field_confidence | Per-field confidence from extraction. Low-confidence fields are held to the same absence rules as any other: a field we are not sure of reads Not stated rather than being shown as a hedged value. |
created_at | When the row was created here. Not when the notice was posted — that is posted_at — and not when we first saw it, which is first_seen_at. |
updated_at | When the row last changed here. Not a verification date; that is last_verified_at. |
Funder
| Column | What it is |
|---|---|
id | Primary key. |
source_id | Foreign key to the feed or dataset the funder record came from. |
merged_into_id | Set when a duplicate funder record is folded into another. The merged record is kept rather than deleted, so a link to it still resolves. |
created_at | When the row was created here. |
updated_at | When the row last changed here. |