Data architecture

← Back

Six related files, about 8,600 rows, all linked by company.

portfolio_companies12 rows
  • company_idtext
  • company_nametext
  • fund_idtext
  • fund_nametext
  • fund_vintageinteger
  • fund_size_gbp_mreal
  • sectortext
  • subsectortext
  • countrytext
  • reporting_currencytext
  • deal_typetext
  • entry_datetext
  • exit_datetext
  • statustext
  • entry_revenue_minteger
  • entry_ebitda_mreal
  • entry_ev_minteger
  • entry_net_debt_minteger
  • exit_ev_minteger
  • ownership_pctinteger
  • lead_partnertext
  • source_systemtext
monthly_financials659 rows
  • company_idtext
  • period_endtext
  • fiscal_yearinteger
  • fiscal_quartertext
  • currencytext
  • fx_rate_to_gbpreal
  • revenuereal
  • cogsreal
  • gross_profitreal
  • opex_totalreal
  • staff_costsreal
  • other_opexreal
  • ebitdareal
  • ebitda_adjustmentsreal
  • adjusted_ebitdareal
  • depreciation_amortisationreal
  • ebitreal
  • interest_expensereal
  • taxreal
  • net_incomereal
  • capexreal
  • cash_balancereal
  • gross_debtreal
  • net_debtreal
  • budget_revenuereal
  • budget_ebitdareal
  • submission_statustext
  • submission_datetext
revenue_segments2,670 rows
  • company_idtext
  • period_endtext
  • segment_nametext
  • segment_typetext
  • currencytext
  • revenuereal
  • units_soldinteger
  • active_customersinteger
  • new_customersinteger
  • churned_customersinteger
headcount4,613 rows
  • company_idtext
  • period_endtext
  • departmenttext
  • currencytext
  • headcount_eominteger
  • new_hiresinteger
  • leaversinteger
  • open_rolesinteger
  • contractor_countinteger
  • payroll_costreal
debt_covenants643 rows
  • company_idtext
  • facility_idtext
  • facility_typetext
  • lendertext
  • facility_currencytext
  • facility_limitreal
  • drawn_amountreal
  • margin_pctreal
  • test_datetext
  • covenant_typetext
  • comparatortext
  • covenant_thresholdreal
  • covenant_actualreal
  • headroomreal
  • breach_flagtext
  • test_statustext
data_quality_ledger12 rows
  • issue_idtext
  • filetext
  • company_idtext
  • periodtext
  • issue_typetext
  • descriptiontext
  • expected_valuetext
  • reported_valuetext
  • severitytext