![Firefox logo](https://assets-prod.sumo.prod.webservices.mozgcp.net/media/uploads/products/2020-04-14-08-36-13-8dda6f.png)
Can I access all dates that a website has been visited?
I have been utilizing the History function to see when a page was last visited and how many times it has been visited.
I would like to see every instance of when I have visited a page. For example, I have visited google.com 27 times in the last month; I can see that I last visited google.com yesterday. But, I would like to see a list of every date/time that I visited google.com in the past month.
Is this possible?
Thanks for your help.
All Replies (2)
- Go to the History menu and select "Show all History"
- In the Library window that opens, select this month on the left side to filter your history items to just those from this month.
- Then type google in the search bar (upper-right) to further filter the results to just google visits this month.
I've attached a screenshot of what it looks like on my Mac. It looks basically the same on Windows XP.
Firefox only shows the last time that you've visited an URL and a visit count.
You will have to use the SQLite Manager extension to see all visit dates.
You can use this query and change url LIKE '%google.com%' to the URL that you want to check.
A percent symbol ("%") in the LIKE pattern matches any sequence of zero or more characters in the string.
- SQLite Manager: https://addons.mozilla.org/firefox/addon/sqlite-manager/
- Open Profile Directory -> places.sqlite -> Go
- Hit the Execute SQL tab
- Use a Select like this:
SELECT datetime(visit_date/1000000,'unixepoch') AS visit_date, url, title FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id AND url LIKE '%google.com%'
- Click Run SQL to generate a results list
- Click the Action button to Save the results to a CSV file
See also:
- A percent symbol ("%") in the LIKE pattern matches any sequence of zero or more characters in the string
- An underscore ("_") in the LIKE pattern matches any single character in the string
- Any other character matches itself or its lower/upper case equivalent (i.e. case-insensitive matching)
cor-el moo ko soppali ci