{"id":1057,"date":"2019-12-12T20:17:53","date_gmt":"2019-12-12T20:17:53","guid":{"rendered":"http:\/\/vpms1.humber.smartmanagedservers.com\/convergencemag\/?p=1057"},"modified":"2023-04-05T18:18:16","modified_gmt":"2023-04-05T18:18:16","slug":"beyond-the-spreadsheet","status":"publish","type":"post","link":"https:\/\/humberjournalism.com\/convergencemag\/beyond-the-spreadsheet\/","title":{"rendered":"Beyond the Spreadsheet: How journalists bring data stories into the real world"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">By Galvin Zaldivar<\/h4>\n\n\n\n<p>Data journalism is more than facts and\nfigures, charts and tables. More than statistics\nand balance sheets, data can be used to tell a\nhuge variety of stories.\n<\/p>\n\n\n\n<p>The third annual Data Driven symposium,\nhosted by Humber\u2019s Faculty of Media and\nCreative Arts (FMCA), was held on Nov. 15 at\nGoogle Canada\u2019s Toronto Headquarters.\n<\/p>\n\n\n\n<p>Started in 2017 by David Weisz and Andrew Ainsworth, Data Driven is a chance to have an in-depth look into the strategies and techniques to turn raw data into tomorrow\u2019s headlines. Investigative and data journalists shared stories they have been able to tell through the use of data. <\/p>\n\n\n\n<p>Guillermo Acosta, Dean of FMCA, said\nthis year\u2019s symposium was very interesting.\n<\/p>\n\n\n\n<p>\u201cI was so struck by the depth of the work\nthat is being done and I was struck by the\npower of the women working behind this, the\npower of the diversity and the that is present\nin this field of Journalism,\u201d he said.\n<\/p>\n\n\n\n<p>Acosta said his appreciation has grown for\nthe field. \u201cThe big learning moment for me\nwas the first one and the second and third I\u2019ve\nseen the evolution.\u201d\n<\/p>\n\n\n\n<p><strong>Counting trees\n<\/strong><\/p>\n\n\n\n<p>Toronto Star data journalist Megan Ogilvie said she was eager to tell a hard-hitting story that was going to change the world. <\/p>\n\n\n\n<p>\u201cSo, I pitched a story on trees,\u201d she told the\naudience.\n<\/p>\n\n\n\n<p>The story stemmed from a story concerning a 300-year-old oak tree, Ogilvie said that she noticed how engaged Star readers became with the story, and began to see a story behind it. <\/p>\n\n\n\n<p>\u201cI thought, \u2018surely there\u2019s more than one\n300-year-old tree in the city, where are they,\n<\/p>\n\n\n\n<p>Kit Kolbegger spoke at the 2019 Data Driven symposium on their experiences with the National Student Investigative Reporter Network. Photo by Galvin Zaldivar. <\/p>\n\n\n\n<p>can we talk to our readers about it?\u2019\u2019 she said. As with all good data stories, Ogilvie said she started by looking for who would have data on the old-growth trees in Toronto.<\/p>\n\n\n\n<p>In searching for the data needed to tell the story, she said the story changed as she began to sort through the numbers.<\/p>\n\n\n\n<p>\u201cIn the end, the story became more of a look at how we\u2019re not really doing a really good job of keeping track of big, old, important trees in the city,\u201d Ogilvie said. <\/p>\n\n\n\n<p>As with all data stories, there were data holes and problems that had on caring for old-growth trees in Toronto, and how the city could improve. <\/p>\n\n\n\n<p>\u201cIn the story, we pointed out in the story\nwhy Toronto should and could be doing\nmore,\u201d Ogilvie said.\n<\/p>\n\n\n\n<p>She said the Star looked at the U.K.\u2019s heritage tree program, which keeps track of 150,000 old-growth trees, and New York City\u2019s heritage tree registry as examples of how Toronto could take care of its old growth trees. <\/p>\n\n\n\n<p>\u201cWhen you talk about trees, you have to show these trees,\u201d she said. \u201cWe picked 10 beautiful trees to show our readers with a neat video and interactive format so they could meet some of these really special trees in the city.\u201d<\/p>\n\n\n\n<p>The response to the story was amazing ac- cording to Ogilvie, with people sending in their stories about their favourite tree in the city. \u201cJust like we do, we follow the readers\u2019 stories and a few days later we profiled five more trees in the Star,\u201d she said.<\/p>\n\n\n\n<p>This led to Ogilvie compiling a weekly feature called Tree of the Week which gave Torontonians the chance to share stories about their favourite trees. <\/p>\n\n\n\n<p>\u201cWe had readers telling us how much they loved it and how it was important to high- light the beautiful things in their city because it gave them a sense of connection to their neighbours, their neighbourhood, their community,\u201d she said. <\/p>\n\n\n\n<p><strong>A rough ride\n<\/strong><\/p>\n\n\n\n<p>Annie Burns-Pieper of the Globe and Mail\nspoke of her research into sexual violence on\npublic transit, and how the data she received\ninfluenced the story she told.\n<\/p>\n\n\n\n<p>\u201cThis is a story that came to me as a woman living in Toronto, an investigative reporter, who took public transit a lot,\u201d she said. <\/p>\n\n\n\n<p>When Burns-Pieper started her investigation, she knew other outlets had covered the\nissue in the past and assumed the data would\nbe readily available.\n<\/p>\n\n\n\n<p>\u201cThis investigation ended up taking three\nyears of my life,\u201d she said. \u201cAnd the story\nended up being much different than the one\nI thought I was going to tell.\u201d\n<\/p>\n\n\n\n<p>After going through the data of the 22 largest transit systems in the country, and their local police services, Burns-Pieper said she discovered many data gaps in the way local police forces and transit systems recorded in- stances of sexual violence. <\/p>\n\n\n\n<p>\u201cAt the same time, I was collecting data on\nthis story, I was talking to survivors of sexual\nviolence on public transit,\u201d she said. \u201cI spoke\nto over 50 people during the course of the re-\nporting, mostly young women.\u201d\n<\/p>\n\n\n\n<p>Among the cases Burns-Pieper examined\nwas a Calgary incident that was well known to\npolice, the city and the transit system, but was\nnot included in the transit system\u2019s own data\non sexual violence.\n<\/p>\n\n\n\n<p>\u201cI was confused,\u201d she said. \u201cI didn\u2019t know\nhow a story that had been reported in multiple\nnews outlets and was well known to the police\nwas missing from the transit system\u2019s data.\u201d\n<\/p>\n\n\n\n<p>Looking through her data, Burns-Pieper\ndiscovered multiple instances of sexual vio-\nlence being reported to transit authorities, but\nnot being reflected in the data.\n<\/p>\n\n\n\n<p>Burns-Pieper said the missing data then became part of the story, and knowing what\u2019s missing can influence the direction a story\nmay take.\n<\/p>\n\n\n\n<p><strong>Let the numbers talk\n<\/strong><\/p>\n\n\n\n<p>Michael Robinson of the Telegraph-Journal out of New Brunswick spoke of creating stories with limited data. <\/p>\n\n\n\n<p>Robinson\u2019s story was on the deficiencies of the billing number system formerly used by New Brunswick to assign doctors to an appropriate region. <\/p>\n\n\n\n<p>\u201cThere wasn\u2019t a lot of pivot tables or data\ncrunching but just simply showing those\nnumbers&#8230;we really let the numbers speak for\nitself,\u201d he said.\n<\/p>\n\n\n\n<p>Robinson said that despite the simple\nnature of the data, he was able to illustrate the\nissues with the billing number system to effect\nreal change.\n<\/p>\n\n\n\n<p>She said her data journalism professor said\nthe real power of data is made manifest when\nyou put two sets of data together and look at the\nsimilarities to find a new angle and perspective.\n<\/p>\n\n\n\n<p>\u201cI\u2019m thinking about how to do that,\u201d Sun\nsaid. \u201cI like to bake, so I\u2019m thinking about this\nstory as baking a blueberry pie.\u201d\n<\/p>\n\n\n\n<p>Think about each component data set as a\npiece of the pie, she said. The income level can\nbe seen as the pie crust, and each collision as a\nsingle blueberry that forms the filling.\n<\/p>\n\n\n\n<p>\u201cFor my story, those blueberries [were]\ndistributed disproportionately all over the\ncity,\u201d Sun said.\n<\/p>\n\n\n\n<p>Sun found 53.1 per cent more pedestrian-involved collisions happened in the poorest neighbourhoods than in the richest. She also found that jaywalking and crossing with the right of way were the top two causes of collisions in the lowest income areas. <\/p>\n\n\n\n<p>Sun told the Data Driven audience that census data is the best gift a data journalist can get. Using census data, journalists can reveal systemic programs and model emerging social trends. <\/p>\n\n\n\n<p>\u201cYou can use census data to empower your story and to make your blueberry pie,\u201dshe said. <\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"youtube-embed\" data-video_id=\"8GGcTN4LH2g\"><iframe loading=\"lazy\" title=\"Data Driven\" width=\"696\" height=\"392\" src=\"https:\/\/www.youtube.com\/embed\/8GGcTN4LH2g?feature=oembed&#038;enablejsapi=1\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/div>\n<\/div><\/figure>\n\n\n\n<p><strong>Can\u2019t see the forest\n<\/strong><\/p>\n\n\n\n<p>John Wihbey of Northeastern University also had a story to tell about trees but to illustrate the importance of immigration to the history of the United States. <\/p>\n\n\n\n<p>\u201cWe decided that in the atmosphere that is\ncurrently in the United States issuing from the\nTrump administration, that we want to tell a\ndifferent story,\u201d he said.\n<\/p>\n\n\n\n<p>Instead of depicting the data linearly,\nWihbey and his partner Pedro Cruz, looked\nto nature for their data visualization.\n<\/p>\n\n\n\n<p>\u201cWe also have to acknowledge that the traditional forms for data storytelling, whether it\u2019s bar charts or line graphs are maybe insufficient. <\/p>\n\n\n\n<p>\u201cThe story can show how you can do a lot with little, and eventually we hammered this issue so hard that when the Throne Speech came around for the new Progressive Conservative government last fall they promised to scrap the system&#8230;and that finally happened this past September,\u201d he said. <\/p>\n\n\n\n<p><strong>Putting it together\n<\/strong><\/p>\n\n\n\n<p>Freelance data journalist Yang Sun showed\nthe audience how to bake a blueberry pie with\ndata. Or more accurately, creating a story out\nof two separate sets of data.\n<\/p>\n\n\n\n<p>\u201cSince I have a lot of opinions with the\ntraffic in Toronto as a pedestrian, the first\nproject I hit is the collision data released by\nthe Toronto police,\u201d she said.\n<\/p>\n\n\n\n<p>The next data Sun looked at was the median household income in the greater golden horseshoe region. She said that looking at the two data sets she had a hunch. <\/p>\n\n\n\n<p>\u201cI feel like some of the lowest income\nneighbourhoods happen to be sitting on\nthose clusters with collisions,\u201d Sun said.\n<\/p>\n\n\n\n<p>She said her data journalism professor said\nthe real power of data is made manifest when\nyou put two sets of data together and look at the\nsimilarities to find a new angle and perspective.\n<\/p>\n\n\n\n<p>\u201cI\u2019m thinking about how to do that,\u201d Sun\nsaid. \u201cI like to bake, so I\u2019m thinking about this\nstory as baking a blueberry pie.\u201d\n<\/p>\n\n\n\n<p>Think about each component data set as a\npiece of the pie, she said. The income level can\nbe seen as the pie crust, and each collision as a\nsingle blueberry that forms the filling.\n<\/p>\n\n\n\n<p>\u201cFor my story, those blueberries [were]\ndistributed disproportionately all over the\ncity,\u201d Sun said.\n<\/p>\n\n\n\n<p>Sun found that 53.1 per cent more pedestrian-involved collisions happened in the poorest neighbourhoods than in the richest. She also found that jaywalking and crossing with the right of way were the top two causes of collisions in the lowest income areas. <\/p>\n\n\n\n<p>Sun told the Data Driven audience that census data is the best gift a data journalist can get. Using census data, journalists can reveal systemic programs and model emerging social trends. <\/p>\n\n\n\n<p>\u201cYou can use census data to empower your story and to make your blueberry pie,\u201d she said. <\/p>\n\n\n\n<p><strong>Can\u2019t see the forest\n<\/strong><\/p>\n\n\n\n<p>John Wihbey of Northeastern University also had a story to tell about trees, but to illustrate the importance of immigration to the history of the United States. <\/p>\n\n\n\n<p>\u201cWe decided that in the atmosphere that is\ncurrently in the United States issuing from the\nTrump administration, that we want to tell a\ndifferent story,\u201d he said.\n<\/p>\n\n\n\n<p>Instead of depicting the data linearly,\nWihbey and his partner Pedro Cruz, looked\nto nature for their data visualization.\n<\/p>\n\n\n\n<p>\u201cWe also have to acknowledge that the traditional forms for data storytelling, whether it\u2019s bar charts or line graphs are maybe insufficient sometimes to tell the real story and to bring around the kind of emotional impact that we want,\u201d he said. <\/p>\n\n\n\n<p>Eventually, the pair settled on using tree rings to visualize and illustrate their data. <\/p>\n\n\n\n<p>\u201cIf you think about it, [tree rings] capture data over time,\u201d Wihbey said, explaining the logic behind the choice. \u201cSeasonal patterns, and patterns of nutrition and growth and we thought, \u2018you know there\u2019s something analogous actually with the population.\u2019\u201d <\/p>\n\n\n\n<p>After much testing and working through\nvarious algorithms, Wihbey and Cruz settled\non a more subtle colour palette after rejecting\nred, white and blue as jingoistic, he said, when\nhe released a preview of the data, he found the\nresponse interesting.\n<\/p>\n\n\n\n<p>\u201cWe saw people from both the political left and the political right &#8230; being kind of inspired and sort of exploring the data and commenting on it,\u201d Wihbey said. \u201cWe thought that maybe by using visual metaphor as opposed to conventional data storytelling techniques we had maybe gotten people to think a little differently about the country.\u201d <\/p>\n\n\n\n<p><strong>Following the water\n<\/strong><\/p>\n\n\n\n<p>Kit Kolbegger, a journalist at the CBC and Humber grad, spoke of their experience working with the National Student Investigative Research Network (NSIRN). The network\u2019s investigation, Tainted Water, caught international attention when it was released on Nov. 4. <\/p>\n\n\n\n<p>\u201cWe were a very small team at Humber,\u201d Kolbegger said. \u201cWe started out with just me and Michelle [Rowe-Jardine] and then in the second semester, a post-grad, Brenden Pietroban, came on to join us.\u201d <\/p>\n\n\n\n<p>When the investigation became focused on lead, the Humber team found themselves investigating Thunder Bay. NSIRN, evidently thought Thunder Bay was much closer to Toronto than it actually was, said Kolbegger. <\/p>\n\n\n\n<p>\u201cAs we started investigating in Thunder\nBay, we found massive pushback from the city\nitself,\u201d they said. \u201cI filed those nine access to\ninformation requests, and I would call the city\narchivist &#8230; and I would say, \u2018Hey what\u2019s the\nupdate?\u2019 and he would say, \u2018They\u2019re having\nanother meeting,\u2019\u201d\n<\/p>\n\n\n\n<p>At one point Kolbegger said they requested a map of Thunder Bay\u2019s water infrastructure, only to be told the city didn\u2019t have one. <\/p>\n\n\n\n<p>\u201cIt was a huge challenge,\u201d Kolbegger said.\n\u201cSo what we ended up doing &#8230; was going\nthrough this huge deep dive.\u201d\n<\/p>\n\n\n\n<p>Kolbegger said they and their team went\nthrough local news outlets, local Facebook\ngroups, real estate listings, Google street view\nwalks and local podcasts\n<\/p>\n\n\n\n<p>\u201cI had the book, Seven Fallen Feathers, on my bookshelf, unread,\u201d Kolbegger said. \u201cDoing this googling, the book came up, and it actually talked about this one high school in Thunder Bay, that had a Ukrainian boiler from the 1950s, and looking into Ukrainian legislation on lead &#8230; we realized that this school could have a significant lead problem.\u201d <\/p>\n\n\n\n<p>After finding the data, Kolbegger said the next step was finding the people behind the numbers.<\/p>\n\n\n\n<p>\u201cNo story has impact without stakeholders,\u201d they said. \u201cAnd again, without being in Thunder Bay, how do you do that?\u201d <\/p>\n\n\n\n<p>Looking through places like social media and online petitions, the Humber team found Rhonda Hannah, and her partner, who re-excavated their home\u2019s pipes by hand because of the expense. After moving to a house, they discovered another 20 metres of lead pipes in their new home. <\/p>\n\n\n\n<p>\u201cThis solidified the need to tell this story,\u201d said Kolbegger. \u201cWe found this huge disparity across the country, in how different municipalities are dealing with the issue of lead pipes. Because most municipalities do have lead pipes somewhere in their water.\u201d <\/p>\n\n\n\n<p>Acosta said he sees a multi-disciplinary approach to data-driven storytelling in the future. \u201cI want to see this expanded beyond journalism and to communications in general be- cause I think this is a good this can be very important for public relations and for advertising and for marketing,\u201d he said. \u201cI\u2019m in this personal, call it [a] search for truth or personal Crusade on restoring faith in communications in general.\u201d<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Galvin Zaldivar Data journalism is more than facts and figures, charts and tables. More than statistics and balance sheets, data can be used to tell a huge variety of stories. The third annual Data Driven symposium, hosted by Humber\u2019s Faculty of Media and Creative Arts (FMCA), was held on Nov. 15 at Google Canada\u2019s [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1147,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","footnotes":""},"categories":[1],"tags":[307,180,20],"uagb_featured_image_src":{"full":["https:\/\/humberjournalism.com\/convergencemag\/wp-content\/uploads\/sites\/2\/2019\/12\/Data-Driven-2-1.jpg",6016,4016,false],"thumbnail":["https:\/\/humberjournalism.com\/convergencemag\/wp-content\/uploads\/sites\/2\/2019\/12\/Data-Driven-2-1-170x120.jpg",160,113,true],"medium":["https:\/\/humberjournalism.com\/convergencemag\/wp-content\/uploads\/sites\/2\/2019\/12\/Data-Driven-2-1-300x200.jpg",300,200,true],"medium_large":["https:\/\/humberjournalism.com\/convergencemag\/wp-content\/uploads\/sites\/2\/2019\/12\/Data-Driven-2-1-768x513.jpg",696,465,true],"large":["https:\/\/humberjournalism.com\/convergencemag\/wp-content\/uploads\/sites\/2\/2019\/12\/Data-Driven-2-1-1024x684.jpg",696,465,true],"1536x1536":["https:\/\/humberjournalism.com\/convergencemag\/wp-content\/uploads\/sites\/2\/2019\/12\/Data-Driven-2-1.jpg",1536,1025,false],"2048x2048":["https:\/\/humberjournalism.com\/convergencemag\/wp-content\/uploads\/sites\/2\/2019\/12\/Data-Driven-2-1.jpg",2048,1367,false],"td_150x0":["https:\/\/humberjournalism.com\/convergencemag\/wp-content\/uploads\/sites\/2\/2019\/12\/Data-Driven-2-1.jpg",150,100,false],"td_218x150":["https:\/\/humberjournalism.com\/convergencemag\/wp-content\/uploads\/sites\/2\/2019\/12\/Data-Driven-2-1.jpg",218,146,false],"td_300x0":["https:\/\/humberjournalism.com\/convergencemag\/wp-content\/uploads\/sites\/2\/2019\/12\/Data-Driven-2-1.jpg",300,200,false],"td_324x400":["https:\/\/humberjournalism.com\/convergencemag\/wp-content\/uploads\/sites\/2\/2019\/12\/Data-Driven-2-1.jpg",324,216,false],"td_485x360":["https:\/\/humberjournalism.com\/convergencemag\/wp-content\/uploads\/sites\/2\/2019\/12\/Data-Driven-2-1.jpg",485,324,false],"td_696x0":["https:\/\/humberjournalism.com\/convergencemag\/wp-content\/uploads\/sites\/2\/2019\/12\/Data-Driven-2-1.jpg",696,465,false],"td_1068x0":["https:\/\/humberjournalism.com\/convergencemag\/wp-content\/uploads\/sites\/2\/2019\/12\/Data-Driven-2-1.jpg",1068,713,false],"td_1920x0":["https:\/\/humberjournalism.com\/convergencemag\/wp-content\/uploads\/sites\/2\/2019\/12\/Data-Driven-2-1.jpg",1920,1282,false]},"uagb_author_info":{"display_name":"convergencemag","author_link":"https:\/\/humberjournalism.com\/convergencemag\/author\/convergencemag\/"},"uagb_comment_info":0,"uagb_excerpt":"By Galvin Zaldivar Data journalism is more than facts and figures, charts and tables. More than statistics and balance sheets, data can be used to tell a huge variety of stories. The third annual Data Driven symposium, hosted by Humber\u2019s Faculty of Media and Creative Arts (FMCA), was held on Nov. 15 at Google Canada\u2019s&hellip;","_links":{"self":[{"href":"https:\/\/humberjournalism.com\/convergencemag\/wp-json\/wp\/v2\/posts\/1057"}],"collection":[{"href":"https:\/\/humberjournalism.com\/convergencemag\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/humberjournalism.com\/convergencemag\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/humberjournalism.com\/convergencemag\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/humberjournalism.com\/convergencemag\/wp-json\/wp\/v2\/comments?post=1057"}],"version-history":[{"count":5,"href":"https:\/\/humberjournalism.com\/convergencemag\/wp-json\/wp\/v2\/posts\/1057\/revisions"}],"predecessor-version":[{"id":4237,"href":"https:\/\/humberjournalism.com\/convergencemag\/wp-json\/wp\/v2\/posts\/1057\/revisions\/4237"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/humberjournalism.com\/convergencemag\/wp-json\/wp\/v2\/media\/1147"}],"wp:attachment":[{"href":"https:\/\/humberjournalism.com\/convergencemag\/wp-json\/wp\/v2\/media?parent=1057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/humberjournalism.com\/convergencemag\/wp-json\/wp\/v2\/categories?post=1057"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/humberjournalism.com\/convergencemag\/wp-json\/wp\/v2\/tags?post=1057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}