live
DashboardTradesPoliticiansStocksScreenerWatchlist
Analysis
AnalysisRelationships
System
DatasetsData HealthAbout

Global search

Search congressional trades, politicians, and tickers.

Datasets
SQL Data Explorer

Live Tables

A direct operating view of the tables behind trades, stock profiles, price cache rows, ingest runs, and alternative datasets.

Tables
27
Visible Rows
10

Operations

Backfill Jobs

BackfillJob

Cursor, status, and error tracking for scheduled source backfills.

Rows0

Ingest Runs

IngestRun

Point-in-time import attempts with fetched, inserted, and error counts.

Rows0

Signal Snapshots

SignalSnapshot

Persisted ticker scores and explanations generated by the analysis layer.

Rows0

Backtest Runs

BacktestRun

Disclosure-date strategy runs with aggregate return, win-rate, and capital statistics.

Rows0

Backtest Positions

BacktestPosition

Position-level entries and exits for disclosure-date backtest runs.

Rows0

Reference

Politicians

Politician

Normalized elected official records used to join congressional trades.

Rows3

Committees

Committee

Current congressional committees and subcommittees from the public legislators dataset.

Rows0

Committee Assignments

PoliticianCommitteeAssignment

Join table connecting normalized politicians to committee roles, rank, chair, and ranking status.

Rows0

Stocks

Stock

Ticker master data for company profile, sector, exchange, and links.

Rows3

Ticker Price Cache

TickerPriceCache

Daily close prices cached from the market data provider for chart overlays.

Rows0

Executive Officials

ExecutiveOfficial

Normalized executive-branch officials (Cabinet, agency heads) used to join executive trades.

Rows0

Executive Agencies

ExecutiveAgency

Cabinet departments and federal agencies referenced by executive officials.

Rows0

Congress

Congress Trades

CongressTrade

Unified congressional trades joined to normalized politician records.

Rows4

Senate Trades

SenateTrade

Raw Senate trading disclosures before unification into CongressTrade.

Rows0

House Trades

HouseTrade

Raw House trading disclosures before unification into CongressTrade.

Rows0

Executive

Executive Trades

ExecutiveTrade

Periodic transaction reports from executive-branch officials (OGE-278) via Open Cabinet.

Rows0

Alternative Data

Insider Trades

InsiderTrade

Corporate insider trading activity by ticker, title, shares, and value.

Rows0

Lobbying Disclosures

LobbyingDisclosure

Lobbying spend by client, registrant, ticker, issue, and filing period.

Rows0

WSB Mentions

WsbMention

WallStreetBets mention counts and sentiment by ticker and date.

Rows0

Twitter Mentions

TwitterMention

Social mention counts, sentiment, and follower reach by ticker and date.

Rows0

Government Contracts

GovContract

Federal contract awards connected to public company tickers.

Rows0

Patents

Patent

Patent filings and grants by ticker, number, inventor, and abstract.

Rows0

Off Exchange Activity

OffExchangeActivity

Short volume, total volume, and dark-pool share by ticker and date.

Rows0

13F Holdings

ThirteenFHolding

Institutional 13F holdings, value, report date, and share changes.

Rows0

SPACs

Spac

SPAC profile, IPO date, trust value, status, and target ticker.

Rows0

Wikipedia Views

WikipediaView

Wikipedia page-view counts by ticker and date.

Rows0

Political Beta

PoliticalBeta

Ticker-level political sensitivity scores by as-of date.

Rows0