Wikidata:Dataset Imports/Life expectancy at birth for countries and geographical regions

You may find these related resources helpful:

• Dataset Imports
• Why import data into Wikidata.
• Learn how to import data
• Bot requests
• Ask a data import question

Guidelines for using this page

Documenting the import

• Guidelines on how to import a dataset into Wikidata are available at Wikidata:Data Import Guide.
• Please include notes on all steps of the process.
• Once a dataset has been imported into Wikidata please edit the page to change the progress status from in progress to complete.
• It is strongly recommended to use Visual Editor when making changes to this page, particularly for editing any of the tables.

Creating a Wikidata item for the dataset

• Please create a Wikidata item for the dataset, this will allow us to improve the coverage of datasets on Wikidata and understand what datasets are available on that topic and which of them have been added to Wikidata.
• If you are working with very large dataset you can break it into smaller Mix n' Match catalogues, but only create one Wikidata item.
• Link the dataset Wikidata item to this page using Wikidata Dataset Imports URL (P5195)

Getting help

• If your dataset import runs into issues please edit the page to change the progress status from in progress to help needed.
• You can ask for help on Wikidata:Project chat.

Overview

Dataset name

Life expectancy at birth for countries and geographical regions

Source

UNESCO Institute of Statistics

Link

http://data.uis.unesco.org/index.aspx?queryid=239 (select "Life expectancy" from dropdown menu)

Dataset description

Life expectancy for countries and geographical regions dating back to 1970. New data released annually, usually 3 years behind current year.

Additional information

To avoid cluttering up country items with very large numbers of date qualified statements, available data has only been imported from 1999 onward (available from 1970 for many countries and regions). It is expected we will need to switch to using a Data Table on Wikimedia Commons in the future, as this would give access to full record of historical values with only a single statement on Wikidata. This has not been done at this stage because it is not yet possible to query Data Tables on Commons using the Wikidata Query Service.

Progress of import

The table below is used to track the progress of importing this dataset. The suggested column headings are most applicable to data being imported from a spreadsheet - you can change some column headings or add new columns as required to best describe the progress of this import.

Wikidata item for the dataset	Import data into spreadsheet	Format the spreadsheet to import the data	Structure of data within Wikidata	Match the dataset to Wikidata	Importing data into Wikidata	Visualisations	Maintainance queries and expected results
UIS life expectancy dataset (Q63494730)	Done (Link)	Done	Done	Done	Done	Done	Not done

Edit history

Date	Description	Method	Properties	Qualifiers	References	Statements added	Statements removed	Link to import sheet
17 Oct 2018	Initial import of all countries from 1999 - 2016	QuickStatements	life expectancy (P2250)	point in time (P585)	reference URL (P854) stated in (P248) = UNESCO Institute for Statistics (Q3152127)	3579	0	Import sheet

Discussion of import

Structure of data within Wikidata

Field name	Wikidata property	Usage	Notes
Fertility rate	life expectancy (P2250)	Main statement	Use "year" as unit
Year of statistic	point in time (P585) (Qualifier)	Qualifier
	reference URL (P854) = http://data.uis.unesco.org/Index.aspx?DataSetCode=DEMO_DS	Reference	Same for all statements
	stated in (P248) = UNESCO Institute for Statistics (Q3152127)	Reference	Same for all statements

Visualisations

Interactive heat map comparing life expectancy at birth for different countries around the world (2015 snapshot)

Added to a wiki page using the Kartographer extension, driven by this Wikidata query

<mapframe>: Couldn't parse JSON: Syntax error

Queries and expected results

Query link	Description	Expected results

Schedule of new data released

Released annually, generally around 3 years behind current year.