Difference between revisions of "Crunchbase Data"
Jump to navigation
Jump to search
(→To do) |
|||
| Line 21: | Line 21: | ||
#Import the data | #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. | 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. | ||
| + | Issue importing organizations.csv. Line count is 515496 but on import got 515491. Last 4 lines in file are chinese characters which might affect import. | ||
==Downloading the data== | ==Downloading the data== | ||
Revision as of 16:57, 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. Issue importing organizations.csv. Line count is 515496 but on import got 515491. Last 4 lines in file are chinese characters which might affect import.
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
