[15:25:55] 17,9 million edits with a few hours to go http://wikidata.wikiscan.org/date/201803/stats [15:28:39] hey sjoerddebruin, that's a lot of edits! I just scheduled the import of about 13.000 paintings so I'll be adding some too ;-) [15:31:42] Maybe you should do 300 edits per minute ;) [15:54:57] No rush here [16:26:04] hi. i'm trying to learn about wikidata. [16:26:31] i see a song (say, "africa"): https://www.wikidata.org/wiki/Q383842 [16:26:53] and in the wikipedia page it is on several charts (like the "billboard 100"): https://en.wikipedia.org/wiki/Africa_(Toto_song) [16:26:53] Songs are still a mess due to Wikipedia combining singles and actual songs [16:27:01] But go on :) [16:27:06] i also see the "billboard 100" chart: https://www.wikidata.org/wiki/Q180072 [16:27:22] but i see no relationship between that song and that chart, even though it's on the wikipedia page [16:27:34] Because nobody added it so far :) [16:27:44] how would one add such a thing? [16:27:54] edit the wikidata page? [16:27:59] and add what relationship? [16:28:13] I don't see any item where it has been done right :| [16:28:21] if i knew one, maybe i could write a bot (or something to parse the wikipedia dump) that could add them all [16:28:48] i can't even figure out how to query "Africa" from wikidata at all right now [16:29:30] i "wrote" this wikidata query to find songs, and even that doesn't work: https://query.wikidata.org/#SELECT%20%3Fsong%20%3FsongLabel%20%3Fcode%20%3Fperformer%20%3FperformerLabel%20%3FBillboard_artist_ID%20%3Ftitle%20WHERE%20%7B%0A%20%20%3Fsong%20wdt%3AP435%20%3Fcode.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP4208%20%3FBillboard_artist_ID [16:30:15] it shows some examples with "bruce springsteen" even though i'm pretty sure he didn't write "o holy night" or "E.T." [16:30:29] so i have no idea what i'm doing [16:32:13] Can you give the short URL of the query? It seems incomplete [16:33:31] http://tinyurl.com/y7t4o6mr [16:33:50] ah, you are right, it was incomplete: https://query.wikidata.org/#SELECT%20%3Fsong%20%3FsongLabel%20%3Fcode%20%3Fperformer%20%3FperformerLabel%20%3FBillboard_artist_ID%20%3Ftitle%20WHERE%20%7B%0A%20%20%3Fsong%20wdt%3AP435%20%3Fcode.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP4208%20%3FBillboard_artist_ID.%20%7D%0A%20%20OPTIONAL%20%7B%20%3 [16:34:29] Your query seems weird due to including one identifier for works and one for people. [16:34:34] my end goal (if that were possible) would be to have publicly available easy access to the billboard top 100 chart for every year, with every song along with metadata (group, year, length, ..) [16:34:44] as i said, i have no idea what i'm doing [16:34:52] it's not obvious to me how to work the query interface [16:35:01] I'm not some master in queries as well :( [16:35:02] i'm just trying stuff [16:35:35] right now, the closest i can imagine is to skip wikidata and write a wikipedia bot to scrape. that seems weird, tho. [16:35:46] it feels like editing wikidata somehow would be better [16:42:54] okay, i tried editing the wikidata page to add "part of" "billboard top 100": https://www.wikidata.org/wiki/Q383842 [16:43:14] it doesn't really have enough info (say, number of weeks, which weeks, ..) but at least it's something [16:43:27] https://www.wikidata.org/wiki/Property:P2291 seems better for it [17:58:13] good call on "charted in"! [17:58:18] i'll try it [18:00:32] used "charted in" [18:02:21] for https://www.wikidata.org/wiki/Q383842