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.

Upcoming XBRL US Events

Domain Steering Committee Meeting
Tuesday, March 19, 2024

Communications & Services Steering Committee Meeting
Tuesday, March 19, 2024

FDTA: Entity and Security Identifiers
Thursday, March 28, 2024

Webinar: SEC Rule – Tailored Shareholder Reports for Mutual Funds and ETFs
Wednesday, May 15, 2024