google_location_history

33 rows where velocity = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: accuracy, altitude, heading, vertical_accuracy, created_at (date), updated_at (date), time (date)

velocity ✖

id ▼ created_at updated_at deleted_at accuracy altitude heading latitude_e7 longitude_e7 time velocity vertical_accuracy
57533 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 163 0 557628059 375634482 2021-01-06 09:38:32.514+03:00 0 10
57534 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 156 0 557634610 375625009 2021-01-06 10:12:21.558+03:00 0 10
57537 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 126 0 557462679 376288682 2021-01-06 11:01:42.601+03:00 0 10
57538 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 126 0 557462641 376288653 2021-01-06 13:24:07.483+03:00 0 10
57539 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 126 0 557462778 376289401 2021-01-06 13:32:21.02+03:00 0 10
57540 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 127 0 557463019 376288947 2021-01-06 14:39:22.403+03:00 0 10
57541 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 129 0 557462710 376288949 2021-01-06 14:47:05.666+03:00 0 10
57542 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 126 0 557462655 376288897 2021-01-06 14:52:11.085+03:00 0 10
57544 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 136 0 557471821 376261826 2021-01-06 16:31:24.537+03:00 0 10
57545 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   103 132 0 557484488 376251530 2021-01-06 16:44:10.514+03:00 0 10
57546 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 137 0 557447199 376141511 2021-01-06 16:47:02.169+03:00 0 10
57547 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   30 153 138 557536245 376117837 2021-01-06 16:49:38.957+03:00 0 24
57549 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   24 161 35 557579659 376168551 2021-01-06 16:55:16.769+03:00 0 33
57550 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   29 161 328 557584808 376177071 2021-01-06 16:57:21.457+03:00 0 20
57551 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   29 152 332 557596518 376161858 2021-01-06 16:59:52.885+03:00 0 62
57553 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   27 161 52 557612527 376147117 2021-01-06 18:19:21.004+03:00 0 23
57555 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   23 163 158 557620090 376022286 2021-01-06 18:31:30.274+03:00 0 31
57557 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 160 0 557617862 375930115 2021-01-06 18:42:37.034+03:00 0 10
57558 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   16 161 16 557617418 375915669 2021-01-06 21:05:40.129+03:00 0 14
57559 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   30 160 11 557629391 375920906 2021-01-06 21:08:36.183+03:00 0 22
57560 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   68 163 53 557643549 375953943 2021-01-06 21:12:14.876+03:00 0 69
57564 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   20 0 0 557629964 375730026 2021-01-06 21:27:05.836+03:00 0 0
57565 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 156 0 557630505 375729355 2021-01-06 21:32:04.766+03:00 0 10
57566 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 157 0 557629900 375729938 2021-01-07 09:26:50.298+03:00 0 10
57567 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 157 0 557629253 375729160 2021-01-07 09:30:40.514+03:00 0 10
57569 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   21 162 266 557636710 375686163 2021-01-07 10:03:59.022+03:00 0 27
57570 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 167 0 557643086 375686985 2021-01-07 10:08:26.71+03:00 0 10
57571 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 168 0 557642785 375688045 2021-01-07 10:34:33.398+03:00 0 10
57572 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   13 163 90 557640095 375684453 2021-01-07 10:40:36.509+03:00 0 17
57574 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   71 157 93 557633932 375619063 2021-01-07 10:45:04.249+03:00 0 69
57575 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 139 0 557422969 376294815 2021-01-07 11:00:54.499+03:00 0 10
57577 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   15 133 315 557464808 376262823 2021-01-07 11:06:20.62+03:00 0 16
57578 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   65 127 0 557462839 376288551 2021-01-07 11:08:49.295+03:00 0 10

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE `google_location_history` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`accuracy` integer,`altitude` integer,`heading` integer,`latitude_e7` integer,`longitude_e7` integer,`time` datetime,`velocity` integer,`vertical_accuracy` integer,PRIMARY KEY (`id`));
CREATE UNIQUE INDEX `google_location_history_key` ON `google_location_history`(`latitude_e7`,`longitude_e7`,`time`);
CREATE INDEX `idx_google_location_history_deleted_at` ON `google_location_history`(`deleted_at`);