Category Archives: online journalism

Local newspaper data journalism – school admissions in Birmingham

data journalism at the Birmingham Mail - school admissions data

The Birmingham Mail has been trying its hand at data journalism with school admissions data. It’s a good place to start – the topic attracts a lot of interest (and so justifies the investment of time) while people tend to be interested in more than just who finishes top and bottom of the tables (justifying the choice of medium).

The results are impressive. Applications data is plotted on a Google map on the main page, while an “interactive chart” page allows you to compare schools across various criteria, and also narrow the sample by selecting from two drop down menus (town and school).

The charts have been made in Tableau, which includes a download link at the bottom. However, you need Tableau itself (free, but PC only) to open it.

A further page features links to tables for each area. Sadly, the pages containing tables do not contain any link to the raw data. This presents an extra hurdle to users – although you can scrape the table into a Google spreadsheet using the =import formula. If you want to see how, here’s a spreadsheet I created from the data by doing just that. Click on the first cell to see the formula that generates it.

I asked David Higgerson, Trinity Mirror’s Head of Multimedia and the man whose name appears on the Tableau data, to explain the process behind the project. It seems the information was a combination of freely available data and that acquired via FOI.

“The Mail took the data available – number of places available, number of first choice applicants and number of total applicants – and worked out a ratio of first choice applicants per place. This is relevant to parents because councils try to allocate places to children based on preference once they’ve decided which schools a child is eligible for. Eligibility varies depending on type of school.

“The figures showed how popular faith schools were, and also how fierce competition was for places at grammar schools. That’s the story which generated most interest.

“As you’ve said on your blog, the hardest part was making the data uniform, and the making it relevant to readers.

“In print, it ran across three days. Day one was grammar schools, day two was all schools and day three revealed how catchment areas for oversubscribed schools which use distance from school to fill their last few places.

“Online, Google Fusion was used to create maps, Tableau for the interactive chart which lets people choose based on town or school, and Tableizer for the quick tables which appear in the section too. We also had a play with Scribble Maps, which we think has real potential for print/online newsrooms.”

It seems education reporter Kat Keogh deserves the credit for spotting the stories in the data, “with the usual support you’d expect in the newsroom – newsdesk etc.”

David and Anna Jeys experimented with the online presentation and others laid out the data for print.

BBC new linking guidelines issued – science journals mentioned

9 Replies

The BBC have just emailed new linking guidelines to their staff. They stipulate that linking is “essential” to online journalism and in one slide (it’s a PowerPoint document) titled ‘If you remember nothing else’ highlight how linking will change:

What we used to do…

Lists of archive news stories

Homepages only on external websites

No inline linking in news stories

What we do now – think adding value…

Avoid news stories and link to useful stuff – analysis, explainers, Q&As, pic galleries etc

On external websites look beyond homepage to pages of specific relevance

Inline linking in news stories is OK when it’s to a primary source

Other points of note in the document include the repeated emphasis on useful deep linking, and the importance of the newstracker module (which links to coverage on other news sites). Curiously, when referring to inline links it does say that “different rules can apply” to BBC blogs – “speak to blogs team if in doubt”.

Something I did look for – and find – was a reference to linking to scientific journals. And here it is: “In news stories inline links must go to primary sources only– eg scientific journal article or policy report (1 or 2 per story; avoid intro)”

This is significant given the previous campaigning on this issue.

On the whole it’s a good set of guidance – I’ll refrain from publishing it in hope that the BBC will…

UPDATE: It seems The Guardian followed up the story and embedded the document, so here it is:

View this document on Scribd

BBC guidelines for linking – Sept 2010

Online journalism student RSS reader starter pack: 50 RSS feeds

40 Replies

Teaching has begun in the new academic year and once again I’m handing out a list of recommended RSS feeds. Last year this came in the form of an OPML file, but this year I’m using Google Reader bundles (instructions on how to create one of your own are here). There are 50 feeds in all – 5 feeds in each of 10 categories. Like any list, this is reliant on my own circles of knowledge and arbitrary in various respects. But it’s a start. I’d welcome other suggestions.

Here is the list with links to the bundles. Each list is in alphabetical order – there is no ranking:

5 of the best: Community

A link to the bundle allowing you to add it to your Google Reader is here.

Blaise Grimes-Viort
Community Building & Community Management
FeverBee
ManagingCommunities.com
Online Community Strategist

5 of the best: Data

This was a particularly difficult list to draw up – I went for a mix of visualisation (FlowingData), statistics (The Numbers Guy), local and national data (CountCulture and Datablog) and practical help on mashups (OUseful). I cheated a little by moving computer assisted reporting blog Slewfootsnoop into the 5 UK feeds and 10,000 Words into Multimedia. Bundle link here. Continue reading →

Interview: Ton Zijlstra on open data in the EU (audio)

Something I wrote for the Guardian Datablog (and caveats)

Hyperlocal voices: Adirondack Almanack / John Warren

1 Reply

hyperlocal voices - Adirondack Almanack, John Warren

Following a nomination via the Online Journalism Blog Facebook group, this Hyperlocal Voices looks at a US blog: the Adirondack Almanack, which covers the rural Adirondack region of upstate New York.

Launched in 2005 out of frustration with the lack of coverage from the mainstream media, the site now boasts 20 contributors, “mostly veteran local writers, journalists, and editors and includes media professionals from local radio, magazines, and newspapers,” says founder John Warren. Here’s the full interview with John:

What made you decide to set up the blog?

The Adirondacks is home to the largest park and the largest state-level protected area in the contiguous United States (it’s also the largest National Historic Landmark). The park is over 6 million acres in size (that makes it bigger than Vermont, or Yellowstone, Yosemite, Grand Canyon, Glacier, and Great Smoky Mountains National Parks combined).

However, about half the land is publicly owned and the rest privately owned, including several villages. That mix of public and private land makes the Park a unique area and fodder for some heated discussions over sustainable development, wilderness, environmental and outdoor recreation issues. I felt strongly that local news media was not fully representing the variety of perspectives on these important issues – many of which are important in other parts of the country as well. Continue reading →

Hyperlocal voices: Jon Clarke (Beckenhamtown.us)

Who were the people behind the blog, and what were their backgrounds before setting it up?

Me, and no one else, I’ve been in digital media at various ad agencies for over 10 years and therefore am au fait with lots of the ways to create and promote a website.

What made you decide to set up the blog?

The main reason was that I thought Beckenham was not well served with a ‘live’ and ‘community’ based website, there just weren’t any for what is quite a neighbourly area for neighbours to talk and share local things.

When did you set up the blog and how did you go about it?

The site was set up in August 2008. I’m not a programmer or web designer so I used the Ning.com community website platform that allows one to cut and paste and move various features around to make a good community site. I then used my knowledge to bring in lots of dynamic content, widgets and RSS feeds to pad out the site and bring it alive.

I wanted to use a co.uk address but it was gone so I plumped instead for a .US address. I thought it best represented who the website was for and about – all of US in Beckenham Town. Continue reading →

A brilliant Donald Duck mashup – Right Wing Radio Duck

2 Replies

Jonathan McIntosh of Rebellious Pixels has just published a mashup of Donald Duck cartoons matched to a mashed-up Glenn Beck (of Fox News) voice track, called “Right Wing Radio Duck”.

[youtube:http://www.youtube.com/watch?v=HfuwNU0jsk0%5D

Jonathan has taken dozens of segments from the cartoon archives, and dozens of voice clips from Glenn Back, to create a new jigsaw from existing pieces, satirising the North American Right.

This is work of studio quality. Alternatively, it can be produced by an individual in their bedroom, and can potentially in this case be a career-creating “splash”.

Either way, it demonstrates how high the bar can be raised. It also illustates the advantages of having a liberal set of copyright laws. How difficult would it be to make this in the UK?

Here’s the Youtube blurb:

“This is a re-imagined Donald Duck cartoon remix constructed using dozens of classic Walt Disney cartoons from the 1930s to 1960s. Donald’s life is turned upside-down by the current economic crisis and he finds himself unemployed and falling behind on his house payments. As his frustration turns into despair Donald discovers a seemingly sympathetic voice coming from his radio named Glenn Beck.

“This transformative remix work constitutes a fair-use of any copyrighted material as provided for in section 107 of the US copyright law. “Right Wing Radio Duck” by Jonathan McIntosh is licensed under a Creative Commons BY-NC-SA 3.0 License – permitting non-commercial sharing with attribution.”

As a contrast, this below is an agitprop video produced by Lib Dem campaigners within a few hours of Gordon Brown’s decision to back away from holding an Election in Autumn 2007. This one was made so quickly, that they used a US version of “The Grand Old Duke of York”.

[youtube:http://www.youtube.com/watch?v=l22kHO5jdRU%5D

This video did not circulate outside the political/media community.

Time to talk about legal

28 Replies

As a lone blogger how much legal protection do you have? No more than anyone else, when it comes to libel, contempt of court law and so on, except that people are more likely to pay attention to large media organisations.

But there are many instances where bloggers have lost a lot of time and money over legal disputes. Last week, for example, journalist and blogger Dave Osler finally saw an end to a legal battle that consumed three years of his life, after he was sued for libel by the political activist Johanna Kaschke. Despite being refused the right to appeal the strike-out of the Osler case, she is still planning to appeal another High Court decision that ended her libel claim against Alex Hilton and John Gray.

If all individual bloggers worried about getting into trouble too much, we’d write much less than we do. Even big scary cases aren’t a deterrent: Dave Osler is still blogging. I was personally surprised by the results of my survey of 71 small online publishers this summer. Not that only 27 per cent had been involved in legal disputes (that was about what I expected) but that over half were satisfied with the number of legal resources available.

Personally, the grey areas of law trouble me and I don’t think there could be enough support: I’d like to see more organised structures for legal help, a sort of Citizens Advice Bureau for bloggers, if you like. Informal advice is already spreading via social networks, as lawyers increasingly use Twitter and blogs to join the conversation.

As I reported on my site Meeja Law, one hyperlocal blogger who was accused of breach of copyright asked for legal advice via Twitter: “Two separate media lawyers confirmed (for free) that I’d done nothing wrong. I also contacted [hyperlocal organisation] Talk About Local for advice, and they told me the same.”

Talk About Local has published several media law guides online (eg. this one on defamation) and the organisation’s founder William Perrin offers some frank legal advice ahead of a legal session at last weekend’s London Local Neighbourhoods Online Unconference:

…just about the best legal advice, which very few follow is to set up a  limited company and keep the website inside that. Then you don’t lose  your house to a nutter under defamation law….

Another concern of mine is the lack of transparency of courts data, something I’ve discussed at length here. I think bloggers should be able to access more information about cases; at the very least, the Ministry of Justice needs to consider its outmoded contempt of court law that is ill-equipped to deal with the online age.

In the coming months, I’d like to build up the conversation in this area and think about how we might approach some of these issues. If you’d like to be part of this informal online ‘working group’ please consider joining the Help Me Investigate challenge at this link (request membership here), or discussing via the OJB Facebook group.

UPDATE [Paul Bradshaw]: I’ve created a LinkedIn group as a place for people to more openly discuss how to take this forward.

Judith Townend (@jtownend on Twitter) is a PhD research student at City University London and freelance journalist.

Hyperlocal Voices: Julia Larden (Acocks Green Focus Group)

3 Replies

Hyperlocal voices - Acocks Green Focus Group blog

Today’s Hyperlocal Voices interview is with Julia Larden, chair of the Acocks Green Focus Group blog, which campaigns to make Acocks Green a “better place to live, work and shop”. The group was established in 2004 and the blog followed in 2007. “We are less likely to get confused or get our facts slightly muddled” than professional journalists, says Julia. Here’s the full interview:

Who were the people behind the blog, and what were their backgrounds before setting it up?

That’s a bit complicated. Originally the blog was set up, more as a straight website, by a member who has long since left the area. It was not working very well at that time, and the ex-member was also asking for quite a lot of money to carry it on. I don’t think the member had any particular background in IT – he was in education, although he has set up a few small websites of his own. I had done some work for it, written some materials and supplied some photographs. My son, who runs a small software company, agreed to take the whole thing into his care for a bit.

Things lay dormant and then, when my son had time he simply picked the content up and plonked the whole thing into a WordPress blog – one of the slightly posher ones that you have to pay a bit for, but he has some sort of contract and can get quite a few of these blogs, so the group just pays him a very nominal sum each year.

It then sat there for a bit longer with not very much happening except the occasional comment, and then several members pointed out that it was a valuable resource which we were not using properly.

One of the members had web experience (running her own online teaching company) and started to make it into a far more interesting blog, asking for more materials, creating new pages and adding in bits and pieces and an opinion survey of the area – as a launch gimmick. (We have kept that – it still gets a lot of interest – more since I shifted it to another page, for some reason.) Continue reading →