activity_records

529,626 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timestamp (date)

Next page

CREATE TABLE activity_records (
	activity_id VARCHAR NOT NULL, 
	record INTEGER NOT NULL, 
	timestamp DATETIME, 
	position_lat FLOAT, 
	position_long FLOAT, 
	distance FLOAT, 
	cadence INTEGER, 
	altitude FLOAT, 
	hr INTEGER, 
	rr FLOAT, 
	speed FLOAT, 
	temperature FLOAT, 
	PRIMARY KEY (activity_id, record), 
	FOREIGN KEY(activity_id) REFERENCES activities (activity_id)
);