Thursday, May 9, 2019 at 6:58 AM #137557
The 3 latest quarterly reports from BBBY (CIK 0000886158) seem to be missing from the database. Those filed on 2018-07-06, 2018-10-10 and 2019-01-09.
Would this be because the DB is not necessarily complete, or am I perhaps searching for them the wrong way?
Thursday, May 9, 2019 at 1:51 PM #137682
Peter – thanks for bringing this to our attention; we’re still assessing what happened, but the filings are there:
NOTE: the 7813 id will be merged into 12275 id in the near term.
Wednesday, May 22, 2019 at 4:10 PM #140244
Peter – a quick note to confirm we’ve resolved the issue for this CIK (and a few others), and updated our load process to prevent future anomalies of this sort. My earlier reply was mistaken, however – the lower entity.id was retained.
You must be logged in to reply to this topic.
Code for publicly traded companies 2 days, 13 hours ago
Code for publicly traded companies 2 days, 19 hours ago
Code for publicly traded companies 2 days, 20 hours ago
CIK and Ticker 2 weeks, 3 days ago
Extracting Data From A Particular Financial Statement 3 weeks, 1 day ago
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Documentation (PDF)
- Get Data with Google Sheets
- Sample Queries (Insomina REST client) - requires account provision
Using the XBRL API with the Public Filings Database
Unless otherwise agreed to in writing, any and all use of the XBRL API to authenticate and retrieve data from the XBRL US Database of Public Filings implies user consent and agreement with the XBRL US API Agreement. If you are unable to agree to these terms, do not use the XBRL API.
Ready to work with the API in Excel's Power Query, or with your own system or app?
Contact us at firstname.lastname@example.org to have your existing XBRL US Web account provisioned to generate client ID/Secret pairs to work with the XBRL API in a REST client or other application, including Excel's Power Query.
NOTE: You do not need to generate client ID/Secret pairs if you use the Google Add-on and Google Sheet exclusively to access data - the XBRL API Authentication Add-on handles this automatically.
Your account needs to be provisioned before you can login and generate client ID/secret pairs.
Login or register for a free account.
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table