SlideShare a Scribd company logo
1 of 32
Download to read offline
BBC Data Day Love Wapping 1
Love Wapping is "Nothing near to a national newspaper" www.lovewapping.org
© 2015 Mark Baynes hello@baynesmedia.com
“In	
  Rahman’s	
  defence,	
  Shahed	
  Ali,	
  the	
  
Independent	
  councillor	
  for	
  Whitechapel	
  
suggested	
  that	
  one	
  source	
  of	
  the	
  allega;ons,	
  
local	
  blog	
  Love	
  Wapping,	
  “is	
  nothing	
  near	
  to	
  
a	
  na;onal	
  newspaper”	
  and	
  that	
  people	
  
should	
  not	
  believe	
  what	
  they	
  read.”
East London Lines
November 28 2013
http://bit.ly/1ygPsyF
BBC Data Day Love Wapping 2
The boring bit. Me.
© 2015 Mark Baynes hello@baynesmedia.com
Experience & Qualifications
• 30 years in media (new & old)
• 20+ years building web sites
• Currently User Experience contractor
• Trade press journalist and editor
• Editorial photographer
• BA Computing & Artificial Intelligence
• MA Media Studies (Multimedia)
• Love Wapping (www.lovewapping.org)
BBC Data Day Love Wapping 3
Tower Hamlets? Where's that then?
© 2015 Mark Baynes hello@baynesmedia.com
Here!
BBC Data Day Love Wapping 4
The East End of London
© 2015 Mark Baynes hello@baynesmedia.com
City of
London CanaryWharf
Tower Hamlets
Greenwich
Newham
Hackney
Southwark
Lewisham
Wapping!
BBC Data Day Love Wapping 5
Wapping. Home of the Waeppa
© 2015 Mark Baynes hello@baynesmedia.com
BBC Data Day Love Wapping 6
The Smoking Gun. Guess what - there isn't one.
© 2015 Mark Baynes hello@baynesmedia.com
BBC Data Day Love Wapping 7
03 November 2013 "Knock knock!"
© 2015 Mark Baynes hello@baynesmedia.com
JAN
2013 2014 2015
NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAYNOV
http://bit.ly/19OB2vq
BBC Data Day Love Wapping 8
Down the rabbit hole.
© 2015 Mark Baynes hello@baynesmedia.com
JAN
2013 2014 2015
NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY
For	
  those	
  of	
  you	
  not	
  on	
  TwiEer	
  here	
  are	
  the	
  highlights	
  
from	
  Ted	
  Jeory’s	
  live	
  coverage	
  of	
  the	
  Tower	
  Hamlets	
  
Council	
  mee;ng	
  last	
  night.	
  It’s	
  amazing	
  what	
  a	
  real	
  
journalist	
  can	
  do	
  with	
  a	
  TwiEer	
  account	
  and	
  a	
  phone	
  
with	
  a	
  very	
  low	
  baEery.
Storify: http://bit.ly/14WQPXd
http://bit.ly/1oMwYiO
NOV
BBC Data Day Love Wapping 9
Data journalism - the myth
© 2015 Mark Baynes hello@baynesmedia.com
BBC Data Day Love Wapping 10
Data journalism - the reality
© 2015 Mark Baynes hello@baynesmedia.com
BBC Data Day Love Wapping 11
Life = Excel
© 2015 Mark Baynes hello@baynesmedia.com
BBC Data Day Love Wapping 12
FOI 9088 - With data...
© 2015 Mark Baynes hello@baynesmedia.com
JAN
2013 2014 2015
NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY
http://bit.ly/PopiXA
APR
BBC Data Day Love Wapping 13
FOI 9087 - Without data.Why?
© 2015 Mark Baynes hello@baynesmedia.com
JAN
2013 2014 2015
NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY
http://bit.ly/PopiXA
APR
BBC Data Day Love Wapping 14
FOI 9087 & 9088 Compared
© 2015 Mark Baynes hello@baynesmedia.com
JAN
2013 2014 2015
NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY
http://bit.ly/PopiXA
APR
BBC Data Day Love Wapping 15
FOI 9087 & 9088 -The Missing Data
© 2015 Mark Baynes hello@baynesmedia.com
JAN
2013 2014 2015
NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY
http://bit.ly/PopiXA
APR
BBC Data Day Love Wapping 16
FOI 9087 & 9088 Metadata compared
© 2015 Mark Baynes hello@baynesmedia.com
JAN
2013 2014 2015
NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY
http://bit.ly/PopiXA
APR
BBC Data Day Love Wapping 17
Tower Hamlets Council payments to suppliers over £500
© 2015 Mark Baynes hello@baynesmedia.com
JAN
2013 2014 2015
NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY
http://bit.ly/P5AXtv
APR
BBC Data Day Love Wapping 18
Tower Hamlets grants funding – why the numbers don’t add up
© 2015 Mark Baynes hello@baynesmedia.com
JAN
2013 2014 2015
NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY
http://bit.ly/1myjzxB
MAY
FOI response 9088 said £2,970,644
Examination of Payment to Suppliers (P2S) data of the same organisations for the
same period gives £11,819,745.
A difference of £8,849,101.
• £709,693 disparity between grants / funding stated in FOI 9088 and stated in Payments to Suppliers
• Four payment records in FOI 9088 compared to 170 in Payments to Suppliers
• Not possible to match payments stated in FOI 9088 to any transaction in Payments to Suppliers.
• Osmani Trust is the only organisation mentioned in FOI 9088, Payments to Suppliers list the Osmani Trust,
Osmani Development Trust and Osmani School
• 20 different Expense Types in Payments to Suppliers
• £29,733 paid on 20th March 2013 through several different Tower Hamlets 'channels' to Osmani Trust
One example.
BBC Data Day Love Wapping 19
Sankey diagram of internal money flowsTower Hamlets council
© 2015 Mark Baynes hello@baynesmedia.com
JAN
2013 2014 2015
NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY
http://bit.ly/1kTbJHR
MAY
BBC Data Day Love Wapping 20
Nine months later.You have found something. How to visualise?
© 2015 Mark Baynes hello@baynesmedia.com
OH.
YES!
BBC Data Day Love Wapping 21
Not like this - just nasty.
© 2015 Mark Baynes hello@baynesmedia.com
NO!
BBC Data Day Love Wapping 22
And absolutely not like this - very nasty.
© 2015 Mark Baynes hello@baynesmedia.com
0%#
5%#
10%#
15%#
20%#
25%#
Bethnal#Green##
Blackwall#&#Cubi8#Town##
Bow#East#
Bow#West##
Bromley#North##
Bromley#South##
Canary#Wharf##
Island#Gardens#
Lansbury#
Limehouse##
Mile#End##
Poplar##
Shadwell#
Spitalfields#&#Banglatown##
St.#Dunstan's##
St.#Katharine's#&#Wapping#
St.#Peter's#
Stepney#Green##
Weavers##
Whitechapel##
Original#Bids#
Officers#RecommendaSon#
Members#Revision#
Cabinet#RecommendaSon#
Final#Grants#
NO!
BBC Data Day Love Wapping 23
Maybe a nice bar chart? Simple is good. But black is often bad.
© 2015 Mark Baynes hello@baynesmedia.com
DULL!
BBC Data Day Love Wapping 24
Possibly something really simple then?
© 2015 Mark Baynes hello@baynesmedia.com
£0# £100,000# £200,000# £300,000# £400,000# £500,000# £600,000# £700,000# £800,000# £900,000# £1,000,000#
Spitalfields#and#Banglatown#
Whitechapel#
Bethnal#Green#South#
Limehouse#
Blackwall#and#CubiH#Town#Ward#
Bethnal#Green#North#
Weavers#
Shadwell#
St.#Dunstan's#and#Stepney#Green#
East#India#and#Lansbury#
Mile#End#East#
Mile#End#and#Globe#Town#
St.#Katharine's#and#Wapping#
BromleyTbyTBow#
Bow#West#
Bow#East#
Millwall#
CFBS#
Community#Chest#
Community#Events#
MSG#
All#pots#
BORING!
BBC Data Day Love Wapping 25
Or something that tells the story at a glance.
© 2015 Mark Baynes hello@baynesmedia.com
JAN
2013 2014 2015
NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY
http://bit.ly/1DmdrNz
OCT
Millwall
Bow East
Bow West
Bromley-by-Bow
Mile End and Globe Town
St. Dunstan's and Stepney Green
Shadwell
St. Katharine's and Wapping
East India and Lansbury
Blackwall and Cubitt Town
Mile End East
Weavers
Bethnal Green North
Limehouse
Whitechapel
Bethnal Green South
Spitalfields and Banglatown
££ £ £ ££ ££ £££ ££ ££££££££
£££ £ £ £ ££ ££££££
£££ £ £ £ £££ £££££
£££ £ £ £££ ££££
££ £ £ ££ ££££
££ £ ££££££
££ £ ££££
££ £ ££££
££ £££
££ £££
££ £££
£££ £££ £
££ £ £
££
£
£ ££
£
£
Electoral WardNumber of Residents in Ward Grant Amount Per Ward Resident
25,000 20,000 15,000 10,000 5,000 0 0 20 40 60 80 100 120
London Borough of Tower Hamlets - Grants Distribution
lovewapping.org
Mark Baynes
@baynesmedia
Sources
Number of Residents in Ward ONS data://bit.ly/1wfwWTD
Grant Amount Per Resident data://bit.ly/1nM8QAS
BBC Data Day Love Wapping 26
Compare your data findings to other datasets.
© 2015 Mark Baynes hello@baynesmedia.com
JAN
2013 2014 2015
NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY
http://bit.ly/1s4skLR
NOV
Percentage of children in poverty,
Oct-Dec 2013 (after housing costs).
Why End Child Poverty
www.endchildpoverty.org.uk
Index scores of overall notifiable
offences per 1,000 daytime population
(2012)
MPS, Home Office, ONS, GLA London
DataStore
Percentage of working-age residents
claiming Jobseeker's Allowance (JSA) or
National Insurance Credits (2012).
GLA London DataStore
Number of residents in ward.
ONS Census 2011.
Office for National Statistics licensed
under the Open Government Licence
v.2.0.
Tower Hamlets Council grants
distribution by electoral ward.
Mainstream Grants, Community Chest,
Community Events and Community Faith
Buildings Support.
www.lovewapping.org
//bit.ly/1wfwWTD //bit.ly/1CR7tSL //bit.ly/Zs1lDa //bit.ly/1DmdrNz //bit.ly/1CR7tSL
Sources
Data links
Millwall
Bow East
Bow West
Bromley-by-Bow
Mile End and Globe Town
St. Dunstan's and Stepney Green
Shadwell
St. Katharine's and Wapping
East India and Lansbury
Blackwall and Cubitt Town
Mile End East
Weavers
Bethnal Green North
Limehouse
Whitechapel
Bethnal Green South
Spitalfields and Banglatown
Unemployment (%)Population (thousands)
Electoral Ward
Child Poverty (%)Child Poverty (%) Grants Distribution (%) Crime Rate (%)
0 5 10 15 20 25 0 5 10 15 20 0 10 20 30 40 50 60 0 2 4 6 8 10 12 14 0 50 100 150 200 250
TOWER HAMLETS GRANTS
QUALITY OF LIFE INDICATORS COMPARED TO COUNCIL GRANTS DISTRIBUTION
Mark Baynes
@baynesmedia
lovewapping.org
BBC Data Day Love Wapping 27
CartoDB is handy. Child Poverty by ward - Millwall
© 2015 Mark Baynes hello@baynesmedia.com
JAN
2013 2014 2015
NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY
http://bit.ly/1tzEMZC
OCT
BBC Data Day Love Wapping 28
Child Poverty by ward - Spitalfields & Banglatown
© 2015 Mark Baynes hello@baynesmedia.com
JAN
2013 2014 2015
NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY
http://bit.ly/1tzEMZC
OCT
BBC Data Day Love Wapping 29
Something I found by chance.An altered press release.
© 2015 Mark Baynes hello@baynesmedia.com
JAN
2013 2014 2015
NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY
http://bit.ly/1H41tux
NOV
BBC Data Day Love Wapping 30
Data Journalism - Essential Geekery
© 2015 Mark Baynes hello@baynesmedia.com
Software Essentials
• Excel (on a PC, not a Mac)
• Refine
• MySQL
• Python
• OmniGraffle (or equivalent)
• Illustrator
• Wordpress
Investigate in a methodical manner
Organise your work
Pencil and paper are good
Sketch lots
Don’t trust online maps
Walk the ground
BBC Data Day Love Wapping 31
Data Journalism -TopTips!
© 2015 Mark Baynes hello@baynesmedia.com
There is not always an app for that. (In fact
there rarely is).
What does your instinct tell you?
Paper still matters
Publish your data, publish your references
Visualise data in the appropriate manner for your
intended audience
Check your data
Check your data
Check your data
Don’t be intimidated
BBC Data Day Love Wapping 32
Stick with it.
© 2015 Mark Baynes hello@baynesmedia.com
@baynesmedia
www.baynesmedia.com
@lovewapping
www.lovewapping.org

More Related Content

Similar to Love Wapping data journalism talk at BBC Data Day 20 January 2015

Creating Resilient Town Centres: 'The Right Ingredients'
Creating Resilient Town Centres: 'The Right Ingredients'Creating Resilient Town Centres: 'The Right Ingredients'
Creating Resilient Town Centres: 'The Right Ingredients'futureoflondon
 
Hyper-Local Insights, Nov-Dec 2011
Hyper-Local Insights, Nov-Dec 2011Hyper-Local Insights, Nov-Dec 2011
Hyper-Local Insights, Nov-Dec 2011Damian Radcliffe
 
Shout NFA Build To Save Report Launch 17 June 2015
Shout NFA Build To Save Report Launch 17 June 2015Shout NFA Build To Save Report Launch 17 June 2015
Shout NFA Build To Save Report Launch 17 June 2015Tim Morton
 
Bristol247 bcfm-marks-10-years-of-broadcasting
Bristol247 bcfm-marks-10-years-of-broadcastingBristol247 bcfm-marks-10-years-of-broadcasting
Bristol247 bcfm-marks-10-years-of-broadcastingBenBehrens1
 
SlideShare ONS Economic Forum Slidepack - 17 July 2023.pptx
SlideShare ONS Economic Forum Slidepack - 17 July 2023.pptxSlideShare ONS Economic Forum Slidepack - 17 July 2023.pptx
SlideShare ONS Economic Forum Slidepack - 17 July 2023.pptxMattBaker737276
 
Remarks by Cllr. Miick Glynn BTCc AGM 2013
Remarks by Cllr. Miick Glynn BTCc AGM 2013Remarks by Cllr. Miick Glynn BTCc AGM 2013
Remarks by Cllr. Miick Glynn BTCc AGM 2013Cllr. Mick Glynn
 
UK and US Hyper Local Update: Sept-Oct 2011 - 20 key developments
UK and US Hyper Local Update: Sept-Oct 2011 - 20 key developmentsUK and US Hyper Local Update: Sept-Oct 2011 - 20 key developments
UK and US Hyper Local Update: Sept-Oct 2011 - 20 key developmentsDamian Radcliffe
 
High Street Data Service
High Street Data ServiceHigh Street Data Service
High Street Data ServiceAlex Gluhak
 
Triangle Open Data Day - Announcements Feb 21, 2015
Triangle Open Data Day - Announcements Feb 21, 2015Triangle Open Data Day - Announcements Feb 21, 2015
Triangle Open Data Day - Announcements Feb 21, 2015Ian Henshaw
 
Jb Hi Fi The Vision, Mission, Values And Challenges Facing...
Jb Hi Fi The Vision, Mission, Values And Challenges Facing...Jb Hi Fi The Vision, Mission, Values And Challenges Facing...
Jb Hi Fi The Vision, Mission, Values And Challenges Facing...Mary Stevenson
 
Shaun Milne - TV's Digital Journey
Shaun Milne - TV's Digital JourneyShaun Milne - TV's Digital Journey
Shaun Milne - TV's Digital JourneyShaun Milne
 
Place AGM 2014: Michael Dall
Place AGM 2014: Michael DallPlace AGM 2014: Michael Dall
Place AGM 2014: Michael DallPlace North West
 

Similar to Love Wapping data journalism talk at BBC Data Day 20 January 2015 (20)

Creating Resilient Town Centres: 'The Right Ingredients'
Creating Resilient Town Centres: 'The Right Ingredients'Creating Resilient Town Centres: 'The Right Ingredients'
Creating Resilient Town Centres: 'The Right Ingredients'
 
Hyper-Local Insights, Nov-Dec 2011
Hyper-Local Insights, Nov-Dec 2011Hyper-Local Insights, Nov-Dec 2011
Hyper-Local Insights, Nov-Dec 2011
 
Shout NFA Build To Save Report Launch 17 June 2015
Shout NFA Build To Save Report Launch 17 June 2015Shout NFA Build To Save Report Launch 17 June 2015
Shout NFA Build To Save Report Launch 17 June 2015
 
Bristol247 bcfm-marks-10-years-of-broadcasting
Bristol247 bcfm-marks-10-years-of-broadcastingBristol247 bcfm-marks-10-years-of-broadcasting
Bristol247 bcfm-marks-10-years-of-broadcasting
 
The bbc
The bbcThe bbc
The bbc
 
Economic Forum - 25 April 2022
Economic Forum - 25 April 2022Economic Forum - 25 April 2022
Economic Forum - 25 April 2022
 
SlideShare ONS Economic Forum Slidepack - 17 July 2023.pptx
SlideShare ONS Economic Forum Slidepack - 17 July 2023.pptxSlideShare ONS Economic Forum Slidepack - 17 July 2023.pptx
SlideShare ONS Economic Forum Slidepack - 17 July 2023.pptx
 
Remarks by Cllr. Miick Glynn BTCc AGM 2013
Remarks by Cllr. Miick Glynn BTCc AGM 2013Remarks by Cllr. Miick Glynn BTCc AGM 2013
Remarks by Cllr. Miick Glynn BTCc AGM 2013
 
Sue Miller, Whitley Bay Big Local
Sue Miller, Whitley Bay Big LocalSue Miller, Whitley Bay Big Local
Sue Miller, Whitley Bay Big Local
 
UK and US Hyper Local Update: Sept-Oct 2011 - 20 key developments
UK and US Hyper Local Update: Sept-Oct 2011 - 20 key developmentsUK and US Hyper Local Update: Sept-Oct 2011 - 20 key developments
UK and US Hyper Local Update: Sept-Oct 2011 - 20 key developments
 
Ledyard Housing Data 2015
Ledyard Housing Data 2015Ledyard Housing Data 2015
Ledyard Housing Data 2015
 
High Street Data Service
High Street Data ServiceHigh Street Data Service
High Street Data Service
 
Economic Forum - Birmingham
Economic Forum - BirminghamEconomic Forum - Birmingham
Economic Forum - Birmingham
 
Triangle Open Data Day - Announcements Feb 21, 2015
Triangle Open Data Day - Announcements Feb 21, 2015Triangle Open Data Day - Announcements Feb 21, 2015
Triangle Open Data Day - Announcements Feb 21, 2015
 
Jb Hi Fi The Vision, Mission, Values And Challenges Facing...
Jb Hi Fi The Vision, Mission, Values And Challenges Facing...Jb Hi Fi The Vision, Mission, Values And Challenges Facing...
Jb Hi Fi The Vision, Mission, Values And Challenges Facing...
 
Cardiff Economic Forum
Cardiff Economic ForumCardiff Economic Forum
Cardiff Economic Forum
 
Bitesize guide to the british media
Bitesize guide to the british mediaBitesize guide to the british media
Bitesize guide to the british media
 
Supporting local policy making
Supporting local policy makingSupporting local policy making
Supporting local policy making
 
Shaun Milne - TV's Digital Journey
Shaun Milne - TV's Digital JourneyShaun Milne - TV's Digital Journey
Shaun Milne - TV's Digital Journey
 
Place AGM 2014: Michael Dall
Place AGM 2014: Michael DallPlace AGM 2014: Michael Dall
Place AGM 2014: Michael Dall
 

Recently uploaded

A_Z-1_0_4T_00A-EN_U-Po_w_erPoint_06.pptx
A_Z-1_0_4T_00A-EN_U-Po_w_erPoint_06.pptxA_Z-1_0_4T_00A-EN_U-Po_w_erPoint_06.pptx
A_Z-1_0_4T_00A-EN_U-Po_w_erPoint_06.pptxjayshuklatrainer
 
Vision Forward: Tracing Image Search SEO From Its Roots To AI-Enhanced Horizons
Vision Forward: Tracing Image Search SEO From Its Roots To AI-Enhanced HorizonsVision Forward: Tracing Image Search SEO From Its Roots To AI-Enhanced Horizons
Vision Forward: Tracing Image Search SEO From Its Roots To AI-Enhanced HorizonsRoxana Stingu
 
TYPES AND DEFINITION OF ONLINE CRIMES AND HAZARDS
TYPES AND DEFINITION OF ONLINE CRIMES AND HAZARDSTYPES AND DEFINITION OF ONLINE CRIMES AND HAZARDS
TYPES AND DEFINITION OF ONLINE CRIMES AND HAZARDSedrianrheine
 
world Tuberculosis day ppt 25-3-2024.pptx
world Tuberculosis day ppt 25-3-2024.pptxworld Tuberculosis day ppt 25-3-2024.pptx
world Tuberculosis day ppt 25-3-2024.pptxnaveenithkrishnan
 
Zero-day Vulnerabilities
Zero-day VulnerabilitiesZero-day Vulnerabilities
Zero-day Vulnerabilitiesalihassaah1994
 
Presentation2.pptx - JoyPress Wordpress
Presentation2.pptx -  JoyPress WordpressPresentation2.pptx -  JoyPress Wordpress
Presentation2.pptx - JoyPress Wordpressssuser166378
 
Introduction to ICANN and Fellowship program by Shreedeep Rayamajhi.pdf
Introduction to ICANN and Fellowship program  by Shreedeep Rayamajhi.pdfIntroduction to ICANN and Fellowship program  by Shreedeep Rayamajhi.pdf
Introduction to ICANN and Fellowship program by Shreedeep Rayamajhi.pdfShreedeep Rayamajhi
 
Check out the Free Landing Page Hosting in 2024
Check out the Free Landing Page Hosting in 2024Check out the Free Landing Page Hosting in 2024
Check out the Free Landing Page Hosting in 2024Shubham Pant
 
Benefits of doing Internet peering and running an Internet Exchange (IX) pres...
Benefits of doing Internet peering and running an Internet Exchange (IX) pres...Benefits of doing Internet peering and running an Internet Exchange (IX) pres...
Benefits of doing Internet peering and running an Internet Exchange (IX) pres...APNIC
 
Niche Domination Prodigy Review Plus Bonus
Niche Domination Prodigy Review Plus BonusNiche Domination Prodigy Review Plus Bonus
Niche Domination Prodigy Review Plus BonusSkylark Nobin
 
WordPress by the numbers - Jan Loeffler, CTO WebPros, CloudFest 2024
WordPress by the numbers - Jan Loeffler, CTO WebPros, CloudFest 2024WordPress by the numbers - Jan Loeffler, CTO WebPros, CloudFest 2024
WordPress by the numbers - Jan Loeffler, CTO WebPros, CloudFest 2024Jan Löffler
 
Bio Medical Waste Management Guideliness 2023 ppt.pptx
Bio Medical Waste Management Guideliness 2023 ppt.pptxBio Medical Waste Management Guideliness 2023 ppt.pptx
Bio Medical Waste Management Guideliness 2023 ppt.pptxnaveenithkrishnan
 
Computer 10 Lesson 8: Building a Website
Computer 10 Lesson 8: Building a WebsiteComputer 10 Lesson 8: Building a Website
Computer 10 Lesson 8: Building a WebsiteMavein
 
LESSON 5 GROUP 10 ST. THOMAS AQUINAS.pdf
LESSON 5 GROUP 10 ST. THOMAS AQUINAS.pdfLESSON 5 GROUP 10 ST. THOMAS AQUINAS.pdf
LESSON 5 GROUP 10 ST. THOMAS AQUINAS.pdfmchristianalwyn
 
LESSON 10/ GROUP 10/ ST. THOMAS AQUINASS
LESSON 10/ GROUP 10/ ST. THOMAS AQUINASSLESSON 10/ GROUP 10/ ST. THOMAS AQUINASS
LESSON 10/ GROUP 10/ ST. THOMAS AQUINASSlesteraporado16
 

Recently uploaded (15)

A_Z-1_0_4T_00A-EN_U-Po_w_erPoint_06.pptx
A_Z-1_0_4T_00A-EN_U-Po_w_erPoint_06.pptxA_Z-1_0_4T_00A-EN_U-Po_w_erPoint_06.pptx
A_Z-1_0_4T_00A-EN_U-Po_w_erPoint_06.pptx
 
Vision Forward: Tracing Image Search SEO From Its Roots To AI-Enhanced Horizons
Vision Forward: Tracing Image Search SEO From Its Roots To AI-Enhanced HorizonsVision Forward: Tracing Image Search SEO From Its Roots To AI-Enhanced Horizons
Vision Forward: Tracing Image Search SEO From Its Roots To AI-Enhanced Horizons
 
TYPES AND DEFINITION OF ONLINE CRIMES AND HAZARDS
TYPES AND DEFINITION OF ONLINE CRIMES AND HAZARDSTYPES AND DEFINITION OF ONLINE CRIMES AND HAZARDS
TYPES AND DEFINITION OF ONLINE CRIMES AND HAZARDS
 
world Tuberculosis day ppt 25-3-2024.pptx
world Tuberculosis day ppt 25-3-2024.pptxworld Tuberculosis day ppt 25-3-2024.pptx
world Tuberculosis day ppt 25-3-2024.pptx
 
Zero-day Vulnerabilities
Zero-day VulnerabilitiesZero-day Vulnerabilities
Zero-day Vulnerabilities
 
Presentation2.pptx - JoyPress Wordpress
Presentation2.pptx -  JoyPress WordpressPresentation2.pptx -  JoyPress Wordpress
Presentation2.pptx - JoyPress Wordpress
 
Introduction to ICANN and Fellowship program by Shreedeep Rayamajhi.pdf
Introduction to ICANN and Fellowship program  by Shreedeep Rayamajhi.pdfIntroduction to ICANN and Fellowship program  by Shreedeep Rayamajhi.pdf
Introduction to ICANN and Fellowship program by Shreedeep Rayamajhi.pdf
 
Check out the Free Landing Page Hosting in 2024
Check out the Free Landing Page Hosting in 2024Check out the Free Landing Page Hosting in 2024
Check out the Free Landing Page Hosting in 2024
 
Benefits of doing Internet peering and running an Internet Exchange (IX) pres...
Benefits of doing Internet peering and running an Internet Exchange (IX) pres...Benefits of doing Internet peering and running an Internet Exchange (IX) pres...
Benefits of doing Internet peering and running an Internet Exchange (IX) pres...
 
Niche Domination Prodigy Review Plus Bonus
Niche Domination Prodigy Review Plus BonusNiche Domination Prodigy Review Plus Bonus
Niche Domination Prodigy Review Plus Bonus
 
WordPress by the numbers - Jan Loeffler, CTO WebPros, CloudFest 2024
WordPress by the numbers - Jan Loeffler, CTO WebPros, CloudFest 2024WordPress by the numbers - Jan Loeffler, CTO WebPros, CloudFest 2024
WordPress by the numbers - Jan Loeffler, CTO WebPros, CloudFest 2024
 
Bio Medical Waste Management Guideliness 2023 ppt.pptx
Bio Medical Waste Management Guideliness 2023 ppt.pptxBio Medical Waste Management Guideliness 2023 ppt.pptx
Bio Medical Waste Management Guideliness 2023 ppt.pptx
 
Computer 10 Lesson 8: Building a Website
Computer 10 Lesson 8: Building a WebsiteComputer 10 Lesson 8: Building a Website
Computer 10 Lesson 8: Building a Website
 
LESSON 5 GROUP 10 ST. THOMAS AQUINAS.pdf
LESSON 5 GROUP 10 ST. THOMAS AQUINAS.pdfLESSON 5 GROUP 10 ST. THOMAS AQUINAS.pdf
LESSON 5 GROUP 10 ST. THOMAS AQUINAS.pdf
 
LESSON 10/ GROUP 10/ ST. THOMAS AQUINASS
LESSON 10/ GROUP 10/ ST. THOMAS AQUINASSLESSON 10/ GROUP 10/ ST. THOMAS AQUINASS
LESSON 10/ GROUP 10/ ST. THOMAS AQUINASS
 

Love Wapping data journalism talk at BBC Data Day 20 January 2015

  • 1. BBC Data Day Love Wapping 1 Love Wapping is "Nothing near to a national newspaper" www.lovewapping.org © 2015 Mark Baynes hello@baynesmedia.com “In  Rahman’s  defence,  Shahed  Ali,  the   Independent  councillor  for  Whitechapel   suggested  that  one  source  of  the  allega;ons,   local  blog  Love  Wapping,  “is  nothing  near  to   a  na;onal  newspaper”  and  that  people   should  not  believe  what  they  read.” East London Lines November 28 2013 http://bit.ly/1ygPsyF
  • 2. BBC Data Day Love Wapping 2 The boring bit. Me. © 2015 Mark Baynes hello@baynesmedia.com Experience & Qualifications • 30 years in media (new & old) • 20+ years building web sites • Currently User Experience contractor • Trade press journalist and editor • Editorial photographer • BA Computing & Artificial Intelligence • MA Media Studies (Multimedia) • Love Wapping (www.lovewapping.org)
  • 3. BBC Data Day Love Wapping 3 Tower Hamlets? Where's that then? © 2015 Mark Baynes hello@baynesmedia.com Here!
  • 4. BBC Data Day Love Wapping 4 The East End of London © 2015 Mark Baynes hello@baynesmedia.com City of London CanaryWharf Tower Hamlets Greenwich Newham Hackney Southwark Lewisham Wapping!
  • 5. BBC Data Day Love Wapping 5 Wapping. Home of the Waeppa © 2015 Mark Baynes hello@baynesmedia.com
  • 6. BBC Data Day Love Wapping 6 The Smoking Gun. Guess what - there isn't one. © 2015 Mark Baynes hello@baynesmedia.com
  • 7. BBC Data Day Love Wapping 7 03 November 2013 "Knock knock!" © 2015 Mark Baynes hello@baynesmedia.com JAN 2013 2014 2015 NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAYNOV http://bit.ly/19OB2vq
  • 8. BBC Data Day Love Wapping 8 Down the rabbit hole. © 2015 Mark Baynes hello@baynesmedia.com JAN 2013 2014 2015 NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY For  those  of  you  not  on  TwiEer  here  are  the  highlights   from  Ted  Jeory’s  live  coverage  of  the  Tower  Hamlets   Council  mee;ng  last  night.  It’s  amazing  what  a  real   journalist  can  do  with  a  TwiEer  account  and  a  phone   with  a  very  low  baEery. Storify: http://bit.ly/14WQPXd http://bit.ly/1oMwYiO NOV
  • 9. BBC Data Day Love Wapping 9 Data journalism - the myth © 2015 Mark Baynes hello@baynesmedia.com
  • 10. BBC Data Day Love Wapping 10 Data journalism - the reality © 2015 Mark Baynes hello@baynesmedia.com
  • 11. BBC Data Day Love Wapping 11 Life = Excel © 2015 Mark Baynes hello@baynesmedia.com
  • 12. BBC Data Day Love Wapping 12 FOI 9088 - With data... © 2015 Mark Baynes hello@baynesmedia.com JAN 2013 2014 2015 NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY http://bit.ly/PopiXA APR
  • 13. BBC Data Day Love Wapping 13 FOI 9087 - Without data.Why? © 2015 Mark Baynes hello@baynesmedia.com JAN 2013 2014 2015 NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY http://bit.ly/PopiXA APR
  • 14. BBC Data Day Love Wapping 14 FOI 9087 & 9088 Compared © 2015 Mark Baynes hello@baynesmedia.com JAN 2013 2014 2015 NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY http://bit.ly/PopiXA APR
  • 15. BBC Data Day Love Wapping 15 FOI 9087 & 9088 -The Missing Data © 2015 Mark Baynes hello@baynesmedia.com JAN 2013 2014 2015 NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY http://bit.ly/PopiXA APR
  • 16. BBC Data Day Love Wapping 16 FOI 9087 & 9088 Metadata compared © 2015 Mark Baynes hello@baynesmedia.com JAN 2013 2014 2015 NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY http://bit.ly/PopiXA APR
  • 17. BBC Data Day Love Wapping 17 Tower Hamlets Council payments to suppliers over £500 © 2015 Mark Baynes hello@baynesmedia.com JAN 2013 2014 2015 NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY http://bit.ly/P5AXtv APR
  • 18. BBC Data Day Love Wapping 18 Tower Hamlets grants funding – why the numbers don’t add up © 2015 Mark Baynes hello@baynesmedia.com JAN 2013 2014 2015 NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY http://bit.ly/1myjzxB MAY FOI response 9088 said £2,970,644 Examination of Payment to Suppliers (P2S) data of the same organisations for the same period gives £11,819,745. A difference of £8,849,101. • £709,693 disparity between grants / funding stated in FOI 9088 and stated in Payments to Suppliers • Four payment records in FOI 9088 compared to 170 in Payments to Suppliers • Not possible to match payments stated in FOI 9088 to any transaction in Payments to Suppliers. • Osmani Trust is the only organisation mentioned in FOI 9088, Payments to Suppliers list the Osmani Trust, Osmani Development Trust and Osmani School • 20 different Expense Types in Payments to Suppliers • £29,733 paid on 20th March 2013 through several different Tower Hamlets 'channels' to Osmani Trust One example.
  • 19. BBC Data Day Love Wapping 19 Sankey diagram of internal money flowsTower Hamlets council © 2015 Mark Baynes hello@baynesmedia.com JAN 2013 2014 2015 NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY http://bit.ly/1kTbJHR MAY
  • 20. BBC Data Day Love Wapping 20 Nine months later.You have found something. How to visualise? © 2015 Mark Baynes hello@baynesmedia.com OH. YES!
  • 21. BBC Data Day Love Wapping 21 Not like this - just nasty. © 2015 Mark Baynes hello@baynesmedia.com NO!
  • 22. BBC Data Day Love Wapping 22 And absolutely not like this - very nasty. © 2015 Mark Baynes hello@baynesmedia.com 0%# 5%# 10%# 15%# 20%# 25%# Bethnal#Green## Blackwall#&#Cubi8#Town## Bow#East# Bow#West## Bromley#North## Bromley#South## Canary#Wharf## Island#Gardens# Lansbury# Limehouse## Mile#End## Poplar## Shadwell# Spitalfields#&#Banglatown## St.#Dunstan's## St.#Katharine's#&#Wapping# St.#Peter's# Stepney#Green## Weavers## Whitechapel## Original#Bids# Officers#RecommendaSon# Members#Revision# Cabinet#RecommendaSon# Final#Grants# NO!
  • 23. BBC Data Day Love Wapping 23 Maybe a nice bar chart? Simple is good. But black is often bad. © 2015 Mark Baynes hello@baynesmedia.com DULL!
  • 24. BBC Data Day Love Wapping 24 Possibly something really simple then? © 2015 Mark Baynes hello@baynesmedia.com £0# £100,000# £200,000# £300,000# £400,000# £500,000# £600,000# £700,000# £800,000# £900,000# £1,000,000# Spitalfields#and#Banglatown# Whitechapel# Bethnal#Green#South# Limehouse# Blackwall#and#CubiH#Town#Ward# Bethnal#Green#North# Weavers# Shadwell# St.#Dunstan's#and#Stepney#Green# East#India#and#Lansbury# Mile#End#East# Mile#End#and#Globe#Town# St.#Katharine's#and#Wapping# BromleyTbyTBow# Bow#West# Bow#East# Millwall# CFBS# Community#Chest# Community#Events# MSG# All#pots# BORING!
  • 25. BBC Data Day Love Wapping 25 Or something that tells the story at a glance. © 2015 Mark Baynes hello@baynesmedia.com JAN 2013 2014 2015 NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY http://bit.ly/1DmdrNz OCT Millwall Bow East Bow West Bromley-by-Bow Mile End and Globe Town St. Dunstan's and Stepney Green Shadwell St. Katharine's and Wapping East India and Lansbury Blackwall and Cubitt Town Mile End East Weavers Bethnal Green North Limehouse Whitechapel Bethnal Green South Spitalfields and Banglatown ££ £ £ ££ ££ £££ ££ ££££££££ £££ £ £ £ ££ ££££££ £££ £ £ £ £££ £££££ £££ £ £ £££ ££££ ££ £ £ ££ ££££ ££ £ ££££££ ££ £ ££££ ££ £ ££££ ££ £££ ££ £££ ££ £££ £££ £££ £ ££ £ £ ££ £ £ ££ £ £ Electoral WardNumber of Residents in Ward Grant Amount Per Ward Resident 25,000 20,000 15,000 10,000 5,000 0 0 20 40 60 80 100 120 London Borough of Tower Hamlets - Grants Distribution lovewapping.org Mark Baynes @baynesmedia Sources Number of Residents in Ward ONS data://bit.ly/1wfwWTD Grant Amount Per Resident data://bit.ly/1nM8QAS
  • 26. BBC Data Day Love Wapping 26 Compare your data findings to other datasets. © 2015 Mark Baynes hello@baynesmedia.com JAN 2013 2014 2015 NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY http://bit.ly/1s4skLR NOV Percentage of children in poverty, Oct-Dec 2013 (after housing costs). Why End Child Poverty www.endchildpoverty.org.uk Index scores of overall notifiable offences per 1,000 daytime population (2012) MPS, Home Office, ONS, GLA London DataStore Percentage of working-age residents claiming Jobseeker's Allowance (JSA) or National Insurance Credits (2012). GLA London DataStore Number of residents in ward. ONS Census 2011. Office for National Statistics licensed under the Open Government Licence v.2.0. Tower Hamlets Council grants distribution by electoral ward. Mainstream Grants, Community Chest, Community Events and Community Faith Buildings Support. www.lovewapping.org //bit.ly/1wfwWTD //bit.ly/1CR7tSL //bit.ly/Zs1lDa //bit.ly/1DmdrNz //bit.ly/1CR7tSL Sources Data links Millwall Bow East Bow West Bromley-by-Bow Mile End and Globe Town St. Dunstan's and Stepney Green Shadwell St. Katharine's and Wapping East India and Lansbury Blackwall and Cubitt Town Mile End East Weavers Bethnal Green North Limehouse Whitechapel Bethnal Green South Spitalfields and Banglatown Unemployment (%)Population (thousands) Electoral Ward Child Poverty (%)Child Poverty (%) Grants Distribution (%) Crime Rate (%) 0 5 10 15 20 25 0 5 10 15 20 0 10 20 30 40 50 60 0 2 4 6 8 10 12 14 0 50 100 150 200 250 TOWER HAMLETS GRANTS QUALITY OF LIFE INDICATORS COMPARED TO COUNCIL GRANTS DISTRIBUTION Mark Baynes @baynesmedia lovewapping.org
  • 27. BBC Data Day Love Wapping 27 CartoDB is handy. Child Poverty by ward - Millwall © 2015 Mark Baynes hello@baynesmedia.com JAN 2013 2014 2015 NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY http://bit.ly/1tzEMZC OCT
  • 28. BBC Data Day Love Wapping 28 Child Poverty by ward - Spitalfields & Banglatown © 2015 Mark Baynes hello@baynesmedia.com JAN 2013 2014 2015 NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY http://bit.ly/1tzEMZC OCT
  • 29. BBC Data Day Love Wapping 29 Something I found by chance.An altered press release. © 2015 Mark Baynes hello@baynesmedia.com JAN 2013 2014 2015 NOV DEC JAN FEB MAR JUN JULY AUG SEPT OCT NOV DECAPR MAY http://bit.ly/1H41tux NOV
  • 30. BBC Data Day Love Wapping 30 Data Journalism - Essential Geekery © 2015 Mark Baynes hello@baynesmedia.com Software Essentials • Excel (on a PC, not a Mac) • Refine • MySQL • Python • OmniGraffle (or equivalent) • Illustrator • Wordpress Investigate in a methodical manner Organise your work Pencil and paper are good Sketch lots Don’t trust online maps Walk the ground
  • 31. BBC Data Day Love Wapping 31 Data Journalism -TopTips! © 2015 Mark Baynes hello@baynesmedia.com There is not always an app for that. (In fact there rarely is). What does your instinct tell you? Paper still matters Publish your data, publish your references Visualise data in the appropriate manner for your intended audience Check your data Check your data Check your data Don’t be intimidated
  • 32. BBC Data Day Love Wapping 32 Stick with it. © 2015 Mark Baynes hello@baynesmedia.com @baynesmedia www.baynesmedia.com @lovewapping www.lovewapping.org