Repository: asterixdb Updated Branches: refs/heads/master 0309d51a5 -> ecba52e0b
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.01.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.01.ddl.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.01.ddl.aql new file mode 100644 index 0000000..190891f --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.01.ddl.aql @@ -0,0 +1,81 @@ +/* + * 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 : Reproduction scenario for ASTERIXDB-1636 + * Expected Res : Success + * Date : Oct 5th 2016 + */ + +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 with filter on create_at; +create index text_idx if not exists on ds_tweet("text") type keyword; +create feed MessageFeed using localfs( +("path"="localhost://../../../../../src/test/resources/integrationts/restart/828.h1w.adm"), +("format"="adm"), +("type-name"="typeTweet")); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.02.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.02.ddl.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.02.ddl.aql new file mode 100644 index 0000000..58dea6b --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.02.ddl.aql @@ -0,0 +1,27 @@ +/* + * 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 : Reproduction scenario for ASTERIXDB-1636 + * Expected Res : Success + * Date : Oct 5th 2016 + */ + +use dataverse twitter; +connect feed MessageFeed to dataset ds_tweet; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.03.script.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.03.script.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.03.script.aql new file mode 100644 index 0000000..d489e74 --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.03.script.aql @@ -0,0 +1 @@ +touch.sh \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.04.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.04.ddl.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.04.ddl.aql new file mode 100644 index 0000000..cf520ca --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.04.ddl.aql @@ -0,0 +1,35 @@ +/* + * 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 : Reproduction scenario for ASTERIXDB-1636 + * Expected Res : Success + * Date : Oct 5th 2016 + */ + +use dataverse twitter; +drop feed TweetFeed if exists; +create feed TweetFeed using localfs +( + ("path"="localhost://../../../../../target/tweets.json"), + ("format"="adm"), + ("type-name"="typeTweet") +); +set wait-for-completion-feed "true"; +connect feed TweetFeed to dataset ds_tweet; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.05.mgx.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.05.mgx.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.05.mgx.aql new file mode 100644 index 0000000..d6e839a --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.05.mgx.aql @@ -0,0 +1,2 @@ +stop -n asterix + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.06.mgx.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.06.mgx.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.06.mgx.aql new file mode 100644 index 0000000..1d6d3bc --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.06.mgx.aql @@ -0,0 +1,2 @@ +start -n asterix + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.07.script.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.07.script.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.07.script.aql new file mode 100644 index 0000000..7503842 --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.07.script.aql @@ -0,0 +1 @@ +cat.sh http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.08.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.08.ddl.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.08.ddl.aql new file mode 100644 index 0000000..860b8ed --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.08.ddl.aql @@ -0,0 +1,27 @@ +/* + * 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 : Reproduction scenario for ASTERIXDB-1636 + * Expected Res : Success + * Date : Oct 5th 2016 + */ +use dataverse twitter; +set wait-for-completion-feed "false"; +connect feed TweetFeed to dataset ds_tweet; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.09.sleep.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.09.sleep.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.09.sleep.aql new file mode 100644 index 0000000..49ccbce --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.09.sleep.aql @@ -0,0 +1,25 @@ +/* + * 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 : Reproduction scenario for ASTERIXDB-1636 + * Expected Res : Success + * Date : Oct 5th 2016 + */ +1000 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.10.script.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.10.script.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.10.script.aql new file mode 100644 index 0000000..80bfb2c --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.10.script.aql @@ -0,0 +1 @@ +kill_cc_and_nc.sh http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.11.script.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.11.script.aql b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.11.script.aql new file mode 100644 index 0000000..d599fbe --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/queries/feed-restart/issue-1636/issue-1636.11.script.aql @@ -0,0 +1 @@ +grep_log.sh \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/cat.sh ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/cat.sh b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/cat.sh new file mode 100755 index 0000000..c111fde --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/cat.sh @@ -0,0 +1,18 @@ +#!/usr/bin/env bash +# 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. +cat src/test/resources/integrationts/restart/tweets.json > target/tweets.json http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/grep_log.sh ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/grep_log.sh b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/grep_log.sh new file mode 100755 index 0000000..b84732f --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/grep_log.sh @@ -0,0 +1,20 @@ +#!/usr/bin/env bash +# 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. +if grep --quiet -m 1 'java.lang.ArrayIndexOutOfBoundsException' target/asterix-installer-*-binary-assembly/clusters/local/working_dir/logs/*.log ; then + echo "ERROR" +fi http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/kill_cc_and_nc.sh ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/kill_cc_and_nc.sh b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/kill_cc_and_nc.sh new file mode 100755 index 0000000..2582713 --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/kill_cc_and_nc.sh @@ -0,0 +1,18 @@ +#!/usr/bin/env bash +# 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. +jps | awk '{if ($2 == "NCDriver" || $2 == "CCDriver") print $1;}' | xargs -n 1 kill -9 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/touch.sh ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/touch.sh b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/touch.sh new file mode 100755 index 0000000..4e0b75c --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/scripts/feed-restart/issue-1636/touch.sh @@ -0,0 +1,21 @@ +#!/usr/bin/env bash +# 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. +if [ -f target/tweets.json ]; then + rm -f target/tweets.json +fi +touch target/tweets.json \ No newline at end of file http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/testsuite.xml ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/testsuite.xml b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/testsuite.xml new file mode 100644 index 0000000..44ae9b4 --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/testsuite.xml @@ -0,0 +1,28 @@ +<!-- + ! 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. + !--> +<test-suite xmlns="urn:xml.testframework.asterix.apache.org" ResultOffsetPath="results" QueryOffsetPath="queries" QueryFileExtension=".aql"> + <test-group name="restart"> + <test-case FilePath="feed-restart"> + <compilation-unit name="issue-1636"> + <output-dir compare="Text">issue-1636</output-dir> + </compilation-unit> + </test-case> + </test-group> +</test-suite> + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ecba52e0/asterixdb/asterix-installer/src/test/resources/integrationts/restart/tweets.json ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-installer/src/test/resources/integrationts/restart/tweets.json b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/tweets.json new file mode 100644 index 0000000..d9fca06 --- /dev/null +++ b/asterixdb/asterix-installer/src/test/resources/integrationts/restart/tweets.json @@ -0,0 +1,39 @@ +{"create_at":datetime("2016-09-23T12:25:34.000"),"id":int64("779401340485271552"),"text":"https://t.co/90HQQzJDie","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"und","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Richmond, VA","id":"00f751614d8ce37b","name":"Richmond","place_type":"city","bounding_box":rectangle("-77.601044,37.447046 -77.385297,37.61272")},"geo_tag":{"stateID":51,"stateName":"Virginia","countyID":51760,"countyName":"Richmond","cityID":5167000,"cityName":"Richmond"},"user":{"id":int64("732261848024809473"),"name":"KUnderwood","screen_name":"KUnderw63665020","lang":"en","location":"Virginia, USA","create_at":date("2016-05-16"),"description":"*Riding On The Trump Train!*\nNO LISTS!\nRETWEETS CIRCULATE INFO THAT MSM WILL NOT!RETWEET ALL INFO GET PPL INFORMED!KNOWLEDGE IS OUR WEAPON!","followers_count":2239,"friends_count":2637,"statues_coun t":37837}} +{"create_at":datetime("2016-09-23T12:25:48.000"),"id":int64("779401398928584704"),"text":"I think they should extend #SuicidePreventionAwarenessMonth from Sept until after the election, and permanently if Trump wins.","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"hashtags":{{"SuicidePreventionAwarenessMonth"}},"place":{"country":"United States","country_code":"United States","full_name":"Fort Worth, TX","id":"42e46bc3663a4b5f","name":"Fort Worth","place_type":"city","bounding_box":rectangle("-97.538285,32.569477 -97.033542,32.990456")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48439,"countyName":"Tarrant","cityID":4827000,"cityName":"Fort Worth"},"user":{"id":int64("25033519"),"name":"Lily Barreda","screen_name":"lbarreda","lang":"en","location":"Fort Worth, TX","create_at":date("2009-03-17"),"description":"Dog mom, brain injury survivor-ish, really bad at writing bi os.","followers_count":2363,"friends_count":304,"statues_count":1438}} +{"create_at":datetime("2016-09-23T12:25:57.000"),"id":int64("779401435486093312"),"text":"Trump called Cruz a liar & his wife ugly, so Cruz is endorsing Trump. It's the kindergarten equivalent of pulling hair of the girl you like.","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"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.734319")},"geo_tag":{"stateID":53,"stateName":"Washington","countyID":53033,"countyName":"King","cityID":5363000,"cityName":"Seattle"},"user":{"id":int64("274147256"),"name":"JHunterJokes","screen_name":"jhuntercomedy","lang":"en","location":"seattle, washington","create_at":date("2011-03-29"),"description":"stand up. comedy writer. None of my tweets are based on fact. Except those about the #LAD odgers #Redskins, my dogs, and beer.","followers_count":1072,"friends_count":1111,"statues_count":18889}} +{"create_at":datetime("2016-09-23T12:26:14.000"),"id":int64("779401506772676608"),"text":"Eric Trump: My dad is the epitome of the American dream! He started with barely anything!\n\nMe: https://t.co/sdNNukaYRw","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Manhattan, NY","id":"01a9a39529b27f36","name":"Manhattan","place_type":"city","bounding_box":rectangle("-74.026675,40.683935 -73.910408,40.877483")},"geo_tag":{"stateID":36,"stateName":"New York","countyID":36061,"countyName":"New York","cityID":36061,"cityName":"Manhattan"},"user":{"id":int64("39267537"),"name":"Lucy Flawless","screen_name":"everythingsjake","lang":"en","location":"New York, NY","create_at":date("2009-05-11"),"description":"I could care.","followers_count":3283,"friends_count":417,"statues_count":161030}} +{"create_at":datetime("2016-09-23T12:26:21.000"),"id":int64("779401534622736384"),"text":"Trump bunk... https://t.co/dNDg6SkmCg","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Brookdale, CA","id":"01289bf759f2ab45","name":"Brookdale","place_type":"city","bounding_box":rectangle("-122.122065,37.089913 -122.085464,37.113252")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6087,"countyName":"Santa Cruz","cityID":608478,"cityName":"Brookdale"},"user":{"id":int64("44959505"),"name":"nancy bowen","screen_name":"lavenderblue27","lang":"en","location":"Brookdale, CA","create_at":date("2009-06-05"),"description":"Fairness, human rights & laughter, I think for myself, avid Olbermann, John Fugelsang, Beatles, John Clark, Jack Reacher fan #UniteBlue","followers_count":21429,"friends_count":21797,"statue s_count":291006}} +{"create_at":datetime("2016-09-23T12:26:22.000"),"id":int64("779401539894915072"),"text":"@JkgaddisJulie @CelesteHerget @ejoy2270 @StatesPoll agreed! Trump creates jobs! Look at his resume","in_reply_to_status":int64("779352835573985280"),"in_reply_to_user":int64("1340907289"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{1340907289,930575720,705433853289082880,4547869279}},"place":{"country":"United States","country_code":"United States","full_name":"Sterling, IL","id":"6ba87c2e2d3960d0","name":"Sterling","place_type":"city","bounding_box":rectangle("-89.771235,41.772244 -89.640186,41.827767")},"geo_tag":{"stateID":17,"stateName":"Illinois","countyID":17195,"countyName":"Whiteside","cityID":1772546,"cityName":"Sterling"},"user":{"id":int64("2752932015"),"name":"Kelley MD\u2764\uFE0FTrump","screen_name":"guthrie_kelley","lang":"en","location":"United States","create_at":date("2014-08-27"),"description":"M.D. and MSW . full ti me doc @ Federal public health dept. I'm a Mainer. now in IL. land locked. Christian !! Jesus calling.....the book to own. :)","followers_count":1900,"friends_count":189,"statues_count":13912}} +{"create_at":datetime("2016-09-23T12:26:23.000"),"id":int64("779401543728652288"),"text":"If equality to some means hating all men and blaming them for all their problems and 2 failed relationships. YOU are more RETARED than Trump","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Savage, MD","id":"013e2fa93b1bd0be","name":"Savage","place_type":"city","bounding_box":rectangle("-76.852175,39.120076 -76.776884,39.179931")},"geo_tag":{"stateID":24,"stateName":"Maryland","countyID":24027,"countyName":"Howard","cityID":2470475,"cityName":"Savage"},"user":{"id":int64("446473873"),"name":"Oscar Villalobos","screen_name":"mistafuntastic","lang":"en","location":"Beltsville, MD ","create_at":date("2011-12-25"),"description":"@UoPeople #Dreamer #DCUnited \u26AB\uFE0F\u26BD\uFE0F #STEM #MLS #Physics","followers_count": 218,"friends_count":235,"statues_count":13741}} +{"create_at":datetime("2016-09-23T12:26:24.000"),"id":int64("779401550976258048"),"text":"WHAT IS THIS NONSENSE @KimKardashian ALSO @Caitlyn_Jenner GURL BYE https://t.co/G3pi9wJZSX","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{25365536,3303293865}},"place":{"country":"United States","country_code":"United States","full_name":"Odessa, TX","id":"2c0346ba4b733e24","name":"Odessa","place_type":"city","bounding_box":rectangle("-102.434966,31.792563 -102.253208,31.955114")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48135,"countyName":"Ector","cityID":4853388,"cityName":"Odessa"},"user":{"id":int64("152033213"),"name":"ERNEST-O","screen_name":"emacys","lang":"en","location":"TEXAS \u272F","create_at":date("2010-06-04"),"description":"journalist / producer / currently rolling my eyes / aggressive @kimkardashian stan /","followers_count":602,"friends_count": 1223,"statues_count":19777}} +{"create_at":datetime("2016-09-23T12:26:27.000"),"id":int64("779401559415357440"),"text":"\"Look at me! Look at me! Hey, LOOK AT ME!\" https://t.co/Aog5ZWQeE1","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Manhattan, NY","id":"01a9a39529b27f36","name":"Manhattan","place_type":"city","bounding_box":rectangle("-74.026675,40.683935 -73.910408,40.877483")},"geo_tag":{"stateID":36,"stateName":"New York","countyID":36061,"countyName":"New York","cityID":36061,"cityName":"Manhattan"},"user":{"id":int64("995194771"),"name":"Steven Beck","screen_name":"becksnyc78","lang":"en","location":"New York","create_at":date("2012-12-07"),"description":"Florida born. NYC living. Wilhelmina Model. Runner. Photography. BUCS. FSU. MUFC.","followers_count":847,"friends_count":706,"statues_count":39316}} +{"create_at":datetime("2016-09-23T12:26:31.000"),"id":int64("779401579803836416"),"text":"If they don't want to be considered enemies, let them come out and endorse DONAL J. TRUMP for president.\nDump the DOPE SMOKER.","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Astatula, FL","id":"dbbd875df397a247","name":"Astatula","place_type":"city","bounding_box":rectangle("-81.747783,28.701654 -81.714374,28.727329")},"geo_tag":{"stateID":12,"stateName":"Florida","countyID":12069,"countyName":"Lake","cityID":1202250,"cityName":"Astatula"},"user":{"id":int64("730763692007002112"),"name":"R A Sutton","screen_name":"rodger_sutton","lang":"en","location":"Central FLORIDA","create_at":date("2016-05-12"),"description":"United States Marine.\nFather,Grandfather,GREAT GRANDFATHER \nTrue Son of the Confederacy.\nAmerican Patriot, R.E.D.\nUS FREEDOM ARMY\nNRA Golden Eagle Member","followers_count":277,"friends_count":22,"statues_count":15286}} +{"create_at":datetime("2016-09-23T12:26:34.000"),"id":int64("779401589417086976"),"text":"@MarkCubanFans @mcuban_NBA The 14 year old that owns an NBA team. Maybe he'll stick his tongue out at Trump.\u2026 https://t.co/VPYKYwngqj","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("614301557"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{614301557,716296544278851585}},"place":{"country":"United States","country_code":"United States","full_name":"Spokane, WA","id":"dc3747428fa88cab","name":"Spokane","place_type":"city","bounding_box":rectangle("-117.565226,47.5742 -117.303868,47.760676")},"geo_tag":{"stateID":53,"stateName":"Washington","countyID":53063,"countyName":"Spokane","cityID":5367000,"cityName":"Spokane"},"user":{"id":int64("3321633224"),"name":"DeplorableDBlack15NC","screen_name":"dblack15nc","lang":"en","location":"null","create_at":date("2015-08-20"),"description":"Catholic Gentleman. 4th Degree KoC. Retired USAF Senior NCO. DAV, VFW, VVA, AmLegion, Sons of Confederate Veterans, Unreconstructed Tar Heel. #MAGA","followers_count":1352,"friends_count":1474,"statues_count":23047}} +{"create_at":datetime("2016-09-23T12:26:36.000"),"id":int64("779401599127093248"),"text":"My house is surrounded with trump supporters lol","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"North Royalton, OH","id":"4506ca1d65ca5b4d","name":"North Royalton","place_type":"city","bounding_box":rectangle("-81.785322,41.264708 -81.70169,41.350954")},"geo_tag":{"stateID":39,"stateName":"Ohio","countyID":39035,"countyName":"Cuyahoga","cityID":3957008,"cityName":"North Royalton"},"user":{"id":int64("120509237"),"name":"Mahmood A","screen_name":"yung_mood","lang":"en","location":"null","create_at":date("2010-03-06"),"description":"Yemeni! BAY AREA!!! living in CLE. IG mahmood_a snapchat mood1996","followers_count":1324,"friends_count":638,"statues_count":6930}} +{"create_at":datetime("2016-09-23T12:26:51.000"),"id":int64("779401661273870336"),"text":"Why Are There Any Liberals Supporting Gary Johnson?\nhttps://t.co/KCOQqQrhaY","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Rancho Cucamonga, CA","id":"36ac79e68ace76e4","name":"Rancho Cucamonga","place_type":"city","bounding_box":rectangle("-117.637862,34.077184 -117.486443,34.166156")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6071,"countyName":"San Bernardino","cityID":659451,"cityName":"Rancho Cucamonga"},"user":{"id":int64("611001007"),"name":"#M","screen_name":"digitalbooger","lang":"en","location":"Rancho Cucamonga","create_at":date("2012-06-17"),"description":"Rams back! Dodgers Lakers Kings USC Duke Bsktbl REM Who Tull U2 Floyd! Liberal Pacifist/Warmonger Chico St. alum AbsurdistNerd 1st S ci Fi novel coming","followers_count":1339,"friends_count":1502,"statues_count":7000}} +{"create_at":datetime("2016-09-23T12:26:52.000"),"id":int64("779401665518637056"),"text":"@maddow @tedcruz @MSNBC , you are shame to the people to USA if you endorse Trump. where are your balls??","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("16129920"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{16129920,23022687,2836421}},"place":{"country":"United States","country_code":"United States","full_name":"Delray Beach, FL","id":"b4a0e9082dcc8436","name":"Delray Beach","place_type":"city","bounding_box":rectangle("-80.13094,26.420813 -80.05542,26.491482")},"geo_tag":{"stateID":12,"stateName":"Florida","countyID":12099,"countyName":"Palm Beach","cityID":1217100,"cityName":"Delray Beach"},"user":{"id":int64("199408437"),"name":"Nidia Gerlach","screen_name":"mamamia909","lang":"en","location":"Delray Beach, Fl. ","create_at":date("2010-10-06"),"description":"Nos encanta ser parte del progreso de nuestro pais. We love t o be part of the progress of our Country.","followers_count":330,"friends_count":1491,"statues_count":1651}} +{"create_at":datetime("2016-09-23T12:26:52.000"),"id":int64("779401667477250048"),"text":"#johnmccain #kellyayotte #ronjohnson #robportman #PatToomey #RichardBurr #markkirk #chuckgrassley \n #trump #gop\nhttps://t.co/YAVjNZ4NxD","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"und","is_retweet":false,"hashtags":{{"johnmccain","kellyayotte","ronjohnson","robportman","PatToomey","RichardBurr","markkirk","chuckgrassley","trump","gop"}},"place":{"country":"United States","country_code":"United States","full_name":"San Francisco, CA","id":"5a110d312052166f","name":"San Francisco","place_type":"city","bounding_box":rectangle("-122.514926,37.708075 -122.357031,37.833238")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6075,"countyName":"San Francisco","cityID":667000,"cityName":"San Francisco"},"user":{"id":int64("216205407"),"name":"Ken Holsclaw","screen_name":"KenHolsclaw","lang":"en","location":"E arth","create_at":date("2010-11-15"),"description":"Basically good,kind, and smart. Hate bigots,false prophets, and mixing politics and religion. Killing women and children in a war should never be intentional.","followers_count":608,"friends_count":561,"statues_count":46347}} +{"create_at":datetime("2016-09-23T12:26:55.000"),"id":int64("779401678567067648"),"text":"@MCuban will sit front row at debates. @HillaryClinton guest. Will he make #DonaldTrump squirm? #SiSePuede https://t.co/uG0HzbBULk","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("16228398"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"hashtags":{{"DonaldTrump","SiSePuede"}},"user_mentions":{{16228398,1339835893}},"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"},"user":{"id":int64("63619403"),"name":"Wise Latinas Linked","screen_name":"wiselatinaslink","lang":"en","location":"USA","create_at":date("2009-08-06"),"description":"#Latina #Influencers #activis ts big block #voters & #consumers, recognized by 2011 & 2013 @LATISM social media leaders | Latina group on #Facebook w/ 7K members","followers_count":8087,"friends_count":5416,"statues_count":19195}} +{"create_at":datetime("2016-09-23T12:26:55.000"),"id":int64("779401679787610112"),"text":"I still think that Ted Cruz is gonna Rick Roll Trump just like he did at the convention. They're both ass hats like that.","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"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"},"user":{"id":int64("25761955"),"name":"Tony Hernandez","screen_name":"HernandezTony","lang":"en","location":"Phoenix, AZ","create_at":date("2009-03-21"),"description":"Author","followers_count":985,"friends_count":583,"statues_count":35384}} +{"create_at":datetime("2016-09-23T12:27:00.000"),"id":int64("779401699291168768"),"text":"@tedcruz HOWS YOUR DAD TODAY!!! IS IT REALLY WORTH IT!!! \uD83D\uDC4E\uD83C\uDFFD\uD83D\uDC4E\uD83D\uDC4E\uD83C\uDFFC\uD83D\uDC4E\uD83C\uDFFF\uD83D\uDC4E\uD83C\uDFFE\uD83D\uDC4E\uD83C\uDFFB\uD83D\uDC36\u274C\uD83D\uDC36\u274C\uD83D\uDC36\u274C\uD83D\uDC36 https://t.co/6MxunVNs8M","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("23022687"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{23022687}},"place":{"country":"United States","country_code":"United States","full_name":"Shinnecock Hills, NY","id":"a34194954d3e5af3","name":"Shinnecock Hills","place_type":"city","bounding_box":rectangle("-72.484145,40.875807 -72.43394,40.897898")},"geo_tag":{"stateID":36,"stateName":"New York","countyID":36103,"countyName":"Suffolk","cityID":3667048,"cityName":"Shinnecock Hills"},"user":{"id":int64("766964096126320640"),"name":"Corey B.","scree n_name":"Coreybez1","lang":"en","location":"Shinnecock Hills, NY","create_at":date("2016-08-20"),"description":"null","followers_count":792,"friends_count":1865,"statues_count":15868}} +{"create_at":datetime("2016-09-23T12:27:03.000"),"id":int64("779401710523383808"),"text":"Hillary on Inner City Youth \n\"Bring to Heel\"\nhttps://t.co/KyV1g5EXYP\n\nTrump - \"Spend Billions\" on Inner City Youth \nhttps://t.co/PypeKtGTcJ","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"San Juan Capistrano, CA","id":"4aea239b6a146e77","name":"San Juan Capistrano","place_type":"city","bounding_box":rectangle("-117.686553,33.466555 -117.611591,33.54673")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6059,"countyName":"Orange","cityID":668028,"cityName":"San Juan Capistrano"},"user":{"id":int64("187059363"),"name":"Flavius Aetius","screen_name":"StupidBoomers","lang":"en","location":"The Titanic State or CA","create_at":date("2010-09-04"),"description":"The Worst Generation-Liberal Baby Boomers -are destroying USA w their selfish, greedy & unsustainable entitlement policies-Young Vet-Media Bias MUST STOP","followers_count":13932,"friends_count":15315,"statues_count":147185}} +{"create_at":datetime("2016-09-23T12:27:08.000"),"id":int64("779401732208066561"),"text":"Reality tv stars stick together ? Imagine the episode Kim K will film at White House if Donald is president :-) https://t.co/YVKUnW3G7V","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Princeton, NJ","id":"c833fbabba6fe48e","name":"Princeton","place_type":"city","bounding_box":rectangle("-74.710297,40.32495 -74.619759,40.37435")},"geo_tag":{"stateID":34,"stateName":"New Jersey","countyID":34021,"countyName":"Mercer","cityID":3460900,"cityName":"Princeton"},"user":{"id":int64("305318105"),"name":"Steven Strauss","screen_name":"Steven_Strauss","lang":"en","location":"Cambridge and Princeton ","create_at":date("2011-05-25"),"description":"John L. Weinberg/Goldman Sachs & Co. Visiting Professor at Princeton's Woodrow Wil son School. OpEd contributor at LA Times, USA Today. Usual disclaimers apply","followers_count":43156,"friends_count":4007,"statues_count":84058}} +{"create_at":datetime("2016-09-23T12:27:12.000"),"id":int64("779401752088940544"),"text":"@tedcruz must NOT endorse Trump! #NeverTrump #HillNo","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("23022687"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"hashtags":{{"NeverTrump","HillNo"}},"user_mentions":{{23022687}},"place":{"country":"United States","country_code":"United States","full_name":"Oakland Park, FL","id":"b230af2256484995","name":"Oakland Park","place_type":"city","bounding_box":rectangle("-80.196625,26.150489 -80.117027,26.209352")},"geo_tag":{"stateID":12,"stateName":"Florida","countyID":12011,"countyName":"Broward","cityID":1250575,"cityName":"Oakland Park"},"user":{"id":int64("62919284"),"name":"Tony Gator","screen_name":"gatormiami","lang":"en","location":"MIAMI or thereabouts","create_at":date("2009-08-04"),"description":"Ultra Conservative, Great Gator Fan & Realtor!","followers_count":1724,"friends_count":2385,"stat ues_count":23132}} +{"create_at":datetime("2016-09-23T12:27:19.000"),"id":int64("779401780375543808"),"text":"Kim Kardashian, wife to Kanye West from Chicago, mother of two biracial children.. Is voting Trump. Ha","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Bronx, NY","id":"002e24c6736f069d","name":"Bronx","place_type":"city","bounding_box":rectangle("-73.933612,40.785365 -73.765271,40.91533")},"geo_tag":{"stateID":36,"stateName":"New York","countyID":36005,"countyName":"Bronx","cityID":36005,"cityName":"Bronx"},"user":{"id":int64("169662144"),"name":"lani","screen_name":"kailaniskye","lang":"en","location":"Bronx, NY","create_at":date("2010-07-22"),"description":"issa knife.","followers_count":2854,"friends_count":301,"statues_count":40616}} +{"create_at":datetime("2016-09-23T12:27:19.000"),"id":int64("779401780178321408"),"text":"@OMAROSA I have no intention of \"bowing\" to the bigoted, fascist Trump.. I will STAND, VOTE, FIGHT! https://t.co/jvmb1JC9pu #nevertrump","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("16799621"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"hashtags":{{"nevertrump"}},"user_mentions":{{16799621}},"place":{"country":"United States","country_code":"United States","full_name":"Glen Burnie, MD","id":"cad757363c1a85df","name":"Glen Burnie","place_type":"city","bounding_box":rectangle("-76.644717,39.131259 -76.563196,39.207912")},"geo_tag":{"stateID":24,"stateName":"Maryland","countyID":24003,"countyName":"Anne Arundel","cityID":2432650,"cityName":"Glen Burnie"},"user":{"id":int64("106288017"),"name":"Kelly Lyles","screen_name":"thekellylyles","lang":"en","location":"Washington, D.C. ","create_at":date("2010-01-18"),"description":"Hybrid Blue Dog Democrat. Tweets on #autos #equality #politics Tweets are my own opinion. RTs are not endorsements.","followers_count":192,"friends_count":790,"statues_count":4109}} +{"create_at":datetime("2016-09-23T12:27:20.000"),"id":int64("779401782938206209"),"text":"https://t.co/fyLLenVync @Cernovich @LouDobbs @realDonaldTrump","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"und","is_retweet":false,"user_mentions":{{358545917,26487169,25073877}},"place":{"country":"United States","country_code":"United States","full_name":"Muscle Shoals, AL","id":"74d460734c3eca69","name":"Muscle Shoals","place_type":"city","bounding_box":rectangle("-87.680639,34.705252 -87.617362,34.762527")},"geo_tag":{"stateID":1,"stateName":"Alabama","countyID":1033,"countyName":"Colbert","cityID":153016,"cityName":"Muscle Shoals"},"user":{"id":int64("4852434473"),"name":"GTolbert","screen_name":"GTolbert9","lang":"en","location":"Alabama, USA","create_at":date("2016-01-26"),"description":"null","followers_count":647,"friends_count":559,"statues_count":22532}} +{"create_at":datetime("2016-09-23T12:27:40.000"),"id":int64("779401869084983296"),"text":"Cincinnati Enquirer spurns Donald Trump to endorse first Democrat in nearly 100 years https://t.co/juhelRdfQX","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"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"},"user":{"id":int64("308851637"),"name":"Ingrid E Baptista","screen_name":"Ingridebap","lang":"en","location":"New York","create_at":date("2011-05-31"),"description":"null","followers_count":250,"friends_count":938,"statues_count":15376}} +{"create_at":datetime("2016-09-23T12:27:44.000"),"id":int64("779401883588833280"),"text":"Uh nope add *sarcasm* pls I don't know you personally and there are too many trump trolls bought by Russia https://t.co/2kStJCm43a","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Las Vegas, NV","id":"5c2b5e46ab891f07","name":"Las Vegas","place_type":"city","bounding_box":rectangle("-115.384091,36.129459 -115.062159,36.336371")},"geo_tag":{"stateID":32,"stateName":"Nevada","countyID":32003,"countyName":"Clark","cityID":3240000,"cityName":"Las Vegas"},"user":{"id":int64("118837027"),"name":"Tracy Downey","screen_name":"msgoddessrises","lang":"en","location":"Viva Las Vegas NV.","create_at":date("2010-03-01"),"description":"Film Student/Writer #DivineInterventionLuckyChronicles CenterR-Ind #Nolabels #NeverTrump #MS #11 yrs Proud innovator with a keyboard. God is in control.","followers_count":1715,"friends_count":340,"statues_count":157425}} +{"create_at":datetime("2016-09-23T12:27:45.000"),"id":int64("779401890333196288"),"text":"@OliverNorgrove @LennyPetsPuppys @senatorshoshana @Popehat \nConsidering the crazy ass shit #Trump pulls, Gary looks like a RhodesScholar.","in_reply_to_status":int64("779352824077508608"),"in_reply_to_user":int64("2233524090"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"hashtags":{{"Trump"}},"user_mentions":{{2233524090,714755712,38445467,18839937}},"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"},"user":{"id":int64("21906070"),"name":"Remember Benghazi!","screen_name":"Kegan05","lang":"en","location":"Northwest USA","create_at":date("2009-02-25"),"description": "Political Junkie, Republican, Recovered Reagan Democrat of 20+ years. Slick Willy was my motivation for dumping the CommieCrats. Never looked back! #TGDN","followers_count":11446,"friends_count":10924,"statues_count":249793}} +{"create_at":datetime("2016-09-23T12:27:47.000"),"id":int64("779401896033390593"),"text":"To terrible human beings in one picture https://t.co/PhJJsXtcGa","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Auburn, AL","id":"deb349182b3f42bb","name":"Auburn","place_type":"city","bounding_box":rectangle("-85.569969,32.532449 -85.413112,32.662041")},"geo_tag":{"stateID":1,"stateName":"Alabama","countyID":1081,"countyName":"Lee","cityID":103076,"cityName":"Auburn"},"user":{"id":int64("35630380"),"name":"Ben Stoner","screen_name":"Ben_Stoner96","lang":"en","location":"Auburn, AL","create_at":date("2009-04-26"),"description":"AU","followers_count":571,"friends_count":530,"statues_count":14829}} +{"create_at":datetime("2016-09-23T12:27:47.000"),"id":int64("779401897304289281"),"text":"@guypbenson Cruz is still \u201Cyoung\u201D and ambitious - its probably also not a coincidence this occurring while Trump talking about SCOTUS.","in_reply_to_status":int64("779394688637775873"),"in_reply_to_user":int64("16193222"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{16193222}},"place":{"country":"United States","country_code":"United States","full_name":"Boynton Beach, FL","id":"005e3661711a29a9","name":"Boynton Beach","place_type":"city","bounding_box":rectangle("-80.173447,26.476484 -80.05236,26.590488")},"geo_tag":{"stateID":12,"stateName":"Florida","countyID":12099,"countyName":"Palm Beach","cityID":1207875,"cityName":"Boynton Beach"},"user":{"id":int64("14641687"),"name":"Aaron Von Gauss","screen_name":"AVonGauss","lang":"en","location":"Boynton Beach, FL","create_at":date("2008-05-03"),"description":"Technology Consultan t who strangely does not live in Silicon Valley, Alley nor Wonderland.","followers_count":134,"friends_count":107,"statues_count":8100}} +{"create_at":datetime("2016-09-23T12:27:52.000"),"id":int64("779401916715376641"),"text":"That says a lot. https://t.co/zKvbTvtmAx","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Shady Shores, TX","id":"6f357cae6be7a645","name":"Shady Shores","place_type":"city","bounding_box":rectangle("-97.065657,33.137751 -97.013767,33.177785")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48121,"countyName":"Denton","cityID":4867100,"cityName":"Shady Shores"},"user":{"id":int64("351153807"),"name":"Nancy Bell","screen_name":"Flygirlfly625","lang":"en","location":"Shady Shores Texas","create_at":date("2011-08-08"),"description":"Occupational Therapist, HomeModification Consultant,NDT Certified. Ergonomic Specialist.Hobbies:Flying, Home Remodeling/Staging, and attempts to play the violin","followers_count":16 2,"friends_count":435,"statues_count":4024}} +{"create_at":datetime("2016-09-23T12:27:53.000"),"id":int64("779401920461111297"),"text":"A vote is the ULTIMATE endorsement -After Bitter Primary Fight, Ted Cruz To Back Donald Trump https://t.co/4oFZzi9kGL","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Waverly, MI","id":"00534e655a405438","name":"Waverly","place_type":"city","bounding_box":rectangle("-86.117567,42.783159 -86.058053,42.856213")},"geo_tag":{"stateID":26,"stateName":"Michigan","countyID":26045,"countyName":"Eaton","cityID":2684800,"cityName":"Waverly"},"user":{"id":int64("728972859356250113"),"name":"Murphy for Congress","screen_name":"DMurphyCongress","lang":"en","location":"Grandville, MI","create_at":date("2016-05-07"),"description":"Voters have a choice! I'm Dennis and I hope to serve in Congress as a Dem from Michigan\u2019s 2nd Dis trict. Feel free to tweet questions & please vote in November!","followers_count":68,"friends_count":160,"statues_count":87}} +{"create_at":datetime("2016-09-23T12:27:56.000"),"id":int64("779401933220184064"),"text":"He's not going to endorse. https://t.co/WEh2PwnWB6","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Rosenberg, TX","id":"00f2b6161655c5cc","name":"Rosenberg","place_type":"city","bounding_box":rectangle("-95.835024,29.482424 -95.699766,29.581688")},"geo_tag":{"stateID":48,"stateName":"Texas","countyID":48157,"countyName":"Fort Bend","cityID":4863284,"cityName":"Rosenberg"},"user":{"id":int64("1424259144"),"name":"Deborah Pearson","screen_name":"debpearsonTX","lang":"en","location":"In the Clouds protecting USA","create_at":date("2013-05-12"),"description":"Born and bred in Texas!! Conservative voter. God fearing, concerned about our REPUBLIC. God bless USA. GOD BLESS TEXAS! #NRA http://tedcruz.org","followers_count": 2266,"friends_count":3262,"statues_count":18221}} +{"create_at":datetime("2016-09-23T12:27:56.000"),"id":int64("779401936441315329"),"text":"Imagine thinking this https://t.co/2E79rFHCUo","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"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"},"user":{"id":int64("3099901028"),"name":"Brandy Jensen","screen_name":"BrandyLJensen","lang":"en","location":"Brooklyn, NY","create_at":date("2015-03-20"),"description":"behind every successful man is a woman pegging him","followers_count":8538,"friends_count":1446,"statues_count":32937}} +{"create_at":datetime("2016-09-23T12:27:57.000"),"id":int64("779401938181971969"),"text":"I am a bit puzzled why the same people that harassed Marco about endorsing Trump are making excuses for Cruz now...","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Manlius, NY","id":"a91318fb3d0ef965","name":"Manlius","place_type":"city","bounding_box":rectangle("-76.026142,42.968277 -75.935566,43.093685")},"geo_tag":{"stateID":36,"stateName":"New York","countyID":36067,"countyName":"Onondaga","cityID":3645018,"cityName":"Manlius"},"user":{"id":int64("237089251"),"name":"Nick Lindquist","screen_name":"nick_lindquist","lang":"en","location":"Team Marco","create_at":date("2011-01-11"),"description":"LMC '19 \u2022 Marketing \u2022 Young Politico \u2022 @decainc Region 9 Officer/Alum \u2022 John Katko Intern \u2022 Con tributor @RedMillennial \u2022 Font Aficionado \u2022 Dr. Pepper Addict","followers_count":934,"friends_count":783,"statues_count":13392}} +{"create_at":datetime("2016-09-23T12:27:58.000"),"id":int64("779401941575237636"),"text":"They're rl idiots!!!! https://t.co/gdRfntHaXU","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Dale City, VA","id":"66cd2cdb819f4414","name":"Dale City","place_type":"city","bounding_box":rectangle("-77.443065,38.61099 -77.274813,38.68125")},"geo_tag":{"stateID":51,"stateName":"Virginia","countyID":51153,"countyName":"Prince William","cityID":5121088,"cityName":"Dale City"},"user":{"id":int64("3229093668"),"name":"Cheena Byrd","screen_name":"ChillCheena","lang":"en","location":"null","create_at":date("2015-05-28"),"description":"August 25\u2764\uFE0F #E4SooMs","followers_count":420,"friends_count":202,"statues_count":8596}} +{"create_at":datetime("2016-09-23T12:28:00.000"),"id":int64("779401952438263808"),"text":"@KarenLeslieHall @speechboy71 It's a tossup. This is a dumbed down electorate, fed lies, rumors, rumors of lies daily. Trump is the product.","in_reply_to_status":int64("779371105081516032"),"in_reply_to_user":int64("1169239260"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{1169239260,113061485}},"place":{"country":"United States","country_code":"United States","full_name":"San Francisco, CA","id":"5a110d312052166f","name":"San Francisco","place_type":"city","bounding_box":rectangle("-122.514926,37.708075 -122.357031,37.833238")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6075,"countyName":"San Francisco","cityID":667000,"cityName":"San Francisco"},"user":{"id":int64("977619834"),"name":"Blind Willies","screen_name":"williesband","lang":"en","location":"San Francisco","create_at":date("2012-11-28"),"description":"rock. \ r\n\r\nStreaming: http://blindwillies.bandcamp.com\r\n\r\nhttp://facebook.com/blindwillies\r\n\r\nContact: blindwill...@blindwillies.net","followers_count":1156,"friends_count":952,"statues_count":6176}} +{"create_at":datetime("2016-09-23T12:28:09.000"),"id":int64("779401988949811200"),"text":"@AlanColmes You are constantly looking ways to bash Trump? Open your eyes Allen and see what HRC has to offer. Nada. You do us a disservice","in_reply_to_status":int64("779393945889411072"),"in_reply_to_user":int64("14924233"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{14924233}},"place":{"country":"United States","country_code":"United States","full_name":"Huntertown, IN","id":"017e230d04270300","name":"Huntertown","place_type":"city","bounding_box":rectangle("-85.186546,41.199635 -85.104621,41.244575")},"geo_tag":{"stateID":18,"stateName":"Indiana","countyID":18003,"countyName":"Allen","cityID":1835266,"cityName":"Huntertown"},"user":{"id":int64("321627407"),"name":"Jeanne Boutilier","screen_name":"mtnest11","lang":"en","location":"Indiana, USA","create_at":date("2011-06-21"),"description":"Happy follower of spouse, 6 states / 11 ho uses. Love being a Grams, best job ever! Lover of life, family, friends & all breathing things. (except spiders)","followers_count":180,"friends_count":297,"statues_count":4288}} +{"create_at":datetime("2016-09-23T12:28:11.000"),"id":int64("779401997527031808"),"text":"This newspaper just endorsed its first Democrat for president in almost a century, because Trump https://t.co/Wuudp4zhf1 via @motherjones","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"en","is_retweet":false,"user_mentions":{{18510860}},"place":{"country":"United States","country_code":"United States","full_name":"Dublin, CA","id":"003253f0107acd32","name":"Dublin","place_type":"city","bounding_box":rectangle("-121.979522,37.697406 -121.849535,37.733656")},"geo_tag":{"stateID":6,"stateName":"California","countyID":6001,"countyName":"Alameda","cityID":620018,"cityName":"Dublin"},"user":{"id":int64("1850731"),"name":"Joyce Tompsett","screen_name":"joycetompsett","lang":"en","location":"Nerdistan CA","create_at":date("2007-03-22"),"description":"Girl Geek, Tech Evangelist, Dir. of Silicon Valley Exec Briefing Ctr at D ell Technologies, yogini, world traveler, living moment by moment w/open heart.","followers_count":902,"friends_count":1335,"statues_count":9773}} +{"create_at":datetime("2016-09-23T12:28:12.000"),"id":int64("779401999859064832"),"text":"\uD83D\uDE04 https://t.co/pE1oMWDVjL","in_reply_to_status":int64("-1"),"in_reply_to_user":int64("-1"),"favorite_count":int64("0"),"retweet_count":int64("0"),"lang":"und","is_retweet":false,"place":{"country":"United States","country_code":"United States","full_name":"Summerlin South, NV","id":"0134e6167ff7f6ec","name":"Summerlin South","place_type":"city","bounding_box":rectangle("-115.355825,36.082837 -115.314862,36.159081")},"geo_tag":{"stateID":32,"stateName":"Nevada","countyID":32003,"countyName":"Clark","cityID":3270900,"cityName":"Summerlin South"},"user":{"id":int64("50230100"),"name":"Tracey","screen_name":"tsh219","lang":"en","location":"Las Vegas,NV ","create_at":date("2009-06-23"),"description":"Native New Yorker, Educator, Doctoral (Ed.D.) Candidate. Waiting For My White Privilege To Kick In. #TrumpPence2016 #MAGA #NeverHillary","followers_count":766,"friends_count":522,"statues_cou nt":5386}}
