15 rows where activity_segment_id = 4617 sorted by updated_at

View and edit SQL

Suggested facets: updated_at (date)

created_at (date)

activity_segment_id

  • 4617 · 15
id created_at updated_at ▼ deleted_at activity_segment_id activity_type probability
24323 2021-03-01 19:29:19.225509+03:00 2021-03-01 19:29:19.225509+03:00   4617 4617 IN_PASSENGER_VEHICLE 62.790822982788086
24324 2021-03-01 19:29:19.225509+03:00 2021-03-01 19:29:19.225509+03:00   4617 4617 IN_BUS 15.077054500579834
24325 2021-03-01 19:29:19.225509+03:00 2021-03-01 19:29:19.225509+03:00   4617 4617 WALKING 12.357146292924881
24326 2021-03-01 19:29:19.225509+03:00 2021-03-01 19:29:19.225509+03:00   4617 4617 STILL 4.3831538408994675
24327 2021-03-01 19:29:19.225509+03:00 2021-03-01 19:29:19.225509+03:00   4617 4617 IN_SUBWAY 3.45674529671669
24328 2021-03-01 19:29:19.225509+03:00 2021-03-01 19:29:19.225509+03:00   4617 4617 IN_TRAIN 0.740010105073452
24329 2021-03-01 19:29:19.225509+03:00 2021-03-01 19:29:19.225509+03:00   4617 4617 IN_TRAM 0.43317507952451706
24330 2021-03-01 19:29:19.225509+03:00 2021-03-01 19:29:19.225509+03:00   4617 4617 MOTORCYCLING 0.38679810240864754
24331 2021-03-01 19:29:19.225509+03:00 2021-03-01 19:29:19.225509+03:00   4617 4617 CYCLING 0.1608717255294323
24332 2021-03-01 19:29:19.225509+03:00 2021-03-01 19:29:19.225509+03:00   4617 4617 FLYING 0.1018963404931128
24333 2021-03-01 19:29:19.225509+03:00 2021-03-01 19:29:19.225509+03:00   4617 4617 IN_FERRY 0.05667313816957176
24334 2021-03-01 19:29:19.225509+03:00 2021-03-01 19:29:19.225509+03:00   4617 4617 RUNNING 0.037678005173802376
24335 2021-03-01 19:29:19.225509+03:00 2021-03-01 19:29:19.225509+03:00   4617 4617 SKIING 0.013479973131325096
24336 2021-03-01 19:29:19.225509+03:00 2021-03-01 19:29:19.225509+03:00   4617 4617 SAILING 0.0043256659409962595
24337 2021-03-01 19:29:19.225509+03:00 2021-03-01 19:29:19.225509+03:00   4617 4617 IN_VEHICLE 0.00016817756431919406

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