50 rows sorted by accuracy

View and edit SQL

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

id created_at updated_at deleted_at accuracy ▼ altitude heading latitude_e7 longitude_e7 time velocity vertical_accuracy
57568 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   9 167 328 557633086 375716308 2021-01-07 10:01:27.125+03:00 1 11
57532 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   13 164 282 557625270 375645207 2021-01-06 09:35:51.321+03:00 1 14
57536 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   13 129 337 557460988 376264853 2021-01-06 10:41:20.039+03:00 1 16
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
57576 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   13 144 343 557442235 376277077 2021-01-07 11:03:36.864+03:00 1 19
57535 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   14 135 311 557423403 376287833 2021-01-06 10:36:58.848+03:00 1 19
57573 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   14 159 279 557640311 375650785 2021-01-07 10:42:46.313+03:00 1 16
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
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
57562 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   17 163 203 557689576 375947868 2021-01-06 21:22:57.133+03:00 1 24
57563 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   17 156 200 557599083 375850472 2021-01-06 21:25:01.186+03:00 9 25
57579 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   17 138 302 557464075 376270592 2021-01-07 13:02:34.827+03:00 1 27
57580 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   17 127 95 557463742 376261118 2021-01-07 13:33:20.458+03:00 1 23
57552 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   18 161 10 557605820 376149646 2021-01-06 17:02:15.557+03:00 1 24
57531 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   20 155 284 557621038 375676685 2021-01-06 09:33:23.386+03:00 2 18
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
57548 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   21 146 39 557567057 376147888 2021-01-06 16:52:50.663+03:00 7 34
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
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
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
57554 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   24 155 325 557641227 376118506 2021-01-06 18:28:43.257+03:00 2 22
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
57543 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   29 132 283 557462282 376270625 2021-01-06 16:17:34.096+03:00 1 19
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
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
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
57556 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   44 161 75 557616440 375927355 2021-01-06 18:34:47.169+03:00 3 25
57561 2021-03-01 19:29:16.363823+03:00 2021-03-01 19:29:16.363823+03:00   56 166 59 557654220 375941079 2021-01-06 21:20:05.527+03:00 2 78
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
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
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
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
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
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
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
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
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
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

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