Candy Power Ranking: candy-data.csv

This table contains the data behind the story The Ultimate Halloween Candy Power Ranking.

candy-data.csv includes attributes for each candy along with its ranking. For binary variables, 1 means yes, 0 means no.

The data contains the following fields:

Header Description
chocolate Does it contain chocolate?
fruity Is it fruit flavored?
caramel Is there caramel in the candy?
peanutalmondy Does it contain peanuts, peanut butter or almonds?
nougat Does it contain nougat?
crispedricewafer Does it contain crisped rice, wafers, or a cookie component?
hard Is it a hard candy?
bar Is it a candy bar?
pluribus Is it one of many candies in a bag or box?
sugarpercent The percentile of sugar it falls under within the data set.
pricepercent The unit price percentile compared to the rest of the set.
winpercent The overall win percentage according to 269,000 matchups.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

85 rows sorted by pricepercent

View and edit SQL

Suggested facets: chocolate, fruity, caramel, peanutyalmondy, nougat, crispedricewafer, hard, bar, pluribus, pricepercent

Link rowid competitorname chocolate fruity caramel peanutyalmondy nougat crispedricewafer hard bar pluribus sugarpercent pricepercent ▼ winpercent
77 Tootsie Roll Midgies 1 0 0 0 0 0 0 0 1 0.17399999 0.011000000000000001 45.736748
49 Pixie Sticks 0 0 0 0 0 0 0 0 1 0.093000002 0.023 37.722336
15 Dum Dums 0 1 0 0 0 0 1 0 0 0.73199999 0.034000002 39.460556
16 Fruit Chews 0 1 0 0 0 0 0 0 1 0.127 0.034000002 43.088924
70 Strawberry bon bons 0 1 0 0 0 0 1 0 1 0.56900001 0.057999998 34.578990999999995
58 Root Beer Barrels 0 0 0 0 0 0 1 0 1 0.73199999 0.06899999799999999 29.703691
60 Sixlets 1 0 0 0 0 0 0 0 1 0.22 0.081 34.722
23 HersheyÕs Kisses 1 0 0 0 0 0 0 0 1 0.127 0.093000002 55.375454000000005
31 Lemonhead 0 1 0 0 0 0 1 0 0 0.046 0.10400000000000001 39.141056
3 One dime 0 0 0 0 0 0 0 0 0 0.011000000000000001 0.11599999999999999 32.261086
30 Laffy Taffy 0 1 0 0 0 0 0 0 0 0.22 0.11599999999999999 41.389557
51 Red vines 0 1 0 0 0 0 0 0 1 0.58099997 0.11599999999999999 37.348521999999996
64 Smarties candy 0 1 0 0 0 0 1 0 1 0.26699999 0.11599999999999999 45.995827
67 Sour Patch Kids 0 1 0 0 0 0 0 0 1 0.06899999799999999 0.11599999999999999 59.863997999999995
68 Sour Patch Tricksters 0 1 0 0 0 0 0 0 1 0.06899999799999999 0.11599999999999999 52.825947
73 Super Bubble 0 1 0 0 0 0 0 0 0 0.162 0.11599999999999999 27.303865000000002
81 Twizzlers 0 1 0 0 0 0 0 0 0 0.22 0.11599999999999999 45.466282
82 Warheads 0 1 0 0 0 0 1 0 0 0.093000002 0.11599999999999999 39.011897999999995
61 Skittles original 0 1 0 0 0 0 0 0 1 0.94099998 0.22 63.08514
62 Skittles wildberry 0 1 0 0 0 0 0 0 1 0.94099998 0.22 55.103694999999995
69 Starburst 0 1 0 0 0 0 0 0 1 0.15099999 0.22 67.037628
79 Trolli Sour Bites 0 1 0 0 0 0 0 0 1 0.31299999 0.255 47.173229
84 WertherÕs Original Caramel 0 0 1 0 0 0 1 0 0 0.18600000000000003 0.26699999 41.904308
32 Lifesavers big ring gummies 0 1 0 0 0 0 0 0 0 0.26699999 0.27900001 52.911392000000006
52 ReeseÕs Miniatures 1 0 0 1 0 0 0 0 0 0.034000002 0.27900001 81.86625699999999
59 Runts 0 1 0 0 0 0 1 0 1 0.87199998 0.27900001 42.849144
83 WelchÕs Fruit Snacks 0 1 0 0 0 0 0 0 1 0.31299999 0.31299999 44.375519
9 Candy Corn 0 0 0 0 0 0 0 0 1 0.90600002 0.32499999 38.010963000000004
10 Caramel Apple Pops 0 1 1 0 0 0 0 0 0 0.60399997 0.32499999 34.517681
13 Chiclets 0 1 0 0 0 0 0 0 1 0.046 0.32499999 24.524988
17 Fun Dip 0 1 0 0 0 0 1 0 0 0.73199999 0.32499999 39.185505
35 Mike & Ike 0 1 0 0 0 0 0 0 1 0.87199998 0.32499999 46.411716
42 Nerds 0 1 0 0 0 0 1 0 1 0.84799999 0.32499999 55.354046
46 Now & Later 0 1 0 0 0 0 0 0 1 0.22 0.32499999 39.4468
72 Sugar Daddy 0 0 1 0 0 0 0 0 0 0.41800001 0.32499999 32.230995
75 Tootsie Pop 1 1 0 0 0 0 1 0 0 0.60399997 0.32499999 48.982651000000004
78 Tootsie Roll Snack Bars 1 0 0 0 0 0 0 1 0 0.465 0.32499999 49.653503
38 Milky Way Midnight 1 0 1 0 1 0 0 1 0 0.73199999 0.44100001 60.800701000000004
18 Gobstopper 0 1 0 0 0 0 1 0 1 0.90600002 0.45300001 46.783348
19 Haribo Gold Bears 0 1 0 0 0 0 0 0 1 0.465 0.465 57.11974
20 Haribo Happy Cola 0 0 0 0 0 0 0 0 1 0.465 0.465 34.158958
21 Haribo Sour Bears 0 1 0 0 0 0 0 0 1 0.465 0.465 51.41243
22 Haribo Twin Snakes 0 1 0 0 0 0 0 0 1 0.465 0.465 42.178771999999995
2 3 Musketeers 1 0 0 0 1 0 0 1 0 0.60399997 0.51099998 67.602936
4 One quarter 0 0 0 0 0 0 0 0 0 0.011000000000000001 0.51099998 46.116505
5 Air Heads 0 1 0 0 0 0 0 0 0 0.90600002 0.51099998 52.341465
8 Boston Baked Beans 0 0 0 1 0 0 0 0 1 0.31299999 0.51099998 23.417824
11 Charleston Chew 1 0 0 0 1 0 0 1 0 0.60399997 0.51099998 38.975037
12 Chewey Lemonhead Fruit Mix 0 1 0 0 0 0 0 0 1 0.73199999 0.51099998 36.017628
14 Dots 0 1 0 0 0 0 0 0 1 0.73199999 0.51099998 42.272076
27 Jawbusters 0 1 0 0 0 0 1 0 1 0.093000002 0.51099998 28.127439000000003
28 Junior Mints 1 0 0 0 0 0 0 0 1 0.19699999999999998 0.51099998 57.21925
29 Kit Kat 1 0 0 0 0 1 0 1 0 0.31299999 0.51099998 76.7686
36 Milk Duds 1 0 1 0 0 0 0 0 1 0.30199999 0.51099998 55.064071999999996
76 Tootsie Roll Juniors 1 0 0 0 0 0 0 0 0 0.31299999 0.51099998 43.068897
33 Peanut butter M&MÕs 1 0 0 1 0 0 0 0 1 0.82499999 0.65100002 71.46505
34 M&MÕs 1 0 0 0 0 0 0 0 1 0.82499999 0.65100002 66.574585
37 Milky Way 1 0 1 0 1 0 0 1 0 0.60399997 0.65100002 73.099556
48 Peanut M&Ms 1 0 0 1 0 0 0 0 1 0.59299999 0.65100002 69.483788
53 ReeseÕs Peanut Butter cup 1 0 0 1 0 0 0 0 0 0.72000003 0.65100002 84.18029
54 ReeseÕs pieces 1 0 0 1 0 0 0 0 1 0.40599999 0.65100002 73.43499
55 ReeseÕs stuffed with pieces 1 0 0 1 0 0 0 0 0 0.98799998 0.65100002 72.887901
65 Snickers 1 0 1 1 1 0 0 1 0 0.546 0.65100002 76.67378199999999
66 Snickers Crisper 1 0 1 1 0 1 0 1 0 0.60399997 0.65100002 59.529251
74 Swedish Fish 0 1 0 0 0 0 0 0 1 0.60399997 0.755 54.861111
6 Almond Joy 1 0 0 1 0 0 0 1 0 0.465 0.76700002 50.347546
7 Baby Ruth 1 0 1 1 1 0 0 1 0 0.60399997 0.76700002 56.914547
43 Nestle Butterfinger 1 0 0 1 0 0 0 1 0 0.60399997 0.76700002 70.735641
44 Nestle Crunch 1 0 0 0 0 1 0 1 0 0.31299999 0.76700002 66.47068
47 Payday 0 0 0 1 1 0 0 1 0 0.465 0.76700002 46.296597
71 Sugar Babies 0 0 1 0 0 0 0 0 1 0.96499997 0.76700002 33.43755
50 Pop Rocks 0 1 0 0 0 0 1 0 1 0.60399997 0.83700001 41.265511
85 Whoppers 1 0 0 0 0 1 0 0 1 0.87199998 0.84799999 49.524113
1 100 Grand 1 0 1 0 0 1 0 1 0 0.73199999 0.86000001 66.971725
39 Milky Way Simply Caramel 1 0 1 0 0 0 0 1 0 0.96499997 0.86000001 64.35334
40 Mounds 1 0 0 0 0 0 0 1 0 0.31299999 0.86000001 47.829754
57 Rolo 1 0 1 0 0 0 0 0 1 0.86000001 0.86000001 65.716286
80 Twix 1 0 1 0 0 1 0 1 0 0.546 0.90600002 81.642914
24 HersheyÕs Krackel 1 0 0 0 0 1 0 1 0 0.43000001 0.91799998 62.28448100000001
25 HersheyÕs Milk Chocolate 1 0 0 0 0 0 0 1 0 0.43000001 0.91799998 56.490501
26 HersheyÕs Special Dark 1 0 0 0 0 0 0 1 0 0.43000001 0.91799998 59.236121999999995
41 Mr Good Bar 1 0 0 1 0 0 0 1 0 0.31299999 0.91799998 54.526451
56 Ring pop 0 1 0 0 0 0 1 0 0 0.73199999 0.96499997 35.290756
45 Nik L Nip 0 1 0 0 0 0 0 0 1 0.19699999999999998 0.97600001 22.445341
63 Nestle Smarties 1 0 0 0 0 0 0 0 1 0.26699999 0.97600001 37.887188

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "candy-power-ranking/candy-data" (
"competitorname" TEXT,
  "chocolate" INTEGER,
  "fruity" INTEGER,
  "caramel" INTEGER,
  "peanutyalmondy" INTEGER,
  "nougat" INTEGER,
  "crispedricewafer" INTEGER,
  "hard" INTEGER,
  "bar" INTEGER,
  "pluribus" INTEGER,
  "sugarpercent" REAL,
  "pricepercent" REAL,
  "winpercent" REAL
);
Powered by Datasette · Query took 55.332ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub