Help

Difference between revisions of "SPARQL (HAL)"

Line 1: Line 1:
 +
== Éléments notables ==
 +
 +
=== Propriétés notables : HAL ===
 +
{| class="wikitable"
 +
! ItemLabel || WD Qid || sur WD || sur HAL
 +
|-
 +
|-
 +
| HAL || Q3144107 || -- || --
 +
|-
 +
| HAL author ID || `P4450` || 1,816 || 7,125?
 +
|-
 +
| HAL structure ID || `P6773` || 5,950 || 35,992
 +
|-
 +
| HAL article ID || `P7864` || 716 || 1,199,139
 +
|-
 +
| HAL journal ID || `P8903` || 29,733 || 100,000+?
 +
|}
 +
* Manque de réconciliation
 +
 +
=== Propriétés notables : Articles ===
 +
{| class="wikitable"
 +
! ItemLabel || WD Qid
 +
|-
 +
|-
 +
| title || `P1476`
 +
|-
 +
| author / author name string || `P50` / `P2093`
 +
|-
 +
| publication date || `P577`
 +
|-
 +
| published in || `P14233`
 +
|-
 +
| volume || `P478`
 +
|-
 +
| issue || `P433`
 +
|-
 +
| page(s) || `P304`
 +
|-
 +
| main subject || `P921`
 +
|}
 +
 +
=== Propriétés notables : Revues ===
 +
{| class="wikitable"
 +
! ItemLabel || WD Qid
 +
|-
 +
|-
 +
| inception || `P571`
 +
|-
 +
| title || `P1476`
 +
|-
 +
| main subject || `P921`
 +
|-
 +
| country of origin || `P495`
 +
|}
 +
 +
=== Propriétés notables : Auteurs ===
 +
{| class="wikitable"
 +
! ItemLabel || WD Qid
 +
|-
 +
|-
 +
| sex or gender || `P21`
 +
|-
 +
| date of birth || `P569`
 +
|-
 +
| place of birth || `P19`
 +
|-
 +
| country of citizenship || `P27`
 +
|-
 +
| given name || `P735`
 +
|-
 +
| doctoral advisor || `P184`
 +
|-
 +
| doctoral student || `P185`
 +
|}
 
== ✅ HAL Authors ==
 
== ✅ HAL Authors ==
 
=== ✅ Number of people in Wikidata with HAL Authors ID ([[:d:Property:P4450|P4450]]) ===
 
=== ✅ Number of people in Wikidata with HAL Authors ID ([[:d:Property:P4450|P4450]]) ===

Revision as of 05:07, 15 June 2023

Éléments notables

Propriétés notables : HAL

ItemLabel WD Qid sur WD sur HAL
HAL Q3144107 -- --
HAL author ID `P4450` 1,816 7,125?
HAL structure ID `P6773` 5,950 35,992
HAL article ID `P7864` 716 1,199,139
HAL journal ID `P8903` 29,733 100,000+?
  • Manque de réconciliation

Propriétés notables : Articles

ItemLabel WD Qid
title `P1476`
author / author name string `P50` / `P2093`
publication date `P577`
published in `P14233`
volume `P478`
issue `P433`
page(s) `P304`
main subject `P921`

Propriétés notables : Revues

ItemLabel WD Qid
inception `P571`
title `P1476`
main subject `P921`
country of origin `P495`

Propriétés notables : Auteurs

ItemLabel WD Qid
sex or gender `P21`
date of birth `P569`
place of birth `P19`
country of citizenship `P27`
given name `P735`
doctoral advisor `P184`
doctoral student `P185`

✅ HAL Authors

✅ Number of people in Wikidata with HAL Authors ID (P4450)

#defaultEndpoint:Wikidata
SELECT (COUNT(?item) AS ?number_Of_Hal_Authors_In_Wikidata)
WHERE {
  ?item wdt:P4450 ?halIdValue. 
}
... Loading ...


✅ HAL Authors on Wikidata → birthdate

#defaultEndpoint:Wikidata
SELECT ?item ?itemLabel ?halIdValue ?genderLabel (YEAR(?birthDate) AS ?birthYear)
WHERE {
  ?item wdt:P31 wd:Q5.                       # has HAL author ID `P4450`
  ?item wdt:P4450 ?halIdValue.               # HAL author ID `P4450` in ?halIdValue
  OPTIONAL { ?item wdt:P569 ?birthDate. }    # birthDate `P569` in ?birthDate
  # MINUS { ?item wdt:P569 ?birthDate. }
  OPTIONAL { ?item wdt:P21 ?gender. }        # gender `P21` in ?gender
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC (?birthYear)
... Loading ...

✅ HAL Authors on Wikidata → Authors cv, publications

#defaultEndpoint:Wikidata
SELECT ?item
?itemLabel 
 (ENCODE_FOR_URI(?itemLabel) AS ?uriLabel)  # Wikipedia title
?halIdValue
 (CONCAT("https://cv.hal.science/", STR(?halIdValue)) AS ?halAuthorCv)  #
 (CONCAT("<a href=https://hal.science/search/index/q/*/authIdHal_s/", STR(?halIdValue),">link</a>") AS ?halAuthorPublications)
 (CONCAT("https://api.archives-ouvertes.fr/search/?q=authIdHal_s:", STR(?halIdValue),'&wt=json') AS ?halAuthorPublicationsAPI)
WHERE {
  ?item wdt:P31 wd:Q5.                       # has HAL author ID `P4450`
  ?item wdt:P4450 ?halIdValue.               # HAL author ID `P4450` in ?halIdValue
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC (?itemLabel)
... Loading ...

✅ HAL Authors on Wikidata → Authors per gender (P21)

1814 authors HAL author ID with in wikipedia

#defaultEndpoint:Wikidata
SELECT 
?genderLabel (count(?item) AS ?nb)           # counting gender
WHERE {
  ?item wdt:P31 wd:Q5;                       # has HAL author ID `P4450`
        wdt:P4450 ?halIdValue.               # HAL author ID `P4450` in ?halIdValue
  OPTIONAL { ?item wdt:P21 ?gender. }        # gender `P21` in ?gender
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?genderLabel
... Loading ...

✅ HAL Articles

SELECT ?item ?itemLabel ?value {

 ?item wdt:P7864 ?dbvalue.
 BIND(IF(wikibase:isSomeValue(?dbvalue), "", ?dbvalue) AS ?value)
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }

}

✅ Number of items in Wikidata with `HAL article ID` property (P7864 )

#defaultEndpoint:Wikidata
SELECT (COUNT(?item) AS ?number_Of_Hal_Article_ID_In_Wikidata)
WHERE {
  ?item wdt:P7864 ?halIdValue. 
}
... Loading ...

✅ Number of items in Wikidata with `HAL Article ID` property (P7864) but no creation date (P571)

#defaultEndpoint:Wikidata
SELECT (COUNT(?item) AS ?number_Of_Hal_Article_ID_In_Wikidata)
WHERE {
  ?item wdt:P7864 ?halIdValue. 
  MINUS { ?item wdt:P571 ?creationDate. }
}
... Loading ...

✅ HAL Article → creation date (inception)

#defaultEndpoint:Wikidata
SELECT ?item ?itemLabel ?halIdValue
(YEAR(?publicationDate) AS ?publicationYear) 
?publishedIn ?pages
(GROUP_CONCAT(?authorLabel1 ; separator=" | ") as ?authorsList)
WHERE {
  ?item wdt:P7864 ?halIdValue .
  OPTIONAL { ?item wdt:P1476 ?title }          # title `P1476`
  OPTIONAL { ?item wdt:P577 ?publicationDate } # publication date `P577`
  OPTIONAL { ?item wdt:P14233 ?publishedIn }   # published in `P14233`
  OPTIONAL { ?item wdt:P304 ?pages }           # pages `P304`
  OPTIONAL { ?item wdt:P2093 ?author }           # author `P50`
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  
  BIND(CONCAT(UCASE(SUBSTR(?author, 1 , 1 )), SUBSTR(?author, 2 )) AS ?authorLabel1)
}
GROUP BY ?item ?itemLabel ?halIdValue ?publicationDate ?publishedIn ?pages
... Loading ...

✅ HAL Journals

✅ Number of items in Wikidata with `HAL journal ID` property (P48903)

#defaultEndpoint:Wikidata
SELECT (COUNT(?item) AS ?number_Of_Hal_Jounal_ID_In_Wikidata)
WHERE {
  ?item wdt:P8903 ?halIdValue. 
}
... Loading ...

✅ Number of items in Wikidata with `HAL journal ID` property(P48903) but no creation date (P571)

#defaultEndpoint:Wikidata
SELECT (COUNT(?item) AS ?number_Of_Hal_Jounal_ID_In_Wikidata)
WHERE {
  ?item wdt:P8903 ?halIdValue. 
  MINUS { ?item wdt:P571 ?creationDate. }
}
... Loading ...

✅ HAL Journal → creation date (inception)

#defaultEndpoint:Wikidata
SELECT ?item ?itemLabel ?halIdValue (YEAR(?creationDate) AS ?creationYear)
WHERE {
  ?item wdt:P8903 ?halIdValue.
  OPTIONAL { ?item wdt:P571 ?creationDate. }
  # MINUS { ?item wdt:P571 ?creationDate. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC (?creationYear)
... Loading ...

🇶 HAL Journal on Wikidata per country (P495)

1814 authors HAL author ID with in wikipedia

#defaultEndpoint:Wikidata
SELECT 
?countryLabel (count(?item) AS ?nb)           # counting occurence per country
WHERE {
  ?item wdt:P8903 ?halIdValue.               # HAL author ID `P4450` in ?halIdValue
  OPTIONAL { ?item wdt:P495 ?country }       # country of origin `P495`
  # OPTIONAL { ?item wdt:P921 ?topic }       # main subject `P921` 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?countryLabel
ORDER BY DESCC (?nb)
... Loading ...

Work to come