china

Just Build

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,Summary of Frame /japane-cast-info

crypto-anarchist · onchain social explorer, advisor · spread FC gospel in /chinese community · curate SocialSight.telegram· write 0xluo.xyz · host /luo ·中文 @luo

Web3产品经理，关注Crypto Native应用与Web3链下基础设施。 ||

Web3 Product Manager, focus on crypto native product and off-chain web3 infra.

可以在加一条过滤规则试试，就是排除掉包含“互关”两个字的cast，当然为了误伤可以再加个限制，包含互关且总字数也很少的

Building @qacaster qacaster.com | Driven to uncover value in decentralized social networks.

I want to follow small but good Chinese accounts

Constant explorer |
Full stack developer | 
Building /bimoo …

Clear and to the point, easy to understand!