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 pageEdit
- 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.
People in the Ísmús database
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
Dataset Wikidata itemEdit
There are 10,003 people in the database at the time of the first import
Progress of importEdit
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|
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|
|Not done||Female||Add date of death statements||QuickStatements|
|Not done||Female||Add Icelandic Aliases||QuickStatements|
|Not done||Female||Add occupations||QuickStatements|
Discussion of importEdit
These headings are generally useful, please change this section to suit your needs.
Format the spreadsheet to import the dataEdit
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:
- Publish Google sheet to web
- 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.
Match the dataset to WikidataEdit
Auto-matching done in spreadsheet using existing list of all Icelandic people on Wikidata
Not done yet
Queries and expected resultsEdit
|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||
Schedule of new data releasedEdit
No set schedule but new data expected to be added periodically