ExtractionFinancials and Employment API
BQ Financials and Employment API
Current and historical financials (income statement, balance sheet, ratios and margins) and employment: Most Recent (MR) trailing-twelve-month figures, annual (TS) and quarterly (TSQ) time series up to 5 years, and monthly employment (TSM).
Example: GET https://apigw.brightquery.com/extraction/api/financials?bq_id=100071190384
Authorization
ApiKeyAuth x-api-key<token>
Your BrightQuery API key, sent in the x-api-key request header.
In: header
Query Parameters
bq_id*integer
Unique ID assigned by BrightQuery to the Organization. Mandatory.
Response Body
application/json
application/json
application/json
application/json
application/json
curl -X GET "https://example.com/extraction/api/financials?bq_id=100003273517"{ "status": 0, "credit_balance": 0, "data": { "bq_id": 0, "bq_company_name": "string", "bq_ticker": "string", "bq_website": "string", "extracted_on": "string", "mr": { "bq_employment_mr": 0, "bq_revenue_mr": 0, "bq_ebitda_mr": 0, "bq_cor_mr": 0, "bq_net_income_mr": 0, "bq_gross_profit_mr": 0, "bq_total_assets_mr": 0, "bq_payroll_mr": 0, "bq_operating_expenses_mr": 0, "bq_operating_income_mr": 0, "bq_tax_and_interest_mr": 0, "bq_gross_profit_margin_mr": 0, "bq_ebitda_margin_mr": 0, "bq_asset_turnover_mr": 0, "bq_net_profit_margin_mr": 0, "bq_return_on_assets_mr": 0, "bq_return_on_sales_mr": 0, "bq_revenue_mr_per_emp": 0, "bq_ebitda_mr_per_emp": 0, "bq_cor_mr_per_emp": 0, "bq_net_income_mr_per_emp": 0, "bq_gross_profit_mr_per_emp": 0, "bq_total_assets_mr_per_emp": 0, "bq_payroll_mr_per_emp": 0, "bq_operating_expenses_mr_per_emp": 0, "bq_operating_income_mr_per_emp": 0, "bq_tax_and_interest_mr_per_emp": 0, "bq_report_date_mr": "string", "bq_revenue_growth_yoy_mr": 0, "bq_employment_growth_yoy_mr": 0, "bq_revenue_growth_quarterly_yoy_mr": 0, "bq_employment_growth_quarterly_yoy_mr": 0, "bq_employment_growth_monthly_yoy_mr": 0, "bq_revenue_growth_qoq_mr": 0, "bq_employment_growth_qoq_mr": 0, "bq_employment_growth_mom_mr": 0, "bq_current_assets_mr": 0, "bq_cash_mr": 0, "bq_trade_notes_and_accounts_receivable_mr": 0, "bq_less_allowance_for_bad_debts_mr": 0, "bq_inventories_mr": 0, "bq_us_government_obligations_mr": 0, "bq_tax_exempt_securities_mr": 0, "bq_other_current_assets_mr": 0, "bq_non_current_assets_mr": 0, "bq_loans_to_shareholders_mr": 0, "bq_mortgage_and_real_estate_loans_mr": 0, "bq_other_investments_mr": 0, "bq_buildings_and_other_depreciable_assets_mr": 0, "bq_less_accumulated_depreciation_mr": 0, "bq_depletable_assets_mr": 0, "bq_less_accumulated_depletion_mr": 0, "bq_land_mr": 0, "bq_intangible_assets_amortizable_mr": 0, "bq_less_accumulated_amortization_mr": 0, "bq_other_non_current_assets_mr": 0, "bq_current_liabilities_mr": 0, "bq_accounts_payable_mr": 0, "bq_short_term_debt_mr": 0, "bq_other_current_liabilities_mr": 0, "bq_non_current_liabilities_mr": 0, "bq_loans_from_shareholders_mr": 0, "bq_long_term_debt_mr": 0, "bq_other_non_current_liabilities_mr": 0, "bq_total_debt_mr": 0, "bq_total_liabilities_mr": 0, "bq_shareholders_equity_mr": 0, "bq_total_liabilities_and_equity_mr": 0, "bq_current_ratio_mr": 0, "bq_quick_ratio_mr": 0, "bq_debt_to_equity_ratio_mr": 0 }, "ts": [ { "bq_year": 0, "bq_employment": 0, "bq_revenue": 0, "bq_ebitda": 0, "bq_cor": 0, "bq_net_income": 0, "bq_gross_profit": 0, "bq_total_assets": 0, "bq_payroll": 0, "bq_operating_expenses": 0, "bq_operating_income": 0, "bq_tax_and_interest": 0, "bq_gross_profit_margin": 0, "bq_ebitda_margin": 0, "bq_asset_turnover": 0, "bq_net_profit_margin": 0, "bq_return_on_assets": 0, "bq_return_on_sales": 0, "bq_revenue_per_emp": 0, "bq_ebitda_per_emp": 0, "bq_cor_per_emp": 0, "bq_net_income_per_emp": 0, "bq_gross_profit_per_emp": 0, "bq_total_assets_per_emp": 0, "bq_payroll_per_emp": 0, "bq_operating_expenses_per_emp": 0, "bq_operating_income_per_emp": 0, "bq_tax_and_interest_per_emp": 0, "bq_fiscal_year_end": "string", "bq_current_assets": 0, "bq_cash": 0, "bq_trade_notes_and_accounts_receivable": 0, "bq_less_allowance_for_bad_debts": 0, "bq_inventories": 0, "bq_us_government_obligations": 0, "bq_tax_exempt_securities": 0, "bq_other_current_assets": 0, "bq_non_current_assets": 0, "bq_loans_to_shareholders": 0, "bq_mortgage_and_real_estate_loans": 0, "bq_other_investments": 0, "bq_buildings_and_other_depreciable_assets": 0, "bq_less_accumulated_depreciation": 0, "bq_depletable_assets": 0, "bq_less_accumulated_depletion": 0, "bq_land": 0, "bq_intangible_assets_amortizable": 0, "bq_less_accumulated_amortization": 0, "bq_other_non_current_assets": 0, "bq_current_liabilities": 0, "bq_accounts_payable": 0, "bq_short_term_debt": 0, "bq_other_current_liabilities": 0, "bq_non_current_liabilities": 0, "bq_loans_from_shareholders": 0, "bq_long_term_debt": 0, "bq_other_non_current_liabilities": 0, "bq_total_debt": 0, "bq_total_liabilities": 0, "bq_shareholders_equity": 0, "bq_total_liabilities_and_equity": 0, "bq_current_ratio": 0, "bq_quick_ratio": 0, "bq_debt_to_equity_ratio": 0 } ], "tsq": [ { "bq_year": 0, "bq_quarter": 0, "bq_fiscal_year": 0, "bq_fiscal_quarter": 0, "bq_fiscal_year_end": "string", "bq_fiscal_quarter_end": "string", "bq_employment": 0, "bq_revenue": 0, "bq_ebitda": 0, "bq_cor": 0, "bq_net_income": 0, "bq_gross_profit": 0, "bq_total_assets": 0, "bq_payroll": 0, "bq_operating_expenses": 0, "bq_operating_income": 0, "bq_tax_and_interest": 0, "bq_gross_profit_margin": 0, "bq_ebitda_margin": 0, "bq_asset_turnover": 0, "bq_net_profit_margin": 0, "bq_return_on_assets": 0, "bq_return_on_sales": 0, "bq_revenue_per_emp": 0, "bq_ebitda_per_emp": 0, "bq_cor_per_emp": 0, "bq_net_income_per_emp": 0, "bq_gross_profit_per_emp": 0, "bq_total_assets_per_emp": 0, "bq_payroll_per_emp": 0, "bq_operating_expenses_per_emp": 0, "bq_operating_income_per_emp": 0, "bq_tax_and_interest_per_emp": 0, "bq_current_assets": 0, "bq_cash": 0, "bq_trade_notes_and_accounts_receivable": 0, "bq_less_allowance_for_bad_debts": 0, "bq_inventories": 0, "bq_us_government_obligations": 0, "bq_tax_exempt_securities": 0, "bq_other_current_assets": 0, "bq_non_current_assets": 0, "bq_loans_to_shareholders": 0, "bq_mortgage_and_real_estate_loans": 0, "bq_other_investments": 0, "bq_buildings_and_other_depreciable_assets": 0, "bq_less_accumulated_depreciation": 0, "bq_depletable_assets": 0, "bq_less_accumulated_depletion": 0, "bq_land": 0, "bq_intangible_assets_amortizable": 0, "bq_less_accumulated_amortization": 0, "bq_other_non_current_assets": 0, "bq_current_liabilities": 0, "bq_accounts_payable": 0, "bq_short_term_debt": 0, "bq_other_current_liabilities": 0, "bq_non_current_liabilities": 0, "bq_loans_from_shareholders": 0, "bq_long_term_debt": 0, "bq_other_non_current_liabilities": 0, "bq_total_debt": 0, "bq_total_liabilities": 0, "bq_shareholders_equity": 0, "bq_total_liabilities_and_equity": 0, "bq_current_ratio": 0, "bq_quick_ratio": 0, "bq_debt_to_equity_ratio": 0 } ], "tsm": [ { "bq_year": 0, "bq_month": 0, "bq_employment": 0, "bq_payroll": 0 } ] }}BQ Executive Extraction API GET
Executives associated with the Organization: names, titles, LinkedIn URL, emails, phones and USPS-standardized addresses. Up to 100 records per page. Example: `GET https://apigw.brightquery.com/extraction/api/executives?bq_id=100003273517&page=1`
BQ Historical Employment API GET
Monthly employment and payroll time series going back up to 5 years. Example: `GET https://apigw.brightquery.com/extraction/api/historical-employment?bq_id=100003273517`