4,162
edits
No edit summary |
|||
Line 11: | Line 11: | ||
Get started by learning about <span style="background-color:#ffddf5;">'''[[Modelling|what sort of data is included and how it is modeled]]'''.</span> | Get started by learning about <span style="background-color:#ffddf5;">'''[[Modelling|what sort of data is included and how it is modeled]]'''.</span> | ||
}} | }} | ||
==Find data | |||
You can use these queries to find all the data of a particular type that's already in Metabase | |||
<div style="float: left; width: 50%;"><div style="padding-right: 5px;"> | |||
{{Mainbox | |||
|color=2098AE | |||
|title=Find data | |||
|content= | |||
You can use these queries to find all the data of a particular type that's already in Metabase. | |||
{{Main Page Button|[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%0A%0ASELECT%20%3Fitem%20%3FitemLabelEN%20%3FitemLabelSV%20%3Fwikidata_iri%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%20wb%3AQ12%20.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP1%20%3FwikidataQ%7D%0AOPTIONAL%20%7B%3Fitem%20rdfs%3Alabel%20%3FitemLabelEN%20filter%20%28lang%28%3FitemLabelEN%29%20%3D%20%22en%22%29%7D.%0AOPTIONAL%20%7B%3Fitem%20rdfs%3Alabel%20%3FitemLabelSV%20filter%20%28lang%28%3FitemLabelSV%29%20%3D%20%22sv%22%29%7D.%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataQ%29%29%20AS%20%3Fwikidata_iri%29%0A%7D Index terms]}} {{Main Page Button|[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%3Fwikidata_iri%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%20wb%3AQ66.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP1%20%3FwikidataQ%7D%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataQ%29%29%20AS%20%3Fwikidata_iri%29%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Locations]}} {{Main Page Button|[https://metabase.wikibase.cloud/query/#%23All%20types%20of%20documents%20and%20their%20Wikidata%20equivalents%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%3Fwikidata_iri%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP4%2a%20wb%3AQ21.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP1%20%3FwikidataQ%7D%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataQ%29%29%20AS%20%3Fwikidata_iri%29%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Document types]}} {{Main Page Button|[https://metabase.wikibase.cloud/query/#%23All%20types%20of%20activities%20and%20events%20and%20their%20Wikidata%20equivalents%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%3Fwikidata_iri%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP4%2a%20wb%3AQ8.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP1%20%3FwikidataQ%7D%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataQ%29%29%20AS%20%3Fwikidata_iri%29%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Types of activities and events]}} | {{Main Page Button|[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%0A%0ASELECT%20%3Fitem%20%3FitemLabelEN%20%3FitemLabelSV%20%3Fwikidata_iri%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%20wb%3AQ12%20.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP1%20%3FwikidataQ%7D%0AOPTIONAL%20%7B%3Fitem%20rdfs%3Alabel%20%3FitemLabelEN%20filter%20%28lang%28%3FitemLabelEN%29%20%3D%20%22en%22%29%7D.%0AOPTIONAL%20%7B%3Fitem%20rdfs%3Alabel%20%3FitemLabelSV%20filter%20%28lang%28%3FitemLabelSV%29%20%3D%20%22sv%22%29%7D.%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataQ%29%29%20AS%20%3Fwikidata_iri%29%0A%7D Index terms]}} {{Main Page Button|[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%3Fwikidata_iri%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%20wb%3AQ66.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP1%20%3FwikidataQ%7D%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataQ%29%29%20AS%20%3Fwikidata_iri%29%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Locations]}} {{Main Page Button|[https://metabase.wikibase.cloud/query/#%23All%20types%20of%20documents%20and%20their%20Wikidata%20equivalents%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%3Fwikidata_iri%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP4%2a%20wb%3AQ21.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP1%20%3FwikidataQ%7D%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataQ%29%29%20AS%20%3Fwikidata_iri%29%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Document types]}} {{Main Page Button|[https://metabase.wikibase.cloud/query/#%23All%20types%20of%20activities%20and%20events%20and%20their%20Wikidata%20equivalents%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%3Fwikidata_iri%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP4%2a%20wb%3AQ8.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP1%20%3FwikidataQ%7D%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataQ%29%29%20AS%20%3Fwikidata_iri%29%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Types of activities and events]}} | ||
{{Main Page Button|[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%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fwikidata_iri%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%20wb%3AQ13%20.%0AOPTIONAL%7B%3Fitem%20wbt%3AP1%20%3FwikidataQ.%7D%0A%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%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Organizations]}} {{Main Page Button|[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%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fwikidata_iri%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%20wb%3AQ23%20.%0AOPTIONAL%7B%3Fitem%20wbt%3AP1%20%3FwikidataQ.%7D%0A%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%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Humans]}} {{Main Page Button|[https://metabase.wikibase.cloud/query/#PREFIX%20wd%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fstart%20%3Fend%20%28GROUP_CONCAT%28DISTINCT%20%3FmainsubjectLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Ftopics%29%20%28GROUP_CONCAT%28DISTINCT%20%3ForganizerLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Forganizers%29%0AWHERE%0A%7B%0A%20%20%3Fitem%20wdt%3AP5%20wd%3AQ2%20.%0A%20%20OPTIONAL%20%7B%20%20%3Fitem%20wdt%3AP6%20%3Fstart.%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP7%20%3Fend.%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP15%20%3Fmainsubject.%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP14%20%3Forganizer.%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%22.%0A%20%20%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel.%0A%20%20%20%20%3Fmainsubject%20rdfs%3Alabel%20%3FmainsubjectLabel.%0A%20%20%20%20%3Forganizer%20rdfs%3Alabel%20%3ForganizerLabel%0A%20%20%7D%0A%7D%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%3Fstart%20%3Fend%0AORDER%20BY%20%3FitemLabel Projects]}} {{Main Page Button|[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%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fwhere%20%3FwhereLabel%20%3Fwhen%20%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2a%20wb%3AQ40%20.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP23%20%3Fwhen%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP27%20%3Fwhere%7D%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Events]}} {{Main Page Button|[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%3Finstance_of%20%3Finstance_ofLabel%20%3Fpublished%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2A%20wb%3AQ21.%0A%3Fitem%20wbt%3AP5%20%3Finstance_of.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP18%20%3Fpublished.%7D%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D Documents]}} | |||
}} | |||
</div></div> | |||
<div style="float: right; width: 50%;"><div style="padding-right: 5px;"> | <div style="float: right; width: 50%;"><div style="padding-right: 5px;"> | ||
Line 29: | Line 37: | ||
</div></div> | </div></div> | ||
== | |||
<div style="float: right; width: 50%;"><div style="padding-right: 5px;"> | |||
{{User:Alicia Fagerving (WMSE)/Template | |||
|color=50A85E | |||
|title=Resources | |||
|content= | |||
Useful links and resources | |||
* Query interface: https://metabase.wikibase.cloud/query/ | * Query interface: https://metabase.wikibase.cloud/query/ | ||
* [[Project:SPARQL/examples|Query examples]] | * [[Project:SPARQL/examples|Query examples]] | ||
* {{Q|Q21897}} | * {{Q|Q21897}} | ||
* [https://metabase.wikibase.cloud/tools/quickstatements/#/ Quickstatements] - [https://www.wikidata.org/wiki/Help:QuickStatements Manual] | * [https://metabase.wikibase.cloud/tools/quickstatements/#/ Quickstatements] - [https://www.wikidata.org/wiki/Help:QuickStatements Manual] | ||
Line 39: | Line 51: | ||
==In other places== | ==In other places== | ||
* Wikimania 2023 presentation: [https://commons.wikimedia.org/wiki/File:Wikimania_2023_-_309_-_August_18_-_It%27s_on_Meta,_but_discoverable_%E2%80%93_organizational_knowledge_in_a_structured_form.webm It's on Meta, but discoverable – organizational knowledge in a structured form] | * Wikimania 2023 presentation: [https://commons.wikimedia.org/wiki/File:Wikimania_2023_-_309_-_August_18_-_It%27s_on_Meta,_but_discoverable_%E2%80%93_organizational_knowledge_in_a_structured_form.webm It's on Meta, but discoverable – organizational knowledge in a structured form] | ||
}} | |||
</div></div> |