FAQ | Problem?

soda tax_2017-11-14_12-55-01.xlsx
soda tax_2017-11-14_12-55-01.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
November 14, 2017
Short Description:
soda tax via NodeXL http://bit.ly/2zCzypV
@axthebevtax
@bansodatax
@fatcatvapor
@mihotep
@phillymayor
@nancyatheart
@drtomfarley
@nyshepa

Description:
Description
The graph represents a network of 1,389 Twitter users whose tweets in the requested range contained "soda tax", or who were replied to or mentioned in those tweets. The network was obtained from the NodeXL Graph Server on Tuesday, 14 November 2017 at 20:55 UTC.

The requested start date was Tuesday, 14 November 2017 at 01:01 UTC and the maximum number of days (going backward) was 14.

The maximum number of tweets collected was 5,000.

The tweets in the network were tweeted over the 13-day, 15-hour, 35-minute period from Tuesday, 31 October 2017 at 01:59 UTC to Monday, 13 November 2017 at 17:34 UTC.

Additional tweets that were mentioned in this data set were also collected from prior time periods. These tweets may expand the complete time period of the data.

There is an edge for each "replies-to" relationship in a tweet, an edge for each "mentions" relationship in a tweet, and a self-loop edge for each tweet that is not a "replies-to" or "mentions".

The graph is directed.

The graph's vertices were grouped by cluster using the Clauset-Newman-Moore cluster algorithm.

The graph was laid out using the Harel-Koren Fast Multiscale layout algorithm.


Author Description


Overall Graph Metrics
Vertices : 1389
Unique Edges : 1436
Edges With Duplicates : 344
Total Edges : 1780
Self-Loops : 362
Reciprocated Vertex Pair Ratio : 0.0165745856353591
Reciprocated Edge Ratio : 0.0326086956521739
Connected Components : 356
Single-Vertex Connected Components : 170
Maximum Vertices in a Connected Component : 614
Maximum Edges in a Connected Component : 924
Maximum Geodesic Distance (Diameter) : 15
Average Geodesic Distance : 4.704146
Graph Density : 0.000668073355284315
Modularity : 0.74863
NodeXL Version : 1.0.1.389

Top Influencers: Top 10 Vertices, Ranked by Betweenness Centrality
Top URLs
Top URLs in Tweet in Entire Graph:
[22] https://www.hsph.harvard.edu/news/hsph-in-the-news/philadelphia-soda-tax-sales/?utm_source=Twitter&utm_medium=Social&utm_campaign=Chan-Twitter-General
[21] https://www.thelocal.fr/20171027/france-tackles-obesity-by-hiking-soda-tax-on-sugary-drinks
[19] http://www.philly.com/philly/news/pennsylvania/another-take-on-soda-tax-businesses-not-hurt-by-levy-20171102.html
[17] http://ahealthblog.com/how-soda-impacts-your-body-infographic-1.html
[15] http://www.philly.com/philly/news/politics/city/another-take-on-soda-tax-businesses-not-hurt-by-levy-20171102.html
[14] https://cspinet.org/sites/default/files/attachment/big-soda-2017.pdf
[10] http://po.st/scms/OrMCe04Lcp0lOFmbYqK-tPTzJpoaCzOdyIwfOEELcp0/w91Epa
[9] http://philadelphia.cbslocal.com/2017/10/24/jeffery-brown-on-soda-tax-out-of-our-seven-stores-four-are-unprofitable/
[8] https://therussells.crossfit.com/2016/10/12/hillary-clinton-campaign-officials-helped-coca-cola-fight-soda-tax/
[7] http://healthfitnesstrends.net/Nutrition/yes-the-berkeley-soda-tax-is-doing-what-it-is-supposed-to

Top URLs in Tweet in G1:
[2] http://www.phillytrib.com/news/report-soda-tax-pinching-markets/article_8c46e59b-51a6-5049-a8ba-9d970890aa1d.html
[2] http://www.philly.com/philly/opinion/commentary/soda-tax-philadelphia-butkovitz-council-20171025.html
[2] https://northeasttimes.com/op-ed-kenneys-soda-tax-is-economically-destructive-b213faeb7476
[1] http://philadelphia.cbslocal.com/2017/10/24/jeffery-brown-on-soda-tax-out-of-our-seven-stores-four-are-unprofitable/
[1] https://www.cnbc.com/2017/08/22/philadelphias-soda-tax-isnt-the-windfall-some-had-hoped-for.html
[1] http://www.philly.com/philly/news/pennsylvania/philadelphia/philadelphia-soda-tax-sales-20170822.html
[1] https://twitter.com/dorisg66535968/status/928597177605206017
[1] https://twitter.com/i/web/status/928660245114580992
[1] https://twitter.com/i/web/status/927964799425683456
[1] https://twitter.com/fundPHLschools/status/925741729780850688

Top URLs in Tweet in G2:
[6] https://www.thelocal.fr/20171027/france-tackles-obesity-by-hiking-soda-tax-on-sugary-drinks
[6] http://healthfitnesstrends.net/Nutrition/yes-the-berkeley-soda-tax-is-doing-what-it-is-supposed-to
[4] http://healthfitnesstrends.net/Nutrition/another-soda-tax-success-story-howard-county-md
[3] https://chicago.eater.com/2017/10/31/16584484/subway-chicago-soda-tax-lawsuit-cook-county
[3] http://www.gopusa.com/phillys-fizzling-soda-tax/
[3] https://www.accuratetax.com/blog/soda-tax-debate/
[3] http://CVSoci.al/HXmls8du
[2] https://chicago.eater.com/2017/10/31/16584484/subway-chicago-soda-tax-lawsuit-cook-county?utm_source=dlvr.it&utm_medium=twitter
[2] http://triblive.com/opinion/editorials/12851213-74/trib-editorial-phillys-fizzling-soda-tax
[2] http://www.bethesdamagazine.com/Bethesda-Beat/2017/Council-Members-Exploring-Soda-Tax-in-Montgomery-County/

Top URLs in Tweet in G3:
[3] https://medium.com/m/global-identity?redirectUrl=https%3A%2F%2Fnortheasttimes.com%2Fop-ed-kenneys-soda-tax-is-economically-destructive-b213faeb7476
[2] https://www.hsph.harvard.edu/news/hsph-in-the-news/philadelphia-soda-tax-sales/
[2] http://healthfitnesstrends.net/Nutrition/another-soda-tax-success-story-howard-county-md
[2] http://www.philly.com/philly/news/pennsylvania/another-take-on-soda-tax-businesses-not-hurt-by-levy-20171102.html
[1] https://twitter.com/i/web/status/929082520808943617
[1] http://feeds.bizjournals.com/~r/bizj_philadelphia/~3/XrQfLu6klxY/philly-soda-tax-pbt-bev-tax-pass-through-retail.html?utm_content=philadelphia&utm_campaign=socialflow&utm_source=twitter&utm_medium=social
[1] https://twitter.com/i/web/status/926546801670451202
[1] http://www.politifact.com/pennsylvania/statements/2016/apr/25/bernie-s/fact-checking-bernie-sanders-claim-jim-kenneys-sod/
[1] https://twitter.com/i/web/status/926968292471918592
[1] https://twitter.com/i/web/status/926968506901463043

Top URLs in Tweet in G4:
[4] http://www.phillymag.com/news/2017/11/03/naacp-soda-tax-rodney-muhammad/
[2] https://www.hsph.harvard.edu/news/hsph-in-the-news/philadelphia-soda-tax-sales/
[1] https://twitter.com/i/web/status/927564517671829504
[1] http://www.phillymag.com/.../naacp-soda-tax-rodney-muhammad/
[1] https://finance.townhall.com/columnists/politicalcalculations/2017/10/06/philadelphia-soda-tax-collections-start-fiscal-year-in-deep-hole-n2391232
[1] https://twitter.com/i/web/status/926505095080136704
[1] https://twitter.com/i/web/status/926173379031371776

Top URLs in Tweet in G5:
[12] https://cspinet.org/sites/default/files/attachment/big-soda-2017.pdf
[5] https://medium.com/m/global-identity?redirectUrl=https://northeasttimes.com/op-ed-kenneys-soda-tax-is-economically-destructive-b213faeb7476
[4] http://www.philly.com/philly/news/politics/city/another-take-on-soda-tax-businesses-not-hurt-by-levy-20171102.html
[1] http://www.philly.com/philly/news/pennsylvania/another-take-on-soda-tax-businesses-not-hurt-by-levy-20171102.html
[1] http://www.philly.com/philly/news/politics/city/another-take-on-soda-tax-businesses-not-hurt-by-levy-20171102.html?mobi=true
[1] https://twitter.com/i/web/status/926482115461607425
[1] https://twitter.com/i/web/status/926141209571221504

Top URLs in Tweet in G6:
[1] http://newsroom.heart.org/news/philadelphias-beverage-tax-is-working

Top URLs in Tweet in G7:
[8] https://therussells.crossfit.com/2016/10/12/hillary-clinton-campaign-officials-helped-coca-cola-fight-soda-tax/
[6] https://twitter.com/dunkthejunkfood/status/927911838850994176
[2] https://www.thelocal.fr/20171027/france-tackles-obesity-by-hiking-soda-tax-on-sugary-drinks
[1] https://twitter.com/Jorgestein44/status/924423640447320069
[1] https://cspinet.org/sites/default/files/attachment/big-soda-2017.pdf
[1] https://twitter.com/i/web/status/926235601359265792

Top URLs in Tweet in G8:
[12] http://www.philly.com/philly/news/pennsylvania/another-take-on-soda-tax-businesses-not-hurt-by-levy-20171102.html
[3] http://www.philly.com/philly/news/politics/city/another-take-on-soda-tax-businesses-not-hurt-by-levy-20171102.html
[2] https://www.hsph.harvard.edu/news/hsph-in-the-news/philadelphia-soda-tax-sales/
[1] http://www.philly.com/philly/news/politics/city/another-take-on-soda-tax-businesses-not-hurt-by-levy-20171102.html?utm_campaign=Philly.com+Twitter+Account&utm_source=t.co&utm_medium=social&cid=Philly.com+Twitter
[1] http://www.philly.com/philly/news/politics/city/soda-tax-philadelphia-airport-20171030.html
[1] http://www.philly.com/r?19=961&43=168201&44=454547613&32=3796&7=195367&40=http%3A%2F%2Fwww.philly.com%2Fphilly%2Fnews%2Fpolitics%2Fanother-take-on-soda-tax-businesses-not-hurt-by-levy-20171102.html&utm_source=dlvr.it&utm_medium=twitter

Top URLs in Tweet in G9:
[2] https://www.bizjournals.com/philadelphia/news/2017/10/25/pbt-beverage-tax-soda-tax-september-revenue.html?platform=hootsuite
[1] http://www.philly.com/philly/news/pennsylvania/another-take-on-soda-tax-businesses-not-hurt-by-levy-20171102.html?platform=hootsuite
[1] https://fb.me/2egVSy0G8
[1] https://twitter.com/i/web/status/926029312834326528
[1] https://www.thelocal.fr/20171027/france-tackles-obesity-by-hiking-soda-tax-on-sugary-drinks

Top URLs in Tweet in G10:
[22] https://www.hsph.harvard.edu/news/hsph-in-the-news/philadelphia-soda-tax-sales/?utm_source=Twitter&utm_medium=Social&utm_campaign=Chan-Twitter-General

Top Domains
Top Domains in Tweet in Entire Graph:
[195] twitter.com
[52] philly.com
[29] harvard.edu
[22] thelocal.fr
[19] bizjournals.com
[17] healthfitnesstrends.net
[17] ahealthblog.com
[14] cspinet.org
[13] fb.me
[12] medium.com

Top Domains in Tweet in G1:
[5] twitter.com
[3] philly.com
[2] phillytrib.com
[2] northeasttimes.com
[1] cbslocal.com
[1] cnbc.com

Top Domains in Tweet in G2:
[36] twitter.com
[13] healthfitnesstrends.net
[8] fb.me
[6] thelocal.fr
[5] eater.com
[4] google.com
[4] bizjournals.com
[3] nytimes.com
[3] medium.com
[3] gopusa.com

Top Domains in Tweet in G3:
[23] twitter.com
[4] healthfitnesstrends.net
[4] philly.com
[3] medium.com
[2] harvard.edu
[1] bizjournals.com
[1] politifact.com
[1] thelocal.fr
[1] economics21.org
[1] treehugger.com

Top Domains in Tweet in G4:
[5] phillymag.com
[3] twitter.com
[2] harvard.edu
[1] townhall.com

Top Domains in Tweet in G5:
[12] cspinet.org
[6] philly.com
[5] medium.com
[2] twitter.com

Top Domains in Tweet in G6:
[1] heart.org

Top Domains in Tweet in G7:
[8] crossfit.com
[8] twitter.com
[2] thelocal.fr
[1] cspinet.org

Top Domains in Tweet in G8:
[18] philly.com
[2] harvard.edu

Top Domains in Tweet in G9:
[2] bizjournals.com
[1] philly.com
[1] fb.me
[1] twitter.com
[1] thelocal.fr

Top Domains in Tweet in G10:
[22] harvard.edu

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[137] axthebevtax
[34] sodatax
[23] health
[20] fitness
[9] soda
[9] boycottnfl
[8] philly
[7] philadelphia
[7] phillybevtax
[6] cookcounty



Top Hashtags in Tweet in G1:
[134] axthebevtax

Top Hashtags in Tweet in G2:
[17] health
[14] fitness
[8] sodatax
[7] soda
[3] illinois
[2] cookcounty
[2] tax
[2] wellness
[1] oped
[1] philly

Top Hashtags in Tweet in G3:
[4] soduh
[4] health
[4] fitness
[3] philadelphia
[2] sodatax
[1] philly
[1] grabyourwallet
[1] twill
[1] bevtax
[1] reallyreally

Top Hashtags in Tweet in G4:
[1] same
[1] philly
[1] sodatax

Top Hashtags in Tweet in G5:
[4] phillyfail
[2] axthebevtax

Top Hashtags in Tweet in G7:
[3] philadelphia
[3] sugar
[3] nationaldiabetesmonth

Top Hashtags in Tweet in G8:
[5] phillybevtax

Top Hashtags in Tweet in G9:
[4] beatncds
[2] sodatax

Top Words
Top Words in Tweet in Entire Graph:
[528] Words in Sentiment List#1: Positive
[758] Words in Sentiment List#2: Negative
[71] Words in Sentiment List#3: Angry/Violent
[22140] Non-categorized Words
[23426] Total Words
[906] tax
[842] soda
[409] axthebevtax
[295] sales
[264] s

Top Words in Tweet in G1:
[395] axthebevtax
[209] s
[164] lose
[142] families
[138] https
[134] council
[131] sales
[127] biz
[125] city
[124] bevtax

Top Words in Tweet in G2:
[190] tax
[181] soda
[26] health
[24] chicago
[21] philadelphia
[18] county
[18] 1
[16] first
[16] please
[16] 5

Top Words in Tweet in G3:
[118] tax
[116] soda
[36] county
[34] cook
[21] t
[18] moveforwardmult
[17] regressive
[16] repealed
[14] don
[11] philadelphia

Top Words in Tweet in G4:
[37] tax
[34] soda
[17] phillymayor
[6] money
[5] fox29philly
[5] going
[4] mayor
[4] much
[4] philly
[4] mrernestowens

Top Words in Tweet in G5:
[46] sales
[42] tax
[31] soda
[24] philly
[24] drtomfarley
[23] sugary
[23] study
[23] stores
[22] penn
[22] harvard

Top Words in Tweet in G6:
[72] good
[36] philly
[36] soda
[36] tax
[36] working
[36] beverage
[36] sales
[36] down
[36] health
[36] grocery

Top Words in Tweet in G7:
[31] soda
[29] tax
[13] greenplusane
[8] exclusive
[8] reporting
[8] hillaryclinton
[8] campaign
[8] officials
[8] helped
[8] cocacolaco

Top Words in Tweet in G8:
[21] tax
[20] soda
[19] hurt
[18] businesses
[17] phillydotcom
[9] sales
[9] harvard
[9] penn
[8] another
[8] take

Top Words in Tweet in G9:
[18] tax
[17] sugary
[17] drinks
[15] preliminary
[15] results
[15] philly
[15] bev
[15] show
[15] decrease
[15] sales

Top Words in Tweet in G10:
[22] philadelphia
[22] soda
[22] tax
[22] appear
[22] hurt
[22] overall
[22] store
[22] sales
[21] harvardchansph

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[607] soda,tax
[100] philly,s
[93] small,biz
[85] families,pay
[83] pay,higher
[83] higher,prices
[83] prices,people
[83] people,lose
[83] lose,jobs
[83] jobs,small

Top Word Pairs in Tweet in G1:
[91] small,biz
[88] philly,s
[82] families,pay
[82] pay,higher
[82] higher,prices
[82] prices,people
[82] people,lose
[82] lose,jobs
[82] jobs,small
[82] biz,lose

Top Word Pairs in Tweet in G2:
[121] soda,tax
[22] tax,soda
[14] please,health
[14] health,fitness
[13] philadelphia,become
[13] become,first
[13] first,major
[13] major,american
[13] american,city
[13] city,pass

Top Word Pairs in Tweet in G3:
[104] soda,tax
[34] cook,county
[14] don,t
[11] two,months
[9] tax,regressive
[9] county,il
[8] tax,soda
[7] opposed,soda
[6] t,fooled
[6] fooled,soda

Top Word Pairs in Tweet in G4:
[33] soda,tax
[5] tax,money
[3] rid,soda
[3] money,going
[2] phillymayor,mayor
[2] philadelphia,soda
[2] tax,appear
[2] appear,hurt
[2] hurt,store
[2] store,sales

Top Word Pairs in Tweet in G5:
[22] penn,harvard
[22] harvard,study
[22] study,philly
[22] philly,tax
[22] tax,cuts
[22] cuts,sugary
[22] sugary,drink
[22] drink,sales
[22] sales,57
[22] 57,impact

Top Word Pairs in Tweet in G6:
[36] philly,soda
[36] soda,tax
[36] tax,working
[36] working,beverage
[36] beverage,sales
[36] sales,down
[36] down,good
[36] good,health
[36] health,grocery
[36] grocery,revenue

Top Word Pairs in Tweet in G7:
[17] soda,tax
[8] exclusive,reporting
[8] reporting,hillaryclinton
[8] hillaryclinton,campaign
[8] campaign,officials
[8] officials,helped
[8] helped,cocacolaco
[8] cocacolaco,fight
[8] fight,soda
[7] greenplusane,exclusive

Top Word Pairs in Tweet in G8:
[19] soda,tax
[13] businesses,hurt
[8] another,take
[8] take,soda
[8] tax,businesses
[8] hurt,levy
[7] levy,phillydotcom
[6] store,sales
[5] penn,harvard
[5] harvard,researches

Top Word Pairs in Tweet in G9:
[17] sugary,drinks
[15] preliminary,results
[15] results,philly
[15] philly,bev
[15] bev,tax
[15] tax,show
[15] show,decrease
[15] decrease,sugary
[15] drinks,sales
[15] sales,without

Top Word Pairs in Tweet in G10:
[22] philadelphia,soda
[22] soda,tax
[22] tax,appear
[22] appear,hurt
[22] hurt,overall
[22] overall,store
[22] store,sales
[21] harvardchansph,philadelphia

Top Replied-To
Top Replied-To in Entire Graph:
@phillymayor
@nyshepa
@phillydotcom
@chmag72
@anniewants
@axthebevtax
@moveforwardmult
@helengymatlarge
@drtomfarley
@tonipreckwinkle

Top Replied-To in G1:
@shelleymichelep
@axthebevtax
@miseichan

Top Replied-To in G3:
@anniewants
@chmag72
@moveforwardmult
@gpantofles
@nyshepa
@seashellfamily
@karen4hearts
@robin42cd
@jhow0089
@annarosenfeld

Top Replied-To in G4:
@phillymayor
@helengymatlarge
@phillydotcom
@jeffcolefox29
@fox29philly
@howardeskin
@philadelphiagov
@jennijoycetv
@kscott6abc
@lil_yenta

Top Replied-To in G5:
@drtomfarley
@phillymayor

Top Replied-To in G8:
@phillydotcom
@liberty4pa

Top Replied-To in G9:
@childrensfood

Top Mentioned
Top Mentioned in Entire Graph:
@axthebevtax
@nancyatheart
@drtomfarley
@harvardchansph
@jhppl
@sarahgollust
@kriegerjim
@againstsugartax
@moveforwardmult
@phillymayor

Top Mentioned in G1:
@axthebevtax

Top Mentioned in G2:
@cornbreadwisdom
@jaspencer1

Top Mentioned in G3:
@moveforwardmult
@phillyhealthsci
@wikileaks
@domelights
@dickdurbin
@axthebevtax
@realdonaldtrump
@chmag72
@forpritzker
@govrauner

Top Mentioned in G4:
@phillymayor
@mrernestowens
@fox29philly
@philanaacp
@darealchrisco
@6abc
@jordanuhl
@bikemamadelphia
@philadelphiadhs
@howardeskin

Top Mentioned in G5:
@drtomfarley
@cspi
@amazon
@healthmac
@fatcatvapor
@axthebevtax
@kriegerjim
@phillymayor

Top Mentioned in G6:
@nancyatheart

Top Mentioned in G7:
@greenplusane
@hillaryclinton
@cocacolaco
@slatha
@lauraschmidtphd
@american_heart
@thehsf
@drscottlear
@slatham
@crossfit

Top Mentioned in G8:
@phillydotcom
@axthebevtax
@harvard
@penn
@laurenhitt
@samijarrah
@clicjf
@healthequitydoc
@lmccrystal
@nancyatheart

Top Mentioned in G9:
@kriegerjim
@network_mms
@amandinegarde
@aveek18
@simoncapewell99
@childrensfood

Top Mentioned in G10:
@harvardchansph

Top Tweeters
Top Tweeters in Entire Graph:
@marcylauren
@alllibertynews
@chris_1791
@jim_peoples_
@ljarratt
@loveorganicxxx
@iceberg21slim5
@instapundit
@live_coverage
@chit_me

Top Tweeters in G1:
@marcylauren
@noreenr1
@britpoptarts
@o_irisht
@russelltim151
@sandyriccobono
@clark7950
@singerman2000
@nancypeggy
@greenbiotechie

Top Tweeters in G2:
@chit_me
@dhrxsol1234
@peoplestrusttor
@dgendvil
@philly_buzz
@honkifyourgay
@varadmehta
@phlsmallbiz
@_papoluca
@tylerbarton27

Top Tweeters in G3:
@instapundit
@cbsphilly
@dandrezner
@aceofspadeshq
@johnglenpdx
@rachelgodlessvg
@lostdiva
@chuckmodi1
@shannoncoulter
@thehealthinsigh

Top Tweeters in G4:
@fox29philly
@nbcphiladelphia
@6abc
@bikemamadelphia
@sportsradiowip
@thephillyvoice
@linds_zolna
@1210wpht
@chrisstigall
@phillynewsguy

Top Tweeters in G5:
@vapeporn
@mihotep
@tribetestmgr
@yonifreedhoff
@jbenton
@cspi
@amazon
@supermarioelia
@drmjoyner
@ericschrimshaw

Top Tweeters in G6:
@laurie_david
@glic16
@dennisg_shea
@mamasconpoder
@killerbgolfer
@consultafamili
@healthtypes
@deettallee
@voicesaction
@rblument1

Top Tweeters in G7:
@jim_peoples_
@amyloukingery
@c_cgottlieb
@robert_veres
@usacit1970
@dunkthejunkfood
@american_heart
@crossfit
@thehsf
@cocacolaco

Top Tweeters in G8:
@chris_1791
@pash22
@phillydotcom
@harvard
@bonillal1
@penn
@newskag
@liberty4pa
@headrick
@laurenhitt

Top Tweeters in G9:
@ilonakickbusch
@ac_brite
@simoncapewell99
@tobyhillman
@harryrutter
@childrensfood
@janeslusser
@mikerayner
@friedinburgh
@richardjaevans

Top Tweeters in G10:
@de_plazza
@sydnets
@shalisa_renee
@annableigh
@armando_ribeiro
@phlu
@monitor_ph
@harvardchansph
@judiehowrylak
@prettypvalue