Wikidata:Dataset Imports/Interlinking dataset of the video game databases Mobygames, GameFAQs and MediaArt DB
You may find these related resources helpful:
Guidelines for using this page[edit]
Documenting the import[edit]
- 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[edit]
- 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[edit]
- 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[edit]
Dataset name[edit]
Interlinking dataset of the video game databases Mobygames, GameFAQs and MediaArt DB
Source[edit]
diggr Research Project
Link[edit]
Dataset description[edit]
The dataset provides identifiers for the interconnection between video game entities in the databases Mobygames, GameFAQs and MediaArt DB.
The links between the databases were created automatically be using a title comparsing algorithm.
The provided links are based on the existence of a MobyGames Game ID in Wikidata and a probability threshold of 0.9 and higher. That means, only items that already have a MobyGames Identifier will be considered
Additional information[edit]
Progress of import[edit]
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 |
|---|---|---|---|---|---|---|---|
| Interlinking dataset of the video game databases Mobygames, GameFAQs and MediaArt DB | done | done | GameFAQs mapping: done
Media Art DB: done | done | GameFAQs: done
| Not done yet | Not done yet |
Edit history[edit]
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.
| Date | Description | Method | EditGroup | Properties | Qualifiers | References | Statements added | Statements removed | Link to import sheet |
|---|---|---|---|---|---|---|---|---|---|
| 2019-08-26 | add GameFAQs IDs | Import via Open Refine | #fa7c0377a (EditGroup) | ||||||
| 2019-08-27 | add Media Art Database console ID with qualifiers | Import via Open Refine | #52af7683d (EditGroup) | ||||||
| 2019-08-30 | add missing qualifiers for GameFAQ IDs (platform 3DO) | Import via Open Refine | #8bb77bdcd (EditGroup) |
Discussion of import[edit]
These headings are generally useful, please change this section to suit your needs.
Wikidata item for dataset[edit]
Interlinking dataset of the video game databases Mobygames, GameFAQs and MediaArt DB (Q65814486)
Import data into spreadsheet[edit]
Format the spreadsheet to import the data[edit]
Structure of data within Wikidata[edit]
| Field name | Wikidata property | Notes |
|---|---|---|
| gf_id | GameFAQs Game ID (P4769) | |
| platform | platform (P400) | Qualifier for GameFAQs ID |
| wkp | Wikidata Item |
| Field name | Wikidata property | Notes |
|---|---|---|
| ma_id | MediaArt Database console game ID (P7117) | |
| Title_full | named as (P1810) | Qualifier for ID |
| publication date | publication date (P577) | Qualifier for ID |
| platform | platform (P400) | Qualifier for ID |
| wkp | Wikidata Item |
Match the dataset to Wikidata[edit]
Importing data into Wikidata[edit]
First import (2019-08-26) contains GameFAQs IDs for 11.135 wikidata items.
Second import (2019-08-27) contains Media Art Database console game ID for 5.771 wikidata items.
Import completion notes[edit]
Visualisations[edit]
Maintenance[edit]
Queries and expected results[edit]
| Query link | Description | Expected results |
|---|---|---|
| Link1 | Property1 | Notes1 |
| Link2 | Property2 | Notes2 |
| Link3 | Property3 | Notes3 |