241
edits
Changes
Jump to navigation
Jump to search
Ecosystem Organization Classifier (view source)
Revision as of 13:55, 4 April 2019
, 13:55, 4 April 2019→First data
For the first data, we are going to use organization descriptions from Crunchbase. Run this code on '''crunchbase3''' (see [[Crunchbase Database]]):
<nowiki>\COPY (SELECT uuid, company_name, short_description FROM Organizations) TO 'CrunchbaseShortOrgDescs.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV</nowiki>
--744332
<nowiki>\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</nowiki>
--520698
