When Google announced it was shutting down Google Video in 2011, that left untold numbers of videos in internet limbo. 

On this week’s Reveal, we are telling a very different kind of story: investigations into questions that might be inconsequential in the grand scheme of things but matter quite a bit to one person. We went looking for an old short film, made by Garrison Hayes, that disappeared when Google Video shut down.

During our investigation, we learned that a group of volunteers banded together to save millions of the videos and their metadata, and the Internet Archive donated storage. That means if you assumed your old videos are gone—you might be wrong. And we have instructions to help you check.

That data—including the Internet Archive URLs from which you can download your video—exists in a massive text file at archive.org. If you’re a programmer, you can use whatever scripting language you prefer to parse the text. Otherwise, the next steps are easiest if you are familiar with word processors.

  1. At the link, your download options are .7z or torrent. If you’re unfamiliar with torrents, you can download the .7z file, which is a compressed version (like .zip). Once you’ve extracted the file, you’ll find a CSV, but it’s too big to open in programs like Excel. The fastest option, if you aren’t a programmer, is to download a free integrated development environment (IDE) like Sublime Text, better suited for opening large files. Be warned that it’ll take a long time for the program to load the file.

Example:

https://web.archive.org/web/20041231235959id_/http://v1.cache5.googlevideo.com/videoplayback?id=5e903bf24b25e80d&itag=5&begin=0&ip=0.0.0.0&ipbits=0&expire=1309659155&sparams=ip,ipbits,expire,id,itag&signature=437990DFE530EA5FF22DDB2882240B5259AE749B.3C6C29148F23B4E28576C57014D57B7A0D500639&key=ck1&redirect_counter=1

A text editor window showing the contents of a CSV file and the search interface, with the search term 'cat' highlighted and a rectangle around the video URL.
This is what one line in the file looks like in Sublime Text, which is denoted as an individual line through the numbering in the left sidebar. Note that the search is not case sensitive by default. The text outlined in red is how a typical video URL appears.

You can also make a copy of this Google Sheets file and use it to automate the new complete URL. Double- or possibly triple-click the line of text for your video to easily get all of it, then copy and paste it into the first column. Just make sure you get the whole line (starting with a negative sign and a series of numbers) if you want the metadata like the email address, title, and description parsed!

Some notes about the archive:

About 92% of the videos have an associated date they were uploaded: Of these, all but two were uploaded between November 11, 2005 and October 26, 2010 (Google had stopped allowing upload before it ended hosting entirely). The last two were reportedly uploaded October 8, 2012 and February 4, 2011.

Melissa Lewis is a data reporter for Reveal. Her work has appeared in the Oregonian, the Los Angeles Times, and New York Times Magazine. She’s passionate about programming, data visualization, open source, Korean food, and libraries. You can reach her at mlewis@revealnews.org or via her website, melissa.news.

Ashley Cleek is a producer for Reveal. She helped develop and launch VICE News’ flagship podcast, VICE News Reports. As a reporter, she's worked with This American Life, VICE, NPR and Latino USA. Her work has won a national Edward R. Murrow Award, a Gracie Award, an International Documentary Association Award and a Third Coast award, and she was a 2020 Livingston Award finalist. She has reported stories across the American South, Turkey, Russia and India. Cleek is based in New York.