Property talk:P648

Documentation

Open Library ID
identifier for a work ("W"), edition ("M") or author ("A") for book data of the Internet Archive

Description

Identifier assigned by Open Library (Q1201876) for works, editions and authors.

Associated item

Open Library (Q1201876), Open Library (Q1201876)

Applicable "stated in" value

Open Library (Q1201876)

Data type

External identifier

Domain

human (Q5), creative work (Q17537576), work (Q386724), organization (Q43229), pseudonym (Q61002), version, edition or translation (Q3331189) or literary work (Q7725634)

Allowed values

OL[1-9]\d*[AMW]

Example

Twenty Years After (Q1639633) → OL36858W (RDF)
Anton Chekhov (Q5685) → OL3156833A (RDF)
Libraries in the Medieval and Renaissance Periods (Q45341759) → OL6917238M (RDF)

Source

https://openlibrary.org/

Formatter URL

https://openlibrary.org/works/$1?mode=all
https://openlibrary.org/work/$1.json
https://openlibrary.org/work/$1.rdf

Robot and gadget jobs

https://openlibrary.org/books/$1

Tracking: usage

Category:Pages using Wikidata property P648 (Q51440038)

Related to country

United States of America (Q30) (See 770 others)

See also

Open 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 discussion

Current uses

Total	441,701
Main statement	405,174	91.7% of uses
Qualifier	11	<0.1% of uses
Reference	36,516	8.3% 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

Type “human (Q5), creative work (Q17537576), work (Q386724), organization (Q43229), pseudonym (Q61002), version, edition or translation (Q3331189), literary work (Q7725634)”: item must contain property “instance of (P31)” with classes “human (Q5), creative work (Q17537576), work (Q386724), organization (Q43229), pseudonym (Q61002), version, edition or translation (Q3331189), literary work (Q7725634)” or their subclasses (defined using subclass of (P279)). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Prime Minister of the United Kingdom (Q14211), Olney (Q2454052), St. Mary's City (Q2321360)
List of violations of this constraint: Database reports/Constraint violations/P648#Type Q5, Q17537576, Q386724, Q43229, Q61002, Q3331189, Q7725634, 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

This property is being used by:

Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

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!

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

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]

Support for having independent properties for works, authors, .... Toni 001 (talk) 12:07, 11 September 2019 (UTC)[reply]
Support There should be 3 independent properties. --WolfgangRieger (talk) 12:29, 22 June 2020 (UTC)[reply]
Weak support the present way technically works, but having three independent properties would be clearer. I would propose continuing the use of this property for authors and creating two new properties for works and editions, transferring to them the pertinent values. --Epìdosis 12:34, 22 June 2020 (UTC)[reply]

Author duplicates

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

Most urgent duplicates (= [4]) -> 4+ duplicates
Simple duplicates (= [5]) -> 2+ duplicates

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

Why do you delete additional identifiers added for the same author? --- Jura 15:05, 23 August 2019 (UTC)[reply]
@Jura1: Because they have been merged, so they are useless redirect. --Epìdosis 16:03, 23 August 2019 (UTC)[reply]
I don't really see the point. If someone added them before, they probably thought them to be useful. --- Jura 17:02, 23 August 2019 (UTC)[reply]
In about two thirds of the cases I added them by myself. I thought they were useful until they were merged - I added them in order to make evident that they were to be merged. After the merge, they are useless redirect, just as redirects on Wikidata. --Epìdosis 20:12, 23 August 2019 (UTC)[reply]
I don't think redirecting items on Wikidata are useless. I think you could also merely set them to deprecated rank and try to find a bot to do these updates. --- Jura 12:14, 24 August 2019 (UTC)[reply]

Work/edition duplicates

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?

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]