Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Is there anyway I can see the first time I visited a certain website?

  • 2 பதிலளிப்புகள்
  • 1 இந்த பிரச்சனை உள்ளது
  • 5 views
  • Last reply by cor-el

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?

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