Difference between revisions of "Talk:ArchiveBot/Wikidata lists"
Jump to navigation
Jump to search
(7 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
You can run these queries in https://query.wikidata.org/ | |||
== Facebook query == | |||
<pre> | |||
SELECT DISTINCT ?item ?facebook | |||
WHERE { | |||
{ ?item wdt:P4003 ?facebook. } UNION { ?item wdt:P2013 ?facebook. } | |||
} | |||
ORDER BY ?facebook | |||
</pre> | |||
== Telegram query == | |||
<pre> | |||
SELECT DISTINCT ?item ?telegram | |||
WHERE { | |||
?item wdt:P3789 ?telegram. | |||
} | |||
ORDER BY ?telegram | |||
</pre> | |||
== Twitter query == | == Twitter query == | ||
Line 38: | Line 57: | ||
ORDER BY ?website | ORDER BY ?website | ||
</pre> | </pre> | ||
* https://transfer.notkiska.pw/aVG4c/museums-top-1000.txt | |||
== Cities query == | == Cities query == | ||
Line 49: | Line 70: | ||
ORDER BY ?website | ORDER BY ?website | ||
</pre> | </pre> | ||
* https://transfer.notkiska.pw/6rYxe/cities-top-1000.txt | |||
== Archives query == | == Archives query == | ||
Line 70: | Line 93: | ||
} | } | ||
ORDER BY ?website | ORDER BY ?website | ||
</pre> | |||
== Newspapers == | |||
Sorted by number of wikipedia languages for each newspaper. | |||
<pre> | |||
Wikidata query: | |||
SELECT DISTINCT ?web | |||
WHERE { | |||
?item wdt:P31/wdt:P279* wd:Q11032. | |||
?item wdt:P856 ?web. | |||
?item wikibase:sitelinks ?sitelinks. | |||
} | |||
ORDER BY DESC(?sitelinks) LIMIT 1000 | |||
</pre> | |||
* https://transfer.notkiska.pw/PTUBR/newspapers-top-100.txt | |||
* https://transfer.notkiska.pw/qORue/newspapers-top-500.txt | |||
* https://transfer.notkiska.pw/5HnU0/newspapers-top-1000.txt | |||
* https://transfer.notkiska.pw/scnOs/newspapers-top-5000.txt | |||
== Government bodies == | |||
<pre> | |||
SELECT DISTINCT ?web | |||
WHERE { | |||
?item wdt:P31/wdt:P279* wd:Q2659904. | |||
?item wdt:P856 ?web. | |||
?item wikibase:sitelinks ?sitelinks. | |||
} | |||
ORDER BY DESC(?sitelinks) LIMIT 25000 | |||
</pre> | </pre> |
Latest revision as of 11:08, 18 March 2020
You can run these queries in https://query.wikidata.org/
Facebook query
SELECT DISTINCT ?item ?facebook WHERE { { ?item wdt:P4003 ?facebook. } UNION { ?item wdt:P2013 ?facebook. } } ORDER BY ?facebook
Telegram query
SELECT DISTINCT ?item ?telegram WHERE { ?item wdt:P3789 ?telegram. } ORDER BY ?telegram
Twitter query
SELECT DISTINCT ?item ?twitter WHERE { ?item wdt:P2002 ?twitter. } ORDER BY ?twitter
Sorted by followers
SELECT DISTINCT ?item ?twitter ?followers WHERE { ?item wdt:P2002 ?twitter. ?item p:P2002 [ pq:P3744 ?followers ]. } ORDER BY DESC(?followers)
YouTube query
SELECT DISTINCT ?item ?youtube WHERE { ?item wdt:P2397 ?youtube. } ORDER BY ?youtube
Museums query
SELECT DISTINCT ?item ?website WHERE { ?item wdt:P31/wdt:P279* wd:Q33506. ?item wdt:P856 ?website. } ORDER BY ?website
Cities query
SELECT DISTINCT ?website WHERE { ?item wdt:P31/wdt:P279* wd:Q486972. ?item wdt:P856 ?website. } ORDER BY ?website
Archives query
SELECT DISTINCT ?website WHERE { ?item wdt:P31/wdt:P279* wd:Q166118. ?item wdt:P856 ?website. } ORDER BY ?website
Sport events
SELECT DISTINCT ?website WHERE { ?item wdt:P31/wdt:P279* wd:Q13406554. ?item wdt:P856 ?website. } ORDER BY ?website
Newspapers
Sorted by number of wikipedia languages for each newspaper.
Wikidata query: SELECT DISTINCT ?web WHERE { ?item wdt:P31/wdt:P279* wd:Q11032. ?item wdt:P856 ?web. ?item wikibase:sitelinks ?sitelinks. } ORDER BY DESC(?sitelinks) LIMIT 1000
- https://transfer.notkiska.pw/PTUBR/newspapers-top-100.txt
- https://transfer.notkiska.pw/qORue/newspapers-top-500.txt
- https://transfer.notkiska.pw/5HnU0/newspapers-top-1000.txt
- https://transfer.notkiska.pw/scnOs/newspapers-top-5000.txt
Government bodies
SELECT DISTINCT ?web WHERE { ?item wdt:P31/wdt:P279* wd:Q2659904. ?item wdt:P856 ?web. ?item wikibase:sitelinks ?sitelinks. } ORDER BY DESC(?sitelinks) LIMIT 25000