Home › Forums › The XBRL API › 10-K/A files
- This topic has 1 reply, 2 voices, and was last updated 4 years, 6 months ago by David Tauriello.
-
AuthorPosts
-
-
Sunday, July 11, 2021 at 8:09 PM #192545Hasnain jafferyParticipant
Hi,
I would like to know that how can I identify which one is an amendment 10-K return. I am looking at an example of Apple returned initial file (report number 0001193125-09-214859) filed for 2009. later in early 2010 an amendment was filed (File number 0001193125-10-012091). How can I differentiate that this an amendment file for 2009.
I wish I can show it via snapshot, but unable to find a way to identify that which one is 10-K/A file in XBRL.US database Plerase help me to identify 10-K/A file
thanks
Hasnain -
Monday, July 12, 2021 at 1:11 PM #192546David TaurielloKeymaster
Hi Hasnain – use the
restatement_indexfield in your query to know when restated facts exist.This XBRL API
factquery shows the details for the two reports in your post (10-K and 10-K/A). I am using Apple CIK along with period details to filter, then sorting by the restated-index.https://api.xbrl.us/api/v1/fact/search?entity.cik=0000320193&period.fiscal-year=2009&period.fiscal-period=Y&concept.local-name=EntityRegistrantName&fact.has-dimensions=false&fields=report.restated,report.restated-index.sort(ASC),report.type,period.fiscal-period,period.fiscal-year,concept.local-name,fact.value,report.accession,report.entry-urlAny fact appearing in a restated report will show report.restated as TRUE; the report.restated-index is an integer reflecting the number of times the report has been restated since the original filing (1).
Let me know if you still have questions about restatements in the Public Filings Database.
-
-
AuthorPosts
- You must be logged in to reply to this topic.
Search Forums
Recent Topics
- Income Statement data for a company by David Tauriello
- Normalized data presentation by David Tauriello
- Extract Director RSUs/Options Form 14A by Priyanka Goonetilleke
- Using the offset parameter by David Tauriello
- Spreadsheet Commands: Query Worksheet and Query Workbook Query Workbook by Liam Noailles
Recent Replies
-
Income Statement data for a company 7 months ago
-
Income Statement data for a company 7 months ago
-
Using the offset parameter 11 months, 1 week ago
-
Using the offset parameter 11 months, 1 week ago
-
Using the offset parameter 11 months, 1 week ago
Documentation & Discussion
- Get started with Google Sheets OR
- Get started with Microsoft Excel OR
- Get access to as-filed data from us for other tools or your own app
- XBRL API Interactive Documentation
- Ten Tips & Techniques
- The XBRL API
- XBRL Data Community
- 2024 US GAAP Taxonomy Viewer
- Live support - Monday, 3:30 - 4:30 PM ET
Who's using this free data?
API Use 2024 || API Use 2023 || API Use 2022 || API Use 2021 || API Use 2020 || API Use 2019 || API Use 2018
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table
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.
To use the XBRL API outside of Google Sheets, your account needs to be provisioned for OAuth2 access.





