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

This topic contains 1 reply, has 2 voices, and was last updated by  David Tauriello 5 months, 2 weeks ago.

  • 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

You must be logged in to reply to this topic.

Comment