18.104.22.168 Lab – Explore Sources of Open Data (Instructor Version)
Explore the different websites that provide openly available data.
- Part 1: Open Government Partnership
- Part 2: Open Data Websites
- Part 3: Data Visualization
Immeasurable amounts of data have been generated and stored. Data is useful only if it can be used to generate new knowledge. When data is made freely available for others to use, without intellectual property restrictions, this data is considered open data. Open data may require attribution to the original source. Derivations from the original work can also be designated as open data.
In this lab, you will explore several sources of open data. You will also explore the data visualization capability available on these websites to create insights based on facts.
- PC or mobile device with Internet access
Part 1: Open Government Partnership
The Open Government Partnership (OGP) was launched in 2011. The goal of the partnership is to create an international platform to create more open, accountable, and responsive governments for their citizens.
a. Navigate to www.opengovpartnership.org/ to find more information about OGP. (The photo you will see may vary.)
b. Click Participants at the top center of the screen.
List several countries that participate in the OGP.
c. Select a country using the map or the list at the bottom of the page to view information about that country’s participation in open data. Using Albania as an example, a page displays an overview of the country’s journey to join OGP. There are also many links to information regarding the country’s move toward a more open government.
d. The top of the page includes an overview of this country’s participation in the OGP. Scroll down the page to see additional information including Action Plans and Reports. Click People involved from Albania (or your selected country) to see a list of the people who are involved from this country.
e. Click Resources at the top of the screen. This page allows you to see information relevant to who you are and what your interest is.
f. Select All Resources (blue box). On the All Resources page, select Data and Research (below the All Resources heading). You will receive a variety of information. Select one of the case studies, for example Case Study (2014): Encouraging Parents’ engagement in Public Education Reform in Mexico.
g. Read the overview of the case study and then click the link below to see additional information.
How can you as a citizen benefit from a more open government?
Part 2: Open Data Websites
Many organizations, such as governments, universities, businesses, and non-profit organizations publish their open data. Are you interested in data about weather, housing, or crime?
a. Navigate to http://www.data.gov. This website is the home of the U.S. Government’s open data. At this website, you can find data and resources about research, software development, and other projects related to data. From this website, you can also navigate to the original websites that provided the published information.
b. Click Data at the top of the screen.
c. How many datasets are available? _________________________
d. Explore an interesting dataset or different topic category. For example, you can filter by different categories. If you are only interested in the data provided by a city government, click Data at the top of the screen. Click Local Government. Scroll down the list until you locate Organizational Types on the left panel. Click City Government.
e. Click Crimes – 2001 to present. This dataset provides the crime statistics for the City of Chicago from 2001 to the present.
f. You can download this dataset by scrolling down to the Downloads and Resources section.
What are the available downloadable file formats?
Click the Landing Page link under Downloads and Resources section to navigate to the City of Chicago’s Data Portal for the Crimes – 2001 to present page.
g. On this page, you can view the crime data for the City of Chicago from 2001 to the present without downloading the data. You can also view a portion of this data on a map. Click City of Chicago at the top of the page to navigate to the list of datasets available from the City of Chicago Data Portal. Under View Types, click Maps.
h. Under View Types in the left panel, click Maps to display a list of maps. Click the dataset titled Crimes – Map. This presents an interactive map of the Chicago area with crime locations for the past year.
i. Click dataset titled Crimes – Map. This presents an interactive map of the Chicago area with crime locations for the past year. You can explore the crime locations by clicking the red dots or zooming in using the scroll bar on the left.
j. If you are interested in other organizational data, you can navigate back to http://www.data.gov and search for other topics. Similar websites for other countries can be found by searching on the Internet. For example:
Part 3: Data Visualization
Data visualization can help you make sense of lists of numbers and present the lists of numbers in a meaningful way. Visualization can help you “see” trends that may be otherwise missed.
Step 1: Explore knoema
At www.knoema.com, you can find many ways to graphically represent statistical data.
a. At the home page, scroll down. A list of different topics displays, such as This Just In, and Viz of the day. Scroll down the page to view many more topics that you can explore.
b. What is the topic for Viz of the day?
c. Click the title and explore the issues and the different graphs available to you. Name the data sources.
d. At the top of the page, click the down arrow next to Data. Click World Data Atlas. From here, or from any category, you can explore the variety of data available to you.
Step 2: Explore Gapminder
The mission of the Gapminder Foundation is to fight knowledge gap using statistical data gathered from various sources. By creating rich data visualization and animated data presentations, statistical data becomes interesting.
In this step, you will explore the free material available from www.gapminder.org.
a. Navigate to www.gapminder.org.
b. Click Videos to view presentations that bring statistical data to life and make the data more relevant to you.
Find videos that are of interest to you. After viewing some of the videos, how did it change your perception of the world?
c. To interact with the bubble charts that were presented in the videos, click Gapminder World.
d. Click Play. Observe the scatterplot changes for the trend between Life expectancy (years) vs. Income per person. Each of these bubbles represents the progress of a country.
What relationship did you observe?
e. Change the y-axis Life Expectancy (years) to Population aged 60+ years, both sexes (%) so the chart compares the percentage of the population over 60 with income per person.
f. Now select a few countries to highlight their path from 1950 to 2012. In this example, Canada, Germany, and Japan were selected. Japan will have the highest percentage of their population at 60+ years of age in 2030 according to the data visualization from http://knoema.com/awppbnd/how-well-ageing-populationis-faring.
g. Click Play to observe the trace for these three countries.
What relationship do you see?
h. The data sources used in these charts are available to you by clicking the grid symbol next to the x or y axis on the chart. Click the grid symbol to view or download the raw data.
Source: Free material from www.gapminder.org
Now you have had a brief introduction to data visualization from different websites. Choose your favorite data visualization website and perform a visualization of your own.
Briefly describe the visualization you performed.
What did you learn as a result of the visualization?