google_activity_type_candidates
15 rows where activity_segment_id = 4625 sorted by id descending
This data as json, CSV (advanced)
updated_at (date) ✖
- 2021-03-01 15
created_at (date) ✖
- 2021-03-01 15
id ▲ | created_at | updated_at | deleted_at | activity_segment_id | activity_type | probability |
---|---|---|---|---|---|---|
24457 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | IN_VEHICLE | 0.0001199278585772845 | |
24456 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | SAILING | 0.007028732943581417 | |
24455 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | SKIING | 0.01444246299797669 | |
24454 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | FLYING | 0.02091389469569549 | |
24453 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | IN_FERRY | 0.05134869716130197 | |
24452 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | IN_TRAM | 0.12326843570917845 | |
24451 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | IN_TRAIN | 0.14408056158572435 | |
24450 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | IN_SUBWAY | 0.1651554717682302 | |
24449 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | MOTORCYCLING | 0.17196076223626733 | |
24448 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | IN_BUS | 0.43811663053929806 | |
24447 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | RUNNING | 0.5103390663862228 | |
24446 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | CYCLING | 2.7286067605018616 | |
24445 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | IN_PASSENGER_VEHICLE | 5.030745640397072 | |
24444 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | STILL | 8.773800730705261 | |
24443 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | WALKING | 81.82005882263184 |
Advanced export
JSON shape: default, array, newline-delimited, object
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`);