15 rows where activity_segment_id = 4616 sorted by updated_at

View and edit SQL

Suggested facets: created_at (date), updated_at (date)

id created_at updated_at ▼ deleted_at activity_segment_id activity_type probability
24308 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 IN_PASSENGER_VEHICLE 24.384233355522156
24309 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 WALKING 22.320562601089478
24310 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 STILL 16.62028133869171
24311 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 IN_SUBWAY 13.827194273471832
24312 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 IN_TRAIN 12.434685230255127
24313 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 IN_BUS 7.8632161021232605
24314 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 FLYING 1.7468204721808434
24315 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 MOTORCYCLING 0.303694698959589
24316 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 IN_FERRY 0.23696941789239645
24317 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 IN_TRAM 0.14869750011712313
24318 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 CYCLING 0.052096531726419926
24319 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 SKIING 0.033604647614993155
24320 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 RUNNING 0.021203413780312985
24321 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 SAILING 0.006503491022158414
24322 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 IN_VEHICLE 0.00023131483430915978

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE `google_activity_type_candidates` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`activity_segment_id` integer,`activity_type` text,`probability` real,PRIMARY KEY (`id`),CONSTRAINT `fk_google_activity_type_candidates_activity_segment` FOREIGN KEY (`activity_segment_id`) REFERENCES `google_activity_segments`(`id`),CONSTRAINT `fk_google_activity_segments_activities` FOREIGN KEY (`activity_segment_id`) REFERENCES `google_activity_segments`(`id`));
CREATE INDEX `idx_google_activity_type_candidates_deleted_at` ON `google_activity_type_candidates`(`deleted_at`);