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
Or, Sign Up with Email & 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-cumulative-cases-by-date-tdt9-vq5y".covid19_cumulative_cases_by_date cambridge_cases
ON
    date_trunc('day', chicago_cases.lab_report_date) = cambridge_cases.date
ORDER BY date ASC;
Join across tables from live datasets