Read-only view of securities_master . Every connection runs with default_transaction_read_only=on ; the ETL in data/ is the only writer.
Classified securities 5,783 assignments matching classification.v_security_classification
Classifications are unreviewed model output. All 5,771 assignments carry source = LLM and is_reviewed = false. Confidence is the model’s own estimate and is not calibrated — it clustered at 0.90–0.98 across the whole first pass, including rows that later proved wrong. Use it to order a review queue, not as a probability. Two share classes of one issuer can disagree.
REAL_ASSET · Infrastructure
FINANCIAL · Insurance
COMMUNICATION · Interactive Media
CORPORATE_CREDIT · Investment Grade
HEALTHCARE · Life Sciences Tools
HEDGE_STRATEGY · Long/Short
INDUSTRIALS · Machinery
HEDGE_STRATEGY · Managed Futures
COMMUNICATION · Media & Entertainment
HEALTHCARE · Medical Devices
MATERIALS · Metals & Mining
FINANCIAL · Mortgage Finance
SECURITIZED · Non-Agency MBS
GOVERNMENT · Non-US Sovereign
ENERGY · Oil & Gas Exploration
ENERGY · Oil & Gas Midstream
ENERGY · Oil & Gas Refining
HEALTHCARE · Pharmaceuticals
COMMODITY · Precious Metals
REAL_ESTATE · Real Estate Services
ENERGY · Renewable Energy
MONEY_MARKET · Repurchase Agreements
REAL_ESTATE · Residential REITs
CONSUMER_DISCRETIONARY · Retail
MUNICIPAL · Revenue
TECHNOLOGY · Semiconductors
TECHNOLOGY · Software
CONSUMER_STAPLES · Staples Retail
TECHNOLOGY · Technology Hardware
COMMUNICATION · Telecommunications
INDUSTRIALS · Transportation
MONEY_MARKET · Treasury Bills
GOVERNMENT · US Agency
GOVERNMENT · US Treasury
UTILITIES · Water Utilities
LNT Alliant Energy Corporation Common Stock CS Equity Utilities Electric Utilities
$18.21B 0.950 LLM
PR Permian Resources Corporation CS Equity Energy Oil & Gas Exploration
$17.97B 0.950 LLM
SBS COMPANHIA DE SANEAMENTO B SICO DO ESTADO DE S… ADRC Equity Utilities Water Utilities
$17.94B 0.950 LLM
TLN Talen Energy Corporation Common Stock CS Equity Utilities Electric Utilities
$17.49B 0.950 LLM
PKX POSCO Holdings Inc. American Depositary Share… ADRC Equity Materials Metals & Mining
$17.27B 0.950 LLM
WF Woori Financial Group Inc. American Depositar… ADRC Equity Financials Banking
$17.08B 0.950 LLM
STRL Sterling Infrastructure, Inc. Common Stock CS Equity Industrials Construction & Engineering
$16.79B 0.950 LLM
PAA Plains All American Pipeline, L.P. Common Uni… CS Equity Energy Oil & Gas Midstream
$16.40B 0.950 LLM