candy-power-ranking/candy-data

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, 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 25.586ms