search

openownership / bodsanalysis

Notebooks and code for analysing data published to the Beneficial Ownership Data Standard
https://www.openownership.org/en/publications/analysis-notebooks-and-dashboards-for-beneficial-ownership-data-standard-bods-data/
MIT License
10 stars 0 forks source link

Add set of queries to capture trends in company dissolution #6

Open StephenAbbott opened 2 years ago

StephenAbbott commented 2 years ago

I'd like us to add a new set of queries to https://github.com/openownership/bodsanalysis/blob/main/qbods.py which show trends in the data we have on companies which have reported both an incorporation date and a dissolution date.

This idea is prompted by recent stories in the UK. As highlighted by Graham Barrow on Twitter and during a parliamentary select committee hearing session on 8th November 2022 (see Guardian coverage), 'burner companies' are those created for a short period of time which can be linked to short-term fraudulent activity.

Proposed queries:

  1. Number of companies in a BODS dataset with a dissolutionDate
  2. Average lifespan of a company in a whole BODS dataset from foundingDate to dissolutionDate
  3. Plot annual trend in average lifespan of a company in a BODS dataset
  4. Average lifespan of a company in the last year from a BODS dataset
  5. Map the addresses of companies dissolved in the last year to see if there is any geographic pattern

These should be added alongside other queries aligned with the 'Up to date and auditable' principle.