Wikidata:Orb Open Graph/Queries
View scheduled queries and query result links
The Orb Open Graph operates a scheduled query service. On this page you can define a query to run at an interval of your choosing. The query service operates at that interval and caches results for use by tools, bots, and humans.
Add a query to this page
editBefore registering a query for recurring run, try it out to make sure it works. The "try" service connects directly to a Blazegraph endpoint with no cache intermediary. This endpoint does not have a timeout limit, but queries that are overly complex may crash.
Create a new subsection at the bottom of this page using the syntax below.
- For query identifier, come up with a unique identifier string for your Wikidata query. It should not be changed once it is set. Try to organize similar or related queries using prefixes.
- For query title, use a more human-readable query name. This does not have to be unique, though it is recommended. Unlike the query identifier, you can change this all you like.
- For preferred output format, describe how you want to view the query results in the query service UI. By default, query results are presented as tables, but you can also opt for the types below. Not all types are available for all queries.
- Image grid
- Graph builder
- Map
- Line chart
- Bar chart
- Scatter chart
- Area chart
- Bubble chart
- Tree map
- Tree
- Timeline
- Dimensions
- Graph
- For data refresh rate, How often you want the results refreshed in seconds
===query identifier===
* query title:
* preferred output format: Table
* data refresh rate: 3600
{{SPARQL|query=
}}
Access results
editTo conveniently access JSON-formatted results, you can use the https://query-api.orbopengraph.com/data API in conjunction with the query identifier used as the section header. For example, https://query-api.orbopengraph.com/data/last-updated updates every five minutes with the query service's last update timestamp (depending on which of the Blazegraph servers is queried). You can also specify /view instead of /data to get the results frontend, like https://query-api.orbopengraph.com/view/last-updated.
A table with queries, including the time of last update, the frequency of updates, and links to the query result display and JSON are available at https://query-api.orbopengraph.com/status
Issues
edit- Using [AUTO_LANGUAGE] does not work, and is probably not useful for this service, since the service submitting the queries to the backend will consistently have a user language of English.
Scheduled recurring queries
editlast-updated
edit- query title: Query service last updated
- preferred output format: Table
- data refresh rate: 300
PREFIX schema: <http://schema.org/>
SELECT * WHERE { <http://www.wikidata.org> schema:dateModified ?y . }
worldnews-newspapers
edit- query title: World News: Newspapers
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?article WHERE {
?item wdt:P31* wd:Q11032.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
worldnews-industry-journalism
edit- query title: World News: Organizations with industry of journalism
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P452 wd:Q11030.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
vsafe-vaccine-types
edit- query title: Vaccine safety: vaccine types
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P31* wd:Q105967696.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
vsafe-vaccine-journals
edit- query title: Vaccine safety: journals about vaccines
- preferred output format: Table
- data refresh rate: 3600
select distinct ?item ?article where {
?item wdt:P31 wd:Q5633421;
rdfs:label ?itemLabel.
filter(contains(?itemLabel, "Vaccine"))
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
stats-doi
edit- query title: Number of Wikidata items with DOIs
- preferred output format: Table
- data refresh rate: 3600
SELECT (COUNT(?item) AS ?count) WHERE {
?item wdt:P356 ?doi .
}
stats-pubmed
edit- query title: Number of Wikidata items with PubMed IDs
- preferred output format: Table
- data refresh rate: 3600
SELECT (COUNT(?item) AS ?count) WHERE {
?item wdt:P698 ?pubmed .
}
nioshtic-all
edit- query title: Mapping of NIOSHTIC2-ID with other identifiers
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?NIOSHTIC2_ID ?NTIS_accession_number ?DOI ?PubMed_Central_ID ?PubMed_ID ?ISBN_13 ?ISBN_10 ?NIOSH_Numbered_Publication_ID ?ProQuest_document_ID ?Handle_ID ?YouTube_video_ID ?JSTOR_article_ID ?CDC_Stacks_ID ?ResearchGate_publication_ID ?Patent_number WHERE {
?item wdt:P2880 ?NIOSHTIC2_ID.
OPTIONAL { ?item wdt:P7791 ?NTIS_accession_number. }
OPTIONAL { ?item wdt:P356 ?DOI. }
OPTIONAL { ?item wdt:P932 ?PubMed_Central_ID. }
OPTIONAL { ?item wdt:P698 ?PubMed_ID. }
OPTIONAL { ?item wdt:P212 ?ISBN_13. }
OPTIONAL { ?item wdt:P957 ?ISBN_10. }
OPTIONAL { ?item wdt:P4596 ?NIOSH_Numbered_Publication_ID. }
OPTIONAL { ?item wdt:P6572 ?ProQuest_document_ID. }
OPTIONAL { ?item wdt:P1184 ?Handle_ID. }
OPTIONAL { ?item wdt:P1651 ?YouTube_video_ID. }
OPTIONAL { ?item wdt:P888 ?JSTOR_article_ID. }
OPTIONAL { ?item wdt:P12706 ?CDC_Stacks_ID. }
OPTIONAL { ?item wdt:P5875 ?ResearchGate_publication_ID. }
OPTIONAL { ?item wdt:P1246 ?Patent_number. }
}
nioshtic-with-pmcid
edit- query title: Identifier map: PubMed Central ID with or without NIOSHTIC2-ID
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?pmcid ?NIOSHTIC2_ID WHERE {
?item wdt:P932 ?pmcid.
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-ntis-accession-number
edit- query title: Identifier map: NTIS Accession Number with or without NIOSHTIC2-ID
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?NTIS_accession_number ?NIOSHTIC2_ID WHERE {
?item wdt:P7791 ?NTIS_accession_number.
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-isbn-10
edit- query title: Identifier map: ISBN-10 with or without NIOSHTIC2-ID
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?ISBN_10 ?NIOSHTIC2_ID WHERE {
?item wdt:P957 ?ISBN_10.
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-isbn-13
edit- query title: Identifier map: ISBN-13 with or without NIOSHTIC2-ID
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?ISBN_13 ?NIOSHTIC2_ID WHERE {
?item wdt:P212 ?ISBN_13.
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-niosh-numbered-publication-id
edit- query title: Identifier map: NIOSH Numbered Publication ID with or without NIOSHTIC2-ID
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?NIOSH_Numbered_Publication_ID ?NIOSHTIC2_ID WHERE {
?item wdt:P4596 ?NIOSH_Numbered_Publication_ID.
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-proquest-document-id
edit- query title: Identifier map: ProQuest document ID with or without NIOSHTIC2-ID
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?ProQuest_document_ID ?NIOSHTIC2_ID WHERE {
?item wdt:P6572 ?ProQuest_document_ID.
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-handle
edit- query title: Identifier map: Handle with or without NIOSHTIC2-ID
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?Handle_ID ?NIOSHTIC2_ID WHERE {
?item wdt:P1184 ?Handle_ID.
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nishotic-with-youtube-video-id
edit- query title: Identifier map: YouTube video ID with or without NIOSHTIC2-ID
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?YouTube_video_ID ?NIOSHTIC2_ID WHERE {
?item wdt:P1651 ?YouTube_video_ID.
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-jstor-article-id
edit- query title: Identifier map: JSTOR article ID with or without NIOSHTIC2-ID
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?JSTOR_article_ID ?NIOSHTIC2_ID WHERE {
?item wdt:P888 ?JSTOR_article_ID.
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-cdc-stacks-id
edit- query title: Identifier map: CDC Stacks ID with or without NIOSHTIC2-ID
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?CDC_Stacks_ID ?NIOSHTIC2_ID WHERE {
?item wdt:P12706 ?CDC_Stacks_ID.
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-researchgate-publication-id
edit- query title: Identifier map: ResearchGate publication ID with or without NIOSHTIC2-ID
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?ResearchGate_publication_ID ?NIOSHTIC2_ID WHERE {
?item wdt:P5875 ?ResearchGate_publication_ID.
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-patent-number
edit- query title: Identifier map: Patent number with or without NIOSHTIC2-ID
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?Patent_number ?NIOSHTIC2_ID WHERE {
?item wdt:P1246 ?Patent_number.
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-doi-1
edit- query title: Identifier map: DOI with or without NIOSHTIC2-ID Part 1
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?identifier ?NIOSHTIC2_ID WHERE {
SERVICE bd:slice {
?item wdt:P356 ?identifier .
bd:serviceParam bd:slice.offset 0 .
bd:serviceParam bd:slice.limit 10000000 .
}
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-doi-2
edit- query title: Identifier map: DOI with or without NIOSHTIC2-ID Part 2
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?identifier ?NIOSHTIC2_ID WHERE {
SERVICE bd:slice {
?item wdt:P356 ?identifier .
bd:serviceParam bd:slice.offset 10000001 .
bd:serviceParam bd:slice.limit 10000000 .
}
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-doi-3
edit- query title: Identifier map: DOI with or without NIOSHTIC2-ID Part 3
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?identifier ?NIOSHTIC2_ID WHERE {
SERVICE bd:slice {
?item wdt:P356 ?identifier .
bd:serviceParam bd:slice.offset 20000001 .
bd:serviceParam bd:slice.limit 10000000 .
}
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-doi-4
edit- query title: Identifier map: DOI with or without NIOSHTIC2-ID Part 4
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?identifier ?NIOSHTIC2_ID WHERE {
SERVICE bd:slice {
?item wdt:P356 ?identifier .
bd:serviceParam bd:slice.offset 30000001 .
bd:serviceParam bd:slice.limit 10000000 .
}
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-pubmed-1
edit- query title: Identifier map: PubMed ID with or without NIOSHTIC2-ID Part 1
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?identifier ?NIOSHTIC2_ID WHERE {
SERVICE bd:slice {
?item wdt:P698 ?identifier .
bd:serviceParam bd:slice.offset 0 .
bd:serviceParam bd:slice.limit 10000000 .
}
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-pubmed-2
edit- query title: Identifier map: PubMed ID with or without NIOSHTIC2-ID Part 2
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?identifier ?NIOSHTIC2_ID WHERE {
SERVICE bd:slice {
?item wdt:P698 ?identifier .
bd:serviceParam bd:slice.offset 10000001 .
bd:serviceParam bd:slice.limit 10000000 .
}
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-pubmed-3
edit- query title: Identifier map: PubMed ID with or without NIOSHTIC2-ID Part 3
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?identifier ?NIOSHTIC2_ID WHERE {
SERVICE bd:slice {
?item wdt:P698 ?identifier .
bd:serviceParam bd:slice.offset 20000001 .
bd:serviceParam bd:slice.limit 10000000 .
}
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
nioshtic-with-pubmed-4
edit- query title: Identifier map: PubMed ID with or without NIOSHTIC2-ID Part 4
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?identifier ?NIOSHTIC2_ID WHERE {
SERVICE bd:slice {
?item wdt:P698 ?identifier .
bd:serviceParam bd:slice.offset 30000001 .
bd:serviceParam bd:slice.limit 10000000 .
}
OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
osh-facet-of
edit- query title: Facet of occupational safety and health
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P1269 wd:Q629029.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-subclass-of
edit- query title: Subclass of occupational safety and health
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P279* wd:Q629029.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-part-of
edit- query title: Part of occupational safety and health
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P361 wd:Q629029.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-hazards
edit- query title: Subclass of occupational hazard
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P279* wd:Q3433185.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-hazards-chemical-with-exposure-items
edit- query title: Chemical articles with exposure items
- preferred output format: Table
- data refresh rate: 3600
SELECT DISTINCT ?item ?itemLabel ?article ?exposure ?exposureLabel
WHERE {
?item wdt:P31 wd:Q113145171;
wdt:P1542 ?exposure.
{
?exposure wdt:P279* wd:Q21167512 .
} UNION {
?exposure wdt:P279* wd:Q68182219 .
}
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en".
}
}
osh-hazards-chemical-exposure-articles
edit- query title: Chemical exposures with Wikipedia articles
- preferred output format: Table
- data refresh rate: 3600
SELECT DISTINCT ?item ?itemLabel ?article
WHERE {
?chemical wdt:P31 wd:Q113145171;
wdt:P1542 ?item.
{
?item wdt:P279* wd:Q21167512 .
} UNION {
?item wdt:P279* wd:Q68182219 .
}
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en".
}
}
osh-infectious-disease
edit- query title: Instance of infectious disease
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P31* wd:Q18123741.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-emerging-infectious-disease
edit- query title: Instance of emerging infectious disease
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P31* wd:Q609748.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-biological-hazards
edit- query title: Subclass of biological hazard
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P279* wd:Q864360.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-physical-injuries
edit- query title: Subclass of injury
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P279* wd:Q193078.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-physical-hazards
edit- query title: Subclass of physical hazard
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P279* wd:Q7189604.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-mental-disorders
edit- query title: Subclass of physical hazard
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P279* wd:Q12135.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-psychosocial-hazards
edit- query title: Subclass of mental disorder
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P279 wd:Q20899861.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-occupations
edit- query title: Instance of occupation
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P31 wd:Q12737077.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-industries
edit- query title: Instance of industry
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P31 wd:Q268592.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-part-of-hazard-control
edit- query title: Part of hazard control
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P361 wd:Q5753150.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-subclass-of-hazard-control
edit- query title: Subclass of hazard control
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P279 wd:Q5753150.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-people-field-of-work
edit- query title: Field of work: occupational safety and health
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P101 wd:Q629029.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-disease
edit- query title: Subclass of disease
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P279* wd:Q12136.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
osh-occupational-disease
edit- query title: Subclass of occupational disease
- preferred output format: Table
- data refresh rate: 3600
select ?item ?article where {
?item wdt:P279* wd:Q637816.
OPTIONAL {
?article schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>.
}
}
recent-citations-to-works-by-niosh-people
edit- query title: Recent citations to people related to NIOSH
- preferred output format: Table
- data refresh rate: 3600
PREFIX target: <http://www.wikidata.org/entity/Q60346>
SELECT DISTINCT ?publication_date ?citing_work ?citing_workLabel ?work ?workLabel
WHERE {
?researcher ( wdt:P108| wdt:P463 | wdt:P1416 ) / wdt:P361* target: .
?work wdt:P50 ?researcher .
?citing_work wdt:P2860 ?work .
?citing_work wdt:P577 ?publication_datetime .
BIND(xsd:date(?publication_datetime) AS ?publication_date)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}
ORDER BY DESC(?publication_date)
LIMIT 200
discontinued-journals
edit- query title: Discontinued journals
- preferred output format: Table
- data refresh rate: 3600
SELECT DISTINCT ?journal (GROUP_CONCAT(DISTINCT ?title; separator=" • ") AS ?combinedTitle) (COUNT(DISTINCT ?paper) AS ?count) WHERE {
?journal wdt:P236 ?issn ;
wdt:P582 ?endtime .
?journal wdt:P1476 ?title .
FILTER (LANG(?title) = "en")
?paper wdt:P1433 ?journal .
?paper wdt:P50 ?author .
?paper wdt:P921 ?topic .
}
GROUP BY ?journal
ORDER BY DESC(?count)
LIMIT 1000
debug-cache-miss
edit- query title: Debug: AUTO_LANGUAGE causes cache miss with frontend
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?itemLabel WHERE {
?item wdt:P31 wd:Q5 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
}
LIMIT 5
wikipedia-en-articles
edit- query title: Wikidata items with English Wikipedia pages
- preferred output format: Table
- data refresh rate: 3600
SELECT ?item ?enWikipediaArticle WHERE {
?enWikipediaArticle schema:isPartOf <https://en.wikipedia.org/> ;
schema:about ?item .
}