query-c4c7b5ad7353ac16013e850ca034699e
NHL Stats ]reply[16:22, 1 March 2019 (UTC)) talk (Сидик из ПТУ![1]Hello! Look at wrong dates]reply[16:31, 4 March 2019 (UTC)) talk (Сидик из ПТУ for goals and assists must mean exceptionally accurate dates of the first goal and the last goal, etc.(P582)end time and (P580)start time in your way since more accurate dates are difficult to determine in this case. Again, then the (P118)league or competition Yes, you can add start time and end time qualifiers to the ]reply[16:00, 4 March 2019 (UTC)) talk (LesserJerome property with start time and end time qualifiers? (P118)league or competition I see, I think I was misunderstanding you. You mean that it doesn't make sense to have the exact same start and time for every statistical property - it would just be repeating information that is obviously the same. Yes, that's a completely fair point, and one I had thought of too. So if we can make statements for each hockey player about their participation in the NHL, when we say that each statistic was achieved in the NHL, the time is inferred. Do I have that correct? If that's right, we can just use the Сидик из ПТУ ]reply[15:24, 4 March 2019 (UTC)) talk (Сидик из ПТУ. Wikidata is a technical storage of information that is only required to be prepared for presentation in a readable form, we should strive for the most optimal solutions. I don't see a problem in getting "1979" from "October 1, 1979" for any reasons, but I see a problem in overloading the database with duplicate data. I suggest first to find a consensus than to fill. First ever example of using this properties should be ideal.(P1350)number of matches played/races/starts I repeat that your slant will lead to purposeless duplication of information about the periods of the players in the league. These time boundaries can always be verified by ]reply[14:48, 4 March 2019 (UTC)) talk (LesserJerome properties will be totally clear to anyone looking up these stats. If we say "Gretzky scored 894 points between 1979 and 1999," we don't need any more information to understand what is meant. While it would be correct to use hockey seasons, if we could find a way to make it work, this more complex schema is not absolutely necessary right now to convey the information. I would rather have this data up and available in a simpler form than not have it available at all because of technicalities. Also, I have the start and end time data for all these players as years right now, and I do not have the capacity to capture the exact date with month and year that each individual player scored their first and last goals. So I am going to upload this data, but I would be more than happy if someone came along after me to flesh it out with exact dates. (P582)end time and (P580)start time I appreciate your thinking, but I have to disagree. First, I think using a year in the Сидик из ПТУ ]reply[19:33, 1 March 2019 (UTC)) talk (Сидик из ПТУ will be wise to use precisely for what I suggest. (P582)end time and (P580)start time and I don't see any reasons to duplicate these obviously coinciding boundaries in each of the statistical properties. In this case, (P1344)participant in . NHL seasons will be specified by (Q1756146)1999–2000 NHL season of NHL goals, or we somehow specify (Q1342283)Jere Karalahti for (P580)start time Let us first discuss as much as possible the expected results of the fill, and only then it will resume. "1999" willn't make any sense to users of this stats. So either we specify "December 30, 1999" as ]reply[19:00, 1 March 2019 (UTC)) talk (LesserJerome Update: I am rolling back my bulk import of stats and I will upload them again with corrected start dates on Monday. Thanks for catching such an important error! Сидик из ПТУ ]reply[18:40, 1 March 2019 (UTC)) talk (LesserJeromeYou are right, though, that the date 2000 is wrong for the start of this particular player's career. It should be 1999. I looked at a few other players and it appears that the career start date data is consistently one year later. I think I should be able to fix this for all of them - leave it to me and I'll take care of it. Thank you for bringing this to my attention. ]reply[19:43, 1 March 2019 (UTC)) talk (Сидик из ПТУI'm suprised by this my edit. I think it was my blooper. and I'm not sure why. removed the edit, which is partially described as "a total number of matches a player officially appeared in during the whole career." I think this is sufficient, when it is qualified by league, but you (P1350)number of matches played/races/starts I do not think a property for total career games is needed - that is covered Сидик из ПТУ ]reply[17:59, 1 March 2019 (UTC)) talk (Сидик из ПТУ. So then everyone can find out his NHL debut date and understand that "he played for some time after February 10, 2001, but never scored a goal". And for 0 values no dates required. (Q1342283)Jere Karalahti 2000 as begin date for player who first scored at 1999 is weird and not common. I think, property for total career games needed. For example, 134 (December 11, 1999 — April 14, 2002) for ]reply[18:40, 1 March 2019 (UTC)) talk (LesserJerome, the years are given 2000 to 2002 and 2002 to 2002 respectively. So these are the seasons he played in, the span of his career, and that's what I've uploaded. Adding the exact dates of the first and last goals is not what I had intended to represent with the start time and end time qualifiers, only that between the start of his career in the NHL and the end of his career, these are his stats. I think this time frame is more significant, because that's important to know that he played for some time after February 10, 2001, but never scored a goal - there was a significant time of his career where he was trying to score, but never scored. You had mentioned before that a separate property would be useful for "date of most recent value change" - that would be different from "end time." What do you think? Nashville Predators and LA Kings I obtained the years of the career from Hockey-Reference.com's franchise pages. For this player's information on his two teams' pages, Сидик из ПТУ ]reply[15:29, 4 March 2019 (UTC)) talk (Сидик из ПТУ too. (P1344)participant in and (P3598)Hockey-Reference.com player ID Anyway, it would be nice to fill ]reply[18:37, 4 March 2019 (UTC)) talk (Сидик из ПТУ. Although this property is so ambiguous that at least every match can be added there… I hope in the future will be taken restrictive measures, but the seasons look great use. (Q211872)Stanley Cup statements, I propose one statement for every NHL season and another one for every (P1344)participant in . As for It was added by me ]reply[17:08, 4 March 2019 (UTC)) talk (LesserJerome statements, do you propose one statement for every NHL season a player played in? (P1344)participant in does have a Hockey-ReferenceID on his page: k/karalje01. As for (Q1342283)Jere Karalahti statements, they were already uploaded. (P3598)Hockey-Reference.com player ID I didn't add the Сидик из ПТУ ]reply[16:31, 4 March 2019 (UTC)) talk (Сидик из ПТУ. both properties. Better to fill (Q680030)1998–99 NHL season or (Q1756146)1999–2000 NHL season after your edits. I think "1999" is more ambiguous than (Q1342283)Jere Karalahti at (P3598)Hockey-Reference.com player ID There was no ]reply[16:00, 4 March 2019 (UTC)) talk (LesserJerome for individual hockey seasons, but it could be more succinct to simply say that a player played in a league from this year to this year. (P1344)participant in ? I know you were thinking (P1344)participant in could be a better choice than (P118)league or competition is complete for NHL players. Do you think (P3598)Hockey-Reference.com player ID As far as I can tell, ]reply[15:42, 4 March 2019 (UTC)) talk (Сидик из ПТУ, which depends only on the known player id.this query), then I think it will not be difficult for you to get the first and last dates of the goals using (Q5289).NET Framework And how do you build your query? If you do it with the use of software code (for example, on the ]reply[19:47, 5 March 2019 (UTC)) talk (Сидик из ПТУYou should send me just "Hello!" or somethinh like this and ater my reply we will be able to use our standard mail systems bypassing Wikimedia. ]reply[19:30, 5 March 2019 (UTC)) talk (LesserJerome and I wouldn't be able to send you a file that way, unless I'm mistaken? Wikimedia mail system I looked into using the Сидик из ПТУ ]reply[18:37, 4 March 2019 (UTC)) talk (Сидик из ПТУYou can use mail system. ]reply[17:08, 4 March 2019 (UTC)) talk (LesserJeromeThat sounds great - I can definitely do this for you. What's the best way for me to send you a file? ]reply[16:31, 4 March 2019 (UTC)) talk (Сидик из ПТУ (for example, in the .txt format), and I will try to write a simple little program that returns this ids with the date of the first and last goals. I expect to cope in a day.(Q28649144)Hockey-Reference.com Let's try to do the following: you will send me a list of ids from ]reply[16:00, 4 March 2019 (UTC)) talk (LesserJeromeI haven't been doing anything too advanced - mostly just copying data from tables available online and manipulating it in spreadsheets and OpenRefine. I'd love to learn how to scrape the web properly though. ]reply[19:19, 13 March 2019 (UTC)) talk (Сидик из ПТУ. Wikidata:Property proposal/date of the latest value change ]reply[22:04, 18 March 2019 (UTC)) talk (Сидик из ПТУ. (Q742594)Evgeny Shaldybin for players with only one goal like (P585)point in time Hello! I think it would be wiser to use ]reply[17:09, 20 March 2019 (UTC)) talk (Сидик из ПТУ, but we can all the same sort all players by their first goals. (P585)point in time 's goal has specified with (Q4692209)Aggie Kukulowicz ]reply[16:28, 20 March 2019 (UTC)) talk (LesserJeromeCan you explain this to me please? ]reply[15:46, 20 March 2019 (UTC)) talk (Сидик из ПТУ. here (Q4692209)Aggie Kukulowicz Look to ]reply[13:37, 20 March 2019 (UTC)) talk (LesserJerome qualifier? Is the ontology able to handle that? If so, do you have any ideas for how to fix this? (P585)point in time Hmm, I guess that makes sense. My one concern is consistency with other statements using this property. If I was to query Wikidata for this property and used the start time and end time qualifiers to do so, would that pick up statements using only a ]reply[22:07, 18 March 2019 (UTC)) talk (Сидик из ПТУ has 0 assists in NHL too. (Q34086)Justin Bieber Another idea is not to specify a property for the value 0. Can you please explain what you mean by "they are counted when querying"? I don't think I understand. If not found means it is zero, then that includes Justin Bieber, as you said before. Also, if a player did not score any goals, simply not including a statement for goals just looks like someone forgot to include information. I think it most straightforward to use zeros, then you can search for players who have "0" goals and not simply players who do not have property statements for goals at all: ]reply[15:54, 20 March 2019 (UTC)) talk (Сидик из ПТУ option.value unknownAnd as far as I understand, usually they do not store amounts in databases - they are counted when querying, so there is no point in storing zeros. Not found - it means there is zero. But do not forget about ]reply[14:01, 20 March 2019 (UTC)) talk (Сидик из ПТУIt is even better for the database if players with zero goals are not selected at all due to the lack of a corresponding property. Otherwise, to get a list of all NHL goalscorers, you will need to specify the query "where the property is exist and it is not zero". ]reply[13:37, 20 March 2019 (UTC)) talk (LesserJerome. Plus, looking at the dataset as a whole, it is meaningful to see that a number of players have zeros in some categories as compared to those that have positive integers. standard presentation of stats qualifier for any of his statements. Put another way, we can't always worry about defining every single negative statement: on Justin Bieber's page, we wouldn't list everything he hasn't done or everything that he isn't, that would be absurd. On the other hand, it is meaningful that an NHL player actually played in the NHL, had an opportunity to record a statistic, and failed to do so. Including a zero where a player hasn't recorded a goal or assist is common practice, and you'd expect to see it in any (Q1215892)National Hockey League (P642)of I appreciate your argument, and I mean no disrespect, but I think it's slightly nonsensical. Of course Justin Bieber has no assists in the NHL. He never played in the NHL. You could not legitimately use an Сидик из ПТУ
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?player ?playerLabel ?goals
WHERE
{
?player wdt:P6509 ?goals.
?player wdt:P118 wd:Q1215892.
FILTER (?goals = 0) .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}