Wikidata:Dataset Imports/People in the Ísmús database

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

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

Overview

Dataset name

People in the Ísmús database

Source

Ísmús

Link

https://www.ismus.is/l/person

Dataset description

Just over 10,000 People listed on Ísmús website, an Icelandic music and cultural heritage database. Data available for each person:

• Ísmús unique URL to description page
• Icelandic name
• Icelandic Aliases
• Date of birth
• Date of death
• Gender
• Occupations

Dataset Wikidata item

people listed in the Ísmús database (Q63565750)

Additional information

There are 10,003 people in the database at the time of the first import

Progress of import

The initial focus was adding the missing women from the dataset, so I've split the progress section to track each gender separately.

Gender segment	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
Female	Done (Link)	Done	Done	Done	Doing…	Not done	Not done
Male	Not done	Not done	Done	Not done	Not done	Not done	Not done

Edit history

The edit history so far, as well as planned upcoming edits are shown below:

Date	Segment	Description	Method	Properties	Qualifiers	References	Items created	Statements added	Statements removed	Link to import sheet
5 Mar 2019	Female	Created missing items and added URL for each person	QuickStatements	described at URL (P973)			1924	1924	0	Link
5 Mar 2019	Female	Add Icelandic labels	QuickStatements	label				1924	0	Link
5 Mar 2019	Female	Add instance of human statements	QuickStatements	instance of (P31) = human (Q5)		reference URL (P854)		1976	0	Link
5 Mar 2019	Female	Add gender statements	QuickStatements	sex or gender (P21) = female (Q6581072)		reference URL (P854)		1976	0	Link
5 Mar 2019	Female	Add date of birth statements	QuickStatements	date of birth (P569)		reference URL (P854)		1860	0	Link
6 Mar 2019	Female	Add country of citizenship statements	QuickStatements	country of citizenship (P27) = Iceland (Q189)		reference URL (P854)		1976	0	Link
4 Nov 2019	Female	Add occupations	QuickStatements	occupation (P106)		reference URL (P854)		2265	0	Link
Not done	Female	Add date of death statements	QuickStatements
Not done	Female	Add Icelandic Aliases	QuickStatements

Discussion of import

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

Format the spreadsheet to import the data

The simplest method for extracting data from the website is to filter the view to required data then copy and paste into Google sheet.

When you do this, you need to extract the links for each item from the 'embedded HTML' links that result in your spreadsheet.This can be achieved with this online solution (scroll down to the solution at the end of the thread). The basic steps are:

1. Publish Google sheet to web
2. Import data back using IMPORTXML

Note that most solutions you find online only work when the hyperlink() formula has been used, but this solution works with embedded HTML links as well.

NavinoEvans (talk) 18:10, 7 May 2019 (UTC)

Match the dataset to Wikidata

Auto-matching done in spreadsheet using existing list of all Icelandic people on Wikidata

Visualisations

Not done yet

Maintenance

Queries and expected results

Query link	Description	Expected results
All People with Described at URL starting with "https://www.ismus.is/i/person/"	Shows all people imported so far, along with the link back to their page on the data source. This property is the main link used for matching	All URLs should be unique Should be around 10,000 or fewer results

Schedule of new data released

No set schedule but new data expected to be added periodically

Exclusions

One item in the dataset is a test page and should not be imported - https://www.ismus.is/i/person/uid-ada4f2b8-b7fe-41bf-9454-b38aa4cc6cce