• Member Since 24th Sep, 2015
  • offline last seen 4 hours ago

Oliver


Let R = { x | x ∉ x }, then R ∈ R ⟺ R ∉ R... or is it?

More Blog Posts343

Mar
25th
2019

Statistics #5.2: Lloyd’s Register of Shipping · 1:34am Mar 25th, 2019

I didn’t expect this project would run on for three posts, yet here it is, the next installment! Continuing on from Modernized Friendliest Fleet I can now offer you a complete listing of all known pony (and some not so pony) pairing ships, (with caveats) rated by upvotes-per-day. (with caveats…)

And a new ship list for the Friendliest Fleet, of course.

In the comments to the prior post, hawthornbunny brought to my attention that Derpibooru does expose – but does not document – an API to access a list of tags. Including a list of tag implications. And there is a tag that is implied by every tag that should be called “shipping” – aptly named “shipping.”

Should have been obvious, in retrospect. This permitted me to automate the initial stage of the calculations – figuring out the shipping tags and determining which characters are members of each pairing – and collect a full table of data on every pairing bronydom ever bothered to draw artwork for. Code in the Github repository has been updated accordingly.

1. Here’s the full table.

But you’ve come here for the data, haven’t you. Brace yourself, the list is much longer now. Here:1

454.3589  - Sunset Shimmer / Twilight Sparkle
388.1065  - Applejack / Rarity
375.6674  - Rarity / Spike
301.1101  - Rainbow Dash / Twilight Sparkle
276.0932  - Starlight Glimmer / Trixie
259.6075  - Applejack / Rainbow Dash
247.0561  - Fluttershy / Rainbow Dash
237.9406  - Princess Celestia / Princess Luna
226.1238  - Shining Armor / Twilight Sparkle
225.6740  - Octavia Melody / Vinyl Scratch
225.4610  - Princess Celestia / Twilight Sparkle
197.6212  - Princess Cadance / Shining Armor
184.2110  - Trixie / Twilight Sparkle
163.0202  - Pinkie Pie / Rainbow Dash
159.3851  - Tempest Shadow / Twilight Sparkle
158.4249  - Spike / Twilight Sparkle
149.2420  - Rainbow Dash / Soarin'
138.5192  - Gallus / Sandbar
137.0752  - Princess Luna / Twilight Sparkle
129.9683  - Big Macintosh / Fluttershy
126.2834  - Bright Mac / Pear Butter
125.3874  - Applejack / Big Macintosh
121.5326  - Starlight Glimmer / Sunburst
117.8399  - Rainbow Dash / Rarity
114.7068  - Applejack / Fluttershy
112.6399  - Fluttershy / Rarity
111.6804  - Rarity / Twilight Sparkle
108.7965  - Big Macintosh / Sugar Belle
108.0933  - Bow Hothoof / Windy Whistles
107.3657  - Princess Ember / Spike
101.5610  - Flash Sentry / Twilight Sparkle
100.2855  - Big Macintosh / Marble Pie
93.0247   - Discord / Fluttershy
91.9358   - Pinkie Pie / Twilight Sparkle
89.0615   - Fluttershy / Pinkie Pie
87.1061   - Stellar Flare / Sunburst
81.1437   - Shining Armor / Twilight Velvet
80.9036   - Fluttershy / Twilight Sparkle
75.7212   - Starlight Glimmer / Twilight Sparkle
75.2870   - Applejack / Twilight Sparkle
72.5431   - Quibble Pants / Rainbow Dash
65.2181   - Discord / Princess Celestia
63.5700   - Adagio Dazzle / Sunset Shimmer
58.8204   - Rainbow Dash / Scootaloo
58.5218   - Spike / Starlight Glimmer
57.0184   - Moondancer / Twilight Sparkle
56.0834   - Aria Blaze / Sonata Dusk
52.7329   - Rarity / Sweetie Belle
51.5206   - Smolder / Spike
48.6072   - Big Macintosh / Cheerilee
48.3061   - Gallus / Silverstream
47.1980   - Queen Chrysalis / Shining Armor
47.1534   - Apple Bloom / Big Macintosh
45.7366   - Maud Pie / Mudbriar
44.3903   - Pinkie Pie / Rarity
43.6557   - Flash Sentry / Sunset Shimmer
43.1202   - Applejack / Spike
42.8527   - Cheese Sandwich / Pinkie Pie
42.8365   - Lyra Heartstrings / Thunderlane
41.3525   - Spike / Sweetie Belle
41.2766   - Coco Pommel / Rarity
39.3849   - Maud Pie / Pinkie Pie
39.2828   - Starlight Glimmer / Sunset Shimmer
38.9387   - Maud Pie / Trixie
38.3901   - Scootaloo / Sweetie Belle
37.9352   - Sky Stinger / Vapor Trail
37.5190   - Applejack / Autumn Blaze
36.4163   - Fluttershy / Spike
35.3201   - Apple Bloom / Sweetie Belle
34.7601   - Princess Cadance / Twilight Sparkle
34.2739   - Princess Ember / Thorax
33.5084   - Applejack / Pinkie Pie
33.1142   - Adagio Dazzle / Sonata Dusk
32.5717   - Diamond Tiara / Silver Spoon
32.5232   - Adagio Dazzle / Aria Blaze
32.0535   - Princess Celestia / Queen Chrysalis
31.6245   - Shining Armor / Spike
31.1048   - Pinkie Pie / Spike
30.4459   - Big Macintosh / Braeburn
30.1670   - Fluttershy / King Sombra
30.0097   - Aloe / Lotus Blossom
29.8834   - Rainbow Dash / Spike
29.8147   - Big Macintosh / Rainbow Dash
29.4870   - Night Light / Twilight Sparkle
27.9622   - Soarin' / Spitfire
27.8456   - Sonata Dusk / Sunset Shimmer
27.6404   - Big Macintosh / Rarity
27.5893   - Button Mash / Sweetie Belle
27.3368   - Twilight Sparkle / Twilight Velvet
27.3194   - Apple Bloom / Applejack
26.6686   - Jack Pot / Trixie
26.2032   - Rainbow Dash / Spitfire
26.1147   - Princess Luna / Shining Armor
26.0396   - Braeburn / Soarin'
25.7813   - Pinkie Pie / Sunset Shimmer
25.2434   - Night Light / Twilight Velvet
24.8982   - Sunset Shimmer / Trixie
23.9864   - Pistachio / Rarity
23.9782   - Big Macintosh / Pinkie Pie
23.8056   - Big Macintosh / Twilight Sparkle
22.9656   - Timber Spruce / Twilight Sparkle
22.9295   - Princess Cadance / Queen Chrysalis
22.8703   - Spike / Thorax
22.6998   - Star Tracker / Twilight Sparkle
22.5462   - Big Macintosh / Sweetie Belle
22.2437   - Apple Bloom / Tender Taps
21.9636   - Cloudchaser / Flitter
21.9563   - Nightmare Moon / Queen Chrysalis
21.5130   - Carrot Cake / Cup Cake
21.4937   - Soarin' / Thunderlane
21.3487   - Big Macintosh / Shining Armor
21.2556   - Ocellus / Sandbar
20.9412   - Princess Celestia / Spike
20.8151   - Glitter Drops / Tempest Shadow
20.7104   - Princess Flurry Heart / Shining Armor
20.5483   - Gilda / Rainbow Dash
20.1818   - Fluttershy / Princess Luna
19.8709   - Apple Bloom / Scootaloo
19.8080   - Applejack / Coloratura
19.5910   - Pinkie Pie / Princess Skystar
19.5269   - Somnambula / Sphinx (Character)
19.2126   - Apple Bloom / Spike
18.9985   - Fluttershy / Zephyr Breeze
18.5425   - Rainbow Dash / Zephyr Breeze
18.3416   - Rumble / Scootaloo
17.9057   - Princess Celestia / Shining Armor
17.7053   - Fluttershy / Tree Hugger
17.6413   - Princess Luna / Tempest Shadow
17.4748   - Applejack / Sunset Shimmer
17.4728   - Angel Bunny / Fluttershy
16.3651   - Discord / Princess Luna
16.1475   - Night Light / Princess Cadance
16.1283   - Pipsqueak / Princess Luna
15.7000   - Apple Bloom / Babs Seed
15.0592   - Big Macintosh / Caramel
15.0038   - Rainbow Dash / Sweetie Belle
14.9331   - Princess Cadance / Princess Celestia
14.9066   - Discord / Songbird Serenade
14.7364   - Hoo'far / Trixie
14.6588   - Big Macintosh / Scootaloo
14.6103   - Princess Cadance / Princess Flurry Heart
14.6028   - Big Macintosh / Princess Luna
14.4490   - Double Diamond / Party Favor
14.0190   - Princess Celestia / Rarity
13.9733   - Princess Cadance / Princess Luna
13.8744   - Bulk Biceps / Fluttershy
13.8543   - Rainbow Dash / Sunset Shimmer
13.8085   - Carrot Top / Derpy Hooves
13.7960   - Applejack / Braeburn
13.3851   - Discord / Twilight Sparkle
13.2848   - Ahuizotl / Daring Do
13.2439   - Princess Celestia / Sunset Shimmer
13.1694   - Twilight Velvet / Windy Whistles
13.1480   - Queen Chrysalis / Twilight Sparkle
12.9918   - King Sombra / Twilight Sparkle
12.9575   - Cloudy Quartz / Igneous Rock
12.9436   - Silverstream / Terramar
12.8343   - Daring Do / Rainbow Dash
12.8073   - Discord / Pinkie Pie
12.6425   - Maud Pie / Starlight Glimmer
12.1007   - Applejack / Princess Luna
12.0843   - Princess Ember / Rarity
11.9449   - Sunset Shimmer / Wallflower Blush
11.7543   - King Sombra / Princess Cadance
11.6594   - Spike / Sunset Shimmer
11.6576   - Daybreaker / Nightmare Moon
11.6485   - Spike / Trixie
11.4823   - Shining Armor / Sunburst
11.2242   - Princess Luna / Trixie
11.1437   - Princess Cadance / Spike
10.9976   - Flash Sentry / Sonata Dusk
10.9640   - Rarity / Trixie
10.6934   - Rarity / Sunset Shimmer
10.5942   - King Sombra / Shining Armor
10.5685   - Ms. Harshwhinny / Rainbow Dash
10.5571   - Scootaloo / Spike
10.5565   - Derpy Hooves / Rainbow Dash
10.5245   - Pinkie Pie / Pokey Pierce
10.1962   - Princess Luna / Spike
10.1241   - Coco Pommel / Spike
10.0934   - Fluttershy / Sunset Shimmer
10.0464   - Firelight / Starlight Glimmer
9.9335    - King Sombra / Princess Celestia
9.7191    - Prince Blueblood / Trixie
9.5817    - Rainbow Dash / Thunderlane
9.4961    - Lemon Zest / Sonata Dusk
9.2897    - Rainbow Dash / Shining Armor
9.2252    - Fluttershy / Princess Celestia
9.1305    - Big Macintosh / Limestone Pie
8.9244    - King Sombra / Princess Luna
8.7521    - Moondancer / Sunburst
8.6665    - Flash Sentry / Shining Armor
8.6644    - Big Macintosh / Zecora
8.6502    - Firelight / Stellar Flare
8.5693    - Rumble / Sweetie Belle
8.5284    - Button Mash / Rumble
8.5162    - Neon Lights / Vinyl Scratch
8.4762    - Fluttershy / Trixie
8.3893    - Rainbow Blaze / Rainbow Dash
8.3714    - Princess Luna / Rainbow Dash
8.2927    - Lightning Dust / Rainbow Dash
8.2395    - Rarity / Thunderlane
8.2335    - Applejack / Cherry Jubilee
8.1201    - Adagio Dazzle / Applejack
8.0104    - Capper Dapperpaws / Rarity
8.0064    - Gilda / Greta
7.8800    - Rainbow Dash / Vinyl Scratch
7.7371    - Derpy Hooves / Princess Luna
7.6800    - Rarity / Vinyl Scratch
7.6544    - Featherweight / Spitfire
7.6525    - Autumn Blaze / Glitter Drops
7.6452    - Pharynx / Thorax
7.5706    - Derpy Hooves / Dinky Hooves
7.5619    - Maud Pie / Rarity
7.5563    - Derpy Hooves / Twilight Sparkle
7.5419    - Applejack / Shining Armor
7.5144    - Princess Celestia / Tempest Shadow
7.4656    - Pound Cake / Princess Flurry Heart
7.4398    - Applejack / Sweetie Belle
7.3697    - Coconut Cream / Toola Roola
7.2011    - Discord / Spike
7.0931    - Princess Luna / Rarity
7.0859    - Night Light / Shining Armor
7.0740    - Rumble / Thunderlane
6.9453    - Apple Bloom / Diamond Tiara
6.8537    - Aria Blaze / Sunset Shimmer
6.8136    - Applejack / Soarin'
6.7927    - Shining Armor / Soarin'
6.7914    - Twilight Sparkle / Zecora
6.7668    - Fluttershy / Iron Will
6.6754    - Applejack / Caramel
6.6622    - Applejack / Princess Celestia
6.6474    - Big Macintosh / Spike
6.6214    - Cheerilee / Twilight Sparkle
6.5932    - Princess Ember / Starlight Glimmer
6.5625    - Octavia Melody / Rarity
6.4898    - Button Mash / Rarity
6.4547    - Garble / Princess Ember
6.4453    - Pinkie Pie / Somnambula
6.3847    - Ms. Harshwhinny / Spike
6.3581    - Sunburst / Twilight Sparkle
6.3483    - Pinkie Pie / Vinyl Scratch
6.3453    - Fleetfoot / Rainbow Dash
6.2029    - Discord / Sweetie Belle
6.1975    - Princess Celestia / Rainbow Dash
6.1442    - Double Diamond / Night Glider
5.9902    - King Sombra / Queen Chrysalis
5.9607    - Big Macintosh / Princess Celestia
5.9034    - Princess Luna / Queen Chrysalis
5.8673    - Silver Spoon / Sweetie Belle
5.8102    - King Sombra / Radiant Hope
5.8078    - Nightmare Rarity / Twilight Sparkle
5.7003    - Coco Pommel / Twilight Sparkle
5.5974    - Princess Luna / Sunset Shimmer
5.5767    - Applejack / Troubleshoes Clyde
5.4524    - Fluttershy / Gilda
5.4286    - Skellinore / Spike
5.4208    - Fancypants / Rarity
5.2500    - Songbird Serenade / Tree Hugger
5.2199    - Rumble / Spike
5.2088    - Big Macintosh / Princess Cadance
5.0382    - Princess Cadance / Trixie
5.0000    - Gloriosa Daisy / Vignette Valencia
4.9535    - Starlight Glimmer / Thorax
4.9174    - Rainbow Dash / Trixie
4.8966    - Party Favor / Pinkie Pie
4.8717    - Indigo Zap / Lemon Zest
4.8314    - Gilda / Pinkie Pie
4.8176    - Flitter / Rumble
4.8087    - Thorax / Twilight Sparkle
4.7995    - Pinkie Pie / Shining Armor
4.7884    - Spike / Zecora
4.7625    - Applejack / Trenderhoof
4.7174    - Cloudchaser / Thunderlane
4.5982    - Fluttershy / Soarin'
4.5766    - Big Macintosh / Derpy Hooves
4.5723    - Nightmare Moon / Rarity
4.5623    - Fluttershy / Thunderlane
4.5405    - Applejack / Starlight Glimmer
4.4809    - Applejack / Strawberry Sunrise
4.4730    - Twilight Velvet / Zecora
4.4483    - Gilda / Tempest Shadow
4.4271    - Prince Blueblood / Princess Celestia
4.4176    - Big Macintosh / Feather Bangs
4.3893    - Coloratura / Songbird Serenade
4.3583    - Adagio Dazzle / Twilight Sparkle
4.3417    - Big Macintosh / Fleetfoot
4.3375    - Apple Bloom / Rarity
4.3343    - Sandbar / Yona
4.3330    - Gabby / Gilda
4.3320    - Sonata Dusk / Twilight Sparkle
4.2842    - Frederic Horseshoepin / Octavia Melody
4.2580    - Rarity / Shining Armor
4.2556    - King Sombra / Pinkie Pie
4.2168    - Diamond Tiara / Sweetie Belle
4.2114    - Fizzle / Garble
4.2083    - Shining Armor / Tempest Shadow
4.1557    - Pharynx / Tempest Shadow
4.1249    - Party Favor / Sugar Belle
4.1224    - Butternut / Oak Nut
4.1152    - Princess Celestia / Trixie
4.0991    - Princess Celestia / Thorax
4.0787    - Adagio Dazzle / Trixie
4.0599    - Lyra Heartstrings / Octavia Melody
4.0377    - Mean Applejack / Mean Rarity
4.0249    - Smooze / Tree Hugger
4.0083    - Big Macintosh / Octavia Melody
3.9959    - Braeburn / Double Diamond
3.9875    - Pharynx / Princess Luna
3.9525    - Mayor Mare / Ms. Harshwhinny
3.9395    - Fleetfoot / Spitfire
3.9244    - Soarin' / Starlight Glimmer
3.9049    - Queen Chrysalis / Spike
3.9017    - Aunt Holiday / Auntie Lofty
3.8877    - Sonata Dusk / Spike
3.7769    - Derpy Hooves / Fluttershy
3.7715    - Adagio Dazzle / Flash Sentry
3.7517    - Pinkie Pie / Sugar Belle
3.7359    - Lyra Heartstrings / Starlight Glimmer
3.7123    - Coloratura / Octavia Melody
3.6971    - Dinky Hooves / Rumble
3.6604    - Fluttershy / Queen Chrysalis
3.6465    - Big Macintosh / Trixie
3.6461    - Cloudchaser / Rumble
3.6207    - Babs Seed / Twist
3.6133    - Flash Magnus / Somnambula
3.5786    - King Sombra / Sunburst
3.5752    - Lyra Heartstrings / Soarin'
3.5689    - Photo Finish / Zesty Gourmand
3.5435    - Diamond Tiara / Filthy Rich
3.5241    - Aria Blaze / Twilight Sparkle
3.4989    - Rarity / Trenderhoof
3.4782    - Apple Bloom / Trixie
3.4755    - Fluttershy / Sweetie Belle
3.4189    - Coco Pommel / Suri Polomare
3.3872    - Night Glider / Sugar Belle
3.3866    - Bon Bon / Thunderlane
3.3862    - Tender Taps / Twilight Sparkle
3.3784    - Braeburn / Rainbow Dash
3.3685    - Derpy Hooves / Troubleshoes Clyde
3.3622    - Shining Armor / Trixie
3.3588    - Braeburn / Spitfire
3.3290    - Applejack / Trixie
3.3246    - Princess Ember / Twilight Sparkle
3.3084    - Feather Bangs / Pokey Pierce
3.3041    - Braeburn / Fluttershy
3.2935    - Autumn Blaze / Hoo'far
3.2800    - Big Macintosh / Soarin'
3.2659    - Discord / Trixie
3.2480    - Braeburn / Little Strongheart
3.2294    - Octavia Melody / Rainbow Dash
3.2278    - Queen Chrysalis / Trixie
3.1773    - Dumbbell / Rainbow Dash
3.1533    - Juniper Montage / Wallflower Blush
3.1471    - Pinkie Pie / Sonata Dusk
3.1328    - Rarity / Suri Polomare
3.1120    - Boulder (Pet) / Twiggy (Pet)
3.1075    - Fluttershy / Marble Pie
3.1074    - Nightmare Moon / Nightmare Rarity
3.0770    - Pinkie Pie / Trixie
3.0394    - Rarity / Saffron Masala
3.0250    - Gabby / Gallus
3.0220    - Discord / Tree Hugger
3.0129    - Princess Cadance / Rainbow Dash
3.0005    - Flash Sentry / Princess Cadance
2.9970    - Scootaloo / Terramar
2.9461    - Derpy Hooves / Pinkie Pie
2.9285    - Rarity / Zecora
2.9198    - Snails / Twist
2.8853    - Sugarcoat / Twilight Sparkle
2.8800    - Lightning Dust / Spitfire
2.8726    - Diamond Tiara / Scootaloo
2.8539    - Comet Tail / Twilight Sparkle
2.8455    - Apple Bloom / Fluttershy
2.8082    - Boulder (Pet) / Maud Pie
2.8023    - Big Macintosh / Silver Spoon
2.8002    - Blossomforth / Thunderlane
2.7969    - Flash Sentry / Timber Spruce
2.7762    - Garble / Spike
2.7289    - Cookie Crumbles / Spike
2.7096    - Inky Rose / Lily Lace
2.7088    - Hoo'far / Saffron Masala
2.7014    - Princess Luna / Sweetie Belle
2.6925    - Big Macintosh / Nurse Redheart
2.6876    - Lemon Zest / Vinyl Scratch
2.6845    - Lemon Zest / Sour Sweet
2.6607    - Soarin' / Twilight Sparkle
2.6522    - Double Diamond / Starlight Glimmer
2.6368    - Applejack / Flim
2.6126    - Gabby / Scootaloo
2.6045    - Flash Magnus / Rainbow Dash
2.5762    - Flash Sentry / Sunburst
2.5544    - Spitfire / Thunderlane
2.5470    - Braeburn / Promontory
2.5341    - Flash Sentry / Rainbow Dash
2.5255    - Adagio Dazzle / Princess Celestia
2.5000    - Snails / Trixie
2.4904    - Inky Rose / Moonlight Raven
2.4821    - Cheerilee / Silver Spoon
2.4764    - Dinky Hooves / Lily Longsocks
2.4664    - Pinkie Pie / Princess Celestia
2.4607    - Snips / Sweetie Belle
2.4581    - Applejack / Cheerilee
2.4581    - Big Macintosh / Hoity Toity
2.4520    - Pinkie Pie / Smooze
2.4498    - Thorax / Trixie
2.4407    - Snips / Trixie
2.4388    - Princess Luna / Thorax
2.4356    - Princess Cadance / Spitfire
2.4328    - Princess Flurry Heart / Thorax
2.4320    - Dinky Hooves / Pipsqueak
2.4308    - Tree Hugger / Zephyr Breeze
2.4092    - Fluttershy / Shining Armor
2.3969    - Princess Celestia / Queen Novo
2.3966    - Babs Seed / Button Mash
2.3861    - Night Light / Nurse Redheart
2.3544    - Applejack / Steam Gauge
2.3266    - Braeburn / Marble Pie
2.2833    - Princess Flurry Heart / Queen Chrysalis
2.2695    - Prince Blueblood / Rarity
2.2660    - Lightning Dust / Limestone Pie
2.2643    - Applejack / Zecora
2.2423    - Spike / Vinyl Scratch
2.2198    - Lemon Hearts / Twilight Sparkle
2.2156    - Stellar Flare / Sugar Belle
2.2123    - Coco Pommel / Fluttershy
2.2109    - Pistachio / Sandbar
2.1961    - Night Glider / Party Favor
2.1785    - Indigo Zap / Sugarcoat
2.1563    - Cheerilee / Scootaloo
2.1503    - Beauty Brass / Fiddlesticks
2.1385    - Pipsqueak / Sweetie Belle
2.1094    - Sunburst / Thorax
2.0959    - Mina / Spike
2.0797    - Open Skies / Thunderlane
2.0796    - Babs Seed / Sweetie Belle
2.0795    - Fluttershy / Sandalwood
2.0693    - Babs Seed / Dinky Hooves
2.0693    - Babs Seed / Shady Daze
2.0678    - Moondancer / Sunset Shimmer
2.0368    - Big Macintosh / Thunderlane
2.0286    - Octavia Melody / Princess Luna
2.0221    - Thunderlane / Twilight Sparkle
2.0073    - Apple Bloom / Zecora
1.9498    - Pinkie Pie / Saffron Masala
1.9125    - Kettle Corn / Skeedaddle
1.8899    - Big Macintosh / Starlight Glimmer
1.8868    - Jet Set / Upper Crust
1.8832    - Octavia Melody / Spike
1.8811    - Sky Stinger / Soarin'
1.8622    - Applejack / Mayor Mare
1.8599    - Lyra Heartstrings / Noteworthy
1.8418    - Autumn Blaze / Princess Skystar
1.8405    - Discord / Queen Chrysalis
1.8117    - Derpy Hooves / Flitter
1.8054    - Octavia Melody / Spitfire
1.7940    - Pinkie Pie / Soarin'
1.7680    - Sour Sweet / Sugarcoat
1.7667    - Filthy Rich / Silver Spoon
1.7492    - Shining Armor / Sunset Shimmer
1.7436    - Lightning Dust / Thunderlane
1.7317    - Rarity / Tom
1.7256    - Caramel / Sassaflash
1.7187    - Prince Blueblood / Twilight Sparkle
1.7166    - Maud Pie / Tom
1.7158    - Derpy Hooves / Soarin'
1.7071    - Pinkie Pie / Surprise
1.7020    - Pinkie Pie / Scootaloo
1.6981    - Flash Sentry / Trixie
1.6793    - Big Macintosh / Gilda
1.6458    - Fluttershy / Zecora
1.6432    - Prince Blueblood / Princess Cadance
1.6403    - Braeburn / Shining Armor
1.6154    - Cup Cake / Spoiled Rich
1.6148    - Cheerilee / Fluttershy
1.6068    - Octavia Melody / Trixie
1.6042    - Lyra Heartstrings / Twilight Sparkle
1.5833    - Gabby / Rainbow Dash
1.5469    - Big Macintosh / Discord
1.5447    - Fluttershy / Scootaloo
1.5417    - Iron Will / Stellar Flare
1.5144    - Derpy Hooves / Lyra Heartstrings
1.5142    - Princess Flurry Heart / Pumpkin Cake
1.5085    - Cheerilee / Princess Celestia
1.5000    - Adagio Dazzle / Timber Spruce
1.4962    - Apple Bloom / Rumble
1.4949    - Daring Do / Doctor Caballeron
1.4887    - Angel Bunny / Starlight Glimmer
1.4850    - Daring Do / Quibble Pants
1.4648    - Princess Cadance / Sunburst
1.4567    - Berry Punch / Ruby Pinch
1.4474    - Limestone Pie / Short Fuse
1.4345    - Gilda / Princess Ember
1.4343    - Braeburn / Pinkie Pie
1.4115    - Moonlight Raven / Sunshine Smiles
1.4113    - Apple Bloom / Maud Pie
1.4096    - Featherweight / Princess Celestia
1.4014    - Aloe / Spike
1.3938    - Mina / Princess Ember
1.3842    - Discord / Rainbow Dash
1.3840    - Mrs. Shy / Somnambula
1.3572    - Raven / Spike
1.3466    - Coco Crusoe / Rainbow Stars
1.3344    - Silver Spoon / Twist
1.3219    - Blaze / Fleetfoot
1.2941    - Autumn Blaze / Pinkie Pie
1.2941    - Photo Finish / Rarity
1.2848    - Braeburn / Cherry Jubilee
1.2780    - Daring Do / Somnambula
1.2756    - Spitfire / Twilight Sparkle
1.2678    - Sweetie Belle / Tender Taps
1.2480    - Lotus Blossom / Spike
1.2476    - Crackle Pop / Tootsie Flute
1.2279    - Moondancer / Spike
1.2193    - Aria Blaze / Fluttershy
1.2190    - Apple Bloom / Featherweight
1.2079    - Double Diamond / Sugar Belle
1.2022    - Cheerilee / Rainbow Dash
1.2001    - Big Macintosh / Sweetcream Scoops
1.1957    - Chancellor Neighsay / Twilight Sparkle
1.1932    - Princess Luna / Scootaloo
1.1928    - Daring Do / Zecora
1.1867    - Limestone Pie / Zephyr Breeze
1.1716    - Pokey Pierce / Rainbow Dash
1.1676    - Rumble / Tender Taps
1.1663    - Fluttershy / Thorax
1.1500    - Feather Bangs / Sugar Belle
1.1464    - Minuette / Moondancer
1.1464    - Lyra Heartstrings / Spike
1.1420    - King Sombra / Rarity
1.1400    - Babs Seed / Snips
1.1325    - Octavia Melody / Twilight Sparkle
1.1088    - Gilda / Princess Celestia
1.1079    - Derpy Hooves / Flash Sentry
1.0935    - Applejack / Scootaloo
1.0934    - Flash Sentry / Rarity
1.0913    - Fluttershy / Timber Spruce
1.0861    - Caramel / Twilight Sparkle
1.0841    - Pinkie Pie / Thunderbass
1.0748    - Scootaloo / Thunderlane
1.0707    - Trenderhoof / Zephyr Breeze
1.0684    - Bluebonnet / Rolling Thunder
1.0508    - Minuette / Twilight Sparkle
1.0488    - Gilda / Trixie
1.0477    - Applejack / Limestone Pie
1.0404    - Cheerilee / Moondancer
1.0331    - Indigo Zap / Sour Sweet
1.0322    - Lightning Dust / Scootaloo
1.0276    - Discord / Lord Tirek
1.0262    - Flash Sentry / Thunderbass
1.0118    - Applejack / King Sombra
1.0089    - Silver Spoon / Spike
1.0077    - Pinkie Pie / Troubleshoes Clyde
  • Ships with a ranking of less than 1 have been omitted for clarity, you can find them in the full table if you need them.
  • Poly pairings have been omitted for the usual reasons.
  • OC pairings have been omitted because everyone would keep asking who these people are.
  • Rule 63 pairings also had to go: By Derpibooru rules, those imply the tags for both the gender-flipped and the non-gender-flipped character, including cases where only one member of the pairing is gender-flipped. Counting those would skew the results a lot, since I can’t always tell which one is involved.
  • Some were shipping tags without any actual images in them – this happens when the tag is created for a single image which is subsequently deleted. I omitted those from the table as well.

With all that said, the total number known pairings currently stands at 978. With the exception of about 15, all of those are the ones that were previously ignored due to the 50-images cutoff rule.

This took a lot longer than it should have due to numerous false starts and unexpected corner cases. I also had to specially filter out the characters from Them’s Fighting Herds before proceeding. Derpibooru traditionally did count them as characters, because they were blessed by Faust, so they have the “character” tag class, unlike, say, Sonic. Which is unfair to Sonic, if you ask me. If you wish to see the data for them as well, data.pickle still contains the data as acquired from Derpibooru, but for the purposes of this project I decided they were extraneous.

One other thing you will notice is that Sunset / Twilight just jumped to the top of the list. The reason for this is quite annoying: In Derpibooru terms, Sci-Twi is a subset of Twilight Sparkle, so they get merged. Previously, for certain specific ship tags, her name was entered manually. Now it isn’t getting entered at all, because the trail of aliased tags leads towards “Twilight Sparkle” anyway.

On one hand, Derpibooru does not properly distinguish between the other human/pony versions pretty much entirely, so I’m not sure why should Twilight’s alternates get special treatment. On the other hand, I have a suspicion this eventually also leads to counting certain images twice, which means I have to redo much of the logic of data collection to account for that possibility, and we’re in for a yet another post in this already prolific series. We want to know the correct ranking, don’t we?

The top spot in the shipping ranking is a dangerous spot indeed.

Anyway, here’s what I’m getting for the Friendliest Fleet now:

Highest scoring fleet:

454.3589  - Sunset Shimmer / Twilight Sparkle
375.6674  - Rarity / Spike
276.0932  - Starlight Glimmer / Trixie
259.6075  - Applejack / Rainbow Dash
237.9406  - Princess Celestia / Princess Luna
225.6740  - Octavia Melody / Vinyl Scratch
197.6212  - Princess Cadance / Shining Armor
138.5192  - Gallus / Sandbar
126.2834  - Bright Mac / Pear Butter
108.7965  - Big Macintosh / Sugar Belle
108.0933  - Bow Hothoof / Windy Whistles
93.0247   - Discord / Fluttershy
87.1061   - Stellar Flare / Sunburst
56.0834   - Aria Blaze / Sonata Dusk
45.7366   - Maud Pie / Mudbriar
42.8527   - Cheese Sandwich / Pinkie Pie
38.3901   - Scootaloo / Sweetie Belle
37.9352   - Sky Stinger / Vapor Trail
34.2739   - Princess Ember / Thorax
32.5717   - Diamond Tiara / Silver Spoon
30.0097   - Aloe / Lotus Blossom
27.9622   - Soarin' / Spitfire
25.2434   - Night Light / Twilight Velvet
22.2437   - Apple Bloom / Tender Taps
21.9636   - Cloudchaser / Flitter
21.9563   - Nightmare Moon / Queen Chrysalis
21.5130   - Carrot Cake / Cup Cake
20.8151   - Glitter Drops / Tempest Shadow
14.4490   - Double Diamond / Party Favor
13.8085   - Carrot Top / Derpy Hooves
13.2848   - Ahuizotl / Daring Do
12.9575   - Cloudy Quartz / Igneous Rock
8.5284    - Button Mash / Rumble
7.4656    - Pound Cake / Princess Flurry Heart
5.8102    - King Sombra / Radiant Hope
4.8717    - Indigo Zap / Lemon Zest
4.2114    - Fizzle / Garble
3.6207    - Babs Seed / Twist
3.2480    - Braeburn / Little Strongheart
2.8002    - Blossomforth / Thunderlane
2.7969    - Flash Sentry / Timber Spruce
2.4320    - Dinky Hooves / Pipsqueak
2.1503    - Beauty Brass / Fiddlesticks
1.8868    - Jet Set / Upper Crust

Total fleet score: 3272.658504963594

Surprisingly, the fleet list is not that different. The most obvious changes include the addition of a few – once again, canonical! – pairings that I have missed on initial search, like Sky Stinger / Vapor Trail, Jet Set / Upper Crust and Cloudy Quartz / Igneous Rock. Some others made it in, including Glitter Drops / Tempest Shadow – bet you didn’t know who Glitter Drops was? I didn’t either.

But all the observed features of the fleet list hold ironclad, and even all the sibling pairings are still in.

And Sunburst still gets his mom. :trollestia:

P.S. The series continues in Statistics #5.3: Revised Lloyd’s Register of Shipping.

Join our Patreon to remove these adverts!
Comments ( 11 )
RBDash47
Site Blogger

Sunburst knows what he likes and no amount of recalculation can change it.

Ah, so her name is Glitter Drops. I kept seeing her pics and I thought she was an OC.

Also, Sunburst stole the title of Equestria's Biggest Motherfucker from Button Mash, it seems...

5032621

Also, Sunburst stole the title of Equestria’s Biggest Motherfucker from Button Mash, it seems…

This kept amusing me ever since I noticed that no matter how I slice it, she’s his highest ranked ship past Starlight. Once the scores are time-weighted, Trixie inevitably wins Starlight, pretty much no matter what kind of logic you use to weigh them by time, and…

5032625
Poor Sunburst, there was no other way for him...

Let's see...

Rarispike, check. :moustache: :raritywink:
Every Sparklecest, check. :twilightblush:
TrixGlim, check. :trixieshiftright:
Dashaloo, check. :scootangel: :rainbowwild:
Lunapip, check. :trollestia:

You're doing Celestia's work, son. Carry on! :rainbowdetermined2:

5032784

You’re doing Celestia’s work, son.

Pretty sure it’s supposed to be Cadance’s work. :raritywink:

5032647
I'd say lucky Sunburst, but I'm kind of biased. :twilightblush:

My mom's 73 and still pretty hot. Dad too...

5033184
Well, that's almost reaching GILF territory, I'd say (my parents are almost 53, so it's not quite there).

5033194
Yeah, I haven't had any kids yet. I don't have to worry about my biological clock because I'm a girl with 'special equipment'. :raritywink:

We're still not sure we want kids, though. My husband deals with generalized anxiety and the stress might kill him, among other concerns. Life can be complicated.

5033213
Yeah, kids are not the best idea in this situation (or in any situation. Or it's just me not liking them).

Wow. You even noticed TwiTaps.

Login or register to comment
Join our Patreon to remove these adverts!