Skip to content

Instantly share code, notes, and snippets.

View jvilledieu's full-sized avatar

Jean Villedieu jvilledieu

12 followers · 0 following
View GitHub Profile
@jvilledieu
jvilledieu / Companies.csv
Last active December 16, 2022 06:27
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 / Acquisitions.csv
Created November 3, 2014 17:29
We can't make this file beautiful and searchable because it's too large.
company_permalink,company_name,company_category_list,company_market,company_country_code,company_state_code,company_region,company_city,acquirer_permalink,acquirer_name,acquirer_category_list,acquirer_market,acquirer_country_code,acquirer_state_code,acquirer_region,acquirer_city,acquired_at,acquired_month,acquired_quarter,acquired_year, price_amount ,price_currency_code
/organization/waywire,#waywire,|Entertainment|Politics|Social Media|News|,News,USA,NY,New York City,New York,/organization/magnify,Waywire Networks,|Curated Web|Video|,Curated Web,USA,NY,New York City,New York,17/10/2013,2013-10,2013-Q4,2013,,USD
/organization/fluff-friends,(fluff)Friends,,,,,,,/organization/social-gaming-network,SGN (Social Gaming Network),|Social Media|Games|,Games,USA,CA,Los Angeles,Beverly Hills,16/09/2008,2008-09,2008-Q3,2008,,USD
/organization/red,(RED),|Nonprofits|,Nonprofits,USA,NY,New York City,New York,/organization/nationstar-mortgage-holdings,Nationstar Mortgage Holdings,|Finance|,Finance,USA,TX,Dallas,Lewisville,0
@jvilledieu
jvilledieu / Investments.csv
Created November 3, 2014 18:00
We can't make this file beautiful and searchable because it's too large.
company_permalink,company_name,company_category_list,company_market,company_country_code,company_state_code,company_region,company_city,investor_permalink,investor_name,investor_category_list,investor_market,investor_country_code,investor_state_code,investor_region,investor_city,funding_round_permalink,funding_round_type,funding_round_code,funded_at,funded_month,funded_quarter,funded_year, raised_amount_usd
/organization/newsela,Newsela,|Education|,Education,USA,NY,New York City,New York,,,,,,,,,/funding-round/410430eccb35a53d483cdd0dc9f2fc8d,venture,A,24/09/2014,2014-09,2014-Q3,2014, 5 956 174
/organization/virtus-data-centres,VIRTUS Data Centres,|Software|,Software,GBR,,London,London,,,,,,,,,/funding-round/f7af4ec8bf735c375262ea349a028c8d,private_equity,,17/09/2014,2014-09,2014-Q3,2014, 81 216 295
/organization/chobolabs,CHOBOLABS,|Mobile Games|,Mobile Games,USA,CA,SF Bay Area,Palo Alto,,,,,,,,,/funding-round/bb93fc583b2ce8af17b1ca14c8a8151d,seed,,16/09/2014,2014-09,2014-Q3,2014, 1 300 000
/organization
@jvilledieu
jvilledieu / Rounds.csv
Created November 3, 2014 18:04
We can't make this file beautiful and searchable because it's too large.
company_permalink,company_name,company_category_list,company_market,company_country_code,company_state_code,company_region,company_city,funding_round_permalink,funding_round_type,funding_round_code,funded_at,funded_month, funded_quarter ,funded_year, raised_amount_usd
/organization/waywire,#waywire,|Entertainment|Politics|Social Media|News|,News,USA,NY,New York City,New York,/funding-round/cc409188fa2b63482bd9008f682c2efa,seed,,30/06/2012,2012-06, 2012-Q2 ,2012, 1 750 000
/organization/tv-communications,&TV Communications,|Games|,Games,USA,CA,Los Angeles,Los Angeles,/funding-round/86d22afc65107b6941e6c43c671ecbb8,undisclosed,,04/06/2010,2010-06, 2010-Q2 ,2010, 1 000 000
/organization/tv-communications,&TV Communications,|Games|,Games,USA,CA,Los Angeles,Los Angeles,/funding-round/59a3669a64e39360c2b939300bcda162,undisclosed,,23/09/2010,2010-09, 2010-Q3 ,2010, 3 000 000
/organization/rock-your-paper,'Rock' Your Paper,|Publishing|Education|,Publishing,EST,,Tallinn,Tallinn,/funding-round/f06b420775f7cb6c1541a
@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 / Analysing Crunchbase
Last active August 29, 2015 14:08
Cypher queries for Crunchbase. This is used to create analyse Crunch via Neo4j (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/
//What is the biggest startup scene?
MATCH (a:CITY)<-[:HAS_CITY]-(b:COMPANY)
RETURN a.name as city, count(b) as score
ORDER BY score DESC
LIMIT 5
//What is the market positioning of startups in San Francisco
MATCH (a:CITY {name:'San Francisco'})<-[:HAS_CITY]-(b:COMPANY)
WITH b
MATCH b-[:HAS_MARKET]->(c:MARKET)
@jvilledieu
jvilledieu / dummy_call_records_analysis
Created December 1, 2014 15:56
Dummy dataset of call records
ID,FULL_NAME,FIRST_NAME,LAST_NAME,CALLING_NBR,CALLED_NBR,START_DATE,END_DATE,DURATION,CITY,STATE,ADDRESS,CELL_TOWER
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-
@jvilledieu
jvilledieu / Create_Crunchbase_demo.cql
Last active August 29, 2015 14:11
//Importing the file Companies.csv
//Creating the constraints
create constraint on (a:COMPANY) assert a.permalink is unique;
create constraint on (e:CITY) assert e.name is unique;
//Creating the companies & Cities
USING PERIODIC COMMIT 2000
LOAD CSV WITH HEADERS FROM "file:c:/Companies.csv" AS line
FIELDTERMINATOR ';'
@jvilledieu
jvilledieu / Call_records_data_import
Last active November 12, 2018 17:53
Data importation script for call records analysis article
//Setup initial constraints
CREATE CONSTRAINT ON (a:PERSON) assert a.number is unique;
CREATE CONSTRAINT ON (b:CALL) assert b.id is unique;
CREATE CONSTRAINT ON (c:LOCATION) assert c.cell_tower is unique;
CREATE CONSTRAINT ON (d:STATE) assert d.name is unique;
CREATE CONSTRAINT ON (e:CITY) assert e.name is unique;
//Create the appropriate nodes
USING PERIODIC COMMIT 1000
LOAD CSV WITH HEADERS FROM "file:c:/Users/Jean/Downloads/call_records_dummy.csv" AS line
@jvilledieu
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-(