Data Dictionary

Schema Reference — Version 1.4.3 · July 2026

This reference covers the key tables exposed via the REST API and the Snowflake Marketplace (free live sample; full-dataset shares are enterprise-only). For methodology behind any field, see the Methodology page. Identifier convention: event_id follows TACO-{year}-{NNNN} (e.g. TACO-2025-0042). No PII is included in any published distribution.

1. Enumerations 2. taco_events 3. index_daily 4. usitc_applied_rates 5. economic_indicators 6. price_impact 7. event_sector_impacts 8. market_impact 9. fr_documents 10. event_timeline 11. regulatory_term_mentions 12. cfr_title_snapshots 13. API output shapes

1. Enumerations

domain_type

Value	Meaning
`trade`	Trade & Tariffs — import tariffs, trade deals, sanctions, export controls
`foreign_policy`	Foreign Policy — military threats, diplomatic ultimatums, alliance threats
`domestic`	Domestic Policy — executive orders, government shutdowns, personnel actions
`rhetorical`	Rhetorical — lawsuits, boycotts, social media retaliation

event_status

Value	Meaning
`detected`	AI flagged, awaiting human review
`confirmed`	Human confirmed as a PEPI event
`monitoring`	Threat made, watching for outcome
`resolved`	Outcome determined, composite score calculated
`rejected`	False positive — not a PEPI event

outcome_type — Reversal Magnitude anchor

Value	Anchor score	Meaning
`full_implementation`	0	Threat carried out as stated
`partial_implementation`	25	Implemented with material modifications
`delayed`	45	Deadline pushed back; still pending
`partial_reversal`	65	Substantial walk-back but not total
`reframed`	80	Reversal dressed up as a victory
`full_reversal`	95	Complete reversal
`abandoned`	100	Quietly dropped, never mentioned again
`indeterminate`	n/a	Non-trade event lapsed with no positive evidence (v25). Not scored; excluded from the chicken-out rate.
`pending`	n/a	Default. No outcome yet — event still monitoring.

statutory_authority (controlled vocabulary)

Token	Legal basis
`IEEPA`	International Emergency Economic Powers Act, 50 U.S.C. §§1701–1708
`Section_301`	Trade Act of 1974, §301 (unfair trade practices)
`Section_232`	Trade Expansion Act of 1962, §232 (national security)
`Section_122`	Trade Act of 1974, §122 (balance-of-payments)
`Executive_Order`	Generic EO without enumerated authority
`USMCA`	United States–Mexico–Canada Agreement
`None`	No enumerated authority (foreign-policy / rhetorical events)

2. taco_events — Core event records

Central entity. One row per PEPI event.

Field	Type	Null	Description
`event_id`	TEXT PK	N	Stable identifier: `TACO-YYYY-NNNN`
`domain`	domain_type	N	Top-level domain (see §1)
`status`	event_status	N	Lifecycle status (default `detected`)
`statutory_authority`	TEXT	Y	Legal authority invoked (see §1.5)
`confidence`	REAL	N	AI classifier confidence (0.0–1.0)
`threat_date`	TIMESTAMPTZ	N	UTC timestamp the threat was made publicly
`threat_source`	source_type	N	Channel: `truth_social`, `executive_order`, `proclamation`, `press_remarks`, …
`threat_text`	TEXT	N	Verbatim threat text
`threat_summary`	TEXT	Y	One-line human-readable summary, ≤280 chars
`target_entities`	TEXT[]	N	Countries, organizations, or persons targeted
`severity_score`	SMALLINT	Y	Initial severity 0–100 (see methodology §4.3)
`stated_deadline`	DATE	Y	Named deadline. Null = no deadline (30-pt vagueness penalty)
`outcome_date`	TIMESTAMPTZ	Y	UTC timestamp outcome was determined
`outcome_type`	outcome_type	N	Final resolution (default `pending`)
`composite_score`	REAL	Y	PEPI score 0–100. Null until resolved.
`reversal_magnitude`	REAL	Y	30% weight. 0–100.
`statutory_rate_announced`	REAL	Y	Announced tariff rate % (trade events; classifier-extracted from threat text when explicitly stated, v1.2.14)
`supersedes`	TEXT	Y	Resolved prior event this threat re-makes — cross-time lineage (v1.2.14)
`prior_reversals_count`	INTEGER	Y	Prior reversals along the lineage chain; feeds the Repetition dimension (v1.2.14)
`current_severity`	INTEGER	Y	Severity as most recently re-stated, from a follow-up statement matched to the event; feeds the Rhetorical Dilution dimension. Null until one is matched, in which case dilution contributes nothing (v1.2.17)
`final_target_count`	INTEGER	Y	Originally targeted entities the outcome still covers, judged from the resolving evidence; feeds Scope Reduction. Null when the evidence does not say (v1.2.17)
`exemption_pct`	REAL	Y	Share (0–1) of the threatened scope carved out by exemptions; feeds Scope Reduction. `0.0` means none were granted; null means the evidence is silent (v1.2.17)
`claimed_as_win`	BOOLEAN	Y	Whether the president publicly claimed credit for the outcome, from a matched action-claim statement; feeds Framing Shift (v1.2.17)
`outcome_evidence_source`	TEXT	Y	Outcome provenance: court / congress / federal_register / gemini_websearch / self_reported / none — published on every event (v1.2.14)
`applied_rate_final`	REAL	Y	Actual applied rate % from USITC DataWeb
`statutory_applied_gap`	REAL	Y	`statutory − applied` in percentage points. The PEPI score in dollar terms.
`cpi_contribution_pp`	REAL	Y	Estimated CPI contribution (pp, four-group price methodology)
`retail_passthrough_pct`	REAL	Y	Cumulative 7-month retail pass-through (%)
`consumer_burden_pct`	REAL	Y	Consumer share of tariff cost (%); remainder absorbed by firms
`market_threat_delta`	REAL	Y	S&P 500 % change on threat day
`market_outcome_delta`	REAL	Y	S&P 500 % change on outcome day
`taco_trade_return`	REAL	Y	Theoretical PEPI trade return (long threat→outcome)

3. index_daily — Daily index time series

One row per calendar day. Drives GET /api/v1/index/history.

Field	Type	Null	Description
`date`	DATE PK	N	Calendar date (UTC)
`composite_index`	REAL	N	30-day exp-weighted PEPI score (methodology §5.3)
`trade_index`	REAL	Y	Trade domain sub-index
`foreign_policy_index`	REAL	Y	Foreign-policy sub-index
`domestic_index`	REAL	Y	Domestic policy sub-index
`rhetorical_index`	REAL	Y	Rhetorical sub-index (EWMA); live from the v37 calibration seeds onward. Like every sub-index, NULL only on dates before that domain has any scored events.
`judicial_index`	REAL	Y	Judicial reaction sub-index (v1.2.15; court-tier weighting v1.2.16): 0–100 decay-weighted count of relevant court filings and court-evidenced resolutions (weight 3) in the trailing 30d. Filings are scaled by court tier (CIT 0.25, CAFC 0.6, district 0.5, regional circuit 1.0, SCOTUS 3.0; unknown court 1.0), because the CIT docket is admitted unfiltered and a flat weight made the series track trade-court throughput rather than judicial reaction; 0 = no judicial activity
`congressional_index`	REAL	Y	Congressional reaction sub-index (v1.2.15): same construction over Congress.gov bill actions on tracked bills (persisted in `congress_bill_actions`) and congress-evidenced resolutions
`active_events`	SMALLINT	Y	Events with status in (confirmed, monitoring)
`sp500_close`	REAL	Y	S&P 500 close for the day (market context; forward-filled up to 5 days over weekends/holidays; NULL before market-data coverage)

4. usitc_applied_rates — USITC DataWeb raw rows

One row per (country, HS-2 chapter, snapshot month). Rolling 3-month window, ~3,160 rows per pipeline run.

Field	Type	Null	Description
`country_iso2`	TEXT	N	ISO-2 country code (CN, MX, CA, JP, KR, VN, TW, DE, GB, FR, IT, BR, IN, TH, TR)
`hts2`	TEXT	N	HS-2 chapter (e.g. `03` = Fish & Seafood)
`snapshot_date`	DATE	N	Period end date of the USITC snapshot
`customs_value_usd`	BIGINT	Y	Import customs value in USD
`duty_collected_usd`	BIGINT	Y	Duties collected in USD
`applied_rate_pct`	REAL	Y	`duty_collected / customs_value × 100`. The effective applied tariff rate.
`fetched_at`	TIMESTAMPTZ	N	Timestamp this row was ingested from USITC DataWeb

5. economic_indicators — BLS / FRED time series

Shared table for all BLS and FRED series. UNIQUE on (series_id, observation_date). Drives GET /api/v1/economic-indicators.

Field	Type	Null	Description
`series_id`	TEXT	N	BLS or FRED series code (e.g. `CPIAUCSL`, `WPUFD4`)
`series_name`	TEXT	Y	Human-readable series name
`source`	TEXT	N	`bls` or `fred`
`unit`	TEXT	Y	Units (e.g. `index 1982-84=100`, `percent`)
`observation_date`	DATE	N	Observation period date
`value`	REAL	Y	Observed value. Null = not yet released by source.
`ingested_at`	TIMESTAMPTZ	N	Row creation timestamp

6. price_impact — Daily price impact observations

One row per (event_id, observation_date). Four-group BLS CPI proxy method. Drives GET /api/v1/events/{id}/price-impact (Premium).

Field	Type	Null	Description
`event_id`	TEXT FK	N	Parent TACO event
`observation_date`	DATE	N	Date of this price observation
`imported_affected_index`	REAL	Y	BLS index proxy for tariff-affected imports (normalized 1.0 at threat_date)
`imported_unaffected_index`	REAL	Y	Control group: exempt imports (e.g. pharma)
`domestic_affected_index`	REAL	Y	Domestic goods competing with tariffed imports
`domestic_unaffected_index`	REAL	Y	Control group: non-competing domestic goods
`imported_trend_deviation_pp`	REAL	Y	Deviation from pre-tariff trend (pp). Core price impact signal.
`domestic_trend_deviation_pp`	REAL	Y	Domestic spillover deviation (pp)
`retail_passthrough_pct`	REAL	Y	Rolling pass-through estimate (`deviation / applied_rate × 100`)
`cpi_contribution_pp`	REAL	Y	Estimated all-items CPI contribution (pp, expenditure-weighted)

7. event_sector_impacts — Per-event sector price impacts

One row per (event_id, coicop3_code). USITC applied rates × hs10_coicop_map crosswalk. Drives GET /api/v1/events/{id}/sector-impact (Standard).

Field	Type	Null	Description
`event_id`	TEXT FK	N	Parent TACO event
`coicop3_code`	TEXT	N	COICOP-3 sector code (e.g. `HF` = Household Furnishings)
`coicop3_label`	TEXT	N	Human-readable sector name
`imported_pp`	REAL	Y	Price impact on affected imports (pp)
`domestic_pp`	REAL	Y	Spillover to domestic competitors (pp)
`cpi_contrib_pp`	REAL	Y	CPI contribution from this sector (pp)
`consumer_pct`	REAL	Y	Consumer incidence share (%)

8. market_impact — Market reaction time series

Daily market data around threat/outcome dates. Drives GET /api/v1/events/{id}/market-impact (Premium).

Field	Type	Null	Description
`event_id`	TEXT FK	N	Parent TACO event
`date`	DATE	N	Market session date
`spy_close`	REAL	Y	S&P 500 ETF closing price
`vix_close`	REAL	Y	CBOE VIX closing value
`xlp_close`	REAL	Y	Consumer Staples ETF (domestic spillover proxy)
`xli_close`	REAL	Y	Industrials ETF (firm margin compression proxy)
`xly_close`	REAL	Y	Consumer Discretionary ETF (imported-affected proxy)
`eem_close`	REAL	Y	Emerging Markets ETF (origin-country incidence proxy)
`spy_cumulative_return_pct`	REAL	Y	SPY cumulative % return since threat_date

9. fr_documents — Federal Register documents

Presidential documents ingested from the Federal Register API. Drives GET /api/v1/events/{id}/federal-register.

Field	Type	Null	Description
`document_number`	TEXT PK	N	FR document number (e.g. `2025-12345`)
`title`	TEXT	N	Document title
`publication_date`	DATE	N	Date published in the Federal Register
`presidential_document_type`	TEXT	Y	EO type: `executive_order`, `proclamation`, `presidential_memorandum`, …
`executive_order_number`	TEXT	Y	EO number (e.g. `14257`)
`proclamation_number`	TEXT	Y	Proclamation number (e.g. `10908`)
`html_url`	TEXT	Y	Canonical URL on federalregister.gov
`abstract`	TEXT	Y	FR abstract text
`effective_on`	DATE	Y	Effective date

10. event_timeline — Event lifecycle log

Chronological log, one row per event state change. A threat entry is written at event creation and an outcome entry when the event terminally resolves (both via the canonical write paths). Drives GET /api/v1/events/{id}/timeline (Standard).

Field	Type	Null	Description
`id`	BIGSERIAL PK	N	Surrogate key
`event_id`	TEXT FK	Y	Parent event (→ `taco_events`)
`entry_date`	TIMESTAMPTZ	N	UTC timestamp of this entry (threat date or resolved outcome date)
`entry_type`	TEXT	N	Lifecycle type — canonical values `threat`, `outcome`
`description`	TEXT	N	Human-readable summary of the entry
`source_url`	TEXT	Y	Citation URL for the threat/outcome, when available
`severity_delta`	SMALLINT	N	Severity change vs. prior entry (reversal −20, implementation +10, else 0)

11. regulatory_term_mentions — CFR term frequency

Time series of how often TACO-relevant terms (e.g. "Section 232", "reciprocal tariff", "IEEPA") appear in the Code of Federal Regulations over time. Current counts are tracked weekly by the pipeline's eCFR step; a monthly 2025→present history is backfilled once.

Field	Type	Null	Description
`id`	BIGSERIAL PK	N	Surrogate key
`term`	TEXT	N	Tracked term
`snapshot_date`	DATE	N	Snapshot date
`mention_count`	INTEGER	N	Number of CFR mentions on that date
`cfr_title`	INTEGER	Y	CFR title scope (NULL = all titles)
`fetched_at`	TIMESTAMPTZ	N	Ingestion timestamp

12. cfr_title_snapshots — CFR title structure cache

Point-in-time structural snapshots of CFR titles (chapter/part/section/word counts + a trimmed structure), persisted during each regulatory diff from structures already fetched for the comparison (no extra requests).

Field	Type	Null	Description
`id`	BIGSERIAL PK	N	Surrogate key
`title`	INTEGER	N	CFR title number
`snapshot_date`	DATE	N	Snapshot date
`chapter_count`	INTEGER	Y	Number of chapters
`part_count`	INTEGER	Y	Number of parts
`section_count`	INTEGER	Y	Number of sections
`word_count`	INTEGER	Y	Total word count
`structure_json`	JSONB	Y	Trimmed structural hierarchy (chapters + part identifiers + section count)
`fetched_at`	TIMESTAMPTZ	N	Ingestion timestamp

13. Key API output shapes

/api/v1/index (Free)

Field	Type	Description
`value`	float	Current composite PEPI score (0–100)
`trend_30d`	float	30-day change in composite score
`trend_90d`	float	90-day change in composite score
`active_events`	int	Events currently in confirmed or monitoring status
`as_of`	date	Date of the latest index_daily row

/api/v1/sources/status (Free)

Field	Type	Description
`sources[].source_id`	string	Source identifier
`sources[].name`	string	Source display name
`sources[].update_cadence`	string	Official release frequency
`sources[].last_changed`	date\|null	“Data through” — newest reference period in the source (a monthly BLS report released mid-July carries June dates; expected)
`sources[].last_ingested`	date\|null	“Last ingested” — when the pipeline last pulled this source (the freshness signal); null where no ingest stamp exists
`sources[].record_count`	integer\|null	Total rows this source has contributed — aggregate volume only (no row content), free like `/stats`; null if uncountable
`sources[].populates`	string[]	The tables/fields this source feeds (data lineage), e.g. `fr_documents → event_fr_matches → taco_events.outcome_type`
`sources[].description`	string	What the source provides, in one line
`sources[].used_in_score`	bool	Whether this source feeds the PEPI score
`generated_at`	ISO 8601	Response generation timestamp