Home Forums The XBRL API Access to cik_tickers table on PostgreSQL Server

Viewing 1 reply thread
  • Author
    Posts
    • #125683
      Tim Bui
      Participant

      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!

    • #126422
      David Tauriello
      Keymaster

      This SQL query should provide all CIK detail (entity_code)

      SELECT * 
      FROM entity
      ORDER BY entity_code
Viewing 1 reply thread
  • You must be logged in to reply to this topic.

Comment