Data for Journalists Chapter Two

Chapter Two

Online Resources: Researching and Finding Data on the Internet

Here are exercises for this chapter and links to resources for effective searches for information and data that are available online.

  • Exercises

1. Find data on three international web sites, three U.S. government websites, and three U.S. state sites. Hint: The World Health Organization can be one of the international web sites.

2. Download data from one of those sites into a spreadsheet or Google sheet. If it does not import easily, then import it into the spreadsheet or Google sheet. Hint: You can try downloading tuberculosis data from the World Health Organization at https://www.who.int/tb/country/data/download/en/ and also the data dictionary so you know what the column headings mean.

3. Sign up for cometdocs.com at https://www.cometdocs.com/ and convert a PDF file to an Excel file. You can try this by downloading the employee compensation file from this city government and then using cometdocs to convert the PDF.

Here is the link and the file:

http://champaignil.gov/hr/salaries-and-benefits/

Fiscal Year 2017-18 Employee Compensation Report

 

© Brant Houston
https://ijec.org/databook/chapter-2-data-and-tips/
ijec.org
crawl=CC-MAIN-2019-51
37090
application/http; msgtype=response
sha1:IYL7ORIALO7B4U5UNKCUOEVC6FL6OXBV
<urn:uuid:e4999115-52a6-4804-b8b3-2412fe55d9c6>
2019-12-11T02:21:34Z
45.79.168.43
text/html
sha1:SQ5PC743EZEKJZ226IOWY5AQQ3MQARDM
<urn:uuid:0cc71feb-7e28-4e20-82fb-c341bdaf4b30>
https://ijec.org/databook/chapter-2-data-and-tips/
response
<urn:uuid:a6fdaa85-3ed0-4cdf-b7e6-65e1dc40c7f3>
isPartOf: CC-MAIN-2019-51
publisher: Common Crawl
description: Wide crawl of the web for December 2019
operator: Common Crawl Admin (info@commoncrawl.org)
hostname: ip-10-67-67-159.ec2.internal
software: Apache Nutch 1.16 (modified, https://github.com/commoncrawl/nutch/)
robots: checked via crawler-commons 1.1-SNAPSHOT (https://github.com/crawler-commons/crawler-commons)
format: WARC File Format 1.1
conformsTo: http://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/