jvilledieu’s gists

jvilledieu / ballon_or.csv

Last active August 14, 2017 05:47

Who voted for who? The Ballon d’Or voting data : https://medium.com/@kristw/who-voted-for-who-diving-into-ballon-dor-voting-data-e09138ba9712

We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.

	Voter;Country;Name;Position;Nominee
	Captain;Afghanistan;Amiri Islam;First_(5pt);Messi Lionel
	Captain;Afghanistan;Amiri Islam;Second_(3pt);Cristiano Ronaldo
	Captain;Afghanistan;Amiri Islam;Third_(1pt);Ibrahimovic Zlatan
	Captain;Albania;Cana Lorik;First_(5pt);Cristiano Ronaldo
	Captain;Albania;Cana Lorik;Second_(3pt);Robben Arjen
	Captain;Albania;Cana Lorik;Third_(1pt);Mueller Thomas
	Captain;Algeria;Bougherra Madjid;First_(5pt);Cristiano Ronaldo
	Captain;Algeria;Bougherra Madjid;Second_(3pt);Robben Arjen
	Captain;Algeria;Bougherra Madjid;Third_(1pt);Benzema Karim

jvilledieu / Import_ballon_or.cql

Last active August 29, 2015 14:13

Script to import the votes from the Ballon d'Or 2014 into a Neo4j graph.

	CREATE CONSTRAINT ON (e:PERSON) ASSERT e.name IS UNIQUE;
	CREATE CONSTRAINT ON (e:TYPE) ASSERT e.name IS UNIQUE;
	CREATE CONSTRAINT ON (e:COUNTRY) ASSERT e.name IS UNIQUE;

	USING PERIODIC COMMIT 2000
	LOAD CSV WITH HEADERS FROM "file:c:/ballon_or.csv" AS line
	FIELDTERMINATOR ';'
	MERGE (:PERSON {name: line.Name, type: line.Voter, country: line.Country})
	MERGE (:TYPE {name: line.Voter})
	MERGE (:COUNTRY {name: line.Country})

jvilledieu / import_AML_dataset.cql

Last active August 29, 2015 14:13

Import script to populate Neo4j with an AML dataset.

	//-----------------------
	//Import the companies
	//-----------------------

	CREATE CONSTRAINT ON (e:COMPANY) ASSERT e.id IS UNIQUE;

	USING PERIODIC COMMIT 2000
	LOAD CSV WITH HEADERS FROM "file:c:/companies.csv" AS line
	MERGE (:COMPANY { id: line.id, company_name: line.company_name, city: line.city, country: line.country, postal_code: line.postal_code, state: line.state, address: line.address});

jvilledieu / contributions_import.cql

Last active August 29, 2015 14:16

Importing the contribution dataset.

	//-----------------------
	//Import the contributors
	//-----------------------

	CREATE INDEX ON :CONTRIBUTOR(`id`);

	USING PERIODIC COMMIT 2000
	LOAD CSV WITH HEADERS FROM "file:c:/contribution_nodes.csv" AS line
	FIELDTERMINATOR ';'
	MERGE (:CONTRIBUTOR { id: line.id, size: line.size, organization_type: line.organization_type, committee_type: line.committee_type, party: line.party, name: line.name});

jvilledieu / import_contributions.cql

Last active January 4, 2017 09:42

Importing the FEC data available here: http://www.fec.gov/finance/disclosure/ftpdet.shtml#a2015_2016

	//-----------------------
	//Import the committees
	//-----------------------

	CREATE CONSTRAINT ON (e:COMMITTEE) ASSERT e.CMTE_ID IS UNIQUE;

	USING PERIODIC COMMIT 2000
	LOAD CSV WITH HEADERS FROM "file:c:/cmv1.csv" AS line
	FIELDTERMINATOR '\|'
	MERGE (:COMMITTEE {

jvilledieu / Contributions analysis.cql

Last active August 29, 2015 14:16

Queries to analyse the political contributions

	//-----------------------
	//Company whose employees donated the more money
	//-----------------------

	MATCH (a:COMPANY)<-[:IS_EMPLOYED]-(b:INDIVIDUAL)-[r:HAS_CONTRIBUTED]->(c:COMMITTEE)
	RETURN a.EMPLOYER, SUM(r.TRANSACTION_AMT) as total
	ORDER BY total DESC
	LIMIT 10

	//-----------------------

jvilledieu / import_fp7.cql

Last active August 29, 2015 14:19

	//-----------------------
	//Import programs
	//-----------------------

	CREATE CONSTRAINT ON (a:PROGRAM) ASSERT a.programmePga IS UNIQUE;

	USING PERIODIC COMMIT 2000
	LOAD CSV WITH HEADERS FROM "file:c:/fp7projects20150303.csv" AS line
	FIELDTERMINATOR ';'
	WITH line

jvilledieu / fp7_analysis.cql

Last active August 29, 2015 14:20

FP7 analysis

	//-----------------------
	//Number of organizations
	//-----------------------
	MATCH (a:ORGANIZATION)
	Return count(a) as total_organizations;

	//-----------------------
	//Number of projects
	//-----------------------
	MATCH (a:PROJECT)

jvilledieu / facebook.cql

Last active August 14, 2017 05:43

Import friends list scrapped from Facebook into Neo4j.

	//-----------------------
	//Import people
	//-----------------------

	CREATE CONSTRAINT ON (a:PEOPLE) ASSERT a.id IS UNIQUE;

	USING PERIODIC COMMIT 2000
	LOAD CSV WITH HEADERS FROM "file:c:/my-facebook-network.csv" AS line
	FIELDTERMINATOR ','
	WITH line

jvilledieu / import_EU_tenders.cql

Last active August 29, 2015 14:23

Importing the European Union tenders into Neo4j

	//-----------------------
	//Import authorities
	//-----------------------

	CREATE CONSTRAINT ON (a:AUTHORITY) ASSERT a.contract_authority_official_name IS UNIQUE;

	USING PERIODIC COMMIT 2000
	LOAD CSV WITH HEADERS FROM "file:c:/ted-contracts.csv" AS line
	FIELDTERMINATOR ','
	WITH line

Jean Villedieu jvilledieu