ED get web data examples

From Discourse DB
Jump to navigation Jump to search

This is the companion page to the External Data web pages examples page on mediawiki.org, showing these calls in action.

NCBI taxonomy

[edit | edit source]

Data from the National Center for Biotechnology Information.

Information for taxon ID 8371:

  • Scientific name: Ranoidea aurea
  • Common name: Australian frog
  • Division: Vertebrates

PubMed

[edit | edit source]

Data from PubMed, run by the National Center for Biotechnology Information.

Information for PMID 19782018:

  • Title: How to choose a good scientific problem.
  • Name: Alon, Uri
  • Journal: Molecular cell
  • Year: 2009
  • Volume: 35

Scopus

[edit | edit source]

Data from Elsevier's Scopus database.

Information for 10.1103/PhysRevA.20.1521:

  • Title: Laser cooling of atoms
  • Author: Wineland D.J.
  • "Cited by" count: 689

Wikidata - individual entry

[edit | edit source]

SPARQL query:

SELECT ?item ?itemLabel ?symbol ?atomicNumber ( YEAR( ?discoveryDate ) AS ?discoveryYear ) ?discoverer ?discovererLabel
WHERE {
  VALUES ?item { wd:Q654 } .
  ?item wdt:P246 ?symbol .
  ?item wdt:P1086 ?atomicNumber .
  ?item wdt:P575 ?discoveryDate .
  ?item wdt:P61 ?discoverer
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

Info for Q654:

Wikidata - full query

[edit | edit source]

All paintings that depict a squirrel.

SPARQL query:

SELECT DISTINCT ?painting ?paintingLabel ?creator ?creatorLabel ( YEAR( ?inception ) as ?year ) ?genre ?genreLabel ( SUBSTR( ?str_image, 52 ) AS ?fileName )
WHERE
{
  ?painting wdt:P180 wd:Q9482 .
  ?painting wdt:P170 ?creator .
  ?painting wdt:P571 ?inception .
  ?painting wdt:P136 ?genre .
  ?painting wdt:P18 ?image .
  BIND (STR(?image) AS ?str_image)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY ?paintingLabel
Name Artist Year Genre Image
Q111135100 Willy Blees 1967 public art
Animals. Ernst Wilhelm Bernhardi 1708 animal art
Basket and bowls of fruit with two monkeys. a squirrel, a macaw and two guinea-pigs Jan van Kessel the Younger 1693 still life
Basket and bowls of fruit with two monkeys. a squirrel, a macaw and two guinea-pigs Jan van Kessel the Younger 1693 animal art
Basket of red and green grapes with fruits of the hunt, including a goldfinch Clara Peeters 1640 still life
Forest still life with squirrel Anna Ruysch 1685 still life
Forest still life with squirrel Anna Ruysch 1685 still life
Fruit bowl, basket, vegetables and a squirrel Gommaert van der Gracht 1645 still life
Fruit bowl, basket, vegetables and a squirrel Gommaert van der Gracht 1645 landscape painting
Fruit still life with goldfinch and squirrel Abraham Mignon 1668 still life
Fruits, Carnation and Squirrel Frans Snyders 1611 still life
Genoveva-Brunnen Hermann Hosaeus 1928 public art
Order of the Cub Scout Tom Frantzen 1994 public art
Peter Pan George Frampton 1924 public art
Pomona in a fruit garland and surrounded by animals Gommaert van der Gracht 1645 still life
Squirrels with Stag Horn Therese Richter 1809 still life
Squirrels with Stag Horn Therese Richter 1809 animal art
Still Life of Fruit, a Lobster, Cheeses and Drinking Vessels with a Parrot and a Squirrel on a Table Artus Claessens 1650 still life
Still Life with Fruit and a Squirrel Catharina Treu 1780 still life
Still life with a basket of fruit, vegetables and a squirrel Abraham Gibbens 1635 still life
Still-Life with a Basket of Fruit, a Squirrel, and a Cat Frans Snyders 1639 still life
Two Squirrels Albrecht Dürer 1512 animal art
Two squirrels Jan Brueghel the Elder 1637 animal art
portal of the Haus Burchardt John Martens 1914 relief sculpture
portal of the Haus Burchardt John Martens 1914 public art
portal of the Haus Burchardt John Martens 1914 architectural sculpture
portal of the Haus Burchardt John Martens 1914 stone sculpture