Difference between revisions of "Truly Tabular RDF"
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
?conference rdfs:label ?conferenceLabel filter (lang(?conferenceLabel) = "en"). | ?conference rdfs:label ?conferenceLabel filter (lang(?conferenceLabel) = "en"). | ||
}</source> [https://query.wikidata.org/#%23%20Academic%20conference%20wikidata%20query%0A%23%20WF%202021-01-30%0APREFIX%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%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0ASELECT%20%3Fconference%20%3FconferenceLabel%20%0AWHERE%0A%7B%0A%20%20%23%20%20academic%20conference%20series%20%28Q2020153%29%0A%20%20%3Fconference%20wdt%3AP31%20wd%3AQ2020153.%0A%20%20%23%20label%0A%20%20%3Fconference%20rdfs%3Alabel%20%3FconferenceLabel%20filter%20%28lang%28%3FconferenceLabel%29%20%3D%20%22en%22%29.%0A%7D%0A try it!] | }</source> [https://query.wikidata.org/#%23%20Academic%20conference%20wikidata%20query%0A%23%20WF%202021-01-30%0APREFIX%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%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0ASELECT%20%3Fconference%20%3FconferenceLabel%20%0AWHERE%0A%7B%0A%20%20%23%20%20academic%20conference%20series%20%28Q2020153%29%0A%20%20%3Fconference%20wdt%3AP31%20wd%3AQ2020153.%0A%20%20%23%20label%0A%20%20%3Fconference%20rdfs%3Alabel%20%3FconferenceLabel%20filter%20%28lang%28%3FconferenceLabel%29%20%3D%20%22en%22%29.%0A%7D%0A try it!] | ||
| + | {| class="wikitable" style="text-align: left;" | ||
| + | |+ <!-- caption --> | ||
| + | |- | ||
| + | ! conference !! conferenceLabel | ||
| + | |- | ||
| + | | http://www.wikidata.org/entity/Q75698988 || The 2013 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies | ||
| + | |- | ||
| + | | http://www.wikidata.org/entity/Q75707991 || Digital Humanities 2020 | ||
| + | |- | ||
| + | | http://www.wikidata.org/entity/Q75709854 || Digital Humanities 2018 | ||
| + | |- | ||
| + | | ... | ||
| + | |} | ||
= How tabular are the Academic Conference entries in wikidata? = | = How tabular are the Academic Conference entries in wikidata? = | ||
{| class="wikitable" style="text-align: left;" | {| class="wikitable" style="text-align: left;" | ||
Revision as of 11:35, 27 July 2022
Naive SPARQL Query
- Start with a wikidata item your are intested in e.g. International Semantic Web Conference 2022
- use the instance of property to find similar items of the same class academic conference try it!
# Academic conference wikidata query # WF 2021-01-30 PREFIX wd: <http://www.wikidata.org/entity/> PREFIX wdt: <http://www.wikidata.org/prop/direct/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT ?conference ?conferenceLabel WHERE { # academic conference series (Q2020153) ?conference wdt:P31 wd:Q2020153. # label ?conference rdfs:label ?conferenceLabel filter (lang(?conferenceLabel) = "en"). }
| conference | conferenceLabel |
|---|---|
| http://www.wikidata.org/entity/Q75698988 | The 2013 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies |
| http://www.wikidata.org/entity/Q75707991 | Digital Humanities 2020 |
| http://www.wikidata.org/entity/Q75709854 | Digital Humanities 2018 |
| ... |
How tabular are the Academic Conference entries in wikidata?
| property | total | f1 | total% | non tabular | non tabular% | f2 | f3 | f14 | f4 | f7 | f5 | f9 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ∑ | 7518 | |||||||||||
| country | 7077 | 7077 | 94.1 | 0 | 0 | |||||||
| part of the series | 7139 | 7120 | 95 | 19 | 0.3 | 15 | 4 | |||||
| VIAF ID | 2096 | 2092 | 27.9 | 4 | 0.2 | 3 | 1 | |||||
| GND ID | 3049 | 3043 | 40.6 | 6 | 0.2 | 4 | 2 | |||||
| location | 7209 | 7180 | 95.9 | 29 | 0.4 | 24 | 4 | 1 | ||||
| start time | 6916 | 6914 | 92 | 2 | 0 | 2 | ||||||
| end time | 6912 | 6909 | 91.9 | 3 | 0 | 3 | ||||||
| official website | 596 | 586 | 7.9 | 10 | 1.7 | 9 | 1 | |||||
| main subject | 1882 | 1722 | 25 | 160 | 8.5 | 131 | 23 | 2 | 2 | 1 | 1 | |
| described at URL | 6512 | 6510 | 86.6 | 2 | 0 | 1 | 1 | |||||
| title | 6718 | 6700 | 89.4 | 18 | 0.3 | 10 | 8 | |||||
| short name | 6750 | 6741 | 89.8 | 9 | 0.1 | 9 | ||||||
| language used | 87 | 84 | 1.2 | 3 | 3.4 | 3 | ||||||
| is proceedings from | 921 | 901 | 12.3 | 20 | 2.2 | 16 | 3 | 1 | ||||
| WikiCFP event ID | 98 | 98 | 1.3 | 0 | 0 |