Difference between revisions of "Crunchbase 2013 Snapshot"
Jump to navigation
Jump to search
(Created page with "==Retrieval== The data was retrieved by Shrey and Matthew - STATE HOW AND FROM WHERE ==Content== The snapshot contained 2 .tar.qz files, which were extracted into 181/crunc...") |
(No difference)
|
Revision as of 14:31, 9 March 2017
Retrieval
The data was retrieved by Shrey and Matthew - STATE HOW AND FROM WHERE
Content
The snapshot contained 2 .tar.qz files, which were extracted into 181/crunchbase using the command
tar -zxvf file.tar.gz
The files and their contents are:
- crunchbase_2013_snapshot_mysql.tar.gz
- license.txt 526
- cb_objects.sql 338955612
- cb_offices.sql 14850092
- cb_people.sql 13253952
- cb_ipos.sql 178397
- cb_milestones.sql 10498840
- cb_funds.sql 385010
- cb_relationships.sql 48655529
- cb_degrees.sql 13829471
- cb_investments.sql 6185134
- cb_acquisitions.sql 2309393
- cb_funding_rounds.sql 14681705
- odm.csv.tar.gz
- organizations.csv 212013301
- Fields: crunchbase_uuid,type,primary_role,name,crunchbase_url,homepage_domain,homepage_url,profile_image_url,facebook_url,twitter_url,linkedin_url,stock_symbol,location_city,location_region,location_country_code,short_description
- 459916 records
- people.csv 188924229
- Fields: crunchbase_uuid,type,first_name,last_name,crunchbase_url,profile_image_url,facebook_url,twitter_url,linkedin_url,location_city,location_region,location_country_code,title,organization,organization_crunchbase_url
- 521634 records
- crunchbase_license.txt 487
- organizations.csv 212013301
