SELECT Date
, 'Subways' as Transportation
, date_part('dayofweek', Date::date) as dow
, "Subways: Total Estimated Ridership" as Total
FROM mta
UNION
SELECT Date
, 'Buses' as Transportation
, date_part('dayofweek', Date::date) as dow
, "Buses: Total Estimated Ridership" as Total
FROM mta