OpenOil-BP-100

= OpenOil - BP Data Import (100 Records)
 
== Setup
 
//setup
//hide
[source, cypher]
----
LOAD CSV FROM 'https://raw.githubusercontent.com/iilab/openoil/master/data/BP100.csv' AS line
MERGE (c:Company { name: line[0], ID: line[6], sourceURL: line[7], sourcePubDate: line[9]})
MERGE (p:Company { name: line[2]})
MERGE (j:Country { name: line[4]})
MERGE (conf:Confidence { level: line[8]})
MERGE (c)-[dir:DIRECT { immediate: line[1]}]->(p)
MERGE (c)-[jur:JURISDICTION]->(j)
MERGE (c)-[con:CONFIDENCE]->(conf)
----
 
== Query
 
[source, cypher]
----
MATCH (n) 
RETURN n
LIMIT 200
----
 
//graph_result

OpenOil-BP-500

= OpenOil - BP Data Import

== Setup

//setup
//hide
[source, cypher]
----
LOAD CSV FROM 'https://raw.githubusercontent.com/iilab/openoil/master/data/BP500.csv' AS line
MERGE (c:Company { name: line[0], corporateId: line[6], sourceURL: line[7], sourcePubDate: line[9]})
MERGE (p:Company { name: line[2]})
MERGE (j:Country { name: line[4]})
MERGE (c)-[d:DIRECT { immediate: line[1]}]->(p)
MERGE (c)-[e:JURISDICTION]->(j)
----

== Query

[source, cypher]
----
MATCH (n) 
RETURN n
LIMIT 200
----

//graph_result

OpenOil-Company-Country

= OpenOil - BP Data Import

== Setup

//setup
//hide
[source, cypher]
----
LOAD CSV FROM 'https://raw.githubusercontent.com/iilab/openoil/master/data/BP%20Dataset%202014.05.28%20%28Full%20AR2013%20Scrape%20-%20edited%29%20-%20Sheet1.csv' AS line
MERGE (c:Company { name: line[0], corporateId: line[6], sourceURL: line[7], sourcePubDate: line[9]})
MERGE (p:Company { name: line[2]})
MERGE (j:Country { name: line[4]})
MERGE (c)-[d:DIRECT { immediate: line[1]}]->(p)
MERGE (c)-[e:JURISDICTION]->(j)
----

== Query

[source, cypher]
----
MATCH (n) 
RETURN n
LIMIT 200
----

//graph_result

OpenOil-Structr

= OpenOil - BP Data Import

== Setup

[source, cypher]
----
CREATE (c:Company { name: 'BP Exploration (Epsilon) Limited', ID: 'gb/01004984', sourceURL: 'https://docs.google.com/file/d/0B5ORBm2amqZSY2NvOFQwbTZvemM', sourcePubDate: '7/6/2013'})
MERGE (p:Company { name: 'BP Exploration Operating Company Limited'})
MERGE (j:Country { name: 'Bahamas'})
MERGE (conf:Confidence { level: 'High Confidence'})
MERGE (c)-[dir:DIRECT { immediate: '100'}]->(p)
MERGE (c)-[jur:JURISDICTION]->(j)
MERGE (c)-[con:CONFIDENCE]->(conf)