Returns the news topics proposed for a given Space: the topic and its description, the Wikipedia article it is the primary topic of, the news articles covering it and how many there are, and the Wikidata item if one has been recorded. Topics with no Wikidata item are still open proposals. Results are ordered by news coverage first, so the best-attested proposals come top. The optional minSources parameter applies a coverage threshold: pass minSources=3 to see only topics that have already appeared in at least three news articles. When it is omitted, no threshold is applied.
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix schema: <https://schema.org/> prefix foaf: <http://xmlns.com/foaf/0.1/> prefix owl: <http://www.w3.org/2002/07/owl#> prefix xsd: <http://www.w3.org/2001/XMLSchema#> select ?topic ?topic_label ?description ?article ?article_label (group_concat(distinct str(?source); separator=" ") as ?sources_multi_iri) (count(distinct ?source) as ?source_count) ?wikidata ?wikidata_label ?date ?override_target ?np ?np_label where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?inv npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } graph ?a { values ?_space_multi_iri {} ?a schema:about ?_space_multi_iri . ?topic rdfs:label ?topic_label . ?topic foaf:isPrimaryTopicOf|dct:isReferencedBy ?anySource . } optional { graph ?a { ?topic dct:description ?description } } optional { graph ?a { ?topic foaf:isPrimaryTopicOf ?article } } optional { graph ?a { ?topic dct:isReferencedBy ?source } } optional { graph ?a { ?topic owl:sameAs ?wikidata } } bind(replace(replace(coalesce(str(?article), ""), "^.*/wiki/", ""), "_", " ") as ?article_label) bind(replace(coalesce(str(?wikidata), ""), "^.*/entity/", "") as ?wikidata_label) bind(str(?np) as ?override_target) bind("^" as ?np_label) } group by ?topic ?topic_label ?description ?article ?article_label ?wikidata ?wikidata_label ?date ?override_target ?np ?np_label having(coalesce(count(distinct ?source) >= xsd:integer(?__minSources), true)) order by desc(?source_count) desc(?date)