108
edits
Changes
Jump to navigation
Jump to search
no edit summary
|Has project status=Complete
}}
==New Work== ===Files=== E:\McNair\Projects\Crunchbase Using the key INSERT HERE Go to WHERE Download*What*What else ==Old Notes from previous work== ===Files and dbases===
The dbase is:
Z:\Crunchbase\CrunchbaseData
===To do===
#Download the data
#Extract top 5 lines
Where, what, etc.
===Importing the data===
To import the data make sure that all 22 crunchbase csv files are on the db server in /bulk/crunchbase/crunchbaseData. Also make sure that the load_crunchbase.sql script is in this directory. Run psql crunchbasebulk to start the db from this directory. Run the command "\i load_crunchbase.sql" to run the script. This will load the contents of the 22 csv files into the db. Check that the number of lines copied into each table matches the actual lines in the csv file. The line numbers have been included in the comments of the load_crunchbase.sql script. See issues section for unexpected results.
Same thing for people - people end point then permalink
===Accelerator Founders Data===
The Crunchbase API can be used to readily access Founders Data. The API is used in the web format: https://api.crunchbase.com/v/3/organizations/company_name/?user_key=662e263576fe3e4ea5991edfbcfb9883, to get a JSON object with alot of data.
E:\McNair\Projects\Accelerators\founders_linkedin.txt
===Funded by Accelerators===
Ben Baldazo : I used this database and coded in "Z:\bulk\crunchbase\AccFunding.psql" to create a table connecting accelerators (just names) from [[Accelerator Seed List (Data)]] to companies that include the acclerator as an investor. Table was joined using uuids and contains names, domains, some dates (founding), and funding amounts & each column has a suffix that labels what the data regards to (a.k.a. what table it came from)
*More notation and the coding is available in "Z:\bulk\crunchbase\AccFunding.psql"
