Difference between revisions of "Crunchbase 2013 Snapshot"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
The files and their contents are | The files and their contents are | ||
| − | crunchbase_2013_snapshot_mysql.tar.gz | + | '''crunchbase_2013_snapshot_mysql.tar.gz''' |
*license.txt 526 | *license.txt 526 | ||
*cb_objects.sql 338955612 | *cb_objects.sql 338955612 | ||
| Line 25: | Line 25: | ||
*cb_funding_rounds.sql 14681705 | *cb_funding_rounds.sql 14681705 | ||
| − | odm.csv.tar.gz | + | '''odm.csv.tar.gz''' |
*organizations.csv 212013301 | *organizations.csv 212013301 | ||
| − | ** | + | **459916 records with the following fields: |
***crunchbase_uuid | ***crunchbase_uuid | ||
***type | ***type | ||
| Line 44: | Line 44: | ||
***location_country_code | ***location_country_code | ||
***short_description | ***short_description | ||
| − | |||
*people.csv 188924229 | *people.csv 188924229 | ||
| − | ** | + | **521634 records with the following fields: |
***crunchbase_uuid | ***crunchbase_uuid | ||
***type | ***type | ||
| Line 62: | Line 61: | ||
***organization | ***organization | ||
***organization_crunchbase_url | ***organization_crunchbase_url | ||
| − | |||
*crunchbase_license.txt 487 | *crunchbase_license.txt 487 | ||
Revision as of 14:36, 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
- 459916 records with the following 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 with the following fields:
- people.csv 188924229
- 521634 records with the following 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 with the following fields:
- crunchbase_license.txt 487
