Vila Real de Santo António: the data

Vila Real de Santo António's data as tables and a graph: its AI map, its stories, its events, its sources and gaps, and everything they connect to across the Algarve. Run your own SQL, or read the answers below.

Ask

The query box runs in your browser and needs JavaScript. Every example below shows its query and the answer the build got from today's data. (scope: place = 'vila-real-de-santo-antonio')

Answers

Vila Real de Santo António's AI map, with the path to AI

Each entry, its kind, its source's host and the day it was read.

SELECT name, kind, steps, ai_path, host, read_on
FROM map
WHERE place = 'vila-real-de-santo-antonio'
ORDER BY steps, name

4 rows.

Vila Real de Santo António's local AI stories

Newest first, with the publisher and the path to AI.

SELECT date, title, publisher, steps, ai_path
FROM news
WHERE place = 'vila-real-de-santo-antonio'
ORDER BY date DESC

2 rows.

Everything within two steps of Vila Real de Santo António

A traversal from the place's node; the path shows how each is reached.

SELECT depth, type, label, path
FROM neighbours('place:vila-real-de-santo-antonio', 2, '-located_in')
WHERE depth > 0 AND type NOT IN ('source', 'fact', 'evidence')
ORDER BY depth, type, label
LIMIT 40

15 rows, the first 12 shown.

Who on Vila Real de Santo António's map is also on another place's map

The organisations this place shares with the rest of the Algarve.

SELECT n.label, group_concat(DISTINCT replace(e2.dst, 'place:', '')) AS also_in
FROM edges e1
JOIN nodes n ON n.id = e1.src
JOIN edges e2 ON e2.src = e1.src AND e2.verb = 'on_ai_map_of' AND e2.dst != 'place:vila-real-de-santo-antonio'
WHERE e1.verb = 'on_ai_map_of' AND e1.dst = 'place:vila-real-de-santo-antonio'
GROUP BY n.id
ORDER BY n.label

1 row.

What Vila Real de Santo António's page rests on

The sources its agent reads, and how many of its items rest on each host.

SELECT name, kind, host, items
FROM sources
WHERE place = 'vila-real-de-santo-antonio'
ORDER BY items DESC, name

9 rows.

What Vila Real de Santo António's agent has not found yet

The gaps, in the agent's words.

SELECT n, text FROM gaps WHERE place = 'vila-real-de-santo-antonio' ORDER BY n

8 rows.