Crunchbase Data
Jump to navigation
Jump to search
Crunchbase Data | |
---|---|
Project Information | |
Project Title | Crunchbase Data |
Owner | Adrian Smart |
Start Date | June 2017 |
Deadline | |
Keywords | Data, Tool, Crunchbase, VC, Angel |
Primary Billing | |
Notes | |
Has project status | Active |
Copyright © 2016 edegan.com. All Rights Reserved. |
Files and dbases
The dbase is:
crunchbasebulk
The files are in:
E:\McNair\Project\... Z:\Crunchbase\CrunchbaseData
To do
- Download the data
- Extract top 5 lines
- Build table specs
- Import the data
Issue importing events.csv. Line count does not match import count. Also typos in data for start_time and end_time which created import errors with time datatype. Switched to varchar.
Downloading the data
Our user key is: 662e263576fe3e4ea5991edfbcfb9883
Where, what, etc.
Importing the data
News is a relationship query parameter
permalink is airbnb in this example:
https://api.crunchbase.com/v/3/organizations/airbnb/news?user_key=662e263576fe3e4ea5991edfbcfb9883
Same thing for people - people end point then permalink