A chronological list from your synced devices.Based on your Chrome browser version and options you’ll have: Google presents the saved data in a number of ways. Although it doesn’t store page contents, it captures the URL, favicon, page title, and timestamp of pages you’ve viewed. You might think of Google’s web history as an online audit trail of your web activity. And what is the meaning of transition INTEGER in visits table, can I extract the time from these, I need to get useful information from these tables, and make their relationship clear.When you use Google Chrome or other Google products, a log entry is made reflecting your actions such as a web query. So my problem are: is the urls table's first column called url_id represents in the visits table's second column called url INTEGER, but the relationship is not clear. So, another table called urls, which is also in this history sqlite is: CREATE TABLE 'urls'(id INTEGER PRIMARY KEY,url LONGVARCHAR,title LONGVARCHAR,visit_count INTEGER DEFAULT 0 NOT NULL,typed_count INTEGER DEFAULT 0 NOT NULL,last_visit_time INTEGER NOT NULL,hidden INTEGER DEFAULT 0 NOT NULL,favicon_id INTEGER DEFAULT 0 NOT NULL) So I find one table called visits in the history is: CREATE TABLE visits(id INTEGER PRIMARY KEY,url INTEGER NOT NULL,visit_time INTEGER NOT NULL,from_visit INTEGER,transition INTEGER DEFAULhT 0 NOT NULL,segment_id INTEGER,is_indexed BOOLEAN) I want to know the meaning of columns in tables. The data is from Chrome Google history file.

Google chrome history not clearing