15 rows where activity_segment_id = 4625 and "created_at" is on date 2021-03-01

View and edit SQL

Suggested facets: updated_at (date)

created_at (date)

  • 2021-03-01 · 15

activity_segment_id

  • 4625 · 15
id ▼ created_at updated_at deleted_at activity_segment_id activity_type probability
24443 2021-03-01 19:29:19.233069+03:00 2021-03-01 19:29:19.233069+03:00   4625 4625 WALKING 81.82005882263184
24444 2021-03-01 19:29:19.233069+03:00 2021-03-01 19:29:19.233069+03:00   4625 4625 STILL 8.773800730705261
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
24446 2021-03-01 19:29:19.233069+03:00 2021-03-01 19:29:19.233069+03:00   4625 4625 CYCLING 2.7286067605018616
24447 2021-03-01 19:29:19.233069+03:00 2021-03-01 19:29:19.233069+03:00   4625 4625 RUNNING 0.5103390663862228
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
24449 2021-03-01 19:29:19.233069+03:00 2021-03-01 19:29:19.233069+03:00   4625 4625 MOTORCYCLING 0.17196076223626733
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
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
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
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
24454 2021-03-01 19:29:19.233069+03:00 2021-03-01 19:29:19.233069+03:00   4625 4625 FLYING 0.02091389469569549
24455 2021-03-01 19:29:19.233069+03:00 2021-03-01 19:29:19.233069+03:00   4625 4625 SKIING 0.01444246299797669
24456 2021-03-01 19:29:19.233069+03:00 2021-03-01 19:29:19.233069+03:00   4625 4625 SAILING 0.007028732943581417
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

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`);