This thread was archived. Please ask a new question if you need help.
Is there anyway I can see the first time I visited a certain website?
For example: Say I visit google.com for the first time on June 17, 2018 and today I want to see when I visited google for the first time, and see the date I did. Is there anyway to see this information?
All Replies (2)
As you know, Firefox's Library window only shows the date/time of the last visit, not the date/time of any earlier visits. This data is stored in Firefox (going back a certain amount of time), but in order to extract it, you would need to use an add-on or external program. I'm not familiar with programs for Mac, sorry.
Try this SQLite viewer and drop the places.sqlite file on the page..
Some older threads with possible SQLite code:
- [/questions/937585] Support for "Date first visited" for history items was removed from Firefox
- [/questions/931864] Can I access all dates that a website has been visited?
- [/questions/945090] How can i prevent Firefox from overiding identical history entries?
SELECT url, title, visit_count, datetime(first_visit/1000000,'unixepoch','localtime') AS EarliestVisit, datetime(last_visit_date/1000000,'unixepoch','localtime') AS LatestVisit FROM moz_places INNER JOIN (SELECT place_id, MIN(visit_date) AS first_visit FROM moz_historyvisits GROUP BY place_id) AS FirstVisits ON FirstVisits.place_id = moz_places.id WHERE url LIKE '%mozilla.org%' ORDER BY url