Property talk:P648

From Wikidata
Jump to navigation Jump to search

Documentation

Open Library ID
identifier for a work ("W"), edition ("M") or author ("A") for book data of the Internet Archive
DescriptionIdentifier assigned by Open Library (Q1201876) for works, editions and authors.
Associated itemOpen Library (Q1201876), Open Library (Q1201876)
Applicable "stated in" valueOpen Library (Q1201876)
Data typeExternal identifier
Domainhuman (Q5), creative work (Q17537576), work (Q386724), organization (Q43229), pseudonym (Q61002), version, edition or translation (Q3331189) or literary work (Q7725634)
Allowed valuesOL[1-9]\d*[AMW]
ExampleTwenty Years After (Q1639633)OL36858W (RDF)
Anton Chekhov (Q5685)OL3156833A (RDF)
Libraries in the Medieval and Renaissance Periods (Q45341759)OL6917238M (RDF)
Sourcehttps://openlibrary.org/
Formatter URLhttps://openlibrary.org/works/$1?mode=all
https://openlibrary.org/work/$1.json
https://openlibrary.org/work/$1.rdf
Robot and gadget jobshttps://openlibrary.org/books/$1
Tracking: usageCategory:Pages using Wikidata property P648 (Q51440038)
Related to country United States of America (Q30) (See 770 others)
See alsoOpen Library subject ID (P3847), Internet Archive ID (P724), ORCID iD (P496), Authorea author ID (P5039), NARCIS researcher ID (P7449), ISNI (P213), Goodreads author ID (P2963), Amazon author ID (P4862), Open Library publisher ID (P12088)
Lists
Proposal discussionProposal discussion
Current uses
Total440,948
Main statement404,92791.8% of uses
Qualifier11<0.1% of uses
Reference36,0108.2% of uses
Search for values
[create Create a translatable help page (preferably in English) for this property to be included here]
Format “OL[1-9]\d{0,7}[AMW]: value must be formatted using this pattern (PCRE syntax). (Help)
List of violations of this constraint: Database reports/Constraint violations/P648#Format, hourly updated report, SPARQL
Distinct values: this property likely contains a value that is different from all other items. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Fabulation, or the Re-Education of Undine (Q5428254), Intimate Apparel (Q6057615)
List of violations of this constraint: Database reports/Constraint violations/P648#Unique value, SPARQL (every item), SPARQL (by value)
Single value: this property generally contains a single value. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: no label (Q40220865), Mirza Ghalib (Q107000)
List of violations of this constraint: Database reports/Constraint violations/P648#Single value, SPARQL
Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P648#Entity types
Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P648#Scope, SPARQL
Unsuitable OL identifier M
OL identifier ending with M should only be used with editions. (Help)
Violations query: SELECT ?item ?val{ ?item wdt:P648 ?val . FILTER(SUBSTR(?val, STRLEN(?val), 1) = 'M') MINUS { ?item wdt:P31/wdt:P279* wd:Q3331189 } }
List of this constraint violations: Database reports/Complex constraint violations/P648#Unsuitable OL identifier M
Unsuitable OL identifier W
OL identifier ending with W should only be used with works. (Help)
Violations query: SELECT ?item ?val{ ?item wdt:P648 ?val . FILTER(SUBSTR(?val, STRLEN(?val), 1) = 'W') MINUS { ?item wdt:P31/wdt:P279* wd:Q47461344 } }
List of this constraint violations: Database reports/Complex constraint violations/P648#Unsuitable OL identifier W
Unsuitable OL identifier A
OL identifier ending with A should only be used with humans, pseudonyms or organizations. (Help)
Violations query: SELECT ?item ?val{ ?item wdt:P648 ?val . FILTER(SUBSTR(?val, STRLEN(?val), 1) = 'A') MINUS { ?item wdt:P31 wd:Q5 } MINUS { ?item wdt:P31/wdt:P279* wd:Q43229 } MINUS { ?item wdt:P31/wdt:P279* wd:Q61002 } }
List of this constraint violations: Database reports/Complex constraint violations/P648#Unsuitable OL identifier A

Danger, Will Robinson!

[edit]

Author Identifiers OL\dA are often non-unique. Several such OL records may exist for a single author, even with the exact same spelling of the name. In other cases, one OL record may reflect many authors with similar names. OL has been dragging its feet for years on implementing consistent authority controls. I've tried to get their attention on this problem to no avail. We'll need to be able to deal with this. Work Identifiers OL\dW are often non-unique, with the same or varying title, linked to various author records. Cleaning up the mess at https://openlibrary.org/search?q=Odyssey&author_key=OL6848355A could take weeks. Edition Identifiers OL\dM are even more of a mess. They conflate different editions under one record, and have multiple records for one edition. All this said, however, OL remains one of the most useful ways to locate a freely-readable copy of many sources. As such, OL identifiers are given for editions or works cited, per w:en:SAYWHEREYOUGOTIT. We'll need to accommodate the multiple OL identifiers attributed to one work, edition, or author. We'll also need to distinguish the multiple works, editions, or authors conflated by one OL identifier. It's nontrivial. It may be impossible to code. Ideas? LeadSongDog (talk) 17:30, 16 June 2016 (UTC)[reply]

  • @LeadSongDog: Thanks for the info! For specificity, can you give examples of such duplications for A, W, M? (I haven't yet seen a M ID, I'd like to see one).
Authors with many OL ID, OL ID mapping to several authors (first one is a mistake on WD)
IMHO WD only needs to worry about the multiplicity if OL goes ahead and removes duplicate IDs without keeping a redirect to the surviving (merged-to) ID: do you have evidence of this happening? Otherwise WD could help OL by finding such duplicates (as constraint violations) but WD can't clean up OL's database. If you yourself say OL IDs are useful, we should keep them. --Vladimir Alexiev (talk) 10:07, 7 June 2017 (UTC)[reply]
@Vladimir Alexiev: Well, an obvious case is OL2624944A. The appropriate quick intervention (which I did in this case) is to suffix " (undifferentiated)" to the author name. The harder job is to mine each of the linked works and its editions in order to find sourcing for more completely spelled names (often via an edition's ISBN or OCLCno), then edit the OL\d*W record to reflect that finding. In most cases there will already be an OL\d*A record to link in. Sometimes there are duplicates even at the better (more specific) spelling. [1] and [2] are the same person, while [3] is quite another. VIAF and ISNI can help to clarify these cases. The latter died before the former was born. LeadSongDog (talk) 17:06, 7 June 2017 (UTC)[reply]

Split this property

[edit]

This property is currently used for the OpenLibrary identifiers for works, editions and people. But, sadly Open Library is using different URI patterns for each of these type (https://openlibrary.org/works/$1, https://openlibrary.org/authors/$1...). It would be nice to split this property in 3 to avoid this problem and to be able to have better constraints. I would suggest to keep this property for the author identifiers (around 119117 usages) and create two new properties, one for works (around 956 usages) and one for editions (around 34324 usages). What do you think about it? Tpt (talk) 14:15, 13 June 2018 (UTC)[reply]

  • I think a feature was requested to address the uri question. It seems to be in the works somewhere. If the existing property is re-purposed as suggested, users might get incoherent results.
    --- Jura 14:19, 13 June 2018 (UTC)[reply]
Agree, it would make sense to have distinct properties OpenLibrary author identifier, OpenLibrary work identifier, and OpenLibrary edition identifier as subtypes of OpenLibrary identifier.LeadSongDog (talk) 16:55, 30 November 2018 (UTC)[reply]

Author duplicates

[edit]

I leave here two useful queries I've been using in the last months in order to find duplicates on Open Library:

--Epìdosis 11:23, 23 August 2019 (UTC)[reply]

Work/edition duplicates

[edit]

A lot of items about works have duplicate ids, because one id represents the work, the other represents just one specific edition. The second one is wrong; there are many editions and the item is about the work, not about some edition. I think this happened mostly because a bot imported both Openlibrary_work and Openlibrary_edition from Internet Archive. Examples: Q466412, Q3603012, Q331651 (or see this search on it.wiki, 950 pages have duplicate external links because of wikidata). Please fix it --Bultro (talk) 10:13, 16 April 2020 (UTC)[reply]

I think the wrong id is always the one that ends with "M". Their urls redirect to openlibrary.org/books... instead of openlibrary.org/works... --Bultro (talk) 10:22, 16 April 2020 (UTC)[reply]
Nearly 40k M identifiers in non-instance of (P31)version, edition or translation (Q3331189) items, all listed here:
#Edition IDs in non-edition items
SELECT ?p ?site WHERE {
  ?p p:P648 [ps:P648 ?site].
  filter(contains(str(?site),"M"))
  MINUS { ?p wdt:P31 wd:Q3331189 . }
}
Try it!
Before removing them (which is technically easy), I would like to hear some opinions from

WikiProject Books has more than 50 participants and couldn't be pinged. Please post on the WikiProject's talk page instead.. --Epìdosis 13:39, 16 April 2020 (UTC)[reply]

Hi, I agree they should be removed, but first only the ones with a Work id (maybe a bot can find the work from the edition) and if we don't want Reinheitsgebot to add them again, the responsible mix-n-match catalogue should be stop.
I looked if I found it, it seems to be du to auxiliary data from archive.org, but I don't know from which catalog.
catalog 98 is only for human (Q5), and 2184 for version, edition or translation (Q3331189).
Maybe Magnus Manske can find it ? — eru [Talk] [french wiki] 17:39, 16 April 2020 (UTC)[reply]
Hi, I have an observation about this batch edit here.
— Linus (disc) 19:22, 25 May 2020 (UTC)[reply]

Is the book borrowable or free access?

[edit]

To my mind open library books can be classified as not available on open library, borrowable, or freely available. That is an incredibly important thing for me to know from Wikidata without having to go the openlibrary itself. I simply want to get a list of the books I can borrow from Wikidata. Am I correct in saying that is not currently possible with the current schema design? Thankyou. -- Deirge Ó Dhaoinebeaga(a)talk 21:13, 6 September 2022 (UTC)[reply]

It’s currently not possible. I also don’t remember seeing it in the open library dump data. Karl Oblique (talk) 11:06, 15 November 2023 (UTC)[reply]