Every figure, and the query behind it
Queried live at render time against the same database files the API and site read from.
Counts
| Metric | Value | Query |
|---|---|---|
| companies | 5,689,367 | select count(*) from company (companies.db) |
| charities | 396,157 | select count(*) from charity (sectorwatch.db) |
| trustees | 833,035 | select count(*) from trustee_person (sectorwatch.db) |
| schools | 26,106 | select count(*) from school (schools_gov.db) |
| governors | 223,436 | select count(*) from gov_person (schools_gov.db) |
| trusts | 2,070 | select count(distinct trust_name) from trust_link (schools_gov.db) |
| parliament | 1,879 | select count(*) from person (au_parliament.db) |
| pubappt_orgs | 1,372 | select count(*) from organisation (ext/uk_public_appointments.db) |
| pubappt_people | 2,187 | select count(*) from person (ext/uk_public_appointments.db) |
| pubappt_appts | 3,537 | select count(*) from appointment (ext/uk_public_appointments.db) |
| nhs_orgs | 324 | select count(*) from organisation (ext/nhs_organisations.db) |
| nhs_board | 1,163 | select count(*) from board_member (ext/nhs_boards.db) |
| councils | 382 | select count(*) from council (ext/councillors.db) |
| councillors | 21,307 | select count(*) from councillor (ext/councillors.db) |
| finance_filings | 4,079,126 | select count(*) from finance_filing (ext/company_finance.db) |
| finance_companies | 3,203,078 | select count(distinct company_number) from finance_filing (ext/company_finance.db) |
| grants | 1,916,508 | select count(*) from grant_slim (ext/grants_slim.db) |
| contracts | 79,185 | select count(*) from contract (ext/contracts.db) |
| groups | 6,873,260 | select count(*) from company_group (ext/groups.db) |
| psc_edges | 9,341,880 | select count(*) from psc_edge (ext/groups.db) |
| disqualified | n/a | select count(*) from disq_person (ext/disqualified.db) |
| confirmed_overlaps | 357,644 | select value from stats where metric='confirmed_links' (company_network.db) |
| trustees_processed | 278,580 | select value from stats where metric='trustees_processed' (company_network.db) |
| ie_orgs | 14,145 | select count(*) from organisation (ireland.db) |
| ie_people | 60,694 | select count(*) from person (ireland.db) |
| ie_boards_orgs | 195 | select count(*) from organisation (ie_boards.db) |
| us_orgs | 1,983,563 | select count(*) from organisation (us.db) |
| us_people | 4,979,148 | select count(*) from person (us.db) |
| ca_orgs | 134,949 | select count(*) from organisation (ca.db) |
| ca_people | 4,235,059 | select count(*) from person (ca.db) |
| cafed_orgs | 201 | select count(*) from organisation (ca_federal.db) |
| au_orgs | 66,013 | select count(*) from organisation (au.db) |
| au_people | 921 | select count(*) from person (au.db) |
| nz_orgs | 52,324 | select count(*) from organisation (nz.db) |
| nz_people | 584,458 | select count(*) from person (nz.db) |
| sco_orgs | 25,048 | select count(*) from organisation (scotland.db) |
| sco_people | 115,494 | select count(*) from person (scotland.db) |
| ni_orgs | 8,358 | select count(*) from organisation (ni.db) |