241
edits
Changes
Jump to navigation
Jump to search
(CrunchbaseShortOrgDescChosenByYi.txt and CrunchbaseShortOrgDescChosenByLibby.txt) File path: Z:\crunchbase3
\COPY CREATE TABLE ChosenShortOrgUUIDs FROM 'CrunchbaseShortOrgDescChosenByYi.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV(--275 uuid varchar(100) );
→Retrieving Incubators from Crunchbase Database
1) Create a file of uuids of incubators
2) Load the file into the database
DROP TABLE ChosenShortOrgUUIDs; CREATE TABLE ChosenShortOrgUUIDs ( uuid varchar(100));
\COPY ChosenShortOrgUUIDs FROM 'CrunchbaseShortOrgDescChosenByYi.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--275
DROP TABLE ChosenLongOrgUUIDs;
CREATE TABLE ChosenLongOrgUUIDs ( uuid varchar(100) );
\COPY ChosenShortOrgUUIDs FROM 'CrunchbaseShortOrgDescChosenByLibby.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV --301
3) Run a query that joins uuids with related fields
Fields we are interested in:
company_name, roles, permalink, domain, homepage_url, country_code, state_code, region, city, address, status, short_description, category_list, category_group_list, funding_rounds, funding_total_usd, founded_on, last_funding_on, closed_on, employee_count, email, phone, facebook_url, linkedin_url, cb_url, logo_url, twitter_url, aliases, uuid, created_at, updated_at, primary_role, type
=Useful Regular Exes=
