home / fivethirtyeight

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

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
1 100 Grand 1 0 1 0 0 1 0 1 0 0.73199999 0.86000001 66.971725
2 3 Musketeers 1 0 0 0 1 0 0 1 0 0.60399997 0.51099998 67.602936
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
5 Air Heads 0 1 0 0 0 0 0 0 0 0.90600002 0.51099998 52.341465
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
8 Boston Baked Beans 0 0 0 1 0 0 0 0 1 0.31299999 0.51099998 23.417824
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
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
13 Chiclets 0 1 0 0 0 0 0 0 1 0.046 0.32499999 24.524988
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
16 Fruit Chews 0 1 0 0 0 0 0 0 1 0.127 0.034000002 43.088924
17 Fun Dip 0 1 0 0 0 0 1 0 0 0.73199999 0.32499999 39.185505
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
23 HersheyÕs Kisses 1 0 0 0 0 0 0 0 1 0.127 0.093000002 55.375454000000005
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
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
30 Laffy Taffy 0 1 0 0 0 0 0 0 0 0.22 0.11599999999999999 41.389557
31 Lemonhead 0 1 0 0 0 0 1 0 0 0.046 0.10400000000000001 39.141056
32 Lifesavers big ring gummies 0 1 0 0 0 0 0 0 0 0.26699999 0.27900001 52.911392000000006
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
35 Mike & Ike 0 1 0 0 0 0 0 0 1 0.87199998 0.32499999 46.411716
36 Milk Duds 1 0 1 0 0 0 0 0 1 0.30199999 0.51099998 55.064071999999996
37 Milky Way 1 0 1 0 1 0 0 1 0 0.60399997 0.65100002 73.099556
38 Milky Way Midnight 1 0 1 0 1 0 0 1 0 0.73199999 0.44100001 60.800701000000004
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
41 Mr Good Bar 1 0 0 1 0 0 0 1 0 0.31299999 0.91799998 54.526451
42 Nerds 0 1 0 0 0 0 1 0 1 0.84799999 0.32499999 55.354046
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
45 Nik L Nip 0 1 0 0 0 0 0 0 1 0.19699999999999998 0.97600001 22.445341
46 Now & Later 0 1 0 0 0 0 0 0 1 0.22 0.32499999 39.4468
47 Payday 0 0 0 1 1 0 0 1 0 0.465 0.76700002 46.296597
48 Peanut M&Ms 1 0 0 1 0 0 0 0 1 0.59299999 0.65100002 69.483788
49 Pixie Sticks 0 0 0 0 0 0 0 0 1 0.093000002 0.023 37.722336
50 Pop Rocks 0 1 0 0 0 0 1 0 1 0.60399997 0.83700001 41.265511
51 Red vines 0 1 0 0 0 0 0 0 1 0.58099997 0.11599999999999999 37.348521999999996
52 ReeseÕs Miniatures 1 0 0 1 0 0 0 0 0 0.034000002 0.27900001 81.86625699999999
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
56 Ring pop 0 1 0 0 0 0 1 0 0 0.73199999 0.96499997 35.290756
57 Rolo 1 0 1 0 0 0 0 0 1 0.86000001 0.86000001 65.716286
58 Root Beer Barrels 0 0 0 0 0 0 1 0 1 0.73199999 0.06899999799999999 29.703691
59 Runts 0 1 0 0 0 0 1 0 1 0.87199998 0.27900001 42.849144
60 Sixlets 1 0 0 0 0 0 0 0 1 0.22 0.081 34.722
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
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
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
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
69 Starburst 0 1 0 0 0 0 0 0 1 0.15099999 0.22 67.037628
70 Strawberry bon bons 0 1 0 0 0 0 1 0 1 0.56900001 0.057999998 34.578990999999995
71 Sugar Babies 0 0 1 0 0 0 0 0 1 0.96499997 0.76700002 33.43755
72 Sugar Daddy 0 0 1 0 0 0 0 0 0 0.41800001 0.32499999 32.230995
73 Super Bubble 0 1 0 0 0 0 0 0 0 0.162 0.11599999999999999 27.303865000000002
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
76 Tootsie Roll Juniors 1 0 0 0 0 0 0 0 0 0.31299999 0.51099998 43.068897
77 Tootsie Roll Midgies 1 0 0 0 0 0 0 0 1 0.17399999 0.011000000000000001 45.736748
78 Tootsie Roll Snack Bars 1 0 0 0 0 0 0 1 0 0.465 0.32499999 49.653503
79 Trolli Sour Bites 0 1 0 0 0 0 0 0 1 0.31299999 0.255 47.173229
80 Twix 1 0 1 0 0 1 0 1 0 0.546 0.90600002 81.642914
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
83 WelchÕs Fruit Snacks 0 1 0 0 0 0 0 0 1 0.31299999 0.31299999 44.375519
84 WertherÕs Original Caramel 0 0 1 0 0 0 1 0 0 0.18600000000000003 0.26699999 41.904308
85 Whoppers 1 0 0 0 0 1 0 0 1 0.87199998 0.84799999 49.524113

Advanced export

JSON shape: default, array

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