It's a Dune query I created to understand the number of Japanese-speaking users.😁

Japanese casts always use "hiragana" (ひらがな), so I've devised a way to measure only casts that contain hiragana.

https://dune.com/queries/3677850/6185785

Inspired by @saxophone55.eth, I created a Dune query to understand the number of Chinese-speaking users.

Based on Saxophone's work, in addition to changing the statistical time zone, I used a rule that counts Chinese casts which must contain at least one Chinese character (\u4e00-\u9fff) and do not contain Japanese "hiragana" characters (ぁ-んー).

The final results show a sharp increase in the number of Chinese-speaking users and the number of casts around May 22nd. This is consistent with my expectations because on that day, Farcaster announced a financing round of 150M, which attracted a large influx of Chinese users. However, the number of Chinese-speaking users is quite small, with only around 2,000.
https://dune.com/queries/3904707/6562840

Frame Creator, Dune Wizard Newbie, Web3 Newbie, Japanese,

crypto-anarchist · onchain social explorer, curator, advisor · host /luo · write 0xluo.xyz