Shark Tank Companies

Can you predict which companies gets a deal on Shark Tank?

@kaggle.ulrikthygepedersen_shark_tank_companies

Table List

1 table(118.17 KB)

Shark Tank Companies

@kaggle.ulrikthygepedersen_shark_tank_companies.shark_tank_companies

118.17 KB
495 rows
19 columns

deal Deal	description Description	episode Episode	category Category	entrepreneurs Entrepreneurs	location Location	website Website	askedfor Askedfor	exchangeforstake Exchangeforstake	valuation Valuation	season Season	shark1 Shark1	shark2 Shark2	shark3 Shark3	shark4 Shark4	shark5 Shark5	title Title	episode_season Episode Season
	Bluetooth device implant for your ear.	1	Novelties	Darrin Johnson	St. Paul, MN	nan	1000000	15	6666667	1	Barbara Corcoran	Robert Herjavec	Kevin O'Leary	Daymond John	Kevin Harrington	Ionic Ear	1-1
true	Retail and wholesale pie factory with two retail locations in New Jersey.	1	Specialty Food	Tod Wilson	Somerset, NJ	http://whybake.com/	460000	10	4600000	1	Barbara Corcoran	Robert Herjavec	Kevin O'Leary	Daymond John	Kevin Harrington	Mr. Tod's Pie Factory	1-1
true	Ava the Elephant is a godsend for frazzled parents of young children everywhere. This talking medicine dispenser makes it easy to administer medicine to little ones by turning the experience more playful and by providing positive reinforcement.	1	Baby and Child Care	Tiffany Krumins	Atlanta, GA	http://www.avatheelephant.com/	50000	15	333333	1	Barbara Corcoran	Robert Herjavec	Kevin O'Leary	Daymond John	Kevin Harrington	Ava the Elephant	1-1
	Organizing, packing, and moving services delivered by college women.	1	Consumer Services	Nick Friedman, Omar Soliman	Tampa, FL	http://collegehunkshaulingjunk.com/	250000	25	1000000	1	Barbara Corcoran	Robert Herjavec	Kevin O'Leary	Daymond John	Kevin Harrington	College Foxes Packing Boxes	1-1
	Interactive media centers for healthcare waiting rooms offering patients web access and educational information.	1	Consumer Services	Kevin Flannery	Cary, NC	http://www.wispots.com/	1200000	10	12000000	1	Barbara Corcoran	Robert Herjavec	Kevin O'Leary	Daymond John	Kevin Harrington	Wispots	1-1
true	One of the first entrepreneurs to pitch on Shark Tank, Susan Knapp presented A Perfect Pear, her line of pear-focused gourmet food products. Sold across 650 retail stores, the Perfect Pear product portfolio includes jams, jellies, spreads, tapenades, vinegars, marinades, dressings and many others, a…	2	Specialty Food	Susan Knapp	Napa Valley, CA	http://www.aperfectpear.com	500000	15	3333333	1	Barbara Corcoran	Robert Herjavec	Kevin O'Leary	Daymond John	Kevin Harrington	A Perfect Pear	1-2
	A mixed martial arts clothing line looking to become the next big brand of active sports / streetwear apparel.	2	Men and Women's Apparel	Craig French	Hollywood, CA	http://crookedjawfashions.com/	200000	20	1000000	1	Barbara Corcoran	Robert Herjavec	Kevin O'Leary	Daymond John	Kevin Harrington	Crooked Jaw	1-2
	Attach Noted is a detachable "arm" that holds Post-It notes on the side of a laptop screen.	2	Productivity Tools	Mary Ellen Simonson	Gardena, CA	http://www.attachnoted.com/	100000	20	500000	1	Barbara Corcoran	Robert Herjavec	Kevin O'Leary	Daymond John	Kevin Harrington	Attach Noted	1-2
	A safety device for seatbelts. It prevents the driver from starting the vehicle unless the seatbelt is buckled.	2	Automotive	Robert Alison	Las Vegas, NV	http://www.nobucklenostart.com/	500000	10	5000000	1	Barbara Corcoran	Robert Herjavec	Kevin O'Leary	Daymond John	Kevin Harrington	Lifebelt	1-2
true	An educational record label and publishing house designed to get students into learning about classic works of literature.	2	Education	Mark Furigay	Chicago, IL	nan	250000	10	2500000	1	Barbara Corcoran	Robert Herjavec	Kevin O'Leary	Daymond John	Kevin Harrington	Classroom Jams	1-2


CREATE TABLE shark_tank_companies (
  "deal" BOOLEAN,
  "description" VARCHAR,
  "episode" BIGINT,
  "category" VARCHAR,
  "entrepreneurs" VARCHAR,
  "location" VARCHAR,
  "website" VARCHAR,
  "askedfor" BIGINT,
  "exchangeforstake" BIGINT,
  "valuation" BIGINT,
  "season" BIGINT,
  "shark1" VARCHAR,
  "shark2" VARCHAR,
  "shark3" VARCHAR,
  "shark4" VARCHAR,
  "shark5" VARCHAR,
  "title" VARCHAR,
  "episode_season" VARCHAR,
  "multiple_entreprenuers" BOOLEAN
);