Radiohead Republicans
by Patrick Ruffini :: October 26th, 2007 6:19 pmThere just aren’t that many of them.
But there are plenty more interested in the Bible, Country music, Sportscenter, watching 24, and playing Halo 3 on their Xbox.
Meanwhile, liberals watch the Daily Show, love Radiohead (by a 6-to-1 margin over conservatives), and let’s just say I like who Stephen Colbert takes votes from.
This is all part of my deep dive into Facebook demographic data provided at by the Flyers Pro advertising engine. . I’ve just updated the spreadsheet. (See part I of this series for more.) The data looks like this:
I’ve also added another column for the percentage of people who specify an ideology (this isn’t perfect since Libertarians are excluded). This is a proxy for how interested politically you are.
The most politically jazzed up constituency are those who say they’re interested in politics (78%), followed by West Wing fans (72%), Capitol Hill staffers (69%), and Daily Show viewers (65%). The least? Those who work at Microsoft, Yahoo, and Google (in the 30s).
People who specify “Politics” as an interest in are 53-25% liberal over conservative as compared to a 9 point liberal lead on the Facebook network.
But Britney Spears fans are 49% to 26% liberal.
If you find this data fascinating and want to help build on it, log into Facebook, go to this page (note: you can only get stats as a Facebook member), and plug in what ever common interest (movie, TV show, pastime, whatever) in the keyword field. Jot down four data points, starting with the number of people who match that interest overall, and the numbers that appear when you tick off the Liberal, Moderate, and Conservative checkboxes. Then post it in the comments.
Could Facebook be the greatest microtargeting engine ever built?
WordPress database error: [Can't open file: 'prwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'prwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'prwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'prwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'prwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'prwp_comments.MYD'. (errno: 144)]
![]()
Comments (
SELECT ID, COUNT( comment_ID ) AS ccount
FROM prwp_posts
LEFT JOIN prwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='')
WHERE post_status = 'publish' AND ID IN (486)
GROUP BY ID
SELECT ID, COUNT( comment_ID ) AS ccount
FROM prwp_posts
LEFT JOIN prwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='pingback')
WHERE post_status = 'publish' AND ID IN (486)
GROUP BY ID
SELECT ID, COUNT( comment_ID ) AS ccount
FROM prwp_posts
LEFT JOIN prwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='trackback')
WHERE post_status = 'publish' AND ID IN (486)
GROUP BY ID
Trackbacks (
SELECT ID, COUNT( comment_ID ) AS ccount
FROM prwp_posts
LEFT JOIN prwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='')
WHERE post_status = 'publish' AND ID IN (486)
GROUP BY ID
SELECT ID, COUNT( comment_ID ) AS ccount
FROM prwp_posts
LEFT JOIN prwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='pingback')
WHERE post_status = 'publish' AND ID IN (486)
GROUP BY ID
SELECT ID, COUNT( comment_ID ) AS ccount
FROM prwp_posts
LEFT JOIN prwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='trackback')
WHERE post_status = 'publish' AND ID IN (486)
GROUP BY ID
del.icio.us
digg it
subscribe
Both comments and pings are currently closed.
WordPress database error: [Can't open file: 'prwp_comments.MYD'. (errno: 144)]
SELECT * FROM prwp_comments WHERE comment_post_ID = '486' AND comment_approved = '1' ORDER BY comment_date



















