15 rows where activity_segment_id = 4619 sorted by activity_type

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
24356 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 CYCLING 2.1416306495666504
24365 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 FLYING 0.036213453859090805
24357 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 IN_BUS 2.075209654867649
24363 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 IN_FERRY 0.11934705544263124
24355 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 IN_PASSENGER_VEHICLE 3.9177849888801575
24358 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 IN_SUBWAY 1.3290752656757832
24361 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 IN_TRAIN 0.4336889833211899
24360 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 IN_TRAM 0.5265606101602316
24367 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 IN_VEHICLE 0.00010040851066150935
24362 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 MOTORCYCLING 0.2249885117635131
24359 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 RUNNING 0.808299146592617
24366 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 SAILING 0.011726153024937958
24364 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 SKIING 0.0555385195184499
24354 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 STILL 5.825493484735489
24353 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 WALKING 82.49434232711792

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