15 rows where activity_type = "FLYING"

View and edit SQL

created_at (date)

activity_type

  • FLYING · 9
id ▼ created_at updated_at deleted_at activity_segment_id activity_type probability
24365 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 FLYING 0.036213453859090805
24378 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 FLYING 0.0642143131699413
24394 2021-03-01 19:29:19.229085+03:00 2021-03-01 19:29:19.229085+03:00   4621 4621 FLYING 0.057931430637836456
24408 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 FLYING 0.0600648985709995
24423 2021-03-01 19:29:19.231227+03:00 2021-03-01 19:29:19.231227+03:00   4623 4623 FLYING 0.020268421212676913
24439 2021-03-01 19:29:19.232088+03:00 2021-03-01 19:29:19.232088+03:00   4624 4624 FLYING 0.03740797401405871
24454 2021-03-01 19:29:19.233069+03:00 2021-03-01 19:29:19.233069+03:00   4625 4625 FLYING 0.02091389469569549
24469 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 FLYING 0.016966814291663468
24484 2021-03-01 19:29:19.234837+03:00 2021-03-01 19:29:19.234837+03:00   4627 4627 FLYING 0.016966814291663468

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