query-e95180c9fa369c754413a0227a22ab2d

rq turtle/ttl

German submarines in WW IIBattle of the Atlantic statistics in war reports and post war surveys. Stats such as number of patrols, merchants sunk, and submarines sunk. Group by month. Count

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?sub ?subLabel ?timeSink ?timeScuttle
{
  # instance of submarine
  ?sub wdt:P31/wdt:P279* wd:Q2811 .

  # ?sub wdt:P607 wd:Q184425 .

  # conflict is WW II
  ?sub wdt:P607 wd:Q362 .

  # operator is Kriegsmarine
  ?sub wdt:P137 wd:Q151701 .

  optional {
    # significant event is sinking
    # ?sub wdt:P793 wd:Q30880545 .
    ?sub p:P793 ?stmtSignificant .
    ?stmtSignificant ps:P793  wd:Q30880545 .
    ?stmtSignificant pq:P585 ?timeSink .
  }

  optional {
    # significant event is scuttling
    # ?sub wdt:P793 wd:Q1786766 .
    ?sub p:P793 ?stmtSignificant .
    ?stmtSignificant ps:P793  wd:Q1786766 .
    ?stmtSignificant pq:P585 ?timeScuttle .
  }

  SERVICE wikibase:label {
     bd:serviceParam wikibase:language "en" .
  }

} ORDER BY ?timeSink

Query found at

• https://www.wikidata.org/wiki/User:Glrx