regmem: mps_ranked_by_matching_shareholdings

Custom SQL query returning 5 rows (hide)

select
  people.id,
  people.name,
  count(*) as num_items,
  json_group_array(json_object('name', item, 'date', date, 'category', categories.name)) as shareholding_items
from
  items
  join people on items.person_id = people.id
  join categories on items.category_id = categories.id
where
  items.category_id in (
    -- All forms of shareholding
    "Aead2f460",
    "a5bbc519",
    "3aff2389",
    "21983754",
    "5b34324e",
    "b1cf7e3e"
  )
  and items.rowid in (
    select
      rowid
    from
      [items_fts]
    where
      [item] match (
        case
          WHEN :search = '' then '*'
          else :search
        end
      )
  )
group by
  items.person_id
order by
  num_items desc;

Query parameters

Edit SQL

This data as json, CSV

id	name	num_items	shareholding_items
uk.org.publicwhip/person/25377	Chris Philp	110	[ { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2015-06-08", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2015-07-13", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2015-08-10", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2015-09-07", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2015-09-28", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2015-10-12", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2015-10-26", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2015-11-09", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2015-11-30", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2015-12-14", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2016-01-11", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2016-01-25", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2016-02-08", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2016-02-22", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2016-03-07", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2016-03-21", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2016-04-18", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2016-05-03", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2016-05-16", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2016-06-06", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus) ; property development and investment in E Europe (Registered 05 June 2015)", "date": "2016-06-27", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe (Registered 05 June 2015)", "date": "2016-07-11", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2016-08-01", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2016-09-05", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2016-10-03", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2016-10-17", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2016-10-31", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2016-11-21", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2016-12-05", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2016-12-19", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-01-09", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-01-23", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-02-06", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-02-20", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-03-06", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-03-20", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-04-10", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-05-02", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-07-07", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-07-31", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-08-29", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-09-11", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-10-09", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-10-23", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-11-13", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-11-27", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2017-12-11", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-01-08", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-01-22", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-02-05", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-02-19", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-03-05", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-03-19", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-04-16", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-04-30", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-05-14", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-06-04", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-06-18", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-07-02", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-07-16", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-08-13", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-09-10", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-10-01", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-10-15", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-10-29", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-11-19", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-12-03", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2018-12-17", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-01-07", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-01-21", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-02-04", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-02-18", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-03-04", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-03-18", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-04-01", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-04-23", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-05-07", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-05-20", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-06-03", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-06-17", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-07-01", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-07-15", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-07-29", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-08-12", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-09-02", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-09-16", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-09-30", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-10-21", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2019-11-05", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2020-01-11", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2020-02-10", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2020-03-02", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2020-03-16", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2020-03-30", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2020-04-14", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2020-04-27", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2020-05-11", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2020-05-26", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2020-06-08", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2020-06-22", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2020-07-06", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015)", "date": "2020-07-20", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "Until 7 November 2019, BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015; updated 23 July 2020)", "date": "2020-08-10", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "Until 7 November 2019, BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015; updated 23 July 2020)", "date": "2020-09-01", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "Until 7 November 2019, BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015; updated 23 July 2020)", "date": "2020-09-14", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "Until 7 November 2019, BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015; updated 23 July 2020)", "date": "2020-09-28", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "Until 7 November 2019, BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015; updated 23 July 2020)", "date": "2020-10-12", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "Until 7 November 2019, BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015; updated 23 July 2020)", "date": "2020-10-26", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "Until 7 November 2019, BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015; updated 23 July 2020)", "date": "2020-11-09", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" }, { "name": "Until 7 November 2019, BP Balkans Pluto (Cyprus); property development and investment in E Europe. (Registered 05 June 2015; updated 23 July 2020)", "date": "2020-11-23", "category": "(ii) Other shareholdings, valued at more than \u00a370,000" } ]
uk.org.publicwhip/person/10854	Jonathan Djanogly	59	[ { "name": " BP plc; oil", "date": "2006-11-27", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2006-12-11", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-01-09", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-01-23", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-02-06", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-02-27", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-03-13", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-03-26", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-05-01", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-05-15", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-06-05", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-06-19", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-07-03", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-07-17", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-07-30", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-08-28", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-10-09", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-10-23", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-11-06", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-11-20", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-12-04", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2007-12-18", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-01-09", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-01-22", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-02-05", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-02-26", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-03-11", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-03-25", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-04-23", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-06-16", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-07-08", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-07-22", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-09-03", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-10-08", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-10-22", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-11-05", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-11-19", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-12-03", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2008-12-17", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-01-14", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-01-28", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-02-11", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-02-25", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-03-11", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-03-25", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-04-22", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-05-06", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-05-20", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-06-10", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-06-24", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-07-08", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-07-21", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-09-02", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-10-14", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-10-28", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-11-11", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-11-25", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2009-12-10", "category": "Registrable shareholdings" }, { "name": " BP plc; oil", "date": "2010-01-06", "category": "Registrable shareholdings" } ]
uk.org.publicwhip/person/11420	John Hemming	58	[ { "name": " BP", "date": "2011-04-18", "category": "Registrable shareholdings" }, { "name": " BP", "date": "2011-05-03", "category": "Registrable shareholdings" }, { "name": " BP", "date": "2011-05-16", "category": "Registrable shareholdings" }, { "name": " BP", "date": "2011-06-06", "category": "Registrable shareholdings" }, { "name": " BP", "date": "2011-06-20", "category": "Registrable shareholdings" }, { "name": " BP", "date": "2011-07-06", "category": "Registrable shareholdings" }, { "name": " BP", "date": "2011-07-19", "category": "Registrable shareholdings" }, { "name": " BP", "date": "2011-08-30", "category": "Registrable shareholdings" }, { "name": " \nBP\n (registered 30 July 2012)", "date": "2012-07-30", "category": "Registrable shareholdings" }, { "name": " \nBP\n (registered 30 July 2012)", "date": "2012-09-03", "category": "Registrable shareholdings" }, { "name": " \nBP\n (registered 30 July 2012)", "date": "2012-10-01", "category": "Registrable shareholdings" }, { "name": " \nBP\n (registered 30 July 2012)", "date": "2012-10-22", "category": "Registrable shareholdings" }, { "name": " \nBP\n (registered 30 July 2012)", "date": "2012-11-05", "category": "Registrable shareholdings" }, { "name": " \nBP\n (registered 30 July 2012)", "date": "2012-11-19", "category": "Registrable shareholdings" }, { "name": " \nBP\n (registered 30 July 2012)", "date": "2012-12-03", "category": "Registrable shareholdings" }, { "name": " \nBP\n (registered 30 July 2012)", "date": "2012-12-19", "category": "Registrable shareholdings" }, { "name": " \nBP\n (registered 30 July 2012)", "date": "2013-01-18", "category": "Registrable shareholdings" }, { "name": " \nBP\n (registered 30 July 2012)", "date": "2013-02-04", "category": "Registrable shareholdings" }, { "name": " \nBP\n (registered 30 July 2012)", "date": "2013-02-25", "category": "Registrable shareholdings" }, { "name": " \nBP\n (registered 30 July 2012)", "date": "2013-03-11", "category": "Registrable shareholdings" }, { "name": " \nBP\n (registered 30 July 2012)", "date": "2013-04-08", "category": "Registrable shareholdings" }, { "name": " \nBP\n (registered 30 July 2012)", "date": "2013-04-22", "category": "Registrable shareholdings" }, { "name": " \nBP\n (registered 30 July 2012)", "date": "2013-05-07", "category": "Registrable shareholdings" }, { "name": " \nBP\n (registered 30 July 2012)", "date": "2013-05-20", "category": "Registrable shareholdings" }, { "name": " \nBP\n (Registered 30 July 2012)", "date": "2013-06-10", "category": "Registrable shareholdings" }, { "name": " \nBP\n (Registered 30 July 2012)", "date": "2013-06-24", "category": "Registrable shareholdings" }, { "name": " \nBP\n (Registered 30 July 2012)", "date": "2013-07-08", "category": "Registrable shareholdings" }, { "name": " \nBP\n (Registered 30 July 2012)", "date": "2013-07-29", "category": "Registrable shareholdings" }, { "name": " \nBP\n (Registered 30 July 2012)", "date": "2013-08-27", "category": "Registrable shareholdings" }, { "name": " \nBP\n (Registered 30 July 2012)", "date": "2013-09-09", "category": "Registrable shareholdings" }, { "name": " \nBP\n (Registered 30 July 2012)", "date": "2013-09-30", "category": "Registrable shareholdings" }, { "name": " \nBP\n (Registered 30 July 2012)", "date": "2013-10-14", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2013-10-28", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2013-11-11", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2013-11-25", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2013-12-09", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-01-06", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-01-20", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-02-03", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-02-24", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-03-10", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-03-21", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-03-24", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-04-07", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-04-28", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-05-12", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-06-02", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-06-16", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-06-30", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-07-14", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-07-28", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-08-26", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-09-22", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-10-13", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-10-27", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-11-10", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-11-24", "category": "Registrable shareholdings" }, { "name": " \nBP\n, until October 2013(Registered 30 July 2012; updated 18 October 2013)", "date": "2014-12-08", "category": "Registrable shareholdings" } ]
uk.org.publicwhip/person/10457	Archie Norman	10	[ { "name": "BP; oil and related.", "date": "2002-11-26", "category": "Registrable shareholdings" }, { "name": "BP; oil and related", "date": "2003-12-04", "category": "Registrable shareholdings" }, { "name": "BP; oil and related", "date": "2004-01-31", "category": "Registrable shareholdings" }, { "name": "BP; oil and related", "date": "2004-05-21", "category": "Registrable shareholdings" }, { "name": "BP; oil and related", "date": "2004-07-16", "category": "Registrable shareholdings" }, { "name": "BP; oil and related", "date": "2004-09-08", "category": "Registrable shareholdings" }, { "name": "BP; oil and related", "date": "2004-10-22", "category": "Registrable shareholdings" }, { "name": "BP; oil and related", "date": "2004-12-03", "category": "Registrable shareholdings" }, { "name": "(b) BP; oil and related", "date": "2005-01-28", "category": "Registrable shareholdings" }, { "name": "(b) BP; oil and related", "date": "2005-04-11", "category": "Registrable shareholdings" } ]
uk.org.publicwhip/person/10509	Marion Roe	8	[ { "name": "BP", "date": "2004-01-31", "category": "Registrable shareholdings" }, { "name": " BP", "date": "2004-05-21", "category": "Registrable shareholdings" }, { "name": " BP", "date": "2004-07-16", "category": "Registrable shareholdings" }, { "name": " BP", "date": "2004-09-08", "category": "Registrable shareholdings" }, { "name": " BP", "date": "2004-10-22", "category": "Registrable shareholdings" }, { "name": " BP", "date": "2004-12-03", "category": "Registrable shareholdings" }, { "name": "BP", "date": "2005-01-28", "category": "Registrable shareholdings" }, { "name": "BP", "date": "2005-04-11", "category": "Registrable shareholdings" } ]