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(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata