Skip to content

Instantly share code, notes, and snippets.

@peterneubauer
Forked from nawroth/GraphGist-intro.adoc
Last active December 19, 2015 19:49
Show Gist options
  • Save peterneubauer/6009066 to your computer and use it in GitHub Desktop.
Save peterneubauer/6009066 to your computer and use it in GitHub Desktop.

The Neo4j T-Graph

This is the full account of all Neo4j-T-Shirts given by different members of the community. Wanna join? Contact one of them! They look something like this (Courtesy René Pickhardt):

streamshirt
Important
Wait a while for the data to load, it’s still a bit slow, hosted on a weak instance on Heroku.

The setup data

Below is the cypher-export of the T-Shirt data from a Google Spreadsheet where we keep track of all the order that have been going out. This data is not yet complete as some of the names are not properly filled in, giving no tgraph-property on the respective node.

//the graphistas
CREATE (peter{tgraph:'peter'})
CREATE (mesirii{tgraph:'mesirii'})
CREATE (maxdemarzi{tgraph:'maxdemarzi'})
CREATE (technige{tgraph:'technige'})
CREATE (mhluongo{tgraph:'mhluongo'})
CREATE (james{tgraph:'james'})
CREATE (craigtaverner{tgraph:'craigtaverner'})
CREATE (ronge{tgraph:'ronge'})
CREATE (renepickhardt{tgraph:'renepickhardt'})
CREATE (ahzf{tgraph:'ahzf'})
CREATE (amorgner{tgraph:'amorgner'})
CREATE (adriano{tgraph:'adriano'})
CREATE (aleksa{tgraph:'aleksa'})
CREATE (tatham{tgraph:'tatham'})
CREATE (geoaxis{tgraph:'geoaxis'})
CREATE (nikhil{tgraph:'nikhil'})
CREATE (luannem{tgraph:'luannem'})
CREATE (yuri{tgraph:'yuri'})
CREATE (emil{tgraph:'emil'})
CREATE (johan{tgraph:'johan'})
CREATE (jakewins{tgraph:'jakewins'})
CREATE (jim{tgraph:'jim'})
CREATE (philip{tgraph:'philip'})
CREATE (lars{tgraph:'lars'})
CREATE (dirk{tgraph:'dirk'})
CREATE (rvanbruggen{tgraph:'rvanbruggen'})
CREATE (cedric{tgraph:'cedric'})
CREATE (richard{tgraph:'richard'})
CREATE (johnny{tgraph:'johnny'})
CREATE (isobel{tgraph:'isobel'})
CREATE (_jamesward{tgraph:'_jamesward'})
CREATE (sarad{tgraph:'sarad'})
CREATE (mattt{tgraph:'mattt'})
CREATE (courtney{tgraph:'courtney'})
CREATE (therubymug{tgraph:'therubymug'})
CREATE (graham{tgraph:'graham'})
CREATE (meghan{tgraph:'meghan'})
CREATE (guillaume{tgraph:'guillaume'})
CREATE (duanechaos{tgraph:'duanechaos'})
CREATE (nuggetwheat{tgraph:'nuggetwheat'})
CREATE (tavisrudd{tgraph:'tavisrudd'})
CREATE (ikwattro{tgraph:'ikwattro'})
CREATE (anders{tgraph:'anders'})
CREATE (kooyeed{tgraph:'kooyeed'})
CREATE (nemanjavuk{tgraph:'nemanjavuk'})
CREATE (philb{tgraph:'philb'})
CREATE (flipping_bits{tgraph:'flipping_bits'})
CREATE (tiberg{tgraph:'tiberg'})
CREATE (nambrot{tgraph:'nambrot'})
CREATE (ossalanr{tgraph:'ossalanr'})
CREATE (systay{tgraph:'systay'})
CREATE (tobias{tgraph:'tobias'})
CREATE (bjorn{tgraph:'bjorn'})
CREATE (abk{tgraph:'abk'})
CREATE (adam{tgraph:'adam'})
CREATE (charlie{tgraph:'charlie'})
CREATE (ian{tgraph:'ian'})
CREATE (ayeeson{tgraph:'ayeeson'})
CREATE (rose{tgraph:'rose'})
CREATE (digitalstain{tgraph:'digitalstain'})
CREATE (alistair{tgraph:'alistair'})
CREATE (builddoctor{tgraph:'builddoctor'})
CREATE (rickardoberg{tgraph:'rickardoberg'})
CREATE (dmontag{tgraph:'dmontag'})
CREATE (chrisl{tgraph:'chrisl'})
CREATE (noomi{tgraph:'noomi'})
CREATE (madde{tgraph:'madde'})
CREATE (tuan{tgraph:'tuan'})
CREATE (wes{tgraph:'wes'})
CREATE (werner{tgraph:'werner'})
CREATE (aidan{tgraph:'aidan'})
CREATE (andrew{tgraph:'andrew'})
CREATE (safwandoterl{tgraph:'safwandoterl'})
CREATE (versae{tgraph:'versae'})
CREATE (scalabl3{tgraph:'scalabl3'})
CREATE (kouphax{tgraph:'kouphax'})
CREATE (oskar{tgraph:'oskar'})
CREATE (kalle{tgraph:'kalle'})
CREATE (matt_m{tgraph:'matt_m'})
CREATE (kerryjj{tgraph:'kerryjj'})
CREATE (howzat{tgraph:'howzat'})
CREATE (mike{tgraph:'mike'})
CREATE (ed{tgraph:'ed'})
CREATE (kris{tgraph:'kris'})
CREATE (fzk{tgraph:'fzk'})
CREATE (rdvdijk{tgraph:'rdvdijk'})
CREATE (m_smalley{tgraph:'m_smalley'})
CREATE (gazdovsky{tgraph:'gazdovsky'})
CREATE (wstarcev{tgraph:'wstarcev'})
CREATE (shabanovd{tgraph:'shabanovd'})
CREATE (mentatseb{tgraph:'mentatseb'})
CREATE (linkurious{tgraph:'linkurious'})
CREATE (purbon{tgraph:'purbon'})
CREATE (tom{tgraph:'tom'})
CREATE (iklaus{tgraph:'iklaus'})
CREATE (ralf{tgraph:'ralf'})
CREATE (tobi{tgraph:'tobi'})
CREATE (niclas{tgraph:'niclas'})
CREATE (cmo_{tgraph:'cmo_'})
CREATE (pramodsadalage{tgraph:'pramodsadalage'})
CREATE (EKozhanov{tgraph:'EKozhanov'})
CREATE (anjeve{tgraph:'anjeve'})
CREATE (ianml{tgraph:'ianml'})
CREATE (tonit{tgraph:'tonit'})
CREATE (tstorms{tgraph:'tstorms'})
CREATE (vpacher{tgraph:'vpacher'})
CREATE (ekozhanov{tgraph:'ekozhanov'})
CREATE emil-[:father]->me<-[:mother]-madde
//the connections

CREATE (emil)-[:father{quote:'newly connected'}]->(noomi)<-[:mother]-(madde)
CREATE (johan)-[:`_`{quote:'I designed Neo4j'}]->(peter)

Let’s find the most connected graphistas

MATCH graphista--other
RETURN graphista.tgraph AS name, COUNT(other) AS friends, ID(graphista) AS id
ORDER BY friends DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment