Halifax Explosion Remembrance Book database, 1917-1918

The 'Halifax Explosion Remembrance Book' is the first really definitive listing for those killed in the disaster of 6 December 1917. The online version features a searchable database with detailed information for 1946 casualties - more than 300 of whom are recently-confirmed and identified victims.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"novascotia-ca/halifax-explosion-remembrance-book-database-5rdj-x7jn\".\"halifax_explosion_remembrance_book_database\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.