Access to cik_tickers table on PostgreSQL Server

[Tim Bui]

Hello,
I see there is a table named cik_tickers on pgAdmin, under xbrl_public database. However, when I try to open it, it says ” ERROR: permission denied for relation cik_tickers, SQL state: 42501.”

Could I have access to this table or can you point me to a place where I can get an up-to-date cik list of companies?

I found this list of Tickers and CIKs but it is a few years old and does not include recent public companies.

http://rankandfiled.com/#/data/tickers

Thank you!

[David Tauriello]

This SQL query should provide all CIK detail (entity_code)

SELECT * 
FROM entity
ORDER BY entity_code

[Author]

Posts