Last active
August 29, 2015 14:13
-
-
Save jonasrosland/8845db40571a588fdab5 to your computer and use it in GitHub Desktop.
Game Music Bundles
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
= 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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment