Property talk:P6878

Documentation

• Start a query
• Current uses
• Statistics by class
• String length
• List of qualifiers
• Count

Erik Amburger database ID
identifier for the Erik Amburger database of foreigners in pre-revolutionary Russia

Applicable "stated in" value	Erik Amburger database (Q64584900)
Data type	External identifier
Domain	human (Q5)
Allowed values	[1-9][0-9]{0,4}
Example	Gustaf Otto Douglas (Q2661624) → 3304 Nicolaus Bernhard Nottbeck (Q64522945) → 73820 Iwan Karlowitsch Tscherlizki (Q29352183) → 55447
Formatter URL	https://amburger.ios-regensburg.de/?id=$1
Related to country	Germany (Q183) (See 347 others)
Lists	Items with the most statements of this property Count of items by number of statements (chart) Items with the most statements Items with the fewest statements Count of items by number of sitelinks (chart) Items with the most sitelinks Items with the most sitelinks, but no link to one Wikipedia (sample: Welsh Wikipedia, cywiki) Items with the fewest sitelinks Most linked wikis Items with the most identifier properties Items with no other external identifier Items with no other statements Most recently created items Items with novalue claims Items with unknown value claims Usage history (total) Usage history (main statement) Chart by item creation date Map of people by place values: place of birth educated at work location residence place of death place of burial January 1st dates People with date of birth on January 1 People with date of death on January 1 People with both dates on January 1 Mix'n'match (Report) Database reports/Constraint violations/P6878 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 5,031 Main statement 4,277 out of 95,409 (4% complete) 85% of uses Qualifier 3 <0.1% of uses Reference 751 14.9% of uses
Search for values

[create Create a translatable help page (preferably in English) for this property to be included here]

Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)

List of violations of this constraint: Database reports/Constraint violations/P6878#Entity types, hourly updated report

Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)

List of violations of this constraint: Database reports/Constraint violations/P6878#Scope, hourly updated report, SPARQL

Format “[1-9][0-9]{0,4}”: value must be formatted using this pattern (PCRE syntax). (Help)

List of violations of this constraint: Database reports/Constraint violations/P6878#Format, hourly updated report, SPARQL

Item “instance of (P31)”: Items with this property should also have “instance of (P31)”. (Help)

List of violations of this constraint: Database reports/Constraint violations/P6878#Item P31, hourly updated report, search, SPARQL

Type “human (Q5)”: item must contain property “instance of (P31)” with classes “human (Q5)” or their subclasses (defined using subclass of (P279)). (Help)

List of violations of this constraint: Database reports/Constraint violations/P6878#Type Q5, hourly updated report, SPARQL

Item “sex or gender (P21)”: Items with this property should also have “sex or gender (P21)”. (Help)

List of violations of this constraint: Database reports/Constraint violations/P6878#Item P21, hourly updated report, search, SPARQL

Distinct values: this property likely contains a value that is different from all other items. (Help)

List of violations of this constraint: Database reports/Constraint violations/P6878#Unique value, hourly updated report, SPARQL (every item), SPARQL (by value)

Duplicates and OIDs

• Taken from the proposal discussion:

  Abegg, August

  1. https://amburger.ios-regensburg.de/?id=3992 / OID 4188
  2. https://amburger.ios-regensburg.de/?id=57140 / OID 57903

  Abegg, Karl

  1. https://amburger.ios-regensburg.de/?id=6965 / OID 7181
  2. https://amburger.ios-regensburg.de/?id=93286 / OID 94817

  Abel, Johann Gottfried

  1. https://amburger.ios-regensburg.de/?id=3662
  2. https://amburger.ios-regensburg.de/?id=93822

  Abel, Nikolaj Ivanovič

  1. https://amburger.ios-regensburg.de/?id=3993
  2. https://amburger.ios-regensburg.de/?id=57141

  77.11.40.170 19:01, 21 June 2019 (UTC)

Search by OID at https://amburger.ios-regensburg.de/index.php?mode=0 77.183.47.197 11:15, 22 June 2019 (UTC)

MnM error list

Wrong IDs in WD by bot

1. "Georg von Bradke (Q15064673)" != Brasche, Adolf Wilhelm Nikolai https://www.wikidata.org/w/index.php?title=Q15064673&diff=966356191&oldid=962272790

   that was the first record that I checked and it was wrong. I checked two others created by the same bot, they were wrong too. 77.11.40.170 19:04, 21 June 2019 (UTC)

2. "Edvin Wirén (Q11856636)" to not found [1] https://www.wikidata.org/w/index.php?title=Q11856636&diff=966406704&oldid=966402082

77.11.40.170 19:51, 21 June 2019 (UTC)

1. The records I checked were wrong, because the Bot always took the oid Nr. (=old ID) and not the actual ID No. in the top line of the data sheet...Kresspahl (talk) 07:06, 22 June 2019 (UTC)

   Kresspahl, thanks! I thought that could be the reason (that's why I added the section "Duplicates and OIDs" from the proposal), but found no easy way to find the correct record. I informed Magnus Manske Topic:V22dbeonn6wg6n5p. 77.183.47.197 10:34, 22 June 2019 (UTC)

Wrong IDs in MnM auto

https://tools.wmflabs.org/mix-n-match/#/list/2636/auto - I check the first 10, all wrong. 77.183.47.197 11:21, 22 June 2019 (UTC)

For MnM, I am using the IDs from the Namensliste. Is that the wrong one? Where can I find the correct one? --Magnus Manske (talk) 13:46, 22 June 2019 (UTC)

There are two numbers in that Namensliste, first the ID, second the OID. The bot took the second one, the O[ld]ID, which is wrong. It should have taken the first one.--Kresspahl (talk) 15:00, 22 June 2019 (UTC)

I have fixed that in mix'n'match. Since I don't know how many wrong ones were imported, I am removing all matches from Wikidata as well; most of them will have been fro MnM. --Magnus Manske (talk) 22:33, 22 June 2019 (UTC)

Removal batch --Magnus Manske (talk) 22:36, 22 June 2019 (UTC)

I have also restarted matching for MnM. All new matches should be on the proper IDs. --Magnus Manske (talk) 22:43, 22 June 2019 (UTC)

Description

"identifier for the Erik Amburger database of foreigners in pre-revolutionary Russia" - not true, this is not an identifier for the database. The items covered are identifiers for records in the database. 77.11.40.170 18:35, 21 June 2019 (UTC)

More than two years - wrong values inserted by Magnus Manske

@Magnus Manske: https://www.wikidata.org/w/index.php?title=Q4151322&action=history - how about fixing each false value inserted by your bot? ErrorRepair20210719T1906 (talk) 15:29, 20 July 2021 (UTC)

 Done @Magnus: Die Anfrage kannst du ignorieren. Es ist eine der zahllosen BBLD-Socken, s. de:Benutzer Diskussion:WahrheitFuerAlle. --Kolja21 (talk) 23:20, 20 July 2021 (UTC)