google_activity_type_candidates

1 row where activity_segment_id = 4623 and activity_type = "IN_FERRY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: updated_at (date)

created_at (date) ✖

activity_type ✖

  • IN_FERRY · 1 ✖

activity_segment_id ✖

  • 4623 · 1 ✖
id ▼ created_at updated_at deleted_at activity_segment_id activity_type probability
24424 2021-03-01 19:29:19.231227+03:00 2021-03-01 19:29:19.231227+03:00   4623 4623 IN_FERRY 0.010890732664847746

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