Difference between revisions of "Crunchbase Database"
Jump to navigation
Jump to search
| Line 27: | Line 27: | ||
==Getting and cleaning data== | ==Getting and cleaning data== | ||
The url to make API calls is https://api.crunchbase.com/v3.1/csv_export/csv_export.tar.gz?user_key=[API KEY GOES HERE] | The url to make API calls is https://api.crunchbase.com/v3.1/csv_export/csv_export.tar.gz?user_key=[API KEY GOES HERE] | ||
| + | |||
| + | API key (premium) is located at E:\projects\crunchbase3 | ||
The command line (bash script) to get the data and extract the data (1.9gb) is at E:\projects\crunchbase3\get_data.sh | The command line (bash script) to get the data and extract the data (1.9gb) is at E:\projects\crunchbase3\get_data.sh | ||
| + | |||
| + | Alternatively, we can download and extract directly using windows command prompt by typing the following commands | ||
| + | |||
| + | curl -O https://api.crunchbase.com/v3.1/csv_export/csv_export.tar.gz?user_key=[API key goes here] \ | ||
| + | |||
| + | tar -xvf csv_export.tar.gz_user_key=[API key goes here]. | ||
Revision as of 14:35, 21 March 2019
| Crunchbase Database | |
|---|---|
| Project Information | |
| Has title | Crunchbase Database |
| Has owner | Hiep Nguyen |
| Has start date | 2019/03/13 |
| Has deadline date | 2019/03/22 |
| Has project status | Active |
| Dependent(s): | Ecosystem Organization Classifier, Incubator Seed Data |
| Copyright © 2019 edegan.com. All Rights Reserved. | |
Files and Dbase
Files are in:
- E:\projects\crunchbase3
- Z:\crunchbase3
Dbase is crunchbase3
The old project page is Crunchbase Data. File locations listed as Z:/bulk/ should now be Z:/bulk/mcnair/. For example there is an old loadscript in /bulk/mcnair/crunchbase/crunchbaseData/load_crunchbase.sql
Crunchbase Pro
https://www.crunchbase.com/login
Login details:
- mcnair@rice.edu getpasswordfromed
Getting and cleaning data
The url to make API calls is https://api.crunchbase.com/v3.1/csv_export/csv_export.tar.gz?user_key=[API KEY GOES HERE]
API key (premium) is located at E:\projects\crunchbase3
The command line (bash script) to get the data and extract the data (1.9gb) is at E:\projects\crunchbase3\get_data.sh
Alternatively, we can download and extract directly using windows command prompt by typing the following commands
curl -O https://api.crunchbase.com/v3.1/csv_export/csv_export.tar.gz?user_key=[API key goes here] \ tar -xvf csv_export.tar.gz_user_key=[API key goes here].
