Welcome to Wikidata, Steak!

Wikidata is a free knowledge base that you can edit! It can be read and edited by humans and machines alike, and you can help. Go to any item page now and add to this ever-growing database!
Need some help getting started? Here are some pages you can familarise yourself with:

If you have any questions, please ask me on my talk page. If you want to try out editing, you can use the sandbox to try. Once again, welcome, and I hope you quickly feel comfortable here, and become an active editor for Wikidata.

Regards, --Jitrixis (talk | support my candidacy) 13:27, 1 November 2012 (UTC)


Hi, Steak! I finally got back to EloBot, I rewrote it so it doesnt claim to wikidata straight but instead outputs a file that can be submitted through QuickStatements.

It simplifies things greatly, gives space for checking/fixing before writing to wikidata and can be easily run by someone else (you :-) ) when I am not available for the update. I did not test it yet, but will get to it soon. You can check the code here. Wesalius (talk) 08:47, 28 July 2018 (UTC)

Ok, thanks, I will have a look at it when I have some time. Steak (talk) 09:53, 28 July 2018 (UTC)
I prepared files for quickstatements starting at Feb18, ending at Jul18. I would appreciate help with checking that they contain correct information. I think they are selfexplanatory, but if you need help understanding them, please contact me. Thank you. Wesalius (talk) 21:19, 29 July 2018 (UTC)
Ok. First thing I noticed is that you use the full URL of the fide homepage instead of the item (Q27038151). I would recommend to use the item, what do you think? Steak (talk) 07:43, 30 July 2018 (UTC)
That I tried, but QS gave me an error stating "string expected". Maybe I should use P248 instead of P854 as a qualifier? Wesalius (talk) 08:53, 30 July 2018 (UTC)
Yes, this is the way it is already done. How difficult is it actually to create these csv-files? Steak (talk) 09:00, 30 July 2018 (UTC)
Ok, I fixed the CSVs, have a look. When I ran a test edit I found out that User:EdgarsBot took over and added elo ratings up until 6/2018. I need to find out who is going to work on it so we dont divide our force. Creating those csv-files is rather easy and fast, have a look at the github repo. Wesalius (talk) 16:11, 30 July 2018 (UTC)
Ok, I was already wondering why you want to import the ratings from this year again. Maybe you should contact the owner of EdgarsBot and agree on who does what. Steak (talk) 18:00, 30 July 2018 (UTC)
@Wesalius: I don't think that Quickstatements can be used to import the Elo ratings. Or do you have a solution for this problem? Steak (talk) 07:51, 3 August 2018 (UTC)
I ran into that as well and I dont have a solution yet. I think our best bet is to contact Magnus as Matěj Suchánek wrote. Wesalius (talk) 11:56, 3 August 2018 (UTC)
I have already done it, but Magnus reaction is not so promising. Steak (talk) 11:57, 3 August 2018 (UTC)
Metoo... What was the reaction? Wesalius (talk) 12:15, 3 August 2018 (UTC)
See here, he says its not so easy. Steak (talk) 12:18, 3 August 2018 (UTC)

It seems that openrefine should work, thanks for the ping at project chat. I managed to reconcile qid values but now I am stuck at creating a schema. If you figure out how the other column's values should be formatted I can easily adapt my script to produce different output, this one was adapted for QS. Wesalius (talk) 14:13, 5 August 2018 (UTC)

Good to hear. Currently I am using PAWS, so it could take a while till I look more deep into OpenRefine. Steak (talk) 18:14, 5 August 2018 (UTC)
@Wesalius: I played a bit with OpenRefine. It always wanted to have a unit of the Elo rating, I did not manage to generate a scheme without a unit. Did you? Steak (talk) 17:52, 7 August 2018 (UTC)

Hi, guys (ping for Wesalius). Well, for me it's not a problem to run the updates. The biggest problem for me is that I have to remember to do that, but that problem can be easily overcome with some reminders. My script does everything in one edit, so it's also a pro, I think :) --Edgars2007 (talk) 06:24, 8 August 2018 (UTC)

Yes this is fine. I am anyways currently not working on importing the most recent Elo ratings, I am just filling up a few missing ratings between 2001 and 2017 and importing those before 2001. Steak (talk) 07:26, 8 August 2018 (UTC)
Is your code for import available somewhere? That is kind of essential, because if you are unavailable, someone should be able to take over from there. Wesalius (talk) 15:45, 9 August 2018 (UTC)
Well, the code for the import is available here, but not written by myself, but thankfully by User:MisterSynergy. With this code I will only import all the missing ratings from 1970 to 2016, the newer ones are imported by Edgars2007, whose code is better because it only needs one edit per item. So I don't think that I am a key person here ;). Steak (talk) 16:59, 9 August 2018 (UTC)

FIDE Sept 2018Edit

I think you already know that I don't know much about chess :D But why there is already September? Is it ok to import it? --Edgars2007 (talk) 13:47, 2 September 2018 (UTC)

Yes, of course. The Elo ratings are always published at the first day of each month. So the ratings for September were published yesterday. As far as I see, August and September ratings are missing in Wikidata, and actually also some older ratings since 2017. Maybe you could also complete those? Steak (talk) 14:25, 2 September 2018 (UTC)
But for other months it's the last day of respective month, that's why I was asking. Currently importing August and September. --Edgars2007 (talk) 14:31, 2 September 2018 (UTC)
Can you given an example? The publication date (= date when the ratings come into effect) is always the first of every month. Steak (talk) 14:32, 2 September 2018 (UTC)
"Aug 2018: Standard rating: TXT (31 Aug 2018, Sz: 7.00 MB) | XML (31 Aug 2018, Sz: 7.49 MB)". --Edgars2007 (talk) 14:35, 2 September 2018 (UTC)
I don't know what that date refers to, maybe they changed it at this date for some reason. The inital publication is always the first, see e.g. here or here. Steak (talk) 14:39, 2 September 2018 (UTC)

Request a queryEdit

You had an interesting query regarding the all-time Elo highscore list, but you removed it again. Solved meanwhile? Otherwise I have a suggestion, and maybe others are interested as well. —MisterSynergy (talk) 22:03, 5 September 2018 (UTC)

Yes I think I could fix it. There is just the minor problem left that, while Listeria Bot generates a list without duplicates, running the query gives duplicate results. But since I am only interested in the Listeria list, I consider this as neglible. Steak (talk) 17:02, 6 September 2018 (UTC)
Okay, thanks, looks good indeed. Otherwise try this one for a clean solution using the Query Service only. There are some subtle differences compared to the dewiki list, since two players are missing in Wikidata and some player’s information is outdated either in dewiki or Wikidata (checked this night, maybe you have already fixed it). Viele Grüße! —MisterSynergy (talk) 17:42, 6 September 2018 (UTC)
Thanks. It seems the query has notable time lag. E.g. Ian Nepomniachtchi (Q521817) has highest Elo 2768, this was added 3rd September. However, the query still gives 2767 as highest rating. Steak (talk) 09:26, 7 September 2018 (UTC)

Matilda of Guelders (Q2031173)Edit

Dear Steak, I noticed you changed the date of death of Matilda of Guelders (Q2031173). The problem I have with this change is that it is incorrect. It now states that she died on 28 October 1247. But the full date of her death is unknown. The only source for her death is the necrology of the Abbey of Arnstein (see [1]) which records the date of death 28 October, but doesn't mention a year. As Matilda is mentioned in a charter dated 1247, she either died in 1247 or after. It is unknown in which year she died. The correct way to write her date of death would be "28 October 1247 or after". But that doesn't fit in the system used for dates on Wikidata. I don't know how to work around that, perhaps you do. Regards, --HRvO (talk) 20:57, 30 September 2018 (UTC)

No I don't know either, I just noticed that there is a discrepancy to the articles. But you are right, currently it's misleading. I reverted my edit. Steak (talk) 06:57, 1 October 2018 (UTC)

Voronkov IMC ?Edit

Hello, Boris Voronkov was an international ICCF master in 1976 according to the page in russian ru:Воронков, Борис Григорьевич. The article gives the source : the soviet Chess encyclopedic dictionary (1990).--Cbigorgne (talk) 19:41, 3 December 2018 (UTC)

Thanks. Steak (talk) 22:12, 3 December 2018 (UTC)

Starr and Company (Q19798765)Edit

I don't know what to do: this is a serial which has 77 episodes. How do I work it? I was think similar to locations in cities, viz. Q61878 barangay below (P150) municipality Q24764

Each serial has different actors. There two different episodes each week (Monday and Thursday) 03:43, 13 June 2019 (UTC)

I added number of episodes (P1113), is this ok for you? Steak (talk) 14:51, 16 June 2019 (UTC)

Community Insights SurveyEdit

RMaung (WMF) 17:38, 10 September 2019 (UTC)

Reminder: Community Insights SurveyEdit

RMaung (WMF) 19:54, 20 September 2019 (UTC)


Good morning! I've seen that you added some DFB IDs. Be aware please that there are different IDs for de and en links, see Property talk:P4023#different ID for en/de for examples. In Wikidata the links with single a/o/u instead of Umlaut have to be taken; but de.wikipedia needs Umlaut-links. can handle this difference. --Hadibe (talk) 10:39, 14 November 2019 (UTC)

MediaWiki talk:Wikibase-SortedProperties/Archive 1#Properties for chessgame databasesEdit

MediaWiki talk:Wikibase-SortedProperties/Archive 1#Properties for chessgame databases

There is a section MediaWiki:Wikibase-SortedProperties#IDs with type "external-id", weird, they did not add your proposal. Maybe try again. 08:53, 25 February 2020 (UTC)


ist 2006 gestorben. Was soll der Quatsch mit Elo-Zahlen aus dem Jahre 2018? --Gereon K. (talk) 08:43, 23 April 2020 (UTC)

Tach! Wurde alles schon vor längerer Zeit ausführlich geklärt, siehe Property_talk:P1087#Rudolf_Teschner_:_ratings_after_death. Steak (talk) 08:44, 23 April 2020 (UTC)

Re Elo ratingsEdit

Ah, OK. Sorry for the rollback and keep it up :).--Gorpik (talk) 09:52, 23 April 2020 (UTC)

Request for Merge: Aslan Aitbayev Q99299793 and Q27522870Edit

Dear Steak,

could you please support me? I created new article in Russian Wiki, and also new Wikidata for that. After creating I noted, that already exist wikidata for this chess player. How can I merge boths wikidata? Thank you in advance! Oscuro (talk) 10:22, 14 September 2020 (UTC)

Hi! Why are you asking me? I have merged the two items. Steak (talk) 10:59, 14 September 2020 (UTC)
Hello Steak! Many thanks for prompt support! Now I know how Merge is working. Why are you asking me? - I noted that you have a lot of experience with wikidata, so I asked you for the help. In ruwiki users usually do such things. Have a nice start of the week! Oscuro (talk) 20:11, 14 September 2020 (UTC)

We sent you an e-mailEdit

Hello Steak,

Really sorry for the inconvenience. This is a gentle note to request that you check your email. We sent you a message titled "The Community Insights survey is coming!". If you have questions, email

You can see my explanation here.

MediaWiki message delivery (talk) 18:45, 25 September 2020 (UTC)

Suggestion for Reference for CitizenshipEdit

In the case of Lehi F. Hintze (Q65974700) and others, presume you are determining country of citizenship (P27) is United States of America (Q30), based on their place of birth. I'm not disputing that logic, in fact, it's obviously legit. If that's your logic, I'd like to suggest that you also reference (in future similar determinations) with based on heuristic (P887) inferred from place of birth (Q91770864). Thanks for the contributions. Trilotat (talk) 13:41, 6 November 2020 (UTC)

Hi Trilotat, yes you are right, I was inferring it from place of birth, and your suggestion is good. However, there are so many items that still miss the US citizenship, I stopped my quickstatements task because I think this would be a better task for a bot. Steak (talk) 13:59, 6 November 2020 (UTC)
Agreed; good task for a bot. I’ll be sure to include citizenship in any future human items that I create. Trilotat (talk) 08:29, 7 November 2020 (UTC)


Just a bit concerned your query seemed not to fit your spec. Try

SELECT DISTINCT ?item ?itemLabel
    ?item wdt:P106 wd:Q10873124 .
    ?item wdt:P21 wd:Q6581097 .
    ?item wdt:P1344/wdt:P31 wd:Q428303 . hint:Prior hint:gearing "forward".
    filter not exists {?item wdt:P3940 [].}
	SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en" } .
Try it! --Tagishsimon (talk) 19:51, 11 November 2020 (UTC)
Thanks, I know that the query I posted in the query request page was quite off target. Meanwhile I also managed to get the result with this query:
SELECT DISTINCT ?item ?itemLabel
    ?olymp wdt:P31 wd:Q428303 .
	?item wdt:P106 wd:Q10873124 .
    ?item wdt:P21 wd:Q6581097 .
    ?item wdt:P1344 ?olymp .
  MINUS{?item wdt:P3940 ?austragung .}
	SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en" } .
Try it!

-- Steak (talk) 20:48, 11 November 2020 (UTC)

Netflix ID (P1874)Edit

Why are you deleting multiple statements with this property? Please stop. Andreasm háblame / just talk to me 17:27, 9 January 2021 (UTC)

Hi, I noticed that those identifiers lead to a 404 error page. Steak (talk) 17:30, 9 January 2021 (UTC)
I have checked several of them and they work in my country, so I restore them. Netflix restrict some titles per regions, best to change the statement to obsolete, not to delete them. Andreasm háblame / just talk to me 17:39, 9 January 2021 (UTC)
Okay, thanks for rechecking! Steak (talk) 17:48, 9 January 2021 (UTC)