Twittering Philly
by Patrick Ruffini :: April 22nd, 2008 8:42 amThe use of Twitter as a discovery vehicle for raw political intelligence takes another step today with Election Journal, a project by Republican election watchdog Mike Roman. The site is using Twitter, Flickr, and Google Maps to cover primary election day in Philadelphia, with Twittering correspondents stationed around the city.
Anyone who’s worked a few election days in Philly knows how colorful things can get. Violence, intimidation, broken machines, and officials denied entry into polling places are par for the course. With more than 1,600 precincts in the city alone, it’s difficult to get a handle on it all. Here’s hoping a little technology-enabled citizen journalism can bring some much needed transparency to election day.
Follow @ElectionJournal on Twitter to get live breaking updates. And here’s a map of the incidents they’ve uncovered so far:
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 (746)
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 (746)
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 (746)
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 (746)
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 (746)
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 (746)
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 = '746' AND comment_approved = '1' ORDER BY comment_date
