Search congressional trades, politicians, and tickers.
Check SQL population, ingest freshness, missing price coverage, unmatched politicians, stale jobs, and empty SQL-state risk before trusting analysis.
Required tables before analysis should be trusted
Required for dashboard, trades, analysis, and search.
Required for politician pages and committee matching.
Required for company names, sectors, and ticker facts.
Required for transaction/disclosure price and return windows.
Congress tickers with cached prices for disclosure return windows
Synced committee rows and politician assignment coverage
Latest assignment sync: Never
Every registered SQL table in the explorer
| Table | Model | Rows |
|---|---|---|
| Backfill Jobs | BackfillJob | 0 |
| Ingest Runs | IngestRun | 0 |
| Politicians | Politician | 3 |
| Committees | Committee | 0 |
| Committee Assignments | PoliticianCommitteeAssignment | 0 |
| Stocks | Stock | 3 |
| Ticker Price Cache | TickerPriceCache | 0 |
| Congress Trades | CongressTrade | 4 |
| Signal Snapshots | SignalSnapshot | 0 |
| Backtest Runs | BacktestRun | 0 |
| Backtest Positions | BacktestPosition | 0 |
| Senate Trades | SenateTrade | 0 |
| House Trades | HouseTrade |
Politician rows without `bioguideId`, which blocks reliable committee matching
| Politician | Party | State | Chamber | Trades |
|---|---|---|---|---|
| No unmatched politicians in the first check window. | ||||
| 0 |
| Executive Trades | ExecutiveTrade | 0 |
| Executive Officials | ExecutiveOfficial | 0 |
| Executive Agencies | ExecutiveAgency | 0 |
| Insider Trades | InsiderTrade | 0 |
| Lobbying Disclosures | LobbyingDisclosure | 0 |
| WSB Mentions | WsbMention | 0 |
| Twitter Mentions | TwitterMention | 0 |
| Government Contracts | GovContract | 0 |
| Patents | Patent | 0 |
| Off Exchange Activity | OffExchangeActivity | 0 |
| 13F Holdings | ThirteenFHolding | 0 |
| SPACs | Spac | 0 |
| Wikipedia Views | WikipediaView | 0 |
| Political Beta | PoliticalBeta | 0 |
Cursor and error state by dataset
| Dataset | Mode | Rows | Health |
|---|---|---|---|
| No ingest jobs exist yet. Run the API probe and backfill after adding the key. | |||