james_garmin_activities
Tables
activities
activity_id, name, description, type, course_id, laps, sport, sub_sport, device_serial_number, self_eval_feel, self_eval_effort, training_load, training_effect, anaerobic_training_effect, start_time, stop_time, elapsed_time, moving_time, distance, cycles, avg_hr, max_hr, avg_rr, max_rr, calories, avg_cadence, max_cadence, avg_speed, max_speed, ascent, descent, max_temperature, min_temperature, avg_temperature, start_lat, start_long, stop_lat, stop_long, hr_zones_method, hrz_1_hr, hrz_2_hr, hrz_3_hr, hrz_4_hr, hrz_5_hr, hrz_1_time, hrz_2_time, hrz_3_time, hrz_4_time, hrz_5_time
339 rows
activity_laps
activity_id, lap, start_time, stop_time, elapsed_time, moving_time, distance, cycles, avg_hr, max_hr, avg_rr, max_rr, calories, avg_cadence, max_cadence, avg_speed, max_speed, ascent, descent, max_temperature, min_temperature, avg_temperature, start_lat, start_long, stop_lat, stop_long, hr_zones_method, hrz_1_hr, hrz_2_hr, hrz_3_hr, hrz_4_hr, hrz_5_hr, hrz_1_time, hrz_2_time, hrz_3_time, hrz_4_time, hrz_5_time
1,706 rows
activity_records
activity_id, record, timestamp, position_lat, position_long, distance, cadence, altitude, hr, rr, speed, temperature
402,088 rows
activity_splits
activity_id, split, grade, completed, falls, start_time, stop_time, elapsed_time, moving_time, distance, cycles, avg_hr, max_hr, avg_rr, max_rr, calories, avg_cadence, max_cadence, avg_speed, max_speed, ascent, descent, max_temperature, min_temperature, avg_temperature, start_lat, start_long, stop_lat, stop_long, hr_zones_method, hrz_1_hr, hrz_2_hr, hrz_3_hr, hrz_4_hr, hrz_5_hr, hrz_1_time, hrz_2_time, hrz_3_time, hrz_4_time, hrz_5_time
12 rows
steps_activities
steps, avg_pace, avg_moving_pace, max_pace, avg_steps_per_min, max_steps_per_min, avg_step_length, avg_vertical_ratio, avg_vertical_oscillation, avg_gct_balance, avg_ground_contact_time, avg_stance_time_percent, vo2_max, activity_id
207 rows
Views
- steps_activities_view
- walking_activities_view
- running_activities_view
- hiking_activities_view
- paddle_activities_view
- cycle_activities_view
- climbing_activities_view
Download SQLite DB: james_garmin_activities.db 48.2 MB