Primary Document
primary_document
Optional
The file name of the filing's main document, read from the primaryDocument column.
SEC EDGAR Filings Scraper: 8-K Earnings, Form 4
Pricing
from $0.54 / 1,000 filing returneds
Get SEC EDGAR filings with each 8-K earnings release excerpted on request, plus its guidance sentences and a sentiment score. Rows carry the form type, filed date, 8-K items, Form 4 trade lines, 10-K and 10-Q financials and document links, and full-text search covers every filing since 2001.
Pricing
from $0.54 / 1,000 filing returneds
Rating
0.0
(0)
Developer
Pradio Actors
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
2 days ago
Last modified
Categories
Share
Company Name
company_name
Optional
The company's registered name, read from the name field of its SEC submissions record.
Accession Number
accession_number
Optional
The filing's accession number, the SEC's unique identifier for the submission, read from the accessionNumber column of the filings feed.
CIK
cik
Optional
The company's Central Index Key, the SEC's numeric filer identifier, from the submissions record.
Ticker
ticker
Optional
The company's first listed stock ticker, from the tickers field of the submissions record; null when the filer has none.
Tickers
tickers
Optional
Every ticker the company trades under, in the order the SEC lists them, such as GOOGL and GOOG for one company. ticker is the first of these. Null when the SEC lists none, as for most funds and private filers.
Form Type
form_type
Optional
The SEC form code the filing was submitted as, such as 10-K, 8-K or 4, read from the form column.
Items
items
Optional
On an 8-K or 8-K/A row: the SEC item numbers the filing reports under, such as 2.02 and 9.01, read from the items column of the filings feed. Filled on every 8-K the feed lists items for, at no extra charge and whether or not Extract Earnings Releases is on. Null on other forms and on an 8-K the feed lists no items for.
Item descriptions
item_descriptions
Optional
On an 8-K or 8-K/A row: the Regulation S-K name of each item in items, in the same order, such as Results of Operations and Financial Condition for 2.02. Filled wherever items is, at no extra charge; null on other forms.
Filed Date
filed_date
Optional
The date the filing was submitted, read from the filingDate column.
Report Date
report_date
Optional
The period end the filing reports on, read from the reportDate column; null where the form carries none.
Acceptance Time
acceptance_date_time
Optional
When the SEC accepted the filing, read from the acceptanceDateTime column.
Report Year
report_year
Optional
The calendar year of the filing's report date.
Fiscal Quarter
fiscal_quarter
Optional
Which of the company's fiscal quarters the report date falls in, computed from reportDate and the company's fiscalYearEnd; null when either is missing. On an 8-K the report date is the date of the event, so an earnings release filed after its quarter ends carries the quarter it was filed in, not the one it reports.
SIC
sic
Optional
The company's Standard Industrial Classification code, read from the sic field of the submissions record.
SIC Description
sic_description
Optional
The industry label for the SIC code, read from the sicDescription field.
State of Incorporation
state_of_incorporation
Optional
The state or country code where the company is incorporated, read from stateOfIncorporation; null where the filer declares none.
Fiscal Year End
fiscal_year_end
Optional
The month and day the company's fiscal year ends, in MMDD, read from fiscalYearEnd.
Exchanges
exchanges
Optional
The stock exchanges the company lists on, read from the exchanges array.
Primary Document
primary_document
Optional
The file name of the filing's main document, read from the primaryDocument column.
Primary Document Description
primary_doc_description
Optional
The SEC's short label for the main document, read from primaryDocDescription.
Document URL
document_url
Optional
A link to the filing's primary document on sec.gov, built from the accession number and primaryDocument.
Filing URL
filing_url
Optional
A link to the filing's index page on sec.gov, which lists every file in the submission.
Index URL
index_url
Optional
A link to the filing's machine-readable index.json on sec.gov.
SEC Viewer URL
sec_viewer_url
Optional
This filing in the SEC's own viewer: the inline XBRL viewer when the filing is inline XBRL, otherwise the filed document itself.
Size (bytes)
size_bytes
Optional
The filing's size in bytes as the feed reports it, read from the size column.
XBRL
is_xbrl
Optional
Whether the filing carries XBRL data, read from the isXBRL flag.
Inline XBRL
is_inline_xbrl
Optional
Whether the filing carries inline XBRL, read from the isInlineXBRL flag.
File Number
file_number
Optional
The SEC file number assigned to the filing, read from fileNumber; null where EDGAR carries none, as on insider filings.
Film Number
film_number
Optional
The SEC film number for the filing, read from filmNumber; null where EDGAR carries none, as on insider filings.
Act Code
act_code
Optional
The Act of Congress the filing references, read from act; null where EDGAR carries none, as on insider filings.
Entity Type
entity_type
Optional
The SEC's category for the filer, such as operating, read from entityType.
Row Type
row_type
Optional
ROW on every data row; ITEM_STATUS on a per-entry miss (pushed so the buyer sees the verdict, never billed); PROFILE_NOT_FOUND when the source answered and had nothing; STOPPED_EARLY when the charge limit ended the run before every fetched row was returned
Reason
reason
Optional
On a status row, why the run returned no rows or why it stopped early. On a filing row, why document_text, sections or matched_passages is null when its Include flag is on: a Form 3, 4, 5 or 144, or a filing a person made.
Status
status
Optional
ok on a data row; on an ITEM_STATUS row it is the miss verdict (bad_url, bad_input, not_found, fetch_failed, not_reached). not_found also marks a company read that holds no filing row for the run, resolved and answered, just quiet. not_reached marks a company the run's row cap left unread, never fetched, never billed. duplicate names an entry resolving to a company an earlier entry already claimed: its filings are returned once under that entry, and nothing is billed
Rows Fetched
rowsFetched
Optional
Present only on a status row: how many filing rows the run found before duplicates were dropped and maxItems was applied
Rows Returned
rowsReturned
Optional
Present only on a status row: how many data rows are in the dataset (0 on an empty result; the count before the charge limit on STOPPED_EARLY)
Rows Remaining
rowsRemaining
Optional
Present only on a status row: how many fetched rows were NOT returned (0 on an empty result)
EIN
ein
Optional
The company's Employer Identification Number, read from the ein field of its SEC submissions record.
Addresses
addresses
Optional
The company's mailing and business addresses as an object, read from the addresses field of its SEC submissions record, every value passed through as the SEC publishes it (isForeignLocation can read 0 on one address and null on the other).
Item Codes
item_codes
Optional
The SEC item codes an earnings-release 8-K reports under (e.g. 2.02): the same numbers as items, kept as the earnings extraction's own column, read from the filings feed or the primary document. Filled only when extractEarnings is on and the 8-K is an earnings release (Item 2.02 with a revenue, net income, operating income or per-share figure); null otherwise.
Item Names
item_names
Optional
The Regulation S-K name of each item code in the same order: the same names as item_descriptions, on a billed earnings release only; null when the row carries no item codes.
Excerpt
excerpt
Optional
A short excerpt of the earnings release text, cleaned of markup and cover-page preamble: from the 8-K's primary document, or from its Exhibit 99.1 press release when the primary document is a cover page, in which case it opens with [From Exhibit 99.1, ]. Null unless the row is an earnings release extracted with extractEarnings on.
Guidance Sentences
guidance_sentences
Optional
Up to eight forward-looking statements from the same text as excerpt: each has a forward word (guidance, outlook, expects, anticipates, forecast, projected, reaffirms) and a figure (an amount, a percent or basis points), such as "Revenue is expected to be $108.0 billion, plus or minus 2%". A line under an outlook heading keeps the heading in front. Headlines, results compared with a past target, safe-harbour text and pay sentences are left out. Null when the release states no guidance with a figure, and unless the row is an earnings release extracted with extractEarnings on.
Sentiment
sentiment
Optional
A light positive/negative word-count score over the whole document the excerpt comes from (the primary document, or Exhibit 99.1 when that was read), not over the excerpt alone: {positive, negative, net, label}; null unless the row is an earnings release extracted with extractEarnings on.
Reported Figures
reported_figures
Optional
On an extracted earnings release: the headline figures the release itself printed, as written: one entry per metric kind found ({metric, value}), metric one of revenue, net_income, operating_income or eps, value the amount the release states, such as "$94.9 billion" or "$1.57". Filer-reported text, never a converted or computed number. Null unless the row is an earnings release extracted with extractEarnings on.
Insider Name
insider_name
Optional
On a Form 3, 4 or 5 row: the reporting insider as named on the form, several joined with a semicolon. Null on other forms and when Insider Transactions is off.
Insider Relationship
insider_relationship
Optional
On a Form 3, 4 or 5 row: the insider's relationship to the company as the form states it, such as Director, Officer (Chief Financial Officer) or 10% Owner. Null on other forms and when Insider Transactions is off.
Transactions
transactions
Optional
On a Form 3, 4 or 5 row: each transaction or holding line on the form, with kind, security_title, derivative, date, code, shares, price_per_share, acquired_disposed (A or D), shares_owned_after, underlying_shares and direct_or_indirect (D or I). On a derivative line, underlying_shares is the number of shares the derivative is for; a Form 3 derivative holding, such as Restricted Stock Units, states its size there and shares_owned_after is null. Null on other forms.
Document Text
document_text
Optional
The filing's primary document as plain text, markup removed, cut at Max Document Characters. Null unless Include Document Text is on, and always null on Forms 3, 4, 5 and 144 and on a filing a person made.
Sections
sections
Optional
When Include Item Sections is on: the filing's primary document split on its Item headings, one entry per item found ({item, name, text}) in item order, each text the filer's own words cut at 20,000 characters, a 10-K's Item 1A Risk Factors or Item 7 MD&A as its own value. Null on Forms 3, 4, 5 and 144, on a filing a person made, and when Include Item Sections is off.
Matched Passages
matched_passages
Optional
When Include Matched Passages is on and the run is a Keyword Search run: up to three sentences from the filing's primary document carrying the query's terms, each cut at 400 characters, where the filing matched, without opening the document. Null on Forms 3, 4, 5 and 144, on a filing a person made, on company runs, and when Include Matched Passages is off.
Financials
financials
Optional
On a 10-K or 10-Q row, when Include Financials is on: the figures this filing itself reported for its own period, read from the SEC XBRL company-concept API and matched to the filing by its accession number. {period_end, fiscal_year, fiscal_period, period_months (12 on a 10-K, 3 on a 10-Q), currency, revenue, gross_profit, operating_income, net_income, eps_basic, eps_diluted, total_assets, total_liabilities, stockholders_equity, cash, operating_cash_flow, operating_cash_flow_months, concepts}. Income figures are for the filing's own period, the quarter on a 10-Q, never the year to date; balances are at period_end; operating_cash_flow is year to date, as a 10-Q states it, with its length in operating_cash_flow_months. concepts names the US GAAP tag each figure came from. A figure the filing did not tag is null. Null on other forms, on a filing that tagged none of these (an IFRS filer, or an amendment with no statements) and when Include Financials is off.
Search Metadata
search_metadata
Optional
The buyer's entry this row answers: {query, event}, where query is the searchQueries line, startUrls link or Keyword Search phrase as given, and event is lookup for a company entry or search for a keyword run. On a status row it names the entry that missed; null only on a run-level status row that names no entry.