Difference between revisions of "Crunchbase Data"

From edegan.com
Jump to navigation Jump to search
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 17:57, 13 June 2017


McNair Project
Crunchbase Data
Project logo 02.png
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

  1. Download the data
  2. Extract top 5 lines
  3. Build table specs
  4. 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

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