ASTERIXDB-1877: Tokenizer in FullText Search fix - Sets the starting offset of the string correctly before it is used in the tokenizer of FullTextContainsEvaluator. Change-Id: Ic949ccc0cc3e66c489f4c8435672a74c70b7c0e7 Reviewed-on: https://asterix-gerrit.ics.uci.edu/1668 Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu> Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu> Reviewed-by: Jianfeng Jia <jianfeng.jia@gmail.com> Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu> BAD: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

commit: ab01c87e5b700f1b90c67b6a58df4c225a6c88bc [log] [tgz]
author: Taewoo Kim <wangsaeu@yahoo.com> Sat Apr 08 16:43:11 2017 -0700
committer: Taewoo Kim <wangsaeu@gmail.com> Mon Apr 10 12:46:51 2017 -0700
tree: 0632493af4e105034c5042caa6e7149f54616c23
parent: 90fb051a0463b71c536c8a2041b67f1490ddd8d2 [diff]
diff --git a/asterixdb/asterix-app/data/fulltext/cloudberry_sample_tweet.adm b/asterixdb/asterix-app/data/fulltext/cloudberry_sample_tweet.adm
new file mode 100644
index 0000000..9e501ba
--- /dev/null
+++ b/asterixdb/asterix-app/data/fulltext/cloudberry_sample_tweet.adm

@@ -0,0 +1,100 @@
+{ "create_at": datetime("2015-11-23T16:14:03.000Z"), "id": 668945640186101761, "text": "Just posted a photo @ Campus Martius Park https://t.co/5Ax4E2CdWZ", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "coordinate": point("-83.04647491,42.33170228"), "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 48121888, "name": "Kevin McKague", "screen_name": "KevinOfMI", "lang": "en", "location": "Davison, Michigan", "create_at": date("2009-06-17"), "description": "I need to ride my bike until my brain shuts up and my muscles are screaming. \nRight after these donuts. Dad of 3.\n Visit my blog 18 Wheels and a 12-Speed Bike.", "followers_count": 1178, "friends_count": 1780, "statues_count": 22263 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Detroit, MI", "id": "b463d3bd6064861b", "name": "Detroit", "place_type": "city", "bounding_box": rectangle("-83.288056,42.255085 -82.91052,42.450488") }, "geo_tag": { "stateID": 26, "stateName": "Michigan", "countyID": 26163, "countyName": "Wayne", "cityID": 2622000, "cityName": "Detroit" } }
+{ "create_at": datetime("2015-11-23T16:14:03.000Z"), "id": 668945640370606080, "text": "These niggas next to me do not know how to stfu", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 2401270118, "name": "sad goon", "screen_name": "Yung_Yadig", "lang": "en", "location": "null", "create_at": date("2014-03-21"), "description": "don't follow me", "followers_count": 112, "friends_count": 224, "statues_count": 7778 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Downers Grove, IL", "id": "6af99a29bfae42a2", "name": "Downers Grove", "place_type": "city", "bounding_box": rectangle("-88.096689,41.744098 -87.983315,41.83907") }, "geo_tag": { "stateID": 17, "stateName": "Illinois", "countyID": 17043, "countyName": "DuPage", "cityID": 1720591, "cityName": "Downers Grove" } }
+{ "create_at": datetime("2015-11-23T16:14:03.000Z"), "id": 668945640471195652, "text": "Who wants to got see @minnesotaBASS with me at Beta this weekend?!?!", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 272486819 }}, "user": { "id": 333882909, "name": "Hannah Montana", "screen_name": "Oootentog", "lang": "en", "location": "Denver, CO", "create_at": date("2011-07-12"), "description": "GOD. Mile High City. ❤️ Miley Cyrus is my spirit animal. I really really really really really really like cats.", "followers_count": 1254, "friends_count": 474, "statues_count": 48340 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Denver, CO", "id": "b49b3053b5c25bf5", "name": "Denver", "place_type": "city", "bounding_box": rectangle("-105.109815,39.614151 -104.734372,39.812975") }, "geo_tag": { "stateID": 8, "stateName": "Colorado", "countyID": 8031, "countyName": "Denver", "cityID": 820000, "cityName": "Denver" } }
+{ "create_at": datetime("2015-11-23T16:14:03.000Z"), "id": 668945640508911616, "text": "I know that I let you down. Is it too late now to say sorry?", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 285176507, "name": "NINA XELYN", "screen_name": "nxelyn", "lang": "en", "location": "Norway/CA", "create_at": date("2011-04-20"), "description": "sc: nxelyn | gemini | sjsu", "followers_count": 232, "friends_count": 64, "statues_count": 1332 }, "place": { "country": "United States", "country_code": "United States", "full_name": "San Jose, CA", "id": "7d62cffe6f98f349", "name": "San Jose", "place_type": "city", "bounding_box": rectangle("-122.035311,37.193164 -121.71215,37.469154") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6085, "countyName": "Santa Clara", "cityID": 668000, "cityName": "San Jose" } }
+{ "create_at": datetime("2015-11-23T16:14:03.000Z"), "id": 668945640630521857, "text": "When did I become a ghost?", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 3432951521, "name": "blyss", "screen_name": "tempurrra", "lang": "en", "location": " kissing az 2 destinys child", "create_at": date("2015-08-20"), "description": "BEAT MY ASS OR SHUT UP", "followers_count": 699, "friends_count": 457, "statues_count": 10229 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Pembroke Pines, FL", "id": "5727d936119423c0", "name": "Pembroke Pines", "place_type": "city", "bounding_box": rectangle("-80.442683,25.992486 -80.213314,26.063293") }, "geo_tag": { "stateID": 12, "stateName": "Florida", "countyID": 12011, "countyName": "Broward", "cityID": 1255775, "cityName": "Pembroke Pines" } }
+{ "create_at": datetime("2015-11-23T16:14:03.000Z"), "id": 668945640819449857, "text": "@misscoorslight @NASCAR_XFINITY @NASCAR_Trucks You look Beautiful Amanda, Enjoy yourself !", "in_reply_to_status": 668923103632838656, "in_reply_to_user": 2484598129, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 2484598129, 20847350, 17105161 }}, "user": { "id": 2476720466, "name": "Mark Antczak", "screen_name": "Mark_751Ant", "lang": "en", "location": "New Jersey", "create_at": date("2014-05-04"), "description": "Love Nascar, Jeff Gordon #1, Yankees, Giants, Rangers, Weather, Love Abc7 News, Wish i was a Race Car Driver (Sprint Cup), WWJD.", "followers_count": 75, "friends_count": 695, "statues_count": 9159 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Bayonne, NJ", "id": "3d3c56338b6a3b4a", "name": "Bayonne", "place_type": "city", "bounding_box": rectangle("-74.146932,40.643773 -74.0658,40.697794") }, "geo_tag": { "stateID": 34, "stateName": "New Jersey", "countyID": 34017, "countyName": "Hudson", "cityID": 3403580, "cityName": "Bayonne" } }
+{ "create_at": datetime("2015-11-23T16:14:03.000Z"), "id": 668945641045893120, "text": "Rutgers gets Wake in the B1G/ACC Challenge...Demon Deacons just took down Indiana in Maui", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 323008880, "name": "Matt Hladik", "screen_name": "MattHladik919", "lang": "en", "location": "201", "create_at": date("2011-06-23"), "description": "Writer/Editor at http://Collegespun.com, formerly of @rivalsnewjersey ...Rutgers alum, proud New Jerseyan and Hudson County native...jack-of-all trades", "followers_count": 2318, "friends_count": 1803, "statues_count": 19414 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Hoboken, NJ", "id": "e9143a85705b4d40", "name": "Hoboken", "place_type": "city", "bounding_box": rectangle("-74.044085,40.7336 -74.020431,40.759159") }, "geo_tag": { "stateID": 34, "stateName": "New Jersey", "countyID": 34017, "countyName": "Hudson", "cityID": 3432250, "cityName": "Hoboken" } }
+{ "create_at": datetime("2015-11-23T16:14:03.000Z"), "id": 668945641121320961, "text": "‼️‼️‼️‼️‼️‼️ https://t.co/4MebTywHOB", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "und", "is_retweet": false, "user": { "id": 1191262604, "name": "Asia✨02/03❤️‼️", "screen_name": "AsiaCarlton", "lang": "en", "location": "Houston, TX", "create_at": date("2013-02-17"), "description": "I'm A Mf'Kn Queen ❣✊ #freenick", "followers_count": 1083, "friends_count": 924, "statues_count": 6067 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Houston, TX", "id": "1c69a67ad480e1b1", "name": "Houston", "place_type": "city", "bounding_box": rectangle("-95.823268,29.522325 -95.069705,30.154665") }, "geo_tag": { "stateID": 48, "stateName": "Texas", "countyID": 48201, "countyName": "Harris", "cityID": 4835000, "cityName": "Houston" } }
+{ "create_at": datetime("2015-11-23T16:14:03.000Z"), "id": 668945641335296000, "text": "@__morgssss__ hi", "in_reply_to_status": -1, "in_reply_to_user": 31514315, "favorite_count": 0, "retweet_count": 0, "lang": "und", "is_retweet": false, "user_mentions": {{ 31514315 }}, "user": { "id": 2922251677, "name": "ZainAwan", "screen_name": "zainzawan", "lang": "en", "location": "Racine, WI", "create_at": date("2014-12-07"), "description": "null", "followers_count": 640, "friends_count": 2009, "statues_count": 257 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Racine, WI", "id": "ce3b7b6f88f0b308", "name": "Racine", "place_type": "city", "bounding_box": rectangle("-87.877863,42.677972 -87.770388,42.799314") }, "geo_tag": { "stateID": 55, "stateName": "Wisconsin", "countyID": 55101, "countyName": "Racine", "cityID": 5566000, "cityName": "Racine" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945641700110336, "text": "I really like these pics I took on Friday�� https://t.co/8ry6XF7Hfe", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 230562362, "name": "Angelica", "screen_name": "angieolivaresss", "lang": "en", "location": "null", "create_at": date("2010-12-25"), "description": "ig: angieolivaresss", "followers_count": 1273, "friends_count": 712, "statues_count": 39895 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Pico Rivera, CA", "id": "e3505917a639e8ec", "name": "Pico Rivera", "place_type": "city", "bounding_box": rectangle("-118.123005,33.950457 -118.037043,34.037384") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6037, "countyName": "Los Angeles", "cityID": 656924, "cityName": "Pico Rivera" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945642115497984, "text": "Definite cough drop addict", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 3207575301, "name": "Alexyss", "screen_name": "AlexyssMarie7", "lang": "en", "location": "Sneads Ferry, NC", "create_at": date("2015-04-25"), "description": ":)(:", "followers_count": 68, "friends_count": 81, "statues_count": 1850 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Sneads Ferry, NC", "id": "008c5aba0de5eebc", "name": "Sneads Ferry", "place_type": "city", "bounding_box": rectangle("-77.409485,34.513794 -77.360135,34.568935") }, "geo_tag": { "stateID": 37, "stateName": "North Carolina", "countyID": 37133, "countyName": "Onslow", "cityID": 3762680, "cityName": "Sneads Ferry" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945642149036032, "text": "#ledyardffa members at the IMAGE conference at Aqua Turf Club. @ Aqua Turf Club https://t.co/qTfur8kdEG", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "coordinate": point("-72.87427231,41.57279355"), "retweet_count": 0, "lang": "en", "is_retweet": false, "hashtags": {{ "ledyardffa" }}, "user": { "id": 801273728, "name": "Bob Williams", "screen_name": "rwilliamslhs", "lang": "en", "location": "Connecticut, USA", "create_at": date("2012-09-03"), "description": "Ledyard HS Ag-Sci Teacher\r\nFormerly Habitat for Humanity International partner in the Philippines and long-time resident of General Santos City", "followers_count": 11, "friends_count": 6, "statues_count": 6 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Southington, CT", "id": "000086513b2042b6", "name": "Southington", "place_type": "city", "bounding_box": rectangle("-72.944738,41.544766 -72.818407,41.653245") }, "geo_tag": { "stateID": 9, "stateName": "Connecticut", "countyID": 9009, "countyName": "New Haven" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945642434072580, "text": "YES LADIES YES https://t.co/cPo6RuqYX4", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 3141836992, "name": "Janetta Crawford", "screen_name": "janettadeane", "lang": "en", "location": "Columbus, GA", "create_at": date("2015-04-06"), "description": "I've found a love greater than life itself.", "followers_count": 107, "friends_count": 239, "statues_count": 730 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Columbus, GA", "id": "00b673715a35dfa7", "name": "Columbus", "place_type": "city", "bounding_box": rectangle("-85.038673,32.373847 -84.795941,32.59076") }, "geo_tag": { "stateID": 13, "stateName": "Georgia", "countyID": 13215, "countyName": "Muscogee", "cityID": 1319000, "cityName": "Columbus" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945642459271168, "text": "Thanks a ton, @SOHFILMS", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 3397648810 }}, "user": { "id": 288990877, "name": "Kaplowitz", "screen_name": "iamkap", "lang": "en", "location": "PNW USA", "create_at": date("2011-04-27"), "description": "Born on Purim, but not last Purim. Cigars and Horse Racing, mostly. Will go to the dogs on occasion. Warning: spontaneous Yiddish may occur.", "followers_count": 4431, "friends_count": 84, "statues_count": 25336 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Eugene, OR", "id": "01241e9666cacdd2", "name": "Eugene", "place_type": "city", "bounding_box": rectangle("-123.208615,43.988281 -123.036188,44.142961") }, "geo_tag": { "stateID": 41, "stateName": "Oregon", "countyID": 41039, "countyName": "Lane", "cityID": 4123850, "cityName": "Eugene" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945642518024192, "text": "Interested in a #Hospitality #job near #Newark, DE? This could be a great fit: https://t.co/E17uOx5trj #Hiring https://t.co/u9RMCfIY0x", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "coordinate": point("-75.7496572,39.6837226"), "retweet_count": 0, "lang": "en", "is_retweet": false, "hashtags": {{ "Hospitality", "job", "Newark", "Hiring" }}, "user": { "id": 2535717440, "name": "Noodles Careers", "screen_name": "NoodlesCareers", "lang": "en", "location": "In your area", "create_at": date("2014-05-30"), "description": "We're looking for people who have a passion for restaurants and a mind for business. If you're looking for a career with us, you’re in the right place!", "followers_count": 297, "friends_count": 459, "statues_count": 2964 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Newark, DE", "id": "23aaa87ea90e76a4", "name": "Newark", "place_type": "city", "bounding_box": rectangle("-75.788669,39.6431 -75.723528,39.715087") }, "geo_tag": { "stateID": 10, "stateName": "Delaware", "countyID": 10003, "countyName": "New Castle", "cityID": 1050670, "cityName": "Newark" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945642606096384, "text": "@yyoonseok CNGRATS", "in_reply_to_status": 668945313491628032, "in_reply_to_user": 162278729, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 162278729 }}, "user": { "id": 141626420, "name": "ST☆RLIGHT_ADRIAN", "screen_name": "softhakyeon", "lang": "en", "location": "missouri | he/him | ♊ | INFP ", "create_at": date("2010-05-08"), "description": "adrian. elf, st☆rlight. DIGIMON. i talk abt rp a lot. gender: kim heechul | i'm in vixx hell and i love it | #10yearswithsuju | FREEZE, ARMOR DOWN!", "followers_count": 292, "friends_count": 834, "statues_count": 113781 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Clinton, MO", "id": "fc3cabb7fafa9f8d", "name": "Clinton", "place_type": "city", "bounding_box": rectangle("-93.801877,38.343979 -93.740328,38.397202") }, "geo_tag": { "stateID": 29, "stateName": "Missouri", "countyID": 29083, "countyName": "Henry", "cityID": 2914986, "cityName": "Clinton" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945642740449280, "text": "Omg DEACS!!!!", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 37855605, "name": "Kyle Fowler", "screen_name": "kfow35", "lang": "en", "location": "San Fran", "create_at": date("2009-05-04"), "description": "Client Developer @foursquare | Washed up WFU bball player", "followers_count": 820, "friends_count": 226, "statues_count": 9126 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Wheaton, IL", "id": "57ac88aefcd20988", "name": "Wheaton", "place_type": "city", "bounding_box": rectangle("-88.151554,41.814328 -88.074936,41.889152") }, "geo_tag": { "stateID": 17, "stateName": "Illinois", "countyID": 17043, "countyName": "DuPage", "cityID": 1781048, "cityName": "Wheaton" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945642773995520, "text": ")((@saltlet @et137h2o #TheUnsayable sh , ,,##HiddenLanguage(of((Trauma\" shh by bb by yy Annie Rogers, Ph.D.rEER° #ampathicdetermination #shh", "in_reply_to_status": 668795712876974081, "in_reply_to_user": 15834056, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "hashtags": {{ "TheUnsayable", "HiddenLanguage", "ampathicdetermination", "shh" }}, "user_mentions": {{ 7774932, 3988239299 }}, "user": { "id": 15834056, "name": "@mistake:.matrix.ore", "screen_name": "frets", "lang": "en", "location": "fb.com/dArEsAyGoThere", "create_at": date("2008-08-13"), "description": "∫misalias resequenci aftew cill cells, find link list stil bugs https://t.co/5DfovCtQkp baking up((#CC0)) #WWMappingDo et cent erra.° yo homo log ados reco cex.", "followers_count": 121, "friends_count": 238, "statues_count": 15057 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Baltimore, MD", "id": "c0b8e8dc81930292", "name": "Baltimore", "place_type": "city", "bounding_box": rectangle("-76.711517,39.197211 -76.529388,39.372215") }, "geo_tag": { "stateID": 24, "stateName": "Maryland", "countyID": 24510, "countyName": "Baltimore", "cityID": 2404000, "cityName": "Baltimore" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945642782330881, "text": "*finishes one sentence within a 10-page paper* https://t.co/g5ciHfSJto", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 311127234, "name": "Brandon Hooks", "screen_name": "CaptainBHooks", "lang": "en", "location": "null", "create_at": date("2011-06-04"), "description": "Sibling parent | cupcake connoisseur | Hillary's wingman | Mindy Kaling's best friend | Beyoncé's godchild", "followers_count": 406, "friends_count": 367, "statues_count": 15021 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Tuscaloosa, AL", "id": "3a22597bb94d08bd", "name": "Tuscaloosa", "place_type": "city", "bounding_box": rectangle("-87.626729,33.098411 -87.440084,33.29479") }, "geo_tag": { "stateID": 1, "stateName": "Alabama", "countyID": 1125, "countyName": "Tuscaloosa", "cityID": 177256, "cityName": "Tuscaloosa" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945643025530880, "text": "@erikgahner Nu ser jeg også at ved alle spg. om nabo i 08 er der 124 der har valgt \"Ved ikke\". Tusind tak for opklaringen.", "in_reply_to_status": 668943432606420992, "in_reply_to_user": 179502768, "favorite_count": 0, "retweet_count": 0, "lang": "da", "is_retweet": false, "user_mentions": {{ 179502768 }}, "user": { "id": 64785998, "name": "Morten Stinus", "screen_name": "mortenstinus", "lang": "en", "location": "Urbana-Champaign via Cph", "create_at": date("2009-08-11"), "description": "PhD-studerende ved UIUCs Institute of Communications Research. Jeg beskæftiger mig mest med strukturel racisme og mediefremstillinger af raciale minoriteter.", "followers_count": 317, "friends_count": 942, "statues_count": 5325 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Urbana, IL", "id": "497789c72fadba82", "name": "Urbana", "place_type": "city", "bounding_box": rectangle("-88.238573,40.072763 -88.162095,40.157407") }, "geo_tag": { "stateID": 17, "stateName": "Illinois", "countyID": 17019, "countyName": "Champaign", "cityID": 1777005, "cityName": "Urbana" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945643054870528, "text": "@Ange77H Too difficult to choose..He's damn good in all of them.", "in_reply_to_status": 668923587437461504, "in_reply_to_user": 20376964, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 20376964 }}, "user": { "id": 120995032, "name": "Shadowbunny49", "screen_name": "Angelica563", "lang": "en", "location": "Chandler, AZ", "create_at": date("2010-03-07"), "description": "Therapist", "followers_count": 24, "friends_count": 21, "statues_count": 832 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Chandler, AZ", "id": "52445186970bafb3", "name": "Chandler", "place_type": "city", "bounding_box": rectangle("-111.972849,33.203761 -111.788898,33.36114") }, "geo_tag": { "stateID": 4, "stateName": "Arizona", "countyID": 4013, "countyName": "Maricopa", "cityID": 412000, "cityName": "Chandler" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945643168210948, "text": "I'm at Cobb Miami Lakes 17 Theatre - @cobbtheatres for The Hunger Games: Mockingjay - Part 2 in Miami Lakes, FL https://t.co/Y4VNoCClyz", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "coordinate": point("-80.30993713,25.91395836"), "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 34640966 }}, "user": { "id": 62131700, "name": "Charlotte Ethel", "screen_name": "breadchastick03", "lang": "en", "location": "Miami, FL", "create_at": date("2009-08-01"), "description": "Traffic Manager at @MSSmedia. #Taco Obsessed, Lover of #Dinos & Human to Retired #Greyhound. Dislikes Babies & Puppies. Terrified of Pregnant Women & Spiders.", "followers_count": 488, "friends_count": 491, "statues_count": 16494 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Miami Lakes, FL", "id": "d286131d0c030d06", "name": "Miami Lakes", "place_type": "city", "bounding_box": rectangle("-80.351414,25.897971 -80.291808,25.927695") }, "geo_tag": { "stateID": 12, "stateName": "Florida", "countyID": 12086, "countyName": "Miami-Dade", "cityID": 1245100, "cityName": "Miami Lakes" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945643285581824, "text": "@OfficialDOGNews \nDo you have a selection?", "in_reply_to_status": 668945288695037952, "in_reply_to_user": 87409245, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 87409245 }}, "user": { "id": 428024537, "name": "Lori", "screen_name": "LoriB59", "lang": "en", "location": "Aliante North Las Vegas, NV", "create_at": date("2011-12-03"), "description": "Been here for 2 years now and loving it", "followers_count": 86, "friends_count": 289, "statues_count": 4541 }, "place": { "country": "United States", "country_code": "United States", "full_name": "North Las Vegas, NV", "id": "01c77c227d4ab0d5", "name": "North Las Vegas", "place_type": "city", "bounding_box": rectangle("-115.212251,36.184836 -115.054495,36.313413") }, "geo_tag": { "stateID": 32, "stateName": "Nevada", "countyID": 32003, "countyName": "Clark", "cityID": 3251800, "cityName": "North Las Vegas" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945643398938624, "text": "Does anybody wanna bring me circus peanuts and a slim jim.?", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 1699065727, "name": "The Babe Slayer", "screen_name": "CoolBlueStrat", "lang": "en", "location": "null", "create_at": date("2013-08-25"), "description": "I fart in crowded elevators", "followers_count": 497, "friends_count": 225, "statues_count": 11711 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Virginia Beach, VA", "id": "84229b03659050aa", "name": "Virginia Beach", "place_type": "city", "bounding_box": rectangle("-76.22808,36.672684 -75.911812,36.932399") }, "geo_tag": { "stateID": 51, "stateName": "Virginia", "countyID": 51810, "countyName": "Virginia Beach", "cityID": 5182000, "cityName": "Virginia Beach" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945643742851072, "text": "@annnabby_4 it's a dick", "in_reply_to_status": 668924231992909824, "in_reply_to_user": 351816036, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 351816036 }}, "user": { "id": 762815268, "name": "lola glitzthong", "screen_name": "pmarr5041", "lang": "en", "location": "just chillin, in cedar rapids", "create_at": date("2012-08-16"), "description": "sju18", "followers_count": 277, "friends_count": 385, "statues_count": 8602 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Philadelphia, PA", "id": "e4a0d228eb6be76b", "name": "Philadelphia", "place_type": "city", "bounding_box": rectangle("-75.280284,39.871811 -74.955712,40.13792") }, "geo_tag": { "stateID": 42, "stateName": "Pennsylvania", "countyID": 42101, "countyName": "Philadelphia", "cityID": 4260000, "cityName": "Philadelphia" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945643834994688, "text": "@Legaspii5 true", "in_reply_to_status": 668943089872932864, "in_reply_to_user": 1101428090, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 1101428090 }}, "user": { "id": 1016751848, "name": "DavidFlores.", "screen_name": "Deeeee123", "lang": "en", "location": "null", "create_at": date("2012-12-16"), "description": "WHERE MY DOGS AT?", "followers_count": 932, "friends_count": 568, "statues_count": 12000 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Visalia, CA", "id": "981989c5b11d5119", "name": "Visalia", "place_type": "city", "bounding_box": rectangle("-119.414399,36.26939 -119.224654,36.369582") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6107, "countyName": "Tulare", "cityID": 682954, "cityName": "Visalia" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945643952406528, "text": "lmfaoooooo", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 604349708, "name": "siekina.", "screen_name": "kinasaafi", "lang": "en", "location": "null", "create_at": date("2012-06-10"), "description": "#missmewiddit", "followers_count": 1136, "friends_count": 897, "statues_count": 17927 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Euless, TX", "id": "5e2d6c67e728cca5", "name": "Euless", "place_type": "city", "bounding_box": rectangle("-97.15606,32.81088 -97.032953,32.881593") }, "geo_tag": { "stateID": 48, "stateName": "Texas", "countyID": 48439, "countyName": "Tarrant", "cityID": 4824768, "cityName": "Euless" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945644027969536, "text": "If my baby ever need me I come speeding", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 110187297, "name": "Yung Zay™", "screen_name": "DaTalkOfFame", "lang": "en", "location": "MO CITY TX, Ridgemont 4", "create_at": date("2010-01-31"), "description": "Rich Is Gangsta #FAH #H52ver #HouGlo", "followers_count": 773, "friends_count": 570, "statues_count": 68608 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Sugar Land, TX", "id": "7a41192a2879ee24", "name": "Sugar Land", "place_type": "city", "bounding_box": rectangle("-95.686106,29.543372 -95.577273,29.663556") }, "geo_tag": { "stateID": 48, "stateName": "Texas", "countyID": 48157, "countyName": "Fort Bend", "cityID": 4870808, "cityName": "Sugar Land" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945644262850560, "text": "I just see this person and he looked just like @D_Boy3rd", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 2236812194 }}, "user": { "id": 605507434, "name": "✨", "screen_name": "adnariv", "lang": "en", "location": "isla vista", "create_at": date("2012-06-11"), "description": "blessed.humble.educated.focused", "followers_count": 1855, "friends_count": 966, "statues_count": 110760 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Isla Vista, CA", "id": "d82e2984d5b9a65e", "name": "Isla Vista", "place_type": "city", "bounding_box": rectangle("-119.881745,34.404565 -119.828412,34.438713") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6083, "countyName": "Santa Barbara", "cityID": 636868, "cityName": "Isla Vista" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945644279623680, "text": "Period lurking the terror is coming", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 161022279, "name": "✧peppermint snatch ✧", "screen_name": "MOLLYBEACH", "lang": "en", "location": "Seattle, WA", "create_at": date("2010-06-29"), "description": "shameless and vulgar ***********laugh or cringe PAYPAL: mollybeach@hotmail.com ✡ ✡✡ ✡ University of Washington", "followers_count": 8769, "friends_count": 2146, "statues_count": 56313 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Seattle, WA", "id": "300bcc6e23a88361", "name": "Seattle", "place_type": "city", "bounding_box": rectangle("-122.436232,47.495315 -122.224973,47.734561") }, "geo_tag": { "stateID": 53, "stateName": "Washington", "countyID": 53033, "countyName": "King", "cityID": 5363000, "cityName": "Seattle" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945644665577473, "text": "Stuck on a trail in the middle of nowhere. On a bike, pitch dark. This is… https://t.co/1W4GkBMkK6", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "coordinate": point("-88.83845593,37.52341548"), "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 424017482, "name": "Justin Mann", "screen_name": "JMMann07", "lang": "en", "location": "null", "create_at": date("2011-11-28"), "description": "Vagabond ✌️", "followers_count": 88, "friends_count": 160, "statues_count": 2823 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Illinois, USA", "id": "f54a2170ff4b15f7", "name": "Illinois", "place_type": "admin", "bounding_box": rectangle("-91.51308,36.970298 -87.019935,42.508303") }, "geo_tag": { "stateID": 17, "stateName": "Illinois", "countyID": 17087, "countyName": "Johnson" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945644673830912, "text": "��FairFax", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 72449959, "name": "Alex", "screen_name": "ItsAlexO_", "lang": "en", "location": "New York, NY", "create_at": date("2009-09-07"), "description": "info.alexordonez@gmail.com dean@d1models.com", "followers_count": 2256, "friends_count": 160, "statues_count": 24701 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Los Angeles, CA", "id": "3b77caf94bfc81fe", "name": "Los Angeles", "place_type": "city", "bounding_box": rectangle("-118.668404,33.704538 -118.155409,34.337041") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6037, "countyName": "Los Angeles", "cityID": 644000, "cityName": "Los Angeles" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945644845928448, "text": "Holy 3's Jesus Christ", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 2795701071, "name": "Swisher 2.0", "screen_name": "nicholasmuhl", "lang": "en", "location": "Bowling Green, Ohio", "create_at": date("2014-09-30"), "description": "Bowling Green State University - Lambda Chi Alpha - Political Science/Philosophy. Live our lives so well that Death trembles to take us.", "followers_count": 321, "friends_count": 407, "statues_count": 7116 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Bowling Green, OH", "id": "001bdb1154d55f66", "name": "Bowling Green", "place_type": "city", "bounding_box": rectangle("-83.690916,41.348047 -83.600702,41.426132") }, "geo_tag": { "stateID": 39, "stateName": "Ohio", "countyID": 39173, "countyName": "Wood", "cityID": 3907972, "cityName": "Bowling Green" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945645068251138, "text": "@bukakecreamteam I would try it and see what happens", "in_reply_to_status": 668944767288344576, "in_reply_to_user": 1640468898, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 1640468898 }}, "user": { "id": 34009973, "name": "uncle louie", "screen_name": "revodrewtion", "lang": "en", "location": "Toledo, OH", "create_at": date("2009-04-21"), "description": "be cool", "followers_count": 239, "friends_count": 228, "statues_count": 12631 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Toledo, OH", "id": "7068dd9474ab6973", "name": "Toledo", "place_type": "city", "bounding_box": rectangle("-83.694776,41.580375 -83.454566,41.732806") }, "geo_tag": { "stateID": 39, "stateName": "Ohio", "countyID": 39095, "countyName": "Lucas", "cityID": 3977000, "cityName": "Toledo" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945645114400768, "text": "Lets go B-LO #Sabres https://t.co/dtWM3V9uqx", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "hashtags": {{ "Sabres" }}, "user": { "id": 315948163, "name": "Angie", "screen_name": "niagarangie", "lang": "en", "location": "Niagara Falls ", "create_at": date("2011-06-12"), "description": "I was born in a city we call Buffalo; zero degrees below is too damn cold and funky.", "followers_count": 213, "friends_count": 641, "statues_count": 385 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Niagara Falls, NY", "id": "eec8e86da985fc44", "name": "Niagara Falls", "place_type": "city", "bounding_box": rectangle("-79.075086,43.07079 -78.942516,43.132798") }, "geo_tag": { "stateID": 36, "stateName": "New York", "countyID": 36063, "countyName": "Niagara", "cityID": 3651055, "cityName": "Niagara Falls" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945645181399040, "text": "A few things I took from that game. 1. The Hoosiers should not be ranked. 2. Bill Walton is insane. 3. Tom Crean should still be fired.", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 35416457, "name": "Sam Schlesinger", "screen_name": "Sam_Schlesinger", "lang": "en", "location": "Indiana", "create_at": date("2009-04-25"), "description": "Sports enthusiast, drummer, student of the world, aspiring advertiser, champion of time. Go Hoosiers!", "followers_count": 250, "friends_count": 180, "statues_count": 12985 }, "place": { "country": "United States", "country_code": "United States", "full_name": "San Francisco, CA", "id": "5a110d312052166f", "name": "San Francisco", "place_type": "city", "bounding_box": rectangle("-122.514926,37.708075 -122.357031,37.833238") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6075, "countyName": "San Francisco", "cityID": 667000, "cityName": "San Francisco" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945645265399808, "text": "@dannyviLe @ElnegroTrias Esperemos q no...........", "in_reply_to_status": 668945384392294401, "in_reply_to_user": 255476951, "favorite_count": 0, "retweet_count": 0, "lang": "es", "is_retweet": false, "user_mentions": {{ 255476951, 158804385 }}, "user": { "id": 523443923, "name": "Un Uruguayo", "screen_name": "abbu25", "lang": "en", "location": "Chicago-Montevideo", "create_at": date("2012-03-13"), "description": "Grado 5 en imperiologia y en fraudeamplismo.", "followers_count": 1340, "friends_count": 484, "statues_count": 87425 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Brooklyn, NY", "id": "011add077f4d2da3", "name": "Brooklyn", "place_type": "city", "bounding_box": rectangle("-74.041878,40.570842 -73.855673,40.739434") }, "geo_tag": { "stateID": 36, "stateName": "New York", "countyID": 36047, "countyName": "Kings", "cityID": 36047, "cityName": "Brooklyn" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945645416415233, "text": "Cannot believe IU just lost that", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 220092617, "name": "Katie Butler", "screen_name": "katbutler09", "lang": "en", "location": "null", "create_at": date("2010-11-26"), "description": "Oregon | Indiana", "followers_count": 245, "friends_count": 435, "statues_count": 6311 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Granger, IN", "id": "20dc6048f416c894", "name": "Granger", "place_type": "city", "bounding_box": rectangle("-86.217544,41.709039 -86.023537,41.760686") }, "geo_tag": { "stateID": 18, "stateName": "Indiana", "countyID": 18141, "countyName": "St. Joseph", "cityID": 1828800, "cityName": "Granger" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945645441388545, "text": "What are you doing for the rest of your life?", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 169799230, "name": "heidi b elizondo", "screen_name": "heidibeatriz", "lang": "en", "location": "null", "create_at": date("2010-07-22"), "description": "Pies, para que los quiero si tengo alas para volar -Frida Kahlo", "followers_count": 123, "friends_count": 191, "statues_count": 1677 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Tucson, AZ", "id": "013379ee5729a5e6", "name": "Tucson", "place_type": "city", "bounding_box": rectangle("-111.083219,32.057802 -110.747928,32.320979") }, "geo_tag": { "stateID": 4, "stateName": "Arizona", "countyID": 4019, "countyName": "Pima", "cityID": 477000, "cityName": "Tucson" } }
+{ "create_at": datetime("2015-11-23T16:14:04.000Z"), "id": 668945645693087744, "text": "Especially the fat ones https://t.co/8CKQBlDSRz", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 1732458362, "name": "Robert Carrillo", "screen_name": "Rob_Goes_Raw", "lang": "en", "location": "Rancho Cucamonga", "create_at": date("2013-09-05"), "description": "fitness. let a real nigga make it right.\nA straight up never serious disrespectful ass nigga.\nnothing i say i mean.", "followers_count": 386, "friends_count": 318, "statues_count": 36058 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Fontana, CA", "id": "d838baf51d1c629d", "name": "Fontana", "place_type": "city", "bounding_box": rectangle("-117.524329,34.033432 -117.401067,34.182889") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6071, "countyName": "San Bernardino", "cityID": 624680, "cityName": "Fontana" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945645873577985, "text": "@natalieeweber @katieannevan do you reliever Christmas lights too? I too need to go that way but I'm cold", "in_reply_to_status": 668943746235527169, "in_reply_to_user": 89072530, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 89072530, 1942885938 }}, "user": { "id": 131608454, "name": "Kayli ☪☯☼❁", "screen_name": "kaymillzz", "lang": "en", "location": "CMU", "create_at": date("2010-04-10"), "description": "Portuguese / ♐ / delta phi epsilon", "followers_count": 835, "friends_count": 769, "statues_count": 42195 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Mount Pleasant, MI", "id": "77f923f5a841bbdf", "name": "Mount Pleasant", "place_type": "city", "bounding_box": rectangle("-84.816945,43.553246 -84.727407,43.63446") }, "geo_tag": { "stateID": 26, "stateName": "Michigan", "countyID": 26073, "countyName": "Isabella", "cityID": 2656020, "cityName": "Mount Pleasant" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945646183837697, "text": "Yo...Nehme's AP calculus...if y'all got that packet due tomorrow...send it :)", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 150267997, "name": "Mayorga™", "screen_name": "imayorga_", "lang": "en", "location": "Yikes ", "create_at": date("2010-05-31"), "description": "Thick thighs & heart eyes", "followers_count": 627, "friends_count": 505, "statues_count": 8001 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Hialeah, FL", "id": "629f4a26fed69cd3", "name": "Hialeah", "place_type": "city", "bounding_box": rectangle("-80.356354,25.806057 -80.252971,25.909407") }, "geo_tag": { "stateID": 12, "stateName": "Florida", "countyID": 12086, "countyName": "Miami-Dade", "cityID": 1230000, "cityName": "Hialeah" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945646339031040, "text": "@alkutbay wtf why is qdoba losing", "in_reply_to_status": 668936130193059840, "in_reply_to_user": 2844400954, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 2844400954 }}, "user": { "id": 2844400954, "name": "Cam Rellim", "screen_name": "alkutbay", "lang": "en", "location": "Oklahoma, USA", "create_at": date("2014-10-25"), "description": "boring white boy", "followers_count": 942, "friends_count": 95, "statues_count": 454 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Norman, OK", "id": "27de1a6e27075587", "name": "Norman", "place_type": "city", "bounding_box": rectangle("-97.51982,35.15327 -97.370527,35.291332") }, "geo_tag": { "stateID": 40, "stateName": "Oklahoma", "countyID": 40027, "countyName": "Cleveland", "cityID": 4052500, "cityName": "Norman" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945646422855680, "text": "@queengost @tradethecycles @CronkiteSays https://t.co/X5gexwzSJl", "in_reply_to_status": 668944542217969664, "in_reply_to_user": 2760050529, "favorite_count": 0, "retweet_count": 0, "lang": "und", "is_retweet": false, "user_mentions": {{ 2760050529, 24716002, 2546562188 }}, "user": { "id": 289256811, "name": "Barbara Jensen", "screen_name": "BarbaraJensen1", "lang": "en", "location": "California", "create_at": date("2011-04-28"), "description": "English Instructor, Merritt Writing Program, UC Merced; constitutional conservative; spinal reconstruction advocate; cat lady in training", "followers_count": 1614, "friends_count": 2446, "statues_count": 13863 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Turlock, CA", "id": "ee2cfc9feb061a08", "name": "Turlock", "place_type": "city", "bounding_box": rectangle("-120.912851,37.459822 -120.812106,37.53937") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6099, "countyName": "Stanislaus", "cityID": 680812, "cityName": "Turlock" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945646532063234, "text": "Huge mistake", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 1307683278, "name": "Raquel", "screen_name": "RaquelYPadilla", "lang": "en", "location": "North Carolina, USA", "create_at": date("2013-03-27"), "description": "wake up and be fucking amazing", "followers_count": 565, "friends_count": 291, "statues_count": 348 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Half Moon, NC", "id": "f65751b1ab474517", "name": "Half Moon", "place_type": "city", "bounding_box": rectangle("-77.477448,34.793941 -77.437472,34.85045") }, "geo_tag": { "stateID": 37, "stateName": "North Carolina", "countyID": 37133, "countyName": "Onslow", "cityID": 3728900, "cityName": "Half Moon" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945646725017600, "text": "life is so good rn honestly", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 467083422, "name": "Vish✊", "screen_name": "vishushu14", "lang": "en", "location": "htx", "create_at": date("2012-01-17"), "description": "null", "followers_count": 773, "friends_count": 612, "statues_count": 31019 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Houston, TX", "id": "1c69a67ad480e1b1", "name": "Houston", "place_type": "city", "bounding_box": rectangle("-95.823268,29.522325 -95.069705,30.154665") }, "geo_tag": { "stateID": 48, "stateName": "Texas", "countyID": 48201, "countyName": "Harris", "cityID": 4835000, "cityName": "Houston" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945646850736128, "text": "������ https://t.co/snic0W4YJN", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "und", "is_retweet": false, "user": { "id": 3645728412, "name": "Marilyn Jordan", "screen_name": "marilynjordann", "lang": "en", "location": "Anaheim, CA", "create_at": date("2015-09-21"), "description": "null", "followers_count": 45, "friends_count": 121, "statues_count": 231 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Anaheim, CA", "id": "0c2e6999105f8070", "name": "Anaheim", "place_type": "city", "bounding_box": rectangle("-118.017789,33.788913 -117.684389,33.896813") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6059, "countyName": "Orange", "cityID": 602000, "cityName": "Anaheim" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945647035219969, "text": "On Saturday/Sunday, December 5/6 @RideSacRT will use special buses between Broadway & Florin Stations while @TheCityofSac constructs bridge.", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 316621010, 69359090 }}, "user": { "id": 1381072680, "name": "Ride Downtown 916", "screen_name": "RideDowntown916", "lang": "en", "location": "Downtown Sacramento, CA 95811", "create_at": date("2013-04-25"), "description": "A grassroots organization showing support for using public transportation throughout the 7-County, 29-City @SACOG & @SJCOG Regions to & from @docosacramento.", "followers_count": 856, "friends_count": 1680, "statues_count": 22588 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Sacramento, CA", "id": "b71fac2ee9792cbe", "name": "Sacramento", "place_type": "city", "bounding_box": rectangle("-121.576613,38.43792 -121.362715,38.685512") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6067, "countyName": "Sacramento", "cityID": 664000, "cityName": "Sacramento" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945647068971008, "text": "@BenRiegel there are two broadcast available on league pass (tv) one is the magic feed. I'm watching it now", "in_reply_to_status": 668945492286554112, "in_reply_to_user": 37227889, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 37227889 }}, "user": { "id": 41074446, "name": "MegB", "screen_name": "RobandMeg", "lang": "en", "location": "Staten Island, NY", "create_at": date("2009-05-19"), "description": "Wife, Music Lover, Love taking my car to the track, Born and raised Texan now living in NYC, Texans fan and Orlando Magic fan! Find me on instagram: Meg180", "followers_count": 242, "friends_count": 413, "statues_count": 2668 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Staten Island, NY", "id": "00c55f041e27dc51", "name": "Staten Island", "place_type": "city", "bounding_box": rectangle("-74.255641,40.495865 -74.052253,40.648887") }, "geo_tag": { "stateID": 36, "stateName": "New York", "countyID": 36085, "countyName": "Richmond", "cityID": 36085, "cityName": "Staten Island" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945647211417601, "text": "@WorldStarFunny another one of my favorites lol", "in_reply_to_status": 666397911123673088, "in_reply_to_user": 1107613844, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 1107613844 }}, "user": { "id": 2720501208, "name": "you", "screen_name": "Xfromdelcity", "lang": "en", "location": "null", "create_at": date("2014-08-09"), "description": "My net worth a good 4 cents", "followers_count": 546, "friends_count": 1044, "statues_count": 8678 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Oklahoma City, OK", "id": "9531d4e3bbafc09d", "name": "Oklahoma City", "place_type": "city", "bounding_box": rectangle("-97.768683,35.290722 -97.335639,35.674965") }, "geo_tag": { "stateID": 40, "stateName": "Oklahoma", "countyID": 40109, "countyName": "Oklahoma", "cityID": 4055000, "cityName": "Oklahoma City" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945647257579520, "text": "You girl think I'm a sweetheart", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 3237243120, "name": "Kenneth", "screen_name": "AhunnidKay", "lang": "en", "location": "Los Angeles / Riv", "create_at": date("2015-06-05"), "description": "$traight We$t Coa$tin", "followers_count": 265, "friends_count": 252, "statues_count": 1876 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Riverside, CA", "id": "6ba08e404aed471f", "name": "Riverside", "place_type": "city", "bounding_box": rectangle("-117.523867,33.85216 -84.097028,39.79369") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6065, "countyName": "Riverside", "cityID": 662000, "cityName": "Riverside" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945647391870976, "text": "Headshots got his eyes closed up", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 524764757, "name": "King", "screen_name": "BossedUpAnt", "lang": "en", "location": "Chad Brown to Pumgansett St", "create_at": date("2012-03-14"), "description": "null", "followers_count": 575, "friends_count": 278, "statues_count": 25249 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Providence, RI", "id": "7b93be1d864cedbb", "name": "Providence", "place_type": "city", "bounding_box": rectangle("-71.474186,41.772455 -71.369479,41.861713") }, "geo_tag": { "stateID": 44, "stateName": "Rhode Island", "countyID": 44007, "countyName": "Providence", "cityID": 4459000, "cityName": "Providence" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945647559553025, "text": "promise I'll be alright.", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 234632195, "name": "tina.", "screen_name": "ThatGirlAsiaa", "lang": "en", "location": "Denton, TX", "create_at": date("2011-01-05"), "description": "#LLL #UNT18", "followers_count": 1287, "friends_count": 828, "statues_count": 115486 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Denton, TX", "id": "f77b0bf942a40070", "name": "Denton", "place_type": "city", "bounding_box": rectangle("-97.187543,33.128938 -97.041998,33.276053") }, "geo_tag": { "stateID": 48, "stateName": "Texas", "countyID": 48121, "countyName": "Denton", "cityID": 4819972, "cityName": "Denton" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945647702142976, "text": "I'm not about to go Black Friday shopping all these broke bitches out here trying to pick pocket .. Ima just wait till cyber Monday.", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 3904944612, "name": "MJ", "screen_name": "rideordie_x", "lang": "en", "location": "Naperville, IL", "create_at": date("2015-10-15"), "description": "Problem solver. Coffee nerd. Typical social mediaholic. Socialite. Infuriatingly humble writer.", "followers_count": 95, "friends_count": 441, "statues_count": 481 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Wheaton, IL", "id": "57ac88aefcd20988", "name": "Wheaton", "place_type": "city", "bounding_box": rectangle("-88.151554,41.814328 -88.074936,41.889152") }, "geo_tag": { "stateID": 17, "stateName": "Illinois", "countyID": 17043, "countyName": "DuPage", "cityID": 1781048, "cityName": "Wheaton" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945647752634372, "text": "I'm at Chicago O'Hare International Airport (ORD) in Chicago, IL https://t.co/86uoo20SDv", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "coordinate": point("-87.90440083,41.97727092"), "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 9206662, "name": "Matt", "screen_name": "jmatthew007", "lang": "en", "location": "Chicago", "create_at": date("2007-10-02"), "description": "Father of three, Married, Northwestern Alum. Basketball and Football tweets. Usually left leaning. Likes beer and BBQ. Destiny addict", "followers_count": 171, "friends_count": 966, "statues_count": 2148 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Chicago, IL", "id": "1d9a5370a355ab0c", "name": "Chicago", "place_type": "city", "bounding_box": rectangle("-87.940033,41.644102 -87.523993,42.023067") }, "geo_tag": { "stateID": 17, "stateName": "Illinois", "countyID": 17031, "countyName": "Cook", "cityID": 1714000, "cityName": "Chicago" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945648637509632, "text": "I want coffee ��", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 1576825423, "name": "Stephanie ✨", "screen_name": "Steeeeeeephy", "lang": "en", "location": "null", "create_at": date("2013-07-07"), "description": "blessed", "followers_count": 857, "friends_count": 806, "statues_count": 8735 }, "place": { "country": "United States", "country_code": "United States", "full_name": "San Antonio, TX", "id": "3df4f427b5a60fea", "name": "San Antonio", "place_type": "city", "bounding_box": rectangle("-98.778559,29.141956 -98.302744,29.693046") }, "geo_tag": { "stateID": 48, "stateName": "Texas", "countyID": 48029, "countyName": "Bexar", "cityID": 4865000, "cityName": "San Antonio" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945649203679232, "text": "Let me know how that works out for you ������ https://t.co/dyl3q3VDi5", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 1965797882, "name": "Empress Ebony", "screen_name": "Ebony_Anissa14", "lang": "en", "location": "Pville", "create_at": date("2013-10-16"), "description": "null", "followers_count": 437, "friends_count": 365, "statues_count": 2099 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Austin, TX", "id": "c3f37afa9efcf94b", "name": "Austin", "place_type": "city", "bounding_box": rectangle("-97.928935,30.127892 -97.580513,30.518799") }, "geo_tag": { "stateID": 48, "stateName": "Texas", "countyID": 48453, "countyName": "Travis", "cityID": 4805000, "cityName": "Austin" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945649287720960, "text": "It was supposed to be a #sunny #day @ Hinsdale, Illinois https://t.co/n6FgTtmBdB", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "coordinate": point("-87.9369,41.8008"), "retweet_count": 0, "lang": "en", "is_retweet": false, "hashtags": {{ "sunny", "day" }}, "user": { "id": 544854654, "name": "Anthony Poselenzny", "screen_name": "APoselenzny", "lang": "en", "location": "Naperville, Il.", "create_at": date("2012-04-03"), "description": "Retired UPSer, Married, 3 children, 2 married, a grandfather, conservative Republican, living in Chicago area. Volunteer mentor at SCORE.", "followers_count": 1138, "friends_count": 1999, "statues_count": 19070 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Hinsdale, IL", "id": "a2e9665d39e55b17", "name": "Hinsdale", "place_type": "city", "bounding_box": rectangle("-87.952677,41.763847 -87.899883,41.828954") }, "geo_tag": { "stateID": 17, "stateName": "Illinois", "countyID": 17043, "countyName": "DuPage", "cityID": 1735307, "cityName": "Hinsdale" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945649489027073, "text": "@Nancy_burns15 wow hot af!!!", "in_reply_to_status": 668942151531806723, "in_reply_to_user": 921362670, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 921362670 }}, "user": { "id": 2764310613, "name": "Lexie Collard", "screen_name": "lexcollard", "lang": "en", "location": "null", "create_at": date("2014-09-07"), "description": "i ❤️ me https://twitter.com/worstofaidol/status/664509180678656001", "followers_count": 333, "friends_count": 307, "statues_count": 1575 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Deer Park, NY", "id": "081822bec6f679d4", "name": "Deer Park", "place_type": "city", "bounding_box": rectangle("-73.354311,40.740662 -73.295069,40.783594") }, "geo_tag": { "stateID": 36, "stateName": "New York", "countyID": 36103, "countyName": "Suffolk", "cityID": 3619972, "cityName": "Deer Park" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945649522630656, "text": "@kaitlynoc3 jus tell me", "in_reply_to_status": 668933687640244225, "in_reply_to_user": 1705572553, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 1705572553 }}, "user": { "id": 559889001, "name": "Eazy_Jesuzzz", "screen_name": "eejholmes", "lang": "en", "location": "null", "create_at": date("2012-04-21"), "description": "trap_607 wher it always ☔️", "followers_count": 203, "friends_count": 898, "statues_count": 2972 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Oneonta, NY", "id": "ff9cc975fb01f747", "name": "Oneonta", "place_type": "city", "bounding_box": rectangle("-75.108773,42.433438 -74.980422,42.478019") }, "geo_tag": { "stateID": 36, "stateName": "New York", "countyID": 36077, "countyName": "Otsego", "cityID": 3654881, "cityName": "Oneonta" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945649560190976, "text": "@laceyloo17 he'll be at @ParadeOfLasers ☺️", "in_reply_to_status": 668942603585474560, "in_reply_to_user": 603057885, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 603057885, 2388719234 }}, "user": { "id": 2190590492, "name": "melissss", "screen_name": "missssm3liss", "lang": "en", "location": "null", "create_at": date("2013-11-12"), "description": "•find comfort in chaos• EDM enthusiast", "followers_count": 609, "friends_count": 1004, "statues_count": 12374 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Broomfield, CO", "id": "00f8c733400e497a", "name": "Broomfield", "place_type": "city", "bounding_box": rectangle("-105.147267,39.894185 -104.997195,40.000314") }, "geo_tag": { "stateID": 8, "stateName": "Colorado", "countyID": 8014, "countyName": "Broomfield", "cityID": 809280, "cityName": "Broomfield" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945649606393856, "text": "turkey bowl 6 on 6 tourney tomorrow op field at 11. Open to any squad of 6. Hmu for more information.", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 1242079939, "name": "skid", "screen_name": "jake_fr97", "lang": "en", "location": "null", "create_at": date("2013-03-04"), "description": "the real friedòle", "followers_count": 413, "friends_count": 273, "statues_count": 3194 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Oak Park, CA", "id": "0038b1943e3140e9", "name": "Oak Park", "place_type": "city", "bounding_box": rectangle("-118.789237,34.168065 -118.744992,34.21356") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6111, "countyName": "Ventura", "cityID": 653116, "cityName": "Oak Park" } }
+{ "create_at": datetime("2015-11-23T16:14:05.000Z"), "id": 668945649748983808, "text": "I've missed college basketball", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 374299328, "name": "Jason A. Wyrick", "screen_name": "steagles1", "lang": "en", "location": "Naptown ✈️ The Ville", "create_at": date("2011-09-15"), "description": "Louisville Ha-ha Guy. Jesus, Pacers, and the UofL Cards. @Pacers and @IndyEleven follow me. Currently a Louisville Cardinal. GC Cougar forever. RIP Dad.", "followers_count": 736, "friends_count": 494, "statues_count": 49690 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Louisville, KY", "id": "095534ad3107e0e6", "name": "Louisville", "place_type": "city", "bounding_box": rectangle("-85.847503,38.108678 -85.597188,38.282432") }, "geo_tag": { "stateID": 21, "stateName": "Kentucky", "countyID": 21111, "countyName": "Jefferson", "cityID": 2148000, "cityName": "Louisville" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945649937743872, "text": "#PhoenixLostFound LOST AUSTRALIAN BORDER COLLIE (83RD & McDowell) (Casa Anita Apartments): URGENT: Lost Dog: Casa… https://t.co/7CwgtPrf3j", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "coordinate": point("-112.07372189,33.4462674"), "retweet_count": 0, "lang": "en", "is_retweet": false, "hashtags": {{ "PhoenixLostFound" }}, "user": { "id": 3019837997, "name": "Phoenix Lost&Found", "screen_name": "Phoenix_LAF", "lang": "en", "location": "Phoenix Arizona", "create_at": date("2015-02-05"), "description": "null", "followers_count": 8, "friends_count": 68, "statues_count": 14061 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Phoenix, AZ", "id": "5c62ffb0f0f3479d", "name": "Phoenix", "place_type": "city", "bounding_box": rectangle("-112.323914,33.29026 -111.925439,33.815465") }, "geo_tag": { "stateID": 4, "stateName": "Arizona", "countyID": 4013, "countyName": "Maricopa", "cityID": 455000, "cityName": "Phoenix" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945650264903684, "text": "#marblemadnessmonday #gameboy @ Headfarmer https://t.co/xha88zNC3K", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "coordinate": point("-111.8822098,33.5533066"), "retweet_count": 0, "lang": "en", "is_retweet": false, "hashtags": {{ "marblemadnessmonday", "gameboy" }}, "user": { "id": 34794198, "name": "Kyle Steven Bahr", "screen_name": "kylesbahr", "lang": "en", "location": "Phoenix, AZ", "create_at": date("2009-04-23"), "description": "Intuitive, focused, lover of music", "followers_count": 152, "friends_count": 137, "statues_count": 239 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Arizona, USA", "id": "a612c69b44b2e5da", "name": "Arizona", "place_type": "admin", "bounding_box": rectangle("-114.818269,31.332246 -109.045152,37.004261") }, "geo_tag": { "stateID": 4, "stateName": "Arizona", "countyID": 4013, "countyName": "Maricopa", "cityID": 465000, "cityName": "Scottsdale" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945650331992064, "text": "وين أيام الهوى اللي كانت جميله .. كنت غير و كان حلمي فيك أكبر", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "ar", "is_retweet": false, "user": { "id": 222253327, "name": "Bo7saiN", "screen_name": "Boassna", "lang": "ar", "location": "KUWAIT +965", "create_at": date("2010-12-02"), "description": "13314 ❤️", "followers_count": 8179, "friends_count": 271, "statues_count": 83822 }, "place": { "country": "United States", "country_code": "United States", "full_name": "San Diego, CA", "id": "a592bd6ceb1319f7", "name": "San Diego", "place_type": "city", "bounding_box": rectangle("-117.282538,32.53962 -116.92744,33.080404") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6073, "countyName": "San Diego", "cityID": 666000, "cityName": "San Diego" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945650416005120, "text": "@xxerika_ I love you too honey bunches of oats ❤️��", "in_reply_to_status": 668633523134296064, "in_reply_to_user": 744173478, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 744173478 }}, "user": { "id": 896195978, "name": "Shianne", "screen_name": "ShianneG", "lang": "en", "location": "null", "create_at": date("2012-10-21"), "description": "The most important things in life, arent things. Skylier❤️ 3/30/15", "followers_count": 382, "friends_count": 383, "statues_count": 6737 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Tuscarawas, OH", "id": "8bdeb5af4ef23efc", "name": "Tuscarawas", "place_type": "city", "bounding_box": rectangle("-81.412475,40.392321 -81.389397,40.40512") }, "geo_tag": { "stateID": 39, "stateName": "Ohio", "countyID": 39157, "countyName": "Tuscarawas", "cityID": 3977924, "cityName": "Tuscarawas" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945650575400960, "text": "@btbCantina is rockin'!\n\nCome support the Special Olympics with us & @PhiSigmaRhoEta!\n\nWe're here until 11.", "in_reply_to_status": -1, "in_reply_to_user": 1250613134, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 1250613134, 266335326 }}, "user": { "id": 762030889, "name": "Phi SigMa Kappa-UofM", "screen_name": "a2phisig", "lang": "en", "location": "Ann Arbor, MI", "create_at": date("2012-08-16"), "description": "The official Twitter of the Delta Deuteron chapter of Phi Sigma Kappa at the University of Michigan.", "followers_count": 173, "friends_count": 102, "statues_count": 172 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Ann Arbor, MI", "id": "92b2158a6d509767", "name": "Ann Arbor", "place_type": "city", "bounding_box": rectangle("-83.800262,42.215087 -83.659681,42.324184") }, "geo_tag": { "stateID": 26, "stateName": "Michigan", "countyID": 26161, "countyName": "Washtenaw", "cityID": 2603000, "cityName": "Ann Arbor" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945650717847552, "text": "\"Dad, what'dya do on your 1st day of vacation?\" \nI built this Lego model of the Eiffel Tower.\n\"That's sad, Dad.\" https://t.co/QPWgpKnaAe", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 25337234, "name": "Robot Taylor", "screen_name": "robotterror", "lang": "en", "location": "Seattle, WA", "create_at": date("2009-03-19"), "description": "Always a treat, never a threat. Cloud something-something. Mostly harmless. Not really a robot. SRE at Adobe. 极客", "followers_count": 387, "friends_count": 258, "statues_count": 5109 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Shoreline, WA", "id": "ecb63eb9d9d83b31", "name": "Shoreline", "place_type": "city", "bounding_box": rectangle("-122.395019,47.733761 -122.291436,47.777982") }, "geo_tag": { "stateID": 53, "stateName": "Washington", "countyID": 53033, "countyName": "King", "cityID": 5363960, "cityName": "Shoreline" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945650881466368, "text": "ball is life guys", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 2932972574, "name": "Delilah Nguyen", "screen_name": "Delilah1126", "lang": "en", "location": "null", "create_at": date("2014-12-16"), "description": "B1A4 & Astro are the best. ✨", "followers_count": 45, "friends_count": 70, "statues_count": 278 }, "place": { "country": "United States", "country_code": "United States", "full_name": "San Jose, CA", "id": "7d62cffe6f98f349", "name": "San Jose", "place_type": "city", "bounding_box": rectangle("-122.035311,37.193164 -121.71215,37.469154") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6085, "countyName": "Santa Clara", "cityID": 668000, "cityName": "San Jose" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945650923409408, "text": "San Antonio ➡️ San the fuckin Diego!", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 1524165463, "name": "Jicuddy the Cancer♋️", "screen_name": "jicuddy", "lang": "en", "location": "EXT195, WA", "create_at": date("2013-06-17"), "description": "halfway there", "followers_count": 238, "friends_count": 241, "statues_count": 11346 }, "place": { "country": "United States", "country_code": "United States", "full_name": "San Antonio, TX", "id": "3df4f427b5a60fea", "name": "San Antonio", "place_type": "city", "bounding_box": rectangle("-98.778559,29.141956 -98.302744,29.693046") }, "geo_tag": { "stateID": 48, "stateName": "Texas", "countyID": 48029, "countyName": "Bexar", "cityID": 4865000, "cityName": "San Antonio" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945650923544576, "text": "it'll never be the same", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 2863816718, "name": "lys", "screen_name": "liss_jayda", "lang": "en", "location": "null", "create_at": date("2014-10-18"), "description": "♊️", "followers_count": 194, "friends_count": 166, "statues_count": 2562 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Thornton, CO", "id": "36148a9a49d3da69", "name": "Thornton", "place_type": "city", "bounding_box": rectangle("-105.015543,39.838926 -104.884147,39.972023") }, "geo_tag": { "stateID": 8, "stateName": "Colorado", "countyID": 8001, "countyName": "Adams", "cityID": 877290, "cityName": "Thornton" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945651053539328, "text": "Massive headache :-)", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 544691296, "name": "Jedi Dad", "screen_name": "ashhh_schroeder", "lang": "en", "location": "null", "create_at": date("2012-04-03"), "description": "| #OU19 | coffee, god, mountains, love | my name is actually Ashleigh |", "followers_count": 334, "friends_count": 242, "statues_count": 22276 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Norman, OK", "id": "27de1a6e27075587", "name": "Norman", "place_type": "city", "bounding_box": rectangle("-97.51982,35.15327 -97.370527,35.291332") }, "geo_tag": { "stateID": 40, "stateName": "Oklahoma", "countyID": 40027, "countyName": "Cleveland", "cityID": 4052500, "cityName": "Norman" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945651145777152, "text": "@_LoveNesha peep my videos in my favs �� promise you won't waste your time �� #BassBoy appreciate it ��", "in_reply_to_status": -1, "in_reply_to_user": 339837956, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "hashtags": {{ "BassBoy" }}, "user_mentions": {{ 339837956 }}, "user": { "id": 2350513298, "name": "Blaze™♒14.6K", "screen_name": "OfficialBassBoy", "lang": "en", "location": "Detroit", "create_at": date("2014-02-18"), "description": "Ghetto Dreams Records \n\nMusic page: @HePlayBass\n#Neckflix", "followers_count": 14698, "friends_count": 14003, "statues_count": 95729 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Detroit, MI", "id": "b463d3bd6064861b", "name": "Detroit", "place_type": "city", "bounding_box": rectangle("-83.288056,42.255085 -82.91052,42.450488") }, "geo_tag": { "stateID": 26, "stateName": "Michigan", "countyID": 26163, "countyName": "Wayne", "cityID": 2622000, "cityName": "Detroit" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945651158380544, "text": "#DEACS!!", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "und", "is_retweet": false, "hashtags": {{ "DEACS" }}, "user": { "id": 249051050, "name": "Chris Edwards", "screen_name": "CSE_Deac", "lang": "en", "location": "New Bern, NC", "create_at": date("2011-02-07"), "description": "Attorney, currently working for federal courts; occasional runner; WFU; Deacs", "followers_count": 200, "friends_count": 896, "statues_count": 174 }, "place": { "country": "United States", "country_code": "United States", "full_name": "New Bern, NC", "id": "c1ef8962bc0b514d", "name": "New Bern", "place_type": "city", "bounding_box": rectangle("-77.137333,35.076669 -77.034161,35.163741") }, "geo_tag": { "stateID": 37, "stateName": "North Carolina", "countyID": 37049, "countyName": "Craven", "cityID": 3746340, "cityName": "New Bern" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945651263115264, "text": "@franifio @ajplus @JunStinson @brookeminters thank you for making this video, these difficult times create a dire need for mental services.", "in_reply_to_status": 668915924871811072, "in_reply_to_user": 547114168, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 547114168, 110396781, 405059892, 22071328 }}, "user": { "id": 18179415, "name": "Phillip Lorenzo", "screen_name": "pllorenzo", "lang": "en", "location": "San Diego, CA", "create_at": date("2008-12-16"), "description": "I love games, comics, books, great TV and film. I geek out. I live life every day with a new sense of curiosity. RTs are not endorsements.", "followers_count": 956, "friends_count": 857, "statues_count": 11631 }, "place": { "country": "United States", "country_code": "United States", "full_name": "San Diego, CA", "id": "a592bd6ceb1319f7", "name": "San Diego", "place_type": "city", "bounding_box": rectangle("-117.282538,32.53962 -116.92744,33.080404") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6073, "countyName": "San Diego", "cityID": 666000, "cityName": "San Diego" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945651531513856, "text": "Trying to get my application for State done and my computer wants to be extra extra extra slow right now����������", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 131762821, "name": "Melissa", "screen_name": "meligurll", "lang": "en", "location": "null", "create_at": date("2010-04-11"), "description": "September 20th 2014 was the greatest day of my life when I met Taylor Swift at her house and listened to her entire 1989 album❤️", "followers_count": 254, "friends_count": 162, "statues_count": 9078 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Clovis, CA", "id": "d3a7f19316bddcf6", "name": "Clovis", "place_type": "city", "bounding_box": rectangle("-119.732263,36.782957 -119.540115,36.878641") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6019, "countyName": "Fresno", "cityID": 614218, "cityName": "Clovis" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945651539931136, "text": "Made in St. Albert! @ Sturdyhouse https://t.co/lafH0Mskl5", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "coordinate": point("-113.65526849,53.65626126"), "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 22565733, "name": "Christopher Sturdy", "screen_name": "cbsturdy", "lang": "en", "location": "St. Albert, AB, Canada", "create_at": date("2009-03-02"), "description": "Professor of psychology, University of Alberta; studying comparative cognition & neuroethology; advocate for evidence-based health and wellness", "followers_count": 506, "friends_count": 968, "statues_count": 6034 }, "place": { "country": "Canada", "country_code": "Canada", "full_name": "St. Albert, Alberta", "id": "56316c24480c1a3a", "name": "St. Albert", "place_type": "city", "bounding_box": rectangle("-113.707088,53.599415 -113.565747,53.681859") }, "geo_tag": { "stateID": 2, "stateName": "Alaska", "countyID": 2016, "countyName": "Aleutians West" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945651690897408, "text": "������ https://t.co/zXf6QGeMXh", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "und", "is_retweet": false, "user": { "id": 3711148940, "name": "jK !", "screen_name": "iamjbabee", "lang": "en", "location": "null", "create_at": date("2015-09-27"), "description": "| ❤️ |", "followers_count": 322, "friends_count": 228, "statues_count": 3466 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Lake Charles, LA", "id": "21b6f72f9fdaeb06", "name": "Lake Charles", "place_type": "city", "bounding_box": rectangle("-93.314852,30.124859 -93.080595,30.280683") }, "geo_tag": { "stateID": 22, "stateName": "Louisiana", "countyID": 22019, "countyName": "Calcasieu", "cityID": 2241155, "cityName": "Lake Charles" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945651854540800, "text": "Put down that gun & try some Facebook Advertising. Then pick up the gun.", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 92295619, "name": "Joy Barr", "screen_name": "tinybadass", "lang": "en", "location": "90046 USA", "create_at": date("2009-11-24"), "description": "a senseless act of living", "followers_count": 1366, "friends_count": 1314, "statues_count": 24880 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Los Angeles, CA", "id": "3b77caf94bfc81fe", "name": "Los Angeles", "place_type": "city", "bounding_box": rectangle("-118.668404,33.704538 -118.155409,34.337041") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6037, "countyName": "Los Angeles", "cityID": 644000, "cityName": "Los Angeles" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945651967856640, "text": "@yesImthatdope @urfavedes GTFOH.", "in_reply_to_status": 668945556656545792, "in_reply_to_user": 2768309057, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 2768309057, 3753538215 }}, "user": { "id": 24127618, "name": "g", "screen_name": "ginamartinezco", "lang": "en", "location": "The Bronx | SoBe", "create_at": date("2009-03-12"), "description": "Instagram: ginamartinezco | Snapchat: g.nababy | contactginamartinez@gmail.com", "followers_count": 2337, "friends_count": 749, "statues_count": 63581 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Miami Beach, FL", "id": "0121b92345f0e2b4", "name": "Miami Beach", "place_type": "city", "bounding_box": rectangle("-80.147162,25.761308 -80.118763,25.872623") }, "geo_tag": { "stateID": 12, "stateName": "Florida", "countyID": 12086, "countyName": "Miami-Dade", "cityID": 1245025, "cityName": "Miami Beach" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945652181667840, "text": "I know what it's like to feel angry at God, authority, impersonators, role models and myself. Without question, there's something to prayer.", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 1171167042, "name": "Armour Gove Halson", "screen_name": "ByronWJohnson", "lang": "en", "location": "United States", "create_at": date("2013-02-11"), "description": "Ajunct USIP research guide, career whistleblower & terror survivor waiting on rekindling relations w/ my beloved children with hopes of a fair civil settlement.", "followers_count": 41, "friends_count": 156, "statues_count": 1175 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Lisle, IL", "id": "3009292baa8dda23", "name": "Lisle", "place_type": "city", "bounding_box": rectangle("-88.11909,41.760185 -88.042417,41.828705") }, "geo_tag": { "stateID": 17, "stateName": "Illinois", "countyID": 17043, "countyName": "DuPage", "cityID": 1743939, "cityName": "Lisle" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945652601085952, "text": "Look who it is ������ @Cee_foee25 @wdrew19 @amulipola10 @ZTaylor07 https://t.co/xWdordcY8r", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 2852078534, 2405302326, 3237591807, 3222087664 }}, "user": { "id": 2374703971, "name": "Anakin", "screen_name": "BRenteria_45", "lang": "en", "location": "null", "create_at": date("2014-03-05"), "description": "#98'LBC \n《BpHs》", "followers_count": 439, "friends_count": 534, "statues_count": 14808 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Buena Park, CA", "id": "0b93bc6a33455615", "name": "Buena Park", "place_type": "city", "bounding_box": rectangle("-118.037391,33.809829 -117.975923,33.895642") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6059, "countyName": "Orange", "cityID": 608786, "cityName": "Buena Park" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945652714483712, "text": "@TheeMattB no fucking way", "in_reply_to_status": 668945440893755393, "in_reply_to_user": 95064837, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 95064837 }}, "user": { "id": 714669102, "name": "whitesoxdave", "screen_name": "barstoolWSD", "lang": "en", "location": "Chicago, IL", "create_at": date("2012-07-24"), "description": "Everything #WhiteSox on Barstool Sports | Former DIII bullpen catcher | Kenny Powers Protege | Viva Chicago, Viva la Stool! | chisoxbarstool@gmail.com |", "followers_count": 6324, "friends_count": 554, "statues_count": 33399 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Chicago, IL", "id": "1d9a5370a355ab0c", "name": "Chicago", "place_type": "city", "bounding_box": rectangle("-87.940033,41.644102 -87.523993,42.023067") }, "geo_tag": { "stateID": 17, "stateName": "Illinois", "countyID": 17031, "countyName": "Cook", "cityID": 1714000, "cityName": "Chicago" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945652907397120, "text": "@EricOswaltRock @The_Iceman_Show https://t.co/ajDB0kewk6", "in_reply_to_status": -1, "in_reply_to_user": 2722203234, "favorite_count": 0, "retweet_count": 0, "lang": "und", "is_retweet": false, "user_mentions": {{ 2722203234, 1275902911 }}, "user": { "id": 4089541480, "name": "Rick", "screen_name": "racdd4u5050", "lang": "en", "location": "South Carolina, USA", "create_at": date("2015-11-01"), "description": "Management, Writer, Love Variety of Music, NASCAR and Life. I Hold No Hate Toward Anyone, Never Have and Never Will! Get to Know Me Before You Judge Me. Peace!", "followers_count": 984, "friends_count": 859, "statues_count": 11472 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Easley, SC", "id": "0029290613dee5f5", "name": "Easley", "place_type": "city", "bounding_box": rectangle("-82.663558,34.776033 -82.476443,34.891439") }, "geo_tag": { "stateID": 45, "stateName": "South Carolina", "countyID": 45077, "countyName": "Pickens", "cityID": 4521985, "cityName": "Easley" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945652961820672, "text": "I pass you the ball and you broke my assist", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 2491972429, "name": ".", "screen_name": "GuitarGuy241", "lang": "en", "location": "null", "create_at": date("2014-05-12"), "description": "null", "followers_count": 115, "friends_count": 131, "statues_count": 8153 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Wesley Chapel, FL", "id": "0003df7b402165e0", "name": "Wesley Chapel", "place_type": "city", "bounding_box": rectangle("-82.403523,28.169963 -82.24588,28.279042") }, "geo_tag": { "stateID": 12, "stateName": "Florida", "countyID": 12101, "countyName": "Pasco", "cityID": 1275875, "cityName": "Wesley Chapel" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945652999696384, "text": "Omfg Niall doing an English accent https://t.co/vcjBDGhhfG", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "coordinate": point("-74.00398001,40.63435342"), "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 30497066, "name": "meow", "screen_name": "EmileeLindner", "lang": "en", "location": "nyc/buff", "create_at": date("2009-04-11"), "description": "Pop music writer @MTVNews. I'm cute. emilee.lindner@viacommix.com", "followers_count": 2183, "friends_count": 924, "statues_count": 8351 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Brooklyn, NY", "id": "011add077f4d2da3", "name": "Brooklyn", "place_type": "city", "bounding_box": rectangle("-74.041878,40.570842 -73.855673,40.739434") }, "geo_tag": { "stateID": 36, "stateName": "New York", "countyID": 36047, "countyName": "Kings", "cityID": 36047, "cityName": "Brooklyn" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945653175730176, "text": "Don't judge me, join me", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 2961609835, "name": "tbuut", "screen_name": "taylorrdb", "lang": "en", "location": "AZ", "create_at": date("2015-01-06"), "description": "22. #calicojacks. part time party animal", "followers_count": 370, "friends_count": 325, "statues_count": 2464 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Phoenix, AZ", "id": "5c62ffb0f0f3479d", "name": "Phoenix", "place_type": "city", "bounding_box": rectangle("-112.323914,33.29026 -111.925439,33.815465") }, "geo_tag": { "stateID": 4, "stateName": "Arizona", "countyID": 4013, "countyName": "Maricopa", "cityID": 455000, "cityName": "Phoenix" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945653247160321, "text": "It went well ��", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 291862650, "name": "Bambi❤️", "screen_name": "___Yannnnn", "lang": "en", "location": "✈ NC", "create_at": date("2011-05-02"), "description": "null", "followers_count": 1400, "friends_count": 1137, "statues_count": 30950 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Philadelphia, PA", "id": "e4a0d228eb6be76b", "name": "Philadelphia", "place_type": "city", "bounding_box": rectangle("-75.280284,39.871811 -74.955712,40.13792") }, "geo_tag": { "stateID": 42, "stateName": "Pennsylvania", "countyID": 42101, "countyName": "Philadelphia", "cityID": 4260000, "cityName": "Philadelphia" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945653356036096, "text": "Your taste in music is perfff https://t.co/b5B5DeMtMZ", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 168012616, "name": "Cookie Jams", "screen_name": "CookieEatsDinos", "lang": "en", "location": "Chicago, IL", "create_at": date("2010-07-17"), "description": "19. Catch Me At Every Issues Show In IL. #hooligan #neverloseyourflames (IG: cookieeatsdinos)", "followers_count": 1112, "friends_count": 670, "statues_count": 74331 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Chicago, IL", "id": "1d9a5370a355ab0c", "name": "Chicago", "place_type": "city", "bounding_box": rectangle("-87.940033,41.644102 -87.523993,42.023067") }, "geo_tag": { "stateID": 17, "stateName": "Illinois", "countyID": 17031, "countyName": "Cook", "cityID": 1714000, "cityName": "Chicago" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945653565751296, "text": "Happy to say I can faithfully change my nose rings now����", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 2438670957, "name": "BiNK", "screen_name": "RianLB_", "lang": "en", "location": "w/ TiNBiN❤️", "create_at": date("2014-03-26"), "description": "16. |Friend4L❤️|reese➰|i❤️Kayla,Morgan,Dezarae|SMALLZ is annoying❤️", "followers_count": 1525, "friends_count": 1270, "statues_count": 33553 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Glenwillow, OH", "id": "8327dc05095356c7", "name": "Glenwillow", "place_type": "city", "bounding_box": rectangle("-81.489091,41.349159 -81.450332,41.378887") }, "geo_tag": { "stateID": 39, "stateName": "Ohio", "countyID": 39035, "countyName": "Cuyahoga", "cityID": 3930632, "cityName": "Glenwillow" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945653582680064, "text": "send me emojis", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 2148938489, "name": "8/23✨", "screen_name": "_janesax3", "lang": "en", "location": "null", "create_at": date("2013-10-22"), "description": "My best friend turned into my guardian angel on 10/17/15. I love you Janasia Alicia Velez♥️", "followers_count": 958, "friends_count": 764, "statues_count": 15171 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Lorain, OH", "id": "91d57ea9ae3b0bbd", "name": "Lorain", "place_type": "city", "bounding_box": rectangle("-82.292185,41.401871 -82.096884,41.485211") }, "geo_tag": { "stateID": 39, "stateName": "Ohio", "countyID": 39093, "countyName": "Lorain", "cityID": 3944856, "cityName": "Lorain" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945653892911104, "text": "@jinnjuicee good lord", "in_reply_to_status": 668945519763304448, "in_reply_to_user": 178821800, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 178821800 }}, "user": { "id": 114837079, "name": "oh.", "screen_name": "austinhastoes", "lang": "en", "location": "denial", "create_at": date("2010-02-16"), "description": "tell me i'm a mobster", "followers_count": 463, "friends_count": 250, "statues_count": 13418 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Gladstone, MO", "id": "e5731aae9bb5e805", "name": "Gladstone", "place_type": "city", "bounding_box": rectangle("-94.593389,39.173738 -94.529799,39.235151") }, "geo_tag": { "stateID": 29, "stateName": "Missouri", "countyID": 29047, "countyName": "Clay", "cityID": 2927190, "cityName": "Gladstone" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945653985251328, "text": "@DavidChhay1 @WorldStarFunny Lmao wth", "in_reply_to_status": 668936332786339840, "in_reply_to_user": 2233932926, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 2233932926, 1107613844 }}, "user": { "id": 2849436048, "name": "Fab✨", "screen_name": "fabxo__", "lang": "en", "location": "wherever the wind takes me", "create_at": date("2014-10-09"), "description": "❥ Ed Sheeran & the weeknd ❥ || ❁ ❁BA Belle❁ ❁||", "followers_count": 176, "friends_count": 261, "statues_count": 5421 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Dallas, TX", "id": "18810aa5b43e76c7", "name": "Dallas", "place_type": "city", "bounding_box": rectangle("-96.977527,32.620678 -96.54598,33.019039") }, "geo_tag": { "stateID": 48, "stateName": "Texas", "countyID": 48113, "countyName": "Dallas", "cityID": 4819000, "cityName": "Dallas" } }
+{ "create_at": datetime("2015-11-23T16:14:06.000Z"), "id": 668945654077485056, "text": "Closed Homeless Concerns request at 4300 18th St https://t.co/DUTsW3Ktyj. Case closed. case completed. resolved: done.", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "coordinate": point("-122.43743881,37.76086417"), "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 1589692776, "name": "SF311 Reports", "screen_name": "SF311Reports", "lang": "en", "location": "San Francisco, CA", "create_at": date("2013-07-12"), "description": "This is account is not monitored and is used to post service request update information. To communicate with SF311, please use our main account 'SF311'", "followers_count": 38, "friends_count": 0, "statues_count": 280817 }, "place": { "country": "United States", "country_code": "United States", "full_name": "San Francisco, CA", "id": "5a110d312052166f", "name": "San Francisco", "place_type": "city", "bounding_box": rectangle("-122.514926,37.708075 -122.357031,37.833238") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6075, "countyName": "San Francisco", "cityID": 667000, "cityName": "San Francisco" } }
+{ "create_at": datetime("2015-11-23T16:14:07.000Z"), "id": 668945654136373250, "text": "@keschilli @laurentsangel looks more like you than dicaprio", "in_reply_to_status": 668945414788378624, "in_reply_to_user": 497076183, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 497076183, 309685171 }}, "user": { "id": 2786773720, "name": "ㅤ", "screen_name": "YouAreLouard", "lang": "en", "location": "Cleveland, OH", "create_at": date("2014-09-26"), "description": "notre dunkin donuts cathedral latin", "followers_count": 707, "friends_count": 716, "statues_count": 14640 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Highland Heights, OH", "id": "668fe3ffece4000a", "name": "Highland Heights", "place_type": "city", "bounding_box": rectangle("-81.489033,41.530607 -81.447145,41.570126") }, "geo_tag": { "stateID": 39, "stateName": "Ohio", "countyID": 39035, "countyName": "Cuyahoga", "cityID": 3935252, "cityName": "Highland Heights" } }
+{ "create_at": datetime("2015-11-23T16:14:07.000Z"), "id": 668945654174101506, "text": "That was a big bunch of nothin' ..... #IUBB", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "hashtags": {{ "IUBB" }}, "user": { "id": 1127945767, "name": "Just_Jer!", "screen_name": "jerry_shonk", "lang": "en", "location": "Greensburg, Indiana USA", "create_at": date("2013-01-28"), "description": "#Colts #Pacers #Reds #IUBB #NASCAR #TeamHendricks #48 #WWE #YR #Sopranos #BatesMotel #HoosierBornAndRaised", "followers_count": 1672, "friends_count": 914, "statues_count": 29082 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Greensburg, IN", "id": "9f29ee1a2f040588", "name": "Greensburg", "place_type": "city", "bounding_box": rectangle("-85.518421,39.312107 -85.459117,39.362492") }, "geo_tag": { "stateID": 18, "stateName": "Indiana", "countyID": 18031, "countyName": "Decatur", "cityID": 1829718, "cityName": "Greensburg" } }
+{ "create_at": datetime("2015-11-23T16:14:07.000Z"), "id": 668945654199226369, "text": "Nigga give me somewhere to be after work besides home��", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user": { "id": 494633996, "name": "SUTTLES #TeamAllison", "screen_name": "Suttles_", "lang": "en", "location": "The LVB", "create_at": date("2012-02-16"), "description": "JS&VG™", "followers_count": 1055, "friends_count": 1055, "statues_count": 36914 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Chicopee, MA", "id": "1cacd95a1b3c5221", "name": "Chicopee", "place_type": "city", "bounding_box": rectangle("-72.626984,42.124341 -72.513489,42.218354") }, "geo_tag": { "stateID": 25, "stateName": "Massachusetts", "countyID": 25013, "countyName": "Hampden", "cityID": 2513660, "cityName": "Chicopee" } }
+{ "create_at": datetime("2015-11-23T16:14:07.000Z"), "id": 668945654266269696, "text": "@Spo0kyChris is it the black parade", "in_reply_to_status": 668944873152626688, "in_reply_to_user": 3037173564, "favorite_count": 0, "retweet_count": 0, "lang": "en", "is_retweet": false, "user_mentions": {{ 3037173564 }}, "user": { "id": 1276076918, "name": "kirby", "screen_name": "mvster_sword", "lang": "en", "location": "Whittier, CA", "create_at": date("2013-03-17"), "description": "drifting endlessly in the great cosmic dark/18", "followers_count": 704, "friends_count": 396, "statues_count": 18126 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Whittier, CA", "id": "f8f8ee516109ee0e", "name": "Whittier", "place_type": "city", "bounding_box": rectangle("-118.072424,33.928201 -117.965287,34.023634") }, "geo_tag": { "stateID": 6, "stateName": "California", "countyID": 6037, "countyName": "Los Angeles", "cityID": 685292, "cityName": "Whittier" } }
+{ "create_at": datetime("2015-11-23T16:14:07.000Z"), "id": 668945654446559232, "text": "Patriots Pre-gaming deep in the heart of Texas... #starsatnight #bigandbright @ Cedar Springs Tap House https://t.co/nr7afYsMNN", "in_reply_to_status": -1, "in_reply_to_user": -1, "favorite_count": 0, "coordinate": point("-96.81248297,32.81178018"), "retweet_count": 0, "lang": "en", "is_retweet": false, "hashtags": {{ "starsatnight", "bigandbright" }}, "user": { "id": 29255704, "name": "Dan Milner", "screen_name": "damilnermd", "lang": "en", "location": "null", "create_at": date("2009-04-06"), "description": "null", "followers_count": 162, "friends_count": 138, "statues_count": 3331 }, "place": { "country": "United States", "country_code": "United States", "full_name": "Dallas, TX", "id": "18810aa5b43e76c7", "name": "Dallas", "place_type": "city", "bounding_box": rectangle("-96.977527,32.620678 -96.54598,33.019039") }, "geo_tag": { "stateID": 48, "stateName": "Texas", "countyID": 48113, "countyName": "Dallas", "cityID": 4819000, "cityName": "Dallas" } }

diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.1.ddl.aql
new file mode 100644
index 0000000..b6732c4
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.1.ddl.aql

@@ -0,0 +1,85 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+/*
+ *  Description     : Full-text search non-index test
+ *                  : This test is intended to verify that the full-text search works as expected.
+ *                  : But, the form of the query is join. So, each keyword from the outer dataset will be processed
+ *                  : separately. Thus, query #3 and query #4 should generate the same result.
+ *                  : query #3 - two string values in [an ordered list] query with "any" option.
+ *                  :            an ordered list is first initialized by let clause and is being used.
+ *                  :            in this case, "any" option that enforces a disjunctive search will be applied.
+ *                  : query #4 - the same as query #3, but with a different option - "all"
+ *                  :            in this case, we explicitly specify "all" option that enforces a conjunctive search.
+ *                  : query #5 - the same as query #4, but without any option that is equivalent to "all".
+ *  Expected Result : Success
+ *
+*/
+
+drop dataverse twitter if exists;
+create dataverse twitter if not exists;
+use dataverse twitter
+create type typeUser if not exists as open {
+    id: int64,
+    name: string,
+    screen_name : string,
+    lang : string,
+    location: string,
+    create_at: date,
+    description: string,
+    followers_count: int32,
+    friends_count: int32,
+    statues_count: int64
+}
+create type typePlace if not exists as open{
+    country : string,
+    country_code : string,
+    full_name : string,
+    id : string,
+    name : string,
+    place_type : string,
+    bounding_box : rectangle
+}
+create type typeGeoTag if not exists as open {
+    stateID: int32,
+    stateName: string,
+    countyID: int32,
+    countyName: string,
+    cityID: int32?,
+    cityName: string?
+}
+create type typeTweet if not exists as open{
+    create_at : datetime,
+    id: int64,
+    "text": string,
+    in_reply_to_status : int64,
+    in_reply_to_user : int64,
+    favorite_count : int64,
+    coordinate: point?,
+    retweet_count : int64,
+    lang : string,
+    is_retweet: boolean,
+    hashtags : {{ string }} ?,
+    user_mentions : {{ int64 }} ? ,
+    user : typeUser,
+    place : typePlace?,
+    geo_tag: typeGeoTag
+}
+create dataset ds_tweet(typeTweet) if not exists primary key id
+using compaction policy prefix (("max-mergable-component-size"="134217728"),("max-tolerance-component-count"="10")) with filter on create_at;

diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.2.update.aql
new file mode 100644
index 0000000..6947e27
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.2.update.aql

@@ -0,0 +1,24 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use dataverse twitter;
+
+load dataset ds_tweet
+using localfs
+(("path"="asterix_nc1://data/fulltext/cloudberry_sample_tweet.adm"),("format"="adm"));

diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.3.query.aql
new file mode 100644
index 0000000..c795d40
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.3.query.aql

@@ -0,0 +1,26 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use dataverse twitter;
+
+for $t in dataset twitter.ds_tweet
+where ftcontains($t.'text', ['good'])
+order by $t.id
+return {"id":$t.id}
+

diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.4.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.4.query.aql
new file mode 100644
index 0000000..8892da0
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.4.query.aql

@@ -0,0 +1,26 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use dataverse twitter;
+
+for $t in dataset twitter.ds_tweet
+where ftcontains($t.'text', ['good','difficult'])
+order by $t.id
+return {"id":$t.id}
+

diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.5.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.5.query.aql
new file mode 100644
index 0000000..b3c61b3
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.5.query.aql

@@ -0,0 +1,26 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use dataverse twitter;
+
+for $t in dataset twitter.ds_tweet
+where ftcontains($t.'text', ['good','difficult'], {'mode':'any'})
+order by $t.id
+return {"id":$t.id}
+

diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/fulltext/fulltext-08/fulltext-08.3.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/fulltext/fulltext-08/fulltext-08.3.adm
new file mode 100644
index 0000000..85c3c4f
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/fulltext/fulltext-08/fulltext-08.3.adm

@@ -0,0 +1,3 @@
+{ "id": 668945643054870528 }
+{ "id": 668945646725017600 }
+{ "id": 668945653892911104 }

diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/fulltext/fulltext-08/fulltext-08.4.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/fulltext/fulltext-08/fulltext-08.4.adm
new file mode 100644
index 0000000..17babd8
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/fulltext/fulltext-08/fulltext-08.4.adm

@@ -0,0 +1 @@
+{ "id": 668945643054870528 }

diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/fulltext/fulltext-08/fulltext-08.5.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/fulltext/fulltext-08/fulltext-08.5.adm
new file mode 100644
index 0000000..2d91ff6
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/fulltext/fulltext-08/fulltext-08.5.adm

@@ -0,0 +1,4 @@
+{ "id": 668945643054870528 }
+{ "id": 668945646725017600 }
+{ "id": 668945651263115264 }
+{ "id": 668945653892911104 }

diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/testsuite.xml b/asterixdb/asterix-app/src/test/resources/runtimets/testsuite.xml
index 7a486b7..956ea53 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/testsuite.xml
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/testsuite.xml

@@ -421,6 +421,11 @@
       </compilation-unit>
     </test-case>
     <test-case FilePath="fulltext">
+      <compilation-unit name="fulltext-08">
+        <output-dir compare="Text">fulltext-08</output-dir>
+      </compilation-unit>
+    </test-case>
+    <test-case FilePath="fulltext">
       <compilation-unit name="fulltext-index-01">
         <output-dir compare="Text">fulltext-index-01</output-dir>
       </compilation-unit>

diff --git a/asterixdb/asterix-doc/src/site/markdown/aql/fulltext.md b/asterixdb/asterix-doc/src/site/markdown/aql/fulltext.md
index 4fe17ac..bc0b398 100644
--- a/asterixdb/asterix-doc/src/site/markdown/aql/fulltext.md
+++ b/asterixdb/asterix-doc/src/site/markdown/aql/fulltext.md

@@ -56,6 +56,14 @@
 
 The DDL and DML of TinySocial can be found in [ADM: Modeling Semistructed Data in AsterixDB](primer.html#ADM:_Modeling_Semistructed_Data_in_AsterixDB).
 
+The same query can be also expressed in the SQL++.
+
+        use TinySocial;
+
+        select element {"id":msg.id}
+        from TweetMessages as msg
+        where TinySocial.ftcontains(msg.`message-text`, "voice", {"mode":"any"})
+
 The `Expression1` is an expression that should be evaluable as a string at runtime as in the above example
 where `$msg.message-text` is a string field. The `Expression2` can be a string, an (un)ordered list
 of string value(s), or an expression. In the last case, the given expression should be evaluable
@@ -103,3 +111,13 @@
 
        ... where ftcontains($msg.message-text, ["sound", "system"], {"mode":"all"})
        ... where ftcontains($msg.message-text, ["sound", "system"])
+
+
+## <a id="FulltextIndex">Creating and utilizing a Full-text index</a> <font size="4"><a href="#toc">[Back to TOC]</a></font> ##
+
+When there is a full-text index on the field that is being searched, rather than scanning all records,
+AsterixDB can utilize that index to expedite the execution of a FTS query. To create a full-text index,
+you need to specify the index type as `fulltext` in your DDL statement. For instance, the following DDL
+statement create a full-text index on the TweetMessages.message-text attribute.
+
+    create index messageFTSIdx on TweetMessages(message-text) type fulltext;

diff --git a/asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/common/FullTextContainsEvaluator.java b/asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/common/FullTextContainsEvaluator.java
index b94821f..0a48f6f 100644
--- a/asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/common/FullTextContainsEvaluator.java
+++ b/asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/common/FullTextContainsEvaluator.java

@@ -244,7 +244,16 @@
         int queryTokenCount = 0;
         int uniqueQueryTokenCount = 0;
 
+        int numBytesToStoreLength;
+
         // Reset the tokenizer for the given keywords in the given query
+        if (typeTag2 == ATypeTag.STRING) {
+            // How many bytes are required to store the length of the given token?
+            numBytesToStoreLength = UTF8StringUtil
+                    .getNumBytesToStoreLength(UTF8StringUtil.getUTFLength(queryArray, queryArrayStartOffset));
+            queryArrayStartOffset = queryArrayStartOffset + numBytesToStoreLength;
+            queryArrayLength = queryArrayLength - numBytesToStoreLength;
+        }
         tokenizerForRightArray.reset(queryArray, queryArrayStartOffset, queryArrayLength);
 
         // Create tokens from the given query predicate
@@ -256,7 +265,6 @@
             // We don't store the actual value of this token since we can access it via offset and length.
             int tokenOffset = tokenizerForRightArray.getToken().getStartOffset();
             int tokenLength = tokenizerForRightArray.getToken().getTokenLength();
-            int numBytesToStoreLength;
 
             // If a token comes from a string tokenizer, each token doesn't have the length data
             // in the beginning. Instead, if a token comes from an (un)ordered list, each token has
@@ -352,7 +360,14 @@
 
         // The left side: field (document)
         // Resets the tokenizer for the given keywords in a document.
-        tokenizerForLeftArray.reset(arg1.getByteArray(), arg1.getStartOffset(), arg1.getLength());
+
+        // How many bytes are required to store the length of the given string?
+        int numBytesToStoreLength = UTF8StringUtil
+                .getNumBytesToStoreLength(UTF8StringUtil.getUTFLength(arg1.getByteArray(), arg1.getStartOffset()));
+        int startOffset = arg1.getStartOffset() + numBytesToStoreLength;
+        int length = arg1.getLength() - numBytesToStoreLength;
+
+        tokenizerForLeftArray.reset(arg1.getByteArray(), startOffset, length);
 
         // Creates tokens from a field in the left side (document)
         while (tokenizerForLeftArray.hasNext()) {
commit	ab01c87e5b700f1b90c67b6a58df4c225a6c88bc	[log] [tgz]
author	Taewoo Kim <wangsaeu@yahoo.com>	Sat Apr 08 16:43:11 2017 -0700
committer	Taewoo Kim <wangsaeu@gmail.com>	Mon Apr 10 12:46:51 2017 -0700
tree	0632493af4e105034c5042caa6e7149f54616c23
parent	90fb051a0463b71c536c8a2041b67f1490ddd8d2 [diff]