spending2graphs/README.org

Begin here for the data https://github.com/netAction/hochschulwatch/blob/gh-pages/import/daten/sponsoring.csv Sponsoring

The reast is in the parrent folder daten

Cypher

LOAD CSV FROM '/home/s0/Code/Projects/OSI/graphsForSpenders/dm-unis-unique.csv' AS line;
CREATE (:Uni { name: line[1] });

WITH "/home/s0/Code/Projects/OSI/graphsForSpenders/" AS base
WITH base + "dm-unis-unique.csv" AS uri
LOAD CSV WITH HEADERS FROM uri AS row
MERGE (:uni {id: row.id})

WITH base + "dm-relationship-geldspende.csv" AS uri
LOAD CSV WITH HEADERS FROM uri as row
MERGE (source:Geber {id: row.src})
MERGE (destination:Uni {id: row.dst})
MERGE (source)-[:MONEY_GRANT {year: row.year, sum: row.sum, source:row.source explanation:row.expl} ]-> (destination)

WITH "https://notabug.org/ProTransparenz/spending2graphs/raw/master/" AS base
WITH base + "dm-relationship-geldleistung.csv" AS uri
LOAD CSV WITH HEADERS FROM uri as row
MERGE (source:Geber {id: row.src})
MERGE (destination:Uni {id: row.dst})
MERGE (source)-[:MONEY_GRANT {year: row.year, sum: row.syn} ]-> (destination)

https://notabug.org/ProTransparenz/spending2graphs/raw/master/dm-relationship-geldspende.csv

state;dst;year;src;rel;art;wert;note;alt;src

Bundesland Universität Jahr Name des Gebers Geld-/Sachspende Art der Leistung Wert Hinweis Alternativname Quelle

WITH "https://notabug.org/ProTransparenz/spending2graphs/raw/master/" AS base
WITH base + "sponsoring.csv" AS uri
LOAD CSV WITH HEADERS FROM uri as row with row where row.src is not null where row.dst is not null
MERGE (source:Geber {id: row.src, state:row.state})
MERGE (destination:Uni {id: row.dst})
MERGE (source)-[:MONEY_GRANT {year: row.year, value: row.value, type:row.rel, art:row.art, alt:row.alt, source:row.source}]-> (destination)