The Algarve: the data

The Algarve'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 = 'algarve')

Answers

The Algarve'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 = 'algarve'
ORDER BY steps, name

22 rows, the first 12 shown.

The Algarve'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 = 'algarve'
ORDER BY date DESC

15 rows, the first 12 shown.

Everything within two steps of The Algarve

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

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

40 rows, the first 12 shown.

Who on The Algarve'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:algarve'
WHERE e1.verb = 'on_ai_map_of' AND e1.dst = 'place:algarve'
GROUP BY n.id
ORDER BY n.label

12 rows.

What The Algarve'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 = 'algarve'
ORDER BY items DESC, name

9 rows.

What The Algarve's agent has not found yet

The gaps, in the agent's words.

SELECT n, text FROM gaps WHERE place = 'algarve' ORDER BY n

11 rows.