cfr_sections

One row per Code of Federal Regulations section (a GovInfo CFR granule), ingested from the GovInfo API by build_cfr_sections. This is the codified, subject-organized body of federal regulations — cfr_ref/title/part/ section are the join keys back to Federal Register cfr_references_json and, transitively, to regulations.gov activity. Scope is section METADATA + CITATIONS only — the full regulatory text of each section is deliberately out of scope for this pass (it is far heavier). Requires an api.data.gov key (DATA_GOV_API_KEY); a keyless ingest run is a no-op. All columns are stored as VARCHAR. NOTE: the GovInfo traversal + field mapping await live validation with a key.

• Parquet file: cfr_sections.parquet
• Queryable via MCP query_sql: Yes

Column	Type	Description
granule_id	VARCHAR	GovInfo granule id for the section. Primary key / dedup key.
package_id	VARCHAR	GovInfo package id (the enclosing CFR title-year edition) the granule belongs to.
cfr_ref	VARCHAR	Compact CFR citation composed from title/part/section (e.g. 40-60.1). The join key to Federal Register cfr_references_json.
title	VARCHAR	CFR title number (e.g. 40).
part	VARCHAR	CFR part number within the title (e.g. 60).
section	VARCHAR	CFR section number within the part (e.g. 1). Often null for non-section granules.
heading	VARCHAR	Section heading / caption text as published by GovInfo.
structure_level	VARCHAR	GovInfo granule class / structural level (e.g. SECTION, PART, APPENDIX).
edition_year	VARCHAR	Annual CFR edition the granule was issued in (from GovInfo editionYear/dateIssued). Drives incremental freshness.
last_modified	VARCHAR	GovInfo last-modified timestamp for the granule. Drives incremental freshness alongside edition_year.
url	VARCHAR	Canonical GovInfo details/link URL for the granule.