1 row sorted by center_lat_e7

View and edit SQL

Suggested facets: updated_at (date), duration_start_timestamp_ms (date)

duration_end_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

CSV options:

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