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
|