1 / 31

FINDING DATA ON LINE

FINDING DATA ON LINE. An increasing number of governments are all levels are putting data on line Those databases come in all shapes and sizes The betting might be that journalists lack the time and expertise to make sense of it We must prove destroy that assumption.

waylon
Download Presentation

FINDING DATA ON LINE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. FINDING DATA ON LINE An increasing number of governments are all levels are putting data on line Those databases come in all shapes and sizes The betting might be that journalists lack the time and expertise to make sense of it We must prove destroy that assumption

  2. WHY WORK WITH DATA ONLINE • Produces original stories that our competitors may not have • More original stories, fewer encounters with assignment editors • Data ads context • Allows audiences to interact • Gives us quick reference points when stories break • Allows us to do a better job following money

  3. WHAT TOOLS DO YOU NEED • General knowledge of data: its strengths and weaknesses • Abandon your fear of numbers • Developing simple math skills: adding, subtracting, ratios, etc. • Good knowledge of Excel; database managers; Mapping software; data-visualization tools

  4. SOME EXAMPLES OF OPEN DATA SITES • Edmontonhttp://data.edmonton.ca/ • Halifax’s Open Data Cataloguehttps://www.halifaxopendata.ca/ • Ottawahttp://app06.ottawa.ca/en/city_hall/statisticsdata/opendata/info/index.htm • Torontohttp://www1.toronto.ca/wps/portal/contentonly?vgnextoid=1a66e03bb8d1e310VgnVCM10000071d60f89RCRD • Vancouverhttp://data.vancouver.ca/ • BChttp://www.openinfo.gov.bc.ca/ibc/index.page?http://www.data.gov.bc.ca/ • Ontariohttp://www.ontario.ca/government/open-data-ontario • Open Data Pilot Project (federal government)http://www.data.gc.ca/default.asp?lang=En • World Development Indicators (The World Bank)http://data.worldbank.org/data-catalog/world-development-indicators?cid=GPD_WDI • Québec Ouvert (les donnéesouvertes pour le Québec)http://quebecouvert.org/

  5. Toronto restaurant inspections

  6. DINESAFE

  7. DineSafe

  8. DINESAFE DATA

  9. MAPPING NASTY RESTAURANTS

  10. DINESAFE APP

  11. Elections • Elections Canadahttp://www.elections.ca/scripts/webpep/fin/select_sear • Elections Ontariohttp://www.elections.on.ca/en-CA/Tools/FinancialStatementsandContributions/RealTimeDisclosure.htmch_option.aspx • Quebec political contributionshttp://www.electionsquebec.qc.ca/francais/provincial/financement-et-depenses-electorales/recherche-sur-les-donateurs.php#

  12. ONTARIO

  13. The data website

  14. The data

  15. QUEBEC

  16. The website

  17. The data

  18. The data_part two

  19. National data sets • Open Data Pilot Project (federal government)http://www.data.gc.ca/default.asp?lang=En • Arms Exportshttp://strategis.ic.gc.ca/sc_mrkti/tdst/tdo/tdo.php#tag • Canadian charities (Canada Revenue Agency)http://www.cra-arc.gc.ca/chrts-gvng/lstngs/menu-eng.html • Civil Aviation Daily Occurrence Reporting System (CADORS): Main Menu • http://wwwapps.tc.gc.ca/Saf-Sec-Sur/2/CADORS-SCREAQ/m.aspx?lang=eng • Sunlight Foundation Tools and Projects http://sunlightfoundation.com/tools/

  20. Tracking lobbying dollars in the U.S.

  21. INFLUENCE EXPLORER

  22. OPEN SECRETS

  23. International datasets • Datacatalogs.org (a comprehensive list of open data catalogs currated by experts from around the world)http://datacatalogs.org/ • National Transportation Safety Board inventory of databaseshttp://www.ntsb.gov/investigations/databases.htmlhttp://www-odi.nhtsa.dot.gov/downloads/ • The FDA's Adverse Drug Reaction Databasehttp://www.fda.gov/Drugs/GuidanceComplianceRegulatoryInformation/Surveillance/AdverseDrugEffects/ucm082193.htm • MAUDE - Manufacturer and User Facility Device Experience • http://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfmaude/search.cfm • U.S. Department of LABOUR (Occupational Safety & Health Administration)http://www.osha.gov/pls/imis/establishment.html • http://ogesdw.dol.gov/data_catalogs • http://ogesdw.dol.gov/data_summary.php

  24. THE STORY

  25. WHERE IT CAME FROM • Buyandsell.gc.ca • https://buyandsell.gc.ca/procurement-data/tenders/download-tenders-data

  26. The Excel table

  27. THE COUNTERFEIT REFERENCE http://www.ontario.ca/government/open-data-ontario

  28. PUBLIC ACCOUNTS

  29. PUBLIC ACCOUNTS

  30. STUDENT DEBT

More Related