Created
August 7, 2012 07:10
-
-
Save kai-koch/3282667 to your computer and use it in GitHub Desktop.
[email protected]: PROTOCOL_ & PARSER_ errors
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //var dbConfig = require('./dbConfig'); | |
| var dbConfig = { | |
| host: 'localhost', | |
| port: 3306, | |
| user: 'user', | |
| password: '*********', | |
| database: 'foo', | |
| charset: 'UTF8_GENERAL_CI' | |
| }; | |
| var mysql = require('mysql'); | |
| //dbConfig.debug = true; | |
| var anotherConnection = mysql.createConnection(dbConfig); | |
| /** | |
| * { [Error: Packets out of order. Got: 95 Expected: 8] code: | |
| * 'PROTOCOL_PACKETS_OUT_OF_ORDER', fatal: true } | |
| */ | |
| var query = anotherConnection.query("SELECT * FROM twitter_test LIMIT 0, 2"); | |
| /** | |
| * Node does not exit | |
| */ | |
| //var query = anotherConnection.query("SELECT * FROM twitter_test LIMIT 1, 2"); | |
| /** | |
| * { [Error: Packets out of order. Got: 101 Expected: 9] | |
| * code: 'PROTOCOL_PACKETS_OUT_OF_ORDER', fatal: true } | |
| */ | |
| //var query = anotherConnection.query("SELECT * FROM twitter_test LIMIT 10, 2"); | |
| /** | |
| * { [Error: sourceEnd < sourceStart] code: 'PROTOCOL_PARSER_EXCEPTION', | |
| * fatal: true } | |
| */ | |
| //var query = anotherConnection.query("SELECT * FROM twitter_test LIMIT 20, 3"); | |
| var rs = { | |
| fields: [], | |
| rows: [], | |
| processRow: function (row, callback) { | |
| var i, akku = ""; | |
| for (i in row) { | |
| if (row.hasOwnProperty(i)) { | |
| if (i === "chunk") { | |
| akku += ' ' + i + ' => ' + row[i].slice(0, 20) + "[...]"; | |
| } else { | |
| akku += ' ' + i + " => " + row[i]; | |
| } | |
| } | |
| } | |
| console.log('processing row'); | |
| rs.rows.push(akku); | |
| callback(); | |
| } | |
| }; | |
| query.on('error', function (err) { | |
| console.dir(err); | |
| }).on('fields', function (fields) { | |
| // the field packets for the rows to follow | |
| var i = 0, len = fields.length; | |
| for (i; i < len; i += 1) { | |
| rs.fields.push(fields.name); | |
| } | |
| }).on('result', function (row) { | |
| // Pausing the connnection is useful if your processing involves I/O | |
| anotherConnection.pause(); | |
| rs.processRow(row, function () { | |
| anotherConnection.resume(); | |
| }); | |
| }).on('end', function () { | |
| console.log(rs.fields.join(" ")); | |
| console.log(rs.rows.join("\n")); | |
| }); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| I get PROTOCOL_ and PARSER_ errors, when selecting from a table with raw messages from Twitter. | |
| Depending on which query I execute, I get different results. In one node does not even exit. | |
| The rows were inserted using connection.escape(). | |
| I am using Node.js 0.8.4 on WindowsXP. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- phpMyAdmin SQL Dump | |
| -- version 3.4.5 | |
| -- http://www.phpmyadmin.net | |
| -- | |
| -- Host: localhost | |
| -- Erstellungszeit: 07. Aug 2012 um 08:21 | |
| -- Server Version: 5.5.16 | |
| -- PHP-Version: 5.3.8 | |
| SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; | |
| SET time_zone = "+00:00"; | |
| /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; | |
| /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; | |
| /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; | |
| /*!40101 SET NAMES utf8 */; | |
| -- | |
| -- Datenbank: `foo` | |
| -- | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Tabellenstruktur für Tabelle `twitter_test` | |
| -- | |
| DROP TABLE IF EXISTS `twitter_test`; | |
| CREATE TABLE IF NOT EXISTS `twitter_test` ( | |
| `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| `timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, | |
| `typeOf` enum('tweet','delete','limit','scrub_geo') DEFAULT NULL COMMENT 'the type of event, that from that chunk', | |
| `chunk` text NOT NULL COMMENT 'Chunks, from the twitter stream that are identified as one msg.', | |
| `processed` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Flag: Has this chunk been processed?', | |
| PRIMARY KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Table that store the raw chunks of twitter information' AUTO_INCREMENT=31 ; | |
| -- | |
| -- Daten für Tabelle `twitter_test` | |
| -- | |
| INSERT INTO `twitter_test` (`id`, `timestamp`, `typeOf`, `chunk`, `processed`) VALUES | |
| (1, '2012-07-29 04:19:21', 'tweet', '{"place":null,"favorited":false,"text":"@_mohini Macadamia and mango was foooooooul.","in_reply_to_user_id_str":"22348858","contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/android\\" rel=\\"nofollow\\"\\u003ETwitter for Android\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:20:56 +0000 2012","retweeted":false,"in_reply_to_user_id":22348858,"in_reply_to_status_id":229425068181168128,"user":{"listed_count":2,"contributors_enabled":false,"geo_enabled":true,"profile_link_color":"7d0c94","time_zone":"Sydney","screen_name":"svedig","default_profile":false,"following":null,"profile_background_color":"000000","is_translator":false,"show_all_inline_media":false,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/604080337\\/id61q8ei8u93b17kwxqs.jpeg","description":"I don''t got this.","created_at":"Sat Nov 27 05:02:12 +0000 2010","profile_sidebar_fill_color":"eded0e","followers_count":132,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2442848484\\/IaI3LsIS_normal","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2442848484\\/IaI3LsIS_normal","verified":false,"url":"http:\\/\\/jamesridpath.wordpress.com","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"f2df0e","favourites_count":68,"protected":false,"statuses_count":16397,"notifications":null,"profile_use_background_image":true,"location":"Fuckin'' Railo.","name":"Liam J. Low","friends_count":138,"profile_text_color":"030a01","id":220238629,"id_str":"220238629","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/604080337\\/id61q8ei8u93b17kwxqs.jpeg","utc_offset":36000},"id":229431287625183232,"in_reply_to_status_id_str":"229425068181168128","id_str":"229431287625183232","entities":{"user_mentions":[{"indices":[0,8],"screen_name":"_mohini","name":"Rosie O''Meley","id":22348858,"id_str":"22348858"}],"hashtags":[],"urls":[]},"in_reply_to_screen_name":"_mohini","truncated":false}', 0), | |
| (2, '2012-07-29 04:19:23', 'tweet', '{"place":null,"favorited":false,"text":"RT @WeLoveDara: [DARA ME2DAY] Dara thanking her fans for the MANGO TREE WREATH PROJECT :) DARALINGS jJANG :) http:\\/\\/t.co\\/YuXUy0jY","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":32,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/iphone\\" rel=\\"nofollow\\"\\u003ETwitter for iPhone\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:20:57 +0000 2012","possibly_sensitive_editable":true,"retweeted_status":{"place":null,"favorited":false,"text":"[DARA ME2DAY] Dara thanking her fans for the MANGO TREE WREATH PROJECT :) DARALINGS jJANG :) http:\\/\\/t.co\\/YuXUy0jY","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":32,"source":"\\u003Ca href=\\"http:\\/\\/www.tweetdeck.com\\" rel=\\"nofollow\\"\\u003ETweetDeck\\u003C\\/a\\u003E","created_at":"Sun Jul 29 03:36:15 +0000 2012","possibly_sensitive_editable":true,"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":286,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"c302d4","time_zone":"Hong Kong","screen_name":"WeLoveDara","default_profile":false,"following":null,"profile_background_color":"ffffff","is_translator":false,"show_all_inline_media":false,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/597290494\\/aum7sf6nosevoayl3wvb.jpeg","description":"WeLoveDara is an account lovingly dedicated to 2ne1''s Goddess Sandara Park - a one of a kind KPOP idol who has big dreams and an even bigger heart.","created_at":"Sun Sep 19 17:11:12 +0000 2010","profile_sidebar_fill_color":"899399","followers_count":29039,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2441792898\\/jm0d5yz4a46gxbllapb7_normal.png","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2441792898\\/jm0d5yz4a46gxbllapb7_normal.png","verified":false,"url":"http:\\/\\/oh-dara.com","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"0a0a0a","favourites_count":21,"protected":false,"statuses_count":58897,"notifications":null,"profile_use_background_image":true,"location":"","name":"We Love Dara","friends_count":291,"profile_text_color":"000000","id":192609878,"id_str":"192609878","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/597290494\\/aum7sf6nosevoayl3wvb.jpeg","utc_offset":28800},"id":229420044256428032,"possibly_sensitive":false,"in_reply_to_status_id_str":null,"id_str":"229420044256428032","entities":{"user_mentions":[],"hashtags":[],"urls":[{"display_url":"twitpic.com\\/acy3do","indices":[95,115],"expanded_url":"http:\\/\\/twitpic.com\\/acy3do","url":"http:\\/\\/t.co\\/YuXUy0jY"}]},"in_reply_to_screen_name":null,"truncated":false},"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":0,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"0084B4","time_zone":null,"screen_name":"chonky_tuts","default_profile":true,"following":null,"profile_background_color":"C0DEED","is_translator":false,"show_all_inline_media":false,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/images\\/themes\\/theme1\\/bg.png","description":null,"created_at":"Wed Mar 18 02:58:11 +0000 2009","profile_sidebar_fill_color":"DDEEF6","followers_count":11,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2356365367\\/image_normal.jpg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2356365367\\/image_normal.jpg","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"C0DEED","favourites_count":0,"protected":false,"statuses_count":114,"notifications":null,"profile_use_background_image":true,"location":null,"name":"Chonks","friends_count":44,"profile_text_color":"333333","id":25015578,"id_str":"25015578","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/images\\/themes\\/theme1\\/bg.png","utc_offset":null},"id":229431293912436736,"possibly_sensitive":false,"in_reply_to_status_id_str":null,"id_str":"229431293912436736","entities":{"user_mentions":[{"indices":[3,14],"screen_name":"WeLoveDara","name":"We Love Dara","id":192609878,"id_str":"192609878"}],"hashtags":[],"urls":[{"display_url":"twitpic.com\\/acy3do","indices":[111,131],"expanded_url":"http:\\/\\/twitpic.com\\/acy3do","url":"http:\\/\\/t.co\\/YuXUy0jY"}]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (3, '2012-07-29 04:19:27', 'tweet', '{"place":null,"favorited":false,"text":"cherries . mango . ice . :))","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/android\\" rel=\\"nofollow\\"\\u003ETwitter for Android\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:21:02 +0000 2012","retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":0,"contributors_enabled":false,"geo_enabled":true,"profile_link_color":"0084B4","time_zone":"Pacific Time (US & Canada)","screen_name":"VIII_XXVII_XII","default_profile":false,"following":null,"profile_background_color":"9AE4E8","is_translator":false,"show_all_inline_media":false,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/592211620\\/2g6aw2yfpjk6bnf05529.png","description":"minnie AUTRY* . bennett university*. c\\/o 2O12*. O728 #teamLEO*. # Jamil C.A Bolger Jr.08''12\\u2665 !(: #PROUD M O T H E R ! #team S P O K E N F O R !(:","created_at":"Tue Apr 20 06:33:51 +0000 2010","profile_sidebar_fill_color":"DDFFCC","followers_count":180,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2403422897\\/I3Vqa5lz_normal","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2403422897\\/I3Vqa5lz_normal","verified":false,"url":"http:\\/\\/facebook.com\\/minnietheebaddest","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"BDDCAD","favourites_count":30,"protected":false,"statuses_count":4904,"notifications":null,"profile_use_background_image":true,"location":"whereever i choose too be :))","name":"* minnie \\u2665 7|28=bday","friends_count":281,"profile_text_color":"333333","id":135059214,"id_str":"135059214","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/592211620\\/2g6aw2yfpjk6bnf05529.png","utc_offset":-28800},"id":229431311931174913,"in_reply_to_status_id_str":null,"id_str":"229431311931174913","entities":{"user_mentions":[],"hashtags":[],"urls":[]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (4, '2012-07-29 04:19:31', 'tweet', '{"place":null,"favorited":false,"text":"SALE Export Quality Fruit Seeds & Plants Guava,Mango,Lemon,Plants,Sapling 9936420215: *India,s No-1 Fruit & Othe... http:\\/\\/t.co\\/5d1muXI9","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/twitterfeed.com\\" rel=\\"nofollow\\"\\u003Etwitterfeed\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:21:05 +0000 2012","possibly_sensitive_editable":true,"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":17,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"088253","time_zone":"Kathmandu","screen_name":"agrimarket","default_profile":false,"following":null,"profile_background_color":"EDECE9","is_translator":false,"show_all_inline_media":false,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/images\\/themes\\/theme3\\/bg.gif","description":"Online community of buyers, sellers and experts in agriculture","created_at":"Sun May 17 07:38:59 +0000 2009","profile_sidebar_fill_color":"E3E2DE","followers_count":848,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/248054976\\/Final_logo_normal.JPG","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/248054976\\/Final_logo_normal.JPG","verified":false,"url":"http:\\/\\/www.agricultureinformation.com","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"D3D2CF","favourites_count":0,"protected":false,"statuses_count":8420,"notifications":null,"profile_use_background_image":true,"location":"Worldwide","name":"Agri Market","friends_count":194,"profile_text_color":"634047","id":40625660,"id_str":"40625660","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/images\\/themes\\/theme3\\/bg.gif","utc_offset":20700},"id":229431327198425088,"possibly_sensitive":false,"in_reply_to_status_id_str":null,"id_str":"229431327198425088","entities":{"user_mentions":[],"hashtags":[],"urls":[{"display_url":"bit.ly\\/P39mCj","indices":[124,144],"expanded_url":"http:\\/\\/bit.ly\\/P39mCj","url":"http:\\/\\/t.co\\/5d1muXI9"}]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (5, '2012-07-29 04:19:32', 'tweet', '{"place":null,"favorited":false,"text":":) (@ Mango''s Tropical Cafe w\\/ 9 others) http:\\/\\/t.co\\/MW7ps9Pd","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/foursquare.com\\" rel=\\"nofollow\\"\\u003Efoursquare\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:21:06 +0000 2012","possibly_sensitive_editable":true,"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":1,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"0084B4","time_zone":"Arizona","screen_name":"DjWeeSss303","default_profile":true,"following":null,"profile_background_color":"C0DEED","is_translator":false,"show_all_inline_media":false,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/images\\/themes\\/theme1\\/bg.png","description":"We like to bullshit and party and bullshit some more. ","created_at":"Fri Feb 03 23:11:43 +0000 2012","profile_sidebar_fill_color":"DDEEF6","followers_count":68,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2427602242\\/DjWeeSss303_normal.jpg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2427602242\\/DjWeeSss303_normal.jpg","verified":false,"url":"http:\\/\\/www.beatroccas.com","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"C0DEED","favourites_count":2,"protected":false,"statuses_count":573,"notifications":null,"profile_use_background_image":true,"location":"Denver","name":"Luis Martinez","friends_count":76,"profile_text_color":"333333","id":482465841,"id_str":"482465841","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/images\\/themes\\/theme1\\/bg.png","utc_offset":-25200},"id":229431331656970242,"possibly_sensitive":false,"in_reply_to_status_id_str":null,"id_str":"229431331656970242","entities":{"user_mentions":[],"hashtags":[],"urls":[{"display_url":"4sq.com\\/PXTllm","indices":[41,61],"expanded_url":"http:\\/\\/4sq.com\\/PXTllm","url":"http:\\/\\/t.co\\/MW7ps9Pd"}]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (6, '2012-07-29 04:19:32', 'tweet', '{"place":null,"favorited":false,"text":"Si la vida te da limones... Di al diablo con los limones y vete por un pinche mango :)","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/android\\" rel=\\"nofollow\\"\\u003ETwitter for Android\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:21:07 +0000 2012","retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":0,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"088253","time_zone":null,"screen_name":"ItzelGarzon","default_profile":false,"following":null,"profile_background_color":"000000","is_translator":false,"show_all_inline_media":true,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/539651433\\/cameras.jpg","description":"","created_at":"Sat Sep 24 03:17:32 +0000 2011","profile_sidebar_fill_color":"000000","followers_count":99,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2434109187\\/TVak83DN_normal","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2434109187\\/TVak83DN_normal","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"030303","favourites_count":30,"protected":false,"statuses_count":2515,"notifications":null,"profile_use_background_image":true,"location":"","name":"Itzel Garz\\u00f3n","friends_count":113,"profile_text_color":"634047","id":378952426,"id_str":"378952426","lang":"es","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/539651433\\/cameras.jpg","utc_offset":null},"id":229431334639120384,"in_reply_to_status_id_str":null,"id_str":"229431334639120384","entities":{"user_mentions":[],"hashtags":[],"urls":[]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (7, '2012-07-29 04:19:34', 'tweet', '{"place":null,"favorited":false,"text":"RT @toriharrisxxx: McDonald''s mango pineapple smoothie is to good for words.","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/android\\" rel=\\"nofollow\\"\\u003ETwitter for Android\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:21:08 +0000 2012","retweeted_status":{"place":null,"favorited":false,"text":"McDonald''s mango pineapple smoothie is to good for words.","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/android\\" rel=\\"nofollow\\"\\u003ETwitter for Android\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:03:46 +0000 2012","retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":0,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"0084B4","time_zone":"Mountain Time (US & Canada)","screen_name":"toriharrisxxx","default_profile":false,"following":null,"profile_background_color":"C0DEED","is_translator":false,"show_all_inline_media":false,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/480084099\\/images.jpeg","description":"#TeamRussellBrand #TeamMacMiller #MostDope","created_at":"Wed Jan 25 14:45:29 +0000 2012","profile_sidebar_fill_color":"DDEEF6","followers_count":153,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2439282001\\/OjNh8HKr_normal","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2439282001\\/OjNh8HKr_normal","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"C0DEED","favourites_count":218,"protected":false,"statuses_count":2573,"notifications":null,"profile_use_background_image":true,"location":"MIDLO","name":"tori harris","friends_count":123,"profile_text_color":"333333","id":473981825,"id_str":"473981825","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/480084099\\/images.jpeg","utc_offset":-25200},"id":229426969765367808,"in_reply_to_status_id_str":null,"id_str":"229426969765367808","entities":{"user_mentions":[],"hashtags":[],"urls":[]},"in_reply_to_screen_name":null,"truncated":false},"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":0,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"0084B4","time_zone":"Eastern Time (US & Canada)","screen_name":"SabrinaBarreraa","default_profile":false,"following":null,"profile_background_color":"C0DEED","is_translator":false,"show_all_inline_media":false,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/599290899\\/yj4voggkptbejtearw7a.jpeg","description":"life is too short, so love the one ya got","created_at":"Thu Jun 28 19:04:32 +0000 2012","profile_sidebar_fill_color":"DDEEF6","followers_count":122,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2442251599\\/w59DuBBs_normal","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2442251599\\/w59DuBBs_normal","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"C0DEED","favourites_count":60,"protected":false,"statuses_count":364,"notifications":null,"profile_use_background_image":true,"location":"","name":"SABRINA","friends_count":141,"profile_text_color":"333333","id":621231541,"id_str":"621231541","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/599290899\\/yj4voggkptbejtearw7a.jpeg","utc_offset":-18000},"id":229431338653085696,"in_reply_to_status_id_str":null,"id_str":"229431338653085696","entities":{"user_mentions":[{"indices":[3,17],"screen_name":"toriharrisxxx","name":"tori harris","id":473981825,"id_str":"473981825"}],"hashtags":[],"urls":[]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (8, '2012-07-29 04:19:35', 'tweet', '{"place":null,"favorited":false,"text":"Mango mousse http:\\/\\/t.co\\/pAYg1LwM","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/instagr.am\\" rel=\\"nofollow\\"\\u003EInstagram\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:21:10 +0000 2012","possibly_sensitive_editable":true,"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":45,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"e76565","time_zone":"Eastern Time (US & Canada)","screen_name":"sixhours","default_profile":false,"following":null,"profile_background_color":"aad1cc","is_translator":false,"show_all_inline_media":false,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/8794269\\/icecream.jpg","description":"Illustrator, photographer, web geek, wife to @tmoorewp and proud mama to two beautiful girls. Theme Wrangler @automattic","created_at":"Sun Apr 22 14:32:56 +0000 2007","profile_sidebar_fill_color":"f7f5ed","followers_count":681,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2050717734\\/6972526563_751c51c6a8_o_normal.jpeg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2050717734\\/6972526563_751c51c6a8_o_normal.jpeg","verified":false,"url":"http:\\/\\/www.carolinemoore.net","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"eaddbd","favourites_count":20,"protected":false,"statuses_count":2477,"notifications":null,"profile_use_background_image":true,"location":"Maine","name":"Caroline Moore","friends_count":259,"profile_text_color":"3c2925","id":5402352,"id_str":"5402352","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/8794269\\/icecream.jpg","utc_offset":-18000},"id":229431346920042499,"possibly_sensitive":false,"in_reply_to_status_id_str":null,"id_str":"229431346920042499","entities":{"user_mentions":[],"hashtags":[],"urls":[{"display_url":"instagr.am\\/p\\/NprJqczGMj\\/","indices":[13,33],"expanded_url":"http:\\/\\/instagr.am\\/p\\/NprJqczGMj\\/","url":"http:\\/\\/t.co\\/pAYg1LwM"}]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (9, '2012-07-29 04:19:38', 'tweet', '{"place":null,"favorited":false,"text":"Come to Mango lounge ! 126 linden Ave JCNJ 07305!! \\ud83d\\ude01\\ud83c\\udf89\\ud83c\\udf7a\\ud83c\\udf7b\\ud83c\\udf78","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/www.osfoora.com\\" rel=\\"nofollow\\"\\u003EOsfoora for iPhone\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:21:12 +0000 2012","retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":5,"contributors_enabled":false,"geo_enabled":true,"profile_link_color":"2FC2EF","time_zone":"Quito","screen_name":"LiLBiTTx3","default_profile":false,"following":null,"profile_background_color":"1A1B1F","is_translator":false,"show_all_inline_media":true,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/images\\/themes\\/theme4\\/bg.gif","description":"Princess gets what Princess wants! \\r\\n|Criminal Justice Major ;Psychology Minor | \\r\\nINSTAGRAM : @LiLBiTTx3 \\r\\n#teamCOWBOYS","created_at":"Fri Apr 23 17:11:01 +0000 2010","profile_sidebar_fill_color":"252429","followers_count":710,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2368135141\\/ProfilePhoto_normal.png","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2368135141\\/ProfilePhoto_normal.png","verified":false,"url":"http:\\/\\/facebook.com\\/LiLBiTT.xx","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"181A1E","favourites_count":11,"protected":false,"statuses_count":17282,"notifications":null,"profile_use_background_image":false,"location":"#RutgersUniversity","name":"Princess Shay''na \\u2755","friends_count":186,"profile_text_color":"666666","id":136339095,"id_str":"136339095","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/images\\/themes\\/theme4\\/bg.gif","utc_offset":-18000},"id":229431356189470720,"in_reply_to_status_id_str":null,"id_str":"229431356189470720","entities":{"user_mentions":[],"hashtags":[],"urls":[]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (10, '2012-07-29 04:19:44', 'tweet', '{"place":null,"favorited":false,"text":"I''m craving mango de bani \\u263a best mango''s in the world deadass","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/blackberry.com\\/twitter\\" rel=\\"nofollow\\"\\u003ETwitter for BlackBerry\\u00ae\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:21:18 +0000 2012","retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":0,"contributors_enabled":false,"geo_enabled":true,"profile_link_color":"0084B4","time_zone":null,"screen_name":"fastcashnel","default_profile":true,"following":null,"profile_background_color":"C0DEED","is_translator":false,"show_all_inline_media":false,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/images\\/themes\\/theme1\\/bg.png","description":"Baseball is everything...","created_at":"Thu Jun 21 02:56:38 +0000 2012","profile_sidebar_fill_color":"DDEEF6","followers_count":7,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2358638427\\/IMG-20120626-00221_normal.jpg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2358638427\\/IMG-20120626-00221_normal.jpg","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"C0DEED","favourites_count":1,"protected":false,"statuses_count":208,"notifications":null,"profile_use_background_image":true,"location":"","name":"nelson piantini","friends_count":22,"profile_text_color":"333333","id":613970611,"id_str":"613970611","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/images\\/themes\\/theme1\\/bg.png","utc_offset":null},"id":229431382361907200,"in_reply_to_status_id_str":null,"id_str":"229431382361907200","entities":{"user_mentions":[],"hashtags":[],"urls":[]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (11, '2012-07-29 04:19:48', 'tweet', '{"place":null,"favorited":false,"text":"Bought Mango Bravo from Conti''s. Legit broke this week HAHAHA! #worthitthough","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"web","created_at":"Sun Jul 29 04:21:22 +0000 2012","retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":4,"contributors_enabled":false,"geo_enabled":true,"profile_link_color":"703d21","time_zone":"Singapore","screen_name":"lintaopalitaw","default_profile":false,"following":null,"profile_background_color":"f7cfe1","is_translator":false,"show_all_inline_media":false,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/306378362\\/as.jpg","description":"Stop trying to fit in when you were born to stand out.","created_at":"Fri May 13 02:25:30 +0000 2011","profile_sidebar_fill_color":"DDEEF6","followers_count":181,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2418932612\\/l285xy7mhazia87y6xvt_normal.jpeg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2418932612\\/l285xy7mhazia87y6xvt_normal.jpeg","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"C0DEED","favourites_count":188,"protected":false,"statuses_count":4048,"notifications":null,"profile_use_background_image":true,"location":"","name":"Ryan L-)","friends_count":81,"profile_text_color":"333333","id":297765435,"id_str":"297765435","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/306378362\\/as.jpg","utc_offset":28800},"id":229431398136684544,"in_reply_to_status_id_str":null,"id_str":"229431398136684544","entities":{"user_mentions":[],"hashtags":[{"text":"worthitthough","indices":[63,77]}],"urls":[]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (12, '2012-07-29 04:19:50', 'tweet', '{"place":null,"text":"Photo: mango-coconut: http:\\/\\/t.co\\/V6UNPfVN","possibly_sensitive":false,"in_reply_to_status_id_str":null,"id_str":"229431406856646656","in_reply_to_screen_name":null,"truncated":false,"favorited":false,"in_reply_to_user_id_str":null,"coordinates":null,"geo":null,"contributors":null,"source":"\\u003Ca href=\\"http:\\/\\/www.tumblr.com\\/\\" rel=\\"nofollow\\"\\u003ETumblr\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:21:24 +0000 2012","retweet_count":0,"possibly_sensitive_editable":true,"retweeted":false,"user":{"friends_count":105,"profile_text_color":"267a11","id_str":"352043303","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/309095757\\/vintage-photography__12.png","screen_name":"RubeeDaisy","listed_count":0,"contributors_enabled":false,"following":null,"geo_enabled":false,"profile_link_color":"33ff00","time_zone":"Central Time (US & Canada)","description":"Don''t read about me: just ask me. ","default_profile":false,"created_at":"Wed Aug 10 02:17:56 +0000 2011","profile_background_color":"080808","is_translator":false,"show_all_inline_media":true,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/309095757\\/vintage-photography__12.png","url":null,"profile_sidebar_fill_color":"000000","followers_count":38,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/1487351008\\/face1_normal.jpg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/1487351008\\/face1_normal.jpg","verified":false,"protected":false,"default_profile_image":false,"follow_request_sent":null,"notifications":null,"profile_sidebar_border_color":"00ff00","location":"Chicago, IL","name":"Ruby Reyes ","favourites_count":11,"id":352043303,"lang":"en","statuses_count":974,"profile_use_background_image":true,"utc_offset":-21600},"id":229431406856646656,"entities":{"urls":[{"indices":[22,42],"display_url":"tmblr.co\\/ZwWDXvQJUThG","url":"http:\\/\\/t.co\\/V6UNPfVN","expanded_url":"http:\\/\\/tmblr.co\\/ZwWDXvQJUThG"}],"user_mentions":[],"hashtags":[]},"in_reply_to_user_id":null,"in_reply_to_status_id":null}', 0), | |
| (13, '2012-07-29 04:19:54', 'tweet', '{"place":null,"text":"#mango","in_reply_to_user_id":null,"in_reply_to_status_id":null,"in_reply_to_status_id_str":null,"id_str":"229431424116215808","coordinates":null,"geo":null,"in_reply_to_screen_name":null,"truncated":false,"favorited":false,"source":"\\u003Ca href=\\"http:\\/\\/ubersocial.com\\" rel=\\"nofollow\\"\\u003EUberSocial for Android\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:21:28 +0000 2012","in_reply_to_user_id_str":null,"contributors":null,"retweet_count":0,"user":{"favourites_count":134,"statuses_count":47813,"profile_use_background_image":true,"screen_name":"_yoFUCKNproblem","following":null,"friends_count":488,"profile_text_color":"333333","id_str":"249894969","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/images\\/themes\\/theme14\\/bg.gif","description":"SWEETESTashhole EVA.. iSwear:) \\r\\n\\r\\nbfo u gt 2 flirtn n dm''n..\\r\\nmeet bby @hairflippinhoez","listed_count":1,"contributors_enabled":false,"geo_enabled":false,"created_at":"Thu Feb 10 00:35:26 +0000 2011","profile_link_color":"009999","time_zone":"Central Time (US & Canada)","url":null,"default_profile":false,"profile_background_color":"131516","is_translator":false,"show_all_inline_media":false,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/images\\/themes\\/theme14\\/bg.gif","protected":false,"notifications":null,"profile_sidebar_fill_color":"efefef","followers_count":510,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2403697441\\/b1jqq6k8a8exzkleotyv_normal.png","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2403697441\\/b1jqq6k8a8exzkleotyv_normal.png","location":"sumWHERE u''ll neva BE..","name":"iMgudW\\/haSHIIT..","verified":false,"id":249894969,"default_profile_image":false,"follow_request_sent":null,"lang":"en","utc_offset":-21600,"profile_sidebar_border_color":"eeeeee"},"id":229431424116215808,"entities":{"user_mentions":[],"hashtags":[{"text":"mango","indices":[0,6]}],"urls":[]},"retweeted":false}', 0), | |
| (14, '2012-07-29 04:19:56', 'tweet', '{"place":null,"favorited":false,"text":"En be\\u011fendi\\u011fin ma\\u011fazalar hangileri? \\u2014 mango zara http:\\/\\/t.co\\/kIyszgSK","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/ask.fm\\/\\" rel=\\"nofollow\\"\\u003EAsk.fm\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:21:30 +0000 2012","possibly_sensitive_editable":true,"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":1,"contributors_enabled":false,"geo_enabled":true,"profile_link_color":"ff00ae","time_zone":null,"screen_name":"NurYldz19","default_profile":false,"following":null,"profile_background_color":"BADFCD","is_translator":false,"show_all_inline_media":false,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/579177059\\/cdsnkqmj302bue12b19v.jpeg","description":"her zaman e\\u011flenceyi sevre","created_at":"Sat Oct 08 20:26:17 +0000 2011","profile_sidebar_fill_color":"FFF7CC","followers_count":36,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/1707941428\\/131313131_normal.jpg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/1707941428\\/131313131_normal.jpg","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"F2E195","favourites_count":10,"protected":false,"statuses_count":237,"notifications":null,"profile_use_background_image":true,"location":"","name":"Nur Y\\u0131ld\\u0131z","friends_count":86,"profile_text_color":"0C3E53","id":387303368,"id_str":"387303368","lang":"tr","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/579177059\\/cdsnkqmj302bue12b19v.jpeg","utc_offset":null},"id":229431432282521600,"possibly_sensitive":false,"in_reply_to_status_id_str":null,"id_str":"229431432282521600","entities":{"user_mentions":[],"hashtags":[],"urls":[{"display_url":"ask.fm\\/a\\/4584koifk9","indices":[48,68],"expanded_url":"http:\\/\\/ask.fm\\/a\\/4584koifk9","url":"http:\\/\\/t.co\\/kIyszgSK"}]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (15, '2012-07-29 04:19:58', 'tweet', '{"place":null,"favorited":false,"text":"RT @BaddestFemaleCL: Our mango wreath ^^ http:\\/\\/t.co\\/lxulRJPb","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":1,"source":"web","created_at":"Sun Jul 29 04:21:32 +0000 2012","possibly_sensitive_editable":true,"retweeted_status":{"place":null,"favorited":false,"text":"Our mango wreath ^^ http:\\/\\/t.co\\/lxulRJPb","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":1,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/iphone\\" rel=\\"nofollow\\"\\u003ETwitter for iPhone\\u003C\\/a\\u003E","created_at":"Sun Jul 29 03:51:56 +0000 2012","possibly_sensitive_editable":true,"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":115,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"8296b5","time_zone":"Central Time (US & Canada)","screen_name":"BaddestFemaleCL","default_profile":false,"following":null,"profile_background_color":"8296b5","is_translator":false,"show_all_inline_media":true,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/545092248\\/twitter.jpg","description":"CL''s first international fansite! (\\ud574\\uc678\\ud32c CLTBF) The #1 source for daily updates about 2NE1''s Fierce and Multi- Talented Leader, Lee Chaerin (\\uc774\\ucc44\\ub9b0) \\u2663 ","created_at":"Wed Aug 04 16:25:10 +0000 2010","profile_sidebar_fill_color":"c9c3c4","followers_count":12119,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2365534690\\/hlmkx52hy7e6253jt65l_normal.jpeg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2365534690\\/hlmkx52hy7e6253jt65l_normal.jpeg","verified":false,"url":"http:\\/\\/clthebaddestfemale.com","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"181A1E","favourites_count":3,"protected":false,"statuses_count":11025,"notifications":null,"profile_use_background_image":true,"location":"Home of International CLovers","name":"CLtheBaddestFemale","friends_count":83,"profile_text_color":"703b12","id":174705430,"id_str":"174705430","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/545092248\\/twitter.jpg","utc_offset":-21600},"id":229423990320529410,"possibly_sensitive":false,"in_reply_to_status_id_str":null,"id_str":"229423990320529410","entities":{"user_mentions":[],"hashtags":[],"urls":[{"display_url":"facebook.com\\/photo.php?fbid\\u2026","indices":[20,40],"expanded_url":"http:\\/\\/www.facebook.com\\/photo.php?fbid=450504821648349&set=a.160033727362128.41987.159849260713908&type=1","url":"http:\\/\\/t.co\\/lxulRJPb"}]},"in_reply_to_screen_name":null,"truncated":false},"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":0,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"0084B4","time_zone":"Singapore","screen_name":"TZQLT","default_profile":false,"following":null,"profile_background_color":"C0DEED","is_translator":false,"show_all_inline_media":false,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/601704754\\/meowp57yxt4m8dawcrvv.jpeg","description":"~Now and Forever Girls Generation~ ~Once A Sone, Always A Sone~ ~T-ara Queen~ ~BIGBANG VIP~ ~2NE1 BLACKJACK~ ~Aff(x)tion~ ~Vodafone McLaren Mercedes~","created_at":"Mon Oct 11 06:17:04 +0000 2010","profile_sidebar_fill_color":"DDEEF6","followers_count":145,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2388255216\\/jx1z8ut9zauw77jiy1y2_normal.jpeg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2388255216\\/jx1z8ut9zauw77jiy1y2_normal.jpeg","verified":false,"url":"http:\\/\\/girlsgeneration.smtown.com","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"C0DEED","favourites_count":576,"protected":false,"statuses_count":7375,"notifications":null,"profile_use_background_image":true,"location":"Taeyeon and Jiyeon''s Hearts","name":"Leonardo Troeman","friends_count":946,"profile_text_color":"333333","id":201156914,"id_str":"201156914","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/601704754\\/meowp57yxt4m8dawcrvv.jpeg","utc_offset":28800},"id":229431440817942528,"possibly_sensitive":false,"in_reply_to_status_id_str":null,"id_str":"229431440817942528","entities":{"user_mentions":[{"indices":[3,19],"screen_name":"BaddestFemaleCL","name":"CLtheBaddestFemale","id":174705430,"id_str":"174705430"}],"hashtags":[],"urls":[{"display_url":"facebook.com\\/photo.php?fbid\\u2026","indices":[41,61],"expanded_url":"http:\\/\\/www.facebook.com\\/photo.php?fbid=450504821648349&set=a.160033727362128.41987.159849260713908&type=1","url":"http:\\/\\/t.co\\/lxulRJPb"}]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (16, '2012-07-29 04:20:00', 'tweet', '{"place":null,"favorited":false,"text":"@AleZavala25 Mango''s Loveee\\u2665","in_reply_to_user_id_str":"47473183","contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/blackberry.com\\/twitter\\" rel=\\"nofollow\\"\\u003ETwitter for BlackBerry\\u00ae\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:21:35 +0000 2012","retweeted":false,"in_reply_to_user_id":47473183,"in_reply_to_status_id":229427414537740289,"user":{"listed_count":0,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"0084B4","time_zone":null,"screen_name":"BerliozMafer","default_profile":true,"following":null,"profile_background_color":"C0DEED","is_translator":false,"show_all_inline_media":false,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/images\\/themes\\/theme1\\/bg.png","description":"","created_at":"Tue May 01 00:30:58 +0000 2012","profile_sidebar_fill_color":"DDEEF6","followers_count":52,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2427183492\\/Gordas_normal.jpg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2427183492\\/Gordas_normal.jpg","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"C0DEED","favourites_count":3,"protected":false,"statuses_count":1132,"notifications":null,"profile_use_background_image":true,"location":"","name":"\\u2022M\\u03b1fer Berl\\u03b9oz\\u2661","friends_count":108,"profile_text_color":"333333","id":567693179,"id_str":"567693179","lang":"es","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/images\\/themes\\/theme1\\/bg.png","utc_offset":null},"id":229431450913628160,"in_reply_to_status_id_str":"229427414537740289","id_str":"229431450913628160","entities":{"user_mentions":[{"indices":[0,12],"screen_name":"AleZavala25","name":"Alejandra Zavala \\u2665","id":47473183,"id_str":"47473183"}],"hashtags":[],"urls":[]},"in_reply_to_screen_name":"AleZavala25","truncated":false}', 0), | |
| (17, '2012-07-29 04:20:02', 'tweet', '{"place":null,"favorited":false,"text":"Is it mango pineapple or pineapple mango smoothie? I always get confused\\/:","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/android\\" rel=\\"nofollow\\"\\u003ETwitter for Android\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:21:37 +0000 2012","retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":0,"contributors_enabled":false,"geo_enabled":true,"profile_link_color":"b8377c","time_zone":"Eastern Time (US & Canada)","screen_name":"Pipe_DownBitch","default_profile":false,"following":null,"profile_background_color":"ffffff","is_translator":false,"show_all_inline_media":false,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/images\\/themes\\/theme18\\/bg.gif","description":"follow my ratchet ass on instagram - 2k5 #TeamBreezy ","created_at":"Sat Mar 03 02:52:58 +0000 2012","profile_sidebar_fill_color":"F6F6F6","followers_count":331,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2424028351\\/W9OTfT8h_normal","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2424028351\\/W9OTfT8h_normal","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"EEEEEE","favourites_count":304,"protected":false,"statuses_count":9166,"notifications":null,"profile_use_background_image":false,"location":"","name":" scandalous","friends_count":292,"profile_text_color":"333333","id":512711219,"id_str":"512711219","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/images\\/themes\\/theme18\\/bg.gif","utc_offset":-18000},"id":229431459641974786,"in_reply_to_status_id_str":null,"id_str":"229431459641974786","entities":{"user_mentions":[],"hashtags":[],"urls":[]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (18, '2012-07-29 04:20:04', 'tweet', '{"place":null,"favorited":false,"text":"Buat yg belum tau, waktu pemotretan buat brand Mango, Piqu\\u00e9 sempet potong rambut. Makanya jambulnya agak beda gitu\\ud83d\\ude18 http:\\/\\/t.co\\/bOU4kwL9","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/www.echofon.com\\/\\" rel=\\"nofollow\\"\\u003EEchofon\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:21:38 +0000 2012","possibly_sensitive_editable":true,"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":2,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"21089e","time_zone":null,"screen_name":"MocMocIndonesia","default_profile":false,"following":null,"profile_background_color":"131516","is_translator":false,"show_all_inline_media":false,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/388557556\\/tumblr_lqe6j8zh5b1qc7tono1_r1_500_large.png","description":"Official Twitter Fanpage of @3gerardpique @cesc4official @carles5puyol\\ninstagram: mocmocindonesia\\ntumblr: mocmoc-345","created_at":"Sat Nov 12 02:54:03 +0000 2011","profile_sidebar_fill_color":"ffffff","followers_count":1306,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/1942947951\\/mocmocindonesia_normal.JPG","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/1942947951\\/mocmocindonesia_normal.JPG","verified":false,"url":"http:\\/\\/mocmoc-345.tumblr.com","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"e60c0c","favourites_count":64,"protected":false,"statuses_count":11185,"notifications":null,"profile_use_background_image":true,"location":"triomocmoc''s pocket","name":"Geri-Cesc-Puyi''s","friends_count":227,"profile_text_color":"d40b0b","id":410429020,"id_str":"410429020","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/388557556\\/tumblr_lqe6j8zh5b1qc7tono1_r1_500_large.png","utc_offset":null},"id":229431466591920129,"possibly_sensitive":false,"in_reply_to_status_id_str":null,"id_str":"229431466591920129","entities":{"user_mentions":[],"hashtags":[],"urls":[{"display_url":"twitpic.com\\/acymjx","indices":[116,136],"expanded_url":"http:\\/\\/twitpic.com\\/acymjx","url":"http:\\/\\/t.co\\/bOU4kwL9"}]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (19, '2012-07-29 04:20:07', 'tweet', '{"place":null,"favorited":false,"text":"@Josetroti cuantos compraste? ya compro chelo y el mango?","in_reply_to_user_id_str":"239869354","contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"web","created_at":"Sun Jul 29 04:21:41 +0000 2012","retweeted":false,"in_reply_to_user_id":239869354,"in_reply_to_status_id":229423869226807296,"user":{"listed_count":0,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"CC3366","time_zone":"Mountain Time (US & Canada)","screen_name":"LuisFLopez_","default_profile":false,"following":null,"profile_background_color":"DBE9ED","is_translator":false,"show_all_inline_media":false,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/611651339\\/1q90wkg1g9dwrjgmr2hw.jpeg","description":"Y lo que sale por esta boca nunca se expira ni se equivoca","created_at":"Thu Dec 01 01:00:50 +0000 2011","profile_sidebar_fill_color":"e0e0e0","followers_count":126,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2359499273\\/xjmhh9bc2i2a0rewuyzv_normal.jpeg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2359499273\\/xjmhh9bc2i2a0rewuyzv_normal.jpeg","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"3d2705","favourites_count":15,"protected":false,"statuses_count":5327,"notifications":null,"profile_use_background_image":true,"location":"Guatebala","name":"Luis L\\u00f3pez","friends_count":95,"profile_text_color":"333333","id":425448602,"id_str":"425448602","lang":"es","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/611651339\\/1q90wkg1g9dwrjgmr2hw.jpeg","utc_offset":-25200},"id":229431479166464000,"in_reply_to_status_id_str":"229423869226807296","id_str":"229431479166464000","entities":{"user_mentions":[{"indices":[0,10],"screen_name":"Josetroti","name":"Jos\\u00e9 Espinoza","id":239869354,"id_str":"239869354"}],"hashtags":[],"urls":[]},"in_reply_to_screen_name":"Josetroti","truncated":false}', 0); | |
| INSERT INTO `twitter_test` (`id`, `timestamp`, `typeOf`, `chunk`, `processed`) VALUES | |
| (20, '2012-07-29 04:20:11', 'tweet', '{"place":{"country":"United States","country_code":"US","bounding_box":{"type":"Polygon","coordinates":[[[-74.25909,40.477399],[-73.700272,40.477399],[-73.700272,40.917477],[-74.25909,40.917477]]]},"place_type":"city","url":"http:\\/\\/api.twitter.com\\/1\\/geo\\/id\\/27485069891a7938.json","attributes":{},"full_name":"New York, NY","name":"New York","id":"27485069891a7938"},"favorited":false,"text":"Ice cream mango pudding \\ud83c\\udf67 @ iDessert http:\\/\\/t.co\\/9udSaNwk","in_reply_to_user_id_str":null,"contributors":null,"coordinates":{"type":"Point","coordinates":[-74.00926060,40.63622294]},"geo":{"type":"Point","coordinates":[40.63622294,-74.00926060]},"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/instagr.am\\" rel=\\"nofollow\\"\\u003EInstagram\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:21:45 +0000 2012","possibly_sensitive_editable":true,"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":7,"contributors_enabled":false,"geo_enabled":true,"profile_link_color":"f5b6b6","time_zone":"Eastern Time (US & Canada)","screen_name":"anniexdarling","default_profile":false,"following":null,"profile_background_color":"fffaf7","is_translator":false,"show_all_inline_media":false,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/332083577\\/backpinkyfloral2.jpg","description":"Cold hearted mack; warm blooded lover.","created_at":"Thu Jun 04 09:48:41 +0000 2009","profile_sidebar_fill_color":"fffaf7","followers_count":330,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2241606584\\/image_normal.jpg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2241606584\\/image_normal.jpg","verified":false,"url":"http:\\/\\/anniedarling.tumblr.com","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"fecbcb","favourites_count":108,"protected":false,"statuses_count":15032,"notifications":null,"profile_use_background_image":true,"location":"","name":"\\uff61.ANNiE \\u2654 DARLiNG.\\uff61","friends_count":238,"profile_text_color":"fc9499","id":44583780,"id_str":"44583780","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/332083577\\/backpinkyfloral2.jpg","utc_offset":-18000},"id":229431494324678657,"possibly_sensitive":false,"in_reply_to_status_id_str":null,"id_str":"229431494324678657","entities":{"user_mentions":[],"hashtags":[],"urls":[{"display_url":"instagr.am\\/p\\/NprL-XP31P\\/","indices":[38,58],"expanded_url":"http:\\/\\/instagr.am\\/p\\/NprL-XP31P\\/","url":"http:\\/\\/t.co\\/9udSaNwk"}]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (21, '2012-07-29 04:36:53', 'tweet', '{"place":null,"favorited":false,"text":"RT @London2012: Gold: USA''s Ryan Lochte becomes 400m Individual Medley champion! A dominant victory at the Aquatics Centre #London2012 h ...","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":1872,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/android\\" rel=\\"nofollow\\"\\u003ETwitter for Android\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:38:27 +0000 2012","retweeted_status":{"place":null,"favorited":false,"text":"Gold: USA''s Ryan Lochte becomes 400m Individual Medley champion! A dominant victory at the Aquatics Centre #London2012 http:\\/\\/t.co\\/rrzu9Jz8","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":1872,"source":"web","created_at":"Sat Jul 28 19:25:35 +0000 2012","possibly_sensitive_editable":true,"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":7703,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"000000","time_zone":"London","screen_name":"London2012","default_profile":false,"following":null,"profile_background_color":"0099ff","is_translator":false,"show_all_inline_media":false,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/529763820\\/Twitter_blue.jpg","description":"Official Olympics and Paralympics channel - Sport, culture, behind the scenes information and opinion on the London 2012 Olympic and Paralympic Games","created_at":"Mon Feb 02 10:23:44 +0000 2009","profile_sidebar_fill_color":"ffffff","followers_count":1165192,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/563087689\\/TwitterPinkLogo_normal.jpg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/563087689\\/TwitterPinkLogo_normal.jpg","verified":true,"url":"http:\\/\\/www.london2012.com","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"ffffff","favourites_count":0,"protected":false,"statuses_count":2696,"notifications":null,"profile_use_background_image":true,"location":"London","name":"London 2012","friends_count":981,"profile_text_color":"000000","id":19900778,"id_str":"19900778","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/529763820\\/Twitter_blue.jpg","utc_offset":0},"id":229296561643986945,"possibly_sensitive":false,"in_reply_to_status_id_str":null,"id_str":"229296561643986945","entities":{"user_mentions":[],"hashtags":[{"text":"London2012","indices":[107,118]}],"urls":[{"display_url":"l2012.cm\\/MLWLsD","indices":[119,139],"expanded_url":"http:\\/\\/l2012.cm\\/MLWLsD","url":"http:\\/\\/t.co\\/rrzu9Jz8"}]},"in_reply_to_screen_name":null,"truncated":false},"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":1,"contributors_enabled":false,"geo_enabled":true,"profile_link_color":"0084B4","time_zone":null,"screen_name":"Ima_Bartender44","default_profile":true,"following":null,"profile_background_color":"C0DEED","is_translator":false,"show_all_inline_media":false,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/images\\/themes\\/theme1\\/bg.png","description":"In the evidence of its brilliance","created_at":"Mon Sep 19 02:36:33 +0000 2011","profile_sidebar_fill_color":"DDEEF6","followers_count":102,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2430825626\\/WhB0DnMx_normal","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2430825626\\/WhB0DnMx_normal","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"C0DEED","favourites_count":10,"protected":false,"statuses_count":3408,"notifications":null,"profile_use_background_image":true,"location":"Harford Road, Hon!","name":"Tweet Green Tea","friends_count":226,"profile_text_color":"333333","id":375975999,"id_str":"375975999","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/images\\/themes\\/theme1\\/bg.png","utc_offset":null},"id":229435698384613378,"in_reply_to_status_id_str":null,"id_str":"229435698384613378","entities":{"user_mentions":[{"indices":[3,14],"screen_name":"London2012","name":"London 2012","id":19900778,"id_str":"19900778"}],"hashtags":[{"text":"London2012","indices":[123,134]}],"urls":[]},"in_reply_to_screen_name":null,"truncated":true}', 0), | |
| (22, '2012-07-29 04:36:53', 'tweet', '{"place":null,"favorited":false,"text":"RT @ma3shita4ro: \\uff2e\\uff28\\uff2b\\u306e\\u67d4\\u9053\\u306e\\u30a4\\u30f3\\u30bf\\u30d3\\u30e5\\u30a2\\u30fc\\u4f55\\u69d8\\u306e\\u3064\\u3082\\u308a\\u306a\\u3093\\u3060\\uff01\\u9280\\u30e1\\u30c0\\u30eb\\u3092\\u7372\\u5f97\\u3057\\u305f\\u5e73\\u5ca1\\u3078\\u306e\\u7b2c\\u4e00\\u58f0\\u304c\\u300c\\u9280\\u30e1\\u30c0\\u30eb\\u3068\\u3044\\u3046\\u7d50\\u679c\\u306b\\u7d42\\u308f\\u3063\\u3066\\u3057\\u307e\\u3044\\u307e\\u3057\\u305f\\u304c\\u300d\\u3063\\u3066\\u3002\\u4e16\\u754c\\u306e\\uff12\\u756a\\u76ee\\u3092\\u8b83\\u3048\\u308b\\u4e00\\u8a00\\u304c\\u5148\\u3060\\u308d\\uff01\\u6319\\u3052\\u53e5\\u306e\\u679c\\u3066\\u306b\\u3001\\u30e1\\u30c0\\u30ea\\u30b9\\u30c8\\u306b\\u3001\\u300c\\u3059\\u307f\\u307e\\u305b\\u3093\\u3067\\u3057\\u305f\\u3002\\u300d\\u3068\\u8a00\\u308f\\u305b\\u308b\\u3068\\u306f\\u3002\\u8f9e ...","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":1822,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/android\\" rel=\\"nofollow\\"\\u003ETwitter for Android\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:38:28 +0000 2012","retweeted_status":{"place":null,"favorited":false,"text":"\\uff2e\\uff28\\uff2b\\u306e\\u67d4\\u9053\\u306e\\u30a4\\u30f3\\u30bf\\u30d3\\u30e5\\u30a2\\u30fc\\u4f55\\u69d8\\u306e\\u3064\\u3082\\u308a\\u306a\\u3093\\u3060\\uff01\\u9280\\u30e1\\u30c0\\u30eb\\u3092\\u7372\\u5f97\\u3057\\u305f\\u5e73\\u5ca1\\u3078\\u306e\\u7b2c\\u4e00\\u58f0\\u304c\\u300c\\u9280\\u30e1\\u30c0\\u30eb\\u3068\\u3044\\u3046\\u7d50\\u679c\\u306b\\u7d42\\u308f\\u3063\\u3066\\u3057\\u307e\\u3044\\u307e\\u3057\\u305f\\u304c\\u300d\\u3063\\u3066\\u3002\\u4e16\\u754c\\u306e\\uff12\\u756a\\u76ee\\u3092\\u8b83\\u3048\\u308b\\u4e00\\u8a00\\u304c\\u5148\\u3060\\u308d\\uff01\\u6319\\u3052\\u53e5\\u306e\\u679c\\u3066\\u306b\\u3001\\u30e1\\u30c0\\u30ea\\u30b9\\u30c8\\u306b\\u3001\\u300c\\u3059\\u307f\\u307e\\u305b\\u3093\\u3067\\u3057\\u305f\\u3002\\u300d\\u3068\\u8a00\\u308f\\u305b\\u308b\\u3068\\u306f\\u3002\\u8f9e\\u3081\\u3055\\u305b\\u308d\\uff01\\uff01 #london2012","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":1822,"source":"\\u003Ca href=\\"http:\\/\\/twipple.jp\\/\\" rel=\\"nofollow\\"\\u003E\\u3064\\u3044\\u3063\\u3077\\u308b for iPhone\\u003C\\/a\\u003E","created_at":"Sat Jul 28 15:46:04 +0000 2012","retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":7,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"990000","time_zone":"Tokyo","screen_name":"ma3shita4ro","default_profile":false,"following":null,"profile_background_color":"fa5d08","is_translator":false,"show_all_inline_media":false,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/309816893\\/img85687254zik3zj.jpg","description":"\\u6c17\\u307e\\u307e\\u306b\\u545f\\u3044\\u3066\\u307f\\u307e\\u3059\\u3002 \\u30a2\\u30eb\\u30d3\\/\\u30d0\\u30eb\\u30b5\\/\\u30de\\u30ea\\u30fc\\u30f3\\u30ba\\/\\u4ed6\\u30b9\\u30dd\\u30fc\\u30c4\\u30cd\\u30bf\\u3068\\u6642\\u4e8b\\u30cd\\u30bf\\u3068\\u3002","created_at":"Thu Apr 29 13:41:39 +0000 2010","profile_sidebar_fill_color":"F3F3F3","followers_count":108,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2422016254\\/image_normal.jpg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2422016254\\/image_normal.jpg","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"DFDFDF","favourites_count":38,"protected":false,"statuses_count":773,"notifications":null,"profile_use_background_image":true,"location":"\\u65b0\\u6f5f\\u770c\\u65b0\\u767a\\u7530\\u5e02","name":"masashi_tashiro","friends_count":192,"profile_text_color":"333333","id":138413819,"id_str":"138413819","lang":"ja","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/309816893\\/img85687254zik3zj.jpg","utc_offset":32400},"id":229241320311517185,"in_reply_to_status_id_str":null,"id_str":"229241320311517185","entities":{"user_mentions":[],"hashtags":[{"text":"london2012","indices":[126,137]}],"urls":[]},"in_reply_to_screen_name":null,"truncated":false},"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":3,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"0084B4","time_zone":"Tokyo","screen_name":"825magnet88","default_profile":true,"following":null,"profile_background_color":"C0DEED","is_translator":false,"show_all_inline_media":false,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/images\\/themes\\/theme1\\/bg.png","description":"\\u597d\\u304d\\u30ad\\u30e3\\u30e9\\u3068\\u304b\\u3044\\u3059\\u304e\\u3066\\u6319\\u3052\\u304d\\u308c\\u306a\\u3044www\\u3000\\u6700\\u8fd1\\u306f\\u7dd1\\u9ad8\\u306b\\u304a\\u71b1\\uff01\\u3000\\u30cf\\u30fc\\u30c8\\u306e\\u6d77\\u8cca\\u56e3\\u3000\\u4ffa\\u30c6\\u30a3\\u30fc\\u306e\\u5bd2\\u5ddd\\u53ef\\u611b\\u3059\\u304e\\u3066\\u6016\\u3044\\u3000RKRN\\u3059\\u304d\\u3059\\u304d\\u3000\\u30dd\\u30b1\\u30e2\\u30f3\\u3082\\u597d\\u304d\\uff5e\\u3000\\u30ec\\u30e0\\u30ec\\u30b9\\u5148\\u8f29\\u3080\\u3075\\u3075\\u3000\\u30e0\\u30e0\\u30ea\\u30af\\u89aa\\u5b50\\u3082\\u611b\\u3057\\u3066\\u308b\\u3000\\u203b\\u8150\\u3063\\u3066\\u307e\\u3059\\u306e\\u3067\\u6ce8\\u610f\\u3000\\u597d\\u304d\\u52dd\\u624b\\u545f\\u3044\\u3066\\u307e\\u3059\\u3000\\u4eba\\u898b\\u77e5\\u308a\\u3067\\u81ea\\u5206\\u304b\\u3089\\u8a71\\u3057\\u304b\\u3051\\u308b\\u3068\\u304b\\u3067\\u304d\\u306a\\u3044\\u7cfb\\u5973\\u5b50\\u3067\\u3059\\u3000\\u7d61\\u3093\\u3067\\u304f\\u308c\\u305f\\u3089\\u5b09\\u3057\\u3044\\u306a\\uff08\\u00b4\\u03c9\\uff40\\uff0a\\uff09","created_at":"Thu Dec 01 12:53:58 +0000 2011","profile_sidebar_fill_color":"DDEEF6","followers_count":141,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/1705513279\\/s4pp9lO1_normal","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/1705513279\\/s4pp9lO1_normal","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"C0DEED","favourites_count":1805,"protected":false,"statuses_count":8196,"notifications":null,"profile_use_background_image":true,"location":"\\u3053\\u305f\\u3064","name":"\\u78c1\\u77f3","friends_count":138,"profile_text_color":"333333","id":425795545,"id_str":"425795545","lang":"ja","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/images\\/themes\\/theme1\\/bg.png","utc_offset":32400},"id":229435699630317568,"in_reply_to_status_id_str":null,"id_str":"229435699630317568","entities":{"user_mentions":[{"indices":[3,15],"screen_name":"ma3shita4ro","name":"masashi_tashiro","id":138413819,"id_str":"138413819"}],"hashtags":[],"urls":[]},"in_reply_to_screen_name":null,"truncated":true}', 0), | |
| (23, '2012-07-29 04:36:55', 'tweet', '{"place":null,"favorited":false,"text":"RT @gmanews: American swimmer na si Ryan Lochte, binasag ang world record ni Michael Phelps #London2012 #BalitanghaliWeekend","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":12,"source":"web","created_at":"Sun Jul 29 04:38:29 +0000 2012","retweeted_status":{"place":null,"favorited":false,"text":"American swimmer na si Ryan Lochte, binasag ang world record ni Michael Phelps #London2012 #BalitanghaliWeekend","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":12,"source":"web","created_at":"Sun Jul 29 04:36:30 +0000 2012","retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":5717,"contributors_enabled":true,"geo_enabled":true,"profile_link_color":"9b3ee6","time_zone":"Singapore","screen_name":"gmanews","default_profile":false,"following":null,"profile_background_color":"330066","is_translator":false,"show_all_inline_media":true,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/612872365\\/dqf8aurg9a7r0iyhn6mi.jpeg","description":"The official Twitter account of GMA News in the Philippines.","created_at":"Tue May 12 07:14:09 +0000 2009","profile_sidebar_fill_color":"dbefff","followers_count":908942,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/1514133761\\/gmanews_logo_thinkversion_normal.png","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/1514133761\\/gmanews_logo_thinkversion_normal.png","verified":true,"url":"http:\\/\\/www.gmanews.tv","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"BDDCAD","favourites_count":617,"protected":false,"statuses_count":87889,"notifications":null,"profile_use_background_image":true,"location":"Philippines","name":"GMA News","friends_count":159,"profile_text_color":"333333","id":39453212,"id_str":"39453212","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/612872365\\/dqf8aurg9a7r0iyhn6mi.jpeg","utc_offset":28800},"id":229435207202263040,"in_reply_to_status_id_str":null,"id_str":"229435207202263040","entities":{"user_mentions":[],"hashtags":[{"text":"London2012","indices":[79,90]},{"text":"BalitanghaliWeekend","indices":[91,111]}],"urls":[]},"in_reply_to_screen_name":null,"truncated":false},"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":0,"contributors_enabled":false,"geo_enabled":true,"profile_link_color":"0084B4","time_zone":"Beijing","screen_name":"JorgePunzalan","default_profile":true,"following":null,"profile_background_color":"C0DEED","is_translator":false,"show_all_inline_media":false,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/images\\/themes\\/theme1\\/bg.png","description":"CICian ako: Maka-Diyos, Mahusay at Mapagkawanggawa. :) +","created_at":"Fri Jun 24 07:23:36 +0000 2011","profile_sidebar_fill_color":"DDEEF6","followers_count":87,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2418167376\\/f1nkbd7m342qlmzmxrh9_normal.jpeg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2418167376\\/f1nkbd7m342qlmzmxrh9_normal.jpeg","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"C0DEED","favourites_count":8538,"protected":false,"statuses_count":9532,"notifications":null,"profile_use_background_image":true,"location":"Cabanatuan City, Nueva Ecija","name":"Jorge Punzalan","friends_count":147,"profile_text_color":"333333","id":323094511,"id_str":"323094511","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/images\\/themes\\/theme1\\/bg.png","utc_offset":28800},"id":229435706303467520,"in_reply_to_status_id_str":null,"id_str":"229435706303467520","entities":{"user_mentions":[{"indices":[3,11],"screen_name":"gmanews","name":"GMA News","id":39453212,"id_str":"39453212"}],"hashtags":[{"text":"London2012","indices":[92,103]},{"text":"BalitanghaliWeekend","indices":[104,124]}],"urls":[]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (24, '2012-07-29 04:36:56', 'tweet', '{"place":null,"favorited":false,"text":"Wow Phelps is not even goin to get a medal in the 400m #London2012","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/iphone\\" rel=\\"nofollow\\"\\u003ETwitter for iPhone\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:38:30 +0000 2012","retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":9,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"0084B4","time_zone":"Pacific Time (US & Canada)","screen_name":"westcoastGREG21","default_profile":false,"following":null,"profile_background_color":"C0DEED","is_translator":false,"show_all_inline_media":false,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/303167957\\/christine-miss-double-d-summer-65.jpg","description":"Sex, Drugs, Rock n Roll, Dodgers,Music,Sports,Twitter!!!!","created_at":"Wed Jul 28 01:39:53 +0000 2010","profile_sidebar_fill_color":"DDEEF6","followers_count":255,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2344501046\\/fljttp62lgd06sfln23m_normal.jpeg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2344501046\\/fljttp62lgd06sfln23m_normal.jpeg","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"C0DEED","favourites_count":9,"protected":false,"statuses_count":9997,"notifications":null,"profile_use_background_image":true,"location":"Dodger Stadium ","name":"Greg!!","friends_count":545,"profile_text_color":"333333","id":171735130,"id_str":"171735130","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/303167957\\/christine-miss-double-d-summer-65.jpg","utc_offset":-28800},"id":229435710048968704,"in_reply_to_status_id_str":null,"id_str":"229435710048968704","entities":{"user_mentions":[],"hashtags":[{"text":"London2012","indices":[55,66]}],"urls":[]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (25, '2012-07-29 04:36:56', 'tweet', '{"place":null,"favorited":false,"text":"Ryan Lochte! #London2012 golden","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/iphone\\" rel=\\"nofollow\\"\\u003ETwitter for iPhone\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:38:30 +0000 2012","retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":3,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"009999","time_zone":"Pacific Time (US & Canada)","screen_name":"JakeAStephens","default_profile":false,"following":null,"profile_background_color":"131516","is_translator":false,"show_all_inline_media":false,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/images\\/themes\\/theme14\\/bg.gif","description":" 21 years old. Good waves & food keep me going. Holistic lifestyle. The farthest journey in life is the shortest distance. Psalm 136","created_at":"Fri Jun 17 07:42:55 +0000 2011","profile_sidebar_fill_color":"efefef","followers_count":137,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2250064138\\/image_normal.jpg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2250064138\\/image_normal.jpg","verified":false,"url":"http:\\/\\/www.facebook.com\\/jacobstephens","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"eeeeee","favourites_count":42,"protected":false,"statuses_count":1550,"notifications":null,"profile_use_background_image":true,"location":"Ocean Side, Cailfornia","name":"Jacob Stephens","friends_count":129,"profile_text_color":"333333","id":318911219,"id_str":"318911219","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/images\\/themes\\/theme14\\/bg.gif","utc_offset":-28800},"id":229435710346764288,"in_reply_to_status_id_str":null,"id_str":"229435710346764288","entities":{"user_mentions":[],"hashtags":[{"text":"London2012","indices":[13,24]}],"urls":[]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (26, '2012-07-29 04:36:56', 'tweet', '{"place":null,"favorited":false,"text":"RT @SonicJL9: Gonna wake up early to watch the soccer games #LONDON2012","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":1,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/iphone\\" rel=\\"nofollow\\"\\u003ETwitter for iPhone\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:38:30 +0000 2012","retweeted_status":{"place":null,"favorited":false,"text":"Gonna wake up early to watch the soccer games #LONDON2012","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":1,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/android\\" rel=\\"nofollow\\"\\u003ETwitter for Android\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:37:07 +0000 2012","retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":0,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"000000","time_zone":"Quito","screen_name":"SonicJL9","default_profile":false,"following":null,"profile_background_color":"ffffff","is_translator":false,"show_all_inline_media":true,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/333087543\\/777941-xs.jpg","description":"#TeamRMadrid #TeamLiverpool #TeamGuate #TeamRavens #TeamBocaJuniors","created_at":"Sat Dec 04 16:48:16 +0000 2010","profile_sidebar_fill_color":"fcfcfc","followers_count":157,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2304861820\\/1ggvbujtqc523uodicsi_normal.jpeg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2304861820\\/1ggvbujtqc523uodicsi_normal.jpeg","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"3300ff","favourites_count":17,"protected":false,"statuses_count":7140,"notifications":null,"profile_use_background_image":true,"location":"D[M]V","name":"Jose Leiva","friends_count":151,"profile_text_color":"2003ff","id":222847713,"id_str":"222847713","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/333087543\\/777941-xs.jpg","utc_offset":-18000},"id":229435360864776195,"in_reply_to_status_id_str":null,"id_str":"229435360864776195","entities":{"user_mentions":[],"hashtags":[{"text":"LONDON2012","indices":[46,57]}],"urls":[]},"in_reply_to_screen_name":null,"truncated":false},"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":10,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"009999","time_zone":"Eastern Time (US & Canada)","screen_name":"MyInterludeXIII","default_profile":false,"following":null,"profile_background_color":"131516","is_translator":false,"show_all_inline_media":true,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/394391524\\/thumb-17538723.jpg","description":"#ThankGodForTheSQUADDDDD. #VirginGang #Nigerian . #TrackNation. Track Star ..","created_at":"Fri Apr 02 03:25:53 +0000 2010","profile_sidebar_fill_color":"efefef","followers_count":678,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2401649552\\/image_normal.jpg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2401649552\\/image_normal.jpg","verified":false,"url":"http:\\/\\/www.facebook.com\\/profile.php?id=648498993","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"eeeeee","favourites_count":126,"protected":false,"statuses_count":69877,"notifications":null,"profile_use_background_image":true,"location":"(PG- Maryland) DMV ","name":"#VirginGang Lada","friends_count":488,"profile_text_color":"11253d","id":128758419,"id_str":"128758419","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/394391524\\/thumb-17538723.jpg","utc_offset":-18000},"id":229435710422278144,"in_reply_to_status_id_str":null,"id_str":"229435710422278144","entities":{"user_mentions":[{"indices":[3,12],"screen_name":"SonicJL9","name":"Jose Leiva","id":222847713,"id_str":"222847713"}],"hashtags":[{"text":"LONDON2012","indices":[60,71]}],"urls":[]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (27, '2012-07-29 04:36:56', 'tweet', '{"place":null,"favorited":false,"text":"Final score in Women''s Beach Volleyball, Game 2: Skins 21, Pants 19. #London2012","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/#!\\/download\\/ipad\\" rel=\\"nofollow\\"\\u003ETwitter for iPad\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:38:31 +0000 2012","retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":0,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"9D582E","time_zone":"Pacific Time (US & Canada)","screen_name":"brownmj61","default_profile":false,"following":null,"profile_background_color":"8B542B","is_translator":false,"show_all_inline_media":false,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/428027442\\/Downtown_Spokane_1960s.jpg","description":"Christian, husband, father, and middle school History\\/English teacher. I like cool tech tools & intelligent conversation, humor & entertainment. ","created_at":"Wed May 13 15:31:49 +0000 2009","profile_sidebar_fill_color":"EADEAA","followers_count":43,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2442826196\\/3guyeuim9o4dgf0e2rp5_normal.jpeg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2442826196\\/3guyeuim9o4dgf0e2rp5_normal.jpeg","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"D9B17E","favourites_count":21,"protected":false,"statuses_count":898,"notifications":null,"profile_use_background_image":true,"location":"Maple Valley, WA","name":"Michael Brown","friends_count":110,"profile_text_color":"333333","id":39772805,"id_str":"39772805","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/428027442\\/Downtown_Spokane_1960s.jpg","utc_offset":-28800},"id":229435711999340545,"in_reply_to_status_id_str":null,"id_str":"229435711999340545","entities":{"user_mentions":[],"hashtags":[{"text":"London2012","indices":[69,80]}],"urls":[]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (28, '2012-07-29 04:36:57', 'tweet', '{"place":null,"favorited":false,"text":"RT @London2012: Gold: USA''s Ryan Lochte becomes 400m Individual Medley champion! A dominant victory at the Aquatics Centre #London2012 h ...","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":1873,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/iphone\\" rel=\\"nofollow\\"\\u003ETwitter for iPhone\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:38:31 +0000 2012","retweeted_status":{"place":null,"favorited":false,"text":"Gold: USA''s Ryan Lochte becomes 400m Individual Medley champion! A dominant victory at the Aquatics Centre #London2012 http:\\/\\/t.co\\/rrzu9Jz8","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":1873,"source":"web","created_at":"Sat Jul 28 19:25:35 +0000 2012","possibly_sensitive_editable":true,"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":7703,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"000000","time_zone":"London","screen_name":"London2012","default_profile":false,"following":null,"profile_background_color":"0099ff","is_translator":false,"show_all_inline_media":false,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/529763820\\/Twitter_blue.jpg","description":"Official Olympics and Paralympics channel - Sport, culture, behind the scenes information and opinion on the London 2012 Olympic and Paralympic Games","created_at":"Mon Feb 02 10:23:44 +0000 2009","profile_sidebar_fill_color":"ffffff","followers_count":1165197,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/563087689\\/TwitterPinkLogo_normal.jpg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/563087689\\/TwitterPinkLogo_normal.jpg","verified":true,"url":"http:\\/\\/www.london2012.com","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"ffffff","favourites_count":0,"protected":false,"statuses_count":2696,"notifications":null,"profile_use_background_image":true,"location":"London","name":"London 2012","friends_count":981,"profile_text_color":"000000","id":19900778,"id_str":"19900778","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/529763820\\/Twitter_blue.jpg","utc_offset":0},"id":229296561643986945,"possibly_sensitive":false,"in_reply_to_status_id_str":null,"id_str":"229296561643986945","entities":{"user_mentions":[],"hashtags":[{"text":"London2012","indices":[107,118]}],"urls":[{"display_url":"l2012.cm\\/MLWLsD","indices":[119,139],"expanded_url":"http:\\/\\/l2012.cm\\/MLWLsD","url":"http:\\/\\/t.co\\/rrzu9Jz8"}]},"in_reply_to_screen_name":null,"truncated":false},"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":0,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"0084B4","time_zone":null,"screen_name":"reesiegirl14","default_profile":true,"following":null,"profile_background_color":"C0DEED","is_translator":false,"show_all_inline_media":false,"profile_background_tile":false,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/images\\/themes\\/theme1\\/bg.png","description":"17, Latter-Day Saint, native Texan, rollerblader, artist, proud english and history nerd :) ","created_at":"Wed Jul 25 06:35:41 +0000 2012","profile_sidebar_fill_color":"DDEEF6","followers_count":5,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2435889090\\/image_normal.jpg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2435889090\\/image_normal.jpg","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"C0DEED","favourites_count":0,"protected":false,"statuses_count":49,"notifications":null,"profile_use_background_image":true,"location":null,"name":"Morgan Reese","friends_count":22,"profile_text_color":"333333","id":715604676,"id_str":"715604676","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/images\\/themes\\/theme1\\/bg.png","utc_offset":null},"id":229435714595610624,"in_reply_to_status_id_str":null,"id_str":"229435714595610624","entities":{"user_mentions":[{"indices":[3,14],"screen_name":"London2012","name":"London 2012","id":19900778,"id_str":"19900778"}],"hashtags":[{"text":"London2012","indices":[123,134]}],"urls":[]},"in_reply_to_screen_name":null,"truncated":true}', 0), | |
| (29, '2012-07-29 04:36:57', 'tweet', '{"place":null,"favorited":false,"text":"RT @haneenM: Muslim athletes praying together at the Olympics! #Islam #Olympics #London2012 http:\\/\\/t.co\\/ZgcS6hDM","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":360,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/iphone\\" rel=\\"nofollow\\"\\u003ETwitter for iPhone\\u003C\\/a\\u003E","created_at":"Sun Jul 29 04:38:32 +0000 2012","possibly_sensitive_editable":true,"retweeted_status":{"place":null,"favorited":false,"text":"Muslim athletes praying together at the Olympics! #Islam #Olympics #London2012 http:\\/\\/t.co\\/ZgcS6hDM","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":360,"source":"\\u003Ca href=\\"http:\\/\\/twitter.com\\/download\\/iphone\\" rel=\\"nofollow\\"\\u003ETwitter for iPhone\\u003C\\/a\\u003E","created_at":"Sun Jul 29 02:32:39 +0000 2012","possibly_sensitive_editable":true,"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":2,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"93A644","time_zone":"Pacific Time (US & Canada)","screen_name":"haneenM","default_profile":false,"following":null,"profile_background_color":"B2DFDA","is_translator":false,"show_all_inline_media":false,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/611097078\\/mo10cmi2itfrhalby0ik.png","description":"Palestinian by blood. American by birth. Muslim by choice. Curious by nature. bio stolen from @ASE. kik: haneenmuhyeddin lost? follow me","created_at":"Thu Apr 23 02:55:40 +0000 2009","profile_sidebar_fill_color":"ffffff","followers_count":406,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2421115485\\/image_normal.jpg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2421115485\\/image_normal.jpg","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"eeeeee","favourites_count":852,"protected":false,"statuses_count":4301,"notifications":null,"profile_use_background_image":true,"location":"Charlotte, NC","name":"Haneen Muhyeddin","friends_count":362,"profile_text_color":"333333","id":34507245,"id_str":"34507245","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/611097078\\/mo10cmi2itfrhalby0ik.png","utc_offset":-28800},"id":229404035243991040,"possibly_sensitive":false,"in_reply_to_status_id_str":null,"id_str":"229404035243991040","entities":{"media":[{"type":"photo","indices":[79,99],"display_url":"pic.twitter.com\\/ZgcS6hDM","media_url_https":"https:\\/\\/p.twimg.com\\/Ay8BwS8CYAEFsGH.jpg","url":"http:\\/\\/t.co\\/ZgcS6hDM","expanded_url":"http:\\/\\/twitter.com\\/haneenM\\/status\\/229404035243991040\\/photo\\/1","sizes":{"small":{"resize":"fit","h":179,"w":340},"medium":{"resize":"fit","h":200,"w":380},"thumb":{"resize":"crop","h":150,"w":150},"large":{"resize":"fit","h":200,"w":380}},"media_url":"http:\\/\\/p.twimg.com\\/Ay8BwS8CYAEFsGH.jpg","id":229404035248185345,"id_str":"229404035248185345"}],"user_mentions":[],"hashtags":[{"text":"Islam","indices":[50,56]},{"text":"Olympics","indices":[57,66]},{"text":"London2012","indices":[67,78]}],"urls":[]},"in_reply_to_screen_name":null,"truncated":false},"retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":0,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"009999","time_zone":"Kuala Lumpur","screen_name":"irafarhanah","default_profile":false,"following":null,"profile_background_color":"131516","is_translator":false,"show_all_inline_media":false,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/359999357\\/tumblr_lbalc2B8NT1qbnrluo1_500.jpg","description":"I like money $$$ #YNWA","created_at":"Thu Jul 16 07:10:49 +0000 2009","profile_sidebar_fill_color":"efefef","followers_count":414,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2428480086\\/image_normal.jpg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2428480086\\/image_normal.jpg","verified":false,"url":null,"default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"eeeeee","favourites_count":291,"protected":false,"statuses_count":5540,"notifications":null,"profile_use_background_image":true,"location":"Malaysia","name":"Ira Farhanah","friends_count":295,"profile_text_color":"333333","id":57269524,"id_str":"57269524","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/359999357\\/tumblr_lbalc2B8NT1qbnrluo1_500.jpg","utc_offset":28800},"id":229435716801794048,"possibly_sensitive":false,"in_reply_to_status_id_str":null,"id_str":"229435716801794048","entities":{"media":[{"type":"photo","indices":[92,112],"display_url":"pic.twitter.com\\/ZgcS6hDM","media_url_https":"https:\\/\\/p.twimg.com\\/Ay8BwS8CYAEFsGH.jpg","source_status_id_str":"229404035243991040","url":"http:\\/\\/t.co\\/ZgcS6hDM","expanded_url":"http:\\/\\/twitter.com\\/haneenM\\/status\\/229404035243991040\\/photo\\/1","sizes":{"small":{"resize":"fit","h":179,"w":340},"medium":{"resize":"fit","h":200,"w":380},"thumb":{"resize":"crop","h":150,"w":150},"large":{"resize":"fit","h":200,"w":380}},"media_url":"http:\\/\\/p.twimg.com\\/Ay8BwS8CYAEFsGH.jpg","source_status_id":229404035243991040,"id":229404035248185345,"id_str":"229404035248185345"}],"user_mentions":[{"indices":[3,11],"screen_name":"haneenM","name":"Haneen Muhyeddin","id":34507245,"id_str":"34507245"}],"hashtags":[{"text":"Islam","indices":[63,69]},{"text":"Olympics","indices":[70,79]},{"text":"London2012","indices":[80,91]}],"urls":[]},"in_reply_to_screen_name":null,"truncated":false}', 0), | |
| (30, '2012-07-29 04:36:58', 'tweet', '{"place":null,"favorited":false,"text":"just watched the opening ceremony......so proud to be british!!! well done!!! #london2012","in_reply_to_user_id_str":null,"contributors":null,"coordinates":null,"geo":null,"retweet_count":0,"source":"web","created_at":"Sun Jul 29 04:38:32 +0000 2012","retweeted":false,"in_reply_to_user_id":null,"in_reply_to_status_id":null,"user":{"listed_count":0,"contributors_enabled":false,"geo_enabled":false,"profile_link_color":"1eb300","time_zone":"London","screen_name":"MarcMcLaren","default_profile":false,"following":null,"profile_background_color":"00ffea","is_translator":false,"show_all_inline_media":true,"profile_background_tile":true,"profile_background_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_background_images\\/551684108\\/Love_chicken.jpg","description":"Player, Coach, Ref and Fan. Love #LFC but most of all love the game. I''m a young guy trying fulfil my dreams! #YOLO","created_at":"Sun Aug 30 22:29:39 +0000 2009","profile_sidebar_fill_color":"ffffff","followers_count":160,"profile_image_url_https":"https:\\/\\/si0.twimg.com\\/profile_images\\/2224325021\\/561176_10150825653497643_500267642_9845323_1256048569_n_normal.jpg","profile_image_url":"http:\\/\\/a0.twimg.com\\/profile_images\\/2224325021\\/561176_10150825653497643_500267642_9845323_1256048569_n_normal.jpg","verified":false,"url":"http:\\/\\/www.facebook.com\\/marc.mclaren","default_profile_image":false,"follow_request_sent":null,"profile_sidebar_border_color":"0ca1eb","favourites_count":187,"protected":false,"statuses_count":1996,"notifications":null,"profile_use_background_image":true,"location":"Birmingham, UK","name":"Marc McLaren","friends_count":143,"profile_text_color":"e6002e","id":70232130,"id_str":"70232130","lang":"en","profile_background_image_url":"http:\\/\\/a0.twimg.com\\/profile_background_images\\/551684108\\/Love_chicken.jpg","utc_offset":0},"id":229435718013956096,"in_reply_to_status_id_str":null,"id_str":"229435718013956096","entities":{"user_mentions":[],"hashtags":[{"text":"london2012","indices":[78,89]}],"urls":[]},"in_reply_to_screen_name":null,"truncated":false}', 0); | |
| /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; | |
| /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; | |
| /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment