-
-
Save brijrajsingh/501016605b28dab3431d to your computer and use it in GitHub Desktop.
The example graph consists of characters in Game of Thrones (GOT) - Graph created by Brijraj Singh
This file contains hidden or 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
= Mahabharata = | |
The example graph consists of characters in Game of Thrones (GOT) | |
Key nodes - Relations, Characters, their houses, status of (Dead, Captured or Hurt), Properties like Title and Prefix | |
The Data is pulled from multiple websites - http://towerofthehand.com, http://gameofthrones.wikia.com/wiki/Game_of_Thrones_Wiki | |
//console | |
[source,cypher] | |
---- | |
CREATE (Addam_Marbrand:Person {name : 'Addam Marbrand', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Adrack_Humble:Person {name : 'Adrack Humble', House : 'Greyjoy', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Aegon_Frey_Jinglebell:Person {name : 'Aegon Frey Jinglebell', House : 'Frey North', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Aegon_I_Targaryen:Person {name : 'Aegon I Targaryen', House : 'Targaryen', isDead : 1, isCaptured : 0, isHurt : 0, Title : 'King of the Seven Kingdoms', Prefix : 'King '}) | |
CREATE (Aegon_Targaryen:Person {name : 'Aegon Targaryen', House : 'Targaryen', isDead : 1, isCaptured : 0, isHurt : 0, Title : 'prince', Prefix : 'Prince '}) | |
CREATE (Aemon_Targaryen:Person {name : 'Aemon Targaryen', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'maester', Prefix : 'Maester '}) | |
CREATE (Aeron_Greyjoy:Person {name : 'Aeron Greyjoy', House : 'Greyjoy', isDead : 1, isCaptured : 0, isHurt : 0, Title : 'priest of the Drowned God', Prefix : ''}) | |
CREATE (Aerys_II_Targaryen:Person {name : 'Aerys II Targaryen', House : 'Targaryen', isDead : 1, isCaptured : 0, isHurt : 0, Title : 'King of the Seven Kingdoms', Prefix : 'King '}) | |
CREATE (Alebelly:Person {name : 'Alebelly', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Alester_Florent:Person {name : 'Alester Florent', House : 'Stannis', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of Brightwater Keep', Prefix : 'Lord '}) | |
CREATE (Alfyn:Person {name : 'Alfyn', House : 'Wildlings north of wall', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Allar_Deem:Person {name : 'Allar Deem', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Amory_Lorch:Person {name : 'Amory Lorch', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Antario_Jast:Person {name : 'Antario Jast', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of House Jast', Prefix : 'Lord '}) | |
CREATE (Areo_Hotah:Person {name : 'Areo Hotah', House : 'Martell', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'captain', Prefix : 'Captain '}) | |
CREATE (Arianne_Martell:Person {name : 'Arianne Martell', House : 'Martell', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : 'Lady '}) | |
CREATE (Arnolf_Karstark:Person {name : 'Arnolf Karstark', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Aron_Santagar:Person {name : 'Aron Santagar', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Arthur_Dayne:Person {name : 'Arthur Dayne', House : 'Targaryen', isDead : 1, isCaptured : 0, isHurt : 0, Title : 'knight of the Kings guard', Prefix : 'Ser '}) | |
CREATE (Arya_Stark:Person {name : 'Arya Stark', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : 'Lady '}) | |
CREATE (Arys_Oakheart:Person {name : 'Arys Oakheart', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight of the Kings guard', Prefix : ''}) | |
CREATE (Asha_Greyjoy:Person {name : 'Asha Greyjoy', House : 'Greyjoy', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Aurane_Waters:Person {name : 'Aurane Waters', House : 'Stannis', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Axell_Florent:Person {name : 'Axell Florent', House : 'Stannis', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Balman_Byrch:Person {name : 'Balman Byrch', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Balon_Greyjoy:Person {name : 'Balon Greyjoy', House : 'Greyjoy', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Iron King', Prefix : 'King '}) | |
CREATE (Balon_Swann:Person {name : 'Balon Swann', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight of the Kings guard', Prefix : 'Ser '}) | |
CREATE (Barra:Person {name : 'Barra', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Barristan_Selmy:Person {name : 'Barristan Selmy', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight of the Kings guard', Prefix : 'Ser '}) | |
CREATE (Belwas:Person {name : 'Belwas', House : 'Targaryen', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Ben_Plumm:Person {name : 'Ben Plumm', House : 'Second Sons', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Benfred_Tallhart:Person {name : 'Benfred Tallhart', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Benjen_Stark:Person {name : 'Benjen Stark', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Beric_Dondarrion:Person {name : 'Beric Dondarrion', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of Blackhaven', Prefix : 'Lord '}) | |
CREATE (Biter:Person {name : 'Biter', House : 'none', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Boros_Blount:Person {name : 'Boros Blount', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight of the Kings guard', Prefix : 'Ser '}) | |
CREATE (Bowen_Marsh:Person {name : 'Bowen Marsh', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Bran_Stark:Person {name : 'Bran Stark', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Brandon_Stark:Person {name : 'Brandon Stark', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Brienne_of_Tarth:Person {name : 'Brienne of Tarth', House : 'Renly', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Lady '}) | |
CREATE (Bronn:Person {name : 'Bronn', House : 'none', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Brynden_Tully:Person {name : 'Brynden Tully', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Catelyn_Tully:Person {name : 'Catelyn Tully', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : 'Lady '}) | |
CREATE (Cersei_Lannister:Person {name : 'Cersei Lannister', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Queen of Westeros', Prefix : 'Queen '}) | |
CREATE (Chayle:Person {name : 'Chayle', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'septon', Prefix : 'Septon '}) | |
CREATE (Chett:Person {name : 'Chett', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Chiswyck:Person {name : 'Chiswyck', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Cleos_Frey:Person {name : 'Cleos Frey', House : 'Frey North', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Coldhands:Person {name : 'Coldhands', House : 'none', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Colemon:Person {name : 'Colemon', House : 'Citadel', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'maester', Prefix : 'Septon '}) | |
CREATE (Cortnay_Penrose:Person {name : 'Cortnay Penrose', House : 'Renly', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Cotter_Pyke:Person {name : 'Cotter Pyke', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Cragorn:Person {name : 'Cragorn', House : 'Greyjoy', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Craster:Person {name : 'Craster', House : 'Wildlings north of wall', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Cressen:Person {name : 'Cressen', House : 'Stannis', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'maester', Prefix : 'Maester '}) | |
CREATE (Daario_Naharis:Person {name : 'Daario Naharis', House : 'Stormcrows', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Dacey_Mormont:Person {name : 'Dacey Mormont', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Daenerys_Targaryen:Person {name : 'Daenerys Targaryen', House : 'Targaryen', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : 'Lady '}) | |
CREATE (Dagon_Codd:Person {name : 'Dagon Codd', House : 'Greyjoy', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Dalla:Person {name : 'Dalla', House : 'Wildlings north of wall', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Dareon:Person {name : 'Dareon', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Daryn_Hornwood:Person {name : 'Daryn Hornwood', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Davos_Seaworth:Person {name : 'Davos Seaworth', House : 'Stannis', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Dick_Crabb:Person {name : 'Dick Crabb', House : 'none', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Dirk:Person {name : 'Dirk', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Donal_Noye:Person {name : 'Donal Noye', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Donella_Manderly:Person {name : 'Donella Manderly', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : 'Lady '}) | |
CREATE (Dontos_Hollard:Person {name : 'Dontos Hollard', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Doran_Martell:Person {name : 'Doran Martell', House : 'Martell', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'prince', Prefix : 'Prince '}) | |
CREATE (Drogo:Person {name : 'Drogo', House : 'Drogo', isDead : 1, isCaptured : 0, isHurt : 0, Title : 'khal', Prefix : 'Khal '}) | |
CREATE (Dywen:Person {name : 'Dywen', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Ebben:Person {name : 'Ebben', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Eddard_Karstark:Person {name : 'Eddard Karstark', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Eddard_Stark:Person {name : 'Eddard Stark', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Warden of the North', Prefix : 'Lord '}) | |
CREATE (Eddison_Tollett:Person {name : 'Eddison Tollett', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Edmure_Tully:Person {name : 'Edmure Tully', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord Paramount of the Riverlands', Prefix : 'Lord '}) | |
CREATE (Edric_Storm:Person {name : 'Edric Storm', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Elia_Martell:Person {name : 'Elia Martell', House : 'Martell', isDead : 1, isCaptured : 0, isHurt : 0, Title : '', Prefix : 'Lady '}) | |
CREATE (Emmon_Cuy:Person {name : 'Emmon Cuy', House : 'Renly', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Emmon_Frey:Person {name : 'Emmon Frey', House : 'Frey North', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Eon_Hunter:Person {name : 'Eon Hunter', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Euron_Greyjoy:Person {name : 'Euron Greyjoy', House : 'Greyjoy', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Falyse_Stokeworth:Person {name : 'Falyse Stokeworth', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (First_High_Septon:Person {name : 'First High Septon', House : 'Faith', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'high septon', Prefix : 'High Septon '}) | |
CREATE (Gared:Person {name : 'Gared', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Garlan_Tyrell:Person {name : 'Garlan Tyrell', House : 'Tyrell', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Garse_Goodbrook:Person {name : 'Garse Goodbrook', House : 'Frey Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Garth_Greyfeather:Person {name : 'Garth Greyfeather', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Gendry:Person {name : 'Gendry', House : 'none', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Gerris_Drinkwater:Person {name : 'Gerris Drinkwater', House : 'Martell', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Gilly:Person {name : 'Gilly', House : 'Wildlings north of wall', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Gladden_Wylde:Person {name : 'Gladden Wylde', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Gregor_Clegane:Person {name : 'Gregor Clegane', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Grenn:Person {name : 'Grenn', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Groleo:Person {name : 'Groleo', House : 'Targaryen', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Guncer_Sunglass:Person {name : 'Guncer Sunglass', House : 'Stannis', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of Sweetport Sound', Prefix : 'Lord '}) | |
CREATE (Guyard_Morrigen:Person {name : 'Guyard Morrigen', House : 'Renly', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Hake:Person {name : 'Hake', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Hal:Person {name : 'Hal', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Haldon:Person {name : 'Haldon', House : 'Targaryen', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Harlan_Hunter:Person {name : 'Harlan Hunter', House : 'none', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Harwin:Person {name : 'Harwin', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Helman_Tallhart:Person {name : 'Helman Tallhart', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Hizdahr_zo_Loraq:Person {name : 'Hizdahr zo Loraq', House : 'Essos', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Hodor:Person {name : 'Hodor', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Hosteen_Frey:Person {name : 'Hosteen Frey', House : 'Frey North', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Hoster_Tully:Person {name : 'Hoster Tully', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord Paramount of the Riverlands', Prefix : 'Lord '}) | |
CREATE (Hot_Pie:Person {name : 'Hot Pie', House : 'none', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Hubard_Rambton:Person {name : 'Hubard Rambton', House : 'Stannis', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Hugh:Person {name : 'Hugh', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Hullen:Person {name : 'Hullen', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Iggo:Person {name : 'Iggo', House : 'Brave Companions', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Illyrio_Mopatis:Person {name : 'Illyrio Mopatis', House : 'none', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Ilyn_Payne:Person {name : 'Ilyn Payne', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Irri:Person {name : 'Irri', House : 'Drogo', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Jacelyn_Bywater:Person {name : 'Jacelyn Bywater', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Jack_Bulwer:Person {name : 'Jack Bulwer', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Jafer_Flowers:Person {name : 'Jafer Flowers', House : 'Night Watch', isDead : 1, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Jaime_Lannister:Person {name : 'Jaime Lannister', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight of the Kings guard', Prefix : 'Ser '}) | |
CREATE (Janos_Slynt:Person {name : 'Janos Slynt', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Commander of the City Watch', Prefix : 'Lord '}) | |
CREATE (Jaqen_Hghar:Person {name : 'Jaqen Hghar', House : 'Faceless Men', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Jared_Frey:Person {name : 'Jared Frey', House : 'Frey North', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Jaremy_Rykker:Person {name : 'Jaremy Rykker', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Jeor_Mormont:Person {name : 'Jeor Mormont', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord Commander of the Night Watch', Prefix : 'Lord Commander '}) | |
CREATE (Jeyne_Poole:Person {name : 'Jeyne Poole', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Jeyne_Westerling:Person {name : 'Jeyne Westerling', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : 'Lady '}) | |
CREATE (Jhiqui:Person {name : 'Jhiqui', House : 'Drogo', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Jhogo:Person {name : 'Jhogo', House : 'Drogo', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'bloodrider', Prefix : ''}) | |
CREATE (Joffrey_Baratheon:Person {name : 'Joffrey Baratheon', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'prince', Prefix : 'Prince '}) | |
CREATE (Jojen_Reed:Person {name : 'Jojen Reed', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Jon_Arryn:Person {name : 'Jon Arryn', House : 'Robert', isDead : 1, isCaptured : 0, isHurt : 0, Title : 'Hand of the King', Prefix : 'Lord '}) | |
CREATE (Jon_Connington:Person {name : 'Jon Connington', House : 'Targaryen', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of Griffins Roost', Prefix : 'Lord '}) | |
CREATE (Jon_Snow:Person {name : 'Jon Snow', House : 'Stark', isDead : 1, isCaptured : 0, isHurt : 0, Title : 'Lord Commander of the Night Watch', Prefix : 'Lord Commander '}) | |
CREATE (Jon_Umber_Greatjon:Person {name : 'Jon Umber Greatjon', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of Last Hearth', Prefix : 'Lord '}) | |
CREATE (Jorah_Mormont:Person {name : 'Jorah Mormont', House : 'none', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Jory_Cassel:Person {name : 'Jory Cassel', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'captain', Prefix : 'Captain '}) | |
CREATE (Kerwin:Person {name : 'Kerwin', House : 'Greyjoy', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Kevan_Lannister:Person {name : 'Kevan Lannister', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Khrazz:Person {name : 'Khrazz', House : 'Essos', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Kindly_Man:Person {name : 'Kindly Man', House : 'Faceless Men', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Kraznys_mo_Nakloz:Person {name : 'Kraznys mo Nakloz', House : 'Essos', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Kyra:Person {name : 'Kyra', House : 'none', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Lancel_Lannister:Person {name : 'Lancel Lannister', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Lark:Person {name : 'Lark', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Lollys_Stokeworth:Person {name : 'Lollys Stokeworth', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : 'Lady '}) | |
CREATE (Lommy_Greenhands:Person {name : 'Lommy Greenhands', House : 'none', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Loras_Tyrell:Person {name : 'Loras Tyrell', House : 'Tyrell', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Lothar_Mallery:Person {name : 'Lothar Mallery', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Lothor_Brune:Person {name : 'Lothor Brune', House : 'Littlefinger', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Lucas_Blackwood:Person {name : 'Lucas Blackwood', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Luton:Person {name : 'Luton', House : 'Bolton Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Luwin:Person {name : 'Luwin', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'maester', Prefix : 'Maester '}) | |
CREATE (Lyanna_Stark:Person {name : 'Lyanna Stark', House : 'Stark', isDead : 1, isCaptured : 0, isHurt : 0, Title : 'lady', Prefix : 'Lady '}) | |
CREATE (Lyman_Darry:Person {name : 'Lyman Darry', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Lymond_Vikary:Person {name : 'Lymond Vikary', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Lysa_Tully:Person {name : 'Lysa Tully', House : 'Littlefinger', isDead : 1, isCaptured : 0, isHurt : 0, Title : 'lady', Prefix : 'Lady '}) | |
CREATE (Mace_Tyrell:Person {name : 'Mace Tyrell', House : 'Tyrell', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of Highgarden', Prefix : 'Lord '}) | |
CREATE (Mag_Mar_Tun_Doh_Weg:Person {name : 'Mag Mar Tun Doh Weg', House : 'Wildlings north of wall', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Mance_Rayder:Person {name : 'Mance Rayder', House : 'Wildlings north of wall', isDead : 1, isCaptured : 0, isHurt : 0, Title : 'King beyond the wall', Prefix : ''}) | |
CREATE (Mandon_Moore:Person {name : 'Mandon Moore', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight of the Kings guard', Prefix : 'Ser '}) | |
CREATE (Margaery_Tyrell:Person {name : 'Margaery Tyrell', House : 'Tyrell', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : 'Lady '}) | |
CREATE (Meera_Reed:Person {name : 'Meera Reed', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Melisandre:Person {name : 'Melisandre', House : 'Red God', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'priestess of the Red God', Prefix : ''}) | |
CREATE (Mero:Person {name : 'Mero', House : 'Second Sons', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Merrett_Frey:Person {name : 'Merrett Frey', House : 'Frey North', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Meryn_Trant:Person {name : 'Meryn Trant', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight of the Kings guard', Prefix : 'Ser '}) | |
CREATE (Mikken:Person {name : 'Mikken', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Mirri_Maz_Duur:Person {name : 'Mirri Maz Duur', House : 'Essos', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Maegi', Prefix : ''}) | |
CREATE (Missandei:Person {name : 'Missandei', House : 'Targaryen', isDead : 0, isCaptured : 1, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Mordane:Person {name : 'Mordane', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'septa', Prefix : 'Septa '}) | |
CREATE (Mycah:Person {name : 'Mycah', House : 'none', isDead : 1, isCaptured : 0, isHurt : 0, Title : 'butcher boy', Prefix : ''}) | |
CREATE (Myrcella_Baratheon:Person {name : 'Myrcella Baratheon', House : 'Lannister', isDead : 1, isCaptured : 0, isHurt : 0, Title : 'princess', Prefix : 'Princess '}) | |
CREATE (Nan:Person {name : 'Nan', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Nymeria:Person {name : 'Nymeria', House : 'Martell', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : 'Lady '}) | |
CREATE (Oberyn_Martell:Person {name : 'Oberyn Martell', House : 'Martell', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'prince', Prefix : 'Prince '}) | |
CREATE (Olenna_Redwyne:Person {name : 'Olenna Redwyne', House : 'Tyrell', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : 'Lady '}) | |
CREATE (Ollo_Lophand:Person {name : 'Ollo Lophand', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Oppo:Person {name : 'Oppo', House : 'none', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Orton_Merryweather:Person {name : 'Orton Merryweather', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of Longtable', Prefix : 'Lord '}) | |
CREATE (Osha:Person {name : 'Osha', House : 'Wildlings north of wall', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Osmund_Kettleblack:Person {name : 'Osmund Kettleblack', House : 'Tyrion', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Osney_Kettleblack:Person {name : 'Osney Kettleblack', House : 'Tyrion', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Othor:Person {name : 'Othor', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Oznak_zo_Pahl:Person {name : 'Oznak zo Pahl', House : 'Essos', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Pate:Person {name : 'Pate', House : 'Citadel', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Paul:Person {name : 'Paul', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Paxter_Redwyne:Person {name : 'Paxter Redwyne', House : 'Tyrell', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of the Arbor', Prefix : 'Lord '}) | |
CREATE (Penny:Person {name : 'Penny', House : 'none', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Petyr_Baelish:Person {name : 'Petyr Baelish', House : 'Littlefinger', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Master of the coin', Prefix : 'Lord '}) | |
CREATE (Podrick_Payne:Person {name : 'Podrick Payne', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Polliver:Person {name : 'Polliver', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Pycelle:Person {name : 'Pycelle', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'grand maester', Prefix : 'Grand Maester '}) | |
CREATE (Pyg:Person {name : 'Pyg', House : 'Brave Companions', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Pypar:Person {name : 'Pypar', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Qhorin_Halfhand:Person {name : 'Qhorin Halfhand', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Qotho:Person {name : 'Qotho', House : 'Drogo', isDead : 1, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Quaithe:Person {name : 'Quaithe', House : 'Essos', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Quaro:Person {name : 'Quaro', House : 'Drogo', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Quentyn_Martell:Person {name : 'Quentyn Martell', House : 'Martell', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'prince', Prefix : 'Prince '}) | |
CREATE (Qyburn:Person {name : 'Qyburn', House : 'Brave Companions', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'maester', Prefix : 'Maester '}) | |
CREATE (Rafford:Person {name : 'Rafford', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Ralf_Kenning:Person {name : 'Ralf Kenning', House : 'Greyjoy', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Ramsay_Snow:Person {name : 'Ramsay Snow', House : 'Bolton North', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Randyll_Tarly:Person {name : 'Randyll Tarly', House : 'Renly', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of Horn Hill', Prefix : 'Lord '}) | |
CREATE (Rattleshirt:Person {name : 'Rattleshirt', House : 'Wildlings north of wall', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Raymun_Darry:Person {name : 'Raymun Darry', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'lord of Darry', Prefix : 'Lord '}) | |
CREATE (Raymund_Frey:Person {name : 'Raymund Frey', House : 'Frey North', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Reek:Person {name : 'Reek', House : 'Bolton Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Renly_Baratheon:Person {name : 'Renly Baratheon', House : 'Renly', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of Storms End', Prefix : 'Lord '}) | |
CREATE (Reznak_mo_Reznak:Person {name : 'Reznak mo Reznak', House : 'Targaryen', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Rhaegar_Frey:Person {name : 'Rhaegar Frey', House : 'Frey Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Rhaegar_Targaryen:Person {name : 'Rhaegar Targaryen', House : 'Targaryen', isDead : 1, isCaptured : 0, isHurt : 0, Title : 'prince', Prefix : 'Prince '}) | |
CREATE (Rhaego:Person {name : 'Rhaego', House : 'Targaryen', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Rhaenys_Targaryen:Person {name : 'Rhaenys Targaryen', House : 'Targaryen', isDead : 1, isCaptured : 0, isHurt : 0, Title : 'Queen of Westeros', Prefix : 'Queen '}) | |
CREATE (Rickard_Karstark:Person {name : 'Rickard Karstark', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of Karhold', Prefix : 'Lord '}) | |
CREATE (Rickard_Stark:Person {name : 'Rickard Stark', House : 'Stark', isDead : 1, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Rickon_Stark:Person {name : 'Rickon Stark', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Robar_Royce:Person {name : 'Robar Royce', House : 'Renly', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Robb_Stark:Person {name : 'Robb Stark', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Robert_Arryn:Person {name : 'Robert Arryn', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Robert_Baratheon:Person {name : 'Robert Baratheon', House : 'Robert', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'King of Westeros', Prefix : 'King '}) | |
CREATE (Robett_Glover:Person {name : 'Robett Glover', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Rodrik_Cassel:Person {name : 'Rodrik Cassel', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Roland_Crakehall:Person {name : 'Roland Crakehall', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of Crakehall', Prefix : 'Lord '}) | |
CREATE (Roose_Bolton:Person {name : 'Roose Bolton', House : 'Bolton North', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Rorge:Person {name : 'Rorge', House : 'none', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Rupert_Brax:Person {name : 'Rupert Brax', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Ryles:Person {name : 'Ryles', House : 'Night Watch', isDead : 1, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Ryman_Frey:Person {name : 'Ryman Frey', House : 'Frey North', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Salladhor_Saan:Person {name : 'Salladhor Saan', House : 'Stannis', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Samwell_Tarly:Person {name : 'Samwell Tarly', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Sandor_Clegane:Person {name : 'Sandor Clegane', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'member of the Kings Guard', Prefix : ''}) | |
CREATE (Sansa_Stark:Person {name : 'Sansa Stark', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : 'Lady '}) | |
CREATE (Satin:Person {name : 'Satin', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Sawane_Botley:Person {name : 'Sawane Botley', House : 'Greyjoy', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of Lordsport', Prefix : 'Lord '}) | |
CREATE (Selyse_Florent:Person {name : 'Selyse Florent', House : 'Stannis', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'lady', Prefix : 'Lady '}) | |
CREATE (Senelle:Person {name : 'Senelle', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Shae:Person {name : 'Shae', House : 'Tyrion', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Shagga:Person {name : 'Shagga', House : 'Mountain clans', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Shagwell:Person {name : 'Shagwell', House : 'Brave Companions', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Shireen_Baratheon:Person {name : 'Shireen Baratheon', House : 'Stannis', isDead : 1, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Skahaz_mo_Kandaq:Person {name : 'Skahaz mo Kandaq', House : 'Targaryen', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Softfoot:Person {name : 'Softfoot', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Stafford_Lannister:Person {name : 'Stafford Lannister', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Stannis_Baratheon:Person {name : 'Stannis Baratheon', House : 'Stannis', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of Dragonstone', Prefix : 'Lord '}) | |
CREATE (Stevron_Frey:Person {name : 'Stevron Frey', House : 'Frey North', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Stiv:Person {name : 'Stiv', House : 'Wildlings north of wall', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Styr:Person {name : 'Styr', House : 'Wildlings north of wall', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Symond_Frey:Person {name : 'Symond Frey', House : 'Frey Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Syrio_Forel:Person {name : 'Syrio Forel', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Taena_of_Myr:Person {name : 'Taena of Myr', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Talbert_Serry:Person {name : 'Talbert Serry', House : 'Tyrell', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (the_Others:Person {name : 'the Others', House : 'the Others', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Theon_Greyjoy:Person {name : 'Theon Greyjoy', House : 'Greyjoy', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Reek', Prefix : 'Reek'}) | |
CREATE (Thistle:Person {name : 'Thistle', House : 'Wildling refugees', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Thoros_of_Myr:Person {name : 'Thoros of Myr', House : 'Red God', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Tickler:Person {name : 'Tickler', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Timeon:Person {name : 'Timeon', House : 'Brave Companions', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Timett:Person {name : 'Timett', House : 'Mountain clans', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Tion_Frey:Person {name : 'Tion Frey', House : 'Frey North', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Tom_of_Sevenstreams:Person {name : 'Tom of Sevenstreams', House : 'Brotherhood without Banners', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Tommen_Baratheon:Person {name : 'Tommen Baratheon', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Tormund:Person {name : 'Tormund', House : 'Wildlings north of wall', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Torrhen_Karstark:Person {name : 'Torrhen Karstark', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Tyrion_Lannister:Person {name : 'Tyrion Lannister', House : 'Tyrion', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Tysha:Person {name : 'Tysha', House : 'Tyrion', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Tytos_Frey:Person {name : 'Tytos Frey', House : 'Frey Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Tywin_Lannister:Person {name : 'Tywin Lannister', House : 'Lannister', isDead : 1, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Utt:Person {name : 'Utt', House : 'Brave Companions', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'septon', Prefix : 'Septon '}) | |
CREATE (Val:Person {name : 'Val', House : 'Wildlings north of wall', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Varamyr:Person {name : 'Varamyr', House : 'Wildlings north of wall', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Vardis_Egen:Person {name : 'Vardis Egen', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Vargo_Hoat:Person {name : 'Vargo Hoat', House : 'Brave Companions', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Varly:Person {name : 'Varly', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Varys:Person {name : 'Varys', House : 'none', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Master of whisperers', Prefix : 'Lord '}) | |
CREATE (Vayon_Poole:Person {name : 'Vayon Poole', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Victarion_Greyjoy:Person {name : 'Victarion Greyjoy', House : 'Greyjoy', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord captain of the Iron Fleet', Prefix : 'Lord'}) | |
CREATE (Viserys_Targaryen:Person {name : 'Viserys Targaryen', House : 'Targaryen', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Walder_Frey:Person {name : 'Walder Frey', House : 'Frey North', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of the Crossing', Prefix : 'Lord '}) | |
CREATE (Walder_Frey_Little:Person {name : 'Walder Frey Little', House : 'Frey North', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Waymar_Royce:Person {name : 'Waymar Royce', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Weeper:Person {name : 'Weeper', House : 'Wildlings north of wall', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Weese:Person {name : 'Weese', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Will:Person {name : 'Will', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Willas_Tyrell:Person {name : 'Willas Tyrell', House : 'Tyrell', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Willem_Lannister:Person {name : 'Willem Lannister', House : 'Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Wylis_Manderly:Person {name : 'Wylis Manderly', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'knight', Prefix : 'Ser '}) | |
CREATE (Wyman_Manderly:Person {name : 'Wyman Manderly', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of White Harbor', Prefix : 'Lord '}) | |
CREATE (Yellow_Dick:Person {name : 'Yellow Dick', House : 'Bolton Lannister', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Ygritte:Person {name : 'Ygritte', House : 'Wildlings north of wall', isDead : 1, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Yohn_Royce:Person {name : 'Yohn Royce', House : 'Stark', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lord of Runestone', Prefix : 'Lord '}) | |
CREATE (Yoren:Person {name : 'Yoren', House : 'Night Watch', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Yurkhaz_zo_Yunzak:Person {name : 'Yurkhaz zo Yunzak', House : 'Essos', isDead : 0, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Moqorro:Person {name : 'Moqorro', House : 'Red God', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'priest of the Red God', Prefix : ''}) | |
CREATE (Sallor_the_Bald:Person {name : 'Sallor the Bald', House : 'Stormcrows', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'captain', Prefix : ''}) | |
CREATE (Prendahl_na_Ghezn:Person {name : 'Prendahl na Ghezn', House : 'Stormcrows', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'captain', Prefix : ''}) | |
CREATE (Talisa_Stark:Person {name : 'Talisa Stark', House : 'Stark', isDead : 1, isCaptured : 0, isHurt : 0, Title : '', Prefix : ''}) | |
CREATE (Drogon:Person {name : 'Drogon', House : 'Targaryen', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Dragon', Prefix : ''}) | |
CREATE (Rhaegal:Person {name : 'Rhaegal', House : 'Targaryen', isDead : 0, isCaptured : 1, isHurt : 0, Title : 'Dragon', Prefix : ''}) | |
CREATE (Viserion:Person {name : 'Viserion', House : 'Targaryen', isDead : 0, isCaptured : 1, isHurt : 0, Title : 'Dragon', Prefix : ''}) | |
CREATE (Yara_Greyjoy:Person {name : 'Yara Greyjoy', House : 'Greyjoy', isDead : 0, isCaptured : 0, isHurt : 0, Title : 'Lady', Prefix : ''}) | |
CREATE (Eddard_Stark)-[:PARENT_OF]->(Arya_Stark) | |
CREATE (Eddard_Stark)-[:PARENT_OF]->(Bran_Stark) | |
CREATE (Eddard_Stark)-[:PARENT_OF]->(Jon_Snow) | |
CREATE (Eddard_Stark)-[:PARENT_OF]->(Rickard_Stark) | |
CREATE (Eddard_Stark)-[:PARENT_OF]->(Rickon_Stark) | |
CREATE (Eddard_Stark)-[:PARENT_OF]->(Robb_Stark) | |
CREATE (Eddard_Stark)-[:PARENT_OF]->(Sansa_Stark) | |
CREATE (Catelyn_Tully)-[:PARENT_OF]->(Arya_Stark) | |
CREATE (Catelyn_Tully)-[:PARENT_OF]->(Bran_Stark) | |
CREATE (Catelyn_Tully)-[:PARENT_OF]->(Jon_Snow) | |
CREATE (Catelyn_Tully)-[:PARENT_OF]->(Rickard_Stark) | |
CREATE (Catelyn_Tully)-[:PARENT_OF]->(Rickon_Stark) | |
CREATE (Catelyn_Tully)-[:PARENT_OF]->(Robb_Stark) | |
CREATE (Catelyn_Tully)-[:PARENT_OF]->(Sansa_Stark) | |
CREATE (Eddard_Stark)-[:SPOUSE]->(Catelyn_Tully) | |
CREATE (Catelyn_Tully)-[:SPOUSE]->(Eddard_Stark) | |
CREATE (Robb_Stark)-[:SPOUSE]->(Talisa_Stark) | |
CREATE (Talisa_Stark)-[:SPOUSE]->(Robb_Stark) | |
CREATE (Jon_Snow)-[:LOVES]->(Ygritte) | |
CREATE (Ygritte)-[:LOVES]->(Jon_Snow) | |
CREATE (Tyrion_Lannister)-[:SPOUSE]->(Sansa_Stark) | |
CREATE (Sansa_Stark)-[:SPOUSE]->(Tyrion_Lannister) | |
CREATE (Robert_Baratheon)-[:SPOUSE]->(Cersei_Lannister) | |
CREATE (Cersei_Lannister)-[:SPOUSE]->(Robert_Baratheon) | |
CREATE (Jaime_Lannister)-[:LOVES]->(Cersei_Lannister) | |
CREATE (Cersei_Lannister)-[:LOVES]->(Jaime_Lannister) | |
CREATE (Jaime_Lannister)-[:SIBLING_OF]->(Cersei_Lannister) | |
CREATE (Cersei_Lannister)-[:SIBLING_OF]->(Jaime_Lannister) | |
CREATE (Robert_Baratheon)-[:PARENT_OF]->(Myrcella_Baratheon) | |
CREATE (Robert_Baratheon)-[:PARENT_OF]->(Joffrey_Baratheon) | |
CREATE (Robert_Baratheon)-[:PARENT_OF]->(Tommen_Baratheon) | |
CREATE (Robert_Baratheon)-[:PARENT_OF]->(Gendry) | |
CREATE (Myrcella_Baratheon)-[:PARENT_OF]->(Cersei_Lannister) | |
CREATE (Joffrey_Baratheon)-[:PARENT_OF]->(Cersei_Lannister) | |
CREATE (Tommen_Baratheon)-[:PARENT_OF]->(Cersei_Lannister) | |
CREATE (Jaime_Lannister)-[:BIOPARENT_OF]->(Myrcella_Baratheon) | |
CREATE (Jaime_Lannister)-[:BIOPARENT_OF]->(Joffrey_Baratheon) | |
CREATE (Jaime_Lannister)-[:BIOPARENT_OF]->(Tommen_Baratheon) | |
CREATE (Tyrion_Lannister)-[:LOVES]->(Shae) | |
CREATE (Shae)-[:LOVES]->(Tyrion_Lannister) | |
CREATE (Joffrey_Baratheon)-[:SPOUSE]->(Margaery_Tyrell) | |
CREATE (Margaery_Tyrell)-[:SPOUSE]->(Joffrey_Baratheon) | |
CREATE (Tommen_Baratheon)-[:SPOUSE]->(Margaery_Tyrell) | |
CREATE (Margaery_Tyrell)-[:SPOUSE]->(Tommen_Baratheon) | |
CREATE (Tywin_Lannister)-[:PARENT_OF]->(Tyrion_Lannister) | |
CREATE (Tywin_Lannister)-[:PARENT_OF]->(Jaime_Lannister) | |
CREATE (Tywin_Lannister)-[:PARENT_OF]->(Cersei_Lannister) | |
CREATE (Renly_Baratheon)-[:SPOUSE]->(Margaery_Tyrell) | |
CREATE (Margaery_Tyrell)-[:SPOUSE]->(Renly_Baratheon) | |
CREATE (Stannis_Baratheon)-[:SPOUSE]->(Selyse_Florent) | |
CREATE (Selyse_Florent)-[:SPOUSE]->(Stannis_Baratheon) | |
CREATE (Stannis_Baratheon)-[:PARENT_OF]->(Shireen_Baratheon) | |
CREATE (Selyse_Florent)-[:PARENT_OF]->(Shireen_Baratheon) | |
CREATE (Aegon_I_Targaryen)-[:SIBLING_OF]->(Aemon_Targaryen) | |
CREATE (Aemon_Targaryen)-[:SIBLING_OF]->(Aegon_I_Targaryen) | |
CREATE (Aemon_Targaryen)-[:SIBLING_OF]->(Aerys_II_Targaryen) | |
CREATE (Aerys_II_Targaryen)-[:SIBLING_OF]->(Aemon_Targaryen) | |
CREATE (Aerys_II_Targaryen)-[:PARENT_OF]->(Daenerys_Targaryen) | |
CREATE (Aerys_II_Targaryen)-[:PARENT_OF]->(Viserys_Targaryen) | |
CREATE (Daenerys_Targaryen)-[:SIBLING_OF]->(Viserys_Targaryen) | |
CREATE (Viserys_Targaryen)-[:SIBLING_OF]->(Daenerys_Targaryen) | |
CREATE (Daenerys_Targaryen)-[:SPOUSE]->(Drogo) | |
CREATE (Drogo)-[:SPOUSE]->(Daenerys_Targaryen) | |
CREATE (Daario_Naharis)-[:LOVES]->(Daenerys_Targaryen) | |
CREATE (Daenerys_Targaryen)-[:LOVES]->(Daario_Naharis) | |
CREATE (Jorah_Mormont)-[:LOVES]->(Daenerys_Targaryen) | |
CREATE (Daenerys_Targaryen)-[:PARENT_OF]->(Drogon) | |
CREATE (Daenerys_Targaryen)-[:PARENT_OF]->(Rhaegal) | |
CREATE (Daenerys_Targaryen)-[:PARENT_OF]->(Viserion) | |
CREATE (Jeor_Mormont)-[:PARENT_OF]->(Jorah_Mormont) | |
CREATE (Selyse_Florent)-[:PARENT_OF]->(Theon_Greyjoy) | |
CREATE (Selyse_Florent)-[:PARENT_OF]->(Yara_Greyjoy) | |
CREATE (Roose_Bolton)-[:PARENT_OF]->(Ramsay_Snow) | |
CREATE (Ramsay_Snow)-[:SPOUSE]->(Sansa_Stark) | |
CREATE (Sansa_Stark)-[:SPOUSE]->(Ramsay_Snow) | |
CREATE (Yara_Greyjoy)-[:SIBLING_OF]->(Theon_Greyjoy) | |
CREATE (Theon_Greyjoy)-[:SIBLING_OF]->(Yara_Greyjoy) | |
---- | |
This gives us the following graph to play with: | |
//graph | |
Let's check how many nodes we have now: Cypher 01 | |
//console | |
[source,cypher] | |
---- | |
Match n RETURN "Hello Graph with " + count(*) + " Nodes! in first Gist by Brijraj Singh " AS welcome; | |
---- | |
//table | |
List all nodes and their relationships: Cypher 02 | |
//console | |
[source,cypher] | |
---- | |
MATCH (n)-[r]->(m) RETURN n AS from, r AS `->`, m AS to; | |
---- | |
//table | |
List most connected nodes in desc order: Cypher 03 | |
//console | |
[source,cypher] | |
---- | |
Match n return n, length(n--()) as connectedness order by connectedness desc limit 5; | |
---- | |
//table | |
Let's get shortest path between Ygritte and Gendry: Cypher 04 | |
//console | |
[source,cypher] | |
---- | |
MATCH (a:Person { name:"Ygritte" }),(b:Person { name:"Gendry" }), | |
p = shortestPath((a)-[*]-(b)) | |
RETURN p | |
---- | |
//table | |
- link:https://twitter.com/brijrajsingh[Twitter] | |
Created by Brijraj Singh (Technical Evangelist, Microsoft) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment