User:Mcarondiotte/JIRIRI Wikidata

Creating Wikidata Items for the Journal of Interpersonal Relations, Intergroup Relations and Identity

The goal of this project is to produce Wikidata items for each of the articles published in the Journal of Interpersonal Relations, Intergroup Relations and Identity (JIRIRI). The JIRIRI is an international scientific journal in social psychology operated by undergraduate students in which articles are authored and reviewed by undergraduates. The Wikidata item for the periodical is Journal of Interpersonal Relations, Intergroup Relations and Identity (Q100418277)

Data Models

I follow the guidelines of the WikiProject Periodicals.

Wikidata Item for Volumes

Wikidata Item Page

• Item label: volume title
  • en: Journal of Interpersonal Relations, Intergroup Relations and Identity, Volume [volume number]
  • fr: Journal sur l'identité, les relations interpersonnelles et les relations intergroupes, volume [volume number]
• Item description:
  • en: [English word for the volume number] volume of the Journal of Interpersonal Relations, Intergroup Relations and Identity
  • fr: [French word for the volume number] volume du Journal sur l'identité, les relations interpersonnelles et les relations intergroupes

Statements

• instance of (P31): volume (Q1238720)
• part of the series (P179): Journal of Interpersonal Relations, Integroup Relations and Identity (Q100418277)
• follows (P155)
  • Wikidata item of the previous volume
• followed by (P156): Wikidata item of the next volume
• publication date (P577)
• number of pages (P1104)
  • string property
• language of work or name (P407): multiple languages (Q20923490)
• volume (P1433): volume
  • string property
• full work available at URL (P953): direct link to the complete volume on the JIRIRI website
  • url string property
• online access status (P6954): open access (Q232932)

Wikidata Item for Articles

Wikidata Item Page

• Item label: article title
• Item description:
  • en: scientific article
  • fr: article scientifique

Statements

• instance of (P31): scholarly article (Q13442814)
• title (P1476)
• publication date (P577)
• author (P50): Wikidata item for author (currently, if it already exists)
  • ideally, the author's item should include its ORCID iD (P496) and Google Scholar author ID (P1960) (if they exist)
  • series ordinal (P1545): order of authors (int: 1 to n)
• author name string (P:2093)
  • string property
  • series ordinal (P1545): order of authors (int: 1 to n)
• language of work or name (P407): either French (Q150) or English (Q1860) (the JIRIRI publishes articles in both languages)
• published in (P1433): Journal of Interpersonal Relations, Integroup Relations and Identity (Q100418277)
• volume (P1433): volume
  • string property
• page(s) (P1433): pages range
  • string property
• full work available at URL (P953): direct link to the article on the JIRIRI website
  • url string property
• online access status (P6954): open access (Q232932)

SPARQL Queries

This SPARQL query retrieve the data about all the articles published in the JIRIRI:

SELECT DISTINCT ?article ?title ?author ?order ?date ?volume ?pages ?url ?language WITH {
  SELECT DISTINCT ?article ?title ?author ?order ?date ?volume ?pages ?url ?language WHERE {
    ?article wdt:P31 wd:Q13442814 .
    ?article wdt:P1433 wd:Q100418277 .
    ?article wdt:P1476 ?title .
    ?article p:P2093 ?author_statement .
    ?author_statement ps:P2093 ?author
                      OPTIONAL { ?author_statement pq:P1545 ?order }
    ?article wdt:P577 ?date .
    ?article wdt:P478 ?volume .
    ?article wdt:P304 ?pages .
    ?article wdt:P953 ?url .
    ?article wdt:P407/wdt:P424 ?language .
  }
 } AS %i WITH {
  SELECT DISTINCT ?article ?title ?author ?order ?date ?volume ?pages ?url ?language WHERE {
    ?article wdt:P31 wd:Q13442814 .
    ?article wdt:P1433 wd:Q100418277 .
    ?article wdt:P1476 ?title .
    ?article wdt:P50 ?author_statement .
    OPTIONAL {?author_statement rdfs:label ?author .  filter(lang(?author)="en")} 
    OPTIONAL { ?author_statement pq:P1545 ?order }
    ?article wdt:P577 ?date .
    ?article wdt:P478 ?volume .
    ?article wdt:P304 ?pages .
    ?article wdt:P953 ?url .
    ?article wdt:P407/wdt:P424 ?language .
  }
 } AS %j WHERE { { include %i} UNION { include %j} }

Try it!

Roadmap

• Creation of the remaining items for all articles published in volumes 1 to 8
• Standardization of the articles already entered in Wikidata with the models presented above
• Enter new items for volumes and articles when a new volume is published (stay up-to-date)
  • automation of the update process (with Python)
• Creation of a Python script to convert the articles' Wikidata items to bibtex and RIS files
• Creation of a Wikidata item for the JIRIRI organization (following the WikiProject Periodicals)
• Create and link Wikidata items in author (P50) for authors that do not have a Wikidata item already
• Create and link Wikidata items in editor (P98) for the editors-in-chief (past and previous) (if they do not already exists)
  • include start date (P1545) and end date (P1545) qualifiers
• Include and populate the works cited (P2860) property for each article

Contributing

• Link already existing Wikidata items for authors
• Link Wikidata items in author (P50) for authors (create a Wikidata item for the authors that do not have one)
  • at least those items should have a ORCID iD (P496) and a Google Scholar author ID (P1960) if possible
• Create and link Wikidata items in works cited (P2860) for works cited in each JIRIRI article (create a Wikidata item for the works if needed, following WikiProject Periodicals)