running_activities_view (view)

78 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, avg_steps_per_min, max_steps_per_min, avg_vertical_ratio, vo2_max, training_effect, anaerobic_training_effect, heart_rate_zone_five_time, start_time (date), stop_time (date)

CREATE VIEW running_activities_view AS SELECT activities.activity_id AS activity_id, activities.name AS name, activities.description AS description, activities.sub_sport AS sub_sport, activities.course_id AS course_id, activities.start_time AS start_time, activities.stop_time AS stop_time, activities.elapsed_time AS elapsed_time, ROUND(activities.distance, 1) AS distance , steps_activities.steps AS steps, steps_activities.avg_pace AS avg_pace, steps_activities.avg_moving_pace AS avg_moving_pace, steps_activities.max_pace AS max_pace, ROUND(steps_activities.avg_steps_per_min, 1) AS avg_steps_per_min , ROUND(steps_activities.max_steps_per_min, 1) AS max_steps_per_min , activities.avg_hr AS avg_hr, activities.max_hr AS max_hr, activities.avg_rr AS avg_rr, activities.max_rr AS max_rr, activities.calories AS calories, ROUND(activities.avg_temperature, 1) AS avg_temperature , ROUND(activities.avg_speed, 1) AS avg_speed , ROUND(activities.max_speed, 1) AS max_speed , ROUND(steps_activities.avg_step_length, 1) AS avg_step_length , ROUND(steps_activities.avg_vertical_ratio, 1) AS avg_vertical_ratio , steps_activities.avg_gct_balance AS avg_gct_balance, ROUND(steps_activities.avg_vertical_oscillation, 1) AS avg_vertical_oscillation , steps_activities.avg_ground_contact_time AS avg_ground_contact_time, steps_activities.avg_stance_time_percent AS avg_stance_time_percent, steps_activities.vo2_max AS vo2_max, activities.training_effect AS training_effect, activities.anaerobic_training_effect AS anaerobic_training_effect, activities.hrz_1_time AS heart_rate_zone_one_time, activities.hrz_2_time AS heart_rate_zone_two_time, activities.hrz_3_time AS heart_rate_zone_three_time, activities.hrz_4_time AS heart_rate_zone_four_time, activities.hrz_5_time AS heart_rate_zone_five_time, "http://maps.google.com/?ie=UTF8&q=" || activities.start_lat || "," || activities.start_long || "&z=13" AS start_loc, "http://maps.google.com/?ie=UTF8&q=" || activities.stop_lat || "," || activities.stop_long || "&z=13" AS stop_loc 
FROM steps_activities JOIN activities ON activities.activity_id = steps_activities.activity_id 
WHERE Activities.sport == "running" ORDER BY activities.start_time DESC;