We're now loading your Tweets from the Twitter API as well as a mixture of other tweets which may be popular to Graph Database enthusiasts.
Note that the Twitter API has quotas which mean your Tweets have to be loaded over time, depending on how much Twitter activity you have.
Access your personal instance of Neo4j using the URL, username, and password above. We'll keep your instance around for a few days, but you can always come back and get a new instance.
Top Mentions of You |
MATCH (u:User)-[:POSTS]->(t:Tweet)-[:MENTIONS]->(m:User {screen_name:''}) WHERE u.screen_name <> '' RETURN u.screen_name AS screen_name, COUNT(u.screen_name) AS count ORDER BY count DESC LIMIT 10 |
Most Tagged by You |
MATCH (h:Hashtag)<-[:TAGS]-(t:Tweet)<-[:POSTS]-(u:User {screen_name:''}) WITH h, COUNT(h) AS Hashtags ORDER BY Hashtags DESC LIMIT 10 RETURN h.name, Hashtags |
Followback Rate |
MATCH (me:User {screen_name: ''})-[:FOLLOWS]->(f) WITH me, f, size((f)-[:FOLLOWS]->(me)) as doesFollowBack RETURN sum(doesFollowBack) / toFloat(count(f)) AS followBackRate |
Users tweeting about You, but you Don't Follow |
MATCH (ou:User)-[:POSTS]->(t:Tweet)-[mt:MENTIONS]->(me:User {screen_name: ''}) WITH DISTINCT ou, me WHERE (ou)-[:FOLLOWS]->(me) AND NOT (me)-[:FOLLOWS]->(ou) RETURN ou.screen_name LIMIT 20 |
Links from Interesting Retweets |
MATCH (:User {screen_name: ''})-[:POSTS]-> (t:Tweet)-[:RETWEETS]->(rt)-[:CONTAINS]->(link:Link) RETURN t.id_str AS tweet, link.url AS url, rt.favorites AS favorites ORDER BY favorites DESC LIMIT 10 |
Users tweeting with common tags as you |
MATCH (me:User {screen_name:''})-[:POSTS]->(tweet:Tweet)-[:TAGS]->(ht) OPTIONAL MATCH (tweet)<-[:RETWEETS]-(retweet) WITH me,ht, collect(distinct retweet) as retweets MATCH (ht)<-[:TAGS]-(tweet2:Tweet)<-[:POSTS]-(sugg:User) WHERE sugg <> me and NOT(tweet2 IN retweets) WITH sugg, count(distinct(ht)) as common RETURN sugg.screen_name as friend, common ORDER BY common DESC LIMIT 20 |