15 rows where activity_segment_id = 4622 sorted by deleted_at

View and edit SQL

Suggested facets: updated_at (date)

created_at (date)

activity_segment_id

  • 4622 · 15
id created_at updated_at deleted_at ▼ activity_segment_id activity_type probability
24398 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 IN_SUBWAY 36.042264103889465
24399 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 IN_PASSENGER_VEHICLE 21.979746222496033
24400 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 WALKING 14.483098685741425
24401 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 IN_BUS 12.418162077665329
24402 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 STILL 8.760665357112885
24403 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 IN_TRAIN 2.73007582873106
24404 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 IN_TRAM 2.019175887107849
24405 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 MOTORCYCLING 0.6815705448389053
24406 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 CYCLING 0.6373894400894642
24407 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 RUNNING 0.09104401106014848
24408 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 FLYING 0.0600648985709995
24409 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 SKIING 0.05662127514369786
24410 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 IN_FERRY 0.038028587005101144
24411 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 SAILING 0.0017821317669586278
24412 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 IN_VEHICLE 0.0003131583298454643

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