jvilledieu’s gists

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 / 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 / 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 / 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_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_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_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 / 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 / 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 / Call_records_dummy

Created January 12, 2015 10:12

Dummy dataset for call records analysis article.

	ID,FULL_NAME,FIRST_NAME,LAST_NAME,CALLING_NBR,CALLED_NBR,START_DATE,END_DATE,DURATION,CITY,STATE,ADDRESS,CELL_SITE
	1,RalphJordan,Ralph,Jordan,8-(921)364-8515,3-(230)472-4011,1419197491,1419198397,906,Fair Oaks,CA,27834 Glendale Hill,0080
	2,PamelaPowell,Pamela,Powell,2-(270)359-8113,2-(833)444-8281,1416290807,1416292942,2135,West Sacramento,CA,35593 Portage Drive,0051
	3,AnnaGibson,Anna,Gibson,3-(307)801-5521,9-(490)378-2330,1417817803,1417820157,2354,Sacramento,CA,1323 El Camino Avenue,0102
	4,BeverlyKelly,Beverly,Kelly,7-(423)821-7199,3-(307)801-5521,1417220166,1417223469,3303,Folsom,CA,28473 Hanson Plaza,0081
	5,RobertBowman,Robert,Bowman,7-(445)366-2890,2-(833)444-8281,1415288003,1415289004,1001,Sacramento,CA,4 Waubesa Plaza,0032
	6,WalterWright,Walter,Wright,9-(375)425-6362,8-(618)141-5320,1414689052,1414691454,2402,Orangevale,CA,97 Briar Crest Plaza,0079
	7,WalterWright,Walter,Wright,9-(375)425-6362,3-(812)536-3510,1419461129,1419462362,1233,Sacramento,CA,11746 Moose Crossing,0059
	8,AnnaGibson,Anna,Gibson,3-(

Jean Villedieu jvilledieu