15 rows where activity_type = "FLYING" sorted by probability

View and edit SQL

created_at (date)

activity_type

  • FLYING · 3
id created_at updated_at deleted_at activity_segment_id activity_type probability ▼
24314 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 FLYING 1.7468204721808434
24294 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 FLYING 20.9058478474617
24278 2021-03-01 19:29:19.221949+03:00 2021-03-01 19:29:19.221949+03:00   4614 4614 FLYING 70.54623365402222

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