15 rows where activity_segment_id = 4615

View and edit SQL

Suggested facets: updated_at (date)

created_at (date)

id ▼ created_at updated_at deleted_at activity_segment_id activity_type probability
24293 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 IN_TRAIN 35.55481731891632
24294 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 FLYING 20.9058478474617
24295 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 IN_PASSENGER_VEHICLE 14.983683824539185
24296 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 IN_SUBWAY 9.542573243379593
24297 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 STILL 7.1688540279865265
24298 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 WALKING 5.6959133595228195
24299 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 IN_BUS 5.320939049124718
24300 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 IN_FERRY 0.4566648509353399
24301 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 MOTORCYCLING 0.20320129115134478
24302 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 IN_TRAM 0.10781829478219151
24303 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 CYCLING 0.02910046896431595
24304 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 SKIING 0.011097583774244413
24305 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 SAILING 0.010928703704848886
24306 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 RUNNING 0.008292181883007288
24307 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 IN_VEHICLE 0.0002712879677346791

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