Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Global_terrorism_database_Cypher_import
// Create node events
load csv with headers from "file:///bdd.csv" as row
merge(e:Event {id: row.eventid})
set e.nature=row.attacktype1_txt
set e.year=row.iyear
set e.month=row.imonth
set e.date=row.iday
Set e.latitude=row.latitude
Set e.longitude=row.longitude
Set e.detail=row.summary
set e.nkill=row.nkill
// Create node City
load csv with headers from "file:///bdd.csv" as row
merge(c:City {id: row.city})
Set c.details=row.location
// Create node Weapon
load csv with headers from "file:///bdd.csv" as row
merge(w:Weapon {id: row.weaptype1_txt})
Set w.type=row.weapsubtype1_txt
// Create node TargetType
load csv with headers from "file:///bdd.csv" as row
merge(s:TargetType {id: row.targtype1_txt})
Set s.subtype=row.targsubtype1_txt
// Create node Province
load csv with headers from "file:///bdd.csv" as row
merge(v:Province {id: row.provstate})
// Create node Region
load csv with headers from "file:///bdd.csv" as row
merge(r:Region {id: row.region_txt})
// Create node Target
load csv with headers from "file:///bdd.csv" as row
merge(t:Target {id: row.target1})
set t.corporation=row.corp1
set t.type=row.targtype1_txt
set t.subtype=row.targsubtype1_txt
// Create node Author
load csv with headers from "file:///bdd.csv" as row
merge(a:Author {id: row.gname})
// Create node Country
load csv with headers from "file:///bdd.csv" as row
merge(cc:Country {id: row.country_txt})
// Create relationship City-Event
load csv with headers from "file:///bdd.csv" as row
match (e:Event {id:row.eventid})
match (c:City {id:row.city})
merge(e)-[i:IS_LOCATED_IN]->(c)
// Create relationship Weapon-Event
load csv with headers from "file:///bdd.csv" as row
match (w:Weapon {id: row.weaptype1_txt})
match (e:Event {id:row.eventid})
merge(w)-[u:WAS_USED_FOR]->(e)
// Create relationship Author-Event
load csv with headers from "file:///bdd.csv" as row
match (a:Author {id: row.gname})
match (e:Event {id:row.eventid})
merge(a)-[p:PERPETRATED]->(e)
// Create relationship Author-Weapon
load csv with headers from "file:///bdd.csv" as row
match (a:Author {id: row.gname})
match (w:Weapon {id: row.weaptype1_txt})
merge(a)-[d:USED]->(w)
// Create relationship Target-Event
load csv with headers from "file:///bdd.csv" as row
match (e:Event {id:row.eventid})
match (t:Target {id: row.target1})
merge(e)-[tar:TARGETED]->(t)
// Create relationship Target-TargetType
load csv with headers from "file:///bdd.csv" as row
match (t:Target {id: row.target1})
match (s:TargetType {id: row.targtype1_txt})
merge(t)-[ts:TYPE_IS]->(s).
// Create relationship City-Province
load csv with headers from "file:///bdd.csv" as row
match (c:City {id:row.city})
match (v:Province {id: row.provstate})
merge(c)-[cp:IS_LOCATED_IN]->(v)
// Create relationship Province-Country
load csv with headers from "file:///bdd.csv" as row
match (v:Province {id: row.provstate})
match (cc:Country {id: row.country_txt})
merge(v)-[ts:IS_LOCATED_IN]->(cc)
// Create relationship Country-region
load csv with headers from "file:///bdd.csv" as row
match (cc:Country {id: row.country_txt})
match (r:Region {id: row.region_txt})
merge(cc)-[li:IS_LOCATED_IN]->(r)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.