Dataset: Technology Mergers & Acquisitions

About this Dataset

Technology Mergers & Acquisitions

These four .CSV contain data from CruchBase on 36 Tech Giants: Adobe, Amazon, AOL, Apple, AT&T, BlackBerry, CA Technologies, Cisco Systems, Comcast, Dell, Dropbox, eBay, EMC , Facebook, Google, HP, IBM, Intel, Juniper Networks, LinkedIn, Microsoft, Nokia, Oracle, Pinterest, Qualcomm, Salesforce, Samsung Electronics, SanDisk, SAP, Sony, Symantec, Teradata, Twitter, Verizon Communications, Vodafone,Yahoo

Their data contained in each .CSV is:

Acquiring Companies.csv Information on the 36 Tech Giants:

CrunchBase Profile
Image
Tagline
Market Categories
Year Founded
IPO
Founders
Number of Employees
Number of Employees (year of last update)
Total Funding ($)
Number of Acquisitions
Board Members
Address (HQ)
City (HQ)
State / Region (HQ)
Country (HQ)
Description
Homepage
Twitter
Acquired Companies
Acquisitions ID
API

Acquired Companies.csv: Information on the 1610 companies acquired by these tech giants. Variables include:

CrunchBase Profile
Image
Tagline
Market Categories
Year Founded
Address (HQ)
City (HQ)
State / Region (HQ)
Country (HQ)
Description
Homepage
Twitter
Acquisitions ID
API

Acquisitions.csv Contains the Acquisitions ID for 1643 transactions. the ID can be used to create referential database with other .CSV who have this column. Other variables are:

Acquired Company
Acquiring Company
Year of acquisition announcement
Deal announced on
Price
Status
Terms
Acquisition Profile
News
News Link

Founders and Board Members.csv Data on the founders of the 36 tech giants and on who sits in their board. Variables are:

Name
CrunchBase Profile
Role
Companies
Image

Tables

Acquired Tech Companies

@kaggle.joebeachcapital_technology_mergers_and_acquisitions.acquired_tech_companies

744.58 KB
1610 rows
16 columns


CREATE TABLE acquired_tech_companies (
  "company" VARCHAR,
  "crunchbase_profile" VARCHAR,
  "image" VARCHAR,
  "tagline" VARCHAR,
  "year_founded" DOUBLE,
  "market_categories" VARCHAR,
  "address_hq" VARCHAR,
  "city_hq" VARCHAR,
  "state_region_hq" VARCHAR,
  "country_hq" VARCHAR,
  "description" VARCHAR,
  "homepage" VARCHAR,
  "twitter" VARCHAR,
  "acquired_by" VARCHAR,
  "acquisitions_id" VARCHAR,
  "api" VARCHAR
);

Acquiring Tech Companies

@kaggle.joebeachcapital_technology_mergers_and_acquisitions.acquiring_tech_companies

114.83 KB
36 rows
23 columns


CREATE TABLE acquiring_tech_companies (
  "acquiring_company" VARCHAR,
  "crunchbase_profile" VARCHAR,
  "image" VARCHAR,
  "tagline" VARCHAR,
  "market_categories" VARCHAR,
  "year_founded" BIGINT,
  "ipo" VARCHAR,
  "founders" VARCHAR,
  "number_of_employees" DOUBLE,
  "number_of_employees_year_of_last_update" DOUBLE,
  "total_funding" BIGINT,
  "number_of_acquisitions" BIGINT,
  "board_members" VARCHAR,
  "address_hq" VARCHAR,
  "city_hq" VARCHAR,
  "state_region_hq" VARCHAR,
  "country_hq" VARCHAR,
  "description" VARCHAR,
  "homepage" VARCHAR,
  "twitter" VARCHAR,
  "acquired_companies" VARCHAR,
  "acquisitions_id" VARCHAR,
  "api" VARCHAR
);

Acquisitions

@kaggle.joebeachcapital_technology_mergers_and_acquisitions.acquisitions

237.45 KB
1643 rows
11 columns


CREATE TABLE acquisitions (
  "acquisitions_id" VARCHAR,
  "acquired_company" VARCHAR,
  "acquiring_company" VARCHAR,
  "year_of_acquisition_announcement" BIGINT,
  "deal_announced_on" VARCHAR,
  "price" VARCHAR,
  "status" VARCHAR,
  "terms" VARCHAR,
  "acquisition_profile" VARCHAR,
  "news" VARCHAR,
  "news_link" VARCHAR
);

Founders And Board Members

@kaggle.joebeachcapital_technology_mergers_and_acquisitions.founders_and_board_members

31.55 KB
382 rows
5 columns


CREATE TABLE founders_and_board_members (
  "name" VARCHAR,
  "crunchbase_profile" VARCHAR,
  "role" VARCHAR,
  "companies" VARCHAR,
  "image" VARCHAR
);