15 rows where activity_type = "SKIING" sorted by id descending

View and edit SQL

Suggested facets: probability, updated_at (date)

created_at (date)

activity_type

  • SKIING · 15
id ▲ created_at updated_at deleted_at activity_segment_id activity_type probability
24483 2021-03-01 19:29:19.234837+03:00 2021-03-01 19:29:19.234837+03:00   4627 4627 SKIING 0.0191149563761428
24468 2021-03-01 19:29:19.233947+03:00 2021-03-01 19:29:19.233947+03:00   4626 4626 SKIING 0.0191149563761428
24455 2021-03-01 19:29:19.233069+03:00 2021-03-01 19:29:19.233069+03:00   4625 4625 SKIING 0.01444246299797669
24440 2021-03-01 19:29:19.232088+03:00 2021-03-01 19:29:19.232088+03:00   4624 4624 SKIING 0.03278239746578038
24425 2021-03-01 19:29:19.231227+03:00 2021-03-01 19:29:19.231227+03:00   4623 4623 SKIING 0.0018817585441865958
24409 2021-03-01 19:29:19.230208+03:00 2021-03-01 19:29:19.230208+03:00   4622 4622 SKIING 0.05662127514369786
24393 2021-03-01 19:29:19.229085+03:00 2021-03-01 19:29:19.229085+03:00   4621 4621 SKIING 0.06655905744992197
24379 2021-03-01 19:29:19.228191+03:00 2021-03-01 19:29:19.228191+03:00   4620 4620 SKIING 0.04397332377266139
24364 2021-03-01 19:29:19.227338+03:00 2021-03-01 19:29:19.227338+03:00   4619 4619 SKIING 0.0555385195184499
24351 2021-03-01 19:29:19.226487+03:00 2021-03-01 19:29:19.226487+03:00   4618 4618 SKIING 0.006763348210370168
24335 2021-03-01 19:29:19.225509+03:00 2021-03-01 19:29:19.225509+03:00   4617 4617 SKIING 0.013479973131325096
24319 2021-03-01 19:29:19.223744+03:00 2021-03-01 19:29:19.223744+03:00   4616 4616 SKIING 0.033604647614993155
24304 2021-03-01 19:29:19.222862+03:00 2021-03-01 19:29:19.222862+03:00   4615 4615 SKIING 0.011097583774244413
24288 2021-03-01 19:29:19.221949+03:00 2021-03-01 19:29:19.221949+03:00   4614 4614 SKIING 0.012550073734018952
24276 2021-03-01 19:29:19.220949+03:00 2021-03-01 19:29:19.220949+03:00   4613 4613 SKIING 0.0027651762138702907

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