7,649
edits
Changes
Jump to navigation
Jump to search
Ecosystem Organization Classifier (view source)
Revision as of 15:15, 30 March 2019
, 15:15, 30 March 2019→First data
For the first data, we are going to use organization descriptions from Crunchbase. Run this code on '''crunchbase3''' (see [[Crunchbase Database]]):
\COPY (SELECT uuid, company_name, short_description FROM Organizations) TO 'CrunchbaseShortOrgDescs.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--744332
\COPY (SELECT A.uuid, A.company_name, B.description FROM Organizations AS A JOIN organization_descriptions AS B on A.uuid=B.uuid) TO 'CrunchbaseLongOrgDescs.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--520698
The resulting files are in Z:\crunchbase3 and copied to E:\projects\crunchbase3.
We can use [[The Matcher (Tool)]] to match organization names to portfolio companies and VC funds and firms taken from '''vcdb3''' (see [[VentureXpert Database]]).
==Related Projects==
