Name: Startup Investments
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Startup Investments

Context

The startup world is flourishing. There are hundreds of new companies being founded each day and venture capital has become a substantial asset class with yearly investments exceeding $100B in the US alone. Crunchbase 2013 Snapshot © 2013 dataset provides a glimpse into this exciting world.

I hope you enjoy and learn while working with the data! 👍

Content

This diverse dataset contains information about the startup ecosystem: organizations, individuals, company news, funding rounds, acquisitions, and IPOs.

There are 11 tables that can be joined using unique IDs (schema to follow). More information about the individual data variables can be found on the Crunchabse Data website (under the API Entities Types section).

No extensive data quality check have been performed yet. The information is available up to December 2013.

While Kaggle contains other datasets focused on startup investments, to the best of my knowledge, this dataset has not yet been published on the platform and is unique.

Acknowledgements

Inspiration

There are multiple avenues for exploration:

EDA of the startup ecosystem.
Tracking and analyzing investment trends over time
Clustering VC funds based on their existing investments.
Predicting which startup will proceed to raise further rounds / will get acquired / will file for an IPO.
Mapping the network of individuals involved in the startup ecosystem.

Tables

Acquisitions

@kaggle.justinas_startup_investments.acquisitions

1.14 MB
9562 rows
12 columns


CREATE TABLE acquisitions (
  "id" BIGINT,
  "acquisition_id" BIGINT,
  "acquiring_object_id" VARCHAR,
  "acquired_object_id" VARCHAR,
  "term_code" VARCHAR,
  "price_amount" DOUBLE,
  "price_currency_code" VARCHAR,
  "acquired_at" TIMESTAMP,
  "source_url" VARCHAR,
  "source_description" VARCHAR,
  "created_at" TIMESTAMP,
  "updated_at" TIMESTAMP
);

Degrees

@kaggle.justinas_startup_investments.degrees

4.07 MB
109610 rows
8 columns


CREATE TABLE degrees (
  "id" BIGINT,
  "object_id" VARCHAR,
  "degree_type" VARCHAR,
  "subject" VARCHAR,
  "institution" VARCHAR,
  "graduated_at" TIMESTAMP,
  "created_at" TIMESTAMP,
  "updated_at" TIMESTAMP
);

Funding Rounds

@kaggle.justinas_startup_investments.funding_rounds

4.98 MB
52928 rows
23 columns


CREATE TABLE funding_rounds (
  "id" BIGINT,
  "funding_round_id" BIGINT,
  "object_id" VARCHAR,
  "funded_at" TIMESTAMP,
  "funding_round_type" VARCHAR,
  "funding_round_code" VARCHAR,
  "raised_amount_usd" DOUBLE,
  "raised_amount" DOUBLE,
  "raised_currency_code" VARCHAR,
  "pre_money_valuation_usd" DOUBLE,
  "pre_money_valuation" DOUBLE,
  "pre_money_currency_code" VARCHAR,
  "post_money_valuation_usd" DOUBLE,
  "post_money_valuation" DOUBLE,
  "post_money_currency_code" VARCHAR,
  "participants" BIGINT,
  "is_first_round" BIGINT,
  "is_last_round" BIGINT,
  "source_url" VARCHAR,
  "source_description" VARCHAR,
  "created_by" VARCHAR,
  "created_at" TIMESTAMP,
  "updated_at" TIMESTAMP
);

Funds

@kaggle.justinas_startup_investments.funds

179.39 KB
1564 rows
11 columns


CREATE TABLE funds (
  "id" BIGINT,
  "fund_id" BIGINT,
  "object_id" VARCHAR,
  "name" VARCHAR,
  "funded_at" TIMESTAMP,
  "raised_amount" DOUBLE,
  "raised_currency_code" VARCHAR,
  "source_url" VARCHAR,
  "source_description" VARCHAR,
  "created_at" TIMESTAMP,
  "updated_at" TIMESTAMP
);

Investments

@kaggle.justinas_startup_investments.investments

1.94 MB
80902 rows
6 columns


CREATE TABLE investments (
  "id" BIGINT,
  "funding_round_id" BIGINT,
  "funded_object_id" VARCHAR,
  "investor_object_id" VARCHAR,
  "created_at" TIMESTAMP,
  "updated_at" TIMESTAMP
);

Ipos

@kaggle.justinas_startup_investments.ipos

90.64 KB
1259 rows
13 columns


CREATE TABLE ipos (
  "id" BIGINT,
  "ipo_id" BIGINT,
  "object_id" VARCHAR,
  "valuation_amount" DOUBLE,
  "valuation_currency_code" VARCHAR,
  "raised_amount" DOUBLE,
  "raised_currency_code" VARCHAR,
  "public_at" TIMESTAMP,
  "stock_symbol" VARCHAR,
  "source_url" VARCHAR,
  "source_description" VARCHAR,
  "created_at" TIMESTAMP,
  "updated_at" TIMESTAMP
);

Milestones

@kaggle.justinas_startup_investments.milestones

5.47 MB
39456 rows
9 columns


CREATE TABLE milestones (
  "id" BIGINT,
  "object_id" VARCHAR,
  "milestone_at" TIMESTAMP,
  "milestone_code" VARCHAR,
  "description" VARCHAR,
  "source_url" VARCHAR,
  "source_description" VARCHAR,
  "created_at" TIMESTAMP,
  "updated_at" TIMESTAMP
);

Objects

@kaggle.justinas_startup_investments.objects

140.76 MB
462651 rows
40 columns


CREATE TABLE objects (
  "id" VARCHAR,
  "entity_type" VARCHAR,
  "entity_id" BIGINT,
  "parent_id" VARCHAR,
  "name" VARCHAR,
  "normalized_name" VARCHAR,
  "permalink" VARCHAR,
  "category_code" VARCHAR,
  "status" VARCHAR,
  "founded_at" TIMESTAMP,
  "closed_at" TIMESTAMP,
  "domain" VARCHAR,
  "homepage_url" VARCHAR,
  "twitter_username" VARCHAR,
  "logo_url" VARCHAR,
  "logo_width" BIGINT,
  "logo_height" BIGINT,
  "short_description" VARCHAR,
  "description" VARCHAR,
  "overview" VARCHAR,
  "tag_list" VARCHAR,
  "country_code" VARCHAR,
  "state_code" VARCHAR,
  "city" VARCHAR,
  "region" VARCHAR,
  "first_investment_at" TIMESTAMP,
  "last_investment_at" TIMESTAMP,
  "investment_rounds" BIGINT,
  "invested_companies" BIGINT,
  "first_funding_at" TIMESTAMP,
  "last_funding_at" TIMESTAMP,
  "funding_rounds" BIGINT,
  "funding_total_usd" DOUBLE,
  "first_milestone_at" TIMESTAMP,
  "last_milestone_at" TIMESTAMP,
  "milestones" BIGINT,
  "relationships" BIGINT,
  "created_by" VARCHAR,
  "created_at" TIMESTAMP,
  "updated_at" TIMESTAMP
);

Offices

@kaggle.justinas_startup_investments.offices

6.2 MB
112718 rows
15 columns


CREATE TABLE offices (
  "id" BIGINT,
  "object_id" VARCHAR,
  "office_id" BIGINT,
  "description" VARCHAR,
  "region" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "city" VARCHAR,
  "zip_code" VARCHAR,
  "state_code" VARCHAR,
  "country_code" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "created_at" VARCHAR,
  "updated_at" VARCHAR
);

People

@kaggle.justinas_startup_investments.people

5.09 MB
226709 rows
6 columns


CREATE TABLE people (
  "id" BIGINT,
  "object_id" VARCHAR,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "birthplace" VARCHAR,
  "affiliation_name" VARCHAR
);

Relationships

@kaggle.justinas_startup_investments.relationships

15.2 MB
402878 rows
11 columns


CREATE TABLE relationships (
  "id" BIGINT,
  "relationship_id" BIGINT,
  "person_object_id" VARCHAR,
  "relationship_object_id" VARCHAR,
  "start_at" TIMESTAMP,
  "end_at" TIMESTAMP,
  "is_past" BIGINT,
  "sequence" BIGINT,
  "title" VARCHAR,
  "created_at" TIMESTAMP,
  "updated_at" TIMESTAMP
);