241
edits
Changes
Jump to navigation
Jump to search
→Retrieving Incubators from Crunchbase Database
1. Create a file of uuids of incubators (CrunchbaseShortOrgDescChosenByYi.txt and CrunchbaseShortOrgDescChosenByLibby.txt)
File path: Z:\crunchbase3
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=
