Thanks Lucas! (nice concat!) Thad https://www.linkedin.com/in/thadguidry/ https://calendly.com/thadguidry/
On Fri, May 7, 2021 at 11:02 AM Lucas Werkmeister <[email protected]> wrote: > If you don’t limit this to dates with a precision greater than “year”, > then it actually works without timeout on the query service, but > unsurprisingly the most common month <https://w.wiki/3Hzy> and day > <https://w.wiki/3Hz$>, by far, are 1 (or January). > > If you do limit it to such dates, the results get a bit more surprising > (to me), in that the query still doesn’t time out; that said, the most > common month <https://w.wiki/3H$4> remains January and the most common day > <https://w.wiki/3H$5> is still the first of the month. > > And taken in combination <https://w.wiki/3H$A>, January 1st is the most > common date, but April 1st and September 1st are not far off. > > Cheers, > Lucas > On 07.05.21 17:38, Thad Guidry wrote: > > Hi Community! > > Rather than me grabbing the dump and processing it to answer the subject > question. > I'm wondering if anyone else could quickly answer this for me. > I couldn't get anything useful from the Property talk: P571 > <https://www.wikidata.org/wiki/Property_talk:P571> > > - Start a query > > <https://query.wikidata.org/#PREFIX%20wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0APREFIX%20wikibase%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%0APREFIX%20p%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2F%3E%0APREFIX%20ps%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fstatement%2F%3E%0APREFIX%20pq%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fqualifier%2F%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0A%23Sample%20query%20to%20start%20a%20list%20of%20values%20for%20property%20P571%0A%23Remove%20some%20of%20the%20%22%23%22%20below%20to%20see%20if%20it%20helps%20you%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fvalue%20%3FvalueLabel%0A%23sample%20variables%20defined%20below%20%28but%20commented%20out%29%0A%3Fdob%20%3Fdod%20%3Fcountry%0AWHERE%0A%7B%0A%20%20%3Fitem%20wdt%3AP571%20%3Fvalue%20.%0A%23%20%20%3Fitem%20wdt%3AP569%20%3Fdob%20.%0A%23%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP570%20%3Fdod%20%7D%20.%0A%23%20%20%3Fitem%20wdt%3AP17%20%3Fcountry%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Cen%22%20%20%7D%0A%7D%0ALIMIT%2010> > - Current uses > > <https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3Fvalue%0A%7B%0A%20%20%3Fitem%20wdt%3AP571%20%3Fvalue%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Cen%22%20%20%7D%0A%7D%0ALIMIT%201000> > - <with precision and calendarmodel> > > <https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3Fvalue%20%3Fprecision%20%3FtpLabel%20%3Fmodel%20%3FmodelLabel%0A%7B%0A%20%20%20%20%7B%20%20SELECT%20%2a%0A%20%20%20%20%20%20%20WHERE%0A%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%3Fitem%20p%3AP571%2Fpsv%3AP571%20%5B%20wikibase%3AtimeValue%20%3Fvalue%20%3B%20wikibase%3AtimePrecision%20%3Fprecision%20%3B%20wikibase%3AtimeCalendarModel%20%3Fmodel%20%5D%0A%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%20LIMIT%20200%0A%20%20%20%20%7D%0A%0A%20%20%20%20%23%20for%20labels%0A%20%20%20%20%3Ftp%20wdt%3AP2803%20%3Fpr%20.%20FILTER%28%20str%28%3Fpr%29%20%3D%20str%28%3Fprecision%29%20%29%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D> > - Statistics by class > > <https://query.wikidata.org/#%23top%2050%20for%20P31%20and%20P279%20of%20items%20using%20P571%0ASELECT%20%3Fclass%20%3FclassLabel%20%3Fcount%20%3Fuse_as_Label%0A%7B%20%20%7B%20%20SELECT%20%3Fclass%20%28COUNT%28*%29%20AS%20%3Fcount%29%20%28wd%3AP31%20as%20%3Fuse_as_%29%0A%20%20%20%20%7B%20%20%3Fa%20%20wdt%3AP571%20%20%3Fp%20%20%3B%20wdt%3AP31%20%20%3Fclass%7D%0A%20%20%20%20%20%20%20%20GROUP%20BY%20%3Fclass%20ORDER%20BY%20DESC%28%3Fcount%29%20LIMIT%2050%0A%20%20%20%20%7D%0A%20%20%20%20UNION%0A%20%20%7B%20%20SELECT%20%3Fclass%20%28COUNT%28*%29%20AS%20%3Fcount%29%20%28wd%3AP279%20as%20%3Fuse_as_%29%0A%20%20%20%20%7B%20%20%3Fa%20%20wdt%3AP571%20%20%3Fp%20%20%3B%20wdt%3AP279%20%20%3Fclass%7D%0A%20%20%20%20%20%20%20%20GROUP%20BY%20%3Fclass%20ORDER%20BY%20DESC%28%3Fcount%29%20LIMIT%2050%0A%20%20%20%20%7D%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Cen%22%20%7D%0A%7D%0AORDER%20BY%20DESC%28%3Fcount%29%20%3Fclass> > - By century > > <https://query.wikidata.org/#%23Number%20of%20dates%20per%20century%0ASELECT%20%3Fcentury%20%28COUNT%28%3Fitem%29%20as%20%3Fcount%29%0AWHERE%0A%7B%0A%20%20%3Fitem%20wdt%3AP571%20%3Fdate%20.%0A%20%20BIND%28FLOOR%28%28YEAR%28%3Fdate%29-1%29%2F100%29%2B1%20as%20%3Fcentury%29%0A%7D%0AGROUP%20BY%20%3Fcentury%0AORDER%20BY%20DESC%28%3Fcentury%29> > - Date precision > > <https://query.wikidata.org/#%23by%20Jura1%2C%202016-05-04%0ASELECT%20%3Fcount%20%3Fdatetime_precision_label%20%3Fdatetime_precision%0A%7B%0A%20%20%7B%0A%20%20%20%20SELECT%20%3Fdatetime_precision%20%28count%28DISTINCT%28%3Fnode%29%29%20as%20%3Fcount%29%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%3Fnode%20psv%3AP571%2Fwikibase%3AtimePrecision%20%3Fdatetime_precision%0A%20%20%20%20%7D%0A%20%20%20%20GROUP%20BY%20%3Fdatetime_precision%0A%20%20%7D%0A%20%20%3Fitem%20wdt%3AP2803%20%3Fvalue%0A%20%20FILTER%20%28%3Fdatetime_precision%20%3D%20%3Fvalue%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Cen%22%20.%20%3Fitem%20rdfs%3Alabel%20%3Fdatetime_precision_label%20%20%7D%0A%7D%0AORDER%20BY%20DESC%28%3Fcount%29%0ALIMIT%2010> > - Calendar models > > <https://query.wikidata.org/#SELECT%20%3Fcalendar%20%28count%28*%29%20as%20%3Fcount%29%0AWHERE%20%7B%0A%20%20%3Fdateproperty%20psv%3AP571%2Fwikibase%3AtimeCalendarModel%20%3Fcalendar.%0A%7D%0AGROUP%20BY%20%3Fcalendar%0AORDER%20BY%20DESC%28%3Fcount%29> > - List of qualifiers > > <https://query.wikidata.org/#%23Count%20of%20qualifiers%20within%20a%20sample%20of%20statements%20%28maybe%20the%20first%20500%2C000%20-%201%20million%29%0A%23by%20User%3AJura1%2C%202020-06-27%0ASELECT%20%3Fqual%20%3FqualLabel%20%3Fcount_sample%0AWHERE%0A%7B%0A%20%20%7B%20%20SELECT%20%3Fqual%20%28COUNT%28%2a%29%20AS%20%3Fcount_sample%29%0A%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%7B%20SELECT%20%2a%20%7B%20%5B%5D%20ps%3AP571%20%5B%5D%3B%20%3Fpq%20%5B%5D%20%7D%20LIMIT%204000000%20%7D%0A%20%20%20%20%20%20%20%20%3Fqual%20wikibase%3Aqualifier%20%3Fpq%0A%20%20%20%20%20%7D%0A%20%20%20%20%20GROUP%20BY%20%3Fqual%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fqual%20rdfs%3Alabel%20%3FqualLabel%20FILTER%28lang%28%3FqualLabel%29%20%3D%20%22en%22%29%20%7D%0A%7D%0AORDER%20BY%20DESC%28%3Fcount_sample%29%20ASC%28%3FqualLabel%29> > - Count > > <https://query.wikidata.org/#%23%20Uses%20of%20P571%3A%0A%23%20-%20as%20property%20%28any%20rank%2Fbest%20rank%2Fnormal%20rank%2Fpreferred%20rank%2Fdeprecated%20rank%29%0A%23%20-%20as%20qualifier%0A%23%20-%20in%20references%0A%23%20by%20Jura1%2C%20rev%202016-03-03%0ASELECT%20%3Fuse%20%3Frank%20%3Fitems_with_property%20%3Fuses_of_property%0AWHERE%20%7B%0A%20%20%7B%0A%20%20%20%20SELECT%20%28wikibase%3AstatementProperty%20AS%20%3Fuse%29%20%28COUNT%28DISTINCT%28%3Fitem%29%29%20AS%20%3Fitems_with_property%29%20%28COUNT%28%3Fvalue%29%20AS%20%3Fuses_of_property%29%0A%20%20%20%20WHERE%20%7B%3Fitem%20p%3AP571%20%3Fvalue%7D%0A%20%20%7D%20UNION%20%7B%0A%20%20%20%20SELECT%20%28wikibase%3AstatementProperty%20AS%20%3Fuse%29%20%28wikibase%3ABestRank%20AS%20%3Frank%29%20%28COUNT%28DISTINCT%28%3Fitem%29%29%20AS%20%3Fitems_with_property%29%20%28COUNT%28%3Fbestvalue%29%20AS%20%3Fuses_of_property%29%0A%20%20%20%20WHERE%20%7B%3Fitem%20wdt%3AP571%20%3Fbestvalue%7D%0A%20%20%7D%20UNION%20%7B%0A%20%20%20%20SELECT%20%28wikibase%3AstatementProperty%20AS%20%3Fuse%29%20%3Frank%20%28COUNT%28DISTINCT%28%3Fitem%29%29%20AS%20%3Fitems_with_property%29%20%28COUNT%28%28%3Fstatement%29%29%20AS%20%3Fuses_of_property%29%0A%20%20%20%20WHERE%20%7B%3Fitem%20p%3AP571%20%3Fstatement%20.%20%3Fstatement%20wikibase%3Arank%20%3Frank%7D%20GROUP%20BY%20%3Frank%0A%20%20%7D%20UNION%20%7B%0A%20%20%20%20SELECT%20%28wikibase%3Areference%20AS%20%3Fuse%29%20%28COUNT%28DISTINCT%28%3Fitem%29%29%20AS%20%3Fitems_with_property%29%20%28COUNT%28%3Fvalue%29%20AS%20%3Fuses_of_property%29%0A%20%20%20%20WHERE%20%7B%3Fitem%20pr%3AP571%20%3Fvalue%7D%0A%20%20%7D%20UNION%20%7B%0A%20%20%20%20SELECT%20%28wikibase%3Aqualifier%20AS%20%3Fuse%29%20%28COUNT%28DISTINCT%28%3Fitem%29%29%20AS%20%3Fitems_with_property%29%20%28COUNT%28%3Fvalue%29%20AS%20%3Fuses_of_property%29%0A%20%20%20%20WHERE%20%7B%3Fitem%20pq%3AP571%20%3Fvalue%7D%0A%20%20%7D%0A%7D%0AORDER%20BY%20DESC%28%3Fuse%29%20DESC%28%3Fitems_with_property%29%20%3Frank%0A%0A%23PLEASE%20NOTE%3A%20Deleted%20items%20appear%20in%20counts%20for%20some%20ranks%2C%20but%20not%20in%20others.> > > *inception* > > So... What is the most popular month/day for inception > <https://www.wikidata.org/wiki/Property:P571> ? > Many global governments and organizations have fiscal years that start/end > in the fall, so my prediction is probably "October" or shortly thereafter. > My prediction for the date would probably be a middle of the month number > (since finality is often determined by human resources which are usually > scarce at the beginning days of months, but who knows!) > > Thanks in advance! And looking forward to the result! > > Thad > https://www.linkedin.com/in/thadguidry/ > https://calendly.com/thadguidry/ > > _______________________________________________ > Wikidata mailing > [email protected]https://lists.wikimedia.org/mailman/listinfo/wikidata > > _______________________________________________ > Wikidata mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikidata >
_______________________________________________ Wikidata mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata
