dd_id_redirects

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

2 rows

✎ View and edit SQL

This data as json, CSV (advanced)

old_dd_id ▼ new_dd_id reason merged_at unmerged_at resolution_note
DD-E-FEC-C30001663 DD-E-EIN-131084330 merge 2026-06-12T10:25:56.951181+00:00   F-2 2026-06-12: FEC electioneering registration (cmte_tp=E) of NAM c6; same legal org, divergent normalization
DD-E-LEI-549300JQK3IU3HBSGK31 DD-E-EIN-521006053 merge 2026-06-12T10:25:56.930581+00:00   F-1 2026-06-12: GLEIF twin of AdvaMed c6 (lapsed LEI reg; HQ+DE-1974 letterhead-verified in review)

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE dd_id_redirects (
    old_dd_id        TEXT PRIMARY KEY,
    new_dd_id        TEXT,
    reason           TEXT NOT NULL,
    merged_at        TEXT NOT NULL,
    unmerged_at      TEXT,
    resolution_note  TEXT,
    CHECK (new_dd_id IS NULL OR old_dd_id != new_dd_id)
);
CREATE INDEX idx_redirects_new ON dd_id_redirects(new_dd_id) WHERE new_dd_id IS NOT NULL;