Hjem

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