Crowdsourced Study on Political Blogs
by Patrick Ruffini :: October 21st, 2007 10:58 pmLast week, tech bloggers compiled Google Reader subscriber data to build a compelling ranking of actual influence in the tech sphere.
I would like to do the same for political blogs, but I need your help.
I’ve started plugging in data in this Google spreadsheet, but the task before me is so massive that I can only hope to have a comprehensive data set by crowdsourcing it. Basically, for any given blog, I need you to look up two things: number of subscribers in Google Reader, and in Bloglines. You don’t have to look up many blogs — just the ones you read up and down the tail. I’m also interested in local bloggers and lefty bloggers.
Once we’re done collecting the data (though will we ever be done… really?), we’ll have a model of blogosphere influence that’s arguably better than traffic numbers or inbound links, giving us a reliable measure of how many readers reward any given blogger with prize position in their feedreader.
To join in, please email me and give me your Google account email address. Or better yet, contact me through Facebook or LinkedIn so I’ll know you’re a trusted user.
The sheet has specific instructions on what to do.
In the end, I’m hoping to aggregate this data on hundreds (if not thousands?) of political blogs, and keep the data open for anyone to view or edit, including academics, PR professionals, and general students of the blogosphere.
Can you join in?
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)]
Tagged: announcements 
blogosphere
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 (480)
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 (480)
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 (480)
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 (480)
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 (480)
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 (480)
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 = '480' AND comment_approved = '1' ORDER BY comment_date
