Castro Marim: the data

Castro Marim'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 = 'castro-marim')

Answers

Castro Marim'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 = 'castro-marim'
ORDER BY steps, name

4 rows.

Castro Marim'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 = 'castro-marim'
ORDER BY date DESC

4 rows.

Everything within two steps of Castro Marim

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

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

9 rows.

Who on Castro Marim'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:castro-marim'
WHERE e1.verb = 'on_ai_map_of' AND e1.dst = 'place:castro-marim'
GROUP BY n.id
ORDER BY n.label

1 row.

What Castro Marim'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 = 'castro-marim'
ORDER BY items DESC, name

9 rows.

What Castro Marim's agent has not found yet

The gaps, in the agent's words.

SELECT n, text FROM gaps WHERE place = 'castro-marim' ORDER BY n

8 rows.