Open main menu

Wikidata:Dataset Imports/Fertility rate for countries and geographical regions

< Wikidata:Dataset Imports

You may find these related resources helpful:

High-contrast-document-save.svg Dataset Imports    High-contrast-view-refresh.svg Why import data into Wikidata.    Light-Bulb by Till Teenck.svg Learn how to import data    Noun project 1248.svg Bot requests    Question Noun project 2185.svg Ask a data import question


Guidelines for using this pageEdit

Documenting the importEdit

  • 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 datasetEdit

  • 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 page (P5195)

Getting helpEdit

  • 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.


Dataset nameEdit

Fertility rate for countries and geographical regions


UNESCO Institute of Statistics


Dataset descriptionEdit

Fertility Rate (average number of births per woman) for countries and geographical regions dating back to 1970. New data released annually, usually 3 years behind current year.

Additional informationEdit

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 importEdit

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 datasetImport data into spreadsheetFormat the spreadsheet to import the dataStructure of data within WikidataMatch the dataset to WikidataImporting data into WikidataVisualisationsMaintainance queries and expected results
UIS fertility rate dataset (Q63434950)  Done (Link)  Done  Done   Done  Done (1999 - 2014)  Done  Not done

Edit historyEdit

Use the table below to list batches of edits that have been completed for this dataset. Ideally each entry should have all applicable columns filled out, but at a minimum please make to add a date and description to give an idea of what was added to Wikidata and when.

DateDescriptionMethodPropertiesQualifiersReferencesStatements addedStatements removedLink to import sheet
20 Feb 2018Initial import of data for all countries/regions (1999 to 2014)API (wikidata-edit Node.js)total fertility rate (P4841)
  • reference URL (P854)
  • 31940Main sheet with some additional fixes

    Discussion of importEdit

    These headings are generally useful, please change this section to suit your needs.

    Structure of data within WikidataEdit

    Field name Wikidata property Usage Notes
    Fertility rate number of out-of-school children (P2573) Main statement
    Year of statistic point in time (P585) (Qualifier) Qualifier
    reference URL (P854) = Reference Same for all statements
    stated in (P248) = UNESCO Institute for Statistics (Q3152127) Reference Same for all statements

    Match the dataset to WikidataEdit

    Only countries and geographic regions needed matching for this dataset (see matching sheet)

    Import completion notesEdit

    Completed for years 1999 - 2014



    Schedule of new data releasedEdit

    New data released annually (around 3 years behind the current year).