4,467
edits
|
Metabase Meet & Greet Meet the WMSE team behind Metabase and other editors and friends of Metabase! Everyone is welcome, regardless if you are an active editor or simply interested in the platform. Ask questions, brainstorm and write queries, or simply chat about the future of Metabase. The first Metabase Meet & Greet will be in November - help us pick the time. |
Main Page: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
No edit summary |
||
| Line 50: | Line 50: | ||
* [https://metabase.wikibase.cloud/query/#%23defaultView%3ATimeline%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Ftime%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP15%20wb%3AQ90%20%23%20SDC%0A%7B%3Fitem%20wbt%3AP23%20%3Ftime%7D%20%23%20point%20in%20time%0AUNION%0A%7B%3Fitem%20wbt%3AP18%20%3Ftime%7D%20%23%20publication%20date%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Csv%22.%20%7D%0A%7D Timeline of everything published or presented about Structured Data on Commons] | * [https://metabase.wikibase.cloud/query/#%23defaultView%3ATimeline%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Ftime%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP15%20wb%3AQ90%20%23%20SDC%0A%7B%3Fitem%20wbt%3AP23%20%3Ftime%7D%20%23%20point%20in%20time%0AUNION%0A%7B%3Fitem%20wbt%3AP18%20%3Ftime%7D%20%23%20publication%20date%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Csv%22.%20%7D%0A%7D Timeline of everything published or presented about Structured Data on Commons] | ||
* [https://metabase.wikibase.cloud/query/#PREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3Fitem%20%3FitemLabel%20%28GROUP_CONCAT%28DISTINCT%20%3FtypeLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Ftypes%29%20%3Fwhen%20%3Fwikipage%20%28GROUP_CONCAT%28DISTINCT%20%3FpersonLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Fpersons%29%20%28GROUP_CONCAT%28DISTINCT%20%3FmainsubjectLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Ftopics%29%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP17%2A%20wb%3AQ22660.%0A%3Fitem%20wbt%3AP5%20%3Ftype.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP23%20%3Fwhen%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP32%20%3Fperson%7D%20%23%20leader%2C%20eg%20in%20a%20workshop%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP33%20%3Fperson%7D%20%23%20speaker%2C%20eg%20in%20a%20presentation%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP19%20%3Fperson%7D%20%23%20author%2C%20eg%20of%20a%20video%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP11%20%3Fwikipage%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP15%20%3Fmainsubject%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Csv%2Ces%22.%0A%20%20%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel.%0A%20%20%20%20%3Fperson%20rdfs%3Alabel%20%3FpersonLabel.%0A%20%20%20%20%3Fmainsubject%20rdfs%3Alabel%20%3FmainsubjectLabel.%0A%20%20%20%20%3Ftype%20rdfs%3Alabel%20%3FtypeLabel.%0A%20%20%7D%0A%7D%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%3Ftypes%20%3Fwhen%20%3Fwikipage%0AORDER%20BY%20%3FitemLabel Sessions at the GLAM Wiki conference 2023] | * [https://metabase.wikibase.cloud/query/#PREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3Fitem%20%3FitemLabel%20%28GROUP_CONCAT%28DISTINCT%20%3FtypeLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Ftypes%29%20%3Fwhen%20%3Fwikipage%20%28GROUP_CONCAT%28DISTINCT%20%3FpersonLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Fpersons%29%20%28GROUP_CONCAT%28DISTINCT%20%3FmainsubjectLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Ftopics%29%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP17%2A%20wb%3AQ22660.%0A%3Fitem%20wbt%3AP5%20%3Ftype.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP23%20%3Fwhen%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP32%20%3Fperson%7D%20%23%20leader%2C%20eg%20in%20a%20workshop%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP33%20%3Fperson%7D%20%23%20speaker%2C%20eg%20in%20a%20presentation%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP19%20%3Fperson%7D%20%23%20author%2C%20eg%20of%20a%20video%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP11%20%3Fwikipage%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP15%20%3Fmainsubject%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Csv%2Ces%22.%0A%20%20%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel.%0A%20%20%20%20%3Fperson%20rdfs%3Alabel%20%3FpersonLabel.%0A%20%20%20%20%3Fmainsubject%20rdfs%3Alabel%20%3FmainsubjectLabel.%0A%20%20%20%20%3Ftype%20rdfs%3Alabel%20%3FtypeLabel.%0A%20%20%7D%0A%7D%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%3Ftypes%20%3Fwhen%20%3Fwikipage%0AORDER%20BY%20%3FitemLabel Sessions at the GLAM Wiki conference 2023] | ||
*[https://metabase.wikibase.cloud/query/#%23Topics%20of%20the%20sessions%20at%20the%20GLAM%20Wiki%202023%20conference%0A%23defaultView%3ABubbleChart%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3Fmainsubject%20%3FmainsubjectLabel%20%28COUNT%28%3Fitem%29%20AS%20%3Fcount%29%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP17%2a%20wb%3AQ22660.%0A%3Fitem%20wbt%3AP15%20%3Fmainsubject%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Fmainsubject%20%3FmainsubjectLabel%0AORDER%20BY%20DESC%28%3Fcount%29 Topics at the GLAM Wiki conference 2023] | |||
* [https://metabase.wikibase.cloud/query/#%23Map%20of%20all%20event%20locations%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%23defaultView%3AMap%0ASELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fplace%20%3FplaceLabel%20%3Fcoords%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2a%20wb%3AQ40%20.%0A%3Fitem%20wbt%3AP27%20%3Fplace.%0A%3Fplace%20wbt%3AP1%20%3FwikidataQ.%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataQ%29%29%20AS%20%3Fwikidata_iri%29%0A%0ASERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%3Fwikidata_iri%20wdt%3AP625%20%3Fcoords.%0A%7D%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Map of all event locations] | * [https://metabase.wikibase.cloud/query/#%23Map%20of%20all%20event%20locations%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%23defaultView%3AMap%0ASELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fplace%20%3FplaceLabel%20%3Fcoords%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2a%20wb%3AQ40%20.%0A%3Fitem%20wbt%3AP27%20%3Fplace.%0A%3Fplace%20wbt%3AP1%20%3FwikidataQ.%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataQ%29%29%20AS%20%3Fwikidata_iri%29%0A%0ASERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%3Fwikidata_iri%20wdt%3AP625%20%3Fcoords.%0A%7D%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Map of all event locations] | ||
* [https://metabase.wikibase.cloud/query/#%23Number%20of%20events%202021-2022%20and%20total%20number%20of%20participants%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%28count%28distinct%20%3Fitem%29%20as%20%3Ftotal_events%29%20%28sum%28%3Fparticipants%29%20as%20%3Ftotal_participants%29%0AWHERE%0A%7B%0A%20%20%3Fitem%20wbt%3AP23%20%3Fwhen.%0A%20%20FILTER%20%28%3Fwhen%20%3E%20%222021-01-01%22%5E%5Exsd%3AdateTime%20%26%26%20%3Fwhen%20%3C%20%222022-12-31%22%5E%5Exsd%3AdateTime%29%0A%20%20OPTIONAL%7B%3Fitem%20wbt%3AP28%20%3Fparticipants.%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Number of events 2021-2022 and total number of participants] | * [https://metabase.wikibase.cloud/query/#%23Number%20of%20events%202021-2022%20and%20total%20number%20of%20participants%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%28count%28distinct%20%3Fitem%29%20as%20%3Ftotal_events%29%20%28sum%28%3Fparticipants%29%20as%20%3Ftotal_participants%29%0AWHERE%0A%7B%0A%20%20%3Fitem%20wbt%3AP23%20%3Fwhen.%0A%20%20FILTER%20%28%3Fwhen%20%3E%20%222021-01-01%22%5E%5Exsd%3AdateTime%20%26%26%20%3Fwhen%20%3C%20%222022-12-31%22%5E%5Exsd%3AdateTime%29%0A%20%20OPTIONAL%7B%3Fitem%20wbt%3AP28%20%3Fparticipants.%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Number of events 2021-2022 and total number of participants] | ||