Dataset: Dragons' Den UK Dataset

About this Dataset

Dragons' Den UK Dataset

Dragons' Den dataset of UK/British TV programm, business reality television series.
Currently, the data set has information from United Kingdom Dragons' Den series 1 to series 21. The dataset has 56 fields and 1438 rows.

Season Number - Season number
Episode Number - Episode number within the season
Startup Name - Company name or product name, at the time of pitch
Pitch Number - Overall pitch number
Season Start - Season first aired date
Season End - Season last aired date
Original Air Date - Episode original/first aired date, on OTT/TV
Industry - Industry name or type
Business Description - Business Description
Company Website - Website of startup/company
UK Viewership - Viewership in UK, TRP rating, in millions
Channel Name - Channel or network name
Pitchers Gender - Gender of pitchers
Pitchers Average Age - Average age of all pitchers, <30 young, 30-50 middle, >50 old
Pitchers City - UK city of pitchers or place where company head office exists
Pitchers State - UK state or country of pitchers where company head office exists
Entrepreneur Names - Pitcher names
Multiple Entrepreneurs - Multiple entrepreneurs are present ? 1-yes, 0-no
Original Ask Amount - Original Ask Amount, in GBP
Original Offered Equity - Original Offered Equity, in percentages
Valuation Requested - Valuation Requested, in GBP
Received Offer - Received offer or not, 1-received, 0-not received
Accepted Offer - Accepted offer or not, 1-accepted, 0-rejected
Deal Successful - Deal Successful/materialized or not, 1-yes, 0-no
Total Deal Amount - Total Deal Amount, in GBP, including debt/loan amount
Total Deal Equity - Total Deal Equity, in percentages
Deal Valuation - Deal Valuation, in GBP
Number of Dragons in Deal - Number of Dragons in deal
Investment Amount Per Dragon - Investment Amount Per Dragon
Equity Per Dragon - Equity received by each Dragon
Royalty Deal - Is it royalty deal or not (1-yes)
Advisory Shares Equity - Deal with Advisory shares or equity, in percentages
Loan - Loan/debt (line of credit) amount given by Dragons, in GBP
Deal Has Conditions - Deal has conditions or not? (yes or no)
Peter Jones Investment Amount - Amount Invested by Peter Jones
Peter Jones Investment Equity - Equity received by Peter Jones
Deborah Meaden Investment Amount - Amount Invested by Deborah Meaden
Deborah Meaden Investment Equity - Equity received by Deborah Meaden
Duncan Bannatyne Investment Amount - Amount Invested by Duncan Bannatyne
Duncan Bannatyne Investment Equity - Equity received by Duncan Bannatyne
Theo Paphitis Investment Amount - Amount Invested by Theo Paphitis
Theo Paphitis Investment Equity - Equity received by Theo Paphitis
Touker Suleyman Investment Amount - Amount Invested by Touker Suleyman
Touker Suleyman Investment Equity - Equity received by Touker Suleyman
Sara Davies Investment Amount - Amount Invested by Sara Davies
Sara Davies Investment Equity - Equity received by Sara Davies
Guest Investment Amount - Amount Invested by Guests
Guest Investment Equity - Equity received by Guests
Invested Guest Name - Name of Guest Dragon(s), if invested in deal
Peter Jones Present - Whether Peter Jones present in episode or not
Deborah Meaden Present - Whether Deborah Meaden present in episode or not
Duncan Bannatyne Present - Whether Duncan Bannatyne present in episode or not
Theo Paphitis Present - Whether Theo Paphitis present in episode or not
Touker Suleyman Present - Whether Touker Suleyman present in episode or not
Sara Davies Present - Whether Sara Davies present in episode or not
Guest Present - Whether Guest(s) present in episode or not

Tables

Dragons Den Uk Dataset

@kaggle.thirumani_dragons_den_uk_dataset.dragons_den_uk_dataset

149.38 KB
1438 rows
56 columns


CREATE TABLE dragons_den_uk_dataset (
  "season_number" BIGINT,
  "episode_number" BIGINT,
  "startup_name" VARCHAR,
  "pitch_number" BIGINT,
  "season_start" VARCHAR,
  "season_end" VARCHAR,
  "original_air_date" VARCHAR,
  "industry" VARCHAR,
  "business_description" VARCHAR,
  "company_website" VARCHAR,
  "uk_viewership" DOUBLE,
  "channel_name" VARCHAR,
  "pitchers_gender" VARCHAR,
  "pitchers_average_age" VARCHAR,
  "pitchers_city" VARCHAR,
  "pitchers_state" VARCHAR,
  "entrepreneur_names" VARCHAR,
  "multiple_entrepreneurs" BIGINT,
  "original_ask_amount" DOUBLE,
  "original_offered_equity" DOUBLE,
  "valuation_requested" DOUBLE,
  "received_offer" BIGINT,
  "accepted_offer" DOUBLE,
  "deal_successful" DOUBLE,
  "total_deal_amount" DOUBLE,
  "total_deal_equity" DOUBLE,
  "deal_valuation" DOUBLE,
  "number_of_dragons_in_deal" DOUBLE,
  "investment_amount_per_dragon" DOUBLE,
  "equity_per_dragon" DOUBLE,
  "royalty_deal" VARCHAR,
  "advisory_shares_equity" DOUBLE,
  "loan" VARCHAR,
  "deal_has_conditions" VARCHAR,
  "peter_jones_investment_amount" DOUBLE,
  "peter_jones_investment_equity" DOUBLE,
  "deborah_meaden_investment_amount" DOUBLE,
  "deborah_meaden_investment_equity" DOUBLE,
  "duncan_bannatyne_investment_amount" DOUBLE,
  "duncan_bannatyne_investment_equity" DOUBLE,
  "theo_paphitis_investment_amount" DOUBLE,
  "theo_paphitis_investment_equity" DOUBLE,
  "touker_suleyman_investment_amount" DOUBLE,
  "touker_suleyman_investment_equity" DOUBLE,
  "sara_davies_investment_amount" DOUBLE,
  "sara_davies_investment_equity" DOUBLE,
  "guest_investment_amount" DOUBLE,
  "guest_investment_equity" DOUBLE,
  "invested_guest_name" VARCHAR,
  "peter_jones_present" DOUBLE,
  "deborah_meaden_present" DOUBLE,
  "duncan_bannatyne_present" DOUBLE,
  "theo_paphitis_present" DOUBLE,
  "touker_suleyman_present" DOUBLE,
  "sara_davies_present" DOUBLE,
  "guest_present" DOUBLE
);