Shark Tank US Dataset (1274, 48)

Shark Tank US Dataset

@kaggle.suvroo_shark_tank_us_dataset_1274_48

Table List

1 table(146.2 KB)

Shark Tank Us

@kaggle.suvroo_shark_tank_us_dataset_1274_48.shark_tank_us

146.2 KB
1274 rows
48 columns

season_number Season Number	episode_number Episode Number	pitch_number Pitch Number	original_air_date Original Air Date	startup_name Startup Name	industry Industry	business_description Business Description	pitchers_gender Pitchers Gender	pitchers_city Pitchers City	pitchers_state Pitchers State	pitchers_average_age Pitchers Average Age	entrepreneur_names Entrepreneur Names	company_website Company Website	us_viewership US Viewership	original_ask_amount Original Ask Amount	original_offered_equity Original Offered Equity	valuation_requested Valuation Requested	got_deal Got Deal	total_deal_amount Total Deal Amount	total_deal_equity Total Deal Equity	deal_valuation Deal Valuation	number_of_sharks_in_deal Number Of Sharks In Deal	investment_amount_per_shark Investment Amount Per Shark	equity_per_shark Equity Per Shark	royalty_deal Royalty Deal	barbara_corcoran_investment_amount Barbara Corcoran Investment Amount	barbara_corcoran_investment_equity Barbara Corcoran Investment Equity	mark_cuban_investment_amount Mark Cuban Investment Amount	mark_cuban_investment_equity Mark Cuban Investment Equity	robert_herjavec_investment_amount Robert Herjavec Investment Amount	robert_herjavec_investment_equity Robert Herjavec Investment Equity	daymond_john_investment_amount Daymond John Investment Amount	daymond_john_investment_equity Daymond John Investment Equity	kevin_o_leary_investment_amount Kevin O Leary Investment Amount	kevin_o_leary_investment_equity Kevin O Leary Investment Equity	guest_name Guest Name	barbara_corcoran_present Barbara Corcoran Present	robert_herjavec_present Robert Herjavec Present	daymond_john_present Daymond John Present	kevin_o_leary_present Kevin O Leary Present
1	1	1	Sun Aug 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	AvaTheElephant	Health/Wellness	Ava The Elephant - Baby and Child Care	Female	Atlanta	GA	nan	Tiffany Krumins	http://www.avatheelephant.com/	4.15	50000	15	333333	1	50000	55	90909	1	50000	55		50000	55									nan	1	1	1	1
1	1	2	Sun Aug 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Mr.Tod'sPieFactory	Food and Beverage	Mr. Tod's Pie Factory - Specialty Food	Male	Somerset	NJ	nan	Tod Wilson	http://whybake.com/	4.15	460000	10	4600000	1	460000	50	920000	2	230000	25		230000	25					230000	25			nan	1	1	1	1
1	1	3	Sun Aug 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Wispots	Business Services	Wispots - Consumer Services	Male	Cary	NC	nan	Kevin Flannery	http://www.wispots.com/	4.15	1200000	10	12000000																			nan	1	1	1	1
1	1	4	Sun Aug 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	CollegeFoxesPackingBoxes	Lifestyle/Home	College Foxes Packing Boxes - Consumer Services	Male	Tampa	FL	nan	Nick Friedman, Omar Soliman	http://collegehunkshaulingjunk.com/	4.15	250000	25	1000000																			nan	1	1	1	1
1	1	5	Sun Aug 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	IonicEar	Software/Tech	Ionic Ear - Novelties	Male	St. Paul	MN	nan	Darrin Johnson	nan	4.15	1000000	15	6666667																			nan	1	1	1	1
1	2	6	Sun Aug 16 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	APerfectPear	Food and Beverage	A Perfect Pear - Specialty Food	Female	Napa Valley	CA	nan	Susan Knapp	http://www.aperfectpear.com	5.59	500000	15	3333333	1	500000	50	1000000	2	250000	25						250000	25			250000	25	nan	1	1	1	1
1	2	7	Sun Aug 16 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	ClassroomJams	Children/Education	Classroom Jams - Education	Male	Chicago	IL	nan	Mark Furigay	http://www.attachnoted.com/	5.59	250000	10	2500000	1	250000	100	250000	5	50000	20	1	50000	20	50000	20	50000	20	50000	20	50000	20	nan	1	1	1	1
1	2	8	Sun Aug 16 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Lifebelt	Automotive	Lifebelt - Automotive	Male	Las Vegas	NV	nan	Robert Alison	nan	5.59	500000	10	5000000																			nan	1	1	1	1
1	2	9	Sun Aug 16 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	CrookedJaw	Fashion/Beauty	Crooked Jaw - Men and Women's Apparel	Male	Hollywood	CA	nan	Craig French	http://crookedjawfashions.com/	5.59	200000	20	1000000																			nan	1	1	1	1
1	2	10	Sun Aug 16 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	StickyNoteHolder	Lifestyle/Home	Sticky Note Holder - Productivity Tools	Female	Gardena	CA	nan	Mary Ellen Simonson	nan	5.59	100000	20	500000																			nan	1	1	1	1


CREATE TABLE shark_tank_us (
  "season_number" BIGINT,
  "episode_number" BIGINT,
  "pitch_number" BIGINT,
  "original_air_date" TIMESTAMP,
  "startup_name" VARCHAR,
  "industry" VARCHAR,
  "business_description" VARCHAR,
  "pitchers_gender" VARCHAR,
  "pitchers_city" VARCHAR,
  "pitchers_state" VARCHAR,
  "pitchers_average_age" VARCHAR,
  "entrepreneur_names" VARCHAR,
  "company_website" VARCHAR,
  "multiple_entrepreneurs" DOUBLE,
  "us_viewership" DOUBLE,
  "original_ask_amount" BIGINT,
  "original_offered_equity" DOUBLE,
  "valuation_requested" BIGINT,
  "got_deal" BIGINT,
  "total_deal_amount" DOUBLE,
  "total_deal_equity" DOUBLE,
  "deal_valuation" DOUBLE,
  "number_of_sharks_in_deal" DOUBLE,
  "investment_amount_per_shark" DOUBLE,
  "equity_per_shark" DOUBLE,
  "royalty_deal" DOUBLE,
  "loan" DOUBLE,
  "barbara_corcoran_investment_amount" DOUBLE,
  "barbara_corcoran_investment_equity" DOUBLE,
  "mark_cuban_investment_amount" DOUBLE,
  "mark_cuban_investment_equity" DOUBLE,
  "lori_greiner_investment_amount" DOUBLE,
  "lori_greiner_investment_equity" DOUBLE,
  "robert_herjavec_investment_amount" DOUBLE,
  "robert_herjavec_investment_equity" DOUBLE,
  "daymond_john_investment_amount" DOUBLE,
  "daymond_john_investment_equity" DOUBLE,
  "kevin_o_leary_investment_amount" DOUBLE,
  "kevin_o_leary_investment_equity" DOUBLE,
  "guest_investment_amount" DOUBLE,
  "guest_investment_equity" DOUBLE,
  "guest_name" VARCHAR,
  "barbara_corcoran_present" DOUBLE,
  "mark_cuban_present" DOUBLE,
  "lori_greiner_present" DOUBLE,
  "robert_herjavec_present" DOUBLE,
  "daymond_john_present" DOUBLE,
  "kevin_o_leary_present" DOUBLE
);