The Data Journalist: Getting the Story by Fred Vallance-JonesThe Data Journalist: Getting the Story by Fred Vallance-Jones

The Data Journalist: Getting the Story

byFred Vallance-Jones, David Mckie

Paperback | September 26, 2016

Pricing and Purchase Info


Earn 300 plum® points

Prices and offers may vary in store


Ships within 1-3 weeks

Ships free on orders over $25

Not available in stores


The definitive guide to using data and technology in reporting, this text teaches students how to combine data analysis with traditional reporting to create compelling stories. Through coverage of theory, practical examples, online tutorials, and celebrated stories from around the world, thistext demonstrates the tools and principles of data-driven journalism.
Fred Vallance-Jones is an award-winning journalist and an associate professor at the University of King's College. He teaches journalism research and data and investigative journalism at the masters and undergraduate levels, and continues to lead students in large data-driven investigative projects. He leads an annual data journalism s...
Title:The Data Journalist: Getting the StoryFormat:PaperbackDimensions:320 pages, 9 × 6 × 0.6 inPublished:September 26, 2016Publisher:Oxford University PressLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:019902006X

ISBN - 13:9780199020065

Look for similar items by category:


Table of Contents

Note: Chapters include:- Bulleted "What you will learn" list- Introduction- General text boxes- Tutorial boxes (linking to online content)- Study questions and exercisesPART I: INTRODUCTION1. IntroductionThe Origins of Data JournalismTechnology: The Tools of Data and How Journalists Use Them2. Online and Open DataWhat You Will LearnPrinciplesThe History of Open Government and Open DataWhat Kind of Data Can You Get?- Chicago's Crime Database- Toronto Payment Card Data- Road Accidents in the United Kingdom- Vancouver Food Vendors- Mine AccidentsData Quality ConcernsSteps to Take When Working with Any DatasetStudy Questions and Exercises3. When Data Is Not Conveniently AvailableWhat You Will LearnInforming YourselfAskingNegotiating for DataDemandingMaking an Effective Request for DataAfter You Make the RequestThe Answer4. Spreadsheets: The Basic ToolWhat You Will LearnSo What Exactly Is a Spreadsheet?Fundamentals of SpreadsheetsHow Journalists Use SpreadsheetsGetting Data into a SpreadsheetGetting to WorkSorting and Simple AnalysisFilteringDoing the Math- Functions Big and Small- Calculating Percentages- Calculating RatesDealing with ErrorsWorking with DatesConcatenationSummarizing Information with Pivot TablesLogical Functions and IF StatementsUsing Paste Special to Convert Formulas to ValuesChronologiesConclusion5. Working with DatabasesWhat You Will LearnWorking with a DatabaseBuilding RelationshipsDatabase ProgramsMaking Tables and Adding DataThe Main Course: Querying your Data- The Language of Queries- Writing Math Queries- The GROUP BY Clause- The HAVING Clause- Aliases- Joining Tables- Some Notes about JoiningMore Advanced Queries- Outer Joins- Union Queries- Subqueries- Using Calculated Fields and String Functions- Creating Views (MySQL)- Improving Query Performances by Adding Indexes- Queries to Alter your Data- Exporting Query ResultsBuilding your own DatabaseSome Final Thoughts6. Introduction to Maps in JournalismWhat You Will LearnMaps Are Not Reality, but Representations of RealityWeb Mapping ServicesGetting your Data onto a Web MapData Not Already in a Map FormatYour Data Is Ready; How To Use It?What Kinds of Maps Can You Make?- Boundary MapsSome Important Design Principles- A Choice of Styles- Choosing Appropriate Colours- Setting BreakpointsConclusion7. Working with GIS ProgramsWhat You Will LearnThe Inside StoryEllipsoids and Datums: Modelling the WorldProjectionsHow Datums and Projections are Incorporated in a GISBasics of a GISHow Spatial Data Is Structured- Metadata- Geometrics- Attributes- Working with LayersHow Journalists Use GIS Programs- Joining Non-Geographic Data with Geographic Data- Selecting Features that Meet Certain Criteria- Buffering- Joining Data Based on Geographical Location- Making a Chloropleth Map- GeocodingCommon Problems and Solutions- Projecting and Re-Projecting a Map Layer- Converting File Formats- Simplifying Polygons- Combining Layers into a Single Layer- Combining Features within a Single LayerSpecial Considerations Relative to Coordinate Systems- Using a Map Layer that has Only a Geographic Coordinate System- Using Maps Based on Different Geographic Coordinate Systems- Using an Inappropriate Projected Coordinate SystemConclusionRecommended Further Reading8. Visualizing DataWhat You Will LearnA History of Visualization: From William Playfair to the Present DayChoosing the Right Chart- The Pie Chart- A Bar Chart- The Line ChartHow Journalists Use "Data Viz" Tools- One Producer's ViewConclusionPART II: ADVANCED TOPICS9. Web ScrapingWhat You Will LearnThe Underpinnings of ScrapingOptions for ScrapingFirst Steps, Thinking through your ScrapeCoding BasicsGetting Ready to Code- Fetching the Page- Scraping More than One Page- More Complicated ScrapesThe Ethics of Web ScrapingAPIsConclusionAdditional Resources10. Web DevelopmentWhat You Will LearnState of Developers in NewsroomsCore Languages Used by Newsroom Developers: An Introduction to the Work Environment- The Server-Side: Writing for your Own Machine- The Client-Side: Writing for Everyone Else's MachineCase Study: Using freeDiveWorking with JavaScript Libraries such as jQuery and D3ConclusionAdditional Reading11. Incorporating Data Journalism into Traditional ReportingWhat You Will LearnWhy Data is Just the BeginningFinding Outliers that Lead to Human StoriesTesting your Data in the Real WorldConnecting Data Patterns with Real-Life PatternsBuilding Powerful Interviews and Writing the StoryConclusionGlossaryNotesCreditsIndex

Editorial Reviews

"The step-by-step instruction and sample datasets will be a great starting point for students to delve into data journalism. . . . More journalists need to be data savvy, and this textbook offers examples and steps to get there." --Cheryl Vallender, Sheridan College