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.

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.

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.

Grant

Funder

Table of Contents

Internal columns

Grant

Funder

Table of Contents