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{%0A%20%20%3Fitem%20wdt%3AP571%20%3Fvalue%20.%0A%23%20%20%3Fitem%20wdt%3AP569%20%3Fdob%20.%0A%23%20%20OPTIONAL%20{%3Fitem%20wdt%3AP570%20%3Fdod%20}%20.%0A%23%20%20%3Fitem%20wdt%3AP17%20%3Fcountry%20.%0A%20%20SERVICE%20wikibase%3Alabel%20{%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Cen%22%20%20}%0A}%0ALIMIT%2010
• Current uses https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3Fvalue%0A{%0A%20%20%3Fitem%20wdt%3AP571%20%3Fvalue%20.%0A%20%20SERVICE%20wikibase%3Alabel%20{%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Cen%22%20%20}%0A}%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{%20%20{%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{%20%20%3Fa%20%20wdt%3AP571%20%20%3Fp%20%20%3B%20wdt%3AP31%20%20%3Fclass}%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}%0A%20%20%20%20UNION%0A%20%20{%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{%20%20%3Fa%20%20wdt%3AP571%20%20%3Fp%20%20%3B%20wdt%3AP279%20%20%3Fclass}%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}%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20{%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Cen%22%20}%0A}%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{%0A%20%20{%0A%20%20%20%20SELECT%20%3Fdatetime_precision%20%28count%28DISTINCT%28%3Fnode%29%29%20as%20%3Fcount%29%0A%20%20%20%20{%0A%20%20%20%20%20%20%20%20%3Fnode%20psv%3AP571%2Fwikibase%3AtimePrecision%20%3Fdatetime_precision%0A%20%20%20%20}%0A%20%20%20%20GROUP%20BY%20%3Fdatetime_precision%0A%20%20}%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{%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Cen%22%20.%20%3Fitem%20rdfs%3Alabel%20%3Fdatetime_precision_label%20%20}%0A}%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{%0A%20%20%3Fdateproperty%20psv%3AP571%2Fwikibase%3AtimeCalendarModel%20%3Fcalendar.%0A}%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://www.linkedin.com/in/thadguidry/ https://calendly.com/thadguidry/ https://calendly.com/thadguidry/

---

Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata