Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

We can't make this file beautiful and searchable because it's too large.
permalink,name,homepage_url,category_list,market,funding_total_usd,status,country_code,state_code,region,city,funding_rounds,founded_at,founded_month,founded_quarter,founded_year,first_funding_at,last_funding_at
/organization/waywire,#waywire,http://www.waywire.com,|Entertainment|Politics|Social Media|News|, News , 1 750 000 ,acquired,USA,NY,New York City,New York,1,01/06/2012,2012-06,2012-Q2,2012,30/06/2012,30/06/2012
/organization/tv-communications,&TV Communications,http://enjoyandtv.com,|Games|,Games, 4 000 000 ,operating,USA,CA,Los Angeles,Los Angeles,2,,,,,04/06/2010,23/09/2010
/organization/rock-your-paper,'Rock' Your Paper,http://www.rockyourpaper.org,|Publishing|Education|,Publishing, 40 000 ,operating,EST,,Tallinn,Tallinn,1,26/10/2012,2012-10,2012-Q4,2012,09/08/2012,09/08/2012
/organization/in-touch-network,(In)Touch Network,http://www.InTouchNetwork.com,|Electronics|Guides|Coffee|Restaurants|Music|iPhone|Apps|Mobile|iOS|E-Commerce|,Electronics, 1 500 000 ,operating,GBR,,London,London,1,01/04/2011,2
@jvilledieu
jvilledieu / import_EU_tendersv2.cql
Last active October 24, 2022 20:23
Importing the European Union tenders into Neo4j
//-----------------------
//Clean everything
//-----------------------
MATCH (n)
OPTIONAL MATCH (n)-[r]-()
DELETE n,r;
//-----------------------
//Import authorities
//-----------------------
RES_ENT_ID DATA_SOURCE RECORD_ID
1 CUSTOMERS 1001
1 REFERENCE 1001
1 WATCHLIST 1001
1 CUSTOMERS 1002
1 REFERENCE 1002
1 WATCHLIST 1002
1 CUSTOMERS 1003
1 REFERENCE 1003
1 WATCHLIST 1003
@jvilledieu
jvilledieu / Whiplash for cash.adoc
Last active December 6, 2021 21:13
A rundown of whiplash for cash schemes and how to use graphs to fight them
@jvilledieu
jvilledieu / Carousel fraud detection.adoc
Last active December 6, 2021 20:54
This interactive Neo4j graph tutorial shows how to detect a popular fraud scam called "carousel fraud".

HR analytics & finding candidates.adoc

This interactive Neo4j graph tutorial shows how human resources professionals can use graphs to match people and positions.


Credit Card Fraud Detection

This interactive Neo4j graph tutorial covers a common credit card fraud detection scenario.


@jvilledieu
jvilledieu / Import_Crunchbase.cql
Last active November 3, 2020 19:09
Import script for Crunchbase. This is used to create a Neo4j data populated with the Crunchbase data (see blog post: http://linkurio.us/the-crunchbase-graph-data-modelling/). The data remains the property of Crunchbase and its use is limited by the following license: https://info.crunchbase.com/docs/licensing-policy-v1/
//Cleaning up the database
MATCH (n)
WITH n LIMIT 10000
OPTIONAL MATCH (n)-[r]->()
DELETE n,r;
//Importing the file Companies.csv
//Creating the constraints
create constraint on (a:COMPANY) assert a.permalink is unique;
create constraint on (b:CATEGORY) assert b.name is unique;
@jvilledieu
jvilledieu / aml_demo.cql
Last active July 22, 2019 12:31
Import script for the aml demo
//Creating the companies
CREATE CONSTRAINT ON (a:COMPANY) ASSERT a.id IS UNIQUE;
USING PERIODIC COMMIT 2000
LOAD CSV WITH HEADERS FROM "file:///companies.csv" AS line
FIELDTERMINATOR ','
WITH line
MERGE (a:COMPANY {id: line.id})
ON CREATE SET a.description = line.description,
a.name = line.name;
@jvilledieu
jvilledieu / Reshipping scam detection.adoc
Last active July 22, 2019 12:15
A neo4j gist on reshipping and retail fraud.