US public companies as registered by the US Securities and Exchange Commission.
List public companies
Find a company by symbol
select*fromfinance_us_sec_public_companywheresymbol = 'AAPL'
Find a company by name
select*fromfinance_us_sec_public_companywherename ilike '%apple%'order byname
"Apple"-ish companies with their last closing price
selectc.symbol,c.name,f.*fromfinance_us_sec_public_company as c,finance_us_sec_filer as fwherec.symbol = f.symboland c.name ilike '%apple%'order byc.symbol
US public companies from the SEC Edgar database.
|name||text||Name of the company.|
|symbol||text||Symbol of the company.|