google_activity_type_candidates
225 rows sorted by created_at
This data as json, CSV (advanced)
created_at (date) ✖
- 2021-03-01 45
| id | created_at ▼ | updated_at | deleted_at | activity_segment_id | activity_type | probability |
|---|---|---|---|---|---|---|
| 24443 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | WALKING | 81.82005882263184 | |
| 24444 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | STILL | 8.773800730705261 | |
| 24445 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | IN_PASSENGER_VEHICLE | 5.030745640397072 | |
| 24446 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | CYCLING | 2.7286067605018616 | |
| 24447 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | RUNNING | 0.5103390663862228 | |
| 24448 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | IN_BUS | 0.43811663053929806 | |
| 24449 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | MOTORCYCLING | 0.17196076223626733 | |
| 24450 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | IN_SUBWAY | 0.1651554717682302 | |
| 24451 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | IN_TRAIN | 0.14408056158572435 | |
| 24452 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | IN_TRAM | 0.12326843570917845 | |
| 24453 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | IN_FERRY | 0.05134869716130197 | |
| 24454 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | FLYING | 0.02091389469569549 | |
| 24455 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | SKIING | 0.01444246299797669 | |
| 24456 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | SAILING | 0.007028732943581417 | |
| 24457 | 2021-03-01 19:29:19.233069+03:00 | 2021-03-01 19:29:19.233069+03:00 | 4625 4625 | IN_VEHICLE | 0.0001199278585772845 | |
| 24458 | 2021-03-01 19:29:19.233947+03:00 | 2021-03-01 19:29:19.233947+03:00 | 4626 4626 | IN_SUBWAY | 63.37483525276184 | |
| 24459 | 2021-03-01 19:29:19.233947+03:00 | 2021-03-01 19:29:19.233947+03:00 | 4626 4626 | WALKING | 23.247535526752472 | |
| 24460 | 2021-03-01 19:29:19.233947+03:00 | 2021-03-01 19:29:19.233947+03:00 | 4626 4626 | IN_TRAIN | 5.612520128488541 | |
| 24461 | 2021-03-01 19:29:19.233947+03:00 | 2021-03-01 19:29:19.233947+03:00 | 4626 4626 | STILL | 2.4516498669981956 | |
| 24462 | 2021-03-01 19:29:19.233947+03:00 | 2021-03-01 19:29:19.233947+03:00 | 4626 4626 | IN_BUS | 1.901007816195488 | |
| 24463 | 2021-03-01 19:29:19.233947+03:00 | 2021-03-01 19:29:19.233947+03:00 | 4626 4626 | IN_TRAM | 1.438759732991457 | |
| 24464 | 2021-03-01 19:29:19.233947+03:00 | 2021-03-01 19:29:19.233947+03:00 | 4626 4626 | IN_PASSENGER_VEHICLE | 1.2068763375282288 | |
| 24465 | 2021-03-01 19:29:19.233947+03:00 | 2021-03-01 19:29:19.233947+03:00 | 4626 4626 | CYCLING | 0.5288755521178246 | |
| 24466 | 2021-03-01 19:29:19.233947+03:00 | 2021-03-01 19:29:19.233947+03:00 | 4626 4626 | RUNNING | 0.0995732145383954 | |
| 24467 | 2021-03-01 19:29:19.233947+03:00 | 2021-03-01 19:29:19.233947+03:00 | 4626 4626 | MOTORCYCLING | 0.09170188568532467 | |
| 24468 | 2021-03-01 19:29:19.233947+03:00 | 2021-03-01 19:29:19.233947+03:00 | 4626 4626 | SKIING | 0.0191149563761428 | |
| 24469 | 2021-03-01 19:29:19.233947+03:00 | 2021-03-01 19:29:19.233947+03:00 | 4626 4626 | FLYING | 0.016966814291663468 | |
| 24470 | 2021-03-01 19:29:19.233947+03:00 | 2021-03-01 19:29:19.233947+03:00 | 4626 4626 | IN_FERRY | 0.009762389527168125 | |
| 24471 | 2021-03-01 19:29:19.233947+03:00 | 2021-03-01 19:29:19.233947+03:00 | 4626 4626 | SAILING | 0.0005598621555691352 | |
| 24472 | 2021-03-01 19:29:19.233947+03:00 | 2021-03-01 19:29:19.233947+03:00 | 4626 4626 | IN_VEHICLE | 0.00026624893507687375 | |
| 24473 | 2021-03-01 19:29:19.234837+03:00 | 2021-03-01 19:29:19.234837+03:00 | 4627 4627 | IN_SUBWAY | 63.37483525276184 | |
| 24474 | 2021-03-01 19:29:19.234837+03:00 | 2021-03-01 19:29:19.234837+03:00 | 4627 4627 | WALKING | 23.247535526752472 | |
| 24475 | 2021-03-01 19:29:19.234837+03:00 | 2021-03-01 19:29:19.234837+03:00 | 4627 4627 | IN_TRAIN | 5.612520128488541 | |
| 24476 | 2021-03-01 19:29:19.234837+03:00 | 2021-03-01 19:29:19.234837+03:00 | 4627 4627 | STILL | 2.4516498669981956 | |
| 24477 | 2021-03-01 19:29:19.234837+03:00 | 2021-03-01 19:29:19.234837+03:00 | 4627 4627 | IN_BUS | 1.901007816195488 | |
| 24478 | 2021-03-01 19:29:19.234837+03:00 | 2021-03-01 19:29:19.234837+03:00 | 4627 4627 | IN_TRAM | 1.438759732991457 | |
| 24479 | 2021-03-01 19:29:19.234837+03:00 | 2021-03-01 19:29:19.234837+03:00 | 4627 4627 | IN_PASSENGER_VEHICLE | 1.2068763375282288 | |
| 24480 | 2021-03-01 19:29:19.234837+03:00 | 2021-03-01 19:29:19.234837+03:00 | 4627 4627 | CYCLING | 0.5288755521178246 | |
| 24481 | 2021-03-01 19:29:19.234837+03:00 | 2021-03-01 19:29:19.234837+03:00 | 4627 4627 | RUNNING | 0.0995732145383954 | |
| 24482 | 2021-03-01 19:29:19.234837+03:00 | 2021-03-01 19:29:19.234837+03:00 | 4627 4627 | MOTORCYCLING | 0.09170188568532467 | |
| 24483 | 2021-03-01 19:29:19.234837+03:00 | 2021-03-01 19:29:19.234837+03:00 | 4627 4627 | SKIING | 0.0191149563761428 | |
| 24484 | 2021-03-01 19:29:19.234837+03:00 | 2021-03-01 19:29:19.234837+03:00 | 4627 4627 | FLYING | 0.016966814291663468 | |
| 24485 | 2021-03-01 19:29:19.234837+03:00 | 2021-03-01 19:29:19.234837+03:00 | 4627 4627 | IN_FERRY | 0.009762389527168125 | |
| 24486 | 2021-03-01 19:29:19.234837+03:00 | 2021-03-01 19:29:19.234837+03:00 | 4627 4627 | SAILING | 0.0005598621555691352 | |
| 24487 | 2021-03-01 19:29:19.234837+03:00 | 2021-03-01 19:29:19.234837+03:00 | 4627 4627 | IN_VEHICLE | 0.00026624893507687375 |
Advanced export
JSON shape: default, array, newline-delimited, object
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`);