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 sugarpercent

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
3 One dime 0 0 0 0 0 0 0 0 0 0.011000000000000001 0.11599999999999999 32.261086
4 One quarter 0 0 0 0 0 0 0 0 0 0.011000000000000001 0.51099998 46.116505
52 ReeseÕs Miniatures 1 0 0 1 0 0 0 0 0 0.034000002 0.27900001 81.86625699999999
13 Chiclets 0 1 0 0 0 0 0 0 1 0.046 0.32499999 24.524988
31 Lemonhead 0 1 0 0 0 0 1 0 0 0.046 0.10400000000000001 39.141056
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
27 Jawbusters 0 1 0 0 0 0 1 0 1 0.093000002 0.51099998 28.127439000000003
49 Pixie Sticks 0 0 0 0 0 0 0 0 1 0.093000002 0.023 37.722336
82 Warheads 0 1 0 0 0 0 1 0 0 0.093000002 0.11599999999999999 39.011897999999995
16 Fruit Chews 0 1 0 0 0 0 0 0 1 0.127 0.034000002 43.088924
23 HersheyÕs Kisses 1 0 0 0 0 0 0 0 1 0.127 0.093000002 55.375454000000005
69 Starburst 0 1 0 0 0 0 0 0 1 0.15099999 0.22 67.037628
73 Super Bubble 0 1 0 0 0 0 0 0 0 0.162 0.11599999999999999 27.303865000000002
77 Tootsie Roll Midgies 1 0 0 0 0 0 0 0 1 0.17399999 0.011000000000000001 45.736748
84 WertherÕs Original Caramel 0 0 1 0 0 0 1 0 0 0.18600000000000003 0.26699999 41.904308
28 Junior Mints 1 0 0 0 0 0 0 0 1 0.19699999999999998 0.51099998 57.21925
45 Nik L Nip 0 1 0 0 0 0 0 0 1 0.19699999999999998 0.97600001 22.445341
30 Laffy Taffy 0 1 0 0 0 0 0 0 0 0.22 0.11599999999999999 41.389557
46 Now & Later 0 1 0 0 0 0 0 0 1 0.22 0.32499999 39.4468
60 Sixlets 1 0 0 0 0 0 0 0 1 0.22 0.081 34.722
81 Twizzlers 0 1 0 0 0 0 0 0 0 0.22 0.11599999999999999 45.466282
32 Lifesavers big ring gummies 0 1 0 0 0 0 0 0 0 0.26699999 0.27900001 52.911392000000006
63 Nestle Smarties 1 0 0 0 0 0 0 0 1 0.26699999 0.97600001 37.887188
64 Smarties candy 0 1 0 0 0 0 1 0 1 0.26699999 0.11599999999999999 45.995827
36 Milk Duds 1 0 1 0 0 0 0 0 1 0.30199999 0.51099998 55.064071999999996
8 Boston Baked Beans 0 0 0 1 0 0 0 0 1 0.31299999 0.51099998 23.417824
29 Kit Kat 1 0 0 0 0 1 0 1 0 0.31299999 0.51099998 76.7686
40 Mounds 1 0 0 0 0 0 0 1 0 0.31299999 0.86000001 47.829754
41 Mr Good Bar 1 0 0 1 0 0 0 1 0 0.31299999 0.91799998 54.526451
44 Nestle Crunch 1 0 0 0 0 1 0 1 0 0.31299999 0.76700002 66.47068
76 Tootsie Roll Juniors 1 0 0 0 0 0 0 0 0 0.31299999 0.51099998 43.068897
79 Trolli Sour Bites 0 1 0 0 0 0 0 0 1 0.31299999 0.255 47.173229
83 WelchÕs Fruit Snacks 0 1 0 0 0 0 0 0 1 0.31299999 0.31299999 44.375519
54 ReeseÕs pieces 1 0 0 1 0 0 0 0 1 0.40599999 0.65100002 73.43499
72 Sugar Daddy 0 0 1 0 0 0 0 0 0 0.41800001 0.32499999 32.230995
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
6 Almond Joy 1 0 0 1 0 0 0 1 0 0.465 0.76700002 50.347546
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
47 Payday 0 0 0 1 1 0 0 1 0 0.465 0.76700002 46.296597
78 Tootsie Roll Snack Bars 1 0 0 0 0 0 0 1 0 0.465 0.32499999 49.653503
65 Snickers 1 0 1 1 1 0 0 1 0 0.546 0.65100002 76.67378199999999
80 Twix 1 0 1 0 0 1 0 1 0 0.546 0.90600002 81.642914
70 Strawberry bon bons 0 1 0 0 0 0 1 0 1 0.56900001 0.057999998 34.578990999999995
51 Red vines 0 1 0 0 0 0 0 0 1 0.58099997 0.11599999999999999 37.348521999999996
48 Peanut M&Ms 1 0 0 1 0 0 0 0 1 0.59299999 0.65100002 69.483788
2 3 Musketeers 1 0 0 0 1 0 0 1 0 0.60399997 0.51099998 67.602936
7 Baby Ruth 1 0 1 1 1 0 0 1 0 0.60399997 0.76700002 56.914547
10 Caramel Apple Pops 0 1 1 0 0 0 0 0 0 0.60399997 0.32499999 34.517681
11 Charleston Chew 1 0 0 0 1 0 0 1 0 0.60399997 0.51099998 38.975037
37 Milky Way 1 0 1 0 1 0 0 1 0 0.60399997 0.65100002 73.099556
43 Nestle Butterfinger 1 0 0 1 0 0 0 1 0 0.60399997 0.76700002 70.735641
50 Pop Rocks 0 1 0 0 0 0 1 0 1 0.60399997 0.83700001 41.265511
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
75 Tootsie Pop 1 1 0 0 0 0 1 0 0 0.60399997 0.32499999 48.982651000000004
53 ReeseÕs Peanut Butter cup 1 0 0 1 0 0 0 0 0 0.72000003 0.65100002 84.18029
1 100 Grand 1 0 1 0 0 1 0 1 0 0.73199999 0.86000001 66.971725
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
15 Dum Dums 0 1 0 0 0 0 1 0 0 0.73199999 0.034000002 39.460556
17 Fun Dip 0 1 0 0 0 0 1 0 0 0.73199999 0.32499999 39.185505
38 Milky Way Midnight 1 0 1 0 1 0 0 1 0 0.73199999 0.44100001 60.800701000000004
56 Ring pop 0 1 0 0 0 0 1 0 0 0.73199999 0.96499997 35.290756
58 Root Beer Barrels 0 0 0 0 0 0 1 0 1 0.73199999 0.06899999799999999 29.703691
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
42 Nerds 0 1 0 0 0 0 1 0 1 0.84799999 0.32499999 55.354046
57 Rolo 1 0 1 0 0 0 0 0 1 0.86000001 0.86000001 65.716286
35 Mike & Ike 0 1 0 0 0 0 0 0 1 0.87199998 0.32499999 46.411716
59 Runts 0 1 0 0 0 0 1 0 1 0.87199998 0.27900001 42.849144
85 Whoppers 1 0 0 0 0 1 0 0 1 0.87199998 0.84799999 49.524113
5 Air Heads 0 1 0 0 0 0 0 0 0 0.90600002 0.51099998 52.341465
9 Candy Corn 0 0 0 0 0 0 0 0 1 0.90600002 0.32499999 38.010963000000004
18 Gobstopper 0 1 0 0 0 0 1 0 1 0.90600002 0.45300001 46.783348
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
39 Milky Way Simply Caramel 1 0 1 0 0 0 0 1 0 0.96499997 0.86000001 64.35334
71 Sugar Babies 0 0 1 0 0 0 0 0 1 0.96499997 0.76700002 33.43755
55 ReeseÕs stuffed with pieces 1 0 0 1 0 0 0 0 0 0.98799998 0.65100002 72.887901

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 61.247ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub