Skip to content

Instantly share code, notes, and snippets.

@brijrajsingh
Forked from shivswami/MahabharataV4.adoc
Last active July 19, 2020 08:40
Show Gist options
  • Save brijrajsingh/501016605b28dab3431d to your computer and use it in GitHub Desktop.
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
= 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