'SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1 AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (47485,47486)
)
) AND (
(
( wp_postmeta.meta_key = \'the_author\' AND wp_postmeta.meta_value = \'1151482\' )
OR
( wp_postmeta.meta_key = \'secondary_author\' AND wp_postmeta.meta_value LIKE \'{4025d54ff9731ffed21671f0bd93b235316fad22fc39dc5c64e9d9dacabda189}\\"1151482\\"{4025d54ff9731ffed21671f0bd93b235316fad22fc39dc5c64e9d9dacabda189}\' )
)
) AND wp_posts.post_type = \'post\' AND ((wp_posts.post_status = \'publish\'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 6'
The Billion Dollar-o-Gram 2009
This image arose out of frustration with media reporting of billion dollar amounts. That is, that they’re meaningless without context. But they’re continually reported as self-evident facts. 500 billion for this war. 50 billion for this pipeline. Literally mind-boggling amounts of money. So here we’ve scraped reported figures from The New York Times, The Guardian, and other news outlets and visualized them as a treemap (?). So you can see in one place figures that would otherwise be scattered across multiple news reports.
October 7, 2010
