google_activity_type_candidates
225 rows where "created_at" is on date 2021-03-01 sorted by id descending
This data as json, CSV (advanced)
id ▲ | created_at | updated_at | deleted_at | activity_segment_id | activity_type | probability |
---|---|---|---|---|---|---|
24387 | 2021-03-01 19:29:19.229085+03:00 | 2021-03-01 19:29:19.229085+03:00 | 4621 4621 | STILL | 2.1133024245500565 | |
24386 | 2021-03-01 19:29:19.229085+03:00 | 2021-03-01 19:29:19.229085+03:00 | 4621 4621 | IN_BUS | 5.065300315618515 | |
24385 | 2021-03-01 19:29:19.229085+03:00 | 2021-03-01 19:29:19.229085+03:00 | 4621 4621 | IN_TRAIN | 5.306672304868698 | |
24384 | 2021-03-01 19:29:19.229085+03:00 | 2021-03-01 19:29:19.229085+03:00 | 4621 4621 | WALKING | 11.779437959194183 | |
24383 | 2021-03-01 19:29:19.229085+03:00 | 2021-03-01 19:29:19.229085+03:00 | 4621 4621 | IN_SUBWAY | 71.69742584228516 | |
24382 | 2021-03-01 19:29:19.228191+03:00 | 2021-03-01 19:29:19.228191+03:00 | 4620 4620 | IN_VEHICLE | 0.0003898495833709603 | |
24381 | 2021-03-01 19:29:19.228191+03:00 | 2021-03-01 19:29:19.228191+03:00 | 4620 4620 | SAILING | 0.0020980007320758887 | |
24380 | 2021-03-01 19:29:19.228191+03:00 | 2021-03-01 19:29:19.228191+03:00 | 4620 4620 | IN_FERRY | 0.03194912860635668 | |
24379 | 2021-03-01 19:29:19.228191+03:00 | 2021-03-01 19:29:19.228191+03:00 | 4620 4620 | SKIING | 0.04397332377266139 | |
24378 | 2021-03-01 19:29:19.228191+03:00 | 2021-03-01 19:29:19.228191+03:00 | 4620 4620 | FLYING | 0.0642143131699413 | |
24377 | 2021-03-01 19:29:19.228191+03:00 | 2021-03-01 19:29:19.228191+03:00 | 4620 4620 | MOTORCYCLING | 0.1686843577772379 | |
24376 | 2021-03-01 19:29:19.228191+03:00 | 2021-03-01 19:29:19.228191+03:00 | 4620 4620 | RUNNING | 0.6386540364474058 | |
24375 | 2021-03-01 19:29:19.228191+03:00 | 2021-03-01 19:29:19.228191+03:00 | 4620 4620 | CYCLING | 0.8598523214459419 | |
24374 | 2021-03-01 19:29:19.228191+03:00 | 2021-03-01 19:29:19.228191+03:00 | 4620 4620 | IN_TRAIN | 1.0211849585175514 | |
24373 | 2021-03-01 19:29:19.228191+03:00 | 2021-03-01 19:29:19.228191+03:00 | 4620 4620 | IN_TRAM | 1.4089587144553661 | |
24372 | 2021-03-01 19:29:19.228191+03:00 | 2021-03-01 19:29:19.228191+03:00 | 4620 4620 | IN_PASSENGER_VEHICLE | 2.691522054374218 | |
24371 | 2021-03-01 19:29:19.228191+03:00 | 2021-03-01 19:29:19.228191+03:00 | 4620 4620 | STILL | 4.328266903758049 | |
24370 | 2021-03-01 19:29:19.228191+03:00 | 2021-03-01 19:29:19.228191+03:00 | 4620 4620 | IN_BUS | 7.065483927726746 | |
24369 | 2021-03-01 19:29:19.228191+03:00 | 2021-03-01 19:29:19.228191+03:00 | 4620 4620 | IN_SUBWAY | 17.8269624710083 | |
24368 | 2021-03-01 19:29:19.228191+03:00 | 2021-03-01 19:29:19.228191+03:00 | 4620 4620 | WALKING | 63.84780406951904 | |
24367 | 2021-03-01 19:29:19.227338+03:00 | 2021-03-01 19:29:19.227338+03:00 | 4619 4619 | IN_VEHICLE | 0.00010040851066150935 | |
24366 | 2021-03-01 19:29:19.227338+03:00 | 2021-03-01 19:29:19.227338+03:00 | 4619 4619 | SAILING | 0.011726153024937958 | |
24365 | 2021-03-01 19:29:19.227338+03:00 | 2021-03-01 19:29:19.227338+03:00 | 4619 4619 | FLYING | 0.036213453859090805 | |
24364 | 2021-03-01 19:29:19.227338+03:00 | 2021-03-01 19:29:19.227338+03:00 | 4619 4619 | SKIING | 0.0555385195184499 | |
24363 | 2021-03-01 19:29:19.227338+03:00 | 2021-03-01 19:29:19.227338+03:00 | 4619 4619 | IN_FERRY | 0.11934705544263124 | |
24362 | 2021-03-01 19:29:19.227338+03:00 | 2021-03-01 19:29:19.227338+03:00 | 4619 4619 | MOTORCYCLING | 0.2249885117635131 | |
24361 | 2021-03-01 19:29:19.227338+03:00 | 2021-03-01 19:29:19.227338+03:00 | 4619 4619 | IN_TRAIN | 0.4336889833211899 | |
24360 | 2021-03-01 19:29:19.227338+03:00 | 2021-03-01 19:29:19.227338+03:00 | 4619 4619 | IN_TRAM | 0.5265606101602316 | |
24359 | 2021-03-01 19:29:19.227338+03:00 | 2021-03-01 19:29:19.227338+03:00 | 4619 4619 | RUNNING | 0.808299146592617 | |
24358 | 2021-03-01 19:29:19.227338+03:00 | 2021-03-01 19:29:19.227338+03:00 | 4619 4619 | IN_SUBWAY | 1.3290752656757832 | |
24357 | 2021-03-01 19:29:19.227338+03:00 | 2021-03-01 19:29:19.227338+03:00 | 4619 4619 | IN_BUS | 2.075209654867649 | |
24356 | 2021-03-01 19:29:19.227338+03:00 | 2021-03-01 19:29:19.227338+03:00 | 4619 4619 | CYCLING | 2.1416306495666504 | |
24355 | 2021-03-01 19:29:19.227338+03:00 | 2021-03-01 19:29:19.227338+03:00 | 4619 4619 | IN_PASSENGER_VEHICLE | 3.9177849888801575 | |
24354 | 2021-03-01 19:29:19.227338+03:00 | 2021-03-01 19:29:19.227338+03:00 | 4619 4619 | STILL | 5.825493484735489 | |
24353 | 2021-03-01 19:29:19.227338+03:00 | 2021-03-01 19:29:19.227338+03:00 | 4619 4619 | WALKING | 82.49434232711792 | |
24352 | 2021-03-01 19:29:19.226487+03:00 | 2021-03-01 19:29:19.226487+03:00 | 4618 4618 | IN_VEHICLE | 0.0003413204467506148 | |
24351 | 2021-03-01 19:29:19.226487+03:00 | 2021-03-01 19:29:19.226487+03:00 | 4618 4618 | SKIING | 0.006763348210370168 | |
24350 | 2021-03-01 19:29:19.226487+03:00 | 2021-03-01 19:29:19.226487+03:00 | 4618 4618 | SAILING | 0.009832075738813728 | |
24349 | 2021-03-01 19:29:19.226487+03:00 | 2021-03-01 19:29:19.226487+03:00 | 4618 4618 | MOTORCYCLING | 0.058633723529055715 | |
24348 | 2021-03-01 19:29:19.226487+03:00 | 2021-03-01 19:29:19.226487+03:00 | 4618 4618 | FLYING | 0.11124492157250643 | |
24347 | 2021-03-01 19:29:19.226487+03:00 | 2021-03-01 19:29:19.226487+03:00 | 4618 4618 | RUNNING | 0.11338669573888183 | |
24346 | 2021-03-01 19:29:19.226487+03:00 | 2021-03-01 19:29:19.226487+03:00 | 4618 4618 | IN_FERRY | 0.1463014166802168 | |
24345 | 2021-03-01 19:29:19.226487+03:00 | 2021-03-01 19:29:19.226487+03:00 | 4618 4618 | IN_TRAIN | 0.2352184383198619 | |
24344 | 2021-03-01 19:29:19.226487+03:00 | 2021-03-01 19:29:19.226487+03:00 | 4618 4618 | IN_TRAM | 0.2561957808211446 | |
24343 | 2021-03-01 19:29:19.226487+03:00 | 2021-03-01 19:29:19.226487+03:00 | 4618 4618 | IN_SUBWAY | 0.29064654372632504 | |
24342 | 2021-03-01 19:29:19.226487+03:00 | 2021-03-01 19:29:19.226487+03:00 | 4618 4618 | CYCLING | 0.31825255136936903 | |
24341 | 2021-03-01 19:29:19.226487+03:00 | 2021-03-01 19:29:19.226487+03:00 | 4618 4618 | IN_BUS | 1.9983457401394844 | |
24340 | 2021-03-01 19:29:19.226487+03:00 | 2021-03-01 19:29:19.226487+03:00 | 4618 4618 | IN_PASSENGER_VEHICLE | 9.790816903114319 | |
24339 | 2021-03-01 19:29:19.226487+03:00 | 2021-03-01 19:29:19.226487+03:00 | 4618 4618 | STILL | 10.991179198026657 | |
24338 | 2021-03-01 19:29:19.226487+03:00 | 2021-03-01 19:29:19.226487+03:00 | 4618 4618 | WALKING | 75.67284107208252 | |
24337 | 2021-03-01 19:29:19.225509+03:00 | 2021-03-01 19:29:19.225509+03:00 | 4617 4617 | IN_VEHICLE | 0.00016817756431919406 | |
24336 | 2021-03-01 19:29:19.225509+03:00 | 2021-03-01 19:29:19.225509+03:00 | 4617 4617 | SAILING | 0.0043256659409962595 | |
24335 | 2021-03-01 19:29:19.225509+03:00 | 2021-03-01 19:29:19.225509+03:00 | 4617 4617 | SKIING | 0.013479973131325096 | |
24334 | 2021-03-01 19:29:19.225509+03:00 | 2021-03-01 19:29:19.225509+03:00 | 4617 4617 | RUNNING | 0.037678005173802376 | |
24333 | 2021-03-01 19:29:19.225509+03:00 | 2021-03-01 19:29:19.225509+03:00 | 4617 4617 | IN_FERRY | 0.05667313816957176 | |
24332 | 2021-03-01 19:29:19.225509+03:00 | 2021-03-01 19:29:19.225509+03:00 | 4617 4617 | FLYING | 0.1018963404931128 | |
24331 | 2021-03-01 19:29:19.225509+03:00 | 2021-03-01 19:29:19.225509+03:00 | 4617 4617 | CYCLING | 0.1608717255294323 | |
24330 | 2021-03-01 19:29:19.225509+03:00 | 2021-03-01 19:29:19.225509+03:00 | 4617 4617 | MOTORCYCLING | 0.38679810240864754 | |
24329 | 2021-03-01 19:29:19.225509+03:00 | 2021-03-01 19:29:19.225509+03:00 | 4617 4617 | IN_TRAM | 0.43317507952451706 | |
24328 | 2021-03-01 19:29:19.225509+03:00 | 2021-03-01 19:29:19.225509+03:00 | 4617 4617 | IN_TRAIN | 0.740010105073452 | |
24327 | 2021-03-01 19:29:19.225509+03:00 | 2021-03-01 19:29:19.225509+03:00 | 4617 4617 | IN_SUBWAY | 3.45674529671669 | |
24326 | 2021-03-01 19:29:19.225509+03:00 | 2021-03-01 19:29:19.225509+03:00 | 4617 4617 | STILL | 4.3831538408994675 | |
24325 | 2021-03-01 19:29:19.225509+03:00 | 2021-03-01 19:29:19.225509+03:00 | 4617 4617 | WALKING | 12.357146292924881 | |
24324 | 2021-03-01 19:29:19.225509+03:00 | 2021-03-01 19:29:19.225509+03:00 | 4617 4617 | IN_BUS | 15.077054500579834 | |
24323 | 2021-03-01 19:29:19.225509+03:00 | 2021-03-01 19:29:19.225509+03:00 | 4617 4617 | IN_PASSENGER_VEHICLE | 62.790822982788086 | |
24322 | 2021-03-01 19:29:19.223744+03:00 | 2021-03-01 19:29:19.223744+03:00 | 4616 4616 | IN_VEHICLE | 0.00023131483430915978 | |
24321 | 2021-03-01 19:29:19.223744+03:00 | 2021-03-01 19:29:19.223744+03:00 | 4616 4616 | SAILING | 0.006503491022158414 | |
24320 | 2021-03-01 19:29:19.223744+03:00 | 2021-03-01 19:29:19.223744+03:00 | 4616 4616 | RUNNING | 0.021203413780312985 | |
24319 | 2021-03-01 19:29:19.223744+03:00 | 2021-03-01 19:29:19.223744+03:00 | 4616 4616 | SKIING | 0.033604647614993155 | |
24318 | 2021-03-01 19:29:19.223744+03:00 | 2021-03-01 19:29:19.223744+03:00 | 4616 4616 | CYCLING | 0.052096531726419926 | |
24317 | 2021-03-01 19:29:19.223744+03:00 | 2021-03-01 19:29:19.223744+03:00 | 4616 4616 | IN_TRAM | 0.14869750011712313 | |
24316 | 2021-03-01 19:29:19.223744+03:00 | 2021-03-01 19:29:19.223744+03:00 | 4616 4616 | IN_FERRY | 0.23696941789239645 | |
24315 | 2021-03-01 19:29:19.223744+03:00 | 2021-03-01 19:29:19.223744+03:00 | 4616 4616 | MOTORCYCLING | 0.303694698959589 | |
24314 | 2021-03-01 19:29:19.223744+03:00 | 2021-03-01 19:29:19.223744+03:00 | 4616 4616 | FLYING | 1.7468204721808434 | |
24313 | 2021-03-01 19:29:19.223744+03:00 | 2021-03-01 19:29:19.223744+03:00 | 4616 4616 | IN_BUS | 7.8632161021232605 | |
24312 | 2021-03-01 19:29:19.223744+03:00 | 2021-03-01 19:29:19.223744+03:00 | 4616 4616 | IN_TRAIN | 12.434685230255127 | |
24311 | 2021-03-01 19:29:19.223744+03:00 | 2021-03-01 19:29:19.223744+03:00 | 4616 4616 | IN_SUBWAY | 13.827194273471832 | |
24310 | 2021-03-01 19:29:19.223744+03:00 | 2021-03-01 19:29:19.223744+03:00 | 4616 4616 | STILL | 16.62028133869171 | |
24309 | 2021-03-01 19:29:19.223744+03:00 | 2021-03-01 19:29:19.223744+03:00 | 4616 4616 | WALKING | 22.320562601089478 | |
24308 | 2021-03-01 19:29:19.223744+03:00 | 2021-03-01 19:29:19.223744+03:00 | 4616 4616 | IN_PASSENGER_VEHICLE | 24.384233355522156 | |
24307 | 2021-03-01 19:29:19.222862+03:00 | 2021-03-01 19:29:19.222862+03:00 | 4615 4615 | IN_VEHICLE | 0.0002712879677346791 | |
24306 | 2021-03-01 19:29:19.222862+03:00 | 2021-03-01 19:29:19.222862+03:00 | 4615 4615 | RUNNING | 0.008292181883007288 | |
24305 | 2021-03-01 19:29:19.222862+03:00 | 2021-03-01 19:29:19.222862+03:00 | 4615 4615 | SAILING | 0.010928703704848886 | |
24304 | 2021-03-01 19:29:19.222862+03:00 | 2021-03-01 19:29:19.222862+03:00 | 4615 4615 | SKIING | 0.011097583774244413 | |
24303 | 2021-03-01 19:29:19.222862+03:00 | 2021-03-01 19:29:19.222862+03:00 | 4615 4615 | CYCLING | 0.02910046896431595 | |
24302 | 2021-03-01 19:29:19.222862+03:00 | 2021-03-01 19:29:19.222862+03:00 | 4615 4615 | IN_TRAM | 0.10781829478219151 | |
24301 | 2021-03-01 19:29:19.222862+03:00 | 2021-03-01 19:29:19.222862+03:00 | 4615 4615 | MOTORCYCLING | 0.20320129115134478 | |
24300 | 2021-03-01 19:29:19.222862+03:00 | 2021-03-01 19:29:19.222862+03:00 | 4615 4615 | IN_FERRY | 0.4566648509353399 | |
24299 | 2021-03-01 19:29:19.222862+03:00 | 2021-03-01 19:29:19.222862+03:00 | 4615 4615 | IN_BUS | 5.320939049124718 | |
24298 | 2021-03-01 19:29:19.222862+03:00 | 2021-03-01 19:29:19.222862+03:00 | 4615 4615 | WALKING | 5.6959133595228195 | |
24297 | 2021-03-01 19:29:19.222862+03:00 | 2021-03-01 19:29:19.222862+03:00 | 4615 4615 | STILL | 7.1688540279865265 | |
24296 | 2021-03-01 19:29:19.222862+03:00 | 2021-03-01 19:29:19.222862+03:00 | 4615 4615 | IN_SUBWAY | 9.542573243379593 | |
24295 | 2021-03-01 19:29:19.222862+03:00 | 2021-03-01 19:29:19.222862+03:00 | 4615 4615 | IN_PASSENGER_VEHICLE | 14.983683824539185 | |
24294 | 2021-03-01 19:29:19.222862+03:00 | 2021-03-01 19:29:19.222862+03:00 | 4615 4615 | FLYING | 20.9058478474617 | |
24293 | 2021-03-01 19:29:19.222862+03:00 | 2021-03-01 19:29:19.222862+03:00 | 4615 4615 | IN_TRAIN | 35.55481731891632 | |
24292 | 2021-03-01 19:29:19.221949+03:00 | 2021-03-01 19:29:19.221949+03:00 | 4614 4614 | IN_VEHICLE | 1.5218266469219088e-05 | |
24291 | 2021-03-01 19:29:19.221949+03:00 | 2021-03-01 19:29:19.221949+03:00 | 4614 4614 | IN_TRAM | 5.9861321233256604e-05 | |
24290 | 2021-03-01 19:29:19.221949+03:00 | 2021-03-01 19:29:19.221949+03:00 | 4614 4614 | CYCLING | 0.0034298158425372094 | |
24289 | 2021-03-01 19:29:19.221949+03:00 | 2021-03-01 19:29:19.221949+03:00 | 4614 4614 | RUNNING | 0.006831376231275499 | |
24288 | 2021-03-01 19:29:19.221949+03:00 | 2021-03-01 19:29:19.221949+03:00 | 4614 4614 | SKIING | 0.012550073734018952 |
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`);