google_place_visits
1 row where "updated_at" is on date 2021-03-01 sorted by center_lat_e7
This data as json, CSV (advanced)
Suggested facets: duration_start_timestamp_ms (date)
created_at (date) ✖
id | created_at | updated_at | deleted_at | center_lat_e7 ▼ | center_lng_e7 | duration_end_timestamp_ms | duration_start_timestamp_ms | edit_confirmation_status | location_address | location_latitude_e7 | location_location_confidence | location_longitude_e7 | location_name | location_place_id | location_source_info_device_tag | place_confidence | visit_confidence | place_visit_id |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2021-03-01 19:29:14.803927+03:00 | 2021-03-01 19:29:14.803927+03:00 | 557504900 | 376543950 | 2014-11-13 11:21:20.462+03:00 | 2014-11-13 10:20:39.864+03:00 | NOT_CONFIRMED | Серебряническая наб., 29 Москва Россия 109028 | 557505241 | 9.819448 | 376540937 | Serebryanyy Gorod | ChIJ160cdvJKtUYRxHICl-Rskqk | 0 | LOW_CONFIDENCE | 77 | 0 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE `google_place_visits` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`center_lat_e7` integer,`center_lng_e7` integer,`duration_end_timestamp_ms` datetime,`duration_start_timestamp_ms` datetime,`edit_confirmation_status` text,`location_address` text,`location_latitude_e7` integer,`location_location_confidence` real,`location_longitude_e7` integer,`location_name` text,`location_place_id` text,`location_source_info_device_tag` integer,`place_confidence` text,`visit_confidence` integer,`place_visit_id` integer,PRIMARY KEY (`id`),CONSTRAINT `fk_google_place_visits_place_visit` FOREIGN KEY (`place_visit_id`) REFERENCES `google_place_visits`(`id`),CONSTRAINT `fk_google_place_visits_child_visits` FOREIGN KEY (`place_visit_id`) REFERENCES `google_place_visits`(`id`)); CREATE INDEX `idx_google_place_visits_deleted_at` ON `google_place_visits`(`deleted_at`); CREATE UNIQUE INDEX `google_place_visits_key` ON `google_place_visits`(`center_lat_e7`,`center_lng_e7`,`duration_end_timestamp_ms`,`duration_start_timestamp_ms`,`location_place_id`);