Taewoo Kim has uploaded a new change for review.
https://asterix-gerrit.ics.uci.edu/1668
Change subject: ASTERIXDB-1877: Tokenizer in FullText Search fix
......................................................................
ASTERIXDB-1877: Tokenizer in FullText Search fix
- Sets the starting offset of the string correctly.
Change-Id: Ic949ccc0cc3e66c489f4c8435672a74c70b7c0e7
---
A asterixdb/asterix-app/data/fulltext/cloudberry_sample_tweet.adm
A
asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.1.ddl.aql
A
asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.2.update.aql
A
asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.3.query.aql
A
asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.4.query.aql
A
asterixdb/asterix-app/src/test/resources/runtimets/queries/fulltext/fulltext-08/fulltext-08.5.query.aql
A
asterixdb/asterix-app/src/test/resources/runtimets/results/fulltext/fulltext-08/fulltext-08.3.adm
A
asterixdb/asterix-app/src/test/resources/runtimets/results/fulltext/fulltext-08/fulltext-08.4.adm
A
asterixdb/asterix-app/src/test/resources/runtimets/results/fulltext/fulltext-08/fulltext-08.5.adm
M asterixdb/asterix-app/src/test/resources/runtimets/testsuite.xml
M
asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/evaluators/common/FullTextContainsEvaluator.java
11 files changed, 308 insertions(+), 1 deletion(-)
git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb
refs/changes/68/1668/1
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.6977
94") }, "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": rectang
le("-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, "state
Name": "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": "Unit
ed 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", "boundin
g_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 La
kes", "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": "Nor
th 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: mollybe...@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, "c
ityName": "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.alexordo...@gmail.com d...@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, "cityNam
e": "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, "state
Name": "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, "cityNa
me": "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", "city
ID": 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": 260
73, "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", "plac
e_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.25564
1,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": 17
043, "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, "s
tateName": "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.8
99883,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": "Ariz
ona", "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": 3977
924, "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, "sta
teName": "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_ty
pe": "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, "stateN
ame": "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 | contactginamarti...@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.042
417,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! | chisoxbarst...@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": { "s
tateID": 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.lind...@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, "cit
yName": "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": recta
ngle("-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": 393525
2, "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-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..fd08d62 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
@@ -352,7 +352,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()) {
--
To view, visit https://asterix-gerrit.ics.uci.edu/1668
To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic949ccc0cc3e66c489f4c8435672a74c70b7c0e7
Gerrit-PatchSet: 1
Gerrit-Project: asterixdb
Gerrit-Branch: master
Gerrit-Owner: Taewoo Kim <wangs...@gmail.com>
