15 rows where activity_segment_id = 4620 sorted by activity_segment_id

View and edit SQL

Suggested facets: updated_at (date)

created_at (date)

activity_segment_id

  • 4620 · 15
id created_at updated_at deleted_at activity_segment_id ▼ activity_type probability
24368 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 WALKING 63.84780406951904
24369 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 IN_SUBWAY 17.8269624710083
24370 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 IN_BUS 7.065483927726746
24371 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 STILL 4.328266903758049
24372 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 IN_PASSENGER_VEHICLE 2.691522054374218
24373 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 IN_TRAM 1.4089587144553661
24374 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 IN_TRAIN 1.0211849585175514
24375 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 CYCLING 0.8598523214459419
24376 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 RUNNING 0.6386540364474058
24377 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 MOTORCYCLING 0.1686843577772379
24378 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 FLYING 0.0642143131699413
24379 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 SKIING 0.04397332377266139
24380 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 IN_FERRY 0.03194912860635668
24381 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 SAILING 0.0020980007320758887
24382 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 IN_VEHICLE 0.0003898495833709603

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