Data Dictionary

Schema Reference — Version 1.3.6 · June 2026

This reference covers the key tables exposed via the REST API and Snowflake Marketplace. 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. 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 only)
`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
`active_events`	SMALLINT	Y	Events with status in (confirmed, monitoring)
`sp500_close`	REAL	Y	S&P 500 closing value (context column)

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)
`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. 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	Last date a new record was ingested
`sources[].used_in_score`	bool	Whether this source feeds the PEPI score
`generated_at`	ISO 8601	Response generation timestamp