#Libday8 Day three (1 February)

Checking in with Twitter first thing

Library Day in the Life Round 8

Senior researcher, Guardian News & Media (news library)

I’ve realised some of the queries I’ve mentioned this week are vague in the extreme – I’m a bit nervous about putting too many details (names, for example) before the articles are published, not that I’ve been researching anything controversial but some journalists like to keep quiet about what they’re writing! I might come back and add links once the pieces are in print.

• 10am: First job of the day is to listen to the morning conference – an editorial meeting open to anyone on the paper, which they stream so you can watch on your desktop. They invite guest speakers in most weeks, and today it’s Lord Hunt, chairman of the PCC, who was at Leveson yesterday.
• 10am: A bit of multitasking! We’ve been asked for a detailed package on Google for one of the editors, by lunchtime, so we’ve all taken sections (it’s quicker to share a big job if there’s a tight deadline). Used Factiva to search US/global press as well as UK, then emailed the docs.
• 11am: Took an email query from a journalist I did some work for last week (some writers have their favourites among us!), trying to pin down the precise role of a government advisor (there’s some confusion over whether he still is one). I hit Google for some details then the text archive, for a reliable source.
• 12pm: Another email query, looking for profiles and background on an interview subject. Back to the text archive and Factiva!
• 12.15pm: A face-to-face query (from the feature writer who sits behind me!), on Michael Gove and his use of the insult “Trot!” yesterday. He needs it for tomorrow’s paper so this takes priority over the previous query…
• 12.45pm: …which I’ll get back to now! It’s turning into another day spent on Factiva. I don’t want to engulf someone with a deluge of articles, but when I’m researching for someone who is planning an interview I try to provide enough substantial previous profiles to give them more than one viewpoint and lots of ideas. This interview subject is a writer so I’m sending reviews of his books as well, several articles he’s written and any recent news so the interviewer is up-to-date.
• 2pm: Lunch!
• 3pm: We’ve been asked to trace a quote that is being questioned by a reader, so back to Factiva and Google.
• 3.15pm: A bit more work on an archive blogpost for the anniversary of the Queen’s succession to the throne in 1952, writing the bones of the article and prepping some of the images in Photoshop. I’ll have to finish it off quickly on Monday morning!
• 3.30pm: Picked up a journalist query from email, looking for statistics on mental health issues for girls and women (eating disorders, depression, self harm). I looked at a few charity websites, which led me to the Department of Health’s 2010-11 hospital episode statistics – the data will never be comprehensive because cases only get recognised when people enter the healthcare system, but it gives an idea of the gender and age ranges where it is most prevalent. They focused on eating disorders last year as one of their topics of interest, which is helpful. I found reports of recent surveys on body image and self harm on the text archive too, and comparative depression stats from the ONS Adult Psychiatric Morbidity study 2007.
• 5.15pm: It’s been a busy day today! Just enough time to read through the draft of a From the archive blogpost a colleague has written (we try to check each other’s work because the blog doesn’t go through a subbing process before we publish).

Normally that would be me done for the week – I’ve been working three days a week since I had my son four years ago – but this Friday I’m going to news:rewired so I’ll have a day off and post a few thoughts on what I learn there over the weekend.

Read today: Hashtags for information professionals by Bethan Ruddock; Librarians as Agents of Democracy by Lauren Smith on the Walk You Home tumblr; the National Libraries Day event page; Laura’s Guide to chartership on the Dark Archive blog; the Guardian’s report on the Whoopensocker US dialects dictionary; and #libday8 posts from Nicole Brock, Lauren Smith, JoLibrariAnne and Rachel Bickley.

#Libday8 Day two (31 January)

Library Day in the Life round 8

Senior researcher, Guardian News & Media (news library)

• 8.45am: Caught up on Twitter on the bus in to work, and read a couple of really interesting #libday8 posts and articles (see below for links)
• 9.30am: I had a journalist query waiting in my inbox when I logged on –  looking for a quote from Hansard (the House of Commons record). There’s an easy-to-use archive on the parliament.uk website which goes back to 1988, and there was a possible date (we like!) but it wasn’t the right one. I searched by MP on Hansard but couldn’t find the quote for that year’s session, so I checked our text archive and Google for the article referenced in the email, to see if I could gather any more info. This led me to a new date (1994), but you can’t search that far back by MP so I headed to the advanced search instead. I should have tried there first! Nothing came up when I searched for the keywords. I even whacked the quote into Google but no joy there either. I’ve asked the journalist for more information. And it seemed so simple…
• 10.30am: Our trainee maintains a spreadsheet of casualty figures from Afghanistan which feeds into a Datablog post on British dead and wounded. I’m responsible for updating the running total in the article and relaunching it with an amended table when wounded figures are released. The spreadsheet also includes amputation figures, released quarterly by the MoD through DASA. They’re out today, and normally our trainee Nina will just copy over the new figure and tot up the annual total, but the MoD have changed their methodology so now they’re reporting amputations by financial year. This, and the fact that they don’t report quarterly figures less than five, means our annual totals no longer tally with the official MoD numbers. I’m loathe to switch to financial year (“there were xx amputations in 2010″ is nicer journalistically than “there were xx amputations in 2010/11″) but as it stands our annual data is incomplete. I’ve added an explanatory note to the spreadsheet but I’m going to consult the Datablog editor to decide whether we should switch to the financial year rather than Jan-Dec.
• 11am: Still working on the Hansard query! The journalist has provided the source of the quote (a pressure group report), so I’ve got more to go on – it seems the quote may not have been said in the House. I checked Google in the first instance, and the writer thought it may have been from the Diana inquest but I can’t find it. I’ve admitted defeat and contacted the House of Commons information office.
• 12pm: We’ve decided to include both the Jan-Dec and financial year totals for amputations in the Datablog figures, so Nina and I amended the spreadsheet and added a note to explain discrepancies.
• 12.15pm: Amended the table of wounded data attached to the Datablog post on British casualties and relaunched the article.
• 1pm: My job share, Lauren, worked on a crowdsourcing Datablog post about people who have refused honours a few weeks ago, and a reader has emailed with some new information, so I added it to the spreadsheet.
• 1.30pm: Proper lunch break – there’s a charity cake sale on by the canteen today so I treated myself to a slice of cherry loaf, yum.
• 2.30pm: Panic over regarding the missing quote, the journalist has located it himself (a bit embarrassing!).
• 2.30pm: Working on From the archive, the ‘on this day’ series that we publish online (with a piece printed in Saturday’s Guardian comment pages). Found two too-long pieces for the end of Feb (Mickey Mouse in 1935 and trials of using computers in 1986) which need trimming.
• 4pm: Journalist query – tracking down a Guardian article from the 1990s – pulled together a few possibles from the text archive and Factiva.
• 4.30pm: Graphics wanted some help finding military stats for an interactive, so I borrowed the Military Balance and photocopied the relevant pages. A bit tedious but much preferable to typing it all out!
• 5.25pm: A quick one to finish – a PDF of an Observer spread from a fortnight ago (from the text archive).
• 5.30pm: Leaving on time for the first time in a long time. Sounds like a country song.

Read today: The engine of serendipity, a 2006 post from Nicholas Carr’s Rough Type blog (via @lilianedwards); Jonathan Franzen : e-books are damaging society in the Telegraph; Save Our Libraries campaign one year on from the Guardian Books blog (via @SimonXIX); Library Day in the Life day one by Nicole Brock at Odd Librarian Out; Library Day in the Life part 2 by Tina Reynolds.

#Libday8: Day one (30 January)

The view from my desk

Library Day in the Life Round 8

Senior researcher, Guardian News & Media (news library)

• 9am: Check Twitter on the bus on the way in to work, to find out what’s in the news this morning (I need to be aware of what’s going on, and it gives me an idea of what I might be asked to work on later). Work doesn’t begin when you enter the office any more!
• 9.45am: Deleted last week’s emails – I don’t work on Thursdays or Fridays so my inbox fills up with old queries.
• 10am: Picked up an emailed query for a land registry search, left over the weekend, and emailed the team to say I’m doing it (that might seem redundant – there are only six of us and we all sit together – but we work different shifts and my job share won’t pick up the email until Thursday, so it pays to attach a name to every job).
• 10.15am: Ran the land registry search – I haven’t used it much so it was good to get a bit of practice – and emailed results to the journalist.
• 10.20-11am: I’ve been running a Guardian Datablog post on the film awards season, something I initiated a few years ago, using a Google spreadsheet to track all the key nominees and winners leading to the Oscars in February. This weekend was the Directors Guild and Screen Actors Guild awards, so I added the winners to the spreadsheet and added a para about them to the article (the DGA winner usually wins the Oscar). The post has tables for best actor and actress attached, and I edited these so that the winners stood out in bold. I also created a new table, for best director nominees. Then I relaunched the post (with today’s date) and told the web team about it so they can attach the story to any relevant content.
• 10.30am: Michel Hazanavicius doesn’t have a keyword on the website yet, so I emailed our keyword manager to request one. He’s on it!
• 11am: Quick department meeting to discuss jobs coming up this week.
• 12pm: It’s the 40th anniversary of Bloody Sunday so I wrote a quick blogpost for From the archive, with Guardian coverage from the time. Once I’d prepped it I ran it past a colleague and our SEO team, to sub it and improve my SEO!
• 1pm: Checked the text for tomorrow’s From the archive piece against the original, to weed out any stray commas or spelling mistakes. This is one of the tasks that is rota’d each week.
• 1.15pm: Quick lunch! At my desk, because I’m going to a staff briefing at half one. I’ll try and sneak some time away from the screen later.
• 1.20pm: The SEO team are happy with my Bloody Sunday post so I launched it, then tweeted the link from our department account (@guardianlibrary).
• 1.30pm: Company-wide meeting about an upcoming Guardian event.
• 3pm: Took a query from a journalist about MPs prosecuted following the expenses scandal (we get most queries via phone or email but this one sidled up to my desk, which I like). I checked for each of the MPs on our text archive of national papers, and on Factiva (to catch regional coverage), and sent articles via email.
• 4.15pm: Journalist query for background on Seb Coe, via phone – Factiva again.
• 5pm: I checked over the From the archive pieces for Wednesday and Thursday while I had a bit of spare time.

Kept up with a few articles via Twitter today – Beyond books: what it takes to be a 21st century librarian and Online newspaper metrics? The grey lady doth protest too much, methinks. I keep Twitter running in the background  and check in periodically to keep up to date, don’t want to miss anything!

Working week, 23-25 January 2012

• Generating a Wordle from a hashtag: Education asked on Tuesday if we could create a word cloud  from the questions asked on Twitter using the #askgove hashtag. See my post for more info on how I prepped it (and why it didn’t run).

• Awards nominations: The Oscar nominations were announced on Tuesday, streamed live on the web. I prepped the article first thing, added the nominations to our spreadsheet as they came in then amended the article before publishing (controversially no nomination for Tilda Swinton!). My computer decided to remove itself from the server ten minutes before the announcement, cue much gnashing of teeth, but luckily the old ‘turn it off then turn it on again’ trick worked. I had a bit of a struggle creating summary tables for the page (thanks Critics’ Choice for nominating six best actors) but Ami showed me a nifty way of narrowing the columns. And I forgot to change the date (so that the article jumps to the top of the Datablog list), but handily someone else noticed and fixed it! Quite exciting launching a story in real time, but lessons to be learned about paying attention to the little details.

• Pre-emptive blogging: I’m trying to work on a few blogposts in advance, so I’ve been looking for content on the Queen’s succession and Valentine’s day.

• Journalist queries included recent comment on the health and social care bill, a 1994 article from Modern Law Review (luckily one of the free online ones), writing bulletpoints on some Olympic sports, corrections, polls on satisfaction with the NHS, a comparative health report, profiles of Aki Kaurismaki, a fact check on Woody Harrelson and background on the judiciary system (who heads it, who regulates it, law schools).

#libday8: Under starter’s orders

Library Day in the Life round 8 starts today – I’ll be posting at the end of each day and tweeting throughout (@katy_bird). Looking forward to reading everyone else’s exploits!

Working week, 16-18 January 2012

• Working on plans for Olympics coverage: We’ve been chatting this week about how we can cover the London 2012 Olympics from an archive perspective. We’ll be blogging some archive stuff, and tweeting too, hopefully with coverage from previous London Olympics. We’re trying to initiate our own projects, rather than being approached by others all the time – it’s much better to be involved from the start so we can be realistic about what is achievable (learning from past mistakes!).

• Wikipedia blackout: We didn’t see a massive influx of queries on Wednesday, when Wikipedia was blacked out for 24 hours to protest Sopa.  Optimists would say that’s because our journalists are above using Wikipedia, but it’s more likely that they’d figured out ways around the blackout. Our encyclopaedias made a star turn for Guardipedia, when Patrick Kingsley fielded questions from readers stumped by the blackout. Shame there was no mention of the librarians (and lots of library clichés!), but he did give us a shout out on Twitter.

• Journalist queries included a 1996 article on the Olympics, Syria in numbers, recent social stories on China, examples for a panel on home experiments gone wrong, interviews and reviews for Russell Tovey and Jaime Winstone, net % change of GDP over time, MP quotes on the Work Programme and a land registry search.

 

Working week, 9-11 January 2012

• Film Datablog post: Nominations were announced for several awards last week (WGAs and Bafta longlist), but Film were busy again and didn’t have time to update the spreadsheet. I need to check with them a few days in advance next time, to make sure they can cover it, or get someone else involved for the days I’m not here. The Golden Globes are next week, I can’t decide whether to get up crazy early to update the page or just wait until I’m in the office. Shame they’re not on terrestrial telly!

• Changes to From the archive: The Guardian dropped a number of pages from the paper yesterday, including shortening the Comment section, which means our on this day column is no longer in the print version. But fear not, we’re continuing online (may blog this later). I had four to upload on Monday, phew! I’ve rewritten the instructions on how to do it all to reflect the changes, too.

• Work experience: We have a work experience bod with us for a fortnight, so I’ve been showing him some of the longer-term projects we’re working on. There aren’t many opportunities to train people in ourdepartment, so it’s good to get a bit of experience.

• Developing the intranet: Our plans for the intranet took a back seat over Christmas, but we’re getting back into it again. I’d hit a point with the design where I needed someone else to come in and advise, and a colleague is now helping me with the images, so we should be ready to relaunch soon.

•  Journalist queries included the current electorate of Denmark (took a bit of digging but I now know the words for election, postal votes and invalid votes in Danish), anything on Nick Walkley for an interview, background on Kate Freud and interviews by Lucian on family, a specific Guardian story on Ed Miliband “by a Labour frontbencher” and polls on public attitudes to cuts.

Working week, 3-4 January 2012

Wow, where did 2011 go?

• Corrections: Lots to catch up on from the festive period, so it took me a while to weedle my way through the list. Luckily otherwise it was a slow start to the week back!

• Department meeting: planning blog coverage for Olympics and other upcoming events, what to do with From the archive (will be dropped from the paper soon), engaging more with Twitter followers.

• Intranet: I’ve not worked on it for a while, but a colleague has offered to help with the design so hopefully we can relaunch soon.

• Fruitless searches: I was asked for the text of an Early Day Motion on Thatcher’s funeral from 2007. A search of the parliament.uk site was fruitless, so I checked for cuts on Factiva and it turns out the EDM wasn’t actually tabled (too controversial I assume!). If something isn’t there there’s usually a good reason. I did discover the really simple database of EDMs on the parliament.uk site for next time, though.

• Journalist queries included whether there was dancing in the Welsh valleys when Churchill died, recent polls on Thatcher (please, no more Thatcher queries…), the source of Rick Santorum’s “CS Lewis” quote (unknown, to all but him), an article from the BMJ (we don’t subscribe but the health desk do), and locating a review that’s not on the digital archive (I suggested the reader contact a specialist archive – another case of a review only appearing in an early edition so not archived, I think).

Working week, 19-21 December

The week before Christmas (six days to go, eek!) can go either way – people are starting to leave for the holidays, so it’s quieter than normal; or people are desperately trying to file stories weeks in advance so they can relax over Christmas, so it’s busier. And then there are the unpredictable news events like Kim Jong-il’s death, which spark a bit of a research frenzy.

• 10 Facts on North Korea for the Datablog: The editor is away so asked me to pull together a collection of Datablog stats following the death of Kim Jong-il, announced on Monday morning. I didn’t have time to pop in graphics or images but quite pleased with the end result. We switched the headline because G2 had already launched a similar piece (which I’m sure we could have helped with!).

• Added the Golden Globes nominations to the Award season 2011-12 Datablog post - Film forgot (unsurprisingly, Thursday is probably their busiest day), so I’ll make sure to check in with them on the day next time. Added the London Critics Circle noms too.

• From the archive: Finished editing a piece on Churchill’s appearance before Congress (27 Dec 1941), and found a Jan 7 piece from 1970 on sex changes. I had to correct something an eagle-eyed reader spotted on the 20 December piece (1913 – merriest Christmas in history?), too – a transcription error meant we referred to 1/5d instead of 1/2d, and there were a few stray commas and hyphens as well (which happens sometimes when you copy the text of the original, if there’s a mark on the page). We’re all pretty thorough but errors do sometimes slip through! Have to pay more attention in future.

• Corrections: It’s not often that one of our more dull jobs makes the news! The Guardian has published a correction relating to the claims the Milly Dowler’s voicemails were deleted, which we printed in July based on evidence at the time. We have the mundane task of attaching the correction to all the articles.

• Trialling Newsvault: I set up a trial of Gale NewsVault following a meeting at Online Information, and it’s really interesting to see another example of a digital archive. It includes the Picture Post, which is referenced in the sex change story I found for From the archive (one of the first cases in the UK told her story to them in 1954). Brilliant to be able to call up the original coverage!

• Other queries included contact details for Kate Nash, a phone number for an old contact and helping a US high school librarian with a citation for a From the archive piece (more confusing than I first thought!).

Working week, 12-14 December

• Film award nominees and winners 2011-12 for the Datablog: In 2009 I ran a spreadsheet on the major film award nominees and winners, and the Film editor has asked for it again this year. I’m quite chuffed, I love the build-up to the Oscars so it’s fun to be able to track it all for work! Nice that the film team found it useful and suggested it themselves, too. They’re even going to help me update it so there’ll be fewer Sunday evenings spent thinking about spreadsheets!

• Events diaries: We keep track of upcoming events in national, foreign and arts news. The diary was hosted on our intranet page originally, then we switched to Google Calendars a few years ago, and last month these were shared on the Guardian site as part of the Open News experiment. Which means even more pressure to keep them up to date! A quiet few days meant I could get a few months under our belt.

• From the archive: We’re trying to get the Christmas period out of the way, and we have more space to play with over Christmas week. I’ve found a Dev Anand film being made on Everest (28 December 1973), a cheery news piece from 1831 about cholera outbreaks in the north east (31 Dec) and a 1941 piece about Churchill’s address to Congress (27 Dec).

• Journalist queries included frequency stats on various austerity phrases in the UK press over the last few years, an article from Broadcast (there’s a paywall online), statistics for a graphic on metal theft, cuts on the Murdoch pie thrower and an attempt to track down the man punched by Prescott in 2001.