Difference between revisions of "Crunchbase Data"
Jump to navigation
Jump to search
(→To do) |
|||
| Line 6: | Line 6: | ||
|Has project status=Active | |Has project status=Active | ||
}} | }} | ||
| − | |||
==Files and dbases== | ==Files and dbases== | ||
| Line 30: | Line 29: | ||
==Importing the data== | ==Importing the data== | ||
| + | |||
| + | News is a relationship query parameter | ||
| + | |||
| + | https://api.crunchbase.com/v/3/organizations?user_key=662e263576fe3e4ea5991edfbcfb9883&uuid=1e4f199c-363b-451b-a164-f94571075ee5 | ||
| + | |||
| + | 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 | ||
Revision as of 16:46, 13 June 2017
| 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
