Google chrome download history
If we examine the timestamp information from the visits table we can see they are not constructed in an Epoch format. This SQL statement extracts all the URLs the user visited alongside the visit count, type and timestamps. So we can construct a SQL statement to get some information about user browser habit: SELECT urls.url, urls.title, urls.visit_count, urls.typed_count, urls.last_visit_time, urls.hidden, visits.visit_time, om_visit, ansitionFROM urls, visitsWHERE urls.id = visits.url schema visitsĬREATE TABLE visits(id INTEGER PRIMARY KEY,url INTEGER NOT NULL,visit_time INTEGER NOT NULL,from_visit INTEGER,transition INTEGER DEFAULT 0 NOT NULL,segment_id INTEGER,is_indexed BOOLEAN) ĬREATE INDEX visits_from_index ON visits (from_visit) ĬREATE INDEX visits_time_index ON visits (visit_time) ĬREATE INDEX visits_url_index ON visits (url) schema urlsCREATE 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) CREATE INDEX urls_favicon_id_INDEX ON urls (favicon_id) CREATE INDEX urls_url_index ON urls (url) Īnd the visits table: sqlite>.
If we examine the urls table for instance by using sqlite3 we can see: sqlite>. The most relevant tables for browsing history are the "urls" table that contains all the visited URLs, the "visits" table that contains among other information about the type of visit and the timestamps and finally the "downloads" table that contains a list of downloaded files. The database file that contains the browsing history is stored under the Default folder as "History" and can be examined using any SQLlite browser there is (such as sqlite3).
There are two different versions of Google Chrome for Linux, the official packets distributed by Google, which stores its data in the google-chrome directory and the Linux distributions version Chromium.
#Google chrome download history windows#
Windows XP: C:\Documents and Settings\\Local Settings\Application Data\Google\Chrome\.Windows Vista (and Win 7): C:\Users\\AppData\Local\Google\Chrome\.Linux: /home/$USER/.config/google-chrome/.Yet the structure of the database file is quite different.Ĭhrome stores its files in the following locations: Google Chrome stores the browser history in a SQLite database, not unlike Firefox.