Property talk:P648

Active discussions


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.
RepresentsOpen Library (Q1201876)
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) or version, edition, or translation (Q3331189)
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)
Formatter URL$1
Robot and gadget jobs$1
Tracking: usageCategory:Pages using Wikidata property P648 (Q51440038)
Related to country  United States of America (Q30) (See 463 others)
See alsoOpen Library subject ID (P3847), Internet Archive ID (P724), ORCID iD (P496), Authorea author ID (P5039), NARCIS researcher ID (P7449), ISNI (P213)
Proposal discussionProposal discussion
Current uses
Main statement253,12793.5% of uses
Qualifier10<0.1% of uses
Reference17,4696.5% 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 this constraint violations: Database reports/Constraint violations/P648#Format, hourly updated report, SPARQL, SPARQL (new)
Distinct values: this property likely contains a value that is different from all other items. (Help)
Exceptions are possible as rare values may exist.
List of this constraint violations: Database reports/Constraint violations/P648#Unique value, SPARQL (every item), SPARQL (by value), SPARQL (new)
Single value: this property generally contains a single value. (Help)
Exceptions are possible as rare values may exist. Known exceptions: Catholic Church (Q9592), Université Laval (Q1067935)
List of this constraint violations: Database reports/Constraint violations/P648#Single value, SPARQL, SPARQL (new)
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.
List of this constraint violations: Database reports/Constraint violations/P648#allowed entity types, SPARQL (new)
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.
List of this constraint violations: Database reports/Constraint violations/P648#scope, SPARQL, SPARQL (new)
  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 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)

  • @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)
@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)

Split this propertyEdit

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 ($1,$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)

  • 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)
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)
  •   Support for having independent properties for works, authors, .... Toni 001 (talk) 12:07, 11 September 2019 (UTC)
  •   Support There should be 3 independent properties. --WolfgangRieger (talk) 12:29, 22 June 2020 (UTC)
  •   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)

Author duplicatesEdit

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)

  • Why do you delete additional identifiers added for the same author? --- Jura 15:05, 23 August 2019 (UTC)
    @Jura1: Because they have been merged, so they are useless redirect. --Epìdosis 16:03, 23 August 2019 (UTC)
    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)
    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)
    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)

Work/edition duplicatesEdit

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, 950 pages have duplicate external links because of wikidata). Please fix it --Bultro (talk) 10:13, 16 April 2020 (UTC)

I think the wrong id is always the one that ends with "M". Their urls redirect to instead of --Bultro (talk) 10:22, 16 April 2020 (UTC)
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].
  MINUS { ?p wdt:P31 wd:Q3331189 . }

Try it!

Before removing them (which is technically easy), I would like to hear some opinions from

Viswaprabha (talk)
Maximilianklein (talk)
Jane023 (talk) 08:21, 30 May 2013 (UTC)
Alexander Doria (talk)
Ruud 23:15, 24 June 2013 (UTC)
Jayanta Nath
Yann (talk)
John Vandenberg (talk) 09:14, 30 November 2013 (UTC)
Danmichaelo (talk) 19:30, 16 February 2014 (UTC)
Ravi (talk)
Mvolz (talk) 08:21, 20 July 2014 (UTC)
Hsarrazin (talk) 07:56, 9 August 2014 (UTC)
PKM (talk) 19:58, 10 October 2014 (UTC)
Revi 16:54, 29 November 2014 (UTC)
Giftzwerg 88 (talk) 23:36, 1 January 2015 (UTC)
Almondega (talk) 00:17, 5 August 2015 (UTC)
Jura to help sort out issues with other projects
Skim (talk) 13:52, 24 June 2016 (UTC)
Marchitelli (talk) 12:29, 5 August 2016 (UTC)
Alexmar983 (talk) 23:53, 28 August 2016 (UTC)
Finn Årup Nielsen (fnielsen) (talk) 10:44, 29 August 2016 (UTC)
Chiara (talk) 14:15, 29 August 2016 (UTC)
Thibaut120094 (talk) 20:31, 14 September 2016 (UTC)
Ivanhercaz | Discusión   15:30, 31 October 2016 (UTC)
YULdigitalpreservation (talk) 17:35, 10 November 2016 (UTC)
PatHadley (talk) 21:51, 15 December 2016 (UTC)
Erica (ohmyerica) (talk) 19:26, 1 January 2017 (UTC)
Mauricio V. Genta (talk) 05:38, 12 March 2017 (UTC)
Sam Wilson 09:24, 24 May 2017 (UTC)
Sic19 (talk) 22:25, 12 July 2017 (UTC)
MartinPoulter (talk) 09:21, 20 July 2017 (UTC)
ThelmadatterThelmadatter (talk) 01:11, 13 September 2017 (UTC)
Zeroth (talk) 15:01, 16 September 2017 (UTC)
Beat Estermann (talk) 20:07, 12 November 2017 (UTC)
Shilonite - specialize in cataloging Jewish & Hebrew books
Elena moz
Oa01 (talk) 10:52, 3 February 2018 (UTC)
Maria zaos (talk) 11:39, 25 March 2018 (UTC)
Wikidelo (talk) 13:07, 15 April 2018 (UTC)
Mfchris84 (talk) 10:08, 27 April 2018 (UTC)
Mlemusrojas (talk) 3:36, 30 April 2018 (UTC)
salgo60 Salgo60 (talk) 12:42, 8 May 2018 (UTC)
Dick Bos (talk) 14:35, 16 May 2018 (UTC)
Marco Chemello (BEIC) (talk) 07:26, 30 May 2018 (UTC)
 徵國單  (討論 🀄) (方孔錢 💴) 14:35, 20 July 2018 (UTC)
Alicia Fagerving (WMSE)
Louize5 (talk) 20:05, 11 September 2018 (UTC)
Viztor (talk) 05:48, 6 November 2018 (UTC)
RaymondYee (talk) 21:12, 29 November 2018 (UTC)
Merrilee (talk) 22:14, 29 November 2018 (UTC)
Kcoyle (talk) 22:17, 29 November 2018 (UTC)
JohnMarkOckerbloom (talk) 22:58, 29 November 2018 (UTC)
Tris T7 TT me
Helmoony (talk) 19:49, 8 December 2018 (UTC)
Shooke (talk) 19:17, 12 January 2019 (UTC)
DarwIn (talk) 14:58, 14 January 2019 (UTC)
I am Davidzdh. 16:08, 18 February 2019 (UTC)
Juandev (talk) 10:03, 27 February 2019 (UTC)
Buccalon (talk) 15:51, 27 March 2019 (UTC)
MJLTalk 16:48, 8 April 2019 (UTC)
Rosiestep (talk) 20:26, 24 April 2019 (UTC)
Dcflyer (talk) 12:23, 7 May 2019 (UTC)
Susanna Giaccai (talk) 05:56, 29 July 2019 (UTC)
Asaf Bartov (talk) 19:03, 31 July 2019 (UTC)
Msuicat (talk) 17:58, 6 August 2019 (UTC)
SilentSpike (talk) 15:27, 12 August 2019 (UTC)
TheFireBender (talk) 12:40, 20 August 2019 (UTC)
Jumtist (talk) 21:45, 22 October 2019 (UTC)
DrLibraryCat (talk) 18:25, 25 November 2019 (UTC)
ShawnMichael100 (talk) 20:04, 25 November 2019 (UTC)
Lmbarrier (talk) 19:47, 2 December 2019 (UTC)
Satpal Dandiwal (talk) 17:32, 16 December 2019 (UTC)
Rosiestep (talk) 17:08, 14 February 2020 (UTC)
Clifford Anderson (talk) 01:37, 1 April 2020 (UTC)
Discostu (talk) 09:02, 9 April 2020 (UTC)
Subodh (talk)
Iwan.Aucamp (talk) 14:02, 27 April 2020 (UTC)
Алексей Скрипник (talk) 15:31, 4 May 2020 (UTC)
MLeonStewart (talk) 18:04, 11 May 2020 (UTC)
ArielBritoJiménez (talk) 16:17, 31 May 2020 (UTC)
DanielleJWiki (talk) 16:16, 8 June 2020 (UTC)
Ninovolador (talk)
Alex (talk) 06:05, 3 August 2020 (UTC)
Alex_Q (talk) 11:11, 18 September 2020 (UTC)
See the bright light (talk)
Alessandra Boccone (talk) 11:18, 6 November 2020 (UTC)
Uomovariabile (talk) 09:54, 13 November 2020 (UTC)
Pru.mitchell (talk) 08:11, 17 November 2020 (UTC)
Carlobia (talk) 13:34, 26 November 2020 (UTC)
Mathieu Kappler (talk) 11:31, 12 December 2020 (UTC)
Pierre Tribhou (talk) 19:19, 28 December 2020 (UTC) Alessandra.Moi (talk) 16:54, 20 February 2021 (UTC) Kind data (talk) 18:09, 23 February 2021 (UTC)
  Notified participants of WikiProject Books. --Epìdosis 13:39, 16 April 2020 (UTC)

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, 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)
Hi, I have an observation about this batch edit here.
— Linus (disc) 19:22, 25 May 2020 (UTC)
Return to "P648" page.