Boris Johnson will today be put under pressure to back calls for Met assistant commissioner John Yates to resign.

Dee Doocey, a liberal Democrat member of the London assembly who is also a member of the Metropolitan Police Authority, released dates of dinners and lunches attended by senior Met policing figures over the past few years, including since allegations of phone hacking at the News of the World first surfaced - based on a freedom of information request and information released by the Metropolitan police at the request of MPA members.

Yates, who was responsible for reviewing the evidence the phone hacking affair has in 2009 and who now has responsibility for counter terrorism, wrote to London mayor Boris Johnson on Monday to express "great regret" for previously reassuring him that the initial inquiry into phone hacking had been "thorough" .

Giving evidence to the Home Affairs Select Committee in light of the fast moving events of last week, Yates expressed the regret he felt at the way those affected were handled under his watch, and for ruling that there was no need to reopen the phone-hacking investigation in 2009. But he insisted this was "not a resignation matter" and that he intended to continue in his job. Asked by the chair of the committee, Keith, Vaz if he had considered his position, Yates told him: "No I haven't offered to resign. If you are suggesting that I should resign for what News of the World has done, I think that is probably unfair."

Doocey, who is the LibDems' city hall spokeswoman on policing, published information secured under a Freedom of Information request which showed Yates had five lunches with staff from the News International stable: three with the Sun newspaper, in August 2008, January 2009 and March 2009, one with the Sunday Times in 2009, and one in November that year with the editor and crime editor of News of the World.

Doocey called on him to quit: "It is shameful that John Yates found time to have five lunches with the News of the World and News International, but after just a few hours decided there was no additional evidence to justify a further investigation into phone hacking.

"John Yates has failed literally hundreds of victims of phone hacking. While he remains in post as Assistant Commissioner of the Met its reputation will not recover.He must take responsibility for this pitiful review and accept that he has lost all credibility. It is time for him to go."

The data that Doocey obtained is below. What can you do with it?

Data summary

News International meetings with senior Metropolitan Police officers Click heading to sort. Download this data Date Occasion Attendees Source .November 8, 2005. Dinner with News of the World Andy Hayman FOI request .February 1, 2006. Lunch with Editorial Staff, The Times Andy Hayman Response to request from MPA .February 1, 2006. Lunch with Editorial Staff, The Times Sir Ian Blair (Commissioner), Paul Stephenson (Deputy Commissioner) Response to request from MPA .March 1, 2006. Meeting Editor, Sunday Times Sir Ian Blair (Commissioner) Response to request from MPA .April 25, 2006. Dinner with News of the World Andy Hayman FOI request .June 1, 2006. Meeting Editor, The Sun Sir Ian Blair (Commissioner) Response to request from MPA .September 1, 2006. Dinner with Deputy Editor, News of the World Paul Stephenson (Deputy Commisioner) Response to request from MPA .November 1, 2006. Lunch, Editor Sunday Times Sir Ian Blair (Commissioner) Response to request from MPA .December 1, 2006. Meeting Editor The Times Sir Ian Blair (Commissioner) Response to request from MPA .March 29, 2007. Lunch with News of the World Andy Hayman FOI request .June 1, 2007. Lunch Editorial Staff, News of the World Sir Ian Blair (Commissioner) Response to request from MPA .July 1, 2007. Drinks Reception, The Times Andy Hayman Response to request from MPA .September 1, 2007. Lunch Editor The Sun Sir Ian Blair (Commissioner) Response to request from MPA .September 5, 2007. Lunch with News of the World Andy Hayman FOI request .November 1, 2007. Dinner with Deputy Editor, News of the World Paul Stephenson (Deputy Commisioner) Response to request from MPA .November 16, 2007. Lunch with News of the World Andy Hayman FOI request .February 1, 2008. Dinner with Deputy Editor, News of the World Paul Stephenson (Deputy Commisioner) Response to request from MPA .April 1, 2008. Dinner Deputy Editor The Sun Sir Paul Stephenson (Deputy Commissioner) Response to request from MPA .August 29, 2008. Lunch with The Times John Yates FOI request .October 1, 2008. Meeting with Deputy Editor, News of the World Paul Stephenson (Deputy Commisioner) Response to request from MPA .October 1, 2008. Dinner with Deputy Editor, News of the World Paul Stephenson (Deputy Commisioner) Response to request from MPA .January 6, 2009. Lunch with The Sun John Yates FOI request .February 1, 2009. Dinner with Deputy Editor, News of the World Paul Stephenson (Commisioner) Response to request from MPA .March 20, 2009. Lunch with The Sun John Yates FOI request .April 1, 2009. Lunch Editor The Sun Paul Stephenson (Commisioner) Response to request from MPA .May 1, 2009. Dinner with Deputy Editor, News of the World Paul Stephenson (Commisioner) Response to request from MPA .June 1, 2009. News Corporation reception Paul Stephenson (Commisioner) Response to request from MPA .June 1, 2009. Lunch Editor The Times Paul Stephenson (Commisioner) Response to request from MPA .June 1, 2009. Dinner with Deputy Editor, News of the World Paul Stephenson (Commisioner) Response to request from MPA .July 1, 2009. Lunch Editor Sunday Times Paul Stephenson (Commisioner) Response to request from MPA .September 8, 2009. Dinner with The Sunday Times John Yates FOI request .November 1, 2009. Lunch Head of News, Sky News Paul Stephenson (Commisioner) Response to request from MPA .November 5, 2009. Dinner with Editor and Crime Editor News of the World John Yates FOI request .April 1, 2010. Lunch Chief Executive News International Paul Stephenson (Commisioner) Response to request from MPA .June 1, 2010. News Corporation reception Paul Stephenson (Commisioner) Response to request from MPA .November 1, 2010. Drinks Editor The Sun Paul Stephenson (Commisioner) Response to request from MPA

• DATA: download the full spreadsheet

More open data

Data journalism and data visualisations from the Guardian

World government data

• Search the world's government data with our gateway

Development and aid data

• Search the world's global development data with our gateway

Can you do something with this data?

• Flickr Please post your visualisations and mash-ups on our Flickr group

• Contact us at data@guardian.co.uk

• Get the A-Z of data

• More at the Datastore directory

• Follow us on Twitter

• Like us on Facebook