turbot/formula1

Query: formula1_race_overview

Usage

powerpipe query formula1.query.formula1_race_overview

SQL

select
races.name as "Race Name",
races.date as "Date",
races.time as "Time",
circuits.name as "Circuit",
circuits.location as "Location",
races.round as "Round",
circuits.country as "Country"
from
races
join circuits on races.circuitId = circuits.circuitId
where
races.raceId = $1;

Dashboards

The query is used in the dashboards: