XBRL API Sheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAK
1
Use the File menu to 'Make a copy...' in your Google account, then authorize the XBRL API Access Add-on and change the B2 dropdown to return data.
2
Select Query from Dropdown
Last 20 FilingsThis file is a starting point for using the XBRL API with the XBRL US Public Database of Filings. After installing the XBRL API Access add-on - https://xbrl.us/xbrl-api-addon - to your Google Account, use the file menu to "Make a copy..." of this XBRL API Sheet file in your account, then follow the prompts to sign in and initialize the add-on under the Add-ons menu.

The 'Config' tab has preloaded queries that can be called by changing the dropdown menu in cell B1 of this 'Main Sheet' tab. Results appear on row 10 and below, using the function =showData(url). By default, the 'Display' is set to return queried data.

Main Sheet Options - Field Tree and Specific Field Name: Change cell B2 on this sheet to "Field Tree" to get a list of fields returned by the query. Use "Specific Field" with forward slashes to return data/details for "Specific Field Name" defined in cell B3. For example, select the query 'Selected US-GAAP 2018 concepts' to get 10 concepts (offset is explained below), then change the display to Field Tree to see what fields are returned. Type label/label.text in the Specific Field Name cell B3 (corresponding to the 'tree' location of the last returned data point for queried records) and change the Display to Specific Field to return only the label.text values for the query.

The 'BSCompare' tab on this file shows data returned and formatted into a very basic Balance Sheet for US GAAP filers.

Not getting all the results you expect? Visit https://xbrl.us/benefits to learn about XBRL US Membership options to return more/all data for your queries.

Non-members can return up to 1,000 records per query, 100 records per page. Use ENDPOINT.offset(INTEGER) in the fields parameter to return additional records that may exist for your query. For example, select the query 'AssetsCurrent for all filers (2015 - 2017)' from the dropdown and fact.offset(900) returns records starting with 900; change the parameter to 0 to see the first results returned (see documentation Section 7. Handling Paging for details).

The API documentation - https://xbrl.us/xbrl-api-documentation - outlines parameters and switches that can be used to update preloaded queries or create your own.
Got questions or ideas? Post to the XBRL Data Community Discussion Forum - https://xbrl.us/xbrl-api-community


3
DisplayQuery Results
4
Specific Field Namereport.id
5
Display full query?
6
Full Queryhttps://api.xbrl.us/api/v1/report/search?report.is-most-current=true&fields=report.*,report.limit(20),report.accepted-timestamp.sort(DESC)
7
8
9
10
Query Response
11
dts.identity.cikentity.identity.ticker
report.accepted-timestamp
report.accession
report.addressreport.base-taxonomy
report.checks-run
report.creation-software
report.document-type
report.entity-name
report.entry-type
report.entry-url
report.filer-category
report.filing-date
report.id
report.is-most-current
report.period-end
report.period-index
report.phone
report.restated
report.restated-index
report.sec-url
report.sic-code
report.source-id
report.source-name
report.state-of-incorporation
12
34489300012898482441hurn2019-10-16 14:48:00
0001289848-19-000040
550 WEST VAN BUREN STREET, CHICAGO IL 60607
US GAAP 2019TRUE
XBRL Document Created with Wdesk from Workiva
8-K
Huron Consulting Group Inc.
inline
http://www.sec.gov/Archives/edgar/data/1289848/000128984819000040/a8k-chicagoleasex6tham.htm
2019-10-16254113TRUE2019-10-101(312) 583-8700FALSE1
http://www.sec.gov/Archives/edgar/data/1289848/000128984819000040/0001289848-19-000040-index.htm
87421SECDE
13
34489100000223565721cbsh2019-10-16 14:27:00
0000022356-19-000041
1000 WALNUT, KANSAS CITY MO 64106
US GAAP 2019TRUE
XBRL Document Created with Wdesk from Workiva
8-K
Commerce Bancshares, Inc.
inline
http://www.sec.gov/Archives/edgar/data/22356/000002235619000041/cbsh093020198k.htm
2019-10-16254111TRUE2019-10-1618162342000FALSE1
http://www.sec.gov/Archives/edgar/data/22356/000002235619000041/0000022356-19-000041-index.htm
60221SECMO
14
34489200014353874344denr2019-10-16 14:20:00
0001493152-19-015565
ONE RIVERWAY DRIVE, SUITE 1700, HOUSTON TX 77056
US GAAP 2019TRUE
Field: Doc-Info; Name: Generator; Value: GoFiler Complete; Version: 5.1b
10-Q
Discovery Energy Corp.
instance
http://www.sec.gov/Archives/edgar/data/1435387/000149315219015565/denr-20190831.xml
Non-accelerated Filer
2019-10-16254112TRUE2019-08-311(713) 840-6495FALSE1
http://www.sec.gov/Archives/edgar/data/1435387/000149315219015565/0001493152-19-015565-index.htm
13821SECNV
15
34489000007136766428pnc2019-10-16 13:20:00
0000713676-19-000064
THE TOWER AT PNC PLAZA, 300 FIFTH AVENUE, PITTSBURGH PA 15222-2401
US GAAP 2019TRUE
XBRL Document Created with Wdesk from Workiva
8-K
PNC FINANCIAL SERVICES GROUP, INC.
inline
http://www.sec.gov/Archives/edgar/data/713676/000071367619000064/q320198-kfs.htm
2019-10-16254110TRUE2019-10-161888-762-2265FALSE1
http://www.sec.gov/Archives/edgar/data/713676/000071367619000064/0000713676-19-000064-index.htm
60211SECPA
16
34488900009326968396nsit2019-10-16 12:52:00
0001564590-19-037006
6820 SOUTH HARL AVENUE, TEMPE AZ 85283
US GAAP 2019TRUE
DFIN ActiveDisclosure(SM) Inline XBRL Document - http://www.dfinsolutions.com/
8-K
INSIGHT ENTERPRISES INC
inline
http://www.sec.gov/Archives/edgar/data/932696/000156459019037006/nsit-8k_20191016.htm
2019-10-16254109TRUE2019-10-161480-902-1001FALSE1
http://www.sec.gov/Archives/edgar/data/932696/000156459019037006/0001564590-19-037006-index.htm
59611SECDE
17
34488800015561799336rmri2019-10-16 12:14:00
0001104659-19-054332
4601 DTC BLVD., SUITE 130, DENVER CO 80237
US GAAP 2019TRUE
XBRL document created with Toppan Merrill Bridge 9.4.0.81
10-Q
RMR Industrials, Inc.
instance
http://www.sec.gov/Archives/edgar/data/1556179/000110465919054332/rmri-20181231.xml
Non-accelerated Filer
2019-10-16254108TRUE2018-12-311720-614-5213FALSE1
http://www.sec.gov/Archives/edgar/data/1556179/000110465919054332/0001104659-19-054332-index.htm
73801SECNV
18
34488700008155567178fast2019-10-16 11:25:00
0000815556-19-000058
2001 THEURER BLVD, WINONA MN 55987
US GAAP 2019TRUE
XBRL Document Created with Wdesk from Workiva
10-QFASTENAL COinline
http://www.sec.gov/Archives/edgar/data/815556/000081555619000058/fast9301910q.htm
Large Accelerated Filer
2019-10-16254107TRUE2019-09-3025074545374FALSE1
http://www.sec.gov/Archives/edgar/data/815556/000081555619000058/0000815556-19-000058-index.htm
52001SECMN
19
34488600003508525971ctbi2019-10-16 09:35:00
0000350852-19-000074
346 NORTH MAYO TRAIL, P.O. BOX 2947, PIKEVILLE KY 41502-2947
US GAAP 2019TRUE8-K
Community Trust Bancorp, Inc.
inline
http://www.sec.gov/Archives/edgar/data/350852/000035085219000074/er8k0919.htm
2019-10-16254106TRUE2019-09-301(606)433-4643FALSE1
http://www.sec.gov/Archives/edgar/data/350852/000035085219000074/0000350852-19-000074-index.htm
60221SECKY
20
34488400011660031899xpo2019-10-16 09:00:00
0001410578-19-001656
5 AMERICAN LANE, GREENWICH CT 06831
US GAAP 2019TRUE
Field: Set; Name: xdx; ID: xdx_06D_USDPShares_3_iso4217%2D%2DUSD_xbrli%2D%2Dshares
8-K
XPO LOGISTICS,
INC.
inline
http://www.sec.gov/Archives/edgar/data/1166003/000141057819001656/tv531012_8k.htm
2019-10-16254104TRUE2019-10-101(855) 976-6951FALSE1
http://www.sec.gov/Archives/edgar/data/1166003/000141057819001656/0001410578-19-001656-index.htm
47001SEC
21
344885000164697211957aci2019-10-16 08:59:00
0001646972-19-000074
250 PARKCENTER BLVD., BOISE ID 83706
US GAAP 2019TRUE
XBRL Document Created with Wdesk from Workiva
8-K
Albertsons Companies, Inc.
inline
http://www.sec.gov/Archives/edgar/data/1646972/000164697219000074/a8kq219earningsrelease.htm
2019-10-16254105TRUE2019-10-161208-395-6200FALSE1
http://www.sec.gov/Archives/edgar/data/1646972/000164697219000074/0001646972-19-000074-index.htm
54111SECDE
22
34487800008861637814lgnd2019-10-16 08:57:00
0000886163-19-000186
3911 SORRENTO VALLEY BLVD, SUITE 110, SAN DIEGO CA 92121
US GAAP 2019TRUE
XBRL Document Created with Wdesk from Workiva
8-K
LIGAND PHARMACEUTICALS INC
inline
http://www.sec.gov/Archives/edgar/data/886163/000088616319000186/lgnd-form8xk101619newb.htm
2019-10-16254098TRUE2019-10-151858-550-7500FALSE1
http://www.sec.gov/Archives/edgar/data/886163/000088616319000186/0000886163-19-000186-index.htm
28341SECDE
23
34488000008998668002alxn2019-10-16 08:50:00
0001193125-19-268091
121 SEAPORT BOULEVARD, BOSTON MA 02210
FALSE8-K
Alexion Pharmaceuticals, Inc.
inline
http://www.sec.gov/Archives/edgar/data/899866/000119312519268091/d788650d8k.htm
2019-10-16254100TRUE2019-10-1514752302596FALSE1
http://www.sec.gov/Archives/edgar/data/899866/000119312519268091/0001193125-19-268091-index.htm
28341SECDE
24
34487900000361046055usb2019-10-16 08:50:00
0001193125-19-268090
U.S. BANCORP, 800 NICOLLET MALL, MINNEAPOLIS MN 55402-7020
US GAAP 2019TRUE8-K
US BANCORP \DE\
inline
http://www.sec.gov/Archives/edgar/data/36104/000119312519268090/d818595d8k.htm
2019-10-16254099TRUE2019-10-161651-466-3000FALSE1
http://www.sec.gov/Archives/edgar/data/36104/000119312519268090/0001193125-19-268090-index.htm
60211SECDE
25
34488100000806617089pgr2019-10-16 08:47:00
0000080661-19-000041
6300 WILSON MILLS RD, MAYFIELD VILLAGE OH 44143
US GAAP 2019TRUE
XBRL Document Created with Wdesk from Workiva
8-K
PROGRESSIVE CORP/OH/
inline
http://www.sec.gov/Archives/edgar/data/80661/000008066119000041/a8-kseptember2019earni.htm
2019-10-16254101TRUE2019-10-1614404615000FALSE1
http://www.sec.gov/Archives/edgar/data/80661/000008066119000041/0000080661-19-000041-index.htm
63311SECOH
26
3448820001019849256pag2019-10-16 08:41:00
0001019849-19-000024
2555 TELEGRAPH RD, BLOOMFIELD HILLS MI 48302-0954
FALSE
iXBRL document created with: Toppan Merrill Bridge iXBRL 9.4.7193.41938
8-K
Penske Automotive Group, Inc.
inline
http://www.sec.gov/Archives/edgar/data/1019849/000101984919000024/pag-20191016x8k.htm
2019-10-16254102TRUE2019-10-161248-648-2500FALSE1
http://www.sec.gov/Archives/edgar/data/1019849/000101984919000024/0001019849-19-000024-index.htm
55001SECDE
27
344883000162785712218sail2019-10-16 08:40:00
0001564590-19-036987
11120 FOUR POINTS DRIVE, SUITE 100, AUSTIN TX 78726
US GAAP 2019TRUE
DFIN ActiveDisclosure(SM) Inline XBRL Document - http://www.dfinsolutions.com/
8-K
SailPoint Technologies Holdings, Inc.
inline
http://www.sec.gov/Archives/edgar/data/1627857/000156459019036987/sail-8k_20191015.htm
2019-10-16254103TRUE2019-10-151(512) 346-2000FALSE1
http://www.sec.gov/Archives/edgar/data/1627857/000156459019036987/0001564590-19-036987-index.htm
73721SEC
28
34487700014594179920twou2019-10-16 08:30:00
0001104659-19-054292
7900 HARKINS ROAD, LANHAM MD 20706
US GAAP 2019TRUE
Field: Set; Name: xdx; ID: xdx_06D_USDPShares_3_iso4217%2D%2DUSD_xbrli%2D%2Dshares
8-K2U, INC.inline
http://www.sec.gov/Archives/edgar/data/1459417/000110465919054292/tm1920311-1_8k.htm
2019-10-16254097TRUE2019-10-101(301) 892-4350FALSE1
http://www.sec.gov/Archives/edgar/data/1459417/000110465919054292/0001104659-19-054292-index.htm
73721SECDE
29
34487400011013021345entg2019-10-16 08:05:00
0001101302-19-000038
129 CONCORD ROAD, BILLERICA MA 01821
US GAAP 2019TRUE
XBRL Document Created with Wdesk from Workiva
8-KENTEGRIS INCinline
http://www.sec.gov/Archives/edgar/data/1101302/000110130219000038/entgform8-kq4dividend.htm
2019-10-16254094TRUE2019-10-1619784366500FALSE1
http://www.sec.gov/Archives/edgar/data/1101302/000110130219000038/0001101302-19-000038-index.htm
30891SECDE
30
34487500012780212334mktx2019-10-16 08:01:00
0001193125-19-268044
55 HUDSON YARDS, 15TH FLOOR, NEW YORK NY 10001
FALSE8-K
MARKETAXESS HOLDINGS INC
inline
http://www.sec.gov/Archives/edgar/data/1278021/000119312519268044/d814221d8k.htm
2019-10-16254095TRUE2019-10-151212-831-6000FALSE1
http://www.sec.gov/Archives/edgar/data/1278021/000119312519268044/0001193125-19-268044-index.htm
62111SEC
31
344876000160392310089wftiq2019-10-16 08:00:00
0001104659-19-054285
70 SIR JOHN ROGERSON'S QUAY, DUBLIN L2 2
US GAAP 2019TRUE
Field: Set; Name: xdx; ID: xdx_06D_USDPShares_3_iso4217%2D%2DUSD_xbrli%2D%2Dshares
8-K
Weatherford International plc
inline
http://www.sec.gov/Archives/edgar/data/1603923/000110465919054285/tm1919680_8k.htm
2019-10-16254096TRUE2019-10-16141.22.816.1500FALSE1
http://www.sec.gov/Archives/edgar/data/1603923/000110465919054285/0001104659-19-054285-index.htm
35331SEC
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...