ποΈ U.S. Congress Stock Trade Tracker (Senate)
Pricing
from $2.10 / 1,000 transaction records
Track every U.S. Senate member stock trade automatically. Clean, structured data from official disclosures β senator name, ticker, trade date, amount. Perfect for investors following congress trades & quant researchers. No PDF parsing needed.
ID
id
Required
SHA-256 of (politician, transaction_date, asset_name, amount_min, amount_max, source_id). Unique per row β changes if source_id changes.
Source document ID
source_id
Required
The source PTR's document id plus the row's ordinal within it (<doc_id>|<row_index>), or <doc_id>|fetch_failed / <doc_id>|paper / <doc_id>|parse_failed for the three placeholder kinds.
Filing ID
filing_id
Required
The filing's own document id, shared by every row and placeholder from this one filing β unlike source_id, which is per-row and therefore different for a placeholder (one row per filing) versus real transaction rows (one row per line item). Used to recognize when a later run's real rows supersede a stale placeholder for the same filing.
Content hash
content_hash
Required
SHA-256 of (politician, transaction_date, asset_name, type, amount_min, amount_max, owner) β source_id excluded. Rows sharing this within the same document are legitimate separate tranches; rows sharing it across different documents are the same real-world transaction reported twice. Never used to drop or merge rows β see actor README.
Filing type
filing_type
Optional
Read from the PTR's own "(Amendment N)" label. Null only when the source page didn't expose a label β never inferred from duplicate documents.
Amendment number
amendment_number
Optional
The N in "(Amendment N)". Null for originals and for anything the source doesn't label.
Row index in filing
row_index_in_filing
Optional
0-based position of this row among its filing's parsed data rows, in source order. Tells apart identical rows inside one filing (which share a content_hash). Not part of id or content_hash. 0 on a placeholder row (a filing's only row).
Supersedes filing ID
supersedes_filing_id
Optional
On an amendment's rows: the filing_id of the earlier filing by the same filer that this amendment re-lists trades from (shares at least one identical trade with). The Senate source exposes no explicit amends-link, so this is only set where the shared trades make it determinable; otherwise null.
Is superseded
is_superseded
Optional
True on the remaining rows of a filing that a later amendment supersedes by the rule described under supersedes_filing_id.
Parse status
parse_status
Required
'ok' for a normally-parsed row. 'fetch_failed' means the detail-page fetch itself failed after retries β the filing's content was never examined; transient, superseded automatically once a later run's fetch succeeds for the same filing. 'scanned_unparsed' means this filing was submitted on paper β Senate EFD serves it as a scanned image/PDF at /search/view/paper//, not the structured HTML table electronic PTRs get, and there is no OCR fallback. 'parse_failed' means the /ptr// page fetched successfully but had zero parseable table rows β a parser bug or a Senate EFD layout change. Every non-'ok' status is a placeholder row: every transaction-detail field (transaction_date, ticker, asset_name, asset_type, asset_subtype, type, amount_min, amount_max, owner) is null, and pdf_url points at the filing's detail page. No filing is ever silently dropped from output.
Source PDF URL
pdf_url
Optional
Populated only on a placeholder row (fetch_failed/scanned_unparsed/parse_failed), pointing at the filing's detail page (no per-row PDF exists on this source). Null on every normally-parsed row β Senate's electronic PTR source is an HTML page, not a per-row PDF.
Fetched at
fetchedAt
Required
ISO 8601 UTC timestamp of when this row was first pulled from source. Immutable once set β a re-fetch of an unchanged row never updates it. If the source later revises this filing row, the new row carries this timestamp forward from the prior version, so 'first seen' survives the revision.
Last modified at
lastModifiedAt
Required
ISO 8601 UTC timestamp of when this row's content was last observed to change. Equals fetchedAt for a first-seen row.
Revision count
revisionCount
Required
Number of content revisions detected for this source document/row lineage. 0 for a first-seen row; incremented each time the source republishes this row with different content.
Politician
politician
Required
Filer name as it appears on the Senate disclosure. Paper filings arrive from the source in ALL CAPS and are re-cased to match electronic ones (see politician_raw).
Politician (raw)
politician_raw
Optional
The filer name exactly as the Senate listing printed it, before any casing normalization.
Member bioguide ID
member_bioguide_id
Optional
Bioguide id from unitedstates/congress-legislators, resolved from the filer name. Null when the filer is not a current senator or the name matches more than one β never guessed.
Transaction date
transaction_date
Required
ISO date (YYYY-MM-DD) when the trade was executed. Null on any placeholder row (fetch_failed/scanned_unparsed/parse_failed) β see parse_status.
Filing date
filing_date
Required
ISO date (YYYY-MM-DD) when the PTR was filed with the Senate.
Ticker
ticker
Optional
Stock ticker as given by the source, cleaned of artifacts. Null when the source omits it (often for bonds, municipal securities, private/LLC holdings, structured notes, and some stocks and ADRs) or gave a company-name abbreviation instead of a ticker. Never guessed or looked up. On an Exchange row this is the GIVEN asset's ticker (the asset asset_name leads with); the received asset's is in received_ticker.
Asset name
asset_name
Required
Full asset description as reported on the PTR. Null on any placeholder row (fetch_failed/scanned_unparsed/parse_failed).
Received ticker
received_ticker
Optional
Exchange rows only (null otherwise): the ticker of the asset RECEIVED in the exchange, from the source's ticker cell ("-- AMCR" = no given ticker, received AMCR) or from a ticker stated in the asset_name text. Null when the source gives none.
Received asset name
received_asset_name
Optional
Exchange rows only (null otherwise): the description of the asset received, parsed from asset_name's " (Exchanged) (Received)" form, without its leading "TICKER - ". Null when the "(Exchanged)" marker is missing.
Asset type
asset_type
Required
Senate EFD asset classification. Null on any placeholder row (fetch_failed/scanned_unparsed/parse_failed).
Asset subtype
asset_subtype
Optional
Derived from asset_name, only when asset_type is 'Stock': Senate's own asset-type checkboxes have no ETF/mutual-fund option, so filers commonly mark those as 'Stock'. 'ETF' when asset_name contains the word 'ETF'; 'Mutual Fund' when it contains 'Fund' (optionally preceded by 'Mutual' or 'Index'). Null for every other asset_type (e.g. 'Other', 'Non-Public Stock') β there, the source's own label is treated as more reliable than a name-text guess. Also null on any placeholder row (fetch_failed/scanned_unparsed/parse_failed).
Trade type
type
Required
Normalized to 'buy' (Purchase), 'sell' (Sale Full / Sale Partial), or 'exchange' (an asset swap, e.g. a called security or merger conversion β reported by the source as its own transaction type, not a buy or sell). Null on any placeholder row (fetch_failed/scanned_unparsed/parse_failed).
Amount lower bound
amount_min
Required
Lower bound of the reported amount range, in USD. Usually a whole dollar disclosure bracket, but a single exact-amount disclosure can carry cents (e.g. 2722.5). Null on any placeholder row (fetch_failed/scanned_unparsed/parse_failed).
Amount upper bound
amount_max
Optional
Upper bound of the reported amount range, in USD. Usually a whole dollar disclosure bracket, but a single exact-amount disclosure can carry cents (e.g. 2722.5). Null for unbounded 'Over $X' brackets, and on any placeholder row (fetch_failed/scanned_unparsed/parse_failed).
Owner
owner
Required
Account owner classification per STOCK Act. Null on any placeholder row (fetch_failed/scanned_unparsed/parse_failed).
