Yes, another Steemfest 2' homework edition' blog has been completed. I hope you find it of use....
Perhaps you'd like to seek (or avoid!) people at the event with particular blog interests?
What are the most popular tags used by SF2 attendees?
What are the most used tags by each attendee?
Answers to these questions (and more) below...
Hi all
Following an attempt at gathering a list of all the attendees to Steemfest 2 in Lisbon this year, I thought it would be interesting to look into what other information I could find that may be of interest prior to the event.
In today's blog (which took a fair amount of time to create to say the least!), I present to you information regarding the tags used by this years' Steemfest attendees.
The 3 most popular tags used by each attendee
This table presents the 3 most popular tags each attendee has used throughout their blogging career on the Steem Blockchain. The table is ordered alphabetically by first tag, which is the also the most popular tag each attendee has used.
| User | Tags |
|---|---|
| @sterlinluxan | anarchism,anarchy,psychology |
| @shortcut | art,deutsch,photography |
| @opheliafu | art,drawing,creativity |
| @mysteem | art,freedom,meditation |
| @paolobeneforti | art,funny,drawing |
| @sature | art,life,music |
| @yoganarchista | art,life,story |
| @voronoi | art,steemit,architecture |
| @chris4210 | beyondbitcoin,bitshares,News |
| @aaronkoenig | bitcoin,blockchain,film |
| @prc | bitcoin,life,cryptocurrency |
| @charlieshrem | bitcoin,steem,life |
| @robrigo | bitshares,security,blockchain |
| @wmougayar | blockchains,models,innovation |
| @anasya | crazychallenge,game,fun |
| @pollux.one | deutsch,life,photography |
| @redpalestino | deutsch,photography,travel |
| @spurious-claims | education,government,life |
| @ivargereiko | fitness,health,gym |
| @allasyummyfood | food,blog,recipe |
| @knozaki2015 | food,travel,minnowsunite |
| @oroger | fr,belgium,steemit |
| @roxane | fr,maviedeblogueuse,busy |
| @ginacarr | freedom,choice,liberty |
| @acromott | freedom,life,art |
| @lenadr | funny,blog,writing |
| @felixxx | funny,photography,steemit |
| @edb | funny,politics,netherlands |
| @alanfreestone | health,homeopathy,vaccines |
| @varunpinto | india,photography,life |
| @fukako | japanese,art,drawing |
| @kinakomochi | japanese,blog,food |
| @shogo | japanese,photography,food |
| @andrewmcmillen | journalism,longform,writing |
| @ramengirl | kr,blog,food |
| @ludorum | kr,blog,life |
| @maa | kr,coinkorea,bitcoin |
| @successtrainer | kr,kr-newbie,steemit |
| @roychoi | kr,kr-newbie,steemit |
| @hansikhouse | kr,life,story |
| @the-alien | life,alien,steemit |
| @e-saber | life,art,gaming |
| @comealong | life,art,photography |
| @soldier | life,art,writing |
| @surfermarly | life,blog,steemit |
| @wandereronwheels | life,blog,travel |
| @mrs.steemit | life,blog,travel |
| @future24 | life,deutsch,photography |
| @getonthetrain | life,money,history |
| @juanmiguelsalas | life,photography,art |
| @silviabeneforti | life,photography,art |
| @lex030 | life,photography,deutsch |
| @jaybird | life,photography,music |
| @detlev | life,photography,story |
| @noboxes | life,photography,travel |
| @pjo | life,photography,travel |
| @serejandmyself | life,poetry,writing |
| @dayleeo | life,remsteem,remotevoices |
| @cryptofunk | life,steemit,bitcoin |
| @ballinconscious | life,steemit,money |
| @ekitcho | life,steemit,steem |
| @terrybrock | life,steemit,success |
| @dougkarr | life,steemit,video |
| @teamhumble | life,steemit,wakeup |
| @exyle | life,story,blog |
| @bkdbkd | life,story,health |
| @ericvancewalton | life,story,writers |
| @saramiller | life,yoga,health |
| @karensuestudios | love,blog,freedom |
| @massivevibration | massivevibrations,music,art |
| @xanoxt | minnowsunite,payitforward,photography |
| @gmuxx | minnowsupportproject,minnowsupport,art |
| @twinner | money,bitcoin,permacryptofolio |
| @walterjay | money,cryptocurrency,bitshares |
| @dollarvigilante | money,finance,bitcoin |
| @tomasgeorge | music,production,video |
| @elear | opensource,steemdev,steemitdev |
| @shak | pevo,science,meetup |
| @s0u1 | photo,life,automobile |
| @everlove | photography,art,life |
| @gringalicious | photography,food,life |
| @eveuncovered | photography,life,art |
| @rea | photography,life,cn |
| @liliana.duarte | photography,life,portugal |
| @timsaid | photography,life,steemit |
| @mammasitta | photography,life,travel |
| @xroni | photography,nature,photo |
| @nomadnessie | photography,nature,travel |
| @quinneaker | photography,steemit,art |
| @osm0sis | photography,travel,culturevulture |
| @jeffjagoe | photography,travel,food |
| @tarquinmaine | photography,travel,writing |
| @lenka | polish,steepshot,life |
| @annaarthur | politics,germany,democracy |
| @jexblackmore | politics,religion,activism |
| @ashleypeat | promo-uk,promo-steem,steem |
| @starkerz | promo-uk,promo-steem,steemitroadshow |
| @logic | science,steemit,steemsquad |
| @brian-rhodes | screenwriting,filmmaking,acting |
| @val | spam,ru,podcasts |
| @oscarcc89 | spanish,art,blog |
| @gargon | spanish,cervantes,life |
| @pgarcgo | spanish,cervantes,steem-guild |
| @inquiringtimes | steem,minnowsupport,life |
| @wingz | steem,money,steemit |
| @ned | steem,steemit,art |
| @steemrollin | steem,steemit,cryptocurrency |
| @good-karma | steem,steemit,esteem |
| @furion | steem,steemit,money |
| @roelandp | steem,steemit,steemfest |
| @heimindanger | steem,steemit,whales |
| @demotruk | steem,steemit,youtube |
| @lukestokes | steem,trading,steemit |
| @philmesnier | steemfest,eos,blockchain |
| @sompitonov | steemit,art,origami |
| @bitrocker2020 | steemit,art,teammalaysia |
| @simonjay | steemit,blockchain,crypto-news |
| @connecteconomy | steemit,cryptocurrency,bitcoin |
| @fatpandadesign | steemit,cryptocurrency,msp |
| @abh12345 | steemit,life,music |
| @blueorgy | steemit,life,photography |
| @lrock | steemit,photography,berlin |
| @vi1son | steemit,photography,steemitphotochallenge |
| @t3ran13 | steemit,rating,blog |
| @vandeberg | steemit,rickandmorty,steem |
| @burnin | steemit,scifi,fiction |
| @jerrybanfield | steemit,steem,life |
| @grumlin | steemit,steem,money |
| @noisy | steemit,steem,polish |
| @theprophet0 | steemit,steem,witness-category |
| @timcliff | steemit,steem,witness-category |
| @steevc | steemit,tsudoscience,music |
| @andrarchy | steemit,video,steem |
| @sneak | steemit,videos,life |
| @dan-atstarlite | steemit,vlog,steem |
| @pnc | steem-quebec,blockchain,fr |
| @teodora | steepshot,life,photography |
| @vcelier | story,life,bd |
| @michelle.gent | story,writing,fiction |
| @ezzy | story,writing,life |
| @tobydaniel2 | surfing,travel,photography |
| @alexlinebrink | technology,cryptocurrency,blockchain |
| @joythewanderer | travel,cn,photography |
| @martibis | travel,poetry,steemit |
| @arunaelentari | travel,spain,art |
| @anomadsoul | travel,spanish,cervantes |
| @lafona | video,steemit,story |
| @heiditravels | video,travel,cryptocurrency |
| @wolfcat | wolfcat,travel,wildatlanticway |
| @theowlhours | writing,fiction,creativity |
| @artist1989 | writing,story,fiction |
Ordering the table by each users most popular tag roughly groups users together. It's quite easy to spot the Artists, and Photographers for example.
Pressing 'Ctrl' + F when using a PC, should bring up the 'Find' box. Entering 'Art', for example, here should allow quick searching of users who have 'Art' as a second or third most popular tag.
The 10 most popular tags used by Steemfest attendees
Our attendess have used over 10000 different tags in the creation of their blogs, but which tags are the most popular?
The next table displays the 10 tags that are used the most by the vistors to Lisbon this year.
| Tag | Count |
|---|---|
| life | 8419 |
| photography | 5670 |
| steemit | 5521 |
| art | 4472 |
| blog | 3420 |
| story | 2966 |
| travel | 2815 |
| food | 2698 |
| steem | 2449 |
| writing | 2278 |
| others | 84719 |
Life is leading the way (as it should?!), being the most popular tag for 29 attendees and represents 7% of the total tags used.
These top 10 tags represent 32% of all the tags used.
Two tags I wouldn't have guessed to appear in the top 10 are 'story' and 'writing'. @vcelier, @michelle.gent, @ezzy have their top tag as 'story', and @theowlhours and @artist1989 have used 'writing' more than any other tag.
Unique top tags used by Steemfest attendees
Are there any niche bloggers attending Steemfest with a particular interest at heart? Lets see what the data says...
In this list are attendees that have a unique most used tag.
| Tag | Count |
|---|---|
| @sterlinluxan | anarchism |
| @chris4210 | beyondbitcoin |
| @robrigo | bitshares |
| @wmougayar | blockchains |
| @anasya | crazychallenge |
| @spurious-claims | education |
| @ivargereiko | fitness |
| @alanfreestone | health |
| @varunpinto | india |
| @karensuestudios | love |
| @massivevibration | massivevibrations |
| @tomasgeorge | music |
| @elear | opensource |
| @shak | pevo |
| @lenka | polish |
| @logic | science |
| @brian-rhodes | screenwriting |
| @val | spam |
| @tobydaniel2 | surfing |
| @alexlinebrink | technology |
| @wolfcat | wolfcat |
This information could be said to highlight a user with a particular blogging interest.
If you are keen to learn more about 'opensource', @elear looks to be your man. @robrigo seems to be the go-to for more information on 'bitshares', and if you need a bit more 'spam' in your life, speak to @val :)
The Steemfest attendees list
The base data and inspiration for the information above came from the idea to create a list of all the users heading to Portugal this year. I posted this list in a blog last week, and have continued to update it following comments, @roelandp's blog, and a check in @steemfest's wallet.
I'm hoping we have most attendees now on the list below, but if you are not present then please let me know.
I'll continue to update it as and when I receive new information, and this will be the last blog I write containing the list (I promise!).
Thanks to everyone for your support with this!
| User | Brief | 1 | 2 |
|---|---|---|---|
| @aaronkoenig | Entrepreneur, consultant, writer and film producer organising Bitfilm contest | - | - |
| @abh12345 | IT consultant, UK Expat, steemian | - | - |
| @acromott | - | - | - |
| @alanfreestone | Homeopath, crypto-enthusiast, interested in launching an ICO/token sale | - | - |
| @alexlinebrink | CEO of PassageX. Serial Entrepreneur. Crypto-Trader. Drone Builder | - | - |
| @allasyummyfood | Youtuber, chef and steemian | - | - |
| @ana.telepova | Flacoin Co-founder | - | - |
| @anasya | Flacoin Co-founder | - | - |
| @andrarchy | Steemit Team Member | - | - |
| @andrewmcmillen | - | - | - |
| @annaarthur | - | - | - |
| @anomadsoul | Nomad. Writer. Dreamer | 1 | - |
| @artist1989 | Artist/author | 1 | - |
| @arunaelentari | - | - | - |
| @ashleypeat | - | - | - |
| @ballinconscious | Hypnotist, Therapist, and Musician | - | - |
| @bitrocker2020 | - | - | - |
| @bkdbkd | - | - | - |
| @blueorgy | - | - | - |
| @brian-rhodes | - | - | - |
| @burnin | - | - | - |
| @charlieshrem | - | - | - |
| @chris4210 | Co-founder Bitshares Munich | - | - |
| @comealong | - | - | - |
| @connecteconomy | Cryptocurrency mentor for conscious women entrepreneurs & and an online biz management consultant focused on customer happiness | - | - |
| @cryptofunk | - | - | - |
| @dan-atstarlite | Vlogger, Founder of Steemit Health - Half of The @SteemBirds | - | - |
| @dayleeo | Digital Freelancer, Voice Over, & Media Maker | 1 | - |
| @demotruk | Developer, investor, stakeholder. | - | - |
| @detlev | CEO, Speaker, Consultant, Author, Traveller, BBQ and (TAG)BeerSaturday creator | - | - |
| @dollarvigilante | - | - | - |
| @dougkarr | Writer. Director. Crypto Enthusiast | - | - |
| @edb | - | - | - |
| @ekitcho | - | - | - |
| @elear | Software Developer/Architect. Tech geek | - | - |
| @ericvancewalton | Author. Traveler. Crypto Enthusiast | - | - |
| @e-saber | Mathematician, Chaos Theorist | - | - |
| @everlove | Artist of life, Steemit Collaborative Art Journey | - | - |
| @eveuncovered | - | - | - |
| @exyle | - | - | - |
| @ezzy | - | - | - |
| @fatpandadesign | - | - | - |
| @felixxx | - | - | - |
| @fukako | - | - | - |
| @furion | - | - | - |
| @future24 | - | - | - |
| @gargon | - | - | - |
| @getonthetrain | Personal finance blogger and Author | - | - |
| @ginacarr | Tribe Builder, Health Activist, Vegan Enthusiast | - | - |
| @gmuxx | Writer, 3D artist and moderator at The Writers' Block | - | - |
| @good-karma | - | - | - |
| @gringalicious | Food blogger / photographer, US citizen who just returned to the states from living in Patagonia Chile for 4 years | 1 | - |
| @grumlin | - | - | - |
| @hansikhouse | Cultural Development Strategist, Co-Founder of Sndbox | - | - |
| @heiditravels | - | - | - |
| @heimindanger | - | - | - |
| @hkjn | - | - | - |
| @inquiringtimes | - | 1 | - |
| @ivargereiko | - | - | - |
| @jaybird | Music/Creative, Founder of The Steemit Sandwich Contest & Half of the @steemBirds | - | - |
| @jeff7 | CFO Steemit | - | - |
| @jeffjagoe | Crypto-Evangelist with a passion for Nature, Food, Technology & Freedom | 1 | - |
| @jerrybanfield | Youtuber, educator, witness, comedian | - | - |
| @jexblackmore | Interdisciplinary artist and activist. Spokesperson for The Satanic Temple | - | - |
| @joythewanderer | multilingual travel blogger, anarchist | - | - |
| @juanmiguelsalas | Video editor and graphic designer from Cuba living in Germany. Education project on Blockchain, uses and advantages for Latin American countries | - | - |
| @karensuestudios | Acroyogi teaching acroyoga at Steemfest, artist, youtuber, published author | - | 2 |
| @kinakomochi | - | - | - |
| @knozaki2015 | - | - | - |
| @lafona | - | - | - |
| @lenadr | Artist, writer, animal fanatic, mayhem creator | - | - |
| @lenka | - | - | - |
| @lex030 | - | - | - |
| @liliana.duarte | - | - | - |
| @logic | - | - | - |
| @lrock | - | - | - |
| @ludorum | - | - | - |
| @lukestokes | Father, husband, business owner, programmer, voluntaryist | 1 | - |
| @maa | - | - | - |
| @mammasitta | - | - | - |
| @martibis | - | - | - |
| @massivevibration | - | - | - |
| @michelle.gent | - | - | - |
| @mrs.steemit | Co-founder Appics | - | - |
| @mysteem | - | - | - |
| @ned | - | - | - |
| @noboxes | Husband, father of 7, crazy life liver, cryto enthusiast, recently returned to the states from living in Patagonia for 4 years and last but not least, Dad of @gringalicious | 1 | - |
| @noisy | - | - | - |
| @nomadnessie | - | - | - |
| @opheliafu | Artist and visual storyteller | - | - |
| @oroger | - | - | - |
| @oscarcc89 | Artist, Computer Technician, Digital Designer. | - | - |
| @osm0sis | - | - | - |
| @paolobeneforti | Artist, Art-At-Steemfest event | 1 | - |
| @peterpanski | - | - | - |
| @pgarcgo | - | - | - |
| @philmesnier | Partner and Blockchain Practice Lead, Object Computing, Inc | - | - |
| @pjo | - | - | - |
| @pnc | - | - | - |
| @pollux.one | - | - | - |
| @prc | - | - | - |
| @quinneaker | Visionary & Founder of the Garden Of Eden EcoVillage | - | - |
| @ramengirl | - | - | - |
| @rea | - | - | - |
| @redpalestino | - | - | - |
| @robrigo | - | - | - |
| @roelandp | Kitesurfer, (mobile app) developer, dad, witness, @steemfest organiser | - | - |
| @roxane | - | - | - |
| @roychoi | - | - | - |
| @s0u1 | - | - | - |
| @saramiller | Yogini, Dakini, & Reiki Master | - | - |
| @sature | - | - | - |
| @serejandmyself | CEO Golos Fund | - | - |
| @shak | PEvO Project Manager | - | - |
| @shogo | Description: University Student(Japan) | - | - |
| @shortcut | Artist, video-editor and web-designer from Germany. Into photography, music and poetry | 1 | - |
| @silviabeneforti | Artist, Art-At-Steemfest event | 1 | - |
| @simonjay | - | - | - |
| @sneak | - | - | - |
| @soldier | - | - | - |
| @sompitonov | - | - | - |
| @spurious-claims | - | - | - |
| @starkerz | Responsible Steem Holder (TAG)promo-steem, (TAG)promo-uk | - | - |
| @steemrollin | Founder BitCash & Peerhub | - | - |
| @steevc | - | - | - |
| @sterlinluxan | Communications Ambassador for Bitcoin.com | - | - |
| @successtrainer | - | - | - |
| @surfermarly | Computer Scientist, surfergirl and steemian | - | 2 |
| @t3ran13 | - | - | - |
| @Tarquinmaine | Curios Nomad Writer Filmmaker | - | 2 |
| @teamhumble | - | 1 | - |
| @teodora | "Nature Warrior, Magic Builder, IOT lover, Meditate- or, Startup Curious and Wannabe Crypto Entrepreneur | - | - |
| @terrybrock | Speaker, Columnist, MC For SteemFest, Steemit Lover | - | - |
| @the-alien | (Ghost)Writer, entrepreneur, world traveler, blockchain and open-source enthusiast | - | - |
| @theowlhours | - | - | - |
| @theprophet0 | SteemSports General Manager, witness in DPoS | - | - |
| @timcliff | Steem witness | - | - |
| @timsaid | Crypto Challenge, scientist, photographer and free | - | - |
| @tobydaniel2 | - | - | - |
| @tomasgeorge | - | - | - |
| @twinner | - | - | - |
| @val | - | - | - |
| @vandeberg | Steemit Blockchain Developer | - | - |
| @varunpinto | - | - | 2 |
| @vcelier | Retired Navy officer, software engineer | - | - |
| @vi1son | - | - | - |
| @voronoi | Curious urbanist. Co-Founder of Sndbox | - | - |
| @walterjay | - | - | - |
| @wandereronwheels | - | - | - |
| @wingz | - | - | - |
| @wmougayar | - | - | - |
| @wolfcat | - | - | - |
| @xanoxt | Rudex.org, Modern Nomad and crypto enthusiast | - | - |
| @xroni | - | - | - |
| @yoganarchista | - | - | - |
| Martin Smolka | https://decent.ch/ Decent chain, ice hockey lover and dog owner | - | - |
Attending and not on the list? Sorry! Let me know!
I hope you have found the data --> information in today's blog useful. The process took me much longer than I initially expected, both to write and execute the queries involved. One query took over 5 hours to complete- Linked server connections with string manipulation do not seem to be the quickest, although my SQL scripting could also be at fault! If there are users reading this who are interested in the SQL scripts use to extract and organise this data from SteemSQL, let me know by commenting below.
If anyone has ideas on the data they might wish to see regarding Steemfest, the attendees, or anything else in the SteemSQL DB that could be of use, please comment below. Finally, thank you very much for supporting my blogs and I shall be seeing at least 155 of you in less than a weeks time! Safe travels all, and have a great day! In other news... It would be great to hear about what Steemfest attendees (and everyone else of course) think about @ned's recent decision to take back 3 million delegated Steem Power from 6 (of the 7) users he distributed it to on the 8th August.
Asher
I'd love to have the chance to ask him about this at Steemfest!