15 rows where activity_segment_id = 4626 sorted by activity_segment_id

View and edit SQL

Suggested facets: updated_at (date)

created_at (date)

activity_segment_id

  • 4626 · 15
id created_at updated_at deleted_at activity_segment_id ▼ activity_type probability
24458 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 IN_SUBWAY 63.37483525276184
24459 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 WALKING 23.247535526752472
24460 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 IN_TRAIN 5.612520128488541
24461 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 STILL 2.4516498669981956
24462 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 IN_BUS 1.901007816195488
24463 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 IN_TRAM 1.438759732991457
24464 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 IN_PASSENGER_VEHICLE 1.2068763375282288
24465 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 CYCLING 0.5288755521178246
24466 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 RUNNING 0.0995732145383954
24467 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 MOTORCYCLING 0.09170188568532467
24468 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 SKIING 0.0191149563761428
24469 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 FLYING 0.016966814291663468
24470 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 IN_FERRY 0.009762389527168125
24471 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 SAILING 0.0005598621555691352
24472 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 IN_VEHICLE 0.00026624893507687375

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