In order to poke my brain to remember a site I figured out how to hack my Chrome History, and learned that Webkit doesn’t use Unixtime. Rather, it uses a timestamp of microseconds since 1 Jan 1601.
Thus to convert from Webkit Format to a generic Unixtime, divide by a million to get seconds, then subtract the number of seconds between 1 Jan 1970 and 1 Jan 1601 (11644473600).
In order to retrieve your Chrome history for analysis within a spreadsheet, (and if you’re using OS X) do the following:
2) open using SQLLite Browser,
3) export table in question to CSV (in my case, `urls`)
4) open in Excel or Numbers
5) create column next to datetime you want to work with (`last_visit_time`)
6) apply this formula referencing the column in question =(CELL/1000000-11644473600)/60/60/24+”1 jan 1970″
7) …and set the column to ‘Custom’ = yyyy-mm-dd h:mm
Update June 29 2013: Reader Darlyn Perez wrote me to offer his Python script to convert a Webkit timestamp into a regular timestamp. As he says, “It basically does the same thing as the spreadsheet formula in your post.”
#!usr/bin/python
#Converts a Webkit timestamp (microseconds since Jan 1 1601) from keyboard input into a human-readable timestamp.
#Script by Darlyn Perez on 2013-06-29
import datetime
def date_from_webkit(webkit_timestamp):
epoch_start = datetime.datetime(1601,1,1)
delta = datetime.timedelta(microseconds=int(webkit_timestamp))
print epoch_start + delta
inTime = int(raw_input('Enter a Webkit timestamp to convert:'))
date_from_webkit(inTime)
I haven’t been that interested in the Pussy Riot trial, except to say going to jail has made their protest far more successful than it would have been if they’d been ignored. We’ve gotten used to ‘radicals’ doing something offensive and disappearing, but these girls performed a song, pissed off people enough to get arrested, forced Western journalists to compare their story to Soviet show trials, and ignited sympathetic protests around the world. When they get out of jail in two years they’ll be free-speech darlings and will probably have a widely successful global tour. If the point of their action was to highlight that Russia is intolerant of protest, then this whole story exemplifies that wonderfully.
However, Russia doesn’t care that Western people under the age of 40 who Tweet think this is outrageous. Reuters reports:
Valentina Ivanova, 60, a retired doctor, said outside the courtroom: “What they did showed disrespect towards everything, and towards believers first of all.”
A poll of Russians released by the independent Levada research group showed only 6 percent sympathized with the women and 51 percent found nothing good about them or felt irritation or hostility. The rest could not say or were indifferent.
I tend to think that our generation does in fact have such thinkers, only they’ve been hampered by structures designed to celebrate such already “brand name” established figures. Also, this generation’s thinkers are less likely to go through an academic publishing route, given the opportunities for self-publishing today.
Hints of “the Mechanism” in Alaistair Reynold’s Blue Remembered Earth appear until it actually becomes a plot element, where we learn precisely what it is. Essentially, by 2162, people have been enhanced, and interact with the data cloud via retinal implants and augmented reality. There is a major political system called the United Aquatic Nations, where people live in under-ocean cities, swim a lot, and where some have even undergone surgeries to make them into living mermaids. These people still use buttons and screens, as we do, but it seems this is mostly a necessity of their lifestyle choice.
Because of the constant, internalized connection, people generate a massive amount of data which needs to be indexed (via posterity engines), while it is also being monitored. The Mechanism is the set of algorithms which constantly monitor the data stream, and intervene if signals indicate a certain action is underway, or about to be. When Geoffrey, a main character, gets so angry we wants to hit someone, the Mechanism recognizes this and strikes him with an instant debilitating headache. (p.283) The incident is logged, and he is then scheduled for a visit by a risk-assessment team to determine the seriousness of the matter.
It is known as The Surveilled World.
•
I recall being a child, going through a Catholic education, and realizing that according to the teaching, God could hear my thoughts. I felt exposed, my privacy violated, and embarrassed. Was there no respite from scrutiny?
Twenty-five years later, I visited the Cloisters, the reconstructed (and frankensteined) medieval complex in New York. Throughout we see little heads gazing down from sculpted elements – these essentially are the medieval version of our black domed cameras, a reminder to the monks of eight-hundred years ago that they were constantly being watched, by a security apparatus of angels.
It seems then, that we have some social need to construct surrogate parental oversight. That a society without watchers – a secularized society that doesn’t believe in spiritual spies and one without CCTV cameras (essentially the Western world for about a hundred and fifty years) cannot exist without engendering existential angst (as seemingly happened).
Speaking of the social upheavals of the mid 21st Century, the character Eunice describes its development:
The warming was global, but Africa was one of the first places to really feel the impact of the changing weather patterns. The depopulation programmes, the forced migrations … we were in the absolute vanguard of all that. In some respects, it was the moment the Surveilled World drew its first hesitant breath. We saw the best and worst of what we were capable of Geoffrey. The devils in us, and our better angels. The devils, mostly. Out of that time of crisis grew the global surveillance network, this invisible, omniscient god that never tires of watching over us, never tires of keeping us from doing harm to one another. Oh, it had been there in pieces before that, but this was the first time we devolved absolute authority to the Mechanism. And you know what? It wasn’t the worst thing that ever happened to us. We’re all living in a totalitarian state, but for the most part it’s a benign, kindly dictatorship. It allows us to do most things except suffer accidents and commit crimes. (p.150)
The quote continues:
“And now the surveilled world doesn’t even end at the edge of space. It’s a notion, a mode of existence, spreading out into the solar system at the same rate as the human expansion front. But these are still the early days. A century, what’s that? Do you think the effects of the 5.9 kilo year event only took a hundred years to be felt? These things play out over much longer timescales than that. Nearly 6000 years of one type of complex, highly organized society. Now a modal shift to something other. Complexity squared, or cubed. Where will we be in a thousand years, or six thousand?”
This is worth quoting in full since it hints at Alastair Reynold’s larger project: Blue Remembered Earth is merely the first novel of a planned trilogy, reported to span into the far future. I imagine the next book will take place centuries ahead, and be part of the answer to this speculation.
The referred to 5.9 kilo year event was a period of intense desertification occurring circa 3900 BCE which triggered worldwide migration to river valleys, from which emerged the first complex city-states. The character is suggesting that present climate-change is a similar event, which will drive us into new ways of living. In the book, one of these new ways is that of globalized surveillance, complete with a thought-control mechanism.
However, there is an area on the Moon that exists outside the Surveilled World, and Geoffry visits his sister Sunday there early on. They strolled through a market while Sunday explained social theories regarding crime as a necessity for innovation and social health. The chapter ends with Geoffrey reaching into his pocket for his hat, and finding it missing …
The hat, it began to dawn on him, had been stolen. The feeling of being a victim of crime was as novel and thrilling as being stopped in the street and kissed by a beautiful stranger. Things like that just didn’t happen back home. (p65)
The Mech then, is an interesting possibility about where we might be headed. The consequences of it are that, by 2162, there are no police forces and no jails. In the novel a news item is mentioned in passing about the demolition of the planet’s last jail, a facility in Mexico.
The author Elah Feder interviewed me about this at the Parkdale Tim Hortons two weeks ago.
“It’s people being lazy. They’re making their problem of having to throw something away, into my problem,” said Timothy Comeau, who’s gotten pretty frustrated with the coffee cups and other scraps of garbage he keeps finding in his rear-mounted milk crate. “I just find it really insulting.”
It’s an interesting effect, given that books have begun to have trailers produced by their publishing houses.
Neil Stephenson’s 2009 Anathem had a trailer…
…as did my latest favorite book (of which I’ve been writing about lately), Alastair Reynolds’ Blue Remembered Earth:
While B.R.E.’s‘ helped me understand what the book entailed, I was convinced by the Amazon Kindle’s sample chapter.
(For that matter, I bought Cloud Atlas at the end of December when I saw the concept art on io9.com, and got hooked by the sample chapter as well).
I have no information with regard to the trailers produced by the publishing houses having any impact. However, if they wanted to produce 6 minute masterpieces like the Cloud Atlas trailer (a distillation of imagery from a reported near 3-hour movie) then the form would come into its own.
This unintended effect generated by the Cloud Atlas trailer may convince them to do just that.
I love the idea of the mini-film being constructed out of choice scenes, of the quality that suggests an excerpt from a larger cinematic work.
Kind of like Franceso Vezzoli’s 2005 art-video, Trailer for a Remake of Gore Vidal’s Caligula
(Gotta love the Gladiator soundtrack. Also, how has this been on YouTube for two years?)
