A basic revenue sort tells you Pokémon is the biggest franchise. That is not interesting. What SQL's window functions surface is something more precise: how dominant each franchise was within its own competitive era across each individual revenue category. The query partitions by both era and revenue category
by KSM
Cross-reference with Chart 3 and the story gets sharper. In 2024, H3 dropped to just 34 episodes — a 72% collapse from 2023's peak. But duration hit its all-time high: months regularly clearing 220–240 minutes. The show was publishing less but asking more from the audience that stayed.
by KSMThis Coffee Quality Institute dataset covers 1,311 Arabica coffee samples from 36+ countries, each evaluated by certified Q Graders on a 100-point scale. That scale is built from ten sub-metrics — aroma, flavor, aftertaste, acidity, body, balance, uniformity, clean cup, sweetness, and cupper points — each scored from zero to ten.
by KSMThis MyAnimeList dataset covers 13,631 unique anime titles spanning 1917 to 2019—closer to a century-scale archive than a "modern seasonal TV" snapshot. That scope is what makes it worth analyzing as an industry story, not just a rankings list. It lets you trace anime from its
by KSMA data analysis of 107 franchises mapping how the most valuable IP in history — from Pokémon to Star Wars — actually makes its money.
by KSM13,631 Titles. A Century Of Data. One Question: What Does The MyAnimeList Archive Actually Tell Us About How Anime Works As An Industry?
by KSM
A basic revenue sort tells you Pokémon is the biggest franchise. That is not interesting. What SQL's window functions surface is something more precise: how dominant each franchise was within its own competitive era across each individual revenue category. The query partitions by both era and revenue category
by KSM
A basic revenue sort tells you Pokémon is the biggest franchise. That is not interesting. What SQL's window functions surface is something more precise: how dominant each franchise was within its own competitive era across each individual revenue category. The query partitions by both era and revenue category
by KSM
Cross-reference with Chart 3 and the story gets sharper. In 2024, H3 dropped to just 34 episodes — a 72% collapse from 2023's peak. But duration hit its all-time high: months regularly clearing 220–240 minutes. The show was publishing less but asking more from the audience that stayed.
by KSMThis Coffee Quality Institute dataset covers 1,311 Arabica coffee samples from 36+ countries, each evaluated by certified Q Graders on a 100-point scale. That scale is built from ten sub-metrics — aroma, flavor, aftertaste, acidity, body, balance, uniformity, clean cup, sweetness, and cupper points — each scored from zero to ten.
by KSMThis MyAnimeList dataset covers 13,631 unique anime titles spanning 1917 to 2019—closer to a century-scale archive than a "modern seasonal TV" snapshot. That scope is what makes it worth analyzing as an industry story, not just a rankings list. It lets you trace anime from its
by KSMA data analysis of 107 franchises mapping how the most valuable IP in history — from Pokémon to Star Wars — actually makes its money.
by KSM13,631 Titles. A Century Of Data. One Question: What Does The MyAnimeList Archive Actually Tell Us About How Anime Works As An Industry?
by KSM