Connect Now
Compatible with most SQL clients
Host
data.splitgraph.com
Port
5432
Database Name
ddn
Connection URI
postgresql://data.splitgraph.com/ddn
Username / Password
Send a Query in 60 Seconds
Query 40k+ datasets with standard SQL
-- Join across two tables at different government data portals (Chicago and Cambridge)
-- Splitgraph will rewrite the queries into the providers' query language, get the data
-- and run the JOIN, returning the results over the PostgreSQL protocol.
SELECT
cambridge_cases.date AS date,
chicago_cases.cases_total AS chicago_daily_cases,
cambridge_cases.new_positive_cases AS cambridge_daily_cases
FROM
"cityofchicago/covid19-daily-cases-deaths-and-hospitalizations-naz8-j4nc".covid19_daily_cases_deaths_and_hospitalizations chicago_cases
FULL OUTER JOIN
"cambridgema-gov/covid19-case-count-by-date-axxk-jvk8".covid19_case_count_by_date cambridge_cases
ON
date_trunc('day', chicago_cases.lab_report_date) = cambridge_cases.date::timestamp
ORDER BY date ASC;
Join across tables from live datasets