Content
@
0 reply
20 recasts
20 reactions
erica
@heavygweit
hello farcaster friends i'm working on improving my sql and i thought it would be fun to practice with real data and answer real questions about the network we're all on so, if you've ever wondered something about the farcaster network and the data on it - shoot examples of questions that i can answer with a sql query: > what's the daily avg # of casts? > what % of casts are just text? > who has been the most mentioned user this week? (will answer as many as i can over the next couple of days!)
8 replies
33 recasts
56 reactions
Trish🫧
@trish
How many times is Elon mentioned and what is the sentiment categorized for gender if/when possible to know 😂
2 replies
0 recast
0 reaction
erica
@heavygweit
haha in the last week, there have been 340 casts that contain either the string "elon" or "musk" can't detect gender of users (that data isn't available) and sentiment analysis requires AI - i'm limiting myself to just sql rn :) diving a bit deeper: most of the casts mentioning elon seem to be AI generated. the ones that seem real are either talking about: > recent and upcoming spacex launches > elon and trump > replies to memes or pictures of elon there is also a big chunk of bot casts written in vietnamese this past week: "thật hay thật tuyệt chúc bạn sức khoẻ để làm công cho elon musk nhé" which translates to: "That's great, I wish you good health to work for Elon Musk" a cast that made me lol while digging around (reply to elon pic): https://warpcast.com/masky.eth/0x9d924dad
0 reply
0 recast
0 reaction
