Jean Villedieu 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.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ Acquisitions.csv
Created
November 3, 2014 17:29
We can't make this file beautiful and searchable because it's too large.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ Investments.csv
Created
November 3, 2014 18:00
We can't make this file beautiful and searchable because it's too large.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ Rounds.csv
Created
November 3, 2014 18:04
We can't make this file beautiful and searchable because it's too large.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ 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/
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //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
/ 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/
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //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
/ dummy_call_records_analysis
Created
December 1, 2014 15:56
Dummy dataset of call records
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ Create_Crunchbase_demo.cql
Last active
August 29, 2015 14:11
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //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
/ Call_records_data_import
Last active
November 12, 2018 17:53
Data importation script for call records analysis article
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //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
/ Call_records_dummy
Created
January 12, 2015 10:12
Dummy dataset for call records analysis article.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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-( |