Game Music Bundles

gistfile1.txt

= Game Music Bundle by Bundledragon and Loudr =

This graph is to see how game musicians correlate to each other within the same genre of music.

image::https://artwork.loudr.fm/artists/8mNvr/game-music-bundle.png.250.jpg[]

//hide
//setup
//graph

[source,cypher]
----
//Bundles
CREATE (gmb1{name:'GMB 1'})
CREATE (gmb2{name:'GMB 2'})
CREATE (gmb3{name:'GMB 3'})
CREATE (gmb4{name:'GMB 4'})
CREATE (gmb5{name:'GMB 5'})
CREATE (gmb6{name:'GMB 6'})
CREATE (gmb7{name:'GMB 7'})
CREATE (gmb8{name:'GMB 8'})
CREATE (retrogmb{name:'Retro GMB'})
CREATE (bittrip{name:'BIT.TRIP Lovers Bundle'})
CREATE (igmb{name:'iGMB'})




//Musicians
//gmb5
CREATE (va{name:'Various Artists'})
CREATE (austinwintory{name:'Austin Wintory'})
CREATE (benprunty{name:'Ben Prunty'})
CREATE (disasterpeace{name:'Disasterpeace'})
CREATE (johnrobertmatz{name:'John Robert Matz'})
CREATE (ryanike{name:'Ryan Ike'})
CREATE (franciscocerda{name:'Francisco Cerda'})
CREATE (kylegabler{name:'Kyle Gabler'})
CREATE (malukah{name:'Malukah'})
CREATE (tinaguo{name:'Tina Guo'})
CREATE (tricksterarts{name:'Trickster Arts'})
CREATE (calumbowen{name:'Calum Bowen'})
CREATE (jamesdean{name:'James Dean'})
CREATE (seagaia{name:'Seagaia'})
CREATE (davidsaulesco{name:'David Saulesco'})
CREATE (soldakentertainment{name:'Soldak Entertainment'})
CREATE (torikamal{name:'Tori Kamal'})

//gmb2
CREATE (alecholowka{name:'Alec Holowka'})
CREATE (jimguthrie{name:'Jim Guthrie'})
CREATE (kanrgao{name:'Kan R Gao'})
CREATE (laurashigihara{name:'Laura Shigihara'})
CREATE (tomasdvorak{name:'Tomas Dvorak'})
CREATE (module{name:'Module'})
CREATE (arival{name:'A_Rival'})
CREATE (jakekaufman{name:'Jake \'virt\' Kaufman'})
CREATE (flashygoodness{name:'Flashygoodness'})
CREATE (romaingauthier{name:'Romain Gauthier'})
CREATE (theoctopusproject{name:'The Octopus Project'})
CREATE (cjeff{name:'C-jeff'})
CREATE (inversephase{name:'Inverse Phase'})

//gmb3
CREATE (scottlloydshelly{name:'Scott Lloyd Shelly'})
CREATE (lifeformed{name:'Lifeformed'})
CREATE (danielolsen{name:'Daniel Olsen'})
CREATE (paultaylor{name:'Paul Taylore'})
CREATE (joakimsandberg{name:'Joakim Sandberg'})
CREATE (whitakerblackall{name:'Whitaker Blackall'})
CREATE (garethcoker{name:'Gareth Coker'})
CREATE (ensnare{name:'_ensnare_'})
CREATE (protodome{name:'Protodome'})
CREATE (georgeandjonathan{name:'George & Jonathan'})
CREATE (joshwhelchel{name:'Josh Whelchel'})
CREATE (jeffball{name:'Jeff Ball'})
CREATE (hyperducksoundworks{name:'Hyperduck Soundworks'})
CREATE (zircon{name:'Zircon'})


//Albums
//gmb2
CREATE (aquaria{name:'Aquaria'})
CREATE (swordandsorcery{name:'Sword & Sorcery - Ballad of the Space Babies'})
CREATE (tothemoon{name:'To The Moon'})
CREATE (jamestown{name:'Jamestown'})
CREATE (machinarium{name:'Machinarium'})
CREATE (shatter{name:'Shatter'})
CREATE (eightbitpimpchiphopep{name:'8-bit Pimp - Chip-Hop EP'})
CREATE (mightyswitchforce{name:'Mighty Switch Force'})
CREATE (catastrophi{name:'Cat Astro Phi'})
CREATE (passcodesouldofthetraveler{name:'Passcode - Soul of the Traveler'})
CREATE (machinariumbonusep{name:'Machinarium - Bonus EP'})
CREATE (towerofheaven{name:'Tower of Heaven'})
CREATE (eternaldaughter{name:'Eternal Daughter'})
CREATE (songsforthecure2010{name:'Songs for the Cure - Edition 2010'})
CREATE (squids{name:'Squids'})
CREATE (thunderbeam{name:'Thunderbeam'})
CREATE (preschtale{name:'Preschtale'})
CREATE (shuttlescuttle{name:'Shuttle Scuttle'})
CREATE (indiemashupepsharingiscaring{name:'Indie Mashup EP - Sharing is Caring'})

//gmb3
CREATE (terraria{name:'Terraria'})
CREATE (plantsvszombies{name:'Plants vs Zombies'})
CREATE (fastfalldustforce{name:'Fastfall - Dustforce OST'})
CREATE (ilomilo{name:'Ilomilo'})
CREATE (frozensynapse{name:'Frozen Synapse'})
CREATE (offspringfling{name:'Offspring Fling'})
CREATE (mublaevolution{name:'Mubla Evol Ution - Noitulove1&2+More'})
CREATE (cardinalquest{name:'Cardinal Quest'})
CREATE (inmomentum{name:'inMomentum'})
CREATE (impeccablemicro{name:'Impeccable Micro'})
CREATE (bluescreenchiptunejazz{name:'Bluescreen - Chiptune / Jazz'})
CREATE (beautifullifestyle{name:'Beautiful Lifestyle'})
CREATE (riseoftheobsidianinterstellar{name:'Rise of the Obsidian Interstellar'})
CREATE (deorbit{name:'Deorbit'})
CREATE (gungirl2{name:'Gungirl 2'})
CREATE (astroman{name:'Astroman'})
CREATE (theblockscometh{name:'The Blocks Cometh'})
CREATE (fittest{name:'Fittest'})
CREATE (songsforthecure2011{name:'Songs for the Cure \'11: Remedy+'})


//gmb5
CREATE (monacowhatsyourismine{name:'Monaco: What\'s Yours is Mine'})
CREATE (ftl{name:'FTL: Faster Than Light'})
CREATE (fez{name:'Fez'})
CREATE (gunpoint{name:'Gunpoint'})
CREATE (leisuresuitlarryreloaded{name:'Leisure Suit Larry: Reloaded'})
CREATE (worldofgoo{name:'World of Goo'})
CREATE (fzsidez{name:'FZ: Side Z'})
CREATE (fzsidef{name:'FZ: Side F'})
CREATE (monacothegentlemansprivatecollection{name:'Monaco: The Gentleman\'s Private Collection'})
CREATE (theforge{name:'The Forge'})
CREATE (heroofmany{name:'Hero of Many'})
CREATE (marbletime{name:'Marble Time'})
CREATE (superpandaadventures{name:'Super Panda Adventures'})
CREATE (anodyneremixalbum{name:'Anodyne Remix Album'})
CREATE (anodyne{name:'Anodyne'})
CREATE (frogfractions{name:'Frog Fractions'})
CREATE (littleinferno{name:'Little Inferno'})
CREATE (meandmydinosaur2{name:'Me and My Dinosaur 2'})
CREATE (droxoperative{name:'Drox Operative'})

//Created by
//gmb3
CREATE (terraria)-[:CREATED_BY]->(scottlloydshelly)
CREATE (plantsvszombies)-[:CREATED_BY]->(laurashigihara)
CREATE (fastfalldustforce)-[:CREATED_BY]->(lifeformed)
CREATE (ilomilo)-[:CREATED_BY]->(danielolsen)
CREATE (frozensynapse)-[:CREATED_BY]->(paultaylor)
CREATE (offspringfling)-[:CREATED_BY]->(alecholowka)
CREATE (mublaevolution)-[:CREATED_BY]->(joakimsandberg)
CREATE (cardinalquest)-[:CREATED_BY]->(whitakerblackall)
CREATE (inmomentum)-[:CREATED_BY]->(garethcoker)
CREATE (impeccablemicro)-[:CREATED_BY]->(ensnare)
CREATE (bluescreenchiptunejazz)-[:CREATED_BY]->(protodome)
CREATE (beautifullifestyle)-[:CREATED_BY]->(georgeandjonathan)
CREATE (riseoftheobsidianinterstellar)-[:CREATED_BY]->(disasterpeace)
CREATE (deorbit)-[:CREATED_BY]->(disasterpeace)
CREATE (gungirl2)-[:CREATED_BY]->(joshwhelchel)
CREATE (astroman)-[:CREATED_BY]->(jeffball)
CREATE (theblockscometh)-[:CREATED_BY]->(hyperducksoundworks)
CREATE (fittest)-[:CREATED_BY]->(zircon)
CREATE (songsforthecure2011)-[:CREATED_BY]->(va)

//gmb5
CREATE (monacowhatsyourismine)-[:CREATED_BY]->(austinwintory)
CREATE (ftl)-[:CREATED_BY]->(benprunty)
CREATE (fez)-[:CREATED_BY]->(disasterpeace)
CREATE (gunpoint)-[:CREATED_BY]->(johnrobertmatz)
CREATE (gunpoint)-[:CREATED_BY]->(ryanike)
CREATE (gunpoint)-[:CREATED_BY]->(franciscocerda)
CREATE (leisuresuitlarryreloaded)-[:CREATED_BY]->(austinwintory)
CREATE (worldofgoo)-[:CREATED_BY]->(kylegabler)
CREATE (fzsidef)-[:CREATED_BY]->(va)
CREATE (fzsidez)-[:CREATED_BY]->(va)
CREATE (monacothegentlemansprivatecollection)-[:CREATED_BY]->(va)
CREATE (theforge)-[:CREATED_BY]->(austinwintory)
CREATE (theforge)-[:CREATED_BY]->(malukah)
CREATE (theforge)-[:CREATED_BY]->(tinaguo)
CREATE (heroofmany)-[:CREATED_BY]->(tricksterarts)
CREATE (marbletime)-[:CREATED_BY]->(calumbowen)
CREATE (superpandaadventures)-[:CREATED_BY]->(jamesdean)
CREATE (anodyneremixalbum)-[:CREATED_BY]->(va)
CREATE (anodyne)-[:CREATED_BY]->(seagaia)
CREATE (frogfractions)-[:CREATED_BY]->(va)
CREATE (littleinferno)-[:CREATED_BY]->(kylegabler)
CREATE (meandmydinosaur2)-[:CREATED_BY]->(davidsaulesco)
CREATE (droxoperative)-[:CREATED_BY]->(soldakentertainment)
CREATE (droxoperative)-[:CREATED_BY]->(torikamal)
//gmb2
CREATE (aquaria)-[:CREATED_BY]->(alecholowka)
CREATE (swordandsorcery)-[:CREATED_BY]->(jimguthrie)
CREATE (tothemoon)-[:CREATED_BY]->(kanrgao)
CREATE (tothemoon)-[:CREATED_BY]->(laurashigihara)
CREATE (jamestown)-[:CREATED_BY]->(franciscocerda)
CREATE (machinarium)-[:CREATED_BY]->(tomasdvorak)
CREATE (shatter)-[:CREATED_BY]->(module)
CREATE (eightbitpimpchiphopep)-[:CREATED_BY]->(arival)
CREATE (mightyswitchforce)-[:CREATED_BY]->(jakekaufman)
CREATE (catastrophi)-[:CREATED_BY]->(disasterpeace)
CREATE (passcodesouldofthetraveler)-[:CREATED_BY]->(disasterpeace)
CREATE (machinariumbonusep)-[:CREATED_BY]->(tomasdvorak)
CREATE (towerofheaven)-[:CREATED_BY]->(flashygoodness)
CREATE (eternaldaughter)-[:CREATED_BY]->(davidsaulesco)
CREATE (songsforthecure2010)-[:CREATED_BY]->(va)
CREATE (squids)-[:CREATED_BY]->(romaingauthier)
CREATE (thunderbeam)-[:CREATED_BY]->(theoctopusproject)
CREATE (preschtale)-[:CREATED_BY]->(cjeff)
CREATE (shuttlescuttle)-[:CREATED_BY]->(inversephase)
CREATE (indiemashupepsharingiscaring)-[:CREATED_BY]->(va)




//Bundle inclusions
//gmb2
CREATE (gmb2)<-[:IS_IN]-(aquaria)
CREATE (gmb2)<-[:IS_IN]-(swordandsorcery)
CREATE (gmb2)<-[:IS_IN]-(tothemoon)
CREATE (gmb2)<-[:IS_IN]-(jamestown)
CREATE (gmb2)<-[:IS_IN]-(machinarium)
CREATE (gmb2)<-[:IS_IN]-(shatter)
CREATE (gmb2)<-[:IS_IN]-(eightbitpimpchiphopep)
CREATE (gmb2)<-[:IS_IN]-(mightyswitchforce)
CREATE (gmb2)<-[:IS_IN]-(catastrophi)
CREATE (gmb2)<-[:IS_IN]-(passcodesouldofthetraveler)
CREATE (gmb2)<-[:IS_IN]-(fmachinariumbonuseptl)
CREATE (gmb2)<-[:IS_IN]-(towerofheaven)
CREATE (gmb2)<-[:IS_IN]-(eternaldaughter)
CREATE (gmb2)<-[:IS_IN]-(songsforthecure2010)
CREATE (gmb2)<-[:IS_IN]-(squids)
CREATE (gmb2)<-[:IS_IN]-(thunderbeam)
CREATE (gmb2)<-[:IS_IN]-(preschtale)
CREATE (gmb2)<-[:IS_IN]-(shuttlescuttle)
CREATE (gmb2)<-[:IS_IN]-(indiemashupepsharingiscaring)


CREATE (gmb3)<-[:IS_IN]-(terraria)
CREATE (gmb3)<-[:IS_IN]-(plantsvszombies)
CREATE (gmb3)<-[:IS_IN]-(fastfalldustforce)
CREATE (gmb3)<-[:IS_IN]-(ilomilo)
CREATE (gmb3)<-[:IS_IN]-(frozen)
CREATE (gmb3)<-[:IS_IN]-(offspringfling)
CREATE (gmb3)<-[:IS_IN]-(mublaevolution)
CREATE (gmb3)<-[:IS_IN]-(cardinalquest)
CREATE (gmb3)<-[:IS_IN]-(inmomentum)
CREATE (gmb3)<-[:IS_IN]-(impeccablemicro)
CREATE (gmb3)<-[:IS_IN]-(bluescreenchiptunejazz)
CREATE (gmb3)<-[:IS_IN]-(beautifullifestyle)
CREATE (gmb3)<-[:IS_IN]-(riseoftheobsidianinterstellar)
CREATE (gmb3)<-[:IS_IN]-(deorbit)
CREATE (gmb3)<-[:IS_IN]-(gungirl2)
CREATE (gmb3)<-[:IS_IN]-(astroman)
CREATE (gmb3)<-[:IS_IN]-(theblockscometh)
CREATE (gmb3)<-[:IS_IN]-(fittest)
CREATE (gmb3)<-[:IS_IN]-(songsforthecure2011)
CREATE (gmb3)<-[:IS_IN]-(songsforthecure2010)

//gmb5
CREATE (gmb5)<-[:IS_IN]-(monacowhatsyourismine)
CREATE (gmb5)<-[:IS_IN]-(ftl)
CREATE (gmb5)<-[:IS_IN]-(fez)
CREATE (gmb5)<-[:IS_IN]-(gunpoint)
CREATE (gmb5)<-[:IS_IN]-(leisuresuitlarryreloaded)
CREATE (gmb5)<-[:IS_IN]-(worldofgoo)
CREATE (gmb5)<-[:IS_IN]-(fzsidez)
CREATE (gmb5)<-[:IS_IN]-(fzsidef)
CREATE (gmb5)<-[:IS_IN]-(monacothegentlemansprivatecollection)
CREATE (gmb5)<-[:IS_IN]-(theforge)
CREATE (gmb5)<-[:IS_IN]-(heroofmany)
CREATE (gmb5)<-[:IS_IN]-(marbletime)
CREATE (gmb5)<-[:IS_IN]-(superpandaadventures)
CREATE (gmb5)<-[:IS_IN]-(anodyneremixalbum)
CREATE (gmb5)<-[:IS_IN]-(anodyne)
CREATE (gmb5)<-[:IS_IN]-(frogfractions)
CREATE (gmb5)<-[:IS_IN]-(littleinferno)
CREATE (gmb5)<-[:IS_IN]-(meandmydinosaur2)
CREATE (gmb5)<-[:IS_IN]-(droxoperative)


----

=== Which albums are in the bundle?
[source,cypher]
----
MATCH (bundle)<-[:IS_IN]-(album)
RETURN bundle.name AS Bundle, album.name AS Album
ORDER BY Bundle ASC

----
//table

=== Who created what?
[source,cypher]
----
MATCH (album)-[:CREATED_BY]->(creator)
RETURN creator.name AS Creator, album.name AS Album
ORDER BY Creator ASC
----
//table

=== Which albums have more than one creator?
[source,cypher]
----
MATCH (album)-[:CREATED_BY]->(creator)
WITH album, COLLECT(creator.name) AS creators
WHERE LENGTH(creators) > 1
RETURN album.name AS Album, creators As Creators;
----
//table

=== Which creators have more than one album?
[source,cypher]
----
MATCH (album)-[:CREATED_BY]->(creator)
WITH creator, COLLECT(album.name) AS albums
WHERE LENGTH(albums) > 1
RETURN creator.name AS Creator, albums As Albums;
----
//table